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
Includes fields such as advisor number, location, phone number

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
Includes fields such as student ID number, section number                 

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