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