Model ROBINST

Model Label :
Path : BANNER DEV/Financial Aid/Finaid_ERD/ROBINST_ERD

List of Objects

Object Name	Object Type	Layer Name
RBBABUD	TABLE	Default
RBRACMP	TABLE	Default
RBRCOMP	TABLE	Default
RBRGMSG	TABLE	Default
RBRMIXD	TABLE	Default
RCRAIDY	TABLE	Default
RCRAPP1	TABLE	Default
RCRAPP2	TABLE	Default
RCRAPP3	TABLE	Default
RCRAPP4	TABLE	Default
RCRESAR	TABLE	Default
RCRINFR	TABLE	Default
RCRTERM	TABLE	Default
RCRTMP1	TABLE	Default
RCRTMP2	TABLE	Default
RCRTMP3	TABLE	Default
RCRTMP4	TABLE	Default
REBDRCT	TABLE	Default
REBPAYV	TABLE	Default
RFRASCH	TABLE	Default
RFRASPC	TABLE	Default
RFRBCMP	TABLE	Default
RFRCOMM	TABLE	Default
RFRDEFA	TABLE	Default
RFRDEFD	TABLE	Default
RFRDETC	TABLE	Default
RFRDLCK	TABLE	Default
RFRDSCH	TABLE	Default
RFRMESG	TABLE	Default
RFRTREQ	TABLE	Default
RHBTRNS	TABLE	Default
RHRCOMM	TABLE	Default
RJBSEDR	TABLE	Default
RJRPAYL	TABLE	Default
RJRPLRL	TABLE	Default
RJRSEAR	TABLE	Default
RJRSERF	TABLE	Default
RJRSEWH	TABLE	Default
RLRAPP1	TABLE	Default
RLRAPP2	TABLE	Default
RLRAPP3	TABLE	Default
RLRAPP4	TABLE	Default
RLRSTAT	TABLE	Default
RNRGLBL	TABLE	Default
RNROVRD	TABLE	Default
RNRVRFY	TABLE	Default
ROBALOG	TABLE	Default
ROBINST	TABLE	Default
ROBUSDF	TABLE	Default
RORAUDT	TABLE	Default
RORCAMP	TABLE	Default
RORCRHR	TABLE	Default
RORDATA	TABLE	Default
RORGDAT	TABLE	Default
RORHOLD	TABLE	Default
RORINID	TABLE	Default
RORPELL	TABLE	Default
RORPOST	TABLE	Default
RORSLOG	TABLE	Default
RORSTAT	TABLE	Default
RORTPRD	TABLE	Default
RORVIEW	TABLE	Default
RORWEBA	TABLE	Default
RPBLOPT	TABLE	Default
RPBOPTS	TABLE	Default
RPRADSB	TABLE	Default
RPRARSC	TABLE	Default
RPRATRM	TABLE	Default
RPRAUTH	TABLE	Default
RPRAWRD	TABLE	Default
RPRCLSS	TABLE	Default
RPRDATE	TABLE	Default
RPRDEFE	TABLE	Default
RPRDEFG	TABLE	Default
RPRDEFS	TABLE	Default
RPRDSAS	TABLE	Default
RPRFEDR	TABLE	Default
RPRFSRC	TABLE	Default
RPRFUND	TABLE	Default
RPRGEQY	TABLE	Default
RPRGFND	TABLE	Default
RPRGGAP	TABLE	Default
RPRGSHP	TABLE	Default
RPRLAPP	TABLE	Default
RPRLPAP	TABLE	Default
RPRRSLT	TABLE	Default
RRRAREQ	TABLE	Default
RRRGREQ	TABLE	Default
RRRTMSG	TABLE	Default
RTVAPRD	TABLE	Default
RTVBGRP	TABLE	Default
RTVICMT	TABLE	Default
RTVINFC	TABLE	Default
RTVPGRP	TABLE	Default
RTVTGRP	TABLE	Default
RTVUSER	TABLE	Default
STVSBGI	TABLE	Default
STVTERM	TABLE	Default

Comments

Model View

Table RBBABUD

Schema Name FAISMGR
Label RBBABUD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RBBABUD_AIDY_CODE	RBBABUD_AIDY_CODE	VARCHAR2(4)	No	*	*
RBBABUD_AIDY_CODE	RBBABUD_AIDY_CODE	VARCHAR2(4)	No	*	*
RBBABUD_AIDY_CODE	RBBABUD_AIDY_CODE	VARCHAR2(4)	No	*	*
RBBABUD_PIDM	RBBABUD_PIDM	NUMBER(8,0)	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_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_BTYP_CODE	RBRACMP_BTYP_CODE	RBRACMP
RBBABUD_PIDM	RBRACMP_PIDM	RBRACMP
RBBABUD_AIDY_CODE	RBRACMP_AIDY_CODE	RBRACMP
RBBABUD_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RBBABUD_BTYP_CODE	RTVBTYP_CODE	RTVBTYP
RBBABUD_PIDM	RORSTAT_PIDM	RORSTAT
RBBABUD_AIDY_CODE	RORSTAT_AIDY_CODE	RORSTAT

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 RBRACMP

Schema Name FAISMGR
Label RBRACMP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RBRACMP_AIDY_CODE	RBRACMP_AIDY_CODE	VARCHAR2(4)	No	*	*
RBRACMP_PIDM	RBRACMP_PIDM	NUMBER(8,0)	No	*
RBRACMP_BTYP_CODE	RBRACMP_BTYP_CODE	VARCHAR2(4)	No	*	*
RBRACMP_COMP_CODE	RBRACMP_COMP_CODE	VARCHAR2(4)	No	*	*
RBRACMP_AMT	RBRACMP_AMT	NUMBER(11,2)	No
RBRACMP_USER_ID	RBRACMP_USER_ID	VARCHAR2(30)	No
RBRACMP_SYS_IND	RBRACMP_SYS_IND	VARCHAR2(1)	No
RBRACMP_ACTIVITY_DATE	RBRACMP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RBRACMP_COMP_CODE	RTVCOMP_CODE	RTVCOMP
RBRACMP_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RBRACMP_BTYP_CODE	RTVBTYP_CODE	RTVBTYP

Index

Index Name	Index Type	Column Name
PK_RBRACMP	Unique	RBRACMP_AIDY_CODE
PK_RBRACMP	Unique	RBRACMP_PIDM
PK_RBRACMP	Unique	RBRACMP_BTYP_CODE
PK_RBRACMP	Unique	RBRACMP_COMP_CODE

Comments

Source Code Comments

Applicant Budget Component Table

Columns Comments for RBRACMP_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 RBRACMP_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RBRACMP_BTYP_CODE (3)

Source Code Comments

BUDGET TYPE CODE: The budget type code associated with this particular budget component.

Columns Comments for RBRACMP_COMP_CODE (4)

Source Code Comments

BUDGET COMPONENT CODE: The code used to identify the source of the expense in the student's budget.

Columns Comments for RBRACMP_AMT (5)

Source Code Comments

BUDGET COMPONENT AMOUNT: The amount of this particular budget component.

Columns Comments for RBRACMP_USER_ID (6)

Source Code Comments

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

Columns Comments for RBRACMP_SYS_IND (7)

Source Code Comments

SYSTEM/MANUAL INDICATOR: The indicator which shows whether the component was created or updated (M)anually by the user , by the (S)ystem through a batch or automatic process, or by use of a mi(X)ed (averaged) budget definition.

Columns Comments for RBRACMP_ACTIVITY_DATE (8)

Source Code Comments

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

Table RBRCOMP

Schema Name FAISMGR
Label RBRCOMP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
RBRCOMP_AIDY_CODE	RBRCOMP_AIDY_CODE	VARCHAR2(4)	No	*
RBRCOMP_APRD_CODE	RBRCOMP_APRD_CODE	VARCHAR2(6)	No	*
RBRCOMP_COMP_CODE	RBRCOMP_COMP_CODE	VARCHAR2(4)	No	*
RBRCOMP_AMT	RBRCOMP_AMT	NUMBER(11,2)	No
RBRCOMP_ACTIVITY_DATE	RBRCOMP_ACTIVITY_DATE	DATE	No
RBRCOMP_BTYP_CODE	RBRCOMP_BTYP_CODE	VARCHAR2(4)	Yes	*
RBRCOMP_BGRP_CODE	RBRCOMP_BGRP_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
RBRCOMP_COMP_CODE	RTVCOMP_CODE	RTVCOMP
RBRCOMP_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RBRCOMP_BTYP_CODE	RTVBTYP_CODE	RTVBTYP
RBRCOMP_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RBRCOMP_BGRP_CODE	RTVBGRP_CODE	RTVBGRP

Index

Index Name	Index Type	Column Name
RBRCOMP_KEY_INDEX	Unique	RBRCOMP_AIDY_CODE
RBRCOMP_KEY_INDEX	Unique	RBRCOMP_BGRP_CODE
RBRCOMP_KEY_INDEX	Unique	RBRCOMP_BTYP_CODE
RBRCOMP_KEY_INDEX	Unique	RBRCOMP_APRD_CODE
RBRCOMP_KEY_INDEX	Unique	RBRCOMP_COMP_CODE

Comments

Source Code Comments

Budget Component Rules Table

Columns Comments for RBRCOMP_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 RBRCOMP_APRD_CODE (2)

Source Code Comments

AID PERIOD CODE: The aid period for the budget being defined.

Columns Comments for RBRCOMP_COMP_CODE (3)

Source Code Comments

BUDGET COMPONENT CODE: The code to identify the component in the budget that is being defined.

Columns Comments for RBRCOMP_AMT (4)

Source Code Comments

BUDGET COMPONENT DOLLAR AMOUNT: The amount of a specific budget component code included in the budget being defined.

Columns Comments for RBRCOMP_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for RBRCOMP_BTYP_CODE (6)

Source Code Comments

BUDGET TYPE CODE: The budget type code for the budget being defined.

Columns Comments for RBRCOMP_BGRP_CODE (7)

Source Code Comments

BUDGET GROUP CODE: The budget group code for the budget being defined.

Table RBRGMSG

Schema Name FAISMGR
Label RBRGMSG
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RBRGMSG_AIDY_CODE	RBRGMSG_AIDY_CODE	VARCHAR2(4)	No	*	*
RBRGMSG_BGRP_CODE	RBRGMSG_BGRP_CODE	VARCHAR2(6)	No	*	*
RBRGMSG_MESG_CODE	RBRGMSG_MESG_CODE	VARCHAR2(4)	No	*	*
RBRGMSG_ACTIVITY_DATE	RBRGMSG_ACTIVITY_DATE	DATE	No
RBRGMSG_LETR_CODE	RBRGMSG_LETR_CODE	VARCHAR2(15)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
RBRGMSG_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RBRGMSG_MESG_CODE	RTVMESG_CODE	RTVMESG
RBRGMSG_BGRP_CODE	RTVBGRP_CODE	RTVBGRP
RBRGMSG_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_RBRGMSG	Unique	RBRGMSG_AIDY_CODE
PK_RBRGMSG	Unique	RBRGMSG_BGRP_CODE
PK_RBRGMSG	Unique	RBRGMSG_MESG_CODE

Comments

Source Code Comments

Budget Group Message Rules Table

Columns Comments for RBRGMSG_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 RBRGMSG_BGRP_CODE (2)

Source Code Comments

BUDGET GROUP CODE: The budget group code that is associated with the message and letter codes.

Columns Comments for RBRGMSG_MESG_CODE (3)

Source Code Comments

MESSAGE CODE: The code for the message that is associated with the budget group and letter code.

Columns Comments for RBRGMSG_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for RBRGMSG_LETR_CODE (5)

Source Code Comments

LETTER CODE: The letter code that is associated with a particular budget group and message code.

Table RBRMIXD

Schema Name FAISMGR
Label RBRMIXD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RBRMIXD_AIDY_CODE	RBRMIXD_AIDY_CODE	VARCHAR2(4)	No	*	*
RBRMIXD_PIDM	RBRMIXD_PIDM	NUMBER(8,0)	No	*
RBRMIXD_BGRP_CODE	RBRMIXD_BGRP_CODE	VARCHAR2(6)	No	*	*
RBRMIXD_PCT	RBRMIXD_PCT	NUMBER(6,3)	No
RBRMIXD_ACTIVITY_DATE	RBRMIXD_ACTIVITY_DATE	DATE	No
RBRMIXD_USER_ID	RBRMIXD_USER_ID	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RBRMIXD_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RBRMIXD_BGRP_CODE	RTVBGRP_CODE	RTVBGRP

Index

Index Name	Index Type	Column Name
PK_RBRMIXD	Unique	RBRMIXD_AIDY_CODE
PK_RBRMIXD	Unique	RBRMIXD_PIDM
PK_RBRMIXD	Unique	RBRMIXD_BGRP_CODE

Comments

Source Code Comments

Applicant Mixed Enrollment Table

Columns Comments for RBRMIXD_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 RBRMIXD_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RBRMIXD_BGRP_CODE (3)

Source Code Comments

BUDGET GROUP CODE: The budget group code associated with the percent for the student's mixed budget definition.

Columns Comments for RBRMIXD_PCT (4)

Source Code Comments

PERCENT: The percent to be applied to each component in the student's budget for the associated group code when defining a mixed budget.

Columns Comments for RBRMIXD_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for RBRMIXD_USER_ID (6)

Source Code Comments

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

Table RCRAIDY

Schema Name FAISMGR
Label RCRAIDY
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RCRAIDY_PRIORITY	RCRAIDY_PRIORITY	NUMBER(4,0)	No	*
RCRAIDY_AIDY_YEAR	RCRAIDY_AIDY_YEAR	VARCHAR2(4)	No		*
RCRAIDY_MSG_ID_1	RCRAIDY_MSG_ID_1	NUMBER(6,0)	No
RCRAIDY_MSG_ID_1_MENU	RCRAIDY_MSG_ID_1_MENU	NUMBER(6,0)	No
RCRAIDY_YEAR_1	RCRAIDY_YEAR_1	VARCHAR2(4)	No
RCRAIDY_START_DATE_1	RCRAIDY_START_DATE_1	DATE	No
RCRAIDY_END_DATE_1	RCRAIDY_END_DATE_1	DATE	No
RCRAIDY_MSG_ID_2	RCRAIDY_MSG_ID_2	NUMBER(6,0)	Yes
RCRAIDY_YEAR_2	RCRAIDY_YEAR_2	VARCHAR2(4)	Yes
RCRAIDY_START_DATE_2	RCRAIDY_START_DATE_2	DATE	Yes
RCRAIDY_END_DATE_2	RCRAIDY_END_DATE_2	DATE	Yes
RCRAIDY_SPK_DLN_START_DATE	RCRAIDY_SPK_DLN_START_DATE	DATE	Yes
RCRAIDY_SPK_DLN_END_DATE	RCRAIDY_SPK_DLN_END_DATE	DATE	Yes
RCRAIDY_APP_DLN_DATE	RCRAIDY_APP_DLN_DATE	DATE	Yes
RCRAIDY_CRED_DLN_DATE	RCRAIDY_CRED_DLN_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RCRAIDY_AIDY_YEAR	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
PK_RCRAIDY	Unique	RCRAIDY_PRIORITY

Comments

Source Code Comments

Telephone Financial Aid Award Year Table defines the award years that are available for telephone financial aid callers.

Columns Comments for RCRAIDY_PRIORITY (1)

Source Code Comments

Priority Sequence Number of Award Year in listing of years for financial aid award years available.

Columns Comments for RCRAIDY_AIDY_YEAR (2)

Source Code Comments

Host Award Year code to be used for host access during telephone Financial Aid.

Columns Comments for RCRAIDY_MSG_ID_1 (3)

Source Code Comments

VRU Message ID for the beginning term of the award year to be spoken during telephone Financial Aid.

Columns Comments for RCRAIDY_MSG_ID_1_MENU (4)

Source Code Comments

VRU Message ID for the beginning term of the award year to be spoken in menus during telephone Financial Aid.

Columns Comments for RCRAIDY_YEAR_1 (5)

Source Code Comments

Year to be spoken in association with Message ID 1.

Columns Comments for RCRAIDY_START_DATE_1 (6)

Source Code Comments

Beginning Date of the first telephone financial aid period.

Columns Comments for RCRAIDY_END_DATE_1 (7)

Source Code Comments

Ending Date of the first telephone financial aid period.

Columns Comments for RCRAIDY_MSG_ID_2 (8)

Source Code Comments

VRU Message ID for the ending term of the award year to be spoken during telephone Financial Aid.

Columns Comments for RCRAIDY_YEAR_2 (9)

Source Code Comments

Year to be spoken in association with Message ID 2.

Columns Comments for RCRAIDY_START_DATE_2 (10)

Source Code Comments

Beginning Date of the second telephone financial aid period.

Columns Comments for RCRAIDY_END_DATE_2 (11)

Source Code Comments

Ending Date of the second telephone financial aid period.

Columns Comments for RCRAIDY_SPK_DLN_START_DATE (12)

Source Code Comments

Ending date from which Financial Aid deadline information will be available.

Columns Comments for RCRAIDY_APP_DLN_DATE (14)

Source Code Comments

Deadline for financial aid applications for award year to be spoken during telephone Financial Aid.

Columns Comments for RCRAIDY_CRED_DLN_DATE (15)

Source Code Comments

Deadline for receiving credentials for Financial Applications to be spoken during telephone Financial Aid.

Table RCRAPP1

Schema Name FAISMGR
Label RCRAPP1
Server name MALDEV8_B60
Creation Date 11/06/2003 12:18:00:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RCRAPP1_AIDY_CODE	RCRAPP1_AIDY_CODE	VARCHAR2(4)	No	*	*
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	VARC