RETURN TO DIMENSION TABLE REPORTS LIST
Employment Application Star Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_SECONDARY_SCHOOL

Description Secondary School Dimension table provides information on the secondary or high school which the person attended. This information includes name of the school and type of diploma earned. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
SECONDARY_DIPLOMA Type of diploma received on completion of secondary school study. VARCHAR2(63)

PRE_STUDENT

SECONDARY_SCHOOL_DIPLOMA

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

SECONDARY_DIPLOMA_LD Long description for the diploma type. VARCHAR2(255)

PRE_STUDENT

SECONDARY_SCHOOL_DIPLOMA_DESC

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

SECONDARY_DIPLOMA_SD Short description for the diploma type. VARCHAR2(255)

PRE_STUDENT

SECONDARY_SCHOOL_DIPLOMA_DESC

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

SECONDARY_SCHOOL Identifies the type of institution attended. This will be only the records marked with an 'H' for High School or Secondary School. VARCHAR2(63)

INSTITUTION

INSTITUTION_TYPE

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

SECONDARY_SCHOOL_KEY Key for the secondary school dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

SECONDARY_SCHOOL_LD Long description for the type of institution. VARCHAR2(255)

INSTITUTION

INSTITUTION_TYPE_DESC

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

SECONDARY_SCHOOL_SD Short description for the type of institution. VARCHAR2(255)

INSTITUTION

INSTITUTION_TYPE_DESC

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

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

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

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

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION



Ver: 3.1