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
|