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	ETL GENERATED	NA	NO	NO	ENROLLMENT
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ENROLLMENT
ENROLLMENT_STATUS_KEY	Key for enrollment status 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	AWARD_BY_PERSON	AWARD_PAID_AMOUNT	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 EDW CLEANSING PROCESS	NA NA	NO NO	NO	ENROLLMENT, ENROLLMENT  ENROLLMENT, 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	GPA_CREDITS	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	MAX_CONTACT_HOURS	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: 8.4.3