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

SGHE Operational Data Store
Reporting View Target: EMPLOYEE_POSITION

Description Contains assignment details for an employee's current and historical positions.
Key & Frequency One row per person per position per job suffix per effective date.
Recommended Search Columns PERSON_UID,¿POSITION,¿SUFFIX
SALARY_GROUP
PERSON_UID,¿POSITION,¿JOB_SUFFIX,¿EFFECTIVE_DATE
TIMESHEET_ORGANIZATION,¿POSITION,¿JOB_SUFFIX
PAY_CODE,¿POSITION,¿JOB_SUFFIX
POSITION
SUPERVISOR_UID

Target Column Business Definition Database Data Type Source Name Source Column
ABOVE_SALARY_RANGE_IND Above salary range indicator. VARCHAR2(1)

FUNCTION

NOKODSF.F_SALARY_RANGE_IND

ACADEMIC_TITLE Name for the academic staff member title or position at the institution. Examples may include, associate professor, adjunct faculty member, etc. VARCHAR2(255)

PERBFAC

PERBFAC_ACADEMIC_TITLE

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

NA

NA

ANNUALIZED_APPOINTMENT_PCT Effort for this Employee_Position. Used to establish the percentage of full time appointment when calculating Annualized FTE and FTE Base Salary. NUMBER

NBRJFTE

NBRJFTE_APPT_PCT

ANNUALIZED_FTE A calculation of FTE using the position budget basis, position annual basis, and job appointment percent. Represents a calculated FTE value as pro-rated by the length of appointment against the annual value of the job, and factored by the employee's appointment. NUMBER

NBRJFTE

NBRJFTE_ANN_FTE

ANNUALIZED_FTE_BASE_SALARY Calculated full time equivalency salary for an Employee_Position annual basis. Represents the full-time equivalent salary over an annual basis. NUMBER

NBRJFTE

NBRJFTE_BASE_SALARY

ANNUALIZED_FTE_EFFECTIVE_DATE Date that the annualized FTE calculations record becomes effective in the payroll system. DATE

NBRJFTE

NBRJFTE_FTE_EFFECTIVE_DATE

ANNUALIZED_FTE_END_DATE Annualized FTE End date. DATE

FUNCTION

NOKODSF.F_GET_END_NBRJFTE_FTE_DATE

ANNUALIZED_FTE_START_DATE Date that the annualized FTE calculations record becomes effective. DATE

NBRJFTE

NBRJFTE_FTE_EFFECTIVE_DATE

ANNUAL_SALARY Annual salary for the Employee_Position based on the calendar year. NUMBER

NBRJOBS

NBRJOBS_ANN_SALARY

APPOINTMENT_PCT Appointment percent is used to establish the percentage of full time appointment for an employee in a position. The value defaults from the position record, but the user may change at the Employee_Position level. The appointment percent cannot exceed 100. NUMBER

NBRJOBS

NBRJOBS_APPT_PCT

ASSIGNMENT_FACTOR Number of pays per calendar year. NUMBER

NBRJOBS

NBRJOBS_FACTOR

ASSIGNMENT_GRADE Salary grade. VARCHAR2(63)

NBRJOBS

NBRJOBS_SAL_GRADE

ASSIGNMENT_PAY_ID Pay identification number to which this Employee_Position belongs. VARCHAR2(63)

NBRJOBS

NBRJOBS_PICT_CODE

ASSIGNMENT_PAY_ID_DESC Payroll group description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ASSIGNMENT_SALARY_GROUP Salary group to which the table/grade for the position belongs. VARCHAR2(63)

NBRJOBS

NBRJOBS_SGRP_CODE

ASSIGNMENT_SALARY_GROUP_DESC Salary group description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ASSIGNMENT_STEP Salary step within the salary grade for this position. NUMBER

NBRJOBS

NBRJOBS_SAL_STEP

ASSIGNMENT_TABLE Salary table. VARCHAR2(63)

NBRJOBS

NBRJOBS_SAL_TABLE

BELOW_SALARY_RANGE_IND Below salary range indicator. VARCHAR2(1)

FUNCTION

NOKODSF.F_SALARY_RANGE_IND

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

CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRBJOB

NBRBJOB_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of Accounts description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CIVIL_SERVICE_IND Indicates if this Employee Position is a civil service job. VARCHAR2(63)

NBRBJOB

NBRBJOB_CIVIL_SERVICE_IND

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_END_DATE Date on which a contract ends. Significant to the encumbering process. DATE

NBRBJOB

NBRBJOB_CONTRACT_END_DATE

CONTRACT_NUMBER Contract number associated with this Employee Position. VARCHAR2(63)

NBRJOBS

NBRJOBS_CONTRACT_NO

CONTRACT_START_DATE Date on which a contract begins. Significant to the encumbering process. DATE

NBRBJOB

NBRBJOB_CONTRACT_BEGIN_DATE

CONTRACT_TOTAL_HOURS The total number of hours of the contract. This is especially helpful if a contract spans multiple fiscal years. NUMBER

NBRBJOB

NBRBJOB_TOTAL_CONTRACT_HRS

DEFERRED_PAY_AMOUNT Amount deferred each pay period for deferred pay calculation. This field is system calculated (and may not be entered directly). It defaults to zero. NUMBER

NBRJOBS

NBRJOBS_PER_PAY_DEFER_AMT

DEFERRED_PAY_AMOUNT_ADJ Amount of deferred pay accumulated for this Employee_Position. NUMBER

NBRBJOB

NBRBJOB_DEFER_BAL

EFFECTIVE_DATE Date an Employee_Position became effective in the payroll system. DATE

NBRJOBS

NBRJOBS_EFFECTIVE_DATE

EFFECTIVE_END_DATE End effective date. DATE

FUNCTION

NOKODSF.F_GET_END_NBRJOBS_DATE

EFFECTIVE_START_DATE Start effective date. DATE

NBRJOBS

NBRJOBS_EFFECTIVE_DATE

EMPLOYEE_CLASS_TYPE Identifies a type of employee class that is potentially eligible for a shift premium. VARCHAR2(63)

PTRECLS

PTRECLS_SHCD_CODE

EMPLOYEE_CLASS_TYPE_DESC Employee Class type code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMPLOYER_CODE 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_Code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ENCUMBRANCE_AMOUNT Amount of money this person is paid in this position during the current fiscal year. NUMBER

NBRBJOB

NBRBJOB_SALARY_ENCUMBRANCE

ENCUMBRANCE_CHANGE_IND Indicates if the encumbrance amount has changed for this job. VARCHAR2(63)

NBRBJOB

NBRBJOB_ENCUMBRANCE_CHANGE_IND

ENCUMBRANCE_FRINGE_AMOUNT The cost of fringe benefits that this person will be paid in this Employee Position during the current fiscal year. NUMBER

NBRBJOB

NBRBJOB_FRINGE_ENCUMBRANCE

ENCUMBRANCE_HOURS The number of hours used for calculating the encumbrance amount for this Employee Position in the active fiscal year. NUMBER

NBRJOBS

NBRJOBS_ENCUMBRANCE_HRS

ENCUMBRANCE_TOTAL_HOURS The sum of the encumbrance hours for the currently active fiscal year. NUMBER

NBRBJOB

NBRBJOB_TOTAL_ENCUMBRANCE_HRS

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)

FEDERAL_REPORT_IND Indicator identifies employee positions that are reportable for federal government reporting. VARCHAR2(1)

NBRBJOB

NBRBJOB_IPEDS_REPT_IND

FULL_TIME_EQUIVALENCY_PCT Full time equivalency percentage assigned to this Employee_Position. NUMBER

NBRJOBS

NBRJOBS_FTE

HOURLY_RATE Regular hourly rate for this Employee_Position. NUMBER

NBRJOBS

NBRJOBS_REG_RATE

HOURS_PER_DAY The number of hours an employee filling this job normally works in a day. NUMBER

NBRJOBS

NBRJOBS_HRS_DAY

HOURS_PER_PAY The number of hours an employee filling this job normally works in a pay period. NUMBER

NBRJOBS

NBRJOBS_HRS_PAY

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IN_SALARY_RANGE_IND In salary range indicator. VARCHAR2(1)

FUNCTION

NOKODSF.F_SALARY_RANGE_IND

JOB_LEAVE_CATEGORY Job leave category code. This field is used when the Leave by Job Method has been selected for leave processing. VARCHAR2(63)

NBRJOBS

NBRJOBS_LCAT_CODE

JOB_LEAVE_CATEGORY_DESC Description or title for the defined Leave Category. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

LABOR_COST_DISTRIBUTION_COUNT Labor cost distribution count. NUMBER

FUNCTION

MPKFUNC.F_COUNT_LABOR_COST

LEAVE_ACCRUAL_IND Determines whether Leave is accrued for this job. VARCHAR2(63)

NBRBJOB

NBRBJOB_ACCRUE_LEAVE_IND

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 Combination of the person's first, middle initial, and last name into one value. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NEXT_AUTO_STEP_INCREASE Selects the next auto step increase based on the combination of salary table, salary grade, salary group code and salary step. NUMBER

FUNCTION

NOKODSF.F_NEXT_AUTO_STEP

NUMBER_OF_PAYS Number of pays the employee receives in the year. Used for deferred pay calculations. NUMBER

NBRJOBS

NBRJOBS_PAYS

PAY_CODE Pay identification number to which this Employee_Position belongs. VARCHAR2(63)

NBRJOBS

NBRJOBS_PICT_CODE

PAY_DESC Payroll group description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NBRBJOB

NBRBJOB_PIDM

PER_PAY_SALARY Per pay gross salary that the employee is actually paid. NUMBER

NBRJOBS

NBRJOBS_PER_PAY_SALARY

POSITION Position number for this Employee_Position. VARCHAR2(63)

NBRJOBS

NBRJOBS_POSN

POSITION_ASSIGNMENT_PAY Per pay gross salary of the Employee_Position. NUMBER

NBRJOBS

NBRJOBS_ASSGN_SALARY

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

NBRBJOB

NBRBJOB_BEGIN_DATE

POSITION_CHANGE_REASON Employee_Position change reason. Job change reason code associates the reason for the change with the Employee_Position record (future change). VARCHAR2(63)

NBRJOBS

NBRJOBS_JCRE_CODE

POSITION_CHANGE_REASON_DESC Employee_Position change reason description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POSITION_CONTRACT_TYPE Indicates whether this is the Primary, Secondary, or Overload position. 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_CURRENT_IND Indicates whether the position is current based on the current date. VARCHAR2(63)

FUNCTION

MPKFUNC.F_POSITION_CURRENT_IND

POSITION_DEFERRED_PAY Deferred Pay Period Code assigns the employee to be paid on a certain deferred pay schedule. VARCHAR2(63)

NBRJOBS

NBRJOBS_DFPR_CODE

POSITION_DEFERRED_PAY_DESC Deferred Pay Code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NBRJOBS

NBRJOBS_ECLS_CODE

POSITION_EMPLOYEE_CLASS_DESC Employee class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

POSITION_EMPLOYEE_GROUP_DESC Position employee group description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NBRBJOB

NBRBJOB_END_DATE

POSITION_HIGH_SALARY High end of the range for the salary table and grade being defined. NUMBER

NTRSALB

NTRSALB_HIGH

POSITION_LABOR_DIST_COUNT Position labor distribution count. NUMBER

FUNCTION

MPKFUNC.F_COUNT_POSN_LABOR

POSITION_LOCATION Location associated with this Employee Position. VARCHAR2(63)

NBRJOBS

NBRJOBS_JBLN_CODE

POSITION_LOCATION_DESC Description of the location of the Employee Position. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POSITION_LOW_SALARY Low end of the range for the salary table and grade being defined. NUMBER

NTRSALB

NTRSALB_LOW

POSITION_MID_SALARY Midpoint of the salary range being defined. Midpoint is used in the budget roll process for position using the 'sum of the midpoint' method. NUMBER

NTRSALB

NTRSALB_MIDPOINT

POSITION_PERSONNEL_DATE Date the change became effective, regardless of payroll. The personnel change Date is the date this change was actually made; as opposed to the effective date (the date the change became effective in the payroll system). DATE

NBRJOBS

NBRJOBS_PERS_CHG_DATE

POSITION_STATUS Status of the Employee_Position (Active, Terminated, Leave with Benefits, etc.). 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

PREMIUM_PAY_CATEGORY Controls premium pay generation. VARCHAR2(63)

NBRJOBS

NBRJOBS_PCAT_CODE

PREMIUM_PAY_CATEGORY_DESC Description of the premium pay category. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PROBATION_BEGIN_DATE Begin date of probationary period. DATE

NBRBJOB

NBRBJOB_PROBATION_BEGIN_DATE

PROBATION_END_DATE End date of a probationary period. This date is calculated based on the Probationary Period and Probationary Begin Date, but may be overridden. DATE

NBRBJOB

NBRBJOB_PROBATION_END_DATE

PROBATION_UNITS Number of probationary units. NUMBER

NBRBJOB

NBRBJOB_PROBATION_UNITS

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

PUBLIC_RETIREMENT_PAY_RATE Public employee retirement pay rate/frequency code. VARCHAR2(63)

NBRJOBS

NBRJOBS_PERS_PAY_CODE

PUBLIC_RETIRE_PAY_RATE_DESC Public employee retirement pay rate/frequency description. VARCHAR2(255)

CALCULATION

DECODE(NBRJOBS_PERS_PAY_CODE)

SALARY_IND Indicates if the salaries/rates being defined are hourly rates or annual salaries. VARCHAR2(1)

NTRSALB

NTRSALB_IND

SHIFT The normal shift assigned to this job. VARCHAR2(63)

NBRJOBS

NBRJOBS_SHIFT

SHIFT_PREMIUM_AMOUNT The additional amount (above their regular rate) an employee will earn when working this shift number. NUMBER

PTRSHFT

PTRSHFT_AMOUNT

SHIFT_PREMIUM_PERCENT The additional percent (above their regular rate) an employee will earn when working this shift number. NUMBER

PTRSHFT

PTRSHFT_PERCENT

STATE_RETIREMENT_ASSIGNMENT State employee retirement assignment code. VARCHAR2(63)

NBRJOBS

NBRJOBS_STRS_ASSN_CODE

STATE_RETIREMENT_ASSIGN_DESC State employee retirement assignment code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STATE_RETIREMENT_PAY_RATE State employee retirement pay rate/frequency code. VARCHAR2(63)

NBRJOBS

NBRJOBS_STRS_PAY_CODE

STATE_RETIREMENT_PAY_RATE_DESC State employee retirement pay rate/frequency description. VARCHAR2(255)

CALCULATION

DECODE(NBRJOBS_STRS_PAY_CODE)

STEP_INCREASE_DAY Day in which an automatic step increase takes place. The step increase day identifies, to an offline process, the day of the month an automatic step increase is applied. VARCHAR2(2)

NBRBJOB

NBRBJOB_STEP_INCR_DAY

STEP_INCREASE_MONTH Month in which an automatic step increase is to take place. The step increment month identifies, to an offline process, the month of an automatic step increase. VARCHAR2(2)

NBRBJOB

NBRBJOB_STEP_INCR_MON

SUPERVISOR_ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SUPERVISOR_JOB_SUFFIX Suffix associated with the supervisors position. After the Supervisor ID is entered, the suffix defaults to the Primary Position defined for that ID (if one exists). The supervisor's position and suffix must first have been established on this form. The position must be active as of the effective date of the Employee_Position record. 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)

TIMESHEET_CHART_DESC Chart of accounts code description or title. VARCHAR2(255)

FTVCOAS

FTVCOAS_TITLE

TIMESHEET_CHART_OF_ACCOUNTS Timesheet chart of accounts. VARCHAR2(63)

NBRJOBS

NBRJOBS_COAS_CODE_TS

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

NBRJOBS

NBRJOBS_ORGN_CODE_TS

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

FUNCTION

GOKODSF.F_GET_DESC

WORKER_COMPENSATION_CLASS Associates a type of workers' compensation with this Employee Position record. VARCHAR2(63)

NBRJOBS

NBRJOBS_WKCP_CODE

WORKER_COMPENSATION_CLASS_DESC Description of the Workers' Compensation Classification. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 3.1