Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAF_APPLY_DATE	Date transaction was applied.	DATE	NOBTRAN	NOBTRAN_APPLY_DATE
PAF_APPLY_IND	Indicator to apply transaction to the database.	VARCHAR2(1)	NOBTRAN	NOBTRAN_APPLY_IND
PAF_APPLY_USER_ID	User ID who applied transaction to the database.	VARCHAR2(63)	NOBTRAN	NOBTRAN_APPLY_USER_ID
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	Approval category description.	VARCHAR2(255)	NTVACAT	NTVACAT_DESC
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	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	Date the personnel action record became effective.	DATE	NOBTRAN	NOBTRAN_EFFECTIVE_DATE
PAF_GENERAL_CHANGE_IND	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	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	Date the personnel action is created.	DATE	NOBTRAN	NOBTRAN_CREATED_DATE
PAF_ORIGINATOR_USER_ID	User id who submitted the personnel action activity.	VARCHAR2(63)	NOBTRAN	NOBTRAN_ORIGINATOR_USER_ID
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	User id who submitted the a personnel action activity.	VARCHAR2(63)	NOBTRAN	NOBTRAN_SUBMITTOR_USER_ID
PAF_TRANSACTION_ACTIVITY_DATE	Date of last activity on this record.	DATE	NOBTRAN	NOBTRAN_ACTIVITY_DATE
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	Status of the personnel action transaction.	VARCHAR2(63)	NOBTRAN	NOBTRAN_TRANS_STATUS_IND
PAF_TRANSACTION_STATUS_DESC	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	System generated, unique, internal identification number assigned to this person.	NUMBER	NOBTRAN	NOBTRAN_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA

Ver: 9.1