RETURN TO BANNER EDW META DATA REPORTS LIST
General Ledger Star  Grant And Project Star  Operating Ledger Star  Receivable Revenue Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CHART

Description Chart Dimension table provides information on the chart of accounts. This information is the chart code and descriptions. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
CHART_KEY Key for the chart dimension. NUMBER

ETL GENERATED

NA

NO

NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
CHART_OF_ACCOUNTS Primary identification code for any chart of accounts that is used to uniquely identify that chart from any other in a multi-chart environment. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)

RECEIVABLE_ACCOUNTING

B_CHART_OF_ACCOUNTS

NO

NO RECEIVABLE REVENUE
CHART_OF_ACCOUNTS_LD Long description or title for the chart of accounts. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)

RECEIVABLE_ACCOUNTING

B_CHART_OF_ACCOUNTS_DESC

NO

NO RECEIVABLE REVENUE
CHART_OF_ACCOUNTS_SD Short description or title for the chart of accounts. VARCHAR2(255)

RECEIVABLE_ACCOUNTING

B_CHART_OF_ACCOUNTS_DESC

NO

NO RECEIVABLE REVENUE
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE


Ver: 9.0