Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT	Account code that this APPROVAL TRANSACTION was charged.	VARCHAR2(63)	NORTLBD	NORTLBD_ACCT_CODE
ACCOUNT_DESC	Position account description.	VARCHAR2(255)	FTVACCT	FTVACCT_TITLE
ACCOUNT_INDEX	Account index code that was used to default the account distribution this APPROVAL TRANSACTION was charged.	VARCHAR2(63)	NORTLBD	NORTLBD_ACCI_CODE
ACCOUNT_INDEX_DESC	An index code that is used to default the account distribution to which this position should be charged.	VARCHAR2(255)	FTVACCI	FTVACCI_TITLE
ACTIVITY	Activity code where this APPROVAL TRANSACTION is charged.	VARCHAR2(63)	NORTLBD	NORTLBD_ACTV_CODE
ACTIVITY_DESC	Position activity description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CHART_OF_ACCOUNTS	Chart of accounts code where this APPROVAL TRANSACTION is charged.	VARCHAR2(63)	NORTLBD	NORTLBD_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COST_TYPE	Cost type where this APPROVAL TRANSACTION is charged when cost accounting is used.	VARCHAR2(63)	NORTLBD	NORTLBD_CTYP_CODE
COST_TYPE_LONG_DESC	Cost type long description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COST_TYPE_SHORT_DESC	Cost type short description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ENCUMBRANCE_CALCULATE_END_DATE	End date used to calculate future fiscal year encumbrances for a labor distribution.	DATE	NORTLBD	NORTLBD_ENC_OVERRIDE_END_DATE
EXTERNAL_ACCOUNT	Free form account number to be used to interface to an external finance system.	VARCHAR2(63)	NORTLBD	NORTLBD_ACCT_CODE_EXTERNAL
FUND	Fund code where this APPROVAL TRANSACTION is charged.	VARCHAR2(63)	NORTLBD	NORTLBD_FUND_CODE
FUND_DESC	Position fund description.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
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
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)	NORTLBD	NORTLBD_SUFF
LOCATION	Location code where this APPROVAL TRANSACTION is charged.	VARCHAR2(63)	NORTLBD	NORTLBD_LOCN_CODE
LOCATION_DESC	Position location description.	VARCHAR2(255)	FTVLOCN	FTVLOCN_TITLE
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
ORGANIZATION_CODE	Organization code where this APPROVAL TRANSACTION is charged.	VARCHAR2(63)	NORTLBD	NORTLBD_ORGN_CODE
ORGANIZATION_DESC	Position organization description.	VARCHAR2(255)	FTVORGN	FTVORGN_TITLE
PAF_APPLY_STATUS	Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled.	VARCHAR2(63)	NORTLBD	NORTLBD_APPLY_STATUS_IND
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
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)	NORTLBD	NORTLBD_APTY_CODE
PAF_APPROVAL_TYPE_DESC	Approval type description.	VARCHAR2(255)	NTVAPTY	NTVAPTY_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	NORTLBD	NORTLBD_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_LABOR_DIST_ACTIVITY_DATE	Date of last activity on this record.	DATE	NORTLBD	NORTLBD_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_TYPE	Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions.	VARCHAR2(63)	CONSTANT	'TBLD'
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
PERCENT	Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.	NUMBER	NORTLBD	NORTLBD_PERCENT
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NOBTRAN	NOBTRAN_PIDM
POSITION	Position number attached to the personnel action.	VARCHAR2(63)	NORTLBD	NORTLBD_POSN
POSITION_TITLE	Employee position description. Defaults from the position title if left blank.	VARCHAR2(255)	FUNCTION	MPKFUNC.F_GET_EMPL_POSITION_INFO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	Program code where this APPROVAL TRANSACTION is charged.	VARCHAR2(63)	NORTLBD	NORTLBD_PROG_CODE
PROGRAM_DESC	Position program description.	VARCHAR2(255)	FTVPROG	FTVPROG_TITLE
PROJECT	Project code where this APPROVAL TRANSACTION is charged when cost accounting is used.	VARCHAR2(63)	NORTLBD	NORTLBD_PROJ_CODE
PROJECT_DESC	Position project description.	VARCHAR2(255)	FTVPROJ	FTVPROJ_DESC

Ver: 9.1