Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
RLRPAPP_APP_LOAN_AMT |
RLADLOR |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPLICATION_LOAN_AMOUNT |
NO |
|
RPRLAPP_ACAD_YR_END_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ACADEMIC_YEAR_END_DATE |
NO |
NA |
RPRLAPP_ACAD_YR_START_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ACADEMIC_YEAR_START_DATE |
NO |
NA |
RPRLAPP_ACTIVITY_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPLICATION_ACTIVITY_DATE |
NO |
|
RPRLAPP_ADDRESS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT |
STREET_LINE1 STREET_LINE1 |
NO NO |
NA |
RPRLAPP_ADDR_LINE2 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
STREET_LINE2 STREET_LINE2 |
NO NO |
NA |
RPRLAPP_ADDR_LINE3 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
STREET_LINE3 STREET_LINE3 |
NO NO |
|
RPRLAPP_AIDY_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
AID_YEAR |
NO |
NA |
RPRLAPP_ALIEN_REG_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ALIEN_REGISTRATION_NUMBER |
NO |
NA |
RPRLAPP_ALT_BOR_LOAN_DEBT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ALT_LOAN_BORROWER_LOAN_DEBT |
NO |
NA |
RPRLAPP_ALT_LOAN_PROG_TYPE_CDE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ALT_LOAN_PROGRAM_TYPE |
NO |
NA |
RPRLAPP_ALT_LOAN_SB_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ALT_LOAN_STUDENT_BORROWER_IND |
NO |
NA |
RPRLAPP_APPL_ID |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PLUS_LOAN_APPLICATION_ID |
NO |
|
RPRLAPP_APPL_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_APPLICATION |
LOAN_NUMBER LOAN_APPLICATION_NUMBER |
NO NO |
NA |
RPRLAPP_APPROVE_AMT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPROVED_AMOUNT |
NO |
NA |
RPRLAPP_APPROVE_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPROVED_DATE |
NO |
NA |
RPRLAPP_APP_COMP_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPLICATION_COMPLETE_DATE |
NO |
|
RPRLAPP_APP_LOAN_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPLICATION_LOAN_AMOUNT |
NO |
|
RPRLAPP_APP_PHASE_CDE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PROCESSING_APP_PHASE_CRNT_LOAN |
NO |
NA |
RPRLAPP_APP_VER_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COMMONLINE_APP_VERSION_NUMBER |
NO |
NA |
RPRLAPP_BATCH_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
BATCH_ID_FOR_DIRECT_LOAN |
NO |
NA |
RPRLAPP_BIRTH_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
BIRTH_DATE |
NO |
|
RPRLAPP_BOOK_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
NOTIFICATION_BOOK_DATE |
NO |
|
RPRLAPP_BOOK_DOCUMENT_ID |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
NOTIFICATION_DOCUMENT_ID |
NO |
|
RPRLAPP_BORROWER_EMAIL |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
BORROWER_EMAIL_ADDRESS |
NO |
|
RPRLAPP_BOR_GROSS_YR_SAL |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
BORROWER_ANNUAL_INCOME |
NO |
NA |
RPRLAPP_BOR_OTH_INC |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
BORROWER_OTHER_INCOME |
NO |
NA |
RPRLAPP_CANCEL_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CANCEL_INACTIVATED_DATE |
NO |
NA |
RPRLAPP_CANCEL_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CANCEL_INACTIVATED_IND |
NO |
NA |
RPRLAPP_CERT_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CERTIFICATION_DATE |
NO |
NA |
RPRLAPP_CITY |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT |
CITY CITY |
NO NO |
NA |
RPRLAPP_CITZ_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CITIZEN_IND |
NO |
NA |
RPRLAPP_CONF_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
SERVICER_CONFIRMATION_DATE |
NO |
NA |
RPRLAPP_COSIGN1_ADDR_LINE1 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_STREET_LINE1 |
NO |
NA |
RPRLAPP_COSIGN1_ADDR_LINE2 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_STREET_LINE2 |
NO |
NA |
RPRLAPP_COSIGN1_BIRTH_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_BIRTH_DATE |
NO |
NA |
RPRLAPP_COSIGN1_CITY |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_CITY |
NO |
NA |
RPRLAPP_COSIGN1_CITZ_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_CITIZEN_IND |
NO |
NA |
RPRLAPP_COSIGN1_DRIVER_LIC_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_DR_LIC_NUMBER |
NO |
NA |
RPRLAPP_COSIGN1_FIRST_NAME |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_FIRST_NAME |
NO |
NA |
RPRLAPP_COSIGN1_FOR_POST_CDE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_FOREIGN_POSTAL_CODE |
NO |
NA |
RPRLAPP_COSIGN1_GROSS_YR_SAL |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_ANNUAL_INCOME |
NO |
NA |
RPRLAPP_COSIGN1_LAST_NAME |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_LAST_NAME |
NO |
NA |
RPRLAPP_COSIGN1_MI |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_MIDDLE_INITIAL |
NO |
NA |
RPRLAPP_COSIGN1_OTH_INC |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_OTHER_INCOME |
NO |
NA |
RPRLAPP_COSIGN1_PHONE_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_PHONE_NUMBER_COMBINED |
NO |
NA |
RPRLAPP_COSIGN1_RELATION_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_RELATIONSHIP |
NO |
NA |
RPRLAPP_COSIGN1_SIGNED_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_SIGNATURE_IND |
NO |
NA |
RPRLAPP_COSIGN1_SSN |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_TAX_ID |
NO |
NA |
RPRLAPP_COSIGN1_STAT_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_STATE_PROVINCE |
NO |
NA |
RPRLAPP_COSIGN1_STAT_CODE_LIC |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_DR_LIC_STATE_PROV |
NO |
NA |
RPRLAPP_COSIGN1_SUFFIX |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_SUFFIX |
NO |
NA |
RPRLAPP_COSIGN1_YR_ADDRESS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_YRS_AT_ADDRESS |
NO |
NA |
RPRLAPP_COSIGN1_ZIP |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN1_POSTAL_CODE |
NO |
NA |
RPRLAPP_COSIGN2_ADDR_LINE1 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_STREET_LINE1 |
NO |
NA |
RPRLAPP_COSIGN2_ADDR_LINE2 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_STREET_LINE2 |
NO |
NA |
RPRLAPP_COSIGN2_BIRTH_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_BIRTH_DATE |
NO |
NA |
RPRLAPP_COSIGN2_CITY |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_CITY |
NO |
NA |
RPRLAPP_COSIGN2_CITZ_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_CITIZEN_IND |
NO |
NA |
RPRLAPP_COSIGN2_DRIVER_LIC_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_DR_LIC_NUMBER |
NO |
NA |
RPRLAPP_COSIGN2_FIRST_NAME |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_FIRST_NAME |
NO |
NA |
RPRLAPP_COSIGN2_FOR_POST_CDE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_FOREIGN_POSTAL_CODE |
NO |
NA |
RPRLAPP_COSIGN2_GROSS_YR_SAL |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_ANNUAL_INCOME |
NO |
NA |
RPRLAPP_COSIGN2_LAST_NAME |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_LAST_NAME |
NO |
NA |
RPRLAPP_COSIGN2_MI |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_MIDDLE_INITIAL |
NO |
NA |
RPRLAPP_COSIGN2_OTH_INC |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_OTHER_INCOME |
NO |
NA |
RPRLAPP_COSIGN2_PHONE_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_PHONE_NUMBER_COMBINED |
NO |
NA |
RPRLAPP_COSIGN2_RELATION_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_RELATIONSHIP |
NO |
NA |
RPRLAPP_COSIGN2_SIGNED_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_SIGNATURE_IND |
NO |
NA |
RPRLAPP_COSIGN2_SSN |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_TAX_ID |
NO |
NA |
RPRLAPP_COSIGN2_STAT_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_STATE_PROVINCE |
NO |
NA |
RPRLAPP_COSIGN2_STAT_CODE_LIC |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_DR_LIC_STATE_PROV |
NO |
NA |
RPRLAPP_COSIGN2_SUFFIX |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_SUFFIX |
NO |
NA |
RPRLAPP_COSIGN2_YR_ADDRESS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_YRS_AT_ADDRESS |
NO |
NA |
RPRLAPP_COSIGN2_ZIP_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COSIGN2_POSTAL_CODE |
NO |
NA |
RPRLAPP_CREATE_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOAN_APP_CREATE_DATE |
NO |
NA |
RPRLAPP_CREDIT_CHECK_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PLUS_CREDIT_CHECK_DATE |
NO |
NA |
RPRLAPP_CREDIT_CHECK_EXP_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CREDIT_CHECK_EXPIRATION_DATE |
NO |
|
RPRLAPP_CREDIT_CHECK_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PLUS_CREDIT_CHECK_STATUS |
NO |
NA |
RPRLAPP_CREDIT_DOCUMENT_ID |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CREDIT_APPLICATION_DOCUMENT_ID |
NO |
|
RPRLAPP_CRED_DIF_NM_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CREDIT_IN_DIFFERENT_NAME_IND |
NO |
NA |
RPRLAPP_CR_ACTION_OPT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CREDIT_ACTION |
NO |
|
RPRLAPP_CR_APPEAL_STATUS |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CREDIT_CHECK_APPEAL_STATUS |
NO |
|
RPRLAPP_CR_OVERRIDE_CDE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CREDIT_CHECK_OVERRIDDEN |
NO |
|
RPRLAPP_DATA_ORIGIN |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPLICATION_DATA_ORIGIN |
NO |
|
RPRLAPP_DISC_NEED_PRINT_FLAG |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DISCLOSURE_REQUIRED_IND |
NO |
NA |
RPRLAPP_DISC_PRINT_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DISCLOSURE_PRINT_DATE |
NO |
NA |
RPRLAPP_DISC_PRINT_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DISCLOSURE_PRINT_IND |
NO |
NA |
RPRLAPP_DL_LOAN_ID |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
DIRECT_LOAN_ID DIRECT_LOAN_ID |
NO NO |
NA |
RPRLAPP_DL_REBATE_PERCENT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_REBATE_FEE_PERCENT |
NO |
NA |
RPRLAPP_DL_RECON_REJECT_1 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_DISB_RECON_REJECT_1 |
NO |
NA |
RPRLAPP_DL_RECON_REJECT_2 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_DISB_RECON_REJECT_2 |
NO |
NA |
RPRLAPP_DL_RECON_REJECT_3 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_DISB_RECON_REJECT_3 |
NO |
NA |
RPRLAPP_DL_RECON_REJECT_4 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_DISB_RECON_REJECT_4 |
NO |
NA |
RPRLAPP_DL_RECON_REJECT_5 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_DISB_RECON_REJECT_5 |
NO |
NA |
RPRLAPP_DL_RECON_STATUS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_BOOKING_STATUS |
NO |
NA |
RPRLAPP_DL_REJECT_CODE_1 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_ORIGINATION_REJECT_1 |
NO |
NA |
RPRLAPP_DL_REJECT_CODE_2 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_ORIGINATION_REJECT_2 |
NO |
NA |
RPRLAPP_DL_REJECT_CODE_3 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_ORIGINATION_REJECT_3 |
NO |
NA |
RPRLAPP_DL_REJECT_CODE_4 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_ORIGINATION_REJECT_4 |
NO |
NA |
RPRLAPP_DL_REJECT_CODE_5 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_ORIGINATION_REJECT_5 |
NO |
NA |
RPRLAPP_DL_SENT_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DIRECT_LOAN_DATE_SENT |
NO |
NA |
RPRLAPP_DL_SEQ_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DIRECT_LOAN_NUMBER |
NO |
NA |
RPRLAPP_DL_STATUS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DIRECT_LOAN_STATUS |
NO |
NA |
RPRLAPP_DOCUMENT_ID |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ORIGINATION_DOCUMENT_ID |
NO |
|
RPRLAPP_DRIVER_LIC_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DRIVER_LICENSE_NUMBER |
NO |
NA |
RPRLAPP_EL_DATE_SENT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COMMONLINE_LOAN_DATE_SENT |
NO |
NA |
RPRLAPP_EL_LOAN_ID |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
EL_LOAN_ID COMMONLINE_LOAN_ID |
NO NO |
NA |
RPRLAPP_EL_PROCESS_TYPE |
RPAELAP |
NO |
|
|
|
|
NA |
RPRLAPP_EL_SEQ_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COMMONLINE_LOAN_SEQ_NUMBER |
NO |
NA |
RPRLAPP_EL_STATUS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
COMMONLINE_LOAN_STATUS |
NO |
NA |
RPRLAPP_ENROLL_START_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ENROLL_START_DATE |
NO |
NA |
RPRLAPP_ENTRANCE_IND |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ENTRANCE_COUNSELING_IND |
NO |
|
RPRLAPP_EXPECT_AMT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
EXPECTED_AMOUNT |
NO |
NA |
RPRLAPP_EXP_GRAD_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
EXPECTED_GRADUATION_DATE |
NO |
NA |
RPRLAPP_FEE_PCT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_APPLICATION |
LOAN_FEE_PERCENT LOAN_FEE |
NO NO |
NA |
RPRLAPP_FIRST_NAME |
RPAELAP |
NO |
|
|
|
|
|
RPRLAPP_FORMER_HEAL_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
FORMER_HEAL_INDICATOR |
NO |
NA |
RPRLAPP_FUND_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
FUND |
NO |
NA |
RPRLAPP_GUAR_PIDM |
NA |
NO |
|
|
|
|
NA |
RPRLAPP_HEAL_DEBT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
HEAL_LOAN_DEBT |
NO |
NA |
RPRLAPP_HOLD_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCK_INDICATOR |
NO |
NA |
RPRLAPP_INT_RATE_OPT_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
INTEREST_RATE_OPTION |
NO |
NA |
RPRLAPP_IN_DEFAULT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
DEFAULT_IND DEFAULT_IND |
NO NO |
NA |
RPRLAPP_LAST_NAME |
RPAELAP |
NO |
|
|
|
|
|
RPRLAPP_LENDER_PIDM |
NA |
NO |
|
|
|
|
NA |
RPRLAPP_LNST_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT |
COMMONLINE_PROCESSING_STATUS LOAN_STATUS LOAN_STATUS |
NO NO NO |
NA |
RPRLAPP_LOAN_PERIOD |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
LOAN_PERIOD LOAN_PERIOD |
NO NO |
NA |
RPRLAPP_LOAN_TYPE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOAN_TYPE |
NO |
|
RPRLAPP_LOCAL_ADDRESS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCAL_STREET_LINE1 |
NO |
NA |
RPRLAPP_LOCAL_ADDR_LINE2 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCAL_STREET_LINE2 |
NO |
NA |
RPRLAPP_LOCAL_ADDR_LINE3 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCAL_STREET_LINE3 |
NO |
|
RPRLAPP_LOCAL_CITY |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCAL_CITY |
NO |
NA |
RPRLAPP_LOCAL_NATN_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCAL_NATION |
NO |
NA |
RPRLAPP_LOCAL_PHONE_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCAL_PHONE_NUMBER_COMBINED |
NO |
NA |
RPRLAPP_LOCAL_STAT_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCAL_STATE_PROVINCE |
NO |
NA |
RPRLAPP_LOCAL_ZIP |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOCAL_POSTAL_CODE |
NO |
NA |
RPRLAPP_LPRD_END_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOAN_PERIOD_END_DATE |
NO |
|
RPRLAPP_LPRD_START_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOAN_PERIOD_START_DATE |
NO |
|
RPRLAPP_MAX_ELIG_AMT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MAXIMUM_ELIGIBLE_AMOUNT |
NO |
NA |
RPRLAPP_MI |
RPAELAP |
NO |
|
|
|
|
|
RPRLAPP_MODEL_CDE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DEPENDENCY_STATUS |
NO |
NA |
RPRLAPP_MPN_BATCH_ID |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MPN_BATCH_ID |
NO |
NA |
RPRLAPP_MPN_DOCUMENT_ID |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MPN_DOCUMENT_ID |
NO |
|
RPRLAPP_MPN_EXP_CODE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MPN_EXPIRATION_REASON |
NO |
|
RPRLAPP_MPN_EXP_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MPN_EXPIRATION_DATE |
NO |
|
RPRLAPP_MPN_EXP_DESC |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MPN_EXPIRATION_REASON_DESC |
NO |
|
RPRLAPP_MPN_ID |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MPN_ID |
NO |
NA |
RPRLAPP_MPN_STATUS_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DL_MPN_STATUS_IND |
NO |
NA |
RPRLAPP_NATN_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
NATION |
NO |
NA |
RPRLAPP_ORIG_CREDIT_STATUS |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ORIGINAL_CREDIT_STATUS |
NO |
|
RPRLAPP_OTHER_DEBT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
OTHER_LOAN_DEBT |
NO |
NA |
RPRLAPP_OTH_LOANS_PERIOD |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
OTHER_LOANS_LOAN_PERIOD |
NO |
NA |
RPRLAPP_OWES_REFUND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
OWES_REFUND_IND |
NO |
NA |
RPRLAPP_PAR_ADDRESS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT |
PARENT_STREET_LINE1 PARENT_STREET_LINE1 |
NO NO |
NA |
RPRLAPP_PAR_ADDR_LINE2 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
PARENT_STREET_LINE2 PARENT_STREET_LINE2 |
NO NO |
NA |
RPRLAPP_PAR_ADDR_LINE3 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT |
PARENT_STREET_LINE3 PARENT_STREET_LINE3 |
NO NO |
|
RPRLAPP_PAR_ALIEN_REG_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_ALIEN_REG_NUMBER |
NO |
NA |
RPRLAPP_PAR_BIRTH_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_BIRTH_DATE |
NO |
NA |
RPRLAPP_PAR_CITY |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT |
PARENT_CITY PARENT_CITY |
NO NO |
NA |
RPRLAPP_PAR_CITZ_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_CITIZEN_IND |
NO |
NA |
RPRLAPP_PAR_DRIVER_LIC_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_DRIVER_LICENSE_NUMBER |
NO |
NA |
RPRLAPP_PAR_ENDORSER_AMT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
ENDORSER_AMOUNT |
NO |
|
RPRLAPP_PAR_FIRST_NAME |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_FIRST_NAME |
NO |
NA |
RPRLAPP_PAR_IN_DEFAULT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_DEFAULT_IND |
NO |
NA |
RPRLAPP_PAR_LAST_NAME |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_LAST_NAME |
NO |
NA |
RPRLAPP_PAR_LOCAL_ADDRESS |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_LOCAL_STREET_LINE1 |
NO |
NA |
RPRLAPP_PAR_LOCAL_ADDR_LINE2 |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_LOCAL_STREET_LINE2 |
NO |
NA |
RPRLAPP_PAR_LOCAL_ADDR_LINE3 |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_LOCAL_STREET_LINE3 |
NO |
|
RPRLAPP_PAR_LOCAL_CITY |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_LOCAL_CITY |
NO |
NA |
RPRLAPP_PAR_LOCAL_NATN_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_LOCAL_NATION |
NO |
NA |
RPRLAPP_PAR_LOCAL_STAT_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_LOCAL_STATE_PROVINCE |
NO |
NA |
RPRLAPP_PAR_LOCAL_ZIP |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_LOCAL_POSTAL_CODE |
NO |
NA |
RPRLAPP_PAR_MI |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_MIDDLE_INITIAL |
NO |
NA |
RPRLAPP_PAR_NATN_CODE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_NATION |
NO |
NA |
RPRLAPP_PAR_PHONE_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT |
PARENT_PHONE_NUMBER_COMBINED PARENT_PHONE_NUMBER_COMBINED |
NO NO |
NA |
RPRLAPP_PAR_SSN |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_TAX_ID |
NO |
NA |
RPRLAPP_PAR_STATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
PARENT_STATE_PROVINCE PARENT_STATE_PROVINCE |
NO NO |
NA |
RPRLAPP_PAR_STAT_CODE_LIC |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_DRIVER_LIC_STATE_PROV |
NO |
NA |
RPRLAPP_PAR_STAT_CODE_RES |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PARENT_STATE_PROVINCE_OF_RES |
NO |
NA |
RPRLAPP_PAR_ZIP |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT |
PARENT_POSTAL_CODE PARENT_POSTAL_CODE |
NO NO |
NA |
RPRLAPP_PERKINS_DEBT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PERKINS_LOAN_DEBT |
NO |
NA |
RPRLAPP_PHONE_NO |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED |
NO NO |
NA |
RPRLAPP_PIDM |
NA |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PERSON_UID |
NO |
NA |
RPRLAPP_PLUS_APP_REASON |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PLUS_APPLICATION_REASON |
NO |
|
RPRLAPP_PLUS_BORROWER_ID_NO |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PLUS_BORROWER_ID |
NO |
|
RPRLAPP_PLUS_TO_STUDENT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
GIVE_PLUS_TO_STUDENT_IND |
NO |
NA |
RPRLAPP_PN_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PROMISSORY_NOTE_DATE |
NO |
NA |
RPRLAPP_PREP_OR_TEACH_IND |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PREP_TEACHER_CERTIFICATION |
NO |
|
RPRLAPP_PREVIOUS_APP_ID |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PLUS_PREVIOUS_APPLICATION_ID |
NO |
|
RPRLAPP_PROCESS_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PROCESS_DATE |
NO |
NA |
RPRLAPP_PROGRAM_OF_STUDY |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PROGRAM_OF_STUDY |
NO |
|
RPRLAPP_RECEIVE_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOAN_APPLICATION_RECEIVED_DATE |
NO |
NA |
RPRLAPP_RECOMMEND_AMT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOAN_RECOMMENDED_AMOUNT |
NO |
NA |
RPRLAPP_RECORD_TYPE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
RECORD_TYPE |
NO |
NA |
RPRLAPP_REPAY_OPT_IND |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
REPAYMENT_OPTION_CODE |
NO |
NA |
RPRLAPP_REQUEST_AMT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPLICANT_LOAN_REQUESTED_AMT |
NO |
NA |
RPRLAPP_REQ_AWARD_END_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
REQUESTED_AWARD_END_DATE |
NO |
|
RPRLAPP_REQ_AWARD_START_DATE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
REQUESTED_AWARD_START_DATE |
NO |
|
RPRLAPP_RETURN_PIDM |
NA |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT |
RETURN_UID |
NO |
NA |
RPRLAPP_SAR_TRAN_NO |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
SAR_TRANSACTION_NUMBER |
NO |
|
RPRLAPP_SCHOOL_CODE |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DIRECT_LOAN_SCHOOL_CODE |
NO |
|
RPRLAPP_SCHOOL_CR_BALANCE_OPT |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
CREDIT_BALANCE_OPTION_IND |
NO |
|
RPRLAPP_SLS_LOAN_DEBT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
SLS_LOAN_DEBT |
NO |
NA |
RPRLAPP_SPGM_LOCK_IND |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PROGRAM_SEQUENCE_LOCK_IND |
NO |
|
RPRLAPP_SPGM_SEQ_NO |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
PROGRAM_SEQUENCE_NUMBER |
NO |
|
RPRLAPP_SSN |
RPAELAP |
NO |
|
|
|
|
|
RPRLAPP_STAF_LOAN_DEBT |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
STAFFORD_LOAN_DEBT |
NO |
NA |
RPRLAPP_STATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION LOAN_DISBURSEMENT |
STATE_PROVINCE STATE_PROVINCE |
NO NO |
NA |
RPRLAPP_STAT_CODE_LIC |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DRIVER_LICENSE_STATE_PROVINCE |
NO |
NA |
RPRLAPP_STU_EMAIL |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
EMAIL_ADDRESS |
NO |
NA |
RPRLAPP_STU_MAJOR |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MAJOR |
NO |
NA |
RPRLAPP_SUB_DATE |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
SUBMISSION_DATE |
NO |
NA |
RPRLAPP_UNKNOWN_LOAN_AMT_IND |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
LOAN_AMOUNT_UNKNOWN_IND |
NO |
|
RPRLAPP_USER_ID |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
APPLICATION_USER_ID |
NO |
|
RPRLAPP_XREF_LOAN_ID |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
XREF_LOAN_ID XREF_LOAN_ID |
NO NO |
NA |
RPRLAPP_YR_IN_COLL |
RPALORG |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
YEAR_IN_COLLEGE |
NO |
|
RPRLAPP_ZIP |
RPAELAP |
NO |
REPORTING VIEW |
LOAN_DISBURSEMENT LOAN_APPLICATION |
POSTAL_CODE POSTAL_CODE |
NO NO |
NA |