Target Column	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	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	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: