RETURN TO FACT TABLE REPORTS LIST
Receivable Revenue Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_RECEIVABLE_REVENUE

Description Receivable Revenue 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 chart, fund, organization, account and program per time frame.

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



Ver: 3.1