RETURN TO DIMENSION TABLE REPORTS LIST
Graduation Completion Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GRADUATION

Description Graduation Dimension table provides information for the person that is specific to a particular completion of award requirements. This information includes campus, cohort and enrolled time status (full time, part time, etc.) at the time of graduation, etc. 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
COHORT Indicates the active student cohort for the student at time of graduation. VARCHAR2(63)

STUDENT_COHORT

COHORT

NO

NO

GRADUATION COMPLETION

COHORT_LD Long description of the admission cohort assigned. VARCHAR2(255)

STUDENT_COHORT

COHORT_DESC

NO

NO

GRADUATION COMPLETION

COHORT_SD Short description of the admission cohort assigned. VARCHAR2(255)

STUDENT_COHORT

COHORT_DESC

NO

NO

GRADUATION COMPLETION

COMPLETION_TIME_STATUS Calculated time status for the student in the last time period for completing an academic outcome requirements. VARCHAR2(63)

ENROLLMENT

CURRENT_TIME_STATUS

NO

NO

GRADUATION COMPLETION

COMPLETION_TIME_STATUS_LD Time status long description at the time of graduation. VARCHAR2(255)

ENROLLMENT

CURRENT_TIME_STATUS_DESC

NO

NO

GRADUATION COMPLETION

COMPLETION_TIME_STATUS_SD Time status short description at the time of graduation. VARCHAR2(255)

ENROLLMENT

CURRENT_TIME_STATUS_DESC

NO

NO

GRADUATION COMPLETION

GRADUATION_CAMPUS Campus code for the academic outcome at time of graduation. VARCHAR2(63)

ACADEMIC_OUTCOME

CAMPUS

NO

NO

GRADUATION COMPLETION

GRADUATION_CAMPUS_LD Long name for the campus. VARCHAR2(255)

ACADEMIC_OUTCOME

CAMPUS_DESC

NO

NO

GRADUATION COMPLETION

GRADUATION_CAMPUS_SD Short name for the campus. VARCHAR2(255)

ACADEMIC_OUTCOME

CAMPUS_DESC

NO

NO

GRADUATION COMPLETION

GRADUATION_KEY Key for the graduation dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRADUATION COMPLETION

INTENDED_TIME_STATUS Indicates the intended time status of full-time or part-time. VARCHAR2(63)

ACADEMIC_STUDY

INTENDED_TIME_STATUS

NO

NO

GRADUATION COMPLETION

INTENDED_TIME_STATUS_LD Intended time status long description that is either Full-time or Part-time. VARCHAR2(255)

ACADEMIC_STUDY

INTENDED_TIME_STATUS

NO

NO

GRADUATION COMPLETION

INTENDED_TIME_STATUS_SD Intended time status short description that is either Full-time or Part-time. VARCHAR2(255)

ACADEMIC_STUDY

INTENDED_TIME_STATUS

NO

NO

GRADUATION COMPLETION

OUTCOME_GRADUATION_DATE Date of the graduation. DATE

ACADEMIC_OUTCOME

OUTCOME_GRADUATION_DATE

NO

NO

GRADUATION COMPLETION

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

ETL GENERATED

NA

NO

NO

GRADUATION COMPLETION

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

ETL GENERATED

NA

NO

NO

GRADUATION COMPLETION



Ver: 3.1