RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE 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(4)

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: 3.1