Composite View Source: RPRLADB

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: RPRLADB Financial Aid

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

Ver: