back to htv views

ColumnTypeLengthContents
IDlong integer Student ID
SortSemchar6Sort semester
DispSemchar6Print semester
Awardsvarchar200Awards, honors, scholarships
FratSororityvarchar50Fraternity or sorority membership
Activitiesvarchar200Student activities
PrevDeg1varchar75Previous degree (graduate students only)
PrevDegSch1varchar75Previous degree school (graduate students only)
PrevDegYear1varchar4Previous degree year (graduate students only)
PrevDeg2varchar75Previous degree (graduate students only)
PrevDegSch2varchar75Previous degree school (graduate students only)
PrevDegYear2varchar4Previous degree year (graduate students only)
HomeAddrvarchar40Home address after graduation
HomeCityvarchar30Home city after graduation
HomeStatevarchar10Home state after graduation
HomeZipvarchar15Home zip after graduation
HomeCountryvarchar30Home country after graduation
HomePhonevarchar20Home phone number after graduation
Emailvarchar50Email address after graduation
BusCompanyvarchar40Employer name after graduation
BusAddrvarchar40Employer address after graduation
BusCityvarchar30Employer city after graduation
BusStatevarchar10Employer state after graduation
BusZipvarchar15Employer zip code after graduation
BusCountryvarchar30Employer country after graduation
AlumniTitlevarchar15Title to be used in alumni publications
RefName1varchar50Reference
RefAddr1varchar75Reference address
RefName2varchar50Reference
RefAddr2varchar75Reference address
OrigDatedatetime Date the record was created
MaintDatedatetime Date the record was last changed
LastChgNamechar Name of the last person who changed the record