Composite View Target: AS_INSTITUTION

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

SGHE 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

CALENDAR_YEAR Calendar year for which the characteristics are associated with the institution. NUMBER
SORBCHR

SORBCHR_DEMO_YEAR

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

INSTITUTION Source/background institution code. VARCHAR2(6)
SORBCHR

SORBCHR_SBGI_CODE

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

INST_CHARACTERISTIC_DESC Institution characteristic description. VARCHAR2(30)

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

Ver:

Target Column	Business Definition	Database Data Type	Source Name	Source Column
CALENDAR_YEAR	Calendar year for which the characteristics are associated with the institution.	NUMBER	SORBCHR	SORBCHR_DEMO_YEAR
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)
INSTITUTION	Source/background institution code.	VARCHAR2(6)	SORBCHR	SORBCHR_SBGI_CODE
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
INST_CHARACTERISTIC_DESC	Institution characteristic description.	VARCHAR2(30)
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)