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

Source Column Source Form Target Type Target Target Column Calculation Formula
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: