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_DEMOGRAPHIC

Description Source composite view contains the source background institution with associated demographic data.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACCREDITATION_TYPE Identifies the type of accreditation held by the institution. Examples, may include north central, southern states, etc.    

SORBACD

SORBACD_ACCREDITATION_TYPE

 
ACCREDITATION_TYPE_DESC Description of the accreditation type.    

SORBACD

SORBACD_ACCREDITATION_TYPE

 
APPROVED_IND Indicates whether the institution is an approved institution within the state or province.    

SORBACD

SORBACD_STATE_APPROV_IND

 
CALENDAR_TYPE Identifies the type of academic period under which the institution operates. Examples, may include semester, quarter, term, etc.    

SORBACD

SORBACD_CALENDAR_TYPE

 
CALENDAR_TYPE_DESC Description of the calendar type code.    

SORBACD

SORBACD_CALENDAR_TYPE

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

SORBACD

SORBACD_DEMO_YEAR

 
CREDIT_WEIGHT Identifies the value or weight for each credit earned at the institution.    

SORBACD

SORBACD_CREDIT_TRANS_VALUE

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

NA

SYSDATE

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

NA

NA

 
ENROLLMENT Identifies the number of students enrolled at this institution.    

SORBDMO

SORBDMO_ENROLLMENT

 
INSTITUTION Source/background institution code.    

SOBSBGI

SOBSBGI_SBGI_CODE

 
MEAN_FAMILY_INCOME Specifies the mean family income for families with students attending the institution.    

SORBDMO

SORBDMO_MEAN_FAMILY_INCOME

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

 
NUMBER_OF_SENIORS Identifies the number of students who are in their final year of attendance at the institution.    

SORBDMO

SORBDMO_NO_OF_SENIORS

 
PERCENT_COLLEGE_BOUND Identifies the percent of students enrolled that intend to pursue a post secondary school education.    

SORBDMO

SORBDMO_PERC_COLLEGE_BOUND

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

NA

NA

 


Ver: 8.3