RETURN TO BANNER EDW META DATA REPORTS LIST
Application Rating Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_APPLICATION_RATING

Description Admission Rating fact table provides data per person per time frame per application record for the ratings recorded.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_TIME_KEY Key of the Academic Time dimension. NUMBER

ETL GENERATED

NA

NO

NO APPLICATION RATING
ADMINISTRATOR_ROLE_KEY Key for the administrator role dimension. NUMBER

ETL GENERATED

NA

NO

NO APPLICATION RATING
ADMINISTRATOR_UID System generated, unique, internal identification number assigned to this person. NUMBER

ADMISSIONS_RATING

ADMINISTRATOR_UID

NO

NO APPLICATION RATING
APPLICATION_NUMBER_KEY Key for the application number linked to the sequence dimension. NUMBER

ETL GENERATED

NA

NO

NO APPLICATION RATING
APPLICATION_RATING Rating value assigned to the student by the administrator. NUMBER

ADMISSIONS_RATING

ADMINISTRATOR_RATING

NO

NO APPLICATION RATING
APPLICATION_RATING_KEY Key for the application rating dimension. NUMBER

ETL GENERATED

NA

NO

NO APPLICATION RATING
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO APPLICATION RATING
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO APPLICATION RATING
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

ADMISSIONS_RATING

PERSON_UID

NO

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

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

NO APPLICATION RATING


Ver: 9.0