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 |
|