Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ABOVE_SALARY_RANGE_IND	Above salary range indicator.	VARCHAR2(1)	FUNCTION	NOKODSF.F_SALARY_RANGE_IND	NO	NO
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	NO	NO
ACTIVITY_DATE	Date of last activity (insert or update) on the record.	DATE	NBRJOBS	NBRJOBS_ACTIVITY_DATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
ANNUALIZED_FTE_EFFECTIVE_DATE	Date that the annualized FTE calculations record becomes effective in the payroll system.	DATE	NBRJFTE	NBRJFTE_FTE_EFFECTIVE_DATE	NO	NO
ANNUALIZED_FTE_END_DATE	Annualized FTE End date.	DATE	FUNCTION	NOKODSF.F_GET_END_NBRJFTE_FTE_DATE	NO	NO
ANNUALIZED_FTE_START_DATE	Date that the annualized FTE calculations record becomes effective.	DATE	NBRJFTE	NBRJFTE_FTE_EFFECTIVE_DATE	NO	NO
ANNUAL_SALARY	Annual salary for the Employee_Position based on the calendar year.	NUMBER	NBRJOBS	NBRJOBS_ANN_SALARY	NO	NO
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	NO	NO
ASSIGNMENT_FACTOR	Number of pays per calendar year.	NUMBER	NBRJOBS	NBRJOBS_FACTOR	NO	NO
ASSIGNMENT_GRADE	Salary grade.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SAL_GRADE	NO	NO
ASSIGNMENT_PAY_ID	Pay identification number to which this Employee_Position belongs.	VARCHAR2(63)	NBRJOBS	NBRJOBS_PICT_CODE	NO	NO
ASSIGNMENT_PAY_ID_DESC	Payroll group description or title.	VARCHAR2(255)	PTRPICT	PTRPICT_DESC	NO	NO
ASSIGNMENT_SALARY_GROUP	Salary group to which the table/grade for the position belongs.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SGRP_CODE	NO	NO
ASSIGNMENT_SALARY_GROUP_DESC	Salary group description.	VARCHAR2(255)	NTRSGRP	NTRSGRP_DESC	NO	NO
ASSIGNMENT_STEP	Salary step within the salary grade for this position.	NUMBER	NBRJOBS	NBRJOBS_SAL_STEP	NO	NO
ASSIGNMENT_TABLE	Salary table.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SAL_TABLE	NO	NO
BELOW_SALARY_RANGE_IND	Below salary range indicator.	VARCHAR2(1)	FUNCTION	NOKODSF.F_SALARY_RANGE_IND	NO	NO
BUDGET_TYPE	Budget type is the expected funding status for the position.	VARCHAR2(63)	NBBPOSN	NBBPOSN_BUDGET_TYPE	NO	NO
BUDGET_TYPE_DESC	Budget type description.	VARCHAR2(255)	FUNCTION	T = TEMPORARY, P = PERMANENT, C = CASUAL AND N = NONE	NO	NO
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	NO	NO
CAMPUS_DESC	The Campus description.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	NBRJOBS	NBRJOBS_COAS_CODE_TS	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of Accounts description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CIVIL_SERVICE_IND	Indicates if this Employee Position is a civil service job.	VARCHAR2(63)	NBRBJOB	NBRBJOB_CIVIL_SERVICE_IND	NO	NO
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	NO	NO
COLLEGE_DESC	The College description.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
CONTRACT_END_DATE	Date on which a contract ends. Significant to the encumbering process.	DATE	NBRBJOB	NBRBJOB_CONTRACT_END_DATE	NO	NO
CONTRACT_NUMBER	Contract number associated with this Employee Position.	VARCHAR2(63)	NBRJOBS	NBRJOBS_CONTRACT_NO	NO	NO
CONTRACT_START_DATE	Date on which a contract begins. Significant to the encumbering process.	DATE	NBRBJOB	NBRBJOB_CONTRACT_BEGIN_DATE	NO	NO
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	NO	NO
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	NO	NO
DEFERRED_PAY_AMOUNT_BALANCE	Amount of deferred pay accumulated for this Employee_Position.	NUMBER	NBRBJOB	NBRBJOB_DEFER_BAL	NO	NO
EFFECTIVE_DATE	Date an Employee_Position became effective in the payroll system.	DATE	NBRJOBS	NBRJOBS_EFFECTIVE_DATE	NO	NO
EFFECTIVE_END_DATE	End effective date.	DATE	FUNCTION	NOKODSF.F_GET_END_NBRJOBS_DATE	NO	NO
EFFECTIVE_START_DATE	Start effective date.	DATE	NBRJOBS	NBRJOBS_EFFECTIVE_DATE	NO	NO
EMPLOYEE_CLASS_TYPE	Identifies a type of employee class that is potentially eligible for a shift premium.	VARCHAR2(63)	PTRECLS	PTRECLS_SHCD_CODE	NO	NO
EMPLOYEE_CLASS_TYPE_DESC	Employee Class type code description.	VARCHAR2(255)	PTVSHCD	PTVSHCD_DESC	NO	NO
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	NO	NO
EMPLOYER_DESC	Employer_Code description.	VARCHAR2(255)	PTREMPR	PTREMPR_DESC	NO	NO
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	NO	NO
EMPLOYMENT_CATEGORY_DESC	Employment category description	VARCHAR2(255)	PTVECIP	PTVECIP_DESC	NO	NO
ENCUMBRANCE_AMOUNT	Amount of money this person is paid in this position during the current fiscal year.	NUMBER	NBRBJOB	NBRBJOB_SALARY_ENCUMBRANCE	NO	NO
ENCUMBRANCE_CHANGE_IND	Indicates if the encumbrance amount has changed for this job.	VARCHAR2(63)	NBRBJOB	NBRBJOB_ENCUMBRANCE_CHANGE_IND	NO	NO
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	NO	NO
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	NO	NO
ENCUMBRANCE_TOTAL_HOURS	The sum of the encumbrance hours for the currently active fiscal year.	NUMBER	NBRBJOB	NBRBJOB_TOTAL_ENCUMBRANCE_HRS	NO	NO
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	NO NO	NO
EXEMPTION_TYPE_DESC	Exemption type description.	VARCHAR2(4000)	CALCULATION	DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)	NO	NO
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	NO	NO
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	NO	NO
FEDERAL_REPORT_IND	Indicator identifies employee positions that are reportable for federal government reporting.	VARCHAR2(1)	NBRBJOB	NBRBJOB_IPEDS_REPT_IND	NO	NO
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	NO	NO
FULL_TIME_EQUIVALENCY_PCT	Full time equivalency percentage assigned to this Employee_Position.	NUMBER	NBRJOBS	NBRJOBS_FTE	NO	NO
HOURLY_RATE	Regular hourly rate for this employee position.	NUMBER	NBRJOBS	NBRJOBS_REG_RATE	NO	NO
HOURS_PER_DAY	The number of hours an employee filling this job normally works in a day.	NUMBER	NBRJOBS	NBRJOBS_HRS_DAY	NO	NO
HOURS_PER_PAY	The number of hours an employee filling this job normally works in a pay period.	NUMBER	NBRJOBS	NBRJOBS_HRS_PAY	NO	NO
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	NO	NO
IN_SALARY_RANGE_IND	In salary range indicator.	VARCHAR2(1)	FUNCTION	NOKODSF.F_SALARY_RANGE_IND	NO	NO
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	NO	NO
JOB_LEAVE_CATEGORY_DESC	Description or title for the defined Leave Category.	VARCHAR2(255)	PTVLCAT	PTVLCAT_DESC	NO	NO
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	NO	NO
LABOR_COST_DISTRIBUTION_COUNT	Labor cost distribution count.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_LABOR_COST	NO	NO
LAST_PAID_DATE	Date on which the employee was last paid that is used in calculations.	DATE	FUNCTION	NOKODSF.F_GET_LAST_PAID_DATE	NO	NO
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(1)	FUNCTION	MPKFUNC.F_POSITION_CURRENT_IND	NO	NO
LEAVE_ACCRUAL_IND	Determines whether Leave is accrued for this job.	VARCHAR2(63)	NBRBJOB	NBRBJOB_ACCRUE_LEAVE_IND	NO	NO
LEAVE_REPORT_ENTRY_METHOD	Leave report method attached to the job.	VARCHAR2(1)	NBRJOBS	NBRJOBS_LEAV_REPT_METHOD	NO	NO
LEAVE_REPORT_ENTRY_METHOD_DESC	Leave Report Entry Method description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
LEAVE_REPORT_PAYROLL_ID_DESC	Leave report payroll identifier description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
LONGEVITY_ELIGIBILITY	Indicates eligibility for additional longevity pay.	VARCHAR2(63)	NBRJOBS	NBRJOBS_LGCD_CODE	NO	NO
LONGEVITY_ELIGIBILITY_DESC	Longevity code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
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	NO	NO
NUMBER_OF_PAYS	Number of pays the employee receives in the year. Used for deferred pay calculations.	NUMBER	NBRJOBS	NBRJOBS_PAYS	NO	NO
PAY_CODE	Pay identification number to which this Employee_Position belongs.	VARCHAR2(63)	NBRJOBS	NBRJOBS_PICT_CODE	NO	NO
PAY_DESC	Payroll group description or title.	VARCHAR2(255)	PTRPICT	PTRPICT_DESC	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NBRBJOB	NBRBJOB_PIDM	NO	NO
PER_PAY_SALARY	Per pay gross salary that the employee is actually paid.	NUMBER	NBRJOBS	NBRJOBS_PER_PAY_SALARY	NO	NO
POSITION	Position number for this Employee_Position.	VARCHAR2(63)	NBRJOBS	NBRJOBS_POSN	NO	NO
POSITION_ASSIGNMENT_PAY	Per pay gross salary of the Employee_Position.	NUMBER	NBRJOBS	NBRJOBS_ASSGN_SALARY	NO	NO
POSITION_BEGIN_DATE	Employee_Position begin date. The date the job assignment started.	DATE	NBRBJOB	NBRBJOB_BEGIN_DATE	NO	NO
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	NO	NO
POSITION_CHANGE_REASON_DESC	Employee_Position change reason description.	VARCHAR2(255)	PTRJCRE	PTRJCRE_DESC	NO	NO
POSITION_CONTRACT_TYPE	Indicates whether this is the Primary, Secondary, or Overload position.	VARCHAR2(63)	NBRBJOB	NBRBJOB_CONTRACT_TYPE	NO	NO
POSITION_CONTRACT_TYPE_DESC	Description for the type of employee contract.	VARCHAR2(255)	CALCULATION	DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')	NO	NO
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	NO	NO
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	NO	NO
POSITION_DEFERRED_PAY_DESC	Deferred Pay Code description.	VARCHAR2(255)	PTRDFPR	PTRDFPR_DESC	NO	NO
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	NO	NO
POSITION_EMPLOYEE_CLASS_DESC	Employee class description.	VARCHAR2(255)	PTRECLS	PTRECLS_LONG_DESC	NO	NO
POSITION_EMPLOYEE_GROUP	Sub-category of the position employee class.	VARCHAR2(63)	PTRECLS	PTRECLS_EGRP_CODE	NO	NO
POSITION_EMPLOYEE_GROUP_DESC	Position employee group description.	VARCHAR2(255)	PTVEGRP	PTVEGRP_DESC	NO	NO
POSITION_END_DATE	Date the Employee_Position is scheduled to end. If left blank, the position is indefinite.	DATE	NBRBJOB	NBRBJOB_END_DATE	NO	NO
POSITION_HIGH_SALARY	High end of the range for the salary table and grade being defined.	NUMBER	NTRSALB	NTRSALB_HIGH	NO	NO
POSITION_LABOR_DIST_COUNT	Position labor distribution count.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_POSN_LABOR	NO	NO
POSITION_LOCATION	Location associated with this Employee Position.	VARCHAR2(63)	NBRJOBS	NBRJOBS_JBLN_CODE	NO	NO
POSITION_LOCATION_DESC	Description of the location of the Employee Position.	VARCHAR2(255)	PTRJBLN	PTRJBLN_DESC	NO	NO
POSITION_LOW_SALARY	Low end of the range for the salary table and grade being defined.	NUMBER	NTRSALB	NTRSALB_LOW	NO	NO
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	NO	NO
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	NO	NO
POSITION_STATUS	Status of the Employee_Position (Active, Terminated, Leave with Benefits, etc.).	VARCHAR2(63)	NBRJOBS	NBRJOBS_STATUS	NO	NO
POSITION_STATUS_DESC	Position status description.	VARCHAR2(255)	CALCULATION	DECODE(NBRJOBS_STATUS)	NO	NO
POSITION_TITLE	Employee_Position description. Defaults from the position title if left blank.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC	NO	NO
PREMIUM_PAY_CATEGORY	Controls premium pay generation.	VARCHAR2(63)	NBRJOBS	NBRJOBS_PCAT_CODE	NO	NO
PREMIUM_PAY_CATEGORY_DESC	Description of the premium pay category.	VARCHAR2(255)	PTVPCAT	PTVPCAT_DESC	NO	NO
PRIMARY_FUNCTION	Position primary function for the government reporting.	VARCHAR2(63)	PEBEMPL	PEBEMPL_IPEDS_PRIMARY_FUNCTION	NO	NO
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	NO	NO
PROBATION_BEGIN_DATE	Begin date of probationary period.	DATE	NBRBJOB	NBRBJOB_PROBATION_BEGIN_DATE	NO	NO
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	NO	NO
PROBATION_UNITS	Number of probationary units.	NUMBER	NBRBJOB	NBRBJOB_PROBATION_UNITS	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROFILE_DATE	Profile Date associated with this record.	DATE	FUNCTION	F_PROFILE_DATE	NO	NO
PUBLIC_RETIREMENT_PAY_RATE	Public employee retirement pay rate/frequency code.	VARCHAR2(63)	NBRJOBS	NBRJOBS_PERS_PAY_CODE	NO	NO
PUBLIC_RETIRE_PAY_RATE_DESC	Public employee retirement pay rate/frequency description.	VARCHAR2(255)	CALCULATION	DECODE(NBRJOBS_PERS_PAY_CODE)	NO	NO
SALARY_IND	Indicates if the salaries/rates being defined are hourly rates or annual salaries.	VARCHAR2(1)	NTRSALB	NTRSALB_IND	NO	NO
SHIFT	The normal shift assigned to this job.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SHIFT	NO	NO
SHIFT_PREMIUM_AMOUNT	The additional amount (above their regular rate) an employee will earn when working this shift number.	NUMBER	PTRSHFT	PTRSHFT_AMOUNT	NO	NO
SHIFT_PREMIUM_PERCENT	The additional percent (above their regular rate) an employee will earn when working this shift number.	NUMBER	PTRSHFT	PTRSHFT_PERCENT	NO	NO
STANDARD_OCCUPATIONAL_CATEGORY	Standard occupational categories defined by the government for federal reporting.	VARCHAR2(63)	NBBPOSN	NBBPOSN_ESOC_CODE	NO	NO
STANDARD_OCCUPATIONAL_CAT_DESC	Occupational category description.	VARCHAR2(255)	PTRESOC	PTRESOC_DESC	NO	NO
STATE_RETIREMENT_ASSIGNMENT	State employee retirement assignment code.	VARCHAR2(63)	NBRJOBS	NBRJOBS_STRS_ASSN_CODE	NO	NO
STATE_RETIREMENT_ASSIGN_DESC	State employee retirement assignment code description.	VARCHAR2(255)	PTVASSN	PTVASSN_DESC	NO	NO
STATE_RETIREMENT_PAY_RATE	State employee retirement pay rate/frequency code.	VARCHAR2(63)	NBRJOBS	NBRJOBS_STRS_PAY_CODE	NO	NO
STATE_RETIREMENT_PAY_RATE_DESC	State employee retirement pay rate/frequency description.	VARCHAR2(255)	CALCULATION	DECODE(NBRJOBS_STRS_PAY_CODE)	NO	NO
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	NO	NO
STEP_INCREASE_ELIGIBLE_DATE	Eligible Date for the step Increase.	DATE	NBRBJOB	NBRBJOB_ELIGIBLE_DATE	NO	NO
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	NO	NO
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	NO	NO
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)	NO	NO
SUPERVISOR_NAME	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SUPERVISOR_POSITION	Position number of the employee's supervisor.	VARCHAR2(63)	CALCULATION	NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)	NO	NO
SUPERVISOR_TITLE	Supervisor's position description.	VARCHAR2(255)	FUNCTION	NOKODSF.F_GET_SUPERVISOR	NO	NO
SUPERVISOR_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	CALCULATION	NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)	NO	NO
TIMESHEET_CHART_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE	NO	NO
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet chart of accounts.	VARCHAR2(63)	NBRJOBS	NBRJOBS_COAS_CODE_TS	NO	NO
TIMESHEET_ORGANIZATION	Organization to which the time sheet for this position is sent.	VARCHAR2(63)	NBRJOBS	NBRJOBS_ORGN_CODE_TS	NO	NO
TIMESHEET_ORGANIZATION_DESC	Organization to which this Employee_Position's time sheet is sent.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TIME_ENTRY_METHOD	Time Entry Method attached to the employee position.	VARCHAR2(1)	NBRJOBS	NBRJOBS_TIME_ENTRY_METHOD	NO	NO
TIME_ENTRY_METHOD_DESC	Time Entry Method description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
TIME_ENTRY_TYPE_DESC	Time Entry Type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	NBRJOBS	NBRJOBS_USER_ID	NO	NO
WORKER_COMPENSATION_CLASS	Associates a type of workers' compensation with this Employee Position record.	VARCHAR2(63)	NBRJOBS	NBRJOBS_WKCP_CODE	NO	NO
WORKER_COMPENSATION_CLASS_DESC	Description of the Workers' Compensation Classification.	VARCHAR2(255)	PTVWKCP	PTVWKCP_DESC	NO	NO

Ver: 9.2