Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CURRENT_DATE	Current Date		DATE
DOMAIN_VALUE	Domain Value	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
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(30)		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(6)		NOBTRAN	NOBTRAN_ACAT_CODE
PAF_APPROVAL_CATEGORY_DESC	Paf Approval Category Description	Approval category description.	VARCHAR2(30)		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_EFFECTIVE_DATE	Paf Effective Date	Date the personnel action record became effective.	DATE		NOBTRAN	NOBTRAN_EFFECTIVE_DATE
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(30)		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(30)		NOBTRAN	NOBTRAN_SUBMITTOR_USER_ID
PAF_TRANSACTION_ACTIVITY_DATE	Paf Transaction Activity Date	Date of last activity on this record.	DATE		NORTRAN	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(1)		NOBTRAN	NOBTRAN_TRANS_STATUS_IND
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		NOBTRAN	NOBTRAN_PIDM
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: