Edits for Student Database Data Elements as of February 1999


FICE ST010
  Must be numeric. Must match HD020 FICE and must be a valid institution FICE code.
       
STID ST020
  Must be numeric. Must be reported with leading zeroes for numbers less than 100000000.
   
DOB ST030
  Must be numeric. If a student is 10 or 11 years old, then ED090 STLEV must be '12'- high school student (student concurrently enrolled in high school and the institution). Otherwise, student must be greater than or equal to 12 years old and less than or equal to 100 years old. If the date of birth is unknown, 9's must be used. Month values must be greater than or equal to 1 and less than or equal to 12. Day values must be greater than or equal to 1 and less than or equal to 31.
   
RPTYR ED040
  Must be numeric. Must match HD030 RPTYR. If ED040 RPTYR = current calendar year - 1, then ED050 RPTTRM must be "FA". Otherwise, ED040 RPTYR must be equal to current calendar year.
   
RPTTRM ED050
  Must match HD040 RPTTRM....valid entries are "FA", "WI", "SP" or "SU".
   
LNAME ST040
  Must not equal all blanks. ST040 LNAME should not include commas or periods. Must be submitted using all capital letters.
   
FNAME ST050
  Must not equal all blanks. ST050 FNAME should not include commas or periods. Must be submitted using all capital letters.
   
MNAME ST060
  Must not include commas or periods. Must be submitted using all capital letters.
   
OTLNAME ST070
  Must not include commas or periods. Must be submitted using all capital letters.
   
OTFNAME ST080
  Must not include commas or periods. Must be submitted using all capital letters.
   
OTMNAME ST090
  Must not include commas or periods. Must be submitted using all capital letters.
   
INTYR ST100
  Must be numeric. Must be less than or equal to current year. Student must be greater than or equal to 12 years old at the time of enrollment at the reporting institution. If student is 10 or 11 years old, then ED090 STLEV must be '12'.
   
INTTRM ST110
  Must be "FA", "WI", "SP", or "SU".
   
GENDER ST120
  Must be numeric. Valid coding options are:
  1
2
9
Female
Male
Unknown/Not Reported
   
RACE ST130
  Must be numeric. Valid coding options are:
  01
02
03
04
05
06
07
99
African American/ Black, Non-Hispanic
American Indian or Alaskan Native
Asian or Pacific Islander
Hispanic
White, Non-Hispanic
Non-Resident Alien
Other (May include multi-racial designations)
Unknown/Not Reported
   
CITIZEN ST140
  Must be numeric. Valid coding options are:
  01
02
03
04
99
United States Citizen
Non-Resident Alien
Resident Alien
Other
Unknown/Not Reported
 
   
COUNTRY ST150
  Must be a valid country code. If country is unknown or not reported, "ZZ" must be used.
   
 ENTST ST160
  Must be a valid state code. If state is unknown or not reported, "ZZ" must be used.
   
COUNTY ST170
  Must be numeric. Must be a valid county code. If state and/or county is unknown or not reported, '99999' must be used.
   
MATRDT ST180
  The first 4 bytes must be numeric. Must be greater than or equal to ST100 INTYR and less than or equal to current year. The last 2 bytes must be "FA", "WI", "SP" or "SU".
   
HSCODE ST190
  Must be numeric and a valid ACT high school code. If no high school code is available, the following options must be used:
  990001
990002
990003
990004
990005
990006
999999
Transfer Student
GED
Non-Resident Alien
Graduate/First Professional Student
Home Educated Student
Not required by reporting institution for enrollment
Unknown/Not reported
 
   
HSGDATE ST200
  Must be numeric. Must be greater than or equal to 1910 and less than or equal to current year. If ST200 HSGDATE is greater than current year, then ED090 STLEV must be '12', but ST200 HSGDATE must not be greater than current year + 10. If the graduation date is unknown or not reported, '9999' must be used.
   
HSGPA ST210
  Must be numeric. Must be greater than 0 and less than 500. If information is unknown or not reported, '999' must be used.
   
ACTSCORE ST220
  Must be numeric. Must be greater than 0 and less than or equal to 36. If information is unknown or not reported, '99' must be used.
   
SATSCORE ST230
  Must be numeric. Must be greater than or equal to 200 and less than or equal to 1600. If information is unknown or not reported, '9999' must be used.
   
TRANCOL ST240
  Must be numeric. Must be a valid FICE or ACT institution code. If using FICE codes, HD090 TRANCODE must be "F". If using ACT Codes, HD090 TRANCODE must be "A". If a student has not transferred from another institution, '000000' must be used. If the information is unknown or not reported, '999999' must be used. If TRANCOL[1] equals 0's, then TRANCOL[2] and TRANCOL[3] must be 0's.
   
TRANHRS ST250
  Must be numeric. Must be greater than or equal to 0 and less than or equal to 99999. If a student has not transferred from another institution, '00000' must be used. If the information is unknown or not reported, '99999' must be used.
   
TRANGPA ST260
  Must be numeric. Must be greater than or equal to 0 and less than or equal to 400. If information is unknown or not reported, '999' must be used.
   
FTPT ED060
  Must be numeric and equal to '1', '2', '3', '4', '5', '6', '7', '8', '9', or '0'.
  1
2
3
4
5
6
7
8
9
0
Full-Time
Part-Time
Full-Time, Audit only
Part-Time, Audit only
Full-Time, Remedial only
Part-Time, Remedial only
Other Full-Time Students Included on IPEDS Forms
Other Part-Time Students Included on IPEDS Forms
Other Full-Time Students NOT Included on IPEDS Forms
Other Part-Time Students NOT Included on IPEDS Forms
 
  If a student is enrolled in audit and remedial, use either coding option 5 or 6 as appropriate.
   
ADMST ED070
  Must be numeric and equal to '01', '02', '03', or '99'.
  01
02
03
99
Provisional
Regular
Concurrent
Other
 
   
INITENL ED080
  Must be numeric. Must be a valid coding option:
  01
02
03
04
05
06
07
99
First-Time Freshman
Undergraduate Transfer Student
First-Time Graduate Student
Graduate Transfer Student
First-Time First Professional Student
First-Time First Professional Transfer Student
Special Admissions (Concurrent enrollment, transient, unclassified, temporary, etc.)
Other
 
   
STLEV ED090
  Must be numeric. Must be a valid coding option:
  01
02
03
04
05
06
07
08
09
10
11
12
13
14
97
98
99
Non-degree seeking undergraduate
Freshman
Sophomore
Junior
Senior
Post baccalaureate student
Specialist degree student
Master's degree
Post master's student
Doctoral student
First Professional student (law, medicine, etc.)
High School student (student concurrently enrolled in high school and the institution)
Unclassified graduate
Unclassified undergraduate
Other graduate
Other undergraduate
Other
 
   
MAJCIP ED100
  Must be numeric and equal to a valid NCES CIP code. Otherwise use '990000' for other or '900000' for undeclared or unknown.
   
CHENR ED110
  Must be numeric and greater than or equal to 0.
CUMCHA ED120
  Must be numeric and greater than or equal to 0.
   
CUMCHE ED130
  Must be numeric and greater than or equal to 0.
   
CUMCHAVG ED140
  Must be numeric and greater than or equal to 0.
   
QPAVG ED150
  Must be numeric and greater than or equal to 0.
   
REMENG ED160
  Must be "Y" or "N".
   
REMMATH ED170
  Must be "Y" or "N".
   
LEGRES ED180
  Must be a valid state code. If the state is unknown or not reported, "ZZ" must be used.
   
VETST ED190
  Must be "Y" or "N".
   
HOUSE ED200
  Must be numeric and equal to '01', '02', or '99'.
  01
02
99
Institutional Housing
Other Housing
Unknown/Not Reported
 
   
MINCIP ED210
  Must be numeric and equal to a valid NCES CIP code. If the student has not declared a minor, '000000' must be used, or use '990000' - other category.
   
FINSTAT ED220
  Must be "Y" or "N".
   
RESSTAT ED230
  Must be numeric and equal to '01', '02' or '99'.
  01
02
99
In-State
Out-of-State
Unknown/Not Reported
 
   
TUITPD ED240
  Must be numeric and equal to '01', '02', or '03', or '04'.
  01
02
03
04
 
In-State
Out-of-State
In-State Other
50 Mile Radius
 
 
  ED240 can be 01 if ED230 is equal 01 and ED180 is equal AL
  ED240 can be 02 if ED230 is equal 02 or 99 and ED180 is not equal AL
  ED240 can be 03 if ED230 is equal 02 or 99 and ED180 is not equal AL
  ED240 can be 04 if ED230 is equal 02 or 99 and ED180 is not equal AL

ED240 ED230 ED180
01 01 AL
02 02 Not Equal AL
02 99 Not Equal AL
03 02 Not Equal AL
03 99 Not Equal AL
04 02 Not Equal AL
04 99 Not Equal AL

COSTTU ED250
  Must be numeric. Must be "99999" if ED240 is not euqal to "04". If ED240 is equal to "04", must contain a valid Federal Information Processing Standard code for Florida, Georgia, Mississippi, or Tennessee only. The first two digits of this number will represent the state and the last three digits the county. If either the state and/or the county code is unknown or not reported, "99999" will be entered in this field.
   
MATHGPA ED260
  Must be numeric. Will be entered with an implied decimal point between the first and second digits. A 4-point scale will be used. The institution will convert all 3-point scale GPAs to a 4-point scale. If information is unknown or not reported, "999" will be entered in this field.
   
SCIENGPA ED270
  Must be numeric. Will be entered with an implied decimal point between the first and second digits. A 4-point scale will be used. The institution will convert all 3-point scale GPAs to a 4-point scale. If information is unknown or not reported, "999" will be entered in this field.
   
ENGLGPA ED280
  Must be numeric. Will be entered with an implied decimal point between the first and second digits. A 4-point scale will be used. The institution will convert all 3-point scale GPAs to a 4-point scale. If information is unknown or not reported, "999" will be entered in this field.
   
SOCSTGPA ED290
  Must be numeric. Will be entered with an implied decimal point between the first and second digits. A 4-point scale will be used. The institution will convert all 3-point scale GPAs to a 4-point scale. If information is unknown or not reported, "999" will be entered in this field.
   
CUMGPA ED300
  Must be numeric. Will be entered with an implied decimal point between the first and second digits. A 4-point scale will be used. The institution will convert all 3-point scale GPAs to a 4-point scale. If information is unknown or not reported, "999" will be entered in this field.

            Click on map for details