Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACCEPT_AMOUNT
|
Accept Amount
|
Amount accepted by the student for the indicated financial aid fund for this aid year.
|
NUMBER
|
CALCULATION
|
SUM(RPRAWRD_ACCEPT_AMT)
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
AID_YEAR
|
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
|
AID_YEAR_DESC
|
Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
ROBINST
|
ROBINST_AIDY_DESC
|
AUTHORIZED_AMOUNT
|
Authorized Amount
|
Authorized amount of financial aid for this fund.
|
NUMBER
|
CALCULATION
|
SUM(RPRAWRD_AUTHORIZE_AMT)
|
CANCEL_AMOUNT
|
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)
|
DECLINE_AMOUNT
|
Decline Amount
|
Total amount of this fund declined by the student's for this aid year.
|
NUMBER
|
CALCULATION
|
SUM(RPRAWRD_DECLINE_AMT)
|
FEDERAL_FUND_ID
|
Federal Fund ID
|
Federal fund associated with the fund code.
|
VARCHAR2(63)
|
RFRBASE
|
RFRBASE_FED_FUND_ID
|
FUND
|
Fund
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
RPRAWRD
|
RPRAWRD_FUND_CODE
|
FUND_DETAIL_CODE
|
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
|
FUND_SOURCE
|
Fund Source
|
Fund source code to be associated with the fund as defined by the institution.
|
VARCHAR2(63)
|
RFRBASE
|
RFRBASE_FSRC_CODE
|
FUND_SOURCE_DESC
|
Fund Source Description
|
Describes the fund source code and identifies what it represents.
|
VARCHAR2(255)
|
RTVFSRC
|
RTVFSRC_DESC
|
FUND_TITLE
|
Fund Title
|
Full title of the financial aid fund code.
|
VARCHAR2(30)
|
RFRBASE
|
RFRBASE_FUND_TITLE
|
FUND_TYPE
|
Fund Type
|
Fund type code to be associated with the fund as defined by the institution.
|
VARCHAR2(63)
|
RFRBASE
|
RFRBASE_FTYP_CODE
|
FUND_TYPE_DESC
|
Fund Type Description
|
Fund type code description or title.
|
VARCHAR2(255)
|
RTVFTYP
|
RTVFTYP_DESC
|
GIFT_OR_SELF_HELP_AID
|
Gift or Self Help Aid Indicator
|
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)
|
GIFT_OR_SELF_HELP_AID_DESC
|
Gift or Self Help Aid Indicator Description
|
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)
|
MEMO_AMOUNT
|
Memo Amount
|
Displays the amount of the memo'd award.
|
NUMBER
|
CALCULATION
|
SUM(RPRAWRD_MEMO_AMT)
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
OFFER_AMOUNT
|
Offer Amount
|
Displays the amount of the current award offer.
|
NUMBER
|
CALCULATION
|
SUM(RPRAWRD_OFFER_AMT)
|
PAID_AMOUNT
|
Paid Amount
|
Displays the amount of the award that was actually disbursed.
|
NUMBER
|
CALCULATION
|
SUM(RPRAWRD_PAID_AMT)
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|