Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ABOVE_SALARY_RANGE_IND	Above Salary Range Indicator	Above salary range indicator.	VARCHAR2(1)	FUNCTION	NOKODSF.F_SALARY_RANGE_IND
ACADEMIC_TITLE	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	Activity Date	Date of last activity (insert or update) on the record.	DATE	NBRJOBS	NBRJOBS_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	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	Annualized Appointment Percent	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	Annualized FTE - Full Time Equated	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	Annualized FTE - Full Time Equated 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	Annualized FTE - Full Time Equated 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 - Full Time Equated End Date	Annualized FTE End date.	DATE	FUNCTION	NOKODSF.F_GET_END_NBRJFTE_FTE_DATE
ANNUALIZED_FTE_START_DATE	Annualized FTE - Full Time Equated Start Date	Date that the annualized FTE calculations record becomes effective.	DATE	NBRJFTE	NBRJFTE_FTE_EFFECTIVE_DATE
ANNUAL_SALARY	Annual Salary	Annual salary for the Employee_Position based on the calendar year.	NUMBER	NBRJOBS	NBRJOBS_ANN_SALARY
APPOINTMENT_PCT	Appointment Percent	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	Assignment Factor	Number of pays per calendar year.	NUMBER	NBRJOBS	NBRJOBS_FACTOR
ASSIGNMENT_GRADE	Assignment Grade	Salary grade.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SAL_GRADE
ASSIGNMENT_PAY_ID	Assignment Pay ID	Pay identification number to which this Employee_Position belongs.	VARCHAR2(63)	NBRJOBS	NBRJOBS_PICT_CODE
ASSIGNMENT_PAY_ID_DESC	Assignment Pay ID Description	Payroll group description or title.	VARCHAR2(255)	PTRPICT	PTRPICT_DESC
ASSIGNMENT_SALARY_GROUP	Assignment Salary Group	Salary group to which the table/grade for the position belongs.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SGRP_CODE
ASSIGNMENT_SALARY_GROUP_DESC	Assignment Salary Group Description	Salary group description.	VARCHAR2(255)	NTRSGRP	NTRSGRP_DESC
ASSIGNMENT_STEP	Assignment Step	Salary step within the salary grade for this position.	NUMBER	NBRJOBS	NBRJOBS_SAL_STEP
ASSIGNMENT_TABLE	Assignment Table	Salary table.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SAL_TABLE
BELOW_SALARY_RANGE_IND	Below Salary Range Indicator	Below salary range indicator.	VARCHAR2(1)	FUNCTION	NOKODSF.F_SALARY_RANGE_IND
BUDGET_TYPE	Budget Type	Budget type is the expected funding status for the position.	VARCHAR2(63)	NBBPOSN	NBBPOSN_BUDGET_TYPE
BUDGET_TYPE_DESC	Budget Type Description	Budget type description.	VARCHAR2(255)	FUNCTION	T = TEMPORARY, P = PERMANENT, C = CASUAL AND N = NONE
CAMPUS	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	Campus Description	The Campus description.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
CHART_OF_ACCOUNTS	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	Chart of Accounts description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CIVIL_SERVICE_IND	Civil Service Indicator	Indicates if this Employee Position is a civil service job.	VARCHAR2(63)	NBRBJOB	NBRBJOB_CIVIL_SERVICE_IND
COLLEGE	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	College Description	The College description.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
CONTRACT_END_DATE	Contract End Date	Date on which a contract ends. Significant to the encumbering process.	DATE	NBRBJOB	NBRBJOB_CONTRACT_END_DATE
CONTRACT_NUMBER	Contract Number	Contract number associated with this Employee Position.	VARCHAR2(63)	NBRJOBS	NBRJOBS_CONTRACT_NO
CONTRACT_START_DATE	Contract Start Date	Date on which a contract begins. Significant to the encumbering process.	DATE	NBRBJOB	NBRBJOB_CONTRACT_BEGIN_DATE
CONTRACT_TOTAL_HOURS	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	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	Defered Pay Amount Balance	Amount of deferred pay accumulated for this Employee_Position.	NUMBER	NBRBJOB	NBRBJOB_DEFER_BAL
EFFECTIVE_DATE	Effective Date	Date an Employee_Position became effective in the payroll system.	DATE	NBRJOBS	NBRJOBS_EFFECTIVE_DATE
EFFECTIVE_END_DATE	Effective End Date	End effective date.	DATE	FUNCTION	NOKODSF.F_GET_END_NBRJOBS_DATE
EFFECTIVE_START_DATE	Effective Start Date	Start effective date.	DATE	NBRJOBS	NBRJOBS_EFFECTIVE_DATE
EMPLOYEE_CLASS_TYPE	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 Description	Employee Class type code description.	VARCHAR2(255)	PTVSHCD	PTVSHCD_DESC
EMPLOYER_CODE	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 Description	Employer_Code description.	VARCHAR2(255)	PTREMPR	PTREMPR_DESC
EMPLOYMENT_CATEGORY	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_ECIP_CODE
EMPLOYMENT_CATEGORY_DESC	Employment Category Description	Employment category description	VARCHAR2(255)	PTVECIP	PTVECIP_DESC
ENCUMBRANCE_AMOUNT	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	Encumbrance Change Indicator	Indicates if the encumbrance amount has changed for this job.	VARCHAR2(63)	NBRBJOB	NBRBJOB_ENCUMBRANCE_CHANGE_IND
ENCUMBRANCE_FRINGE_AMOUNT	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	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	Encumbrance Total Hours	The sum of the encumbrance hours for the currently active fiscal year.	NUMBER	NBRBJOB	NBRBJOB_TOTAL_ENCUMBRANCE_HRS
EXEMPTION_TYPE	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	Exemption type description.	VARCHAR2(4000)	CALCULATION	DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)
FEDERAL_FACULTY_REPORT_IND	Federal Faculty Report Indicator	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	Federal Medical Dental Indicator	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	Federal Report Indicator	Indicator identifies employee positions that are reportable for federal government reporting.	VARCHAR2(1)	NBRBJOB	NBRBJOB_IPEDS_REPT_IND
FEDERAL_SOFT_MONEY_IND	Federal Soft Money Indicator	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 Percent	Full time equivalency percentage assigned to this Employee_Position.	NUMBER	NBRJOBS	NBRJOBS_FTE
HOURLY_RATE	Hourly Rate	Regular hourly rate for this employee position.	NUMBER	NBRJOBS	NBRJOBS_REG_RATE
HOURS_PER_DAY	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	Hours Per Pay	The number of hours an employee filling this job normally works in a pay period.	NUMBER	NBRJOBS	NBRJOBS_HRS_PAY
ID	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	In salary range indicator.	VARCHAR2(1)	FUNCTION	NOKODSF.F_SALARY_RANGE_IND
JOB_LEAVE_CATEGORY	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	Job Leave Category Description	Description or title for the defined Leave Category.	VARCHAR2(255)	PTVLCAT	PTVLCAT_DESC
JOB_SUFFIX	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	Labor cost distribution count.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_LABOR_COST
LAST_PAID_DATE	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	Latest Position Indicator	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(1)	FUNCTION	MPKFUNC.F_POSITION_CURRENT_IND
LEAVE_ACCRUAL_IND	Leave Accrual Indicator	Determines whether Leave is accrued for this job.	VARCHAR2(63)	NBRBJOB	NBRBJOB_ACCRUE_LEAVE_IND
LEAVE_REPORT_ENTRY_METHOD	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	Leave Report Entry Method description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
LEAVE_REPORT_PAYROLL_ID	Leave Report Payroll Identifier	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	Leave report payroll identifier description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
LONGEVITY_ELIGIBILITY	Longevity Eligibility	Indicates eligibility for additional longevity pay.	VARCHAR2(63)	NBRJOBS	NBRJOBS_LGCD_CODE
LONGEVITY_ELIGIBILITY_DESC	Longevity Eligibility Description	Longevity code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	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	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	Number of pays the employee receives in the year. Used for deferred pay calculations.	NUMBER	NBRJOBS	NBRJOBS_PAYS
PAY_CODE	Pay Code	Pay identification number to which this Employee_Position belongs.	VARCHAR2(63)	NBRJOBS	NBRJOBS_PICT_CODE
PAY_DESC	Pay Description	Payroll group description or title.	VARCHAR2(255)	PTRPICT	PTRPICT_DESC
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NBRBJOB	NBRBJOB_PIDM
PER_PAY_SALARY	Period Pay Salary	Per pay gross salary that the employee is actually paid.	NUMBER	NBRJOBS	NBRJOBS_PER_PAY_SALARY
POSITION	Position	Position number for this Employee_Position.	VARCHAR2(63)	NBRJOBS	NBRJOBS_POSN
POSITION_ASSIGNMENT_PAY	Position Assignment Pay	Per pay gross salary of the Employee_Position.	NUMBER	NBRJOBS	NBRJOBS_ASSGN_SALARY
POSITION_BEGIN_DATE	Position Begin Date	Employee_Position begin date. The date the job assignment started.	DATE	NBRBJOB	NBRBJOB_BEGIN_DATE
POSITION_CHANGE_REASON	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	Position Change Reason Description	Employee_Position change reason description.	VARCHAR2(255)	PTRJCRE	PTRJCRE_DESC
POSITION_CONTRACT_TYPE	Position Contract Type	Indicates whether this is the Primary, Secondary, or Overload position.	VARCHAR2(63)	NBRBJOB	NBRBJOB_CONTRACT_TYPE
POSITION_CONTRACT_TYPE_DESC	Position Contract Type Description	Description for the type of employee contract.	VARCHAR2(255)	CALCULATION	DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')
POSITION_CURRENT_IND	Position Current Indicator	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	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	Position Deferred Pay Description	Deferred Pay Code description.	VARCHAR2(255)	PTRDFPR	PTRDFPR_DESC
POSITION_EMPLOYEE_CLASS	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	Position Employee Class Description	Employee class description.	VARCHAR2(255)	PTRECLS	PTRECLS_LONG_DESC
POSITION_EMPLOYEE_GROUP	Position Employee Group	Sub-category of the position employee class.	VARCHAR2(63)	PTRECLS	PTRECLS_EGRP_CODE
POSITION_EMPLOYEE_GROUP_DESC	Position Employee Group	Position employee group description.	VARCHAR2(255)	PTVEGRP	PTVEGRP_DESC
POSITION_END_DATE	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	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 Dist Count	Position labor distribution count.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_POSN_LABOR
POSITION_LOCATION	Position Location	Location associated with this Employee Position.	VARCHAR2(63)	NBRJOBS	NBRJOBS_JBLN_CODE
POSITION_LOCATION_DESC	Position Location Description	Description of the location of the Employee Position.	VARCHAR2(255)	PTRJBLN	PTRJBLN_DESC
POSITION_LOW_SALARY	Position Low Salary	Low end of the range for the salary table and grade being defined.	NUMBER	NTRSALB	NTRSALB_LOW
POSITION_MID_SALARY	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	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	Position Status	Status of the Employee_Position (Active, Terminated, Leave with Benefits, etc.).	VARCHAR2(63)	NBRJOBS	NBRJOBS_STATUS
POSITION_STATUS_DESC	Position Status Description	Position status description.	VARCHAR2(255)	CALCULATION	DECODE(NBRJOBS_STATUS)
POSITION_TITLE	Position Title	Employee_Position description. Defaults from the position title if left blank.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC
PREMIUM_PAY_CATEGORY	Premium Pay Category	Controls premium pay generation.	VARCHAR2(63)	NBRJOBS	NBRJOBS_PCAT_CODE
PREMIUM_PAY_CATEGORY_DESC	Premium Pay Category Description	Description of the premium pay category.	VARCHAR2(255)	PTVPCAT	PTVPCAT_DESC
PRIMARY_FUNCTION	Primary Function	Position primary function for the government reporting.	VARCHAR2(63)	PEBEMPL	PEBEMPL_IPEDS_PRIMARY_FUNCTION
PRIMARY_FUNCTION_DESC	Primary Function Description	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	Probation Begin Date	Begin date of probationary period.	DATE	NBRBJOB	NBRBJOB_PROBATION_BEGIN_DATE
PROBATION_END_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	Probation Units	Number of probationary units.	NUMBER	NBRBJOB	NBRBJOB_PROBATION_UNITS
PROCESS_GROUP	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	Profile Date associated with this record.	DATE	FUNCTION	F_PROFILE_DATE
PUBLIC_RETIREMENT_PAY_RATE	Public Retirement Pay Rate	Public employee retirement pay rate/frequency code.	VARCHAR2(63)	NBRJOBS	NBRJOBS_PERS_PAY_CODE
PUBLIC_RETIRE_PAY_RATE_DESC	Public Retire Pay Rate Description	Public employee retirement pay rate/frequency description.	VARCHAR2(255)	CALCULATION	DECODE(NBRJOBS_PERS_PAY_CODE)
SALARY_IND	Salary Indicator	Indicates if the salaries/rates being defined are hourly rates or annual salaries.	VARCHAR2(1)	NTRSALB	NTRSALB_IND
SHIFT	Shift	The normal shift assigned to this job.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SHIFT
SHIFT_PREMIUM_AMOUNT	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	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 Category	Standard occupational categories defined by the government for federal reporting.	VARCHAR2(63)	NBBPOSN	NBBPOSN_ESOC_CODE
STANDARD_OCCUPATIONAL_CAT_DESC	Standard Occupational Cat Description	Occupational category description.	VARCHAR2(255)	PTRESOC	PTRESOC_DESC
STATE_RETIREMENT_ASSIGNMENT	State Retirement Assignment	State employee retirement assignment code.	VARCHAR2(63)	NBRJOBS	NBRJOBS_STRS_ASSN_CODE
STATE_RETIREMENT_ASSIGN_DESC	State Retirement Assign Description	State employee retirement assignment code description.	VARCHAR2(255)	PTVASSN	PTVASSN_DESC
STATE_RETIREMENT_PAY_RATE	State Retirement Pay Rate	State employee retirement pay rate/frequency code.	VARCHAR2(63)	NBRJOBS	NBRJOBS_STRS_PAY_CODE
STATE_RETIREMENT_PAY_RATE_DESC	State Retirement Pay Rate Description	State employee retirement pay rate/frequency description.	VARCHAR2(255)	CALCULATION	DECODE(NBRJOBS_STRS_PAY_CODE)
STEP_INCREASE_DAY	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	Step Increase Eligible Date	Eligible Date for the step Increase.	DATE	NBRBJOB	NBRBJOB_ELIGIBLE_DATE
STEP_INCREASE_MONTH	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	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	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	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	Supervisor Position	Position number of the employee's supervisor.	VARCHAR2(63)	CALCULATION	NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)
SUPERVISOR_TITLE	Supervisor Title	Supervisor's position description.	VARCHAR2(255)	FUNCTION	NOKODSF.F_GET_SUPERVISOR
SUPERVISOR_UID	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	Timesheet Chart Description	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet Chart Of Accounts	Timesheet chart of accounts.	VARCHAR2(63)	NBRJOBS	NBRJOBS_COAS_CODE_TS
TIMESHEET_ORGANIZATION	Timesheet Organization	Organization to which the time sheet for this position is sent.	VARCHAR2(63)	NBRJOBS	NBRJOBS_ORGN_CODE_TS
TIMESHEET_ORGANIZATION_DESC	Timesheet Organization Description	Organization to which this Employee_Position's time sheet is sent.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TIME_ENTRY_METHOD	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	Time Entry Method description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TIME_ENTRY_TYPE	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	Time Entry Type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TIME_IN_OUT_IND	Time In Out Indicator	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	User Identifier	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	NBRJOBS	NBRJOBS_USER_ID
WORKER_COMPENSATION_CLASS	Worker Compensation Class	Associates a type of workers' compensation with this Employee Position record.	VARCHAR2(63)	NBRJOBS	NBRJOBS_WKCP_CODE
WORKER_COMPENSATION_CLASS_DESC	Worker Compensation Class Description	Description of the Workers' Compensation Classification.	VARCHAR2(255)	PTVWKCP	PTVWKCP_DESC

Ver: 9.2