RETURN TO FACT TABLE REPORTS LIST
Enrollment Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ENROLLMENT

Description Enrollment 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 enrollment academic period.

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

ENROLLMENT

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

PERSON

FUNCTION

NO

NO

ENROLLMENT

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

ENROLLMENT

ENROLLMENT_STATUS_KEY Key for the enrollment dimension. NUMBER

ETL GENERATED

NA

NO

NO

ENROLLMENT

FINANCIAL_AID_AMOUNT Total amount of financial aid calculated by a sum of all the AWARD_PAID_AMOUNT on the MRT_AWARD_BY_PERSON ODS composite table. NUMBER

RECEIVABLE_ACCOUNT_DETAIL

FUNCTION

NO

NO

ENROLLMENT

FTE_DENOMINATOR Denominator used for the calculation of a full time equivalent based. The denominator represents the student normal credit load for the time period. This value will be assigned in the cleansing rules for the EDW. NUMBER

EDW CLEANSING PROCESS

NA

NO

NO

ENROLLMENT

FTE_NUMERATOR Numerator used for the calculation of a full time equivalent based on the number of generated credits for this student and time period. NUMBER

GPA_BY_TERM

CREDITS_ATTEMPTED

NO

NO

ENROLLMENT

INST_ACAD_PER_CREDITS_ATTEMPT Sum credits attempted at the institution in this academic period based on the STUDENT_COURSE details. NUMBER

GPA_BY_TERM

CREDITS_ATTEMPTED

NO

NO

ENROLLMENT

INST_ACAD_PER_CREDITS_EARNED Sum credits earned at the institution in this academic period based on based on the STUDENT_COURSE details. NUMBER

GPA_BY_TERM

CREDITS_EARNED

NO

NO

ENROLLMENT

INST_ACAD_PER_CREDITS_PASSED Sum credits passed, by the definition of the institution, during this academic period based on based on the STUDENT_COURSE details. NUMBER

GPA_BY_TERM

CREDITS_PASSED

NO

NO

ENROLLMENT

INST_ACAD_PER_GPA_CREDITS Sum credits to be used in the calculation of the GPA for this academic period based on based on the STUDENT_COURSE details. NUMBER

GPA_BY_TERM

CREDITS_FOR_GPA

NO

NO

ENROLLMENT

INST_ACAD_PER_QUALITY_POINTS Sum quality points to be used in the calculation of the GPA for this academic period based on based on the STUDENT_COURSE details. NUMBER

GPA_BY_TERM

QUALITY_POINTS

NO

NO

ENROLLMENT

INST_LEVEL_CREDITS_ATTEMPT Total credits attempted based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals institutional. NUMBER

GPA_BY_LEVEL

CREDITS_ATTEMPTED

NO

NO

ENROLLMENT

INST_LEVEL_CREDITS_EARNED Total credits earned based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals institutional. NUMBER

GPA_BY_LEVEL

CREDITS_EARNED

NO

NO

ENROLLMENT

INST_LEVEL_CREDITS_PASSED Total credits passed based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals institutional. NUMBER

GPA_BY_LEVEL

CREDITS_PASSED

NO

NO

ENROLLMENT

INST_LEVEL_GPA_CREDITS Total credits used for the GPA calculation based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals institutional. NUMBER

GPA_BY_LEVEL

GPA_CREDITS

NO

NO

ENROLLMENT

INST_LEVEL_QUALITY_POINTS Total quality points used in the GPA calculation based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals institutional. NUMBER

GPA_BY_LEVEL

QUALITY_POINTS

NO

NO

ENROLLMENT

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

ENROLLMENT

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

PERSON

PERSON_UID

NO

NO

ENROLLMENT

STUDENT_KEY Key for the student dimension. NUMBER

ETL GENERATED

NA

NO

NO

ENROLLMENT

STUDENT_LEVEL_CREDITS_ATTEMPT Total credits attempted based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals overall. NUMBER

GPA_BY_LEVEL

CREDITS_ATTEMPTED

NO

NO

ENROLLMENT

STUDENT_LEVEL_CREDITS_EARNED Total credits earned based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals overall. NUMBER

GPA_BY_LEVEL

CREDITS_EARNED

NO

NO

ENROLLMENT

STUDENT_LEVEL_CREDITS_PASSED Total credits passed based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals overall. NUMBER

GPA_BY_LEVEL

CREDITS_PASSED

NO

NO

ENROLLMENT

STUDENT_LEVEL_GPA_CREDITS Total credits used for the GPA calculation based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals overall. NUMBER

GPA_BY_LEVEL

GPA_CREDITS

NO

NO

ENROLLMENT

STUDENT_LEVEL_QUALITY_POINTS Total quality points used in the GPA calculation based on the based on the GPA_BY_LEVEL ODS reporting view where the GPA_TYPE equals overall. NUMBER

GPA_BY_LEVEL

QUALITY_POINTS

NO

NO

ENROLLMENT

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

ETL GENERATED

NA

NO

NO

ENROLLMENT

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

ETL GENERATED

NA

NO

NO

ENROLLMENT

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

ENROLLMENT

TOTAL_BILLING Total billing units for the enrollment detail information where the student earns Credits. NUMBER

STUDENT

TOTAL_BILLING

NO

NO

ENROLLMENT

TOTAL_CEU Total continuing education units associated with the enrollment detail information. NUMBER

STUDENT

TOTAL_CEU_CREDITS

NO

NO

ENROLLMENT

TOTAL_CEU_BILLING Total billing units for the enrollment detail information where the student earns CEU's instead of Credits. NUMBER

STUDENT

TOTAL_CEU_BILLING

NO

NO

ENROLLMENT

TOTAL_CONTACT_HOURS Total hours of instruction for the enrollment detail information. The number of contact hours and usually workload units assigned to the student and the instructor. NUMBER

SCHEDULE_OFFERING

FUNCTION

NO

NO

ENROLLMENT

TOTAL_CREDITS_GENERATED Total credits associated with the student enrollment detail information. This is calculated by multiplying the section credits by the number of students enrolled. NUMBER

STUDENT

TOTAL_CREDITS

NO

NO

ENROLLMENT

TUITION_CHARGES Total tuition charges associated with the enrollment detail calculated by a sum of all the amounts for detail codes with a category = 'TUI' on the MST_Receivable_Account_Detail ODS composite table. NUMBER

RECEIVABLE_ACCOUNT_DETAIL

FUNCTION

NO

NO

ENROLLMENT



Ver: 3.1