Composite View Target: AS_ACADEMIC

Go To View:	RETURN TO BANNER COMP META DATA REPORTS LIST
	Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_ACADEMIC_STANDING

Description Source composite view contains any academic status values assigned to a student for the term in which they were assigned.

Target Column Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. 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
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 Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, 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:

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	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	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	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, 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