WDT_ACCOUNT - Account Dimension
| Account Dimension table provides information for the hierarchy of the account. This information includes internal account type and account pool information as well as the two account types and four levels that may have been assigned to the account. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_CHART - Chart Dimension
| Chart Dimension table provides information on the chart of accounts. This information is the chart code and descriptions. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_FUND - Fund Dimension
| Fund Dimension table provides information for the hierarchy of the fund. This information includes the fund pool information as well as the two fund types and five levels that may have been assigned to the fund. 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_GENERAL_LEDGER - General Ledger Fact Table
| General Ledger 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 and account per time frame. | | |