Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: RPRLADB Financial Aid
Banner Operational Data Store Composite View Source: RPRLADB - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
RPRLADB_ACTIVITY_DATE RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ACTIVITY_DATE

NO

 
RPRLADB_AFFIRM_FLAG RPAELAP RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

CONFIRMATION_IND

NO

 
RPRLADB_AIDY_CODE RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

AID_YEAR

NO

 
RPRLADB_APPL_NO RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

APPLICATION_NUMBER

NO

 
RPRLADB_BATCH_NO RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_BATCH_NUMBER

NO

 
RPRLADB_CANCEL_DATE RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

CANCEL_DATE

NO

 
RPRLADB_CANCEL_IND RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

CANCEL_IND

NO

 
RPRLADB_CHECK_AMT RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

NET_CHECK_AMOUNT

NO

 
RPRLADB_CHECK_DATE RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

CHECK_DATE_RECEIVED

NO

 
RPRLADB_CHECK_RETURN_AMT RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

CHECK_RETURN_AMOUNT

NO

 
RPRLADB_CHECK_RETURN_DATE RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

CHECK_RETURN_DATE

NO

 
RPRLADB_CIP_CODE RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

PROGRAM_CLASSIFICATION

NO

 
RPRLADB_COMMENT RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DISBURSEMENT_COMMENT

NO

 
RPRLADB_DATA_ORIGIN RPALORG NO          
RPRLADB_DISBURSE_DATE RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

SCHEDULED_DATE

NO

 
RPRLADB_DISBURSE_LOAD RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ENROLLMENT_LOAD

NO

 
RPRLADB_DISBURSE_LOAD_OPT RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ENROLLMENT_LOAD_OPTION

NO

 
RPRLADB_DISB_BYPASS RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DISBURSEMENT_BYPASS_IND

NO

 
RPRLADB_DISB_OVERRIDE_IND RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

OVERRIDE_IND

NO

 
RPRLADB_DISB_STATUS RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DISBURSEMENT_PROCESSING_STATUS

NO

 
RPRLADB_DL_ACKN_DATE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_COD_RECEIPT_DATE

NO

 
RPRLADB_DL_AUTHORIZED_IND RPALORG NO          
RPRLADB_DL_DISB_NO RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_DISBURSEMENT_NUMBER

NO

 
RPRLADB_DL_FEE_AMT RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_FEE_AMOUNT

NO

 
RPRLADB_DL_GROSS_AMT RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_GROSS_AMOUNT

NO

 
RPRLADB_DL_REBATE_AMT RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_REBATE_AMOUNT

NO

 
RPRLADB_DL_REJECT_CODE_1 RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_REJECT_CODE1

NO

 
RPRLADB_DL_REJECT_CODE_2 RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_REJECT_CODE2

NO

 
RPRLADB_DL_REJECT_CODE_3 RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_REJECT_CODE3

NO

 
RPRLADB_DL_REJECT_CODE_4 RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_REJECT_CODE4

NO

 
RPRLADB_DL_REJECT_CODE_5 RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_REJECT_CODE5

NO

 
RPRLADB_DL_SEQ_NO RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_SEQUENCE_NUMBER

NO

 
RPRLADB_DOCUMENT_ID RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_DOCUMENT_ID

NO

 
RPRLADB_EFT_IND RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ELECTRONIC_TRANSFER_IND

NO

 
RPRLADB_EL_BOR_DIRECT_DISB_IND RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

BORROWER_DIRECT_DISBURSE_IND

NO

 
RPRLADB_EL_DIRECT_CHECK_AMT RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

BORROWER_DIRECT_CHECK_AMOUNT

NO

 
RPRLADB_EL_DISB_NO RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ELECTRONIC_DISBURSEMENT_NUMBER

NO

 
RPRLADB_EL_HOLD_REL_DATE RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

HOLD_RELEASE_DATE

NO

 
RPRLADB_EL_REV_GROSS_AMT RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

REVISED_GROSS_AMOUNT

NO

 
RPRLADB_EL_SERV_DISB_DATE RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

SERVICER_DISBURSEMENT_DATE

NO

 
RPRLADB_EL_SERV_GROSS_AMT RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

SERVICER_DISBURSEMENT_GROSS

NO

 
RPRLADB_EL_SERV_GUAR_FEE RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

GUARANTEE_FEE_AMOUNT

NO

 
RPRLADB_EL_SERV_NET_AMT RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ELECTRONIC_SERVICE_NET_AMOUNT

NO

 
RPRLADB_EL_SERV_ORIG_FEE RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ORIGINATION_FEE_AMOUNT

NO

 
RPRLADB_ENROLLMENT_SCHOOL_CDE RPALORG NO          
RPRLADB_ENROLLMENT_STATUS RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ENROLLMENT_STATUS

NO

 
RPRLADB_FEED_DATE RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DISBURSEMENT_FEED_DATE

NO

 
RPRLADB_FEED_IND RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DISBURSEMENT_FEED

NO

 
RPRLADB_FEES_PAID RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

SUBSIDIZED_FEES_PAID

NO

 
RPRLADB_FUND_CODE RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

FUND

NO

 
RPRLADB_HOLD_REL_STATUS RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

HOLD_RELEASE_STATUS

NO

 
RPRLADB_LOAN_PCT RPAELAP RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

LOAN_PERCENTAGE_DISBURSEMENT

NO

 
RPRLADB_MEMO_EXP_DAYS NA NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

MEMO_EXPIRATION_DAYS

NO

 
RPRLADB_PAY_PD_START_DATE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

PAYMENT_PERIOD_START_DATE

NO

 
RPRLADB_PERIOD RPALDSB RPALORG NO          
RPRLADB_PIDM NA NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

PERSON_UID

NO

 
RPRLADB_PN_DISB_DATE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

MPN_DISBURSEMENT_DATE

NO

 
RPRLADB_PREV_DISB_SEQ_NO RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

PREVIOUS_DISBURSEMENT_NUMBER

NO

 
RPRLADB_PRIOR_DISB_DATE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

PRIOR_DISBURSEMENT_DATE

NO

 
RPRLADB_RECON_BATCH_NO NA NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

RECONCILIATION_BATCH_NUMBER

NO

 
RPRLADB_REF_ID RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ELECTRONIC_REFERENCE_ID

NO

 
RPRLADB_REGION_CD RPALORG NO          
RPRLADB_REPT_DISB_DATE RPALDSB NO          
RPRLADB_RET_LNDR_DATE RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

CHECK_RETURNED_LENDER_DATE

NO

 
RPRLADB_REV_DISB_AMT RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

REVISED_NET_AMOUNT

NO

 
RPRLADB_SAS_END_DATE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_MONTH_END_DATE

NO

 
RPRLADB_SAS_PROCESS_DATE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_MONTH_PROCESS_DATE

NO

 
RPRLADB_SAS_RECORD_COUNT_SEQ RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_RECORD_COUNT_NO

NO

 
RPRLADB_SAS_START_DATE RPALORG NO          
RPRLADB_SCHOOL_CODE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

COLLEGE

NO

 
RPRLADB_SCHOOL_STAT_CODE RPALORG NO          
RPRLADB_SEQ_NO RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DISBURSEMENT_SEQUENCE_NUMBER

NO

 
RPRLADB_SERVICER RPALORG NO          
RPRLADB_SERV_BOOKED_DATE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_COD_BOOK_DATE

NO

 
RPRLADB_SERV_FEE_AMT RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_SERVICE_FEE_AMOUNT

NO

 
RPRLADB_SERV_GROSS_AMT RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_COD_GROSS_AMOUNT

NO

 
RPRLADB_SERV_NET_ADJ_AMT RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_COD_ADJUSTED_NET

NO

 
RPRLADB_SERV_NET_AMT RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_COD_NET_AMOUNT

NO

 
RPRLADB_SERV_REBATE_AMT RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DIRECT_LOAN_COD_REBATE_AMOUNT

NO

 
RPRLADB_SERV_TRANS_TYPE RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

TRANSACTION_TYPE

NO

 
RPRLADB_STU_RECEIVE_DATE RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

STUDENT_RECEIVE_DATE

NO

 
RPRLADB_TERM_CODE RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ACADEMIC_PERIOD

NO

 
RPRLADB_TRAN_NUMBER RPALDSB RPALORG NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

TRANSACTION_NUMBER

NO

 
RPRLADB_USER_ID RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

USER_ID

NO

 


Ver: