Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_ACTIVE_TERMS

Description Source composite view contains all students and the terms in which they have activity. This includes academic periods with a new base student record, enrollment activity, academic history, transfer activity, graduation, a cohort entry, sports participation, student attributes, student activities, student work experience, financial aid application or awards, and accounts receivable detail or student contracts.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Identifies the valid term codes within the Year selected. VARCHAR2(6)

ROBINST

RORTPRD

RPRATRM

SFBETRM

SGBSTDN

SGRCHRT

SGRCOOP

SGRSACT

SGRSATT

SGRSPRT

SHRDGMR

SHRTRAM

SHRTTRM

TBBCSTU

TBRACCD

ROBINST_CURRENT_TERM_CODE

RORTPRD_TERM_CODE

RPRATRM_TERM_CODE

SFBETRM_TERM_CODE

SGBSTDN_TERM_CODE_EFF

SGRCHRT_TERM_CODE_EFF

SGRCOOP_TERM_CODE

SGRSACT_TERM_CODE

SGRSATT_TERM_CODE_EFF

SGRSPRT_TERM_CODE

SHRDGMR_TERM_CODE_GRAD

SHRTRAM_TERM_CODE_ENTERED

SHRTTRM_TERM_CODE

TBBCSTU_TERM_CODE

TBRACCD_TERM_CODE

ACADEMIC_PERIOD_DESC Describes the term code and identifies what it represents. Not used in academic year. VARCHAR2(30)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR The year to be associated with information in this record. This may be from any of the year validations in the system. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC The description of the valid year. VARCHAR2(30)

STVACYR

STVACYR_DESC

CURRENT_DATE The current date. 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

RORSTAT

RPRATRM

SFBETRM

SGBSTDN

SGRCHRT

SGRCOOP

SGRSACT

SGRSATT

SGRSPRT

SHRDGMR

SHRTRAM

SHRTTRM

TBBCSTU

TBRACCD

RORSTAT_PIDM

RPRATRM_PIDM

SFBETRM_PIDM

SGBSTDN_PIDM

SGRCHRT_PIDM

SGRCOOP_PIDM

SGRSACT_PIDM

SGRSATT_PIDM

SGRSPRT_PIDM

SHRDGMR_PIDM

SHRTRAM_PIDM

SHRTTRM_PIDM

TBBCSTU_STU_PIDM

TBRACCD_PIDM

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: 8.1