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.

 

            Click on map for details