Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: RPRAWRD Financial Aid Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: RPRAWRD - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
RPRAWRD_ACCEPT_AMT RPAAWRD

REPORTING VIEW

GOVERNMENT_FA_FUND

AWARD_BY_AID_YEAR

GOVERNMENT_FINANCIAL_AID

TOTAL_ACCEPT_AMOUNT

TOTAL_ACCEPT_AMOUNT

ACCEPT_AMOUNT

NA
RPRAWRD_ACCEPT_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

TOTAL_ACCEPT_DATE

 
RPRAWRD_ACTIVITY_DATE NA        
RPRAWRD_AIDY_CODE NA

REPORTING VIEW

AWARD_BY_AID_YEAR

AWARD_BY_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FINANCIAL_AID

AID_YEAR

AID_YEAR

AID_YEAR

AID_YEAR

NA
RPRAWRD_AUTHORIZE_AMT RPAAPMT SHOWS AS RPRAWRD_MEMAUTH_AMT IN RPAAWRD FORM.

REPORTING VIEW

AWARD_BY_AID_YEAR

ANNUAL_AWARD_AUTHORIZE_AMOUNT

 
RPRAWRD_AUTHORIZE_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

ANNUAL_AWARD_AUTHORIZE_DATE

 
RPRAWRD_AWST_CODE RPAAWRD

REPORTING VIEW

AWARD_BY_AID_YEAR

AWARD_BY_PERSON

AWARD_STATUS

AWARD_STATUS

NA
RPRAWRD_AWST_DATE RPAAWRD

REPORTING VIEW

AWARD_BY_PERSON

AWARD_BY_AID_YEAR

AWARD_STATUS_DATE

AWARD_STATUS_DATE

NA
RPRAWRD_CANCEL_AMT RPAAWRD RPAAWRD ROARMAN

REPORTING VIEW

AWARD_BY_AID_YEAR

ANNUAL_AWARD_CANCEL_AMOUNT

 
RPRAWRD_CANCEL_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

ANNUAL_AWARD_CANCEL_DATE

 
RPRAWRD_DECLINE_AMT RPAAWRD

REPORTING VIEW

GOVERNMENT_FA_FUND

GOVERNMENT_FINANCIAL_AID

AWARD_BY_AID_YEAR

TOTAL_DECLINE_AMOUNT

DECLINE_AMOUNT

TOTAL_DECLINE_AMOUNT

NA
RPRAWRD_DECLINE_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

TOTAL_DECLINE_DATE

 
RPRAWRD_FED_LIMIT_OVRDE_IND TBD

REPORTING VIEW

AWARD_BY_PERSON

AWARD_BY_AID_YEAR

FEDERAL_LIMIT_OVERRIDE_IND

FEDERAL_LIMIT_OVERRIDE_IND

 
RPRAWRD_FUND_CODE RPAAWRD

REPORTING VIEW

AWARD_BY_FUND

AWARD_BY_AID_YEAR

FUND

FUND

NA
RPRAWRD_FUND_LIMIT_OVRDE_IND TBD

REPORTING VIEW

AWARD_BY_PERSON

AWARD_BY_AID_YEAR

FUND_LIMIT_OVERRIDE_IND

FUND_LIMIT_OVERRIDE_IND

 
RPRAWRD_INFO_ACCESS_IND RPAAWRD ROARMAN RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

ANNUAL_AWARD_ACCESS_IND

 
RPRAWRD_LAST_WEB_UPDATE NA

REPORTING VIEW

AWARD_BY_AID_YEAR

ANNUAL_AWARD_LAST_WEB_UPDATE

 
RPRAWRD_LOCK_IND TBD

REPORTING VIEW

AWARD_BY_AID_YEAR

AWARD_BY_PERSON

ANNUAL_AWARD_LOCKED

ANNUAL_AWARD_LOCKED

 
RPRAWRD_MEMO_AMT RPAAPMT SHOWS AS RPRAWRD_MEMAUTH_AMT IN RPAAWRD FORM.

REPORTING VIEW

AWARD_BY_AID_YEAR

ANNUAL_AWARD_MEMO_AMOUNT

 
RPRAWRD_MEMO_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

ANNUAL_AWARD_MEMO_DATE

 
RPRAWRD_OFFER_AMT RPAAWRD

REPORTING VIEW

AWARD_BY_AID_YEAR

GOVERNMENT_FINANCIAL_AID

OFFER_AMOUNT

OFFER_AMOUNT

NA
RPRAWRD_OFFER_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

OFFER_DATE

 
RPRAWRD_OFFER_EXP_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

AWARD_OFFER_EXPIRATION_DATE

 
RPRAWRD_ORIG_OFFER_AMT RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

GOVERNMENT_FA_FUND

TOTAL_OFFER_AMOUNT

TOTAL_OFFER_AMOUNT

NA
RPRAWRD_ORIG_OFFER_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

TOTAL_ORIGINAL_OFFER_DATE

 
RPRAWRD_OVERRIDE_NO_PELL TBD

REPORTING VIEW

AWARD_BY_PERSON

AWARD_BY_AID_YEAR

NO_PELL_OVERRIDE_IND

NO_PELL_OVERRIDE_IND

 
RPRAWRD_OVERRIDE_YR_IN_COLL TBD

REPORTING VIEW

AWARD_BY_AID_YEAR

AWARD_BY_PERSON

ACADEMIC_YEAR_OVERRIDE

ACADEMIC_YEAR_OVERRIDE

 
RPRAWRD_PAID_AMT RPAAWRD

REPORTING VIEW

GOVERNMENT_FA_FUND

AWARD_BY_AID_YEAR

GOVERNMENT_FINANCIAL_AID

TOTAL_PAID_AMOUNT

TOTAL_PAID_AMOUNT

PAID_AMOUNT

NA
RPRAWRD_PAID_DATE RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

TOTAL_PAID_DATE

 
RPRAWRD_PIDM RPAAWRD RPAAPMT

REPORTING VIEW

AWARD_BY_AID_YEAR

PERSON_UID

 
RPRAWRD_REPLACE_TFC_OVRDE_IND TBD

REPORTING VIEW

AWARD_BY_PERSON

AWARD_BY_AID_YEAR

REPLACE_TFC_OVERRIDE_IND

REPLACE_TFC_OVERRIDE_IND

 
RPRAWRD_SYS_IND TBD

REPORTING VIEW

AWARD_BY_PERSON

AWARD_BY_AID_YEAR

SYSTEM

SYSTEM_IND

 
RPRAWRD_TREQ_OVRDE_IND TBD

REPORTING VIEW

AWARD_BY_AID_YEAR

AWARD_BY_PERSON

TRACKING_REQ_OVERRIDE_IND

TRACKING_REQ_OVERRIDE_IND

 
RPRAWRD_UNMET_NEED_OVRDE_IND TBD

REPORTING VIEW

AWARD_BY_AID_YEAR

AWARD_BY_PERSON

UNMET_NEED_OVERRIDE

UNMET_NEED_OVERRIDE

 
RPRAWRD_USER_ID NA

REPORTING VIEW

AWARD_BY_AID_YEAR

USER_ID

 


Ver: 8.0