Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRESAR	RCRESAR_ACTIVITY_DATE
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
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(2)	RCRESAR	RCRESAR_AGENCY_IND
ASSUMED_ADDL_FIN_INFO	Student's assumed additional financial information total.	NUMBER	RCRESAR	RCRESAR_A_S_ADDL_FINANCIAL
ASSUMED_AGI	Student's assumed adjusted gross income.	NUMBER	RCRESAR	RCRESAR_A_US_INC
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
ASSUMED_CITIZENSHIP	Code to determine assumptions about the student's citizenship.	VARCHAR2(1)	RCRESAR	RCRESAR_A_CITZ_IND
ASSUMED_CITIZENSHIP_DESC	Assumed citizen description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_A_CITZ_IND)
ASSUMED_DEPENDENT_IND	Assumed number of student dependents.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_S_DEPENDANTS)
ASSUMED_HOMELESS_HUD	Month 9, primary family contribution.	VARCHAR2(63)	RCRESAR	RCRESAR_A_HOMELESS_HUD
ASSUMED_HOMELESS_SCHOOL	The student is assumed to be homeless by the school.	VARCHAR2(63)	RCRESAR	RCRESAR_A_HOMELESS_SCHOOL
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(1)	CALCULATION	DECODE(RCRESAR_A_MARRIED)
ASSUMED_RISK_OF_HOMELESSNESS	The student is assumed to be at risk of homelessness.	VARCHAR2(63)	RCRESAR	RCRESAR_A_AT_RISK_HOMELESS
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
ASSUMED_VETERAN_IND	Assumed veteran status of the student.	VARCHAR2(1)	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(1)	CALCULATION	NVL(RCRESAR_AUTO_ZERO_EFC_FLAG)
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
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(2)	RCRESAR	RCRESAR_CORR_APPL
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DESTINATION_NUMBER	The TGXXXXX number for the destination code of the transaction.	VARCHAR2(7)	RCRESAR	RCRESAR_ETI_DEST_CODE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
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)
ELECT_APPL_ENTRY_SOURCE_IND	The origin of the electronic application.	VARCHAR2(1)	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 assumed income from work.	NUMBER	RCRESAR	RCRESAR_A_FATH_INC_FR_WRK
FATHER_ASSUMED_TAX_ID	Assumed Father's tax ID number.	VARCHAR2(9)	RCRESAR	RCRESAR_A_FATH_SSN
FEDERAL_HOUSING1	Federal housing code associated with the student's first federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_1
FEDERAL_HOUSING10	Indicates the federal housing code associated with the student's tenth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_10
FEDERAL_HOUSING10_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_10)
FEDERAL_HOUSING1_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_1)
FEDERAL_HOUSING2	Federal housing code associated with the student's second federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_2
FEDERAL_HOUSING2_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_2)
FEDERAL_HOUSING3	Federal housing code associated with the student's third federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_3
FEDERAL_HOUSING3_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_3)
FEDERAL_HOUSING4	Federal housing code associated with the student's fourth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_4
FEDERAL_HOUSING4_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_4)
FEDERAL_HOUSING5	Federal housing code associated with the student's fifth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_5
FEDERAL_HOUSING5_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_5)
FEDERAL_HOUSING6	Federal housing code associated with the student's sixth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_6
FEDERAL_HOUSING6_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_6)
FEDERAL_HOUSING7	Indicates the federal housing code associated with the student's seventh federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_7
FEDERAL_HOUSING7_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_7)
FEDERAL_HOUSING8	Indicates the federal housing code associated with the student's eighth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_8
FEDERAL_HOUSING8_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_8)
FEDERAL_HOUSING9	Indicates the federal housing code associated with the student's ninth federal college choice.	VARCHAR2(1)	RCRESAR	RCRESAR_FED_HOUS_CDE_9
FEDERAL_HOUSING9_DESC	Federal housing code description.	VARCHAR2(15)	CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_9)
INPUT_RECORD_TYPE	Type of Input Record.	VARCHAR2(1)	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(7)	RCRESAR	RCRESAR_INFC_CODE
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
ISIR_ELECT_TRANSACTION_DESC	ISIR electronic transaction description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_EDE_ETI_IND)
MARITAL_STATUS_IND	Indicates the marital status of the student.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_MRTL_STATUS_IND)
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
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
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
MONTH9_FAMILY_CONTRIB_PRIMARY	Month 9, primary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_1_FC_09_MTH_CALC
MONTH9_FAMILY_CONTRIB_SECOND	Month 9, secondary family contribution.	NUMBER	RCRESAR	RCRESAR_ALT_2_FC_09_MTH_CALC
MOTHER_ASSUMED_INCOME_WORK	Mother's assumed income from work.	NUMBER	RCRESAR	RCRESAR_A_MOTH_INC_FR_WRK
MOTHER_ASSUMED_TAX_ID	Assumed Mother's tax ID number.	VARCHAR2(9)	RCRESAR	RCRESAR_A_MOTH_SSN
MULTI_SCHOOL_FLAG1	Multi School Code Flag 1.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_1
MULTI_SCHOOL_FLAG10	Multi School Code Flag 10	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_10
MULTI_SCHOOL_FLAG10_DESC	Multi School Code Flag 10 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_10)
MULTI_SCHOOL_FLAG1_DESC	Multi School Code Flag 1 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_1)
MULTI_SCHOOL_FLAG2	Multi School Code Flag 2.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_2
MULTI_SCHOOL_FLAG2_DESC	Multi School Code Flag 2 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_2)
MULTI_SCHOOL_FLAG3	Multi School Code Flag 3.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_3
MULTI_SCHOOL_FLAG3_DESC	Multi School Code Flag 3 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_3)
MULTI_SCHOOL_FLAG4	Multi School Code Flag 4.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_4
MULTI_SCHOOL_FLAG4_DESC	Multi School Code Flag 4 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_4)
MULTI_SCHOOL_FLAG5	Multi School Code Flag 5.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_5
MULTI_SCHOOL_FLAG5_DESC	Multi School Code Flag 5 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_5)
MULTI_SCHOOL_FLAG6	Multi School Code Flag 6.	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_6
MULTI_SCHOOL_FLAG6_DESC	Multi School Code Flag 6 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_6)
MULTI_SCHOOL_FLAG7	Multi School Code Flag 7	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_7
MULTI_SCHOOL_FLAG7_DESC	Multi School Code Flag 7 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_7)
MULTI_SCHOOL_FLAG8	Multi School Code Flag 8	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_8
MULTI_SCHOOL_FLAG8_DESC	Multi School Code Flag 8 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_8)
MULTI_SCHOOL_FLAG9	Multi School Code Flag 9	VARCHAR2(1)	RCRESAR	RCRESAR_M_SCHOOL_FLAG_9
MULTI_SCHOOL_FLAG9_DESC	Multi School Code Flag 9 description.	VARCHAR2(125)	CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_9)
OLDER_THAN_24_IND	Indicates that the student is older than 24.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_BORN_BEFORE_IND)
PARENT_ASSUMED_ADDL_FIN_INFO	Parent's assumed additional financial information total.	NUMBER	RCRESAR	RCRESAR_A_P_ADDL_FINANCIAL
PARENT_ASSUMED_AGI	Parent's assumed adjusted gross income.	NUMBER	RCRESAR	RCRESAR_A_PAR_US_INC
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
PARENT_ASSUMED_INCOME_TAX_PAID	Parent's assumed income tax paid.	VARCHAR2(1)	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(1)	CALCULATION	DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)
PARENT_TAX_FILER_IND	CPS Determination of Parent's Tax Filing Status.	VARCHAR2(1)	CALCULATION	DECODE(RCRESAR_A_PAR_TAX_FILED_IND)
PELL_ELIGIBLE_IND	Indicates applicants eligibility as of this transaction for a Federal Pell Grant.	VARCHAR2(1)	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(1)	RCRESAR	RCRESAR_REC_TYPE
PROCESSED_RECORD_TYPE_DESC	Processed record type description.	VARCHAR2(30)	CALCULATION	DECODE(RCRESAR_REC_TYPE)
REPROCESSED_REASON	Code for the reason the application was reprocessed.	VARCHAR2(2)	RCRESAR	RCRESAR_RE_PROC_REA_CD
SECONDARY_EFC_TYPE	Type of the secondary Expected Family Contribution.	VARCHAR2(1)	RCRESAR	RCRESAR_SEC_EFC_TYPE
SECONDARY_EFC_TYPE_DESC	Secondary expected family contribution description.	VARCHAR2(60)	CALCULATION	DECODE(RCRESAR_SEC_EFC_TYPE)
SIGNATURE_REJECT_EFC	Calculated EFC for record rejected due to missing signatures only. This is an unofficial EFC.	NUMBER	RCRESAR	RCRESAR_SIGNATURE_REJ_EFC
SPECIAL_CIRCUMSTANCES_FLAG	Indicates type of special circumstance performed.	VARCHAR2(63)	RCRESAR	RCRESAR_SPEC_CIRCUM_FLG
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(1)	CALCULATION	NVL(RCRESAR_SUB_APP)
TAX_FILER_IND	CPS Determination of Student's Tax Filing Status.	VARCHAR2(1)	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(2)	RCRESAR	RCRESAR_MDE_SITE_CD
TRANSACTION_TYPE	From where the transaction was generated.	VARCHAR2(1)	RCRESAR	RCRESAR_TRAN_TYPE
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RCRESAR	RCRESAR_USER_ID
VERIFICATION_SELECT_CHANGE_IND	Verification selection flag.	VARCHAR2(1)	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(2)	RCRESAR	RCRESAR_VERIF_TYPE
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: