Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: EMPLOYEE_POSITION

Description Contains assignment details for an employee's current and historical positions including salary, leave and supervisor details. Selecting person specific data and when not available position control data for the assignment. Note this reporting view will display both active and inactive employee assignments from the Assignment Repeating Table.
Key & Frequency One row per person per position per job suffix per effective date.
Recommended Search Columns PERSON_UID
PERSON_UID, POSITION, JOB_SUFFIX, EFFECTIVE_DATE
TIMESHEET_ORGANIZATION, POSITION, JOB_SUFFIX
PAY_CODE, POSITION, JOB_SUFFIX
POSITION
POSITION_STATUS
ASSIGNMENT_SALARY_GROUP
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

ACTIVITY_DATE Date of last activity (insert or update) on the record. DATE

NBRJOBS

NBRJOBS_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative-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)

PTRPICT

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

NTRSGRP

NTRSGRP_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

BUDGET_TYPE Budget type is the expected funding status for the position. VARCHAR2(63)

NBBPOSN

NBBPOSN_BUDGET_TYPE

BUDGET_TYPE_DESC Budget type description. VARCHAR2(255)

FUNCTION

T = TEMPORARY, P = PERMANENT, C = CASUAL AND N = NONE

CAMPUS Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)

PEBEMPL

PEBEMPL_CAMP_CODE

CAMPUS_DESC The Campus description. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

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

NBRJOBS

NBRJOBS_COAS_CODE_TS

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 First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)

PEBEMPL

PEBEMPL_COLL_CODE

COLLEGE_DESC The College description. VARCHAR2(255)

STVCOLL

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

PTVSHCD

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

PTREMPR

PTREMPR_DESC

EMPLOYMENT_CATEGORY Federal employment reporting categories that identify either the number of month or whether the employment length is full time or part time. VARCHAR2(63)

NBBPOSN

NBBPOSN

NBBPOSN_ECIP_CODE

������NBBPOSN_ECIP_CODE

EMPLOYMENT_CATEGORY_DESC Employment category description VARCHAR2(255)

PTVECIP

������PTVCIP

PTVECIP_DESC

PTVECIP_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 overridden for this specific position. VARCHAR2(2)

NBBPOSN

NTRPCLS

NBBPOSN_EXEMPT_IND

NTRPCLS_EXEMPT_IND

EXEMPTION_TYPE_DESC Exemption type description. VARCHAR2(4000)

CALCULATION

DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)

FEDERAL_FACULTY_REPORT_IND Indicator identifies faculty employee positions that are reportable for federal government reporting. (currently used for Canadian STATSCAN reporting). VARCHAR2(1)

NBRBJOB

NBRBJOB_FACL_STATSCAN_REPT_IND

FEDERAL_MEDICAL_DENTAL_IND Determines where the person is reported for government reporting. Valid values are: Y = report under the Medical/Dental section. N = reported under the Non-medical section. Banner HR default is N. VARCHAR2(1)

PEBEMPL

PEBEMPL_IPEDS_MED_DENTAL_IND

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

NBRBJOB

NBRBJOB_IPEDS_REPT_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

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)

PTVLCAT

PTVLCAT_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

LAST_PAID_DATE Date on which the employee was last paid that is used in calculations. DATE

FUNCTION

NOKODSF.F_GET_LAST_PAID_DATE

LATEST_POSITION_IND Indicates the latest position(s) an employee has where the system date is between the employee's effective start date and employee's effective end date. if the latest position is terminated, then that is determined to be the latest position regardless of the employee's effective end date. VARCHAR2

FUNCTION

MPKFUNC.F_POSITION_CURRENT_IND

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

NBRBJOB

NBRBJOB_ACCRUE_LEAVE_IND

LEAVE_REPORT_ENTRY_METHOD Leave report method attached to the job. VARCHAR2(1)

NBRJOBS

NBRJOBS_LEAV_REPT_METHOD

LEAVE_REPORT_ENTRY_METHOD_DESC Leave Report Entry Method description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

LEAVE_REPORT_PAYROLL_ID Leave report payroll identifier attached to the job and associated with a leave report or leave request. VARCHAR2(63)

NBRJOBS

NBRJOBS_PICT_CODE_LEAV_REPT

LEAVE_REPORT_PAYROLL_ID_DESC Leave report payroll identifier description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

LONGEVITY_ELIGIBILITY Indicates eligibility for additional longevity pay. VARCHAR2(63)

NBRJOBS

NBRJOBS_LGCD_CODE

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

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)

PTRPICT

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

PTRJCRE

PTRJCRE_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 the current active position(s) an employee has that is not terminated where the system date is between the employee's effective start date and employee's effective end date. VARCHAR2(1)

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)

PTRDFPR

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

PTRECLS

PTRECLS_LONG_DESC

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

PTRECLS

PTRECLS_EGRP_CODE

POSITION_EMPLOYEE_GROUP_DESC Position employee group description. VARCHAR2(255)

PTVEGRP

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

PTRJBLN

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

PTVPCAT

PTVPCAT_DESC

PRIMARY_FUNCTION Position primary function for the government reporting. VARCHAR2(63)

PEBEMPL

PEBEMPL_IPEDS_PRIMARY_FUNCTION

PRIMARY_FUNCTION_DESC Primary function description. VARCHAR2(255)

FUNCTION

SELECT SUBSTR(VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PRIMARY_FUNCTION' AND VALUE = A.PRIMARY_FUNCTION

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

STANDARD_OCCUPATIONAL_CATEGORY Standard occupational categories defined by the government for federal reporting. VARCHAR2(63)

NBBPOSN

NBBPOSN

NBBPOSN_ESOC_CODE

������NBBPOSN_ESOC_CODE

STANDARD_OCCUPATIONAL_CAT_DESC Occupational category description. VARCHAR2(255)

PTRESOC

PTRESOC_DESC

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)

PTVASSN

PTVASSN_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_ELIGIBLE_DATE Eligible Date for the step Increase. DATE

NBRBJOB

NBRBJOB_ELIGIBLE_DATE

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

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

TIME_ENTRY_METHOD Time Entry Method attached to the employee position. VARCHAR2(1)

NBRJOBS

NBRJOBS_TIME_ENTRY_METHOD

TIME_ENTRY_METHOD_DESC Time Entry Method description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TIME_ENTRY_TYPE Time Entry Type attached to the job. It represents the structure of how time will be entered over the Web or on the Electronic Approvals of Time Entry Form. VARCHAR2(1)

NBRJOBS

NBRJOBS_TIME_ENTRY_TYPE

TIME_ENTRY_TYPE_DESC Time Entry Type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TIME_IN_OUT_IND Time In/Out Indicator attached to the job. Indicates if this employee must enter time in and out information on the Web or have it entered by a department administrator. Time In and out must be entered for all earn codes that require hours entry. Time in and out will not be entered for earn codes that require units entry. VARCHAR2(1)

NBRJOBS

NBRJOBS_TIME_IN_OUT_IND

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

NBRJOBS

NBRJOBS_USER_ID

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)

PTVWKCP

PTVWKCP_DESC



Ver: 8.5