RETURN TO BANNER EDW META DATA REPORTS LIST


Financial Aid Award By Aid Year 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 graduate 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_FUND_STATUS - Financial Aid Fund Status Dimension
The Financial Aid Fund Status Dimension table provides information on the financial aid fund stage of processing. This information includes award offered, accepted, declined, canceled and paid indicators.
WDT_FINANCIAL_AID_STATUS - Financial Aid Status Dimension
The Financial Aid Status Dimension table provides information on the applicant's financial aid status. This information includes award offered, accepted, declined, canceled and paid indicators.
WDT_FINANCIAL_AID_YEAR - Financial Aid Year Dimension
The Financial Aid Year dimension provides information on the financial aid year. 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 information on the source(s) of information. This information is the multi-source code and its descriptions along with the process group and administrative group.
WDT_PERSON - Person Dimension
Person Dimension table provides information on an individual.

WFT_FINAID_AWARD_AID_YEAR - Finaid Award Aid Year Fact Table
Financial Aid Award fact table provides information about the financial aid awards for the financial aid applicant for the aid year. This information includes the amount and date by processing status for the award (offered, accepted, declined, canceled, authorized, memo, paid).

Source Reports:

AWARD_BY_AID_YEAR
CALCULATION
CALCULATION
CALCULATION
EDW CLEANSING PROCESS
ETL GENERATED
ETL GENERATED
ETL_GENERATED
FINAID_FUND
FUNCTION
FUNCTION
FUNCTION
PERSON
PERSON
PERSON
PERSON
PERSON_SENSITIVE_RACE
STUDENT
TELEPHONE
VISA


Ver: 9.0