RETURN TO DIMENSION TABLE REPORTS LIST
Receivable Customer Star Receivable Revenue Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ACCOUNTS_RECEIVABLE

Description Accounts Receivable Dimension table provides information for the accounts receivable details. This information includes detail and category codes, and bill and effective date ranges for aging. It uses the cleansing rules in the EDW for the short and long descriptions and to assign the date ranges to a number of days.

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 CUSTOMER, RECEIVABLE REVENUE

BILL_DATE_AGING Date used for aging the details on the receivable account that specifies when the detail was billed to the person or entity. VARCHAR2(63)

RECEIVABLE_ACCOUNT_DETAIL

BILL_DATE_AGING

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

BILL_DATE_AGING_LD Long description for the bill date aging. VARCHAR2(255)

RECEIVABLE_ACCOUNT_DETAIL

BILL_DATE_AGING_DESC

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

BILL_DATE_AGING_SD Short description for the bill date aging. VARCHAR2(255)

RECEIVABLE_ACCOUNT_DETAIL

BILL_DATE_AGING_DESC

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

CATEGORY Category used to group types of detail code transactions for reporting. For example, registration tuition and fees, deposits, contracts, etc.. VARCHAR2(63)

RECEIVABLE_ACCOUNT_DETAIL

CATEGORY

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

CATEGORY_LD Long description for the category code. VARCHAR2(255)

RECEIVABLE_ACCOUNT_DETAIL

CATEGORY_DESC

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

CATEGORY_SD Short description for the category code. VARCHAR2(255)

RECEIVABLE_ACCOUNT_DETAIL

CATEGORY_DESC

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

DETAIL_CODE Identifier for every charge or payment recorded on a receivable account. VARCHAR2(63)

RECEIVABLE_ACCOUNT_DETAIL

DETAIL_CODE

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

DETAIL_CODE_LD Long text description for the detail code that describes the charge or payment. VARCHAR2(255)

RECEIVABLE_ACCOUNT_DETAIL

DETAIL_CODE_DESC

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

DETAIL_CODE_SD Short text description for the detail code that describes the charge or payment. VARCHAR2(255)

RECEIVABLE_ACCOUNT_DETAIL

DETAIL_CODE_DESC

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

EFFECTIVE_DATE_AGING Date used for aging the details on the receivable account that specifies when the detail was entered as effective for billing purposes. VARCHAR2(63)

RECEIVABLE_ACCOUNT_DETAIL

EFFECTIVE_DATE_AGING

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

EFFECTIVE_DATE_AGING_LD Long description for the effective date aging. VARCHAR2(255)

RECEIVABLE_ACCOUNT_DETAIL

EFFECTIVE_DATE_AGING_DESC

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

EFFECTIVE_DATE_AGING_SD Short description for the effective date aging. VARCHAR2(255)

RECEIVABLE_ACCOUNT_DETAIL

EFFECTIVE_DATE_AGING_DESC

NO

NO

RECEIVABLE CUSTOMER, 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 CUSTOMER, RECEIVABLE REVENUE

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE



Ver: 3.1