| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
|---|
| RPRATRM_ACCEPT_AMT |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_ACCEPT_AMOUNT |
NA |
| RPRATRM_ACCEPT_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_ACCEPT_DATE |
|
| RPRATRM_ACTIVITY_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
ACTIVITY_DATE |
|
| RPRATRM_AIDY_CODE |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AID_YEAR |
NA |
| RPRATRM_AIDY_CODE_FUNDS |
RPAAPMT |
|
|
|
|
| RPRATRM_AUTHORIZE_AMT |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_AUTHORIZE_AMOUNT |
NA |
| RPRATRM_AUTHORIZE_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_AUTHORIZE_DATE |
|
| RPRATRM_AWST_CODE |
NA |
|
|
|
|
| RPRATRM_AWST_DATE |
NA |
|
|
|
|
| RPRATRM_BBAY_CODE |
RPAAPMT |
|
|
|
|
| RPRATRM_CANCEL_AMT |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_CANCEL_AMOUNT |
NA |
| RPRATRM_CANCEL_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_CANCEL_DATE |
|
| RPRATRM_CIP_OVERRIDE_CODE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
PROGRAM_CLASSIFICATION_OVR |
|
| RPRATRM_DATA_ORIGIN |
NA |
|
|
|
|
| RPRATRM_DECLINE_AMT |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_DECLINE_AMOUNT |
NA |
| RPRATRM_DECLINE_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_DECLINE_DATE |
|
| RPRATRM_DISB_FINAL_IND |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
DISBURSEMENT_FINALIZE_IND |
NA |
| RPRATRM_DIST_PCT |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
TERM_PERCENT_OF_DISTRIBUTION |
NA |
| RPRATRM_FUND_CODE |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
FUND |
NA |
| RPRATRM_LOCK_IND |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_LOCKED |
|
| RPRATRM_MAJR_OVERRIDE_CODE |
NA |
|
|
|
|
| RPRATRM_MEMO_AMT |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_MEMO_AMOUNT |
NA |
| RPRATRM_MEMO_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_MEMO_EXPIRATION_DATE |
|
| RPRATRM_MEMO_EXP_DATE |
NA |
|
|
|
|
| RPRATRM_NSLDS_OVRD_IND |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
STUDENT_LOAN_OVERRIDE |
|
| RPRATRM_OFFER_AMT |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_OFFER_AMOUNT |
NA |
| RPRATRM_OFFER_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_OFFER_DATE |
|
| RPRATRM_OFFER_EXP_DATE |
NA |
|
|
|
|
| RPRATRM_ORIG_OFFER_AMT |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_ORIGINAL_OFFER_AMOUNT |
|
| RPRATRM_ORIG_OFFER_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_ORIGINAL_OFFER_DATE |
|
| RPRATRM_OVERRIDE_DISB_RULE |
NA |
|
|
|
|
| RPRATRM_PAID_AMT |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_PAID_AMOUNT |
NA |
| RPRATRM_PAID_DATE |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_PAID_DATE |
|
| RPRATRM_PCKG_LOAD_IND |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
TIME_STATUS |
NA |
| RPRATRM_PELL_AWRD_LOAD_OPT |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
PELL_AWARD_ENROLLMENT_OPTION |
|
| RPRATRM_PERIOD |
TBD |
|
|
|
|
| RPRATRM_PIDM |
NA |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON AS_ACTIVE_TERMS |
PERSON_UID PERSON_UID |
NA |
| RPRATRM_TERM_CODE |
RPAAPMT |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON AS_ACTIVE_TERMS |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
NA |
| RPRATRM_USER_ID |
TBD |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
USER_ID |
|