| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACADEMIC_STUDY_KEY
|
Key for the academic study dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
ACCOUNTS_RECEIVABLE_KEY
|
Key for the accounts receivable dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
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_SUMMARY
|
AMOUNT
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
BALANCE
|
Account balance on the date of the EDW record creation. Total debits minus total credits.
|
NUMBER
|
RECEIVABLE_SUMMARY
|
BALANCE
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
CUSTOMER_KEY
|
Key for the customer dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
CUSTOMER_UID
|
System internally generated ID to uniquely identify account holder.
|
NUMBER
|
RECEIVABLE_ACCOUNT
|
ACCOUNT_UID
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|
|
TIME_KEY
|
Key for the time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECEIVABLE CUSTOMER
|