| 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 CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS B_CHART_OF_ACCOUNTS
|
NO NO NO 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 CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC B_CHART_OF_ACCOUNTS_DESC
|
NO NO NO 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 CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC B_CHART_OF_ACCOUNTS_DESC
|
NO NO NO 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
|