Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_POSITION_IND	Identifies the employees who have an active position assignment for the time frame.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
ANNUAL_SALARY_RANGE	Calculated based on the ANNUAL_SALARY on the EMPLOYEE_POSITION record.	VARCHAR2(63)	EDW CLEANSING PROCESS	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
ANNUAL_SALARY_RANGE_LD	Long description for the salary range defined in cleansing.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
ANNUAL_SALARY_RANGE_SD	Short description for the salary range defined in cleansing.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_CLASS	Grouping or classification of employees.	VARCHAR2(63)	EMPLOYEE	EMPLOYEE_CLASS	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_CLASS_LD	Long description for the employee class.	VARCHAR2(255)	EMPLOYEE	EMPLOYEE_CLASS_LONG_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_CLASS_SD	Short description for the employee class.	VARCHAR2(255)	EMPLOYEE	EMPLOYEE_CLASS_SHORT_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_EEO_SKILL	EEO skill code as defined for government reporting.	VARCHAR2(63)	EMPLOYEE	EEO_SKILL	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_EEO_SKILL_LD	Long description of the EEO skill.	VARCHAR2(255)	EMPLOYEE	EEO_SKILL_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_EEO_SKILL_SD	Short description of the EEO skill.	VARCHAR2(255)	EMPLOYEE	EEO_SKILL_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_GROUPING	Governmental codes for grouping faculty member for reporting. For example Statistics Canada Group codes.	VARCHAR2(63)	EMPLOYEE	EMPLOYEE_GROUPING	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_GROUPING_LD	Long description for the employee groupings.	VARCHAR2(255)	EMPLOYEE	EMPLOYEE_GROUPING_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_GROUPING_SD	Short description for the employee groupings.	VARCHAR2(255)	EMPLOYEE	EMPLOYEE_GROUPING_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_STATUS	Current status of the employee. Usually designated if the employee is active on payroll or not.	VARCHAR2(63)	EMPLOYEE	EMPLOYEE_STATUS	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_STATUS_LD	Long description for the employee status.	VARCHAR2(255)	EMPLOYEE	EMPLOYEE_STATUS_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_STATUS_SD	Short description for the employee status.	VARCHAR2(255)	EMPLOYEE	EMPLOYEE_STATUS_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_TIME_STATUS	Full time/part time status for the employee.	VARCHAR2(63)	EMPLOYEE	FULL_OR_PART_TIME_IND	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_TIME_STATUS_LD	Long description full time/part time indicator.	VARCHAR2(255)	EMPLOYEE	FULL_OR_PART_TIME_IND	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
EMPLOYEE_TIME_STATUS_SD	Short description full time/part time indicator.	VARCHAR2(255)	EMPLOYEE	FULL_OR_PART_TIME_IND	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
FACULTY_MEMBER_CATEGORY	Faculty member category is a way to group faculty positions together. Examples might be Full professor, Adjunct professor, Associate professor, etc..	VARCHAR2(63)	FACULTY	FACULTY_MEMBER_CATEGORY	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
FACULTY_MEMBER_CATEGORY_LD	Long descriptive name for the faculty member category.	VARCHAR2(255)	FACULTY	FACULTY_MEMBER_CATEGORY_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
FACULTY_MEMBER_CATEGORY_SD	Short descriptive name for the faculty member category.	VARCHAR2(255)	FACULTY	FACULTY_MEMBER_CATEGORY_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
FACULTY_STAFF_IND	Indicates if the employee is considered a faculty staff member. Determined if the FACULTY reporting view exists for the time extracted.	VARCHAR2(63)	EMPLOYEE	FUNCTION	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
SALARY_GRADE	Salary grade is a combination of salary group (which associates a set of salary tables and grades), salary table values and the salary grade values based on the institution's definition.	VARCHAR2(63)	CALCULATION	SALARY_GROUP||SALARY_TABLE||SALARY_GRADE	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
SALARY_GRADE_LD	Long description for the salary grade, salary table and the salary grade value. This may be updated by the institution using cleansing rules to present a meaningful reporting value.	VARCHAR2(255)	CALCULATION	SALARY_GROUP||SALARY_TABLE||SALARY_GRADE	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
SALARY_GRADE_SD	Short description for the salary grade, salary table and the salary grade value. This may be updated by the institution using cleansing rules to present a meaningful reporting value.	VARCHAR2(255)	CALCULATION	SALARY_GROUP||SALARY_TABLE||SALARY_GRADE	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
TENURE	Specifies the member of academic faculty's current tenure status.	VARCHAR2(63)	FACULTY	TENURE	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
TENURE_LD	Short description of the faculty's tenure code.	VARCHAR2(255)	FACULTY	TENURE_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
TENURE_SD	Long description of the faculty's tenure code.	VARCHAR2(255)	FACULTY	TENURE_DESC	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
YEARS_OF_SERVICE_RANGE	Calculated by using the CURRENT_HIRE_DATE or the ADJUSTED_SERVICE_DATE from the EMPLOYEE record. Placed in the appropriate range per EDW cleansing rules.	VARCHAR2(63)	EDW CLEANSING PROCESS	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
YEARS_OF_SERVICE_RANGE_LD	Long description for the range of years the employee has been employed.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION
YEARS_OF_SERVICE_RANGE_SD	Short description for the range of years the employee has been employed.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION

Ver: 9.0