RETURN TO DIMENSION TABLE 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)

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

RECEIVABLE_ACCOUNTING

CHART_OF_ACCOUNTS

B_CHART_OF_ACCOUNTS

NO

NO

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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)

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

RECEIVABLE_ACCOUNTING

CHART_OF_ACCOUNTS_DESC

B_CHART_OF_ACCOUNTS_DESC

NO

NO

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

RECEIVABLE REVENUE

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

RECEIVABLE_ACCOUNTING

CHART_OF_ACCOUNTS_DESC

B_CHART_OF_ACCOUNTS_DESC

NO

NO

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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: 3.1