Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT	Account code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_ACCT_CODE
ACTIVITY	Activity code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_ACTV_CODE
ACTIVITY_DESC	Description of the activity code.	VARCHAR2(35)	FUNCTION	GOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
ACTIVITY_STATUS	Status of the associated activity for this Level of the Hierarchy.	VARCHAR2(1)	FUNCTION	GOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
BUDGET_DOCUMENT	User or system generated document number.	VARCHAR2(8)	NHRDIST	NHRDIST_POSNBUD_DOC_CODE
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
BUDGET_IDENTIFIER_DESC	Description of the budget.	VARCHAR2(35)	NHRDIST	NHRDIST_OBUD_CODE
BUDGET_PHASE_CODE	System defined code for the budget phase.	VARCHAR2(6)	NHRDIST	NHRDIST_OBPH_CODE
BUDGET_PHASE_DESC	Budget phase description.	VARCHAR2(35)	NHRDIST	NHRDIST_OBPH_CODE
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
BUDGET_STATUS_DESC	Position status description.	VARCHAR2(30)	CALCULATION	DECODE(NBRPTOT_STATUS,'A',APPROVED,'C',CLOSED,'T',TRANSFERRED,'W',WORKING)
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
CARRIER	Identifies the specific Benefit/deduction.	VARCHAR2(3)	NHRDIST	NHRDIST_BDCA_CODE
CARRIER_LONG_DESC	Identifies the long description for the specific Benefit/deduction.	VARCHAR2(30)	PTRBDCA	PTRBDCA_LONG_DESC
CARRIER_SHORT_DESC	Identifies the short description for the specific Benefit/deduction.	VARCHAR2(8)	PTRBDCA	PTRBDCA_SHORT_DESC
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
CATEGORY_DESC	Need help identifying from form	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
CHART_OF_ACCOUNTS	Chart of Accounts Code. Only filled if Finance System is present.	VARCHAR2(1)	NHRDIST	NHRDIST_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Name of the chart of accounts.	VARCHAR2(35)	FTVCOAS	FTVCOAS_TITLE
COST_TYPE	Type of labor cost.	VARCHAR2(2)	NHRDIST	NHRDIST_CTYP_CODE
COST_TYPE_DESC	Cost type description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
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
DOCUMENT	User or system generated document number.	VARCHAR2(8)	NHRDIST	NHRDIST_DOC_CODE
DOCUMENT_DATE	The date that will appear on the pay document.	DATE	PTRCALN	PTRCALN_CHECK_DATE
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
EARNINGS	Earnings Code.	VARCHAR2(3)	NHRDIST	NHRDIST_EARN_CODE
EARNINGS_DESC	Earnings code long description.	VARCHAR2(30)	PTREARN	PTREARN_LONG_DESC
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(4)	NHRDIST	NHRDIST_ENCD_ITEM_NUM
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
ENCUMBRANCE_SEQ_NUMBER	Used with BANNER FINANCE to identify the sequence number on the encumbrance document posted from BANNER HR.	NUMBER(4)	NHRDIST	NHRDIST_ENCD_SEQ_NUM
EVENT_SEQUENCE_NUMBER	Pay Event Identifying Sequence Number.	NUMBER(2)	NHRDIST	NHRDIST_SEQ_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
FISCAL_YEAR	The Fiscal Year to which this interface transaction will be posted.	VARCHAR2(4)	NHRDIST	NHRDIST_FISC_CODE
FUND	Fund code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_FUND_CODE
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
LABOR_DISTRIBUTION_HOURS	Number of Earnings Hours Associated With the Labor Distribution.	NUMBER(6, 2)	NHRDIST	NHRDIST_HRS
LOCATION	Location code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_LOCN_CODE
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
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
ORGANIZATION_CODE	Organization code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_ORGN_CODE
PAYROLL_EVENT_TYPE	Indicates the type of pay event (Manual, Void, Redistribution, etc.).	VARCHAR2(1)	NHRDIST	NHRDIST_HIST_TYPE_IND
PAYROLL_EVENT_TYPE_DESC	Description of the pay event type.	VARCHAR2(30)	CALCULATION	DECODE(NHRDIST_HIST_TYPE_IND)
PAYROLL_IDENTIFIER	Pay identification number to which this Employee_Position belongs.	VARCHAR2(2)	NHRDIST	NHRDIST_PICT_CODE
PAYROLL_IDENTIFIER_DESC	The description or title of the payroll code.	VARCHAR2(30)	PTRPICT	PTRPICT_DESC
PAYROLL_PERIOD_NUMBER	The Pay Number is used to uniquely identify a pay period within a fiscal year.	NUMBER(3)	NHRDIST	NHRDIST_PAYNO
PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER(8)	NHRDIST	NHRDIST_PIDM
POSITION	Employee Position number.	VARCHAR2(6)	NHRDIST	NHRDIST_POSN
POSITION_EMPLOYEE_CLASS	Employee Position Class	VARCHAR2(2)	NHRDIST	NHRDIST_ECLS_CODE
POSITION_EMPLOYEE_CLASS_DESC	Employee position class description.	VARCHAR2(30)	PTRECLS	PTRECLS_LONG_DESC
POSITION_TOTAL_IND	Indicates if the earnings being processed updates the position total and expended amount.	VARCHAR2(1)	NHRDIST	NHRDIST_EARN_EXPENDS_PTOT_IND
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
PROGRAM	Program code. Only filled if Finance System is present.	VARCHAR2(6)	NHRDIST	NHRDIST_PROG_CODE
PROJECT	Work order code used for cost accounting.	VARCHAR2(8)	NHRDIST	NHRDIST_PROJ_CODE
PROJECT_DESC	Description of the project.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
RULE_CLASS	The Finance System Rule Class code to be applied to this interface transaction.	VARCHAR2(4)	NHRDIST	NHRDIST_RUCL_CODE
RULE_CLASS_DESC	Unique title assigned to a rule class.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
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
SOURCE_DESC	Description of the source.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
TAX_DEDUCTION	Identifies the specific Benefit/deduction.	VARCHAR2(3)	PDRDEDN	PDRDEDN_BDCA_CODE
TAX_DEDUCTION_LONG_DESC	Identifies the long description for the specific Benefit/deduction.	VARCHAR2(30)	PTRBDCA	PTRBDCA_LONG_DESC
TAX_DEDUCTION_SHORT_DESC	Identifies the short description for the specific Benefit/deduction.	VARCHAR2(8)	PTRBDCA	PTRBDCA_SHORT_DESC
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(11, 2)	NHRDIST	NHRDIST_AMT
TRANSACTION_DATE	The transaction date used to post this entry through into the finance system.	DATE	NHRDIST	NHRDIST_TRANS_DATE
TRANSACTION_NUMBER	Unique transaction number generated by the payroll process.	NUMBER(15)	NHRDIST	NHRDIST_TNUM
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

Ver: 8.1