RETURN TO EDW META DATA REPORTS LIST


Financial Aid Pre-Student Star Report

Target Reports:

WDT_DEMOGRAPHIC - Demographic Dimension
Demographic Dimension table provides information for the person that is consistent whether this is an employee, inquirer, applicant, student or graduand at the institution. This information includes gender, ethnicity, age range and family income range. It uses the cleansing rules in the EDW for the short and long descriptions as well as the definition of the ranges in this dimension.
WDT_FINANCIAL_AID_FUND - Financial Aid Fund Dimension
Financial Aid Fund Dimension table provides information about the financial aid fund. This information includes name of the fund, type and source of fund that will identify if the funds are considered grant, scholarship, and loan or work as well as if the funds are federal, institutional or other. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_FINANCIAL_AID_STATUS - Financial Aid Status Dimension
Financial Aid Status Dimension table provides information on the processing steps completed for financial aid. This information includes award offered, accepted, declined or canceled and paid. 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_PRE_STUDENT_STATUS - Pre Student Status Dimension
Pre-Student Status Dimension table provides information on the processing steps completed for those applying to study at the institution. This information includes inquired, applied, admitted, accepted and enrolled. 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_FINANCIAL_AID_PRE_STUDENT - Financial Aid Pre Student Fact Table
Financial Aid Pre-student 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 person per time frame. This is NOT one per inquiry or application record rather one per person. Financial Aid Status and Pre-student Status indicators are the highest value for any inquiry or application in the time frame.

Source Reports:

ADMISSIONS_APPLICATION
AWARD_BY_PERSON
EDW CLEANSING PROCESS
ETL GENERATED
FINAID_FUND
NEED_ANALYSIS
PERSON
YEAR_TYPE_DEFINITION


Ver: 3.1