Model History and Transcripts

Model Label : Banner Financial Aid History and Transcripts Module.
Path : BANNER DEV/Financial Aid/Finaid_ERD/HistoryTranscripts_ERD

List of Objects

Object Name	Object Type	Layer Name
RCRAPP2	TABLE	Default
RCRAPP4	TABLE	Default
RCRLDS1	TABLE	Default
RCRLDS4	TABLE	Default
RCRLDS5	TABLE	Default
RCRLDS6	TABLE	Default
RCRLDS7	TABLE	Default
RCRLDS8	TABLE	Default
RFRBASE	TABLE	Default
RHBDFLT	TABLE	Default
RHBTINF	TABLE	Default
RHBTRNS	TABLE	Default
RHRAWRD	TABLE	Default
RHRCOMM	TABLE	Default
RHRFUND	TABLE	Default
RHRLOAN	TABLE	Default
RHRPCMT	TABLE	Default
RHRPCOL	TABLE	Default
RHRRQST	TABLE	Default
RHRTCMT	TABLE	Default
RORMESG	TABLE	Default
RPBLPRD	TABLE	Default
RPRAWRD	TABLE	Default
RPRLAPP	TABLE	Default
RTVMESG	TABLE	Default

Comments

Model View

Table RCRAPP2

Schema Name FAISMGR
Label RCRAPP2
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:53:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RCRAPP2_AIDY_CODE	RCRAPP2_AIDY_CODE	VARCHAR2(4)	No	*	*
RCRAPP2_AIDY_CODE	RCRAPP2_AIDY_CODE	VARCHAR2(4)	No	*	*
RCRAPP2_PIDM	RCRAPP2_PIDM	NUMBER(8,0)	No	*	*
RCRAPP2_INFC_CODE	RCRAPP2_INFC_CODE	VARCHAR2(7)	No	*	*
RCRAPP2_INFC_CODE	RCRAPP2_INFC_CODE	VARCHAR2(7)	No	*	*
RCRAPP2_SEQ_NO	RCRAPP2_SEQ_NO	NUMBER(3,0)	No	*	*
RCRAPP2_MODEL_CDE	RCRAPP2_MODEL_CDE	VARCHAR2(1)	Yes
RCRAPP2_C_PAR_DATA_PRESENT	RCRAPP2_C_PAR_DATA_PRESENT	VARCHAR2(1)	Yes
RCRAPP2_C_DATA_PRESENT	RCRAPP2_C_DATA_PRESENT	VARCHAR2(1)	Yes
RCRAPP2_C_DEPEND_STATUS	RCRAPP2_C_DEPEND_STATUS	VARCHAR2(1)	Yes
RCRAPP2_C_AGE	RCRAPP2_C_AGE	NUMBER(2,0)	Yes
RCRAPP2_C_MRTL_STATUS	RCRAPP2_C_MRTL_STATUS	VARCHAR2(1)	Yes
RCRAPP2_C_FAM_MEMB	RCRAPP2_C_FAM_MEMB	NUMBER(2,0)	Yes
RCRAPP2_C_NO_IN_COLL	RCRAPP2_C_NO_IN_COLL	NUMBER(1,0)	Yes
RCRAPP2_C_PAR_MRTL_STATUS	RCRAPP2_C_PAR_MRTL_STATUS	VARCHAR2(1)	Yes
RCRAPP2_C_PAR_FAM_MEMB	RCRAPP2_C_PAR_FAM_MEMB	NUMBER(2,0)	Yes
RCRAPP2_C_PAR_NO_IN_COLL	RCRAPP2_C_PAR_NO_IN_COLL	NUMBER(1,0)	Yes
RCRAPP2_C_PAR_PAR_IN_COLL	RCRAPP2_C_PAR_PAR_IN_COLL	NUMBER(1,0)	Yes
RCRAPP2_C_PAR_OTH_IN_COLL	RCRAPP2_C_PAR_OTH_IN_COLL	NUMBER(1,0)	Yes
RCRAPP2_C_ASSUME_YR_IN_COLL	RCRAPP2_C_ASSUME_YR_IN_COLL	VARCHAR2(1)	Yes
RCRAPP2_C_PAR_1_ANLY_TYPE	RCRAPP2_C_PAR_1_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_C_PAR_1_AGI_TAX_INC	RCRAPP2_C_PAR_1_AGI_TAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_1_TOT_UNTAX_INC	RCRAPP2_C_PAR_1_TOT_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_1_TOT_INC	RCRAPP2_C_PAR_1_TOT_INC	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_1_US_INC_TAX	RCRAPP2_C_PAR_1_US_INC_TAX	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_1_ST_OTH_TAX	RCRAPP2_C_PAR_1_ST_OTH_TAX	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_FICA_TAX	RCRAPP2_C_PAR_1_FICA_TAX	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_1_MED_DEN_EXP	RCRAPP2_C_PAR_1_MED_DEN_EXP	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_1_SCH_TUIT	RCRAPP2_C_PAR_1_SCH_TUIT	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_1_EMP_ALLOW	RCRAPP2_C_PAR_1_EMP_ALLOW	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_MNT_ALLOW	RCRAPP2_C_PAR_1_MNT_ALLOW	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_TOT_ALLOW	RCRAPP2_C_PAR_1_TOT_ALLOW	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_AVAIL_DISC_INC	RCRAPP2_C_PAR_1_AVAIL_DISC_INC	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_CASH_AMT	RCRAPP2_C_PAR_1_CASH_AMT	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_1_HME_VAL	RCRAPP2_C_PAR_1_HME_VAL	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_1_RE_INV_VAL	RCRAPP2_C_PAR_1_RE_INV_VAL	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_ADJ_BF_NET_WTH	RCRAPP2_C_PAR_1_ADJ_BF_NET_WTH	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_NET_WTH	RCRAPP2_C_PAR_1_NET_WTH	NUMBER(9,0)	Yes
RCRAPP2_C_PAR_1_PROT_ALLOW	RCRAPP2_C_PAR_1_PROT_ALLOW	NUMBER(9,0)	Yes
RCRAPP2_C_PAR_1_DISC_NET_WTH	RCRAPP2_C_PAR_1_DISC_NET_WTH	NUMBER(9,0)	Yes
RCRAPP2_C_PAR_1_CONV_PCT	RCRAPP2_C_PAR_1_CONV_PCT	NUMBER(3,1)	Yes
RCRAPP2_C_PAR_1_INC_SUPPLEMENT	RCRAPP2_C_PAR_1_INC_SUPPLEMENT	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_1_ADJ_AVAIL_INC	RCRAPP2_C_PAR_1_ADJ_AVAIL_INC	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_1_TOT_CTRB	RCRAPP2_C_PAR_1_TOT_CTRB	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_NO_IN_COLL	RCRAPP2_C_PAR_1_NO_IN_COLL	NUMBER(1,0)	Yes
RCRAPP2_C_PAR_1_CTRB_FOR_STDT	RCRAPP2_C_PAR_1_CTRB_FOR_STDT	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_CTRB_OFFL_EST	RCRAPP2_C_PAR_1_CTRB_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_C_PAR_1_CTRB_FR_INC	RCRAPP2_C_PAR_1_CTRB_FR_INC	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_1_CTRB_FR_ASSET	RCRAPP2_C_PAR_1_CTRB_FR_ASSET	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_2_ANLY_TYPE	RCRAPP2_C_PAR_2_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_C_PAR_2_AGI_TAX_INC	RCRAPP2_C_PAR_2_AGI_TAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_2_TOT_UNTAX_INC	RCRAPP2_C_PAR_2_TOT_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_2_TOT_INC	RCRAPP2_C_PAR_2_TOT_INC	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_2_US_INC_TAX	RCRAPP2_C_PAR_2_US_INC_TAX	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_2_ST_OTH_TAX	RCRAPP2_C_PAR_2_ST_OTH_TAX	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_2_FICA_TAX	RCRAPP2_C_PAR_2_FICA_TAX	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_2_MED_DEN_EXP	RCRAPP2_C_PAR_2_MED_DEN_EXP	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_2_SCH_TUIT	RCRAPP2_C_PAR_2_SCH_TUIT	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_2_EMP_ALLOW	RCRAPP2_C_PAR_2_EMP_ALLOW	NUMBER(4,0)	Yes
RCRAPP2_C_PAR_2_MNT_ALLOW	RCRAPP2_C_PAR_2_MNT_ALLOW	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_2_TOT_ALLOW	RCRAPP2_C_PAR_2_TOT_ALLOW	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_2_AVAIL_DISC_INC	RCRAPP2_C_PAR_2_AVAIL_DISC_INC	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_2_CASH_AMT	RCRAPP2_C_PAR_2_CASH_AMT	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_2_HME_VAL	RCRAPP2_C_PAR_2_HME_VAL	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_2_RE_INV_VAL	RCRAPP2_C_PAR_2_RE_INV_VAL	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_2_ADJ_BF_NET_WTH	RCRAPP2_C_PAR_2_ADJ_BF_NET_WTH	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_2_NET_WTH	RCRAPP2_C_PAR_2_NET_WTH	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_2_PROT_ALLOW	RCRAPP2_C_PAR_2_PROT_ALLOW	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_2_DISC_NET_WTH	RCRAPP2_C_PAR_2_DISC_NET_WTH	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_2_CONV_PCT	RCRAPP2_C_PAR_2_CONV_PCT	NUMBER(3,1)	Yes
RCRAPP2_C_PAR_2_INC_SUPPLEMENT	RCRAPP2_C_PAR_2_INC_SUPPLEMENT	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_2_ADJ_AVAIL_INC	RCRAPP2_C_PAR_2_ADJ_AVAIL_INC	NUMBER(8,0)	Yes
RCRAPP2_C_PAR_2_TOT_CTRB	RCRAPP2_C_PAR_2_TOT_CTRB	NUMBER(6,0)	Yes
RCRAPP2_C_PAR_2_NO_IN_COLL	RCRAPP2_C_PAR_2_NO_IN_COLL	NUMBER(4,1)	Yes
RCRAPP2_C_PAR_2_CTRB_FOR_STDT	RCRAPP2_C_PAR_2_CTRB_FOR_STDT	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_2_CTRB_OFFL_EST	RCRAPP2_C_PAR_2_CTRB_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_C_PAR_2_CTRB_FR_INC	RCRAPP2_C_PAR_2_CTRB_FR_INC	NUMBER(5,0)	Yes
RCRAPP2_C_PAR_2_CTRB_FR_ASSET	RCRAPP2_C_PAR_2_CTRB_FR_ASSET	NUMBER(5,0)	Yes
RCRAPP2_C_1_ANLY_TYPE	RCRAPP2_C_1_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_C_1_AGI_TAX_INC	RCRAPP2_C_1_AGI_TAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_1_TOT_UNTAX_INC	RCRAPP2_C_1_TOT_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_1_TOT_INC	RCRAPP2_C_1_TOT_INC	NUMBER(7,0)	Yes
RCRAPP2_C_1_US_INC_TAX	RCRAPP2_C_1_US_INC_TAX	NUMBER(5,0)	Yes
RCRAPP2_C_1_ST_OTH_TAX	RCRAPP2_C_1_ST_OTH_TAX	NUMBER(7,0)	Yes
RCRAPP2_C_1_FICA_TAX	RCRAPP2_C_1_FICA_TAX	NUMBER(5,0)	Yes
RCRAPP2_C_1_MED_DEN_EXP	RCRAPP2_C_1_MED_DEN_EXP	NUMBER(5,0)	Yes
RCRAPP2_C_1_SCH_TUIT	RCRAPP2_C_1_SCH_TUIT	NUMBER(5,0)	Yes
RCRAPP2_C_1_EMP_ALLOW	RCRAPP2_C_1_EMP_ALLOW	NUMBER(7,0)	Yes
RCRAPP2_C_1_MNT_ALLOW	RCRAPP2_C_1_MNT_ALLOW	NUMBER(7,0)	Yes
RCRAPP2_C_1_AVAIL_TAX_INC	RCRAPP2_C_1_AVAIL_TAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_1_AVAIL_DISC_INC	RCRAPP2_C_1_AVAIL_DISC_INC	NUMBER(7,0)	Yes
RCRAPP2_C_1_CASH_AMT	RCRAPP2_C_1_CASH_AMT	NUMBER(6,0)	Yes
RCRAPP2_C_1_HME_VAL	RCRAPP2_C_1_HME_VAL	NUMBER(6,0)	Yes
RCRAPP2_C_1_RE_INV_VAL	RCRAPP2_C_1_RE_INV_VAL	NUMBER(6,0)	Yes
RCRAPP2_C_1_ADJ_BF_NET_WTH	RCRAPP2_C_1_ADJ_BF_NET_WTH	NUMBER(7,0)	Yes
RCRAPP2_C_1_NET_WTH	RCRAPP2_C_1_NET_WTH	NUMBER(9,0)	Yes
RCRAPP2_C_1_PROT_ALLOW	RCRAPP2_C_1_PROT_ALLOW	NUMBER(9,0)	Yes
RCRAPP2_C_1_DISC_NET_WTH	RCRAPP2_C_1_DISC_NET_WTH	NUMBER(9,0)	Yes
RCRAPP2_C_1_CONV_PCT	RCRAPP2_C_1_CONV_PCT	NUMBER(3,1)	Yes
RCRAPP2_C_1_INC_SUPPLEMENT	RCRAPP2_C_1_INC_SUPPLEMENT	NUMBER(8,0)	Yes
RCRAPP2_C_1_ADJ_AVAIL_INC	RCRAPP2_C_1_ADJ_AVAIL_INC	NUMBER(8,0)	Yes
RCRAPP2_C_1_TOT_CTRB	RCRAPP2_C_1_TOT_CTRB	NUMBER(7,0)	Yes
RCRAPP2_C_1_NO_IN_COLL	RCRAPP2_C_1_NO_IN_COLL	NUMBER(1,0)	Yes
RCRAPP2_C_1_CTRB_FOR_STDT	RCRAPP2_C_1_CTRB_FOR_STDT	NUMBER(5,0)	Yes
RCRAPP2_C_1_CTRB_OFFL_EST	RCRAPP2_C_1_CTRB_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_C_1_CTRB_FR_INC	RCRAPP2_C_1_CTRB_FR_INC	NUMBER(7,0)	Yes
RCRAPP2_C_1_CTRB_FR_ASSET	RCRAPP2_C_1_CTRB_FR_ASSET	NUMBER(7,0)	Yes
RCRAPP2_C_1_VA_BEN_INCL	RCRAPP2_C_1_VA_BEN_INCL	VARCHAR2(1)	Yes
RCRAPP2_C_1_TAX_INC_CTRB	RCRAPP2_C_1_TAX_INC_CTRB	NUMBER(5,0)	Yes
RCRAPP2_C_1_TOT_ALLOW	RCRAPP2_C_1_TOT_ALLOW	NUMBER(7,0)	Yes
RCRAPP2_C_1_CALC_AVAIL_INC	RCRAPP2_C_1_CALC_AVAIL_INC	NUMBER(7,0)	Yes
RCRAPP2_C_2_ANLY_TYPE	RCRAPP2_C_2_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_C_2_AGI_TAX_INC	RCRAPP2_C_2_AGI_TAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_2_TOT_UNTAX_INC	RCRAPP2_C_2_TOT_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_2_TOT_INC	RCRAPP2_C_2_TOT_INC	NUMBER(7,0)	Yes
RCRAPP2_C_2_US_INC_TAX	RCRAPP2_C_2_US_INC_TAX	NUMBER(5,0)	Yes
RCRAPP2_C_2_ST_OTH_TAX	RCRAPP2_C_2_ST_OTH_TAX	NUMBER(5,0)	Yes
RCRAPP2_C_2_FICA_TAX	RCRAPP2_C_2_FICA_TAX	NUMBER(5,0)	Yes
RCRAPP2_C_2_MED_DEN_EXP	RCRAPP2_C_2_MED_DEN_EXP	NUMBER(5,0)	Yes
RCRAPP2_C_2_SCH_TUIT	RCRAPP2_C_2_SCH_TUIT	NUMBER(5,0)	Yes
RCRAPP2_C_2_EMP_ALLOW	RCRAPP2_C_2_EMP_ALLOW	NUMBER(4,0)	Yes
RCRAPP2_C_2_MNT_ALLOW	RCRAPP2_C_2_MNT_ALLOW	NUMBER(5,0)	Yes
RCRAPP2_C_2_AVAIL_TAX_INC	RCRAPP2_C_2_AVAIL_TAX_INC	NUMBER(6,0)	Yes
RCRAPP2_C_2_AVAIL_DISC_INC	RCRAPP2_C_2_AVAIL_DISC_INC	NUMBER(7,0)	Yes
RCRAPP2_C_2_CASH_AMT	RCRAPP2_C_2_CASH_AMT	NUMBER(6,0)	Yes
RCRAPP2_C_2_HME_VAL	RCRAPP2_C_2_HME_VAL	NUMBER(6,0)	Yes
RCRAPP2_C_2_RE_INV_VAL	RCRAPP2_C_2_RE_INV_VAL	NUMBER(6,0)	Yes
RCRAPP2_C_2_ADJ_BF_NET_WTH	RCRAPP2_C_2_ADJ_BF_NET_WTH	NUMBER(7,0)	Yes
RCRAPP2_C_2_NET_WTH	RCRAPP2_C_2_NET_WTH	NUMBER(8,0)	Yes
RCRAPP2_C_2_PROT_ALLOW	RCRAPP2_C_2_PROT_ALLOW	NUMBER(5,0)	Yes
RCRAPP2_C_2_DISC_NET_WTH	RCRAPP2_C_2_DISC_NET_WTH	NUMBER(8,0)	Yes
RCRAPP2_C_2_CONV_PCT	RCRAPP2_C_2_CONV_PCT	NUMBER(3,1)	Yes
RCRAPP2_C_2_INC_SUPPLEMENT	RCRAPP2_C_2_INC_SUPPLEMENT	NUMBER(8,0)	Yes
RCRAPP2_C_2_ADJ_AVAIL_INC	RCRAPP2_C_2_ADJ_AVAIL_INC	NUMBER(8,0)	Yes
RCRAPP2_C_2_TOT_CTRB	RCRAPP2_C_2_TOT_CTRB	NUMBER(5,0)	Yes
RCRAPP2_C_2_NO_IN_COLL	RCRAPP2_C_2_NO_IN_COLL	NUMBER(4,1)	Yes
RCRAPP2_C_2_CTRB_FOR_STDT	RCRAPP2_C_2_CTRB_FOR_STDT	NUMBER(5,0)	Yes
RCRAPP2_C_2_CTRB_OFFL_EST	RCRAPP2_C_2_CTRB_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_C_2_CTRB_FR_INC	RCRAPP2_C_2_CTRB_FR_INC	NUMBER(6,0)	Yes
RCRAPP2_C_2_CTRB_FR_ASSET	RCRAPP2_C_2_CTRB_FR_ASSET	NUMBER(5,0)	Yes
RCRAPP2_C_2_VA_BEN_INCL	RCRAPP2_C_2_VA_BEN_INCL	VARCHAR2(1)	Yes
RCRAPP2_C_2_TAX_INC_CTRB	RCRAPP2_C_2_TAX_INC_CTRB	NUMBER(5,0)	Yes
RCRAPP2_C_2_TOT_ALLOW	RCRAPP2_C_2_TOT_ALLOW	NUMBER(6,0)	Yes
RCRAPP2_C_2_CALC_AVAIL_INC	RCRAPP2_C_2_CALC_AVAIL_INC	NUMBER(7,0)	Yes
RCRAPP2_C_1_TOT_FAM_CTRB	RCRAPP2_C_1_TOT_FAM_CTRB	NUMBER(6,0)	Yes
RCRAPP2_C_1_TFC_OFFL_EST	RCRAPP2_C_1_TFC_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_C_2_TOT_FAM_CTRB	RCRAPP2_C_2_TOT_FAM_CTRB	NUMBER(6,0)	Yes
RCRAPP2_C_2_TFC_OFFL_EST	RCRAPP2_C_2_TFC_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_PELL_P_ANLY_TYPE	RCRAPP2_PELL_P_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_PELL_P_AGI_TAX_INC	RCRAPP2_PELL_P_AGI_TAX_INC	NUMBER(6,0)	Yes
RCRAPP2_PELL_P_TOT_UNTAX_INC	RCRAPP2_PELL_P_TOT_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP2_PELL_P_TOT_INC	RCRAPP2_PELL_P_TOT_INC	NUMBER(7,0)	Yes
RCRAPP2_PELL_P_US_INC_TAX	RCRAPP2_PELL_P_US_INC_TAX	NUMBER(6,0)	Yes
RCRAPP2_PELL_P_ST_OTH_TAX	RCRAPP2_PELL_P_ST_OTH_TAX	NUMBER(5,0)	Yes
RCRAPP2_PELL_P_MED_DEN_EXP	RCRAPP2_PELL_P_MED_DEN_EXP	NUMBER(5,0)	Yes
RCRAPP2_PELL_P_SCH_TUIT	RCRAPP2_PELL_P_SCH_TUIT	NUMBER(5,0)	Yes
RCRAPP2_PELL_P_EMP_ALLOW	RCRAPP2_PELL_P_EMP_ALLOW	NUMBER(4,0)	Yes
RCRAPP2_PELL_P_MNT_ALLOW	RCRAPP2_PELL_P_MNT_ALLOW	NUMBER(5,0)	Yes
RCRAPP2_PELL_P_TOT_ALLOW	RCRAPP2_PELL_P_TOT_ALLOW	NUMBER(6,0)	Yes
RCRAPP2_PELL_P_AVAIL_DISC_INC	RCRAPP2_PELL_P_AVAIL_DISC_INC	NUMBER(6,0)	Yes
RCRAPP2_PELL_P_CASH_AMT	RCRAPP2_PELL_P_CASH_AMT	NUMBER(6,0)	Yes
RCRAPP2_PELL_P_HME_VAL	RCRAPP2_PELL_P_HME_VAL	NUMBER(6,0)	Yes
RCRAPP2_PELL_P_RE_INV_VAL	RCRAPP2_PELL_P_RE_INV_VAL	NUMBER(7,0)	Yes
RCRAPP2_PELL_P_ADJ_BF_NET_WTH	RCRAPP2_PELL_P_ADJ_BF_NET_WTH	NUMBER(7,0)	Yes
RCRAPP2_PELL_P_NET_WTH	RCRAPP2_PELL_P_NET_WTH	NUMBER(8,0)	Yes
RCRAPP2_PELL_P_PROT_ALLOW	RCRAPP2_PELL_P_PROT_ALLOW	NUMBER(6,0)	Yes
RCRAPP2_PELL_P_DISC_NET_WTH	RCRAPP2_PELL_P_DISC_NET_WTH	NUMBER(8,0)	Yes
RCRAPP2_PELL_P_CONV_PCT	RCRAPP2_PELL_P_CONV_PCT	NUMBER(3,1)	Yes
RCRAPP2_PELL_P_TOT_CTRB	RCRAPP2_PELL_P_TOT_CTRB	NUMBER(5,0)	Yes
RCRAPP2_PELL_P_NO_IN_COLL	RCRAPP2_PELL_P_NO_IN_COLL	NUMBER(1,0)	Yes
RCRAPP2_PELL_P_CTRB_FOR_STDT	RCRAPP2_PELL_P_CTRB_FOR_STDT	NUMBER(5,0)	Yes
RCRAPP2_PELL_P_CTRB_OFFL_EST	RCRAPP2_PELL_P_CTRB_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_PELL_P_CTRB_FR_INC	RCRAPP2_PELL_P_CTRB_FR_INC	NUMBER(5,0)	Yes
RCRAPP2_PELL_P_CTRB_FR_ASSET	RCRAPP2_PELL_P_CTRB_FR_ASSET	NUMBER(5,0)	Yes
RCRAPP2_PELL_P_2_ANLY_TYPE	RCRAPP2_PELL_P_2_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_PELL_ANLY_TYPE	RCRAPP2_PELL_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_PELL_AGI_TAX_INC	RCRAPP2_PELL_AGI_TAX_INC	NUMBER(6,0)	Yes
RCRAPP2_PELL_TOT_UNTAX_INC	RCRAPP2_PELL_TOT_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP2_PELL_TOT_INC	RCRAPP2_PELL_TOT_INC	NUMBER(7,0)	Yes
RCRAPP2_PELL_US_INC_TAX	RCRAPP2_PELL_US_INC_TAX	NUMBER(5,0)	Yes
RCRAPP2_PELL_ST_OTH_TAX	RCRAPP2_PELL_ST_OTH_TAX	NUMBER(5,0)	Yes
RCRAPP2_PELL_MED_DEN_EXP	RCRAPP2_PELL_MED_DEN_EXP	NUMBER(5,0)	Yes
RCRAPP2_PELL_SCH_TUIT	RCRAPP2_PELL_SCH_TUIT	NUMBER(5,0)	Yes
RCRAPP2_PELL_EMP_ALLOW	RCRAPP2_PELL_EMP_ALLOW	NUMBER(4,0)	Yes
RCRAPP2_PELL_MNT_ALLOW	RCRAPP2_PELL_MNT_ALLOW	NUMBER(5,0)	Yes
RCRAPP2_PELL_TOT_ALLOW	RCRAPP2_PELL_TOT_ALLOW	NUMBER(6,0)	Yes
RCRAPP2_PELL_AVAIL_DISC_INC	RCRAPP2_PELL_AVAIL_DISC_INC	NUMBER(6,0)	Yes
RCRAPP2_PELL_CASH_AMT	RCRAPP2_PELL_CASH_AMT	NUMBER(6,0)	Yes
RCRAPP2_PELL_HME_VAL	RCRAPP2_PELL_HME_VAL	NUMBER(6,0)	Yes
RCRAPP2_PELL_RE_INV_VAL	RCRAPP2_PELL_RE_INV_VAL	NUMBER(6,0)	Yes
RCRAPP2_PELL_ADJ_BF_NET_WTH	RCRAPP2_PELL_ADJ_BF_NET_WTH	NUMBER(7,0)	Yes
RCRAPP2_PELL_NET_WTH	RCRAPP2_PELL_NET_WTH	NUMBER(8,0)	Yes
RCRAPP2_PELL_PROT_ALLOW	RCRAPP2_PELL_PROT_ALLOW	NUMBER(6,0)	Yes
RCRAPP2_PELL_DISC_NET_WTH	RCRAPP2_PELL_DISC_NET_WTH	NUMBER(8,0)	Yes
RCRAPP2_PELL_CONV_PCT	RCRAPP2_PELL_CONV_PCT	NUMBER(3,1)	Yes
RCRAPP2_PELL_TOT_CTRB	RCRAPP2_PELL_TOT_CTRB	NUMBER(5,0)	Yes
RCRAPP2_PELL_NO_IN_COLL	RCRAPP2_PELL_NO_IN_COLL	NUMBER(1,0)	Yes
RCRAPP2_PELL_CTRB_FOR_STDT	RCRAPP2_PELL_CTRB_FOR_STDT	NUMBER(5,0)	Yes
RCRAPP2_PELL_CTRB_OFFL_EST	RCRAPP2_PELL_CTRB_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_PELL_CTRB_FR_INC	RCRAPP2_PELL_CTRB_FR_INC	NUMBER(5,0)	Yes
RCRAPP2_PELL_CTRB_FR_ASSET	RCRAPP2_PELL_CTRB_FR_ASSET	NUMBER(5,0)	Yes
RCRAPP2_PELL_PGI	RCRAPP2_PELL_PGI	NUMBER(5,0)	Yes
RCRAPP2_PELL_PGI_OFFL_EST	RCRAPP2_PELL_PGI_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_PELL_2_ANLY_TYPE	RCRAPP2_PELL_2_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_PELL_2_PGI	RCRAPP2_PELL_2_PGI	NUMBER(5,0)	Yes
RCRAPP2_PELL_2_PGI_OFFL_EST	RCRAPP2_PELL_2_PGI_OFFL_EST	VARCHAR2(1)	Yes
RCRAPP2_IM_BUDG_LENGTH	RCRAPP2_IM_BUDG_LENGTH	NUMBER(2,0)	Yes
RCRAPP2_IM_1_ANLY_TYPE	RCRAPP2_IM_1_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_IM_1_SC	RCRAPP2_IM_1_SC	NUMBER(5,0)	Yes
RCRAPP2_IM_1_PAR_ANLY_TYPE	RCRAPP2_IM_1_PAR_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_IM_1_PC	RCRAPP2_IM_1_PC	NUMBER(5,0)	Yes
RCRAPP2_IM_1_UNASSESSED_VA	RCRAPP2_IM_1_UNASSESSED_VA	NUMBER(5,0)	Yes
RCRAPP2_IM_1_TFC	RCRAPP2_IM_1_TFC	NUMBER(6,0)	Yes
RCRAPP2_IM_2_ANLY_TYPE	RCRAPP2_IM_2_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_IM_2_SC	RCRAPP2_IM_2_SC	NUMBER(5,0)	Yes
RCRAPP2_IM_2_PAR_ANLY_TYPE	RCRAPP2_IM_2_PAR_ANLY_TYPE	VARCHAR2(1)	Yes
RCRAPP2_IM_2_PC	RCRAPP2_IM_2_PC	NUMBER(5,0)	Yes
RCRAPP2_IM_2_UNASSESSED_VA	RCRAPP2_IM_2_UNASSESSED_VA	NUMBER(5,0)	Yes
RCRAPP2_INAS_CTR	RCRAPP2_INAS_CTR	NUMBER(2,0)	Yes
RCRAPP2_RQST_SLS_AMT	RCRAPP2_RQST_SLS_AMT	NUMBER(4,0)	Yes
RCRAPP2_DEFER_SLS_PMTS	RCRAPP2_DEFER_SLS_PMTS	VARCHAR2(1)	Yes
RCRAPP2_SLS_INTS_PMTS	RCRAPP2_SLS_INTS_PMTS	VARCHAR2(1)	Yes
RCRAPP2_BAL_ON_ALL_SLS	RCRAPP2_BAL_ON_ALL_SLS	NUMBER(5,0)	Yes
RCRAPP2_RECENT_SLS_BAL	RCRAPP2_RECENT_SLS_BAL	NUMBER(5,0)	Yes
RCRAPP2_RECENT_SLS_FR_MTH_YR	RCRAPP2_RECENT_SLS_FR_MTH_YR	VARCHAR2(4)	Yes
RCRAPP2_RECENT_SLS_CLASS	RCRAPP2_RECENT_SLS_CLASS	VARCHAR2(2)	Yes
RCRAPP2_LENDER_CODE	RCRAPP2_LENDER_CODE	VARCHAR2(6)	Yes
RCRAPP2_DEGREE_SOUGHT	RCRAPP2_DEGREE_SOUGHT	VARCHAR2(1)	Yes
RCRAPP2_DRUG_ABUSE	RCRAPP2_DRUG_ABUSE	VARCHAR2(1)	Yes
RCRAPP2_ELIGIBILITY_MSG	RCRAPP2_ELIGIBILITY_MSG	VARCHAR2(1)	Yes
RCRAPP2_EPS_CDE	RCRAPP2_EPS_CDE	VARCHAR2(4)	Yes
RCRAPP2_HS_GRADUATE	RCRAPP2_HS_GRADUATE	VARCHAR2(1)	Yes
RCRAPP2_ORIG_RCPT_DATE	RCRAPP2_ORIG_RCPT_DATE	DATE	Yes
RCRAPP2_DUR_ELIG_OVRD_IND	RCRAPP2_DUR_ELIG_OVRD_IND	VARCHAR2(1)	Yes
RCRAPP2_C_1_UNADJ_BUS_NET	RCRAPP2_C_1_UNADJ_BUS_NET	NUMBER(7,0)	Yes
RCRAPP2_C_1_UNADJ_FARM_NET	RCRAPP2_C_1_UNADJ_FARM_NET	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_UNADJ_BUS_NET	RCRAPP2_C_PAR_1_UNADJ_BUS_NET	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_1_UNADJ_FARM_NET	RCRAPP2_C_PAR_1_UNADJ_FARM_NET	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_2_CALC_AVAIL_INC	RCRAPP2_C_PAR_2_CALC_AVAIL_INC	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_2_UNADJ_BUS_NET	RCRAPP2_C_PAR_2_UNADJ_BUS_NET	NUMBER(7,0)	Yes
RCRAPP2_C_PAR_2_UNADJ_FARM_NET	RCRAPP2_C_PAR_2_UNADJ_FARM_NET	NUMBER(7,0)	Yes
RCRAPP2_FM_INST_1_FED_EFC	RCRAPP2_FM_INST_1_FED_EFC	NUMBER(5,0)	Yes
RCRAPP2_FM_INST_1_FED_ELIG	RCRAPP2_FM_INST_1_FED_ELIG	NUMBER(5,0)	Yes
RCRAPP2_FM_INST_1_VA_BEN	RCRAPP2_FM_INST_1_VA_BEN	NUMBER(5,0)	Yes
RCRAPP2_FM_INST_2_FED_EFC	RCRAPP2_FM_INST_2_FED_EFC	NUMBER(5,0)	Yes
RCRAPP2_FM_INST_2_FED_ELIG	RCRAPP2_FM_INST_2_FED_ELIG	NUMBER(5,0)	Yes
RCRAPP2_FM_INST_2_VA_BEN	RCRAPP2_FM_INST_2_VA_BEN	NUMBER(5,0)	Yes
RCRAPP2_FM_INST_3_FED_EFC	RCRAPP2_FM_INST_3_FED_EFC	NUMBER(5,0)	Yes
RCRAPP2_FM_INST_3_FED_ELIG	RCRAPP2_FM_INST_3_FED_ELIG	NUMBER(5,0)	Yes
RCRAPP2_FM_INST_3_VA_BEN	RCRAPP2_FM_INST_3_VA_BEN	NUMBER(5,0)	Yes
RCRAPP2_CM2_IM_CALC_IND	RCRAPP2_CM2_IM_CALC_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RCRAPP2_AIDY_CODE	RCRAPP1_AIDY_CODE	RCRAPP1
RCRAPP2_PIDM	RCRAPP1_PIDM	RCRAPP1
RCRAPP2_INFC_CODE	RCRAPP1_INFC_CODE	RCRAPP1
RCRAPP2_SEQ_NO	RCRAPP1_SEQ_NO	RCRAPP1
RCRAPP2_INFC_CODE	RTVINFC_CODE	RTVINFC
RCRAPP2_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
PK_RCRAPP2	Unique	RCRAPP2_AIDY_CODE
PK_RCRAPP2	Unique	RCRAPP2_PIDM
PK_RCRAPP2	Unique	RCRAPP2_INFC_CODE
PK_RCRAPP2	Unique	RCRAPP2_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
reris00.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
reris01.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
reris02.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
reris03.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
rorfs00.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
rorfs01.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
rorfs02.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
rorfs98.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
rorfs99.pc	C/C++ File	[E:\BANNER\C\FINAID\C\]	Use(select )
main	C/C++ Function	[E:\BANNER\C\FINAID\C\RLRLOGG.PC]	Use()
del_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP98.PC]	Use(delete )
del_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP99.PC]	Use(delete )
del_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP01.PC]	Use(delete )
del_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP02.PC]	Use(delete )
del_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP04.PC]	Use(delete )
del_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP00.PC]	Use(delete )
del_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP03.PC]	Use(delete )
get_rcrappx	C/C++ Function	[E:\BANNER\C\FINAID\C\RPRLORC.PC]	Use(select )
get_rcrappx	C/C++ Function	[E:\BANNER\C\FINAID\C\RPRELAP.PC]	Use(select )
get_system_agi_amt	C/C++ Function	[E:\BANNER\C\FINAID\C\RPRELAP.PC]	Use(select )
get_system_budget	C/C++ Function	[E:\BANNER\C\FINAID\C\RPRELAP.PC]	Use(select )
ins_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP98.PC]	Use(insert,select )
ins_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP03.PC]	Use(insert,select )
ins_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP04.PC]	Use(insert,select )
ins_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP99.PC]	Use(insert,select )
ins_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP00.PC]	Use(insert,select )
ins_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP01.PC]	Use(insert,select )
ins_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP02.PC]	Use(insert,select )
ins_rcrapp2_isir	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP03.PC]	Use(insert,select )
ins_rcrapp2_isir	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP00.PC]	Use(insert,select )
ins_rcrapp2_isir	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP01.PC]	Use(insert,select )
ins_rcrapp2_isir	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP02.PC]	Use(insert,select )
ins_rcrapp2_isir	C/C++ Function	[E:\BANNER\C\FINAID\C\RCRTP04.PC]	Use(insert,select )
lock_rcrapp2	C/C++ Function	[E:\BANNER\C\FINAID\C\RORBPST.PC]	Use()
rlrapp2_hdr	C/C++ Function	[E:\BANNER\C\FINAID\C\RLRLOGG.PC]	Use()
sel_any_title_iv	C/C++ Function	[E:\BANNER\C\FINAID\C\RHRTRAN.PC]	Use(select )
sel_any_title_iv	C/C++ Function	[E:\BANNER\C\INFOACC\C\IRRKTRN.PC]	Use(select )
sel_current_title_iv	C/C++ Function	[E:\BANNER\C\INFOACC\C\IRRKTRN.PC]	Use(select )
sel_efc_dep	C/C++ Function	[E:\BANNER\C\FINAID\C\RORFS98.PC]	Use(select )
sel_efc_dep	C/C++ Function	[E:\BANNER\C\FINAID\C\RORFS02.PC]	Use(select )
sel_efc_dep	C/C++ Function	[E:\BANNER\C\FINAID\C\RORFS01.PC]