Go To View:  RETURN TO BANNER 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
APPLICANT_PERIOD_STATUS
Contains expected enrollment status and if the period is locked or frozen for the student by aid enrollment period.One row per person per aid enrollment period.PERSON_UID,AID_ENROLLMENT_PERIOD
EXPECTED_ENROLL_STATUS
PERSON_UID,AID_YEAR,AID_PERIOD,AID_ENROLLMENT_PERIOD
APPLICANT_RESOURCE
Contains Financial Aid resource information and amounts available to financial aid applicants.One row per aid year per person per resource type per resource number.AID_YEAR, PERSON_UID, RESOURCE_TYPE, RESOURCE_NUMBER
AID_YEAR, APPLICANT_RESOURCE
AWARD_BY_AID_YEAR
Contains detail data for each person who was made an offer of financial aid within the aid year.One row per person per aid year per fund.PERSON_UID, AID_YEAR, FUND
FUND, AID_YEAR
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.FUND, AID_YEAR
AID_YEAR, FUND_SOURCE
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, aid enrollment period, financial aid fund, fund source, fund type, fund detail code, award status, disbursement finalize indicator and award amount information. Also the accounts receivable and student academic periods.One row per person per aid year and per fund.PERSON_UID, FUND, AID_ENROLLMENT_PERIOD
AID_ENROLLMENT_PERIOD
PERSON_UID, FUND, ACADEMIC_PERIOD
ACADEMIC_PERIOD
AID_YEAR, FUND_SOURCE
FUND, AID_YEAR
AWARD_DISBURSEMENT
Contains data regarding the award disbursements scheduled or posted for a person by financial aid fund and aid enrollment period. Details will include aid enrollment period, student academic period, accounts receivable 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, AID_ENROLLMENT_PERIOD
AID_YEAR, FUND, AID_ENROLLMENT_PERIOD
PERSON_UID, AID_YEAR, FUND, ACADEMIC_PERIOD
AID_YEAR, FUND, ACADEMIC_PERIOD
DIRECT_LOAN_SUB_USAGE
Contains Direct loan subsidized usageOne row per person per aid year per loan id per sequence number.PERSON_UID,AID_YEAR,LOAN_ID,SEQUENCE_NUMBER
DOCUMENT_ID
PERSON_UID,AID_YEAR,LOAN_ID,SEQUENCE_NUMBER,CREATE_DATE
FINAID_APPLICANT_STATUS
Contains data for the aid year and the person who has applied for financial aid for the aid year. The person may have submitted either or both a federal and institutional application for financial aid. Optionally the person may have the financial aid status record created without an application because of some other institutional process that required it to be created. Details may include 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
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 aid enrollment period per budget type per profile code per component rule.PERSON_UID,��AID_YEAR,AID_ENROLLMENT_PERIOD,BUDGET_TYPE,PROFILE_CODE,COMPONENT_RULE
ACTIVITY_DATE
FINAID_COMMENTS
Contains comments associated with a financial aid applicant.One row per person per sequence number.PERSON_UID, COMMENT_SEQUENCE_NUMBER
AID_YEAR, COMMENT_CATEGORY
FINAID_ENROLLMENT
Contains details regarding the person's enrollment information by aid year, academic period, and finanical aid enrollment rule that is used as the data for why an award had financial aid disbursement. 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 finaid enrollment rule per personPERSON_UID, ACADEMIC_PERIOD
AID_YEAR, ACADEMIC_PERIOD
FINAID_FUND
Contains data regarding a financial aid fund for an aid year. Details may include fund source, fund type, fund detail code, federal financial 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_SOURCE
FUND, AID_YEAR
FINAID_HOLD
Contains all of the financial aid holds (restrictions) for a person.One row per person per hold from date per hold to date.PERSON_UID
HOLD_USER_CREATOR
HOLD_FROM_DATE, HOLD_TO_DATE
HOLD_PACKAGING_IND
HOLD_MEMO_IND
HOLD_DISBURSEMENT_IND
HOLD, HOLD_FROM_DATE, HOLD_TO_DATE
FINAID_MESSAGE
Contains message information provided to financial aid applicants.One row per Aid Year per person per message code.AID_YEAR, PERSON_UID, MESSAGE, MESSAGE_SHORT_DESCRIPTION
AID_YEAR, MESSAGE
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
AID_YEAR, REQUIREMENT, FUND
FUND_MESSAGE_RULE
Contains information that displays the links between financial aid messages and specific funds and then displays the related messages provided to financial aid applicants.One row per aid year per fund per message per pidm.AID_YEAR, FUND, MESSAGE, COMMUNICATION
AID_YEAR, MESSAGE
AID_YEAR, COMMUNICATION
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.FUND, AID_YEAR
AID_YEAR
GOVERNMENT_FINANCIAL_AID
Contains common data identified for known governmental reporting regarding financial aid students. Detail data may include aid enrollment period, accounts receivable academic period, student academic period, student level, financial aid fund title or name, fund source type, financial aid type, offered amount, accepted amount, declined amount, paid amount, disbursed amount, etc.One row per aid year per aid enrollment period per fund per person.PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
PERSON_UID, FUND, AID_ENROLLMENT_PERIOD
AID_ENROLLMENT_PERIOD
PERSON_UID, FUND, ACADEMIC_PERIOD
AID_YEAR
FUND, AID_YEAR
PERSON_UID, ACADEMIC_PERIOD, COHORT_RULE
LOAN_AGGREGATES
Contains information received from the National Student Loan Data System (NSLDS) such as NSLDS summary and name information, and the Stafford, Direct, and Perkins loan aggregate and history information.One row per aid year, per person, per interface data code, per sequence number.AID_YEAR, PERSON_UID, CURRENT_RECORD_IND
AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, SEQUENCE_NUMBER
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.AID_YEAR, FUND
PERSON_UID, FUND
LOAN_DISBURSEMENT
The Loan Disbursement by aid enrollment period contains detail data for loan disbursements that were made within the aid enrollment period. Details may include person and person address; loan fund code and description; loan period and description; loan application number; aid enrollment period, accounts receivable term recommended, student academic period, expected and approved loan amount; loan status code; term disbursement date, sequence number, reference number, check number and amount; feed indicator; disbursement load; loan fee amounts; and disbursement rejects and edit fields.One row per person per aid enrollment period per fund per application number per disbursement date per disbursement.PERSON_UID, FUND, APPLICATION_NUMBER, AID_ENROLLMENT_PERIOD, SCHEDULED_DATE, DISBURSEMENT_SEQUENCE_NUMBER
PERSON_UID, AID_ENROLLMENT_PERIOD, FUND, APPLICATION_NUMBER
PERSON_UID, FUND, APPLICATION_NUMBER, ACADEMIC_PERIOD, SCHEDULED_DATE, DISBURSEMENT_SEQUENCE_NUMBER
AID_YEAR, FUND
LOAN_DISBURSEMENT_DETAIL
Contains loan disbursement detailsOne row per person per loan application no per disbursement number per disbursement sequence number per reconciliation batch number.PERSON_UID,LOAN_APPLICATION_NO,DISBURSEMENT_NUMBER,DISBURSEMENT_SEQUENCE_NUMBER,RECONCILIATION_BATCH_NUMBER
DL_LOAN_ID
PERSON_UID,LOAN_APPLICATION_NO,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 need 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, CURRENT_RECORD_IND PERSON_UID
NEED_ANALYSIS_DEMOGRAPHIC
Contains demographic information about the student and parents from the financial aid application. Also contains information specific to the financial aid application itself.One row per Aid Year per Person per Interface Tape Code per Application Number.AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND
NEED_ANALYSIS_FEDERAL_METHOD
Contains information specific to the federal methodology for computing applicant need.One row per Aid Year per Person per Interface Tape Code per Application Number.AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND
NEED_ANALYSIS_INST_METHOD
Contains information specific to the institutional methodology of computing applicant need.One row per Aid Year per Person per Interface Tape Code per Application Number.AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND
NEED_ANALYSIS_ISIR_SPECIFIC
Contains need analysis data specific to the Institutional Student Information Report.One row per Aid Year per Person per Interface Tape Code per Application Number.AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND
NEED_ANALYSIS_OVERRIDE
Descriptive text about the reporting view or composite table, fact or dimension table. This is used by the technical writer to pull into documentation as the Description for the view.One row per Aid Year per Person.AID_YEAR, PERSON_UID
NEED_ANALYSIS_PROFILE_SPECIFIC
Additional Institutional Methodology Data.One row per Aid Year per Person per Interface Tape Code per Application Number.AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND
NON_YEAR_USER_DEFINED_FIELDS
Contains the data from the financial aid user-defined fields that may be populated for the person without an aid year.One row per person.PERSON_UID
PERIOD_BUDGET_COMPONENT
Contains the budget component details for the person for the budget group assigned for the aid year and aid enrollmentn period. Details may include budget type, budget component amount, total budget.One row per aid year per period per budget type per budget component per budget group per person.AID_YEAR,PERSON_UID,AID_ENROLLMENT_PERIOD,BUDGET_TYPE,BUDGET_COMPONENT
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
STUDENT_SUB_USAGE_LIMIT
Contains Student subsidized usage limitOne row per person per aid year per sequence number.PERSON_UID,AID_YEAR,SEQUENCE_NUMBER
DOCUMENT_ID
PERSON_UID,AID_YEAR,SEQUENCE_NUMBER,CREATE_DATE
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:

CALCULATION
DLRDLOR
FUNCTION
NA
RBBABUD
RBRACMP
RBRAPBC
RBRAPBG
RBRPBCP
RBRPBGP
RBRPBTP
RCRAPP1
RCRAPP2
RCRAPP3
RCRAPP4
RCRESAR
RCRHOME
RCRIMP1
RCRIRSF
RCRLDS4
RCRLOAD
RCRSARI
RCRTRUS
RERCDED
RERCODA
RERCODS
RFRASPC
RFRBASE
RFRMESG
RHRCOMM
RLRCBID
RLRDBOR
RLRDDAS
RLRDLBN
RLRDLDB
RLRDLDD
RLRDLOR
RLRDMPN
RLRPAPP
RLRPLUS
RNROVRD
ROBBBAY
ROBINST
ROBNYUD
ROBPRDS
ROBUSDF
ROIAIDY
RORENRL
RORHOLD
RORMESG
RORMVAL
RORNYVD
RORPRDS
RORPRST
RORSAPR
RORSTAT
RORTPRD
RORUSER
RPBLPRD
RPRADSB
RPRARSC
RPRATRM
RPRAWRD
RPRDLPS
RPRDLSU
RPRLADB
RPRLAPP
RPRLATR
RPRSULA
RRRAREQ
RRRTMSG
RTVABRC
RTVAPRD
RTVARSC
RTVAWST
RTVBBTP
RTVBGRP
RTVBTYP
RTVCCOM
RTVCOMP
RTVENRR
RTVFSRC
RTVFTYP
RTVHOLD
RTVINFC
RTVLNST
RTVMESG
RTVPBCP
RTVPBGP
RTVPBTP
RTVPGRP
RTVRJCT
RTVSAYR
RTVTGRP
STVEPSC
STVNATN
STVSTAT
STVTERM


Ver: 9.2