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(11)	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	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	NHRDIST	NHRDIST_ENCD_SEQ_NUM
EVENT_SEQUENCE_NUMBER	Pay Event Identifying Sequence Number.	NUMBER	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	Financial Aid Fund code to be associated with information in this record.	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	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(13)	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	NHRDIST	NHRDIST_PAYNO
PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER	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	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
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	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	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: