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

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

AR_AWARD_BY_AID_YEAR

TOTAL_ACCEPT_AMOUNT

NA
RPRAWRD_ACCEPT_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

TOTAL_ACCEPT_DATE

 
RPRAWRD_ACTIVITY_DATE NA COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ACTIVITY_DATE

 
RPRAWRD_AIDY_CODE NA COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

AR_AWARD_BY_FUND

AID_YEAR

AID_YEAR

NA
RPRAWRD_AUTHORIZE_AMT RPAAPMT SHOWS AS RPRAWRD_MEMAUTH_AMT IN RPAAWRD FORM. COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_AUTHORIZE_AMOUNT

 
RPRAWRD_AUTHORIZE_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_AUTHORIZE_DATE

 
RPRAWRD_AWST_CODE RPAAWRD COMPOSITE VIEW

AR_AWARD_BY_PERSON

AR_AWARD_BY_AID_YEAR

AWARD_STATUS

AWARD_STATUS

NA
RPRAWRD_AWST_DATE RPAAWRD COMPOSITE VIEW

AR_AWARD_BY_PERSON

AR_AWARD_BY_AID_YEAR

AWARD_STATUS_DATE

AWARD_STATUS_DATE

NA
RPRAWRD_CANCEL_AMT RPAAWRD RPAAWRD ROARMAN COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_CANCEL_AMOUNT

 
RPRAWRD_CANCEL_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_CANCEL_DATE

 
RPRAWRD_DECLINE_AMT RPAAWRD COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

TOTAL_DECLINE_AMOUNT

NA
RPRAWRD_DECLINE_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

TOTAL_DECLINE_DATE

 
RPRAWRD_FED_LIMIT_OVRDE_IND TBD COMPOSITE VIEW

AR_AWARD_BY_PERSON

AR_AWARD_BY_AID_YEAR

FEDERAL_LIMIT_OVERRIDE_IND

FEDERAL_LIMIT_OVERRIDE_IND

 
RPRAWRD_FUND_CODE RPAAWRD COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

AR_AWARD_BY_FUND

FUND

FUND

NA
RPRAWRD_FUND_LIMIT_OVRDE_IND TBD COMPOSITE VIEW

AR_AWARD_BY_PERSON

AR_AWARD_BY_AID_YEAR

FUND_LIMIT_OVERRIDE_IND

FUND_LIMIT_OVERRIDE_IND

 
RPRAWRD_INFO_ACCESS_IND RPAAWRD ROARMAN RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_ACCESS_IND

 
RPRAWRD_LAST_WEB_UPDATE NA COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_LAST_WEB_UPDATE

 
RPRAWRD_LOCK_IND TBD COMPOSITE VIEW

AR_AWARD_BY_PERSON

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_LOCKED

ANNUAL_AWARD_LOCKED

 
RPRAWRD_MEMO_AMT RPAAPMT SHOWS AS RPRAWRD_MEMAUTH_AMT IN RPAAWRD FORM. COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_MEMO_AMOUNT

 
RPRAWRD_MEMO_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

ANNUAL_AWARD_MEMO_DATE

 
RPRAWRD_OFFER_AMT RPAAWRD COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

OFFER_AMOUNT

NA
RPRAWRD_OFFER_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

OFFER_DATE

 
RPRAWRD_OFFER_EXP_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

AWARD_OFFER_EXPIRATION_DATE

 
RPRAWRD_ORIG_OFFER_AMT RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

TOTAL_OFFER_AMOUNT

NA
RPRAWRD_ORIG_OFFER_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

TOTAL_ORIGINAL_OFFER_DATE

 
RPRAWRD_OVERRIDE_NO_PELL TBD COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

AR_AWARD_BY_PERSON

NO_PELL_OVERRIDE_IND

NO_PELL_OVERRIDE_IND

 
RPRAWRD_OVERRIDE_YR_IN_COLL TBD COMPOSITE VIEW

AR_AWARD_BY_PERSON

AR_AWARD_BY_AID_YEAR

ACADEMIC_YEAR_OVERRIDE

ACADEMIC_YEAR_OVERRIDE

 
RPRAWRD_PAID_AMT RPAAWRD COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

TOTAL_PAID_AMOUNT

NA
RPRAWRD_PAID_DATE RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

TOTAL_PAID_DATE

 
RPRAWRD_PIDM RPAAWRD RPAAPMT COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

PERSON_UID

 
RPRAWRD_REPLACE_TFC_OVRDE_IND TBD COMPOSITE VIEW

AR_AWARD_BY_PERSON

AR_AWARD_BY_AID_YEAR

REPLACE_TFC_OVERRIDE_IND

REPLACE_TFC_OVERRIDE_IND

 
RPRAWRD_SYS_IND TBD COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

AR_AWARD_BY_PERSON

SYSTEM_IND

SYSTEM

 
RPRAWRD_TREQ_OVRDE_IND TBD COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

AR_AWARD_BY_PERSON

TRACKING_REQ_OVERRIDE_IND

TRACKING_REQ_OVERRIDE_IND

 
RPRAWRD_UNMET_NEED_OVRDE_IND TBD COMPOSITE VIEW

AR_AWARD_BY_PERSON

AR_AWARD_BY_AID_YEAR

UNMET_NEED_OVERRIDE

UNMET_NEED_OVERRIDE

 
RPRAWRD_USER_ID NA COMPOSITE VIEW

AR_AWARD_BY_AID_YEAR

USER_ID

 


Ver: