ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_PERIOD	This field identifies the academic period or term associated with the information on the student information record.			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.			STVTERM	STVTERM_DESC
ACADEMIC_STANDING	Identifies a student's academic standing at the beginning of the term (probation, good standing, etc).			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.			SHRTTRM	SHRTTRM_ASTD_DATE_END_OF_TERM
ACADEMIC_STANDING_DESC	The description of the academic standing field.			STVASTD	STVASTD_DESC
ACADEMIC_STANDING_END	Identifies a student's academic standing at the end of the term (probation, good standing, etc).			SHRTTRM	SHRTTRM_ASTD_CODE_END_OF_TERM
ACADEMIC_STANDING_END_DT	Date on which the end of term academic standing was entered.			SHRTTRM	SHRTTRM_ASTD_DATE_END_OF_TERM
ACADEMIC_STAND_OVERRIDE	This field identifies the academic standing override for a student for the term.			SGBSTDN	SGBSTDN_ASTD_CODE
ACADEMIC_STAND_OVERRIDE_DESC	The description of the academic standing override for a student for the term.			STVASTD	STVASTD_DESC
ACADEMIC_YEAR	This field identifies the academic year associated with the information on the student information record.			STVACYR	STVACYR_CODE
ACADEMIC_YEAR_DESC	This field specifies the academic year associated with the academic year code.			STVACYR	STVACYR_DESC
ACAD_STANDING_END_DESC	The description of the academic standing field.			STVASTD	STVASTD_DESC
COMBINED_ACAD_STANDING	Academic History Term record Combined Academic Standing code.			FUNCTION SHRTTRM	SOKODSF.F_GET_CAST_DEFAULT SHRTTRM_CAST_CODE
COMBINED_ACAD_STANDING_DATE	This is the date combined academic standing code was updated.			SHRTTRM	SHRTTRM_CAST_DATE
COMBINED_ACAD_STANDING_DESC	The description of the Academic History Term record Combined Academic Standing code.			STVCAST	STVCAST_DESC
COMBINED_ACAD_STAND_END	Identifies a student's combined academic standing at the end of the term (probation, good standing, etc).			SHRTTRM	SHRTTRM_CAST_CODE
COMBINED_ACAD_STAND_END_DATE	Date on which the end of term combined academic standing was entered.			SHRTTRM	SHRTTRM_CAST_DATE
COMBINED_ACAD_STAND_END_DESC	The description of the combined academic standing field.			STVCAST	STVCAST_DESC
COMB_ACAD_STAND_OVERRIDE	This field identifies the combined academic standing override for a student for the term.			SGBSTDN	SGBSTDN_CAST_CODE
COMB_ACAD_STAND_OVERRIDE_DESC	The description of the combined academic standing override for a student for the term.			STVCAST	STVCAST_DESC
CURRENT_DATE	This is the date when the rows in this view were retrieved.			NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.			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.			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.			NA	NA
PERSON_UID	The internal number used to uniquely identify an individual.			SGBSTDN SHRTTRM	SGBSTDN_PIDM SHRTTRM_PIDM
PROGRESS_EVALUATION	Academic History Term record Progress Evaluation code.			FUNCTION SHRTTRM	SOKODSF.F_GET_PREV_DEFAULT SHRTTRM_PREV_CODE
PROGRESS_EVALUATION_DATE	This is the date progress evaluation code was updated.			SHRTTRM	SHRTTRM_PREV_DATE
PROGRESS_EVALUATION_DESC	The description of the Academic History Term record Progress Evaluation code.			STVPREV	STVPREV_DESC
PROGRESS_EVALUATION_END	Identifies a student's progress evaluation at the end of the term (probation, good standing, etc).			SHRTTRM	SHRTTRM_PREV_CODE
PROGRESS_EVALUATION_END_DATE	Date on which the end of term progress evaluation was entered.			SHRTTRM	SHRTTRM_PREV_DATE
PROGRESS_EVALUATION_END_DESC	The description of the progress evaluation field.			STVPREV	STVPREV_DESC
PROGRESS_EVAL_OVERRIDE	This field identifies the progress evaluation override for a student for the term.			SGBSTDN	SGBSTDN_PREV_CODE
PROGRESS_EVAL_OVERRIDE_DESC	The description of the progress evaluation override for a student for the term.			STVPREV	STVPREV_DESC
STUDENT_LEVEL	Student level associated with the academic standing. Examples include undergraduate, graduate, etc.			SGBSTDN	SGBSTDN_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.			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.			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.			NA	NA
ZONE_VALUE	Zone column for future use, not currently populated.			NA	NA

Ver: 8.3