Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACCOUNT	Account code that this APPROVAL TRANSACTION was charged.	VARCHAR2(6)	NORTBLD	NORTLBD_ACCT_CODE	NO	NO
ACCOUNT_DESC	Position account description.	VARCHAR2(35)	FTVACCT	FTVACCT_TITLE	NO	NO
ACCOUNT_INDEX	Account index code that was used to default the account distribution this APPROVAL TRANSACTION was charged.	VARCHAR2(6)	NORTBLD	NORTLBD_ACCI_CODE	NO	NO
ACCOUNT_INDEX_DESC	An index code that is used to default the account distribution to which this position should be charged.	VARCHAR2(35)	FTVACCI	FTVACCI_TITLE	NO	NO
ACTIVITY	Activity code where this APPROVAL TRANSACTION is charged.	VARCHAR2(6)	NORTBLD	NORTLBD_ACTV_CODE	NO	NO
ACTIVITY_DESC	Position activity description.	VARCHAR2(35)	FTVACTV	FTVACTV_TITLE	NO	NO
CHART_OF_ACCOUNTS	Chart of accounts code where this APPROVAL TRANSACTION is charged.	VARCHAR2(1)	NORTBLD	NORTLBD_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COST_TYPE	Cost type where this APPROVAL TRANSACTION is charged when cost accounting is used.	VARCHAR2(2)	NORTBLD	NORTLBD_CTYP_CODE	NO	NO
COST_TYPE_LONG_DESC		VARCHAR2(30)				NO
COST_TYPE_SHORT_DESC		VARCHAR2(30)				NO
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
ENCUMBRANCE_CALCULATE_END_DATE	End date used to calculate future fiscal year encumbrances for a labor distribution.	DATE	NORTBLD	NORTLBD_ENC_OVERRIDE_END_DATE	NO	NO
EXTERNAL_ACCOUNT	Free form account number to be used to interface to an external finance system.	VARCHAR2(60)	NORTBLD	NORTLBD_ACCT_CODE_EXTERNAL	NO	NO
FUND	Fund code where this APPROVAL TRANSACTION is charged.	VARCHAR2(6)	NORTBLD	NORTLBD_FUND_CODE	NO	NO
FUND_DESC	Position fund description.	VARCHAR2(35)	FTVFUND	FTVFUND_TITLE	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(2)	NORTBLD	NORTBLD_SUFF	NO	NO
LOCATION	Location code where this APPROVAL TRANSACTION is charged.	VARCHAR2(6)	NORTBLD	NORTLBD_LOCN_CODE	NO	NO
LOCATION_DESC	Position location description.	VARCHAR2(35)	FTVLOCN	FTVLOCN_TITLE	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
ORGANIZATION	Organization code where this APPROVAL TRANSACTION is charged.	VARCHAR2(6)	NORTBLD	NORTLBD_ORGN_CODE	NO	NO
ORGANIZATION_CODE		VARCHAR2(6)				NO
ORGANIZATION_DESC	Position organization description.	VARCHAR2(35)	FTVORGN	FTVORGN_TITLE	NO	NO
PAF_APPLY_STATUS	Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled.	VARCHAR2(1)	NORTBLD	NORTLBD_APPLY_STATUS_IND	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(6)	NORTBLD	NORTBLD_APTY_CODE	NO	NO
PAF_APPROVAL_TYPE_DESC	Approval type description.	VARCHAR2(30)	NTVAPTY	NTVAPTY_DESC	NO	NO
PAF_EFFECTIVE_DATE	Date the personnel action record became effective.	DATE	NORTBLD	NORTLBD_EFFECTIVE_DATE	NO	NO
PAF_LABOR_DIST_ACTIVITY_DATE	Date of last activity on this record.	DATE	NORTBLD	NORTLBD_ACTIVITY_DATE	NO	NO
PAF_TRANSACTION_NUMBER	System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.	NUMBER	NORTBLD	NORTLBD_TRANSACTION_NO	NO	NO
PAF_TRANSACTION_TYPE	Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions.	CHAR(4)	CALCULATION	TBLD	NO	NO
PERCENT	Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.	NUMBER	NORTBLD	NORTLBD_PERCENT	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(6)	NORTBLD	NORTLBD_POSN	NO	NO
PROGRAM	Program code where this APPROVAL TRANSACTION is charged.	VARCHAR2(6)	NORTBLD	NORTLBD_PROG_CODE	NO	NO
PROGRAM_DESC	Position program description.	VARCHAR2(35)	FTVPROG	FTVPROG_TITLE	NO	NO
PROJECT	Project code where this APPROVAL TRANSACTION is charged when cost accounting is used.	VARCHAR2(8)	NORTBLD	NORTLBD_PROJ_CODE	NO	NO
PROJECT_DESC	Position project description.	VARCHAR2(30)	FTVPROJ	FTVPROJ_DESC	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

Ver: