Target Column	Business Definition	Database Data Type	Source Name	Source Column
CURRENT_DATE	This is the system current date (sysdate).	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
EFFECTIVE_DATE	The Date that the Positions record becomes effective.	DATE	NBRJOBS	NBRJOBS_EFFECTIVE_DATE
JOB_SUFFIX	Position suffix.	VARCHAR2(2)	NBRBJOB	NBRBJOB_SUFF
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA
PERSON_UID	System generated number that is internally generated to uniquely identify the person.	NUMBER	NBRBJOB	NBRBJOB_PIDM
POSITION	The position number this position is attached to.	VARCHAR2(6)	NBRBJOB	NBRBJOB_POSN
POSITION_CONTRACT_TYPE	Indicates whether this is the (P)rimary, (S)econdary, or (O)verload 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_STATUS	The status of the position. Valid values are: A-active, B-leave without pay with benefits, L-leave without pay without benefits, F-leave with full pay and benefits, P-leave with partial pay and benefits, T-terminated.	VARCHAR2(1)	NBRJOBS	NBRJOBS_STATUS
POSITION_STATUS_DESC	Position Status description.	VARCHAR2(40)	CALCULATION	DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C',CANCELLED,'F',FROZEN,'I',INACTIVE)
POSITION_TITLE	Description of the position. Defaults from the Position Title if left blank.	VARCHAR2(30)	NBRJOBS	NBRJOBS_DESC
SUPERVISOR_JOB_SUFFIX	Suffix associated with the supervisors position.	VARCHAR2(2)	CALCULATION	NVL(NBRJOBS_SUPERVISOR_SUFF, NOKODSF.F_GET_SUPERVISOR)
SUPERVISOR_POSITION	The position number of the supervisor.	VARCHAR2(6)	CALCULATION	NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)
SUPERVISOR_TITLE	Title associated with the supervisors position.	VARCHAR2(30)	FUNCTION	NOKODSF.F_GET_SUPERVISOR
SUPERVISOR_UID	Identification number of the supervisor for this position.	NUMBER	CALCULATION	NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: