Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AN_EMPLOYEE_POSITION

Description Source composite view contains data on each position or assignment held by the employee.

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

PERBFAC

PERBFAC_ACADEMIC_TITLE

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

NBRJOBS

NBRJOBS_ACTIVITY_DATE

ANNUAL_SALARY Annual salary for the Employee_Position based on the calendar year. NUMBER(11, 2)

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

NBRJOBS

NBRJOBS_APPT_PCT

ASSIGNMENT_FACTOR Number of pays per calendar year. NUMBER(3, 1)

NBRJOBS

NBRJOBS_FACTOR

ASSIGNMENT_GRADE Salary grade. VARCHAR2(5)

NBRJOBS

NBRJOBS_SAL_GRADE

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

NBRJOBS

NBRJOBS_PICT_CODE

ASSIGNMENT_PAY_ID_DESC Payroll group description or title. VARCHAR2(30)

PTRPICT

PTRPICT_DESC

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

NBRJOBS

NBRJOBS_SGRP_CODE

ASSIGNMENT_SALARY_GROUP_DESC Salary group description. VARCHAR2(30)

NTRSGRP

NTRSGRP_DESC

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

NBRJOBS

NBRJOBS_SAL_STEP

ASSIGNMENT_TABLE Salary table. VARCHAR2(2)

NBRJOBS

NBRJOBS_SAL_TABLE

BELOW_SALARY_RANGE_IND Below salary range indicator. VARCHAR2(1)

FUNCTION

NOKODSF.F_SALARY_RANGE_IND

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

NBRJOBS

NBRJOBS_COAS_CODE_TS

CHART_OF_ACCOUNTS_DESC Chart of Accounts description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

NBRBJOB

NBRBJOB_CIVIL_SERVICE_IND

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

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

NBRBJOB

NBRBJOB_TOTAL_CONTRACT_HRS

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

NA

SYSDATE

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

NBRJOBS

NBRJOBS_PER_PAY_DEFER_AMT

DEFERRED_PAY_AMOUNT_BALANCE Amount of deferred pay accumulated for this Employee_Position. NUMBER(11,2)

NBRBJOB

NBRBJOB_DEFER_BAL

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

PTRECLS

PTRECLS_SHCD_CODE

EMPLOYEE_CLASS_TYPE_DESC Employee Class type code description. VARCHAR2(30)

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

NBRJOBS

NBRJOBS_EMPR_CODE

EMPLOYER_DESC Employer_Code description. VARCHAR2(30)

PTREMPR

PTREMPR_DESC

ENCUMBRANCE_AMOUNT Amount of money this person is paid in this position during the current fiscal year. NUMBER(11, 2)

NBRBJOB

NBRBJOB_SALARY_ENCUMBRANCE

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

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

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

NBRJOBS

NBRJOBS_ENCUMBRANCE_HRS

ENCUMBRANCE_TOTAL_HOURS The sum of the encumbrance hours for the currently active fiscal year. NUMBER(6, 2)

NBRBJOB

NBRBJOB_TOTAL_ENCUMBRANCE_HRS

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_REPORT_IND Indicator identifies employee positions that are reportable for federal government reporting. VARCHAR2(1)

NBRBJOB

NBRBJOB_IPEDS_REPT_IND

FULL_TIME_EQUIVALENCY_PCT The full time equivalency percentage assigned to this Position. NUMBER(6, 3)

NBRJOBS

NBRJOBS_FTE

HOURLY_RATE Regular hourly rate for this Employee_Position. NUMBER(11, 6)

NBRJOBS

NBRJOBS_REG_RATE

HOURS_PER_DAY The number of hours an employee filling this job normally works in a day. NUMBER(6, 2)

NBRJOBS

NBRJOBS_HRS_DAY

HOURS_PER_PAY The number of hours an employee filling this job normally works in a pay period. NUMBER(6, 2)

NBRJOBS

NBRJOBS_HRS_PAY

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

NBRJOBS

NBRJOBS_LCAT_CODE

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

PTVLCAT

PTVLCAT_DESC

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

NBRJOBS

NBRJOBS_SUFF

LAST_PAID_DATE Calculation of the last date in which the employee was paid. DATE

FUNCTION

POKODSF.F_GET_LAST_PAID_DATE

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

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

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

NBRJOBS

NBRJOBS_PICT_CODE_LEAV_REPT

LEAVE_REPORT_PAYROLL_ID_DESC Leave report payroll identifier description. VARCHAR2(30)

PTRPICT

PTRPICT_DESC

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

NBRJOBS

NBRJOBS_LGCD_CODE

LONGEVITY_ELIGIBILITY_DESC Longevity code description. VARCHAR2(30)

PTVLGCD

PTVLGCD_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

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

NBRJOBS

NBRJOBS_PAYS

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

NBRJOBS

NBRJOBS_PICT_CODE

PAY_DESC Payroll group description or title. VARCHAR2(30)

PTRPICT

PTRPICT_DESC

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

NBRBJOB

NBRBJOB_PIDM

PER_PAY_SALARY Per pay gross salary that the employee actually paid. NUMBER(11, 2)

NBRJOBS

NBRJOBS_PER_PAY_SALARY

POSITION Position number for this Employee_Position. VARCHAR2(6)

NBRJOBS

NBRJOBS_POSN

POSITION_ASSIGNMENT_PAY Per pay gross salary of the Employee_Position. NUMBER(11, 2)

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

NBRJOBS

NBRJOBS_JCRE_CODE

POSITION_CHANGE_REASON_DESC Employee_Position change reason description. VARCHAR2(30)

PTRJCRE

PTRJCRE_DESC

POSITION_CONTRACT_TYPE Indicates whether this is the Primary, Secondary, or Overload position. VARCHAR2(1)

NBRBJOB

NBRBJOB_CONTRACT_TYPE

POSITION_CONTRACT_TYPE_DESC Indicates whether this is the (P)rimary, (S)econdary, or (O)verload position. VARCHAR2(30)

CALCULATION

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

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

NBRJOBS

NBRJOBS_DFPR_CODE

POSITION_DEFERRED_PAY_DESC Deferred pay code description. VARCHAR2(30)

PTRDFPR

PTRDFPR_DESC

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

NBRJOBS

NBRJOBS_ECLS_CODE

POSITION_EMPLOYEE_CLASS_DESC Employee class description. VARCHAR2(30)

PTRECLS

PTRECLS_LONG_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_LOCATION Location associated with this Employee Position. VARCHAR2(6)

NBRJOBS

NBRJOBS_JBLN_CODE

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

PTRJBLN

PTRJBLN_DESC

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

NBRJOBS

NBRJOBS_STATUS

POSITION_STATUS_DESC Position Status description. VARCHAR2(40)

CALCULATION

DECODE(NBRJOBS_STATUS)

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

NBRJOBS

NBRJOBS_DESC

PREMIUM_PAY_CATEGORY Controls premium pay generation. VARCHAR2(4)

NBRJOBS

NBRJOBS_PCAT_CODE

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

PTVPCAT

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

NBRBJOB

NBRBJOB_PROBATION_UNITS

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

NBRJOBS

NBRJOBS_PERS_PAY_CODE

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

CALCULATION

DECODE(NBRJOBS_PERS_PAY_CODE)

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

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

NBRJOBS

NBRJOBS_STRS_ASSN_CODE

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

PTVASSN

PTVASSN_DESC

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

NBRJOBS

NBRJOBS_STRS_PAY_CODE

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

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 to be 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_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(2)

NBRJOBS

NBRJOBS_SUPERVISOR_SUFF

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

NBRJOBS

NBRJOBS_SUPERVISOR_POSN

SUPERVISOR_TITLE Title associated with the supervisors position. VARCHAR2(30)

FUNCTION

NOKODSF.F_GET_SUPERVISOR

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

NBRJOBS

NBRJOBS_SUPERVISOR_PIDM

TIMESHEET_CHART_DESC Timesheet Chart of Accounts description. VARCHAR2(35)

FTVCOAS

FTVCOAS_TITLE

TIMESHEET_CHART_OF_ACCOUNTS Time sheet chart of accounts code identifies the chart of accounts to which the time sheet organization for this Employee_Position belongs. VARCHAR2(1)

NBRJOBS

NBRJOBS_COAS_CODE_TS

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

NBRJOBS

NBRJOBS_ORGN_CODE_TS

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

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

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 (PHATIME). VARCHAR2(1)

NBRJOBS

NBRJOBS_TIME_ENTRY_TYPE

TIME_ENTRY_TYPE_DESC Time entry type description. VARCHAR2(30)

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

NBRJOBS

NBRJOBS_USER_ID

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

NBRJOBS

NBRJOBS_WKCP_CODE

WORKER_COMPENSATION_CLASS_DESC Description of the Workers Compensation Classification. VARCHAR2(30)

PTVWKCP

PTVWKCP_DESC

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

NA

NA



Ver: 8.0