Reporting View Source: RPRAWRD

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**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
RPRAWRD_ACCEPT_AMT	RPAAWRD	REPORTING VIEW	AWARD_BY_AID_YEAR GOVERNMENT_FA_FUND 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	REPORTING VIEW	AWARD_BY_AID_YEAR	ACTIVITY_DATE
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_AID_YEAR AWARD_BY_PERSON	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	AWARD_BY_AID_YEAR GOVERNMENT_FA_FUND GOVERNMENT_FINANCIAL_AID	TOTAL_DECLINE_AMOUNT TOTAL_DECLINE_AMOUNT 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_AID_YEAR AWARD_BY_PERSON	FEDERAL_LIMIT_OVERRIDE_IND FEDERAL_LIMIT_OVERRIDE_IND
RPRAWRD_FUND_CODE	RPAAWRD	REPORTING VIEW	AWARD_BY_AID_YEAR AWARD_BY_FUND	FUND FUND	NA
RPRAWRD_FUND_LIMIT_OVRDE_IND	TBD	REPORTING VIEW	AWARD_BY_AID_YEAR AWARD_BY_PERSON	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_AID_YEAR AWARD_BY_PERSON	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	AWARD_BY_AID_YEAR GOVERNMENT_FA_FUND 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_AID_YEAR AWARD_BY_PERSON	REPLACE_TFC_OVERRIDE_IND REPLACE_TFC_OVERRIDE_IND
RPRAWRD_SYS_IND	TBD	REPORTING VIEW	AWARD_BY_AID_YEAR AWARD_BY_PERSON	SYSTEM_IND SYSTEM
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.1