Tables and Views for FAISMGR as of 21-JUN-2004 08:23am
Date: 21-JUN-2004 Page: 1
TABLE: EXCEPTIONS
CREATOR: FAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ROW_ID ROWID 10 YES
OWNER VARCHAR2 30 YES
TABLE_NAME VARCHAR2 30 YES
CONSTRAINT VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 2
TABLE: GJBJOBS_INSTALL
CREATOR: FAISMGR
faismgr GJBJOBS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBJOBS_NAME VARCHAR2 30 NO
GJBJOBS_TITLE VARCHAR2 30 NO
GJBJOBS_ACTIVITY_DATE DATE 7 NO
GJBJOBS_SYSI_CODE VARCHAR2 2 YES
GJBJOBS_JOB_TYPE_IND VARCHAR2 1 YES
GJBJOBS_DESC VARCHAR2 240 YES
GJBJOBS_COMMAND_NAME VARCHAR2 30 YES
GJBJOBS_PRNT_FORM VARCHAR2 30 YES
GJBJOBS_PRNT_CODE VARCHAR2 30 YES
GJBJOBS_LINE_COUNT NUMBER 3 YES
GJBJOBS_VALIDATION VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 3
TABLE: GJBPDEF_INSTALL
CREATOR: FAISMGR
faismgr GJBPDEF rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDEF_JOB VARCHAR2 30 NO
GJBPDEF_NUMBER VARCHAR2 2 NO
GJBPDEF_DESC VARCHAR2 30 NO
GJBPDEF_LENGTH NUMBER 2 NO
GJBPDEF_TYPE_IND VARCHAR2 1 NO
GJBPDEF_OPTIONAL_IND VARCHAR2 1 NO
GJBPDEF_SINGLE_IND VARCHAR2 1 NO
GJBPDEF_ACTIVITY_DATE DATE 7 NO
GJBPDEF_LOW_RANGE VARCHAR2 30 YES
GJBPDEF_HIGH_RANGE VARCHAR2 30 YES
GJBPDEF_HELP_TEXT VARCHAR2 78 YES
GJBPDEF_VALIDATION VARCHAR2 30 YES
GJBPDEF_LIST_VALUES VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 4
TABLE: GJBPDFT_INSTALL
CREATOR: FAISMGR
faismgr GJBPDFT rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDFT_JOB VARCHAR2 30 NO
GJBPDFT_NUMBER VARCHAR2 2 NO
GJBPDFT_ACTIVITY_DATE DATE 7 NO
GJBPDFT_USER_ID VARCHAR2 30 YES
GJBPDFT_VALUE VARCHAR2 30 YES
GJBPDFT_JPRM_CODE VARCHAR2 15 YES
Date: 21-JUN-2004 Page: 5
TABLE: GJBPVAL_INSTALL
CREATOR: FAISMGR
faismgr GJBPVAL rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPVAL_JOB VARCHAR2 30 NO
GJBPVAL_NUMBER VARCHAR2 2 NO
GJBPVAL_VALUE VARCHAR2 30 NO
GJBPVAL_DESC VARCHAR2 30 NO
GJBPVAL_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 6
TABLE: GUBBHLP_INSTALL
CREATOR: FAISMGR
faismgr GUBBHLP rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBBHLP_FORM_NAME VARCHAR2 30 NO
GUBBHLP_BLOCK_NAME VARCHAR2 30 YES
GUBBHLP_FIELD_NAME VARCHAR2 30 YES
GUBBHLP_TEXT LONG NO
GUBBHLP_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 7
TABLE: GUBOBJS_INSTALL
CREATOR: FAISMGR
faismgr GUBOBJS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBOBJS_NAME VARCHAR2 30 NO
GUBOBJS_DESC VARCHAR2 80 NO
GUBOBJS_OBJT_CODE VARCHAR2 10 NO
GUBOBJS_SYSI_CODE VARCHAR2 2 NO
GUBOBJS_USER_ID VARCHAR2 30 NO
GUBOBJS_ACTIVITY_DATE DATE 7 NO
GUBOBJS_HELP_IND VARCHAR2 1 NO
GUBOBJS_EXTRACT_ENABLED_IND VARCHAR2 1 NO
Date: 21-JUN-2004 Page: 8
TABLE: GURAOBJ_INSTALL
CREATOR: FAISMGR
faismgr GURAOBJ rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURAOBJ_OBJECT VARCHAR2 30 NO
GURAOBJ_DEFAULT_ROLE VARCHAR2 30 NO
GURAOBJ_CURRENT_VERSION VARCHAR2 10 NO
GURAOBJ_SYSI_CODE VARCHAR2 2 NO
GURAOBJ_ACTIVITY_DATE DATE 7 NO
GURAOBJ_CHECKSUM VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 9
TABLE: GURDMOD_INSTALL
CREATOR: FAISMGR
faismgr GURDMOD rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURDMOD_CODE VARCHAR2 30 YES
GURDMOD_DATE DATE 7 YES
GURDMOD_APPLIED_BY_USER VARCHAR2 30 YES
GURDMOD_OBJECT VARCHAR2 30 YES
GURDMOD_DESC VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 10
TABLE: GURMENU_INSTALL
CREATOR: FAISMGR
faismgr GURMENU rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURMENU_NAME VARCHAR2 30 NO
GURMENU_OBJ_NAME VARCHAR2 30 NO
GURMENU_SORT_SEQ NUMBER NO
GURMENU_USER_ID VARCHAR2 30 NO
GURMENU_ACTIVITY_DATE DATE 7 NO
GURMENU_DESC VARCHAR2 80 YES
Date: 21-JUN-2004 Page: 11
TABLE: GUROPTM_INSTALL
CREATOR: FAISMGR
faismgr GUROPTM rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUROPTM_SORT_SEQ NUMBER 5 2 YES
GUROPTM_TYPE_IND VARCHAR2 1 NO
GUROPTM_FORM_NAME VARCHAR2 30 NO
GUROPTM_NAME1 VARCHAR2 30 NO
GUROPTM_NAME1_DESC VARCHAR2 60 YES
GUROPTM_NAME2 VARCHAR2 61 YES
GUROPTM_CAPACITY VARCHAR2 1 YES
GUROPTM_TRG_NAME VARCHAR2 30 YES
GUROPTM_TRG_TYPE VARCHAR2 1 YES
GUROPTM_BLOCK_VALID VARCHAR2 30 YES
GUROPTM_ACTIVITY_DATE DATE 7 YES
GUROPTM_USER_ID VARCHAR2 30 NO
GUROPTM_FORM_TO_BE_CALLED VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 12
TABLE: RBBABUD
CREATOR: FAISMGR
Applicant Budget Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RBBABUD_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc.
RBBABUD_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RBBABUD_TFC_IND VARCHAR2 1 NO 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
RBBABUD_BTYP_CODE VARCHAR2 4 NO BUDGET TYPE CODE: Code indicating which budget types
have been associated with the student applicant.
EXAMPLES: (PELL = Pell Type) (CAMP = Campus-Based
Type)
RBBABUD_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RBBABUD_SYS_IND VARCHAR2 1 NO SYSTEM/MANUAL INDICATOR: Indicator to show if the
student's budget type was assigned (M)anually or by
the (S)ystem.
RBBABUD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
Date: 21-JUN-2004 Page: 13
TABLE: RBRACMP
CREATOR: FAISMGR
Applicant Budget Component Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RBRACMP_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc.
RBRACMP_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RBRACMP_BTYP_CODE VARCHAR2 4 NO BUDGET TYPE CODE: The budget type code associated with
this particular budget component.
RBRACMP_COMP_CODE VARCHAR2 4 NO BUDGET COMPONENT CODE: The code used to identify the
source of the expense in the student's budget.
RBRACMP_AMT NUMBER 11 2 NO BUDGET COMPONENT AMOUNT: The amount of this particular
budget component.
RBRACMP_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RBRACMP_SYS_IND VARCHAR2 1 NO 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.
RBRACMP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
Date: 21-JUN-2004 Page: 14
TABLE: RBRCOMP
CREATOR: FAISMGR
Budget Component Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RBRCOMP_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc.
RBRCOMP_APRD_CODE VARCHAR2 6 NO AID PERIOD CODE: The aid period for the budget being
defined.
RBRCOMP_COMP_CODE VARCHAR2 4 NO BUDGET COMPONENT CODE: The code to identify the
component in the budget that is being defined.
RBRCOMP_AMT NUMBER 11 2 NO BUDGET COMPONENT DOLLAR AMOUNT: The amount of a
specific budget component code included in the budget
being defined.
RBRCOMP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
RBRCOMP_BTYP_CODE VARCHAR2 4 YES BUDGET TYPE CODE: The budget type code for the budget
being defined.
RBRCOMP_BGRP_CODE VARCHAR2 6 YES BUDGET GROUP CODE: The budget group code for the
budget being defined.
Date: 21-JUN-2004 Page: 15
TABLE: RBRGMSG
CREATOR: FAISMGR
Budget Group Message Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RBRGMSG_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc.
RBRGMSG_BGRP_CODE VARCHAR2 6 NO BUDGET GROUP CODE: The budget group code that is
associated with the message and letter codes.
RBRGMSG_MESG_CODE VARCHAR2 4 NO MESSAGE CODE: The code for the message that is
associated with the budget group and letter code.
RBRGMSG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
RBRGMSG_LETR_CODE VARCHAR2 15 YES LETTER CODE: The letter code that is associated with a
particular budget group and message code.
Date: 21-JUN-2004 Page: 16
TABLE: RBRGTYP
CREATOR: FAISMGR
Budget Group/Budget Type Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RBRGTYP_BGRP_CODE VARCHAR2 6 NO BUDGET GROUP CODE: The budget group code associated
with the budget type code.
RBRGTYP_BTYP_CODE VARCHAR2 4 NO BUDGET TYPE CODE: The budget type code that is
associated with the budget group code.
RBRGTYP_DEFAULT_IND VARCHAR2 1 NO DEFAULT INDICATOR: This indicates which of the
eligible budget
types for this group should be created
for the student. (In addition to the 'PELL' type if
the 'PELL' type is an eligible type for the group.)
RBRGTYP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
Date: 21-JUN-2004 Page: 17
TABLE: RBRMIXD
CREATOR: FAISMGR
Applicant Mixed Enrollment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RBRMIXD_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc.
RBRMIXD_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RBRMIXD_BGRP_CODE VARCHAR2 6 NO BUDGET GROUP CODE: The budget group code associated
with the percent for the student's mixed budget
definition.
RBRMIXD_PCT NUMBER 6 3 NO PERCENT: The percent to be applied to each component
in the student's budget for the associated group code
when defining a mixed budget.
RBRMIXD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
RBRMIXD_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
Date: 21-JUN-2004 Page: 18
TABLE: RCRAIDY
CREATOR: FAISMGR
Telephone Financial Aid Award Year Table defines the award years that are available for telephone financial aid
callers.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAIDY_PRIORITY NUMBER 4 NO Priority Sequence Number of Award Year in listing of
years for financial aid award years available.
RCRAIDY_AIDY_YEAR VARCHAR2 4 NO Host Award Year code to be used for host access during
telephone Financial Aid.
RCRAIDY_MSG_ID_1 NUMBER 6 NO VRU Message ID for the beginning term of the award
year to be spoken during telephone Financial Aid.
RCRAIDY_MSG_ID_1_MENU NUMBER 6 NO VRU Message ID for the beginning term of the award
year to be spoken in menus during telephone Financial
Aid.
RCRAIDY_YEAR_1 VARCHAR2 4 NO Year to be spoken in association with Message ID 1.
RCRAIDY_START_DATE_1 DATE 7 NO Beginning Date of the first telephone financial aid
period.
RCRAIDY_END_DATE_1 DATE 7 NO Ending Date of the first telephone financial aid
period.
RCRAIDY_MSG_ID_2 NUMBER 6 YES VRU Message ID for the ending term of the award year
to be spoken during telephone Financial Aid.
RCRAIDY_YEAR_2 VARCHAR2 4 YES Year to be spoken in association with Message ID 2.
RCRAIDY_START_DATE_2 DATE 7 YES Beginning Date of the second telephone financial aid
period.
RCRAIDY_END_DATE_2 DATE 7 YES Ending Date of the second telephone financial aid
period.
RCRAIDY_SPK_DLN_START_DATE DATE 7 YES Ending date from which Financial Aid deadline
information will be available.
RCRAIDY_SPK_DLN_END_DATE DATE 7 YES
RCRAIDY_APP_DLN_DATE DATE 7 YES Deadline for financial aid applications for award year
to be spoken during telephone Financial Aid.
RCRAIDY_CRED_DLN_DATE DATE 7 YES Deadline for receiving credentials for Financial
Applications to be spoken during telephone Financial
Aid.
Date: 21-JUN-2004 Page: 19
TABLE: RCRAPP1
CREATOR: FAISMGR
Financial Aid Application Table - Part 1
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, 1991, 1992, etc.
RCRAPP1_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRAPP1_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record. EXAMPLES: CSS, ACT-CSS
RCRAPP1_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
from the same processor/source.
RCRAPP1_CURR_REC_IND VARCHAR2 1 NO CURRENT RECORD INDICATOR: Indicates if this
application record has been flagged as the 'current'
record for processing.
RCRAPP1_CREATOR_ID VARCHAR2 30 NO APPLICATION CREATOR ID: The ID of the person who
created this application record on the database.
RCRAPP1_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RCRAPP1_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date that this
application record was created on the database.
RCRAPP1_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
RCRAPP1_COLL_CDE VARCHAR2 6 YES COLLEGE CODE: The four digit college code identifying
the school for which this application tape record was
created.
RCRAPP1_ACYR_CODE VARCHAR2 2 YES 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.
RCRAPP1_LAST_NAME VARCHAR2 16 YES LAST NAME: The student's last name as reported on the
aid application.
RCRAPP1_FIRST_NAME VARCHAR2 12 YES FIRST NAME: The student's first name as reported on
the aid application.
RCRAPP1_MI VARCHAR2 1 YES MIDDLE INITIAL: The student's middle initial as
reported on the aid application.
RCRAPP1_TITLE VARCHAR2 1 YES TITLE: The student's title. (Mr. or Miss, Ms., Mrs.)
RCRAPP1_ADDR VARCHAR2 35 YES ADDRESS: The student's number and street for their
address as reported on their aid application.
RCRAPP1_CITY VARCHAR2 21 YES CITY: The city of the student's address from the aid
application.
RCRAPP1_STAT_CODE VARCHAR2 2 YES STATE CODE: The two character postal abbreviation for
the student's state reported as part of the address.
RCRAPP1_ZIP VARCHAR2 10 YES ZIP CODE: The zip code for the student's address.
RCRAPP1_SSN_PREFIX VARCHAR2 1 YES SOCIAL SECURITY NUMBER PREFIX: A one character prefix
before the student's nine character SSN. (ACT format
only)
Date: 21-JUN-2004 Page: 20
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_SSN VARCHAR2 9 YES SOCIAL SECURITY NUMBER: The student's social security
number as reported on the aid application.
RCRAPP1_BIRTH_DATE DATE 7 YES BIRTH DATE: The student's date of birth. (In Oracle
format)
RCRAPP1_PHONE_AREA VARCHAR2 3 YES STUDENT'S PHONE NUMBER AREA CODE: The area code of the
student's home telephone number.
RCRAPP1_PHONE_NO VARCHAR2 7 YES STUDENT'S PHONE NUMBER: The student's home telephone
number without area code.
RCRAPP1_STAT_CODE_RES VARCHAR2 2 YES STATE OF LEGAL RESIDENCE: The student's state of legal
residence.
RCRAPP1_START_RES_MTH_YR VARCHAR2 4 YES START RESIDENCE DATE (MONTH/YR): The date the student
began living in his/her state of legal residence in
MMYY format.
RCRAPP1_RCPT_DATE DATE 7 YES APPLICATION RECEIPT DATE: The date that the processor
received the aid application.
RCRAPP1_REV_RCPT_DATE DATE 7 YES REVISION RECEIPT DATE: The date that the processor
received a request for revisions from the student.
RCRAPP1_ORIG_COMP_DATE DATE 7 YES ORIGINAL COMPUTE DATE: The date that the application
was originally processed by the processor.
RCRAPP1_REV_COMP_DATE DATE 7 YES REVISION COMPUTE DATE: The date that the processor
processed a revised report for the applicant.
RCRAPP1_CITZ_IND VARCHAR2 1 YES CITIZENSHIP INDICATOR: 1=U.S. Citizen, 2=Eligible
Non-Citizen, 3=None of the above, Blank= Not reported.
RCRAPP1_ALIEN_REG_NO VARCHAR2 9 YES 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'.
RCRAPP1_MRTL_STATUS VARCHAR2 1 YES MARITAL STATUS: The student's reported marital status.
RCRAPP1_HS_CDE VARCHAR2 6 YES HIGH SCHOOL CODE: The six digit code for the student's
high school.
RCRAPP1_EXP_ENROLL_STATUS VARCHAR2 1 YES EXPECTED ENROLLMENT STATUS: The student's expected
enrollment status for the school year.
RCRAPP1_YR_IN_COLL VARCHAR2 1 YES YEAR IN COLLEGE: Indicates which year in college the
student will be enrolled in during the school year.
RCRAPP1_CRSE_OF_STUDY VARCHAR2 5 YES COURSE OF STUDY: A code to indicate the student's
anticipated college major.
RCRAPP1_EXP_GRAD_MTH_YR VARCHAR2 6 YES EXPECTED GRADUATION MONTH AND YEAR: The student's
expected graduation date. (MMYY format)
RCRAPP1_DEGREE_BY_JULY VARCHAR2 1 YES 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.
RCRAPP1_MORE_THAN_3_PREV_COLL VARCHAR2 1 YES MORE THAN 3 PREVIOUS COLLEGES: Indicates whether or
not the student attended more than three previous
colleges.
RCRAPP1_NO_SCH NUMBER 1 YES NUMBER OF PREVIOUS SCHOOLS ATTENDED: The number of
schools, beyond high school, that the student has
attended.
RCRAPP1_PREV_COLL1 VARCHAR2 6 YES PREVIOUS COLLEGE #1: The school code number of the
most previously attended school since high school.
RCRAPP1_PREV_COLL2 VARCHAR2 6 YES PREVIOUS COLLEGE #2: The school code number of the
second most previously attended school since high
school.
Date: 21-JUN-2004 Page: 21
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_PREV_COLL3 VARCHAR2 6 YES PREVIOUS COLLEGE #3: The school code number of the
third most previously attended school since high
school.
RCRAPP1_DRIVER_LIC_NO VARCHAR2 20 YES DRIVER'S LICENSE NUMBER: The student's drivers license
number.
RCRAPP1_STAT_CODE_LIC VARCHAR2 2 YES STATE OF DRIVER'S LICENSE: The state that issued the
student's drivers license.
RCRAPP1_DISL_WRK VARCHAR2 1 YES DISLOCATED WORKER: Indicates if the student or spouse
has been certified as a dislocated worker by the
appropriate agency.
RCRAPP1_DISP_HME VARCHAR2 1 YES DISPLACED HOMEMAKER: Indicates if the student or
spouse is a displaced homemaker.
RCRAPP1_FAM_MEMB NUMBER 2 YES FAMILY MEMBERS: The number of people in the student's
household during the school year.
RCRAPP1_NO_IN_COLL NUMBER 1 YES NUMBER IN COLLEGE: The total number of family members
in the student's household that will attend college at
least half-time.
RCRAPP1_CASH_AMT NUMBER 7 YES CASH, SAVINGS AND CHECKING ACCOUNTS: The amount the
student currently has in cash on hand and in savings
and checking accounts.
RCRAPP1_HME_VAL NUMBER 7 YES HOME VALUE: The current market value of the student's
home.
RCRAPP1_HME_DBT NUMBER 7 YES HOME DEBT: The student's current outstanding debts
against the home.
RCRAPP1_RE_INV_VAL NUMBER 7 YES STUDENT'S REAL ESTATE AND INVESTMENTS VALUE: The
student's current market value of other real estate
and investment assets.
RCRAPP1_RE_INV_DBT NUMBER 7 YES STUDENT'S REAL ESTATE AND INVESTMENTS DEBTS: The
student's current outstanding debts against other real
estate and investment assets.
RCRAPP1_BUS_FARM_VAL NUMBER 7 YES BUSINESS AND FARM VALUE: The current market value of
the student's business and farm assets.
RCRAPP1_BUS_FARM_DBT NUMBER 7 YES BUSINESS AND FARM DEBT: The amount of the student's
outstanding debts against business and farm assets.
RCRAPP1_INCL_FARM VARCHAR2 1 YES ASSETS INCLUDE FARM: Indicates whether or not the
student's reported business/farm assets includes farm
assets.
RCRAPP1_BORN_BEFORE_1_1_XX VARCHAR2 1 YES BORN BEFORE 1-1-XX: Indicates whether or not the
student was born before Jan. 1, 19xx. The xx is 67
for the 1990-91, 68 for 1991-92, etc.
RCRAPP1_US_VET VARCHAR2 1 YES VETERAN OF THE US ARMED FORCES: Indicates if the
student is a veteran of the US Armed Forces.
RCRAPP1_WARD_OF_COURT VARCHAR2 1 YES WARD OF THE COURT INDICATOR: Indicates if the student
reported being a ward of the court or is an orphan.
RCRAPP1_HAS_LEGAL_DEPEND VARCHAR2 1 YES HAS LEGAL DEPENDENTS: Indicates whether or not the
student has legal dependents other than a spouse for
determining dependency status.
RCRAPP1_TAX_FORM_IND VARCHAR2 1 YES TAX FORM INDICATOR: Indicates which type of federal
tax return the student filed (or will file) and
whether or not the income data is estimated.
RCRAPP1_NO_EXEMPT NUMBER 2 YES NUMBER OF TAX EXEMPTIONS: The number of tax exemptions
claimed by the student on their federal tax return.
Date: 21-JUN-2004 Page: 22
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_US_INC NUMBER 6 YES ADJUSTED GROSS INCOME: The amount of AGI in the base
year reported by the student on his/her federal tax
return.
RCRAPP1_US_INC_TAX_PD NUMBER 6 YES INCOME TAX PAID: The amount of federal income taxes
paid by the student in the base year as reported on
the student's US income tax return.
RCRAPP1_INC_FR_WRK NUMBER 6 YES INCOME FROM WORK: The amount of the student's base
year income from working.
RCRAPP1_SPS_INC_FR_WRK NUMBER 6 YES SPOUSE INCOME FROM WORK: The amount of income earned
from work by the student's spouse in the base year.
RCRAPP1_SS_BENE NUMBER 6 YES SOCIAL SECURITY BENEFITS: The amount of social
security benefits received by the student (and spouse)
in the base year.
RCRAPP1_AFDC NUMBER 6 YES AID TO FAMILIES WITH DEPENDENT CHILDREN: Student's
base year income from the Aid to Families with
Dependent Children program (AFDC or ADC).
RCRAPP1_CHILD_SUPP NUMBER 6 YES CHILD SUPPORT: The student's base year income from
child support received for all children.
RCRAPP1_OTH_UNTAX_INC NUMBER 6 YES OTHER UNTAXED INCOME AND BENEFITS: The student's
reported base year other untaxed income and benefits.
RCRAPP1_MED_DEN_EXP NUMBER 6 YES MEDICAL AND DENTAL EXPENSES: The student's reported
base year medical and dental expenses not paid by
insurance.
RCRAPP1_TUIT_PD NUMBER 6 YES TUITION PAID: The amount of elementary, jr. or sr.
high school tuition expenses paid by the student in
the base year for his/her dependent children.
RCRAPP1_NO_CHILD_TUIT NUMBER 1 YES NUMBER OF CHILDREN WHO PAID TUITION: The number of
dependent children for the student who paid
elementary, jr. high, or high school tuition.
RCRAPP1_EXP_TAX_PD NUMBER 6 YES EXPECTED TAX PAID: The student's expected calendar
year taxes paid.
RCRAPP1_EXP_INC_FR_WRK NUMBER 6 YES EXPECTED INCOME FROM WORK: The student's expected
calendar year income from work.
RCRAPP1_EXP_SPS_INC_FR_WRK NUMBER 6 YES EXPECTED SPOUSE INCOME FROM WORK: The expected
calendar year income from work for the student's
spouse.
RCRAPP1_EXP_OTH_TAX_INC NUMBER 6 YES EXPECTED OTHER TAXABLE INCOME: The student's expected
calendar year other taxable income.
RCRAPP1_EXP_UNTAX_INC NUMBER 6 YES EXPECTED UNTAXED INCOME: The student's expected
calendar year nontaxable income and benefits.
RCRAPP1_EXP_SMR_INC NUMBER 6 YES EXPECTED SUMMER INCOME: The student's expected income
from work for the summer (3 months).
RCRAPP1_EXP_ACYR_INC NUMBER 6 YES EXPECTED ACADEMIC YEAR INCOME FROM WORK: The student's
expected academic year (9 months) income from wages.
RCRAPP1_EXP_SPS_SMR_INC NUMBER 6 YES EXPECTED SPOUSE SUMMER INCOME: The expected income
from work during the summer (3 months) for the
student's spouse.
RCRAPP1_EXP_SPS_ACYR_INC NUMBER 6 YES EXPECTED SPOUSE ACADEMIC YEAR INCOME: The student's
spouse's academic year (9 month) income from work.
RCRAPP1_EXP_SMR_OTH_TAX_INC NUMBER 6 YES EXPECTED SUMMER OTHER TAXABLE INCOME: The student's
expected other taxable income for the summer (3
months).
Date: 21-JUN-2004 Page: 23
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_EXP_ACYR_OTH_TAX_INC NUMBER 6 YES EXPECTED ACADEMIC YEAR OTHER TAXABLE INCOME: The
student's expected academic year (9 months) other
taxable income.
RCRAPP1_EXP_SMR_UNTAX_INC NUMBER 6 YES EXPECTED SUMMER UNTAXED INCOME: The student's expected
nontaxable income and benefits for the summer (3
months).
RCRAPP1_EXP_ACYR_UNTAX_INC NUMBER 6 YES EXPECTED ACADEMIC YEAR UNTAXED INCOME: The student's
expected academic year (9 months) nontaxable income
and benefits.
RCRAPP1_GI_DEAB_AMT NUMBER 3 YES DEPENDENTS EDUCATIONAL ASSISTANCE BENEFITS: The
monthly amount of the student's Dependents Educational
Assistance Benefits (DEAB) from the Veterans
Administration (VA).
RCRAPP1_GI_DEAB_MTH NUMBER 2 YES DEPENDENTS EDUCATIONAL ASSISTANCE BENEFITS MONTHS: The
number of months the student will receive the benefits
during the 12 month award year.
RCRAPP1_VEAP_BEN_AMT NUMBER 3 YES VEAP BENEFITS AMOUNT: The amount of monthly VA
Contributory Benefits that the student expects to
receive during the school year.
RCRAPP1_VEAP_BEN_MTH NUMBER 2 YES VEAP BENEFITS NUMBER OF MONTHS: The number of months
that the student expects to receive VA Contributory
Benefits during the school year.
RCRAPP1_OTH_VA_AMT NUMBER 4 YES OTHER VA BENEFITS AMOUNT: The amount per month from
other VA programs.
RCRAPP1_OTH_VA_MTH NUMBER 2 YES OTHER VA BENEFITS NUMBER OF MONTHS: The number of
months that the other VA benefits will be received
during the award year.
RCRAPP1_CLM_AS_TAX_EXEMPT_2YR VARCHAR2 1 YES CLAIMED AS TAX EXEMPTION IN xxxx: Indicator of whether
or not the student was claimed as a tax exemption by
his or her parents for the year two years prior to the
start of the aid year. (EX, 1990 for 1992-93)
RCRAPP1_CLM_AS_TAX_EXEMPT_1YR VARCHAR2 1 YES CLAIMED AS TAX EXEMPTION IN xxxx: Indicator of whether
or not the student was claimed as a tax exemption by
his or her parents for the year prior to the start of
the aid year. (EX. 1991 for 1992-93)
RCRAPP1_CLM_AS_TAX_EXEMPT VARCHAR2 1 YES CLAIMED AS TAX EXEMPTION IN xxxx: Indicator of whether
or not the student was or will be claimed as a tax
exemption by his or her parents for the first year of
the aid year. (EX. 1992 for 1992-93) (For married
and graduate students only.
RCRAPP1_WHEN_RCVD_AID VARCHAR2 1 YES WHEN AID WAS FIRST RECEIVED: Indicates during what
school year the student first received federal student
aid.
RCRAPP1_1985_RSRC_4000_8788 VARCHAR2 1 YES RESOURCES IN 1985 FOR 87-88 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1985 if
aid was received first in the 1987-88 school year.
RCRAPP1_1986_RSRC_4000_8788 VARCHAR2 1 YES RESOURCES IN 1986 FOR 87-88 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1986 if
aid was received first in the 1987-88 school year.
RCRAPP1_1986_RSRC_4000_8889 VARCHAR2 1 YES RESOURCES IN 1986 FOR 88-89 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1986 if
aid was received first in the 1988-89 school year.
Date: 21-JUN-2004 Page: 24
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_1987_RSRC_4000_8889 VARCHAR2 1 YES RESOURCES IN 1987 FOR 88-89 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1987 if
aid was received first in the 1988-89 school year.
RCRAPP1_1987_RSRC_4000_8990 VARCHAR2 1 YES RESOURCES IN 1987 FOR 89-90 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1987 if
aid was received first in the 1989-90 school year.
RCRAPP1_1988_RSRC_4000_8990 VARCHAR2 1 YES RESOURCES IN 1988 FOR 89-90 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1988 if
aid was received first in the 1989-90 school year.
RCRAPP1_1988_RSRC_4000_9091 VARCHAR2 1 YES RESOURCES IN 1988 FOR 90-91 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1988 if
aid was received first in the 1990-91 school year.
RCRAPP1_1989_RSRC_4000_9091 VARCHAR2 1 YES RESOURCES IN 1989 FOR 90-91 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1989 if
aid was received first in the 1990-91 school year.
RCRAPP1_NO_AID_RSRC_4000_2YR VARCHAR2 1 YES RESOURCES IN xxxx FOR NONE OF THE ABOVE: Indicates if
the student had resources of $4000 or more in the year
two years prior to the start of the aid year. (EX.
1990 for 1992-93)
RCRAPP1_NO_AID_RSRC_4000_1YR VARCHAR2 1 YES RESOURCES IN xxxx FOR NONE OF THE ABOVE: Indicates if
the student had resources of $4000 or more in the the
year prior to the first year of the aid year. (EX.
1991 for 1992-93)
RCRAPP1_LINE2_RELSHIP VARCHAR2 1 YES LINE 2 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed second on
the family members matrix. (CSS source and format
only)
RCRAPP1_LINE2_ATTEND_COLL VARCHAR2 1 YES LINE 2 ATTENDS COLLEGE: Indicates whether or not the
person listed second on the family members matrix will
attend college at least half-time. (CSS source and
format only)
RCRAPP1_LINE3_RELSHIP VARCHAR2 1 YES LINE 3 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed third on
the family members matrix. (CSS source and format
only)
RCRAPP1_LINE3_ATTEND_COLL VARCHAR2 1 YES LINE 3 ATTENDS COLLEGE: Indicates whether or not the
person listed third on the family members matrix will
attend college at least half-time. (CSS source and
format only)
RCRAPP1_LINE4_RELSHIP VARCHAR2 1 YES LINE 4 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed fourth on
the family members matrix. (CSS source and format
only)
RCRAPP1_LINE4_ATTEND_COLL VARCHAR2 1 YES LINE 4 ATTENDS COLLEGE: Indicates whether or not the
person listed fourth on the family members matrix will
attend college at least half-time. (CSS source and
format only)
RCRAPP1_LINE5_RELSHIP VARCHAR2 1 YES LINE 5 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed fifth on
the family members matrix. (CSS source and format
only)
RCRAPP1_LINE5_ATTEND_COLL VARCHAR2 1 YES LINE 5 ATTENDS COLLEGE: Indicates whether or not the
person listed fifth on the family members matrix will
attend college at least half-time. (CSS source and
format only)
Date: 21-JUN-2004 Page: 25
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_LINE6_RELSHIP VARCHAR2 1 YES LINE 6 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed sixth on
the family members matrix. (CSS source and format
only)
RCRAPP1_LINE6_ATTEND_COLL VARCHAR2 1 YES LINE 6 ATTENDS COLLEGE: Indicates whether or not the
person listed sixth on the family members matrix will
attend college at least half-time. (CSS source and
format only)
RCRAPP1_LINE7_RELSHIP VARCHAR2 1 YES LINE 7 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed seventh on
the family members matrix. (CSS source and format
only)
RCRAPP1_LINE7_ATTEND_COLL VARCHAR2 1 YES LINE 7 ATTENDS COLLEGE: Indicates whether or not the
person listed second on the family members matrix will
attend college at least half-time. (CSS source and
format only)
RCRAPP1_LINE8_RELSHIP VARCHAR2 1 YES LINE 8 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed eighth on
the family members matrix. (CSS source and format
only)
RCRAPP1_LINE8_ATTEND_COLL VARCHAR2 1 YES LINE 8 ATTENDS COLLEGE: Indicates whether or not the
person listed eighth on the family members matrix will
attend college at least half-time. (CSS source and
format only)
RCRAPP1_PAR_MRTL_STATUS VARCHAR2 1 YES PARENTS MARITAL STATUS: The marital status for the
student's parents.
RCRAPP1_PAR_OLDER_AGE NUMBER 2 YES AGE OF OLDER PARENT: The age of the older parent.
RCRAPP1_PAR_STAT_CODE_RES VARCHAR2 2 YES PARENTS STATE OF LEGAL RESIDENCE: The state of legal
residence for the student's parents.
RCRAPP1_PAR_DISL_WRK VARCHAR2 1 YES PARENTS DISLOCATED WORKER INDICATOR: Indicates whether
or not either of the student's parents are certified
as a dislocated worker.
RCRAPP1_PAR_DISP_HME VARCHAR2 1 YES PARENTS DISPLACED HOMEMAKER INDICATOR: Indicates
whether or not either of the student's parents is a
displaced homemaker.
RCRAPP1_PAR_FAM_MEMB NUMBER 2 YES PARENTS FAMILY MEMBERS: The number of family members
in the parents household.
RCRAPP1_PAR_NO_IN_COLL NUMBER 1 YES PARENTS NUMBER OF FAMILY MEMBERS IN COLLEGE: The
number of people in the parents household that will be
enrolled in college at least half-time.
RCRAPP1_PAR_CASH_AMT NUMBER 7 YES PARENTS CASH ASSETS AMOUNT: The value of cash, savings
and checking accounts reported by the student's
parents.
RCRAPP1_PAR_HME_VAL NUMBER 7 YES PARENTS HOME VALUE: The current market value of the
student's parents home.
RCRAPP1_PAR_HME_DBT NUMBER 7 YES PARENTS HOME DEBT: The current outstanding debts
against the home for the student's parents.
RCRAPP1_PAR_RE_INV_VAL NUMBER 7 YES PARENTS REAL ESTATE AND INVESTMENTS VALUE: The current
market value of other real estate and investment
assets reported by the student's parents.
RCRAPP1_PAR_RE_INV_DBT NUMBER 7 YES PARENTS REAL ESTATE AND INVESTMENTS DEBT: The current
debts against other real estate and investment assets
reported by the student's parents.
Date: 21-JUN-2004 Page: 26
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_PAR_CURR_INV_VAL NUMBER 7 YES PARENTS CURRENT INVESTMENTS VALUE: The value of
current investments reported by the student's parents.
RCRAPP1_PAR_BUS_FARM_VAL NUMBER 7 YES PARENTS BUSINESS / FARM VALUE: The value of business
and farm assets reported by the student's parents.
RCRAPP1_PAR_BUS_FARM_DBT NUMBER 7 YES PARENTS BUSINESS / FARM DEBTS: The amount of business
and farm debts reported by the student's parents.
RCRAPP1_PAR_INCL_FARM VARCHAR2 1 YES PARENTS ASSETS INCLUDE FARM ASSETS INDICATOR:
Indicates whether or not the business / farm assets
amount reported by the student's parents includes any
farm assets.
RCRAPP1_PAR_HME_YR_PURCH NUMBER 4 YES PARENTS HOME YEAR PURCHASED: The last two digits of
the year that the student's parents purchased their
home.
RCRAPP1_PAR_HME_PURCH_AMT NUMBER 7 YES PARENTS HOME PURCHASE PRICE: The amount that the
student's parents paid for their home.
RCRAPP1_PAR_DIV_SEP_REM_IND VARCHAR2 1 YES DIVORCED, SEPARATED, OR REMARRIED PARENTS INFORMATION
INDICATOR: Indicates whether or not information was
supplied by the student about divorced, separated or
remarried parents.
RCRAPP1_PAR_TAX_FORM_IND VARCHAR2 1 YES PARENTS TAX FORM INDICATOR: Indicates which federal
income tax return form the student's parents filed.
RCRAPP1_PAR_NO_EXEMPT NUMBER 2 YES PARENTS NUMBER OF EXEMPTIONS: The number of income tax
exemptions claimed by the student's parents on their
federal tax return.
RCRAPP1_PAR_US_INC NUMBER 7 YES PARENTS ADJUSTED GROSS INCOME: The amount of the AGI
in the base year reported by the student's parents on
their federal tax return.
RCRAPP1_PAR_WAGES NUMBER 6 YES PARENTS WAGES: The amount of wages, salaries, tips,
etc. in the base year reported by the student's
parents on their federal tax return.
RCRAPP1_PAR_INT_INC NUMBER 6 YES PARENTS INTEREST INCOME: The amount of interest income
received in the base year by the student's parents.
RCRAPP1_PAR_DIV_INC NUMBER 6 YES PARENTS DIVIDEND INCOME: The amount of income received
from dividends by the student's parents in the base
year.
RCRAPP1_PAR_BUS_FARM_INC NUMBER 6 YES PARENTS BUSINESS / FARM INCOME: The amount of income
the student's parents received from business, farm,
rents, royalties, partnerships, estates, trusts, etc.
in the base year.
RCRAPP1_PAR_OTH_TAX_INC NUMBER 6 YES PARENTS OTHER TAXABLE INCOME: The other taxable income
reported by the student's parents from alimony,
capital gains, pensions, annuities, etc.
RCRAPP1_PAR_ADJ_TO_INC NUMBER 6 YES PARENTS ADJUSTMENTS TO INCOME: The amount that the
parents reported as adjustments to income on their
federal tax return.
RCRAPP1_PAR_US_INC_TAX_PD NUMBER 6 YES PARENTS US INCOME TAX PAID: The amount of federal
income taxes paid in the base year reported by the
student's parents on their federal tax return.
RCRAPP1_FATH_INC_FR_WRK NUMBER 6 YES FATHER'S INCOME FROM WORK: The amount of income earned
from work by the student's father in the base year.
RCRAPP1_MOTH_INC_FR_WRK NUMBER 6 YES MOTHER'S INCOME FROM WORK: The mother's reported base
year income from work.
Date: 21-JUN-2004 Page: 27
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_PAR_SS_BENE NUMBER 6 YES PARENTS SOCIAL SECURITY BENEFITS: The social security
benefits received in the base year by the student's
parents for all household members.
RCRAPP1_PAR_AFDC NUMBER 6 YES PARENTS AFDC: The amount of AFDC (Aid to Families with
Dependent Children) received by the student's parents
in the base year.
RCRAPP1_PAR_CHILD_SUPP NUMBER 6 YES PARENTS CHILD SUPPORT: The amount of income received
by the student's parents from child support for all
children in the base year.
RCRAPP1_PAR_OTH_UNTAX_INC NUMBER 6 YES PARENTS OTHER UNTAXED INCOME: Other untaxed income
received in the base year by the student's parents.
RCRAPP1_PAR_MED_DEN_EXP NUMBER 6 YES PARENTS MEDICAL / DENTAL EXPENSES: The amount of
medical and dental expenses paid by the student's
parents in the base year that was not paid by
insurance.
RCRAPP1_PAR_TUIT_PD NUMBER 6 YES PARENTS TUITION PAID: The amount of elementary, jr.
high, and high school tuition paid by the student's
parents in the base year.
RCRAPP1_PAR_NO_CHILD_TUIT NUMBER 1 YES PARENTS NUMBER OF CHILDREN PAYING TUITION: The number
of children in the parents household that incurred
elementary, jr. high, or high school tuition
expenses.
RCRAPP1_EXP_PAR_TAX_PD NUMBER 6 YES EXPECTED PARENTS TAX PAID: The expected calendar year
taxes to be paid for the student's parents.
RCRAPP1_EXP_PAR_OTH_TAX_INC NUMBER 6 YES EXPECTED PARENTS OTHER TAXABLE INCOME: The expected
calendar year other taxable income for the student's
parents.
RCRAPP1_EXP_PAR_UNTAX_INC NUMBER 6 YES EXPECTED PARENTS UNTAXED INCOME: The expected calendar
year nontaxable income and benefits for the student's
parents.
RCRAPP1_EXP_FATH_INC_FR_WRK NUMBER 6 YES EXPECTED FATHER'S INCOME FROM WORK: The expected
calendar year income from work for the student's
father.
RCRAPP1_EXP_MOTH_INC_FR_WRK NUMBER 6 YES EXPECTED MOTHER'S INCOME FROM WORK: The expected
calendar year income from work for the student's
mother.
RCRAPP1_FED_COLL_CHOICE_1 VARCHAR2 6 YES FEDERAL COLLEGE CHOICE #1: The student's first choice
of a college to receive information from the Central
Processing System.
RCRAPP1_FED_COLL_CHOICE_2 VARCHAR2 6 YES FEDERAL COLLEGE CHOICE #2: The student's second choice
of a college to receive information from the Central
Processing System.
RCRAPP1_FED_COLL_CHOICE_3 VARCHAR2 6 YES FEDERAL COLLEGE CHOICE #3: The student's third choice
of a college to receive information from the Central
Processing System.
RCRAPP1_COLL_CHOICE_NO VARCHAR2 1 YES COLLEGE CHOICE NUMBER: Indicates whether the school
receiving the application record was the student's
first, second, third, fourth, etc. choice. (ACT
format only)
RCRAPP1_IN_DEFAULT VARCHAR2 1 YES IN DEFAULT: Indicates whether or not the student
reported being in default on an educational loan.
RCRAPP1_OWES_REFUND VARCHAR2 1 YES OWES REFUND: Indicates whether or not the student
reported owing a refund on a federal grant.
RCRAPP1_CONSIDER_FOR_STAF VARCHAR2 1 YES CONSIDERED FOR STAFFORD LOAN: Indicator as to whether
or not the student wants to be considered for a
Stafford Loan.
Date: 21-JUN-2004 Page: 28
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_BAL_ON_ALL_STAF NUMBER 5 YES BALANCE ON ALL STAFFORD LOANS: The unpaid balance on
the cumulative amount of Stafford Loans for the
student.
RCRAPP1_RECENT_STAF_BAL NUMBER 5 YES MOST RECENT STAFFORD BALANCE: The total unpaid balance
on the student's most recent Stafford Loan.
RCRAPP1_RECENT_STAF_INT_RATE VARCHAR2 1 YES MOST RECENT STAFFORD INTEREST RATE: The code for the
interest rate of the student's most recent Stafford
Loan.
RCRAPP1_RECENT_STAF_FR_MTH_YR VARCHAR2 4 YES MOST RECENT STAFFORD FROM MONTH AND YEAR: The
beginning date (month and year) of the loan period for
the student's most recent Stafford Loan.
RCRAPP1_RECENT_STAF_TO_MTH_YR VARCHAR2 4 YES MOST RECENT STAFFORD TO MONTH AND YEAR: The ending
date (month and year) of the loan period for the
student's most recent Stafford Loan.
RCRAPP1_RECENT_STAF_CLASS VARCHAR2 2 YES MOST RECENT STAFFORD CLASS: The class level code for
the student's most recently received Stafford Loan.
RCRAPP1_RQST_FA_PREF VARCHAR2 1 YES REQUESTED FINANCIAL AID PREFERENCE: A code indicating
the student's preference for loans, jobs, both, or
neither.
RCRAPP1_RQST_FA_FR_MTH_YR VARCHAR2 4 YES REQUESTED AID FROM MONTH AND YEAR: The beginning date
(month and year) of the period of time that the
student requested aid.
RCRAPP1_RQST_FA_TO_MTH_YR VARCHAR2 4 YES REQUESTED AID TO MONTH AND YEAR: The ending date
(month and year) of the period of time that the
student requested aid.
RCRAPP1_RQST_STAF_AMT NUMBER 4 YES REQUESTED STAFFORD AMOUNT: The amount that the student
wishes to borrow under the Stafford Loan program.
RCRAPP1_RQST_STAF_FA_FR_MTH_YR VARCHAR2 4 YES REQUESTED STAFFORD FROM MONTH AND YEAR: The beginning
date (month and year) of the loan period that the
student desires a Stafford Loan.
RCRAPP1_RQST_STAF_FA_TO_MTH_YR VARCHAR2 4 YES REQUESTED STAFFORD TO MONTH AND YEAR: The ending date
(month and year) of the loan period that the student
desires a Stafford Loan.
RCRAPP1_RQST_FA_SUMMER_THIS_YR VARCHAR2 1 YES REQUESTED AID FOR THE SUMMER THIS YEAR: Indicates if
the student requested aid for the summer term that
preceded the normal school year.
RCRAPP1_RQST_FA_FALL_THIS_YR VARCHAR2 1 YES REQUESTED AID FOR FALL THIS YEAR: Indicates if the
student requested aid for the fall term.
RCRAPP1_RQST_FA_WINTER_NEXT_YR VARCHAR2 1 YES REQUESTED AID FOR WINTER NEXT YEAR: Indicates if the
student requested aid for the winter term.
RCRAPP1_RQST_FA_SPRING_NEXT_YR VARCHAR2 1 YES REQUESTED AID FOR SPRING NEXT YEAR: Indicates if the
student requested aid for the spring term.
RCRAPP1_RQST_FA_SUMMER_NEXT_YR VARCHAR2 1 YES REQUESTED AID FOR SUMMER NEXT YEAR: Indicates if the
student requested aid for the summer term following
the normal school year.
RCRAPP1_RQST_FA_OTHER VARCHAR2 1 YES REQUESTED AID FOR OTHER TERM: Indicates if the student
requested aid for a term not listed on the
application.
RCRAPP1_CLASSIFICATION VARCHAR2 1 YES CLASSIFICATION: 1=Entering freshman, 2=Transfer
student, 3=Continuing student, 4=Former student,
Blank=No response.
RCRAPP1_EXP_WRK_HRS VARCHAR2 1 YES EXPECTED WORK HOURS: The number of hours per week that
the student expects to work off-campus during the
school year. 1=None, 2=under 10, 3=11 to 25, 4=26 to
34, 5=35 or more. From ACT application only.
Date: 21-JUN-2004 Page: 29
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_INST_HOUS_CDE VARCHAR2 1 YES INSTITUTIONAL HOUSING CODE: The housing code reported
by the student applicant for the school that is
receiving this application record.
RCRAPP1_COLL_CDE_1 VARCHAR2 6 YES COLLEGE CODE 1: The first college/program code listed
by the student on the aid application for receipt of
information.
RCRAPP1_HOUS_CDE_1 VARCHAR2 1 YES HOUSING CODE 1: The housing code for the school listed
first on the application indicating the student's
expected place of residence at school.
RCRAPP1_COLL_CDE_2 VARCHAR2 6 YES COLLEGE CODE 2: The second college/program code listed
by the student on the aid application for receipt of
information.
RCRAPP1_HOUS_CDE_2 VARCHAR2 1 YES HOUSING CODE 2: The housing code for the school listed
second on the application indicating the student's
expected place of residence at school.
RCRAPP1_COLL_CDE_3 VARCHAR2 6 YES COLLEGE CODE 3: The third college/program code listed
by the student on the aid application for receipt of
information.
RCRAPP1_HOUS_CDE_3 VARCHAR2 1 YES HOUSING CODE 3: The housing code for the school listed
third on the application indicating the student's
expected place of residence at school.
RCRAPP1_COLL_CDE_4 VARCHAR2 6 YES COLLEGE CODE 4: The fourth college/program code listed
by the student on the aid application for receipt of
information.
RCRAPP1_HOUS_CDE_4 VARCHAR2 1 YES HOUSING CODE 4: The housing code for the school listed
fourth on the application indicating the student's
expected place of residence at school.
RCRAPP1_COLL_CDE_5 VARCHAR2 6 YES COLLEGE CODE 5: The fifth college/program code listed
by the student on the aid application for receipt of
information.
RCRAPP1_HOUS_CDE_5 VARCHAR2 1 YES HOUSING CODE 5: The housing code for the school listed
fifth on the application indicating the student's
expected place of residence at school.
RCRAPP1_COLL_CDE_6 VARCHAR2 6 YES COLLEGE CODE 6: The sixth college/program code listed
by the student on the aid application for receipt of
information.
RCRAPP1_HOUS_CDE_6 VARCHAR2 1 YES HOUSING CODE 6: The housing code for the school listed
sixth on the application indicating the student's
expected place of residence at school.
RCRAPP1_COLL_CDE_7 VARCHAR2 6 YES COLLEGE CODE 7: The seventh college/program code
listed by the student on the aid application for
receipt of information.
RCRAPP1_HOUS_CDE_7 VARCHAR2 1 YES HOUSING CODE 7: The housing code for the school listed
seventh on the application indicating the student's
expected place of residence at school.
RCRAPP1_COLL_CDE_8 VARCHAR2 6 YES COLLEGE CODE 8: The eighth college/program code listed
by the student on the aid application for receipt of
information.
RCRAPP1_HOUS_CDE_8 VARCHAR2 1 YES HOUSING CODE 8: The housing code for the school listed
eighth on the application indicating the student's
expected place of residence at school.
Date: 21-JUN-2004 Page: 30
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_ADDL_COLL_CDE_1 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 1: The first school code if
more than eight school codes were requested through an
original application or an additional college request.
RCRAPP1_ADDL_COLL_CDE_2 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 2: The second school code if
more than eight school codes were requested through an
original application or an additional college request.
RCRAPP1_ADDL_COLL_CDE_3 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 3: The third school code if
more than eight school codes were requested through an
original application or an additional college request.
RCRAPP1_ADDL_COLL_CDE_4 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 4: The fourth school code if
more than eight school codes were requested through an
original application or an additional college request.
RCRAPP1_ADDL_COLL_CDE_5 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 5: The fifth school code if
more than eight school codes were requested through an
original application or an additional college request.
RCRAPP1_ADDL_COLL_CDE_6 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 6: The sixth school code if
more than eight school codes were requested through an
original application or an additional college request.
RCRAPP1_ADDL_COLL_CDE_7 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 7: The seventh school code if
more than eight school codes were requested through an
original application or an additional college request.
RCRAPP1_ADDL_COLL_CDE_8 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 8: The eighth school code if
more than eight school codes were requested through an
original application or an additional college request.
RCRAPP1_EXTRA_REQUEST VARCHAR2 1 YES EXTRA REQUEST: Indicates if more than four college
codes were requested on the student's application.
(ACT format only)
RCRAPP1_REL_TO_STATE VARCHAR2 1 YES RELEASE TO STATE: Indicates whether or not the
processor sent information from the application to the
financial aid agency in the student's state.
RCRAPP1_REL_TO_US_ED VARCHAR2 1 YES RELEASE TO US DEPT. OF ED.: Indicates whether or not
the student gave permission for the processor to
release information from the application to the US
Dept. of Education.
RCRAPP1_REL_US_ED_TO_STATE VARCHAR2 1 YES RELEASE FROM US DEPT. OF ED. TO STATE: Indicates
whether or not the student gave permission for the US
Dept. of Education to release information from the
application to the financial aid agency in the
student's state.
RCRAPP1_REL_US_ED_TO_COLL VARCHAR2 1 YES RELEASE FROM US DEPT. OF ED. TO COLLEGE: Indicates
whether or not the student gave permission for the US
Dept. of Education to release application data to the
student's college.
RCRAPP1_BUS_FARM_SUPP_FILED VARCHAR2 1 YES BUSINESS/FARM SUPPLEMENT FILED: Indicator as to
whether or not the student filed a special Business
and Farm Supplement along with the application.
1=Yes, blank=No
RCRAPP1_SIGNED VARCHAR2 1 YES SIGNED BY STUDENT: Indicates if the application was
signed by the student.
RCRAPP1_SIGNED_SPS VARCHAR2 1 YES SIGNED BY SPOUSE: Indicates if the application was
signed by the student's spouse.
RCRAPP1_SIGNED_FATH VARCHAR2 1 YES SIGNED BY FATHER: Indicates if the application was
signed by the student's father.
Date: 21-JUN-2004 Page: 31
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_SIGNED_MOTH VARCHAR2 1 YES SIGNED BY MOTHER: Indicates if the application was
signed by the student's mother.
RCRAPP1_SIGNED_PAR VARCHAR2 1 YES SIGNED BY PARENT: Indicates if the application was
signed by either parent.
RCRAPP1_SIGNED_MTH_DAY VARCHAR2 4 YES SIGNATURE DATE (MONTH/DAY): The month and day that the
application was signed.
RCRAPP1_SIGNED_YR VARCHAR2 1 YES SIGNATURE DATE (YR): The year that the application was
signed.
RCRAPP1_DEPEND_AGE_0_5 NUMBER 1 YES DEPENDENTS BETWEEN AGES 0 AND 5: The number of
dependents the student has, other than a spouse,
between the ages of 0 and 5.
RCRAPP1_DEPEND_AGE_6_12 NUMBER 1 YES DEPENDENTS BETWEEN AGES 6 AND 12: The number of
dependents the student has, other than a spouse,
between the ages of 6 and 12.
RCRAPP1_DEPEND_AGE_13_PLUS NUMBER 1 YES DEPENDENTS AGES 13 AND OVER: The number of dependents
the student has, other than a spouse, ages 13 and
over.
RCRAPP1_CONT_WRK_ACYR VARCHAR2 1 YES CONTINUE WORKING DURING ACADEMIC YEAR: Indicator as to
whether or not the student intends to continue working
for the reported employer during the school year.
RCRAPP1_PERMIT_DRAFT_REG VARCHAR2 1 YES PERMIT DRAFT REGISTRATION: Indicates whether or not
the student gave permission to the processor to send
data to the Selective Service for draft registration.
RCRAPP1_PELL_REL_MSG VARCHAR2 1 YES PELL RELEASE MESSAGE: Indicates whether or not the
processor released student data from the application
to the U.S. Dept. of Ed. for a Pell Grant and other
federal aid.
RCRAPP1_ST_AGENCY_REL_MSG VARCHAR2 1 YES STATE AGENCY RELEASE RELEASE MESSAGE: Indicates if the
student gave permission for the processor to release
application data to the financial aid agency in the
student's state.
RCRAPP1_VERIFICATION_MSG VARCHAR2 1 YES VERIFICATION MESSAGE: Indicates whether or not the
student has been selected for verification by US Dept.
of Ed edits or by the institution.
RCRAPP1_VERIFICATION_PRTY VARCHAR2 4 YES VERIFICATION PRIORITY CODE: Indicates the priority of
the edits used to select the student for data
verification.
RCRAPP1_INS VARCHAR2 1 YES DEPARTMENT OF HOMELAND SECURITY (DHS): Indicates
whether or not the student's permanent resident status
has been confirmed by DHS. Prior to 2004-2005,
Immigration and Naturalization Service, INS.
RCRAPP1_SELECTIVE_SERVICE VARCHAR2 1 YES SELECTIVE SERVICE: Indicates whether or not the
student's draft registration status was confirmed by
Selective Service. (1=Confirmed, 2=Not Confirmed)
RCRAPP1_SPEC_COND_IND VARCHAR2 1 YES SPECIAL CONDITION INDICATOR: Indicates if the student
applicant has met the requirements for having the Pell
Grant Index calculated using estimated year data due
to unusual circumstances as defined by the Dept. of
Ed.
RCRAPP1_TITLE_IV_DEFAULT VARCHAR2 1 YES TITLE IV DEFAULT INDICATOR: Indicates whether or not
the student is listed as being in default on any Title
IV student loan through the national student loan
database. (1=Def/Not Elig, 2=Def/Elig, 3=Cannot
Determine)
Date: 21-JUN-2004 Page: 32
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP1_INAS_OPTION VARCHAR2 1 YES INAS OPTION: Indicates whether the last INAS
calculation performed on this record was a long (full)
or short (partial) calculation. I.E. All or some
fields in RCRAPP2/RCRAPP4 were updated.
RCRAPP1_EDE_SOURCE VARCHAR2 1 YES EDE SOURCE: Identifies which source originated the MDE
record. A=ACT, B=AFSA, C=CSS, P=PHEAA, U=USAF, X=CSX,
Z=Stage 0 Site
RCRAPP1_EDE_SPEC_COND_IND VARCHAR2 1 YES SPECIAL CONDITION/PROFESSIONAL JUDGEMENT INDICATOR:
Indicates if a request for special condition treatment
was received and if so, was it accepted. Y=Submitted,
accepted N=Submitted, rejected blank=none submitted
RCRAPP1_USED_TRANS_NO VARCHAR2 2 YES USED TRANSACTION NUMBER: The one up sequence number
assigned by the Central Processing System to this
application/correction record.
RCRAPP1_DEF_MATCH_REGION VARCHAR2 1 YES DEFAULT MATCH REGION CODE: The ED regional office to
contact for Title IV loan default status information.
4=Atlanta, 5=Chicago, 9=San Francisco, blank=none
RCRAPP1_PREV_COLL4 VARCHAR2 6 YES PREVIOUS COLLEGE #4: The school code number of the
fourth most previously attended school since high
school.
RCRAPP1_1989_RSRC_4000_9192 VARCHAR2 1 YES RESOURCES IN 1989 FOR 91-92 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1989 if
aid was received first in the 1991-92 school year.
RCRAPP1_1990_RSRC_4000_9192 VARCHAR2 1 YES RESOURCES IN 1990 FOR 91-92 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1990 if
aid was received first in the 1991-92 school year.
RCRAPP1_IN_DEF_OWE_REF VARCHAR2 1 YES IN DEFAULT OR OWE REFUND INDICATOR: 1 = Default, 2 =
Owe Refund, 3 = Both, and 4 = Neither.
RCRAPP1_PAR_SS_BENE_STU_ONLY NUMBER 6 YES SOCIAL SECURITY BENEFITS RECEIVED FOR STUDENT: The
portion of Social Security B
enefits received by the
family for the student. IM will exclude students
benef
its. EFM will include students benefits
Date: 21-JUN-2004 Page: 33
TABLE: RCRAPP2
CREATOR: FAISMGR
Financial Aid Application Table - Part 2
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc.
RCRAPP2_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRAPP2_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record. EXAMPLES: CSS, ACT, ACT-CSS
RCRAPP2_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
from the same processor/source.
RCRAPP2_MODEL_CDE VARCHAR2 1 YES MODEL CODE: Indicates if the student is (I)ndependent
or (D)ependent.
RCRAPP2_C_PAR_DATA_PRESENT VARCHAR2 1 YES 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).
RCRAPP2_C_DATA_PRESENT VARCHAR2 1 YES 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).
RCRAPP2_C_DEPEND_STATUS VARCHAR2 1 YES COMPUTED DEPENDENCY STATUS: Indicates the students
dependency status as computed by INAS or loaded from
the tape record. Uses a code from 1-8.
RCRAPP2_C_AGE NUMBER 2 YES AGE: The student's age used in all calculations.
RCRAPP2_C_MRTL_STATUS VARCHAR2 1 YES MARITAL STATUS: The computed student's marital status.
RCRAPP2_C_FAM_MEMB NUMBER 2 YES FAMILY MEMBERS: The number of people in the
independent student's household as computed by the
need analysis processor.
RCRAPP2_C_NO_IN_COLL NUMBER 1 YES 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.
RCRAPP2_C_PAR_MRTL_STATUS VARCHAR2 1 YES PARENTS' MARITAL STATUS: The parents' marital status
as used in the calculation of the PC. (CM)
RCRAPP2_C_PAR_FAM_MEMB NUMBER 2 YES PARENTS' FAMILY MEMBERS: The number of family members
in the parents' household as used in the calculation
of the PC.
RCRAPP2_C_PAR_NO_IN_COLL NUMBER 1 YES 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)
RCRAPP2_C_PAR_PAR_IN_COLL NUMBER 1 YES PARENTS' PARENTS IN COLLEGE: The number in college
that are parents of the student. (CM)
RCRAPP2_C_PAR_OTH_IN_COLL NUMBER 1 YES 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)
Date: 21-JUN-2004 Page: 34
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_C_ASSUME_YR_IN_COLL VARCHAR2 1 YES ASSUMED STUDENT'S YEAR IN COLLEGE: The year in college
used in all calculations
RCRAPP2_C_PAR_1_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type used to determine the
primary Parent Calculation. (FM)
RCRAPP2_C_PAR_1_AGI_TAX_INC NUMBER 6 YES PARENTS' ADJUSTED GROSS INCOME/TAXABLE INCOME: The
AGI/taxable income used in the calculation of the
primary parents' contribution. (CM)
RCRAPP2_C_PAR_1_TOT_UNTAX_INC NUMBER 6 YES PARENTS' TOTAL UNTAXED INCOME: The total untaxed
income used in the calculation of the primary PC.
(CM)
RCRAPP2_C_PAR_1_TOT_INC NUMBER 8 YES PARENTS' TOTAL INCOME: The total income used in the
calculation of the primary PC. (CM)
RCRAPP2_C_PAR_1_US_INC_TAX NUMBER 6 YES PARENTS' US INCOME TAXES PAID: The amount of US income
taxes paid used in the calculation of the primary PC.
(CM)
RCRAPP2_C_PAR_1_ST_OTH_TAX NUMBER 7 YES PARENTS' STATE AND OTHER TAXES PAID: The amount of
state and other taxes paid used in the calculation of
the primary PC. (CM)
RCRAPP2_C_PAR_1_FICA_TAX NUMBER 5 YES PARENTS' FICA TAX: The amount of FICA taxes used in
the calculation of the primary PC. (CM)
RCRAPP2_C_PAR_1_MED_DEN_EXP NUMBER 5 YES PARENTS' MEDICAL/DENTAL EXPENSES: The amount of
medical and dental expenses used in the calculation of
the primary PC. (CM)
RCRAPP2_C_PAR_1_SCH_TUIT NUMBER 5 YES PARENTS' ELEMENTARY/SECONDARY SCHOOL TUITION PAID: The
amount of elementary and secondary school tuition paid
used in the calculation of the primary PC. (CM)
RCRAPP2_C_PAR_1_EMP_ALLOW NUMBER 7 YES PARENTS' EMPLOYMENT ALLOWANCE: The employment
allowance used in the calculation of the primary PC.
(CM)
RCRAPP2_C_PAR_1_MNT_ALLOW NUMBER 7 YES PARENTS' STANDARD MAINTENANCE ALLOWANCE: The SMA used
in the calculation of the primary PC. (CM)
RCRAPP2_C_PAR_1_TOT_ALLOW NUMBER 7 YES PARENTS' TOTAL ALLOWANCES: The total allowances used
in the calculation of the primary PC. (CM)
RCRAPP2_C_PAR_1_AVAIL_DISC_INC NUMBER 7 YES PARENTS' AVAILABLE DISCRETIONARY INCOME: The available
discretionary income used in the calculation of the
primary PC. (CM)
RCRAPP2_C_PAR_1_CASH_AMT NUMBER 6 YES PARENTS' CASH AMOUNT: The amount of parents' cash,
savings and checking accounts used in the calculation
of the primary PC. (CM)
RCRAPP2_C_PAR_1_HME_VAL NUMBER 6 YES PARENTS' HOME EQUITY: The home equity used in the
calculation of the primary PC. (CM)
RCRAPP2_C_PAR_1_RE_INV_VAL NUMBER 7 YES PARENTS' REAL ESTATE/INVESTMENT EQUITY: The other real
estate and investment equity used in the calculation
of the primary PC. (CM)
RCRAPP2_C_PAR_1_ADJ_BF_NET_WTH NUMBER 7 YES PARENTS' ADJUSTED BUSINESS/FARM NET WORTH: The
adjusted business/farm net worth used in the primary
calculation of the PC. (CM)
RCRAPP2_C_PAR_1_NET_WTH NUMBER 9 YES PARENTS' NET WORTH: The net worth used in the
calculation of the primary PC. (CM)
RCRAPP2_C_PAR_1_PROT_ALLOW NUMBER 9 YES PARENTS' ASSET PROTECTION ALLOWANCE: The asset
protection allowance used in the calculation of the
primary PC. (CM)
Date: 21-JUN-2004 Page: 35
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_C_PAR_1_DISC_NET_WTH NUMBER 9 YES PARENTS' DISCRETIONARY NET WORTH: The discretionary
net worth used in the calculation of the primary PC.
(CM)
RCRAPP2_C_PAR_1_CONV_PCT NUMBER 3 1 YES PARENTS' CONVERSION PERCENT: The discretionary net
worth conversion percent used in the calculation of
the primary PC. (CM)
RCRAPP2_C_PAR_1_INC_SUPPLEMENT NUMBER 8 YES PARENTS' INCOME SUPPLEMENT: The income supplement used
in the calculation of the primary PC. (CM)
RCRAPP2_C_PAR_1_ADJ_AVAIL_INC NUMBER 8 YES PARENTS' ADJUSTED AVAILABLE INCOME: The amount of the
AAI that was used in the primary calculation of the
Parent Contribution. (CM)
RCRAPP2_C_PAR_1_TOT_CTRB NUMBER 7 YES PARENTS' TOTAL CONTRIBUTION: The total primary PC
before adjustment for the number of family members in
college. (CM)
RCRAPP2_C_PAR_1_NO_IN_COLL NUMBER 1 YES PARENTS' NUMBER IN COLLEGE: The number of people in
the parents' household who will be enrolled in college
at least half-time as used in the calculation of the
primary PC. (CM)
RCRAPP2_C_PAR_1_CTRB_FOR_STDT NUMBER 7 YES PARENTS' CONTRIBUTION FOR STUDENT: The primary parent
contribution. (CM)
RCRAPP2_C_PAR_1_CTRB_OFFL_EST VARCHAR2 1 YES PARENTS' CONTRIBUTION OFFICIAL/ESTIMATED INDICATOR:
Indicates if the primary PC is official (1) or
estimated (2).
RCRAPP2_C_PAR_1_CTRB_FR_INC NUMBER 5 YES PARENTS' CONTRIBUTION FROM INCOME: The portion of the
primary PC that came from income. (CM)
RCRAPP2_C_PAR_1_CTRB_FR_ASSET NUMBER 7 YES PARENTS' CONTRIBUTION FROM ASSETS: The portion of the
primary PC that came from assets. (CM)
RCRAPP2_C_PAR_2_ANLY_TYPE VARCHAR2 1 YES
RCRAPP2_C_PAR_2_AGI_TAX_INC NUMBER 6 YES PARENTS' ADJUSTED GROSS INCOME/TAXABLE INCOME: The
AGI/taxable income used in the calculation of the
secondary PC. (CM)
RCRAPP2_C_PAR_2_TOT_UNTAX_INC NUMBER 6 YES
RCRAPP2_C_PAR_2_TOT_INC NUMBER 8 YES
RCRAPP2_C_PAR_2_US_INC_TAX NUMBER 6 YES
RCRAPP2_C_PAR_2_ST_OTH_TAX NUMBER 5 YES
RCRAPP2_C_PAR_2_FICA_TAX NUMBER 5 YES
RCRAPP2_C_PAR_2_MED_DEN_EXP NUMBER 5 YES
RCRAPP2_C_PAR_2_SCH_TUIT NUMBER 5 YES
RCRAPP2_C_PAR_2_EMP_ALLOW NUMBER 4 YES
RCRAPP2_C_PAR_2_MNT_ALLOW NUMBER 5 YES
RCRAPP2_C_PAR_2_TOT_ALLOW NUMBER 6 YES
RCRAPP2_C_PAR_2_AVAIL_DISC_INC NUMBER 8 YES
RCRAPP2_C_PAR_2_CASH_AMT NUMBER 6 YES
RCRAPP2_C_PAR_2_HME_VAL NUMBER 7 YES
RCRAPP2_C_PAR_2_RE_INV_VAL NUMBER 7 YES
RCRAPP2_C_PAR_2_ADJ_BF_NET_WTH NUMBER 7 YES PARENTS' BUSINESS/FARM NET WORTH: The amount of
business and farm net worth used in the calculation of
the secondary PC. (CM)
RCRAPP2_C_PAR_2_NET_WTH NUMBER 8 YES
RCRAPP2_C_PAR_2_PROT_ALLOW NUMBER 5 YES
RCRAPP2_C_PAR_2_DISC_NET_WTH NUMBER 8 YES
Date: 21-JUN-2004 Page: 36
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_C_PAR_2_CONV_PCT NUMBER 3 1 YES
RCRAPP2_C_PAR_2_INC_SUPPLEMENT NUMBER 8 YES
RCRAPP2_C_PAR_2_ADJ_AVAIL_INC NUMBER 8 YES PARENTS' ADJUSTED AVAILABLE INCOME: The AAI used in
the calculation of the secondary PC. (CM)
RCRAPP2_C_PAR_2_TOT_CTRB NUMBER 6 YES
RCRAPP2_C_PAR_2_NO_IN_COLL NUMBER 4 1 YES NUMBER IN COLLEGE ADJUSTMENT (PARENT): The percentage
of adjustment to the parent contribution for differing
numbers of family members in college. Prior to 0001,
this contains the number in college as used in the
calculation of EFC.
RCRAPP2_C_PAR_2_CTRB_FOR_STDT NUMBER 5 YES
RCRAPP2_C_PAR_2_CTRB_OFFL_EST VARCHAR2 1 YES
RCRAPP2_C_PAR_2_CTRB_FR_INC NUMBER 5 YES
RCRAPP2_C_PAR_2_CTRB_FR_ASSET NUMBER 5 YES
RCRAPP2_C_1_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type used to determine the
primary Student Calculation. (FM)
RCRAPP2_C_1_AGI_TAX_INC NUMBER 6 YES ADJUSTED GROSS INCOME/TAXABLE INCOME: The student's
AGI/Taxable Income for the primary calculation. (CM)
RCRAPP2_C_1_TOT_UNTAX_INC NUMBER 6 YES TOTAL UNTAXED INCOME: The amount of total untaxed
income used in the student's primary calculation.
(CM)
RCRAPP2_C_1_TOT_INC NUMBER 7 YES TOTAL INCOME: The total income used in the student's
primary calculation. (CM)
RCRAPP2_C_1_US_INC_TAX NUMBER 5 YES US INCOME TAX PAID: The amount of US income taxes paid
used in the student's primary calculation. (CM)
RCRAPP2_C_1_ST_OTH_TAX NUMBER 7 YES STATE/OTHER TAXES: The amount of state and other taxes
used in the student's primary calculation. (CM)
RCRAPP2_C_1_FICA_TAX NUMBER 5 YES FICA TAX: The amount of FICA Tax used in the student's
primary calculation. (CM)
RCRAPP2_C_1_MED_DEN_EXP NUMBER 5 YES MEDICAL/DENTAL EXPENSES: The amount of medical and
dental expenses used in the student's primary
calculation. (CM)
RCRAPP2_C_1_SCH_TUIT NUMBER 5 YES ELEMENTARY/SECONDARY SCHOOL TUITION PAID: The amount
of elementary/secondary school tuition paid that was
used in the student's primary calculation. (CM)
RCRAPP2_C_1_EMP_ALLOW NUMBER 7 YES EMPLOYMENT ALLOWANCE: The student's employment
allowance used in the primary calculation. (CM)
RCRAPP2_C_1_MNT_ALLOW NUMBER 7 YES STANDARD MAINTENANCE ALLOWANCE: The SMA used for the
student's primary calculation. (CM)
RCRAPP2_C_1_AVAIL_TAX_INC NUMBER 6 YES AVAILABLE TAXABLE INCOME: The student's available
taxable income for the primary calculation. (CM)
RCRAPP2_C_1_AVAIL_DISC_INC NUMBER 7 YES AVAILABLE DISCRETIONARY INCOME: The student's
available discretionary income for the primary
calculation. (CM)
RCRAPP2_C_1_CASH_AMT NUMBER 6 YES CASH AMOUNT: The student's amounts in cash, savings
and checking accounts used in the primary calculation.
(CM)
RCRAPP2_C_1_HME_VAL NUMBER 6 YES HOME EQUITY: The Home Equity used in the student's
primary calculation. (CM)
RCRAPP2_C_1_RE_INV_VAL NUMBER 6 YES REAL ESTATE/INVESTMENTS VALUE: The amount of other
real estate/investment equity used in the student's
primary calculation. (CM)
Date: 21-JUN-2004 Page: 37
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_C_1_ADJ_BF_NET_WTH NUMBER 7 YES ADJUSTED BUSINESS/FARM NET WORTH: The student's
adjusted business or farm net worth for the primary
calculation. (CM)
RCRAPP2_C_1_NET_WTH NUMBER 9 YES NET WORTH: The amount of the student's net worth used
in the primary calculation. (CM)
RCRAPP2_C_1_PROT_ALLOW NUMBER 9 YES PROTECTION ALLOWANCE: The amount of the student's
asset protection allowance in the primary calculation.
RCRAPP2_C_1_DISC_NET_WTH NUMBER 9 YES DISCRETIONARY NET WORTH: The student's discretionary
net worth used in the primary calculation. (CM)
RCRAPP2_C_1_CONV_PCT NUMBER 3 1 YES CONVERSION PERCENT: The conversion percent used in the
student's primary calculation. (CM)
RCRAPP2_C_1_INC_SUPPLEMENT NUMBER 8 YES INCOME SUPPLEMENT: The amount of the income supplement
used in the student's primary calculation. (CM)
RCRAPP2_C_1_ADJ_AVAIL_INC NUMBER 8 YES ADJUSTED AVAILABLE INCOME: The student's calculated
AAI for the primary calculation. (CM)
RCRAPP2_C_1_TOT_CTRB NUMBER 7 YES TOTAL CONTRIBUTION: The total student contribution
before the number in college adjustment for the
primary calculation. (CM)
RCRAPP2_C_1_NO_IN_COLL NUMBER 1 YES NUMBER IN COLLEGE: The number of people in the
student's household that will be in college as used in
the student's primary calculation. (CM)
RCRAPP2_C_1_CTRB_FOR_STDT NUMBER 5 YES CONTRIBUTION FOR STUDENT: The Congressional
Methodology student contribution for the primary
calculation. (CM)
RCRAPP2_C_1_CTRB_OFFL_EST VARCHAR2 1 YES CONTRIBUTION OFFICIAL/ESTIMATED INDICATOR: Indicates
if the student contribution for the primary
calculation is official (1) or estimated (2). (CM)
RCRAPP2_C_1_CTRB_FR_INC NUMBER 7 YES CONTRIBUTION FROM INCOME: The student's contribution
from income for the primary calculation. (CM)
RCRAPP2_C_1_CTRB_FR_ASSET NUMBER 7 YES CONTRIBUTION FROM ASSETS: The student's contribution
from assets for the primary calculation. (CM)
RCRAPP2_C_1_VA_BEN_INCL VARCHAR2 1 YES VA BENEFITS INCLUDED INDICATOR: Indicates if VA
benefits have been included in the calculation of the
student's primary contribution. 1=Yes, 2=No (CM)
RCRAPP2_C_1_TAX_INC_CTRB NUMBER 5 YES TAXABLE INCOME CONTRIBUTION: The taxable income
contribution for single independent students for the
primary calculation. (CM)
RCRAPP2_C_1_TOT_ALLOW NUMBER 7 YES TOTAL ALLOWANCES: The amount of total allowances used
in the student's primary calculation. (CM)
RCRAPP2_C_1_CALC_AVAIL_INC NUMBER 7 YES CALCULATED AVAILABLE INCOME: The student's calculated
available income for the primary calculation. (CM)
RCRAPP2_C_2_ANLY_TYPE VARCHAR2 1 YES
RCRAPP2_C_2_AGI_TAX_INC NUMBER 6 YES
RCRAPP2_C_2_TOT_UNTAX_INC NUMBER 6 YES
RCRAPP2_C_2_TOT_INC NUMBER 7 YES
RCRAPP2_C_2_US_INC_TAX NUMBER 5 YES
RCRAPP2_C_2_ST_OTH_TAX NUMBER 5 YES
RCRAPP2_C_2_FICA_TAX NUMBER 5 YES
RCRAPP2_C_2_MED_DEN_EXP NUMBER 5 YES
RCRAPP2_C_2_SCH_TUIT NUMBER 5 YES
RCRAPP2_C_2_EMP_ALLOW NUMBER 4 YES
Date: 21-JUN-2004 Page: 38
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_C_2_MNT_ALLOW NUMBER 5 YES
RCRAPP2_C_2_AVAIL_TAX_INC NUMBER 6 YES
RCRAPP2_C_2_AVAIL_DISC_INC NUMBER 7 YES
RCRAPP2_C_2_CASH_AMT NUMBER 6 YES
RCRAPP2_C_2_HME_VAL NUMBER 6 YES
RCRAPP2_C_2_RE_INV_VAL NUMBER 6 YES
RCRAPP2_C_2_ADJ_BF_NET_WTH NUMBER 7 YES
RCRAPP2_C_2_NET_WTH NUMBER 8 YES
RCRAPP2_C_2_PROT_ALLOW NUMBER 5 YES
RCRAPP2_C_2_DISC_NET_WTH NUMBER 8 YES
RCRAPP2_C_2_CONV_PCT NUMBER 3 1 YES
RCRAPP2_C_2_INC_SUPPLEMENT NUMBER 8 YES
RCRAPP2_C_2_ADJ_AVAIL_INC NUMBER 8 YES
RCRAPP2_C_2_TOT_CTRB NUMBER 5 YES
RCRAPP2_C_2_NO_IN_COLL NUMBER 4 1 YES NUMBER IN COLLEGE ADJUSTMENT (STUDENT): The percentage
of adjustment to the student contribution for
differing numbers of family members in college. Prior
to 0001, this contains the number in college as used
in the calculation of EFC.
RCRAPP2_C_2_CTRB_FOR_STDT NUMBER 5 YES
RCRAPP2_C_2_CTRB_OFFL_EST VARCHAR2 1 YES
RCRAPP2_C_2_CTRB_FR_INC NUMBER 6 YES
RCRAPP2_C_2_CTRB_FR_ASSET NUMBER 5 YES
RCRAPP2_C_2_VA_BEN_INCL VARCHAR2 1 YES
RCRAPP2_C_2_TAX_INC_CTRB NUMBER 5 YES
RCRAPP2_C_2_TOT_ALLOW NUMBER 6 YES
RCRAPP2_C_2_CALC_AVAIL_INC NUMBER 7 YES
RCRAPP2_C_1_TOT_FAM_CTRB NUMBER 6 YES TOTAL FAMILY CONTRIBUTION: This is the primary TFC
loaded in from AFSA/EDE records which replaces the
student/parent contributions. (CM)
RCRAPP2_C_1_TFC_OFFL_EST VARCHAR2 1 YES TOTAL FAMILY CONTRIBUTION OFFICIAL/ESTIMATE INDICATOR:
Indicates if the TFC (not the field labeled as
'Total') is official (1) or is estimated (2) for the
primary calculation. (CM)
RCRAPP2_C_2_TOT_FAM_CTRB NUMBER 6 YES
RCRAPP2_C_2_TFC_OFFL_EST VARCHAR2 1 YES
RCRAPP2_PELL_P_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type for the primary
system PGI. (Parent share)
RCRAPP2_PELL_P_AGI_TAX_INC NUMBER 6 YES
RCRAPP2_PELL_P_TOT_UNTAX_INC NUMBER 6 YES
RCRAPP2_PELL_P_TOT_INC NUMBER 7 YES
RCRAPP2_PELL_P_US_INC_TAX NUMBER 6 YES
RCRAPP2_PELL_P_ST_OTH_TAX NUMBER 5 YES
RCRAPP2_PELL_P_MED_DEN_EXP NUMBER 5 YES
RCRAPP2_PELL_P_SCH_TUIT NUMBER 5 YES
RCRAPP2_PELL_P_EMP_ALLOW NUMBER 4 YES
RCRAPP2_PELL_P_MNT_ALLOW NUMBER 5 YES
RCRAPP2_PELL_P_TOT_ALLOW NUMBER 6 YES
RCRAPP2_PELL_P_AVAIL_DISC_INC NUMBER 6 YES
RCRAPP2_PELL_P_CASH_AMT NUMBER 6 YES
Date: 21-JUN-2004 Page: 39
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_PELL_P_HME_VAL NUMBER 6 YES
RCRAPP2_PELL_P_RE_INV_VAL NUMBER 7 YES
RCRAPP2_PELL_P_ADJ_BF_NET_WTH NUMBER 7 YES
RCRAPP2_PELL_P_NET_WTH NUMBER 8 YES
RCRAPP2_PELL_P_PROT_ALLOW NUMBER 6 YES
RCRAPP2_PELL_P_DISC_NET_WTH NUMBER 8 YES
RCRAPP2_PELL_P_CONV_PCT NUMBER 3 1 YES
RCRAPP2_PELL_P_TOT_CTRB NUMBER 5 YES
RCRAPP2_PELL_P_NO_IN_COLL NUMBER 1 YES
RCRAPP2_PELL_P_CTRB_FOR_STDT NUMBER 5 YES
RCRAPP2_PELL_P_CTRB_OFFL_EST VARCHAR2 1 YES
RCRAPP2_PELL_P_CTRB_FR_INC NUMBER 5 YES
RCRAPP2_PELL_P_CTRB_FR_ASSET NUMBER 5 YES
RCRAPP2_PELL_P_2_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type for the secondary
system Pell PGI. (Parent share)
RCRAPP2_PELL_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type for the primary
system Pell PGI. (Student share)
RCRAPP2_PELL_AGI_TAX_INC NUMBER 6 YES
RCRAPP2_PELL_TOT_UNTAX_INC NUMBER 6 YES
RCRAPP2_PELL_TOT_INC NUMBER 7 YES
RCRAPP2_PELL_US_INC_TAX NUMBER 5 YES
RCRAPP2_PELL_ST_OTH_TAX NUMBER 5 YES
RCRAPP2_PELL_MED_DEN_EXP NUMBER 5 YES
RCRAPP2_PELL_SCH_TUIT NUMBER 5 YES
RCRAPP2_PELL_EMP_ALLOW NUMBER 4 YES
RCRAPP2_PELL_MNT_ALLOW NUMBER 5 YES
RCRAPP2_PELL_TOT_ALLOW NUMBER 6 YES
RCRAPP2_PELL_AVAIL_DISC_INC NUMBER 6 YES
RCRAPP2_PELL_CASH_AMT NUMBER 6 YES
RCRAPP2_PELL_HME_VAL NUMBER 6 YES
RCRAPP2_PELL_RE_INV_VAL NUMBER 6 YES
RCRAPP2_PELL_ADJ_BF_NET_WTH NUMBER 7 YES
RCRAPP2_PELL_NET_WTH NUMBER 8 YES
RCRAPP2_PELL_PROT_ALLOW NUMBER 6 YES
RCRAPP2_PELL_DISC_NET_WTH NUMBER 8 YES
RCRAPP2_PELL_CONV_PCT NUMBER 3 1 YES
RCRAPP2_PELL_TOT_CTRB NUMBER 5 YES
RCRAPP2_PELL_NO_IN_COLL NUMBER 1 YES
RCRAPP2_PELL_CTRB_FOR_STDT NUMBER 5 YES
RCRAPP2_PELL_CTRB_OFFL_EST VARCHAR2 1 YES
RCRAPP2_PELL_CTRB_FR_INC NUMBER 5 YES
RCRAPP2_PELL_CTRB_FR_ASSET NUMBER 5 YES
RCRAPP2_PELL_PGI NUMBER 5 YES PELL SYSTEM PGI: The primary system Pell PGI.
RCRAPP2_PELL_PGI_OFFL_EST VARCHAR2 1 YES PELL PGI OFFICIAL/ESTIMATED INDICATOR: Indicates if
the primary system Pell PGI is official (1) or
estimated (2).
RCRAPP2_PELL_2_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type for the secondary
system PGI. (Student share)
RCRAPP2_PELL_2_PGI NUMBER 5 YES SECONDARY PELL GRANT INDEX: The secondary system PGI.
RCRAPP2_PELL_2_PGI_OFFL_EST VARCHAR2 1 YES PELL GRANT INDEX OFFICIAL/ESTIMATED INDICATOR:
Indicates if the secondary system PGI is official (1)
or estimated (2).
Date: 21-JUN-2004 Page: 40
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_IM_BUDG_LENGTH NUMBER 2 YES BUDGET LENGTH: The budget length used in the
institutional methodology formulas.
RCRAPP2_IM_1_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type used for the primary
SC. (IM)
RCRAPP2_IM_1_SC NUMBER 5 YES STUDENT CONTRIBUTION: The primary institutional
methodology student contribution.
RCRAPP2_IM_1_PAR_ANLY_TYPE VARCHAR2 1 YES PARENTS' ANALYSIS TYPE: The analysis type used for the
primary PC. (IM)
RCRAPP2_IM_1_PC NUMBER 5 YES PARENT CONTRIBUTION: The primary institutional
methodology parent contribution.
RCRAPP2_IM_1_UNASSESSED_VA NUMBER 5 YES UNASSESSED VA BENEFITS: The unassessed VA benefits
used in the primary IM student contribution
calculation.
RCRAPP2_IM_1_TFC NUMBER 6 YES TOTAL FAMILY CONTRIBUTION: The primary institutional
methodology TFC.
RCRAPP2_IM_2_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type used for the
secondary institutional methodology SC.
RCRAPP2_IM_2_SC NUMBER 5 YES STUDENT CONTRIBUTION: The secondary institutional
methodology SC.
RCRAPP2_IM_2_PAR_ANLY_TYPE VARCHAR2 1 YES ANALYSIS TYPE: The analysis type used for the
secondary institutional methodology parent
contribution.
RCRAPP2_IM_2_PC NUMBER 5 YES PARENT CONTRIBUTION: The secondary institutional
methodology PC.
RCRAPP2_IM_2_UNASSESSED_VA NUMBER 5 YES UNASSESSED VA BENEFITS: The amount of unassessed VA
benefits used in the secondary calculation of SC.
RCRAPP2_INAS_CTR NUMBER 2 YES INAS COUNTER: The counter for the number of times an
INAS calculation has been run locally for a student.
Stops counting at 9. May be reset to 0 on RNAOVRD
Form.
RCRAPP2_RQST_SLS_AMT NUMBER 4 YES REQUESTED SLS AMOUNT: The amount that the student
requests to borrow from the SLS program.
RCRAPP2_DEFER_SLS_PMTS VARCHAR2 1 YES DEFER SLS PAYMENTS: Indicates if the student chooses
to defer principal payments on an SLS loan while
enrolled.
RCRAPP2_SLS_INTS_PMTS VARCHAR2 1 YES SLS INTEREST PAYMENTS: This indicates the student's
choice as to the treatment of SLS interest payments
while enrolled. 1=Accrue:Capitalize, 2=Periodic
Installment Payments
RCRAPP2_BAL_ON_ALL_SLS NUMBER 5 YES BALANCE ON ALL SLS LOANS: The current outstanding
balance on all SLS loans.
RCRAPP2_RECENT_SLS_BAL NUMBER 5 YES RECENT BALANCE ON SLS LOANS: The current outstanding
balance on the most recent SLS loan taken out by the
student.
RCRAPP2_RECENT_SLS_FR_MTH_YR VARCHAR2 4 YES RECENT SLS FROM DATE: The beginning date (month/year)
for the loan period of the student's most recent SLS
loan.
RCRAPP2_RECENT_SLS_CLASS VARCHAR2 2 YES RECENT SLS CLASS YEAR: The class year of the student
for which the most recent SLS loan was processed.
RCRAPP2_LENDER_CODE VARCHAR2 6 YES LENDER CODE: A code identifying the student's lender.
RCRAPP2_DEGREE_SOUGHT VARCHAR2 1 YES DEGREE SOUGHT: Student's current postsecondary
degree/certificate objective. (1=Cert.,
2=AA/Transfer, 3=1st Bach, 4=2nd Bach, 5=Teacher
Cred., 6=Grad/Prof, 7=Other) (ACT Format Only)
Date: 21-JUN-2004 Page: 41
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_DRUG_ABUSE VARCHAR2 1 YES DRUG ABUSE INDICATOR: Indicates whether student
application on hold because of prior drug abuse.
(1=Hold File-Released, 2=Hold File)
RCRAPP2_ELIGIBILITY_MSG VARCHAR2 1 YES U.S.E.D. ELIGIBILITY STATUS MESSAGE: 1= (C)heck it
out. The result of data base matches indicates
further investigation by the aid administrator needed.
RCRAPP2_EPS_CDE VARCHAR2 4 YES ENROLLMENT PLANNING SERVICE: The EPS Marketing code
based on the student's zip code. Used to provide a
standard geographic region code for use in planning
and research. (CSS formats only)
RCRAPP2_HS_GRADUATE VARCHAR2 1 YES HIGH SCHOOL GRADUATE: Indicates if the student will be
a high school graduate or will have a GED by Sept. 1
of the first year of the aid year. (ACT only)
RCRAPP2_ORIG_RCPT_DATE DATE 7 YES ORIGINAL FAF RECEIPT DATE: The date that CSS initially
received the FAF/SAAC. (ORACLE Format date)
RCRAPP2_DUR_ELIG_OVRD_IND VARCHAR2 1 YES DURATION OF ELIGIBILITY OVERRIDE INDICATOR: Indicates
if the 5 year Pell Grant limit has been overridden for
the student. Also used as an EDE Stage 2 input field
to report to the CPS that you are requesting an
override.
RCRAPP2_C_1_UNADJ_BUS_NET NUMBER 7 YES UNADJUSTED BUSINESS NET: The student's bussiness net
worth for the primary calculation. (FM)
RCRAPP2_C_1_UNADJ_FARM_NET NUMBER 7 YES UNADJUSTED FARM NET: The student's farm net worth for
the primary calculation. (FM)
RCRAPP2_C_PAR_1_UNADJ_BUS_NET NUMBER 7 YES PARENTS' UNADJUSTED BUSINESS NET: The parents'
unadjusted business net worth used in the primary
calculation. (FM)
RCRAPP2_C_PAR_1_UNADJ_FARM_NET NUMBER 7 YES PARENTS' UNADJUSTED FARM NET: The parents' unadjusted
farm net worth used in theprimary calculation. (FM)
RCRAPP2_C_PAR_2_CALC_AVAIL_INC NUMBER 7 YES PARENTS' CALCULATED AVAILABLE INCOME: The parents'
calculated available income used in the secondary
calculation (FM).
RCRAPP2_C_PAR_2_UNADJ_BUS_NET NUMBER 7 YES PARENTS' UNADJUSTED BUSINESS NET: The parents'
unadjusted business net worth used in the secondary
calculation (FM).
RCRAPP2_C_PAR_2_UNADJ_FARM_NET NUMBER 7 YES PARENTS' UNADJUSTED FARM NET: The parents' unadjusted
farm net worth used in thesecondary calculation (FM).
RCRAPP2_FM_INST_1_FED_EFC NUMBER 5 YES BUDGET 1 - FEDERAL EFFECTIVE FAMILY CONTRIBUTION: The
amount of federal EFC estimated for budget number 1.
RCRAPP2_FM_INST_1_FED_ELIG NUMBER 5 YES BUDGET 1 - FEDERAL ELIGIBILITY: The amount of federal
eligibility estimated for budget number 1.
RCRAPP2_FM_INST_1_VA_BEN NUMBER 5 YES BUDGET 1 - VETERANS BENEFITS: The amount of veterans
benefits estimated for budget number 1.
RCRAPP2_FM_INST_2_FED_EFC NUMBER 5 YES BUDGET 2 - FEDERAL EFFECTIVE FAMILY CONTRIBUTION: The
amount of federal EFC estimated for budget number 2.
RCRAPP2_FM_INST_2_FED_ELIG NUMBER 5 YES BUDGET 2 - FEDERAL ELIGIBILITY: The amount of federal
eligibility estimated for budget number 2.
RCRAPP2_FM_INST_2_VA_BEN NUMBER 5 YES BUDGET 2 - VETERANS BENEFITS: The amount of veterans
benefits estimated for budget number 2.
RCRAPP2_FM_INST_3_FED_EFC NUMBER 5 YES BUDGET 3 - FEDERAL EFFECTIVE FAMILY CONTRIBUTION: The
amount of federal EFC estimated for budget number 3.
Date: 21-JUN-2004 Page: 42
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP2_FM_INST_3_FED_ELIG NUMBER 5 YES BUDGET 3 - FEDERAL ELIGIBILITY: The amount of federal
eligibility estimated for budget number 3.
RCRAPP2_FM_INST_3_VA_BEN NUMBER 5 YES BUDGET 3 - VETERANS BENEFITS: The amount of veterans
benefits estimated for budget number 3.
RCRAPP2_CM2_IM_CALC_IND VARCHAR2 1 YES CALCULATED INDICATOR: contains an 'I' value for the
1993-94 aid year and later. This indicates that
student/parents FAFNAR column II values will represent
the values used in IM. A blank indicates the
secondary FM (previously called CM)
Date: 21-JUN-2004 Page: 43
TABLE: RCRAPP3
CREATOR: FAISMGR
Financial Aid Application Table - Part 3
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP3_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc.
RCRAPP3_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRAPP3_INFC_CODE VARCHAR2 7 NO
RCRAPP3_SEQ_NO NUMBER 3 NO
RCRAPP3_C_INST_1_UNASSESS_VA NUMBER 5 YES
RCRAPP3_C_INST_2_UNASSESS_VA NUMBER 5 YES
RCRAPP3_C_INST_3_UNASSESS_VA NUMBER 5 YES
RCRAPP3_C_1_ALT_CTRB NUMBER 5 YES
RCRAPP3_C_2_ALT_CTRB NUMBER 5 YES
RCRAPP3_PELL_1_ALT_CTRB NUMBER 5 YES
RCRAPP3_PELL_2_ALT_CTRB NUMBER 5 YES
RCRAPP3_C_PAR_1_ALT_CTRB NUMBER 5 YES
RCRAPP3_C_PAR_2_ALT_CTRB NUMBER 5 YES
RCRAPP3_PELL_1_ALT_PGI NUMBER 5 YES
RCRAPP3_PELL_2_ALT_PGI NUMBER 5 YES
RCRAPP3_PAR_1_ALT_AGI NUMBER 6 YES
RCRAPP3_PAR_2_ALT_AGI NUMBER 6 YES
RCRAPP3_PAR_ALT_MRTL_STATUS VARCHAR2 1 YES
RCRAPP3_PAR_ALT_FAM_SIZE NUMBER 2 YES
RCRAPP3_PAR_ALT_NO_IN_COLL VARCHAR2 1 YES
RCRAPP3_ALT_OPT_LOSS_TO_ZERO VARCHAR2 1 YES
RCRAPP3_ALT_OPT_HME_VAL VARCHAR2 1 YES
RCRAPP3_ALT_OPT_PAR_IN_COLL VARCHAR2 1 YES
RCRAPP3_MSG_91 VARCHAR2 1 YES
RCRAPP3_MSG_91_BUDG_1 VARCHAR2 5 YES
RCRAPP3_MSG_91_BUDG_2 VARCHAR2 5 YES
RCRAPP3_MSG_91_BUDG_3 VARCHAR2 5 YES
RCRAPP3_MSG_73_TAX VARCHAR2 5 YES
RCRAPP3_C_1_CTRB_ADJ_1_8_MTH NUMBER 5 YES
RCRAPP3_C_2_CTRB_ADJ_1_8_MTH NUMBER 5 YES
RCRAPP3_C_1_CTRB_ADJ_OVR_9_MTH NUMBER 5 YES
RCRAPP3_C_2_CTRB_ADJ_OVR_9_MTH NUMBER 5 YES
RCRAPP3_REJ_REASON_PRTY_1 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_2 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_3 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_4 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_5 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_6 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_7 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_8 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_9 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_10 VARCHAR2 2 YES
Date: 21-JUN-2004 Page: 44
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP3_REJ_REASON_PRTY_11 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_12 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_13 VARCHAR2 2 YES
RCRAPP3_REJ_REASON_PRTY_14 VARCHAR2 2 YES
RCRAPP3_REJ_IN_ANALYSIS_FLAG VARCHAR2 1 YES
RCRAPP3_MSG_0 VARCHAR2 1 YES
RCRAPP3_MSG_1 VARCHAR2 1 YES
RCRAPP3_MSG_2 VARCHAR2 1 YES
RCRAPP3_MSG_3 VARCHAR2 1 YES
RCRAPP3_MSG_4 VARCHAR2 1 YES
RCRAPP3_MSG_5 VARCHAR2 1 YES
RCRAPP3_MSG_6 VARCHAR2 1 YES
RCRAPP3_MSG_11 VARCHAR2 1 YES
RCRAPP3_MSG_12 VARCHAR2 1 YES
RCRAPP3_MSG_13 VARCHAR2 1 YES
RCRAPP3_MSG_14 VARCHAR2 1 YES
RCRAPP3_MSG_15 VARCHAR2 1 YES
RCRAPP3_MSG_21 VARCHAR2 1 YES
RCRAPP3_MSG_22 VARCHAR2 1 YES
RCRAPP3_MSG_23 VARCHAR2 1 YES
RCRAPP3_MSG_24 VARCHAR2 1 YES
RCRAPP3_MSG_26 VARCHAR2 1 YES
RCRAPP3_MSG_27 VARCHAR2 1 YES
RCRAPP3_MSG_28 VARCHAR2 1 YES
RCRAPP3_MSG_29 VARCHAR2 1 YES
RCRAPP3_MSG_30 VARCHAR2 1 YES
RCRAPP3_MSG_32 VARCHAR2 1 YES
RCRAPP3_MSG_33 VARCHAR2 1 YES
RCRAPP3_MSG_34 VARCHAR2 1 YES
RCRAPP3_MSG_46 VARCHAR2 1 YES
RCRAPP3_MSG_47 VARCHAR2 1 YES
RCRAPP3_MSG_48 VARCHAR2 1 YES
RCRAPP3_MSG_49 VARCHAR2 1 YES
RCRAPP3_MSG_50 VARCHAR2 1 YES
RCRAPP3_MSG_61 VARCHAR2 1 YES
RCRAPP3_MSG_62 VARCHAR2 1 YES
RCRAPP3_MSG_63 VARCHAR2 1 YES
RCRAPP3_MSG_64 VARCHAR2 1 YES
RCRAPP3_MSG_65 VARCHAR2 1 YES
RCRAPP3_MSG_66 VARCHAR2 1 YES
RCRAPP3_MSG_67 VARCHAR2 1 YES
RCRAPP3_MSG_68 VARCHAR2 1 YES
RCRAPP3_MSG_71 VARCHAR2 1 YES
RCRAPP3_MSG_73 VARCHAR2 1 YES
RCRAPP3_MSG_74 VARCHAR2 1 YES
RCRAPP3_MSG_75 VARCHAR2 1 YES
RCRAPP3_MSG_76 VARCHAR2 1 YES
RCRAPP3_MSG_77 VARCHAR2 1 YES
RCRAPP3_MSG_78 VARCHAR2 1 YES
RCRAPP3_MSG_79 VARCHAR2 1 YES
Date: 21-JUN-2004 Page: 45
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP3_MSG_80 VARCHAR2 1 YES
RCRAPP3_MSG_81 VARCHAR2 1 YES
RCRAPP3_MSG_82 VARCHAR2 1 YES
RCRAPP3_MSG_90 VARCHAR2 1 YES
RCRAPP3_MSG_92 VARCHAR2 1 YES
RCRAPP3_MSG_93 VARCHAR2 1 YES
RCRAPP3_MSG_94 VARCHAR2 1 YES
RCRAPP3_MSG_95 VARCHAR2 1 YES
RCRAPP3_MSG_96 VARCHAR2 1 YES
RCRAPP3_MSG_97 VARCHAR2 1 YES
RCRAPP3_MSG_98 VARCHAR2 1 YES
RCRAPP3_MSG_99 VARCHAR2 1 YES
RCRAPP3_MSG_11_PAR_FAM_MEMB VARCHAR2 1 YES
RCRAPP3_MSG_12_PAR_NO_IN_COLL VARCHAR2 1 YES
RCRAPP3_MSG_22_PAR_DER_AGI NUMBER 6 YES
RCRAPP3_MSG_27_VAL NUMBER 6 YES
RCRAPP3_MSG_47_PAR_HME_VAL NUMBER 6 YES
RCRAPP3_MSG_48_PAR_HME_VAL_3 NUMBER 6 YES
RCRAPP3_MSG_48_PAR_HME_EQTY_3 NUMBER 6 YES
RCRAPP3_MSG_49_PAR_HME_VAL NUMBER 6 YES
RCRAPP3_MSG_49_PAR_HME_EQTY NUMBER 6 YES
RCRAPP3_MSG_63_FAM_MEMB VARCHAR2 1 YES
RCRAPP3_MSG_64_NO_IN_COLL VARCHAR2 1 YES
RCRAPP3_MSG_81_AVAIL_INC NUMBER 6 YES
RCRAPP3_MSG_90_INC NUMBER 4 YES
RCRAPP3_MSG_90_SMA NUMBER 4 YES
RCRAPP3_MSG_90_DIFF NUMBER 4 YES
RCRAPP3_MSG_92_BUDG_1 NUMBER 5 YES
RCRAPP3_MSG_92_BUDG_2 NUMBER 5 YES
RCRAPP3_MSG_92_BUDG_3 NUMBER 5 YES
RCRAPP3_MSG_93_CALC NUMBER 5 YES
RCRAPP3_MSG_93_RESC NUMBER 5 YES
RCRAPP3_PAR_1_ALT_FED_TAX NUMBER 6 YES
RCRAPP3_PAR_2_ALT_FED_TAX NUMBER 6 YES
RCRAPP3_MSG_0_FED_1_FAM_CTRB VARCHAR2 5 YES
RCRAPP3_MSG_0_FED_2_FAM_CTRB VARCHAR2 5 YES
RCRAPP3_MSG_0_FED_1_PGI VARCHAR2 5 YES
RCRAPP3_MSG_0_FED_2_PGI VARCHAR2 5 YES
RCRAPP3_ASSUMPTION_MSG_1 VARCHAR2 2 YES
RCRAPP3_ASSUMPTION_MSG_2 VARCHAR2 2 YES
RCRAPP3_ASSUMPTION_MSG_3 VARCHAR2 2 YES
RCRAPP3_ASSUMPTION_MSG_4 VARCHAR2 2 YES
RCRAPP3_ASSUMPTION_MSG_5 VARCHAR2 2 YES
RCRAPP3_ASSUMPTION_MSG_6 VARCHAR2 2 YES
RCRAPP3_MSG_51 VARCHAR2 1 YES
RCRAPP3_MSG_51_VAL NUMBER 6 YES
RCRAPP3_MSG_83 VARCHAR2 1 YES
RCRAPP3_MSG_84 VARCHAR2 1 YES
RCRAPP3_MSG_85 VARCHAR2 1 YES
RCRAPP3_MSG_85_VAL NUMBER 6 YES
Date: 21-JUN-2004 Page: 46
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP3_ASSUMPT_OVRD_1 VARCHAR2 1 YES ASSUMPTION OVERRIDE 1: Set by electronic application
user to override assumption 1: Parent's Number of
Family Members assumed to be 3.
RCRAPP3_ASSUMPT_OVRD_2 VARCHAR2 1 YES ASSUMPTION OVERRIDE 2: Set by electronic application
user to override assumption 2: Parent's Number of
College assumed to be 1.
RCRAPP3_ASSUMPT_OVRD_3 VARCHAR2 1 YES ASSUMPTION OVERRIDE 3: Set by electronic application
user to override assumption 3: Parent's AGI assumed
equal to sum of parent's earned income portions.
RCRAPP3_ASSUMPT_OVRD_4 VARCHAR2 1 YES ASSUMPTION OVERRIDE 4: Set by electronic application
user to override assumption 4: Student's Number of
College assumed to be 1.
RCRAPP3_ASSUMPT_OVRD_5 VARCHAR2 1 YES ASSUMPTION OVERRIDE 5: Set by electronic application
user to override assumption 5: Student's AGI assumed
equal to sum of student's and spouse's earned income
portions.
RCRAPP3_ASSUMPT_OVRD_6 VARCHAR2 1 YES ASSUMPTION OVERRIDE 6: Set by electronic application
user to override assumption 6: Student's social
security benefits assumed to be zero.
RCRAPP3_ASSUMPT_OVRD_7 VARCHAR2 1 YES ASSUMPTION OVERRIDE 7: set by electronic application
user to override assumption 7: Student's other real
estate/investment value and debt assumed to be zero.
RCRAPP3_ASSUMPT_OVRD_8 VARCHAR2 1 YES ASSUMPTION OVERRIDE 8: Set by electronic application
user to override assumption 8: Student's business
value and debt assumed to be zero.
RCRAPP3_ASSUMPT_OVRD_9 VARCHAR2 1 YES ASSUMPTION OVERRIDE 9: Set by electronic application
user to override assumption 9: Student's farm value
and debt assumed to be zero.
RCRAPP3_ATTEND_SAME_COLL VARCHAR2 1 YES ATTEND SAME COLLEGE: Indicates whether or not in
1993-94 a student plans to attend the same college
that was previously attended.
RCRAPP3_BUS_DBT NUMBER 7 YES STUDENT'S BUSINESS DEBT: Contains a student's business
value.
RCRAPP3_BUS_VAL NUMBER 7 YES STUDENT'S BUSINESS VALUE: Contains the student's
business value.
RCRAPP3_C_SIGNED VARCHAR2 1 YES STUDENT'S SIGNATURE INDICATOR: Indicates whether or
not a student's signature ison the application.
RCRAPP3_C_SIGNED_FATH VARCHAR2 1 YES FATHER'S SIGNATURE INDICATOR: Indicates whether or not
a father's signature is on the application.
RCRAPP3_C_SIGNED_MOTH VARCHAR2 1 YES MOTHER'S SIGNATURE INDICATOR: Indicates whether or not
a mother's signature is on the application.
RCRAPP3_C_SIGNED_MTH_DAY VARCHAR2 4 YES MONTH AND DAY SIGNED: Contains the month and day the
application was completed.
RCRAPP3_C_SIGNED_PAR VARCHAR2 1 YES PARENTS' SIGNATURE INDICATOR: Indicates whether or not
the parents' signatures are on the application.
RCRAPP3_C_SIGNED_SPS VARCHAR2 1 YES SPOUSE'S SIGNATURE INDICATOR: Indicates whether or not
a spouse's signature is on the application.
RCRAPP3_C_SIGNED_YR VARCHAR2 1 YES YEAR SIGNED: Contains the year the application was
completed.
RCRAPP3_CASH_CHK NUMBER 6 YES STUDENT'S CASH, SAVINGS, AND CHECKING ACCOUNTS:
Contains the amount of cash on hand, in saving and
checking accounts of the student.
Date: 21-JUN-2004 Page: 47
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP3_CHILD_CARE NUMBER 2 YES STUDENT'S CHILD CARE: Contains the number of dependent
children that a student will pay child care expenses
for in 1993-94.
RCRAPP3_CHILD_SUPP_PAID NUMBER 5 YES STUDENT'S CHILD SUPPORT PAID: Contains the amount paid
for child support by a student in 1992.
RCRAPP3_DEGREE_TYPE VARCHAR2 3 YES DEGREE TYPE: Contains the abbreviation of the degree
or certificate a student is pursuing.
RCRAPP3_EFC_MATCH VARCHAR2 1 YES EFFECTIVE FAMILY CONTRIBUTION MATCH FLAG: Indicates
whether the calculation of EFC is matched with the CPS
results.
RCRAPP3_ESTIMATE_FLAGS VARCHAR2 2 YES ACT ESTIMATE FLAGS
RCRAPP3_FAA_DEP_OVERRIDE VARCHAR2 1 YES DEPENDENCY OVERRIDE: Used by the financial aid
administrator to override dependency.
RCRAPP3_FAA_SIGNATURE VARCHAR2 1 YES FINANCIAL AID ADMINISTRATOR'S SIGNATURE: Indicates
whether the FAA Signature is on the application.
RCRAPP3_FAA_TITLE_IV_CODE VARCHAR2 6 YES TITLE IV CODE: Contains the title IV institutional
number.
RCRAPP3_FAF_FAFSA_DATA VARCHAR2 1 YES FAF AND FAFSA DATA INDICATOR: Indicates whether the
FAF and/or the FAFSA data ispresent.
RCRAPP3_FAF_RCPT_DATE DATE 7 YES FAF RECEIPT DATE: Contains the date the CSS received
request for report to the institution or agency.
RCRAPP3_FARM_DBT NUMBER 7 YES STUDENT'S FARM DEBT: Contains a student's farm debt.
RCRAPP3_FARM_VAL NUMBER 7 YES STUDENT'S FARM VALUE: Contains a student's farm value.
RCRAPP3_FATHER_AGE VARCHAR2 2 YES FATHER'S AGE: Contains the father's age.
RCRAPP3_FATHER_HI_GRADE VARCHAR2 1 YES FATHER'S HIGHEST GRADE: Contains the highest grade
level completed by the father
RCRAPP3_FED_COLL_CHOICE_4 VARCHAR2 6 YES THE FOURTH FEDERAL COLLEGE CHOICE: Contains the fourth
college choice a student plans to attend in 1993-94.
RCRAPP3_FED_COLL_CHOICE_5 VARCHAR2 6 YES THE FIFTH FEDERAL COLLEGE CHOICE: Contains the fifth
college choice a student plans to attend in 1993-94
RCRAPP3_FED_COLL_CHOICE_6 VARCHAR2 6 YES THE SIXTH FEDERAL COLLEGE CHOICE: Contains the sixth
college choice a student plans to attend in 1993-94.
RCRAPP3_GA_MATCH_FLAG VARCHAR2 1 YES GUARANTEED AGENCY MATCH FLAG: Contains the match flag
that is used by the ACT for guaranteed agency. Valid
values are Yes (in default) or blank.
RCRAPP3_GED_MTH_YR VARCHAR2 4 YES GED DATE: Contains the month and year the student
earned a GED.
RCRAPP3_GRAD_OR_PROF VARCHAR2 1 YES GRADUATE OR PROFESSIONAL INDICATOR: Indicates whether
or not a student is a graduate or professional
student.
RCRAPP3_HS_GRAD_MTH_YR VARCHAR2 4 YES HIGH SCHOOL GRADUATON DATE: Contains the month and
year the student graduates from high school.
RCRAPP3_INVEST_DBT NUMBER 6 YES STUDENT'S INVESTMENT DEBT: Contains a student's
investment debt.
RCRAPP3_INVEST_VAL NUMBER 6 YES STUDENT'S INVESTMENT VALUE: Contains a student's
investment value.
RCRAPP3_LIVE_ON_FARM VARCHAR2 1 YES LIVE ON FARM INDICATOR: Indicates whether or not a
student is living on a farm.
RCRAPP3_MARRIED VARCHAR2 1 YES MARRIED INDICATOR: Indicates whether or not a student
is married.
RCRAPP3_MOTHER_AGE VARCHAR2 2 YES MOTHER'S AGE: Contains the mother's age.
Date: 21-JUN-2004 Page: 48
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP3_MOTHER_HI_GRADE VARCHAR2 1 YES MOTHER'S HIGHEST GRADE: Contains the highest grade
level completed by the mother
RCRAPP3_MSG_52 VARCHAR2 1 YES MESSAGE NUMBER 52: Displays the message indicating the
difference between FAFSA assets and FAF assets.
RCRAPP3_MSG_91_SEC_FM_EFC NUMBER 6 YES SECONDARY FEDERAL METHODOLOGY EFC MESSAGE: Displays
the message indicating the value of a Secondary
Federal Methodology EFC.
RCRAPP3_P_RES_DATE DATE 7 YES PARENTS' RESIDENT DATE: Contains the date the parents
became legal residents of the specified state.
RCRAPP3_PAR_ALT_HME_VAL NUMBER 7 YES PARENT'S ALTERNATE HOME VALUE: Contains the parents'
alternate value on a home.
RCRAPP3_PAR_ALT_HME_VAL_CAP NUMBER 6 YES PARENTS' ALTERNATE HOME VALUE CAP: Contains the
parents' alternate highest valueon a home.
RCRAPP3_PAR_BUS_DBT NUMBER 7 YES PARENTS' BUSINESS DEBT: Contains the parents' business
debt.
RCRAPP3_PAR_BUS_VAL NUMBER 7 YES PARENTS' BUSINESS VALUE: Contains the parents'
business value.
RCRAPP3_PAR_CASH_CHK NUMBER 6 YES PARENTS' CASH, SAVINGS, AND CHECKING ACCOUNTS:
Contains the amount of cash on hand, in saving and
checking accounts of the parents.
RCRAPP3_PAR_CHILD_SUPP_PAID NUMBER 5 YES PARENTS' CHILD SUPPORT PAID: Contains the amount paid
for child support by the parents in 1992.
RCRAPP3_PAR_EIC NUMBER 5 YES PARENTS' EARNED INCOME CREDIT: Contains the parents'
earned income credit.
RCRAPP3_PAR_FARM_DBT NUMBER 7 YES PARENTS' FARM DEBT: Contains the parents' farm debt.
RCRAPP3_PAR_FARM_VAL NUMBER 7 YES PARENTS' FARM VALUE: Contains the parents' farm value.
RCRAPP3_PAR_FOR_INC_EXCL NUMBER 6 YES PARENTS' FOREIGN INCOME EXCLUSION: Contains the
parents' foreign income exclusion.
RCRAPP3_PAR_HOUSE_FOOD_OTH NUMBER 5 YES PARENTS' HOUSING, FOOD, AND OTHER LIVING ALLOWANCES:
Contains the housing, food,and other living allowances
paid by the parents to the members of the military,
clergy, and others.
RCRAPP3_PAR_INC_BENEFITS NUMBER 6 YES PARENTS' INCOME BENEFITS: Contains the parents'
untaxed income and benefits.
RCRAPP3_PAR_INVEST_DBT NUMBER 7 YES PARENTS' INVESTMENT DEBT: Contains the parents'
investment debt.
RCRAPP3_PAR_INVEST_VAL NUMBER 7 YES PARENTS' INVESTMENT VALUE: Contains the parents'
investment value.
RCRAPP3_PAR_IRA_KEOUGH NUMBER 5 YES IRA AND KEOUGH PAYMENTS: Contains the parents'
deductible IRA and/or keough payments.
RCRAPP3_PAR_LIVE_ON_FARM VARCHAR2 1 YES LIVE ON FARM INDICATOR: Indicates whether or not the
parents are living on a farm.
RCRAPP3_PAR_MTH_MORT_RENT_PAY NUMBER 5 YES MONTHLY MORTGAGE RENTAL PAYMENT: Contains the parents'
monthly home mortgage or rental payment.
RCRAPP3_PAR_PORTION_OF_PENS NUMBER 5 YES PORTION OF PENSIONS: Contains the parents' untaxed
portion of pensions.
RCRAPP3_PAR_RE_DBT NUMBER 7 YES PARENTS' REAL ESTATE DEBT: Contains the parents' real
estate debt.
RCRAPP3_PAR_RE_VAL NUMBER 7 YES PARENTS' REAL ESTATE VALUE: Contains the parents' real
estate value.
Date: 21-JUN-2004 Page: 49
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP3_PAR_SPEC_FUELS NUMBER 5 YES SPECIAL FUELS: Contains the parents' Credit for
federal tax on special fuels.
RCRAPP3_PAR_TAX_DEF_PENSION NUMBER 5 YES TAX-DEFERRED PENSION PLANS: Contains the parents'
payments to tax-deferred pension and saving plans that
are paid directly or withheld from earnings. Also
contains the untaxed portion of 401(k) and 403(b)
plans.
RCRAPP3_PAR_TE_INT_INC NUMBER 5 YES TAX EXEMPT INTEREST INCOME: Contains the parents' tax
exempt interest income.
RCRAPP3_PIN VARCHAR2 4 YES PIN NUMBER: Contains the unique number assigned to
student applicant. It will only present on ESARs
generated by electronic applications.
RCRAPP3_PREPARER_EIN VARCHAR2 9 YES PREPARER'S EMPLOYEE IDENTIFICATION NUMBER: Contains
the preparer's employee identification number.
RCRAPP3_PREPARER_SIGN VARCHAR2 1 YES PREPARER'S SIGNATURE INDICATOR: Indicates whether or
not the preparer's signature is on the application.
RCRAPP3_PREPARER_SSN VARCHAR2 9 YES PREPARER'S SOCIAL SECURITY NUMBER: Contains a
preparer' social security number.
RCRAPP3_PREV_COLL5 VARCHAR2 6 YES PREVIOUS COLLEGE NUMBER 5: Contains the fifth college
that a student has attended.
RCRAPP3_RE_DBT NUMBER 6 YES STUDENT'S REAL ESTATE DEBT: Contains a student's real
estate debt.
RCRAPP3_RE_VAL NUMBER 6 YES STUDENT'S REAL ESTATE VALUE: Contains a student's real
estate value.
RCRAPP3_REJECT_OVRD_1 VARCHAR2 1 YES REJECT OVERRIDE B: Set to Y (box checked) if Reject B
override accepted - Independent status in question
because of student's age.
RCRAPP3_REJECT_OVRD_2 VARCHAR2 1 YES REJECT OVERRIDE 2: Set to 'Y' by the electronic
application user to override rejection 2: Independent
student status in question because of student's age.
RCRAPP3_REJECT_OVRD_3 VARCHAR2 1 YES REJECT OVERRIDE 3: Set to 'Y' by the electronic
application user to override rejection 3: Unusually
low income.
RCRAPP3_REJECT_OVRD_4 VARCHAR2 1 YES REJECT OVERRIDE N: Set by electronic application user
to override reject N: Missing first or last name.
RCRAPP3_REJECT_OVRD_5 VARCHAR2 1 YES REJECTION OVERRIDE 5: Set to 'Y' by the electronic
application user to override rejection 5: Student's
first or last name blank.
RCRAPP3_REJECT_OVRD_6 VARCHAR2 1 YES REJECT OVERRIDE W: Set by electronic application user
to override reject W: Questionable number of family
members, greater than 15.
RCRAPP3_REJECT_OVRD_7 VARCHAR2 1 YES REJECT OVERRIDE 7: Set to 'Y' by the electronic
application user to override rejection 7: Unusually
large number of family members.
RCRAPP3_S_MAR_MTH_YR VARCHAR2 6 YES DATE OF STUDENT'S MARITAL STATUS: Contains the month
and year the student is married, widowed, separated,
or divorced.
RCRAPP3_SAR_C_FLAG VARCHAR2 1 YES STUDENT AID REPORT 'C' FLAG: Indicates when a 'C'
would have printed next to theEFC on Part 1 of the
Student Aid Report.
RCRAPP3_SELF_HELP_VALUE NUMBER 5 YES
Date: 21-JUN-2004 Page: 50
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP3_SOC_SEC VARCHAR2 1 YES SOCIAL SECURITY MATCH FLAG
RCRAPP3_STU_ALT_NO_IN_COLL NUMBER 1 YES STUDENT'S NUMBER IN COLLEGE: Contains the student's
number in college used in the Institutional
Methodology.
RCRAPP3_YR_IN_COLL_2 VARCHAR2 1 YES YEAR IN COLLEGE: Indicates the student's year in
college.
RCRAPP3_ADJ_EFC_CALC_REQ VARCHAR2 1 YES ADJUSTED EFC CALCULATED REQUEST: Contains a request to
calculate the adjusted Effective Family Contribution.
RCRAPP3_FAA_ADJ_EFC_CORR NUMBER 4 YES FINANCIAL AID ADMINISTRATOR'S RECALCULATED EFC:
Contains the FA Administrator's recalculated EFC.
RCRAPP3_EFC_RECALC_CORR_REQ VARCHAR2 1 YES RECALCULATE EFC REQUEST: Indicates a request to the
CPS to recalculate the EFC.
RCRAPP3_S_RES_DATE DATE 7 YES STUDENT'S RESIDENT DATE: Contains the date the student
became a legal resident of the specified state.
RCRAPP3_OFFL_UNOFFL_IND VARCHAR2 1 YES OFFICIAL OR UNOFFICIAL INDICATOR: Contains the
official or unofficial indicator.
RCRAPP3_ASSUMPTION_MSG_7 VARCHAR2 2 YES ASSUMPTION MESSAGE 7: Holds data assumption code
generated by INAS.
RCRAPP3_ASSUMPTION_MSG_8 VARCHAR2 2 YES ASSUMPTION MESSAGE 8: Holds data assumption code
generated by INAS.
RCRAPP3_ASSUMPTION_MSG_9 VARCHAR2 2 YES ASSUMPTION MESSAGE 9: Holds data assumption code
generated by INAS.
RCRAPP3_ASSUMPTION_MSG_10 VARCHAR2 2 YES ASSUMPTION MESSAGE 10: Holds data assumption code
generated by INAS.
RCRAPP3_PHEAA_GRANT_AMT_1 NUMBER 5 YES PHEAA State Grant amount for term 1.
RCRAPP3_PHEAA_GRANT_AMT_2 NUMBER 5 YES PHEAA State Grant amount for term 2.
RCRAPP3_PHEAA_GRANT_AMT_3 NUMBER 5 YES PHEAA State Grant amount for term 3.
RCRAPP3_PHEAA_GRANT_AMT_4 NUMBER 5 YES PHEAA State Grant amount for term 4.
RCRAPP3_PHEAA_GRANT_CDE_1 VARCHAR2 1 YES PHEAA State Grant code for term 1.
RCRAPP3_PHEAA_GRANT_CDE_2 VARCHAR2 1 YES PHEAA State Grant code for term 2.
RCRAPP3_PHEAA_GRANT_CDE_3 VARCHAR2 1 YES PHEAA State Grant code for term 3.
RCRAPP3_PHEAA_GRANT_CDE_4 VARCHAR2 1 YES PHEAA State Grant code for term 4.
RCRAPP3_REJECT_OVRD_A VARCHAR2 1 YES REJECT OVERRIDE A: Set by electronic application user
to override reject A: Date of birth equals 1900
through 1928.
RCRAPP3_REJECT_OVRD_C VARCHAR2 1 YES REJECT OVERRIDE C: Set by electronic application user
to override reject C: Taxes paid >0 and >= fixed % of
AGI but not >= AGI.
RCRAPP3_PAR_MAR_MTH_YR VARCHAR2 6 YES DATE OF PARENTS' MARITAL STATUS: Contains the month
and year the parents were married, widowed, separated,
or divorced.
RCRAPP3_PAR_TUI_FEE_DED NUMBER 6 YES TUITION AND FEES DEDUCTION FROM 1040: The tuition and
fees deduction from IRS 1040 and 1040A
RCRAPP3_FATH_SSN_MATCH VARCHAR2 1 YES FATHER'S/STEPFATHER'S SSN MATCH FLAG:
Father's/Stepfather's SSN Match Flag
RCRAPP3_MOTH_SSN_MATCH VARCHAR2 1 YES MOTHER'S/STEPMOTHER'S SSN MATCH FLAG:
Mother's/Stepmother's SSN Match Flag
RCRAPP3_REJECT_OVRD_G VARCHAR2 1 YES REJECT OVERRIDE G: Set by electronic application user
to override reject G: Dependent Student's Taxes paid
>0 and >= fixed % of AGI but not >= AGI.
Date: 21-JUN-2004 Page: 51
TABLE: RCRAPP4
CREATOR: FAISMGR
Financial Aid Application Table - Part 4
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc.
RCRAPP4_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRAPP4_INFC_CODE VARCHAR2 7 NO
RCRAPP4_SEQ_NO NUMBER 3 NO
RCRAPP4_REC_TYPE VARCHAR2 1 YES
RCRAPP4_MDE_ID_NO VARCHAR2 8 YES
RCRAPP4_CTRL_NO VARCHAR2 5 YES
RCRAPP4_TAPE_RPT_EXTRCT_DATE DATE 7 YES
RCRAPP4_INST_RPT_TYPE VARCHAR2 1 YES
RCRAPP4_SECT_R_WRITTEN_EXPLAIN VARCHAR2 1 YES
RCRAPP4_SECT_S_INST_ID NUMBER 2 YES
RCRAPP4_ST_SPECIFIC_INFO VARCHAR2 160 YES
RCRAPP4_C_INST_1_OUT_ST_TUIT VARCHAR2 1 YES
RCRAPP4_C_INST_1_BUDG_NAME VARCHAR2 7 YES
RCRAPP4_C_INST_1_BUDG_DUR NUMBER 2 YES
RCRAPP4_C_INST_1_TUIT_FEE NUMBER 5 YES
RCRAPP4_C_INST_1_BOOKS NUMBER 5 YES
RCRAPP4_C_INST_1_LIVING_EXP NUMBER 5 YES
RCRAPP4_C_INST_1_TOT_EXP NUMBER 5 YES
RCRAPP4_C_INST_1_TOT_CTRB NUMBER 5 YES
RCRAPP4_C_INST_1_TOT_PAR_CTRB NUMBER 5 YES
RCRAPP4_C_INST_1_TOT_FAM_CTRB NUMBER 6 YES
RCRAPP4_C_INST_1_TFC_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_INST_1_EST_FA_NEED NUMBER 5 YES
RCRAPP4_C_INST_1_EST_PELL_AWRD NUMBER 5 YES
RCRAPP4_C_INST_1_EST_ST_AWRD NUMBER 5 YES
RCRAPP4_C_INST_2_BUDG_NAME VARCHAR2 7 YES
RCRAPP4_C_INST_2_BUDG_DUR NUMBER 2 YES
RCRAPP4_C_INST_2_TUIT_FEE NUMBER 5 YES
RCRAPP4_C_INST_2_BOOKS NUMBER 5 YES
RCRAPP4_C_INST_2_LIVING_EXP NUMBER 5 YES
RCRAPP4_C_INST_2_TOT_EXP NUMBER 5 YES
RCRAPP4_C_INST_2_TOT_CTRB NUMBER 5 YES
RCRAPP4_C_INST_2_TOT_PAR_CTRB NUMBER 5 YES
RCRAPP4_C_INST_2_TOT_FAM_CTRB NUMBER 5 YES
RCRAPP4_C_INST_2_TFC_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_INST_2_EST_FA_NEED NUMBER 5 YES
RCRAPP4_C_INST_2_EST_PELL_AWRD NUMBER 5 YES
RCRAPP4_C_INST_2_EST_ST_AWRD NUMBER 5 YES
RCRAPP4_C_INST_3_BUDG_NAME VARCHAR2 7 YES
RCRAPP4_C_INST_3_BUDG_DUR NUMBER 2 YES
Date: 21-JUN-2004 Page: 52
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_C_INST_3_TUIT_FEE NUMBER 5 YES
RCRAPP4_C_INST_3_BOOKS NUMBER 5 YES
RCRAPP4_C_INST_3_LIVING_EXP NUMBER 5 YES
RCRAPP4_C_INST_3_TOT_EXP NUMBER 5 YES
RCRAPP4_C_INST_3_TOT_CTRB NUMBER 5 YES
RCRAPP4_C_INST_3_TOT_PAR_CTRB NUMBER 5 YES
RCRAPP4_C_INST_3_TOT_FAM_CTRB NUMBER 5 YES
RCRAPP4_C_INST_3_TFC_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_INST_3_EST_FA_NEED NUMBER 5 YES
RCRAPP4_C_INST_3_EST_PELL_AWRD NUMBER 5 YES
RCRAPP4_C_INST_3_EST_ST_AWRD NUMBER 5 YES
RCRAPP4_C_INST_1_DEPEND_CARE NUMBER 5 YES
RCRAPP4_C_INST_2_DEPEND_CARE NUMBER 5 YES
RCRAPP4_C_INST_3_DEPEND_CARE NUMBER 5 YES
RCRAPP4_C_NA_1_CTRB_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_NA_1_CTRB_FOR_STDT NUMBER 5 YES
RCRAPP4_C_NA_1_ANLY_TYPE VARCHAR2 1 YES
RCRAPP4_C_NA_2_CTRB_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_NA_2_CTRB_FOR_STDT NUMBER 5 YES
RCRAPP4_C_NA_2_ANLY_TYPE VARCHAR2 1 YES
RCRAPP4_C_NA_1_P_CTRB_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_NA_1_P_CTRB_FOR_STDT NUMBER 7 YES
RCRAPP4_C_NA_1_P_ANLY_TYPE VARCHAR2 1 YES
RCRAPP4_C_NA_2_P_CTRB_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_NA_2_P_CTRB_FOR_STDT NUMBER 5 YES
RCRAPP4_C_NA_2_P_ANLY_TYPE VARCHAR2 1 YES
RCRAPP4_C_NA_1_TOT_FAM_CTRB NUMBER 6 YES
RCRAPP4_C_NA_1_TFC_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_NA_2_TOT_FAM_CTRB NUMBER 5 YES
RCRAPP4_C_NA_2_TFC_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_NA_1_PELL_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_NA_1_PELL_PGI NUMBER 5 YES
RCRAPP4_C_NA_2_PELL_OFFL_EST VARCHAR2 1 YES
RCRAPP4_C_NA_2_PELL_PGI NUMBER 5 YES
RCRAPP4_C_NA_1_IM_CTRB_STDT NUMBER 5 YES
RCRAPP4_C_NA_1_IM_ANLY_TYPE VARCHAR2 1 YES
RCRAPP4_C_NA_2_IM_CTRB_STDT NUMBER 5 YES
RCRAPP4_C_NA_2_IM_ANLY_TYPE VARCHAR2 1 YES
RCRAPP4_C_NA_1_P_IM_CTRB_STDT NUMBER 5 YES
RCRAPP4_C_NA_1_P_IM_ANLY_TYPE VARCHAR2 1 YES
RCRAPP4_C_NA_2_P_IM_CTRB_STDT NUMBER 5 YES
RCRAPP4_C_NA_2_P_IM_ANLY_TYPE VARCHAR2 1 YES
RCRAPP4_C_NA_1_IM_TOT_FAM_CTRB NUMBER 6 YES
RCRAPP4_C_NA_FISAP_INC NUMBER 6 YES
RCRAPP4_RECORD_MARK VARCHAR2 1 YES
RCRAPP4_COLL_SPECIFIC_INFO VARCHAR2 98 YES ACT COLLEGE SPECIFIC INFORMATION: Student responses to
the College Questions on the College Questions
Supplement. (ACT only)
RCRAPP4_ADJ_EFC NUMBER 5 YES ADJUSTED EFFECTIVE FAMILY CONTRIBUTION: Indicates
adjustment for Pell Grant award funding was made by
the financial aid administrator.
Date: 21-JUN-2004 Page: 53
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_EFC_TYPE VARCHAR2 1 YES TYPE OF EFFECTIVE FAMILY CONTRIBUTION: Indicates the
EFC that will appear on the Pell Grant Payment
Voucher.
RCRAPP4_ESAR_USER_DEF_FIELDS VARCHAR2 100 YES USER DEFINED FIELDS: Contains the user defined fields.
RCRAPP4_C_INST_1_ASSUM_HOUS VARCHAR2 1 YES ASSUMED HOUSING STATUS: Contains the assumed housing
status for budget number 1.
RCRAPP4_C_INST_2_ASSUM_HOUS VARCHAR2 1 YES ASSUMED HOUSING STATUS: Contains the assumed housing
status for budget number 2.
RCRAPP4_C_INST_3_ASSUM_HOUS VARCHAR2 1 YES ASSUMED HOUSING STATUS: Contains the assumed housing
status for budget number 3.
RCRAPP4_C_INST_4_ASSUM_HOUS VARCHAR2 1 YES ASSUMED HOUSING STATUS: Contains the assumed housing
status for budget number 4,that will be used by the
ACT.
RCRAPP4_C_INST_4_BUDG_DUR NUMBER 2 YES BUDGET DURATION: Contains the duration of budget
number 4 that will be used by the ACT.
RCRAPP4_C_INST_4_BUDG_NAME VARCHAR2 7 YES BUDGET NAME: Contains the name of budget number 4 used
by the ACT.
RCRAPP4_C_INST_4_EST_FA_NEED NUMBER 5 YES ESTIMATED FINANCIAL AID NEED: Contains the estimated
Financial Aid Need for budget number 4 that will used
by the ACT.
RCRAPP4_C_INST_4_EST_PELL_AWRD NUMBER 5 YES ESTIMATED PELL AWARD: Contains the estimated pell
award for budget number 4 thatwill be used by the ACT.
RCRAPP4_C_INST_4_LIVING_EXP NUMBER 5 YES LIVING EXPENSES: Contains the living expenses for
budget number 4 that will be used by the ACT.
RCRAPP4_C_INST_4_TOT_EXP NUMBER 5 YES TOTAL EXPENSES: Contains the total expenses for budget
number 4 that will be by the ACT.
RCRAPP4_C_INST_4_TOT_CTRB NUMBER 5 YES TOTAL CONTRIBUTION: Contains the total contribution
for budget number 4 that will be used by the ACT.
RCRAPP4_C_INST_4_TOT_FAM_CTRB NUMBER 6 YES TOTAL FAMILY CONTRIBUTION: Contains the total family
contribution for budget number 4 that will be used by
the ACT.
RCRAPP4_C_INST_4_TOT_PAR_CTRB NUMBER 5 YES TOTAL PARENT CONTRIBUTION: Contains the total
contribution from the parents for budget number 4 that
will be used by the ACT.
RCRAPP4_C_INST_4_TUIT_FEE NUMBER 5 YES TUITION FEE: Contains the tuition fee for budget
number 4 that will be used by the ACT.
RCRAPP4_C_INST_4_UNASSESS_VA NUMBER 5 YES
RCRAPP4_C_INST_5_ASSUM_HOUS VARCHAR2 1 YES ASSUMED HOUSING STATUS: Contains the assumed housing
status for budget number 5.
RCRAPP4_C_INST_5_BUDG_DUR NUMBER 2 YES BUDGET DURATION: Contains the duration of budget
number 5 that will be used by the ACT.
RCRAPP4_C_INST_5_BUDG_NAME VARCHAR2 7 YES BUDGET NAME: Contains the name of budget number 5.
RCRAPP4_C_INST_5_EST_FA_NEED NUMBER 5 YES ESTIMATED FINANCIAL AID NEED: Contains the estimated
financial aid need for budget number 5.
RCRAPP4_C_INST_5_EST_PELL_AWRD NUMBER 5 YES ESTIMATED PELL AWARD: Contains the estimated pell
award for budget number 5 thatwill be used by the ACT.
RCRAPP4_C_INST_5_LIVING_EXP NUMBER 5 YES LIVING EXPENSES: Contains the living expenses for
budget number 5 that will be used by the ACT.
RCRAPP4_C_INST_5_TOT_EXP NUMBER 5 YES TOTAL EXPENSES: Contains the total expenses for budget
number 5 that will be used by the ACT.
RCRAPP4_C_INST_5_TOT_CTRB NUMBER 5 YES TOTAL CONTRIBUTION: Contains the total contribution
for budget number 5 that will be used by the ACT.
Date: 21-JUN-2004 Page: 54
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_C_INST_5_TOT_FAM_CTRB NUMBER 6 YES TOTAL FAMILY CONTRIBUTION: Contains the total
contribution from a family for budget number 5 that
will be used by the ACT.
RCRAPP4_C_INST_5_TOT_PAR_CTRB NUMBER 5 YES TOTAL PARENT CONTRIBUTION: Contains the total
contribution from the parents for budget number 5 that
will be used by the ACT.
RCRAPP4_C_INST_5_TUIT_FEE NUMBER 5 YES TUITION FEE: Contains the tuition fee for budget
number 5 that will be used by the ACT.
RCRAPP4_C_INST_5_UNASSESS_VA NUMBER 5 YES
RCRAPP4_C2_INST_1_EST_PELL_AWD NUMBER 4 YES ESTIMATED PELL AWARD FOR BUDGET 1: Contains the
estimated pell award for budget number 1.
RCRAPP4_C2_INST_1_TOT_FAM_CTRB NUMBER 5 YES TOTAL FAMILY CONTRIBUTION FOR BUDGET 1: Contains the
total family contribution for budget number 1.
RCRAPP4_C2_INST_2_EST_PELL_AWD NUMBER 4 YES ESTIMATED PELL AWARD FOR BUDGET 2: Contains the
estimated pell award for budget number 2.
RCRAPP4_C2_INST_2_TOT_FAM_CTRB NUMBER 5 YES TOTAL FAMILY CONTRIBUTION FOR BUDGET 2: Contains the
total family contribution for budget number 2.
RCRAPP4_C2_INST_3_EST_PELL_AWD NUMBER 4 YES ESTIMATED PELL AWARD FOR BUDGET 3: Contains the
estimated pell award for budget number 3.
RCRAPP4_C2_INST_3_TOT_FAM_CTRB NUMBER 5 YES TOTAL FAMILY CONTRIBUTION FOR BUDGET 3: Contains the
total family contribution for budget number 3.
RCRAPP4_C2_INST_4_EST_PELL_AWD NUMBER 4 YES ESTIMATED PELL AWARD FOR BUDGET 4: Contains the
estimated pell award for budget number 4.
RCRAPP4_C2_INST_4_TOT_FAM_CTRB NUMBER 5 YES TOTAL FAMILY CONTRIBUTION FOR BUDGET 4: Contains the
total family contribution for budget number 4.
RCRAPP4_C2_INST_5_EST_PELL_AWD NUMBER 4 YES ESTIMATED PELL AWARD FOR BUDGET 5: Contains the
estimated pell award for budget number 5.
RCRAPP4_C2_INST_5_TOT_FAM_CTRB NUMBER 5 YES TOTAL FAMILY CONTRIBUTION FOR BUDGET 5: Contains the
total family contribution for budget number 5.
RCRAPP4_PELL_1_EFC NUMBER 5 YES PRIMARY EFFECTIVE FAMILY CONTRIBUTION: Contains the
primary adjusted total contribution from a family.
RCRAPP4_PELL_2_EFC NUMBER 5 YES SECONDARY EFFECTIVE FAMILY CONTRIBUTION: Contains the
secondary adjusted total contribution from a family.
RCRAPP4_S_IV_INC NUMBER 5 YES Student's Title IV income exclusions such as taxable
financial aid and child support paid
RCRAPP4_P_IV_INC NUMBER 5 YES Parent's Title IV income exclusions such as taxable
financial aid and child support paid
RCRAPP4_CURRENT_PLUS VARCHAR2 1 YES This field indicates whether the applicant has a
current Federal Plus loan
RCRAPP4_CURRENT_CONSOL VARCHAR2 1 YES This field indicates wheher the applicant has a
current Federal Concolidator loan
RCRAPP4_WORK_STUDY VARCHAR2 1 YES This field indicates that a student is interested in
receiving work-study assistance
RCRAPP4_LOAN_INT VARCHAR2 1 YES This field indicates that a student is interested in
receiving student loans
RCRAPP4_PLUS_INT VARCHAR2 1 YES This field indicates that a parent is interested in
receiving a parent PLUS loan
RCRAPP4_S_DIV_INT_INC NUMBER 5 YES This field holds the amount of the student's dividend
and interest income received
RCRAPP4_S_FARM_VAL_FAF NUMBER 6 YES Represents the amount of the student's farm value
Date: 21-JUN-2004 Page: 55
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_S_FARM_DBT_FAF NUMBER 6 YES Represents the amount of the student's farm debt
RCRAPP4_P_FARM_VAL_FAF NUMBER 7 YES Represents the amount of the parent's farm value
RCRAPP4_P_FARM_DBT_FAF NUMBER 7 YES Represents the amount of the parent's farm debt
RCRAPP4_VERIF_NUM VARCHAR2 15 YES This field holds the DHS verification number 2004-2005
changed INS to DHS.
RCRAPP4_ALT_OPT_TUIT VARCHAR2 1 YES Indicates whether elementary or secondary tuition was
included as an allowance in IM comuptations
RCRAPP4_MSG_31 VARCHAR2 1 YES A value of '1' indicates F.78 and C30A-I differ by
$100 or more
RCRAPP4_MSG_72 VARCHAR2 1 YES A value of '1' indicates Federal student AGI reduced
by F.68
RCRAPP4_OLDEST_LOAN_DATE VARCHAR2 4 YES This contains the date (MMDDYY) of the student's
oldest outstanding loan
RCRAPP4_NSLDS_MATCH VARCHAR2 1 YES This field indicates the results of the tape match
against the National Student Loan Data System database
RCRAPP4_BAL_ON_SLS NUMBER 5 YES
RCRAPP4_C_NA_1_IM_PC_IND VARCHAR2 1 YES Indicates, with a F value that the students FM PC is
higher than the IM PC.
RCRAPP4_IRA_KEOGH_AMT NUMBER 6 YES Contains the sum of the amounts paid by the student
into their IRA and KEOGH accounts during the base
year.
RCRAPP4_EXP_PAR_TUIT_PD NUMBER 5 YES
RCRAPP4_EXP_PAR_NO_CHILD_TUIT NUMBER 1 YES
RCRAPP4_HME_YR_PURCH NUMBER 4 YES
RCRAPP4_HME_PURCH_AMT NUMBER 6 YES
RCRAPP4_VISA_CLASS VARCHAR2 1 YES VISA CLASSIFICATION: This field indicates what a
students VISA classification is, see CSS tape layout
for valid values.
RCRAPP4_C_INST_1_OTH_CTRB NUMBER 5 YES OTHER CONTRIBUTION FOR BUDGET 1: Contains the other
contribution to be used with budget number 1.
RCRAPP4_C_1_INC_ADJ NUMBER 8 YES STUDENT FM INCOME ADJUSTMENT: The amount of the income
adjustment used in the student FM calculation.
RCRAPP4_C_1_OTH_ALLOW NUMBER 8 YES STUDENT FM OTHER INCOME ALLOWANCE: The amount of the
other income allowance (override) used in the student
FM calculation.
RCRAPP4_C_1_IRA_KEOGH NUMBER 8 YES STUDENT FM IRA/KEOGH AMOUNT: Reserved for future use.
RCRAPP4_C_1_TRUST_VAL NUMBER 8 YES STUDENT FM TRUST ACCOUNT VALUE: Reserved for future
use.
RCRAPP4_C_1_OTH_ASSET NUMBER 8 YES STUDENT FM OTHER ASSET: The amount of the other asset
(override) used in the student FM calculation.
RCRAPP4_C_1_OTH_ASSET_ALLOW NUMBER 8 YES STUDENT FM OTHER ASSET ALLOWANCE: The amount of the
other asset allowance (override) used in the student
FM calculation.
RCRAPP4_C_2_INC_ADJ NUMBER 8 YES STUDENT IM INCOME ADJUSTMENT: The amount of the income
adjustment used in the student IM calculation.
RCRAPP4_C_2_OTH_ALLOW NUMBER 8 YES STUDENT IM OTHER INCOME ALLOWANCE: The amount of the
other income allowance (override) used in the student
IM calculation.
RCRAPP4_C_2_IRA_KEOGH NUMBER 8 YES STUDENT IM IRA/KEOGH AMOUNT: The amount of the student
IRA/KEOGH account used in the student IM calculation.
RCRAPP4_C_2_TRUST_VAL NUMBER 8 YES STUDENT IM TRUST ACCOUNT VALUE: The amount of the
student trust account used in the student IM
calculation.
Date: 21-JUN-2004 Page: 56
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_C_2_OTH_ASSET NUMBER 8 YES STUDENT IM OTHER ASSET: The amount of the other asset
(override) used in the student IM calculation.
RCRAPP4_C_2_OTH_ASSET_ALLOW NUMBER 8 YES STUDENT IM OTHER ASSET ALLOWANCE: The amount of the
other asset allowance (override) used in the student
IM calculation.
RCRAPP4_C_PAR_1_INC_ADJ NUMBER 8 YES PARENT FM INCOME ADJUSTMENT: The amount of the income
adjustment used in the parent FM calculation.
RCRAPP4_C_PAR_1_OTH_ALLOW NUMBER 8 YES PARENT FM OTHER INCOME ALLOWANCE: The amount of the
other income allowance (override) used in the parent
FM calculation.
RCRAPP4_C_PAR_1_OTH_ASSET NUMBER 8 YES PARENT FM OTHER ASSET: The amount of the other asset
(override) used in the parent FM calculation.
RCRAPP4_C_PAR_1_OTH_ASSET_ALLW NUMBER 8 YES PARENT FM OTHER ASSET ALLOWANCE: The amount of the
other asset allowance (override) used in the parent FM
calculation.
RCRAPP4_C_PAR_2_INC_ADJ NUMBER 8 YES PARENT IM INCOME ADJUSTMENT: The amount of the income
adjustment used in the parent IM calculation.
RCRAPP4_C_PAR_2_OTH_ALLOW NUMBER 8 YES PARENT IM OTHER INCOME ALLOWANCE: The amount of the
other income allowance (override) used in the parent
IM calculation.
RCRAPP4_C_PAR_2_OTH_ASSET NUMBER 8 YES PARENT IM OTHER ASSET: The amount of the other asset
(override) used in the parent IM calculation.
RCRAPP4_C_PAR_2_OTH_ASSET_ALLW NUMBER 8 YES PARENT IM OTHER ASSET ALLOWANCE: The amount of the
other asset allowance (override) used in the parent IM
calculation.
RCRAPP4_TYPE_DATA_AVAIL VARCHAR2 1 YES TYPE OF DATA AVAILABLE: Indicates the type of data
available for the FM and/or IM calculations.
RCRAPP4_IM_PAR_DATA_AVAIL VARCHAR2 1 YES PARENT DATA AVAILABLE FOR THE IM CALCULATION:
Indicates whether parent data was available for the IM
calculation.
RCRAPP4_FM_PAR_DATA_AVAIL VARCHAR2 1 YES PARENT DATA AVAILABLE FOR THE FM CALCULATION:
Indicates whether parent data was available for the FM
calculation.
RCRAPP4_IM_BUDG_DUR_FOR_CALC NUMBER 3 1 YES IM BUDGET DURATION: The budget duration used for the
IM calculation.
RCRAPP4_STATE_FOR_TAXES VARCHAR2 2 YES STUDENT STATE FOR TAXES: The state used for
calculation of the student state and local taxes.
RCRAPP4_PAR_STATE_FOR_TAXES VARCHAR2 2 YES PARENT STATE FOR TAXES: The state used for calculation
of the parent state and local taxes.
RCRAPP4_FORMULA_FOR_CALC VARCHAR2 1 YES FORMULA FOR CALCULATION: The formula used for the FM
calculation.
RCRAPP4_TAX_FILER VARCHAR2 1 YES STUDENT TAX FILER: Indicates whether the student was
considered to be a tax filer for calculation purposes.
RCRAPP4_PAR_TAX_FILER VARCHAR2 1 YES PARENT TAX FILER: Indicates whether the parents were
considered to be tax filers for calculation purposes.
RCRAPP4_TYPE_FM_CALC VARCHAR2 1 YES TYPE OF FM CALCULATION: Indicates whether the
calculation was an (O)riginal or a (R)ecalculation.
RCRAPP4_PAR_DEP_CARE_AND_MED NUMBER 5 YES PARENT DEPENDENT CARE AND MEDICAL SPENDING ACCOUNTS:
Contains the amounts withheld from parent wages for
dependent care and medical spending accounts.
Date: 21-JUN-2004 Page: 57
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_S_EIC NUMBER 5 YES
RCRAPP4_SSA_CITIZEN_IND VARCHAR2 1 YES
RCRAPP4_SAR_EFC NUMBER 5 YES TAPE LOAD SAR EFC: This field identifies what the SAR
EFC was for a person when they were added in dataload.
RCRAPP4_HS_GED_RCVD VARCHAR2 1 YES HIGH SCHOOL DIPLOMA/GED RECEIVED: This field indicates
if the person has received a high school diploma/GED.
RCRAPP4_FISAP_INC NUMBER 7 YES FISAP TOTAL INCOME: This field indicates the person's
total FISAP income.
RCRAPP4_EMAIL_ADDRESS VARCHAR2 50 YES E-MAIL ADDRESS: Student's e-mail address as reported
on PROFILE.
RCRAPP4_NSLDS_TRAN_NO VARCHAR2 2 YES NSLDS TRANSACTION NUMBER: This field indicates the
NSLDS transaction number associated with the Need
Analysis data for this applicant.
RCRAPP4_DRIVERS_LIC_IND VARCHAR2 1 YES DRIVERS LICENSE INDICATOR: This field indicates
whether the student has a driver's license.
RCRAPP4_LEGAL_RES_IND VARCHAR2 1 YES LEGAL RESIDENT INDICATOR: This field indicates whether
the student was a legal resident before January 1,
YYYY.
RCRAPP4_PAR_LEGAL_RES_IND VARCHAR2 1 YES PARENT LEGAL RESIDENT INDICATOR: This field indicates
whether the parent was a legal resident before January
1, YYYY.
RCRAPP4_TX_RET_FILED_IND VARCHAR2 1 YES TAX RETURN FILED INDICATOR: This field indicates
whether the student has already filed, will file or
will not file a tax return.
RCRAPP4_PAR_TX_RET_FILED_IND VARCHAR2 1 YES PARENT TAX RETURN FILED INDICATOR: This field
indicates whether the parent has already filed, will
file or will not file a tax return.
RCRAPP4_1040A_ELIG_IND VARCHAR2 1 YES 1040A ELIGIBILITY INDICATOR: This field indicates
whether the student is eligible to file a 1040A or
1040EZ tax form.
RCRAPP4_PAR_1040A_ELIG_IND VARCHAR2 1 YES PARENT 1040A ELIGIBILITY INDICATOR: This field
indicates whether the parent is eligible to file a
1040A or 1040EZ tax form.
RCRAPP4_INV_NET_WORTH NUMBER 6 YES INVESTMENT NET WORTH: This field indicates the
student's investment net worth.
RCRAPP4_PAR_INV_NET_WORTH NUMBER 6 YES PARENT INVESTMENT NET WORTH: This field indicates the
parent's investment net worth.
RCRAPP4_BUS_NET_WORTH NUMBER 6 YES BUSINESS NET WORTH: This field indicates the student's
business net worth.
RCRAPP4_PAR_BUS_NET_WORTH NUMBER 6 YES PARENT BUSINESS NET WORTH: This field indicates the
parent's business net worth.
RCRAPP4_FARM_NET_WORTH NUMBER 6 YES FARM NET WORTH: This field indicates the student's
farm net worth.
RCRAPP4_PAR_FARM_NET_WORTH NUMBER 6 YES PARENT FARM NET WORTH: This field indicates the
parent's farm net worth.
RCRAPP4_DEATH_DATE DATE 7 YES DEATH DATE: This field indicates the date of death
associated with the Social Security Number on this
application as reported to the Social Security
Administration.
RCRAPP4_VA_MATCH_FLAG VARCHAR2 1 YES VA MATCH FLAG: This field indicates the value of the
Veteran's Administration federal database match flag.
Date: 21-JUN-2004 Page: 58
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_FISAP_2_INC NUMBER 7 YES FISAP SECONDARY TOTAL INCOME: This field indicates the
person's secondary total FISAP income.
RCRAPP4_DRUG_OFFENSE_CONVIC VARCHAR2 1 YES DRUG OFFENSE CONVICTION: Drug Offense Conviction
Question.
RCRAPP4_FATH_LAST_NAME VARCHAR2 16 YES FATHER'S LAST NAME: Father's Last Name.
RCRAPP4_MOTH_LAST_NAME VARCHAR2 16 YES MOTHER'S LAST NAME: Mother's Last Name.
RCRAPP4_FATH_SSN VARCHAR2 9 YES FATHER'S SOCIAL SECURITY NUMBER: Father's Social
Security Number.
RCRAPP4_MOTH_SSN VARCHAR2 9 YES MOTHER'S SOCIAL SECURITY NUMBER: Mother's Social
Security Number.
RCRAPP4_SUB_VERIF_SELECTED VARCHAR2 1 YES SUBSEQUENT RECORD SELECTED FOR VERIFICATION:
Subsequent Record Selected For Verification.
RCRAPP4_P_RES_DATE_MO_YR VARCHAR2 6 YES RESIDENT SINCE DATE: Start date of Parent's Residency
in State.
RCRAPP4_S_RES_DATE_MO_YR VARCHAR2 6 YES RESIDENT SINCE DATE: Start date of Student's Residency
in State.
RCRAPP4_PRISONER_MATCH_FLAG VARCHAR2 1 YES PRISONER MATCH: Prisoner Match.
RCRAPP4_HAVE_CHILDREN VARCHAR2 1 YES HAVE CHILDRENYOU SUPPORT: Do you have children who
receive more than half of their support from you.
RCRAPP4_PAR_WORKSHEET_C NUMBER 5 YES PARENT'S WORKSHEET C TOTAL: Parent's total amount from
Worksheet C.
RCRAPP4_WORKSHEET_C NUMBER 5 YES STUDENT'S/SPOUSE'S WORKSHEET C TOTAL: Student and
spouse total amount from Worksheet C.
RCRAPP4_SOURCE_CORRECTION VARCHAR2 1 YES SOURCE OF CORRECTION: The source of the correction.
RCRAPP4_EFC_CHANGE_IND VARCHAR2 1 YES EFC CHANGE FLAG: The EFC Change flag indicates if the
EFC has increased or decreased.
RCRAPP4_DUP_SSN_IND VARCHAR2 1 YES DUPLICATE SSN INDICATOR: The duplicate SSN indicator
identifies whether more than one person is using the
same SSN.
RCRAPP4_EARLY_ADM_FLAG VARCHAR2 1 YES EARLY ADMISSION FLAG: Used to indicate a student
requesting early admission.
RCRAPP4_SEC_INS_MATCH_IND VARCHAR2 1 YES SECONDARY DHS MATCH FLAG: Secondary DHS Match Flag.
This field holds the DHS verification number 2004-2005
changed INS to DHS.
RCRAPP4_WORKSHEET_A NUMBER 5 YES STUDENT'S WORKSHEET A TOTAL: Student's Worksheet A
untaxed income total.
RCRAPP4_PAR_WORKSHEET_A NUMBER 5 YES PARENTS' WORKSHEET A TOTAL: Parents' Worksheet A
untaxed income total.
RCRAPP4_WORKSHEET_B NUMBER 5 YES STUDENT'S WORKSHEET B TOTAL: Student's Worksheet B
untaxed income total.
RCRAPP4_PAR_WORKSHEET_B NUMBER 5 YES PARENTS' WORKSHEET B TOTAL: Parents' Worksheet B
untaxed income total.
RCRAPP4_SS_MATCH VARCHAR2 1 YES SELECTIVE SERVICE MATCH FLAG: Results from the
Selective Service match.
RCRAPP4_SS_REG_FLAG VARCHAR2 1 YES SELECTIVE SERVICE REGISTRATION FLAG: Results from the
student's request to be registered with the Selective
Service.
RCRAPP4_FATH_FIRST_NAME_INI VARCHAR2 1 YES FATHER'S /STEPFATHER'S FIRST NAME INITIAL
RCRAPP4_FATH_BIRTH_DATE DATE 7 YES FATHER'S/STEPFATHER'S DATE OF BIRTH
RCRAPP4_MOTH_FIRST_NAME_INI VARCHAR2 1 YES MOTHER'S/STEPMOTHER'S FIRST NAME INITIAL
Date: 21-JUN-2004 Page: 59
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRAPP4_MOTH_BIRTH_DATE DATE 7 YES MOTHER'S/STEPMOTHER'S DATE OF BIRTH
RCRAPP4_P_EMAIL_ADDRESS VARCHAR2 50 YES PARENT'S EMAIL ADDRESS: Parent's Email Address.
RCRAPP4_ADDRESS_CHG_FLAG VARCHAR2 1 YES ADDRESS ONLY CHANGE FLAG: Address Only Change Flag
RCRAPP4_PUSH_ISIR_FLAG VARCHAR2 1 YES CPS PUSHED ISIR FLAG: CPS Pushed ISIR Flag
RCRAPP4_SAR_C_CHANGE_FLAG VARCHAR2 1 YES SAR C CHANGE FLAG: SAR C Change Flag
Date: 21-JUN-2004 Page: 60
TABLE: RCRESAR
CREATOR: FAISMGR
Financial Aid Application Table - ESAR Data
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRESAR_AIDY_CODE VARCHAR2 4 NO
RCRESAR_PIDM NUMBER 8 NO
RCRESAR_INFC_CODE VARCHAR2 7 NO
RCRESAR_SEQ_NO NUMBER 3 NO
RCRESAR_USER_ID VARCHAR2 30 NO
RCRESAR_ACTIVITY_DATE DATE 7 NO
RCRESAR_PELL_ID VARCHAR2 6 YES
RCRESAR_TRANS_MDE_IND VARCHAR2 1 YES
RCRESAR_NAME_SSN_CHG_IND VARCHAR2 1 YES
RCRESAR_PGI_AWARD_IND VARCHAR2 1 YES
RCRESAR_RIT_IND VARCHAR2 2 YES
RCRESAR_PGI_ADJ_IND VARCHAR2 1 YES
RCRESAR_HOLD_STATUS_IND VARCHAR2 1 YES
RCRESAR_SYS_GEN_IND VARCHAR2 1 YES
RCRESAR_AGENCY_IND VARCHAR2 2 YES
RCRESAR_BATCH_NO NUMBER 17 YES
RCRESAR_TRAN_TYPE VARCHAR2 1 YES
RCRESAR_A_CITZ_IND VARCHAR2 1 YES
RCRESAR_A_MRTL_STATUS_IND VARCHAR2 1 YES
RCRESAR_A_BORN_BEFORE_IND VARCHAR2 1 YES
RCRESAR_A_FAM_MEMB NUMBER 2 YES
RCRESAR_A_NO_IN_COLL NUMBER 1 YES
RCRESAR_A_TAX_FILED_IND VARCHAR2 1 YES
RCRESAR_A_EXP_TAX_FILED_IND VARCHAR2 1 YES
RCRESAR_A_US_INC NUMBER 6 YES
RCRESAR_A_INC_TAX_PD_IND VARCHAR2 1 YES
RCRESAR_A_EXP_TAX_PD_IND VARCHAR2 1 YES
RCRESAR_A_INC_FR_WRK NUMBER 6 YES
RCRESAR_A_SPS_INC_FR_WRK NUMBER 6 YES
RCRESAR_A_SS_BENE_IND VARCHAR2 1 YES
RCRESAR_A_AFDC_IND VARCHAR2 1 YES
RCRESAR_A_CHILD_SUPP_IND VARCHAR2 1 YES
RCRESAR_A_MED_DEN_EXP_IND VARCHAR2 1 YES
RCRESAR_A_TUIT_PAID_IND VARCHAR2 1 YES
RCRESAR_A_NO_CHILD_TUIT NUMBER 1 YES
RCRESAR_A_GI_DEAB_AMT NUMBER 3 YES
RCRESAR_A_GI_DEAB_MTH NUMBER 2 YES
RCRESAR_A_VEAP_BEN_AMT_IND VARCHAR2 1 YES
RCRESAR_A_VEAP_BEN_MTH NUMBER 2 YES
RCRESAR_A_DISL_WRK_IND VARCHAR2 1 YES
RCRESAR_A_EXP_INC_FR_WRK_IND VARCHAR2 1 YES
RCRESAR_A_EXP_SPS_INC_WRK_IND VARCHAR2 1 YES
RCRESAR_A_DISP_HME_IND VARCHAR2 1 YES
RCRESAR_A_HME_VAL_IND VARCHAR2 1 YES
Date: 21-JUN-2004 Page: 61
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRESAR_A_HME_DBT_IND VARCHAR2 1 YES
RCRESAR_A_RE_INV_VAL_IND VARCHAR2 1 YES
RCRESAR_A_RE_INV_DBT_IND VARCHAR2 1 YES
RCRESAR_A_BUS_FARM_VAL_IND VARCHAR2 1 YES
RCRESAR_A_BUS_FARM_DBT_IND VARCHAR2 1 YES
RCRESAR_A_INCL_FARM_IND VARCHAR2 1 YES
RCRESAR_A_PAR_MRTL_STATUS_IND VARCHAR2 1 YES
RCRESAR_A_PAR_FAM_MEMB NUMBER 2 YES
RCRESAR_A_PAR_NO_IN_COLL NUMBER 1 YES
RCRESAR_A_PAR_TAX_FILED_IND VARCHAR2 1 YES
RCRESAR_A_PAR_EXP_TX_FILED_IND VARCHAR2 1 YES
RCRESAR_A_PAR_US_INC NUMBER 6 YES
RCRESAR_A_PAR_INC_TAX_PD_IND VARCHAR2 1 YES
RCRESAR_A_PAR_EXP_TAX_PD_IND VARCHAR2 1 YES
RCRESAR_A_FATH_INC_FR_WRK NUMBER 6 YES
RCRESAR_A_MOTH_INC_FR_WRK NUMBER 6 YES
RCRESAR_A_PAR_MED_DEN_EXP_IND VARCHAR2 1 YES
RCRESAR_A_PAR_TUIT_PAID_IND VARCHAR2 1 YES
RCRESAR_A_PAR_NO_CHILD_TUIT NUMBER 1 YES
RCRESAR_A_PAR_DISL_WRK_IND VARCHAR2 1 YES
RCRESAR_A_FATH_EXP_INC_WRK_IND VARCHAR2 1 YES
RCRESAR_A_MOTH_EXP_INC_WRK_IND VARCHAR2 5 YES
RCRESAR_A_PAR_DISP_HME_IND VARCHAR2 1 YES
RCRESAR_A_PAR_INCL_FARM_IND VARCHAR2 1 YES
RCRESAR_ALT_1_FC_01_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_02_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_03_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_04_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_05_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_06_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_07_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_08_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_10_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_11_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_1_FC_12_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_01_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_02_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_03_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_04_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_05_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_06_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_07_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_08_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_10_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_11_MTH_CALC NUMBER 5 YES
RCRESAR_ALT_2_FC_12_MTH_CALC NUMBER 5 YES
RCRESAR_COMM_CODE_01 NUMBER 3 YES
RCRESAR_COMM_CODE_02 NUMBER 3 YES
RCRESAR_COMM_CODE_03 NUMBER 3 YES
RCRESAR_COMM_CODE_04 NUMBER 3 YES
Date: 21-JUN-2004 Page: 62
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRESAR_COMM_CODE_05 NUMBER 3 YES
RCRESAR_COMM_CODE_06 NUMBER 3 YES
RCRESAR_COMM_CODE_07 NUMBER 3 YES
RCRESAR_COMM_CODE_08 NUMBER 3 YES
RCRESAR_COMM_CODE_09 NUMBER 3 YES
RCRESAR_COMM_CODE_10 NUMBER 3 YES
RCRESAR_COMM_CODE_11 NUMBER 3 YES
RCRESAR_COMM_CODE_12 NUMBER 3 YES
RCRESAR_COMM_CODE_13 NUMBER 3 YES
RCRESAR_COMM_CODE_14 NUMBER 3 YES
RCRESAR_COMM_CODE_15 NUMBER 3 YES
RCRESAR_COMM_CODE_16 NUMBER 3 YES
RCRESAR_COMM_CODE_17 NUMBER 3 YES
RCRESAR_COMM_CODE_18 NUMBER 3 YES
RCRESAR_COMM_CODE_19 NUMBER 3 YES
RCRESAR_COMM_CODE_20 NUMBER 3 YES
RCRESAR_EDE_INST_IND VARCHAR2 1 YES ELECTRONIC APPLICATION ENTRY SOURCE CODE: The origin
of the electronic application.
RCRESAR_A_BAL_ON_ALL_STAF VARCHAR2 1 YES
RCRESAR_A_RECENT_STAF_BAL VARCHAR2 1 YES
RCRESAR_STAGE_0_REJ_CODE_1 VARCHAR2 1 YES STAGE 0 REJECT CODE: Institution ID is not authorized
for participation in stage 0. Y = rejected, blank =
not rejected.
RCRESAR_STAGE_0_REJ_CODE_2 VARCHAR2 1 YES STAGE 0 REJECT CODE 2: Record not signed by applicant.
Y = rejected, blank = not rejected.
RCRESAR_STAGE_0_REJ_CODE_3 VARCHAR2 1 YES STAGE 0 REJECT CODE 3: Alpha value in numeric field.
Y = rejected, blank = not rejected.
RCRESAR_STAGE_0_REJ_CODE_4 VARCHAR2 1 YES STAGE 0 REJECT CODE 4: Numeric value in alpha field.
Y = rejected, blank = not rejected.
RCRESAR_STAGE_0_REJ_CODE_5 VARCHAR2 1 YES STAGE 0 REJECT CODE 5: Data field value out of
specified range. Y = rejected, blank = not rejected.
RCRESAR_STAGE_0_REJ_CODE_6 VARCHAR2 1 YES STAGE 0 REJECT CODE 6: Dependency override or special
condition not submitted on Correction Application. Y
= rejected, blank = not rejected.
RCRESAR_STAGE_0_REJ_CODE_7 VARCHAR2 1 YES STAGE 0 REJECT CODE 7: FAA signature not submitted on
dependency override. Y = rejected, blank = not
rejected.
RCRESAR_STAGE_0_REJ_CODE_8 VARCHAR2 1 YES STAGE 0 REJECT CODE 8: Blank or invalid encryption
code. Y = rejected, blank = not rejected.
RCRESAR_STAGE_0_REJ_CODE_9 VARCHAR2 1 YES STAGE 0 REJECT CODE 9: Destination point submitting
Renewal Application was not requesting destination
point. Y = rejected, blank = not rejected.
RCRESAR_STAGE_0_REJ_CODE_10 VARCHAR2 1 YES STAGE 0 REJECT CODE 10: Renewal application record is
not on the renewal application data base. Y =
rejected, blank = not rejected.
RCRESAR_A_MARRIED VARCHAR2 1 YES STUDENT ASSUMED MARRIED: Indicates that the assumption
is used to determine thata student is married.
RCRESAR_A_P_LIVE_ON_FARM VARCHAR2 1 YES PARENTS ASSUMED LIVE ON FARM: Indicates that an
assumption is used to determine whether the parents
are living on a farm.
RCRESAR_A_S_BUS_DBT VARCHAR2 1 YES STUDENT'S BUSINESS DEBT ASSUMED: Indicates that an
assumption is used to determine the student's business
debt.
Date: 21-JUN-2004 Page: 63
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRESAR_A_S_BUS_VAL VARCHAR2 1 YES STUDENT'S BUSINESS VALUE ASSUMED: Indicates that an
assumption is used to determine the student's business
value.
RCRESAR_A_S_FARM_DBT VARCHAR2 1 YES STUDENT'S FARM DEBT ASSUMED: Indicates that an
assumption is used to determine the student's farm
debt.
RCRESAR_A_S_FARM_VAL VARCHAR2 1 YES STUDENT'S FARM VALUE ASSUMED: Indicates that an
assumption is used to determine the student's farm
value.
RCRESAR_A_S_LIVE_ON_FARM VARCHAR2 1 YES STUDENT LIVE ON FARM ASSUMED: Indicates that an
assumption is used to determine that a student is
living on a farm.
RCRESAR_DUP_REQ_IND VARCHAR2 1 YES DUPLICATE REQUEST INDICATOR: Indicates that the record
was sent to the institution as a result of a request
for a duplicate ESAR
RCRESAR_A_S_BAL_SLS VARCHAR2 1 YES ASSUMED BALANCE SLS: Value of P means student reported
a negative value. CPS assumed same positive value
RCRESAR_VERIF_TYPE VARCHAR2 2 YES VERIFICATION TYPE: Indicates the results of the
verification edits on this transaction number. May be
different from Verification Message on transactions
above number 1
RCRESAR_CORR_APPL VARCHAR2 2 YES CORRECTION APPLIED: Indicates the transaction number
to which the history correction was applied
RCRESAR_EXP_IV_INC NUMBER 5 YES EXPECTED TITLE IV INCOME EXCLUSIONS: Student/parent
expected Title IV income exclusions
RCRESAR_A_S_IV_INC NUMBER 5 YES ASSUMED STUDENT TITLE IV INCOME EXCLUSIONS: Represents
the value assumed by the CPS for the student Title IV
income exclusions
RCRESAR_A_P_IV_INC NUMBER 5 YES ASSUMED PARENT TITLE IV INCOME EXCLUSIONS: Represents
the value assumed by the CPS for the parent Title IV
income exclusions
RCRESAR_A_EXP_IV_INC NUMBER 5 YES ASSUMED EXPECTED TITLE IV INCOME EXCLUSIONS:
Represents the value assumed by the CPS for the
expected student/parent Title IV income exclusions
RCRESAR_PELL_ELGBL VARCHAR2 1 YES PELL GRANT ELIGIBILITY FLAG: This field indicates
applicants eligibility as of this transaction for a
Federal Pell Grant.
RCRESAR_SUB_APP VARCHAR2 1 YES SUBSEQUENT APPLICATION FLAG: This field indicates if
subsequent application from applicant.
RCRESAR_REC_TYPE VARCHAR2 1 YES
RCRESAR_A_S_FIT NUMBER 5 YES ASSUMED STUDENT'S U.S. TAX PAID: This field indicates
the assumed amount of U.S. Tax paid by the student.
RCRESAR_A_S_SS_BEN NUMBER 5 YES ASSUMED STUDENT'S SSB: This field indicates the
assumed amount of Social Security Benefits received by
the student.
RCRESAR_A_S_AFDC NUMBER 5 YES ASSUMED STUDENT'S AFDC: This field indicates the
assumed amount of AFDC benefits received by the
student.
RCRESAR_A_S_CHILD_SUPP NUMBER 5 YES ASSUMED STUDENT'S CHILD SUPPORT: This field indicates
the assumed amount of child support received by the
student.
RCRESAR_A_S_RE_INV_VAL NUMBER 6 YES ASSUMED STUDENT'S INVESTMENT VALUE: This field
indicates the student's assumed amount of investment
value.
Date: 21-JUN-2004 Page: 64
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRESAR_A_BUS_VAL NUMBER 7 YES ASSUMED STUDENT'S BUSINESS VALUE: This field indicates
the student's assumed amount of business value.
RCRESAR_A_FARM_VAL NUMBER 7 YES ASSUMED STUDENT'S INVESTMENT FARM VALUE: This field
indicates the student's assumed investment farm value.
RCRESAR_A_P_FIT NUMBER 6 YES ASSUMED PARENTS' U.S. TAX PAID: This field indicates
the parents' assumed tax paid amount.
RCRESAR_A_S_EXP_FIT NUMBER 6 YES ASSUMED EXPECTED INCOME TAX PAID: This field indicates
the assumed expected tax to be paid.
RCRESAR_EARLY_ADM_FLAG VARCHAR2 1 YES EARLY ADMISSION FLAG: This field indicates if the
student has an early admission flag or not.
RCRESAR_SAR_ACKNOWL_CD VARCHAR2 20 YES SAR ACKNOWLEDGEMENT CODES: This field indicates the
SAR acknowledgement codes.
RCRESAR_A_S_EIC NUMBER 5 YES ASSUMED STUDENT'S EARNED INCOME CREDIT: This field
indicates the assumed amount of earned income credit
for the student.
RCRESAR_A_P_EIC NUMBER 5 YES ASSUMED PARENTS' EARNED INCOME CREDIT: This field
indicates the assumed amount of earned income credit
for the parents.
RCRESAR_A_S_OTH_UNTAX_INC NUMBER 5 YES ASSUMED STUDENT'S OTHER UNTAXED INCOME: This field
indicates the assumed amount of other untaxed income
for the student.
RCRESAR_A_P_OTH_UNTAX_INC NUMBER 5 YES ASSUMED PARENTS' OTHER UNTAXED INCOME: This field
indicates the assumed amount of other untaxed income
for the parents.
RCRESAR_A_P_AFDC NUMBER 5 YES ASSUMED PARENTS' AFDC: This field indicates the
assumed amount of AFDC received by the parents.
RCRESAR_A_P_CHILD_SUPPORT NUMBER 5 YES ASSUMED PARENTS' CHILD SUPPORT: This field indicates
the assumed amount of child support the parents will
receive.
RCRESAR_A_S_DEPENDANTS VARCHAR2 1 YES
RCRESAR_BATCH_ID VARCHAR2 23 YES BATCH ID: This is the ID of the batch, assigned by the
processor, from which this ESAR data was loaded into
the system. Alphanumeric, replaces numeric batch
number starting in 9697 aid year.
RCRESAR_TRAN_RECEIPT_DATE DATE 7 YES TRANSACTION RECEIPT DATE: The date the FAFSA ISIR
information was received at the CPS.
RCRESAR_MDE_SITE_CD VARCHAR2 2 YES TRANSACTION SOURCE SITE CODE: The origin and site code
for the transaction.
RCRESAR_APPL_SRC_SITE_CD VARCHAR2 1 YES APPLICATION SOURCE SITE CODE: The Site Location for
the initial paper or electronic application. 1 = Site
1, 2 = Site 2.
RCRESAR_RE_PROC_REA_CD VARCHAR2 2 YES REPROCESSED REASON CODE: The code for the reason the
application was reprocessed.
RCRESAR_A_P_SSB NUMBER 5 YES PARENT SOCIAL SECURITY BENEFITS: The assumed parents
social security benefits.
RCRESAR_FED_HOUS_CDE_1 VARCHAR2 1 YES FEDERAL HOUSING CODE 1: This field indicates the
federal housing code associated with the student's
first federal college choice.
RCRESAR_FED_HOUS_CDE_2 VARCHAR2 1 YES FEDERAL HOUSING CODE 2: This field indicates the
federal housing code associated with the student's
second federal college choice.
Date: 21-JUN-2004 Page: 65
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRESAR_FED_HOUS_CDE_3 VARCHAR2 1 YES FEDERAL HOUSING CODE 3: This field indicates the
federal housing code associated with the student's
third federal college choice.
RCRESAR_FED_HOUS_CDE_4 VARCHAR2 1 YES FEDERAL HOUSING CODE 4: This field indicates the
federal housing code associated with the student's
fourth federal college choice.
RCRESAR_FED_HOUS_CDE_5 VARCHAR2 1 YES FEDERAL HOUSING CODE 5: This field indicates the
federal housing code associated with the student's
fifth federal college choice.
RCRESAR_FED_HOUS_CDE_6 VARCHAR2 1 YES FEDERAL HOUSING CODE 6: This field indicates the
federal housing code associated with the student's
sixth federal college choice.
RCRESAR_ELEC_APP_VERSION_NO VARCHAR2 6 YES ELECTRONIC APPLICATION VERSION NUMBER: This field
indicates the version number of the student's
electronic application.
RCRESAR_ETI_DEST_CODE VARCHAR2 7 YES ETI DESTINATION CODE: This field indicates the TGXXXXX
number for the destination code of the transaction.
RCRESAR_COMPUTE_BATCH_NO NUMBER 3 YES COMPUTED BATCH NUMBER: This field indicates the
computed batch number assigned by the Central
Processor to this ISIR.
RCRESAR_PAID_EFC NUMBER 5 YES PAID EFC: This field indicates the EFC upon which the
school based its payment, as reported to the Central
Processor.
RCRESAR_SEC_EFC_TYPE VARCHAR2 1 YES SECONDARY EFC TYPE: This field indicates the type of
the secondary Expected Family Contribution.
RCRESAR_A_VA_STATUS VARCHAR2 1 YES ASSUMED VA STATUS: This field indicates the assumed
veteran status of the student.
RCRESAR_DUP_PROCESSED_DATE DATE 7 YES DUPLICATE PROCESSED DATE: This field indicates the
date upon which the duplicate ISIR record was
processed.
RCRESAR_CORR_FLAGS VARCHAR2 120 YES CORRECTION FLAGS: This field indicates which fields in
this ISIR have been changed. For example, a '1' in
position 3 would mean that ISIR Field Number 3 has
changed.
RCRESAR_HIGH_FLAGS VARCHAR2 120 YES HIGHLIGHT FLAGS: This field indicates which fields in
this ISIR should be printed with highlighting. For
example, a '1' in position 3 would mean that ISIR
Field Number 3 should be highlighted when printed on
an ISIR.
RCRESAR_A_FATH_SSN VARCHAR2 9 YES ASSUMED FATHER'S SOCIAL SECURITY NUMBER: Assumed
Father's Social Security Number.
RCRESAR_INPUT_REC_TYPE VARCHAR2 1 YES INPUT RECORD TYPE: Type of Input Record.
RCRESAR_A_MOTH_SSN VARCHAR2 9 YES ASSUMED MOTHER'S SOCIAL SECURITY NUMBER: Assumed
Mother's Social Security Number.
RCRESAR_A_HAVE_CHILDREN VARCHAR2 1 YES ASSUMED HAVE CHILDREN YOU SUPPORT: Assumed have
children you support who receive more than half of
their support from you.
RCRESAR_AUTO_ZERO_EFC_FLAG VARCHAR2 1 YES AUTOMATIC ZERO EFC FLAG: EFC automatically set to zero
based on income criteria.
RCRESAR_SERIAL_NUMBER NUMBER 5 YES SERIAL NUMBER: Sequential position of ISIR in batch in
which it is received
RCRESAR_DEP_INDEP_IND VARCHAR2 1 YES DEPENDENCY STATUS: The student's dependency status. D
= Dependent; I = Independent
Date: 21-JUN-2004 Page: 66
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRESAR_GRADUATE_FLAG VARCHAR2 1 YES GRADUATE FLAG: Indicates a graduate student based on
responses to graduate questions.
RCRESAR_PRI_EFC_TYPE VARCHAR2 1 YES PRIMARY EFC TYPE: Identifies the formula typed used to
calculate the primary EFC Valid values are 1 - 6.
RCRESAR_SEC_TI NUMBER 7 YES SEC TI: Secondary Total Income
RCRESAR_SEC_ATI NUMBER 7 YES SEC ATI: Secondary Allowances Against Total Income
RCRESAR_SEC_STX NUMBER 7 YES SEC STX: Secondary State Tax Allowance
RCRESAR_SEC_EA NUMBER 7 YES SEC EA: Secondary Employment Allowance
RCRESAR_SEC_IPA NUMBER 7 YES SEC IPA: Secondary Income Protection Allowance
RCRESAR_SEC_AI NUMBER 7 YES SEC AI: Secondary Available Income
RCRESAR_SEC_CAI NUMBER 7 YES SEC CAI: Secondary Contribution from Available Income
RCRESAR_SEC_DNW NUMBER 9 YES SEC DNW: Secondary Discretionary Net Worth
RCRESAR_SEC_NW NUMBER 9 YES SEC NW: Secondary Net Worth
RCRESAR_SEC_APA NUMBER 9 YES SEC APA: Secondary Asset Protection Allowances
RCRESAR_SEC_PCA NUMBER 7 YES SEC PCA: Secondary Parents' Contribution from Assets
RCRESAR_SEC_AAI NUMBER 7 YES SEC AAI: Secondary Adjusted Available Income
RCRESAR_SEC_TSC NUMBER 7 YES SEC TSC: Secondary Total Student Contribution
RCRESAR_SEC_TPC NUMBER 7 YES SEC TPC: Secondary Total Parent Contribution
RCRESAR_SEC_PC NUMBER 7 YES SEC PC: Secondary Parents' Contribution
RCRESAR_SEC_STI NUMBER 7 YES SEC STI: Secondary Students' Total Income
RCRESAR_SEC_SATI NUMBER 7 YES SEC SATI: Secondary Student's Allowance Against Total
Income
RCRESAR_SEC_SIC NUMBER 7 YES SEC SIC: Secondary Student's Dependent Income
Contribution
RCRESAR_SEC_SDNW NUMBER 9 YES SECSDNW: Secondary Student's Discretionary Net Worth
RCRESAR_SEC_SCA NUMBER 7 YES SEC SDNW: Secondary Student's Contribution from Assets
RCRESAR_A_S_WORKSHEET_C NUMBER 5 YES ASSUMED STUDENT'S WORKSHEET C TOTAL: Assumed Student's
Worksheet C Title IV Income Exclusions Total
RCRESAR_A_P_WORKSHEET_C NUMBER 5 YES ASSUMED PARENTS' WORKSHEET C TOTAL: Assumed Parents'
Worksheet C Title IV Income Exclusions Total
RCRESAR_DATA_VERIFY_FLAG VARCHAR2 120 YES FAFSA DATA VERIFY FLAG: Each flag byte corresponds to
a specific SAR field and indicates fields corrected
status.
RCRESAR_EDE_ETI_IND VARCHAR2 1 YES ISIR ELECTRONIC TRANSACTION INDICATOR (ETI): ISIR
Electronic Transaction Indicator (ETI)
RCRESAR_M_SCHOOL_FLAG_1 VARCHAR2 1 YES MULTI SCHOOL CODE FLAG 1: Multi School Code Flag 1
RCRESAR_M_SCHOOL_FLAG_2 VARCHAR2 1 YES MULTI SCHOOL CODE FLAG 2: Multi School Code Flag 2
RCRESAR_M_SCHOOL_FLAG_3 VARCHAR2 1 YES MULTI SCHOOL CODE FLAG 3: Multi School Code Flag 3
RCRESAR_M_SCHOOL_FLAG_4 VARCHAR2 1 YES MULTI SCHOOL CODE FLAG 4: Multi School Code Flag 4
RCRESAR_M_SCHOOL_FLAG_5 VARCHAR2 1 YES MULTI SCHOOL CODE FLAG 5: Multi School Code Flag 5
RCRESAR_M_SCHOOL_FLAG_6 VARCHAR2 1 YES MULTI SCHOOL CODE FLAG 6: Multi School Code Flag 6
Date: 21-JUN-2004 Page: 67
TABLE: RCRIMP1
CREATOR: FAISMGR
Additional CSS PROFILE Data
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLE: 9697.
RCRIMP1_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRIMP1_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record. EXAMPLE: CSS.
RCRIMP1_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application. Zero (0) indicates data associated with
the custodial parent; -1 indicates the non-custodial
parent.
RCRIMP1_CREATOR_ID VARCHAR2 30 NO APPLICATION CREATOR ID: The ID of the person who
created this application record on the database.
RCRIMP1_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RCRIMP1_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date that this
application record was created on the database.
RCRIMP1_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
RCRIMP1_REGIS_RCPT_DATE DATE 7 YES REGISTRATION RECEIPT DATE: The date that CSS received
the PROFILE registration form.
RCRIMP1_REGIS_TYPE VARCHAR2 1 YES REGISTRATION TYPE: Indicates the type (student or
institutional) of registration.
RCRIMP1_APPLIC_TYPE VARCHAR2 1 YES APPLICATION TYPE: Indicates the type (regular or
renewal) of application.
RCRIMP1_ELEC_EXTRACT_DATE DATE 7 YES ELECTRONIC EXTRACT DATE: The date that the data was
extracted for electronic transmission.
RCRIMP1_ADDL_SCHL_REQ_DATE DATE 7 YES ADDITIONAL SCHOOL REQUEST DATE: The date when CSS
received the additional school request.
RCRIMP1_FIN_AID_STATUS VARCHAR2 1 YES FINANCIAL AID STATUS: Indicates the student financial
aid status.
RCRIMP1_CITZ_COUNTRY VARCHAR2 15 YES CITIZENSHIP COUNTRY: The student country of
citizenship.
RCRIMP1_ITEM_DEDUCTNS NUMBER 5 YES ITEMIZED DEDUCTIONS: The itemized deductions reported
by the student.
RCRIMP1_EIC NUMBER 5 YES EARNED INCOME CREDIT: The earned income credit
reported by the student.
RCRIMP1_TAX_STU_AID NUMBER 5 YES TAXABLE STUDENT AID: Earnings from Federal Work-Study
or other need-based work programs plus any grant and
scholarship aid reported on the student U.S. Income
tax return.
RCRIMP1_IRA_KEOGH_ACCT_VAL NUMBER 6 YES VALUE OF IRA/KEOGH ACCOUNT: The total value of the
student IRA, Keogh, 401k, 403b, etc. accounts
RCRIMP1_TRUST_AMT NUMBER 6 YES TRUST AMOUNT: The total value ofall trust accounts for
the student.
Date: 21-JUN-2004 Page: 68
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_TRUST_AVAIL_IND VARCHAR2 1 YES TRUST AVAILABILITY: Indicates whether any trust income
or part of the trust principal is currently available
to the student.
RCRIMP1_TRUST_ESTAB_BY VARCHAR2 1 YES WHO ESTABLISHED THE TRUST: Indicates who established
the trust for the student.
RCRIMP1_EXP_GRANT_SCHLRSHP NUMBER 5 YES EXPECTED GRANTS/SCHOLARSHIPS: The total amount of
grants, scholarships, fellowships, etc. expected from
other than the colleges or universities to which the
student is applying.
RCRIMP1_EXP_TUIT_BENE NUMBER 5 YES EXPECTED TUITION BENEFITS: The total tuition benefits
that the student expects to receive from parents
and/or the student or spouse employer.
RCRIMP1_EXP_PAR_CTRB NUMBER 5 YES EXPECTED PARENT CONTRIBUTION: The amount of
contribution expected from the parents of the student.
RCRIMP1_EXP_OTH_CTRB NUMBER 5 YES EXPECTED OTHER CONTRIBUTION: The total contribution
expected by the student from other relatives, parents
of the spouse, and all other sources.
RCRIMP1_PAR_PRNT_IN_COLL VARCHAR2 1 YES PARENTS IN COLLEGE: Indicates how many parents will be
in college at least half-time during the school year.
RCRIMP1_PAR_NTRL_SEP_DIV VARCHAR2 1 YES NATURAL/ADOPTIVE PARENT MARITAL STATUS: Indicates
whether the natural or adoptive parents of the student
are separated or divorced.
RCRIMP1_PAR_ED_LN_RPAY_AMT NUMBER 5 YES PARENT EDUCATIONAL LOANS REPAYMENT: The amount that
the parents are spending for repayment of educational
loans during the current year.
RCRIMP1_EXP_PAR_CHILD_SUPP_PD NUMBER 5 YES EXPECTED PARENT CHILD SUPPORT PAID: The expected child
support paid to be paid by the parents.
RCRIMP1_EXP_PAR_ED_LN_RPAY_AMT NUMBER 5 YES EXPECTED PARENT EDUCATIONAL LOANS REPAYMENT: The
expected amount that the parents will be spending for
repayment of educational loans.
RCRIMP1_EXP_PAR_MED_DEN_EXPN NUMBER 5 YES EXPECTED PARENT MED/DENTAL EXPENSES: The amount that
the parents expect to spend on medical and dental
expenses.
RCRIMP1_PAR_OWN_BUS_FARM VARCHAR2 1 YES PARENTS OWN A BUSINESS OR FARM: Indicates whether the
parents own all or part of a business or farm.
RCRIMP1_PAR_OTH_RE_YR_PURCH NUMBER 4 YES YEAR PARENTS PURCHASED OTHER REAL ESTATE: The year
(YY) when the parents purchased other real estate.
RCRIMP1_PAR_OTH_RE_PURCH_AMT NUMBER 7 YES PARENT OTHER REAL ESTATE PRICE: The amount that the
parents paid for other real estate.
RCRIMP1_PAR_PRYR_AGI NUMBER 7 YES PARENT PRIOR YEAR AGI: The amount of AGI reported by
the parents on their prior year federal tax return.
RCRIMP1_PAR_PRYR_US_TAX_PD NUMBER 6 YES PARENT PRIOR YEAR US TAXES PAID: The amount of federal
income tax reported by the parents on their prior year
federal tax return.
RCRIMP1_PAR_PRYR_ITEM_DEDUCTNS NUMBER 6 YES PARENT PRIOR YEAR ITEMIZED DEDUCTIONS: The amount of
itemized deductions reported by the parents on their
prior year federal tax return.
RCRIMP1_PAR_PRYR_UNTAX_INC NUMBER 6 YES PARENT PRIOR YEAR UNTAXED INCOME: The amount of
untaxed income received by the parents during the
prior year.
RCRIMP1_PAR_ITEM_DEDUCTNS NUMBER 6 YES PARENT ITEMIZED DEDUCTIONS: The itemized deductions
reported by the parents.
Date: 21-JUN-2004 Page: 69
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_COLL_CDE_9 VARCHAR2 6 YES COLLEGE CODE 9: The ninth college/program code listed
by the student on the aid application for receipt of
information.
RCRIMP1_HOUS_CDE_9 VARCHAR2 1 YES HOUSING CODE 9: The housing code for the school listed
ninth on the application indicating the student
expected place of residence at school.
RCRIMP1_COLL_CDE_10 VARCHAR2 6 YES COLLEGE CODE 10: The tenth college/program code listed
by the student on the aid application for receipt of
information.
RCRIMP1_HOUS_CDE_10 VARCHAR2 1 YES HOUSING CODE 10: The housing code for the school
listed tenth on the application indicating the student
expected place of residence at school.
RCRIMP1_ADDL_COLL_CDE_9 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 9: The ninth school code if
more than ten school codes were requested through an
original application or an additional college request.
RCRIMP1_ADDL_COLL_CDE_10 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 10: The tenth school code if
more than ten school codes were requested through an
original application or an additional college request.
RCRIMP1_SIGNED_CERTIFIED VARCHAR2 1 YES CERTIFIED SIGNATURE: Indicates whether the student
signature of certification is present.
RCRIMP1_PAR_ALT_HME_DBT NUMBER 7 YES OPTION PARENT HOME DEBT: The parent home debt that was
used during the IM calculation of home value.
RCRIMP1_PAR_ALT_AAI_RATE VARCHAR2 1 YES PARENT ALTERNATE AAI RATE: Indicates whether the
alternate AAI rate table was used during the parent IM
calculation.
RCRIMP1_ALT_IRA_KEOGH VARCHAR2 1 YES IRA/KEOGH OPTION: Indicates whether the institutional
option for calculation of IRA/KEOGH assets was used
during the student IM calculation.
RCRIMP1_ALT_AI_RATE VARCHAR2 1 YES AI RATE OPTION: Indicates whether the institutional
option for AI rate was used during the student IM
calculation.
RCRIMP1_S_ALT_OPT_HME_VAL VARCHAR2 1 YES HOME VALUE OPTION: Indicates whether the option for
calculating home value was used during the student IM
calculation.
RCRIMP1_ALT_HME_VAL NUMBER 6 YES OPTION HOME VALUE: The home value calculated during
the student IM calculation.
RCRIMP1_ALT_HME_DBT NUMBER 6 YES OPTION HOME DEBT: The home debt used during the IM
calculation of the student home value.
RCRIMP1_ALT_SUM_AY_INC VARCHAR2 1 YES OPTION FOR SUMMER/ACADEMIC YEAR INCOME: Indicates
whether the institutional option regarding student
summer/academic year income was used during the
student IM calculation.
RCRIMP1_C_2_CTRB_ADJ_1_8_MTH NUMBER 5 YES OPTIONAL IM 1-8 MONTHADJUSTMENT: Reserved for future
use.
RCRIMP1_C_2_CTRB_ADJ_OVR_9_MTH NUMBER 5 YES OPTIONAL IM OVER-9 MONTH ADJUSTMENT: Reserved for
future use.
RCRIMP1_MSG_6 VARCHAR2 1 YES MESSAGE 6 INDICATOR: Indicates whether CSS Message 6
is present or not.
RCRIMP1_MSG_7 VARCHAR2 1 YES MESSAGE 7 INDICATOR: Indicates whether CSS Message 7
is present or not.
Date: 21-JUN-2004 Page: 70
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_MSG_8 VARCHAR2 1 YES MESSAGE 8 INDICATOR: Indicates whether CSS Message 8
is present or not.
RCRIMP1_MSG_9 VARCHAR2 1 YES MESSAGE 9 INDICATOR: Indicates whether CSS Message 9
is present or not.
RCRIMP1_MSG_10 VARCHAR2 1 YES MESSAGE 10 INDICATOR: Indicates whether CSS Message 10
is present or not.
RCRIMP1_MSG_20 VARCHAR2 1 YES MESSAGE 20 INDICATOR: Indicates whether CSS Message 20
is present or not.
RCRIMP1_MSG_25 VARCHAR2 1 YES MESSAGE 25 INDICATOR: Indicates whether CSS Message 25
is present or not.
RCRIMP1_MSG_34 VARCHAR2 1 YES MESSAGE 34 INDICATOR: Indicates whether CSS Message 34
is present or not.
RCRIMP1_MSG_35 VARCHAR2 1 YES MESSAGE 35 INDICATOR: Indicates whether CSS Message 35
is present or not.
RCRIMP1_MSG_36 VARCHAR2 1 YES MESSAGE 36 INDICATOR: Indicates whether CSS Message 36
is present or not.
RCRIMP1_MSG_37 VARCHAR2 1 YES MESSAGE 37 INDICATOR: Indicates whether CSS Message 37
is present or not.
RCRIMP1_MSG_38 VARCHAR2 1 YES MESSAGE 38 INDICATOR: Indicates whether CSS Message 38
is present or not.
RCRIMP1_MSG_45 VARCHAR2 1 YES MESSAGE 45 INDICATOR: Indicates whether CSS Message 45
is present or not.
RCRIMP1_MSG_55 VARCHAR2 1 YES MESSAGE 55 INDICATOR: Indicates whether CSS Message 55
is present or not.
RCRIMP1_MSG_56 VARCHAR2 1 YES MESSAGE 56 INDICATOR: Indicates whether CSS Message 56
is present or not.
RCRIMP1_MSG_57 VARCHAR2 1 YES MESSAGE 57 INDICATOR: Indicates whether CSS Message 57
is present or not.
RCRIMP1_MSG_58 VARCHAR2 1 YES MESSAGE 58 INDICATOR: Indicates whether CSS Message 58
is present or not.
RCRIMP1_MSG_59 VARCHAR2 1 YES MESSAGE 59 INDICATOR: Indicates whether CSS Message 59
is present or not.
RCRIMP1_MSG_60 VARCHAR2 1 YES MESSAGE 60 INDICATOR: Indicates whether CSS Message 60
is present or not.
RCRIMP1_MSG_73 VARCHAR2 1 YES MESSAGE 73 INDICATOR: Indicates whether CSS Message 73
is present or not.
RCRIMP1_MSG_FAM_MEMB VARCHAR2 2 YES MATRIX NUMBER IN FAMILY: Independent student number of
family members, derived from the family member matrix,
when the derived value differs from the reported
value.
RCRIMP1_MSG_NUM_IN_COLL VARCHAR2 1 YES MATRIX NUMBER IN COLLEGE: Independent student number
in college, derived from the family member matrix,
when the derived value differs from the reported
value.
RCRIMP1_MSG_AVAIL_INC NUMBER 6 YES NEGATIVE AVAILABLE INCOME: The IM available income for
the student, when the calculated value is negative.
RCRIMP1_MSG_US_TAX NUMBER 6 YES REPORTED US TAXES: The reported US tax amount when
calculated taxes were used in the student FM and IM
computations.
RCRIMP1_MSG_CALC_HME_VAL NUMBER 6 YES CALCULATED HOME EQUITY: The student IM home equity,
calculated using the housing multiplier when the
reported value was blank.
Date: 21-JUN-2004 Page: 71
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_MSG_MULT_HME_VAL NUMBER 6 YES MULTIPLIER HOME VALUE: The student IM home value,
calculated using the housing multiplier.
RCRIMP1_MSG_MULT_HME_EQTY NUMBER 6 YES MULTIPLIER HOME EQUITY: The student IM home equity,
calculated using the housing multiplier.
RCRIMP1_MSG_XPCT_HME_VAL NUMBER 6 YES PERCENTAGE HOME VALUE: The student calculated IM home
value, calculated at 3%, when the reported value shows
an increase of less than 3% per year.
RCRIMP1_MSG_XPCT_HME_EQTY NUMBER 6 YES PERCENTAGE HOME EQUITY: The student calculated IM home
equity, calculated at 3%, when the reported value
shows an increase of less than 3% per year.
RCRIMP1_MSG_CAP_HME_EQTY NUMBER 6 YES CAP HOME EQUITY: The student calculated IM home
equity, using the value cap.
RCRIMP1_MSG_PAR_FAM_MEMB VARCHAR2 2 YES MATRIX PARENT NUMBER IN FAMILY: Parent number of
family members, derived from the family member matrix,
when the derived value differs from the reported
value.
RCRIMP1_MSG_PAR_NUM_IN_COLL VARCHAR2 1 YES MATRIX PARENT NUMBER IN COLLEGE: Parent number in
college, derived from the family member matrix, when
the derived value differs from the reported value.
RCRIMP1_MSG_PAR_AGI_DIFF NUMBER 7 YES PARENT DERIVED AGI: The parent derived AGI, when the
derived value and the reported value differ by $1000
or more.
RCRIMP1_MSG_PAR_US_TAX NUMBER 7 YES PARENT REPORTED US TAXES: The parent reported US tax
amount when calculated taxes were used in the parent
FM and IM computations.
RCRIMP1_MSG_PAR_CALC_HME_VAL NUMBER 7 YES PARENT CALCULATED HOME EQUITY: The parent IM home
equity, calculated using the housing multiplier when
the reported value was blank.
RCRIMP1_MSG_PAR_MULT_HME_VAL NUMBER 7 YES PARENT MULTIPLIER HOME VALUE: The parent IM home
value, calculated using the housing multiplier.
RCRIMP1_MSG_PAR_MULT_HME_EQTY NUMBER 7 YES PARENT MULTIPLIER HOME EQUITY: The parent IM home
equity, calculated using the housing multiplier.
RCRIMP1_MSG_PAR_XPCT_HME_VAL NUMBER 7 YES PARENT PERCENTAGE HOME VALUE: The parent calculated IM
home value, calculated at 3%, when the reported value
shows an increase of less than 3% per year.
RCRIMP1_MSG_PAR_XPCT_HME_EQTY NUMBER 7 YES PARENT PERCENTAGE HOME EQUITY: The parents calculated
IM home equity, calculated at 3%, when the reported
value shows an increase of less than 3% per year.
RCRIMP1_MSG_PAR_CAP_HME_EQTY NUMBER 7 YES PARENT CAP HOME EQUITY: The parent calculated IM home
equity, using the value cap.
RCRIMP1_ASSUMPT_PROF_MSG_1 VARCHAR2 4 YES INAS IM ASSUMPTION 1: The first IM assumption returned
by INAS.
RCRIMP1_ASSUMPT_PROF_MSG_2 VARCHAR2 4 YES INAS IM ASSUMPTION 2: The second IM assumption
returned by INAS.
RCRIMP1_ASSUMPT_PROF_MSG_3 VARCHAR2 4 YES INAS IM ASSUMPTION 3: The third IM assumption returned
by INAS.
RCRIMP1_ASSUMPT_PROF_MSG_4 VARCHAR2 4 YES INAS IM ASSUMPTION 4: The fourth IM assumption
returned by INAS.
RCRIMP1_ASSUMPT_PROF_MSG_5 VARCHAR2 4 YES INAS IM ASSUMPTION 5: The fifth IM assumption returned
by INAS.
RCRIMP1_ASSUMPT_PROF_MSG_6 VARCHAR2 4 YES INAS IM ASSUMPTION 6: The sixth IM assumption returned
by INAS.
Date: 21-JUN-2004 Page: 72
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_ASSUMPT_PROF_MSG_7 VARCHAR2 4 YES INAS IM ASSUMPTION 7: The seventh IM assumption
returned by INAS.
RCRIMP1_ASSUMPT_PROF_MSG_8 VARCHAR2 4 YES INAS IM ASSUMPTION 8: The eighth IM assumption
returned by INAS.
RCRIMP1_ASSUMPT_PROF_MSG_9 VARCHAR2 4 YES INAS IM ASSUMPTION 9: The ninth IM assumption returned
by INAS.
RCRIMP1_ASSUMPT_PROF_MSG_10 VARCHAR2 4 YES INAS IM ASSUMPTION 10: The tenth IM assumption
returned by INAS.
RCRIMP1_BUS_DEPRECIATION NUMBER 7 YES BUSINESS DEPRECIATION: The value of business
depreciations claimed by the student.
RCRIMP1_PAR_BUS_DEPRECIATION NUMBER 7 YES PARENT BUSINESS DEPRECIATION: The value of business
depreciations claimed by the parents.
RCRIMP1_BUS_IN_HOME_MISC NUMBER 7 YES BUSINESS IN THE HOME: The value associated with a
business in the home and other miscellaneous expenses
claimed by the student.
RCRIMP1_PAR_BUS_IN_HOME_MISC NUMBER 7 YES PARENT BUSINESS IN THE HOME: The value associated with
a business in the home and other miscellaneous
expenses claimed by the parents.
RCRIMP1_RENT_DEPRECIATION NUMBER 7 YES RENTAL DEPRECIATION: The value of rental depreciation
claimed by the student.
RCRIMP1_PAR_RENT_DEPRECIATION NUMBER 7 YES PARENT RENTAL DEPRECIATION: The value of rental
depreciation claimed by the parents.
RCRIMP1_OTH_ADDBACK_1 NUMBER 7 YES OTHER ADDBACK 1: The value associated with the first
additional addback category for the student.
RCRIMP1_PAR_OTH_ADDBACK_1 NUMBER 7 YES PARENT OTHER ADDBACK 1: The value associated with the
first additional addback category for the parents.
RCRIMP1_OTH_ADDBACK_2 NUMBER 7 YES OTHER ADDBACK 2: The value associated with the second
additional addback category for the student.
RCRIMP1_PAR_OTH_ADDBACK_2 NUMBER 7 YES PARENT OTHER ADDBACK 2: The value associated with the
second additional addback category for the parents.
RCRIMP1_CUST_NONCUST_PARENT VARCHAR2 1 YES CUSTODIAL/NONCUSTODIAL PARENT: Indicates whether the
associated IM record (custodial or non-custodial)
contains parental data for the Father or for the
Mother.
RCRIMP1_PC_NON_CUST_PAR NUMBER 6 YES CONTRIBUTION FROM NON-CUSTODIAL PARENT: The reported
contribution for the non-custodial parent.
RCRIMP1_LINE2_AGE NUMBER 2 YES LINE 2 AGE: The age of the person listed second on the
family member matrix.
RCRIMP1_LINE3_AGE NUMBER 2 YES LINE 3 AGE: The age of the person listed third on the
family member matrix.
RCRIMP1_LINE4_AGE NUMBER 2 YES LINE 4 AGE: The age of the person listed fourth on the
family member matrix.
RCRIMP1_LINE5_AGE NUMBER 2 YES LINE 5 AGE: The age of the person listed fifth on the
family member matrix.
RCRIMP1_LINE6_AGE NUMBER 2 YES LINE 6 AGE: The age of the person listed sixth on the
family member matrix.
RCRIMP1_LINE7_AGE NUMBER 2 YES LINE 7 AGE: The age of the person listed seventh on
the family member matrix.
RCRIMP1_LINE8_AGE NUMBER 2 YES LINE 8 AGE: The age of the person listed eighth on the
family member matrix.
RCRIMP1_LINE2_SCHL_TYPE VARCHAR2 1 YES LINE 2 SCHOOL TYPE: The type of school attended by the
person listed second on the family member matrix.
Date: 21-JUN-2004 Page: 73
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_LINE3_SCHL_TYPE VARCHAR2 1 YES LINE 3 SCHOOL TYPE: The type of school attended by the
person listed third on the family member matrix.
RCRIMP1_LINE4_SCHL_TYPE VARCHAR2 1 YES LINE 4 SCHOOL TYPE: The type of school attended by the
person listed fourth on the family member matrix.
RCRIMP1_LINE5_SCHL_TYPE VARCHAR2 1 YES LINE 5 SCHOOL TYPE: The type of school attended by the
person listed fifth on the family member matrix.
RCRIMP1_LINE6_SCHL_TYPE VARCHAR2 1 YES LINE 6 SCHOOL TYPE: The type of school attended by the
person listed sixth on the family member matrix.
RCRIMP1_LINE7_SCHL_TYPE VARCHAR2 1 YES LINE 7 SCHOOL TYPE: The type of school attended by the
person listed seventh on the family member matrix.
RCRIMP1_LINE8_SCHL_TYPE VARCHAR2 1 YES LINE 8 SCHOOL TYPE: The type of school attended by the
person listed eighth on the family member matrix.
RCRIMP1_FOREIGN_ADDR_IND VARCHAR2 1 YES FOREIGN ADDRESS INDICATOR: This field is used to
indicate that the student lives outside the U.S.
RCRIMP1_FOREIGN_POSTAL_CDE VARCHAR2 9 YES FOREIGN POSTAL CODE: This field is used to identify
the foreign postal code for students that live outside
the U.S.
RCRIMP1_COUNTRY VARCHAR2 25 YES FOREIGN COUNTRY: This field is used to identify the
country for students that live outside the U.S.
RCRIMP1_PAR_SIBLING_ASSETS NUMBER 7 YES PARENTS ASSETS IN OTHER CHILD NAME: This field is used
to identify the amount of parents' assets held in the
name of a student's siblings
RCRIMP1_HOPE_LL_CREDIT NUMBER 6 YES STUDENT HOPE AND LL CREDITS: Hope and Lifetime
Learning tax credits as reported on student's tax
return.
RCRIMP1_PAR_HOPE_LL_CREDIT NUMBER 6 YES PARENT HOPE AND LL CREDITS: Hope and Lifetime Learning
tax credits as reported on parent's tax return.
RCRIMP1_PAR_YR_SEP VARCHAR2 4 YES PARENT SEPARATION YEAR: Year of parents' separation.
RCRIMP1_PAR_YR_DIV VARCHAR2 4 YES PARENT DIVORCE YEAR: Year of parents' divorce.
RCRIMP1_ONLINE_SIG VARCHAR2 1 YES STUDENT ONLINE SIGNATURE: 1 = Student completed online
version of PROFILE and the signature is electronic, or
blank.
RCRIMP1_HOPE_LL_CREDIT_OPT VARCHAR2 1 YES STUDENT HOPE AND LL CREDIT OPTION: 1 = Institutional
option for student's Hope/LL tax credit used in
calculation.
RCRIMP1_PAR_HOPE_LL_CREDIT_OPT VARCHAR2 1 YES PARENT HOPE AND LL CREDIT OPTION: 1 = Institutional
option for parent's Hope/LL tax credit used in
calculation.
RCRIMP1_AESA VARCHAR2 1 YES STUDENT ANNUAL EDUCATION SAVINGS ALLOWANCE NUMBER OF
CHILDREN: Number of children used in calculation of
Student's Annual Education Savings Allowance
RCRIMP1_PAR_AESA VARCHAR2 1 YES PARENT ANNUAL EDUCATION SAVINGS ALLOWANCE NUMBER OF
CHILDREN: Number of children used in calculation of
Parents' Annual Education Savings Allowance
RCRIMP1_CESA VARCHAR2 2 YES STUDENT CUMULATIVE EDUCATION SAVING ALLOWANCE: Sum of
the ages of children used in calculation of Student's
Cumulative Education Savings Allowance
RCRIMP1_PAR_CESA VARCHAR2 2 YES PARENT CUMULATIVE EDUCATION SAVING ALLOWANCE: Sum of
the ages of children used in calculation of Parents'
Cumulative Education Savings Allowance
RCRIMP1_MSG_13 VARCHAR2 1 YES MESSAGE 13: 1=Student left age of at least one child
blank. Assumed age used in CESA. Blank=No Message
Date: 21-JUN-2004 Page: 74
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_MSG_27 VARCHAR2 1 YES MESSAGE 27: 1=CSS suggests review of student's
reported Hope/LL Credits. Blank=No Message
RCRIMP1_MSG_51 VARCHAR2 1 YES MESSAGE 51: 1=Parents left age of at least one child
blank. Assumed age from CESA. Blank=No message
RCRIMP1_MSG_64 VARCHAR2 1 YES MESSAGE 64: 1=CSS suggests review of parent's reported
Hope/LL Credits. Blank=No Message
RCRIMP1_ANNUAL_ED_SAVINGS NUMBER 5 YES AMOUNT OF STUDENT ANNUAL EDUCATION SAVING ALLOWANCE:
Amount of student's Annual Education Savings Allowance
RCRIMP1_PAR_ANNUAL_ED_SAVINGS NUMBER 5 YES AMOUNT OF PARENT ANNUAL EDUCATION SAVING ALLOWANCE:
Amount of parents' Annual Education Savings Allowance
RCRIMP1_CUM_ED_SAVINGS NUMBER 6 YES AMOUNT OF STUDENT CUMULATIVE EDUCATION SAVINGS: Amount
of student's Cumulative Education Savings Allowance
RCRIMP1_PAR_CUM_ED_SAVINGS NUMBER 6 YES AMOUNT OF PARENT CUMULATIVE EDUCATION SAVINGS: Amount
of parents' Cumulative Education Savings Allowance
RCRIMP1_LOW_INC_ALLOW NUMBER 8 YES STUDENT LOW INCOME ALLOWANCE: Amount of student's low
income allowance
RCRIMP1_PAR_LOW_INC_ALLOW NUMBER 8 YES PARENT LOW INCOME ALLOWANCE: Amount of parents' low
income allowance
RCRIMP1_EMERG_RES_ALLOW NUMBER 5 YES STUDENT EMERGENCY RESERVE ALLOWANCE: Amount of
student's Emergency Reserve Allowance
RCRIMP1_PAR_EMERG_RES_ALLOW NUMBER 5 YES PARENT EMERGENCY RESERVE ALLOWANCE: Amount of parents'
Emergency Reserve Allowance
RCRIMP1_PAR_SIB_PRE_TUIT NUMBER 8 YES SIBLINGS' PRE-PAID TUITION PLAN AMOUNT: Value of
parent's assets in prepaid tuition plans for the
student's brothers and sisters.
RCRIMP1_PAR_STU_PRE_TUIT NUMBER 8 YES STUDENT'S PRE-PAID TUITION PLAN AMOUNT: Value of
parent's assets in prepaid tuition plans for the
student.
RCRIMP1_MSG_39 VARCHAR2 1 YES MESSAGE 39 INDICATOR: Indicates whether CSS message 39
is present or not.
RCRIMP1_MSG_52 VARCHAR2 1 YES MESSAGE 52 INDICATOR: Indicates whether CSS message 52
is present or not.
RCRIMP1_MSG_65 VARCHAR2 1 YES MESSAGE 65 INDICATOR: Indicates whether CSS message 65
is present or not.
RCRIMP1_PAR_OPT_TOT_INC NUMBER 8 YES IM PARENTS' TOTAL INCOME: The parents' Institutional
Methodology total income based on the optional
calculation.
RCRIMP1_PAR_OPT_CTRB_FOR_STDT NUMBER 5 YES IM PARENTS' CONTRIBUTION FOR THE STUDENT: The parents'
Institutional Methodology contribution for the student
based on the optional calculation.
RCRIMP1_PAR_OPT_CTRB_FR_INC NUMBER 5 YES IM PARENTS' CONTRIBUTION FROM INCOME: The parents'
Institutional Methodology optional contribution from
income based on the optional calculation.
RCRIMP1_PAR_OPT_CTRB_FR_ASSET NUMBER 5 YES IM PARENTS' CONTRIBUTION FROM ASSETS: The parents'
Institutional Methodology optional contribution from
assets based on the optional calculation.
RCRIMP1_S_EST_TOT_INC NUMBER 7 YES IM STUDENT'S ESTIMATED TOTAL INCOME: The student's
Institutional Methodology estimated total income based
on current year data.
RCRIMP1_S_EST_CTRB_FOR_STDT NUMBER 5 YES IM STUDENT'S ESTIMATED CONTRIBUTION FOR STUDENT: The
student's Institutional Methodology estimated
contribution based on current year data.
Date: 21-JUN-2004 Page: 75
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRIMP1_S_EST_CTRB_FR_INC NUMBER 6 YES IM STUDENT'S ESTIMATED CONTRIBUTION FROM INCOME: The
student's Institutional Methodology estimated
contribution from income based on current year data.
RCRIMP1_S_EST_CTRB_FR_ASSET NUMBER 5 YES IM STUDENT'S ESTIMATED CONTRIBUTION FROM ASSETS: The
student's Institutional Methodology estimated
contribution from assets based on current year data.
RCRIMP1_S_OPT_TOT_INC NUMBER 7 YES IM STUDENT'S TOTAL INCOME: The student's Institutional
Methodology total income based on the optional
calculation.
RCRIMP1_S_OPT_CTRB_FOR_STDT NUMBER 5 YES IM STUDENT'S CONTRIBUTION: The student's Institutional
Methodology contribution based on the optional
calculation.
RCRIMP1_S_OPT_CTRB_FR_INC NUMBER 6 YES IM STUDENT'S CONTRIBUTION FROM INCOME: The student's
Institutional Methodology optional contribution from
income based on the optional calculation.
RCRIMP1_S_OPT_CTRB_FR_ASSET NUMBER 5 YES IM STUDENT'S CONTRIBUTION FROM ASSETS: The student's
Institutional Methodology optional contribution from
assets based on the optional calculation.
RCRIMP1_FM_INST_1_PELL_AWD NUMBER 4 YES FM ESTIMATED PELL AWARD: The student's estimated Pell
award as calculated by CSS.
RCRIMP1_PAR_COLA_ALT_ADJ_OPT VARCHAR2 1 YES COST OF LIVING ADJUSTMENT OPTION: 1 = Institutional
option for Cost of Living adjustment used in option
calculation. BLANK = Not used.
RCRIMP1_PAR_STU_FAM_ASSETS_OPT VARCHAR2 1 YES TREAT STUDENT ASSETS AS PARENT ASSETS OPTION: 1 =
Institutional option to treat student assets as parent
assets in option calculation. BLANK = Not used.
RCRIMP1_PAR_IPT_ASSETS_OPT VARCHAR2 1 YES INPUT PARENT ASSETS OPTION: 1 = Institutional option
to input parent assets from interest and dividend
income used in option calculation. BLANK = Not used.
RCRIMP1_IPT_ASSETS_OPT VARCHAR2 1 YES INPUT STUDENT ASSETS OPTION: 1 = Institutional option
to input student assets from interest and dividend
income used in option calculation. BLANK = Not used.
RCRIMP1_PAR_COLA_ADJ_VALUE_OPT VARCHAR2 5 YES ADJUSTMENT FACTOR TO IPA AND ERA: Adjustment factor
used to modify IPA and ERA. Format: x.xx%. May be
blank.
RCRIMP1_IND_STU_IPT_ASSETS_OPT VARCHAR2 1 YES OPTION TO IMPUTE INDEPENDENT STUDENT ASSETS: Option to
Impute Independent Student Assets from Interest and
Dividend.
Date: 21-JUN-2004 Page: 76
TABLE: RCRINFC
CREATOR: FAISMGR
Interface Data Aid Year Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRINFC_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record.
RCRINFC_INFC_CODE VARCHAR2 7 NO INTERFACE DATA CODE: A code from the Interface Tape
Table indicating the sourceand format of the
application record.
RCRINFC_TREQ_CODE VARCHAR2 6 NO TRACKING REQUIREMENT CODE: The code of the tracking
requirement to be posted to the system when the data
load is completed.
RCRINFC_TRST_CODE VARCHAR2 1 NO TRACKING STATUS CODE: The status code to be posted to
the tracking requirement when the data load process is
complete.
RCRINFC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity to this record.
RCRINFC_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
Date: 21-JUN-2004 Page: 77
TABLE: RCRINFR
CREATOR: FAISMGR
Tape Matching Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRINFR_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year associated with the
information in this record.
RCRINFR_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: This field maintains the source
of the tape, (i.e. CSS, ACT, USAF, etc) with which
the information in this record is associated with.
RCRINFR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field maintains the date that
information in this record was entered or last
updated.
RCRINFR_SSN_IND VARCHAR2 1 YES SOCIAL SECURITY NUMBER INDICATOR: This field indicates
whether the SSN will be used as a match during the
tape load process to determine if the student already
exists in the student system.
RCRINFR_SSN_LEN NUMBER 1 YES SOCIAL SECURITY NUMBER LENGTH: This field maintains
the number of characters that will be matched in the
tape load process to determine if the student already
exists in the student system.
RCRINFR_LNAME_LEN NUMBER 2 YES LAST NAME LENGTH: This field maintains the number of
characters that will be attempted to be matched in the
tape load process.
RCRINFR_FNAME_LEN NUMBER 2 YES FIRST NAME LENGTH: This field maintains the number of
characters that will be attempted to be matched in the
tape load process with the student system information.
RCRINFR_MI_IND VARCHAR2 1 YES MIDDLE INITIAL INDICATOR: This field indicates whether
the middle initial will be used as a match in the tape
load process to determine if the student already
exists in the student system.
RCRINFR_BIRTH_MO_IND VARCHAR2 1 YES BIRTH MONTH INDICATOR: This field indicates whether
the birth month will be used as a match in the tape
load process to determine if the student already
exists in the student system.
RCRINFR_BIRTH_DA_IND VARCHAR2 1 YES BIRTH DATE INDICATOR: This field indicates whether the
birth date will be used as a match in the tape load
process to determine if the student already exists in
the student system.
RCRINFR_BIRTH_YR_IND VARCHAR2 1 YES BIRTH YEAR INDICATOR: This field indicates whether the
birth year will be used a match in the tape load
process to determine if the student already exists in
the student system.
RCRINFR_SEX_IND VARCHAR2 1 YES SEX INDICATOR: This field indicates whether the sex
will be used as a match in the tape load process in
order to determine whether the student already exists
in the student system.
RCRINFR_ADDR1_IND VARCHAR2 1 YES ADDRESS INDICATOR: This field indicates whether this
field will be used in the tape load process to
determine a match against the students in the student
system.
Date: 21-JUN-2004 Page: 78
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRINFR_ADDR1_LEN NUMBER 2 YES ADDRESS LENGTH: This field maintains the number of
characters that the match process will attempt to
match on in the tape load process for this field.
RCRINFR_CITY_IND VARCHAR2 1 YES CITY INDICATOR: This field indicates whether the city
will be used as a match in the tape load process to
determine if the student already exists in the student
system.
RCRINFR_CITY_LEN NUMBER 2 YES CITY LENGTH: This field maintains the number of
characters that will be used in the match process with
the student system when a tape is being loaded.
RCRINFR_STATE_IND VARCHAR2 1 YES STATE INDICATOR: This field indicates whether the
state code will be used in the tape load process in
order to determine if the student already exists in
the student system.
RCRINFR_STATE_LEN NUMBER 2 YES STATE LENGTH: This field maintains the number of
characters of the state that will be used to match in
the tape load process to determine if the student
already exists in the student system.
RCRINFR_ZIP_IND VARCHAR2 1 YES ZIP INDICATOR: This field indicates whether the zip
code will be used as a match in the tape load process
to determine if the student already exists in the
student system.
RCRINFR_ZIP_LEN NUMBER 2 YES ZIP CODE LENGTH: This field maintains the number of
characters that the tape load process will attempt to
match on to determine if the student already exists in
the student system.
RCRINFR_AREA_CODE_IND VARCHAR2 1 YES AREA CODE INDICATOR: This field indicates whether the
area code will be used in the tape load match process
to determine if the student already exists in the
student system.
RCRINFR_PHONE_IND VARCHAR2 1 YES PHONE INDICATOR: This field indicates whether the
phone number will be used as a match in the tape load
process to determine whether the student already
exists in the student system.
RCRINFR_MI_LEN NUMBER 2 YES MIDDLE INITIAL LENGTH: This field maintains the number
of characters that will be used in the match process
to determine if the student exists in the student
system.
RCRINFR_FNAME_IND VARCHAR2 1 YES FIRST NAME INDICATOR: This field indicates whether the
first name will be used as a match in the tape load
process to determine whether the student already
exists in the database. R=Required to match, Y=match
if on tape, blank=no match.
Date: 21-JUN-2004 Page: 79
TABLE: RCRLDS1
CREATOR: FAISMGR
Applicant NSLDS Table Part 1
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS1_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, 1991, 1992, etc.
RCRLDS1_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRLDS1_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record. EXAMPLES: CSS, ACT-CSS
RCRLDS1_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
from the same processor/source.
RCRLDS1_CURR_REC_IND VARCHAR2 1 NO APPLICATION CREATOR ID: The ID of the person who
created this application record on the database.
RCRLDS1_CREATOR_ID VARCHAR2 30 NO
RCRLDS1_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RCRLDS1_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date that this
application record was created on the database.
RCRLDS1_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
RCRLDS1_GA_CODE_1 VARCHAR2 3 YES GA MATCH CODE 1: GA Match, Code 1
RCRLDS1_GA_CODE_2 VARCHAR2 3 YES GA MATCH CODE 2: GA Match, Code 2
RCRLDS1_GA_CODE_3 VARCHAR2 3 YES GA MATCH CODE 3: GA Match, Code 3
RCRLDS1_GA_SCHL_CODE_1 VARCHAR2 8 YES GA MATCH SCHOOL CODE 1: GA Match, SCHOOL Code 1
RCRLDS1_GA_SCHL_CODE_2 VARCHAR2 8 YES GA MATCH SCHOOL CODE 2: GA Match, SCHOOL Code 2
RCRLDS1_GA_SCHL_CODE_3 VARCHAR2 8 YES GA MATCH SCHOOL CODE 3: GA Match, SCHOOL Code 3
RCRLDS1_GA_REGION_CODE VARCHAR2 2 YES GA MATCH REGION CODE: GA Match, Region Code
RCRLDS1_GRANT_PROG_1 VARCHAR2 2 YES GRANT MATCH 1 GRANT PROGRAM: Grant Match 1, Grant
Program
RCRLDS1_GRANT_OVERPMT_1 VARCHAR2 1 YES GRANT MATCH 1 OVERPAYMENT: Grant Match 1, Overpayment
RCRLDS1_GRANT_PROG_2 VARCHAR2 2 YES GRANT MATCH 2 GRANT PROGRAM: Grant Match 2, Grant
Program
RCRLDS1_GRANT_OVERPMT_2 VARCHAR2 1 YES GRANT MATCH 2 OVERPAYMENT: Grant Match 2, Overpayment
RCRLDS1_GRANT_PROG_3 VARCHAR2 2 YES GRANT MATCH 3 GRANT PROGRAM: Grant Match 3, Grant
Program
RCRLDS1_GRANT_OVERPMT_3 VARCHAR2 1 YES GRANT MATCH 3 OVERPAYMENT: Grant Match 3, Overpayment
Date: 21-JUN-2004 Page: 80
TABLE: RCRLDS2
CREATOR: FAISMGR
Applicant NSLDS Table Part 2
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS2_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, 1991, 1992, etc.
RCRLDS2_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRLDS2_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record. EXAMPLES: CSS, ACT-CSS
RCRLDS2_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
from the same processor/source.
RCRLDS2_CURR_REC_IND VARCHAR2 1 NO APPLICATION CREATOR ID: The ID of the person who
created this application record on the database.
RCRLDS2_CREATOR_ID VARCHAR2 30 NO
RCRLDS2_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RCRLDS2_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date that this
application record was created on the database.
RCRLDS2_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
RCRLDS2_MATCH_NO NUMBER 2 NO MATCH NUMBER: This number indicates what occurrence of
the Loan Type Program this record is
RCRLDS2_PRCD_CODE VARCHAR2 2 YES LOAN TYPE MATCH PROGRAM: Loan Type Match, Program
RCRLDS2_LOAN_TYPE_STATUS VARCHAR2 2 YES LOAN TYPE MATCH MATCH TYPE: Loan Type Match, Match
Type
RCRLDS2_LOAN_TYPE_BAL NUMBER 6 YES LOAN TYPE MATCH OUTSTANDING BALANCE: Loan Type Match,
Outstanding Balance
RCRLDS2_LOAN_TYPE_UPDATE DATE 7 YES LOAN TYPE MATCH UPDATE DATE: Loan Type Match, Update
Date
Date: 21-JUN-2004 Page: 81
TABLE: RCRLDS3
CREATOR: FAISMGR
Applicant NSLDS Table Part 3
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS3_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, 1991, 1992, etc.
RCRLDS3_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRLDS3_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record. EXAMPLES: CSS, ACT-CSS
RCRLDS3_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
from the same processor/source.
RCRLDS3_CURR_REC_IND VARCHAR2 1 NO APPLICATION CREATOR ID: The ID of the person who
created this application record on the database.
RCRLDS3_CREATOR_ID VARCHAR2 30 NO
RCRLDS3_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RCRLDS3_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date that this
application record was created on the database.
RCRLDS3_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
RCRLDS3_MATCH_NO NUMBER 2 NO MATCH NUMBER: This number indicates what occurrence of
the Loan Level Match this record is
RCRLDS3_PRCD_CODE VARCHAR2 2 YES LOAN LEVEL MATCH PROGRAM: Loan Level Match, Program
RCRLDS3_LOAN_LEVEL_NET_AMT NUMBER 5 YES LOAN LEVEL MATCH NET AMOUNT: Loan Level Match, Net
Amount
RCRLDS3_LOAN_LEVEL_ACYR VARCHAR2 1 YES LOAN LEVEL MATCH ACADEMIC YEAR: Loan Level Match,
Academic Year
RCRLDS3_LOAN_LEVEL_BEG_DATE DATE 7 YES LOAN LEVEL MATCH LOAN BEG DATE: Loan Level Match, Loan
begining date
RCRLDS3_LOAN_LEVEL_END_DATE DATE 7 YES LOAN LEVEL MATCH LOAN END DATE: Loan Level Match, Loan
ending date
RCRLDS3_LOAN_LEVEL_DISB_AMT NUMBER 5 YES LOAN LEVEL MATCH GROSS AMT DISBURSED: Loan Level
Match, Gross Amount Disbursed
Date: 21-JUN-2004 Page: 82
TABLE: RCRLDS4
CREATOR: FAISMGR
Applicant NSLDS Table Part 1
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS4_AIDY_CODE VARCHAR2 4 NO
RCRLDS4_PIDM NUMBER 8 NO
RCRLDS4_INFC_CODE VARCHAR2 7 NO
RCRLDS4_SEQ_NO NUMBER 3 NO
RCRLDS4_CURR_REC_IND VARCHAR2 1 NO
RCRLDS4_CREATOR_ID VARCHAR2 30 NO
RCRLDS4_USER_ID VARCHAR2 30 NO
RCRLDS4_CREATE_DATE DATE 7 NO
RCRLDS4_ACTIVITY_DATE DATE 7 NO
RCRLDS4_NSLDS_DB_RESULT_FLAG VARCHAR2 1 YES
RCRLDS4_AGT_SUB_OUT_PRIN_BAL NUMBER 6 YES
RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL NUMBER 6 YES AGGREGATE UNSUBSIDIZED OUTSTANDING PRINCIPLE BALANCE:
Provides the cumulative dollars of unsubsidized
outstanding principle balance; from the 1999-2000 aid
year onward, the term 'unsubsidized' is replaced by
'combined' in this context.
RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2 NUMBER 6 YES NSLDS UNALLOCATED CONSOLIDATED OUTSTANDING PRINCIPAL
BALANCE: NSLDS Unallocated Consolidated Outstanding
Principal Balance
RCRLDS4_PERK_CUMULATIVE_AMT NUMBER 6 YES
RCRLDS4_PERK_CURRENT_YR_AMT NUMBER 6 YES
RCRLDS4_PERK_1ST_DISB_FLAG_1 VARCHAR2 1 YES
RCRLDS4_PERK_1ST_DISB_FLAG_2 VARCHAR2 1 YES
RCRLDS4_PERK_EXP_LOAN_FLAG VARCHAR2 1 YES
RCRLDS4_PELL_OVER_PAY_FLAG VARCHAR2 1 YES
RCRLDS4_SEOG_OVER_PAY_FLAG VARCHAR2 1 YES
RCRLDS4_PERK_DEFAULT_FLAG VARCHAR2 1 YES
RCRLDS4_ACT_BANKRUPT_FLAG VARCHAR2 1 YES
RCRLDS4_PROC_DATE DATE 7 YES PROCESS DATE: The date on which NSLDS processed this
student record.
RCRLDS4_MATCH_IND VARCHAR2 1 YES MATCH INDICATOR: Indicates that NSLDS is in default or
refund status.
RCRLDS4_AGT_SUB_PEND_DISB NUMBER 6 YES PENDING SUBSIDIZED DISBURSEMENTS: Aggregate subsidized
pending disbursements reported to NSLDS.
RCRLDS4_AGT_UNSUB_PEND_DISB NUMBER 6 YES PENDING UNSUBSIDIZED DISBURSEMENTS: Aggregate
unsubsidized pending disbursements reported to NSLDS;
from the 1999-2000 aid year onward, the term
'unsubsidized' is replaced by 'combined' in this
context.
RCRLDS4_AGT_CONSOL_PEND_DISB NUMBER 6 YES PENDING CONSOLIDATED DISBURSEMENTS: Aggregate
consolidated pending disbursements reported to NSLDS.
RCRLDS4_AGT_SUB_TOTAL NUMBER 6 YES AGGREGATE SUBSIDIZED TOTAL: Aggregate total subsidized
disbursements reported to NSLDS.
RCRLDS4_AGT_UNSUB_TOTAL NUMBER 6 YES AGGREGATE UNSUBSIDIZED TOTAL: Aggregate total
unsubsidized disbursements reported to NSLDS; from the
1999-2000 aid year onward, the term 'unsubsidized' is
replaced by 'combined' in this context.
Date: 21-JUN-2004 Page: 83
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS4_AGT_CONSOL_TOTAL NUMBER 6 YES NSLDS UNALLOCATED CONSOLIDATED TOTAL: NSLDS
Unallocated Consolidated Total
RCRLDS4_TRAN_NO VARCHAR2 2 YES TRANSACTION NUMBER: NSLDS transaction number.
RCRLDS4_PELL_OVER_PAY_CONTACT VARCHAR2 8 YES NSLDS PELL OVERPAYMENT CONTACT: This field indicates
the school code where the student's PELL overpayment
occurred.
RCRLDS4_SEOG_OVER_PAY_CONTACT VARCHAR2 8 YES NSLDS SEOG OVERPAYMENT CONTACT: This field indicates
the school code where the student's SEOG overpayment
occurred.
RCRLDS4_PERK_OVER_PAY_CONTACT VARCHAR2 8 YES NSLDS PERK OVERPAYMENT CONTACT: This field indicates
the school code where the student's PERK overpayment
occurred.
RCRLDS4_PERK_OVER_PAY_FLG VARCHAR2 1 YES PERKINS OVERPAYMENT FLAG: This field indicates whether
Perkins was overpaid or if satisfactory repayment has
occurred.
RCRLDS4_DEFAULTED_LOAN_FLG VARCHAR2 1 YES DEFAULTED LOAN FLAG: This field indicates if the
student has any loans in default.
RCRLDS4_DISCHARG_LOAN_FLG VARCHAR2 1 YES DISCHARGED LOAN FLAG: This field indicates if the
student has any loans that have been discharged.
RCRLDS4_LOAN_SAT_REPAY_FLG VARCHAR2 1 YES LOAN SATISFACTORY REPAYMENT FLAG: This field indicates
if the student has made satisfactory arrangements to
repay the loan.
RCRLDS4_DEF_LOAN_CHG_FLG VARCHAR2 1 YES DEFAULTED LOAN CHANGE FLAG: This field indicates if
there has been a change to the defaulted loan flag
since the previous transaction.
RCRLDS4_DISCHARG_LOAN_CHG_FLG VARCHAR2 1 YES DISCHARGED LOAN CHANGE FLAG: This field indicates if
there has been a change to the discharged loan flag
since the previous transaction.
RCRLDS4_LOAN_SAT_REPAY_CHG_FLG VARCHAR2 1 YES LOAN SATISFACTORY REPAYMENT CHANGE FLAG: This field
indicates if there has been a change to the
satisfactory repayment flag since the previous
transaction.
RCRLDS4_ACT_BANKRUPT_CHG_FLG VARCHAR2 1 YES ACTIVE BANKRUPTCY CHANGE FLAG: This field indicates if
there has been a change to the active bankruptcy flag
since the previous transaction.
RCRLDS4_OVER_PAY_CHG_FLG VARCHAR2 1 YES OVERPAYMENTS CHANGE FLAG: This field indicates if
there has been a change to any of the overpayment
flags since the previous transaction.
RCRLDS4_AGT_CHG_FLG VARCHAR2 1 YES AGGREGATE LOAN CHANGE FLAG: This field indicates if
there has been a change to the aggregate loan amounts
since the previous transaction.
RCRLDS4_PERK_CHG_FLG VARCHAR2 1 YES PERKINS LOAN CHANGE FLAG: This field indicates if
there has been a change to the Perkins loan data since
the previous transaction.
RCRLDS4_PELL_PMT_CHG_FLG VARCHAR2 1 YES PELL PAYMENT CHANGE FLAG: This field indicates if
there has been a change to the Pell Payment data since
the previous transaction.
RCRLDS4_ADDL_PELL_FLG VARCHAR2 1 YES ADDITIONAL PELL FLAG: This field indicates if the
student has additional Pell records beyond what has
been included on the ISIR.
RCRLDS4_ADDL_LOANS_FLG VARCHAR2 1 YES ADDITIONAL LOANS FLAG: This field indicates if the
student has additional loans beyond what has been
included on the ISIR.
Date: 21-JUN-2004 Page: 84
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS4_AGT_COMB_TOTAL NUMBER 6 YES NSLDS AGGREGATE COMBINED TOTAL: NSLDS Aggregate
Combined Total.
RCRLDS4_AGT_COMB_PEND_DISB NUMBER 6 YES NSLDS AGGREGATE COMBINED PENDING DISBURSEMENT: NSLDS
Aggregate Combined Pending Disbursement.
RCRLDS4_AGT_COMB_PRIN_BAL NUMBER 6 YES NSLDS AGGREGATE COMBINED PRINCIPLE BALANCE: NSLDS
Aggregate Combined Principle Balance.
RCRLDS4_POST_SCREEN_RSN_CDE VARCHAR2 2 YES NSLDS POST-SCREENING REASON CODE: NSLDS Post-Screening
Reason Code; The student's eligibility has changed
since the initial screening.
RCRLDS4_DL_MPN_FLAG VARCHAR2 1 YES DIRECT LOAN MASTER PROMISSORY NOTE FLAG: Direct Loan
Master Promissory Note Flag.
RCRLDS4_FFEL_MPN_FLAG VARCHAR2 1 YES FFEL MASTER PROMISSORY NOTE FLAG: FFEL Master
Promissory Note Flag.
RCRLDS4_FFEL_LEND_CODE VARCHAR2 6 YES FFEL LENDER CODE: FFEL Lender Code.
RCRLDS4_LOAN_CHG_FLAG VARCHAR2 1 YES LOAN CHANGE FLAG: Indicates that information about 1
or more loans changed.
RCRLDS4_CURRENT_SSN VARCHAR2 9 YES CURRENT SSN: The current Social Security Number from
NSLDS for the student.
RCRLDS4_CURRENT_FIRST_NAME VARCHAR2 12 YES CURRENT FIRST NAME: The current first name from NSLDS
for the student.
RCRLDS4_CURRENT_LAST_NAME VARCHAR2 35 YES CURRENT LAST NAME: The current last name from NSLDS
for the student.
RCRLDS4_CURRENT_BIRTH_DATE DATE 7 YES CURRENT BIRTH DATE: The current date of birth from
NSLDS for the student.
RCRLDS4_DL_PLUS_MPN_FLAG VARCHAR2 1 YES DIRECT LOAN PLUS MASTER PROMISSORY NOTE FLAG: Direct
Loan PLUS Master Promissory Note Flag.
RCRLDS4_POST_SCREEN_RSN_CDE_2 VARCHAR2 2 YES NSLDS POST-SCREENING REASON CODE 2: The second NSLDS
Post-Screening Reason Code. The student's eligibility
has changed since the initial screening.
RCRLDS4_POST_SCREEN_RSN_CDE_3 VARCHAR2 2 YES NSLDS POST-SCREENING REASON CODE 3: The third NSLDS
Post-Screening Reason Code. The student's eligibility
has changed since the initial screening.
RCRLDS4_AGT_OVER_LIMIT_SUB VARCHAR2 1 YES SUBSIDIZED LOAN LIMIT IND: Subsidized Loan Limit
Indicator
RCRLDS4_AGT_OVER_LIMIT_COMB VARCHAR2 1 YES COMBINED LOAN LIMIT IND: Combined Loan Limit Indicator
Date: 21-JUN-2004 Page: 85
TABLE: RCRLDS5
CREATOR: FAISMGR
Applicant NSLDS Table Part 2
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS5_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9495, 9596,
9697.
RCRLDS5_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRLDS5_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record.
RCRLDS5_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
for the student.
RCRLDS5_CURR_REC_IND VARCHAR2 1 NO CURRENT RECORD INDICATOR: Indicates if this
application record has been flagged as the 'current'
record for processing.
RCRLDS5_CREATOR_ID VARCHAR2 30 NO APPLICATION CREATOR ID: The ID of the user who entered
or last updated the record on the database.
RCRLDS5_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RCRLDS5_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date that the
application record was created on the database.
RCRLDS5_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
RCRLDS5_MATCH_NO NUMBER 3 NO MATCH NUMBER: This number indicates what occurrence of
the Loan Level Match this record is
RCRLDS5_DEF_LOAN_FAM_CD VARCHAR2 1 YES DEFAULTED LOAN 1 - LOAN FAMILY CODE: This field
indicates if the defaulted loan is a F=FFEL, D=Direct,
or a P=Perkins Loan.
RCRLDS5_DEF_ADD_LOAN_FLAG VARCHAR2 1 YES DEFAULTED LOAN 1 - ADDITIONAL LOAN FLAG: This field
indicates if the student received the defaulted loan
funds under the additional loan program.
RCRLDS5_DEF_PROG_CD VARCHAR2 2 YES DEFAULTED LOAN 1-PROGRAM CODE: This field provides the
program code for the defaulted loan 1.
RCRLDS5_DEF_STAT_CD VARCHAR2 2 YES DEFAULTED LOAN 1 -STATUS CODE: This field provides the
status code for the defaulted loan 1.
RCRLDS5_DEF_STAT_DATE DATE 7 YES DEFAULTED LOAN 1 - STATUS DATE: This field provides
the date that the status was reported.
RCRLDS5_DEF_OUT_BAL NUMBER 5 YES DEFAULTED LOAN 1 - OUTSTANDING BALANCE: This field
provides the outstanding balance on the defaulted loan
1.
RCRLDS5_DEF_BEGIN_DATE DATE 7 YES DEFAULTED LOAN 1 - BEGIN DATE: This field provides the
beginning date of the loan that is defaulted.
RCRLDS5_DEF_END_DATE DATE 7 YES DEFAULTED LOAN 1 - END DATE: This field provides the
ending date of the loan that is defaulted 1.
RCRLDS5_DEF_GA_CD VARCHAR2 3 YES DEFAULTED LOAN 1 -GA CODE: This field provides the
guarantee agency's code for the defaulted loan.
RCRLDS5_DEF_INST_CD VARCHAR2 8 YES DEFAULTED LOAN 1 - INSTITUTIONAL CODE: This field
provides the OPE ID of the school.
Date: 21-JUN-2004 Page: 86
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS5_DEF_SERVICE_CD VARCHAR2 6 YES DEFAULTED LOAN 1 - SERVICER CODE: This field provides
the FDSLP Direct Loan Servicer Code. The field is
blank for FFELP schools.
RCRLDS5_DEF_REGION_CD VARCHAR2 2 YES DEFAULTED LOAN 1 - REGION CODE: This field provides
the region code for the defaulted loan.
RCRLDS5_LOAN_AMT NUMBER 5 YES LOAN AMOUNT: Original amount of this loan.
RCRLDS5_OUT_BAL_DATE DATE 7 YES OUTSTANDING BALANCE DATE: Outstanding balance date.
RCRLDS5_TRAN_NO VARCHAR2 2 YES TRANSACTION NUMBER: NSLDS transaction number.
Date: 21-JUN-2004 Page: 87
TABLE: RCRLDS6
CREATOR: FAISMGR
Applicant NSLDS Table Part 3
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS6_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9495, 9596,
9697.
RCRLDS6_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRLDS6_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record.
RCRLDS6_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
for the student.
RCRLDS6_CURR_REC_IND VARCHAR2 1 NO CURRENT RECORD INDICATOR: Indicates if this
application record has been flagged as the 'current'
record for processing.
RCRLDS6_CREATOR_ID VARCHAR2 30 NO APPLICATION CREATOR ID: The ID of the user who entered
or last updated the record on the database.
RCRLDS6_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RCRLDS6_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date that the
application record was created on the database.
RCRLDS6_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
RCRLDS6_MATCH_NO NUMBER 3 NO MATCH NUMBER: This number indicates what occurrence of
the Loan Level Match this record is
RCRLDS6_DIR_ADD_LOAN_FLAG VARCHAR2 1 YES DIRECT/FFEL LOAN 1 -ADDITIONAL LOANS FLAG: This field
indicates if the DIRECT/FFEL Loan 1 was received under
the additional loan program.
RCRLDS6_DIR_PROG_CD VARCHAR2 2 YES DIRECT/FFEL LOAN 1 - PROGRAM CODE: Provides the
program code for the Direct/FFEL loan 1.
RCRLDS6_DIR_STAT_CD VARCHAR2 2 YES DIRECT/FFEL LOAN 1 - STATUS CODE: This field provides
the status code for the DIRECT/FFEL loan 1.
RCRLDS6_DIR_STAT_DATE DATE 7 YES DIRECT/FFEL LOAN 1 - STATUS DATE: This field provides
the date the status was reported for the DIRECT/FFEL
Loan 1.
RCRLDS6_DIR_LOAN_AMOUNT NUMBER 6 YES DIRECT/FFEL LOAN 1 - LOAN AMOUNT: This field provides
the loan amount for the DIRECT/FFEL Loan 1.
RCRLDS6_DIR_OUT_BAL NUMBER 6 YES DIRECT/FFEL LOAN 1 - OUTSTANDING BALANCE: This field
provides the outstanding balance for the DIRECT/FFEL
LOAN.
RCRLDS6_DIR_OUT_BAL_DATE DATE 7 YES DIRECT/FFEL LOAN 1 OUTSTANDING BALANCE DATE: This
field provides the date that the outstanding balance
was reported for the DIRECT/FFEL Loan.
RCRLDS6_DIR_BEGIN_DATE DATE 7 YES DIRECT/FFEL LOAN 1 - BEGIN DATE: This field reports
the beginning date of the DIRECT/FFEL LOAN 1.
RCRLDS6_DIR_END_DATE DATE 7 YES DIRECT/FFEL LOAN 1 -END DATE: This field reports the
ending date of the DIRECT/FFEL LOAN 1.
Date: 21-JUN-2004 Page: 88
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS6_DIR_GA_CD VARCHAR2 3 YES DIRECT/FFEL LOAN 1 - GA CODE: This field provides the
guarantee agency code for the DIRECT/FFEL LOAN 1.
RCRLDS6_DIR_SERVICE_CD VARCHAR2 6 YES DIRECT/FFEL LOAN 1 - SERVICER CODE: This field
provides the FDSLP Direct Loan Service Code. This
field is blank for FFELP schools.
RCRLDS6_DIR_INST_CD VARCHAR2 8 YES INSTITUTIONAL CODE: Direct/FFEL Institution Code.
RCRLDS6_DIR_REGION_CD VARCHAR2 2 YES REGION CODE: Direct/FFEL Region Code.
RCRLDS6_TRAN_NO VARCHAR2 2 YES TRANSACTION NUMBER: NSLDS transaction number.
RCRLDS6_TYPE_CD VARCHAR2 1 YES NSLDS LOAN TYPE CODE: This field indicates if the
student loan is Defaulted or Recent.
RCRLDS6_CHG_FLAG VARCHAR2 1 YES NSLDS LOAN CHANGE FLAG: This field indicates if the
student loan has changed since the last NSLDS
transaction number.
RCRLDS6_CONTACT_TYPE VARCHAR2 3 YES NSLDS LOAN CONTACT TYPE: This field indicates the
student loan contact type.
RCRLDS6_CONTACT_CD VARCHAR2 8 YES NSLDS LOAN CONTACT CODE: This field indicates the
student loan contact code.
RCRLDS6_GRADE_LEVEL VARCHAR2 3 YES GRADE LEVEL: This field indicates the NSLDS loan grade
level.
RCRLDS6_EXTRA_UNSUB_LN_FLAG VARCHAR2 1 YES EXTRA UNSUBSIDIZED LOAN FLAG: Extra unsubsidized loan
flag.
RCRLDS6_LOAN_CAP_INT_FLAG VARCHAR2 1 YES CAPITALIZED INTEREST FLAG: Capitalized interest flag.
RCRLDS6_LAST_DISB_AMT NUMBER 6 YES NSLDS AMOUNT OF LAST LOAN DISBURSEMENT: The amount of
the last loan disbursement according to NSLDS records.
RCRLDS6_LAST_DISB_DATE DATE 7 YES NSLDS DATE OF LAST LOAN DISBURSEMENT: The date of the
last loan disbursement according to NSLDS records.
RCRLDS6_FFEL_LEND_CODE VARCHAR2 6 YES FFEL LENDER CODE: Lender code associated with loan.
RCRLDS6_COMB_AGT_SUB_AMT NUMBER 6 YES COMBINED LOAN SUBSIDIZED AMT: Amount included in
subsidized Aggregate calculation for a Combined Loan.
RCRLDS6_COMB_AGT_UNSUB_AMT NUMBER 6 YES COMBINED LOAN UNSUB AMT: Amount included in
unsubsidized Aggregate calculation for a Combined
Loan.
RCRLDS6_COMB_AGT_AMT NUMBER 6 YES COMBINED LOAN AGGREGATE AMT: Amount included in
Combined Aggregate calculation. This amount could
include HEAL.
RCRLDS6_COMB_AGT_REMAIN_AMT NUMBER 6 YES COMBINED LOAN REMAINING AMT: Amount that could not be
determined to be subsidized, unsubsidized or Perkins
for a Combined Loan.
Date: 21-JUN-2004 Page: 89
TABLE: RCRLDS7
CREATOR: FAISMGR
NSLDS Pell Payment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS7_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record.
RCRLDS7_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRLDS7_INFC_CODE VARCHAR2 7 NO INTERFACE DATA CODE: A code for the Interface Data
Table indicating the source of the application record.
RCRLDS7_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
for the student.
RCRLDS7_CURR_REC_IND VARCHAR2 1 NO CURRENT RECORD INDICATOR: Indicates if this
application record has been flagged as the 'current'
record for processing.
RCRLDS7_CREATOR_ID VARCHAR2 30 NO APPLICATION CREATOR ID: The ID of the user who created
the record in the database.
RCRLDS7_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table
RCRLDS7_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date the application
record was created in the database.
RCRLDS7_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date information was last entered
or updated for this record in the table.
RCRLDS7_MATCH_NO NUMBER 3 NO MATCH NUMBER: This number indicates what occurrence of
the Pell payment record this is.
RCRLDS7_PELL_SCHOOL_CODE VARCHAR2 8 YES PELL SCHOOL CODE: This field provides the Pell school
code.
RCRLDS7_PELL_TRAN_NO VARCHAR2 2 YES PELL TRANSACTION NUMBER: This field indicates the Pell
transaction number.
RCRLDS7_PELL_LAST_UPDATE VARCHAR2 8 YES PELL LAST UPDATED DATE: This field indicates the date
Pell was last updated.
RCRLDS7_PELL_SCHED_AMT NUMBER 6 YES PELL SCHEDULED AMOUNT: This field indicates the amount
of Pell that is scheduled.
RCRLDS7_PELL_PAID_TO_DATE NUMBER 6 YES PELL PAID TO DATE: This field indicates the amount of
Pell paid to date.
RCRLDS7_PELL_REMAINS_TO_PAY NUMBER 6 YES PELL REMAINING AMOUNT TO PAY: This field indicates the
remaining amount of Pell to be paid.
RCRLDS7_PELL_PERCENT_SCHED NUMBER 5 2 YES PELL PERCENT SCHEDULED AWARD USED: This field
indicates the percent of Pell the award is scheduled
to use.
RCRLDS7_PELL_VER_FLAG VARCHAR2 3 YES PELL VERIFICATION FLAG: This field indicates the value
of the NSLDS Pell Verification Flag.
RCRLDS7_PELL_EFC NUMBER 6 YES PELL EFC: This field indicates the value of the NSLDS
Pell EFC.
RCRLDS7_PELL_AWARD_AMT NUMBER 6 YES NSLDS PELL AWARD AMOUNT: NSLDS Pell Award Amount.
RCRLDS7_PELL_PMT_CHG_FLAG VARCHAR2 1 YES PELL PAYMENT CHANGE FLAG: Indicates that a change was
made to this Pell Grant Record.
RCRLDS7_PELL_PMT_POSTED DATE 7 YES PAYMENT POSTED TO PELL DATE: Date the disbursement was
posted to the Pell system.
Date: 21-JUN-2004 Page: 90
TABLE: RCRLDS8
CREATOR: FAISMGR
NSLDS Name History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRLDS8_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record.
RCRLDS8_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
RCRLDS8_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record.
RCRLDS8_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
for the student.
RCRLDS8_CURR_REC_IND VARCHAR2 1 NO CURRENT RECORD INDICATOR: Indicates if this
application record has been flagged as the 'current'
record for processing.
RCRLDS8_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
RCRLDS8_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
RCRLDS8_MATCH_NO NUMBER 3 NO MATCH NUMBER: This is a one-up number that indicates
the number of the occurrence of the Name History Match
record. It is increased when a new record if
imported.
RCRLDS8_FIRST_NAME_HIST VARCHAR2 12 YES NSLDS FIRST NAME HISTORY: Other first name on NSLDS
Database.
RCRLDS8_MI_HIST VARCHAR2 1 YES NSLDS MIDDLE INITIAL HISTORY: Other middle initial on
NSLDS Database.
RCRLDS8_LAST_NAME_HIST VARCHAR2 35 YES NSLDS LAST NAME HISTORY: Other last name on NSLDS
Database.
Date: 21-JUN-2004 Page: 91
TABLE: RCRNAME
CREATOR: FAISMGR
First Name Translation Rules Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRNAME_DATA_FIRST_NAME VARCHAR2 15 NO FIRST NAME FROM DATA SOURCE: The first name of the
person from the MDE data source.
RCRNAME_FIRST_NAME VARCHAR2 15 NO FIRST NAME: The first name of person from the General
Person table.
RCRNAME_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
RCRNAME_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
Date: 21-JUN-2004 Page: 92
TABLE: RCRTERM
CREATOR: FAISMGR
Telephone Financial Aid Term Table defines the terms that are available within an award year, for giving students
disbursement information in telephone financial aid.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTERM_PRIORITY NUMBER 4 NO Priority Sequence Number of Term in listing of terms
for financial aid disbursement information.
RCRTERM_AIDY_YEAR VARCHAR2 4 NO Award Year associated with term code to be spoken
during telephone Financial Aid.
RCRTERM_TERM_CODE_HOST VARCHAR2 6 NO Financial Aid Term Code.
RCRTERM_YEAR VARCHAR2 4 NO Year to be spoken in association with the message id
for the term.
RCRTERM_TERM_MSG_ID NUMBER 6 NO VRU Message ID for the term to be spoken during
telephone Financial Aid.
RCRTERM_TERM_MSG_ID_MENU NUMBER 6 NO VRU Message ID for the term to be spoken when term is
used in menus during telephone Financial Aid.
RCRTERM_START_DATE_1 DATE 7 NO Beginning Date of the first telephone financial aid
period in which term code may be used.
RCRTERM_END_DATE_1 DATE 7 NO Ending Date of the first telephone financial aid
period in which term code may be used.
RCRTERM_START_DATE_2 DATE 7 YES Beginning Date of the second telephone financial aid
period in which term code may be used.
RCRTERM_END_DATE_2 DATE 7 YES Ending Date of the second telephone financial aid
period in which term code may be used.
Date: 21-JUN-2004 Page: 93
TABLE: RCRTMP1
CREATOR: FAISMGR
Financial Aid Temp. Appl. Table - Part 1
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_AIDY_CODE VARCHAR2 4 NO AID YEAR CODE: The aid year to be associated with
information in this record. EXAMPLES: 9091, 9192,
9293, etc. (TEMPORARY)
RCRTMP1_PIDM NUMBER 8 NO PIDM: The internal system student identification
number. (TEMPORARY)
RCRTMP1_INFC_CODE VARCHAR2 7 NO INTERFACE TAPE CODE: A code from the Interface Tape
Table indicating the source and format of the
application record. EXAMPLES: CSS, ACT-CSS
(TEMPORARY)
RCRTMP1_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The number to uniquely identify the
application if multiple applications have been stored
from the same processor/source. (TEMPORARY)
RCRTMP1_CURR_REC_IND VARCHAR2 1 NO CURRENT RECORD INDICATOR: Indicates if this
application record has been flagged as the 'current'
record for processing. (TEMPORARY)
RCRTMP1_CREATOR_ID VARCHAR2 30 NO APPLICATION CREATOR ID: The ID of the person who
created this application record on the database.
(TEMPORARY)
RCRTMP1_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table. (TEMPORARY)
RCRTMP1_CREATE_DATE DATE 7 NO APPLICATION CREATED DATE: The date that this
application record was created on the database.
(TEMPORARY)
RCRTMP1_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
(TEMPORARY)
RCRTMP1_COLL_CDE VARCHAR2 6 YES COLLEGE CODE: The four digit college code identifying
the school for which this application tape record was
created. (TEMPORARY)
RCRTMP1_ACYR_CODE VARCHAR2 2 YES 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. (TEMPORARY)
RCRTMP1_LAST_NAME VARCHAR2 16 YES LAST NAME: The student's last name as reported on the
aid application. (TEMPORARY)
RCRTMP1_FIRST_NAME VARCHAR2 12 YES FIRST NAME: The student's first name as reported on
the aid application. (TEMPORARY)
RCRTMP1_MI VARCHAR2 1 YES MIDDLE INITIAL: The student's middle initial as
reported on the aid application. (TEMPORARY)
RCRTMP1_TITLE VARCHAR2 1 YES TITLE: The student's title. (Mr. or Miss, Ms., Mrs.)
(TEMPORARY)
RCRTMP1_ADDR VARCHAR2 35 YES ADDRESS: The student's number and street for their
address as reported on their aid application.
(TEMPORARY)
RCRTMP1_CITY VARCHAR2 21 YES CITY: The city of the student's address from the aid
application. (TEMPORARY)
RCRTMP1_STAT_CODE VARCHAR2 2 YES STATE CODE: The two character postal abbreviation for
the student's state reported as part of the address.
(TEMPORARY)
RCRTMP1_ZIP VARCHAR2 9 YES ZIP CODE: The zip code for the student's address.
(TEMPORARY)
Date: 21-JUN-2004 Page: 94
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_SSN_PREFIX VARCHAR2 1 YES SOCIAL SECURITY NUMBER PREFIX: A one character prefix
before the student's nine character SSN. (ACT format
only) (TEMPORARY)
RCRTMP1_SSN VARCHAR2 9 YES SOCIAL SECURITY NUMBER: The student's social security
number as reported on the aid application.
(TEMPORARY)
RCRTMP1_BIRTH_DATE DATE 7 YES BIRTH DATE: The student's date of birth. (In Oracle
format) (TEMPORARY)
RCRTMP1_PHONE_AREA VARCHAR2 3 YES STUDENT'S PHONE NUMBER AREA CODE: The area code of the
student's home telephone number. (TEMPORARY)
RCRTMP1_PHONE_NO VARCHAR2 7 YES STUDENT'S PHONE NUMBER: The student's home telephone
number without area code. (TEMPORARY)
RCRTMP1_STAT_CODE_RES VARCHAR2 2 YES STATE OF LEGAL RESIDENCE: The student's state of legal
residence. (TEMPORARY)
RCRTMP1_START_RES_MTH_YR VARCHAR2 4 YES START RESIDENCE DATE (MONTH/YR): The date the student
began living in his/her state of legal residence in
MMYY format. (TEMPORARY)
RCRTMP1_RCPT_DATE DATE 7 YES APPLICATION RECEIPT DATE: The date that the processor
received the aid application. (TEMPORARY)
RCRTMP1_REV_RCPT_DATE DATE 7 YES REVISION RECEIPT DATE: The date that the processor
received a request for revisions from the student.
(TEMPORARY)
RCRTMP1_ORIG_COMP_DATE DATE 7 YES ORIGINAL COMPUTE DATE: The date that the application
was originally processed by the processor.
(TEMPORARY)
RCRTMP1_REV_COMP_DATE DATE 7 YES REVISION COMPUTE DATE: The date that the processor
processed a revised report for the applicant.
(TEMPORARY)
RCRTMP1_CITZ_IND VARCHAR2 1 YES CITIZENSHIP INDICATOR: 1=U.S. Citizen, 2=Eligible
Non-Citizen, 3=None of the above, Blank= Not reported.
(TEMPORARY)
RCRTMP1_ALIEN_REG_NO VARCHAR2 9 YES 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'.
(TEMPORARY)
RCRTMP1_MRTL_STATUS VARCHAR2 1 YES MARITAL STATUS: The student's reported marital status.
(TEMPORARY)
RCRTMP1_HS_CDE VARCHAR2 6 YES HIGH SCHOOL CODE: The six digit code for the student's
high school. (TEMPORARY)
RCRTMP1_EXP_ENROLL_STATUS VARCHAR2 1 YES EXPECTED ENROLLMENT STATUS: The student's expected
enrollment status for the school year. (TEMPORARY)
RCRTMP1_YR_IN_COLL VARCHAR2 1 YES YEAR IN COLLEGE: Indicates which year in college the
student will be enrolled in during the school year.
(TEMPORARY)
RCRTMP1_CRSE_OF_STUDY VARCHAR2 5 YES COURSE OF STUDY: A code to indicate the student's
anticipated college major. (TEMPORARY)
RCRTMP1_EXP_GRAD_MTH_YR VARCHAR2 6 YES EXPECTED GRADUATION MONTH AND YEAR: The student's
expected graduation date. (MMYY format) (TEMPORARY)
RCRTMP1_DEGREE_BY_JULY VARCHAR2 1 YES DEGREE BY JULY 1, 1990: Indicates if the student will
have a first bachelor's degree by July 1, 1990.
(TEMPORARY)
RCRTMP1_MORE_THAN_3_PREV_COLL VARCHAR2 1 YES MORE THAN 3 PREVIOUS COLLEGES: Indicates whether or
not the student attended more than three previous
colleges. (TEMPORARY)
Date: 21-JUN-2004 Page: 95
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_NO_SCH NUMBER 1 YES NUMBER OF PREVIOUS SCHOOLS ATTENDED: The number of
schools, beyond high school, that the student has
attended. (TEMPORARY)
RCRTMP1_PREV_COLL1 VARCHAR2 6 YES PREVIOUS COLLEGE #1: The school code number of the
most previously attended school since high school.
(TEMPORARY)
RCRTMP1_PREV_COLL2 VARCHAR2 6 YES PREVIOUS COLLEGE #2: The school code number of the
second most previously attended school since high
school. (TEMPORARY)
RCRTMP1_PREV_COLL3 VARCHAR2 6 YES PREVIOUS COLLEGE #3: The school code number of the
third most previously attended school since high
school. (TEMPORARY)
RCRTMP1_DRIVER_LIC_NO VARCHAR2 20 YES DRIVER'S LICENSE NUMBER: The student's driver's
license number. (TEMPORARY)
RCRTMP1_STAT_CODE_LIC VARCHAR2 2 YES STATE OF DRIVER'S LICENSE: The state that issued the
student's driver's license. (TEMPORARY)
RCRTMP1_DISL_WRK VARCHAR2 1 YES DISLOCATED WORKER: Indicates if the student or spouse
has been certified as a dislocated worker by the
appropriate agency. (TEMPORARY)
RCRTMP1_DISP_HME VARCHAR2 1 YES DISPLACED HOMEMAKER: Indicates if the student or
spouse is a displaced homemaker. (TEMPORARY)
RCRTMP1_FAM_MEMB NUMBER 2 YES FAMILY MEMBERS: The number of people in the student's
household during the school year. (TEMPORARY)
RCRTMP1_NO_IN_COLL NUMBER 1 YES NUMBER IN COLLEGE: The total number of family members
in the student's household that will attend college at
least half-time. (TEMPORARY)
RCRTMP1_CASH_AMT NUMBER 7 YES CASH, SAVINGS AND CHECKING ACCOUNTS: The amount the
student currently has in cash on hand and in savings
and checking accounts. (TEMPORARY)
RCRTMP1_HME_VAL NUMBER 7 YES HOME VALUE: The current market value of the student's
home. (TEMPORARY)
RCRTMP1_HME_DBT NUMBER 7 YES HOME DEBT: The student's current outstanding debts
against the home. (TEMPORARY)
RCRTMP1_RE_INV_VAL NUMBER 7 YES STUDENT'S REAL ESTATE AND INVESTMENTS VALUE: The
student's current market value of other real estate
and investment assets. (TEMPORARY)
RCRTMP1_RE_INV_DBT NUMBER 7 YES STUDENT'S REAL ESTATE AND INVESTMENTS DEBTS: The
student's current outstanding debts against other real
estate and investment assets. (TEMPORARY)
RCRTMP1_BUS_FARM_VAL NUMBER 7 YES BUSINESS AND FARM VALUE: The current market value of
the student's business and farm assets. (TEMPORARY)
RCRTMP1_BUS_FARM_DBT NUMBER 7 YES BUSINESS AND FARM DEBT: The amount of the student's
outstanding debts against business and farm assets.
(TEMPORARY)
RCRTMP1_INCL_FARM VARCHAR2 1 YES ASSETS INCLUDE FARM: Indicates whether or not the
student's reported business/farm assets includes farm
assets. (TEMPORARY)
RCRTMP1_BORN_BEFORE_1_1_XX VARCHAR2 1 YES BORN BEFORE 1-1-XX: Indicates whether or not the
student was born before Jan. 1, 19xx. The xx is 67
for the 1990-91, 68 for 1991-92, etc. (TEMPORARY)
Date: 21-JUN-2004 Page: 96
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_US_VET VARCHAR2 1 YES VETERAN OF THE US ARMED FORCES: Indicates if the
student is a veteran of the US Armed Forces.
(TEMPORARY)
RCRTMP1_WARD_OF_COURT VARCHAR2 1 YES WARD OF THE COURT INDICATOR: Indicates if the student
reported being a ward of the court or is an orphan.
(TEMPORARY)
RCRTMP1_HAS_LEGAL_DEPEND VARCHAR2 1 YES HAS LEGAL DEPENDENTS: Indicates whether or not the
student has legal dependents other than a spouse for
determining dependency status. (TEMPORARY)
RCRTMP1_TAX_FORM_IND VARCHAR2 1 YES TAX FORM INDICATOR: Indicates which type of federal
tax return the student filed (or will file) and
whether or not the income data is estimated.
(TEMPORARY)
RCRTMP1_NO_EXEMPT NUMBER 2 YES NUMBER OF TAX EXEMPTIONS: The number of tax exemptions
claimed by the student on their federal tax return.
(TEMPORARY)
RCRTMP1_US_INC NUMBER 6 YES ADJUSTED GROSS INCOME: The amount of AGI in the base
year reported by the student on his/her federal tax
return. (TEMPORARY)
RCRTMP1_US_INC_TAX_PD NUMBER 6 YES INCOME TAX PAID: The amount of federal income taxes
paid by the student in the base year as reported on
the student's US income tax return. (TEMPORARY)
RCRTMP1_INC_FR_WRK NUMBER 6 YES INCOME FROM WORK: The amount of the student's base
year income from working. (TEMPORARY)
RCRTMP1_SPS_INC_FR_WRK NUMBER 6 YES SPOUSE INCOME FROM WORK: The amount of income earned
from work by the student's spouse in the base year.
(TEMPORARY)
RCRTMP1_SS_BENE NUMBER 6 YES SOCIAL SECURITY BENEFITS: The amount of social
security benefits received by the student (and spouse)
in the base year. (TEMPORARY)
RCRTMP1_AFDC NUMBER 6 YES AID TO FAMILIES WITH DEPENDENT CHILDREN: Student's
base year income from the Aid to Families with
Dependent Children program (AFDC or ADC). (TEMPORARY)
RCRTMP1_CHILD_SUPP NUMBER 6 YES CHILD SUPPORT: The student's base year income from
child support received for all children. (TEMPORARY)
RCRTMP1_OTH_UNTAX_INC NUMBER 6 YES OTHER UNTAXED INCOME AND BENEFITS: The student's
reported base year other untaxed income and benefits.
(TEMPORARY)
RCRTMP1_MED_DEN_EXP NUMBER 6 YES MEDICAL AND DENTAL EXPENSES: The student's reported
base year medical and dental expenses not paid by
insurance. (TEMPORARY)
RCRTMP1_TUIT_PD NUMBER 6 YES TUITION PAID: The amount of elementary, jr. or sr.
high school tuition expenses paid by the student in
the base year for his/her dependent children.
(TEMPORARY)
RCRTMP1_NO_CHILD_TUIT NUMBER 1 YES NUMBER OF CHILDREN WHO PAID TUITION: The number of
dependent children for the student who paid
elementary, jr. high, or high school tuition.
(TEMPORARY)
RCRTMP1_EXP_TAX_PD NUMBER 6 YES EXPECTED TAX PAID: The student's expected calendar
year taxes paid. (TEMPORARY)
RCRTMP1_EXP_INC_FR_WRK NUMBER 6 YES EXPECTED INCOME FROM WORK: The student's expected
calendar year income from work. (TEMPORARY)
RCRTMP1_EXP_SPS_INC_FR_WRK NUMBER 6 YES EXPECTED SPOUSE INCOME FROM WORK: The expected
calendar year income from work for the student's
spouse. (TEMPORARY)
Date: 21-JUN-2004 Page: 97
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_EXP_OTH_TAX_INC NUMBER 6 YES EXPECTED OTHER TAXABLE INCOME: The student's expected
calendar year other taxable income. (TEMPORARY)
RCRTMP1_EXP_UNTAX_INC NUMBER 6 YES EXPECTED UNTAXED INCOME: The student's expected
calendar year nontaxable income and benefits.
(TEMPORARY)
RCRTMP1_EXP_SMR_INC NUMBER 6 YES EXPECTED SUMMER INCOME: The student's expected income
from work for the summer (3 months). (TEMPORARY)
RCRTMP1_EXP_ACYR_INC NUMBER 6 YES EXPECTED ACADEMIC YEAR INCOME FROM WORK: The student's
expected academic year (9 months) income from wages.
(TEMPORARY)
RCRTMP1_EXP_SPS_SMR_INC NUMBER 6 YES EXPECTED SPOUSE SUMMER INCOME: The expected income
from work during the summer (3 months) for the
student's spouse. (TEMPORARY)
RCRTMP1_EXP_SPS_ACYR_INC NUMBER 6 YES EXPECTED SPOUSE ACADEMIC YEAR INCOME: The student's
spouse's academic year (9 month) income from work.
(TEMPORARY)
RCRTMP1_EXP_SMR_OTH_TAX_INC NUMBER 6 YES EXPECTED SUMMER OTHER TAXABLE INCOME: The student's
expected other taxable income for the summer (3
months). (TEMPORARY)
RCRTMP1_EXP_ACYR_OTH_TAX_INC NUMBER 6 YES EXPECTED ACADEMIC YEAR OTHER TAXABLE INCOME: The
student's expected academic year (9 months) other
taxable income. (TEMPORARY)
RCRTMP1_EXP_SMR_UNTAX_INC NUMBER 6 YES EXPECTED SUMMER UNTAXED INCOME: The student's expected
nontaxable income and benefits for the summer (3
months). (TEMPORARY)
RCRTMP1_EXP_ACYR_UNTAX_INC NUMBER 6 YES EXPECTED ACADEMIC YEAR UNTAXED INCOME: The student's
expected academic year (9 months) nontaxable income
and benefits. (TEMPORARY)
RCRTMP1_GI_DEAB_AMT NUMBER 3 YES GI BILL / DEPENDENTS EDUCATIONAL ASSISTANCE BENEFITS:
The monthly amount of the student's GI Bill and
Dependents Educational Assistance Benefits (DEAB) from
the Veterans Administration (VA). (TEMPORARY)
RCRTMP1_GI_DEAB_MTH NUMBER 2 YES GI BILL / DEPENDENTS EDUCATIONAL ASSISTANCE BENEFITS
MONTHS: The number of months the student will receive
the VA benefits during the 12 month award year.
(TEMPORARY)
RCRTMP1_VEAP_BEN_AMT NUMBER 3 YES VEAP BENEFITS AMOUNT: The amount of monthly VA
Contributory Benefits that the student expects to
receive during the school year. (TEMPORARY)
RCRTMP1_VEAP_BEN_MTH NUMBER 2 YES VEAP BENEFITS NUMBER OF MONTHS: The number of months
that the student expects to receive VA Contributory
Benefits during the school year. (TEMPORARY)
RCRTMP1_OTH_VA_AMT NUMBER 4 YES OTHER VA BENEFITS AMOUNT: The amount per month from
other VA programs. (TEMPORARY)
RCRTMP1_OTH_VA_MTH NUMBER 2 YES OTHER VA BENEFITS NUMBER OF MONTHS: The number of
months that the other VA benefits will be received
during the award year. (TEMPORARY)
RCRTMP1_CLM_AS_TAX_EXEMPT_2YR VARCHAR2 1 YES CLAIMED AS TAX EXEMPTION IN 1988: Indicator of whether
or not the student was claimed as a tax exemption by
his or her parents for 1988. (TEMPORARY)
RCRTMP1_CLM_AS_TAX_EXEMPT_1YR VARCHAR2 1 YES CLAIMED AS TAX EXEMPTION IN 1989: Indicator of whether
or not the student was claimed as a tax exemption by
his or her parents for 1989. (TEMPORARY)
Date: 21-JUN-2004 Page: 98
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_CLM_AS_TAX_EXEMPT VARCHAR2 1 YES CLAIMED AS TAX EXEMPTION IN 1990: Indicator of whether
or not the student was or will be claimed as a tax
exemption by his or her parents for 1990. (For
married or graduate/professional students only.)
(TEMPORARY)
RCRTMP1_WHEN_RCVD_AID VARCHAR2 1 YES WHEN AID WAS FIRST RECEIVED: Indicates during what
school year the student first received federal student
aid. (TEMPORARY)
RCRTMP1_1985_RSRC_4000_8788 VARCHAR2 1 YES RESOURCES IN 1985 FOR 87-88 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1985 if
aid was received first in the 1987-88 school year.
(TEMPORARY)
RCRTMP1_1986_RSRC_4000_8788 VARCHAR2 1 YES RESOURCES IN 1986 FOR 87-88 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1986 if
aid was received first in the 1987-88 school year.
(TEMPORARY)
RCRTMP1_1986_RSRC_4000_8889 VARCHAR2 1 YES RESOURCES IN 1986 FOR 88-89 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1986 if
aid was received first in the 1988-89 school year.
(TEMPORARY)
RCRTMP1_1987_RSRC_4000_8889 VARCHAR2 1 YES RESOURCES IN 1987 FOR 88-89 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1987 if
aid was received first in the 1988-89 school year.
(TEMPORARY)
RCRTMP1_1987_RSRC_4000_8990 VARCHAR2 1 YES RESOURCES IN 1987 FOR 89-90 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1987 if
aid was received first in the 1989-90 school year.
(TEMPORARY)
RCRTMP1_1988_RSRC_4000_8990 VARCHAR2 1 YES RESOURCES IN 1988 FOR 89-90 SCHOOL YEAR: Indicates if
the student had resources of $4000 or more in 1988 if
aid was received first in the 1989-90 school year.
(TEMPORARY)
RCRTMP1_1988_RSRC_4000_9091 VARCHAR2 1 YES
RCRTMP1_1989_RSRC_4000_9091 VARCHAR2 1 YES
RCRTMP1_NO_AID_RSRC_4000_2YR VARCHAR2 1 YES RESOURCES IN 1988 FOR NONE OF 87-88, 88-89 or 89-90:
Indicates if the student had resources of $4000 or
more in 1988 if aid was not received first in the
1987-88, 1988-89 or 1989-90 school years. (TEMPORARY)
RCRTMP1_NO_AID_RSRC_4000_1YR VARCHAR2 1 YES RESOURCES IN 1989 FOR NONE OF 87-88, 88-89 or 89-90:
Indicates if the student had resources of $4000 or
more in 1989 if aid was not received first in the
1987-88, 1988-89 or 1989-90 school years. (TEMPORARY)
RCRTMP1_LINE2_RELSHIP VARCHAR2 1 YES LINE 2 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed second on
the family members matrix. (CSS source and format
only) (TEMPORARY)
RCRTMP1_LINE2_ATTEND_COLL VARCHAR2 1 YES LINE 2 ATTENDS COLLEGE: Indicates whether or not the
person listed second on the family members matrix will
attend college at least half-time. (CSS source and
format only) (TEMPORARY)
RCRTMP1_LINE3_RELSHIP VARCHAR2 1 YES LINE 3 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed third on
the family members matrix. (CSS source and format
only) (TEMPORARY)
Date: 21-JUN-2004 Page: 99
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_LINE3_ATTEND_COLL VARCHAR2 1 YES LINE 3 ATTENDS COLLEGE: Indicates whether or not the
person listed third on the family members matrix will
attend college at least half-time. (CSS source and
format only) (TEMPORARY)
RCRTMP1_LINE4_RELSHIP VARCHAR2 1 YES LINE 4 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed fourth on
the family members matrix. (CSS source and format
only) (TEMPORARY)
RCRTMP1_LINE4_ATTEND_COLL VARCHAR2 1 YES LINE 4 ATTENDS COLLEGE: Indicates whether or not the
person listed fourth on the family members matrix will
attend college at least half-time. (CSS source and
format only) (TEMPORARY)
RCRTMP1_LINE5_RELSHIP VARCHAR2 1 YES LINE 5 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed fifth on
the family members matrix. (CSS source and format
only) (TEMPORARY)
RCRTMP1_LINE5_ATTEND_COLL VARCHAR2 1 YES LINE 5 ATTENDS COLLEGE: Indicates whether or not the
person listed fifth on the family members matrix will
attend college at least half-time. (CSS source and
format only) (TEMPORARY)
RCRTMP1_LINE6_RELSHIP VARCHAR2 1 YES LINE 6 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed sixth on
the family members matrix. (CSS source and format
only) (TEMPORARY)
RCRTMP1_LINE6_ATTEND_COLL VARCHAR2 1 YES LINE 6 ATTENDS COLLEGE: Indicates whether or not the
person listed sixth on the family members matrix will
attend college at least half-time. (CSS source and
format only) (TEMPORARY)
RCRTMP1_LINE7_RELSHIP VARCHAR2 1 YES LINE 7 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed seventh on
the family members matrix. (CSS source and format
only) (TEMPORARY)
RCRTMP1_LINE7_ATTEND_COLL VARCHAR2 1 YES LINE 7 ATTENDS COLLEGE: Indicates whether or not the
person listed second on the family members matrix will
attend college at least half-time. (CSS source and
format only) (TEMPORARY)
RCRTMP1_LINE8_RELSHIP VARCHAR2 1 YES LINE 8 RELATIONSHIP: The code for the relationship to
the student applicant for the person listed eighth on
the family members matrix. (CSS source and format
only) (TEMPORARY)
RCRTMP1_LINE8_ATTEND_COLL VARCHAR2 1 YES LINE 8 ATTENDS COLLEGE: Indicates whether or not the
person listed eighth on the family members matrix will
attend college at least half-time. (CSS source and
format only) (TEMPORARY)
RCRTMP1_PAR_MRTL_STATUS VARCHAR2 1 YES PARENTS MARITAL STATUS: The marital status for the
student's parents. (TEMPORARY)
RCRTMP1_PAR_OLDER_AGE NUMBER 2 YES AGE OF OLDER PARENT: The age of the older parent.
(TEMPORARY)
RCRTMP1_PAR_STAT_CODE_RES VARCHAR2 2 YES PARENTS STATE OF LEGAL RESIDENCE: The state of legal
residence for the student's parents. (TEMPORARY)
Date: 21-JUN-2004 Page: 100
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_PAR_DISL_WRK VARCHAR2 1 YES PARENTS DISLOCATED WORKER INDICATOR: Indicates whether
or not either of the student's parents are certified
as a dislocated worker. (TEMPORARY)
RCRTMP1_PAR_DISP_HME VARCHAR2 1 YES PARENTS DISPLACED HOMEMAKER INDICATOR: Indicates
whether or not either of the student's parents is a
displaced homemaker. (TEMPORARY)
RCRTMP1_PAR_FAM_MEMB NUMBER 2 YES PARENTS FAMILY MEMBERS: The number of family members
in the parents household. (TEMPORARY)
RCRTMP1_PAR_NO_IN_COLL NUMBER 1 YES PARENTS NUMBER OF FAMILY MEMBERS IN COLLEGE: The
number of people in the parents household that will be
enrolled in college at least half-time. (TEMPORARY)
RCRTMP1_PAR_CASH_AMT NUMBER 7 YES PARENTS CASH ASSETS AMOUNT: The value of cash, savings
and checking accounts reported by the student's
parents. (TEMPORARY)
RCRTMP1_PAR_HME_VAL NUMBER 7 YES PARENTS HOME VALUE: The current market value of the
student's parents home. (TEMPORARY)
RCRTMP1_PAR_HME_DBT NUMBER 7 YES PARENTS HOME DEBT: The current outstanding debts
against the home for the student's parents.
(TEMPORARY)
RCRTMP1_PAR_RE_INV_VAL NUMBER 7 YES PARENTS REAL ESTATE AND INVESTMENTS VALUE: The current
market value of other real estate and investment
assets reported by the student's parents. (TEMPORARY)
RCRTMP1_PAR_RE_INV_DBT NUMBER 7 YES PARENTS REAL ESTATE AND INVESTMENTS DEBT: The current
debts against other real estate and investment assets
reported by the student's parents. (TEMPORARY)
RCRTMP1_PAR_CURR_INV_VAL NUMBER 7 YES PARENTS CURRENT INVESTMENTS VALUE: The value of
current investments reported by the student's parents.
(TEMPORARY)
RCRTMP1_PAR_BUS_FARM_VAL NUMBER 7 YES PARENTS BUSINESS / FARM VALUE: The value of business
and farm assets reported by the student's parents.
(TEMPORARY)
RCRTMP1_PAR_BUS_FARM_DBT NUMBER 7 YES PARENTS BUSINESS / FARM DEBTS: The amount of business
and farm debts reported by the student's parents.
(TEMPORARY)
RCRTMP1_PAR_INCL_FARM VARCHAR2 1 YES PARENTS ASSETS INCLUDE FARM ASSETS INDICATOR:
Indicates whether or not the business / farm assets
amount reported by the student's parents includes any
farm assets. (TEMPORARY)
RCRTMP1_PAR_HME_YR_PURCH NUMBER 4 YES PARENTS HOME YEAR PURCHASED: The last two digits of
the year that the student's parents purchased their
home. (TEMPORARY)
RCRTMP1_PAR_HME_PURCH_AMT NUMBER 7 YES PARENTS HOME PURCHASE PRICE: The amount that the
student's parents paid for their home. (TEMPORARY)
RCRTMP1_PAR_DIV_SEP_REM_IND VARCHAR2 1 YES DIVORCED, SEPARATED, OR REMARRIED PARENTS INFORMATION
INDICATOR: Indicates whether or not information was
supplied by the student about divorced, separated or
remarried parents. (TEMPORARY)
RCRTMP1_PAR_TAX_FORM_IND VARCHAR2 1 YES PARENTS TAX FORM INDICATOR: Indicates which federal
income tax return form the student's parents filed.
(TEMPORARY)
RCRTMP1_PAR_NO_EXEMPT NUMBER 2 YES PARENTS NUMBER OF EXEMPTIONS: The number of income tax
exemptions claimed by the student's parents on their
federal tax return. (TEMPORARY)
Date: 21-JUN-2004 Page: 101
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_PAR_US_INC NUMBER 7 YES PARENTS ADJUSTED GROSS INCOME: The amount of the AGI
in the base year reported by the student's parents on
their federal tax return. (TEMPORARY)
RCRTMP1_PAR_WAGES NUMBER 6 YES PARENTS WAGES: The amount of wages, salaries, tips,
etc. in the base year reported by the student's
parents on their federal tax return. (TEMPORARY)
RCRTMP1_PAR_INT_INC NUMBER 6 YES PARENTS INTEREST INCOME: The amount of interest income
received in the base year by the student's parents.
(TEMPORARY)
RCRTMP1_PAR_DIV_INC NUMBER 6 YES PARENTS DIVIDEND INCOME: The amount of income received
from dividends by the student's parents in the base
year. (TEMPORARY)
RCRTMP1_PAR_BUS_FARM_INC NUMBER 6 YES PARENTS BUSINESS / FARM INCOME: The amount of income
the student's parents received from business, farm,
rents, royalties, partnerships, estates, trusts, etc.
in the base year. (TEMPORARY)
RCRTMP1_PAR_OTH_TAX_INC NUMBER 6 YES PARENTS OTHER TAXABLE INCOME: The other taxable income
reported by the student's parents from alimony,
capital gains, pensions, annuities, etc. (TEMPORARY)
RCRTMP1_PAR_ADJ_TO_INC NUMBER 6 YES PARENTS ADJUSTMENTS TO INCOME: The amount that the
parents reported as adjustments to income on their
federal tax return. (TEMPORARY)
RCRTMP1_PAR_US_INC_TAX_PD NUMBER 6 YES PARENTS US INCOME TAX PAID: The amount of federal
income taxes paid in the base year reported by the
student's parents on their federal tax return.
(TEMPORARY)
RCRTMP1_FATH_INC_FR_WRK NUMBER 6 YES FATHER'S INCOME FROM WORK: The amount of income earned
from work by the student's father in the base year.
(TEMPORARY)
RCRTMP1_MOTH_INC_FR_WRK NUMBER 6 YES MOTHER'S INCOME FROM WORK: The mother's reported base
year income from work. (TEMPORARY)
RCRTMP1_PAR_SS_BENE NUMBER 6 YES PARENTS SOCIAL SECURITY BENEFITS: The social security
benefits received in the base year by the student's
parents for all household members. (TEMPORARY)
RCRTMP1_PAR_AFDC NUMBER 6 YES PARENTS AFDC: The amount of AFDC (Aid to Families with
Dependent Children) received by the student's parents
in the base year. (TEMPORARY)
RCRTMP1_PAR_CHILD_SUPP NUMBER 6 YES PARENTS CHILD SUPPORT: The amount of income received
by the student's parents from child support for all
children in the base year. (TEMPORARY)
RCRTMP1_PAR_OTH_UNTAX_INC NUMBER 6 YES PARENTS OTHER UNTAXED INCOME: Other untaxed income
received in the base year by the student's parents.
(TEMPORARY)
RCRTMP1_PAR_MED_DEN_EXP NUMBER 6 YES PARENTS MEDICAL / DENTAL EXPENSES: The amount of
medical and dental expenses paid by the student's
parents in the base year that was not paid by
insurance. (TEMPORARY)
RCRTMP1_PAR_TUIT_PD NUMBER 6 YES PARENTS TUITION PAID: The amount of elementary, jr.
high, and high school tuition paid by the student's
parents in the base year. (TEMPORARY)
RCRTMP1_PAR_NO_CHILD_TUIT NUMBER 1 YES PARENTS NUMBER OF CHILDREN PAYING TUITION: The number
of children in the parents household that incurred
elementary, jr. high, or high school tuition
expenses. (TEMPORARY)
Date: 21-JUN-2004 Page: 102
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_EXP_PAR_TAX_PD NUMBER 6 YES EXPECTED PARENTS TAX PAID: The expected calendar year
taxes to be paid for the student's parents.
(TEMPORARY)
RCRTMP1_EXP_PAR_OTH_TAX_INC NUMBER 6 YES EXPECTED PARENTS OTHER TAXABLE INCOME: The expected
calendar year other taxable income for the student's
parents. (TEMPORARY)
RCRTMP1_EXP_PAR_UNTAX_INC NUMBER 6 YES EXPECTED PARENTS UNTAXED INCOME: The expected calendar
year nontaxable income and benefits for the student's
parents. (TEMPORARY)
RCRTMP1_EXP_FATH_INC_FR_WRK NUMBER 6 YES EXPECTED FATHER'S INCOME FROM WORK: The expected
calendar year income from work for the student's
father. (TEMPORARY)
RCRTMP1_EXP_MOTH_INC_FR_WRK NUMBER 6 YES EXPECTED MOTHER'S INCOME FROM WORK: The expected
calendar year income from work for the student's
mother. (TEMPORARY)
RCRTMP1_FED_COLL_CHOICE_1 VARCHAR2 6 YES FEDERAL COLLEGE CHOICE #1: The student's first choice
of a college to receive information from the Central
Processing System. (TEMPORARY)
RCRTMP1_FED_COLL_CHOICE_2 VARCHAR2 6 YES FEDERAL COLLEGE CHOICE #2: The student's second choice
of a college to receive information from the Central
Processing System. (TEMPORARY)
RCRTMP1_FED_COLL_CHOICE_3 VARCHAR2 6 YES
RCRTMP1_COLL_CHOICE_NO VARCHAR2 1 YES COLLEGE CHOICE NUMBER: Indicates whether the school
receiving the application record was the student's
first, second, third, fourth, etc. choice. (ACT
format only) (TEMPORARY)
RCRTMP1_IN_DEFAULT VARCHAR2 1 YES IN DEFAULT: Indicates whether or not the student
reported being in default on an educational loan.
(TEMPORARY)
RCRTMP1_OWES_REFUND VARCHAR2 1 YES OWES REFUND: Indicates whether or not the student
reported owing a refund on a federal grant.
(TEMPORARY)
RCRTMP1_CONSIDER_FOR_STAF VARCHAR2 1 YES CONSIDERED FOR STAFFORD LOAN: Indicator as to whether
or not the student wants to be considered for a
Stafford Loan. (TEMPORARY)
RCRTMP1_BAL_ON_ALL_STAF NUMBER 5 YES BALANCE ON ALL STAFFORD LOANS: The unpaid balance on
the cumulative amount of Stafford Loans for the
student. (TEMPORARY)
RCRTMP1_RECENT_STAF_BAL NUMBER 5 YES MOST RECENT STAFFORD BALANCE: The total unpaid balance
on the student's most recent Stafford Loan.
(TEMPORARY)
RCRTMP1_RECENT_STAF_INT_RATE VARCHAR2 1 YES MOST RECENT STAFFORD INTEREST RATE: The code for the
interest rate of the student's most recent Stafford
Loan. (TEMPORARY)
RCRTMP1_RECENT_STAF_FR_MTH_YR VARCHAR2 4 YES MOST RECENT STAFFORD FROM MONTH AND YEAR: The
beginning date (month and year) of the loan period for
the student's most recent Stafford Loan. (TEMPORARY)
RCRTMP1_RECENT_STAF_TO_MTH_YR VARCHAR2 4 YES MOST RECENT STAFFORD TO MONTH AND YEAR: The ending
date (month and year) of the loan period for the
student's most recent Stafford Loan. (TEMPORARY)
RCRTMP1_RECENT_STAF_CLASS VARCHAR2 2 YES MOST RECENT STAFFORD CLASS: The class level code for
the student's most recently received Stafford Loan.
(TEMPORARY)
RCRTMP1_RQST_FA_PREF VARCHAR2 1 YES REQUESTED FINANCIAL AID PREFERENCE: A code indicating
the student's preference for loans, jobs, both, or
neither. (TEMPORARY)
Date: 21-JUN-2004 Page: 103
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_RQST_FA_FR_MTH_YR VARCHAR2 4 YES REQUESTED AID FROM MONTH AND YEAR: The beginning date
(month and year) of the period of time that the
student requested aid. (TEMPORARY)
RCRTMP1_RQST_FA_TO_MTH_YR VARCHAR2 4 YES REQUESTED AID TO MONTH AND YEAR: The ending date
(month and year) of the period of time that the
student requested aid. (TEMPORARY)
RCRTMP1_RQST_STAF_AMT NUMBER 4 YES REQUESTED STAFFORD AMOUNT: The amount that the student
wishes to borrow under the Stafford Loan program.
(TEMPORARY)
RCRTMP1_RQST_STAF_FA_FR_MTH_YR VARCHAR2 4 YES REQUESTED STAFFORD FROM MONTH AND YEAR: The beginning
date (month and year) of the loan period that the
student desires a Stafford Loan. (TEMPORARY)
RCRTMP1_RQST_STAF_FA_TO_MTH_YR VARCHAR2 4 YES REQUESTED STAFFORD TO MONTH AND YEAR: The ending date
(month and year) of the loan period that the student
desires a Stafford Loan. (TEMPORARY)
RCRTMP1_RQST_FA_SUMMER_THIS_YR VARCHAR2 1 YES REQUESTED AID FOR THE SUMMER THIS YEAR: Indicates if
the student requested aid for the summer term that
preceded the normal school year. (TEMPORARY)
RCRTMP1_RQST_FA_FALL_THIS_YR VARCHAR2 1 YES REQUESTED AID FOR FALL THIS YEAR: Indicates if the
student requested aid for the fall term. (TEMPORARY)
RCRTMP1_RQST_FA_WINTER_NEXT_YR VARCHAR2 1 YES REQUESTED AID FOR WINTER NEXT YEAR: Indicates if the
student requested aid for the winter term.
(TEMPORARY)
RCRTMP1_RQST_FA_SPRING_NEXT_YR VARCHAR2 1 YES REQUESTED AID FOR SPRING NEXT YEAR: Indicates if the
student requested aid for the spring term.
(TEMPORARY)
RCRTMP1_RQST_FA_SUMMER_NEXT_YR VARCHAR2 1 YES REQUESTED AID FOR SUMMER NEXT YEAR: Indicates if the
student requested aid for the summer term following
the normal school year. (TEMPORARY)
RCRTMP1_RQST_FA_OTHER VARCHAR2 1 YES REQUESTED AID FOR OTHER TERM: Indicates if the student
requested aid for a term not listed on the
application. (TEMPORARY)
RCRTMP1_CLASSIFICATION VARCHAR2 1 YES CLASSIFICATION: 1=Entering freshman, 2=Transfer
student, 3=Continuing student, 4=Former student,
Blank=No response. (TEMPORARY)
RCRTMP1_EXP_WRK_HRS VARCHAR2 1 YES EXPECTED WORK HOURS: The number of hours per week that
the student expects to work off-campus during the
school year. 1=None, 2=under 10, 3=11 to 25, 4=26 to
34, 5=35 or more. From ACT application only.
(TEMPORARY)
RCRTMP1_INST_HOUS_CDE VARCHAR2 1 YES INSTITUTIONAL HOUSING CODE: The housing code reported
by the student applicant for the school that is
receiving this application record. (TEMPORARY)
RCRTMP1_COLL_CDE_1 VARCHAR2 6 YES COLLEGE CODE 1: The first college/program code listed
by the student on the aid application for receipt of
information. (TEMPORARY)
RCRTMP1_HOUS_CDE_1 VARCHAR2 1 YES HOUSING CODE 1: The housing code for the school listed
first on the application indicating the student's
expected place of residence at school. (TEMPORARY)
RCRTMP1_COLL_CDE_2 VARCHAR2 6 YES COLLEGE CODE 2: The second college/program code listed
by the student on the aid application for receipt of
information. (TEMPORARY)
RCRTMP1_HOUS_CDE_2 VARCHAR2 1 YES HOUSING CODE 2: The housing code for the school listed
second on the application indicating the student's
expected place of residence at school. (TEMPORARY)
Date: 21-JUN-2004 Page: 104
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_COLL_CDE_3 VARCHAR2 6 YES COLLEGE CODE 3: The third college/program code listed
by the student on the aid application for receipt of
information. (TEMPORARY)
RCRTMP1_HOUS_CDE_3 VARCHAR2 1 YES HOUSING CODE 3: The housing code for the school listed
third on the application indicating the student's
expected place of residence at school. (TEMPORARY)
RCRTMP1_COLL_CDE_4 VARCHAR2 6 YES COLLEGE CODE 4: The fourth college/program code listed
by the student on the aid application for receipt of
information. (TEMPORARY)
RCRTMP1_HOUS_CDE_4 VARCHAR2 1 YES HOUSING CODE 4: The housing code for the school listed
fourth on the application indicating the student's
expected place of residence at school. (TEMPORARY)
RCRTMP1_COLL_CDE_5 VARCHAR2 6 YES COLLEGE CODE 5: The fifth college/program code listed
by the student on the aid application for receipt of
information. (TEMPORARY)
RCRTMP1_HOUS_CDE_5 VARCHAR2 1 YES HOUSING CODE 5: The housing code for the school listed
fifth on the application indicating the student's
expected place of residence at school. (TEMPORARY)
RCRTMP1_COLL_CDE_6 VARCHAR2 6 YES COLLEGE CODE 6: The sixth college/program code listed
by the student on the aid application for receipt of
information. (TEMPORARY)
RCRTMP1_HOUS_CDE_6 VARCHAR2 1 YES HOUSING CODE 6: The housing code for the school listed
sixth on the application indicating the student's
expected place of residence at school. (TEMPORARY)
RCRTMP1_COLL_CDE_7 VARCHAR2 6 YES COLLEGE CODE 7: The seventh college/program code
listed by the student on the aid application for
receipt of information. (TEMPORARY)
RCRTMP1_HOUS_CDE_7 VARCHAR2 1 YES HOUSING CODE 7: The housing code for the school listed
seventh on the application indicating the student's
expected place of residence at school. (TEMPORARY)
RCRTMP1_COLL_CDE_8 VARCHAR2 6 YES COLLEGE CODE 8: The eighth college/program code listed
by the student on the aid application for receipt of
information. (TEMPORARY)
RCRTMP1_HOUS_CDE_8 VARCHAR2 1 YES HOUSING CODE 8: The housing code for the school listed
eighth on the application indicating the student's
expected place of residence at school. (TEMPORARY)
RCRTMP1_ADDL_COLL_CDE_1 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 1: The first school code if
more than eight school codes were requested through an
original application or an additional college request.
(TEMPORARY)
RCRTMP1_ADDL_COLL_CDE_2 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 2: The second school code if
more than eight school codes were requested through an
original application or an additional college request.
(TEMPORARY)
RCRTMP1_ADDL_COLL_CDE_3 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 3: The third school code if
more than eight school codes were requested through an
original application or an additional college request.
(TEMPORARY)
RCRTMP1_ADDL_COLL_CDE_4 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 4: The fourth school code if
more than eight school codes were requested through an
original application or an additional college request.
(TEMPORARY)
Date: 21-JUN-2004 Page: 105
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_ADDL_COLL_CDE_5 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 5: The fifth school code if
more than eight school codes were requested through an
original application or an additional college request.
(TEMPORARY)
RCRTMP1_ADDL_COLL_CDE_6 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 6: The sixth school code if
more than eight school codes were requested through an
original application or an additional college request.
(TEMPORARY)
RCRTMP1_ADDL_COLL_CDE_7 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 7: The seventh school code if
more than eight school codes were requested through an
original application or an additional college request.
(TEMPORARY)
RCRTMP1_ADDL_COLL_CDE_8 VARCHAR2 6 YES ADDITIONAL COLLEGE CODE 8: The eighth school code if
more than eight school codes were requested through an
original application or an additional college request.
(TEMPORARY)
RCRTMP1_EXTRA_REQUEST VARCHAR2 1 YES EXTRA REQUEST: Indicates if more than four college
codes were requested on the student's application.
(ACT format only) (TEMPORARY)
RCRTMP1_REL_TO_STATE VARCHAR2 1 YES RELEASE TO STATE: Indicates whether or not the
processor sent information from the application to the
financial aid agency in the student's state.
(TEMPORARY)
RCRTMP1_REL_TO_US_ED VARCHAR2 1 YES RELEASE TO US DEPT. OF ED.: Indicates whether or not
the student gave permission for the processor to
release information from the application to the US
Dept. of Education. (TEMPORARY)
RCRTMP1_REL_US_ED_TO_STATE VARCHAR2 1 YES RELEASE FROM US DEPT. OF ED. TO STATE: Indicates
whether or not the student gave permission for the US
Dept. of Education to release information from the
application to the financial aid agency in the
student's state. (TEMPORARY)
RCRTMP1_REL_US_ED_TO_COLL VARCHAR2 1 YES RELEASE FROM US DEPT. OF ED. TO COLLEGE: Indicates
whether or not the student gave permission for the US
Dept. of Education to release application data to the
student's college. (TEMPORARY)
RCRTMP1_BUS_FARM_SUPP_FILED VARCHAR2 1 YES BUSINESS/FARM SUPPLEMENT FILED: Indicator as to
whether or not the student filed a special Business
and Farm Supplement along with the application.
1=Yes, blank=No (TEMPORARY)
RCRTMP1_SIGNED VARCHAR2 1 YES SIGNED BY STUDENT: Indicates if the application was
signed by the student. (TEMPORARY)
RCRTMP1_SIGNED_SPS VARCHAR2 1 YES SIGNED BY SPOUSE: Indicates if the application was
signed by the student's spouse. (TEMPORARY)
RCRTMP1_SIGNED_FATH VARCHAR2 1 YES SIGNED BY FATHER: Indicates if the application was
signed by the student's father. (TEMPORARY)
RCRTMP1_SIGNED_MOTH VARCHAR2 1 YES SIGNED BY MOTHER: Indicates if the application was
signed by the student's mother. (TEMPORARY)
RCRTMP1_SIGNED_PAR VARCHAR2 1 YES SIGNED BY PARENT: Indicates if the application was
signed by either parent. (TEMPORARY)
RCRTMP1_SIGNED_MTH_DAY VARCHAR2 4 YES SIGNATURE DATE (MONTH/DAY): The month and day that the
application was signed. (TEMPORARY)
Date: 21-JUN-2004 Page: 106
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_SIGNED_YR VARCHAR2 1 YES SIGNATURE DATE (YR): The year that the application was
signed. (TEMPORARY)
RCRTMP1_DEPEND_AGE_0_5 NUMBER 1 YES DEPENDENTS BETWEEN AGES 0 AND 5: The number of
dependents the student has, other than a spouse,
between the ages of 0 and 5. (TEMPORARY)
RCRTMP1_DEPEND_AGE_6_12 NUMBER 1 YES DEPENDENTS BETWEEN AGES 6 AND 12: The number of
dependents the student has, other than a spouse,
between the ages of 6 and 12. (TEMPORARY)
RCRTMP1_DEPEND_AGE_13_PLUS NUMBER 1 YES DEPENDENTS AGES 13 AND OVER: The number of dependents
the student has, other than a spouse, ages 13 and
over. (TEMPORARY)
RCRTMP1_CONT_WRK_ACYR VARCHAR2 1 YES CONTINUE WORKING DURING ACADEMIC YEAR: Indicator as to
whether or not the student intends to continue working
for the reported employer during the school year.
(TEMPORARY)
RCRTMP1_PERMIT_DRAFT_REG VARCHAR2 1 YES PERMIT DRAFT REGISTRATION: Indicates whether or not
the student gave permission to the processor to send
data to the Selective Service for draft registration.
(TEMPORARY)
RCRTMP1_PELL_REL_MSG VARCHAR2 1 YES PELL RELEASE MESSAGE: Indicates whether or not the
processor released student data from the application
to the U.S. Dept. of Ed. for a Pell Grant and other
federal aid. (TEMPORARY)
RCRTMP1_ST_AGENCY_REL_MSG VARCHAR2 1 YES STATE AGENCY RELEASE RELEASE MESSAGE: Indicates if the
student gave permission for the processor to release
application data to the financial aid agency in the
student's state. (TEMPORARY)
RCRTMP1_VERIFICATION_MSG VARCHAR2 1 YES VERIFICATION MESSAGE: Indicates whether or not the
student has been selected for verification by US Dept.
of Ed edits or by the institution. (TEMPORARY)
RCRTMP1_VERIFICATION_PRTY VARCHAR2 4 YES VERIFICATION PRIORITY CODE: Indicates the priority of
the edits used to select the student for data
verification. (TEMPORARY)
RCRTMP1_INS VARCHAR2 1 YES DEPARTMENT OF HOMELAND SECURITY (DHS): Indicates
whether or not the student's permanent resident status
has been confirmed by DHS. Prior to 2004-2005,
Immigration and Naturalization Service, INS.
RCRTMP1_SELECTIVE_SERVICE VARCHAR2 1 YES SELECTIVE SERVICE: Indicates whether or not the
student's draft registration status was confirmed by
Selective Service. (TEMPORARY)
RCRTMP1_SPEC_COND_IND VARCHAR2 1 YES SPECIAL CONDITION INDICATOR: Indicates if the student
applicant has met the requirements for having the Pell
Grant Index calculated using estimated year data due
to unusual circumstances as defined by the Dept. of
Ed. (TEMPORARY)
RCRTMP1_TITLE_IV_DEFAULT VARCHAR2 1 YES TITLE IV DEFAULT INDICATOR: Indicates whether or not
the student is listed as being in default on any Title
IV student loan through the national student loan
database. (TEMPORARY)
RCRTMP1_INAS_OPTION VARCHAR2 1 YES
Date: 21-JUN-2004 Page: 107
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP1_EDE_SOURCE VARCHAR2 1 YES
RCRTMP1_EDE_SPEC_COND_IND VARCHAR2 1 YES
RCRTMP1_USED_TRANS_NO VARCHAR2 2 YES
RCRTMP1_DEF_MATCH_REGION VARCHAR2 1 YES
RCRTMP1_PREV_COLL4 VARCHAR2 6 YES
RCRTMP1_1989_RSRC_4000_9192 VARCHAR2 1 YES
RCRTMP1_1990_RSRC_4000_9192 VARCHAR2 1 YES
RCRTMP1_IN_DEF_OWE_REF VARCHAR2 1 YES
RCRTMP1_PAR_SS_BENE_STU_ONLY NUMBER 6 YES SOCIAL SECURITY BENEFITS RECEIVED FOR STUDENT: The
portion of Social Security Benefits received by the
family for the student. IM will exclude student's
benefits. EFM will include student's benefits.
Date: 21-JUN-2004 Page: 108
TABLE: RCRTMP2
CREATOR: FAISMGR
Financial Aid Temp. Appl. Table - Part 2
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
RCRTMP2_AIDY_CODE VARCHAR2 4 NO TEMPORARY AID YEAR CODE: The aid year to be associated
with information in this record. EXAMPLES: 9091,
9192, 9293, etc.
RCRTMP2_PIDM NUMBER 8 NO TEMPORARY PIDM: The internal system student
identification number.
RCRTMP2_INFC_CODE VARCHAR2 7 NO TEMPORARY
RCRTMP2_SEQ_NO NUMBER 3 NO TEMPORARY
RCRTMP2_MODEL_CDE VARCHAR2 1 YES
RCRTMP2_C_PAR_DATA_PRESENT VARCHAR2 1 YES TEMPORARY
RCRTMP2_C_DATA_PRESENT VARCHAR2 1 YES TEMPORARY
RCRTMP2_C_DEPEND_STATUS VARCHAR2 1 YES TEMPORARY
RCRTMP2_C_AGE NUMBER 2 YES TEMPORARY
RCRTMP2_C_MRTL_STATUS VARCHAR2 1 YES TEMPORARY
RCRTMP2_C_FAM_MEMB NUMBER 2 YES TEMPORARY
RCRTMP2_C_NO_IN_COLL NUMBER 1 YES TEMPORARY
RCRTMP2_C_PAR_MRTL_STATUS VARCHAR2 1 YES TEMPORARY
RCRTMP2_C_PAR_FAM_MEMB NUMBER 2 YES TEMPORARY
RCRTMP2_C_PAR_NO_IN_COLL NUMBER 1 YES TEMPORARY
RCRTMP2_C_PAR_PAR_IN_COLL NUMBER 1 YES TEMPORARY
RCRTMP2_C_PAR_OTH_IN_COLL NUMBER 1 YES TEMPORARY
RCRTMP2_C_ASSUME_YR_IN_COLL VARCHAR2 1 YES TEMPORARY
RCRTMP2_C_PAR_1_ANLY_TYPE VARCHAR2 1 YES
RCRTMP2_C_PAR_1_AGI_TAX_INC NUMBER 6 YES TEMPORARY
RCRTMP2_C_PAR_1_TOT_UNTAX_INC NUMBER 6 YES TEMPORARY
RCRTMP2_C_PAR_1_TOT_INC NUMBER 8 YES TEMPORARY
RCRTMP2_C_PAR_1_US_INC_TAX NUMBER 6 YES TEMPORARY
RCRTMP2_C_PAR_1_ST_OTH_TAX NUMBER 7 YES TEMPORARY
RCRTMP2_C_PAR_1_FICA_TAX NUMBER 5 YES TEMPORARY
RCRTMP2_C_PAR_1_MED_DEN_EXP NUMBER 5 YES TEMPORARY
RCRTMP2_C_PAR_1_SCH_TUIT NUMBER 5 YES TEMPORARY
RCRTMP2_C_PAR_1_EMP_ALLOW NUMBER 7 YES TEMPORARY
RCRTMP2_C_PAR_1_MNT_ALLOW NUMBER 7 YES TEMPORARY
RCRTMP2_C_PAR_1_TOT_ALLOW NUMBER 7 YES TEMPORARY
RCRTMP2_C_PAR_1_AVAIL_DISC_INC NUMBER 7 YES TEMPORARY
RCRTMP2_C_PAR_1_CASH_AMT NUMBER 6 YES TEMPORARY
RCRTMP2_C_PAR_1_HME_VAL NUMBER 6 YES TEMPORARY
RCRTMP2_C_PAR_1_RE_INV_VAL NUMBER 7 YES TEMPORARY
RCRTMP2_C_PAR_1_ADJ_BF_NET_WTH N