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