| 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_ID |
RPAELAP |
|
|
|
|
| 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_COMP_DATE |
RPALORG |
|
|
|
|
| RPRLAPP_APP_LOAN_AMT |
RPALORG |
|
|
|
|
| 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_TAX_ID |
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_TAX_ID |
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_EXP_DATE |
RPALORG |
|
|
|
|
| RPRLAPP_CREDIT_CHECK_IND |
RPAELAP |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
PLUS_CREDIT_CHECK_STATUS |
NA |
| RPRLAPP_CREDIT_DOCUMENT_ID |
RPALORG |
|
|
|
|
| RPRLAPP_CRED_DIF_NM_IND |
RPAELAP |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
CREDIT_IN_DIFF_NAME_IND |
NA |
| RPRLAPP_CR_ACTION_OPT |
RPALORG |
|
|
|
|
| RPRLAPP_CR_APPEAL_STATUS |
RPALORG |
|
|
|
|
| RPRLAPP_CR_OVERRIDE_CDE |
RPALORG |
|
|
|
|
| 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_ENTRANCE_IND |
RPALORG |
|
|
|
|
| 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_FIRST_NAME |
RPAELAP |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
FIRST_NAME |
|
| 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_LAST_NAME |
RPAELAP |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
LAST_NAME |
|
| 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_LOAN_TYPE |
RPALORG |
|
|
|
|
| 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_MI |
RPAELAP |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
MIDDLE_INITIAL |
|
| 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_ORIG_CREDIT_STATUS |
RPALORG |
|
|
|
|
| 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_ENDORSER_AMT |
RPALORG |
|
|
|
|
| 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_TAX_ID |
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_APP_REASON |
RPALORG |
|
|
|
|
| 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_PREVIOUS_APP_ID |
RPALORG |
|
|
|
|
| RPRLAPP_PROCESS_DATE |
RPAELAP |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
PROCESS_DATE |
NA |
| RPRLAPP_PROGRAM_OF_STUDY |
RPALORG |
|
|
|
|
| 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_REQ_AWARD_END_DATE |
RPALORG |
|
|
|
|
| RPRLAPP_REQ_AWARD_START_DATE |
RPALORG |
|
|
|
|
| RPRLAPP_RETURN_PIDM |
NA |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
RETURN_UID |
NA |
| RPRLAPP_SCHOOL_CR_BALANCE_OPT |
RPALORG |
|
|
|
|
| RPRLAPP_SLS_LOAN_DEBT |
RPAELAP |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
SLS_LOAN_DEBT |
NA |
| RPRLAPP_SSN |
RPAELAP |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
TAX_ID |
|
| 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_UNKNOWN_LOAN_AMT_IND |
RPALORG |
|
|
|
|
| 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 |