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
|