Go To View:  RETURN TO BANNER COMP META DATA 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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD 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)  

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 Academic Period Description Describes the term code and identifies what it represents. Not used in academic year. VARCHAR2(30)  

STVTERM

STVTERM_DESC

ACADEMIC_YEAR 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 Academic Year Description The description of the valid year. VARCHAR2(30)  

STVACYR

STVACYR_DESC

CURRENT_DATE Current Date The current date. DATE  

NA

NA

SYSDATE

SYSDATE

DOMAIN_VALUE Domain Value Domain column for future use, not currently populated. VARCHAR2(6)  

NA

NA

NA

NA

MIF_DESC MIF Description 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

NA

NA

MIF_VALUE 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

NA

NA

PERSON_UID 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 Value Zone column for future use, not currently populated. VARCHAR2(6)  

NA

NA

NA

NA



Ver: