Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
EARNINGS
|
Earnings
|
Identifies the transaction approval default earnings code.
|
VARCHAR2(63)
|
NORTERN
|
NORTERN_EARN_CODE
|
EARNINGS_DESC
|
Earnings Description
|
Earnings code long description.
|
VARCHAR2(255)
|
PTREARN
|
PTREARN_LONG_DESC
|
EARNINGS_END_DATE
|
Earnings End Date
|
End date for this earnings code.
|
DATE
|
NORTERN
|
NORTERN_CANCEL_DATE
|
EARNINGS_HOURS
|
Earning Hours
|
Hours or units to default for this earnings code.
|
NUMBER
|
NORTERN
|
NORTERN_HRS
|
FEDERAL_EMPLOYMENT_HOURS
|
Federal Employment Hours
|
Hours for federal employment reporting. Used to report hours for Canadian Employment Insurance.
|
NUMBER
|
NORTERN
|
NORTERN_DEEMED_HRS
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
JOB_SUFFIX
|
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(63)
|
NORTERN
|
NORTERN_SUFF
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PAF_APPLY_STATUS
|
Paf Apply Status
|
Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled.
|
VARCHAR2(63)
|
NORTERN
|
NORTERN_APPLY_STATUS_IND
|
PAF_APPLY_STATUS_DESC
|
Paf Apply Status Description
|
Personnel action sequence status description.
|
VARCHAR2(255)
|
FUNCTION
|
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS' AND VALUE =PAF_APPLY_STATUS
|
PAF_APPROVAL_TYPE
|
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(63)
|
NORTERN
|
NORTERN_APTY_CODE
|
PAF_APPROVAL_TYPE_DESC
|
Paf Approval Type Description
|
Approval type description.
|
VARCHAR2(255)
|
NTVAPTY
|
NTVAPTY_DESC
|
PAF_COMMENT_COUNT
|
Paf Comment Count
|
Number of comment records for this transaction and sequence number.
|
NUMBER
|
FUNCTION
|
NOKODSF.F_GET_PAF_COMMENT_COUNT
|
PAF_EARNINGS_DEFAULT_IND
|
Paf Earnings Default Indicator
|
Identifies the actions taken under this personnel action transaction number update employee data for the person. The details of these transactions maybe found in the PERSONNEL_ACTION _EARNING reporting view. Each transaction may also create data in one or more personnel action reporting views.
|
VARCHAR2(1)
|
FUNCTION
|
MPKFUNC.F_GET_PERSONNEL_ACTION_IND
|
PAF_EARNING_ACTIVITY_DATE
|
Paf Earning Activity Date
|
Date of last activity on this record.
|
DATE
|
NORTERN
|
NORTERN_ACTIVITY_DATE
|
PAF_EFFECTIVE_DATE
|
Paf Effective Date
|
Date the personnel action record became effective.
|
DATE
|
NORTERN
|
NORTERN_EFFECTIVE_DATE
|
PAF_GENERAL_CHANGE_IND
|
Paf General Change Indicator
|
Identifies the actions taken under this personnel action transaction number update either the name, ID, address, telephone number or other biographical data for the person. General changes may also include changes to columns on the employee and or job records. The details of these transactions maybe found in the PERSONNEL_ACTION_GENERAL reporting view. Each transaction may also create data in one or more personnel action reporting views.
|
VARCHAR2(1)
|
FUNCTION
|
MPKFUNC.F_GET_PERSONNEL_ACTION_IND
|
PAF_LABOR_DISTRIBUTION_IND
|
Paf Labor Distribution Indicator
|
Identifies the actions taken under this personnel action transaction number update employee data for the person. The details of these transactions maybe found in the PERSONNEL_ACTION_LABOR_DIST reporting view. Each transaction may also create data in one or more personnel action reporting views.
|
VARCHAR2(1)
|
FUNCTION
|
MPKFUNC.F_GET_PERSONNEL_ACTION_IND
|
PAF_TRANSACTION_NUMBER
|
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
|
Paf Transaction Type
|
Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions.
|
VARCHAR2(63)
|
CALCULATION
|
EARN
|
PAF_TRANSACTION_TYPE_DESC
|
Paf Transaction Type Description
|
PAF transaction change type description.
|
VARCHAR2(255)
|
FUNCTION
|
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
NOBTRAN
|
NOBTRAN_PIDM
|
POSITION
|
Position
|
Position number attached to the personnel action.
|
VARCHAR2(63)
|
NORTERN
|
NORTERN_POSN
|
POSITION_TITLE
|
Position Title
|
Employee position description. Defaults from the position title if left blank.
|
VARCHAR2(255)
|
FUNCTION
|
MPKFUNC.F_GET_EMPL_POSITION_INFO
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
SHIFT_NUMBER
|
Shift Number
|
Shift associated with earnings code.
|
VARCHAR2(63)
|
NORTERN
|
NORTERN_SHIFT
|
SPECIAL_RATE
|
Special Rate
|
Special rate (if applicable) to be used for this earnings code.
|
NUMBER
|
NORTERN
|
NORTERN_SPECIAL_RATE
|