Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner 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

ACTIVITY_DATE Date when the record was inserted or last modified. DATE

PEBEMPL

PEBEMPL_ACTIVITY_DATE

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)

PTRBCAT

PTRBCAT_DESC

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

PEBEMPL

PEBEMPL_CAMP_CODE

CAMPUS_DESC The campus description. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

CHECK_DISTRIBUTION_CHART The chart of accounts code to which the employee's documents, such as checks, are distributed. VARCHAR2(1)

PEBEMPL

PEBEMPL_COAS_CODE_DIST

CHECK_DISTRIBUTION_CHART_DESC Check distribution chart description. VARCHAR2(255)

FUNCTION

PTVORGN

F_GET_FINANCE_DESC

PTVORGN_DESC

CHECK_DIST_ORGANIZATION The organization code used for document distribution. VARCHAR2(63)

PEBEMPL

PEBEMPL_ORGN_CODE_DIST

CHECK_DIST_ORGANIZATION_DESC Check distribution organization description. VARCHAR2(255)

FUNCTION

PTVORGN

F_GET_FINANCE_DESC

PTVORGN_DESC

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

PEBEMPL

PEBEMPL_COLL_CODE

COLLEGE_DESC The college description. VARCHAR2(255)

STVCOLL

STVCOLL_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)

GTVDICD

GTVDICD_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)

PTVESKL

PTVESKL_DESC

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)

PTVESKL

PTVESKL_DESC

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

NBRJOBS

NBRJOBS_EFFECTIVE_DATE

ELECTRONIC_CONSENT_DATE Identifies the most recent date the eectronic consent indicator was updated. DATE

PEBEMPL

PEBEMPL_EW2_CONSENT_DATE

ELECTRONIC_CONSENT_IND Indicates the employee has consented to receive their annual earnins statement (W-2, in the United States) electronically. VARCHAR2(1)

PEBEMPL

PEBEMPL_EW2_CONSENT_IND

ELECTRONIC_CONSENT_USER_ID The unique identification of the user who last updated the electronic consent indicator. VARCHAR2(63)

PEBEMPL

PEBEMPL_EW2_CONSENT_USER_ID

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)

PTRECLS

PTRECLS_LONG_DESC

EMPLOYEE_CLASS_SHORT_DESC Employee class short description. VARCHAR2(255)

PTRECLS

PTRECLS_SHORT_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)

PTVSTGR

PTVSTGR_DESC

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

PTVEGRP

PTVEGRP_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)

PTREMPR

PTREMPR_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)

FAIR_LABOR_STANDARDS_TYPE Indicates the type of fair labor standards overtime compensation to be paid to the employee. VARCHAR2(1)

PEBEMPL

PEBEMPL_FLSA_IND

FAIR_LABOR_STANDARDS_TYPE_DESC Fair labor standards type description. VARCHAR2(255)

CALCULATION

DECODE(PEBEMPL_FLSA_IND)

FEDERAL_SOFT_MONEY_IND Indicates employee is paid in full from soft money. Used for IPEDS reporting in the United States. VARCHAR2(1)

PEBEMPL

PEBEMPL_IPEDS_SOFT_MONEY_IND

FIRST_WORK_DATE The first day that the employee worked. DATE

PEBEMPL

PEBEMPL_FIRST_WORK_DATE

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

HIRING_LOCATION The Location to which the employee belongs. VARCHAR2(63)

PEBEMPL

PEBEMPL_JBLN_CODE

HIRING_LOCATION_DESC Hiring location description. VARCHAR2(255)

PTRJBLN

PTRJBLN_DESC

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

PTVORGN

F_GET_FINANCE_DESC

PTVORGN_DESC

HOME_ORGANIZATION_DESC Home organization code description of the employee VARCHAR2(255)

FUNCTION

PTVORGN

F_GET_FINANCE_DESC

PTVORGN_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

LAST_WORK_DATE The last day that the employee worked. DATE

PEBEMPL

PEBEMPL_LAST_WORK_DATE

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)

PTVLCAT

PTVLCAT_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)

PTRLREA

PTRLREA_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(255)

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

NONRESIDENT_SERVICE_INDUSTRY Primarily used for Canada T4A-NR reporting. Specifically, displays service Industries represented by non-residents which they report to Revenue Canada. VARCHAR2(63)

PEBEMPL

PEBEMPL_NRSI_CODE

NONRESIDENT_SERV_INDUSTRY_DESC Non-resident service industry description. VARCHAR2(255)

PTVNRSI

PTVNRSI_DESC

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

PUBLIC_RETIREMENT_MEMBERSHIP Used primarily as to indicate membership in the California Pension plans (STRS/PERS). VARCHAR2(1)

PEBEMPL

PEBEMPL_CALIF_PENSION_IND

PUBLIC_RETIREMENT_MEMBER_DESC Public retirement membership description. VARCHAR2(255)

CALCULATION

DECODE(PEBEMPL_CALIF_PENSION_IND)

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

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)

PTRTREA

PTRTREA_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

USER_ID The user who last created or updated the employee record. VARCHAR2(63)

PEBEMPL

PEBEMPL_USER_ID

WORK_PERIOD Defines the work period. VARCHAR2(63)

PEBEMPL

PEBEMPL_WKPR_CODE

WORK_PERIOD_DESC Work period description. VARCHAR2(255)

PTRWKPR

PTRWKPR_DESC



Ver: 8.0