| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| RPRATRM_ACCEPT_AMT |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_ACCEPT_AMOUNT |
NO |
NA |
| RPRATRM_ACCEPT_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_ACCEPT_DATE |
NO |
|
| RPRATRM_ACTIVITY_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
ACTIVITY_DATE |
NO |
|
| RPRATRM_AIDY_CODE |
RPAAPMT |
NO |
REPORTING VIEW |
GOVERNMENT_FINANCIAL_AID AWARD_BY_PERSON AWARD_BY_PERSON |
AID_PERIOD AID_YEAR ORIGINAL_AID_YEAR |
NO NO NO |
NA |
| RPRATRM_AIDY_CODE_FUNDS |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
FUND_AID_YEAR |
NO |
|
| RPRATRM_AUTHORIZE_AMT |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_AUTHORIZE_AMOUNT |
NO |
NA |
| RPRATRM_AUTHORIZE_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_AUTHORIZE_DATE |
NO |
|
| RPRATRM_AWST_CODE |
NA |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_STATUS |
NO |
|
| RPRATRM_AWST_DATE |
NA |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_STATUS_DATE |
NO |
|
| RPRATRM_BBAY_CODE |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
BORROWER_BASED_ACADEMIC_YEAR |
NO |
|
| RPRATRM_CANCEL_AMT |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_CANCEL_AMOUNT |
NO |
NA |
| RPRATRM_CANCEL_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_CANCEL_DATE |
NO |
|
| RPRATRM_CIP_OVERRIDE_CODE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
PROGRAM_CLASSIFICATION_OVR |
NO |
|
| RPRATRM_DATA_ORIGIN |
NA |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_BY_PERSON_DATA_ORIGIN |
NO |
|
| RPRATRM_DECLINE_AMT |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_DECLINE_AMOUNT |
NO |
NA |
| RPRATRM_DECLINE_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_DECLINE_DATE |
NO |
|
| RPRATRM_DISB_FINAL_IND |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
DISBURSEMENT_FINALIZE_IND |
NO |
NA |
| RPRATRM_DIST_PCT |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
PERCENT_DISTRIBUTION_ACAD_PER |
NO |
NA |
| RPRATRM_FUND_CODE |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
FUND |
NO |
NA |
| RPRATRM_LOCK_IND |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_LOCKED |
NO |
|
| RPRATRM_MAJR_OVERRIDE_CODE |
NA |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
MAJOR_OVERRIDE |
NO |
|
| RPRATRM_MEMO_AMT |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_MEMO_AMOUNT |
NO |
NA |
| RPRATRM_MEMO_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON AWARD_BY_PERSON |
AWARD_MEMO_DATE AWARD_MEMO_EXPIRATION_DATE |
NO NO |
|
| RPRATRM_MEMO_EXP_DATE |
NA |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_MEMO_EXPIRATION_DATE |
NO |
|
| RPRATRM_NSLDS_OVRD_IND |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
STUDENT_LOAN_OVERRIDE |
NO |
|
| RPRATRM_OFFER_AMT |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_OFFER_AMOUNT |
NO |
NA |
| RPRATRM_OFFER_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_OFFER_DATE |
NO |
|
| RPRATRM_OFFER_EXP_DATE |
NA |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_OFFER_EXPIRATION_DATE |
NO |
|
| RPRATRM_ORIG_OFFER_AMT |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_ORIGINAL_OFFER_AMOUNT |
NO |
|
| RPRATRM_ORIG_OFFER_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_ORIGINAL_OFFER_DATE |
NO |
|
| RPRATRM_OVERRIDE_DISB_RULE |
NA |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
DISBURSEMENT_RULE_OVERRIDE_IND |
NO |
|
| RPRATRM_PAID_AMT |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_PAID_AMOUNT |
NO |
NA |
| RPRATRM_PAID_DATE |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
AWARD_PAID_DATE |
NO |
|
| RPRATRM_PCKG_LOAD_IND |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
TIME_STATUS |
NO |
NA |
| RPRATRM_PELL_AWRD_LOAD_OPT |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
PELL_AWARD_ENROLLMENT_OPTION |
NO |
|
| RPRATRM_PERIOD |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON GOVERNMENT_FINANCIAL_AID |
AID_ENROLLMENT_PERIOD AID_ENROLLMENT_PERIOD |
NO NO |
|
| RPRATRM_PIDM |
NA |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
PERSON_UID |
NO |
NA |
| RPRATRM_TERM_CODE |
RPAAPMT |
NO |
REPORTING VIEW |
AWARD_BY_PERSON GOVERNMENT_FINANCIAL_AID |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
NO NO |
NA |
| RPRATRM_USER_ID |
TBD |
NO |
REPORTING VIEW |
AWARD_BY_PERSON |
USER_ID |
NO |
|