Graduation Database
File Layout
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 |
censusdt |
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 |
subfreq |
char |
X |
037 |
'A' |
|
|
| DATA RECORD: (one per student) |
Ref
Numbr |
Field Name |
Data Type |
Format |
Starting
Position |
| gr010 |
fice |
inte |
999999 |
001 |
| gr020 |
stid |
inte |
999999999 |
007 |
| gr030 |
dob |
inte |
99999999 |
016 |
| gr040 |
rptyr |
inte |
9999 |
024 |
| gr050 |
rpttrm |
char |
XX |
028 |
| gr060 |
gradyr |
inte |
9999 |
030 |
| gr070 |
gradtrm |
char |
XX |
034 |
| gr080 |
degcip |
inte |
999999 |
036 |
| gr090 |
degdes |
inte |
99 |
042 |
|
|
| 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 |
*Note:
The header and trailer records are only required for 2-year public
institutions when multiple colleges are submitted together by the
Alabama Department of Postsecondary Education.
|
