Composite View Target: AR_AWARD_BY

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

SGHE Banner Operational Data Store
Composite View Target: AR_AWARD_BY_FUND

Description Source composite view contains each fund with its award information for each time indication.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACCEPT_AMOUNT Amount accepted by the student for the indicated financial aid fund for this aid year. NUMBER
CALCULATION

SUM(RPRAWRD_ACCEPT_AMT)

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

RPRAWRD_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)
ROBINST

ROBINST_AIDY_DESC

AUTHORIZED_AMOUNT Authorized amount of financial aid for this fund. NUMBER
CALCULATION

SUM(RPRAWRD_AUTHORIZE_AMT)

CANCEL_AMOUNT Total amount of this fund that was offered and or accepted by the student's and then canceled. NUMBER
CALCULATION

SUM(RPRAWRD_CANCEL_AMT)

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

SYSDATE

DECLINE_AMOUNT Total amount of this fund declined by the student's for this aid year. NUMBER
CALCULATION

SUM(RPRAWRD_DECLINE_AMT)

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

NA

FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)
RPRAWRD

RPRAWRD_FUND_CODE

FUND_TITLE Full title of the financial aid fund code. VARCHAR2(30)
RFRBASE

RFRBASE_FUND_TITLE

MEMO_AMOUNT Displays the amount of the memo'd award. NUMBER
CALCULATION

SUM(RPRAWRD_MEMO_AMT)

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

NA

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

NA

OFFER_AMOUNT Displays the amount of the current award offer. NUMBER
CALCULATION

SUM(RPRAWRD_OFFER_AMT)

PAID_AMOUNT Amount of the award that was actually disbursed. NUMBER
CALCULATION

SUM(RPRAWRD_PAID_AMT)

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

NA

Ver:

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACCEPT_AMOUNT		Amount accepted by the student for the indicated financial aid fund for this aid year.	NUMBER	CALCULATION	SUM(RPRAWRD_ACCEPT_AMT)
AID_YEAR	Financial Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)	RPRAWRD	RPRAWRD_AIDY_CODE
AID_YEAR_DESC		Financial aid year name.	VARCHAR2(30)	ROBINST	ROBINST_AIDY_DESC
AUTHORIZED_AMOUNT		Authorized amount of financial aid for this fund.	NUMBER	CALCULATION	SUM(RPRAWRD_AUTHORIZE_AMT)
CANCEL_AMOUNT		Total amount of this fund that was offered and or accepted by the student's and then canceled.	NUMBER	CALCULATION	SUM(RPRAWRD_CANCEL_AMT)
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DECLINE_AMOUNT		Total amount of this fund declined by the student's for this aid year.	NUMBER	CALCULATION	SUM(RPRAWRD_DECLINE_AMT)
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
FUND		Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	RPRAWRD	RPRAWRD_FUND_CODE
FUND_TITLE		Full title of the financial aid fund code.	VARCHAR2(30)	RFRBASE	RFRBASE_FUND_TITLE
MEMO_AMOUNT		Displays the amount of the memo'd award.	NUMBER	CALCULATION	SUM(RPRAWRD_MEMO_AMT)
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
OFFER_AMOUNT		Displays the amount of the current award offer.	NUMBER	CALCULATION	SUM(RPRAWRD_OFFER_AMT)
PAID_AMOUNT		Amount of the award that was actually disbursed.	NUMBER	CALCULATION	SUM(RPRAWRD_PAID_AMT)
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA