| Column | Type | Length | Contents |
|---|
| ProgID | int | | Program ID number |
| ProgCode | char | 15 | Program code (Div Dept Prog, e.g. LA0001) |
| DiscCode | char | 7 | Discipline code |
| ProgName | varchar | 50 | Program name |
| HegisCode | char | 4 | HEGIS code |
| GpaReq | decimal | | Not currently in use |
| TotUnits | decimal | | Not currently in use |
| SysMajCd | char | 2 | Not currently in use |
| BegDt | datetime | | Start date of program |
| EndDt | datetime | | End date of program |
| MaintDt | datetime | | Maintenance date |
| LastChgID | int | | ID of last user who updated the record |
| Division | char | 2 | Division code |
| Department | char | 3 | Department code |
| AwardLevel | varchar | 6 | Code indicating award level |
| ProgramLevel | varchar | 6 | Code indicating program level (U=undergraduate, G=graduate) |
| ProgramType | varchar | 6 | Used with undergraduate programs, indicates major, minor or SNCD |
| DisplayName | varchar | 50 | Alternate name of program |
| DegreeType | varchar | 15 | Abbreviated degree (e.g. B.F.A., M.S.W., A.B.) |
| FieldOfStudy | varchar | 50 | Majors, minors, etc. (e.g. History, Mechanical Engineering) |
| Language | char | 1 | Diploma language (L=Latin, E=English) |
| DiplomaName | varchar | 70 | Name of degree printed on diplomas (e.g. Philosophiae Doctoris, Bachelor of Science) |
| CIP2000 | char | 10 | Classification of Instructional Programs codes (revised 2000) |