Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
CURRENT_DATE
|
|
DATE
|
|
|
|
NO
|
DOMAIN_VALUE
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PAF_APPLY_DATE
|
Date transaction was applied.
|
DATE
|
NOBTRAN
|
NOBTRAN_APPLY_DATE
|
NO
|
NO
|
PAF_APPLY_IND
|
Indicator to apply transaction to the database.
|
VARCHAR2(1)
|
NOBTRAN
|
NOBTRAN_APPLY_IND
|
NO
|
NO
|
PAF_APPLY_USER_ID
|
User ID who applied transaction to the database.
|
VARCHAR2(30)
|
NOBTRAN
|
NOBTRAN_APPLY_USER_ID
|
NO
|
NO
|
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(6)
|
NOBTRAN
|
NOBTRAN_ACAT_CODE
|
NO
|
NO
|
PAF_APPROVAL_CATEGORY_DESC
|
Approval category description.
|
VARCHAR2(30)
|
NTVACAT
|
NTVACAT_DESC
|
NO
|
NO
|
PAF_COMMENT_COUNT
|
Number of comment records for this transaction and sequence number.
|
NUMBER
|
FUNCTION
|
NOKODSF.F_GET_PAF_COMMENT_COUNT
|
NO
|
NO
|
PAF_EFFECTIVE_DATE
|
Date the personnel action record became effective.
|
DATE
|
NOBTRAN
|
NOBTRAN_EFFECTIVE_DATE
|
NO
|
NO
|
PAF_ORIGINATOR_CREATE_DATE
|
Date the personnel action is created.
|
DATE
|
NOBTRAN
|
NOBTRAN_CREATED_DATE
|
NO
|
NO
|
PAF_ORIGINATOR_USER_ID
|
User id who submitted the personnel action activity.
|
VARCHAR2(30)
|
NOBTRAN
|
NOBTRAN_ORIGINATOR_USER_ID
|
NO
|
NO
|
PAF_SUBMIT_DATE
|
Date the personnel action is submitted to start the transaction through the approval queue.
|
DATE
|
NOBTRAN
|
NOBTRAN_SUBMISSION_DATE
|
NO
|
NO
|
PAF_SUBMIT_USER_ID
|
User id who submitted the a personnel action activity.
|
VARCHAR2(30)
|
NOBTRAN
|
NOBTRAN_SUBMITTOR_USER_ID
|
NO
|
NO
|
PAF_TRANSACTION_ACTIVITY_DATE
|
Date of last activity on this record.
|
DATE
|
NORTRAN
|
NOBTRAN_ACTIVITY_DATE
|
NO
|
NO
|
PAF_TRANSACTION_NUMBER
|
System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.
|
NUMBER
|
NOBTRAN
|
NOBTRAN_TRANSACTION_NO
|
NO
|
NO
|
PAF_TRANSACTION_STATUS
|
Status of the personnel action transaction.
|
VARCHAR2(1)
|
NOBTRAN
|
NOBTRAN_TRANS_STATUS_IND
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
NOBTRAN
|
NOBTRAN_PIDM
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|