RETURN TO BANNER EDW META DATA REPORTS LIST
Advisor Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ADVISOR

Description Advisor Fact Table provides a record for all advisor assignments for the student for each academic period.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_TIME_END_KEY Key for the advisor assignment end academic time dimension.. NUMBER

ETL_GENERATED

NA

NO

NO ADVISOR
ACADEMIC_TIME_KEY Key for the academic time dimension.. NUMBER

ETL_GENERATED

NA

NO

NO ADVISOR
ACADEMIC_TIME_START_KEY Key for the advisor assignment start academic time dimension.. NUMBER

ETL_GENERATED

NA

NO

NO ADVISOR
ADVISOR_COUNT_KEY Advisor count unique identifier used to count advisor assignments. NUMBER

ETL_GENERATED

NA

NO

NO ADVISOR
ADVISOR_GROUP_KEY Advisor group identification key. NUMBER

ETL_GENERATED

NA

NO

NO ADVISOR
ADVISOR_KEY Key for the advisor dimension.. NUMBER

ETL_GENERATED

NA

NO

NO ADVISOR
ADVISOR_UID System generated, unique, internal identification number assigned to this advisor. NUMBER

ETL_GENERATED

NA

NO

NO ADVISOR
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL_GENERATED

NA

NO

NO ADVISOR
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL_GENERATED

NA

NO

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

ETL_GENERATED

NA

NO

NO ADVISOR
PRIMARY_ADVISOR_IND Identifies this advisor assignment as the primary advisor for this student . NUMBER

ADVISOR

PRIMARY_ADVISOR_IND

NO

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

ETL_GENERATED

NA

NO

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

ETL_GENERATED

NA

NO

NO ADVISOR


Ver: 9.0