| Column | Type | Length | Contents |
|---|
| ID | long int | | Student ID number |
| EthnicMix | char | 10 | not currently in use |
| RaceCode | char | 1 | Race code |
| MaritalStat | char | 1 | Marital status |
| Sex | char | 1 | Sex |
| BirthDate | datetime | | Birthdate |
| BirthPlace | char | 14 | Birthplace |
| FSChild | char | 1 | Faculty/Staff child |
| AlumniCd | char | 1 | Alumni code |
| Citizen | char | 1 | Citizenship code |
| SortSemEntry | char | 6 | Semester of entry. SortSemEntry is a SortSem |
| SemEntry | char | 6 | Semester of entry. SemEntry is a DispSem |
| EnrollSt | char | 1 | Enrollment status (F=fall freshman, T=fall transfer, X=spring freshman, Y=spring transfer) |
| FrozenCohort | varchar | 8 | Permanent record of an undergraduate’s entry status, captured on the first day of class for entering students. Format is: Enrollment Status + Anticipated Grad Date + Division Code (e.g. FR2020LA is an Arts & Sciences FL2016 freshman) |
| CCntryCd | char | 4 | Country code |
| VisaType | char | 2 | Visa type |
| ProfSch1 | char | 2 | Professional school interest code (e.g. PM=pre-med) |
| ProfSch2 | char | 2 | Professional school interest code (e.g. PM=pre-med) |
| ParentOcc | char | 6 | Parent occupation |
| ProgYr | char | 1 | Program year – not currently in use |
| DateOfDeath | datetime | | Date of death |
| AreaIntCd | char | 7 | Academic interest codes |
| DegCandid | char | 1 | Flag indicating student is seeking a degree |
| DegAnticpDt | char | 4 | Anticipated graduation date |
| Locale | char | 1 | Local (maintained for current full-time freshmen; L=local, N=outside metropolitan area) |
| ParentInc | char | 1 | Code indicating parent income |
| AreaInt | char | 18 | Used for different data by different departments |
| Veteran | char | 1 | Veteran code |
| DisciplinAction | char | 1 | University College flag tied to approval process |
| Hispanic | char | 1 | Flag indicating if a student identified as Hispanic |
| NativeAmer | char | 1 | Flag indicating if a student identified as American Indian or Alaska Native |
| Asian | char | 1 | Flag indicating if a student identified as Asian |
| Black | char | 1 | Flag indicating if a student identified as Black or African American |
| HawaiianPacific | char | 1 | Flag indicating if a student identified as Native Hawaiian or Other Pacific Islander |
| White | char | 1 | Flag indicating if a student identified as White |
| NonResAlien | char | 1 | Flag indicating if a student identified as Nonresident alien |
| RaceNotReported | char | 1 | Flag indicating if a student did not report a race |
| FirstLanguage | char | 1 | First Language |
| DACatSortSem | char | 1 | DA Cat Sort Sememester |
| MaintDt | datetime | | Last date record was updated |
| LastChgName | char | 46 | Name of last user who updated the record |
| IPEDSRaceEthnicity | char | 41 | IPEDSRaceEthnicity The National Center for Education Statistics IPEDS definition for grouping a student into one race category |