Table Name | COUNT |
Long Name | Count File |
Description | |
Prefix |
Field Name | Length | Type | Description | Comments |
---|---|---|---|---|
raea | 2 | char | Resident AEA | |
rcy | 2 | char | Resident County | |
rdist | 4 | char | Resident District | |
id | 12 | char | ID | |
seq | 2 | char | ID Sequence | |
ln | 14 | char | Name (Last) | |
fn | 11 | char | Name (First) | |
mi | 1 | char | Middle Initial | |
dob | 6 | char | Birthdate | |
srvstat | 1 | char | Served Status | |
plstat | 1 | char | Placement Status | |
dis | 2 | char | Disability | |
grade | 2 | char | Grade | |
fullp | 1 | char | Full/Part Time | |
placedt | 6 | char | Placement Date | |
exitdt | 6 | char | Final Exit Code | |
pp | 2 | char | Present Program | |
pw | 2 | char | Present Weight | |
rp | 2 | char | Recommended Program | |
rw | 2 | char | Recommended Weight | |
saea | 2 | char | Sponsor AEA | |
scy | 2 | char | Sponsor County | |
sdist | 4 | char | Sponsor District | |
aaea | 2 | char | Attending AEA | |
acy | 2 | char | Attending County | |
adist | 4 | char | Attending District | |
abldg | 4 | char | Attending Building | |
f1 | 1 | char | Previous Year Status | |
pgid | 3 | char | Program ID | |
pgseq | 2 | char | Program Sequence | |
pp1 | 2 | char | Support Service 01 | |
pp2 | 2 | char | Support Service 02 | |
pp3 | 2 | char | Support Service 03 | |
pp4 | 2 | char | Support Service 04 | |
pp5 | 2 | char | Support Service 05 | |
pp6 | 2 | char | Support Service 06 | |
pp7 | 2 | char | Support Service 07 | |
pp8 | 2 | char | Support Service 08 | |
pp9 | 2 | char | Support Service 09 | |
pp10 | 2 | char | Support Service 10 | |
pp11 | 2 | char | Support Service 11 | |
pp12 | 2 | char | Support Service 12 | |
exitrea | 3 | char | Exit Reason | |
birthdate | 8 | datetime | Birthdate | |
plandt | 8 | datetime | Plan Date | |
plantype | 4 | char | Plan Type | |
f2 | 3 | char | Basis for Enrollment | |
mode | 4 | char | Intervention Mode | |
ecset | 4 | char | ||
race | 1 | char | Ethnicity | |
ethnicity | 1 | char | ||
ethnicDeterm | 2 | smallint | ||
raceI | 2 | smallint | ||
raceA | 2 | smallint | ||
raceB | 2 | smallint | ||
raceH | 2 | smallint | ||
raceW | 2 | smallint | ||
raceDeterm | 2 | smallint | ||
catgrpt | 1 | char | ||
ddist | 4 | char | Domicile District | |
dbldg | 4 | char | Domicile Building | |
staff | 33 | char | Staff | |
ssn | 9 | char | Social Security Number | |
dwa | 1 | char | District Wide Assessment | |
eyse | 1 | char | Extended Year Special Education | |
sex | 1 | char | Gender | |
lre | 3 | char | Least Restrictive Environment | |
deccnt | 200 | char | December Count Comments | |
exitdate | 8 | datetime | Exit Date | |
stateid | 10 | char | State ID | |
hostdist | 4 | char | Host District | |
temp | 24 | varchar |