Reporting View Source: RPRLAPP

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: RPRLAPP Financial Aid Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
RPRLAPP_ACAD_YR_END_DATE	RPAELAP	LOAN_APPLICATION	ACADEMIC_YEAR_END_DATE
RPRLAPP_ACAD_YR_START_DATE	RPAELAP	LOAN_APPLICATION	ACADEMIC_YEAR_START_DATE
RPRLAPP_ADDL_STFD_ELIG_IND	RPAELAP	LOAN_APPLICATION	ADDITIONAL_STAFFORD_ELIG_IND
RPRLAPP_ADDRESS	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	STREET_LINE1 STREET_LINE1
RPRLAPP_ADDR_LINE2	RPAELAP	LOAN_DISBURSEMENT LOAN_APPLICATION	STREET_LINE2 STREET_LINE2
RPRLAPP_AIDY_CODE	RPAELAP	LOAN_APPLICATION	AID_YEAR
RPRLAPP_ALIEN_REG_NO	RPAELAP	LOAN_APPLICATION	ALIEN_REGISTRATION_NUMBER
RPRLAPP_ALT_BOR_LOAN_DEBT	RPAELAP	LOAN_APPLICATION	ALT_LOAN_BORROWER_LOAN_DEBT
RPRLAPP_ALT_LOAN_PROG_TYPE_CDE	RPAELAP	LOAN_APPLICATION	ALT_LOAN_PROGRAM_TYPE
RPRLAPP_ALT_LOAN_SB_IND	RPAELAP	LOAN_APPLICATION	ALT_LOAN_STUDENT_BORROWER_IND
RPRLAPP_APPL_NO	RPAELAP	LOAN_APPLICATION	LOAN_APPLICATION_NUMBER
RPRLAPP_APPROVE_AMT	RPAELAP	LOAN_APPLICATION	APPROVED_AMOUNT
RPRLAPP_APPROVE_DATE	RPAELAP	LOAN_APPLICATION	APPROVED_DATE
RPRLAPP_APP_PHASE_CDE	RPAELAP	LOAN_APPLICATION	PROCESSING_APP_PHASE_CRNT_LOAN
RPRLAPP_APP_VER_NO	RPAELAP	LOAN_APPLICATION	COMMONLINE_APP_VERSION_NUMBER
RPRLAPP_BATCH_NO	RPAELAP	LOAN_APPLICATION	BATCH_ID_FOR_DIRECT_LOAN
RPRLAPP_BOR_GROSS_YR_SAL	RPAELAP	LOAN_APPLICATION	BORROWER_ANNUAL_INCOME
RPRLAPP_BOR_OTH_INC	RPAELAP	LOAN_APPLICATION	BORROWER_OTHER_INCOME
RPRLAPP_CANCEL_DATE	RPAELAP	LOAN_APPLICATION	CANCEL_INACTIVATED_DATE
RPRLAPP_CANCEL_IND	RPAELAP	LOAN_APPLICATION	CANCEL_INACTIVATED_IND
RPRLAPP_CERT_DATE	RPAELAP	LOAN_APPLICATION	CERTIFICATION_DATE
RPRLAPP_CITY	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	CITY CITY
RPRLAPP_CITZ_IND	RPAELAP	LOAN_APPLICATION	CITIZEN_IND
RPRLAPP_CONF_DATE	RPAELAP	LOAN_APPLICATION	SERVICER_CONFIRMATION_DATE
RPRLAPP_COSIGN1_ADDR_LINE1	RPAELAP	LOAN_APPLICATION	COSIGN1_STREET_LINE1
RPRLAPP_COSIGN1_ADDR_LINE2	RPAELAP	LOAN_APPLICATION	COSIGN1_STREET_LINE2
RPRLAPP_COSIGN1_BIRTH_DATE	RPAELAP	LOAN_APPLICATION	COSIGN1_BIRTH_DATE
RPRLAPP_COSIGN1_CITY	RPAELAP	LOAN_APPLICATION	COSIGN1_CITY
RPRLAPP_COSIGN1_CITZ_IND	RPAELAP	LOAN_APPLICATION	COSIGN1_CITIZEN_IND
RPRLAPP_COSIGN1_DRIVER_LIC_NO	RPAELAP	LOAN_APPLICATION	COSIGN1_DR_LIC_NUMBER
RPRLAPP_COSIGN1_FIRST_NAME	RPAELAP	LOAN_APPLICATION	COSIGN1_FIRST_NAME
RPRLAPP_COSIGN1_FOR_POST_CDE	RPAELAP	LOAN_APPLICATION	COSIGN1_FOREIGN_POSTAL_CODE
RPRLAPP_COSIGN1_GROSS_YR_SAL	RPAELAP	LOAN_APPLICATION	COSIGN1_ANNUAL_INCOME
RPRLAPP_COSIGN1_LAST_NAME	RPAELAP	LOAN_APPLICATION	COSIGN1_LAST_NAME
RPRLAPP_COSIGN1_MI	RPAELAP	LOAN_APPLICATION	COSIGN1_MIDDLE_INITIAL
RPRLAPP_COSIGN1_OTH_INC	RPAELAP	LOAN_APPLICATION	COSIGN1_OTHER_INCOME
RPRLAPP_COSIGN1_PHONE_NO	RPAELAP	LOAN_APPLICATION	COSIGN1_PHONE_NUMBER_COMBINED
RPRLAPP_COSIGN1_RELATION_IND	RPAELAP	LOAN_APPLICATION	COSIGN1_RELATIONSHIP
RPRLAPP_COSIGN1_SIGNED_IND	RPAELAP	LOAN_APPLICATION	COSIGN1_SIGNATURE_IND
RPRLAPP_COSIGN1_SSN	RPAELAP	LOAN_APPLICATION	COSIGN1_TAX_ID
RPRLAPP_COSIGN1_STAT_CODE	RPAELAP	LOAN_APPLICATION	COSIGN1_STATE_PROVINCE
RPRLAPP_COSIGN1_STAT_CODE_LIC	RPAELAP	LOAN_APPLICATION	COSIGN1_DR_LIC_STATE_PROV
RPRLAPP_COSIGN1_SUFFIX	RPAELAP	LOAN_APPLICATION	COSIGN1_SUFFIX
RPRLAPP_COSIGN1_YR_ADDRESS	RPAELAP	LOAN_APPLICATION	COSIGN1_YRS_AT_ADDRESS
RPRLAPP_COSIGN1_ZIP	RPAELAP	LOAN_APPLICATION	COSIGN1_POSTAL_CODE
RPRLAPP_COSIGN2_ADDR_LINE1	RPAELAP	LOAN_APPLICATION	COSIGN2_STREET_LINE1
RPRLAPP_COSIGN2_ADDR_LINE2	RPAELAP	LOAN_APPLICATION	COSIGN2_STREET_LINE2
RPRLAPP_COSIGN2_BIRTH_DATE	RPAELAP	LOAN_APPLICATION	COSIGN2_BIRTH_DATE
RPRLAPP_COSIGN2_CITY	RPAELAP	LOAN_APPLICATION	COSIGN2_CITY
RPRLAPP_COSIGN2_CITZ_IND	RPAELAP	LOAN_APPLICATION	COSIGN2_CITIZEN_IND
RPRLAPP_COSIGN2_DRIVER_LIC_NO	RPAELAP	LOAN_APPLICATION	COSIGN2_DR_LIC_NUMBER
RPRLAPP_COSIGN2_FIRST_NAME	RPAELAP	LOAN_APPLICATION	COSIGN2_FIRST_NAME
RPRLAPP_COSIGN2_FOR_POST_CDE	RPAELAP	LOAN_APPLICATION	COSIGN2_FOREIGN_POSTAL_CODE
RPRLAPP_COSIGN2_GROSS_YR_SAL	RPAELAP	LOAN_APPLICATION	COSIGN2_ANNUAL_INCOME
RPRLAPP_COSIGN2_LAST_NAME	RPAELAP	LOAN_APPLICATION	COSIGN2_LAST_NAME
RPRLAPP_COSIGN2_MI	RPAELAP	LOAN_APPLICATION	COSIGN2_MIDDLE_INITIAL
RPRLAPP_COSIGN2_OTH_INC	RPAELAP	LOAN_APPLICATION	COSIGN2_OTHER_INCOME
RPRLAPP_COSIGN2_PHONE_NO	RPAELAP	LOAN_APPLICATION	COSIGN2_PHONE_NUMBER_COMBINED
RPRLAPP_COSIGN2_RELATION_IND	RPAELAP	LOAN_APPLICATION	COSIGN2_RELATIONSHIP
RPRLAPP_COSIGN2_SIGNED_IND	RPAELAP	LOAN_APPLICATION	COSIGN2_SIGNATURE_IND
RPRLAPP_COSIGN2_SSN	RPAELAP	LOAN_APPLICATION	COSIGN2_TAX_ID
RPRLAPP_COSIGN2_STAT_CODE	RPAELAP	LOAN_APPLICATION	COSIGN2_STATE_PROVINCE
RPRLAPP_COSIGN2_STAT_CODE_LIC	RPAELAP	LOAN_APPLICATION	COSIGN2_DR_LIC_STATE_PROV
RPRLAPP_COSIGN2_SUFFIX	RPAELAP	LOAN_APPLICATION	COSIGN2_SUFFIX
RPRLAPP_COSIGN2_YR_ADDRESS	RPAELAP	LOAN_APPLICATION	COSIGN2_YRS_AT_ADDRESS
RPRLAPP_COSIGN2_ZIP_CODE	RPAELAP	LOAN_APPLICATION	COSIGN2_POSTAL_CODE
RPRLAPP_CREATE_DATE	RPAELAP	LOAN_APPLICATION	LOAN_APP_CREATE_DATE
RPRLAPP_CREDIT_CHECK_DATE	RPAELAP	LOAN_APPLICATION	PLUS_CREDIT_CHECK_DATE
RPRLAPP_CREDIT_CHECK_IND	RPAELAP	LOAN_APPLICATION	PLUS_CREDIT_CHECK_STATUS
RPRLAPP_CRED_DIF_NM_IND	RPAELAP	LOAN_APPLICATION	CREDIT_IN_DIFFERENT_NAME_IND
RPRLAPP_DISC_NEED_PRINT_FLAG	RPAELAP	LOAN_APPLICATION	DISCLOSURE_REQUIRED_IND
RPRLAPP_DISC_PRINT_DATE	RPAELAP	LOAN_APPLICATION	DISCLOSURE_PRINT_DATE
RPRLAPP_DISC_PRINT_IND	RPAELAP	LOAN_APPLICATION	DISCLOSURE_PRINT_IND
RPRLAPP_DL_LOAN_ID	RPAELAP	LOAN_APPLICATION	DIRECT_LOAN_ID
RPRLAPP_DL_REBATE_PERCENT	RPAELAP	LOAN_APPLICATION	DL_REBATE_FEE_PERCENT
RPRLAPP_DL_RECON_REJECT_1	RPAELAP	LOAN_APPLICATION	DL_DISB_RECON_REJECT_1
RPRLAPP_DL_RECON_REJECT_2	RPAELAP	LOAN_APPLICATION	DL_DISB_RECON_REJECT_2
RPRLAPP_DL_RECON_REJECT_3	RPAELAP	LOAN_APPLICATION	DL_DISB_RECON_REJECT_3
RPRLAPP_DL_RECON_REJECT_4	RPAELAP	LOAN_APPLICATION	DL_DISB_RECON_REJECT_4
RPRLAPP_DL_RECON_REJECT_5	RPAELAP	LOAN_APPLICATION	DL_DISB_RECON_REJECT_5
RPRLAPP_DL_RECON_STATUS	RPAELAP	LOAN_APPLICATION	DL_BOOKING_STATUS
RPRLAPP_DL_REJECT_CODE_1	RPAELAP	LOAN_APPLICATION	DL_ORIGINATION_REJECT_1
RPRLAPP_DL_REJECT_CODE_2	RPAELAP	LOAN_APPLICATION	DL_ORIGINATION_REJECT_2
RPRLAPP_DL_REJECT_CODE_3	RPAELAP	LOAN_APPLICATION	DL_ORIGINATION_REJECT_3
RPRLAPP_DL_REJECT_CODE_4	RPAELAP	LOAN_APPLICATION	DL_ORIGINATION_REJECT_4
RPRLAPP_DL_REJECT_CODE_5	RPAELAP	LOAN_APPLICATION	DL_ORIGINATION_REJECT_5
RPRLAPP_DL_SENT_DATE	RPAELAP	LOAN_APPLICATION	DIRECT_LOAN_DATE_SENT
RPRLAPP_DL_SEQ_NO	RPAELAP	LOAN_APPLICATION	DIRECT_LOAN_NUMBER
RPRLAPP_DL_STATUS	RPAELAP	LOAN_APPLICATION	DIRECT_LOAN_STATUS
RPRLAPP_DRIVER_LIC_NO	RPAELAP	LOAN_APPLICATION	DRIVER_LICENSE_NUMBER
RPRLAPP_EL_DATE_SENT	RPAELAP	LOAN_APPLICATION	COMMONLINE_LOAN_DATE_SENT
RPRLAPP_EL_LOAN_ID	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	COMMONLINE_LOAN_ID EL_LOAN_ID
RPRLAPP_EL_PROCESS_TYPE	RPAELAP
RPRLAPP_EL_SEQ_NO	RPAELAP	LOAN_APPLICATION	COMMONLINE_LOAN_SEQ_NUMBER
RPRLAPP_EL_STATUS	RPAELAP	LOAN_APPLICATION	COMMONLINE_LOAN_STATUS
RPRLAPP_ENROLL_START_DATE	RPAELAP	LOAN_APPLICATION	ENROLL_START_DATE
RPRLAPP_EXPECT_AMT	RPAELAP	LOAN_APPLICATION	EXPECTED_AMOUNT
RPRLAPP_EXP_GRAD_DATE	RPAELAP	LOAN_APPLICATION	EXPECTED_GRADUATION_DATE
RPRLAPP_FEE_PCT	RPAELAP	LOAN_APPLICATION	LOAN_FEE
RPRLAPP_FIRST_NAME	RPAELAP
RPRLAPP_FORMER_HEAL_IND	RPAELAP	LOAN_APPLICATION	FORMER_HEAL_INDICATOR
RPRLAPP_FUND_CODE	RPAELAP	LOAN_APPLICATION	FUND
RPRLAPP_GUAR_PIDM	NA
RPRLAPP_HEAL_DEBT	RPAELAP	LOAN_APPLICATION	HEAL_LOAN_DEBT
RPRLAPP_HOLD_IND	RPAELAP	LOAN_APPLICATION	LOCK_INDICATOR
RPRLAPP_INT_RATE_OPT_IND	RPAELAP	LOAN_APPLICATION	INTEREST_RATE_OPTION
RPRLAPP_IN_DEFAULT	RPAELAP	LOAN_DISBURSEMENT LOAN_APPLICATION	DEFAULT_IND DEFAULT_IND
RPRLAPP_LAST_NAME	RPAELAP
RPRLAPP_LENDER_PIDM	NA
RPRLAPP_LNST_CODE	RPAELAP	LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT	LOAN_STATUS COMMONLINE_PROCESSING_STATUS LOAN_STATUS
RPRLAPP_LOAN_PERIOD	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	LOAN_PERIOD LOAN_PERIOD
RPRLAPP_LOCAL_ADDRESS	RPAELAP	LOAN_APPLICATION	LOCAL_STREET_LINE1
RPRLAPP_LOCAL_ADDR_LINE2	RPAELAP	LOAN_APPLICATION	LOCAL_STREET_LINE2
RPRLAPP_LOCAL_CITY	RPAELAP	LOAN_APPLICATION	LOCAL_CITY
RPRLAPP_LOCAL_NATN_CODE	RPAELAP	LOAN_APPLICATION	LOCAL_NATION
RPRLAPP_LOCAL_PHONE_NO	RPAELAP	LOAN_APPLICATION	LOCAL_PHONE_NUMBER_COMBINED
RPRLAPP_LOCAL_STAT_CODE	RPAELAP	LOAN_APPLICATION	LOCAL_STATE_PROVINCE
RPRLAPP_LOCAL_ZIP	RPAELAP	LOAN_APPLICATION	LOCAL_POSTAL_CODE
RPRLAPP_MAX_ELIG_AMT	RPAELAP	LOAN_APPLICATION	MAXIMUM_ELIGIBLE_AMOUNT
RPRLAPP_MI	RPAELAP
RPRLAPP_MODEL_CDE	RPAELAP	LOAN_APPLICATION	DEPENDENCY_STATUS
RPRLAPP_MPN_BATCH_ID	RPAELAP	LOAN_APPLICATION	MPN_BATCH_ID
RPRLAPP_MPN_ID	RPAELAP	LOAN_APPLICATION	MPN_ID
RPRLAPP_MPN_STATUS_IND	RPAELAP	LOAN_APPLICATION	DL_MPN_STATUS_IND
RPRLAPP_NATN_CODE	RPAELAP	LOAN_APPLICATION	NATION
RPRLAPP_OTHER_DEBT	RPAELAP	LOAN_APPLICATION	OTHER_LOAN_DEBT
RPRLAPP_OTH_LOANS_PERIOD	RPAELAP	LOAN_APPLICATION	OTHER_LOANS_LOAN_PERIOD
RPRLAPP_OWES_REFUND	RPAELAP	LOAN_APPLICATION	OWES_REFUND_IND
RPRLAPP_PAR_ADDRESS	RPAELAP	LOAN_DISBURSEMENT LOAN_APPLICATION	PARENT_STREET_LINE1 PARENT_STREET_LINE1
RPRLAPP_PAR_ADDR_LINE2	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	PARENT_STREET_LINE2 PARENT_STREET_LINE2
RPRLAPP_PAR_ALIEN_REG_NO	RPAELAP	LOAN_APPLICATION	PARENT_ALIEN_REG_NUMBER
RPRLAPP_PAR_BIRTH_DATE	RPAELAP	LOAN_APPLICATION	PARENT_BIRTH_DATE
RPRLAPP_PAR_CITY	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	PARENT_CITY PARENT_CITY
RPRLAPP_PAR_CITZ_IND	RPAELAP	LOAN_APPLICATION	PARENT_CITIZEN_IND
RPRLAPP_PAR_DRIVER_LIC_NO	RPAELAP	LOAN_APPLICATION	PARENT_DRIVER_LICENSE_NUMBER
RPRLAPP_PAR_FIRST_NAME	RPAELAP	LOAN_APPLICATION	PARENT_FIRST_NAME
RPRLAPP_PAR_IN_DEFAULT	RPAELAP	LOAN_APPLICATION	PARENT_DEFAULT_IND
RPRLAPP_PAR_LAST_NAME	RPAELAP	LOAN_APPLICATION	PARENT_LAST_NAME
RPRLAPP_PAR_LOCAL_ADDRESS	RPAELAP	LOAN_APPLICATION	PARENT_LOCAL_STREET_LINE1
RPRLAPP_PAR_LOCAL_ADDR_LINE2	RPAELAP	LOAN_APPLICATION	PARENT_LOCAL_STREET_LINE2
RPRLAPP_PAR_LOCAL_CITY	RPAELAP	LOAN_APPLICATION	PARENT_LOCAL_CITY
RPRLAPP_PAR_LOCAL_NATN_CODE	RPAELAP	LOAN_APPLICATION	PARENT_LOCAL_NATION
RPRLAPP_PAR_LOCAL_STAT_CODE	RPAELAP	LOAN_APPLICATION	PARENT_LOCAL_STATE_PROVINCE
RPRLAPP_PAR_LOCAL_ZIP	RPAELAP	LOAN_APPLICATION	PARENT_LOCAL_POSTAL_CODE
RPRLAPP_PAR_MI	RPAELAP	LOAN_APPLICATION	PARENT_MIDDLE_INITIAL
RPRLAPP_PAR_NATN_CODE	RPAELAP	LOAN_APPLICATION	PARENT_NATION
RPRLAPP_PAR_PHONE_NO	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	PARENT_PHONE_NUMBER_COMBINED PARENT_PHONE_NUMBER_COMBINED
RPRLAPP_PAR_SSN	RPAELAP	LOAN_APPLICATION	PARENT_TAX_ID
RPRLAPP_PAR_STATE	RPAELAP	LOAN_DISBURSEMENT LOAN_APPLICATION	PARENT_STATE_PROVINCE PARENT_STATE_PROVINCE
RPRLAPP_PAR_STAT_CODE_LIC	RPAELAP	LOAN_APPLICATION	PARENT_DRIVER_LIC_STATE_PROV
RPRLAPP_PAR_STAT_CODE_RES	RPAELAP	LOAN_APPLICATION	PARENT_STATE_PROVINCE_OF_RES
RPRLAPP_PAR_ZIP	RPAELAP	LOAN_DISBURSEMENT LOAN_APPLICATION	PARENT_POSTAL_CODE PARENT_POSTAL_CODE
RPRLAPP_PERKINS_DEBT	RPAELAP	LOAN_APPLICATION	PERKINS_LOAN_DEBT
RPRLAPP_PHONE_NO	RPAELAP	LOAN_DISBURSEMENT LOAN_APPLICATION	PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED
RPRLAPP_PIDM	NA	LOAN_APPLICATION	PERSON_UID
RPRLAPP_PLUS_TO_STUDENT	RPAELAP	LOAN_APPLICATION	GIVE_PLUS_TO_STUDENT_IND
RPRLAPP_PN_DATE	RPAELAP	LOAN_APPLICATION	PROMISSORY_NOTE_DATE
RPRLAPP_PROCESS_DATE	RPAELAP	LOAN_APPLICATION	PROCESS_DATE
RPRLAPP_RECEIVE_DATE	RPAELAP	LOAN_APPLICATION	LOAN_APPLICATION_RECEIVED_DATE
RPRLAPP_RECOMMEND_AMT	RPAELAP	LOAN_APPLICATION	LOAN_RECOMMENDED_AMOUNT
RPRLAPP_RECORD_TYPE	RPAELAP	LOAN_APPLICATION	RECORD_TYPE
RPRLAPP_REPAY_OPT_IND	RPAELAP	LOAN_APPLICATION	REPAYMENT_OPTION_CODE
RPRLAPP_REQUEST_AMT	RPAELAP	LOAN_APPLICATION	APPLICANT_LOAN_REQUESTED_AMT
RPRLAPP_RETURN_PIDM	NA	LOAN_DISBURSEMENT	RETURN_UID
RPRLAPP_SLS_LOAN_DEBT	RPAELAP	LOAN_APPLICATION	SLS_LOAN_DEBT
RPRLAPP_SSN	RPAELAP
RPRLAPP_STAF_LOAN_DEBT	RPAELAP	LOAN_APPLICATION	STAFFORD_LOAN_DEBT
RPRLAPP_STATE	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	STATE_PROVINCE STATE_PROVINCE
RPRLAPP_STAT_CODE_LIC	RPAELAP	LOAN_APPLICATION	DRIVER_LICENSE_STATE_PROVINCE
RPRLAPP_STU_EMAIL	RPAELAP	LOAN_APPLICATION	EMAIL_ADDRESS
RPRLAPP_STU_MAJOR	RPAELAP	LOAN_APPLICATION	MAJOR
RPRLAPP_SUB_DATE	RPAELAP	LOAN_APPLICATION	SUBMISSION_DATE
RPRLAPP_XREF_LOAN_ID	RPAELAP	LOAN_DISBURSEMENT LOAN_APPLICATION	XREF_LOAN_ID XREF_LOAN_ID
RPRLAPP_ZIP	RPAELAP	LOAN_APPLICATION LOAN_DISBURSEMENT	POSTAL_CODE POSTAL_CODE

Ver: 8.3