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

ETL GENERATED

NA

NA

NO

NO

NO SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT 

SECONDARY SCHOOL SUBJECT, 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: 8.4.3