RBBABUD RCRAPP1 RCRAPP2 RCRAPP3 RCRAPP4 RCRESAR ROBINST RORSTAT RRRAREQ RTVINFC SPRIDEN

Model RCRAPP1


Model Label : Banner Financial Aid Core Table RCRAPP1
Path : Default Folder/B70/finaid/RCRAPP1_ERD

List of Objects

Object Name Object Type Layer Name
RBBABUD TABLE Default
RCRAPP1 TABLE Default
RCRAPP2 TABLE Default
RCRAPP3 TABLE Default
RCRAPP4 TABLE Default
RCRESAR TABLE Default
ROBINST TABLE Default
RORSTAT TABLE Default
RRRAREQ TABLE Default
RTVINFC TABLE Default
SPRIDEN TABLE Default

Comments

Model View

''

Table RBBABUD

Schema Name FAISMGR
Label RBBABUD
Server name S4B70
Creation Date 09/29/2003 12:14:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RBBABUD_AIDY_CODE RBBABUD_AIDY_CODE VARCHAR2(4) No * *
RBBABUD_PIDM RBBABUD_PIDM NUMBER(8,0) No *
RBBABUD_TFC_IND RBBABUD_TFC_IND VARCHAR2(1) No *
RBBABUD_BTYP_CODE RBBABUD_BTYP_CODE VARCHAR2(4) No * *
RBBABUD_USER_ID RBBABUD_USER_ID VARCHAR2(30) No
RBBABUD_SYS_IND RBBABUD_SYS_IND VARCHAR2(1) No
RBBABUD_ACTIVITY_DATE RBBABUD_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
RBBABUD_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RBBABUD_BTYP_CODE RTVBTYP_CODE RTVBTYP

Index

Index Name Index Type Column Name
PK_RBBABUD Unique RBBABUD_AIDY_CODE
PK_RBBABUD Unique RBBABUD_PIDM
PK_RBBABUD Unique RBBABUD_BTYP_CODE
PK_RBBABUD Unique RBBABUD_TFC_IND

Comments

Source Code Comments

Applicant Budget Table

Columns Comments for RBBABUD_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 RBBABUD_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RBBABUD_TFC_IND (3)

Source Code Comments

TFC INDICATOR: Indicator to show which Total Family Contribution is to be used for this student when calculating need. EXAMPLES: (F)ederal or (I)nstitutional Methodology

Columns Comments for RBBABUD_BTYP_CODE (4)

Source Code Comments

BUDGET TYPE CODE: Code indicating which budget types have been associated with the student applicant. EXAMPLES: (PELL = Pell Type) (CAMP = Campus-Based Type)

Columns Comments for RBBABUD_USER_ID (5)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record in this table.

Columns Comments for RBBABUD_SYS_IND (6)

Source Code Comments

SYSTEM/MANUAL INDICATOR: Indicator to show if the student's budget type was assigned (M)anually or by the (S)ystem.

Columns Comments for RBBABUD_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

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