Reporting View Source: NHRDIST

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: NHRDIST Human Resources Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
NHRDIST_ACCT_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	ACCOUNT
NHRDIST_ACCT_CODE_EXTERNAL	PHPFEXP	PAYROLL_DISTRIBUTION	EXTERNAL_ACCOUNT
NHRDIST_ACTV_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	ACTIVITY
NHRDIST_AMT	PHPFEXP	PAYROLL_DISTRIBUTION	TRANSACTION_AMOUNT
NHRDIST_BDCA_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	CARRIER
NHRDIST_CATEGORY_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	CATEGORY
NHRDIST_COAS_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	CHART_OF_ACCOUNTS
NHRDIST_CTYP_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	COST_TYPE
NHRDIST_DOC_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	DOCUMENT
NHRDIST_DR_CR_IND	PHPFEXP	PAYROLL_DISTRIBUTION	DEBIT_CREDIT_IND
NHRDIST_EARN_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	EARNINGS
NHRDIST_EARN_EXPENDS_PTOT_IND	PHPFEXP	PAYROLL_DISTRIBUTION	POSITION_TOTAL_IND
NHRDIST_ECLS_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	POSITION_EMPLOYEE_CLASS
NHRDIST_ENCD_ITEM_NUM	PHPFEXP	PAYROLL_DISTRIBUTION	ENCUMBRANCE_ITEM_NUMBER
NHRDIST_ENCD_NUM	PHPFEXP	PAYROLL_DISTRIBUTION	ENCUMBRANCE_NUMBER
NHRDIST_ENCD_SEQ_NUM	PHPFEXP	PAYROLL_DISTRIBUTION	ENCUMBRANCE_SEQ_NUMBER
NHRDIST_FISC_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	FISCAL_YEAR
NHRDIST_FUND_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	FUND
NHRDIST_HIST_TYPE_IND	PHPFEXP	PAYROLL_DISTRIBUTION	PAYROLL_EVENT_TYPE
NHRDIST_HRS	PHPFEXP	PAYROLL_DISTRIBUTION	LABOR_DISTRIBUTION_HOURS
NHRDIST_INTERFACED_IND	PHPFEXP	PAYROLL_DISTRIBUTION	POSTING_STATUS
NHRDIST_LOCN_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	LOCATION
NHRDIST_OBPH_CODE	PHPFEXP	PAYROLL_DISTRIBUTION PAYROLL_DISTRIBUTION	BUDGET_PHASE_CODE BUDGET_PHASE_DESC
NHRDIST_OBUD_CODE	PHPFEXP	PAYROLL_DISTRIBUTION PAYROLL_DISTRIBUTION	BUDGET_IDENTIFIER BUDGET_IDENTIFIER_DESC
NHRDIST_ORGN_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	ORGANIZATION_CODE
NHRDIST_PAYNO	NHRDIST	PAYROLL_DISTRIBUTION	PAYROLL_NUMBER
NHRDIST_PICT_CODE	NHRDIST	PAYROLL_DISTRIBUTION	PAYROLL_IDENTIFIER
NHRDIST_PIDM	PHPFEXP	PAYROLL_DISTRIBUTION	PERSON_UID
NHRDIST_POSN	PHPFEXP	PAYROLL_DISTRIBUTION	POSITION
NHRDIST_POSNBUD_DOC_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	BUDGET_DOCUMENT
NHRDIST_PROG_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	PROGRAM
NHRDIST_PROJ_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	PROJECT
NHRDIST_PTOT_STATUS	PHPFEXP	PAYROLL_DISTRIBUTION	BUDGET_STATUS
NHRDIST_RUCL_CODE	PHPFEXP	PAYROLL_DISTRIBUTION	RULE_CLASS
NHRDIST_SEQ_NO	PHPFEXP	PAYROLL_DISTRIBUTION	EVENT_SEQUENCE_NUMBER
NHRDIST_SOURCE	PHPFEXP	PAYROLL_DISTRIBUTION	SOURCE
NHRDIST_SUFF	PHPFEXP	PAYROLL_DISTRIBUTION	JOB_SUFFIX
NHRDIST_TNUM	PHPFEXP	PAYROLL_DISTRIBUTION	TRANSACTION_NUMBER
NHRDIST_TRANS_DATE	PHPFEXP	PAYROLL_DISTRIBUTION	TRANSACTION_DATE
NHRDIST_YEAR	NHRDIST	PAYROLL_DISTRIBUTION	CALENDAR_YEAR

Ver: 8.3