RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: RPRLAPP Financial Aid Composite View Reports
SGHE Operational Data Store Composite View Source: RPRLAPP

Source Column Source Form Target Type Target Target Column Calculation Formula
RPRLAPP_ACAD_YR_END_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

ACAD_YEAR_END_DATE

NA
RPRLAPP_ACAD_YR_START_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

ACAD_YEAR_START_DATE

NA
RPRLAPP_ADDL_STFD_ELIG_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

ADDL_STAFFORD_ELIG_IND

NA
RPRLAPP_ADDRESS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

STREET_LINE1

NA
RPRLAPP_ADDR_LINE2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

STREET_LINE2

NA
RPRLAPP_AIDY_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

AID_YEAR

NA
RPRLAPP_ALIEN_REG_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

ALIEN_REGISTRATION_NO

NA
RPRLAPP_ALT_BOR_LOAN_DEBT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

ALT_LOAN_BORROWER_LN_DEBT

NA
RPRLAPP_ALT_LOAN_PROG_TYPE_CDE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

ALT_LOAN_PROGRAM_TYPE

NA
RPRLAPP_ALT_LOAN_SB_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

ALT_LOAN_STU_BORROWER_IND

NA
RPRLAPP_APPL_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOAN_APPLICATION_NO

NA
RPRLAPP_APPROVE_AMT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

APPROVED_AMT

NA
RPRLAPP_APPROVE_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

APPROVED_DATE

NA
RPRLAPP_APP_PHASE_CDE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

APP_PHASE_CODE

NA
RPRLAPP_APP_VER_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

APP_VERSION_NO

NA
RPRLAPP_BATCH_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

BATCH_ID

NA
RPRLAPP_BOR_GROSS_YR_SAL RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

BORROWER_ANNUAL_INCOME

NA
RPRLAPP_BOR_OTH_INC RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

BORROWER_OTHER_INCOME

NA
RPRLAPP_CANCEL_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

CANCEL_DATE

NA
RPRLAPP_CANCEL_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

CANCEL_IND

NA
RPRLAPP_CERT_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

CERTIFICATION_DATE

NA
RPRLAPP_CITY RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

CITY

NA
RPRLAPP_CITZ_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

CITIZEN_IND

NA
RPRLAPP_CONF_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

SERVICER_CONFIRMATION_DATE

NA
RPRLAPP_COSIGN1_ADDR_LINE1 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_STREET_LINE1

NA
RPRLAPP_COSIGN1_ADDR_LINE2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_STREET_LINE2

NA
RPRLAPP_COSIGN1_BIRTH_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_BIRTH_DATE

NA
RPRLAPP_COSIGN1_CITY RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_CITY

NA
RPRLAPP_COSIGN1_CITZ_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_CITIZEN_IND

NA
RPRLAPP_COSIGN1_DRIVER_LIC_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_DRIVER_LIC_NO

NA
RPRLAPP_COSIGN1_FIRST_NAME RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_FIRST_NAME

NA
RPRLAPP_COSIGN1_FOR_POST_CDE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_FOREIGN_POSTAL_CODE

NA
RPRLAPP_COSIGN1_GROSS_YR_SAL RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_ANNUAL_INCOME

NA
RPRLAPP_COSIGN1_LAST_NAME RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_LAST_NAME

NA
RPRLAPP_COSIGN1_MI RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_MIDDLE_INITIAL

NA
RPRLAPP_COSIGN1_OTH_INC RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_OTHER_INCOME

NA
RPRLAPP_COSIGN1_PHONE_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_PHONE_NUMBER_COMBINED

NA
RPRLAPP_COSIGN1_RELATION_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_RELATIONSHIP

NA
RPRLAPP_COSIGN1_SIGNED_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_SIGNATURE_IND

NA
RPRLAPP_COSIGN1_SSN RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_SSN

NA
RPRLAPP_COSIGN1_STAT_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_STATE_PROVINCE

NA
RPRLAPP_COSIGN1_STAT_CODE_LIC RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_DRIVER_LIC_STAT

NA
RPRLAPP_COSIGN1_SUFFIX RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_SUFFIX

NA
RPRLAPP_COSIGN1_YR_ADDRESS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_YRS_AT_ADDRESS

NA
RPRLAPP_COSIGN1_ZIP RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_POSTAL_CODE

NA
RPRLAPP_COSIGN2_ADDR_LINE1 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_STREET_LINE1

NA
RPRLAPP_COSIGN2_ADDR_LINE2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_STREET_LINE2

NA
RPRLAPP_COSIGN2_BIRTH_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_BIRTH_DATE

NA
RPRLAPP_COSIGN2_CITY RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_CITY

NA
RPRLAPP_COSIGN2_CITZ_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_CITIZEN_IND

NA
RPRLAPP_COSIGN2_DRIVER_LIC_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_DRIVER_LIC_NO

NA
RPRLAPP_COSIGN2_FIRST_NAME RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_FIRST_NAME

NA
RPRLAPP_COSIGN2_FOR_POST_CDE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_FOREIGN_POSTAL_CODE

NA
RPRLAPP_COSIGN2_GROSS_YR_SAL RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_ANNUAL_INCOME

NA
RPRLAPP_COSIGN2_LAST_NAME RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_LAST_NAME

NA
RPRLAPP_COSIGN2_MI RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_MIDDLE_INITIAL

NA
RPRLAPP_COSIGN2_OTH_INC RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_OTHER_INCOME

NA
RPRLAPP_COSIGN2_PHONE_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_PHONE_NUMBER_COMBINED

NA
RPRLAPP_COSIGN2_RELATION_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_RELATIONSHIP

NA
RPRLAPP_COSIGN2_SIGNED_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_SIGNATURE_IND

NA
RPRLAPP_COSIGN2_SSN RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_SSN

NA
RPRLAPP_COSIGN2_STAT_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_STATE_PROVINCE

NA
RPRLAPP_COSIGN2_STAT_CODE_LIC RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_DRIVER_LIC_STAT_PROV

NA
RPRLAPP_COSIGN2_SUFFIX RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_SUFFIX

NA
RPRLAPP_COSIGN2_YR_ADDRESS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_YRS_AT_ADDRESS

NA
RPRLAPP_COSIGN2_ZIP_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_POSTAL_CODE

NA
RPRLAPP_CREATE_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

CREATE_DATE

NA
RPRLAPP_CREDIT_CHECK_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PLUS_CREDIT_CHECK_DATE

NA
RPRLAPP_CREDIT_CHECK_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PLUS_CREDIT_CHECK_STATUS

NA
RPRLAPP_CRED_DIF_NM_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

CREDIT_IN_DIFF_NAME_IND

NA
RPRLAPP_DISC_NEED_PRINT_FLAG RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DISCLOSURE_NEED_PRINT_FLAG

NA
RPRLAPP_DISC_PRINT_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DISCLOSURE_PRINT_DATE

NA
RPRLAPP_DISC_PRINT_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DISCLOSURE_PRINT_IND

NA
RPRLAPP_DL_LOAN_ID RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_LOAN_ID

NA
RPRLAPP_DL_REBATE_PERCENT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_REBATE_FEE_PERCENT

NA
RPRLAPP_DL_RECON_REJECT_1 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_RECON_REJECT1

NA
RPRLAPP_DL_RECON_REJECT_2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_RECON_REJECT2

NA
RPRLAPP_DL_RECON_REJECT_3 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_RECON_REJECT3

NA
RPRLAPP_DL_RECON_REJECT_4 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_RECON_REJECT4

NA
RPRLAPP_DL_RECON_REJECT_5 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_RECON_REJECT5

NA
RPRLAPP_DL_RECON_STATUS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

BOOKING_STATUS

NA
RPRLAPP_DL_REJECT_CODE_1 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_REJECT_CODE1

NA
RPRLAPP_DL_REJECT_CODE_2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_REJECT_CODE2

NA
RPRLAPP_DL_REJECT_CODE_3 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_REJECT_CODE3

NA
RPRLAPP_DL_REJECT_CODE_4 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_REJECT_CODE4

NA
RPRLAPP_DL_REJECT_CODE_5 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_REJECT_CODE5

NA
RPRLAPP_DL_SENT_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_SENT_DATE

NA
RPRLAPP_DL_SEQ_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_SEQ_NO

NA
RPRLAPP_DL_STATUS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DL_LOAN_STATUS

NA
RPRLAPP_DRIVER_LIC_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DRIVER_LICENSE_NO

NA
RPRLAPP_EL_DATE_SENT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

EL_DATE_SENT

NA
RPRLAPP_EL_LOAN_ID RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

EL_LOAN_ID

NA
RPRLAPP_EL_PROCESS_TYPE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

EL_PROCESS_TYPE

NA
RPRLAPP_EL_SEQ_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

EL_SEQ_NO

NA
RPRLAPP_EL_STATUS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

EL_LOAN_STATUS

NA
RPRLAPP_ENROLL_START_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

ENROLL_START_DATE

NA
RPRLAPP_EXPECT_AMT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

EXPECTED_AMT

NA
RPRLAPP_EXP_GRAD_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

EXPECTED_GRAD_DATE

NA
RPRLAPP_FEE_PCT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOAN_FEE

NA
RPRLAPP_FORMER_HEAL_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

FORMER_HEAL_IND

NA
RPRLAPP_FUND_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

FUND

NA
RPRLAPP_GUAR_PIDM NA COMPOSITE VIEW

AR_LOAN_APPLICATION

GUARANTOR_UID

NA
RPRLAPP_HEAL_DEBT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

HEAL_LOAN_DEBT

NA
RPRLAPP_HOLD_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOCK_IND

NA
RPRLAPP_INT_RATE_OPT_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

INTEREST_RATE_OPTION_CODE

NA
RPRLAPP_IN_DEFAULT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DEFAULT_IND

NA
RPRLAPP_LENDER_PIDM NA COMPOSITE VIEW

AR_LOAN_APPLICATION

LENDER_UID

NA
RPRLAPP_LNST_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOAN_STATUS

NA
RPRLAPP_LOAN_PERIOD RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOAN_PERIOD

NA
RPRLAPP_LOCAL_ADDRESS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOCAL_STREET_LINE1

NA
RPRLAPP_LOCAL_ADDR_LINE2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOCAL_STREET_LINE2

NA
RPRLAPP_LOCAL_CITY RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOCAL_CITY

NA
RPRLAPP_LOCAL_NATN_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOCAL_NATION

NA
RPRLAPP_LOCAL_PHONE_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOCAL_PHONE_NUMBER_COMBINED

NA
RPRLAPP_LOCAL_STAT_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOCAL_STATE_PROVINCE

NA
RPRLAPP_LOCAL_ZIP RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

LOCAL_POSTAL_CODE

NA
RPRLAPP_MAX_ELIG_AMT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

MAXIMUM_ELIGIBLE_AMT

NA
RPRLAPP_MODEL_CDE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DEPENDENCY_STATUS

NA
RPRLAPP_MPN_BATCH_ID RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

MPN_BATCH_ID

NA
RPRLAPP_MPN_ID RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

MPN_ID

NA
RPRLAPP_MPN_STATUS_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

MPN_STATUS_IND

NA
RPRLAPP_NATN_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

NATION

NA
RPRLAPP_OTHER_DEBT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

OTHER_LOAN_DEBT

NA
RPRLAPP_OTH_LOANS_PERIOD RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

OTHER_LOANS_FOR_LN_PERIOD

NA
RPRLAPP_OWES_REFUND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

OWES_REFUND_IND

NA
RPRLAPP_PAR_ADDRESS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_STREET_LINE1

NA
RPRLAPP_PAR_ADDR_LINE2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_STREET_LINE2

NA
RPRLAPP_PAR_ALIEN_REG_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_ALIEN_REGISTRATION_NO

NA
RPRLAPP_PAR_BIRTH_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_BIRTH_DATE

NA
RPRLAPP_PAR_CITY RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_CITY

NA
RPRLAPP_PAR_CITZ_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_CITIZEN_IND

NA
RPRLAPP_PAR_DRIVER_LIC_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_DRIVER_LICENSE_NO

NA
RPRLAPP_PAR_FIRST_NAME RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_FIRST_NAME

NA
RPRLAPP_PAR_IN_DEFAULT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_DEFAULT_IND

NA
RPRLAPP_PAR_LAST_NAME RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_LAST_NAME

NA
RPRLAPP_PAR_LOCAL_ADDRESS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_LOCAL_STREET_LINE1

NA
RPRLAPP_PAR_LOCAL_ADDR_LINE2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_LOCAL_STREET_LINE2

NA
RPRLAPP_PAR_LOCAL_CITY RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_LOCAL_CITY

NA
RPRLAPP_PAR_LOCAL_NATN_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_LOCAL_NATION

NA
RPRLAPP_PAR_LOCAL_STAT_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_LOCAL_STATE_PROVINCE

NA
RPRLAPP_PAR_LOCAL_ZIP RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_LOCAL_POSTAL_CODE

NA
RPRLAPP_PAR_MI RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_MIDDLE_INITIAL

NA
RPRLAPP_PAR_NATN_CODE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_NATION

NA
RPRLAPP_PAR_PHONE_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_PHONE_NUMBER_COMBINED

NA
RPRLAPP_PAR_SSN RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_SSN

NA
RPRLAPP_PAR_STATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_STATE_PROVINCE

NA
RPRLAPP_PAR_STAT_CODE_LIC RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_DRIVER_LIC_STATE_PROV

NA
RPRLAPP_PAR_STAT_CODE_RES RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_STATE_PROVINCE_OF_RES

NA
RPRLAPP_PAR_ZIP RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PARENT_POSTAL_CODE

NA
RPRLAPP_PERKINS_DEBT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PERKINS_LOAN_DEBT

NA
RPRLAPP_PHONE_NO RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PHONE_NUMBER_COMBINED

NA
RPRLAPP_PIDM NA COMPOSITE VIEW

AR_LOAN_APPLICATION

PERSON_UID

NA
RPRLAPP_PLUS_TO_STUDENT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PLUS_TO_STUDENT_IND

NA
RPRLAPP_PN_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PROM_NOTE_DATE

NA
RPRLAPP_PROCESS_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

PROCESS_DATE

NA
RPRLAPP_RECEIVE_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

APP_RECEIVED_DATE

NA
RPRLAPP_RECOMMEND_AMT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

RECOMMENDED_AMT

NA
RPRLAPP_RECORD_TYPE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

RECORD_TYPE

NA
RPRLAPP_REPAY_OPT_IND RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

REPAYMENT_OPTION_CODE

NA
RPRLAPP_REQUEST_AMT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

REQUESTED_AMT

NA
RPRLAPP_RETURN_PIDM NA COMPOSITE VIEW

AR_LOAN_APPLICATION

RETURN_UID

NA
RPRLAPP_SLS_LOAN_DEBT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

SLS_LOAN_DEBT

NA
RPRLAPP_STAF_LOAN_DEBT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

STAFFORD_LOAN_DEBT

NA
RPRLAPP_STATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

STATE_PROVINCE_OF_RESIDENCE

NA
RPRLAPP_STAT_CODE_LIC RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

DRIVER_LICENSE_STATE_PROVINCE

NA
RPRLAPP_STU_EMAIL RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

STUDENT_EMAIL_ADDRESS

NA
RPRLAPP_STU_MAJOR RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

STUDENT_MAJOR

NA
RPRLAPP_SUB_DATE RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

SUBMISSION_DATE

NA
RPRLAPP_XREF_LOAN_ID RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

XREF_LOAN_ID

NA
RPRLAPP_ZIP RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

POSTAL_CODE

NA


Ver: 3.1