Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Activity Description	Description of the activity code.	VARCHAR2(35)		FUNCTION	GOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
ACTIVITY_STATUS	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	Carrier	Identifies the specific Benefit/deduction.	VARCHAR2(3)		NHRDIST	NHRDIST_BDCA_CODE
CARRIER_LONG_DESC	Carrier Long Description	Identifies the long description for the specific Benefit/deduction.	VARCHAR2(30)		PTRBDCA	PTRBDCA_LONG_DESC
CARRIER_SHORT_DESC	Carrier Short Description	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	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	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(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(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	Project Description	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	Tax Deduction	Identifies the specific Benefit/deduction.	VARCHAR2(3)		PDRDEDN	PDRDEDN_BDCA_CODE
TAX_DEDUCTION_LONG_DESC	Tax Deduction Long Description	Identifies the long description for the specific Benefit/deduction.	VARCHAR2(30)		PTRBDCA	PTRBDCA_LONG_DESC
TAX_DEDUCTION_SHORT_DESC	Tax Deduction Short Description	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: