RETURN TO BANNER EDW META DATA REPORTS LIST
Institution Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_INSTITUTION

Description Institution Fact table provides measures that may be used to compare and display institution related information.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ENROLLMENT Institution's enrollment. NUMBER

INSTITUTION_DEMOGRAPHIC

ENROLLMENT

NO

NO INSTITUTION
GEOGRAPHIC_REGION_KEY Key for the geographic region dimension. NUMBER

ETL GENERATED

NA

NO

NO INSTITUTION
INSTITUTION_GRP_KEY Institution Grp KEY. NUMBER       NO
INSTITUTION_KEY Key for the institution dimension. NUMBER

ETL GENERATED

NA

NO

NO INSTITUTION
MEAN_FAMILY_INCOME Mean family income for the institution. NUMBER

INSTITUTION_DEMOGRAPHIC

MEAN_FAMILY_INCOME

NO

NO INSTITUTION
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO INSTITUTION
NUMBER_OF_SENIORS Institution's number of seniors. NUMBER

INSTITUTION_DEMOGRAPHIC

NUMBER_OF_SENIORS

NO

NO INSTITUTION
PERCENT_COLLEGE_BOUND Percent college bound for the institution. NUMBER

INSTITUTION_DEMOGRAPHIC

PERCENT_COLLEGE_BOUND

NO

NO INSTITUTION
POSTAL_KEY Key for the postal dimension. NUMBER

ETL GENERATED

NA

NO

NO INSTITUTION
RECRUITING_TERRITORY_KEY Recruiting Territory KEY. NUMBER       NO
STREET_LINE_KEY Key of the street line dimension. NUMBER

ETL GENERATED

NA

NO

NO INSTITUTION
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO INSTITUTION
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO INSTITUTION


Ver: 9.0