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

Source Column Source Form Target Type Target Target Column Calculation Formula
RLRPAPP_APP_LOAN_AMT RLADLOR        
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_ACTIVITY_DATE RPALORG        
RPRLAPP_ADDRESS RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

STREET_LINE1

NA
RPRLAPP_ADDR_LINE2 RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

STREET_LINE2

NA
RPRLAPP_ADDR_LINE3 RPALORG        
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_BIRTH_DATE RPALORG        
RPRLAPP_BOOK_DATE RPALORG        
RPRLAPP_BOOK_DOCUMENT_ID RPALORG        
RPRLAPP_BORROWER_EMAIL RPALORG        
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_DATA_ORIGIN 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_DOCUMENT_ID RPALORG        
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_ADDR_LINE3 RPALORG        
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_LPRD_END_DATE RPALORG        
RPRLAPP_LPRD_START_DATE RPALORG        
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_DOCUMENT_ID RPALORG        
RPRLAPP_MPN_EXP_CODE RPALORG        
RPRLAPP_MPN_EXP_DATE RPALORG        
RPRLAPP_MPN_EXP_DESC RPALORG        
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_ADDR_LINE3 RPALORG        
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_ADDR_LINE3 RPALORG        
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_BORROWER_ID_NO 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_PREP_OR_TEACH_IND RPALORG        
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_SAR_TRAN_NO RPALORG        
RPRLAPP_SCHOOL_CODE RPALORG        
RPRLAPP_SCHOOL_CR_BALANCE_OPT RPALORG        
RPRLAPP_SLS_LOAN_DEBT RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

SLS_LOAN_DEBT

NA
RPRLAPP_SPGM_LOCK_IND RPALORG        
RPRLAPP_SPGM_SEQ_NO RPALORG        
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_USER_ID RPALORG        
RPRLAPP_XREF_LOAN_ID RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

XREF_LOAN_ID

NA
RPRLAPP_YR_IN_COLL RPALORG        
RPRLAPP_ZIP RPAELAP COMPOSITE VIEW

AR_LOAN_APPLICATION

POSTAL_CODE

NA


Ver: