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
|
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
|
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_DATE
|
Paf Apply Date
|
Date transaction was applied.
|
DATE
|
NOBTRAN
|
NOBTRAN_APPLY_DATE
|
PAF_APPLY_IND
|
Paf Apply Indicator
|
Indicator to apply transaction to the database.
|
VARCHAR2(1)
|
NOBTRAN
|
NOBTRAN_APPLY_IND
|
PAF_APPLY_USER_ID
|
Paf Apply User ID
|
User ID who applied transaction to the database.
|
VARCHAR2(63)
|
NOBTRAN
|
NOBTRAN_APPLY_USER_ID
|
PAF_APPROVAL_CATEGORY
|
Paf Approval Category
|
Approval category that represents the purpose of the personnel action. Designates the action taken on the part of the employee such as the transfer of an employee from one department to another.
|
VARCHAR2(63)
|
NOBTRAN
|
NOBTRAN_ACAT_CODE
|
PAF_APPROVAL_CATEGORY_DESC
|
Paf Approval Category Description
|
Approval category description.
|
VARCHAR2(255)
|
NTVACAT
|
NTVACAT_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_EFFECTIVE_DATE
|
Paf Effective Date
|
Date the personnel action record became effective.
|
DATE
|
NOBTRAN
|
NOBTRAN_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_ORIGINATOR_CREATE_DATE
|
Paf Originator Create Date
|
Date the personnel action is created.
|
DATE
|
NOBTRAN
|
NOBTRAN_CREATED_DATE
|
PAF_ORIGINATOR_USER_ID
|
Paf Originator User ID
|
User id who submitted the personnel action activity.
|
VARCHAR2(63)
|
NOBTRAN
|
NOBTRAN_ORIGINATOR_USER_ID
|
PAF_SUBMIT_DATE
|
Paf Submit Date
|
Date the personnel action is submitted to start the transaction through the approval queue.
|
DATE
|
NOBTRAN
|
NOBTRAN_SUBMISSION_DATE
|
PAF_SUBMIT_USER_ID
|
Paf Submit User ID
|
User id who submitted the a personnel action activity.
|
VARCHAR2(63)
|
NOBTRAN
|
NOBTRAN_SUBMITTOR_USER_ID
|
PAF_TRANSACTION_ACTIVITY_DATE
|
Paf Transaction Activity Date
|
Date of last activity on this record.
|
DATE
|
NOBTRAN
|
NOBTRAN_ACTIVITY_DATE
|
PAF_TRANSACTION_NUMBER
|
Paf Transaction Number
|
System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.
|
NUMBER
|
NOBTRAN
|
NOBTRAN_TRANSACTION_NO
|
PAF_TRANSACTION_STATUS
|
Paf Transaction Status
|
Status of the personnel action transaction.
|
VARCHAR2(63)
|
NOBTRAN
|
NOBTRAN_TRANS_STATUS_IND
|
PAF_TRANSACTION_STATUS_DESC
|
Paf Transaction Status Description
|
Personnel action transaction status description.
|
VARCHAR2(255)
|
FUNCTION
|
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE = PAF_TRANSACTION_STATUS
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
NOBTRAN
|
NOBTRAN_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|