| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACTIVITY_DATE
|
Activity Date
|
Date record was inserted or updated.
|
DATE
|
RCRESAR
|
RCRESAR_ACTIVITY_DATE
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
AID_YEAR
|
Financial Aid Year
|
Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_AIDY_CODE
|
|
AID_YEAR_DESC
|
Financial Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
APPLICATION_NUMBER
|
Application Number
|
Financial aid application unique sequence number.
|
NUMBER
|
RCRESAR
|
RCRESAR_SEQ_NO
|
|
APPLICATION_SOURCE_SITE
|
Application Source Site
|
Indicates the origin of the initial application and the site of the location.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(RCRESAR_AGENCY_IND,SUBSTR((SELECT RCRLOAD_TEXT_VALUE FROM RCRLOAD WHERE RCRLOAD_FIELD_CODE = 'APPLICATION_SOURCE'
|
|
ASSUMED_AGI
|
Assumed Agi
|
Student's assumed adjusted gross income.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_US_INC
|
|
ASSUMED_ASSET_TH_EXCD
|
ASSUMED STUDENT ASSET THRESHOLD EXCEEDED
|
Indicates that an assumption is used to determine whether the student's asset threshold has been exceeded.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_A_S_ASSET_THRESH_EXCD
|
|
ASSUMED_CITIZENSHIP
|
Assumed Citizenship
|
Code to determine assumptions about the student's citizenship.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_A_CITZ_IND
|
|
ASSUMED_CITIZENSHIP_DESC
|
Assumed Citizenship Description
|
Assumed citizen description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_A_CITZ_IND)
|
|
ASSUMED_DEPENDENT_IND
|
Assumed Dependent Indicator
|
Assumed number of student dependents.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_A_S_DEPENDANTS)
|
|
ASSUMED_INCOME_TAX_PAID
|
Assumed Income Tax Paid
|
Assumed amount of Federal Tax paid by the student.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_S_FIT
|
|
ASSUMED_INCOME_WORK
|
Assumed Income Work
|
Student's assumed income from work.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_INC_FR_WRK
|
|
ASSUMED_MARRIED_IND
|
Assumed Married Indicator
|
Indicates that an assumption is used to determine that a student is married.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_A_MARRIED)
|
|
ASSUMED_SUPPORT_CHILD
|
Assumed Support Child
|
Assumed student has children who receive more than half of their support from him/her.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_A_HAVE_CHILDREN
|
|
ASSUMED_VETERAN_IND
|
Assumed Veteran Indicator
|
Assumed veteran status of the student.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_A_VA_STATUS)
|
|
ASSUMED_WORKSHEET_C_TOT
|
Assumed Worksheet C Total
|
Assumed student's worksheet C Title IV income exclusions total.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_S_WORKSHEET_C
|
|
AUTOMATIC_ZERO_EFC_IND
|
Automatic Zero Effective Family Contribution Indicator
|
Expected family contribution automatically set to zero based on income criteria.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG)
|
|
BATCH_ID
|
Batch ID
|
ID of the batch, assigned by the processor, from which this ISIR data was loaded into the system.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_BATCH_ID
|
|
COLLEGE_CHOICE1
|
College Choice 1
|
Student's first choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP1
|
RCRAPP1_FED_COLL_CHOICE_1
|
|
COLLEGE_CHOICE10
|
College Choice 10
|
Student's tenth choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_10
|
|
COLLEGE_CHOICE2
|
College Choice 2
|
Student's second choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP1
|
RCRAPP1_FED_COLL_CHOICE_2
|
|
COLLEGE_CHOICE3
|
College Choice 3
|
Student's third choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP1
|
RCRAPP1_FED_COLL_CHOICE_3
|
|
COLLEGE_CHOICE4
|
College Choice 4
|
Student's fourth choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_4
|
|
COLLEGE_CHOICE5
|
College Choice 5
|
Student's fifth choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_5
|
|
COLLEGE_CHOICE6
|
College Choice 6
|
Student's sixth choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_6
|
|
COLLEGE_CHOICE7
|
College Choice 7
|
Student's seventh choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_7
|
|
COLLEGE_CHOICE8
|
College Choice 8
|
Student's eighth choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_8
|
|
COLLEGE_CHOICE9
|
College Choice 9
|
Student's ninth choice of college planning to attend.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_9
|
|
COMMENT1
|
Comment 1
|
ISIR comment code 1.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_01
|
|
COMMENT10
|
Comment 10
|
ISIR comment code 10.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_10
|
|
COMMENT10_DESC
|
Comment 10 Description
|
ISIR comment code 10 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT11
|
Comment 11
|
ISIR comment code 11.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_11
|
|
COMMENT11_DESC
|
Comment 11 Description
|
ISIR comment code 11 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT12
|
Comment 12
|
ISIR comment code 12.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_12
|
|
COMMENT12_DESC
|
Comment 12 Description
|
ISIR comment code 12 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT13
|
Comment 13
|
ISIR comment code 13.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_13
|
|
COMMENT13_DESC
|
Comment 13 Description
|
ISIR comment code 13 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT14
|
Comment 14
|
ISIR comment code 14.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_14
|
|
COMMENT14_DESC
|
Comment 14 Description
|
ISIR comment code 14 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT15
|
Comment 15
|
ISIR comment code 15.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_15
|
|
COMMENT15_DESC
|
Comment 15 Description
|
ISIR comment code 15 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT16
|
Comment 16
|
ISIR comment code 16.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_16
|
|
COMMENT16_DESC
|
Comment 16 Description
|
ISIR comment code 16 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT17
|
Comment 17
|
ISIR comment code 17.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_17
|
|
COMMENT17_DESC
|
Comment 17 Description
|
ISIR comment code 17 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT18
|
Comment 18
|
ISIR comment code 18.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_18
|
|
COMMENT18_DESC
|
Comment 18 Description
|
ISIR comment code 18 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT19
|
Comment 19
|
ISIR comment code 19.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_19
|
|
COMMENT19_DESC
|
Comment 19 Description
|
ISIR comment code 19 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT1_DESC
|
Comment 1 Description
|
ISIR comment code 1 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT2
|
Comment 2
|
ISIR comment code 2.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_02
|
|
COMMENT20
|
Comment 20
|
ISIR comment code 20.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_20
|
|
COMMENT20_DESC
|
Comment 20 Description
|
ISIR comment code 20 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT2_DESC
|
Comment 2 Description
|
ISIR comment code 2 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT3
|
Comment 3
|
ISIR comment code 3.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_03
|
|
COMMENT3_DESC
|
Comment 3 Description
|
ISIR comment code 3 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT4
|
Comment 4
|
ISIR comment code 4.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_04
|
|
COMMENT4_DESC
|
Comment 4 Description
|
ISIR comment code 4 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT5
|
Comment 5
|
ISIR comment code 5.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_05
|
|
COMMENT5_DESC
|
Comment 5 Description
|
ISIR comment code 5 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT6
|
Comment 6
|
ISIR comment code 6.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_06
|
|
COMMENT6_DESC
|
Comment 6 Description
|
ISIR comment code 6 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT7
|
Comment 7
|
ISIR comment code 7.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_07
|
|
COMMENT7_DESC
|
Comment 7 Description
|
ISIR comment code 7 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT8
|
Comment 8
|
ISIR comment code 8.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_08
|
|
COMMENT8_DESC
|
Comment 8 Description
|
ISIR comment code 8 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT9
|
Comment 9
|
ISIR comment code 9.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMM_CODE_09
|
|
COMMENT9_DESC
|
Comment 9 Description
|
ISIR comment code 9 description.
|
VARCHAR2(2000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMPUTED_BATCH_NUMBER
|
Computed Batch Number
|
Computed batch number assigned by the Central Processor to this ISIR.
|
NUMBER
|
RCRESAR
|
RCRESAR_COMPUTE_BATCH_NO
|
|
CORRECTION_APPLIED_TRANS_NO
|
Correction Applied Transaction Number
|
Indicates the transaction number to which the history correction was applied.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_CORR_APPL
|
|
CURRENT_RECORD_IND
|
Current Record Indicator
|
Specifies that this is the current need analysis record.
|
VARCHAR2(63)
|
RCRAPP1
|
RCRAPP1_CURR_REC_IND
|
|
DEPENDENCY_STATUS
|
Dependency Status
|
The student dependency status. D = Dependent; I = Independent
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_DEP_INDEP_IND
|
|
DESTINATION_NUMBER
|
Destination Number
|
The TGXXXXX number for the destination code of the transaction.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_ETI_DEST_CODE
|
|
DUPLICATE_REQUEST_IND
|
Duplicate Request Indicator
|
Indicates that the record was sent to the institution as a result of a request for a duplicate ISIR.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_DUP_REQ_IND)
|
|
ELECT_APPL_ENTRY_SOURCE_IND
|
Elect Applicant Entry Source Indicator
|
The origin of the electronic application.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_EDE_INST_IND)
|
|
FAMILY_IN_COLLEGE
|
Family In College
|
Number of student's family members in college.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_NO_IN_COLL
|
|
FAMILY_SIZE
|
Family Size
|
Size of the student's family.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_FAM_MEMB
|
|
FATHER_ASSUMED_INCOME_WORK
|
Parent 1 Assumed Income Work
|
Father's/Mother's/Stepparent's assumed income from work.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_FATH_INC_FR_WRK
|
|
FATHER_ASSUMED_TAX_ID
|
Parent 1 Assumed Tax ID
|
Assumed Father's/Mother's/Stepparent's tax ID number.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_A_FATH_SSN
|
|
FEDERAL_HOUSING1
|
Federal Housing 1
|
Federal housing code associated with the student's first federal college choice.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_1
|
|
FEDERAL_HOUSING1_DESC
|
Federal Housing 1 Description
|
Federal housing code description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_1)
|
|
FEDERAL_HOUSING2
|
Federal Housing 2
|
Federal housing code associated with the student's second federal college choice.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_2
|
|
FEDERAL_HOUSING2_DESC
|
Federal Housing 2 Description
|
Federal housing code description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_2)
|
|
FEDERAL_HOUSING3
|
Federal Housing 3
|
Federal housing code associated with the student's third federal college choice.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_3
|
|
FEDERAL_HOUSING3_DESC
|
Federal Housing 3 Description
|
Federal housing code description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_3)
|
|
FEDERAL_HOUSING4
|
Federal Housing 4
|
Federal housing code associated with the student's fourth federal college choice.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_4
|
|
FEDERAL_HOUSING4_DESC
|
Federal Housing 4 Description
|
Federal housing code description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_4)
|
|
FEDERAL_HOUSING5
|
Federal Housing 5
|
Federal housing code associated with the student's fifth federal college choice.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_5
|
|
FEDERAL_HOUSING5_DESC
|
Federal Housing 5 Description
|
Federal housing code description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_5)
|
|
FEDERAL_HOUSING6
|
Federal Housing 6
|
Federal housing code associated with the student's sixth federal college choice.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_6
|
|
FEDERAL_HOUSING6_DESC
|
Federal Housing 6 Description
|
Federal housing code description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_6)
|
|
GRADUATE_FLAG
|
Graduate Flag
|
Indicates a graduate student based on responses to graduate questions.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_GRADUATE_FLAG
|
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
INPUT_RECORD_TYPE
|
Input Record Type
|
Type of Input Record.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_INPUT_REC_TYPE
|
|
INTERFACE_TAPE_CODE
|
Interface Tape Code
|
Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_INFC_CODE
|
|
INTERFACE_TAPE_DESC
|
Interface Tape Description
|
Description of the interface tape code.
|
VARCHAR2(255)
|
RTVINFC
|
RTVINFC_DESC
|
|
ISIR_ELECT_TRANSACTION
|
Isir Elect Transaction
|
One character code that Indicates whether the school receiving the ISIR submitted input to generate the ISIR transaction or did not generate the transaction, but was listed on the record. Also indicates whether the type of ISIR is a daily, requested, or pushed ISIR.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_EDE_ETI_IND
|
|
ISIR_ELECT_TRANSACTION_DESC
|
Isir Elect Transaction Description
|
ISIR electronic transaction description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_EDE_ETI_IND)
|
|
MARITAL_STATUS_IND
|
Marital Status Indicator
|
Indicates the marital status of the student.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_A_MRTL_STATUS_IND)
|
|
MONTH10_FAMILY_CONTRIB_PRIMARY
|
Month 10 Family Contribution Primary
|
Month 10, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_10_MTH_CALC
|
|
MONTH10_FAMILY_CONTRIB_SECOND
|
Month 10 Family Contribution Second
|
Month 10, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_10_MTH_CALC
|
|
MONTH11_FAMILY_CONTRIB_PRIMARY
|
Month 11 Family Contribution Primary
|
Month 11, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_11_MTH_CALC
|
|
MONTH11_FAMILY_CONTRIB_SECOND
|
Month 11 Family Contribution Second
|
Month 11, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_11_MTH_CALC
|
|
MONTH12_FAMILY_CONTRIB_PRIMARY
|
Month 12 Family Contribution Primary
|
Month 12, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_12_MTH_CALC
|
|
MONTH12_FAMILY_CONTRIB_SECOND
|
Month 12 Family Contribution Second
|
Month 12, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_12_MTH_CALC
|
|
MONTH1_FAMILY_CONTRIB_PRIMARY
|
Month 1 Family Contribution Primary
|
Month 1, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_01_MTH_CALC
|
|
MONTH1_FAMILY_CONTRIB_SECOND
|
Month 1 Family Contribution Second
|
Month 1, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_01_MTH_CALC
|
|
MONTH2_FAMILY_CONTRIB_PRIMARY
|
Month 2 Family Contribution Primary
|
Month 2, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_02_MTH_CALC
|
|
MONTH2_FAMILY_CONTRIB_SECOND
|
Month 2 Family Contribution Second
|
Month 2, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_02_MTH_CALC
|
|
MONTH3_FAMILY_CONTRIB_PRIMARY
|
Month 3 Family Contribution Primary
|
Month 3, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_03_MTH_CALC
|
|
MONTH3_FAMILY_CONTRIB_SECOND
|
Month 3 Family Contribution Second
|
Month 3, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_03_MTH_CALC
|
|
MONTH4_FAMILY_CONTRIB_PRIMARY
|
Month 4 Family Contribution Primary
|
Month 4, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_04_MTH_CALC
|
|
MONTH4_FAMILY_CONTRIB_SECOND
|
Month 4 Family Contribution Second
|
Month 4, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_04_MTH_CALC
|
|
MONTH5_FAMILY_CONTRIB_PRIMARY
|
Month 5 Family Contribution Primary
|
Month 5, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_05_MTH_CALC
|
|
MONTH5_FAMILY_CONTRIB_SECOND
|
Month 5 Family Contribution Second
|
Month 5, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_05_MTH_CALC
|
|
MONTH6_FAMILY_CONTRIB_PRIMARY
|
Month 6 Family Contribution Primary
|
Month 6, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_06_MTH_CALC
|
|
MONTH6_FAMILY_CONTRIB_SECOND
|
Month 6 Family Contribution Second
|
Month 6, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_06_MTH_CALC
|
|
MONTH7_FAMILY_CONTRIB_PRIMARY
|
Month 7 Family Contribution Primary
|
Month 7, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_07_MTH_CALC
|
|
MONTH7_FAMILY_CONTRIB_SECOND
|
Month 7 Family Contribution Second
|
Month 7, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_07_MTH_CALC
|
|
MONTH8_FAMILY_CONTRIB_PRIMARY
|
Month 8 Family Contribution Primary
|
Month 8, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_08_MTH_CALC
|
|
MONTH8_FAMILY_CONTRIB_SECOND
|
Month 8 Family Contribution Second
|
Month 8, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_08_MTH_CALC
|
|
MONTH9_FAMILY_CONTRIB_PRIMARY
|
Month 9 Family Contribution Primary
|
Month 9, primary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_1_FC_09_MTH_CALC
|
|
MONTH9_FAMILY_CONTRIB_SECOND
|
Month 9 Family Contribution Second
|
Month 9, secondary family contribution.
|
NUMBER
|
RCRESAR
|
RCRESAR_ALT_2_FC_09_MTH_CALC
|
|
MOTHER_ASSUMED_INCOME_WORK
|
Parent 2 Assumed Income Work
|
Father's/Mother's/Stepparent's assumed income from work.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_MOTH_INC_FR_WRK
|
|
MOTHER_ASSUMED_TAX_ID
|
Parent 2 Assumed Tax ID
|
Assumed Father's/Mother's/Stepparent's tax ID number.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_A_MOTH_SSN
|
|
MULTI_SCHOOL_FLAG1
|
Multi School Indicator 1
|
Multi School Code Flag 1.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_1
|
|
MULTI_SCHOOL_FLAG1_DESC
|
Multi School Indicator 1 Description
|
Multi School Code Flag 1 description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_1)
|
|
MULTI_SCHOOL_FLAG2
|
Multi School Indicator 2
|
Multi School Code Flag 2.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_2
|
|
MULTI_SCHOOL_FLAG2_DESC
|
Multi School Indicator 2 Description
|
Multi School Code Flag 2 description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_2)
|
|
MULTI_SCHOOL_FLAG3
|
Multi School Indicator 3
|
Multi School Code Flag 3.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_3
|
|
MULTI_SCHOOL_FLAG3_DESC
|
Multi School Indicator 3 Description
|
Multi School Code Flag 3 description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_3)
|
|
MULTI_SCHOOL_FLAG4
|
Multi School Indicator 4
|
Multi School Code Flag 4.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_4
|
|
MULTI_SCHOOL_FLAG4_DESC
|
Multi School Indicator 4 Description
|
Multi School Code Flag 4 description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_4)
|
|
MULTI_SCHOOL_FLAG5
|
Multi School Indicator 5
|
Multi School Code Flag 5.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_5
|
|
MULTI_SCHOOL_FLAG5_DESC
|
Multi School Indicator 5 Description
|
Multi School Code Flag 5 description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_5)
|
|
MULTI_SCHOOL_FLAG6
|
Multi School Indicator 6
|
Multi School Code Flag 6.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_6
|
|
MULTI_SCHOOL_FLAG6_DESC
|
Multi School Indicator 6 Description
|
Multi School Code Flag 6 description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_6)
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
NAME_SSN_CHG_IND
|
SSN Change Status Indicator
|
Indicates a SSN change status.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_NAME_SSN_CHG_IND
|
|
OLDER_THAN_24_IND
|
Older Than 24 Indicator
|
Indicates that the student is older than 24.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_A_BORN_BEFORE_IND)
|
|
PARENT_ASSUMED_AGI
|
Parent Assumed Agi
|
Parent's assumed adjusted gross income.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_PAR_US_INC
|
|
PARENT_ASSUMED_ASSET_TH_EXCD
|
ASSUMED PARENT ASSET THRESHOLD EXCEEDED
|
Indicates that an assumption is used to determine whether the parents' asset threshold has been exceeded.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_A_P_ASSET_THRESH_EXCD
|
|
PARENT_ASSUMED_INCOME_TAX_PAID
|
Parent Assumed Income Tax Paid
|
Parent's assumed income tax paid.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_A_PAR_INC_TAX_PD_IND
|
|
PARENT_ASSUMED_WORKSHEET_C_TOT
|
Parent Assumed Worksheet C Total
|
Assumed Parents' Worksheet C Title IV income exclusions total.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_P_WORKSHEET_C
|
|
PARENT_FAMILY_IN_COLLEGE
|
Parent Family In College
|
Number of parent's family members in college.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_PAR_NO_IN_COLL
|
|
PARENT_FAMILY_SIZE
|
Parent Family Size
|
Size of the parent's family.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_PAR_FAM_MEMB
|
|
PARENT_MARITAL_STATUS_IND
|
Parent Marital Status Indicator
|
Indicates the marital status of the parents.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)
|
|
PARENT_TAX_FILER_IND
|
Parent Tax Filer Indicator
|
CPS Determination of Parent's Tax Filing Status.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_A_PAR_TAX_FILED_IND)
|
|
PELL_ELIGIBLE_IND
|
Pell Eligible Indicator
|
Indicates applicants eligibility as of this transaction for a Federal Pell Grant.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_PELL_ELGBL
|
|
PELL_PAID_EFC
|
Pell Paid Effective Family Contribution
|
Expected family contribution upon which the school based its payment, as reported to the Central Processor.
|
NUMBER
|
RCRESAR
|
RCRESAR_PAID_EFC
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RCRESAR
|
RCRESAR_PIDM
|
|
PROCESSED_RECORD_TYPE
|
Processed Record Type
|
Type of processed application.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_REC_TYPE
|
|
PROCESSED_RECORD_TYPE_DESC
|
Processed Record Type Description
|
Processed record type description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_REC_TYPE)
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
REJECTED_STATUS_CHANGE_FLAG
|
Rejected status change flag.
|
Rejected status change flag.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_REJ_STATUS_CHANGE_IND
|
|
REPROCESSED_REASON
|
Reprocessed Reason
|
Code for the reason the application was reprocessed.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_RE_PROC_REA_CD
|
|
SECONDARY_EFC_TYPE
|
Secondary Effective Family Contribution Type
|
Type of the secondary Expected Family Contribution.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_SEC_EFC_TYPE
|
|
SECONDARY_EFC_TYPE_DESC
|
Secondary Effective Family Contribution Type Description
|
Secondary expected family contribution description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRESAR_SEC_EFC_TYPE)
|
|
SIGNATURE_REJECT_EFC
|
SIGNATURE REJECT EFC
|
Calculated EFC for record rejected due to missing signatures only. This is an unofficial EFC.
|
NUMBER
|
RCRESAR
|
RCRESAR_SIGNATURE_REJ_EFC
|
|
SPOUSE_ASSUMED_INCOME_WORK
|
Spouse Assumed Income Work
|
Student's spouse's assumed income from work.
|
NUMBER
|
RCRESAR
|
RCRESAR_A_SPS_INC_FR_WRK
|
|
SUBSEQUENT_APPLICATION_IND
|
Subsequent Application Indicator
|
Indicates if a subsequent application from applicant exists.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_SUB_APP)
|
|
TAX_FILER_IND
|
Tax Filer Indicator
|
CPS Determination of Student's Tax Filing Status.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRESAR_A_TAX_FILED_IND)
|
|
TRANSACTION_RECEIPT_DATE
|
Transaction Receipt Date
|
Date the FAFSA ISIR information was received.
|
DATE
|
RCRESAR
|
RCRESAR_TRAN_RECEIPT_DATE
|
|
TRANSACTION_SITE_SOURCE
|
Transaction Site Source
|
Origin and site code for the transaction.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(RCRESAR_MDE_SITE_CD, SUBSTR((SELECT RCRLOAD_TEXT_VALUE FROM RCRLOAD WHERE RCRLOAD_FIELD_CODE = 'TRANSACTION_SOURCE'
|
|
TRANSACTION_TYPE
|
Transaction Type
|
From where the transaction was generated.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_TRAN_TYPE
|
|
USER_ID
|
User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_USER_ID
|
|
VERIFICATION_SELECT_CHANGE_IND
|
Verification Select Change Indicator
|
Verification selection flag.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(RCRESAR_VERIF_CHANGE_IND)
|
|
VERIFICATION_TYPE
|
Verification Type
|
Indicates the results of the verification edits on this transaction number. May be different from Verification Message on transactions above number 1.
|
VARCHAR2(63)
|
RCRESAR
|
RCRESAR_VERIF_TYPE
|