Model History and Transcripts

Model Label : Banner Financial Aid History and Transcripts Module
Path : Default Folder/B70/finaid/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 S4B70
Creation Date 10/05/2004 13:30:27:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
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_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
RCRAPP2_C_PAR_AGE	RCRAPP2_C_PAR_AGE	NUMBER(2,0)	Yes
RCRAPP2_USER_ID	RCRAPP2_USER_ID	VARCHAR2(30)	Yes
RCRAPP2_ACTIVITY_DATE	RCRAPP2_ACTIVITY_DATE	DATE	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
RCRAPP2_PIDM	RORSTAT_PIDM	RORSTAT

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

Comments

Source Code Comments

Financial Aid Application Table - Part 2

Columns Comments for RCRAPP2_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RCRAPP2_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RCRAPP2_INFC_CODE (3)

Source Code Comments

INTERFACE TAPE CODE: A code from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, ACT, ACT-CSS

Columns Comments for RCRAPP2_SEQ_NO (4)

Source Code Comments

SEQUENCE NUMBER: The number to uniquely identify the application if multiple applications have been stored from the same processor/source.

Columns Comments for RCRAPP2_MODEL_CDE (5)

Source Code Comments

MODEL CODE: Indicates if the student is (I)ndependent or (D)ependent.

Columns Comments for RCRAPP2_C_PAR_DATA_PRESENT (6)

Source Code Comments

PARENTS' DATA PRESENT INDICATOR: Indicates if minimal data is present to calculate a Parents' Contribution for simple, displaced homemaker, or regular analysis (1) or not (2).

Columns Comments for RCRAPP2_C_DATA_PRESENT (7)

Source Code Comments

DATA PRESENT INDICATOR: Indicates if minimal data is present to calculate an independent student contribution for simple, displaced homemaker, or regular analysis (1) or not (2).

Columns Comments for RCRAPP2_C_DEPEND_STATUS (8)

Source Code Comments

COMPUTED DEPENDENCY STATUS: Indicates the students dependency status as computed by INAS or loaded from the tape record. Uses a code from 1-8.

Columns Comments for RCRAPP2_C_AGE (9)

Source Code Comments

AGE: The student's age used in all calculations.

Columns Comments for RCRAPP2_C_MRTL_STATUS (10)

Source Code Comments

MARITAL STATUS: The computed student's marital status.

Columns Comments for RCRAPP2_C_FAM_MEMB (11)

Source Code Comments

FAMILY MEMBERS: The number of people in the independent student's household as computed by the need analysis processor.

Columns Comments for RCRAPP2_C_NO_IN_COLL (12)

Source Code Comments

NUMBER IN COLLEGE: The number of people in the student's family that will be in college at least half-time as computed by the need analysis processor.

Columns Comments for RCRAPP2_C_PAR_MRTL_STATUS (13)

Source Code Comments

PARENTS' MARITAL STATUS: The parents' marital status as used in the calculation of the PC. (CM)

Columns Comments for RCRAPP2_C_PAR_FAM_MEMB (14)

Source Code Comments

PARENTS' FAMILY MEMBERS: The number of family members in the parents' household as used in the calculation of the PC.

Columns Comments for RCRAPP2_C_PAR_NO_IN_COLL (15)

Source Code Comments

PARENTS' NUMBER IN COLL: The number of people in the parents household who will be in college as used in the calculation of the PC. (CM)

Columns Comments for RCRAPP2_C_PAR_PAR_IN_COLL (16)

Source Code Comments

PARENTS' PARENTS IN COLLEGE: The number in college that are parents of the student. (CM)

Columns Comments for RCRAPP2_C_PAR_OTH_IN_COLL (17)

Source Code Comments

PARENTS' OTHERS IN COLLEGE: The number of non-parents in the household that will be in college as used in the calculation of PC. (CM)

Columns Comments for RCRAPP2_C_ASSUME_YR_IN_COLL (18)

Source Code Comments

ASSUMED STUDENT'S YEAR IN COLLEGE: The year in college used in all calculations

Columns Comments for RCRAPP2_C_PAR_1_ANLY_TYPE (19)

Source Code Comments

ANALYSIS TYPE: The analysis type used to determine the primary Parent Calculation. (FM)

Columns Comments for RCRAPP2_C_PAR_1_AGI_TAX_INC (20)

Source Code Comments

PARENTS' ADJUSTED GROSS INCOME/TAXABLE INCOME: The AGI/taxable income used in the calculation of the primary parents' contribution. (CM)

Columns Comments for RCRAPP2_C_PAR_1_TOT_UNTAX_INC (21)

Source Code Comments

PARENTS' TOTAL UNTAXED INCOME: The total untaxed income used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_TOT_INC (22)

Source Code Comments

PARENTS' TOTAL INCOME: The total income used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_US_INC_TAX (23)

Source Code Comments

PARENTS' US INCOME TAXES PAID: The amount of US income taxes paid used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_ST_OTH_TAX (24)

Source Code Comments

PARENTS' STATE AND OTHER TAXES PAID: The amount of state and other taxes paid used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_FICA_TAX (25)

Source Code Comments

PARENTS' FICA TAX: The amount of FICA taxes used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_MED_DEN_EXP (26)

Source Code Comments

PARENTS' MEDICAL/DENTAL EXPENSES: The amount of medical and dental expenses used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_SCH_TUIT (27)

Source Code Comments

PARENTS' ELEMENTARY/SECONDARY SCHOOL TUITION PAID: The amount of elementary and secondary school tuition paid used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_EMP_ALLOW (28)

Source Code Comments

PARENTS' EMPLOYMENT ALLOWANCE: The employment allowance used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_MNT_ALLOW (29)

Source Code Comments

PARENTS' STANDARD MAINTENANCE ALLOWANCE: The SMA used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_TOT_ALLOW (30)

Source Code Comments

PARENTS' TOTAL ALLOWANCES: The total allowances used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_AVAIL_DISC_INC (31)

Source Code Comments

PARENTS' AVAILABLE DISCRETIONARY INCOME: The available discretionary income used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_CASH_AMT (32)

Source Code Comments

PARENTS' CASH AMOUNT: The amount of parents' cash, savings and checking accounts used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_HME_VAL (33)

Source Code Comments

PARENTS' HOME EQUITY: The home equity used in the calculation of the primary PC. (CM)

Columns Comments for RCRAPP2_C_PAR_1_RE_INV_VAL (34)

Source Code Comments

PARENTS' REAL ESTATE/INVESTMENT EQUITY: The other real estate and investment equity used