Composite View Source: RPRAWRD

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: RPRAWRD Financial Aid

**SGHE Banner Operational Data Store**
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: