Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
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)	NORTRAN	NORTRAN_SUFF	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PAF_APPLY_ACTIVITY_DATE	Date of last activity on this record.	DATE	NORTRAN	NORTRAN_ACTIVITY_DATE	NO	NO
PAF_APPLY_COLUMN	Database column that was sent through the approval process.	VARCHAR2(63)	NORTRAN	NORTRAN_AUFD_CODE	NO	NO
PAF_APPLY_FORM	Data entry form that was sent through the approval process.	VARCHAR2(63)	NORTRAN	NORTRAN_AUFM_CODE	NO	NO
PAF_APPLY_STATUS	Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled.	VARCHAR2(63)	NORTRAN	NORTRAN_APPLY_STATUS_IND	NO	NO
PAF_APPLY_STATUS_DESC	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	NO	NO
PAF_APPLY_TABLE	Database table that was sent through the approval process.	VARCHAR2(63)	NORTRAN	NORTRAN_AUBK_CODE	NO	NO
PAF_APPLY_VALUE	New value entered for the database column.	VARCHAR2(4000)	NORTRAN	NORTRAN_VALUE	NO	NO
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)	NORTRAN	NORTRAN_APTY_CODE	NO	NO
PAF_APPROVAL_TYPE_DESC	Approval type description.	VARCHAR2(255)	NTVAPTY	NTVAPTY_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_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	NO	NO
PAF_EFFECTIVE_DATE	Date the personnel action record became effective.	DATE	NOBTRAN	NOBTRAN_EFFECTIVE_DATE	NO	NO
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	NO	NO
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	NO	NO
PAF_SEQUENCE_NUMBER	Display sequence for each of field changed in the approval transaction.	NUMBER	NORTRAN	NORTRAN_DISPLAY_SEQ_NO	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(63)	NOBTRAN	NOBTRAN_TRANS_STATUS_IND	NO	NO
PAF_TRANSACTION_STATUS_DESC	Personnel action transaction status description.	VARCHAR2(255)	FUNCTION	(SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE =PAF_TRANSACTION_STATUS)	NO	NO
PAF_TRANSACTION_TYPE	Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions.	VARCHAR2(63)	CALCULATION	CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN'	NO	NO
PAF_TRANSACTION_TYPE_DESC	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	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NOBTRAN	NOBTRAN_PIDM	NO	NO
POSITION	Position number attached to the personnel action.	VARCHAR2(63)	NORTRAN	NORTRAN_POSN	NO	NO
POSITION_TITLE	Employee position description. Defaults from the position title if left blank.	VARCHAR2(255)	FUNCTION	MPKFUNC.F_GET_EMPL_POSITION_INFO	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2