| 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(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
|