RETURN TO FACT TABLE REPORTS LIST
Receivable Customer Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_RECEIVABLE_CUSTOMER

Description Receivable Customer Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per customer (person or entity) per time frame.

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_SUMMARY

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



Ver: 3.1