RETURN TO EDW META DATA REPORTS LIST


Receivable Customer Star Report

Target Reports:

WDT_ACADEMIC_STUDY - Academic Study Dimension
Academic Study Dimension table provides information for the program of study for the individual. This may be the data on the admission application or the academic outcome record that identifies the major subject area and sought award or degree, etc.. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_ACCOUNTS_RECEIVABLE - Accounts Receivable Dimension
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.
WDT_CUSTOMER - Customer Dimension
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.
WDT_MULTI_SOURCE - Multi Source Dimension
Multi Source Dimension table provides an institution source value when the optional multi-source feature has been applied. Institution source VALUES have a short and long description. Data in this dimension may optionally include a process-oriented identifier and an administrative-oriented identifier for the record used to determine access authorization to this record. The cleansing rules are used in the EDW for the short and long descriptions.One row per multi_source per process group per admistrative group.
WDT_TIME - Time Dimension
Time Dimension table provides information on the time frame for which the rest of the associated dimension and fact table are storing the information in the star. The time dimension may be based either on a calendar, academic, financial aid or fiscal year, The time frame will go down at least one and sometimes two layers to periods and or sub periods of time. It uses the cleansing rules in the EDW for the short and long descriptions.

WFT_RECEIVABLE_CUSTOMER - Receivable Customer Fact Table
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.

Source Reports:

ACADEMIC_STUDY
EDW CLEANSING PROCESS
ETL GENERATED
RECEIVABLE_ACCOUNT
RECEIVABLE_ACCOUNT_DETAIL
RECEIVABLE_SUMMARY
YEAR_TYPE_DEFINITION


Ver: 3.1