| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| RPRLADB_ACTIVITY_DATE |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ACTIVITY_DATE |
NO |
|
| RPRLADB_AFFIRM_FLAG |
RPAELAP RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
CONFIRMATION_IND |
NO |
|
| RPRLADB_AIDY_CODE |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
AID_YEAR |
NO |
|
| RPRLADB_APPL_NO |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_DISBURSEMENT |
APPLICATION_NUMBER LOAN_NUMBER |
NO NO |
|
| RPRLADB_BATCH_NO |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_BATCH_NUMBER |
NO |
|
| RPRLADB_CANCEL_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
CANCEL_DATE |
NO |
|
| RPRLADB_CANCEL_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
CANCEL_IND |
NO |
|
| RPRLADB_CHECK_AMT |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
NET_CHECK_AMOUNT |
NO |
|
| RPRLADB_CHECK_DATE |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
CHECK_DATE_RECEIVED |
NO |
|
| RPRLADB_CHECK_RETURN_AMT |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
CHECK_RETURN_AMOUNT |
NO |
|
| RPRLADB_CHECK_RETURN_DATE |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
CHECK_RETURN_DATE |
NO |
|
| RPRLADB_CIP_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
PROGRAM_CLASSIFICATION |
NO |
|
| RPRLADB_COMMENT |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DISBURSEMENT_COMMENT |
NO |
|
| RPRLADB_DATA_ORIGIN |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DISBURSEMENT_DATA_ORIGIN |
NO |
|
| RPRLADB_DISBURSE_DATE |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
SCHEDULED_DATE |
NO |
|
| RPRLADB_DISBURSE_LOAD |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ENROLLMENT_LOAD |
NO |
|
| RPRLADB_DISBURSE_LOAD_OPT |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ENROLLMENT_LOAD_OPTION |
NO |
|
| RPRLADB_DISB_BYPASS |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DISBURSEMENT_BYPASS_IND |
NO |
|
| RPRLADB_DISB_OVERRIDE_IND |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
OVERRIDE_IND |
NO |
|
| RPRLADB_DISB_STATUS |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DISBURSEMENT_PROCESSING_STATUS |
NO |
|
| RPRLADB_DL_ACKN_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_COD_RECEIPT_DATE |
NO |
|
| RPRLADB_DL_AUTHORIZED_IND |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
AUTHORIZED_IND |
NO |
|
| RPRLADB_DL_DISB_NO |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_DISBURSEMENT_NUMBER |
NO |
|
| RPRLADB_DL_FEE_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_FEE_AMOUNT |
NO |
|
| RPRLADB_DL_GROSS_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_GROSS_AMOUNT |
NO |
|
| RPRLADB_DL_REBATE_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_REBATE_AMOUNT |
NO |
|
| RPRLADB_DL_REJECT_CODE_1 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_REJECT_CODE1 |
NO |
|
| RPRLADB_DL_REJECT_CODE_2 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_REJECT_CODE2 |
NO |
|
| RPRLADB_DL_REJECT_CODE_3 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_REJECT_CODE3 |
NO |
|
| RPRLADB_DL_REJECT_CODE_4 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_REJECT_CODE4 |
NO |
|
| RPRLADB_DL_REJECT_CODE_5 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_REJECT_CODE5 |
NO |
|
| RPRLADB_DL_SEQ_NO |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_SEQUENCE_NUMBER |
NO |
|
| RPRLADB_DOCUMENT_ID |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_DOCUMENT_ID |
NO |
|
| RPRLADB_EFT_IND |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ELECTRONIC_TRANSFER_IND |
NO |
|
| RPRLADB_EL_BOR_DIRECT_DISB_IND |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
BORROWER_DIRECT_DISBURSE_IND |
NO |
|
| RPRLADB_EL_DIRECT_CHECK_AMT |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
BORROWER_DIRECT_CHECK_AMOUNT |
NO |
|
| RPRLADB_EL_DISB_NO |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ELECTRONIC_DISBURSEMENT_NUMBER |
NO |
|
| RPRLADB_EL_HOLD_REL_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
HOLD_RELEASE_DATE |
NO |
|
| RPRLADB_EL_REV_GROSS_AMT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
REVISED_GROSS_AMOUNT |
NO |
|
| RPRLADB_EL_SERV_DISB_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
SERVICER_DISBURSEMENT_DATE |
NO |
|
| RPRLADB_EL_SERV_GROSS_AMT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
SERVICER_DISBURSEMENT_GROSS |
NO |
|
| RPRLADB_EL_SERV_GUAR_FEE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
GUARANTEE_FEE_AMOUNT |
NO |
|
| RPRLADB_EL_SERV_NET_AMT |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ELECTRONIC_SERVICE_NET_AMOUNT |
NO |
|
| RPRLADB_EL_SERV_ORIG_FEE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ORIGINATION_FEE_AMOUNT |
NO |
|
| RPRLADB_ENROLLMENT_SCHOOL_CDE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ENROLLMENT_SCHOOL_CODE |
NO |
|
| RPRLADB_ENROLLMENT_STATUS |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ENROLLMENT_STATUS |
NO |
|
| RPRLADB_FEED_DATE |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DISBURSEMENT_FEED_DATE |
NO |
|
| RPRLADB_FEED_IND |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DISBURSEMENT_FEED |
NO |
|
| RPRLADB_FEES_PAID |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
SUBSIDIZED_FEES_PAID |
NO |
|
| RPRLADB_FUND_CODE |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
FUND |
NO |
|
| RPRLADB_HOLD_REL_STATUS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
HOLD_RELEASE_STATUS |
NO |
|
| RPRLADB_LOAN_PCT |
RPAELAP RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
LOAN_PERCENTAGE_DISBURSEMENT |
NO |
|
| RPRLADB_MEMO_EXP_DAYS |
NA |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
MEMO_EXPIRATION_DAYS |
NO |
|
| RPRLADB_PAY_PD_START_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
PAYMENT_PERIOD_START_DATE |
NO |
|
| RPRLADB_PERIOD |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
AID_ENROLLMENT_PERIOD |
NO |
|
| RPRLADB_PIDM |
NA |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
PERSON_UID |
NO |
|
| RPRLADB_PN_DISB_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
MPN_DISBURSEMENT_DATE |
NO |
|
| RPRLADB_PREV_DISB_SEQ_NO |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
PREVIOUS_DISBURSEMENT_NUMBER |
NO |
|
| RPRLADB_PRIOR_DISB_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
PRIOR_DISBURSEMENT_DATE |
NO |
|
| RPRLADB_RECON_BATCH_NO |
NA |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
RECONCILIATION_BATCH_NUMBER |
NO |
|
| RPRLADB_REF_ID |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ELECTRONIC_REFERENCE_ID |
NO |
|
| RPRLADB_REGION_CD |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
SAS_REGION |
NO |
|
| RPRLADB_REPT_DISB_DATE |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
REPORTED_DATE |
NO |
|
| RPRLADB_RET_LNDR_DATE |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
CHECK_RETURNED_LENDER_DATE |
NO |
|
| RPRLADB_REV_DISB_AMT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
REVISED_NET_AMOUNT |
NO |
|
| RPRLADB_SAS_END_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_MONTH_END_DATE |
NO |
|
| RPRLADB_SAS_PROCESS_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_MONTH_PROCESS_DATE |
NO |
|
| RPRLADB_SAS_RECORD_COUNT_SEQ |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_RECORD_COUNT_NO |
NO |
|
| RPRLADB_SAS_START_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_MONTH_START_DATE |
NO |
|
| RPRLADB_SCHOOL_CODE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
COLLEGE |
NO |
|
| RPRLADB_SCHOOL_STAT_CODE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
SAS_STATE_PROVINCE |
NO |
|
| RPRLADB_SEQ_NO |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DISBURSEMENT_SEQUENCE_NUMBER |
NO |
|
| RPRLADB_SERVICER |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
LOAN_SERVICER |
NO |
|
| RPRLADB_SERV_BOOKED_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_COD_BOOK_DATE |
NO |
|
| RPRLADB_SERV_FEE_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_SERVICE_FEE_AMOUNT |
NO |
|
| RPRLADB_SERV_GROSS_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_COD_GROSS_AMOUNT |
NO |
|
| RPRLADB_SERV_NET_ADJ_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_COD_ADJUSTED_NET |
NO |
|
| RPRLADB_SERV_NET_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_COD_NET_AMOUNT |
NO |
|
| RPRLADB_SERV_REBATE_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
DIRECT_LOAN_COD_REBATE_AMOUNT |
NO |
|
| RPRLADB_SERV_TRANS_TYPE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
TRANSACTION_TYPE |
NO |
|
| RPRLADB_STU_RECEIVE_DATE |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
STUDENT_RECEIVE_DATE |
NO |
|
| RPRLADB_TERM_CODE |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
ACADEMIC_PERIOD |
NO |
|
| RPRLADB_TRAN_NUMBER |
RPALDSB RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
TRANSACTION_NUMBER |
NO |
|
| RPRLADB_USER_ID |
RPALDSB |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
USER_ID |
NO |
|