back to htv views

ColumnTypeLengthContents
IDlong int Student ID number
ActionTypechar3Type of action (always HON)
ActionIDchar4Action ID
Descriptionvarchar255Description of the action (e.g. Dean’s List)
DispSemchar6Print semester
SortSemchar6Sort semester
SeqNosmallint Sequence number used when an action is duplicated in one semester
Commentvarchar255Comment describing the action type
SemesterStartchar4Start date of the semester in which the action occurred (month and day)
DeanCodechar2Dean code
SchCodechar1School code
DeptCodechar3Department code of a course ID to which an action is related
CourseNochar4Course number of a course ID to which an action is related
Gradechar4Grade for a course to which an action is related
MaintDtdatetime Last date the record was updated
LastChgNamechar45Name of last user who updated the record
OrigDtdatetime Date the action was originally created
RecCodechar2Record code (HO=Honor)