| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| RRRAREQ_ACTIVITY_DATE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
REQUIREMENT_ACTIVITY_DATE |
NO |
|
| RRRAREQ_AIDY_CODE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT |
AID_YEAR AID_YEAR |
NO NO |
NA |
| RRRAREQ_DATA_ORIGIN |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
REQUIREMENT_DATA_ORIGIN |
NO |
|
| RRRAREQ_DISB_IND |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT |
DISBURSEMENT_REQ_IND DISBURSEMENT_REQ_IND1 DISBURSEMENT_REQ_IND3 DISBURSEMENT_REQ_IND2 |
NO NO NO NO |
NA |
| RRRAREQ_EST_DATE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
ESTABLISHED_DATE |
NO |
NA |
| RRRAREQ_FUND_CODE |
RRAAREQ |
NO |
REPORTING VIEW |
TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT |
FUND1 FUND3 FUND FUND2 |
NO NO NO NO |
NA |
| RRRAREQ_MEMO_IND |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT |
MEMO_IND MEMO_IND1 MEMO_IND2 MEMO_IND3 |
NO NO NO NO |
NA |
| RRRAREQ_MPN_FIRST_DISB_DATE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
PERKINS_FIRST_DISBURSE_DATE |
NO |
|
| RRRAREQ_MPN_SIGNED_DATE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
PERKINS_SIGNED_DATE |
NO |
|
| RRRAREQ_PCKG_IND |
RRAAREQ |
NO |
REPORTING VIEW |
TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT FINAID_TRACKING_REQUIREMENT |
PACKAGING_REQ_IND3 PACKAGING_REQ_IND1 PACKAGING_REQ_IND2 PACKAGING_REQ_IND |
NO NO NO NO |
NA |
| RRRAREQ_PERIOD |
TBD |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
AID_ENROLLMENT_PERIOD |
NO |
|
| RRRAREQ_PERK_MPN_EXP_DATE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
PERKINS_EXPIRATION_DATE |
NO |
|
| RRRAREQ_PIDM |
NA |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT |
PERSON_UID PERSON_UID |
NO NO |
NA |
| RRRAREQ_SATISFIED_DATE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
PERKINS_SATISFIED_DATE |
NO |
|
| RRRAREQ_SAT_IND |
RRAAREQ |
NO |
REPORTING VIEW |
TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT FINAID_TRACKING_REQUIREMENT |
SATISFIED_IND1 SATISFIED_IND2 SATISFIED_IND3 SATISFIED_IND |
NO NO NO NO |
NA |
| RRRAREQ_SBGI_CODE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT |
INSTITUTION INSTITUTION1 INSTITUTION2 INSTITUTION3 |
NO NO NO NO |
NA |
| RRRAREQ_SBGI_TYPE_IND |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
INSTITUTION_TYPE |
NO |
|
| RRRAREQ_STAT_DATE |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT |
STATUS_DATE STATUS_DATE1 STATUS_DATE3 STATUS_DATE2 |
NO NO NO NO |
NA |
| RRRAREQ_SYS_IND |
NA |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
REQUIREMENT_SOURCE |
NO |
|
| RRRAREQ_TERM_CODE |
TBD |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
ACADEMIC_PERIOD |
NO |
|
| RRRAREQ_TREQ_CODE |
RRAAREQ |
NO |
REPORTING VIEW |
TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT FINAID_TRACKING_REQUIREMENT |
REQUIREMENT1 REQUIREMENT2 REQUIREMENT3 REQUIREMENT |
NO NO NO NO |
NA |
| RRRAREQ_TREQ_DESC |
RRAAREQ |
NO |
REPORTING VIEW |
TRACKING_REQUIREMENT_SLOT FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT |
REQUIREMENT_DESC3 REQUIREMENT_DESC REQUIREMENT_DESC1 REQUIREMENT_DESC2 |
NO NO NO NO |
NA |
| RRRAREQ_TRK_LTR_IND |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
TRACKING_LETTER_IND |
NO |
|
| RRRAREQ_TRST_CODE |
RRAAREQ |
NO |
REPORTING VIEW |
TRACKING_REQUIREMENT_SLOT FINAID_TRACKING_REQUIREMENT TRACKING_REQUIREMENT_SLOT TRACKING_REQUIREMENT_SLOT |
STATUS2 STATUS STATUS3 STATUS1 |
NO NO NO NO |
NA |
| RRRAREQ_USER_ID |
RRAAREQ |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
REQUIREMENT_USER_ID |
NO |
|