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

Source Column Source Form Target Type Target Target Column Calculation Formula
RLRPAPP_APP_LOAN_AMT RLADLOR

REPORTING VIEW

LOAN_APPLICATION

APPLICATION_LOAN_AMOUNT

 
RPRLAPP_ACAD_YR_END_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

ACADEMIC_YEAR_END_DATE

NA
RPRLAPP_ACAD_YR_START_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

ACADEMIC_YEAR_START_DATE

NA
RPRLAPP_ACTIVITY_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

APPLICATION_ACTIVITY_DATE

 
RPRLAPP_ADDRESS RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

STREET_LINE1

STREET_LINE1

NA
RPRLAPP_ADDR_LINE2 RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

LOAN_APPLICATION

STREET_LINE2

STREET_LINE2

NA
RPRLAPP_ADDR_LINE3 RPALORG

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

STREET_LINE3

STREET_LINE3

 
RPRLAPP_AIDY_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

AID_YEAR

NA
RPRLAPP_ALIEN_REG_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

ALIEN_REGISTRATION_NUMBER

NA
RPRLAPP_ALT_BOR_LOAN_DEBT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

ALT_LOAN_BORROWER_LOAN_DEBT

NA
RPRLAPP_ALT_LOAN_PROG_TYPE_CDE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

ALT_LOAN_PROGRAM_TYPE

NA
RPRLAPP_ALT_LOAN_SB_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

ALT_LOAN_STUDENT_BORROWER_IND

NA
RPRLAPP_APPL_ID RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PLUS_LOAN_APPLICATION_ID

 
RPRLAPP_APPL_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_APPLICATION

LOAN_APPLICATION_NUMBER

LOAN_NUMBER

NA
RPRLAPP_APPROVE_AMT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

APPROVED_AMOUNT

NA
RPRLAPP_APPROVE_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

APPROVED_DATE

NA
RPRLAPP_APP_COMP_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

APPLICATION_COMPLETE_DATE

 
RPRLAPP_APP_LOAN_AMT RPALORG

REPORTING VIEW

LOAN_APPLICATION

APPLICATION_LOAN_AMOUNT

 
RPRLAPP_APP_PHASE_CDE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PROCESSING_APP_PHASE_CRNT_LOAN

NA
RPRLAPP_APP_VER_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COMMONLINE_APP_VERSION_NUMBER

NA
RPRLAPP_BATCH_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

BATCH_ID_FOR_DIRECT_LOAN

NA
RPRLAPP_BIRTH_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

BIRTH_DATE

 
RPRLAPP_BOOK_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

NOTIFICATION_BOOK_DATE

 
RPRLAPP_BOOK_DOCUMENT_ID RPALORG

REPORTING VIEW

LOAN_APPLICATION

NOTIFICATION_DOCUMENT_ID

 
RPRLAPP_BORROWER_EMAIL RPALORG

REPORTING VIEW

LOAN_APPLICATION

BORROWER_EMAIL_ADDRESS

 
RPRLAPP_BOR_GROSS_YR_SAL RPAELAP

REPORTING VIEW

LOAN_APPLICATION

BORROWER_ANNUAL_INCOME

NA
RPRLAPP_BOR_OTH_INC RPAELAP

REPORTING VIEW

LOAN_APPLICATION

BORROWER_OTHER_INCOME

NA
RPRLAPP_CANCEL_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

CANCEL_INACTIVATED_DATE

NA
RPRLAPP_CANCEL_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

CANCEL_INACTIVATED_IND

NA
RPRLAPP_CERT_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

CERTIFICATION_DATE

NA
RPRLAPP_CITY RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

CITY

CITY

NA
RPRLAPP_CITZ_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

CITIZEN_IND

NA
RPRLAPP_CONF_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

SERVICER_CONFIRMATION_DATE

NA
RPRLAPP_COSIGN1_ADDR_LINE1 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_STREET_LINE1

NA
RPRLAPP_COSIGN1_ADDR_LINE2 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_STREET_LINE2

NA
RPRLAPP_COSIGN1_BIRTH_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_BIRTH_DATE

NA
RPRLAPP_COSIGN1_CITY RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_CITY

NA
RPRLAPP_COSIGN1_CITZ_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_CITIZEN_IND

NA
RPRLAPP_COSIGN1_DRIVER_LIC_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_DR_LIC_NUMBER

NA
RPRLAPP_COSIGN1_FIRST_NAME RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_FIRST_NAME

NA
RPRLAPP_COSIGN1_FOR_POST_CDE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_FOREIGN_POSTAL_CODE

NA
RPRLAPP_COSIGN1_GROSS_YR_SAL RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_ANNUAL_INCOME

NA
RPRLAPP_COSIGN1_LAST_NAME RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_LAST_NAME

NA
RPRLAPP_COSIGN1_MI RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_MIDDLE_INITIAL

NA
RPRLAPP_COSIGN1_OTH_INC RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_OTHER_INCOME

NA
RPRLAPP_COSIGN1_PHONE_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_PHONE_NUMBER_COMBINED

NA
RPRLAPP_COSIGN1_RELATION_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_RELATIONSHIP

NA
RPRLAPP_COSIGN1_SIGNED_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_SIGNATURE_IND

NA
RPRLAPP_COSIGN1_SSN RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_TAX_ID

NA
RPRLAPP_COSIGN1_STAT_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_STATE_PROVINCE

NA
RPRLAPP_COSIGN1_STAT_CODE_LIC RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_DR_LIC_STATE_PROV

NA
RPRLAPP_COSIGN1_SUFFIX RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_SUFFIX

NA
RPRLAPP_COSIGN1_YR_ADDRESS RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_YRS_AT_ADDRESS

NA
RPRLAPP_COSIGN1_ZIP RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_POSTAL_CODE

NA
RPRLAPP_COSIGN2_ADDR_LINE1 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_STREET_LINE1

NA
RPRLAPP_COSIGN2_ADDR_LINE2 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_STREET_LINE2

NA
RPRLAPP_COSIGN2_BIRTH_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_BIRTH_DATE

NA
RPRLAPP_COSIGN2_CITY RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_CITY

NA
RPRLAPP_COSIGN2_CITZ_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_CITIZEN_IND

NA
RPRLAPP_COSIGN2_DRIVER_LIC_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_DR_LIC_NUMBER

NA
RPRLAPP_COSIGN2_FIRST_NAME RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_FIRST_NAME

NA
RPRLAPP_COSIGN2_FOR_POST_CDE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_FOREIGN_POSTAL_CODE

NA
RPRLAPP_COSIGN2_GROSS_YR_SAL RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_ANNUAL_INCOME

NA
RPRLAPP_COSIGN2_LAST_NAME RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_LAST_NAME

NA
RPRLAPP_COSIGN2_MI RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_MIDDLE_INITIAL

NA
RPRLAPP_COSIGN2_OTH_INC RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_OTHER_INCOME

NA
RPRLAPP_COSIGN2_PHONE_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_PHONE_NUMBER_COMBINED

NA
RPRLAPP_COSIGN2_RELATION_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_RELATIONSHIP

NA
RPRLAPP_COSIGN2_SIGNED_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_SIGNATURE_IND

NA
RPRLAPP_COSIGN2_SSN RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_TAX_ID

NA
RPRLAPP_COSIGN2_STAT_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_STATE_PROVINCE

NA
RPRLAPP_COSIGN2_STAT_CODE_LIC RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_DR_LIC_STATE_PROV

NA
RPRLAPP_COSIGN2_SUFFIX RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_SUFFIX

NA
RPRLAPP_COSIGN2_YR_ADDRESS RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_YRS_AT_ADDRESS

NA
RPRLAPP_COSIGN2_ZIP_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_POSTAL_CODE

NA
RPRLAPP_CREATE_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_APP_CREATE_DATE

NA
RPRLAPP_CREDIT_CHECK_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PLUS_CREDIT_CHECK_DATE

NA
RPRLAPP_CREDIT_CHECK_EXP_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

CREDIT_CHECK_EXPIRATION_DATE

 
RPRLAPP_CREDIT_CHECK_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PLUS_CREDIT_CHECK_STATUS

NA
RPRLAPP_CREDIT_DOCUMENT_ID RPALORG

REPORTING VIEW

LOAN_APPLICATION

CREDIT_APPLICATION_DOCUMENT_ID

 
RPRLAPP_CRED_DIF_NM_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

CREDIT_IN_DIFFERENT_NAME_IND

NA
RPRLAPP_CR_ACTION_OPT RPALORG

REPORTING VIEW

LOAN_APPLICATION

CREDIT_ACTION

 
RPRLAPP_CR_APPEAL_STATUS RPALORG

REPORTING VIEW

LOAN_APPLICATION

CREDIT_CHECK_APPEAL_STATUS

 
RPRLAPP_CR_OVERRIDE_CDE RPALORG

REPORTING VIEW

LOAN_APPLICATION

CREDIT_CHECK_OVERRIDDEN

 
RPRLAPP_DATA_ORIGIN RPALORG

REPORTING VIEW

LOAN_APPLICATION

APPLICATION_DATA_ORIGIN

 
RPRLAPP_DISC_NEED_PRINT_FLAG RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DISCLOSURE_REQUIRED_IND

NA
RPRLAPP_DISC_PRINT_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DISCLOSURE_PRINT_DATE

NA
RPRLAPP_DISC_PRINT_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DISCLOSURE_PRINT_IND

NA
RPRLAPP_DL_LOAN_ID RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

LOAN_APPLICATION

DIRECT_LOAN_ID

DIRECT_LOAN_ID

NA
RPRLAPP_DL_REBATE_PERCENT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_REBATE_FEE_PERCENT

NA
RPRLAPP_DL_RECON_REJECT_1 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_DISB_RECON_REJECT_1

NA
RPRLAPP_DL_RECON_REJECT_2 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_DISB_RECON_REJECT_2

NA
RPRLAPP_DL_RECON_REJECT_3 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_DISB_RECON_REJECT_3

NA
RPRLAPP_DL_RECON_REJECT_4 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_DISB_RECON_REJECT_4

NA
RPRLAPP_DL_RECON_REJECT_5 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_DISB_RECON_REJECT_5

NA
RPRLAPP_DL_RECON_STATUS RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_BOOKING_STATUS

NA
RPRLAPP_DL_REJECT_CODE_1 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_ORIGINATION_REJECT_1

NA
RPRLAPP_DL_REJECT_CODE_2 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_ORIGINATION_REJECT_2

NA
RPRLAPP_DL_REJECT_CODE_3 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_ORIGINATION_REJECT_3

NA
RPRLAPP_DL_REJECT_CODE_4 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_ORIGINATION_REJECT_4

NA
RPRLAPP_DL_REJECT_CODE_5 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_ORIGINATION_REJECT_5

NA
RPRLAPP_DL_SENT_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DIRECT_LOAN_DATE_SENT

NA
RPRLAPP_DL_SEQ_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DIRECT_LOAN_NUMBER

NA
RPRLAPP_DL_STATUS RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DIRECT_LOAN_STATUS

NA
RPRLAPP_DOCUMENT_ID RPALORG

REPORTING VIEW

LOAN_APPLICATION

ORIGINATION_DOCUMENT_ID

 
RPRLAPP_DRIVER_LIC_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DRIVER_LICENSE_NUMBER

NA
RPRLAPP_EL_DATE_SENT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COMMONLINE_LOAN_DATE_SENT

NA
RPRLAPP_EL_LOAN_ID RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

COMMONLINE_LOAN_ID

EL_LOAN_ID

NA
RPRLAPP_EL_PROCESS_TYPE RPAELAP       NA
RPRLAPP_EL_SEQ_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COMMONLINE_LOAN_SEQ_NUMBER

NA
RPRLAPP_EL_STATUS RPAELAP

REPORTING VIEW

LOAN_APPLICATION

COMMONLINE_LOAN_STATUS

NA
RPRLAPP_ENROLL_START_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

ENROLL_START_DATE

NA
RPRLAPP_ENTRANCE_IND RPALORG

REPORTING VIEW

LOAN_APPLICATION

ENTRANCE_COUNSELING_IND

 
RPRLAPP_EXPECT_AMT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

EXPECTED_AMOUNT

NA
RPRLAPP_EXP_GRAD_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

EXPECTED_GRADUATION_DATE

NA
RPRLAPP_FEE_PCT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_APPLICATION

LOAN_FEE

LOAN_FEE_PERCENT

NA
RPRLAPP_FIRST_NAME RPAELAP        
RPRLAPP_FORMER_HEAL_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

FORMER_HEAL_INDICATOR

NA
RPRLAPP_FUND_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

FUND

NA
RPRLAPP_GUAR_PIDM NA       NA
RPRLAPP_HEAL_DEBT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

HEAL_LOAN_DEBT

NA
RPRLAPP_HOLD_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOCK_INDICATOR

NA
RPRLAPP_INT_RATE_OPT_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

INTEREST_RATE_OPTION

NA
RPRLAPP_IN_DEFAULT RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

LOAN_APPLICATION

DEFAULT_IND

DEFAULT_IND

NA
RPRLAPP_LAST_NAME RPAELAP        
RPRLAPP_LENDER_PIDM NA       NA
RPRLAPP_LNST_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_APPLICATION

LOAN_DISBURSEMENT

LOAN_STATUS

COMMONLINE_PROCESSING_STATUS

LOAN_STATUS

NA
RPRLAPP_LOAN_PERIOD RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

LOAN_PERIOD

LOAN_PERIOD

NA
RPRLAPP_LOAN_TYPE RPALORG

REPORTING VIEW

LOAN_APPLICATION

LOAN_TYPE

 
RPRLAPP_LOCAL_ADDRESS RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOCAL_STREET_LINE1

NA
RPRLAPP_LOCAL_ADDR_LINE2 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOCAL_STREET_LINE2

NA
RPRLAPP_LOCAL_ADDR_LINE3 RPALORG

REPORTING VIEW

LOAN_APPLICATION

LOCAL_STREET_LINE3

 
RPRLAPP_LOCAL_CITY RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOCAL_CITY

NA
RPRLAPP_LOCAL_NATN_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOCAL_NATION

NA
RPRLAPP_LOCAL_PHONE_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOCAL_PHONE_NUMBER_COMBINED

NA
RPRLAPP_LOCAL_STAT_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOCAL_STATE_PROVINCE

NA
RPRLAPP_LOCAL_ZIP RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOCAL_POSTAL_CODE

NA
RPRLAPP_LPRD_END_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

LOAN_PERIOD_END_DATE

 
RPRLAPP_LPRD_START_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

LOAN_PERIOD_START_DATE

 
RPRLAPP_MAX_ELIG_AMT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

MAXIMUM_ELIGIBLE_AMOUNT

NA
RPRLAPP_MI RPAELAP        
RPRLAPP_MODEL_CDE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DEPENDENCY_STATUS

NA
RPRLAPP_MPN_BATCH_ID RPAELAP

REPORTING VIEW

LOAN_APPLICATION

MPN_BATCH_ID

NA
RPRLAPP_MPN_DOCUMENT_ID RPALORG

REPORTING VIEW

LOAN_APPLICATION

MPN_DOCUMENT_ID

 
RPRLAPP_MPN_EXP_CODE RPALORG

REPORTING VIEW

LOAN_APPLICATION

MPN_EXPIRATION_REASON

 
RPRLAPP_MPN_EXP_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

MPN_EXPIRATION_DATE

 
RPRLAPP_MPN_EXP_DESC RPALORG

REPORTING VIEW

LOAN_APPLICATION

MPN_EXPIRATION_REASON_DESC

 
RPRLAPP_MPN_ID RPAELAP

REPORTING VIEW

LOAN_APPLICATION

MPN_ID

NA
RPRLAPP_MPN_STATUS_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DL_MPN_STATUS_IND

NA
RPRLAPP_NATN_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

NATION

NA
RPRLAPP_ORIG_CREDIT_STATUS RPALORG

REPORTING VIEW

LOAN_APPLICATION

ORIGINAL_CREDIT_STATUS

 
RPRLAPP_OTHER_DEBT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

OTHER_LOAN_DEBT

NA
RPRLAPP_OTH_LOANS_PERIOD RPAELAP

REPORTING VIEW

LOAN_APPLICATION

OTHER_LOANS_LOAN_PERIOD

NA
RPRLAPP_OWES_REFUND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

OWES_REFUND_IND

NA
RPRLAPP_PAR_ADDRESS RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

LOAN_APPLICATION

PARENT_STREET_LINE1

PARENT_STREET_LINE1

NA
RPRLAPP_PAR_ADDR_LINE2 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

PARENT_STREET_LINE2

PARENT_STREET_LINE2

NA
RPRLAPP_PAR_ADDR_LINE3 RPALORG

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

PARENT_STREET_LINE3

PARENT_STREET_LINE3

 
RPRLAPP_PAR_ALIEN_REG_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_ALIEN_REG_NUMBER

NA
RPRLAPP_PAR_BIRTH_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_BIRTH_DATE

NA
RPRLAPP_PAR_CITY RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

PARENT_CITY

PARENT_CITY

NA
RPRLAPP_PAR_CITZ_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_CITIZEN_IND

NA
RPRLAPP_PAR_DRIVER_LIC_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_DRIVER_LICENSE_NUMBER

NA
RPRLAPP_PAR_ENDORSER_AMT RPALORG

REPORTING VIEW

LOAN_APPLICATION

ENDORSER_AMOUNT

 
RPRLAPP_PAR_FIRST_NAME RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_FIRST_NAME

NA
RPRLAPP_PAR_IN_DEFAULT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_DEFAULT_IND

NA
RPRLAPP_PAR_LAST_NAME RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_LAST_NAME

NA
RPRLAPP_PAR_LOCAL_ADDRESS RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_LOCAL_STREET_LINE1

NA
RPRLAPP_PAR_LOCAL_ADDR_LINE2 RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_LOCAL_STREET_LINE2

NA
RPRLAPP_PAR_LOCAL_ADDR_LINE3 RPALORG

REPORTING VIEW

LOAN_APPLICATION

PARENT_LOCAL_STREET_LINE3

 
RPRLAPP_PAR_LOCAL_CITY RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_LOCAL_CITY

NA
RPRLAPP_PAR_LOCAL_NATN_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_LOCAL_NATION

NA
RPRLAPP_PAR_LOCAL_STAT_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_LOCAL_STATE_PROVINCE

NA
RPRLAPP_PAR_LOCAL_ZIP RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_LOCAL_POSTAL_CODE

NA
RPRLAPP_PAR_MI RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_MIDDLE_INITIAL

NA
RPRLAPP_PAR_NATN_CODE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_NATION

NA
RPRLAPP_PAR_PHONE_NO RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

PARENT_PHONE_NUMBER_COMBINED

PARENT_PHONE_NUMBER_COMBINED

NA
RPRLAPP_PAR_SSN RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_TAX_ID

NA
RPRLAPP_PAR_STATE RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

LOAN_APPLICATION

PARENT_STATE_PROVINCE

PARENT_STATE_PROVINCE

NA
RPRLAPP_PAR_STAT_CODE_LIC RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_DRIVER_LIC_STATE_PROV

NA
RPRLAPP_PAR_STAT_CODE_RES RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PARENT_STATE_PROVINCE_OF_RES

NA
RPRLAPP_PAR_ZIP RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

LOAN_APPLICATION

PARENT_POSTAL_CODE

PARENT_POSTAL_CODE

NA
RPRLAPP_PERKINS_DEBT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PERKINS_LOAN_DEBT

NA
RPRLAPP_PHONE_NO RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

LOAN_APPLICATION

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

NA
RPRLAPP_PIDM NA

REPORTING VIEW

LOAN_APPLICATION

PERSON_UID

NA
RPRLAPP_PLUS_APP_REASON RPALORG

REPORTING VIEW

LOAN_APPLICATION

PLUS_APPLICATION_REASON

 
RPRLAPP_PLUS_BORROWER_ID_NO RPALORG

REPORTING VIEW

LOAN_APPLICATION

PLUS_BORROWER_ID

 
RPRLAPP_PLUS_TO_STUDENT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

GIVE_PLUS_TO_STUDENT_IND

NA
RPRLAPP_PN_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PROMISSORY_NOTE_DATE

NA
RPRLAPP_PREP_OR_TEACH_IND RPALORG

REPORTING VIEW

LOAN_APPLICATION

PREP_TEACHER_CERTIFICATION

 
RPRLAPP_PREVIOUS_APP_ID RPALORG

REPORTING VIEW

LOAN_APPLICATION

PLUS_PREVIOUS_APPLICATION_ID

 
RPRLAPP_PROCESS_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

PROCESS_DATE

NA
RPRLAPP_PROGRAM_OF_STUDY RPALORG

REPORTING VIEW

LOAN_APPLICATION

PROGRAM_OF_STUDY

 
RPRLAPP_RECEIVE_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_APPLICATION_RECEIVED_DATE

NA
RPRLAPP_RECOMMEND_AMT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_RECOMMENDED_AMOUNT

NA
RPRLAPP_RECORD_TYPE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

RECORD_TYPE

NA
RPRLAPP_REPAY_OPT_IND RPAELAP

REPORTING VIEW

LOAN_APPLICATION

REPAYMENT_OPTION_CODE

NA
RPRLAPP_REQUEST_AMT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

APPLICANT_LOAN_REQUESTED_AMT

NA
RPRLAPP_REQ_AWARD_END_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

REQUESTED_AWARD_END_DATE

 
RPRLAPP_REQ_AWARD_START_DATE RPALORG

REPORTING VIEW

LOAN_APPLICATION

REQUESTED_AWARD_START_DATE

 
RPRLAPP_RETURN_PIDM NA

REPORTING VIEW

LOAN_DISBURSEMENT

RETURN_UID

NA
RPRLAPP_SAR_TRAN_NO RPALORG

REPORTING VIEW

LOAN_APPLICATION

SAR_TRANSACTION_NUMBER

 
RPRLAPP_SCHOOL_CODE RPALORG

REPORTING VIEW

LOAN_APPLICATION

DIRECT_LOAN_SCHOOL_CODE

 
RPRLAPP_SCHOOL_CR_BALANCE_OPT RPALORG

REPORTING VIEW

LOAN_APPLICATION

CREDIT_BALANCE_OPTION_IND

 
RPRLAPP_SLS_LOAN_DEBT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

SLS_LOAN_DEBT

NA
RPRLAPP_SPGM_LOCK_IND RPALORG

REPORTING VIEW

LOAN_APPLICATION

PROGRAM_SEQUENCE_LOCK_IND

 
RPRLAPP_SPGM_SEQ_NO RPALORG

REPORTING VIEW

LOAN_APPLICATION

PROGRAM_SEQUENCE_NUMBER

 
RPRLAPP_SSN RPAELAP        
RPRLAPP_STAF_LOAN_DEBT RPAELAP

REPORTING VIEW

LOAN_APPLICATION

STAFFORD_LOAN_DEBT

NA
RPRLAPP_STATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

STATE_PROVINCE

STATE_PROVINCE

NA
RPRLAPP_STAT_CODE_LIC RPAELAP

REPORTING VIEW

LOAN_APPLICATION

DRIVER_LICENSE_STATE_PROVINCE

NA
RPRLAPP_STU_EMAIL RPAELAP

REPORTING VIEW

LOAN_APPLICATION

EMAIL_ADDRESS

NA
RPRLAPP_STU_MAJOR RPAELAP

REPORTING VIEW

LOAN_APPLICATION

MAJOR

NA
RPRLAPP_SUB_DATE RPAELAP

REPORTING VIEW

LOAN_APPLICATION

SUBMISSION_DATE

NA
RPRLAPP_UNKNOWN_LOAN_AMT_IND RPALORG

REPORTING VIEW

LOAN_APPLICATION

LOAN_AMOUNT_UNKNOWN_IND

 
RPRLAPP_USER_ID RPALORG

REPORTING VIEW

LOAN_APPLICATION

APPLICATION_USER_ID

 
RPRLAPP_XREF_LOAN_ID RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

LOAN_APPLICATION

XREF_LOAN_ID

XREF_LOAN_ID

NA
RPRLAPP_YR_IN_COLL RPALORG

REPORTING VIEW

LOAN_APPLICATION

YEAR_IN_COLLEGE

 
RPRLAPP_ZIP RPAELAP

REPORTING VIEW

LOAN_APPLICATION

LOAN_DISBURSEMENT

POSTAL_CODE

POSTAL_CODE

NA


Ver: 9.0