Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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 academic period (probation, good standing, etc). This will be either an override academic standing or the calculated value from the closest previous academic period.	VARCHAR2(2)		FUNCTION	SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''ASTD'',''C'')
ACADEMIC_STANDING_DATE		Date on which the beginning academic standing is effective for the academic period.	DATE		FUNCTION	SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''ASTD'',''D'')
ACADEMIC_STANDING_DESC		Description of the academic standing value.	VARCHAR2(30)		STVASTD	STVASTD_DESC
ACADEMIC_STANDING_END		Identifies a student's academic standing at the end of the academic period (probation, good standing, etc).	VARCHAR2(2)		SHRTTRM	SHRTTRM_ASTD_CODE_END_OF_TERM
ACADEMIC_STANDING_END_DT		Date on which the end of academic period academic standing is effective.	DATE		SHRTTRM	SHRTTRM_ASTD_DATE_END_OF_TERM
ACADEMIC_STAND_OVERRIDE		Identifies the academic standing override for a student for the academic period.	VARCHAR2(2)		SGBSTDN	SGBSTDN_ASTD_CODE
ACADEMIC_STAND_OVERRIDE_DESC		Description of the academic standing override value.	VARCHAR2(30)		STVASTD	STVASTD_DESC
ACADEMIC_YEAR		This field identifies the academic year associated with the information on the student information record.	VARCHAR2(4)
ACADEMIC_YEAR_DESC		This field specifies the academic year associated with the academic year code.	VARCHAR2(30)		STVACYR	STVACYR_DESC
ACAD_STANDING_END_DESC		Description of the academic standing code.	VARCHAR2(30)		STVASTD	STVASTD_DESC
COMBINED_ACAD_STANDING		Identifies a student's combined academic standing at the beginning of the academic period (probation, good standing, etc). This will be either an override combined academic standing or the calculated value from the closest previous academic period.	VARCHAR2(2)		FUNCTION	SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''CAST'',''C'')
COMBINED_ACAD_STANDING_DATE		Date combined academic standing code was updated.	DATE		FUNCTION	SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''CAST'',''D'')
COMBINED_ACAD_STANDING_DESC		Description of the combined academic standing code for the academic period.	VARCHAR2(30)		STVCAST	STVCAST_DESC
COMBINED_ACAD_STAND_END		Identifies a student's combined academic standing at the end of the academic period (probation, good standing, etc).	VARCHAR2(2)		SHRTTRM	SHRTTRM_CAST_CODE
COMBINED_ACAD_STAND_END_DATE		Date on which the end of academic period combined academic standing was entered.	DATE		SHRTTRM	SHRTTRM_CAST_DATE
COMBINED_ACAD_STAND_END_DESC		Description of the combined academic standing.	VARCHAR2(30)		STVCAST	STVCAST_DESC
COMB_ACAD_STAND_OVERRIDE		Identifies the combined academic standing override for a student for the academic period.	VARCHAR2(2)		SGBSTDN	SGBSTDN_CAST_CODE
COMB_ACAD_STAND_OVERRIDE_DESC		Description of the combined academic standing override for a student for the academic period.	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		Identifies a student's progress evaluation at the beginning of the academic period (probation, good standing, etc). This will be either an override progress evaluation or the calculated value from the closest previous academic period.	VARCHAR2(2)		FUNCTION	SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''PREV'',''C'')
PROGRESS_EVALUATION_DATE		This is the date progress evaluation code was updated.	DATE		FUNCTION	SOKODSF.F_START_ACAD_STAND_DATA (PIDM,TERM,''PREV'',''D'')
PROGRESS_EVALUATION_DESC		The description for the progress evaluation code for this academic history academic period.	VARCHAR2(30)		STVPREV	STVPREV_DESC
PROGRESS_EVALUATION_END		Identifies a student's progress evaluation at the end of the academic period (probation, good standing, etc).	VARCHAR2(2)		SHRTTRM	SHRTTRM_PREV_CODE
PROGRESS_EVALUATION_END_DATE		Date on which the end of academic period progress evaluation was entered.	DATE		SHRTTRM	SHRTTRM_PREV_DATE
PROGRESS_EVALUATION_END_DESC		Description of the progress evaluation for this academic period.	VARCHAR2(30)		STVPREV	STVPREV_DESC
PROGRESS_EVAL_OVERRIDE		Identifies the progress evaluation override for a student for the academic period.	VARCHAR2(2)		SGBSTDN	SGBSTDN_PREV_CODE
PROGRESS_EVAL_OVERRIDE_DESC		Description of the progress evaluation override for a student for the academic period.	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: