Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: APPLICANT_NEED

Description 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.
Key & Frequency One row per person per aid year.
Recommended Search Columns AID_YEAR, PERSON_UID
PERSON_UID

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_PERIOD Aid Period Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc. VARCHAR2(63)

RORSTAT

RORSTAT_APRD_CODE

AID_PERIOD_DESC Aid Period Description Financial Aid period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

AID_YEAR Aid Year Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

RORSTAT

RORSTAT_AIDY_CODE

AID_YEAR_DESC Aid Year Description Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COST_OF_EDUCATION Cost Of Education Total cost of education used in the applicant's need calculation. NUMBER

FUNCTION

RNKNEED.F_CALC_BUDGET_AMT

FM_COST_OF_EDUCATION Federal Method Cost Of Education Student''s federal method cost of attendance used in the applicant''s need calculation. NUMBER

FUNCTION

RNKNEED.F_CALC_BUDGET_AMT (RORSTAT_PIDM, RORSTAT_AIDY_CODE, 'F')

FM_GROSS_NEED Fm Gross Need Gross need of the applicant defined as budget minus total family contribution. NUMBER

FUNCTION

RNKNEED.F_CALC_NEED_DATA

FM_TFC Fm Tfc Primary family contribution total family contribution. NUMBER

FUNCTION

RNKNEED.F_CALC_EFC

FM_UNMET_NEED Fm Unmet Need Student's unmet need that is the gross need minus any awards. NUMBER

FUNCTION

RNKNEED.F_CALC_NEED_DATA

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IM_COST_OF_EDUCATION Institution Method Cost Of Education Student''s institutional method cost of attendance used in the applicant''s need calculation. NUMBER

CALCULATION

DECODE (MRVAND0_EFC_IND, 'F', '', RNKNEED.F_CALC_BUDGET_AMT (MRVAND0_PIDM, MRVAND0_AIDY_CODE, 'I')), '999999999D99')

IM_GROSS_NEED Im Gross Need Gross need based on institutional methodology. NUMBER

FUNCTION

RNKNEED.F_CALC_NEED_DATA

IM_TFC Im Tfc Total family contribution based on institutional methodology. NUMBER

FUNCTION

RNKNEED.F_CALC_IM_TFC

IM_UNMET_NEED Im Unmet Need Unmet need based on institutional methodology. NUMBER

FUNCTION

RNKNEED.F_CALC_NEED_DATA

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER

RORSTAT

RORSTAT_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

RESOURCE_AMOUNT Resource Amount Total amount of outside resources used in the applicant's need calculation. NUMBER

FUNCTION

RNKNEED.F_CALC_RESOURCE

TOTAL_OFFER_AMOUNT Total Offer Amount Total amount of offers used in the applicant's need calculation. NUMBER

FUNCTION

F_CALC_TOTAL_OFFER



Ver: 9.2