| Column | Type | Length | Contents |
|---|
| ID | long int | | Student ID number |
| ProgID | int | | Program ID number |
| SemAdmitted | char | 6 | Semester admitted to the program (format is ccyyss, where ss=01 is January Intersession, ss=02 is Spring, ss=03 is Summer, ss=04 is Year and ss=05 is Fall, e.g. 200105 = FL2001) |
| SeqNo | tinyint | | Sequence number for uniqueness if a student is admitted to the same program twice in one semester |
| Discipline | char | 12 | Discipline code |
| AdvisorID | char | 9 | Advisor ID |
| AdvisorName | char | 15 | Advisor name |
| JointProgDept1 | char | 6 | Joint program department code 1 or second major department code |
| JointProgDept2 | char | 6 | Joint program department code 2 or third major department code |
| Status | char | 1 | Program status (1=open, 2=closed, 3=completed) |
| TermSem | char | 6 | Semester the program was terminated either by closing or completing (format is ccyyss, where ss=01 is January Intersession, ss=02 is Spring, ss=03 is Summer, ss=04 is Year and ss=05 is Fall, e.g. 200105 is FL2001) |
| School | char | 2 | Pre-professional school |
| HoldCode | char | 8 | Program hold code |
| DegreeCode | char | 4 | Degree Code |
| PrimeJointDiv | char | 1 | Code indicating if the program is prime or joint (P=prime, J=joint) |
| ProgramCode | char | 6 | Major program code |
| ProgramName | varchar | 50 | Program Name |
| OrigDt | datetime | | Date the record was originally created |
| Completed | varchar | 10 | Flag indicating that program requirements are complete |
| MaintDt | smalldatetime | | Last date record was updated |
| LastChgName | char | 46 | Name of last user who updated the record |