RETURN TO FACT TABLE REPORTS LIST
Graduation Completion Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_GRADUATION_COMPLETION

Description Graduation Completion Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per person per time frame per outcome number (award).

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_STUDY_KEY Key for the academic study dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRADUATION COMPLETION

ACTIVE_ACADEMIC_PERIODS Calculated number of academic periods in that the student enrolled and completed coursework applied toward this graduation record. NUMBER

ENROLLMENT

ACTIVE_ACADEMIC_PERIODS

NO

NO

GRADUATION COMPLETION

AGE Calculated by a function that subtracts the birth date from the load date. NUMBER

PERSON

FUNCTION

NO

NO

GRADUATION COMPLETION

CREDITS_ATTEMPTED Number of credits attempted and used for the academic outcome requirement completion. NUMBER

ACADEMIC_OUTCOME

CREDITS_ATTEMPTED

NO

NO

GRADUATION COMPLETION

CREDITS_EARNED Number of credits earned and used for the academic outcome requirement completion. NUMBER

ACADEMIC_OUTCOME

CREDITS_EARNED

NO

NO

GRADUATION COMPLETION

CREDITS_PASSED Number of credits passed and used for the academic outcome requirement completion. NUMBER

ACADEMIC_OUTCOME

CREDITS_PASSED

NO

NO

GRADUATION COMPLETION

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRADUATION COMPLETION

GPA_CREDITS Number of credits to be used in the GPA calculation for courses used to complete the academic outcome requirements. NUMBER

ACADEMIC_OUTCOME

GPA_CREDITS

NO

NO

GRADUATION COMPLETION

GRADUATION_KEY Key for the graduation dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRADUATION COMPLETION

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRADUATION COMPLETION

OUTCOME_NUMBER Outcome sequence number. NUMBER

ACADEMIC_OUTCOME

OUTCOME_NUMBER

NO

NO

GRADUATION COMPLETION

PERSON_UID System internally generated ID to uniquely identify the person. NUMBER

PERSON

PERSON_UID

NO

NO

GRADUATION COMPLETION

QUALITY_POINTS Number of quality points to be used in the GPA calculation for courses used to complete the academic outcome requirements. NUMBER

ACADEMIC_OUTCOME

QUALITY_POINTS

NO

NO

GRADUATION COMPLETION

STUDENT_KEY Key for the student dimension. NUMBER

ETL GENERATED

NA

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

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRADUATION COMPLETION



Ver: 3.1