Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACCEPT_AMOUNT	Amount accepted by the student for the indicated financial aid fund for this aid year.	NUMBER	CALCULATION	SUM(RPRAWRD_ACCEPT_AMT)	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(63)	RPRAWRD	RPRAWRD_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC	NO	NO
AUTHORIZED_AMOUNT	Authorized amount of financial aid for this fund.	NUMBER	CALCULATION	SUM(RPRAWRD_AUTHORIZE_AMT)	NO	NO
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)	NO	NO
DECLINE_AMOUNT	Total amount of this fund declined by the student's for this aid year.	NUMBER	CALCULATION	SUM(RPRAWRD_DECLINE_AMT)	NO	NO
FEDERAL_FUND_ID	Federal fund associated with the fund code.	VARCHAR2(63)	RFRBASE	RFRBASE_FED_FUND_ID	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RPRAWRD	RPRAWRD_FUND_CODE	NO	NO
FUND_DETAIL_CODE	Links a financial aid fund code to an AR detail code for crediting funds to student accounts.	VARCHAR2(63)	RFRBASE	RFRBASE_DETAIL_CODE	NO	NO
FUND_SOURCE	Fund source code to be associated with the fund as defined by the institution.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE	NO	NO
FUND_SOURCE_DESC	Describes the fund source code and identifies what it represents.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC	NO	NO
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(30)	RFRBASE	RFRBASE_FUND_TITLE	NO	NO
FUND_TYPE	Fund type code to be associated with the fund as defined by the institution.	VARCHAR2(63)	RFRBASE	RFRBASE_FTYP_CODE	NO	NO
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(255)	RTVFTYP	RTVFTYP_DESC	NO	NO
GIFT_OR_SELF_HELP_AID	Classification of an award (or fund) based on the financial aid type associated with the fund, with Gift Aid having an aid type of grant or scholarship and Self Help Aid having an aid type of loan or work.	VARCHAR2(63)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)	NO	NO
GIFT_OR_SELF_HELP_AID_DESC	Description of the Gift or Self Help Aid code, where G = Gift Aid and S = Self Help Aid.	VARCHAR2(255)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)	NO	NO
MEMO_AMOUNT	Displays the amount of the memo'd award.	NUMBER	CALCULATION	SUM(RPRAWRD_MEMO_AMT)	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
OFFER_AMOUNT	Displays the amount of the current award offer.	NUMBER	CALCULATION	SUM(RPRAWRD_OFFER_AMT)	NO	NO
PAID_AMOUNT	Displays the amount of the award that was actually disbursed.	NUMBER	CALCULATION	SUM(RPRAWRD_PAID_AMT)	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2