Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_APPLICANT_NEED

Description Source composite view contains financial aid applicant need information for an aid year.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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(6)

RORSTAT

RORSTAT_APRD_CODE

NO

NO
AID_PERIOD_DESC Financial Aid period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

RORSTAT

RORSTAT_AIDY_CODE

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

RNKNEED.F_CALC_BUDGET_AMT

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

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

FUNCTION

RNKNEED.F_CALC_NEED_DATA

NO

NO
FM_TFC Primary family contribution total family contribution. NUMBER

FUNCTION

RNKNEED.F_CALC_EFC

NO

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

FUNCTION

RNKNEED.F_CALC_NEED_DATA

NO

NO
IM_COST_OF_EDUCATION   NUMBER       NO
IM_GROSS_NEED Gross need based on institutional methodology. NUMBER

FUNCTION

RNKNEED.F_CALC_NEED_DATA

NO

NO
IM_TFC Total family contribution based on institutional methodology. NUMBER

FUNCTION

RNKNEED.F_CALC_IM_TFC

NO

NO
IM_UNMET_NEED Unmet need based on institutional methodology. NUMBER

FUNCTION

RNKNEED.F_CALC_NEED_DATA

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

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

RORSTAT

RORSTAT_PIDM

NO

NO
RESOURCE_AMOUNT Total amount of outside resources that will be used in the applicant's need calculation. NUMBER

FUNCTION

RNKNEED.F_CALC_RESOURCE

NO

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

FUNCTION

F_CALC_TOTAL_OFFER

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: