Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ANNUALIZED_APPOINTMENT_PCT	APPOINTMENT PERCENT: The effort for the position.	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	FTE BASE SALARY: The full time equivalency salary for a Position Annual Basis.	NUMBER	NBRJFTE	NBRJFTE_BASE_SALARY	NO	NO
ANNUALIZED_FTE_EFFECTIVE_DATE	FTE EFFECTIVE DATE: The Date that the FTE Calculations record becomes effective.	DATE	NBRJFTE	NBRJFTE_FTE_EFFECTIVE_DATE	NO	NO
ANNUALIZED_FTE_END_DATE	End Date.	DATE	FUNCTION	NOKODSF.F_GET_END_NBRJFTE_FTE_DATE	NO	NO
ANNUALIZED_FTE_START_DATE	Start Date.	DATE	NBRJFTE	NBRJFTE_FTE_EFFECTIVE_DATE	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
JOB_EFFECTIVE_DATE	Date that the Employee_Position record becomes effective in the payroll system.	DATE	NBRJFTE	NBRJFTE_EFFECTIVE_DATE	NO	NO
JOB_END_DATE	Employee position or job end date.	DATE	FUNCTION	NOKODSF.F_GET_END_NBRJFTE_JOB_DATE	NO	NO
JOB_START_DATE	Date that the Employee_Position record becomes effective in the payroll system.	DATE	NBRJFTE	NBRJFTE_EFFECTIVE_DATE	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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NBRJFTE	NBRJFTE_PIDM	NO	NO
POSITION	Position number of the Employee_Position.	VARCHAR2(6)	NBRJFTE	NBRJFTE_POSN	NO	NO
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)	NBRJFTE	NBRJFTE_SUFF	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: