Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRESAR	RCRESAR_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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 name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRESAR	RCRESAR_SEQ_NO
APPLICATION_SOURCE_SITE	Indicates the origin of the initial application and the site of the location.	VARCHAR2(63)	RCRESAR	RCRESAR_AGENCY_IND
ASSUMED_AGI	Student's assumed adjusted gross income.	NUMBER	RCRESAR	RCRESAR_A_US_INC
ASSUMED_CITIZENSHIP	Code to determine assumptions about the student's citizenship.	VARCHAR2(63)	RCRESAR	RCRESAR_A_CITZ_IND
ASSUMED_CITIZENSHIP_DESC	Assumed citizen description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_A_CITZ_IND)
ASSUMED_DEPENDENT_IND	Assumed number of student dependents.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_A_S_DEPENDANTS)
ASSUMED_INCOME_TAX_PAID	Assumed amount of Federal Tax paid by the student.	NUMBER	RCRESAR	RCRESAR_A_S_FIT
ASSUMED_INCOME_WORK	Student's assumed income from work.	NUMBER	RCRESAR	RCRESAR_A_INC_FR_WRK
ASSUMED_MARRIED_IND	Indicates that an assumption is used to determine that a student is married.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_A_MARRIED)
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 status of the student.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_A_VA_STATUS)
ASSUMED_WORKSHEET_C_TOT	Assumed student's worksheet C Title IV income exclusions total.	NUMBER	RCRESAR	RCRESAR_A_S_WORKSHEET_C
AUTOMATIC_ZERO_EFC_IND	Expected family contribution automatically set to zero based on income criteria.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG)
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	Student's first choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_1
COLLEGE_CHOICE10	Student's tenth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_10
COLLEGE_CHOICE2	Student's second choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_2
COLLEGE_CHOICE3	Student's third choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_3
COLLEGE_CHOICE4	Student's fourth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_4
COLLEGE_CHOICE5	Student's fifth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_5
COLLEGE_CHOICE6	Student's sixth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_6
COLLEGE_CHOICE7	Student's seventh choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_7
COLLEGE_CHOICE8	Student's eighth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_8
COLLEGE_CHOICE9	Student's ninth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_9
COMMENT1	ISIR comment code 1.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_01
COMMENT10	ISIR comment code 10.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_10
COMMENT10_DESC	ISIR comment code 10 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT11	ISIR comment code 11.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_11
COMMENT11_DESC	ISIR comment code 11 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT12	ISIR comment code 12.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_12
COMMENT12_DESC	ISIR comment code 12 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT13	ISIR comment code 13.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_13
COMMENT13_DESC	ISIR comment code 13 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT14	ISIR comment code 14.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_14
COMMENT14_DESC	ISIR comment code 14 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT15	ISIR comment code 15.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_15
COMMENT15_DESC	ISIR comment code 15 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT16	ISIR comment code 16.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_16
COMMENT16_DESC	ISIR comment code 16 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT17	ISIR comment code 17.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_17
COMMENT17_DESC	ISIR comment code 17 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT18	ISIR comment code 18.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_18
COMMENT18_DESC	ISIR comment code 18 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT19	ISIR comment code 19.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_19
COMMENT19_DESC	ISIR comment code 19 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT1_DESC	ISIR comment code 1 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT2	ISIR comment code 2.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_02
COMMENT20	ISIR comment code 20.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_20
COMMENT20_DESC	ISIR comment code 20 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT2_DESC	ISIR comment code 2 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT3	ISIR comment code 3.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_03
COMMENT3_DESC	ISIR comment code 3 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT4	ISIR comment code 4.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_04
COMMENT4_DESC	ISIR comment code 4 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT5	ISIR comment code 5.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_05
COMMENT5_DESC	ISIR comment code 5 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT6	ISIR comment code 6.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_06
COMMENT6_DESC	ISIR comment code 6 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT7	ISIR comment code 7.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_07
COMMENT7_DESC	ISIR comment code 7 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT8	ISIR comment code 8.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_08
COMMENT8_DESC	ISIR comment code 8 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT9	ISIR comment code 9.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_09
COMMENT9_DESC	ISIR comment code 9 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMPUTED_BATCH_NUMBER	Computed batch number assigned by the Central Processor to this ISIR.	NUMBER	RCRESAR	RCRESAR_COMPUTE_BATCH_NO
CORRECTION_APPLIED_TRANS_NO	Indicates the transaction number to which the history correction was applied.	VARCHAR2(63)	RCRESAR	RCRESAR_CORR_APPL
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CURR_REC_IND
DESTINATION_NUMBER	The TGXXXXX number for the destination code of the transaction.	VARCHAR2(63)	RCRESAR	RCRESAR_ETI_DEST_CODE
DUPLICATE_REQUEST_IND	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	The origin of the electronic application.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_EDE_INST_IND)
FAMILY_IN_COLLEGE	Number of student's family members in college.	NUMBER	RCRESAR	RCRESAR_A_NO_IN_COLL
FAMILY_SIZE	Size of the student's family.	NUMBER	RCRESAR	RCRESAR_A_FAM_MEMB
FATHER_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	Assumed Father's/Mother's/Stepparent's tax ID number.	VARCHAR2(63)	RCRESAR	RCRESAR_A_FATH_SSN
FEDERAL_HOUSING1	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 code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_1)
FEDERAL_HOUSING2	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 code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_2)
FEDERAL_HOUSING3	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 code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_3)
FEDERAL_HOUSING4	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 code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_4)
FEDERAL_HOUSING5	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 code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_5)
FEDERAL_HOUSING6	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 code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_6)
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	Type of Input Record.	VARCHAR2(63)	RCRESAR	RCRESAR_INPUT_REC_TYPE
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	Description of the interface tape code.	VARCHAR2(255)	RTVINFC	RTVINFC_DESC
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 electronic transaction description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_EDE_ETI_IND)
MARITAL_STATUS_IND	Indicates the marital status of the student.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_A_MRTL_STATUS_IND)
MONTH10_FAMILY_CONTRIB_PRIMARY	Month 10, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_10_MTH_CALC
MONTH10_FAMILY_CONTRIB_SECOND	Month 10, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_10_MTH_CALC
MONTH11_FAMILY_CONTRIB_PRIMARY	Month 11, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_11_MTH_CALC
MONTH11_FAMILY_CONTRIB_SECOND	Month 11, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_11_MTH_CALC
MONTH12_FAMILY_CONTRIB_PRIMARY	Month 12, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_12_MTH_CALC
MONTH12_FAMILY_CONTRIB_SECOND	Month 12, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_12_MTH_CALC
MONTH1_FAMILY_CONTRIB_PRIMARY	Month 1, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_01_MTH_CALC
MONTH1_FAMILY_CONTRIB_SECOND	Month 1, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_01_MTH_CALC
MONTH2_FAMILY_CONTRIB_PRIMARY	Month 2, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_02_MTH_CALC
MONTH2_FAMILY_CONTRIB_SECOND	Month 2, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_02_MTH_CALC
MONTH3_FAMILY_CONTRIB_PRIMARY	Month 3, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_03_MTH_CALC
MONTH3_FAMILY_CONTRIB_SECOND	Month 3, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_03_MTH_CALC
MONTH4_FAMILY_CONTRIB_PRIMARY	Month 4, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_04_MTH_CALC
MONTH4_FAMILY_CONTRIB_SECOND	Month 4, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_04_MTH_CALC
MONTH5_FAMILY_CONTRIB_PRIMARY	Month 5, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_05_MTH_CALC
MONTH5_FAMILY_CONTRIB_SECOND	Month 5, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_05_MTH_CALC
MONTH6_FAMILY_CONTRIB_PRIMARY	Month 6, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_06_MTH_CALC
MONTH6_FAMILY_CONTRIB_SECOND	Month 6, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_06_MTH_CALC
MONTH7_FAMILY_CONTRIB_PRIMARY	Month 7, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_07_MTH_CALC
MONTH7_FAMILY_CONTRIB_SECOND	Month 7, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_07_MTH_CALC
MONTH8_FAMILY_CONTRIB_PRIMARY	Month 8, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_08_MTH_CALC
MONTH8_FAMILY_CONTRIB_SECOND	Month 8, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_08_MTH_CALC
MOTHER_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	Assumed Father's/Mother's/Stepparent's tax ID number.	VARCHAR2(63)	RCRESAR	RCRESAR_A_MOTH_SSN
MULTI_SCHOOL_FLAG1	Multi School Code Flag 1.	VARCHAR2(63)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_1
MULTI_SCHOOL_FLAG1_DESC	Multi School Code Flag 1 description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_1)
MULTI_SCHOOL_FLAG2	Multi School Code Flag 2.	VARCHAR2(63)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_2
MULTI_SCHOOL_FLAG2_DESC	Multi School Code Flag 2 description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_2)
MULTI_SCHOOL_FLAG3	Multi School Code Flag 3.	VARCHAR2(63)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_3
MULTI_SCHOOL_FLAG3_DESC	Multi School Code Flag 3 description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_3)
MULTI_SCHOOL_FLAG4	Multi School Code Flag 4.	VARCHAR2(63)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_4
MULTI_SCHOOL_FLAG4_DESC	Multi School Code Flag 4 description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_4)
MULTI_SCHOOL_FLAG5	Multi School Code Flag 5.	VARCHAR2(63)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_5
MULTI_SCHOOL_FLAG5_DESC	Multi School Code Flag 5 description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_5)
MULTI_SCHOOL_FLAG6	Multi School Code Flag 6.	VARCHAR2(63)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_6
MULTI_SCHOOL_FLAG6_DESC	Multi School Code Flag 6 description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_6)
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OLDER_THAN_24_IND	Indicates that the student is older than 24.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_A_BORN_BEFORE_IND)
PARENT_ASSUMED_AGI	Parent's assumed adjusted gross income.	NUMBER	RCRESAR	RCRESAR_A_PAR_US_INC
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	Assumed Parents' Worksheet C Title IV income exclusions total.	NUMBER	RCRESAR	RCRESAR_A_P_WORKSHEET_C
PARENT_FAMILY_IN_COLLEGE	Number of parent's family members in college.	NUMBER	RCRESAR	RCRESAR_A_PAR_NO_IN_COLL
PARENT_FAMILY_SIZE	Size of the parent's family.	NUMBER	RCRESAR	RCRESAR_A_PAR_FAM_MEMB
PARENT_MARITAL_STATUS_IND	Indicates the marital status of the parents.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)
PARENT_TAX_FILER_IND	CPS Determination of Parent's Tax Filing Status.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_A_PAR_TAX_FILED_IND)
PELL_ELIGIBLE_IND	Indicates applicants eligibility as of this transaction for a Federal Pell Grant.	VARCHAR2(63)	RCRESAR	RCRESAR_PELL_ELGBL
PELL_PAID_EFC	Expected family contribution upon which the school based its payment, as reported to the Central Processor.	NUMBER	RCRESAR	RCRESAR_PAID_EFC
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRESAR	RCRESAR_PIDM
PROCESSED_RECORD_TYPE	Type of processed application.	VARCHAR2(63)	RCRESAR	RCRESAR_REC_TYPE
PROCESSED_RECORD_TYPE_DESC	Processed record type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_REC_TYPE)
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REPROCESSED_REASON	Code for the reason the application was reprocessed.	VARCHAR2(63)	RCRESAR	RCRESAR_RE_PROC_REA_CD
SECONDARY_EFC_TYPE	Type of the secondary Expected Family Contribution.	VARCHAR2(63)	RCRESAR	RCRESAR_SEC_EFC_TYPE
SECONDARY_EFC_TYPE_DESC	Secondary expected family contribution description.	VARCHAR2(255)	CALCULATION	DECODE(RCRESAR_SEC_EFC_TYPE)
SPOUSE_ASSUMED_INCOME_WORK	Student's spouse's assumed income from work.	NUMBER	RCRESAR	RCRESAR_A_SPS_INC_FR_WRK
SUBSEQUENT_APPLICATION_IND	Indicates if a subsequent application from applicant exists.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_SUB_APP)
TAX_FILER_IND	CPS Determination of Student's Tax Filing Status.	VARCHAR2(63)	CALCULATION	DECODE(RCRESAR_A_TAX_FILED_IND)
TRANSACTION_RECEIPT_DATE	Date the FAFSA ISIR information was received.	DATE	RCRESAR	RCRESAR_TRAN_RECEIPT_DATE
TRANSACTION_SITE_SOURCE	Origin and site code for the transaction.	VARCHAR2(63)	RCRESAR	RCRESAR_MDE_SITE_CD
TRANSACTION_TYPE	From where the transaction was generated.	VARCHAR2(63)	RCRESAR	RCRESAR_TRAN_TYPE
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 selection flag.	VARCHAR2(63)	CALCULATION	NVL(RCRESAR_VERIF_CHANGE_IND)
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

Ver: 9.1