RETURN TO DIMENSION TABLE REPORTS LIST
Employee Star Employee Degree Star Employee Position Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_EMPLOYEE

Description Employee Dimension table provides information for the person that is an employee of the institution. This will include all employees who do not have an n Employee Status = 'T' (Terminated). This information includes employee class, employee EEO Skill, Tenure and whether or not they have an active employee position. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
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_KEY Key for the employee dimension. NUMBER

ETL GENERATED

NA

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

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. Alternatively, we could use d the Seniority Date on the EMPLOYEE? 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: 3.1