Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
RCRLDS4_AIDY_CODE
|
 
|
VARCHAR2(4)
|
No
|
*
|
*
|
RCRLDS4_PIDM
|
 
|
NUMBER(8,0)
|
No
|
*
|
*
|
RCRLDS4_INFC_CODE
|
 
|
VARCHAR2(7)
|
No
|
*
|
*
|
RCRLDS4_SEQ_NO
|
 
|
NUMBER(3,0)
|
No
|
*
|
*
|
RCRLDS4_CURR_REC_IND
|
 
|
VARCHAR2(1)
|
No
|
 
|
 
|
RCRLDS4_CREATOR_ID
|
 
|
VARCHAR2(30)
|
No
|
 
|
 
|
RCRLDS4_USER_ID
|
 
|
VARCHAR2(30)
|
No
|
 
|
 
|
RCRLDS4_CREATE_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RCRLDS4_ACTIVITY_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RCRLDS4_NSLDS_DB_RESULT_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_SUB_OUT_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_CUMULATIVE_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_CURRENT_YR_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_1ST_DISB_FLAG_1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_1ST_DISB_FLAG_2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_EXP_LOAN_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_PELL_OVER_PAY_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_SEOG_OVER_PAY_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_DEFAULT_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_ACT_BANKRUPT_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_PROC_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RCRLDS4_MATCH_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_SUB_PEND_DISB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_UNSUB_PEND_DISB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_CONSOL_PEND_DISB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_SUB_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_UNSUB_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_CONSOL_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_TRAN_NO
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RCRLDS4_PELL_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RCRLDS4_SEOG_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_OVER_PAY_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_DEFAULTED_LOAN_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_DISCHARG_LOAN_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_LOAN_SAT_REPAY_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_DEF_LOAN_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_DISCHARG_LOAN_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_LOAN_SAT_REPAY_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_ACT_BANKRUPT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_OVER_PAY_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_PERK_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_PELL_PMT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_ADDL_PELL_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_ADDL_LOANS_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_COMB_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_COMB_PEND_DISB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_COMB_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_POST_SCREEN_RSN_CDE
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RCRLDS4_DL_MPN_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_FFEL_MPN_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_FFEL_LEND_CODE
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RCRLDS4_LOAN_CHG_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_CURRENT_SSN
|
 
|
VARCHAR2(9)
|
Yes
|
 
|
 
|
RCRLDS4_CURRENT_FIRST_NAME
|
 
|
VARCHAR2(12)
|
Yes
|
 
|
 
|
RCRLDS4_CURRENT_LAST_NAME
|
 
|
VARCHAR2(35)
|
Yes
|
 
|
 
|
RCRLDS4_CURRENT_BIRTH_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RCRLDS4_DL_PLUS_MPN_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_POST_SCREEN_RSN_CDE_2
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RCRLDS4_POST_SCREEN_RSN_CDE_3
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_OVER_LIMIT_SUB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_OVER_LIMIT_COMB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_FFEL_CONS_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_PLUS_OUT_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_FFEL_CONS_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_PLUS_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_ACG_PMT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_SMART_PMT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_ADDL_ACG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_ADDL_SMART_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_DL_GR_PLUS_MPN_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_ACG_OVER_PAY_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_ACG_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RCRLDS4_SMART_OVER_PAY_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_SMART_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RCRLDS4_FRAUD_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_GR_PLUS_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_AGT_GR_PLUS_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RCRLDS4_FRAUD_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_GR_AGT_OVER_LIMIT_SUB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RCRLDS4_GR_AGT_OVER_LIMIT_COMB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
RLRAPP1_LOG_NO
|
 
|
NUMBER(8,0)
|
No
|
*
|
 
|
RLRAPP1_ID_NO
|
 
|
NUMBER(1,0)
|
No
|
*
|
 
|
RLRAPP1_AIDY_CODE
|
 
|
VARCHAR2(4)
|
No
|
 
|
*
|
RLRAPP1_PIDM
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLRAPP1_INFC_CODE
|
 
|
VARCHAR2(7)
|
No
|
 
|
*
|
RLRAPP1_SEQ_NO
|
 
|
NUMBER(3,0)
|
No
|
 
|
 
|
RLRAPP1_CURR_REC_IND
|
 
|
VARCHAR2(1)
|
No
|
 
|
 
|
RLRAPP1_CREATOR_ID
|
 
|
VARCHAR2(30)
|
No
|
 
|
 
|
RLRAPP1_USER_ID
|
 
|
VARCHAR2(30)
|
No
|
 
|
 
|
RLRAPP1_CREATE_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RLRAPP1_ACTIVITY_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RLRAPP1_COLL_CDE
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_ACYR_CODE
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_LAST_NAME
|
 
|
VARCHAR2(60)
|
Yes
|
 
|
 
|
RLRAPP1_FIRST_NAME
|
 
|
VARCHAR2(60)
|
Yes
|
 
|
 
|
RLRAPP1_MI
|
 
|
VARCHAR2(60)
|
Yes
|
 
|
 
|
RLRAPP1_TITLE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_ADDR
|
 
|
VARCHAR2(75)
|
Yes
|
 
|
 
|
RLRAPP1_CITY
|
 
|
VARCHAR2(50)
|
Yes
|
 
|
 
|
RLRAPP1_STAT_CODE
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_ZIP
|
 
|
VARCHAR2(30)
|
Yes
|
 
|
 
|
RLRAPP1_SSN_PREFIX
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SSN
|
 
|
VARCHAR2(15)
|
Yes
|
 
|
 
|
RLRAPP1_BIRTH_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP1_PHONE_AREA
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_PHONE_NO
|
 
|
VARCHAR2(12)
|
Yes
|
 
|
 
|
RLRAPP1_STAT_CODE_RES
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_START_RES_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_RCPT_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP1_REV_RCPT_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP1_ORIG_COMP_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP1_REV_COMP_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP1_CITZ_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_ALIEN_REG_NO
|
 
|
VARCHAR2(9)
|
Yes
|
 
|
 
|
RLRAPP1_MRTL_STATUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_HS_CDE
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_ENROLL_STATUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_YR_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_CRSE_OF_STUDY
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_GRAD_MTH_YR
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_DEGREE_BY_JULY
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_MORE_THAN_3_PREV_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_NO_SCH
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP1_PREV_COLL1
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_PREV_COLL2
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_PREV_COLL3
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_DRIVER_LIC_NO
|
 
|
VARCHAR2(20)
|
Yes
|
 
|
 
|
RLRAPP1_STAT_CODE_LIC
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_DISL_WRK
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_DISP_HME
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_FAM_MEMB
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP1_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP1_CASH_AMT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_HME_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_HME_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_RE_INV_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_RE_INV_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_BUS_FARM_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_BUS_FARM_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_INCL_FARM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_BORN_BEFORE_1_1_XX
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_US_VET
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_WARD_OF_COURT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_HAS_LEGAL_DEPEND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_TAX_FORM_IND
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_NO_EXEMPT
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP1_US_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_US_INC_TAX_PD
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_INC_FR_WRK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_SPS_INC_FR_WRK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_SS_BENE
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_AFDC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_CHILD_SUPP
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_OTH_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_MED_DEN_EXP
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_TUIT_PD
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_NO_CHILD_TUIT
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_TAX_PD
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_INC_FR_WRK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_SPS_INC_FR_WRK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_OTH_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_SMR_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_ACYR_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_SPS_SMR_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_SPS_ACYR_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_SMR_OTH_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_ACYR_OTH_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_SMR_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_ACYR_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_GI_DEAB_AMT
|
 
|
NUMBER(3,0)
|
Yes
|
 
|
 
|
RLRAPP1_GI_DEAB_MTH
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP1_VEAP_BEN_AMT
|
 
|
NUMBER(3,0)
|
Yes
|
 
|
 
|
RLRAPP1_VEAP_BEN_MTH
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP1_OTH_VA_AMT
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP1_OTH_VA_MTH
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP1_CLM_AS_TAX_EXEMPT_2YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_CLM_AS_TAX_EXEMPT_1YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_CLM_AS_TAX_EXEMPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_WHEN_RCVD_AID
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1985_RSRC_4000_8788
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1986_RSRC_4000_8788
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1986_RSRC_4000_8889
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1987_RSRC_4000_8889
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1987_RSRC_4000_8990
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1988_RSRC_4000_8990
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1988_RSRC_4000_9091
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1989_RSRC_4000_9091
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_NO_AID_RSRC_4000_2YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_NO_AID_RSRC_4000_1YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE2_RELSHIP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE2_ATTEND_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE3_RELSHIP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE3_ATTEND_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE4_RELSHIP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE4_ATTEND_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE5_RELSHIP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE5_ATTEND_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE6_RELSHIP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE6_ATTEND_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE7_RELSHIP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE7_ATTEND_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE8_RELSHIP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_LINE8_ATTEND_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_MRTL_STATUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_OLDER_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_STAT_CODE_RES
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_DISL_WRK
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_DISP_HME
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_FAM_MEMB
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_CASH_AMT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_HME_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_HME_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_RE_INV_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_RE_INV_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_CURR_INV_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_BUS_FARM_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_BUS_FARM_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_INCL_FARM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_HME_YR_PURCH
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_HME_PURCH_AMT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_DIV_SEP_REM_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_TAX_FORM_IND
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_NO_EXEMPT
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_US_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_WAGES
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_INT_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_DIV_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_BUS_FARM_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_OTH_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_ADJ_TO_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_US_INC_TAX_PD
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_FATH_INC_FR_WRK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_MOTH_INC_FR_WRK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_SS_BENE
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_AFDC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_CHILD_SUPP
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_OTH_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_MED_DEN_EXP
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_TUIT_PD
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_NO_CHILD_TUIT
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_PAR_TAX_PD
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_PAR_OTH_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_PAR_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_FATH_INC_FR_WRK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_MOTH_INC_FR_WRK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_FED_COLL_CHOICE_1
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_FED_COLL_CHOICE_2
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_FED_COLL_CHOICE_3
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CHOICE_NO
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_IN_DEFAULT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_OWES_REFUND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_CONSIDER_FOR_STAF
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_BAL_ON_ALL_STAF
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP1_RECENT_STAF_BAL
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP1_RECENT_STAF_INT_RATE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RECENT_STAF_FR_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_RECENT_STAF_TO_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_RECENT_STAF_CLASS
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_PREF
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_FR_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_TO_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_STAF_AMT
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_STAF_FA_FR_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_STAF_FA_TO_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_SUMMER_THIS_YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_FALL_THIS_YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_WINTER_NEXT_YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_SPRING_NEXT_YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_SUMMER_NEXT_YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RQST_FA_OTHER
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_CLASSIFICATION
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_EXP_WRK_HRS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_INST_HOUS_CDE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CDE_1
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_HOUS_CDE_1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CDE_2
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_HOUS_CDE_2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CDE_3
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_HOUS_CDE_3
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CDE_4
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_HOUS_CDE_4
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CDE_5
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_HOUS_CDE_5
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CDE_6
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_HOUS_CDE_6
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CDE_7
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_HOUS_CDE_7
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_COLL_CDE_8
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_HOUS_CDE_8
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_ADDL_COLL_CDE_1
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_ADDL_COLL_CDE_2
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_ADDL_COLL_CDE_3
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_ADDL_COLL_CDE_4
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_ADDL_COLL_CDE_5
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_ADDL_COLL_CDE_6
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_ADDL_COLL_CDE_7
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_ADDL_COLL_CDE_8
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_EXTRA_REQUEST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_REL_TO_STATE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_REL_TO_US_ED
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_REL_US_ED_TO_STATE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_REL_US_ED_TO_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_BUS_FARM_SUPP_FILED
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SIGNED
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SIGNED_SPS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SIGNED_FATH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SIGNED_MOTH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SIGNED_PAR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SIGNED_MTH_DAY
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_SIGNED_YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_DEPEND_AGE_0_5
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP1_DEPEND_AGE_6_12
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP1_DEPEND_AGE_13_PLUS
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP1_CONT_WRK_ACYR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PERMIT_DRAFT_REG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PELL_REL_MSG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_ST_AGENCY_REL_MSG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_VERIFICATION_MSG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_VERIFICATION_PRTY
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_INS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SELECTIVE_SERVICE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SPEC_COND_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_TITLE_IV_DEFAULT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_INAS_OPTION
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_EDE_SOURCE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_EDE_SPEC_COND_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_USED_TRANS_NO
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP1_DEF_MATCH_REGION
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PREV_COLL4
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP1_1989_RSRC_4000_9192
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_1990_RSRC_4000_9192
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_IN_DEF_OWE_REF
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_SS_BENE_STU_ONLY
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP1_COMPLETION_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP1_PAR_REMARRIAGE_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP1_LOWEST_INC_FILER
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_MEANS_TEST_BEN
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_RECD_TANF
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_RECD_SSI
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_MEANS_TEST_BEN
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_HOUS_STAT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_ACTIVE_DUTY
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_FOOD_STAMPS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_SCHOOL_LUNCH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_PAR_RECD_WIC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RECD_SSI
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_FOOD_STAMPS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SCHOOL_LUNCH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RECD_TANF
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_RECD_WIC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP1_SURNAME_PREFIX
|
 
|
VARCHAR2(60)
|
Yes
|
 
|
 
|
RLRAPP1_CTRY_CODE_PHONE
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP1_ADDR2
|
 
|
VARCHAR2(75)
|
Yes
|
 
|
 
|
RLRAPP1_ADDR3
|
 
|
VARCHAR2(75)
|
Yes
|
 
|
 
|
RLRAPP1_ADDR4
|
 
|
VARCHAR2(75)
|
Yes
|
 
|
 
|
RLRAPP1_HOUSE_NUMBER
|
 
|
VARCHAR2(10)
|
Yes
|
 
|
 
|
Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
RLRAPP2_LOG_NO
|
 
|
NUMBER(8,0)
|
No
|
*
|
 
|
RLRAPP2_ID_NO
|
 
|
NUMBER(1,0)
|
No
|
*
|
 
|
RLRAPP2_AIDY_CODE
|
 
|
VARCHAR2(4)
|
No
|
 
|
*
|
RLRAPP2_PIDM
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLRAPP2_INFC_CODE
|
 
|
VARCHAR2(7)
|
No
|
 
|
*
|
RLRAPP2_SEQ_NO
|
 
|
NUMBER(3,0)
|
No
|
 
|
 
|
RLRAPP2_MODEL_CDE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_DATA_PRESENT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_DATA_PRESENT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_DEPEND_STATUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_MRTL_STATUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_FAM_MEMB
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_MRTL_STATUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_FAM_MEMB
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_PAR_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_OTH_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_ASSUME_YR_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_AGI_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_TOT_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_TOT_INC
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_US_INC_TAX
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_ST_OTH_TAX
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_FICA_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_MED_DEN_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_SCH_TUIT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_EMP_ALLOW
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_MNT_ALLOW
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_TOT_ALLOW
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_AVAIL_DISC_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_CASH_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_RE_INV_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_ADJ_BF_NET_WTH
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_NET_WTH
|
 
|
NUMBER(9,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_PROT_ALLOW
|
 
|
NUMBER(9,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_DISC_NET_WTH
|
 
|
NUMBER(9,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_CONV_PCT
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_INC_SUPPLEMENT
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_ADJ_AVAIL_INC
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_TOT_CTRB
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_CTRB_FOR_STDT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_CTRB_FR_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_CTRB_FR_ASSET
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_AGI_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_TOT_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_TOT_INC
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_US_INC_TAX
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_ST_OTH_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_FICA_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_MED_DEN_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_SCH_TUIT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_EMP_ALLOW
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_MNT_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_TOT_ALLOW
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_AVAIL_DISC_INC
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_CASH_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_HME_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_RE_INV_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_ADJ_BF_NET_WTH
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_NET_WTH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_PROT_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_DISC_NET_WTH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_CONV_PCT
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_INC_SUPPLEMENT
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_ADJ_AVAIL_INC
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_TOT_CTRB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_NO_IN_COLL
|
 
|
NUMBER(4,1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_CTRB_FR_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_CTRB_FR_ASSET
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_AGI_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_TOT_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_TOT_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_US_INC_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_ST_OTH_TAX
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_FICA_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_MED_DEN_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_SCH_TUIT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_EMP_ALLOW
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_MNT_ALLOW
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_AVAIL_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_AVAIL_DISC_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_CASH_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_RE_INV_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_ADJ_BF_NET_WTH
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_NET_WTH
|
 
|
NUMBER(9,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_PROT_ALLOW
|
 
|
NUMBER(9,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_DISC_NET_WTH
|
 
|
NUMBER(9,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_CONV_PCT
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_INC_SUPPLEMENT
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_ADJ_AVAIL_INC
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_TOT_CTRB
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_CTRB_FR_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_CTRB_FR_ASSET
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_VA_BEN_INCL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_TAX_INC_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_TOT_ALLOW
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_CALC_AVAIL_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_AGI_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_TOT_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_TOT_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_US_INC_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_ST_OTH_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_FICA_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_MED_DEN_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_SCH_TUIT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_EMP_ALLOW
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_MNT_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_AVAIL_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_AVAIL_DISC_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_CASH_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_RE_INV_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_ADJ_BF_NET_WTH
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_NET_WTH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_PROT_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_DISC_NET_WTH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_CONV_PCT
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_INC_SUPPLEMENT
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_ADJ_AVAIL_INC
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_NO_IN_COLL
|
 
|
NUMBER(4,1)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_CTRB_FR_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_CTRB_FR_ASSET
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_VA_BEN_INCL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_TAX_INC_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_TOT_ALLOW
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_CALC_AVAIL_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_TOT_FAM_CTRB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_TFC_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_TOT_FAM_CTRB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_2_TFC_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_AGI_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_TOT_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_TOT_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_US_INC_TAX
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_ST_OTH_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_MED_DEN_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_SCH_TUIT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_EMP_ALLOW
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_MNT_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_TOT_ALLOW
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_AVAIL_DISC_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_CASH_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_RE_INV_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_ADJ_BF_NET_WTH
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_NET_WTH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_PROT_ALLOW
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_DISC_NET_WTH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_CONV_PCT
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_CTRB_FR_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_CTRB_FR_ASSET
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_P_2_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_AGI_TAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_TOT_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_TOT_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_US_INC_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_ST_OTH_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_MED_DEN_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_SCH_TUIT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_EMP_ALLOW
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_MNT_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_TOT_ALLOW
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_AVAIL_DISC_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_CASH_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_RE_INV_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_ADJ_BF_NET_WTH
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_NET_WTH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_PROT_ALLOW
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_DISC_NET_WTH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_CONV_PCT
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_CTRB_FR_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_CTRB_FR_ASSET
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_PGI
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_PGI_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_2_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_2_PGI
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_PELL_2_PGI_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_IM_BUDG_LENGTH
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP2_IM_1_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_IM_1_SC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_IM_1_PAR_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_IM_1_PC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_IM_1_UNASSESSED_VA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_IM_1_TFC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP2_IM_2_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_IM_2_SC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_IM_2_PAR_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_IM_2_PC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_IM_2_UNASSESSED_VA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_INAS_CTR
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP2_RQST_SLS_AMT
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP2_DEFER_SLS_PMTS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_SLS_INTS_PMTS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_BAL_ON_ALL_SLS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_RECENT_SLS_BAL
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_RECENT_SLS_FR_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP2_RECENT_SLS_CLASS
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP2_LENDER_CODE
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP2_DEGREE_SOUGHT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_DRUG_ABUSE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_ELIGIBILITY_MSG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_EPS_CDE
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP2_HS_GRADUATE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_ORIG_RCPT_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP2_DUR_ELIG_OVRD_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_UNADJ_BUS_NET
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_1_UNADJ_FARM_NET
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_UNADJ_BUS_NET
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_1_UNADJ_FARM_NET
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_CALC_AVAIL_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_UNADJ_BUS_NET
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_2_UNADJ_FARM_NET
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_1_FED_EFC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_1_FED_ELIG
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_1_VA_BEN
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_2_FED_EFC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_2_FED_ELIG
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_2_VA_BEN
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_3_FED_EFC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_3_FED_ELIG
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_FM_INST_3_VA_BEN
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP2_CM2_IM_CALC_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP2_C_PAR_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP2_USER_ID
|
 
|
VARCHAR2(30)
|
Yes
|
 
|
 
|
RLRAPP2_ACTIVITY_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
RLRAPP3_LOG_NO
|
 
|
NUMBER(8,0)
|
No
|
*
|
 
|
RLRAPP3_ID_NO
|
 
|
NUMBER(1,0)
|
No
|
*
|
 
|
RLRAPP3_AIDY_CODE
|
 
|
VARCHAR2(4)
|
No
|
 
|
*
|
RLRAPP3_PIDM
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLRAPP3_INFC_CODE
|
 
|
VARCHAR2(7)
|
No
|
 
|
*
|
RLRAPP3_SEQ_NO
|
 
|
NUMBER(3,0)
|
No
|
 
|
 
|
RLRAPP3_C_INST_1_UNASSESS_VA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_INST_2_UNASSESS_VA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_INST_3_UNASSESS_VA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_1_ALT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_2_ALT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PELL_1_ALT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PELL_2_ALT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_PAR_1_ALT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_PAR_2_ALT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PELL_1_ALT_PGI
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PELL_2_ALT_PGI
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_1_ALT_AGI
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_2_ALT_AGI
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_ALT_MRTL_STATUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_ALT_FAM_SIZE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_ALT_NO_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ALT_OPT_LOSS_TO_ZERO
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ALT_OPT_HME_VAL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ALT_OPT_PAR_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_91
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_91_BUDG_1
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_91_BUDG_2
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_91_BUDG_3
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_73_TAX
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP3_C_1_CTRB_ADJ_1_8_MTH
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_2_CTRB_ADJ_1_8_MTH
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_1_CTRB_ADJ_OVR_9_MTH
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_2_CTRB_ADJ_OVR_9_MTH
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_1
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_2
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_3
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_4
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_5
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_6
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_7
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_8
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_9
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_10
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_11
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_12
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_13
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_REASON_PRTY_14
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_REJ_IN_ANALYSIS_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_0
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_3
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_4
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_5
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_6
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_11
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_12
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_13
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_14
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_15
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_21
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_22
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_23
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_24
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_26
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_27
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_28
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_29
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_30
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_32
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_33
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_34
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_46
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_47
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_48
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_49
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_50
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_61
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_62
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_63
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_64
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_65
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_66
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_67
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_68
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_71
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_73
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_74
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_75
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_76
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_77
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_78
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_79
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_80
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_81
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_82
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_90
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_92
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_93
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_94
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_95
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_96
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_97
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_98
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_99
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_11_PAR_FAM_MEMB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_12_PAR_NO_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_22_PAR_DER_AGI
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_27_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_47_PAR_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_48_PAR_HME_VAL_3
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_48_PAR_HME_EQTY_3
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_49_PAR_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_49_PAR_HME_EQTY
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_63_FAM_MEMB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_64_NO_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_81_AVAIL_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_90_INC
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_90_SMA
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_90_DIFF
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_92_BUDG_1
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_92_BUDG_2
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_92_BUDG_3
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_93_CALC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_93_RESC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_1_ALT_FED_TAX
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_2_ALT_FED_TAX
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_0_FED_1_FAM_CTRB
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_0_FED_2_FAM_CTRB
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_0_FED_1_PGI
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_0_FED_2_PGI
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_1
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_2
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_3
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_4
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_5
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_6
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_51
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_51_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_83
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_84
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_85
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_85_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_3
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_4
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_5
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_6
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_7
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_8
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPT_OVRD_9
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ATTEND_SAME_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_BUS_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_BUS_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_C_SIGNED
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_C_SIGNED_FATH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_C_SIGNED_MOTH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_C_SIGNED_MTH_DAY
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP3_C_SIGNED_PAR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_C_SIGNED_SPS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_C_SIGNED_YR
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_CASH_CHK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_CHILD_CARE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP3_CHILD_SUPP_PAID
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_DEGREE_TYPE
|
 
|
VARCHAR2(3)
|
Yes
|
 
|
 
|
RLRAPP3_EFC_MATCH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ESTIMATE_FLAGS
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_FAA_DEP_OVERRIDE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_FAA_SIGNATURE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_FAA_TITLE_IV_CODE
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_FAF_FAFSA_DATA
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_FAF_RCPT_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP3_FARM_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_FARM_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_FATHER_AGE
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_FATHER_HI_GRADE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_FED_COLL_CHOICE_4
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_FED_COLL_CHOICE_5
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_FED_COLL_CHOICE_6
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_GA_MATCH_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_GED_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP3_GRAD_OR_PROF
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_HS_GRAD_MTH_YR
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP3_INVEST_DBT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_INVEST_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_LIVE_ON_FARM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MARRIED
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MOTHER_AGE
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_MOTHER_HI_GRADE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_52
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MSG_91_SEC_FM_EFC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_P_RES_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP3_PAR_ALT_HME_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_ALT_HME_VAL_CAP
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_BUS_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_BUS_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_CASH_CHK
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_CHILD_SUPP_PAID
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_EIC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_FARM_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_FARM_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_FOR_INC_EXCL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_HOUSE_FOOD_OTH
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_INC_BENEFITS
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_INVEST_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_INVEST_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_IRA_KEOUGH
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_LIVE_ON_FARM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_MTH_MORT_RENT_PAY
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_PORTION_OF_PENS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_RE_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_RE_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_SPEC_FUELS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_TAX_DEF_PENSION
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_TE_INT_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PIN
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP3_PREPARER_EIN
|
 
|
VARCHAR2(9)
|
Yes
|
 
|
 
|
RLRAPP3_PREPARER_SIGN
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_PREPARER_SSN
|
 
|
VARCHAR2(15)
|
Yes
|
 
|
 
|
RLRAPP3_PREV_COLL5
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_RE_DBT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_RE_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_3
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_4
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_5
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_6
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_7
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_S_MAR_MTH_YR
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_SAR_C_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_SELF_HELP_VALUE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_SOC_SEC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_STU_ALT_NO_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP3_YR_IN_COLL_2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ADJ_EFC_CALC_REQ
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_FAA_ADJ_EFC_CORR
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP3_EFC_RECALC_CORR_REQ
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_S_RES_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP3_OFFL_UNOFFL_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_7
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_8
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_9
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_ASSUMPTION_MSG_10
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP3_PHEAA_GRANT_AMT_1
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PHEAA_GRANT_AMT_2
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PHEAA_GRANT_AMT_3
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PHEAA_GRANT_AMT_4
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP3_PHEAA_GRANT_CDE_1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_PHEAA_GRANT_CDE_2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_PHEAA_GRANT_CDE_3
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_PHEAA_GRANT_CDE_4
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_A
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_C
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_MAR_MTH_YR
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_PAR_TUI_FEE_DED
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP3_FATH_SSN_MATCH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_MOTH_SSN_MATCH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_G
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_USER_ID
|
 
|
VARCHAR2(30)
|
Yes
|
 
|
 
|
RLRAPP3_ACTIVITY_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_12
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_J
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_K
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_FED_COLL_CHOICE_7
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_FED_COLL_CHOICE_8
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_FED_COLL_CHOICE_9
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_FED_COLL_CHOICE_10
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_B
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_N
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_W
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP3_REJECT_OVRD_20
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
RLRAPP4_LOG_NO
|
 
|
NUMBER(8,0)
|
No
|
*
|
 
|
RLRAPP4_ID_NO
|
 
|
NUMBER(1,0)
|
No
|
*
|
 
|
RLRAPP4_AIDY_CODE
|
 
|
VARCHAR2(4)
|
No
|
 
|
*
|
RLRAPP4_PIDM
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLRAPP4_INFC_CODE
|
 
|
VARCHAR2(7)
|
No
|
 
|
*
|
RLRAPP4_SEQ_NO
|
 
|
NUMBER(3,0)
|
No
|
 
|
 
|
RLRAPP4_REC_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_MDE_ID_NO
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RLRAPP4_CTRL_NO
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRAPP4_TAPE_RPT_EXTRCT_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP4_INST_RPT_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_SECT_R_WRITTEN_EXPLAIN
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_SECT_S_INST_ID
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP4_ST_SPECIFIC_INFO
|
 
|
VARCHAR2(160)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_OUT_ST_TUIT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_BUDG_NAME
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_BUDG_DUR
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_TUIT_FEE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_BOOKS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_LIVING_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_TOT_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_TOT_PAR_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_TOT_FAM_CTRB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_TFC_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_EST_FA_NEED
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_EST_PELL_AWRD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_EST_ST_AWRD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_BUDG_NAME
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_BUDG_DUR
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_TUIT_FEE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_BOOKS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_LIVING_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_TOT_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_TOT_PAR_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_TOT_FAM_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_TFC_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_EST_FA_NEED
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_EST_PELL_AWRD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_EST_ST_AWRD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_BUDG_NAME
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_BUDG_DUR
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_TUIT_FEE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_BOOKS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_LIVING_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_TOT_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_TOT_PAR_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_TOT_FAM_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_TFC_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_EST_FA_NEED
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_EST_PELL_AWRD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_EST_ST_AWRD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_DEPEND_CARE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_DEPEND_CARE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_DEPEND_CARE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_P_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_P_CTRB_FOR_STDT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_P_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_P_CTRB_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_P_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_P_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_TOT_FAM_CTRB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_TFC_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_TOT_FAM_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_TFC_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_PELL_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_PELL_PGI
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_PELL_OFFL_EST
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_PELL_PGI
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_IM_CTRB_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_IM_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_IM_CTRB_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_IM_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_P_IM_CTRB_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_P_IM_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_P_IM_CTRB_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_2_P_IM_ANLY_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_IM_TOT_FAM_CTRB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_FISAP_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_RECORD_MARK
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_COLL_SPECIFIC_INFO
|
 
|
VARCHAR2(98)
|
Yes
|
 
|
 
|
RLRAPP4_ADJ_EFC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_EFC_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_ESAR_USER_DEF_FIELDS
|
 
|
VARCHAR2(100)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_ASSUM_HOUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_2_ASSUM_HOUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_3_ASSUM_HOUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_ASSUM_HOUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_BUDG_DUR
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_BUDG_NAME
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_EST_FA_NEED
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_EST_PELL_AWRD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_LIVING_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_TOT_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_TOT_FAM_CTRB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_TOT_PAR_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_TUIT_FEE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_4_UNASSESS_VA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_ASSUM_HOUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_BUDG_DUR
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_BUDG_NAME
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_EST_FA_NEED
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_EST_PELL_AWRD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_LIVING_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_TOT_EXP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_TOT_FAM_CTRB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_TOT_PAR_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_TUIT_FEE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_5_UNASSESS_VA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_1_EST_PELL_AWD
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_1_TOT_FAM_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_2_EST_PELL_AWD
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_2_TOT_FAM_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_3_EST_PELL_AWD
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_3_TOT_FAM_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_4_EST_PELL_AWD
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_4_TOT_FAM_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_5_EST_PELL_AWD
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP4_C2_INST_5_TOT_FAM_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_PELL_1_EFC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_PELL_2_EFC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_S_IV_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_P_IV_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_CURRENT_PLUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_CURRENT_CONSOL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_WORK_STUDY
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_LOAN_INT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PLUS_INT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_S_DIV_INT_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_S_FARM_VAL_FAF
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_S_FARM_DBT_FAF
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_P_FARM_VAL_FAF
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP4_P_FARM_DBT_FAF
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP4_VERIF_NUM
|
 
|
VARCHAR2(15)
|
Yes
|
 
|
 
|
RLRAPP4_ALT_OPT_TUIT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_MSG_31
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_MSG_72
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_OLDEST_LOAN_DATE
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRAPP4_NSLDS_MATCH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_BAL_ON_SLS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_NA_1_IM_PC_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_IRA_KEOGH_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_EXP_PAR_TUIT_PD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_EXP_PAR_NO_CHILD_TUIT
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLRAPP4_HME_YR_PURCH
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRAPP4_HME_PURCH_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_VISA_CLASS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_C_INST_1_OTH_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_1_INC_ADJ
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_1_OTH_ALLOW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_1_IRA_KEOGH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_1_TRUST_VAL
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_1_OTH_ASSET
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_1_OTH_ASSET_ALLOW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_2_INC_ADJ
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_2_OTH_ALLOW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_2_IRA_KEOGH
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_2_TRUST_VAL
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_2_OTH_ASSET
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_2_OTH_ASSET_ALLOW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_PAR_1_INC_ADJ
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_PAR_1_OTH_ALLOW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_PAR_1_OTH_ASSET
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_PAR_1_OTH_ASSET_ALLW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_PAR_2_INC_ADJ
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_PAR_2_OTH_ALLOW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_PAR_2_OTH_ASSET
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_C_PAR_2_OTH_ASSET_ALLW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRAPP4_TYPE_DATA_AVAIL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_IM_PAR_DATA_AVAIL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_FM_PAR_DATA_AVAIL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_IM_BUDG_DUR_FOR_CALC
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLRAPP4_STATE_FOR_TAXES
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_STATE_FOR_TAXES
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP4_FORMULA_FOR_CALC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_TAX_FILER
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_TAX_FILER
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_TYPE_FM_CALC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_DEP_CARE_AND_MED
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_S_EIC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_SSA_CITIZEN_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_SAR_EFC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_HS_GED_RCVD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_FISAP_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP4_EMAIL_ADDRESS
|
 
|
VARCHAR2(128)
|
Yes
|
 
|
 
|
RLRAPP4_NSLDS_TRAN_NO
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRAPP4_DRIVERS_LIC_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_LEGAL_RES_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_LEGAL_RES_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_TX_RET_FILED_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_TX_RET_FILED_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_1040A_ELIG_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_1040A_ELIG_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_INV_NET_WORTH
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_INV_NET_WORTH
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_BUS_NET_WORTH
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_BUS_NET_WORTH
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_FARM_NET_WORTH
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_FARM_NET_WORTH
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRAPP4_DEATH_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP4_VA_MATCH_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_FISAP_2_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRAPP4_DRUG_OFFENSE_CONVIC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_FATH_LAST_NAME
|
 
|
VARCHAR2(60)
|
Yes
|
 
|
 
|
RLRAPP4_MOTH_LAST_NAME
|
 
|
VARCHAR2(60)
|
Yes
|
 
|
 
|
RLRAPP4_FATH_SSN
|
 
|
VARCHAR2(15)
|
Yes
|
 
|
 
|
RLRAPP4_MOTH_SSN
|
 
|
VARCHAR2(15)
|
Yes
|
 
|
 
|
RLRAPP4_SUB_VERIF_SELECTED
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_P_RES_DATE_MO_YR
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP4_S_RES_DATE_MO_YR
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRAPP4_PRISONER_MATCH_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_HAVE_CHILDREN
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_WORKSHEET_C
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_WORKSHEET_C
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_SOURCE_CORRECTION
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_EFC_CHANGE_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_DUP_SSN_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_EARLY_ADM_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_SEC_INS_MATCH_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_WORKSHEET_A
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_WORKSHEET_A
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_WORKSHEET_B
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_WORKSHEET_B
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_SS_MATCH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_SS_REG_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_FATH_FIRST_NAME_INI
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_FATH_BIRTH_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP4_MOTH_FIRST_NAME_INI
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_MOTH_BIRTH_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP4_P_EMAIL_ADDRESS
|
 
|
VARCHAR2(128)
|
Yes
|
 
|
 
|
RLRAPP4_ADDRESS_CHG_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PUSH_ISIR_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_SAR_C_CHANGE_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_CUSTODIAL_PARENT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_CUST_PAR_BASE_PCT_INC
|
 
|
NUMBER(3,0)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_BASE_CTRB_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_BASE_CTRB_ASSETS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_PAR_BASE_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRAPP4_USER_ID
|
 
|
VARCHAR2(30)
|
Yes
|
 
|
 
|
RLRAPP4_ACTIVITY_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRAPP4_FEE_WAIVER_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_WRK_STDY_LOANS_INT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_AP_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRAPP4_PAR1_OCCUPATION
|
 
|
VARCHAR2(20)
|
Yes
|
 
|
 
|
RLRAPP4_PAR1_EMPLOYER
|
 
|
VARCHAR2(20)
|
Yes
|
 
|
 
|
RLRAPP4_PAR2_OCCUPATION
|
 
|
VARCHAR2(20)
|
Yes
|
 
|
 
|
RLRAPP4_PAR2_EMPLOYER
|
 
|
VARCHAR2(20)
|
Yes
|
 
|
 
|
Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
RLRIMP1_LOG_NO
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLRIMP1_ID_NO
|
 
|
NUMBER(1,0)
|
No
|
 
|
 
|
RLRIMP1_AIDY_CODE
|
 
|
VARCHAR2(4)
|
No
|
 
|
 
|
RLRIMP1_PIDM
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLRIMP1_INFC_CODE
|
 
|
VARCHAR2(7)
|
No
|
 
|
 
|
RLRIMP1_SEQ_NO
|
 
|
NUMBER(3,0)
|
No
|
 
|
 
|
RLRIMP1_CREATOR_ID
|
 
|
VARCHAR2(30)
|
No
|
 
|
 
|
RLRIMP1_USER_ID
|
 
|
VARCHAR2(30)
|
No
|
 
|
 
|
RLRIMP1_CREATE_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RLRIMP1_ACTIVITY_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RLRIMP1_REGIS_RCPT_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRIMP1_REGIS_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_APPLIC_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_ELEC_EXTRACT_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRIMP1_ADDL_SCHL_REQ_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRIMP1_FIN_AID_STATUS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_CITZ_COUNTRY
|
 
|
VARCHAR2(15)
|
Yes
|
 
|
 
|
RLRIMP1_ITEM_DEDUCTNS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_EIC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_TAX_STU_AID
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_IRA_KEOGH_ACCT_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_TRUST_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_TRUST_AVAIL_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_TRUST_ESTAB_BY
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_EXP_GRANT_SCHLRSHP
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_EXP_TUIT_BENE
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_EXP_PAR_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_EXP_OTH_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_PRNT_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_NTRL_SEP_DIV
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_ED_LN_RPAY_AMT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_EXP_PAR_CHILD_SUPP_PD
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_EXP_PAR_ED_LN_RPAY_AMT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_EXP_PAR_MED_DEN_EXPN
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OWN_BUS_FARM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OTH_RE_YR_PURCH
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OTH_RE_PURCH_AMT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_PRYR_AGI
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_PRYR_US_TAX_PD
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_PRYR_ITEM_DEDUCTNS
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_PRYR_UNTAX_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_ITEM_DEDUCTNS
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_COLL_CDE_9
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRIMP1_HOUS_CDE_9
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_COLL_CDE_10
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRIMP1_HOUS_CDE_10
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_ADDL_COLL_CDE_9
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRIMP1_ADDL_COLL_CDE_10
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRIMP1_SIGNED_CERTIFIED
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_ALT_HME_DBT
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_ALT_AAI_RATE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_ALT_IRA_KEOGH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_ALT_AI_RATE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_S_ALT_OPT_HME_VAL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_ALT_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_ALT_HME_DBT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_ALT_SUM_AY_INC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_C_2_CTRB_ADJ_1_8_MTH
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_C_2_CTRB_ADJ_OVR_9_MTH
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_6
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_7
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_8
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_9
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_10
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_20
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_25
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_34
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_35
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_36
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_37
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_38
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_45
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_55
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_56
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_57
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_58
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_59
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_60
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_73
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_FAM_MEMB
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_NUM_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_AVAIL_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_US_TAX
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_CALC_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_MULT_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_MULT_HME_EQTY
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_XPCT_HME_VAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_XPCT_HME_EQTY
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_CAP_HME_EQTY
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_FAM_MEMB
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_NUM_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_AGI_DIFF
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_US_TAX
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_CALC_HME_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_MULT_HME_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_MULT_HME_EQTY
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_XPCT_HME_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_XPCT_HME_EQTY
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_PAR_CAP_HME_EQTY
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_1
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_2
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_3
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_4
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_5
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_6
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_7
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_8
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_9
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ASSUMPT_PROF_MSG_10
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_BUS_DEPRECIATION
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_BUS_DEPRECIATION
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_BUS_IN_HOME_MISC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_BUS_IN_HOME_MISC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_RENT_DEPRECIATION
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_RENT_DEPRECIATION
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_OTH_ADDBACK_1
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OTH_ADDBACK_1
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_OTH_ADDBACK_2
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OTH_ADDBACK_2
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_CUST_NONCUST_PARENT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PC_NON_CUST_PAR
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_LINE2_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRIMP1_LINE3_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRIMP1_LINE4_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRIMP1_LINE5_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRIMP1_LINE6_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRIMP1_LINE7_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRIMP1_LINE8_AGE
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLRIMP1_LINE2_SCHL_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_LINE3_SCHL_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_LINE4_SCHL_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_LINE5_SCHL_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_LINE6_SCHL_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_LINE7_SCHL_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_LINE8_SCHL_TYPE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_FOREIGN_ADDR_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_FOREIGN_POSTAL_CDE
|
 
|
VARCHAR2(9)
|
Yes
|
 
|
 
|
RLRIMP1_COUNTRY
|
 
|
VARCHAR2(25)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_SIBLING_ASSETS
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_HOPE_LL_CREDIT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_HOPE_LL_CREDIT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_YR_SEP
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_YR_DIV
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLRIMP1_ONLINE_SIG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_HOPE_LL_CREDIT_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_HOPE_LL_CREDIT_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_AESA
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_AESA
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_CESA
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_CESA
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_13
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_27
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_51
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_64
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_ANNUAL_ED_SAVINGS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_ANNUAL_ED_SAVINGS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_CUM_ED_SAVINGS
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_CUM_ED_SAVINGS
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_LOW_INC_ALLOW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_LOW_INC_ALLOW
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRIMP1_EMERG_RES_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_EMERG_RES_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_SIB_PRE_TUIT
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_STU_PRE_TUIT
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_39
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_52
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_65
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OPT_TOT_INC
|
 
|
NUMBER(8,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OPT_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OPT_CTRB_FR_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OPT_CTRB_FR_ASSET
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_S_EST_TOT_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_S_EST_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_S_EST_CTRB_FR_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_S_EST_CTRB_FR_ASSET
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_S_OPT_TOT_INC
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_S_OPT_CTRB_FOR_STDT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_S_OPT_CTRB_FR_INC
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRIMP1_S_OPT_CTRB_FR_ASSET
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_FM_INST_1_PELL_AWD
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_COLA_ALT_ADJ_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_STU_FAM_ASSETS_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_IPT_ASSETS_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_IPT_ASSETS_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_COLA_ADJ_VALUE_OPT
|
 
|
VARCHAR2(5)
|
Yes
|
 
|
 
|
RLRIMP1_IND_STU_IPT_ASSETS_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_STU_LIVES_WITH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_STU_MOST_SUPPORT_FROM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_LOCATION_COMPUTER
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_CUST_PAR_CTRB_ADJ_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_CUST_PAR_OPT_PCT_INC
|
 
|
NUMBER(3,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OPT_CTRB_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OPT_CTRB_ASSETS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_OPT_TOT_CTRB
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLRIMP1_OWN_BUS_HM_SELF_EMP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_SMALL_BUSINESS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_FATH_RET_ACCT_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_MOTH_RET_ACCT_VAL
|
 
|
NUMBER(7,0)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_SELF_EMPLOYED
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_PAR_SMALL_BUSINESS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRIMP1_MSG_53
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
RLRLDS4_LOG_NO
|
 
|
NUMBER(8,0)
|
No
|
*
|
 
|
RLRLDS4_ID_NO
|
 
|
NUMBER(1,0)
|
No
|
*
|
 
|
RLRLDS4_AIDY_CODE
|
 
|
VARCHAR2(4)
|
No
|
 
|
 
|
RLRLDS4_PIDM
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLRLDS4_INFC_CODE
|
 
|
VARCHAR2(7)
|
No
|
 
|
 
|
RLRLDS4_SEQ_NO
|
 
|
NUMBER(3,0)
|
No
|
 
|
 
|
RLRLDS4_CURR_REC_IND
|
 
|
VARCHAR2(1)
|
No
|
 
|
 
|
RLRLDS4_CREATOR_ID
|
 
|
VARCHAR2(30)
|
No
|
 
|
 
|
RLRLDS4_USER_ID
|
 
|
VARCHAR2(30)
|
No
|
 
|
 
|
RLRLDS4_CREATE_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RLRLDS4_ACTIVITY_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RLRLDS4_NSLDS_DB_RESULT_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_SUB_OUT_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_UNSUB_OUT_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_SUB_OUT_PRIN_BAL_2
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_CUMULATIVE_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_CURRENT_YR_AMT
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_1ST_DISB_FLAG_1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_1ST_DISB_FLAG_2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_EXP_LOAN_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_PELL_OVER_PAY_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_SEOG_OVER_PAY_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_DEFAULT_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_ACT_BANKRUPT_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_PROC_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRLDS4_MATCH_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_SUB_PEND_DISB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_UNSUB_PEND_DISB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_CONSOL_PEND_DISB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_SUB_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_UNSUB_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_CONSOL_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_TRAN_NO
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRLDS4_PELL_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RLRLDS4_SEOG_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_OVER_PAY_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_DEFAULTED_LOAN_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_DISCHARG_LOAN_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_LOAN_SAT_REPAY_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_DEF_LOAN_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_DISCHARG_LOAN_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_LOAN_SAT_REPAY_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_ACT_BANKRUPT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_OVER_PAY_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_PERK_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_PELL_PMT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_ADDL_PELL_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_ADDL_LOANS_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_COMB_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_COMB_PEND_DISB
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_COMB_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_POST_SCREEN_RSN_CDE
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRLDS4_DL_MPN_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_FFEL_MPN_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_FFEL_LEND_CODE
|
 
|
VARCHAR2(6)
|
Yes
|
 
|
 
|
RLRLDS4_LOAN_CHG_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_CURRENT_SSN
|
 
|
VARCHAR2(9)
|
Yes
|
 
|
 
|
RLRLDS4_CURRENT_FIRST_NAME
|
 
|
VARCHAR2(12)
|
Yes
|
 
|
 
|
RLRLDS4_CURRENT_LAST_NAME
|
 
|
VARCHAR2(35)
|
Yes
|
 
|
 
|
RLRLDS4_CURRENT_BIRTH_DATE
|
 
|
DATE
|
Yes
|
 
|
 
|
RLRLDS4_DL_PLUS_MPN_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_POST_SCREEN_RSN_CDE_2
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRLDS4_POST_SCREEN_RSN_CDE_3
|
 
|
VARCHAR2(2)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_OVER_LIMIT_SUB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_OVER_LIMIT_COMB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_FFEL_CONS_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_PLUS_OUT_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_FFEL_CONS_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_PLUS_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_ACG_PMT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_SMART_PMT_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_ADDL_ACG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_ADDL_SMART_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_DL_GR_PLUS_MPN_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_ACG_OVER_PAY_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_ACG_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RLRLDS4_SMART_OVER_PAY_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_SMART_OVER_PAY_CONTACT
|
 
|
VARCHAR2(8)
|
Yes
|
 
|
 
|
RLRLDS4_FRAUD_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_GR_PLUS_PRIN_BAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_AGT_GR_PLUS_TOTAL
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLRLDS4_FRAUD_CHG_FLG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_GR_AGT_OVER_LIMIT_SUB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLRLDS4_GR_AGT_OVER_LIMIT_COMB
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
RLROVRD_LOG_NO
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLROVRD_ID_NO
|
 
|
NUMBER(1,0)
|
No
|
 
|
 
|
RLROVRD_AIDY_CODE
|
 
|
VARCHAR2(4)
|
No
|
 
|
 
|
RLROVRD_PIDM
|
 
|
NUMBER(8,0)
|
No
|
 
|
 
|
RLROVRD_ACTIVITY_DATE
|
 
|
DATE
|
No
|
 
|
 
|
RLROVRD_FORMULA_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_FORMULA_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PELL_FORMULA_IND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_USE_PROJ_INC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_USE_PROJ_INC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_MIN_EARNINGS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_COST_LIV_INDEX
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_EMP_ALLOW
|
 
|
NUMBER(4,0)
|
Yes
|
 
|
 
|
RLROVRD_CHG_DEPEND
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PC_NON_CUST_PAR
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_INV_PROJ
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_BUDG_DUR
|
 
|
NUMBER(3,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_ACT_ST_LOC_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_ACT_ST_LOC_TAX
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_ACT_FICA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_ACT_FICA
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_ZERO_LOSS_RECALC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_HOME_VAL_PROJ
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_TABLE_ID
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO1
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE1
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND1
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO2
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE2
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND2
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO3
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE3
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND3
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND3
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND3
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO4
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE4
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND4
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND4
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND4
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO5
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE5
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND5
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND5
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND5
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO6
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE6
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND6
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND6
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND6
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO7
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE7
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND7
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND7
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND7
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO8
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE8
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND8
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND8
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND8
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FIELD_NO9
|
 
|
VARCHAR2(4)
|
Yes
|
 
|
 
|
RLROVRD_VALUE9
|
 
|
VARCHAR2(7)
|
Yes
|
 
|
 
|
RLROVRD_C_METH_IND9
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_I_METH_IND9
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_METH_IND9
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ADJUST_SC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_INCL_P_TUIT_EXP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_INCL_P_MED_EXP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_INCL_S_MED_EXP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_S_INV_PROJ
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_CALC_PC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ALLOW_NEG_INC_SUPP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_AGI_ASM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_ASSET_ASM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_S_ASSET_ASM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_OTH_INC_ASM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_NUM_IN_COLL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_INCL_P_INC_EXCL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_INCL_S_INC_EXCL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_REMOVE_EST_FLAG
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_INCL_S_TUIT_EXP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_BUDG_DUR_FM
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLROVRD_CHG_DEPEND_FM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_CALC_US_TAX_FM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_CALC_US_TAX_FM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_TUIT_EXP_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_TUIT_EXP_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_MED_DENT_EXP_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_MED_DENT_EXP_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_OTH_INC_ALLOW_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_OTH_INC_ALLOW_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_OTH_ASSET_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_OTH_ASSET_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_ASSET_ALLOW_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_ASSET_ALLOW_FM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_CHG_DEPEND_IM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_BUDG_DUR_IM
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLROVRD_CALC_PC_IM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_TUIT_EXP_IM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_TUIT_EXP_IM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_MED_DENT_EXP_IM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_MED_DENT_EXP_IM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_STU_EMP_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_EMP_ALLOW
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_OTH_INC_ALLOW_IM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_OTH_INC_ALLOW_IM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_STU_COST_LIV_INDEX
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_PAR_COST_LIV_INDEX
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_IPA_AMT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_IPA_AMT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_US_TAX_AMT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_US_TAX_AMT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_CALC_US_TAX_IM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_CALC_US_TAX_IM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_EST_TAX_AMT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_EST_TAX_AMT
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_ST_LOC_TAX_RATE
|
 
|
NUMBER(2,2)
|
Yes
|
 
|
 
|
RLROVRD_PAR_ST_LOC_TAX_RATE
|
 
|
NUMBER(2,2)
|
Yes
|
 
|
 
|
RLROVRD_INC_ASSESS_RATE
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_ZERO_LOSS_BUS_FARM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ZERO_LOSS_OTH
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ZERO_LOSS_INC_ADJ
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_AAI_TBL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_AAI_TBL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_OTH_ASSET_IM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_OTH_ASSET_IM
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_ASSET_ALLOW_IM
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_ASSET_ALLOW_IM
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLROVRD_S_HOME_VAL_PROJ
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_HOME_VAL_CAP
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_PAR_HOME_VAL_CAP
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_IRA_KEOGH_PCT
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_S_ALLOW_NEG_INC_SUPP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_P_ALLOW_NEG_INC_SUPP
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ASSET_ASSESS_PCT
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_PAR_ASSET_ASSESS_PCT
|
 
|
NUMBER(3,2)
|
Yes
|
 
|
 
|
RLROVRD_ELIM_APA
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_ELIM_APA
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_STU_NUM_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_NUM_IN_COLL
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLROVRD_MIN_SC_FROM_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_MIN_PC_FROM_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_MIN_SC_FROM_ASSETS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_MIN_PC_FROM_ASSETS
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PRIOR_YR_SC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PRIOR_YR_PC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_SC_PCT_INCREASE
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLROVRD_PC_PCT_INCREASE
|
 
|
NUMBER(3,1)
|
Yes
|
 
|
 
|
RLROVRD_MAX_PC_OTH_IN_COLL
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_ALLOW_IM_SC_LOWR_FM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ALLOW_IM_PC_LOWR_FM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_CALC_PC_FM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_AGI
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_AGI
|
 
|
NUMBER(6,0)
|
Yes
|
 
|
 
|
RLROVRD_UNTAX_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_UNTAX_INC
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_USE_PROJ_INC_EFM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_USE_PROJ_INC_EFM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_NUM_IN_COLL_EFM
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_NUM_IN_COLL_EFM
|
 
|
NUMBER(1,0)
|
Yes
|
 
|
 
|
RLROVRD_NUM_IN_HSLD_EFM
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_NUM_IN_HSLD_EFM
|
 
|
NUMBER(2,0)
|
Yes
|
 
|
 
|
RLROVRD_NON_CUST_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_SKIP_AGE_EXCL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_NON_CUST_PC_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_LIMIT_PC_BY_BDGT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_STU_BUDGET
|
 
|
NUMBER(5,0)
|
Yes
|
 
|
 
|
RLROVRD_PAR_AGI_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ADD_BK_HOPE_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_ADD_BK_HOPE_OPT
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FM_PAR_NUM_COL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ALLOW_PAR_IN_COL
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_ALLOW_PAR_IN_COL_EFM
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_USE_P_ST_TAX_ALWNCE
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_FAMILY_ASSETS
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_REJ_A_INAS_OVRD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_REJ_C_INAS_OVRD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_SSN_NO_DOB_REJ_OVRD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_F_SSN_NO_DOB_REJ_OVRD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_M_SSN_NO_DOB_REJ_OVRD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_SSN_NO_NAME_REJ_OVRD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_F_SSN_NO_NAME_REJ_OVRD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_M_SSN_NO_NAME_REJ_OVRD
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
RLROVRD_CAP_EQT_FACTOR
|
 
|
NUMBER(2,1)
|
Yes
|
 
|
 
|
RLROVRD_PAR_CAP_EQT_FACTOR
|
 
|
NUMBER(2,1)
|
Yes
|
 
|
 
|
RLROVRD_MIN_SC_FROM_INC_CALC
|
 
|
VARCHAR2(1)
|
Yes
|
 
|
 
|
Object Name
|
Object Type
|
Parent Name
|
Link Type
|
ROVALOG
|
SQL View
|
S10B80.BANINST1
|
Use (select)
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE05
|
Rely On
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE05
|
Use (Insert)
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE06
|
Rely On
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE06
|
Use (Insert)
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE07
|
Rely On
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE07
|
Use (Insert)
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE08
|
Rely On
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE08
|
Use (Insert)
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE09
|
Rely On
|
P_INSERT_CREATE_DATE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE09
|
Use (Insert)
|
P_LOG_DATA
|
Oracle Package Procedure
|
S10B80.BANINST1.RP_APPLICANT_STATUS
|
Rely On
|
P_LOG_DATA
|
Oracle Package Procedure
|
S10B80.BANINST1.RP_APPLICANT_STATUS
|
Use (Insert)
|
P_UPDATEDLORIG
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI04
|
Rely On
|
P_UPDATEDLORIG
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI04
|
Use (update,select)Rely On
|
ROBALOG_ROW
|
Oracle Package Variable
|
S10B80.BANINST1.REKCI04
|
Rely On
|
ROBALOG_ROW
|
Oracle Package Variable
|
S10B80.BANINST1.REKCI05
|
Rely On
|
ROBALOG_ROW
|
Oracle Package Variable
|
S10B80.BANINST1.REKCI06
|
Rely On
|
ROBALOG_ROW
|
Oracle Package Variable
|
S10B80.BANINST1.REKCI07
|
Rely On
|
ROBALOG_ROW
|
Oracle Package Variable
|
S10B80.BANINST1.REKCI08
|
Rely On
|
ROBALOG_ROW
|
Oracle Package Variable
|
S10B80.BANINST1.REKCI09
|
Rely On
|
P_DISPLAY_ROBALOG
|
Oracle Package Procedure
|
S10B80.BANINST1.RPK_DEBS_DISPLAYS
|
Rely On
|
P_DISPLAY_ROBALOG
|
Oracle Package Procedure
|
S10B80.BANINST1.RPK_DEBS_DISPLAYS
|
Use (select)Rely On
|
P_RESCHED_FUND_TERM_DISBURSE
|
Oracle Package Procedure
|
S10B80.BANINST1.ROKMISC
|
Use (Insert)
|
P_RESCHED_TERM_DISBURSE
|
Oracle Package Procedure
|
S10B80.BANINST1.ROKMISC
|
Use (Insert)
|
P_SELECT_PERSON_INFO
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE05
|
Use (select)
|
P_SELECT_PERSON_INFO
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE06
|
Use (select)
|
P_SELECT_PERSON_INFO
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE07
|
Use (select)
|
P_SELECT_PERSON_INFO
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE08
|
Use (select)
|
P_SELECT_PERSON_INFO
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE09
|
Use (select)
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI05
|
Rely On
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI05
|
Use (update,select)Rely On
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI06
|
Rely On
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI06
|
Use (update,select)Rely On
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI07
|
Rely On
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI07
|
Use (update,select)Rely On
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI08
|
Rely On
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI08
|
Use (update,select)Rely On
|
P_UPDATE_DLPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI09
|
Use (update,select)
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI05
|
Rely On
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI05
|
Use (update,select)Rely On
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI06
|
Rely On
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI06
|
Use (update,select)Rely On
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI07
|
Rely On
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI07
|
Use (update,select)Rely On
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI08
|
Rely On
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI08
|
Use (update,select)Rely On
|
P_UPDATE_DLSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI09
|
Use (update,select)
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI05
|
Rely On
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI05
|
Use (update,select)Rely On
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI06
|
Rely On
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI06
|
Use (update,select)Rely On
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI07
|
Rely On
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI07
|
Use (update,select)Rely On
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI08
|
Rely On
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI08
|
Use (update,select)Rely On
|
P_UPDATE_DLUNSUB_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI09
|
Use (update,select)
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE05
|
Rely On
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE05
|
Use (update)
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE06
|
Rely On
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE06
|
Use (update)
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE07
|
Rely On
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE07
|
Use (update)
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE08
|
Rely On
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE08
|
Use (update)
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE09
|
Rely On
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCE09
|
Use (update)
|
P_UPDATE_DL_CHANGE
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCEXX
|
Rely On
|
P_UPDATE_GPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI06
|
Rely On
|
P_UPDATE_GPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI06
|
Use (update,select)Rely On
|
P_UPDATE_GPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI07
|
Rely On
|
P_UPDATE_GPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI07
|
Use (update,select)Rely On
|
P_UPDATE_GPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI08
|
Rely On
|
P_UPDATE_GPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI08
|
Use (update,select)Rely On
|
P_UPDATE_GPLUS_ORIGINATIONS
|
Oracle Package Procedure
|
S10B80.BANINST1.REKCI09
|
Use (update,select)
|
F_SELECT_DL_AWARDS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE06
|
Use (select)
|
F_SELECT_DL_AWARDS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE07
|
Use (select)
|
F_SELECT_DL_AWARDS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE08
|
Use (select)
|
F_SELECT_DL_AWARDS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE09
|
Use (select)
|
F_SELECT_DL_CHANGES
|
Oracle Package Function
|
S10B80.BANINST1.REKCE05
|
Use (select)
|
F_SELECT_DL_CHANGES
|
Oracle Package Function
|
S10B80.BANINST1.REKCE06
|
Use (select)
|
F_SELECT_DL_CHANGES
|
Oracle Package Function
|
S10B80.BANINST1.REKCE07
|
Use (select)
|
F_SELECT_DL_CHANGES
|
Oracle Package Function
|
S10B80.BANINST1.REKCE08
|
Use (select)
|
F_SELECT_DL_CHANGES
|
Oracle Package Function
|
S10B80.BANINST1.REKCE09
|
Use (select)
|
F_SELECT_STUDENTS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE05
|
Use (select)
|
F_SELECT_STUDENTS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE06
|
Use (select)
|
F_SELECT_STUDENTS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE07
|
Use (select)
|
F_SELECT_STUDENTS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE08
|
Use (select)
|
F_SELECT_STUDENTS
|
Oracle Package Function
|
S10B80.BANINST1.REKCE09
|
Use (select)
|
ROBALOG
|
Oracle Synonym
|
S10B80.PUBLIC
|
Rely On
|