RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Human Resources Reporting View Reports

SGHE Operational Data Store
Reporting View Target: EMPLOYEE

Description Contains current employee data.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID
HOME_ORGANIZATION_CHART, HOME_ORGANIZATION, PERSON_UID
CURRENT_HIRE_DATE
PERSON_UID, POSITION, JOB_SUFFIX, EFFECTIVE_DATE
POSITION, JOB_SUFFIX
SUPERVISOR_UID

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVE_JOBS_COUNT Count of the number of active jobs for this employee. NUMBER

FUNCTION

MPKFUNC.F_COUNT_ACTIVE_JOBS

ADJUSTED_SERVICE_DATE Date used to determine years of service for leave accrual if the first hire date and current hire date are not equal. DATE

PEBEMPL

PEBEMPL_ADJ_SERVICE_DATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BARGAINING_UNIT_COUNT Count of bargaining units. NUMBER

FUNCTION

MPKFUNC.F_COUNT_BARG_UNIT

BENEFIT_CATEGORY Benefit category to which the employee belongs. VARCHAR2(63)

PEBEMPL

PEBEMPL_BCAT_CODE

BENEFIT_CATEGORY_DESC Benefits category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CAMPUS The Campus to which the employee belongs. VARCHAR2(63)

PEBEMPL

PEBEMPL_CAMP_CODE

CAMPUS_DESC The campus description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE The college to which the employee belongs. VARCHAR2(63)

PEBEMPL

PEBEMPL_COLL_CODE

COLLEGE_DESC The college description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CONTRACT_TYPE Identifies the type of faculty contract assigned to the person. Included may be full time, adjunct or continuing education only, etc. VARCHAR2(63)

NA

NA

CONTRACT_TYPE_DESC Type of faculty contract description. VARCHAR2(255)

NA

NA

CURRENT_HIRE_DATE Employees current date of hire. May differ from original date of hire in cases where an employee is re-hired. DATE

PEBEMPL

PEBEMPL_CURRENT_HIRE_DATE

CURRENT_REVIEW_DATE Date this review type is due for completion. DATE

PERREVW

PERREVW_REVT_DATE

CURRENT_REVIEW_RATING A user defined rating system for completed review types. VARCHAR2(63)

PERREVW

PERREVW_REVT_RATING

CURRENT_REVIEW_TYPE A code identifying the type of review. VARCHAR2(63)

PERREVW

PERREVW_REVT_CODE

CURRENT_REVIEW_TYPE_COMP_IND Code used to identify if this review type has been completed. VARCHAR2(1)

PERREVW

PERREVW_REVT_COMPLETE

CURRENT_REVIEW_TYPE_DESC Review type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DIRECT_REPORT_COUNT Count of the distinct number of people in active positions that are direct reports to this supervisor. NUMBER

FUNCTION

MPKFUNC.F_COUNT_DIRECT_REPORT

DIVISION District or division associated with an employee. VARCHAR2(63)

PEBEMPL

PEBEMPL_DICD_CODE

DIVISION_DESC District or division description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EEO_CATEGORY Used by institutions of higher education for Equal Employment Opportunity reporting as defined by the federal government. VARCHAR2(63)

NA

NA

EEO_CATEGORY_DESC EEO category code description. VARCHAR2(255)

NA

NA

EEO_SKILL Used by institutions of higher education for Equal Employment Opportunity skills reporting as defined by the federal government. VARCHAR2(63)

NTRPCLS

NTRPCLS_ESKL_CODE

EEO_SKILL_DESC EEO skill description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EFFECTIVE_DATE Date an Employee Position became effective in the payroll system. DATE

NBRJOBS

NBRJOBS_EFFECTIVE_DATE

EMPLOYEE_CLASS Employee class code. Organizes position information consistent with employee groupings. At the employee level,used to help determine controls for benefits, leave, payroll and self-service rules. VARCHAR2(63)

PEBEMPL

PEBEMPL_ECLS_CODE

EMPLOYEE_CLASS_LONG_DESC Employee class long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYEE_CLASS_SHORT_DESC Employee class short description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYEE_EARNING_COUNT Employee earning count. NUMBER

FUNCTION

MPKFUNC.F_COUNT_EMPL_EARN

EMPLOYEE_GROUP Sub-category of the employee class. VARCHAR2(63)

PEBEMPL

PEBEMPL_EGRP_CODE

EMPLOYEE_GROUPING Statistics Canada grouping code used for statistics Canada reporting for government installations. VARCHAR2(63)

PEBEMPL

PEBEMPL_STGR_CODE

EMPLOYEE_GROUPING_DESC Statistics Canada grouping description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYEE_GROUP_DESC The description of the employee group. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYEE_STATUS Status of the employee (Active, Termed, etc.). VARCHAR2(1)

PEBEMPL

PEBEMPL_EMPL_STATUS

EMPLOYEE_STATUS_DESC Employee status description. VARCHAR2(255)

CALCULATION

DECODE(PEBEMPL_EMPL_STATUS)

EMPLOYER User-defined code used as part of the Employee_Position definition. It is often used, for example, as a means to identify different campuses within an institution, or different major functional areas. VARCHAR2(63)

NBRJOBS

NBRJOBS_EMPR_CODE

EMPLOYER_DESC Employer description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EXEMPTION_TYPE Indicates if employees assigned to this position class are exempt or non-exempt from federal overtime rules and then indicates if that exemption or non-exemption has been overriden for this specific position. VARCHAR2(2)

NBBPOSN

NTRPCLS

NBBPOSN_EXEMPT_IND

NTRPCLS_EXEMPT_IND

EXEMPTION_TYPE_DESC Exemption Type description. VARCHAR2(67)

CALCULATION

DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)

FOREIGN_INCOME_RECIPIENT_DESC Foreign employee recipient description. VARCHAR2(255)

CALCULATION

DECODE(PEBEMPL_1042_RECIPIENT_CD)

FOREIGN_INCOME_RECIPIENT_TYPE Identifies an employment type for a foreign individual who is receiving employment payments outside their home country. In the US this is a 1042 statement. VARCHAR2(63)

PEBEMPL

PEBEMPL_1042_RECIPIENT_CD

FULL_OR_PART_TIME_IND Internal part time/full time indicator, used for EEO reporting. VARCHAR2(1)

PEBEMPL

PEBEMPL_INTERNAL_FT_PT_IND

HOME_ORGANIZATION Home organization code of the employee. VARCHAR2(63)

PEBEMPL

PEBEMPL_ORGN_CODE_HOME

HOME_ORGANIZATION_CHART Home chart of accounts code for the employee. VARCHAR2(63)

PEBEMPL

PEBEMPL_COAS_CODE_HOME

HOME_ORGANIZATION_CHART_DESC Home organization chart description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

HOME_ORGANIZATION_DESC Organization to which this Employee_Position's time sheet is sent. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IMMIGRATION_DATE Date immigration information was received. For U.S. clients, this is the date the I-9 form was filed. DATE

PEBEMPL

PEBEMPL_I9_DATE

IMMIGRATION_EXPIRATION_DATE Date the immigration information expires. For U.S. clients, this is the date a temporary I-9 form expires. DATE

PEBEMPL

PEBEMPL_I9_EXPIRE_DATE

IMMIGRATION_STATUS Indicates whether immigration information has been received. For U.S. clients, this is the I-9 Form status. VARCHAR2(63)

PEBEMPL

PEBEMPL_I9_FORM_IND

IMMIGRATION_STATUS_DESC I9 status description. VARCHAR2(255)

CALCULATION

DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED,N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT)

JOB_SUFFIX Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another. VARCHAR2(63)

NBRJOBS

NBRJOBS_SUFF

LEAVE_CATEGORY Leave category to which the employee belongs. VARCHAR2(63)

PEBEMPL

PEBEMPL_LCAT_CODE

LEAVE_CATEGORY_DESC Leave category description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

LEAVE_COUNT Count of number of leaves. NUMBER

FUNCTION

MPKFUNC.F_COUNT_LEAVE

LEAVE_OF_ABSENCE_BEGIN_DATE Begin date of a leave of absence for the employee. DATE

PEBEMPL

PEBEMPL_LOA_BEG_DATE

LEAVE_OF_ABSENCE_END_DATE Anticipated end date for an employees leave of absence. DATE

PEBEMPL

PEBEMPL_LOA_END_DATE

LEAVE_OF_ABSENCE_REASON A code identifying the reason of the leave of absence for the employee. VARCHAR2(63)

PEBEMPL

PEBEMPL_LREA_CODE

LEAVE_OF_ABSENCE_REASON_DESC Leave of absence description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NEW_EMPLOYEE_IND Identifies the person as a new employee based on the value in service years. By default, service years that are less than 1.0 are defined as new. However, this default value can be changed in MGRSDAX. VARCHAR2(1)

FUNCTION

MPKFUNC.F_NEW_EMPLOYEE_IND

NONRESIDENT_DAYS_IN_COUNTRY Primarily used for Canada T4A-NR reporting. Specifically, the number of days employee worked in Canada. NUMBER

PEBEMPL

PEBEMPL_DAYS_IN_CANADA

ORIGINAL_HIRE_DATE Date the employee was first hired. DATE

PEBEMPL

PEBEMPL_FIRST_HIRE_DATE

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

PEBEMPL

PEBEMPL_PIDM

POSITION Position. VARCHAR2(63)

NBRJOBS

NBRJOBS_POSN

POSITION_BEGIN_DATE Employee_Position begin date. The date the job assignment started. DATE

NBRBJOB

NBRBJOB_BEGIN_DATE

POSITION_CONTRACT_TYPE Identifies the type of faculty contract assigned to the person. Included may be full time, adjunct or continuing education only, etc. VARCHAR2(63)

NBRBJOB

NBRBJOB_CONTRACT_TYPE

POSITION_CONTRACT_TYPE_DESC Description for the type of employee contract. VARCHAR2(255)

CALCULATION

DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')

POSITION_END_DATE Date the Employee_Position is scheduled to end. If left blank, the position is indefinite. DATE

NBRBJOB

NBRBJOB_END_DATE

POSITION_PERSONNEL_DATE Date the change became effective, regardless of payroll. DATE

NBRJOBS

NBRJOBS_PERS_CHG_DATE

POSITION_STATUS Position status. VARCHAR2(63)

NBRJOBS

NBRJOBS_STATUS

POSITION_STATUS_DESC Position status description. VARCHAR2(255)

CALCULATION

DECODE(NBRJOBS_STATUS)

POSITION_TITLE Employee_Position description. Defaults from the position title if left blank. VARCHAR2(255)

NBRJOBS

NBRJOBS_DESC

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROFILE_DATE Profile Date associated with this record. DATE

FUNCTION

F_PROFILE_DATE

PROFILE_YEAR Profile year. NUMBER

NA

NA

REVIEW_COUNT Count of reviews. NUMBER

FUNCTION

MPKFUNC.F_COUNT_REVIEW

SENIORITY_DATE Institution defined date field. DATE

PEBEMPL

PEBEMPL_SENIORITY_DATE

SERVICE_YEARS Calculates the length of service in years for active employees based on the difference between today's date and the adjusted service date; for terminated employees based on the difference between termination date and adjusted service date. NUMBER

FUNCTION

MPKFUNC.F_SERVICE_YEARS

SUPERVISOR_ID Person's identification number used to access the records associated with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SUPERVISOR_IND Identifies if the person has any direct reports. VARCHAR2(1)

FUNCTION

MPKFUNC.F_CHECK_SUPERVISOR

SUPERVISOR_JOB_SUFFIX Suffix associated with the supervisors position. VARCHAR2(63)

CALCULATION

NVL(NBRJOBS_SUPERVISOR_SUFF, NOKODSF.F_GET_SUPERVISOR)

SUPERVISOR_NAME Combination of the person's first, middle initial, and last name into one value. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SUPERVISOR_POSITION Position number of the employee's supervisor. VARCHAR2(63)

CALCULATION

NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)

SUPERVISOR_TITLE Supervisor's position description. VARCHAR2(255)

FUNCTION

NOKODSF.F_GET_SUPERVISOR

SUPERVISOR_UID System generated, unique, internal identification number assigned to this person. NUMBER

CALCULATION

NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)

TERMINATION_DATE Termination date of the employee. DATE

PEBEMPL

PEBEMPL_TERM_DATE

TERMINATION_REASON Code used to identify the reason of termination. VARCHAR2(63)

PEBEMPL

PEBEMPL_TREA_CODE

TERMINATION_REASON_DESC Termination reason description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TIME_SHEET_CHART Timesheet chart of accounts. VARCHAR2(63)

NBRJOBS

NBRJOBS_COAS_CODE_TS

TIME_SHEET_CHART_DESC Chart of accounts description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TIME_SHEET_ORGANIZATION Organization to which the time sheet for this position is sent. VARCHAR2(63)

NBRJOBS

NBRJOBS_ORGN_CODE_TS

TIME_SHEET_ORGANIZATION_DESC Organization to which this Employee_Position's time sheet is sent. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 3.1