Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	This field identifies the academic period or term associated with the information on the student information record.	VARCHAR2(6)	SGBSTDN SHRTTRM	SGBSTDN_TERM_CODE_EFF SHRTTRM_TERM_CODE
ACADEMIC_PERIOD_DESC	This field specifies the academic period or term associated with the academic period code.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_STANDING	Identifies a student's academic standing at the beginning of the term (probation, good standing, etc).	VARCHAR2(2)	FUNCTION SHRTTRM	SOKODSF.F_GET_ASTD_DEFAULT SHRTTRM_ASTD_CODE_END_OF_TERM
ACADEMIC_STANDING_DATE	Date on which the beginning of term academic standing was entered.	DATE	SHRTTRM	SHRTTRM_ASTD_DATE_END_OF_TERM
ACADEMIC_STANDING_DESC	The description of the academic standing field.	VARCHAR2(30)	STVASTD	STVASTD_DESC
ACADEMIC_STANDING_END	Identifies a student's academic standing at the end of the term (probation, good standing, etc).	VARCHAR2(2)	SHRTTRM	SHRTTRM_ASTD_CODE_END_OF_TERM
ACADEMIC_STANDING_END_DT	Date on which the end of term academic standing was entered.	DATE	SHRTTRM	SHRTTRM_ASTD_DATE_END_OF_TERM
ACADEMIC_STAND_OVERRIDE	This field identifies the academic standing override for a student for the term.	VARCHAR2(2)	SGBSTDN	SGBSTDN_ASTD_CODE
ACADEMIC_STAND_OVERRIDE_DESC	The description of the academic standing override for a student for the term.	VARCHAR2(30)	STVASTD	STVASTD_DESC
ACADEMIC_YEAR	This field identifies the academic year associated with the information on the student information record.	VARCHAR2(4)	STVACYR	STVACYR_CODE
ACADEMIC_YEAR_DESC	This field specifies the academic year associated with the academic year code.	VARCHAR2(30)	STVACYR	STVACYR_DESC
ACAD_STANDING_END_DESC	The description of the academic standing field.	VARCHAR2(30)	STVASTD	STVASTD_DESC
COMBINED_ACAD_STANDING	Academic History Term record Combined Academic Standing code.	VARCHAR2(2)	FUNCTION SHRTTRM	SOKODSF.F_GET_CAST_DEFAULT SHRTTRM_CAST_CODE
COMBINED_ACAD_STANDING_DATE	This is the date combined academic standing code was updated.	DATE	SHRTTRM	SHRTTRM_CAST_DATE
COMBINED_ACAD_STANDING_DESC	The description of the Academic History Term record Combined Academic Standing code.	VARCHAR2(30)	STVCAST	STVCAST_DESC
COMBINED_ACAD_STAND_END	Identifies a student's combined academic standing at the end of the term (probation, good standing, etc).	VARCHAR2(2)	SHRTTRM	SHRTTRM_CAST_CODE
COMBINED_ACAD_STAND_END_DATE	Date on which the end of term combined academic standing was entered.	DATE	SHRTTRM	SHRTTRM_CAST_DATE
COMBINED_ACAD_STAND_END_DESC	The description of the combined academic standing field.	VARCHAR2(30)	STVCAST	STVCAST_DESC
COMB_ACAD_STAND_OVERRIDE	This field identifies the combined academic standing override for a student for the term.	VARCHAR2(2)	SGBSTDN	SGBSTDN_CAST_CODE
COMB_ACAD_STAND_OVERRIDE_DESC	The description of the combined academic standing override for a student for the term.	VARCHAR2(30)	STVCAST	STVCAST_DESC
CURRENT_DATE	This is the date when the rows in this view were retrieved.	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA
PERSON_UID	The internal number used to uniquely identify an individual.	NUMBER(8)	SGBSTDN SHRTTRM	SGBSTDN_PIDM SHRTTRM_PIDM
PROGRESS_EVALUATION	Academic History Term record Progress Evaluation code.	VARCHAR2(2)	FUNCTION SHRTTRM	SOKODSF.F_GET_PREV_DEFAULT SHRTTRM_PREV_CODE
PROGRESS_EVALUATION_DATE	This is the date progress evaluation code was updated.	DATE	SHRTTRM	SHRTTRM_PREV_DATE
PROGRESS_EVALUATION_DESC	The description of the Academic History Term record Progress Evaluation code.	VARCHAR2(30)	STVPREV	STVPREV_DESC
PROGRESS_EVALUATION_END	Identifies a student's progress evaluation at the end of the term (probation, good standing, etc).	VARCHAR2(2)	SHRTTRM	SHRTTRM_PREV_CODE
PROGRESS_EVALUATION_END_DATE	Date on which the end of term progress evaluation was entered.	DATE	SHRTTRM	SHRTTRM_PREV_DATE
PROGRESS_EVALUATION_END_DESC	The description of the progress evaluation field.	VARCHAR2(30)	STVPREV	STVPREV_DESC
PROGRESS_EVAL_OVERRIDE	This field identifies the progress evaluation override for a student for the term.	VARCHAR2(2)	SGBSTDN	SGBSTDN_PREV_CODE
PROGRESS_EVAL_OVERRIDE_DESC	The description of the progress evaluation override for a student for the term.	VARCHAR2(30)	STVPREV	STVPREV_DESC
STUDENT_LEVEL	Student level associated with the academic standing. Examples include undergraduate, graduate, etc.	VARCHAR2(2)	SGBSTDN	SGBSTDN_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC
SUB_ACADEMIC_PERIOD	This field identifies the session or part of the academic period associated with the information on the student information record.	VARCHAR2(6)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	This field identifies the description of the session or part of the academic period associated with the information on the student information record.	VARCHAR2(30)	NA	NA
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: 8.1