Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ADJUNCT_FACULTY_HEADCOUNT	Number of institution employees that are counted as adjunct faculty employed by the institution in the calendar year. The calculation is the total number of faculty employed in all the terms or academic periods within a calendar year with adjunct or part-time assignments. This metric is used for external reporting and is an indicator of how the institution is tracking against hiring or growth plans.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE AND EMPLOYEE CLASS IS EQUAL TO THE MTVPARM EXTRACT PARAMETER [ADJUNCT_FACULTY_IND]	NO	NO	EMPLOYEE
ADMINISTRATION_KEY	Key for the administration dimension.	NUMBER	ETL GENERATED	NA	NO	NO	EMPLOYEE
AGE	Calculated by a function that subtracts the birth date from the load date.	NUMBER				NO
ANNUAL_SALARY	Annual salary for the position based on the calendar year.	NUMBER	EMPLOYEE_POSITION	ANNUAL_SALARY	NO	NO	EMPLOYEE
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	EMPLOYEE
EMPLOYEE_DEDUCTION_AMOUNT	Employee cost; percentage of gross pay.	NUMBER	MONTHLY_DEDUCTION	EMPLOYEE_CONTRIBUTION_AMOUNT	NO	NO	EMPLOYEE
EMPLOYEE_HEADCOUNT	Number of persons employed by the institution. The calculation is the sum of all active, employees within a calendar year and calendar month. This metric is used for external reporting and can measure performance against targets. Analysis over time can show trends.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE EXISTS AND EMPLOYEE_STATUS = 'A'.	NO	NO	EMPLOYEE
EMPLOYEE_KEY	Key for the employee dimension.	NUMBER	ETL GENERATED	NA	NO	NO	EMPLOYEE
EMPLOYER_DEDUCTION_AMOUNT	Employer cost; flat amount deduction per pay.	NUMBER	MONTHLY_DEDUCTION	EMPLOYER_CONTRIBUTION_AMOUNT	NO	NO	EMPLOYEE
ENCUMBRANCE_AMOUNT	Encumbered amount for the employee in all active positions and jobs.	NUMBER	EMPLOYEE_POSITION	ENCUMBRANCE_AMOUNT	NO	NO	EMPLOYEE
FACULTY_HEADCOUNT	Number of institution employees that are counted as faculty employed by the institution in the calendar year. The calculation is the total number of faculty employed in all academic periods within a calendar year. This metric is used for external reporting and is an indicator of how the institution is tracking against hiring or growth plans.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MST_FACULTY EXISTS	NO	NO	EMPLOYEE
FULL_TIME_EMPLOYEE_HEADCOUNT	Number of full-time faculty employed by the institution. The calculation is the sum of all active, full-time employees within a calendar year and calendar month. This metric is used for external reporting and can measure performance against targets. Analysis over time can show trends.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE WHERE THE FULL_OR_PART_TIME_IND = 'F' AND EMPLOYEE_STATUS = 'A'	NO	NO	EMPLOYEE
FULL_TIME_FACULTY_HEADCOUNT	Number of institution employees that are counted as full-time faculty employed by the institution in the calendar year/calendar month. The calculation is the total number of faculty employed in all the terms or academic periods within the time frame when instructional/non-instructional assignments are combined and the employee time status is set to full-time. This metric is used for external reporting and is an indicator of how the institution is tracking against hiring or growth plans.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MST_FACULTY EXISTS AND MPT_EMPLOYEE.FULL_OR_PART_TIME_IND = 'F" AND JOIN ON PERSON_UID	NO	NO	EMPLOYEE
HOURLY_FTE	FTE or portion of an FTE represented by the employee in all the active positions and jobs, if the job has an hourly salary (otherwise zero).	NUMBER	EMPLOYEE_POSITION	ANNUALIZED_FTE	NO	NO	EMPLOYEE
LEAVE_BENEFITS_AMOUNT	Amount of leave benefits to be paid for this employee for all positions. This is a calculation that uses the remaining leave and the salary information to determine the annual leave amount.	NUMBER	LEAVE_BALANCE	BEGINNING_BALANCE	NO	NO	EMPLOYEE
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	EMPLOYEE
OTHER_EARNINGS	Total other earnings for this employee. This will be all the earnings for the employee on the MPT_EMPLOYEE_EARNING_CY that have an EARNINGS code of Other and all positions. This can be indicated by the EDW cleansing rules that combine groups of codes together for this purpose.	NUMBER	EMPLOYEE_EARNING_CY	FUNCTION	NO	NO	EMPLOYEE
OVERTIME_EARNINGS	Overtime earnings for this employee. This will be the earnings for the employee on the MPT_EMPLOYEE_EARNING_CY that have an EARNINGS code of Overtime. This can be indicated by the EDW cleansing rules that combine groups of codes together for this purpose.	NUMBER	EMPLOYEE_EARNING_CY	FUNCTION	NO	NO	EMPLOYEE
PART_TIME_EMPLOYEE_HEADCOUNT	Number of part-time faculty employed by the institution. The calculation is the sum of all active, part-time employees within a calendar year and calendar month. This metric is used for external reporting and can measure performance against targets. Analysis over time can show trends.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE WHERE THE FULL_OR_PART_TIME_IND = 'P' AND EMPLOYEE_STATUS = 'A'	NO	NO	EMPLOYEE
PART_TIME_FACULTY_HEADCOUNT	Number of institution employees that are counted as part-time faculty employed by the institution in the calendar year/calendar month. The calculation is the total number of faculty employed in all the terms or academic periods within the time frame when instructional/non-instructional assignments are combined and the employee time status is set to part-time. This metric is used for external reporting and is an indicator of how the institution is tracking against hiring or growth plans.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MST_FACULTY EXISTS AND MPT_EMPLOYEE.FULL_OR_PART_TIME_IND = 'P" AND JOIN ON PERSON_UID	NO	NO	EMPLOYEE
PERSON_UID	System internally generated ID to uniquely identify the person.	NUMBER	EMPLOYEE	PERSON_UID	NO	NO	EMPLOYEE
REGULAR_EARNINGS	Total regular for this employee. The employee earnings on the MPT_EMPLOYEE_EARNING_CY that have an EARNINGS code of Regular. This can be indicated by the EDW cleansing rules that combine groups of codes together for this purpose.	NUMBER	EMPLOYEE_EARNING_CY	FUNCTION	NO	NO	EMPLOYEE
SALARIED_FTE	FTE or portion of an FTE represented by the employee in all active positions and jobs, if the job is salaried (otherwise zero.).	NUMBER	EMPLOYEE_POSITION	ANNUALIZED_FTE	NO	NO	EMPLOYEE
STUDENT_EMPLOYEE_HEADCOUNT	Number of students employed by the institution. The calculation is derived as the sum of all active students within the calendar year/calendar month. This metric is used to measure performance against targets. Analysis over time can show trends.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE AND EMPLOYEE CLASS = MTVPARM EXTRACT PARAMETER [STUDENT_EMPLOYEE_IND]	NO	NO	EMPLOYEE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	EMPLOYEE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	EMPLOYEE
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	EMPLOYEE
TOTAL_EARNINGS	Total earnings for this employee. This will be the earnings for the employee on the MPT_EMPLOYEE_EARNING_CY for a particular position when looking at the information on the WFT_EMPLOYEE.	NUMBER	EMPLOYEE_EARNING_CY	FUNCTION	NO	NO	EMPLOYEE
YEARS_OF_SERVICE	Number of years the employee has been in any position with the institution. Need to look at all positions and count the number of years.	NUMBER	EMPLOYEE	FUNCTION	NO	NO	EMPLOYEE
YTD_EMPLOYEE_DEDUCTION_AMOUNT	Year to date employee deduction amount for all positions.	NUMBER	FUNCTION	SUM(EMPLOYEE_CONTRIBUTION_AMOUNT)	NO	NO	EMPLOYEE
YTD_EMPLOYER_DEDUCTION_AMOUNT	Year to date employer deduction contribution for all this employee's deductions for all positions.	NUMBER	FUNCTION	SUM(EMPLOYER_CONTRIBUTION_AMOUNT)	NO	NO	EMPLOYEE
YTD_OTHER_EARNINGS	Year to date total other for this employee in this position and job. This will be the sum of all the earnings for the employee on the EMPLOYEE_EARNING_CY reporting view that have an EARNINGS code of Other. This can be indicated by the EDW cleansing rules that combine groups of codes together for this purpose.	NUMBER	EMPLOYEE_EARNING_CY	TOTAL_EARNINGS_YTD	NO	NO	EMPLOYEE
YTD_OVERTIME_EARNINGS	Year to date total overtime for this employee in this position and job. This will be the sum of all the earnings for the employee on the EMPLOYEE_EARNING_CY reporting view that have an EARNINGS code of Overtime. This can be indicated by the EDW cleansing rules that combine groups of codes together for this purpose.	NUMBER	EMPLOYEE_EARNING_CY	TOTAL_EARNINGS_YTD	NO	NO	EMPLOYEE
YTD_REGULAR_EARNINGS	Year to date total regular for this employee in this position and job. This will be the sum of all the earnings for the employee on the EMPLOYEE_EARNING_CY reporting view that have an EARNINGS code of Regular. This can be indicated by the EDW cleansing rules that combine groups of codes together for this purpose.	NUMBER	EMPLOYEE_EARNING_CY	TOTAL_EARNINGS_YTD	NO	NO	EMPLOYEE
YTD_TOTAL_EARNINGS	Year to date total earnings for this employee. This will be the earnings for the employee on the EMPLOYEE_EARNING_CY reporting view for this particular position.	NUMBER	EMPLOYEE_EARNING_CY	TOTAL_EARNINGS_YTD	NO	NO	EMPLOYEE

Ver: 9.0