Composite View Source: RPRADSB

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
RPRADSB_ACPT_DISB_SEQ_NO	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISBURSEMENT_NUMBER	NA
RPRADSB_ACPT_PAY_PD_START_DATE	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	ACCEPTED_PAY_PERIOD_START_DATE
RPRADSB_ACPT_PREV_DISB_SEQ_NO	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_PREVIOUS_DISB_SEQUENCE_NO
RPRADSB_ACTIVITY_DATE	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	ACTIVITY_DATE
RPRADSB_AIDY_CODE	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	AID_YEAR	NA
RPRADSB_CIP_CODE	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PROGRAM_CLASSIFICATION
RPRADSB_CONCUR_ENROLL_FLAG	READIXX
RPRADSB_DATE_CHANGE_IND	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DISBURSEMENT_CHANGE_DATE_IND
RPRADSB_DEBIT_CR_IND	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DEBIT_CREDIT	NA
RPRADSB_DISBURSE_AMT	RPAAPMT	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT AR_AWARD_DISBURSEMENT	TOTAL_DISBURSED_AMOUNT DISBURSED_AMOUNT	NA
RPRADSB_DISBURSE_DATE	RPAAPMT	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DISBURSED_DATE	NA
RPRADSB_DISBURSE_LOAD	RPAAPMT	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DISBURSEMENT_LOAD	NA
RPRADSB_DISBURSE_LOAD_OPT	RPAAPMT	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DISBURSEMENT_LOAD_OPT	NA
RPRADSB_DISBURSE_PCT	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DISBURSED_PERCENTAGE	NA
RPRADSB_DISB_ACK_REF_NO	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_REFERENCE_NUMBER	NA
RPRADSB_DISB_ACPT_AMT	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_UNSIGNED_DISBURSED_AMOUNT	NA
RPRADSB_DISB_ACPT_DATE	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISBURSED_DATE	NA
RPRADSB_DISB_ACPT_DEBIT_CR_IND	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DEBIT_CREDIT	NA
RPRADSB_DISB_ACTION_CODE	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISBURSEMENT_ACTION	NA
RPRADSB_DISB_AMT	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	UNSIGNED_DISBURSED_AMOUNT	NA
RPRADSB_DISB_BATCH_NO	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PELL_BATCH_NUMBER	NA
RPRADSB_DISB_DATE	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISBURSEMENT_DATE
RPRADSB_DISB_DATE_SENT	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISBURSEMENT_SENT_DATE
RPRADSB_DISB_NET_AMT	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	NET_AMOUNT_DISBURSED	NA
RPRADSB_DISB_REF_NO	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	REFERENCE_NUMBER	NA
RPRADSB_DISB_SEQ_NO	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DISBURSEMENT_NUMBER	NA
RPRADSB_DOCUMENT_ID	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DOCUMENT_ID	NA
RPRADSB_EDIT_FIELD_1	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_FIELD1
RPRADSB_EDIT_FIELD_2	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_FIELD2
RPRADSB_EDIT_FIELD_3	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_FIELD3
RPRADSB_EDIT_FIELD_4	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_FIELD4
RPRADSB_EDIT_FIELD_5	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_FIELD5
RPRADSB_EDIT_REJ_01	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE1
RPRADSB_EDIT_REJ_02	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE2
RPRADSB_EDIT_REJ_03	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE3
RPRADSB_EDIT_REJ_04	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE4
RPRADSB_EDIT_REJ_05	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE5
RPRADSB_EDIT_REJ_06	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE6
RPRADSB_EDIT_REJ_07	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE7
RPRADSB_EDIT_REJ_08	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE8
RPRADSB_EDIT_REJ_09	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE9
RPRADSB_EDIT_REJ_10	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_REJECT_CODE10
RPRADSB_EDIT_VALUE_1	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_VALUE1
RPRADSB_EDIT_VALUE_2	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_VALUE2
RPRADSB_EDIT_VALUE_3	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_VALUE3
RPRADSB_EDIT_VALUE_4	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_VALUE4
RPRADSB_EDIT_VALUE_5	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISB_EDIT_VALUE5
RPRADSB_ENROLLMENT_SCHOOL_CDE	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	ENROLLMENT_INSTITUTION
RPRADSB_FUND_CODE	RPAADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	FUND	NA
RPRADSB_HIGHEST_CPS_TRAN_NO	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	HIGHEST_CPS_TRANSACTION_NO
RPRADSB_INST_XREF	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISBURSEMENT_CROSS_REF
RPRADSB_LMS_FEED_IND	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	INSTITUTIONAL_LOAN_FEED_IND
RPRADSB_ORIG_ID	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_ORIGINATION_IDENTIFIER
RPRADSB_PAY_PD_START_DATE	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PAYMENT_PERIOD_START_DATE
RPRADSB_PELLC_DISB_LOAD	RPAAWRD	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PELL_CALCULATED_DISB_LOAD
RPRADSB_PELLC_DISB_LOAD_OPT	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PELL_CALC_DISB_LOAD_OPTION
RPRADSB_PELL_CALC_DISB_AMT	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PELL_CALCULATED_DISB_AMOUNT
RPRADSB_PELL_LEU	READIXX
RPRADSB_PERCENT_ELIB_USED	READIXX
RPRADSB_PERCENT_ELIG_USED	TBD
RPRADSB_PERIOD	TBD
RPRADSB_PIDM	NA	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PERSON_UID	NA
RPRADSB_POTENTIAL_OVERPMT_FLAG	READIXX
RPRADSB_SCHEDULE_AMT	RPAAPMT	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	SCHEDULED_AMOUNT	NA
RPRADSB_SCHEDULE_DATE	RPAAPMT	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	SCHEDULED_DATE	NA
RPRADSB_TERM_CODE	RPAAPMT	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	ACADEMIC_PERIOD	NA
RPRADSB_TRAN_NUMBER	RPAAPMT	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	TRANSACTION_NUMBER	NA
RPRADSB_USER_ID	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	USER_ID
RPRADSB_VERIF_W_STATUS_FLAG	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	VERIFICATION_CORRECTION_IND
RPRADSB_YTD_AMT_PAID	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_YTD_AMOUNT_PAID	NA

Ver: