Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE		RCRESAR	RCRESAR_ACTIVITY_DATE
AID_YEAR	Financial Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)		RCRESAR	RCRESAR_AIDY_CODE
APPLICATION_NUMBER	Application Number	Financial aid application unique sequence number.	NUMBER(3)		RCRESAR	RCRESAR_SEQ_NO
APPLICATION_SOURCE_SITE	Application Source Site	Indicates the origin of the initial application and the site of the location.	VARCHAR2(2)		RCRESAR	RCRESAR_AGENCY_IND
ASSUMED_AGI	Assumed Agi	Student's assumed adjusted gross income.	NUMBER(6)		RCRESAR	RCRESAR_A_US_INC
ASSUMED_CITIZENSHIP	Assumed Citizenship	Code to determine assumptions about the student's citizenship.	VARCHAR2(1)		RCRESAR	RCRESAR_A_CITZ_IND
ASSUMED_CITIZENSHIP_DESC	Assumed Citizenship Description	Assumed citizen description.	VARCHAR2(15)		CALCULATION	DECODE(RCRESAR_A_CITZ_IND)
ASSUMED_DEPENDENT_IND	Assumed Dependent Indicator	Assumed number of student dependents.	VARCHAR2(1)		CALCULATION	DECODE(RCRESAR_A_S_DEPENDANTS)
ASSUMED_INCOME_TAX_PAID	Assumed Income Tax Paid	Assumed amount of Federal Tax paid by the student.	NUMBER(5)		RCRESAR	RCRESAR_A_S_FIT
ASSUMED_INCOME_WORK	Assumed Income Work	Student's assumed income from work.	NUMBER(6)		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(1)		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(1)		RCRESAR	RCRESAR_A_HAVE_CHILDREN
ASSUMED_VETERAN_IND	Assumed Veteran Indicator	Assumed veteran status of the student.	VARCHAR2(1)		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(5)		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(1)		CALCULATION	NVL(RCRESAR_AUTO_ZERO_EFC_FLAG)
BATCH_ID	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	Comment 1	ISIR comment code 1.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_01
COMMENT10	Comment 10	ISIR comment code 10.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_10
COMMENT10_DESC	Comment 10 Description	ISIR comment code 10 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT11	Comment 11	ISIR comment code 11.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_11
COMMENT11_DESC	Comment 11 Description	ISIR comment code 11 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT12	Comment 12	ISIR comment code 12.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_12
COMMENT12_DESC	Comment 12 Description	ISIR comment code 12 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT13	Comment 13	ISIR comment code 13.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_13
COMMENT13_DESC	Comment 13 Description	ISIR comment code 13 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT14	Comment 14	ISIR comment code 14.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_14
COMMENT14_DESC	Comment 14 Description	ISIR comment code 14 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT15	Comment 15	ISIR comment code 15.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_15
COMMENT15_DESC	Comment 15 Description	ISIR comment code 15 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT16	Comment 16	ISIR comment code 16.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_16
COMMENT16_DESC	Comment 16 Description	ISIR comment code 16 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT17	Comment 17	ISIR comment code 17.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_17
COMMENT17_DESC	Comment 17 Description	ISIR comment code 17 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT18	Comment 18	ISIR comment code 18.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_18
COMMENT18_DESC	Comment 18 Description	ISIR comment code 18 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT19	Comment 19	ISIR comment code 19.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_19
COMMENT19_DESC	Comment 19 Description	ISIR comment code 19 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT1_DESC	Comment 1 Description	ISIR comment code 1 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT2	Comment 2	ISIR comment code 2.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_02
COMMENT20	Comment 20	ISIR comment code 20.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_20
COMMENT20_DESC	Comment 20 Description	ISIR comment code 20 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT2_DESC	Comment 2 Description	ISIR comment code 2 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT3	Comment 3	ISIR comment code 3.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_03
COMMENT3_DESC	Comment 3 Description	ISIR comment code 3 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT4	Comment 4	ISIR comment code 4.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_04
COMMENT4_DESC	Comment 4 Description	ISIR comment code 4 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT5	Comment 5	ISIR comment code 5.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_05
COMMENT5_DESC	Comment 5 Description	ISIR comment code 5 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT6	Comment 6	ISIR comment code 6.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_06
COMMENT6_DESC	Comment 6 Description	ISIR comment code 6 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT7	Comment 7	ISIR comment code 7.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_07
COMMENT7_DESC	Comment 7 Description	ISIR comment code 7 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT8	Comment 8	ISIR comment code 8.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_08
COMMENT8_DESC	Comment 8 Description	ISIR comment code 8 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMMENT9	Comment 9	ISIR comment code 9.	NUMBER(3)		RCRESAR	RCRESAR_COMM_CODE_09
COMMENT9_DESC	Comment 9 Description	ISIR comment code 9 description.	VARCHAR2(1000)		FUNCTION	ROKODSF.F_GET_COMMENT_DESC
COMPUTED_BATCH_NUMBER	Computed Batch Number	Computed batch number assigned by the Central Processor to this ISIR.	NUMBER(3)		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(2)		RCRESAR	RCRESAR_CORR_APPL
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DESTINATION_NUMBER	Destination Number	The TGXXXXX number for the destination code of the transaction.	VARCHAR2(7)		RCRESAR	RCRESAR_ETI_DEST_CODE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
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(1)		CALCULATION	DECODE(RCRESAR_DUP_REQ_IND)
ELECT_APPL_ENTRY_SOURCE_IND	Elect Applicant Entry Source Indicator	The origin of the electronic application.	VARCHAR2(1)		CALCULATION	DECODE(RCRESAR_EDE_INST_IND)
FAMILY_IN_COLLEGE	Family In College	Number of student's family members in college.	NUMBER(1)		RCRESAR	RCRESAR_A_NO_IN_COLL
FAMILY_SIZE	Family Size	Size of the student's family.	NUMBER(2)		RCRESAR	RCRESAR_A_FAM_MEMB
FATHER_ASSUMED_INCOME_WORK	Father Assumed Income Work	Father's assumed income from work.	NUMBER(6)		RCRESAR	RCRESAR_A_FATH_INC_FR_WRK
FATHER_ASSUMED_TAX_ID	Father Assumed Tax ID	Assumed Father's tax ID number.	VARCHAR2(9)		RCRESAR	RCRESAR_A_FATH_SSN
FEDERAL_HOUSING1	Federal Housing 1	Federal housing code associated with the student's first federal college choice.	VARCHAR2(1)		RCRESAR	RCRESAR_FED_HOUS_CDE_1
FEDERAL_HOUSING1_DESC	Federal Housing 1 Description	Federal housing code description.	VARCHAR2(15)		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(1)		RCRESAR	RCRESAR_FED_HOUS_CDE_2
FEDERAL_HOUSING2_DESC	Federal Housing 2 Description	Federal housing code description.	VARCHAR2(15)		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(1)		RCRESAR	RCRESAR_FED_HOUS_CDE_3
FEDERAL_HOUSING3_DESC	Federal Housing 3 Description	Federal housing code description.	VARCHAR2(15)		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(1)		RCRESAR	RCRESAR_FED_HOUS_CDE_4
FEDERAL_HOUSING4_DESC	Federal Housing 4 Description	Federal housing code description.	VARCHAR2(15)		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(1)		RCRESAR	RCRESAR_FED_HOUS_CDE_5
FEDERAL_HOUSING5_DESC	Federal Housing 5 Description	Federal housing code description.	VARCHAR2(15)		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(1)		RCRESAR	RCRESAR_FED_HOUS_CDE_6
FEDERAL_HOUSING6_DESC	Federal Housing 6 Description	Federal housing code description.	VARCHAR2(15)		CALCULATION	DECODE(RCRESAR_FED_HOUS_CDE_6)
INPUT_RECORD_TYPE	Input Record Type	Type of Input Record.	VARCHAR2(1)		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(7)		RCRESAR	RCRESAR_INFC_CODE
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(1)		RCRESAR	RCRESAR_EDE_ETI_IND
ISIR_ELECT_TRANSACTION_DESC	Isir Elect Transaction Description	ISIR electronic transaction description.	VARCHAR2(125)		CALCULATION	DECODE(RCRESAR_EDE_ETI_IND)
MARITAL_STATUS_IND	Marital Status Indicator	Indicates the marital status of the student.	VARCHAR2(1)		CALCULATION	DECODE(RCRESAR_A_MRTL_STATUS_IND)
MIF_DESC	MIF Description	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	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 Family Contribution Primary	Month 10, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_10_MTH_CALC
MONTH10_FAMILY_CONTRIB_SECOND	Month 10 Family Contribution Second	Month 10, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_10_MTH_CALC
MONTH11_FAMILY_CONTRIB_PRIMARY	Month 11 Family Contribution Primary	Month 11, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_11_MTH_CALC
MONTH11_FAMILY_CONTRIB_SECOND	Month 11 Family Contribution Second	Month 11, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_11_MTH_CALC
MONTH12_FAMILY_CONTRIB_PRIMARY	Month 12 Family Contribution Primary	Month 12, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_12_MTH_CALC
MONTH12_FAMILY_CONTRIB_SECOND	Month 12 Family Contribution Second	Month 12, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_12_MTH_CALC
MONTH1_FAMILY_CONTRIB_PRIMARY	Month 1 Family Contribution Primary	Month 1, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_01_MTH_CALC
MONTH1_FAMILY_CONTRIB_SECOND	Month 1 Family Contribution Second	Month 1, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_01_MTH_CALC
MONTH2_FAMILY_CONTRIB_PRIMARY	Month 2 Family Contribution Primary	Month 2, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_02_MTH_CALC
MONTH2_FAMILY_CONTRIB_SECOND	Month 2 Family Contribution Second	Month 2, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_02_MTH_CALC
MONTH3_FAMILY_CONTRIB_PRIMARY	Month 3 Family Contribution Primary	Month 3, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_03_MTH_CALC
MONTH3_FAMILY_CONTRIB_SECOND	Month 3 Family Contribution Second	Month 3, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_03_MTH_CALC
MONTH4_FAMILY_CONTRIB_PRIMARY	Month 4 Family Contribution Primary	Month 4, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_04_MTH_CALC
MONTH4_FAMILY_CONTRIB_SECOND	Month 4 Family Contribution Second	Month 4, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_04_MTH_CALC
MONTH5_FAMILY_CONTRIB_PRIMARY	Month 5 Family Contribution Primary	Month 5, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_05_MTH_CALC
MONTH5_FAMILY_CONTRIB_SECOND	Month 5 Family Contribution Second	Month 5, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_05_MTH_CALC
MONTH6_FAMILY_CONTRIB_PRIMARY	Month 6 Family Contribution Primary	Month 6, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_06_MTH_CALC
MONTH6_FAMILY_CONTRIB_SECOND	Month 6 Family Contribution Second	Month 6, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_06_MTH_CALC
MONTH7_FAMILY_CONTRIB_PRIMARY	Month 7 Family Contribution Primary	Month 7, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_07_MTH_CALC
MONTH7_FAMILY_CONTRIB_SECOND	Month 7 Family Contribution Second	Month 7, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_07_MTH_CALC
MONTH8_FAMILY_CONTRIB_PRIMARY	Month 8 Family Contribution Primary	Month 8, primary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_1_FC_08_MTH_CALC
MONTH8_FAMILY_CONTRIB_SECOND	Month 8 Family Contribution Second	Month 8, secondary family contribution.	NUMBER(5)		RCRESAR	RCRESAR_ALT_2_FC_08_MTH_CALC
MOTHER_ASSUMED_INCOME_WORK	Mother Assumed Income Work	Mother's assumed income from work.	NUMBER(6)		RCRESAR	RCRESAR_A_MOTH_INC_FR_WRK
MOTHER_ASSUMED_TAX_ID	Mother Assumed Tax ID	Assumed Mother's tax ID number.	VARCHAR2(9)		RCRESAR	RCRESAR_A_MOTH_SSN
MULTI_SCHOOL_FLAG1	Multi School Indicator 1	Multi School Code Flag 1	VARCHAR2(1)		RCRESAR	RCRESAR_M_SCHOOL_FLAG_1
MULTI_SCHOOL_FLAG1_DESC	Multi School Indicator 1 Description	Multi School Code Flag 1 description.	VARCHAR2(125)		CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_1)
MULTI_SCHOOL_FLAG2	Multi School Indicator 2	Multi School Code Flag 2.	VARCHAR2(1)		RCRESAR	RCRESAR_M_SCHOOL_FLAG_2
MULTI_SCHOOL_FLAG2_DESC	Multi School Indicator 2 Description	Multi School Code Flag 2 description.	VARCHAR2(125)		CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_2)
MULTI_SCHOOL_FLAG3	Multi School Indicator 3	Multi School Code Flag 3.	VARCHAR2(1)		RCRESAR	RCRESAR_M_SCHOOL_FLAG_3
MULTI_SCHOOL_FLAG3_DESC	Multi School Indicator 3 Description	Multi School Code Flag 3 description.	VARCHAR2(125)		CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_3)
MULTI_SCHOOL_FLAG4	Multi School Indicator 4	Multi School Code Flag 4.	VARCHAR2(1)		RCRESAR	RCRESAR_M_SCHOOL_FLAG_4
MULTI_SCHOOL_FLAG4_DESC	Multi School Indicator 4 Description	Multi School Code Flag 4 description.	VARCHAR2(125)		CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_4)
MULTI_SCHOOL_FLAG5	Multi School Indicator 5	Multi School Code Flag 5.	VARCHAR2(1)		RCRESAR	RCRESAR_M_SCHOOL_FLAG_5
MULTI_SCHOOL_FLAG5_DESC	Multi School Indicator 5 Description	Multi School Code Flag 5 description.	VARCHAR2(125)		CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_5)
MULTI_SCHOOL_FLAG6	Multi School Indicator 6	Multi School Code Flag 6.	VARCHAR2(1)		RCRESAR	RCRESAR_M_SCHOOL_FLAG_6
MULTI_SCHOOL_FLAG6_DESC	Multi School Indicator 6 Description	Multi School Code Flag 6 description.	VARCHAR2(125)		CALCULATION	DECODE(RCRESAR_M_SCHOOL_FLAG_6)
OLDER_THAN_24_IND	Older Than 24 Indicator	Indicates that the student is older than 24.	VARCHAR2(1)		CALCULATION	DECODE(RCRESAR_A_BORN_BEFORE_IND)
PARENT_ASSUMED_AGI	Parent Assumed Agi	Parent's assumed adjusted gross income.	NUMBER(6)		RCRESAR	RCRESAR_A_PAR_US_INC
PARENT_ASSUMED_INCOME_TAX_PAID	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	Parent Assumed Worksheet C Total	Assumed Parents' Worksheet C Title IV income exclusions total.	NUMBER(5)		RCRESAR	RCRESAR_A_P_WORKSHEET_C
PARENT_FAMILY_IN_COLLEGE	Parent Family In College	Number of parent's family members in college.	NUMBER(1)		RCRESAR	RCRESAR_A_PAR_NO_IN_COLL
PARENT_FAMILY_SIZE	Parent Family Size	Size of the parent's family.	NUMBER(2)		RCRESAR	RCRESAR_A_PAR_FAM_MEMB
PARENT_MARITAL_STATUS_IND	Parent Marital Status Indicator	Indicates the marital status of the parents.	VARCHAR2(1)		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(1)		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(1)		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(5)		RCRESAR	RCRESAR_PAID_EFC
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RCRESAR	RCRESAR_PIDM
PROCESSED_RECORD_TYPE	Processed Record Type	Type of processed application.	VARCHAR2(1)		RCRESAR	RCRESAR_REC_TYPE
PROCESSED_RECORD_TYPE_DESC	Processed Record Type Description	Processed record type description.	VARCHAR2(30)		CALCULATION	DECODE(RCRESAR_REC_TYPE)
REPROCESSED_REASON	Reprocessed Reason	Code for the reason the application was reprocessed.	VARCHAR2(2)		RCRESAR	RCRESAR_RE_PROC_REA_CD
SECONDARY_EFC_TYPE	Secondary Effective Family Contribution Type	Type of the secondary Expected Family Contribution.	VARCHAR2(1)		RCRESAR	RCRESAR_SEC_EFC_TYPE
SECONDARY_EFC_TYPE_DESC	Secondary Effective Family Contribution Type Description	Secondary expected family contribution description.	VARCHAR2(60)		CALCULATION	DECODE(RCRESAR_SEC_EFC_TYPE)
SPOUSE_ASSUMED_INCOME_WORK	Spouse Assumed Income Work	Student's spouse's assumed income from work.	NUMBER(6)		RCRESAR	RCRESAR_A_SPS_INC_FR_WRK
SUBSEQUENT_APPLICATION_IND	Subsequent Application Indicator	Indicates if a subsequent application from applicant exists.	VARCHAR2(1)		CALCULATION	NVL(RCRESAR_SUB_APP)
TAX_FILER_IND	Tax Filer Indicator	CPS Determination of Student's Tax Filing Status	VARCHAR2(1)		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(2)		RCRESAR	RCRESAR_MDE_SITE_CD
TRANSACTION_TYPE	Transaction Type	From where the transaction was generated.	VARCHAR2(1)		RCRESAR	RCRESAR_TRAN_TYPE
USER_ID	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 Select Change Indicator	Verification selection flag.	VARCHAR2(1)		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(2)		RCRESAR	RCRESAR_VERIF_TYPE
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: