Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRESAR	RCRESAR_ACTIVITY_DATE	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RCRESAR	RCRESAR_AIDY_CODE	NO	NO
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRESAR	RCRESAR_SEQ_NO	NO	NO
APPLICATION_SOURCE_SITE	Indicates the origin of the initial application and the site of the location.	VARCHAR2(2)	RCRESAR	RCRESAR_AGENCY_IND	NO	NO
ASSUMED_ADDL_FIN_INFO	Student's assumed additional financial information total.	NUMBER	RCRESAR	RCRESAR_A_S_ADDL_FINANCIAL	NO	NO
ASSUMED_AGI	Student's assumed adjusted gross income.	NUMBER	RCRESAR	RCRESAR_A_US_INC	NO	NO
ASSUMED_ASSET_TH_EXCD	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	NO	NO
ASSUMED_CITIZENSHIP	Code to determine assumptions about the student's citizenship.	VARCHAR2(1)	RCRESAR	RCRESAR_A_CITZ_IND	NO	NO
ASSUMED_CITIZENSHIP_DESC	Assumed citizen description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_A_CITZ_IND)	NO	NO
ASSUMED_DEPENDENT_IND	Assumed number of student dependents.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_S_DEPENDANTS)	NO	NO
ASSUMED_HOMELESS_HUD	Month 9, primary family contribution.	VARCHAR2(63)	RCRESAR	RCRESAR_A_HOMELESS_HUD	NO	NO
ASSUMED_HOMELESS_SCHOOL	The student is assumed to be homeless by the school.	VARCHAR2(63)	RCRESAR	RCRESAR_A_HOMELESS_SCHOOL	NO	NO
ASSUMED_INCOME_TAX_PAID	Assumed amount of Federal Tax paid by the student.	NUMBER	RCRESAR	RCRESAR_A_S_FIT	NO	NO
ASSUMED_INCOME_WORK	Student's assumed income from work.	NUMBER	RCRESAR	RCRESAR_A_INC_FR_WRK	NO	NO
ASSUMED_MARRIED_IND	Indicates that an assumption is used to determine that a student is married.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_MARRIED)	NO	NO
ASSUMED_RISK_OF_HOMELESSNESS	The student is assumed to be at risk of homelessness.	VARCHAR2(63)	RCRESAR	RCRESAR_A_AT_RISK_HOMELESS	NO	NO
ASSUMED_SUPPORT_CHILD	Assumed student has children who receive more than half of their support from him/her.	VARCHAR2(1)	RCRESAR	RCRESAR_A_HAVE_CHILDREN	NO	NO
ASSUMED_VETERAN_IND	Assumed veteran status of the student.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_VA_STATUS)	NO	NO
ASSUMED_WORKSHEET_C_TOT	Assumed student's worksheet C Title IV income exclusions total.	NUMBER	RCRESAR	RCRESAR_A_S_WORKSHEET_C	NO	NO
AUTOMATIC_ZERO_EFC_IND	Expected family contribution automatically set to zero based on income criteria.	VARCHAR2(1)	CALCULATION	NVL(RCRESAR_AUTO_ZERO_EFC_FLAG)	NO	NO
BATCH_ID	ID of the batch, assigned by the processor, from which this ESAR data was loaded into the system.	VARCHAR2(23)	RCRESAR	RCRESAR_BATCH_ID	NO	NO
COMMENT1	ISIR comment code 1.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_01	NO	NO
COMMENT10	ISIR comment code 10.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_10	NO	NO
COMMENT10_DESC	ISIR comment code 10 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT11	ISIR comment code 11.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_11	NO	NO
COMMENT11_DESC	ISIR comment code 11 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT12	ISIR comment code 12.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_12	NO	NO
COMMENT12_DESC	ISIR comment code 12 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT13	ISIR comment code 13.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_13	NO	NO
COMMENT13_DESC	ISIR comment code 13 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT14	ISIR comment code 14.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_14	NO	NO
COMMENT14_DESC	ISIR comment code 14 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT15	ISIR comment code 15.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_15	NO	NO
COMMENT15_DESC	ISIR comment code 15 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT16	ISIR comment code 16.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_16	NO	NO
COMMENT16_DESC	ISIR comment code 16 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT17	ISIR comment code 17.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_17	NO	NO
COMMENT17_DESC	ISIR comment code 17 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT18	ISIR comment code 18.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_18	NO	NO
COMMENT18_DESC	ISIR comment code 18 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT19	ISIR comment code 19.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_19	NO	NO
COMMENT19_DESC	ISIR comment code 19 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT1_DESC	ISIR comment code 1 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT2	ISIR comment code 2.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_02	NO	NO
COMMENT20	ISIR comment code 20.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_20	NO	NO
COMMENT20_DESC	ISIR comment code 20 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT2_DESC	ISIR comment code 2 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT3	ISIR comment code 3.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_03	NO	NO
COMMENT3_DESC	ISIR comment code 3 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT4	ISIR comment code 4.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_04	NO	NO
COMMENT4_DESC	ISIR comment code 4 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT5	ISIR comment code 5.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_05	NO	NO
COMMENT5_DESC	ISIR comment code 5 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT6	ISIR comment code 6.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_06	NO	NO
COMMENT6_DESC	ISIR comment code 6 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT7	ISIR comment code 7.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_07	NO	NO
COMMENT7_DESC	ISIR comment code 7 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT8	ISIR comment code 8.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_08	NO	NO
COMMENT8_DESC	ISIR comment code 8 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMMENT9	ISIR comment code 9.	NUMBER	RCRESAR	RCRESAR_COMM_CODE_09	NO	NO
COMMENT9_DESC	ISIR comment code 9 description.	VARCHAR2(1000)	FUNCTION	ROKODSF.F_GET_COMMENT_DESC	NO	NO
COMPUTED_BATCH_NUMBER	Computed batch number assigned by the Central Processor to this ISIR.	NUMBER	RCRESAR	RCRESAR_COMPUTE_BATCH_NO	NO	NO
CORRECTION_APPLIED_TRANS_NO	Indicates the transaction number to which the history correction was applied.	VARCHAR2(2)	RCRESAR	RCRESAR_CORR_APPL	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DESTINATION_NUMBER	The TGXXXXX number for the destination code of the transaction.	VARCHAR2(7)	RCRESAR	RCRESAR_ETI_DEST_CODE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
DUPLICATE_REQUEST_IND	Indicates that the record was sent to the institution as a result of a request for a duplicate ISIR.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_DUP_REQ_IND)	NO	NO
ELECT_APPL_ENTRY_SOURCE_IND	The origin of the electronic application.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_EDE_INST_IND)	NO	NO
FAMILY_IN_COLLEGE	Number of student's family members in college.	NUMBER	RCRESAR	RCRESAR_A_NO_IN_COLL	NO	NO
FAMILY_SIZE	Size of the student's family.	NUMBER	RCRESAR	RCRESAR_A_FAM_MEMB	NO	NO
FATHER_ASSUMED_INCOME_WORK	Father's assumed income from work.	NUMBER	RCRESAR	RCRESAR_A_FATH_INC_FR_WRK	NO	NO
FATHER_ASSUMED_TAX_ID	Assumed Father's tax ID number.	VARCHAR2(9)	RCRESAR	RCRESAR_A_FATH_SSN	NO	NO
FEDERAL_HOUSING1	Federal housing code associated with the student's first federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_1	NO	NO
FEDERAL_HOUSING10	Indicates the federal housing code associated with the student's tenth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_10	NO	NO
FEDERAL_HOUSING10_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_10)	NO	NO
FEDERAL_HOUSING1_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_1)	NO	NO
FEDERAL_HOUSING2	Federal housing code associated with the student's second federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_2	NO	NO
FEDERAL_HOUSING2_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_2)	NO	NO
FEDERAL_HOUSING3	Federal housing code associated with the student's third federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_3	NO	NO
FEDERAL_HOUSING3_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_3)	NO	NO
FEDERAL_HOUSING4	Federal housing code associated with the student's fourth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_4	NO	NO
FEDERAL_HOUSING4_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_4)	NO	NO
FEDERAL_HOUSING5	Federal housing code associated with the student's fifth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_5	NO	NO
FEDERAL_HOUSING5_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_5)	NO	NO
FEDERAL_HOUSING6	Federal housing code associated with the student's sixth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_6	NO	NO
FEDERAL_HOUSING6_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_6)	NO	NO
FEDERAL_HOUSING7	Indicates the federal housing code associated with the student's seventh federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_7	NO	NO
FEDERAL_HOUSING7_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_7)	NO	NO
FEDERAL_HOUSING8	Indicates the federal housing code associated with the student's eighth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_8	NO	NO
FEDERAL_HOUSING8_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_8)	NO	NO
FEDERAL_HOUSING9	Indicates the federal housing code associated with the student's ninth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_9	NO	NO
FEDERAL_HOUSING9_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_9)	NO	NO
INPUT_RECORD_TYPE	Type of Input Record.	VARCHAR2(1)	RCRESAR	RCRESAR_INPUT_REC_TYPE	NO	NO
INTERFACE_TAPE_CODE	Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).	VARCHAR2(7)	RCRESAR	RCRESAR_INFC_CODE	NO	NO
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(1)	RCRESAR	RCRESAR_EDE_ETI_IND	NO	NO
ISIR_ELECT_TRANSACTION_DESC	ISIR electronic transaction description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_EDE_ETI_IND)	NO	NO
MARITAL_STATUS_IND	Indicates the marital status of the student.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_MRTL_STATUS_IND)	NO	NO
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA	NO	NO
MONTH10_FAMILY_CONTRIB_PRIMARY	Month 10, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_10_MTH_CALC	NO	NO
MONTH10_FAMILY_CONTRIB_SECOND	Month 10, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_10_MTH_CALC	NO	NO
MONTH11_FAMILY_CONTRIB_PRIMARY	Month 11, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_11_MTH_CALC	NO	NO
MONTH11_FAMILY_CONTRIB_SECOND	Month 11, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_11_MTH_CALC	NO	NO
MONTH12_FAMILY_CONTRIB_PRIMARY	Month 12, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_12_MTH_CALC	NO	NO
MONTH12_FAMILY_CONTRIB_SECOND	Month 12, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_12_MTH_CALC	NO	NO
MONTH1_FAMILY_CONTRIB_PRIMARY	Month 1, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_01_MTH_CALC	NO	NO
MONTH1_FAMILY_CONTRIB_SECOND	Month 1, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_01_MTH_CALC	NO	NO
MONTH2_FAMILY_CONTRIB_PRIMARY	Month 2, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_02_MTH_CALC	NO	NO
MONTH2_FAMILY_CONTRIB_SECOND	Month 2, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_02_MTH_CALC	NO	NO
MONTH3_FAMILY_CONTRIB_PRIMARY	Month 3, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_03_MTH_CALC	NO	NO
MONTH3_FAMILY_CONTRIB_SECOND	Month 3, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_03_MTH_CALC	NO	NO
MONTH4_FAMILY_CONTRIB_PRIMARY	Month 4, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_04_MTH_CALC	NO	NO
MONTH4_FAMILY_CONTRIB_SECOND	Month 4, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_04_MTH_CALC	NO	NO
MONTH5_FAMILY_CONTRIB_PRIMARY	Month 5, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_05_MTH_CALC	NO	NO
MONTH5_FAMILY_CONTRIB_SECOND	Month 5, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_05_MTH_CALC	NO	NO
MONTH6_FAMILY_CONTRIB_PRIMARY	Month 6, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_06_MTH_CALC	NO	NO
MONTH6_FAMILY_CONTRIB_SECOND	Month 6, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_06_MTH_CALC	NO	NO
MONTH7_FAMILY_CONTRIB_PRIMARY	Month 7, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_07_MTH_CALC	NO	NO
MONTH7_FAMILY_CONTRIB_SECOND	Month 7, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_07_MTH_CALC	NO	NO
MONTH8_FAMILY_CONTRIB_PRIMARY	Month 8, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_08_MTH_CALC	NO	NO
MONTH8_FAMILY_CONTRIB_SECOND	Month 8, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_08_MTH_CALC	NO	NO
MONTH9_FAMILY_CONTRIB_PRIMARY	Month 9, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_09_MTH_CALC	NO	NO
MONTH9_FAMILY_CONTRIB_SECOND	Month 9, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_09_MTH_CALC	NO	NO
MOTHER_ASSUMED_INCOME_WORK	Mother's assumed income from work.	NUMBER	RCRESAR	RCRESAR_A_MOTH_INC_FR_WRK	NO	NO
MOTHER_ASSUMED_TAX_ID	Assumed Mother's tax ID number.	VARCHAR2(9)	RCRESAR	RCRESAR_A_MOTH_SSN	NO	NO
MULTI_SCHOOL_FLAG1	Multi School Code Flag 1.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_1	NO	NO
MULTI_SCHOOL_FLAG10	Multi School Code Flag 10	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_10	NO	NO
MULTI_SCHOOL_FLAG10_DESC	Multi School Code Flag 10 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_10)	NO	NO
MULTI_SCHOOL_FLAG1_DESC	Multi School Code Flag 1 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_1)	NO	NO
MULTI_SCHOOL_FLAG2	Multi School Code Flag 2.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_2	NO	NO
MULTI_SCHOOL_FLAG2_DESC	Multi School Code Flag 2 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_2)	NO	NO
MULTI_SCHOOL_FLAG3	Multi School Code Flag 3.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_3	NO	NO
MULTI_SCHOOL_FLAG3_DESC	Multi School Code Flag 3 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_3)	NO	NO
MULTI_SCHOOL_FLAG4	Multi School Code Flag 4.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_4	NO	NO
MULTI_SCHOOL_FLAG4_DESC	Multi School Code Flag 4 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_4)	NO	NO
MULTI_SCHOOL_FLAG5	Multi School Code Flag 5.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_5	NO	NO
MULTI_SCHOOL_FLAG5_DESC	Multi School Code Flag 5 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_5)	NO	NO
MULTI_SCHOOL_FLAG6	Multi School Code Flag 6.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_6	NO	NO
MULTI_SCHOOL_FLAG6_DESC	Multi School Code Flag 6 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_6)	NO	NO
MULTI_SCHOOL_FLAG7	Multi School Code Flag 7	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_7	NO	NO
MULTI_SCHOOL_FLAG7_DESC	Multi School Code Flag 7 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_7)	NO	NO
MULTI_SCHOOL_FLAG8	Multi School Code Flag 8	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_8	NO	NO
MULTI_SCHOOL_FLAG8_DESC	Multi School Code Flag 8 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_8)	NO	NO
MULTI_SCHOOL_FLAG9	Multi School Code Flag 9	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_9	NO	NO
MULTI_SCHOOL_FLAG9_DESC	Multi School Code Flag 9 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_9)	NO	NO
OLDER_THAN_24_IND	Indicates that the student is older than 24.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_BORN_BEFORE_IND)	NO	NO
PARENT_ASSUMED_ADDL_FIN_INFO	Parent's assumed additional financial information total.	NUMBER	RCRESAR	RCRESAR_A_P_ADDL_FINANCIAL	NO	NO
PARENT_ASSUMED_AGI	Parent's assumed adjusted gross income.	NUMBER	RCRESAR	RCRESAR_A_PAR_US_INC	NO	NO
PARENT_ASSUMED_ASSET_TH_EXCD	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	NO	NO
PARENT_ASSUMED_INCOME_TAX_PAID	Parent's assumed income tax paid.	VARCHAR2(1)	RCRESAR	RCRESAR_A_PAR_INC_TAX_PD_IND	NO	NO
PARENT_ASSUMED_WORKSHEET_C_TOT	Assumed Parents' Worksheet C Title IV income exclusions total.	NUMBER	RCRESAR	RCRESAR_A_P_WORKSHEET_C	NO	NO
PARENT_FAMILY_IN_COLLEGE	Number of parent's family members in college.	NUMBER	RCRESAR	RCRESAR_A_PAR_NO_IN_COLL	NO	NO
PARENT_FAMILY_SIZE	Size of the parent's family.	NUMBER	RCRESAR	RCRESAR_A_PAR_FAM_MEMB	NO	NO
PARENT_MARITAL_STATUS_IND	Indicates the marital status of the parents.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)	NO	NO
PARENT_TAX_FILER_IND	CPS Determination of Parent's Tax Filing Status.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_PAR_TAX_FILED_IND)	NO	NO
PELL_ELIGIBLE_IND	Indicates applicants eligibility as of this transaction for a Federal Pell Grant.	VARCHAR2(1)	RCRESAR	RCRESAR_PELL_ELGBL	NO	NO
PELL_PAID_EFC	Expected family contribution upon which the school based its payment, as reported to the Central Processor.	NUMBER	RCRESAR	RCRESAR_PAID_EFC	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRESAR	RCRESAR_PIDM	NO	NO
PROCESSED_RECORD_TYPE	Type of processed application.	VARCHAR2(1)	RCRESAR	RCRESAR_REC_TYPE	NO	NO
PROCESSED_RECORD_TYPE_DESC	Processed record type description.	VARCHAR2(30)	CALCULATION	DECODE(RCRESAR_REC_TYPE)	NO	NO
REPROCESSED_REASON	Code for the reason the application was reprocessed.	VARCHAR2(2)	RCRESAR	RCRESAR_RE_PROC_REA_CD	NO	NO
SECONDARY_EFC_TYPE	Type of the secondary Expected Family Contribution.	VARCHAR2(1)	RCRESAR	RCRESAR_SEC_EFC_TYPE	NO	NO
SECONDARY_EFC_TYPE_DESC	Secondary expected family contribution description.	VARCHAR2(60)	CALCULATION	DECODE(RCRESAR_SEC_EFC_TYPE)	NO	NO
SIGNATURE_REJECT_EFC	Calculated EFC for record rejected due to missing signatures only. This is an unofficial EFC.	NUMBER	RCRESAR	RCRESAR_SIGNATURE_REJ_EFC	NO	NO
SPECIAL_CIRCUMSTANCES_FLAG	Indicates type of special circumstance performed.	VARCHAR2(63)	RCRESAR	RCRESAR_SPEC_CIRCUM_FLG	NO	NO
SPOUSE_ASSUMED_INCOME_WORK	Student's spouse's assumed income from work.	NUMBER	RCRESAR	RCRESAR_A_SPS_INC_FR_WRK	NO	NO
SUBSEQUENT_APPLICATION_IND	Indicates if a subsequent application from applicant exists.	VARCHAR2(1)	CALCULATION	NVL(RCRESAR_SUB_APP)	NO	NO
TAX_FILER_IND	CPS Determination of Student's Tax Filing Status.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_TAX_FILED_IND)	NO	NO
TRANSACTION_RECEIPT_DATE	Date the FAFSA ISIR information was received.	DATE	RCRESAR	RCRESAR_TRAN_RECEIPT_DATE	NO	NO
TRANSACTION_SITE_SOURCE	Origin and site code for the transaction.	VARCHAR2(2)	RCRESAR	RCRESAR_MDE_SITE_CD	NO	NO
TRANSACTION_TYPE	From where the transaction was generated.	VARCHAR2(1)	RCRESAR	RCRESAR_TRAN_TYPE	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RCRESAR	RCRESAR_USER_ID	NO	NO
VERIFICATION_SELECT_CHANGE_IND	Verification selection flag.	VARCHAR2(1)	CALCULATION	NVL(RCRESAR_VERIF_CHANGE_IND)	NO	NO
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(2)	RCRESAR	RCRESAR_VERIF_TYPE	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: