Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACCOUNT	Account code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_ACCT_CODE	NO	NO
ACTIVITY	Activity code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_ACTV_CODE	NO	NO
ACTIVITY_DESC	Description of the activity code.	VARCHAR2(35)	FUNCTION	GOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC	NO	NO
ACTIVITY_STATUS	Status of the associated activity for this Level of the Hierarchy.	VARCHAR2(1)	FUNCTION	GOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS	NO	NO
BUDGET_DOCUMENT	User or system generated document number.	VARCHAR2(8)	NHRDIST	NHRDIST_POSNBUD_DOC_CODE	NO	NO
BUDGET_IDENTIFIER	User-defined unique identification of the budget. Generally Fiscal year for which the budget is being prepared.	VARCHAR2(6)	NHRDIST	NHRDIST_OBUD_CODE	NO	NO
BUDGET_IDENTIFIER_DESC	Description of the budget.	VARCHAR2(35)	NHRDIST	NHRDIST_OBUD_CODE	NO	NO
BUDGET_PHASE_CODE	System defined code for the budget phase.	VARCHAR2(6)	NHRDIST	NHRDIST_OBPH_CODE	NO	NO
BUDGET_PHASE_DESC	Budget phase description.	VARCHAR2(35)	NHRDIST	NHRDIST_OBPH_CODE	NO	NO
BUDGET_STATUS	Identifies the current status of the Position Total record. Valid values are active, working, transferred or closed.	VARCHAR2(1)	NHRDIST	NHRDIST_PTOT_STATUS	NO	NO
BUDGET_STATUS_DESC	Position status description.	VARCHAR2(11)	CALCULATION	DECODE(NBRPTOT_STATUS,'A',APPROVED,'C',CLOSED,'T',TRANSFERRED,'W',WORKING)	NO	NO
CALENDAR_YEAR	Pay Period Year for Expenditure Interface transactions. This will be null for all transactions other than Expenditure type transactions.	VARCHAR2(4)	NHRDIST	NHRDIST_YEAR	NO	NO
CARRIER	Identifies the specific Benefit/deduction.	VARCHAR2(3)	NHRDIST	NHRDIST_BDCA_CODE	NO	NO
CARRIER_LONG_DESC	Identifies the long description for the specific Benefit/deduction.	VARCHAR2(30)	PTRBDCA	PTRBDCA_LONG_DESC	NO	NO
CARRIER_SHORT_DESC	Identifies the short description for the specific Benefit/deduction.	VARCHAR2(8)	PTRBDCA	PTRBDCA_SHORT_DESC	NO	NO
CATEGORY	An internal code which identifies the type of Finance Interface transaction (Earnings, Employee deductions, Net Pay, Budget Adjustment, Encumbrance, etc.).	VARCHAR2(1)	NHRDIST	NHRDIST_CATEGORY_CODE	NO	NO
CATEGORY_DESC	Need help identifying from form.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CHART_OF_ACCOUNTS	Chart of Accounts Code. Only filled if Finance System is present.	VARCHAR2(1)	NHRDIST	NHRDIST_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Name of the chart of accounts.	VARCHAR2(35)	FTVCOAS	FTVCOAS_TITLE	NO	NO
COST_TYPE	Type of labor cost.	VARCHAR2(2)	NHRDIST	NHRDIST_CTYP_CODE	NO	NO
COST_TYPE_DESC	Cost type description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DEBIT_CREDIT_IND	Debit/Credit indicator. This column can have a value of D, C, + or - depending on the particular transaction and whether that transaction represents a negative amount or not.	VARCHAR2(1)	NHRDIST	NHRDIST_DR_CR_IND	NO	NO
DOCUMENT	User or system generated document number.	VARCHAR2(8)	NHRDIST	NHRDIST_DOC_CODE	NO	NO
DOCUMENT_DATE	The date that will appear on the pay document.	DATE	PTRCALN	PTRCALN_CHECK_DATE	NO	NO
DOMAIN_VALUE	The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)	NA	NA	NO	NO
EARNINGS	Earnings Code.	VARCHAR2(3)	NHRDIST	NHRDIST_EARN_CODE	NO	NO
EARNINGS_DESC	Earnings code long description.	VARCHAR2(30)	PTREARN	PTREARN_LONG_DESC	NO	NO
ENCUMBRANCE_ITEM_NUMBER	Used with BANNER FINANCE to identify the line item on the encumbrance document posted from BANNER HR. Item 0 is salary, 1 is standard fringe, 2 is residual fringe.	NUMBER	NHRDIST	NHRDIST_ENCD_ITEM_NUM	NO	NO
ENCUMBRANCE_NUMBER	Used with BANNER FINANCE to identify the encumbrance document posted from BANNER HR for a given fiscal year.	VARCHAR2(8)	NHRDIST	NHRDIST_ENCD_NUM	NO	NO
ENCUMBRANCE_SEQ_NUMBER	Used with BANNER FINANCE to identify the sequence number on the encumbrance document posted from BANNER HR.	NUMBER	NHRDIST	NHRDIST_ENCD_SEQ_NUM	NO	NO
EVENT_SEQUENCE_NUMBER	Pay Event Identifying Sequence Number.	NUMBER	NHRDIST	NHRDIST_SEQ_NO	NO	NO
EXTERNAL_ACCOUNT	Free form Account Number to be used to interface to finance systems when Banner Finance is not present.	VARCHAR2(60)	NHRDIST	NHRDIST_ACCT_CODE_EXTERNAL	NO	NO
FISCAL_YEAR	The Fiscal Year to which this interface transaction will be posted.	VARCHAR2(4)	NHRDIST	NHRDIST_FISC_CODE	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	NHRDIST	NHRDIST_FUND_CODE	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)	NHRDIST	NHRDIST_SUFF	NO	NO
LABOR_DISTRIBUTION_HOURS	Number of Earnings Hours Associated With the Labor Distribution.	NUMBER	NHRDIST	NHRDIST_HRS	NO	NO
LOCATION	Location code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_LOCN_CODE	NO	NO
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA	NO	NO
ORGANIZATION_CODE	Organization code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_ORGN_CODE	NO	NO
PAYROLL_EVENT_TYPE	Indicates the type of pay event (Manual, Void, Redistribution, etc.).	VARCHAR2(1)	NHRDIST	NHRDIST_HIST_TYPE_IND	NO	NO
PAYROLL_EVENT_TYPE_DESC	Description of the pay event type.	VARCHAR2(13)	CALCULATION	DECODE(NHRDIST_HIST_TYPE_IND)	NO	NO
PAYROLL_IDENTIFIER	Pay identification number to which this Employee_Position belongs.	VARCHAR2(2)	NHRDIST	NHRDIST_PICT_CODE	NO	NO
PAYROLL_IDENTIFIER_DESC	The description or title of the payroll code.	VARCHAR2(30)	PTRPICT	PTRPICT_DESC	NO	NO
PAYROLL_PERIOD_NUMBER	The Pay Number is used to uniquely identify a pay period within a fiscal year.	NUMBER	NHRDIST	NHRDIST_PAYNO	NO	NO
PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER	NHRDIST	NHRDIST_PIDM	NO	NO
POSITION	Employee Position number.	VARCHAR2(6)	NHRDIST	NHRDIST_POSN	NO	NO
POSITION_EMPLOYEE_CLASS	Employee Position Class.	VARCHAR2(2)	NHRDIST	NHRDIST_ECLS_CODE	NO	NO
POSITION_EMPLOYEE_CLASS_DESC	Employee position class description.	VARCHAR2(30)	PTRECLS	PTRECLS_LONG_DESC	NO	NO
POSITION_TOTAL_IND	Indicates if the earnings being processed updates the position total and expended amount.	VARCHAR2(1)	NHRDIST	NHRDIST_EARN_EXPENDS_PTOT_IND	NO	NO
POSTING_STATUS	Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed.	VARCHAR2(1)	NHRDIST	NHRDIST_INTERFACED_IND	NO	NO
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(6)	NHRDIST	NHRDIST_PROG_CODE	NO	NO
PROJECT	Work order code used for cost accounting.	VARCHAR2(8)	NHRDIST	NHRDIST_PROJ_CODE	NO	NO
PROJECT_DESC	Description of the project.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC	NO	NO
RULE_CLASS	The Finance System Rule Class code to be applied to this interface transaction.	VARCHAR2(4)	NHRDIST	NHRDIST_RUCL_CODE	NO	NO
RULE_CLASS_DESC	Unique title assigned to a rule class.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOURCE	Helps to tie the transaction back to its source. Different values are stored here depending on the transaction (For earnings: Earn Code, for Benefits/Deductions: Deduction/Benefit code, for budget: Position ID, etc.).	VARCHAR2(10)	NHRDIST	NHRDIST_SOURCE	NO	NO
SOURCE_DESC	Description of the source.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TAX_DEDUCTION	Identifies the specific Benefit/deduction.	VARCHAR2(3)	PDRDEDN	PDRDEDN_BDCA_CODE	NO	NO
TAX_DEDUCTION_LONG_DESC	Identifies the long description for the specific Benefit/deduction.	VARCHAR2(30)	PTRBDCA	PTRBDCA_LONG_DESC	NO	NO
TAX_DEDUCTION_SHORT_DESC	Identifies the short description for the specific Benefit/deduction.	VARCHAR2(8)	PTRBDCA	PTRBDCA_SHORT_DESC	NO	NO
TRANSACTION_AMOUNT	The absolute dollar amount of the transaction associated with this specific account distribution. The DEBIT_CREDIT_IND is used when representing negative transactions.	NUMBER	NHRDIST	NHRDIST_AMT	NO	NO
TRANSACTION_DATE	The transaction date used to post this entry through into the finance system.	DATE	NHRDIST	NHRDIST_TRANS_DATE	NO	NO
TRANSACTION_NUMBER	Unique transaction number generated by the payroll process.	NUMBER	NHRDIST	NHRDIST_TNUM	NO	NO
ZONE_VALUE	The institution value of the process-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)	NA	NA	NO	NO

Ver: