Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
CURRENT_DATE
|
|
DATE
|
|
|
DOMAIN_VALUE
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
EARNINGS
|
Identifies the transaction approval default earnings code.
|
VARCHAR2(3)
|
NORTERN
|
NORTERN_EARN_CODE
|
EARNINGS_DESC
|
Earnings code long description.
|
VARCHAR2(30)
|
PTREARN
|
PTREARN_LONG_DESC
|
EARNINGS_END_DATE
|
Date on which this earnings code is canceled, ended or no longer applied to this position and job suffix for the person.
|
DATE
|
NORTERN
|
NORTERN_CANCEL_DATE
|
EARNINGS_HOURS
|
|
NUMBER
|
|
|
FEDERAL_EMPLOYMENT_HOURS
|
Hours for federal employment reporting. Used to report hours for Canadian Employment Insurance.
|
NUMBER
|
NORTERN
|
NORTERN_DEEMED_HRS
|
JOB_SUFFIX
|
Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another.
|
VARCHAR2(2)
|
NORTERN
|
NORTERN_SUFF
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
MIF_VALUE
|
|
VARCHAR2(6)
|
|
|
PAF_APPLY_STATUS
|
Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled.
|
VARCHAR2(1)
|
NORTERN
|
NORTERN_APPLY_STATUS_IND
|
PAF_APPROVAL_TYPE
|
Approval type defaulted for the sequence number per approval category rules. Rule include one record for each basic type of action defined for the approval category, such as establishing a new job assignment or terminating an existing job assignment.
|
VARCHAR2(6)
|
NORTERN
|
NORTERN_APTY_CODE
|
PAF_APPROVAL_TYPE_DESC
|
Approval type description.
|
VARCHAR2(30)
|
NTVAPTY
|
NTVAPTY_DESC
|
PAF_EARNING_ACTIVITY_DATE
|
Date of last activity on this record.
|
DATE
|
NORTERN
|
NORTERN_ACTIVITY_DATE
|
PAF_EFFECTIVE_DATE
|
Date the personnel action record became effective.
|
DATE
|
NORTERN
|
NORTERN_EFFECTIVE_DATE
|
PAF_TRANSACTION_NUMBER
|
System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.
|
NUMBER
|
NORTERN
|
NORTERN_TRANSACTION_NO
|
PAF_TRANSACTION_TYPE
|
Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions.
|
CHAR(4)
|
CALCULATION
|
EARN
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
NOBTRAN
|
NOBTRAN_PIDM
|
POSITION
|
Position number attached to the personnel action.
|
VARCHAR2(6)
|
NORTERN
|
NORTERN_POSN
|
SHIFT_NUMBER
|
Shift associated with earnings code.
|
VARCHAR2(1)
|
NORTERN
|
NORTERN_SHIFT
|
SPECIAL_RATE
|
Special rate (if applicable) to be used for this earnings code.
|
NUMBER
|
NORTERN
|
NORTERN_SPECIAL_RATE
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|