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

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_SECONDARY_SCHOOL_SUBJECT

Description Secondary School Subject dimension table provides information on the secondary or high school subjects being tracked for a person.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
SECONDARY_SCHOOL_SUBJECT Identifies secondary school subjects taken by the prospect/applicant to be used as evaluation criteria. VARCHAR2(63)

SECONDARY_SCHOOL_SUBJECT

SUBJECT

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
SECONDARY_SCHOOL_SUBJECT_LD Secondary school subject description. VARCHAR2(255)

SECONDARY_SCHOOL_SUBJECT

SUBJECT_DESC

NO

NO SECONDARY SCHOOL SUBJECT
SECONDARY_SCHOOL_SUBJECT_SD Secondary school subject description. VARCHAR2(255)

SECONDARY_SCHOOL_SUBJECT

SUBJECT_DESC

NO

NO SECONDARY SCHOOL SUBJECT
SECONDARY_SUBJECT_GPA_RANGE Calculated grade point average or average for a set of courses completed by the person at their secondary school. VARCHAR2(63)

SECONDARY_SCHOOL_SUBJECT

GPA

NO

NO SECONDARY SCHOOL SUBJECT
SECONDARY_SUBJECT_GPA_RANGE_LD Long description for the secondary school subject GPA range. VARCHAR2(255)

EDW CLEANSING PROCESS

EDW CLEANSING PROCESS

NA

NA

NO

NO

NO SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT 

SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT

SECONDARY_SUBJECT_GPA_RANGE_SD Short description for the secondary school subject GPA range. VARCHAR2(255)

EDW CLEANSING PROCESS

EDW CLEANSING PROCESS

NA

NA

NO

NO

NO SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT 

SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT

SECONDARY_SUBJECT_GRADE Grades received for high school subjects taken by the prospect/applicant. VARCHAR2(63)

SECONDARY_SCHOOL_SUBJECT

GRADE

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


Ver: 8.4.3