Composite View Source: RPRLAPP

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
RPRLAPP_ACAD_YR_END_DATE	RPAELAP	AR_LOAN_APPLICATION	ACAD_YEAR_END_DATE
RPRLAPP_ACAD_YR_START_DATE	RPAELAP	AR_LOAN_APPLICATION	ACAD_YEAR_START_DATE
RPRLAPP_ADDL_STFD_ELIG_IND	RPAELAP	AR_LOAN_APPLICATION	ADDL_STAFFORD_ELIG_IND
RPRLAPP_ADDRESS	RPAELAP	AR_LOAN_APPLICATION	STREET_LINE1
RPRLAPP_ADDR_LINE2	RPAELAP	AR_LOAN_APPLICATION	STREET_LINE2
RPRLAPP_AIDY_CODE	RPAELAP	AR_LOAN_APPLICATION	AID_YEAR
RPRLAPP_ALIEN_REG_NO	RPAELAP	AR_LOAN_APPLICATION	ALIEN_REGISTRATION_NO
RPRLAPP_ALT_BOR_LOAN_DEBT	RPAELAP	AR_LOAN_APPLICATION	ALT_LOAN_BORROWER_LN_DEBT
RPRLAPP_ALT_LOAN_PROG_TYPE_CDE	RPAELAP	AR_LOAN_APPLICATION	ALT_LOAN_PROGRAM_TYPE
RPRLAPP_ALT_LOAN_SB_IND	RPAELAP	AR_LOAN_APPLICATION	ALT_LOAN_STU_BORROWER_IND
RPRLAPP_APPL_NO	RPAELAP	AR_LOAN_APPLICATION	LOAN_APPLICATION_NO
RPRLAPP_APPROVE_AMT	RPAELAP	AR_LOAN_APPLICATION	APPROVED_AMT
RPRLAPP_APPROVE_DATE	RPAELAP	AR_LOAN_APPLICATION	APPROVED_DATE
RPRLAPP_APP_PHASE_CDE	RPAELAP	AR_LOAN_APPLICATION	APP_PHASE_CODE
RPRLAPP_APP_VER_NO	RPAELAP	AR_LOAN_APPLICATION	APP_VERSION_NO
RPRLAPP_BATCH_NO	RPAELAP	AR_LOAN_APPLICATION	BATCH_ID
RPRLAPP_BOR_GROSS_YR_SAL	RPAELAP	AR_LOAN_APPLICATION	BORROWER_ANNUAL_INCOME
RPRLAPP_BOR_OTH_INC	RPAELAP	AR_LOAN_APPLICATION	BORROWER_OTHER_INCOME
RPRLAPP_CANCEL_DATE	RPAELAP	AR_LOAN_APPLICATION	CANCEL_DATE
RPRLAPP_CANCEL_IND	RPAELAP	AR_LOAN_APPLICATION	CANCEL_IND
RPRLAPP_CERT_DATE	RPAELAP	AR_LOAN_APPLICATION	CERTIFICATION_DATE
RPRLAPP_CITY	RPAELAP	AR_LOAN_APPLICATION	CITY
RPRLAPP_CITZ_IND	RPAELAP	AR_LOAN_APPLICATION	CITIZEN_IND
RPRLAPP_CONF_DATE	RPAELAP	AR_LOAN_APPLICATION	SERVICER_CONFIRMATION_DATE
RPRLAPP_COSIGN1_ADDR_LINE1	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_STREET_LINE1
RPRLAPP_COSIGN1_ADDR_LINE2	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_STREET_LINE2
RPRLAPP_COSIGN1_BIRTH_DATE	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_BIRTH_DATE
RPRLAPP_COSIGN1_CITY	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_CITY
RPRLAPP_COSIGN1_CITZ_IND	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_CITIZEN_IND
RPRLAPP_COSIGN1_DRIVER_LIC_NO	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_DRIVER_LIC_NO
RPRLAPP_COSIGN1_FIRST_NAME	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_FIRST_NAME
RPRLAPP_COSIGN1_FOR_POST_CDE	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_FOREIGN_POSTAL_CODE
RPRLAPP_COSIGN1_GROSS_YR_SAL	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_ANNUAL_INCOME
RPRLAPP_COSIGN1_LAST_NAME	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_LAST_NAME
RPRLAPP_COSIGN1_MI	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_MIDDLE_INITIAL
RPRLAPP_COSIGN1_OTH_INC	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_OTHER_INCOME
RPRLAPP_COSIGN1_PHONE_NO	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_PHONE_NUMBER_COMBINED
RPRLAPP_COSIGN1_RELATION_IND	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_RELATIONSHIP
RPRLAPP_COSIGN1_SIGNED_IND	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_SIGNATURE_IND
RPRLAPP_COSIGN1_SSN	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_TAX_ID
RPRLAPP_COSIGN1_STAT_CODE	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_STATE_PROVINCE
RPRLAPP_COSIGN1_STAT_CODE_LIC	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_DRIVER_LIC_STAT
RPRLAPP_COSIGN1_SUFFIX	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_SUFFIX
RPRLAPP_COSIGN1_YR_ADDRESS	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_YRS_AT_ADDRESS
RPRLAPP_COSIGN1_ZIP	RPAELAP	AR_LOAN_APPLICATION	COSIGN1_POSTAL_CODE
RPRLAPP_COSIGN2_ADDR_LINE1	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_STREET_LINE1
RPRLAPP_COSIGN2_ADDR_LINE2	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_STREET_LINE2
RPRLAPP_COSIGN2_BIRTH_DATE	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_BIRTH_DATE
RPRLAPP_COSIGN2_CITY	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_CITY
RPRLAPP_COSIGN2_CITZ_IND	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_CITIZEN_IND
RPRLAPP_COSIGN2_DRIVER_LIC_NO	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_DRIVER_LIC_NO
RPRLAPP_COSIGN2_FIRST_NAME	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_FIRST_NAME
RPRLAPP_COSIGN2_FOR_POST_CDE	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_FOREIGN_POSTAL_CODE
RPRLAPP_COSIGN2_GROSS_YR_SAL	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_ANNUAL_INCOME
RPRLAPP_COSIGN2_LAST_NAME	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_LAST_NAME
RPRLAPP_COSIGN2_MI	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_MIDDLE_INITIAL
RPRLAPP_COSIGN2_OTH_INC	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_OTHER_INCOME
RPRLAPP_COSIGN2_PHONE_NO	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_PHONE_NUMBER_COMBINED
RPRLAPP_COSIGN2_RELATION_IND	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_RELATIONSHIP
RPRLAPP_COSIGN2_SIGNED_IND	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_SIGNATURE_IND
RPRLAPP_COSIGN2_SSN	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_TAX_ID
RPRLAPP_COSIGN2_STAT_CODE	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_STATE_PROVINCE
RPRLAPP_COSIGN2_STAT_CODE_LIC	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_DRIVER_LIC_STAT_PROV
RPRLAPP_COSIGN2_SUFFIX	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_SUFFIX
RPRLAPP_COSIGN2_YR_ADDRESS	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_YRS_AT_ADDRESS
RPRLAPP_COSIGN2_ZIP_CODE	RPAELAP	AR_LOAN_APPLICATION	COSIGN2_POSTAL_CODE
RPRLAPP_CREATE_DATE	RPAELAP	AR_LOAN_APPLICATION	CREATE_DATE
RPRLAPP_CREDIT_CHECK_DATE	RPAELAP	AR_LOAN_APPLICATION	PLUS_CREDIT_CHECK_DATE
RPRLAPP_CREDIT_CHECK_IND	RPAELAP	AR_LOAN_APPLICATION	PLUS_CREDIT_CHECK_STATUS
RPRLAPP_CRED_DIF_NM_IND	RPAELAP	AR_LOAN_APPLICATION	CREDIT_IN_DIFF_NAME_IND
RPRLAPP_DISC_NEED_PRINT_FLAG	RPAELAP	AR_LOAN_APPLICATION	DISCLOSURE_NEED_PRINT_FLAG
RPRLAPP_DISC_PRINT_DATE	RPAELAP	AR_LOAN_APPLICATION	DISCLOSURE_PRINT_DATE
RPRLAPP_DISC_PRINT_IND	RPAELAP	AR_LOAN_APPLICATION	DISCLOSURE_PRINT_IND
RPRLAPP_DL_LOAN_ID	RPAELAP	AR_LOAN_APPLICATION	DL_LOAN_ID
RPRLAPP_DL_REBATE_PERCENT	RPAELAP	AR_LOAN_APPLICATION	DL_REBATE_FEE_PERCENT
RPRLAPP_DL_RECON_REJECT_1	RPAELAP	AR_LOAN_APPLICATION	DL_RECON_REJECT1
RPRLAPP_DL_RECON_REJECT_2	RPAELAP	AR_LOAN_APPLICATION	DL_RECON_REJECT2
RPRLAPP_DL_RECON_REJECT_3	RPAELAP	AR_LOAN_APPLICATION	DL_RECON_REJECT3
RPRLAPP_DL_RECON_REJECT_4	RPAELAP	AR_LOAN_APPLICATION	DL_RECON_REJECT4
RPRLAPP_DL_RECON_REJECT_5	RPAELAP	AR_LOAN_APPLICATION	DL_RECON_REJECT5
RPRLAPP_DL_RECON_STATUS	RPAELAP	AR_LOAN_APPLICATION	BOOKING_STATUS
RPRLAPP_DL_REJECT_CODE_1	RPAELAP	AR_LOAN_APPLICATION	DL_REJECT_CODE1
RPRLAPP_DL_REJECT_CODE_2	RPAELAP	AR_LOAN_APPLICATION	DL_REJECT_CODE2
RPRLAPP_DL_REJECT_CODE_3	RPAELAP	AR_LOAN_APPLICATION	DL_REJECT_CODE3
RPRLAPP_DL_REJECT_CODE_4	RPAELAP	AR_LOAN_APPLICATION	DL_REJECT_CODE4
RPRLAPP_DL_REJECT_CODE_5	RPAELAP	AR_LOAN_APPLICATION	DL_REJECT_CODE5
RPRLAPP_DL_SENT_DATE	RPAELAP	AR_LOAN_APPLICATION	DL_SENT_DATE
RPRLAPP_DL_SEQ_NO	RPAELAP	AR_LOAN_APPLICATION	DL_SEQ_NO
RPRLAPP_DL_STATUS	RPAELAP	AR_LOAN_APPLICATION	DL_LOAN_STATUS
RPRLAPP_DRIVER_LIC_NO	RPAELAP	AR_LOAN_APPLICATION	DRIVER_LICENSE_NO
RPRLAPP_EL_DATE_SENT	RPAELAP	AR_LOAN_APPLICATION	EL_DATE_SENT
RPRLAPP_EL_LOAN_ID	RPAELAP	AR_LOAN_APPLICATION	EL_LOAN_ID
RPRLAPP_EL_PROCESS_TYPE	RPAELAP	AR_LOAN_APPLICATION	EL_PROCESS_TYPE
RPRLAPP_EL_SEQ_NO	RPAELAP	AR_LOAN_APPLICATION	EL_SEQ_NO
RPRLAPP_EL_STATUS	RPAELAP	AR_LOAN_APPLICATION	EL_LOAN_STATUS
RPRLAPP_ENROLL_START_DATE	RPAELAP	AR_LOAN_APPLICATION	ENROLL_START_DATE
RPRLAPP_EXPECT_AMT	RPAELAP	AR_LOAN_APPLICATION	EXPECTED_AMT
RPRLAPP_EXP_GRAD_DATE	RPAELAP	AR_LOAN_APPLICATION	EXPECTED_GRAD_DATE
RPRLAPP_FEE_PCT	RPAELAP	AR_LOAN_APPLICATION	LOAN_FEE
RPRLAPP_FIRST_NAME	RPAELAP	AR_LOAN_APPLICATION	FIRST_NAME
RPRLAPP_FORMER_HEAL_IND	RPAELAP	AR_LOAN_APPLICATION	FORMER_HEAL_IND
RPRLAPP_FUND_CODE	RPAELAP	AR_LOAN_APPLICATION	FUND
RPRLAPP_GUAR_PIDM	NA	AR_LOAN_APPLICATION	GUARANTOR_UID
RPRLAPP_HEAL_DEBT	RPAELAP	AR_LOAN_APPLICATION	HEAL_LOAN_DEBT
RPRLAPP_HOLD_IND	RPAELAP	AR_LOAN_APPLICATION	LOCK_IND
RPRLAPP_INT_RATE_OPT_IND	RPAELAP	AR_LOAN_APPLICATION	INTEREST_RATE_OPTION_CODE
RPRLAPP_IN_DEFAULT	RPAELAP	AR_LOAN_APPLICATION	DEFAULT_IND
RPRLAPP_LAST_NAME	RPAELAP	AR_LOAN_APPLICATION	LAST_NAME
RPRLAPP_LENDER_PIDM	NA	AR_LOAN_APPLICATION	LENDER_UID
RPRLAPP_LNST_CODE	RPAELAP	AR_LOAN_APPLICATION	LOAN_STATUS
RPRLAPP_LOAN_PERIOD	RPAELAP	AR_LOAN_APPLICATION	LOAN_PERIOD
RPRLAPP_LOCAL_ADDRESS	RPAELAP	AR_LOAN_APPLICATION	LOCAL_STREET_LINE1
RPRLAPP_LOCAL_ADDR_LINE2	RPAELAP	AR_LOAN_APPLICATION	LOCAL_STREET_LINE2
RPRLAPP_LOCAL_CITY	RPAELAP	AR_LOAN_APPLICATION	LOCAL_CITY
RPRLAPP_LOCAL_NATN_CODE	RPAELAP	AR_LOAN_APPLICATION	LOCAL_NATION
RPRLAPP_LOCAL_PHONE_NO	RPAELAP	AR_LOAN_APPLICATION	LOCAL_PHONE_NUMBER_COMBINED
RPRLAPP_LOCAL_STAT_CODE	RPAELAP	AR_LOAN_APPLICATION	LOCAL_STATE_PROVINCE
RPRLAPP_LOCAL_ZIP	RPAELAP	AR_LOAN_APPLICATION	LOCAL_POSTAL_CODE
RPRLAPP_MAX_ELIG_AMT	RPAELAP	AR_LOAN_APPLICATION	MAXIMUM_ELIGIBLE_AMT
RPRLAPP_MI	RPAELAP	AR_LOAN_APPLICATION	MIDDLE_INITIAL
RPRLAPP_MODEL_CDE	RPAELAP	AR_LOAN_APPLICATION	DEPENDENCY_STATUS
RPRLAPP_MPN_BATCH_ID	RPAELAP	AR_LOAN_APPLICATION	MPN_BATCH_ID
RPRLAPP_MPN_ID	RPAELAP	AR_LOAN_APPLICATION	MPN_ID
RPRLAPP_MPN_STATUS_IND	RPAELAP	AR_LOAN_APPLICATION	MPN_STATUS_IND
RPRLAPP_NATN_CODE	RPAELAP	AR_LOAN_APPLICATION	NATION
RPRLAPP_OTHER_DEBT	RPAELAP	AR_LOAN_APPLICATION	OTHER_LOAN_DEBT
RPRLAPP_OTH_LOANS_PERIOD	RPAELAP	AR_LOAN_APPLICATION	OTHER_LOANS_FOR_LN_PERIOD
RPRLAPP_OWES_REFUND	RPAELAP	AR_LOAN_APPLICATION	OWES_REFUND_IND
RPRLAPP_PAR_ADDRESS	RPAELAP	AR_LOAN_APPLICATION	PARENT_STREET_LINE1
RPRLAPP_PAR_ADDR_LINE2	RPAELAP	AR_LOAN_APPLICATION	PARENT_STREET_LINE2
RPRLAPP_PAR_ALIEN_REG_NO	RPAELAP	AR_LOAN_APPLICATION	PARENT_ALIEN_REGISTRATION_NO
RPRLAPP_PAR_BIRTH_DATE	RPAELAP	AR_LOAN_APPLICATION	PARENT_BIRTH_DATE
RPRLAPP_PAR_CITY	RPAELAP	AR_LOAN_APPLICATION	PARENT_CITY
RPRLAPP_PAR_CITZ_IND	RPAELAP	AR_LOAN_APPLICATION	PARENT_CITIZEN_IND
RPRLAPP_PAR_DRIVER_LIC_NO	RPAELAP	AR_LOAN_APPLICATION	PARENT_DRIVER_LICENSE_NO
RPRLAPP_PAR_FIRST_NAME	RPAELAP	AR_LOAN_APPLICATION	PARENT_FIRST_NAME
RPRLAPP_PAR_IN_DEFAULT	RPAELAP	AR_LOAN_APPLICATION	PARENT_DEFAULT_IND
RPRLAPP_PAR_LAST_NAME	RPAELAP	AR_LOAN_APPLICATION	PARENT_LAST_NAME
RPRLAPP_PAR_LOCAL_ADDRESS	RPAELAP	AR_LOAN_APPLICATION	PARENT_LOCAL_STREET_LINE1
RPRLAPP_PAR_LOCAL_ADDR_LINE2	RPAELAP	AR_LOAN_APPLICATION	PARENT_LOCAL_STREET_LINE2
RPRLAPP_PAR_LOCAL_CITY	RPAELAP	AR_LOAN_APPLICATION	PARENT_LOCAL_CITY
RPRLAPP_PAR_LOCAL_NATN_CODE	RPAELAP	AR_LOAN_APPLICATION	PARENT_LOCAL_NATION
RPRLAPP_PAR_LOCAL_STAT_CODE	RPAELAP	AR_LOAN_APPLICATION	PARENT_LOCAL_STATE_PROVINCE
RPRLAPP_PAR_LOCAL_ZIP	RPAELAP	AR_LOAN_APPLICATION	PARENT_LOCAL_POSTAL_CODE
RPRLAPP_PAR_MI	RPAELAP	AR_LOAN_APPLICATION	PARENT_MIDDLE_INITIAL
RPRLAPP_PAR_NATN_CODE	RPAELAP	AR_LOAN_APPLICATION	PARENT_NATION
RPRLAPP_PAR_PHONE_NO	RPAELAP	AR_LOAN_APPLICATION	PARENT_PHONE_NUMBER_COMBINED
RPRLAPP_PAR_SSN	RPAELAP	AR_LOAN_APPLICATION	PARENT_TAX_ID
RPRLAPP_PAR_STATE	RPAELAP	AR_LOAN_APPLICATION	PARENT_STATE_PROVINCE
RPRLAPP_PAR_STAT_CODE_LIC	RPAELAP	AR_LOAN_APPLICATION	PARENT_DRIVER_LIC_STATE_PROV
RPRLAPP_PAR_STAT_CODE_RES	RPAELAP	AR_LOAN_APPLICATION	PARENT_STATE_PROVINCE_OF_RES
RPRLAPP_PAR_ZIP	RPAELAP	AR_LOAN_APPLICATION	PARENT_POSTAL_CODE
RPRLAPP_PERKINS_DEBT	RPAELAP	AR_LOAN_APPLICATION	PERKINS_LOAN_DEBT
RPRLAPP_PHONE_NO	RPAELAP	AR_LOAN_APPLICATION	PHONE_NUMBER_COMBINED
RPRLAPP_PIDM	NA	AR_LOAN_APPLICATION	PERSON_UID
RPRLAPP_PLUS_TO_STUDENT	RPAELAP	AR_LOAN_APPLICATION	PLUS_TO_STUDENT_IND
RPRLAPP_PN_DATE	RPAELAP	AR_LOAN_APPLICATION	PROM_NOTE_DATE
RPRLAPP_PROCESS_DATE	RPAELAP	AR_LOAN_APPLICATION	PROCESS_DATE
RPRLAPP_RECEIVE_DATE	RPAELAP	AR_LOAN_APPLICATION	APP_RECEIVED_DATE
RPRLAPP_RECOMMEND_AMT	RPAELAP	AR_LOAN_APPLICATION	RECOMMENDED_AMT
RPRLAPP_RECORD_TYPE	RPAELAP	AR_LOAN_APPLICATION	RECORD_TYPE
RPRLAPP_REPAY_OPT_IND	RPAELAP	AR_LOAN_APPLICATION	REPAYMENT_OPTION_CODE
RPRLAPP_REQUEST_AMT	RPAELAP	AR_LOAN_APPLICATION	REQUESTED_AMT
RPRLAPP_RETURN_PIDM	NA	AR_LOAN_APPLICATION	RETURN_UID
RPRLAPP_SLS_LOAN_DEBT	RPAELAP	AR_LOAN_APPLICATION	SLS_LOAN_DEBT
RPRLAPP_SSN	RPAELAP	AR_LOAN_APPLICATION	TAX_ID
RPRLAPP_STAF_LOAN_DEBT	RPAELAP	AR_LOAN_APPLICATION	STAFFORD_LOAN_DEBT
RPRLAPP_STATE	RPAELAP	AR_LOAN_APPLICATION	STATE_PROVINCE_OF_RESIDENCE
RPRLAPP_STAT_CODE_LIC	RPAELAP	AR_LOAN_APPLICATION	DRIVER_LICENSE_STATE_PROVINCE
RPRLAPP_STU_EMAIL	RPAELAP	AR_LOAN_APPLICATION	STUDENT_EMAIL_ADDRESS
RPRLAPP_STU_MAJOR	RPAELAP	AR_LOAN_APPLICATION	STUDENT_MAJOR
RPRLAPP_SUB_DATE	RPAELAP	AR_LOAN_APPLICATION	SUBMISSION_DATE
RPRLAPP_XREF_LOAN_ID	RPAELAP	AR_LOAN_APPLICATION	XREF_LOAN_ID
RPRLAPP_ZIP	RPAELAP	AR_LOAN_APPLICATION	POSTAL_CODE

Ver: 8.3