| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACCOUNTS_RECEIVABLE_KEY
|
Key for the accounts receivable dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
ACCOUNT_KEY
|
Key for the account dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
AMOUNT_DUE
|
Amount due or current as of the date of the EDW record creation. Amounts with a future effective date will not be included in this measure.
|
NUMBER
|
RECEIVABLE_ACCOUNT_DETAIL
|
AMOUNT
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
BALANCE
|
Account balance on the date of the EDW record creation. Total debits minus total credits.
|
NUMBER
|
RECEIVABLE_ACCOUNT_DETAIL
|
BALANCE
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
CHART_KEY
|
Key for the chart dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
FUND_KEY
|
Key for the fund dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
ORGANIZATION_KEY
|
Key for the organization dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
PROGRAM_KEY
|
Key for the program dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
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
|
RECEIVABLE REVENUE
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE REVENUE
|
|
TIME_KEY
|
Key for the time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE REVENUE
|