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(80)	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
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(5)	NBRJOBS	NBRJOBS_SAL_GRADE	NO	NO
ASSIGNMENT_PAY_ID	Pay identification number to which this Employee_Position belongs.	VARCHAR2(2)	NBRJOBS	NBRJOBS_PICT_CODE	NO	NO
ASSIGNMENT_PAY_ID_DESC	Payroll group description or title.	VARCHAR2(30)	PTRPICT	PTRPICT_DESC	NO	NO
ASSIGNMENT_SALARY_GROUP	Salary group to which the table/grade for the position belongs.	VARCHAR2(6)	NBRJOBS	NBRJOBS_SGRP_CODE	NO	NO
ASSIGNMENT_SALARY_GROUP_DESC	Salary group description.	VARCHAR2(30)	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(2)	NBRJOBS	NBRJOBS_SAL_TABLE	NO	NO
BELOW_SALARY_RANGE_IND	Below salary range indicator.	VARCHAR2(1)	FUNCTION	NOKODSF.F_SALARY_RANGE_IND	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	NBRJOBS	NBRJOBS_COAS_CODE_TS	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of Accounts description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CIVIL_SERVICE_IND	Indicates if this Employee Position is a civil service job.	VARCHAR2(1)	NBRBJOB	NBRBJOB_CIVIL_SERVICE_IND	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(8)	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
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	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
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	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(4)	PTRECLS	PTRECLS_SHCD_CODE	NO	NO
EMPLOYEE_CLASS_TYPE_DESC	Employee Class type code description.	VARCHAR2(30)	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(4)	NBRJOBS	NBRJOBS_EMPR_CODE	NO	NO
EMPLOYER_DESC	Employer_Code description.	VARCHAR2(30)	PTREMPR	PTREMPR_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(1)	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
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_REPORT_IND	Indicator identifies employee positions that are reportable for federal government reporting.	VARCHAR2(1)	NBRBJOB	NBRBJOB_IPEDS_REPT_IND	NO	NO
FULL_TIME_EQUIVALENCY_PCT	The full time equivalency percentage assigned to this 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
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(2)	NBRJOBS	NBRJOBS_LCAT_CODE	NO	NO
JOB_LEAVE_CATEGORY_DESC	Description or title for the defined Leave Category.	VARCHAR2(30)	PTVLCAT	PTVLCAT_DESC	NO	NO
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	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
LEAVE_ACCRUAL_IND	Determines whether Leave is accrued for this job.	VARCHAR2(1)	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(30)	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(2)	NBRJOBS	NBRJOBS_PICT_CODE_LEAV_REPT	NO	NO
LEAVE_REPORT_PAYROLL_ID_DESC	Leave report payroll identifier description.	VARCHAR2(30)	PTRPICT	PTRPICT_DESC	NO	NO
LONGEVITY_ELIGIBILITY	Indicates eligibility for additional longevity pay.	VARCHAR2(4)	NBRJOBS	NBRJOBS_LGCD_CODE	NO	NO
LONGEVITY_ELIGIBILITY_DESC	Longevity code description.	VARCHAR2(30)	PTVLGCD	PTVLGCD_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	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(2)	NBRJOBS	NBRJOBS_PICT_CODE	NO	NO
PAY_DESC	Payroll group description or title.	VARCHAR2(30)	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 actually paid.	NUMBER	NBRJOBS	NBRJOBS_PER_PAY_SALARY	NO	NO
POSITION	Position number for this Employee_Position.	VARCHAR2(6)	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(5)	NBRJOBS	NBRJOBS_JCRE_CODE	NO	NO
POSITION_CHANGE_REASON_DESC	Employee_Position change reason description.	VARCHAR2(30)	PTRJCRE	PTRJCRE_DESC	NO	NO
POSITION_CONTRACT_TYPE	Indicates whether this is the Primary, Secondary, or Overload position.	VARCHAR2(1)	NBRBJOB	NBRBJOB_CONTRACT_TYPE	NO	NO
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')	NO	NO
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	NO	NO
POSITION_DEFERRED_PAY_DESC	Deferred pay code description.	VARCHAR2(30)	PTRDFPR	PTRDFPR_DESC	NO	NO
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	NO	NO
POSITION_EMPLOYEE_CLASS_DESC	Employee class description.	VARCHAR2(30)	PTRECLS	PTRECLS_LONG_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_LOCATION	Location associated with this Employee Position.	VARCHAR2(6)	NBRJOBS	NBRJOBS_JBLN_CODE	NO	NO
POSITION_LOCATION_DESC	Description of the location of the Employee Position.	VARCHAR2(30)	PTRJBLN	PTRJBLN_DESC	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(1)	NBRJOBS	NBRJOBS_STATUS	NO	NO
POSITION_STATUS_DESC	Position Status description.	VARCHAR2(40)	CALCULATION	DECODE(NBRJOBS_STATUS)	NO	NO
POSITION_TITLE	Employee_Position description. Defaults from the position title if left blank.	VARCHAR2(30)	NBRJOBS	NBRJOBS_DESC	NO	NO
PREMIUM_PAY_CATEGORY	Controls premium pay generation.	VARCHAR2(4)	NBRJOBS	NBRJOBS_PCAT_CODE	NO	NO
PREMIUM_PAY_CATEGORY_DESC	Description of the premium pay category.	VARCHAR2(30)	PTVPCAT	PTVPCAT_DESC	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
PUBLIC_RETIREMENT_PAY_RATE	Public employee retirement pay rate/frequency code.	VARCHAR2(2)	NBRJOBS	NBRJOBS_PERS_PAY_CODE	NO	NO
PUBLIC_RETIRE_PAY_RATE_DESC	Public employee retirement pay rate/frequency description.	VARCHAR2(30)	CALCULATION	DECODE(NBRJOBS_PERS_PAY_CODE)	NO	NO
SHIFT	The normal shift assigned to this job.	VARCHAR2(1)	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
STATE_RETIREMENT_ASSIGNMENT	State employee retirement assignment code.	VARCHAR2(2)	NBRJOBS	NBRJOBS_STRS_ASSN_CODE	NO	NO
STATE_RETIREMENT_ASSIGN_DESC	State employee retirement assignment code description.	VARCHAR2(60)	PTVASSN	PTVASSN_DESC	NO	NO
STATE_RETIREMENT_PAY_RATE	State employee retirement pay rate/frequency code.	VARCHAR2(2)	NBRJOBS	NBRJOBS_STRS_PAY_CODE	NO	NO
STATE_RETIREMENT_PAY_RATE_DESC	State employee retirement pay rate/frequency description.	VARCHAR2(30)	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 to be 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_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	NO	NO
SUPERVISOR_POSITION	Position number of the employee's supervisor.	VARCHAR2(6)	NBRJOBS	NBRJOBS_SUPERVISOR_POSN	NO	NO
SUPERVISOR_TITLE	Title associated with the supervisors position.	VARCHAR2(30)	FUNCTION	NOKODSF.F_GET_SUPERVISOR	NO	NO
SUPERVISOR_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NBRJOBS	NBRJOBS_SUPERVISOR_PIDM	NO	NO
TIMESHEET_CHART_DESC	Timesheet Chart of Accounts description.	VARCHAR2(35)	FTVCOAS	FTVCOAS_TITLE	NO	NO
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	NO	NO
TIMESHEET_ORGANIZATION	Organization to which the time sheet for this position is sent.	VARCHAR2(6)	NBRJOBS	NBRJOBS_ORGN_CODE_TS	NO	NO
TIMESHEET_ORGANIZATION_DESC	Organization to which this Employee_Position's time sheet is sent.	VARCHAR2(35)	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(30)	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 (PHATIME).	VARCHAR2(1)	NBRJOBS	NBRJOBS_TIME_ENTRY_TYPE	NO	NO
TIME_ENTRY_TYPE_DESC	Time entry type description.	VARCHAR2(30)	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(30)	NBRJOBS	NBRJOBS_USER_ID	NO	NO
WORKER_COMPENSATION_CLASS	Associates a type of workers compensation with this Employee Position record.	VARCHAR2(4)	NBRJOBS	NBRJOBS_WKCP_CODE	NO	NO
WORKER_COMPENSATION_CLASS_DESC	Description of the Workers Compensation Classification.	VARCHAR2(30)	PTVWKCP	PTVWKCP_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: