Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_PERIOD_FRSTATTEND_KEY	Key for the academic time dimension that identifies the first academic period the person attended the institution at the student level by finding the earliest academic period with a student course that has a source type of history or registration. In Banner this is the minimum academic period with either an SFRSTCR or SHRTCKN record for the person at the student level.	NUMBER	ETL GENERATED	NA	NO	NO	ENROLLMENT
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
DEVELOPMENTAL_COURSE_HEADCOUNT	Number of enrolled students that are registered for one or more developmental education course. This is used to calculate other metrics like the percent of students enrolled who are required to take a developmental course prior to proceeding with courses in their program. This can be used to refine admissions criteria for subsequent years.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_STUDENT_COURSE_ATTRIBUTE AND MST_ENROLLMENT JOIN ON PERSON_UID AND ACADEMIC_PERIOD EXISTS AND COURSE_ATTRIBUTE = MTVPARM EXTRACT PARAMETER [DEV_COURSE_ATTRIBUTE]	NO	NO	ENROLLMENT
ENROLLED_HEADCOUNT	Total number of students, full and part-time, enrolled at the institution. The calculation is the sum of students enrolled in all programs within a given time frame. This metric is used for external reporting and as a basic understanding of how many students are enrolled at the institution.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT.ENROLLED_IND EXISTS	NO	NO	ENROLLMENT
ENROLLMENT_STATUS_KEY	Key for enrollment status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ENROLLMENT
FINAID_APPLICANT_HEADCOUNT	Number of financial aid applicants who receive financial assistance. The calculation is the number of students receiving aid divided by the total number of aid applicants within a given time frame. This metric is used for external reporting and can be used to measure progress against institutional targets.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_FA_PSTU_EXTR.F_GET_FA_PRE_STUDENT: IF MRT_FINAID_APPLICANT_STATUS EXISTS AND FINANCIAL_AID_APPLICATION_IND = 'Y'	NO	NO	ENROLLMENT
FINAID_OFFER_HEADCOUNT	Number of students who are offered financial aid. This number may be used to calculate other metrics like the number of students receiving aid divided by the total number of aid applicants. This metric is used for external reporting and can be used to measure progress against institutional targets.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_FA_PSTU_EXTR.F_GET_FA_PRE_STUDENT:IF MRT_AWARD_BY_PERSON AND AWARD_OFFER_AMOUNT > 0	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	CALCULATION	FUNCTION	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
FULL_TIME_ENROLLED_HEADCOUNT	Number of full-time students enrolled at the institution. The calculation is the sum of students enrolled within a given time frame with a time status equal ot full-time. This metric is used for external reporting and as a basic understanding of how many students are enrolled in full-time study at the institution.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT EXISTS AND CURRENT_TIME_STATUS = MTVPARM EXTRACT PARAMETER [FULL_TIME_COURSE]	NO	NO	ENROLLMENT
INSTITUTION_KEY	Key for the institution dimension.	NUMBER	ETL GENERATED	NA	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
NON_DEGREE_HEADCOUNT	Total number of students enrolled in classes, but not seeking a degree (e.g. University Extension Program and other non-degree granting programs). The calculation is the sum of students who are enrolled in at least one course, but have not been admitted to a degree granting program within a given time frame. This metric provides an understanding of the size and composition of the non-degree seeking population taking classes at the institution.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_GENERAL_STUDENT AND MST_ENROLLMENT EXIST AND JOIN PERSON_UID AND ACADEMIC_PERIOD AND DEGREE = MTVPARM EXTRACT PARAMETER [NON_DEGREE_ATTRIBUTE]	NO	NO	ENROLLMENT
OVERALL_RET_EXCLUDE_HEADCOUNT	Headcount of the students not included in the retained nor the not retained headcounts and rates for a like academic period. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death.	NUMBER	FUNCTION	DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_S	NO	NO	ENROLLMENT
OVERALL_RET_HEADCOUNT	Student enrolled in a fall semesters who register for the sequential spring semester or vice versa. Measure used to calculate the percent of students retained by dividing the number enrolled for one academic period divided by the number of students enrolled for the previous fall academic period. This metric provides an understanding of how many students drop out of school mid-year. When analyzed by class year, program, and other criteria, can help determine potential causes for student attrition.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT JOIN PERSON_UID AND ACADEMIC_PERIOD MST_GENERAL_STUDENT WHEN PRIMARY_PROGRAM_IND = 'Y' AND REGISTERED_IND = 'Y'	NO	NO	ENROLLMENT
PERSON_UID	System internally generated ID to uniquely identify the person.	NUMBER	PERSON	PERSON_UID	NO	NO	ENROLLMENT
POSTAL_KEY	Key for the postal dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ENROLLMENT
STEM_PROGRAM_HEADCOUNT	Number of students enrolled in programs with a major in either science, technology, engineering, or math. The calculation is the number of students with STEM majors divided by the total students within a given time frame. This metric is used for external reporting.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_GENERAL_STUDENT AND MST_ENROLLMENT EXIST JOIN PERSON_UID AND ACADEMIC_PERIOD AND MAJOR = MTVPARM EXTRACT PARAMETER [STEM_PROGRAM_ATTRIBUTE]	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
YEAR2_RETAINED_HEADCOUNT	Headcount of the students registered and retained to year 2.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT JOIN PERSON_UID AND ACADEMIC_PERIOD MST_GENERAL_STUDENT WHEN PRIMARY_PROGRAM_IND = 'Y' AND NO MTVPARM EXTRACT PARAMETER ['EXCLUSION_STATUS_CODE'] FOR YEAR2, ACADEMIC_PERIOD+100	NO	NO	ENROLLMENT
YEAR2_RET_EXCLUDE_HEADCOUNT	Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death.	NUMBER	FUNCTION	DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR2_RET_EXCLUDE_HEADCOUNT	NO	NO	ENROLLMENT
YEAR3_RETAINED_HEADCOUNT	Headcount of the students registered and retained to year 3.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT JOIN PERSON_UID AND ACADEMIC_PERIOD MST_GENERAL_STUDENT WHEN PRIMARY_PROGRAM_IND = 'Y' AND NO MTVPARM EXTRACT PARAMETER ['EXCLUSION_STATUS_CODE'] FOR YEAR3, ACADEMIC_PERIOD+200	NO	NO	ENROLLMENT
YEAR3_RET_EXCLUDE_HEADCOUNT	Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death.	NUMBER	FUNCTION	DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR3_RET_EXCLUDE_HEADCOUNT	NO	NO	ENROLLMENT
YEAR4_GRADUATION_HEADCOUNT	Headcount of the students who graduated within four academic years.	NUMBER	FUNCTION	DECODE(YEAR4_GRADUATION_IND,1,PERSON_IN,NULL) YEAR4_GRADUATION_HEADCOUNT,	NO	NO	ENROLLMENT
YEAR4_GRAD_EXCLUDE_HEADCOUNT	Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status.	NUMBER	FUNCTION	DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR4_GRAD_EXCLUDE_HEADCOUNT,	NO	NO	ENROLLMENT
YEAR4_RETAINED_HEADCOUNT	Headcount of the students registered and retained to year 4.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT JOIN PERSON_UID AND ACADEMIC_PERIOD MST_GENERAL_STUDENT WHEN PRIMARY_PROGRAM_IND = 'Y' AND NO MTVPARM EXTRACT PARAMETER ['EXCLUSION_STATUS_CODE'] FOR YEAR4, ACADEMIC_PERIOD+300	NO	NO	ENROLLMENT
YEAR4_RET_EXCLUDE_HEADCOUNT	Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death.	NUMBER	FUNCTION	DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR4_RET_EXCLUDE_HEADCOUNT	NO	NO	ENROLLMENT
YEAR5_GRADUATION_HEADCOUNT	Headcount of the student graduated within the sixth attended academic year. Headcount is cumulative and includes any graduation at the student level from each year through this year.	NUMBER	FUNCTION	DECODE(YEAR5_GRADUATION_IND,1,PERSON_IN,NULL) YEAR5_GRADUATION_HEADCOUNT,	NO	NO	ENROLLMENT
YEAR5_GRAD_EXCLUDE_HEADCOUNT	Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status.	NUMBER	FUNCTION	DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR5_GRAD_EXCLUDE_HEADCOUNT,	NO	NO	ENROLLMENT
YEAR6_GRADUATION_HEADCOUNT	Headcount of the student graduated within the sixth attended academic year. Headcount is cumulative and includes any graduation at the student level from each year through this year.	NUMBER	FUNCTION	DECODE(YEAR6_GRADUATION_IND,1,PERSON_IN,NULL) YEAR6_GRADUATION_HEADCOUNT,	NO	NO	ENROLLMENT
YEAR6_GRAD_EXCLUDE_HEADCOUNT	Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status.	NUMBER	FUNCTION	DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR6_GRAD_EXCLUDE_HEADCOUNT,	NO	NO	ENROLLMENT

Ver: 9.0