RETURN TO FACT TABLE REPORTS LIST
Course Registration Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_COURSE_REGISTRATION

Description Course Registration 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 course reference number for the schedule offering.

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

COURSE REGISTRATION

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

PERSON

FUNCTION

NO

NO

COURSE REGISTRATION

COURSE_KEY Key for the course dimension NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

COURSE_REFERENCE_NUMBER System internally generated ID to uniquely identify the schedule offering. VARCHAR2(63)

STUDENT_COURSE

COURSE_REFERENCE_NUMBER

NO

NO

COURSE REGISTRATION

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

STUDENT_COURSE

CREDITS_ATTEMPTED

NO

NO

COURSE REGISTRATION

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

STUDENT_COURSE

CREDITS_EARNED

NO

NO

COURSE REGISTRATION

CREDITS_GENERATED Sum credits assigned to the course based on the STUDENT_COURSE details. When totaled for all students it will be the number of credits generated for a time frame by attributes. NUMBER

STUDENT_COURSE

COURSE_CREDITS

NO

NO

COURSE REGISTRATION

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

STUDENT_COURSE

CREDITS_PASSED

NO

NO

COURSE REGISTRATION

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

ENROLLMENT_STATUS_KEY Key for the enrollment dimension. NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

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

STUDENT_COURSE

CREDITS_FOR_GPA

NO

NO

COURSE REGISTRATION

INSTRUCTOR_KEY Key for the instructor dimension NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

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

PERSON

PERSON_UID

NO

NO

COURSE REGISTRATION

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

STUDENT_COURSE

QUALITY_POINTS

NO

NO

COURSE REGISTRATION

REGISTRATION_KEY Key for the registration dimension. NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

STUDENT_KEY Key for the student dimension. NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

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

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

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

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

COURSE REGISTRATION



Ver: 3.1