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

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_POST_SECONDARY_SCHOOL

Description Post Secondary School Dimension table provides information on the post secondary school (college, university, trade school, etc after high school) that the person attended. This information includes name of the school and type of degree or award earned and the major subject area of study. 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
FINAL_DEGREE_IND Indicator is set for the last degree or award recorded for the person. This is calculated by using the PREVIOUS_EDUCATION_SLOT ODS reporting view column in the first post secondary institution columns. VARCHAR2(63)

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

FUNCTION

NO

NO

EMPLOYEE DEGREE

EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_DEGREE Identifies the degree or award associated with the previous post secondary school or internally awarded degree or other award from the ACADEMIC_OUTCOME reporting view. VARCHAR2(63)

ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

DEGREE

POST_SECONDARY_DEGREE1

NO

NO

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYEE DEGREE

EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_DEGREE_LD Long name of the degree or award. VARCHAR2(255)

ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

DEGREE_DESC

POST_SECONDARY_DEGREE_DESC1

NO

NO

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYEE DEGREE

EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_DEGREE_SD Short name of the degree or award. VARCHAR2(255)

ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

DEGREE_DESC

POST_SECONDARY_DEGREE_DESC1

POST_SECONDARY_DEGREE_DESC_1

POST_SECONDARY_DEGREE_DESC1

NO

NO

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYEE DEGREE

EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_MAJOR Identifies the major or subject area associated with the previous post secondary school. VARCHAR2(63)

ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

MAJOR

POST_SECONDARY_MAJOR1

POST_SECONDARY_MAJOR1_1

POST_SECONDARY_MAJOR1

NO

NO

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYEE DEGREE

EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_MAJOR_LD Long name of the major or subject area. VARCHAR2(255)

ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PRE_STUDENT

MAJOR_DESC

POST_SECONDARY_MAJOR_DESC1

NO

NO

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_MAJOR_SD Short name of the major or subject area. VARCHAR2(255)

ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PRE_STUDENT

MAJOR_DESC

POST_SECONDARY_MAJOR_DESC1

NO

NO

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_SCHOOL Institution previously attended or this institution from cleansing rule. VARCHAR2(63)

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

INSTITUTION

SECONDARY_SCHOOL

LATEST_POST_SECONDARY_SCHOOL

NO

NO

EMPLOYEE DEGREE

EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_SCHOOL_KEY Key for the post secondary dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

POST_SECONDARY_SCHOOL_LD Long name of the institution. VARCHAR2(255)

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

INSTITUTION_DESC

POST_SECONDARY_SCHOOL_DESC_1

LATEST_POST_SECONDARY_DESC

NO

NO

EMPLOYEE DEGREE

EMPLOYMENT APPLICATION

RECRUITING AND ADMISSION

POST_SECONDARY_SCHOOL_SD Short name of the institution. VARCHAR2(255)

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

INSTITUTION_DESC

POST_SECONDARY_SCHOOL_DESC_1

LATEST_POST_SECONDARY_DESC

NO

NO

EMPLOYEE DEGREE

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

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION

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

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, RECRUITING AND ADMISSION



Ver: 3.1