|
Student Database
File Layout
1998-1999
HEADER RECORD: |
| |
Ref
Numbr |
|
Field
Name |
Data
Type |
Format |
Starting
Position |
| |
hd010 |
header |
char |
x(6) |
001 |
| |
hd020 |
fice |
inte |
999999 |
007 |
| |
hd030 |
rptyr |
inte |
9999 |
013 |
| |
hd040 |
rpttrm |
char |
XX |
017 |
| |
hd050 |
census date |
date |
99/99/9999 |
019 |
| |
hd060 |
subdate |
date |
99/99/9999 |
027 |
| |
hd070 |
filetype |
logi |
stud/grad |
035 |
| |
hd080 |
subtype |
char |
X |
036 |
I=Initial
R=Resubmit
C=Correction |
|
hd090 |
trancode |
char |
X |
037 |
A=ACT
F=Fice |
|
|
DATA RECORD:
(one per student) |
| |
Ref
Numbr |
|
Field Name |
Data Type |
Format |
Starting
Position |
| |
st010 |
fice |
inte |
999999 |
001 |
* |
st020 |
stid |
inte |
999999999 |
007 |
* |
st030 |
dob |
inte |
99999999 |
016 |
| |
ed040 |
rptyr |
inte |
9999 |
024 |
| |
ed050 |
rpttrm |
char |
XX |
028 |
| |
st040 |
lname |
char |
X(25) |
030 |
| |
st050 |
fname |
char |
X(20) |
055 |
| |
st060 |
mname |
char |
X(20) |
075 |
| |
st070 |
otlname |
char |
X(25) |
095 |
| |
st080 |
otfname |
char |
X(20) |
120 |
| |
st090 |
otmname |
char |
X(20) |
140 |
| |
st100 |
intyr |
inte |
9999 |
160 |
| |
st110 |
inttrm |
char |
XX |
164 |
* |
st120 |
gender |
inte |
9 |
166 |
* |
st130 |
race |
inte |
99 |
167 |
| |
st140 |
citizen |
inte |
99 |
169 |
* |
st150 |
country |
char |
XX |
171 |
* |
st160 |
entst |
char |
XX |
173 |
| |
st170 |
county |
inte |
99999 |
175 |
* |
st180 |
matrdt |
char |
9999XX |
180 |
* |
st190 |
hscode |
inte |
999999 |
186 |
* |
st200 |
hsgdate |
inte |
9999 |
192 |
* |
st210 |
hsgpa |
inte |
999 |
196 |
* |
st220 |
actscore |
inte |
99 |
199 |
* |
st230 |
satscore |
inte |
9999 |
201 |
* |
st240 |
trancol[1] |
inte |
999999 |
205 |
* |
st240 |
trancol[2] |
inte |
999999 |
211 |
* |
st240 |
trancol[3] |
inte |
999999 |
217 |
* |
st250 |
tranhrs |
inte |
99999 |
223 |
* |
st260 |
trangpa |
inte |
999 |
228 |
|
ed060 |
|
ftpt |
inte |
9 |
231 |
|
* |
ed070 |
admst |
inte |
99 |
232 |
| |
ed080 |
initenl |
inte |
99 |
234 |
* |
ed090 |
stlev |
inte |
99 |
236 |
* |
ed100 |
majcip |
inte |
999999 |
238 |
* |
ed110 |
chenr |
inte |
99999 |
244 |
* |
ed120 |
cumcha |
inte |
99999 |
249 |
* |
ed130 |
cumche |
inte |
999999 |
254 |
* |
ed140 |
cumchavg |
inte |
999999 |
260 |
* |
ed150 |
qpavg |
inte |
999999 |
266 |
| |
ed160 |
remeng |
logi |
y/n |
272 |
| |
ed170 |
remmath |
logi |
y/n |
273 |
* |
ed180 |
legres |
char |
XX |
274 |
* |
ed190 |
vetst |
logi |
y/n |
276 |
* |
ed200 |
house |
inte |
99 |
277 |
* |
ed210 |
mincip |
inte |
999999 |
279 |
* |
ed220 |
finstat |
logi |
y/n |
285 |
* |
ed230 |
resstat |
inte |
99 |
286 |
* |
ed240 |
tuitpd |
inte |
99 |
288 |
|
|
|
|
|
|
|
TRAILER RECORD: |
| |
tr010 |
trailer |
char |
x(7) |
001 |
| |
tr020 |
fice |
inte |
999999 |
008 |
| |
tr030 |
rptyr |
inte |
9999 |
014 |
| |
tr040 |
rpttrm |
char |
XX |
018 |
| |
tr050 |
filetype |
logi |
stud/grad |
020 |
| |
tr060 |
reccnt |
inte |
999999 |
021 |
* Indicates data element specified in ACT 96-509.
|
