Model Common Origination and Disbursement

Model Label : Banner Financial Aid COD Module
Path : Default Folder/B70/finaid/COD_ERD

List of Objects

Object Name	Object Type	Layer Name
RCRAPP1	TABLE	Default
RCRAPP2	TABLE	Default
RCRAPP3	TABLE	Default
RCRAPP4	TABLE	Default
RCTXMLD	TABLE	Default
REBPAYV	TABLE	Default
RERCODD	TABLE	Default
RERSTID	TABLE	Default
RFRPROM	TABLE	Default
ROBALOG	TABLE	Default
RORSTAT	TABLE	Default
RPRADSB	TABLE	Default
RPRLADB	TABLE	Default
RPRLAPP	TABLE	Default
RPRRFND	TABLE	Default
RTVCDNT	TABLE	Default
RTVCDST	TABLE	Default
RTVRJCT	TABLE	Default

Comments

Model View

Table RCRAPP1

Schema Name FAISMGR
Label RCRAPP1
Server name S4B70
Creation Date 11/03/2004 14:45:47:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RCRAPP1_AIDY_CODE	RCRAPP1_AIDY_CODE	VARCHAR2(4)	No	*	*
RCRAPP1_PIDM	RCRAPP1_PIDM	NUMBER(8,0)	No	*	*
RCRAPP1_INFC_CODE	RCRAPP1_INFC_CODE	VARCHAR2(7)	No	*	*
RCRAPP1_SEQ_NO	RCRAPP1_SEQ_NO	NUMBER(3,0)	No	*
RCRAPP1_CURR_REC_IND	RCRAPP1_CURR_REC_IND	VARCHAR2(1)	No
RCRAPP1_CREATOR_ID	RCRAPP1_CREATOR_ID	VARCHAR2(30)	No
RCRAPP1_USER_ID	RCRAPP1_USER_ID	VARCHAR2(30)	No
RCRAPP1_CREATE_DATE	RCRAPP1_CREATE_DATE	DATE	No
RCRAPP1_ACTIVITY_DATE	RCRAPP1_ACTIVITY_DATE	DATE	No
RCRAPP1_COLL_CDE	RCRAPP1_COLL_CDE	VARCHAR2(6)	Yes
RCRAPP1_ACYR_CODE	RCRAPP1_ACYR_CODE	VARCHAR2(2)	Yes
RCRAPP1_LAST_NAME	RCRAPP1_LAST_NAME	VARCHAR2(16)	Yes
RCRAPP1_FIRST_NAME	RCRAPP1_FIRST_NAME	VARCHAR2(12)	Yes
RCRAPP1_MI	RCRAPP1_MI	VARCHAR2(1)	Yes
RCRAPP1_TITLE	RCRAPP1_TITLE	VARCHAR2(1)	Yes
RCRAPP1_ADDR	RCRAPP1_ADDR	VARCHAR2(35)	Yes
RCRAPP1_CITY	RCRAPP1_CITY	VARCHAR2(21)	Yes
RCRAPP1_STAT_CODE	RCRAPP1_STAT_CODE	VARCHAR2(2)	Yes
RCRAPP1_ZIP	RCRAPP1_ZIP	VARCHAR2(10)	Yes
RCRAPP1_SSN_PREFIX	RCRAPP1_SSN_PREFIX	VARCHAR2(1)	Yes
RCRAPP1_SSN	RCRAPP1_SSN	VARCHAR2(9)	Yes
RCRAPP1_BIRTH_DATE	RCRAPP1_BIRTH_DATE	DATE	Yes
RCRAPP1_PHONE_AREA	RCRAPP1_PHONE_AREA	VARCHAR2(3)	Yes
RCRAPP1_PHONE_NO	RCRAPP1_PHONE_NO	VARCHAR2(7)	Yes
RCRAPP1_STAT_CODE_RES	RCRAPP1_STAT_CODE_RES	VARCHAR2(2)	Yes
RCRAPP1_START_RES_MTH_YR	RCRAPP1_START_RES_MTH_YR	VARCHAR2(4)	Yes
RCRAPP1_RCPT_DATE	RCRAPP1_RCPT_DATE	DATE	Yes
RCRAPP1_REV_RCPT_DATE	RCRAPP1_REV_RCPT_DATE	DATE	Yes
RCRAPP1_ORIG_COMP_DATE	RCRAPP1_ORIG_COMP_DATE	DATE	Yes
RCRAPP1_REV_COMP_DATE	RCRAPP1_REV_COMP_DATE	DATE	Yes
RCRAPP1_CITZ_IND	RCRAPP1_CITZ_IND	VARCHAR2(1)	Yes
RCRAPP1_ALIEN_REG_NO	RCRAPP1_ALIEN_REG_NO	VARCHAR2(9)	Yes
RCRAPP1_MRTL_STATUS	RCRAPP1_MRTL_STATUS	VARCHAR2(1)	Yes
RCRAPP1_HS_CDE	RCRAPP1_HS_CDE	VARCHAR2(6)	Yes
RCRAPP1_EXP_ENROLL_STATUS	RCRAPP1_EXP_ENROLL_STATUS	VARCHAR2(1)	Yes
RCRAPP1_YR_IN_COLL	RCRAPP1_YR_IN_COLL	VARCHAR2(1)	Yes
RCRAPP1_CRSE_OF_STUDY	RCRAPP1_CRSE_OF_STUDY	VARCHAR2(5)	Yes
RCRAPP1_EXP_GRAD_MTH_YR	RCRAPP1_EXP_GRAD_MTH_YR	VARCHAR2(6)	Yes
RCRAPP1_DEGREE_BY_JULY	RCRAPP1_DEGREE_BY_JULY	VARCHAR2(1)	Yes
RCRAPP1_MORE_THAN_3_PREV_COLL	RCRAPP1_MORE_THAN_3_PREV_COLL	VARCHAR2(1)	Yes
RCRAPP1_NO_SCH	RCRAPP1_NO_SCH	NUMBER(1,0)	Yes
RCRAPP1_PREV_COLL1	RCRAPP1_PREV_COLL1	VARCHAR2(6)	Yes
RCRAPP1_PREV_COLL2	RCRAPP1_PREV_COLL2	VARCHAR2(6)	Yes
RCRAPP1_PREV_COLL3	RCRAPP1_PREV_COLL3	VARCHAR2(6)	Yes
RCRAPP1_DRIVER_LIC_NO	RCRAPP1_DRIVER_LIC_NO	VARCHAR2(20)	Yes
RCRAPP1_STAT_CODE_LIC	RCRAPP1_STAT_CODE_LIC	VARCHAR2(2)	Yes
RCRAPP1_DISL_WRK	RCRAPP1_DISL_WRK	VARCHAR2(1)	Yes
RCRAPP1_DISP_HME	RCRAPP1_DISP_HME	VARCHAR2(1)	Yes
RCRAPP1_FAM_MEMB	RCRAPP1_FAM_MEMB	NUMBER(2,0)	Yes
RCRAPP1_NO_IN_COLL	RCRAPP1_NO_IN_COLL	NUMBER(1,0)	Yes
RCRAPP1_CASH_AMT	RCRAPP1_CASH_AMT	NUMBER(7,0)	Yes
RCRAPP1_HME_VAL	RCRAPP1_HME_VAL	NUMBER(7,0)	Yes
RCRAPP1_HME_DBT	RCRAPP1_HME_DBT	NUMBER(7,0)	Yes
RCRAPP1_RE_INV_VAL	RCRAPP1_RE_INV_VAL	NUMBER(7,0)	Yes
RCRAPP1_RE_INV_DBT	RCRAPP1_RE_INV_DBT	NUMBER(7,0)	Yes
RCRAPP1_BUS_FARM_VAL	RCRAPP1_BUS_FARM_VAL	NUMBER(7,0)	Yes
RCRAPP1_BUS_FARM_DBT	RCRAPP1_BUS_FARM_DBT	NUMBER(7,0)	Yes
RCRAPP1_INCL_FARM	RCRAPP1_INCL_FARM	VARCHAR2(1)	Yes
RCRAPP1_BORN_BEFORE_1_1_XX	RCRAPP1_BORN_BEFORE_1_1_XX	VARCHAR2(1)	Yes
RCRAPP1_US_VET	RCRAPP1_US_VET	VARCHAR2(1)	Yes
RCRAPP1_WARD_OF_COURT	RCRAPP1_WARD_OF_COURT	VARCHAR2(1)	Yes
RCRAPP1_HAS_LEGAL_DEPEND	RCRAPP1_HAS_LEGAL_DEPEND	VARCHAR2(1)	Yes
RCRAPP1_TAX_FORM_IND	RCRAPP1_TAX_FORM_IND	VARCHAR2(1)	Yes
RCRAPP1_NO_EXEMPT	RCRAPP1_NO_EXEMPT	NUMBER(2,0)	Yes
RCRAPP1_US_INC	RCRAPP1_US_INC	NUMBER(6,0)	Yes
RCRAPP1_US_INC_TAX_PD	RCRAPP1_US_INC_TAX_PD	NUMBER(6,0)	Yes
RCRAPP1_INC_FR_WRK	RCRAPP1_INC_FR_WRK	NUMBER(6,0)	Yes
RCRAPP1_SPS_INC_FR_WRK	RCRAPP1_SPS_INC_FR_WRK	NUMBER(6,0)	Yes
RCRAPP1_SS_BENE	RCRAPP1_SS_BENE	NUMBER(6,0)	Yes
RCRAPP1_AFDC	RCRAPP1_AFDC	NUMBER(6,0)	Yes
RCRAPP1_CHILD_SUPP	RCRAPP1_CHILD_SUPP	NUMBER(6,0)	Yes
RCRAPP1_OTH_UNTAX_INC	RCRAPP1_OTH_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP1_MED_DEN_EXP	RCRAPP1_MED_DEN_EXP	NUMBER(6,0)	Yes
RCRAPP1_TUIT_PD	RCRAPP1_TUIT_PD	NUMBER(6,0)	Yes
RCRAPP1_NO_CHILD_TUIT	RCRAPP1_NO_CHILD_TUIT	NUMBER(1,0)	Yes
RCRAPP1_EXP_TAX_PD	RCRAPP1_EXP_TAX_PD	NUMBER(6,0)	Yes
RCRAPP1_EXP_INC_FR_WRK	RCRAPP1_EXP_INC_FR_WRK	NUMBER(6,0)	Yes
RCRAPP1_EXP_SPS_INC_FR_WRK	RCRAPP1_EXP_SPS_INC_FR_WRK	NUMBER(6,0)	Yes
RCRAPP1_EXP_OTH_TAX_INC	RCRAPP1_EXP_OTH_TAX_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_UNTAX_INC	RCRAPP1_EXP_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_SMR_INC	RCRAPP1_EXP_SMR_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_ACYR_INC	RCRAPP1_EXP_ACYR_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_SPS_SMR_INC	RCRAPP1_EXP_SPS_SMR_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_SPS_ACYR_INC	RCRAPP1_EXP_SPS_ACYR_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_SMR_OTH_TAX_INC	RCRAPP1_EXP_SMR_OTH_TAX_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_ACYR_OTH_TAX_INC	RCRAPP1_EXP_ACYR_OTH_TAX_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_SMR_UNTAX_INC	RCRAPP1_EXP_SMR_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_ACYR_UNTAX_INC	RCRAPP1_EXP_ACYR_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP1_GI_DEAB_AMT	RCRAPP1_GI_DEAB_AMT	NUMBER(3,0)	Yes
RCRAPP1_GI_DEAB_MTH	RCRAPP1_GI_DEAB_MTH	NUMBER(2,0)	Yes
RCRAPP1_VEAP_BEN_AMT	RCRAPP1_VEAP_BEN_AMT	NUMBER(3,0)	Yes
RCRAPP1_VEAP_BEN_MTH	RCRAPP1_VEAP_BEN_MTH	NUMBER(2,0)	Yes
RCRAPP1_OTH_VA_AMT	RCRAPP1_OTH_VA_AMT	NUMBER(4,0)	Yes
RCRAPP1_OTH_VA_MTH	RCRAPP1_OTH_VA_MTH	NUMBER(2,0)	Yes
RCRAPP1_CLM_AS_TAX_EXEMPT_2YR	RCRAPP1_CLM_AS_TAX_EXEMPT_2YR	VARCHAR2(1)	Yes
RCRAPP1_CLM_AS_TAX_EXEMPT_1YR	RCRAPP1_CLM_AS_TAX_EXEMPT_1YR	VARCHAR2(1)	Yes
RCRAPP1_CLM_AS_TAX_EXEMPT	RCRAPP1_CLM_AS_TAX_EXEMPT	VARCHAR2(1)	Yes
RCRAPP1_WHEN_RCVD_AID	RCRAPP1_WHEN_RCVD_AID	VARCHAR2(1)	Yes
RCRAPP1_1985_RSRC_4000_8788	RCRAPP1_1985_RSRC_4000_8788	VARCHAR2(1)	Yes
RCRAPP1_1986_RSRC_4000_8788	RCRAPP1_1986_RSRC_4000_8788	VARCHAR2(1)	Yes
RCRAPP1_1986_RSRC_4000_8889	RCRAPP1_1986_RSRC_4000_8889	VARCHAR2(1)	Yes
RCRAPP1_1987_RSRC_4000_8889	RCRAPP1_1987_RSRC_4000_8889	VARCHAR2(1)	Yes
RCRAPP1_1987_RSRC_4000_8990	RCRAPP1_1987_RSRC_4000_8990	VARCHAR2(1)	Yes
RCRAPP1_1988_RSRC_4000_8990	RCRAPP1_1988_RSRC_4000_8990	VARCHAR2(1)	Yes
RCRAPP1_1988_RSRC_4000_9091	RCRAPP1_1988_RSRC_4000_9091	VARCHAR2(1)	Yes
RCRAPP1_1989_RSRC_4000_9091	RCRAPP1_1989_RSRC_4000_9091	VARCHAR2(1)	Yes
RCRAPP1_NO_AID_RSRC_4000_2YR	RCRAPP1_NO_AID_RSRC_4000_2YR	VARCHAR2(1)	Yes
RCRAPP1_NO_AID_RSRC_4000_1YR	RCRAPP1_NO_AID_RSRC_4000_1YR	VARCHAR2(1)	Yes
RCRAPP1_LINE2_RELSHIP	RCRAPP1_LINE2_RELSHIP	VARCHAR2(1)	Yes
RCRAPP1_LINE2_ATTEND_COLL	RCRAPP1_LINE2_ATTEND_COLL	VARCHAR2(1)	Yes
RCRAPP1_LINE3_RELSHIP	RCRAPP1_LINE3_RELSHIP	VARCHAR2(1)	Yes
RCRAPP1_LINE3_ATTEND_COLL	RCRAPP1_LINE3_ATTEND_COLL	VARCHAR2(1)	Yes
RCRAPP1_LINE4_RELSHIP	RCRAPP1_LINE4_RELSHIP	VARCHAR2(1)	Yes
RCRAPP1_LINE4_ATTEND_COLL	RCRAPP1_LINE4_ATTEND_COLL	VARCHAR2(1)	Yes
RCRAPP1_LINE5_RELSHIP	RCRAPP1_LINE5_RELSHIP	VARCHAR2(1)	Yes
RCRAPP1_LINE5_ATTEND_COLL	RCRAPP1_LINE5_ATTEND_COLL	VARCHAR2(1)	Yes
RCRAPP1_LINE6_RELSHIP	RCRAPP1_LINE6_RELSHIP	VARCHAR2(1)	Yes
RCRAPP1_LINE6_ATTEND_COLL	RCRAPP1_LINE6_ATTEND_COLL	VARCHAR2(1)	Yes
RCRAPP1_LINE7_RELSHIP	RCRAPP1_LINE7_RELSHIP	VARCHAR2(1)	Yes
RCRAPP1_LINE7_ATTEND_COLL	RCRAPP1_LINE7_ATTEND_COLL	VARCHAR2(1)	Yes
RCRAPP1_LINE8_RELSHIP	RCRAPP1_LINE8_RELSHIP	VARCHAR2(1)	Yes
RCRAPP1_LINE8_ATTEND_COLL	RCRAPP1_LINE8_ATTEND_COLL	VARCHAR2(1)	Yes
RCRAPP1_PAR_MRTL_STATUS	RCRAPP1_PAR_MRTL_STATUS	VARCHAR2(1)	Yes
RCRAPP1_PAR_OLDER_AGE	RCRAPP1_PAR_OLDER_AGE	NUMBER(2,0)	Yes
RCRAPP1_PAR_STAT_CODE_RES	RCRAPP1_PAR_STAT_CODE_RES	VARCHAR2(2)	Yes
RCRAPP1_PAR_DISL_WRK	RCRAPP1_PAR_DISL_WRK	VARCHAR2(1)	Yes
RCRAPP1_PAR_DISP_HME	RCRAPP1_PAR_DISP_HME	VARCHAR2(1)	Yes
RCRAPP1_PAR_FAM_MEMB	RCRAPP1_PAR_FAM_MEMB	NUMBER(2,0)	Yes
RCRAPP1_PAR_NO_IN_COLL	RCRAPP1_PAR_NO_IN_COLL	NUMBER(1,0)	Yes
RCRAPP1_PAR_CASH_AMT	RCRAPP1_PAR_CASH_AMT	NUMBER(7,0)	Yes
RCRAPP1_PAR_HME_VAL	RCRAPP1_PAR_HME_VAL	NUMBER(7,0)	Yes
RCRAPP1_PAR_HME_DBT	RCRAPP1_PAR_HME_DBT	NUMBER(7,0)	Yes
RCRAPP1_PAR_RE_INV_VAL	RCRAPP1_PAR_RE_INV_VAL	NUMBER(7,0)	Yes
RCRAPP1_PAR_RE_INV_DBT	RCRAPP1_PAR_RE_INV_DBT	NUMBER(7,0)	Yes
RCRAPP1_PAR_CURR_INV_VAL	RCRAPP1_PAR_CURR_INV_VAL	NUMBER(7,0)	Yes
RCRAPP1_PAR_BUS_FARM_VAL	RCRAPP1_PAR_BUS_FARM_VAL	NUMBER(7,0)	Yes
RCRAPP1_PAR_BUS_FARM_DBT	RCRAPP1_PAR_BUS_FARM_DBT	NUMBER(7,0)	Yes
RCRAPP1_PAR_INCL_FARM	RCRAPP1_PAR_INCL_FARM	VARCHAR2(1)	Yes
RCRAPP1_PAR_HME_YR_PURCH	RCRAPP1_PAR_HME_YR_PURCH	NUMBER(4,0)	Yes
RCRAPP1_PAR_HME_PURCH_AMT	RCRAPP1_PAR_HME_PURCH_AMT	NUMBER(7,0)	Yes
RCRAPP1_PAR_DIV_SEP_REM_IND	RCRAPP1_PAR_DIV_SEP_REM_IND	VARCHAR2(1)	Yes
RCRAPP1_PAR_TAX_FORM_IND	RCRAPP1_PAR_TAX_FORM_IND	VARCHAR2(1)	Yes
RCRAPP1_PAR_NO_EXEMPT	RCRAPP1_PAR_NO_EXEMPT	NUMBER(2,0)	Yes
RCRAPP1_PAR_US_INC	RCRAPP1_PAR_US_INC	NUMBER(7,0)	Yes
RCRAPP1_PAR_WAGES	RCRAPP1_PAR_WAGES	NUMBER(6,0)	Yes
RCRAPP1_PAR_INT_INC	RCRAPP1_PAR_INT_INC	NUMBER(6,0)	Yes
RCRAPP1_PAR_DIV_INC	RCRAPP1_PAR_DIV_INC	NUMBER(6,0)	Yes
RCRAPP1_PAR_BUS_FARM_INC	RCRAPP1_PAR_BUS_FARM_INC	NUMBER(6,0)	Yes
RCRAPP1_PAR_OTH_TAX_INC	RCRAPP1_PAR_OTH_TAX_INC	NUMBER(6,0)	Yes
RCRAPP1_PAR_ADJ_TO_INC	RCRAPP1_PAR_ADJ_TO_INC	NUMBER(6,0)	Yes
RCRAPP1_PAR_US_INC_TAX_PD	RCRAPP1_PAR_US_INC_TAX_PD	NUMBER(6,0)	Yes
RCRAPP1_FATH_INC_FR_WRK	RCRAPP1_FATH_INC_FR_WRK	NUMBER(6,0)	Yes
RCRAPP1_MOTH_INC_FR_WRK	RCRAPP1_MOTH_INC_FR_WRK	NUMBER(6,0)	Yes
RCRAPP1_PAR_SS_BENE	RCRAPP1_PAR_SS_BENE	NUMBER(6,0)	Yes
RCRAPP1_PAR_AFDC	RCRAPP1_PAR_AFDC	NUMBER(6,0)	Yes
RCRAPP1_PAR_CHILD_SUPP	RCRAPP1_PAR_CHILD_SUPP	NUMBER(6,0)	Yes
RCRAPP1_PAR_OTH_UNTAX_INC	RCRAPP1_PAR_OTH_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP1_PAR_MED_DEN_EXP	RCRAPP1_PAR_MED_DEN_EXP	NUMBER(6,0)	Yes
RCRAPP1_PAR_TUIT_PD	RCRAPP1_PAR_TUIT_PD	NUMBER(6,0)	Yes
RCRAPP1_PAR_NO_CHILD_TUIT	RCRAPP1_PAR_NO_CHILD_TUIT	NUMBER(1,0)	Yes
RCRAPP1_EXP_PAR_TAX_PD	RCRAPP1_EXP_PAR_TAX_PD	NUMBER(6,0)	Yes
RCRAPP1_EXP_PAR_OTH_TAX_INC	RCRAPP1_EXP_PAR_OTH_TAX_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_PAR_UNTAX_INC	RCRAPP1_EXP_PAR_UNTAX_INC	NUMBER(6,0)	Yes
RCRAPP1_EXP_FATH_INC_FR_WRK	RCRAPP1_EXP_FATH_INC_FR_WRK	NUMBER(6,0)	Yes
RCRAPP1_EXP_MOTH_INC_FR_WRK	RCRAPP1_EXP_MOTH_INC_FR_WRK	NUMBER(6,0)	Yes
RCRAPP1_FED_COLL_CHOICE_1	RCRAPP1_FED_COLL_CHOICE_1	VARCHAR2(6)	Yes
RCRAPP1_FED_COLL_CHOICE_2	RCRAPP1_FED_COLL_CHOICE_2	VARCHAR2(6)	Yes
RCRAPP1_FED_COLL_CHOICE_3	RCRAPP1_FED_COLL_CHOICE_3	VARCHAR2(6)	Yes
RCRAPP1_COLL_CHOICE_NO	RCRAPP1_COLL_CHOICE_NO	VARCHAR2(1)	Yes
RCRAPP1_IN_DEFAULT	RCRAPP1_IN_DEFAULT	VARCHAR2(1)	Yes
RCRAPP1_OWES_REFUND	RCRAPP1_OWES_REFUND	VARCHAR2(1)	Yes
RCRAPP1_CONSIDER_FOR_STAF	RCRAPP1_CONSIDER_FOR_STAF	VARCHAR2(1)	Yes
RCRAPP1_BAL_ON_ALL_STAF	RCRAPP1_BAL_ON_ALL_STAF	NUMBER(5,0)	Yes
RCRAPP1_RECENT_STAF_BAL	RCRAPP1_RECENT_STAF_BAL	NUMBER(5,0)	Yes
RCRAPP1_RECENT_STAF_INT_RATE	RCRAPP1_RECENT_STAF_INT_RATE	VARCHAR2(1)	Yes
RCRAPP1_RECENT_STAF_FR_MTH_YR	RCRAPP1_RECENT_STAF_FR_MTH_YR	VARCHAR2(4)	Yes
RCRAPP1_RECENT_STAF_TO_MTH_YR	RCRAPP1_RECENT_STAF_TO_MTH_YR	VARCHAR2(4)	Yes
RCRAPP1_RECENT_STAF_CLASS	RCRAPP1_RECENT_STAF_CLASS	VARCHAR2(2)	Yes
RCRAPP1_RQST_FA_PREF	RCRAPP1_RQST_FA_PREF	VARCHAR2(1)	Yes
RCRAPP1_RQST_FA_FR_MTH_YR	RCRAPP1_RQST_FA_FR_MTH_YR	VARCHAR2(4)	Yes
RCRAPP1_RQST_FA_TO_MTH_YR	RCRAPP1_RQST_FA_TO_MTH_YR	VARCHAR2(4)	Yes
RCRAPP1_RQST_STAF_AMT	RCRAPP1_RQST_STAF_AMT	NUMBER(4,0)	Yes
RCRAPP1_RQST_STAF_FA_FR_MTH_YR	RCRAPP1_RQST_STAF_FA_FR_MTH_YR	VARCHAR2(4)	Yes
RCRAPP1_RQST_STAF_FA_TO_MTH_YR	RCRAPP1_RQST_STAF_FA_TO_MTH_YR	VARCHAR2(4)	Yes
RCRAPP1_RQST_FA_SUMMER_THIS_YR	RCRAPP1_RQST_FA_SUMMER_THIS_YR	VARCHAR2(1)	Yes
RCRAPP1_RQST_FA_FALL_THIS_YR	RCRAPP1_RQST_FA_FALL_THIS_YR	VARCHAR2(1)	Yes
RCRAPP1_RQST_FA_WINTER_NEXT_YR	RCRAPP1_RQST_FA_WINTER_NEXT_YR	VARCHAR2(1)	Yes
RCRAPP1_RQST_FA_SPRING_NEXT_YR	RCRAPP1_RQST_FA_SPRING_NEXT_YR	VARCHAR2(1)	Yes
RCRAPP1_RQST_FA_SUMMER_NEXT_YR	RCRAPP1_RQST_FA_SUMMER_NEXT_YR	VARCHAR2(1)	Yes
RCRAPP1_RQST_FA_OTHER	RCRAPP1_RQST_FA_OTHER	VARCHAR2(1)	Yes
RCRAPP1_CLASSIFICATION	RCRAPP1_CLASSIFICATION	VARCHAR2(1)	Yes
RCRAPP1_EXP_WRK_HRS	RCRAPP1_EXP_WRK_HRS	VARCHAR2(1)	Yes
RCRAPP1_INST_HOUS_CDE	RCRAPP1_INST_HOUS_CDE	VARCHAR2(1)	Yes
RCRAPP1_COLL_CDE_1	RCRAPP1_COLL_CDE_1	VARCHAR2(6)	Yes
RCRAPP1_HOUS_CDE_1	RCRAPP1_HOUS_CDE_1	VARCHAR2(1)	Yes
RCRAPP1_COLL_CDE_2	RCRAPP1_COLL_CDE_2	VARCHAR2(6)	Yes
RCRAPP1_HOUS_CDE_2	RCRAPP1_HOUS_CDE_2	VARCHAR2(1)	Yes
RCRAPP1_COLL_CDE_3	RCRAPP1_COLL_CDE_3	VARCHAR2(6)	Yes
RCRAPP1_HOUS_CDE_3	RCRAPP1_HOUS_CDE_3	VARCHAR2(1)	Yes
RCRAPP1_COLL_CDE_4	RCRAPP1_COLL_CDE_4	VARCHAR2(6)	Yes
RCRAPP1_HOUS_CDE_4	RCRAPP1_HOUS_CDE_4	VARCHAR2(1)	Yes
RCRAPP1_COLL_CDE_5	RCRAPP1_COLL_CDE_5	VARCHAR2(6)	Yes
RCRAPP1_HOUS_CDE_5	RCRAPP1_HOUS_CDE_5	VARCHAR2(1)	Yes
RCRAPP1_COLL_CDE_6	RCRAPP1_COLL_CDE_6	VARCHAR2(6)	Yes
RCRAPP1_HOUS_CDE_6	RCRAPP1_HOUS_CDE_6	VARCHAR2(1)	Yes
RCRAPP1_COLL_CDE_7	RCRAPP1_COLL_CDE_7	VARCHAR2(6)	Yes
RCRAPP1_HOUS_CDE_7	RCRAPP1_HOUS_CDE_7	VARCHAR2(1)	Yes
RCRAPP1_COLL_CDE_8	RCRAPP1_COLL_CDE_8	VARCHAR2(6)	Yes
RCRAPP1_HOUS_CDE_8	RCRAPP1_HOUS_CDE_8	VARCHAR2(1)	Yes
RCRAPP1_ADDL_COLL_CDE_1	RCRAPP1_ADDL_COLL_CDE_1	VARCHAR2(6)	Yes
RCRAPP1_ADDL_COLL_CDE_2	RCRAPP1_ADDL_COLL_CDE_2	VARCHAR2(6)	Yes
RCRAPP1_ADDL_COLL_CDE_3	RCRAPP1_ADDL_COLL_CDE_3	VARCHAR2(6)	Yes
RCRAPP1_ADDL_COLL_CDE_4	RCRAPP1_ADDL_COLL_CDE_4	VARCHAR2(6)	Yes
RCRAPP1_ADDL_COLL_CDE_5	RCRAPP1_ADDL_COLL_CDE_5	VARCHAR2(6)	Yes
RCRAPP1_ADDL_COLL_CDE_6	RCRAPP1_ADDL_COLL_CDE_6	VARCHAR2(6)	Yes
RCRAPP1_ADDL_COLL_CDE_7	RCRAPP1_ADDL_COLL_CDE_7	VARCHAR2(6)	Yes
RCRAPP1_ADDL_COLL_CDE_8	RCRAPP1_ADDL_COLL_CDE_8	VARCHAR2(6)	Yes
RCRAPP1_EXTRA_REQUEST	RCRAPP1_EXTRA_REQUEST	VARCHAR2(1)	Yes
RCRAPP1_REL_TO_STATE	RCRAPP1_REL_TO_STATE	VARCHAR2(1)	Yes
RCRAPP1_REL_TO_US_ED	RCRAPP1_REL_TO_US_ED	VARCHAR2(1)	Yes
RCRAPP1_REL_US_ED_TO_STATE	RCRAPP1_REL_US_ED_TO_STATE	VARCHAR2(1)	Yes
RCRAPP1_REL_US_ED_TO_COLL	RCRAPP1_REL_US_ED_TO_COLL	VARCHAR2(1)	Yes
RCRAPP1_BUS_FARM_SUPP_FILED	RCRAPP1_BUS_FARM_SUPP_FILED	VARCHAR2(1)	Yes
RCRAPP1_SIGNED	RCRAPP1_SIGNED	VARCHAR2(1)	Yes
RCRAPP1_SIGNED_SPS	RCRAPP1_SIGNED_SPS	VARCHAR2(1)	Yes
RCRAPP1_SIGNED_FATH	RCRAPP1_SIGNED_FATH	VARCHAR2(1)	Yes
RCRAPP1_SIGNED_MOTH	RCRAPP1_SIGNED_MOTH	VARCHAR2(1)	Yes
RCRAPP1_SIGNED_PAR	RCRAPP1_SIGNED_PAR	VARCHAR2(1)	Yes
RCRAPP1_SIGNED_MTH_DAY	RCRAPP1_SIGNED_MTH_DAY	VARCHAR2(4)	Yes
RCRAPP1_SIGNED_YR	RCRAPP1_SIGNED_YR	VARCHAR2(1)	Yes
RCRAPP1_DEPEND_AGE_0_5	RCRAPP1_DEPEND_AGE_0_5	NUMBER(1,0)	Yes
RCRAPP1_DEPEND_AGE_6_12	RCRAPP1_DEPEND_AGE_6_12	NUMBER(1,0)	Yes
RCRAPP1_DEPEND_AGE_13_PLUS	RCRAPP1_DEPEND_AGE_13_PLUS	NUMBER(1,0)	Yes
RCRAPP1_CONT_WRK_ACYR	RCRAPP1_CONT_WRK_ACYR	VARCHAR2(1)	Yes
RCRAPP1_PERMIT_DRAFT_REG	RCRAPP1_PERMIT_DRAFT_REG	VARCHAR2(1)	Yes
RCRAPP1_PELL_REL_MSG	RCRAPP1_PELL_REL_MSG	VARCHAR2(1)	Yes
RCRAPP1_ST_AGENCY_REL_MSG	RCRAPP1_ST_AGENCY_REL_MSG	VARCHAR2(1)	Yes
RCRAPP1_VERIFICATION_MSG	RCRAPP1_VERIFICATION_MSG	VARCHAR2(1)	Yes
RCRAPP1_VERIFICATION_PRTY	RCRAPP1_VERIFICATION_PRTY	VARCHAR2(4)	Yes
RCRAPP1_INS	RCRAPP1_INS	VARCHAR2(1)	Yes
RCRAPP1_SELECTIVE_SERVICE	RCRAPP1_SELECTIVE_SERVICE	VARCHAR2(1)	Yes
RCRAPP1_SPEC_COND_IND	RCRAPP1_SPEC_COND_IND	VARCHAR2(1)	Yes
RCRAPP1_TITLE_IV_DEFAULT	RCRAPP1_TITLE_IV_DEFAULT	VARCHAR2(1)	Yes
RCRAPP1_INAS_OPTION	RCRAPP1_INAS_OPTION	VARCHAR2(1)	Yes
RCRAPP1_EDE_SOURCE	RCRAPP1_EDE_SOURCE	VARCHAR2(1)	Yes
RCRAPP1_EDE_SPEC_COND_IND	RCRAPP1_EDE_SPEC_COND_IND	VARCHAR2(1)	Yes
RCRAPP1_USED_TRANS_NO	RCRAPP1_USED_TRANS_NO	VARCHAR2(2)	Yes
RCRAPP1_DEF_MATCH_REGION	RCRAPP1_DEF_MATCH_REGION	VARCHAR2(1)	Yes
RCRAPP1_PREV_COLL4	RCRAPP1_PREV_COLL4	VARCHAR2(6)	Yes
RCRAPP1_1989_RSRC_4000_9192	RCRAPP1_1989_RSRC_4000_9192	VARCHAR2(1)	Yes
RCRAPP1_1990_RSRC_4000_9192	RCRAPP1_1990_RSRC_4000_9192	VARCHAR2(1)	Yes
RCRAPP1_IN_DEF_OWE_REF	RCRAPP1_IN_DEF_OWE_REF	VARCHAR2(1)	Yes
RCRAPP1_PAR_SS_BENE_STU_ONLY	RCRAPP1_PAR_SS_BENE_STU_ONLY	NUMBER(6,0)	Yes
RCRAPP1_COMPLETION_DATE	RCRAPP1_COMPLETION_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RCRAPP1_INFC_CODE	RTVINFC_CODE	RTVINFC
RCRAPP1_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RCRAPP1_AIDY_CODE	RCRTMP1_AIDY_CODE	RCRTMP1
RCRAPP1_AIDY_CODE	RORSTAT_AIDY_CODE	RORSTAT
RCRAPP1_PIDM	RORSTAT_PIDM	RORSTAT

Index

Index Name	Index Type	Column Name
PK_RCRAPP1	Unique	RCRAPP1_AIDY_CODE
PK_RCRAPP1	Unique	RCRAPP1_PIDM
PK_RCRAPP1	Unique	RCRAPP1_INFC_CODE
PK_RCRAPP1	Unique	RCRAPP1_SEQ_NO
RCRAPP1_CURR_INDEX		RCRAPP1_AIDY_CODE
RCRAPP1_CURR_INDEX		RCRAPP1_PIDM
RCRAPP1_CURR_INDEX		RCRAPP1_CURR_REC_IND

Comments

Source Code Comments

Financial Aid Application Table - Part 1

Impact job : New Impact2 New Job

Columns Comments for RCRAPP1_AIDY_CODE (1)

Source Code Comments

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

Columns Comments for RCRAPP1_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RCRAPP1_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-CSS

Columns Comments for RCRAPP1_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 RCRAPP1_CURR_REC_IND (5)

Source Code Comments

CURRENT RECORD INDICATOR: Indicates if this application record has been flagged as the 'current' record for processing.

Columns Comments for RCRAPP1_CREATOR_ID (6)

Source Code Comments

APPLICATION CREATOR ID: The ID of the person who created this application record on the database, either manually or through dataload part 1.

Columns Comments for RCRAPP1_USER_ID (7)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record in this table, either manually or through dataload part 3.

Columns Comments for RCRAPP1_CREATE_DATE (8)

Source Code Comments

APPLICATION CREATED DATE: The date that this application record was created on the database, either manually or through dataload part 3.

Columns Comments for RCRAPP1_ACTIVITY_DATE (9)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated, either manually or through dataload part 3.

Columns Comments for RCRAPP1_COLL_CDE (10)

Source Code Comments

COLLEGE CODE: The four digit college code identifying the school for which this application tape record was created.

Columns Comments for RCRAPP1_ACYR_CODE (11)

Source Code Comments

ACADEMIC YEAR CODE: The last two digits of the first year for the academic year being processed. EXAMPLE: '90' for the 1990-91 academic year.

Columns Comments for RCRAPP1_LAST_NAME (12)

Source Code Comments

LAST NAME: The student's last name as reported on the aid application.

Columns Comments for RCRAPP1_FIRST_NAME (13)

Source Code Comments

FIRST NAME: The student's first name as reported on the aid application.

Columns Comments for RCRAPP1_MI (14)

Source Code Comments

MIDDLE INITIAL: The student's middle initial as reported on the aid application.

Columns Comments for RCRAPP1_TITLE (15)

Source Code Comments

TITLE: The student's title. (Mr. or Miss, Ms., Mrs.)

Columns Comments for RCRAPP1_ADDR (16)

Source Code Comments

ADDRESS: The student's number and street for their address as reported on their aid application.

Columns Comments for RCRAPP1_CITY (17)

Source Code Comments

CITY: The city of the student's address from the aid application.

Columns Comments for RCRAPP1_STAT_CODE (18)

Source Code Comments

STATE CODE: The two character postal abbreviation for the student's state reported as part of the address.

Columns Comments for RCRAPP1_ZIP (19)

Source Code Comments

ZIP CODE: The zip code for the student's address.

Columns Comments for RCRAPP1_SSN_PREFIX (20)

Source Code Comments

SOCIAL SECURITY NUMBER PREFIX: A one character prefix before the student's nine character SSN. (ACT format only)

Columns Comments for RCRAPP1_SSN (21)

Source Code Comments

SOCIAL SECURITY NUMBER: The student's social security number as reported on the aid application.

Columns Comments for RCRAPP1_BIRTH_DATE (22)

Source Code Comments

BIRTH DATE: The student's date of birth. (In Oracle format)

Columns Comments for RCRAPP1_PHONE_AREA (23)

Source Code Comments

STUDENT'S PHONE NUMBER AREA CODE: The area code of the student's home telephone number.

Columns Comments for RCRAPP1_PHONE_NO (24)

Source Code Comments

STUDENT'S PHONE NUMBER: The student's home telephone number without area code.

Columns Comments for RCRAPP1_STAT_CODE_RES (25)

Source Code Comments

STATE OF LEGAL RESIDENCE: The student's state of legal residence.

Columns Comments for RCRAPP1_START_RES_MTH_YR (26)

Source Code Comments

START RESIDENCE DATE (MONTH/YR): The date the student began living in his/her state of legal residence in MMYY format.

Columns Comments for RCRAPP1_RCPT_DATE (27)

Source Code Comments

APPLICATION RECEIPT DATE: The date that the processor received the aid application.

Columns Comments for RCRAPP1_REV_RCPT_DATE (28)

Source Code Comments

REVISION RECEIPT DATE: The date that the processor received a request for revisions from the student.

Columns Comments for RCRAPP1_ORIG_COMP_DATE (29)

Source Code Comments

ORIGINAL COMPUTE DATE: The date that the application was originally processed by the processor.

Columns Comments for RCRAPP1_REV_COMP_DATE (30)

Source Code Comments

REVISION COMPUTE DATE: The date that the processor processed a revised report for the applicant.

Columns Comments for RCRAPP1_CITZ_IND (31)

Source Code Comments

CITIZENSHIP INDICATOR: 1=U.S. Citizen, 2=Eligible Non-Citizen, 3=None of the above, Blank= Not reported.

Columns Comments for RCRAPP1_ALIEN_REG_NO (32)

Source Code Comments

ALIEN REGISTRATION NUMBER: The number assigned by the Immigration and Naturalization Service (INS) to all eligible permanent resident non-citizens. A nine digit identification beginning with the letter 'A'.

Columns Comments for RCRAPP1_MRTL_STATUS (33)

Source Code Comments

MARITAL STATUS: The student's reported marital status.

Columns Comments for RCRAPP1_HS_CDE (34)

Source Code Comments

HIGH SCHOOL CODE: The six digit code for the student's high school.

Columns Comments for RCRAPP1_EXP_ENROLL_STATUS (35)

Source Code Comments

EXPECTED ENROLLMENT STATUS: The student's expected enrollment status for the school year.

Columns Comments for RCRAPP1_YR_IN_COLL (36)

Source Code Comments

YEAR IN COLLEGE: Indicates which year in college the student will be enrolled in during the school year.

Columns Comments for RCRAPP1_CRSE_OF_STUDY (37)

Source Code Comments

COURSE OF STUDY: A code to indicate the student's anticipated college major.

Columns Comments for RCRAPP1_EXP_GRAD_MTH_YR (38)

Source Code Comments

EXPECTED GRADUATION MONTH AND YEAR: The student's expected graduation date. (MMYY format)

Columns Comments for RCRAPP1_DEGREE_BY_JULY (39)

Source Code Comments

DEGREE BY JULY 1, xxxx: Indicates if the student will have a first bachelor's degree by July 1, of the start of the aid year.

Columns Comments for RCRAPP1_MORE_THAN_3_PREV_COLL (40)

Source Code Comments

MORE THAN 3 PREVIOUS COLLEGES: Indicates whether or not the student attended more than three previous colleges.

Columns Comments for RCRAPP1_NO_SCH (41)

Source Code Comments

NUMBER OF PREVIOUS SCHOOLS ATTENDED: The number of schools, beyond high school, that the student has attended.