Undergraduate Files: (Field
details are listed below for each file)
F_STUDENT |
Active Undergraduate Student File (one record per student) Includes fields such as alpha name, social security number, major, minor, term applied, accepted date |
F_HISTORY |
Undergraduate History File (multi records per student) Grade information including social security number, department, course, section, year term |
F_MAJOR |
Undergraduate Major File sorted by major code Includes fields such as major code, major name |
F_MINOR |
Undergraduate Minor File sorted by minor code Includes fields such as minor code, minor name |
Graduate Files: (Field details are
listed below for each file)
F_GRADUATE |
Active Graduate Student File (one record per student) Includes fields such as alpha name, social security number, major, minor, term applied, accepted date |
F_GHISTORY |
Graduate History File (multi records per student) Including fields such as social security number, department, course, section, year term |
F_GMAJOR |
Graduate Major File sorted by major code Including fields such as major code, major name, |
Other Common Files: (Field
details are listed below for each file)
F_ADVISOR |
Advisor Information |
F_GEOGRAPH |
State and County Codes Includes fields such as geographic code and name |
F_ZCUR1MMM |
Course Information for Semester Includes fields such as section number, department, credit hours, class time, instructor, |
F_ZCUR1REM |
Student Course Enrollment Information for Semester |
F_NAMEINFO |
Student File for All Students (one record per student) Includes fields such as ID number, name, address, DOB, race Identical to NAME5ZIP file below but home zip code is 9 long |
F_NAME5ZIP |
Student File for All Students (one record per student) Includes fields such as ID number, name, address, DOB, race Identical to NAMEINFO file above but home zip code is 5 long |