RETURN TO BANNER EDW META DATA REPORTS LIST
(Banner ODS Target Report)

SGHE Enterprise Data Warehouse Banner EDW Source: RECEIVABLE_ACCOUNTING - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
B_ACCOUNT NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT

RECEIVABLE REVENUE 

NO

B_ACCOUNT_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LD

RECEIVABLE REVENUE 

NO

B_CHART_OF_ACCOUNTS NO

DIMENSION TABLE

WDT_CHART

CHART_OF_ACCOUNTS

RECEIVABLE REVENUE 

NO

B_CHART_OF_ACCOUNTS_DESC NO

DIMENSION TABLE

WDT_CHART

WDT_CHART

CHART_OF_ACCOUNTS_LD

CHART_OF_ACCOUNTS_SD

RECEIVABLE REVENUE 

RECEIVABLE REVENUE 

NO

NO

B_FUND NO

DIMENSION TABLE

WDT_FUND

FUND

RECEIVABLE REVENUE 

NO

B_FUND_DESC NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_SD

FUND_LD

RECEIVABLE REVENUE 

RECEIVABLE REVENUE 

NO

NO

B_ORGANIZATION NO

DIMENSION TABLE

WDT_ORGANIZATION

ORGANIZATION_CODE

RECEIVABLE REVENUE 

NO

B_ORGANIZATION_DESC NO

DIMENSION TABLE

WDT_ORGANIZATION

WDT_ORGANIZATION

ORGANIZATION_CODE_LD

ORGANIZATION_CODE_SD

RECEIVABLE REVENUE 

RECEIVABLE REVENUE 

NO

NO

B_PROGRAM NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM

RECEIVABLE REVENUE 

NO

B_PROGRAM_DESC NO

DIMENSION TABLE

WDT_PROGRAM

PROGRAM_LD

RECEIVABLE REVENUE 

NO



Ver: 9.0