RETURN TO DIMENSION TABLE REPORTS LIST
Receivable Customer Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CUSTOMER

Description Customer Dimension table provides information for the person or entity with an accounts receivable account. This information includes delinquency status, number of bad cheques and collections assignment indicator. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
COLLECTION_IND Indicates if this customer receivable account has been assigned to a collection agency. This will be set to yes when the collection agency count is greater than zero. VARCHAR2(63)

RECEIVABLE_ACCOUNT

COLLECTION_COUNT

NO

NO

RECEIVABLE CUSTOMER

CUSTOMER_KEY Key for the customer dimension. NUMBER

ETL GENERATED

NA

NO

NO

RECEIVABLE CUSTOMER

DELINQUENCY Delinquency code assigned to this receivable customer. This maybe blank. Typical VALUES will be 30, 60, 90 days to designate the number of days past due the balance was the last time it was evaluated. VARCHAR2(63)

RECEIVABLE_ACCOUNT

DELINQUENCY

NO

NO

RECEIVABLE CUSTOMER

DELINQUENCY_LD Long description for the delinquency code. VARCHAR2(255)

RECEIVABLE_ACCOUNT

DELINQUENCY_DESC

NO

NO

RECEIVABLE CUSTOMER

DELINQUENCY_SD Short description for the delinquency code. VARCHAR2(255)

RECEIVABLE_ACCOUNT

DELINQUENCY_DESC

NO

NO

RECEIVABLE CUSTOMER

NSF_COUNT Number of non-sufficient funds cheques written by this customer. VARCHAR2(63)

RECEIVABLE_ACCOUNT

NSF_COUNTER

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



Ver: 3.1