| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| RLRDLOR_ACAD_YR_END_DATE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
ACADEMIC_YEAR_END_DATE ACADEMIC_YEAR_END_DATE |
NO NO |
|
| RLRDLOR_ACAD_YR_START_DATE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
ACADEMIC_YEAR_START_DATE ACADEMIC_YEAR_START_DATE |
NO NO |
|
| RLRDLOR_ACTIVITY_DATE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
APPLICATION_ACTIVITY_DATE ACTIVITY_DATE |
NO NO |
|
| RLRDLOR_ADDL_UNSUB_ELIG_IND |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
ADDITIONAL_STAFFORD_ELIG_IND ADDL_UNSUBSIDIZED_ELIG_IND ADDL_UNSUBSIDIZED_ELIG_IND |
NO NO NO |
|
| RLRDLOR_AIDY_CODE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
AID_YEAR AID_YEAR |
NO NO |
|
| RLRDLOR_AWARD_END_DATE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
LOAN_PERIOD_END_DATE LOAN_PERIOD_END_DATE |
NO NO |
|
| RLRDLOR_AWARD_START_DATE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
LOAN_PERIOD_START_DATE LOAN_PERIOD_START_DATE |
NO NO |
|
| RLRDLOR_BBAY_CODE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
BORROWER_BASED_ACADEMIC_YEAR BORROWER_BASED_ACADEMIC_YEAR |
NO NO |
|
| RLRDLOR_CREATE_DATE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL |
CREATE_DATE |
NO |
|
| RLRDLOR_DATA_ORIGIN |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
APPLICATION_DATA_ORIGIN DISBURSEMENT_DATA_ORIGIN |
NO NO |
|
| RLRDLOR_DATE_SENT |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
DIRECT_LOAN_DATE_SENT DL_SENT_DATE |
NO NO |
|
| RLRDLOR_DEPENDENCY_STATUS |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
DEPENDENCY_STATUS DEPENDENCY_STATUS |
NO NO |
|
| RLRDLOR_DISC_PRINT_FLAG |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
DISCLOSURE_REQUIRED_IND DISCLOSURE_NEED_PRINT_FLAG |
NO NO |
|
| RLRDLOR_DOCUMENT_ID |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
ORIGINATION_DOCUMENT_ID ORIGINATION_DOCUMENT_ID |
NO NO |
|
| RLRDLOR_ENTRANCE_IND |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
ENTRANCE_COUNSELING_IND ENTRANCE_COUNSELING_IND |
NO NO |
|
| RLRDLOR_FEE_PCT |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
LOAN_FEE_PERCENT LOAN_FEE LOAN_FEE_PERCENT |
NO NO NO |
|
| RLRDLOR_FUND_CODE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
FUND FUND |
NO NO |
|
| RLRDLOR_HPPA_IND |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
FORMER_HEAL_INDICATOR HPPA_IND |
NO NO |
|
| RLRDLOR_IN_DEFAULT |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
DEFAULT_IND DEFAULT_IND DEFAULT_IND |
NO NO NO |
|
| RLRDLOR_LINKED_IND |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MPN_LINKED_IND |
NO |
|
| RLRDLOR_LNST_CODE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_DISBURSEMENT LOAN_APPLICATION LOAN_APPLICATION |
LOAN_STATUS LOAN_STATUS COMMONLINE_PROCESSING_STATUS LOAN_STATUS |
NO NO NO NO |
|
| RLRDLOR_LOAN_AMT |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
APPROVED_AMOUNT LOAN_AMOUNT |
NO NO |
|
| RLRDLOR_LOAN_ID |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
DIRECT_LOAN_ID DIRECT_LOAN_ID DIRECT_LOAN_ID |
NO NO NO |
|
| RLRDLOR_LOAN_NO |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
LOAN_APPLICATION_NUMBER LOAN_NUMBER LOAN_APPLICATION_NUMBER |
NO NO NO |
|
| RLRDLOR_LOAN_TYPE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
LOAN_TYPE LOAN_TYPE |
NO NO |
|
| RLRDLOR_LOCK_IND |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
LOCK_INDICATOR LOCK_INDICATOR |
NO NO |
|
| RLRDLOR_MPN_ID |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
MPN_ID MPN_ID |
NO NO |
|
| RLRDLOR_MPN_LINKED_IND |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL |
MPN_LINKED_IND |
NO |
|
| RLRDLOR_PIDM |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
PERSON_UID PERSON_UID |
NO NO |
|
| RLRDLOR_PREP_OR_TEACH_IND |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
PREP_TEACHER_CERTIFICATION PREP_TEACH_CERTIFICATION_IND |
NO NO |
|
| RLRDLOR_PROCESS_DATE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION LOAN_APPLICATION |
PROCESS_DATE PROCESS_DATE SERVICER_CONFIRMATION_DATE |
NO NO NO |
|
| RLRDLOR_REBATE_PCT |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL |
REBATE_FEE_PERCENT |
NO |
|
| RLRDLOR_SAR_TRAN_NO |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
SAR_TRANSACTION_NUMBER SAR_TRANSACTION_NUMBER |
NO NO |
|
| RLRDLOR_SAYR_CODE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
SCHEDULED_ACADEMIC_YEAR SCHEDULED_ACADEMIC_YEAR |
NO NO |
|
| RLRDLOR_SCHOOL_CODE |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
DIRECT_LOAN_SCHOOL_CODE DIRECT_LOAN_SCHOOL_CODE |
NO NO |
|
| RLRDLOR_SPGM_LOCK_IND |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
PROGRAM_SEQUENCE_LOCK_IND PROGRAM_SEQUENCE_LOCK_IND |
NO NO |
|
| RLRDLOR_SPGM_SEQ_NO |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
PROGRAM_SEQUENCE_NUMBER PROGRAM_SEQUENCE_NUMBER |
NO NO |
|
| RLRDLOR_STATUS |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL LOAN_APPLICATION |
ORIGINATION_STATUS DIRECT_LOAN_STATUS |
NO NO |
|
| RLRDLOR_SURROGATE_ID |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL |
SURROGATE_ID |
NO |
|
| RLRDLOR_USER_ID |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
APPLICATION_USER_ID USER_ID |
NO NO |
|
| RLRDLOR_YR_IN_COLL |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT_DETAIL |
YEAR_IN_COLLEGE YEAR_IN_COLLEGE |
NO NO |
|