RETURN TO ODS META DATA REPORTS LIST


Financial Aid Reporting View Meta Data Reports

Target Reports:

Reporting ViewDescriptionKey & FrequencyRecommended Search Columns
APPLICANT_NEED
Contains detail data for the financial aid applicant's need information by aid year. Details will potentially include data loaded with calculations for total family contributions, gross need, cost of education and unmet need based on either a federal method or an institution method.One row per person per aid year.AID_YEAR, PERSON_UID
PERSON_UID
AWARD_BY_FUND
Contains total amount of aid awarded by financial aid fund within an aid year. Detail data may include the aid year, academic period, financial aid fund, fund source, fund type, fund detail code, and federal financial aid fund identification code.One row per aid year per fund.AID_YEAR, FUND
FUND, AID_YEAR
AWARD_BY_PERSON
Contains detail data for each person who was made an offer of a financial aid fund award within the aid year. Details may includes person, academic period, financial aid fund, fund source, fund type, fund detail code, award status, disbursement finalize indicator and award amount information.One row per person per aid year and per fund.AID_YEAR, PERSON_UID, FUND, ACADEMIC_PERIOD
PERSON_UID, FUND, ACADEMIC_PERIOD
ACADEMIC_PERIOD
AID_YEAR, FUND
FUND
AWARD_DISBURSEMENT
Contains data regarding the award disbursements scheduled or posted for a person by financial aid fund and academic period. Details will include academic period, disbursement ID, disbursed date, scheduled date, disbursed amount, scheduled amount, disbursed percentage and disbursement load. NOTE: the disbursement details do not currently include Loan Disbursement information.One row per person per aid year per disbursement ID or transaction number.PERSON_UID,┐AID_YEAR,┐FUND,┐ACADEMIC_PERIOD
FINAID_APPLICANT_STATUS
Contains data for the aid year and the person who has applied for financial aid for the aid year. Details may includes application locked indicator, budget group, administrative group, packaging group, tracking group, financial aid application status data, and budget type.One row per aid year and person.AID_YEAR, PERSON_UID
PERSON_UID
FINAID_BUDGET_COMPONENT
Contains the budget component details for the person for the budget group assigned for the aid year. Details may include budget type, budget component amount, total budget.One row per aid year per budget type per budget component per budget group per person.AID_YEAR, PERSON_UID, BUDGET_TYPE, BUDGET_COMPONENT
PERSON_UID
FINAID_BUDGET_COMP_SLOT
Uses data from the FINAID_BUDGET_COMPONENT reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of BUDGET COMPS and a delivered or institution defined internal code. Delivered internal codes of FAPLBCMP may be used independently by the institution.One row per person per aid year per profile code per component rule.PERSON_UID, AID_YEAR, BUDGET_TYPE, PROFILE_CODE, COMPONENT_RULE
ACTIVITY_DATE
FINAID_ENROLLMENT
Contains details regarding the person's enrollment information by aid year and academic period that is used as the data for why an award had a financial aid disbursements. Data may include total anticipated credits, total actual credits, total billing credits, total freeze credits, total earned credits and total adjusted credits.One row per aid year per academic period per person.PERSON_UID, ACADEMIC_PERIOD
FINAID_FUND
Contains data regarding a financial aid fund for an aid year. Details may includes fund source, fund type, fund detail code, federal financaial aid fund identification, need based indicator, budget allocated amount, transfer amount, prior balance, total allocated amount, original offered amounts, accepted amount, declined amount, canceled amount, authorized amount and memoed amount.One row per aid year per fund.AID_YEAR, FUND
FUND
FINAID_TRACKING_REQUIREMENT
Contains detail data on the tracking requirements for a financial aid applicant for the aid year. Data may include requirement, satisfied indicator, status, waived reason disbursement requirement indicators and memo indicator, etc.One row per aid year per person per requirement.PERSON_UID, AID_YEAR, REQUIREMENT, FUND
GOVERNMENT_FA_FUND
Contains a set of common data identified for known governmental reporting regarding a financial aid fund. Detail data includes aid year, financial aid source type, financial aid type with reporting group for external or internal.One row per aid year per academic period per financial aid source type per financial aid type per fund.AID_YEAR, FUND
FUND, AID_YEAR
AID_YEAR, FUND, ACADEMIC_PERIOD
GOVERNMENT_FINANCIAL_AID
Contains common data identified for known governmental reporting regarding financial aid students. Detail data may include academic period, student level, financial aid fund title or name, fund source type, financial aid type, offerred amount, accepted amount, declined amount, paid amount, disbursed amount, etc.One row per aid year per academic period per fund per person.AID_YEAR, PERSON_UID, FUND, ACADEMIC_PERIOD
PERSON_UID, FUND, ACADEMIC_PERIOD
ACADEMIC_PERIOD
AID_YEAR, FUND
FUND
PERSON_UID, ACADEMIC_PERIOD
PERSON_UID, COHORT_RULE
PERSON_UID, AID_YEAR, FUND, ACADEMIC_PERIOD
PERSON_UID, STUDENT_LEVEL, ACADEMIC_PERIOD
STUDENT_LEVEL, ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_LEVEL
LOAN_APPLICATION
Contains data from a loan application submitted by a person for an aid year. Detail data may include loan application number, citizen indicator, alien registration number, driver's license number, addresses, phone numbers, and detailed loan data for various loans.One row per aid year per loan application number.PERSON_UID, AID_YEAR, FUND
NEED_ANALYSIS
Contains data usually loaded from a federally supplied electronic media. Detail data will include all data collected regarding student need for the aid year and student. Data may include parental contribution, student contribution, interface tape code, application number, state/province of residence, and other need based data for doing needs analysis either using a federal or institution method of calculation.One row per aid year per person per interface tape code per application number.AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER
AID_YEAR, PERSON_UID, CURRENT_RECORD_IND
PERSON_UID
SATISFACTORY_ACAD_PROGRESS
Contains data on the student's satisfactory academic progress for the aid year as defined by a federal standard for calculation. One row per person per aid year per academic period.PERSON_UID, ACADEMIC_PERIOD
TRACKING_REQUIREMENT_SLOT
Uses data from the FINAID_TRACKING_REQUIREMENT reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of TRACKING REQS and a delivered or institution defined internal code. Delivered internal codes of FAPLTREQ may be used independently by the institution.One row per person per aid year per profile code per requirement rule.PERSON_UID, AID_YEAR, PROFILE_CODE, REQUIREMENT_RULE
ACTIVITY_DATE
USER_DEFINED_FIELDS
Contains the data from the financial aid user-defined fields that may be populated by aid year for the person.One row per aid year per person.AID_YEAR, PERSON_UID
PERSON_UID

Source Reports:

RBBABUD
RBRACMP
RCRAPP1
RCRAPP2
RCRAPP4
RFRASPC
RFRBASE
ROBINST
ROBUSDF
RORENRL
RORSAPR
RORSTAT
RORTPRD
RPRADSB
RPRATRM
RPRAWRD
RPRLAPP
RRRAREQ
RRRTMSG
RTVAPRD
RTVAWST
RTVBTYP
RTVCOMP
RTVFSRC
RTVFTYP
RTVMESG


Ver: 3.1