Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: RPRLAPP Financial Aid Reporting View Meta Data Reports
Banner Operational Data Store Reporting View Source: RPRLAPP - NULL

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


Ver: 9.2