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

SGHE 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD Academic period representing the accounts receivable term for disbursement.    

FUNCTION

MRKFUNC.F_GET_ACADEMIC_PERIOD

 
ACADEMIC_PERIOD_DESC Academic period description.    

FUNCTION

MRKFUNC.F_GET_ACADEMIC_PERIOD

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.    

RORSTAT

RORSTAT_APRD_CODE

 
AID_PERIOD_DESC Financial Aid period description.    

FUNCTION

GOKODSF.F_GET_DESC

 
AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).    

RORSTAT

RORSTAT_AIDY_CODE

 
AID_YEAR_DESC Financial aid year name.    

FUNCTION

GOKODSF.F_GET_DESC

 
COST_OF_EDUCATION Total cost of education used in the applicant's need calculation.    

FUNCTION

RNKNEED.F_CALC_BUDGET_AMT

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

FUNCTION

RNKNEED.F_CALC_NEED_DATA

 
FM_TFC Primary family contribution total family contribution.    

FUNCTION

RNKNEED.F_CALC_EFC

 
FM_UNMET_NEED Student's unmet need that is the gross need minus any awards.    

FUNCTION

RNKNEED.F_CALC_NEED_DATA

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
IM_GROSS_NEED Gross need based on institutional methodology.    

FUNCTION

RNKNEED.F_CALC_NEED_DATA

 
IM_TFC Total family contribution based on institutional methodology.    

FUNCTION

RNKNEED.F_CALC_IM_TFC

 
IM_UNMET_NEED Unmet need based on institutional methodology.    

FUNCTION

RNKNEED.F_CALC_NEED_DATA

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

RORSTAT

RORSTAT_PIDM

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

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

FUNCTION

RNKNEED.F_CALC_RESOURCE

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

FUNCTION

F_CALC_TOTAL_OFFER

 


Ver: 8.3