| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| RPRAWRD_ACCEPT_AMT |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
TOTAL_ACCEPT_AMOUNT |
NO |
NA |
| RPRAWRD_ACCEPT_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
TOTAL_ACCEPT_DATE |
NO |
|
| RPRAWRD_ACTIVITY_DATE |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ACTIVITY_DATE |
NO |
|
| RPRAWRD_AIDY_CODE |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR AR_AWARD_BY_FUND |
AID_YEAR AID_YEAR |
NO NO |
NA |
| RPRAWRD_AUTHORIZE_AMT |
RPAAPMT SHOWS AS RPRAWRD_MEMAUTH_AMT IN RPAAWRD FORM. |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_AUTHORIZE_AMOUNT |
NO |
|
| RPRAWRD_AUTHORIZE_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_AUTHORIZE_DATE |
NO |
|
| RPRAWRD_AWST_CODE |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON AR_AWARD_BY_AID_YEAR |
AWARD_STATUS AWARD_STATUS |
NO NO |
NA |
| RPRAWRD_AWST_DATE |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR AR_AWARD_BY_PERSON |
AWARD_STATUS_DATE AWARD_STATUS_DATE |
NO NO |
NA |
| RPRAWRD_CANCEL_AMT |
RPAAWRD RPAAWRD ROARMAN |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_CANCEL_AMOUNT |
NO |
|
| RPRAWRD_CANCEL_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_CANCEL_DATE |
NO |
|
| RPRAWRD_DECLINE_AMT |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
TOTAL_DECLINE_AMOUNT |
NO |
NA |
| RPRAWRD_DECLINE_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
TOTAL_DECLINE_DATE |
NO |
|
| RPRAWRD_FED_LIMIT_OVRDE_IND |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR AR_AWARD_BY_PERSON |
FEDERAL_LIMIT_OVERRIDE_IND FEDERAL_LIMIT_OVERRIDE_IND |
NO NO |
|
| RPRAWRD_FUND_CODE |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_FUND AR_AWARD_BY_AID_YEAR |
FUND FUND |
NO NO |
NA |
| RPRAWRD_FUND_LIMIT_OVRDE_IND |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON AR_AWARD_BY_AID_YEAR |
FUND_LIMIT_OVERRIDE_IND FUND_LIMIT_OVERRIDE_IND |
NO NO |
|
| RPRAWRD_INFO_ACCESS_IND |
RPAAWRD ROARMAN RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_ACCESS_IND |
NO |
|
| RPRAWRD_LAST_WEB_UPDATE |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_LAST_WEB_UPDATE |
NO |
|
| RPRAWRD_LOCK_IND |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_LOCKED ANNUAL_AWARD_LOCKED |
NO NO |
|
| RPRAWRD_MEMO_AMT |
RPAAPMT SHOWS AS RPRAWRD_MEMAUTH_AMT IN RPAAWRD FORM. |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_MEMO_AMOUNT |
NO |
|
| RPRAWRD_MEMO_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
ANNUAL_AWARD_MEMO_DATE |
NO |
|
| RPRAWRD_OFFER_AMT |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
OFFER_AMOUNT |
NO |
NA |
| RPRAWRD_OFFER_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
OFFER_DATE |
NO |
|
| RPRAWRD_OFFER_EXP_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
AWARD_OFFER_EXPIRATION_DATE |
NO |
|
| RPRAWRD_ORIG_OFFER_AMT |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
TOTAL_OFFER_AMOUNT |
NO |
NA |
| RPRAWRD_ORIG_OFFER_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
TOTAL_ORIGINAL_OFFER_DATE |
NO |
|
| RPRAWRD_OVERRIDE_NO_PELL |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR AR_AWARD_BY_PERSON |
NO_PELL_OVERRIDE_IND NO_PELL_OVERRIDE_IND |
NO NO |
|
| RPRAWRD_OVERRIDE_YR_IN_COLL |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR AR_AWARD_BY_PERSON |
ACADEMIC_YEAR_OVERRIDE ACADEMIC_YEAR_OVERRIDE |
NO NO |
|
| RPRAWRD_PAID_AMT |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
TOTAL_PAID_AMOUNT |
NO |
NA |
| RPRAWRD_PAID_DATE |
RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
TOTAL_PAID_DATE |
NO |
|
| RPRAWRD_PIDM |
RPAAWRD RPAAPMT |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
PERSON_UID |
NO |
|
| RPRAWRD_REPLACE_TFC_OVRDE_IND |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR AR_AWARD_BY_PERSON |
REPLACE_TFC_OVERRIDE_IND REPLACE_TFC_OVERRIDE_IND |
NO NO |
|
| RPRAWRD_SYS_IND |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR AR_AWARD_BY_PERSON |
SYSTEM_IND SYSTEM |
NO NO |
|
| RPRAWRD_TREQ_OVRDE_IND |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR AR_AWARD_BY_PERSON |
TRACKING_REQ_OVERRIDE_IND TRACKING_REQ_OVERRIDE_IND |
NO NO |
|
| RPRAWRD_UNMET_NEED_OVRDE_IND |
TBD |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON AR_AWARD_BY_AID_YEAR |
UNMET_NEED_OVERRIDE UNMET_NEED_OVERRIDE |
NO NO |
|
| RPRAWRD_USER_ID |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_AID_YEAR |
USER_ID |
NO |
|