back to htv views

ColumnTypeLengthContents
IDlong int Student ID number
SortSemchar6Sort semester
DispSemchar6Print semester
Fnamevarchar20Student’s first name for diploma
Mnamevarchar20Student’s middle name for diploma
Lnamevarchar20Student’s last name for diploma
Suffixvarchar10Student’s suffix for diploma (e.g. Jr. III)
StdtIntentvarchar10Student’s commencement plans (gradonly=graduating but not attending commencement; gradwalk=graduating and attending commencement; walkonly=not graduating but attending commencement)
OSRStatusvarchar10Code indicating the intent status after review by the Office of Student Records
OSRMemovarchar200 
DivStatusvarchar10 
DivMemovarchar200 
ProgCommentvarchar100Student’s comments
ProgMissingchar1Not currently in use
Pronunciationvarchar60Student name pronunciation guide
SpecialNamechar1Flag indicating special name instructions or characters (Y or N)
WalkingOnlychar1Flag indicating student is not graduating, but is walking in the commencement ceremony (Y or N)
SpringWalkingchar1Not currently in use
CollegeHonorsvarchar10Not currently in use
OrigDatedatetime Date the record was created
MaintDatedatetime Date the record was last changed
LastChgNamechar47Name of the last person who changed the record