Go To View:  RETURN TO COMPOSITE VIEW 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 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.0