RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_EMPLOYEE

Description Source composite view contains basic information pertaining to employees. Data includes status, employee class, home organization, leave and benefits categories, etc. The view returns one row per person.

Target Column Business Definition Database Data Type Source Name Source Column
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

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

PEBEMPL

PEBEMPL_BCAT_CODE

BENEFIT_CATEGORY_DESC Benefits category description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CAMPUS The Campus to which the employee belongs. VARCHAR2(3)    
CAMPUS_DESC The Campus description. VARCHAR2(30)    
COLLEGE The College to which the employee belongs. VARCHAR2(2)    
COLLEGE_DESC The College description VARCHAR2(30)    
CONTRACT_TYPE Identifies the type of faculty contract assigned to the person. Included may be full time, adjunct or continuing education only, etc. VARCHAR2(0)

NBRBJOB

NBRBJOB_CONTRACT_TYPE

CONTRACT_TYPE_DESC Type of faculty contract description. VARCHAR2(0)

CALCULATION

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

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

DIVISION District or division associated with an employee. VARCHAR2(3)    
DIVISION_DESC District or division description. VARCHAR2(30)    
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

NTRPCLS

NTRPCLS_ESKL_CODE

EEO_CATEGORY_DESC EEO category code description. VARCHAR2(0)

NA

NA

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

PTVESKL

PTVESKL_CODE

EEO_SKILL_DESC EEO skill description. VARCHAR2(0)

NA

NA

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(2)

PEBEMPL

PEBEMPL_ECLS_CODE

EMPLOYEE_CLASS_LONG_DESC Employee class long description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYEE_CLASS_SHORT_DESC Employee Class short description. VARCHAR2(8)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYEE_GROUP Sub-category of the employee class. VARCHAR2(4)    
EMPLOYEE_GROUPING Statistics Canada grouping code used for statistics Canada reporting for government installations. VARCHAR2(2)

PEBEMPL

PEBEMPL_STGR_CODE

EMPLOYEE_GROUPING_DESC Statistics Canada grouping description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYEE_GROUP_DESC Description of the employee group. VARCHAR2(30)    
EMPLOYEE_STATUS Status of the employee (Active, Termed, etc.). VARCHAR2(1)

PEBEMPL

PEBEMPL_EMPL_STATUS

EMPLOYEE_STATUS_DESC Employee Status description. VARCHAR2(30)

CALCULATION

DECODE(PEBEMPL_EMPL_STATUS)

FOREIGN_INCOME_RECIPIENT_DESC 1042 recipient description. VARCHAR2(35)

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(2)

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(6)

PEBEMPL

PEBEMPL_ORGN_CODE_HOME

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

PEBEMPL

PEBEMPL_COAS_CODE_HOME

HOME_ORGANIZATION_CHART_DESC The home Chart of Accounts Code description for the employee. VARCHAR2(35)    
HOME_ORGANIZATION_DESC Organization to which this Employee_Position's time sheet will be sent. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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(1)

PEBEMPL

PEBEMPL_I9_FORM_IND

IMMIGRATION_STATUS_DESC I9 status description. VARCHAR2(30)

CALCULATION

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

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

PEBEMPL

PEBEMPL_LCAT_CODE

LEAVE_CATEGORY_DESC Description or title for the defined Leave Category. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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(2)

PEBEMPL

PEBEMPL_LREA_CODE

LEAVE_OF_ABSENCE_REASON_DESC Leave of absence description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

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

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(8)

PEBEMPL

PEBEMPL_PIDM

POSITION_EMPLOYEE_GROUP Sub-category of the employee class. VARCHAR2(4)    
POSITION_EMPLOYEE_GROUP_DESC Description of the employee group. VARCHAR2(30)    
PROFILE_DATE Profile Date associated with this record. VARCHAR2(0)

FUNCTION

F_PROFILE_DATE

SENIORITY_DATE Institution defined date field. DATE

PEBEMPL

PEBEMPL_SENIORITY_DATE

TERMINATION_DATE Termination date of the employee. DATE

PEBEMPL

PEBEMPL_TERM_DATE

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

PEBEMPL

PEBEMPL_TREA_CODE

TERMINATION_REASON_DESC Termination reason description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA



Ver: 3.1