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_FINANCE_ACTIVITY - Finance Activity Dimension
| Finance Activity Dimension table provides information for the activity codes defined by the institution. This information includes activity code and description. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_FINANCE_LOCATION - Finance Location Dimension
| Finance Location Dimension table provides information for the location codes defined by the institution. This information includes location code and description as well as the hierarchy levels for the location codes. 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_ORGANIZATION - Organization Dimension
| Organization Dimension table provides information for the hierarchy of the organization. This information includes the organization pool information as well as the eight levels that may have been assigned to the organization. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_PROGRAM - Program Dimension
| Program Dimension table provides information for the hierarchy of the program. This information includes the five levels that may have been assigned to the program. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
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_OPERATING_LEDGER - Operating Ledger Fact Table
| Operating 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. | | |