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

Banner Operational Data Store
Composite View Target: AS_INSTITUTION_CHARACTERISTIC

Description Source composite view contains all institution characteristics associated within a calendar year to an institution.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
CALENDAR_YEAR Calendar year for which the characteristics are associated with the institution. NUMBER

SORBCHR

SORBCHR_DEMO_YEAR

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE       NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)       NO
INSTITUTION Source/background institution code. VARCHAR2(6)

SORBCHR

SORBCHR_SBGI_CODE

NO

NO
INST_CHARACTERISTIC Identifies a characteristic or attribute associated with the source background institution that may be used to group institutions for varied reporting purposes. VARCHAR2(1)

SORBCHR

SORBCHR_BCHR_CODE

NO

NO
INST_CHARACTERISTIC_DESC Institution characteristic description. VARCHAR2(30)       NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)       NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)       NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)       NO


Ver: