Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	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	Defered 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	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_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	Last Paid Date	Date on which the employee was last paid that is used in calculations.	DATE		FUNCTION	NOKODSF.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 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(30)		FUNCTION	GOKODSF.F_GET_DESC
LEAVE_REPORT_PAYROLL_ID	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 ID Description	Leave report payroll identifier description.	VARCHAR2(30)		PTRPICT	PTRPICT_DESC
LONGEVITY_ELIGIBILITY	Longevity Eligibility	Indicates eligibility for additional longevity pay.	VARCHAR2(4)		NBRJOBS	NBRJOBS_LGCD_CODE
LONGEVITY_ELIGIBILITY_DESC	Longevity Eligibility Description	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 Retirement Assignment Description	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	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	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(30)		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 (PHATIME).	VARCHAR2(1)		NBRJOBS	NBRJOBS_TIME_ENTRY_TYPE
TIME_ENTRY_TYPE_DESC	Time Entry Type Description	Time entry type description.	VARCHAR2(30)		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 Identification	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: