Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CURRENT_DATE	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(8)		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: