Column | Type | Length | Contents |
---|
ID | long int | | Student ID number |
SortSem | char | 6 | Sort semester |
DispSem | char | 6 | Print semester |
Fname | varchar | 20 | Student’s first name for diploma |
Mname | varchar | 20 | Student’s middle name for diploma |
Lname | varchar | 20 | Student’s last name for diploma |
Suffix | varchar | 10 | Student’s suffix for diploma (e.g. Jr. III) |
StdtIntent | varchar | 10 | Student’s commencement plans (gradonly=graduating but not attending commencement; gradwalk=graduating and attending commencement; walkonly=not graduating but attending commencement) |
OSRStatus | varchar | 10 | Code indicating the intent status after review by the Office of Student Records |
OSRMemo | varchar | 200 | |
DivStatus | varchar | 10 | |
DivMemo | varchar | 200 | |
ProgComment | varchar | 100 | Student’s comments |
ProgMissing | char | 1 | Not currently in use |
Pronunciation | varchar | 60 | Student name pronunciation guide |
SpecialName | char | 1 | Flag indicating special name instructions or characters (Y or N) |
WalkingOnly | char | 1 | Flag indicating student is not graduating, but is walking in the commencement ceremony (Y or N) |
SpringWalking | char | 1 | Not currently in use |
CollegeHonors | varchar | 10 | Not currently in use |
OrigDate | datetime | | Date the record was created |
MaintDate | datetime | | Date the record was last changed |
LastChgName | char | 47 | Name of the last person who changed the record |