RETURN TO BANNER EDW META DATA REPORTS LIST
Student Attribute Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_STUDENT_ATTRIBUTE

Description Student Attribute Fact Table provides data for each student attribute associated with the student by academic period.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_TIME_KEY Key for the academic time dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT ATTRIBUTE
ATTRIBUTE_KEY Key for the attribute dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT ATTRIBUTE
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT ATTRIBUTE
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT ATTRIBUTE
PERSON_UID Key for the person dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT ATTRIBUTE
STUDENT_ATTRIBUTE_COUNT_KEY Key for the student attribute count. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT ATTRIBUTE
STUDENT_ATTRIBUTE_GROUP_KEY Key for the student attribute group. NUMBER

ETL_GENERATED

NA

NO

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

ETL_GENERATED

NA

NO

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

ETL_GENERATED

NA

NO

NO STUDENT ATTRIBUTE


Ver: 9.0