Htv nslc

back to htv views

Column	Type	Length	Contents
ID	long int		Student ID number
DispSem	char	6	Print semester
SortSem	char	6	Sort semester
Campus	char	1	Campus location (H=Hilltop, M=Med School)
Div	char	2	Student’s prime division
ProgramCode	varchar	15	Student’s prime open program code
Units	decimal		Semester course units
StdtLevel	char	2	Student level (1=1st semester freshman, 2=2nd semester freshman, 3=1st semester sophomore, …, 8=2nd semester senior)
GradLevel	char	1	Code indicating whether a student is graduate or undergraduate level (G=graduate, U=undergraduate)
Name	varchar	25	Student’s name (Last, first, middle)
FirstName	varchar	20	Student’s first name
MiddleInitial	char	1	Student’s middle initial
LastName	varchar	20	Student’s last name
Suffix	varchar	5	Student’s name suffix (Jr., Sr., III, etc.)
Street1	varchar	30	Street address 1
Street2	varchar	30	Street address 2
City	varchar	20	Home City
State	char	2	Home State
Zip	char	9	Home Zip
Country	varchar	15	Home country
Birthdate	datetime		Student’s Birthdate
Deceased	datetime		Date of death
DeanFlag	char	2	Dean flag
EnrSt	char	1	Student’s enrollment status (F=Full time, Q=Three-Quarter time, H=Half time, L=Less than half time)
StatusDt	datetime		Status date
FAEnrSt	char	1	Student’s financial aid enrollment status (F=Full time, Q=Three-Quarter time, H=Half time, L=Less than half time)
ResStat	char	1	Student’s resident status (Y=yes, N=no, Blank=yes)
MaintDt	datetime		Maintenance date
LastChgName	char	46	Name of last user who updated the record