RETURN TO BANNER EDW META DATA REPORTS LIST
Secondary School Subject Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_SECONDARY_SCHOOL_SUBJECT

Description Secondary School Subject fact table provides the measures and data related to the subjects taken at a secondary school. .

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO SECONDARY SCHOOL SUBJECT
INSTITUTION_KEY Key for the institution dimension. NUMBER

ETL GENERATED

NA

NO

NO SECONDARY SCHOOL SUBJECT
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO SECONDARY SCHOOL SUBJECT
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SECONDARY_SCHOOL_SUBJECT

PERSON_UID

NO

NO SECONDARY SCHOOL SUBJECT
SECONDARY_SCHOOL_SUBJECT_GPA Number of secondary school years the person took this subject. NUMBER

SECONDARY_SCHOOL_SUBJECT

GPA

NO

NO SECONDARY SCHOOL SUBJECT
SECONDARY_SCHOOL_SUBJECT_KEY Key for the secondary school subject dimension. NUMBER

ETL GENERATED

NA

NO

NO SECONDARY SCHOOL SUBJECT
SEC_SCHOOL_SUBJECT_GROUP_KEY Key for the secondary school subject group. NUMBER

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

NO SECONDARY SCHOOL SUBJECT
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO SECONDARY SCHOOL SUBJECT
YEARS_TAKEN Calculated grade point average or average for a set of courses completed by the person at their secondary school. NUMBER

SECONDARY_SCHOOL_SUBJECT

YEARS_TAKEN

NO

NO SECONDARY SCHOOL SUBJECT


Ver: 9.0