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

NA

NO

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

EDW CLEANSING PROCESS

NA

NO

NO 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: 9.0