Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRAPP4	RCRAPP4_ACTIVITY_DATE	NO	NO
ADDRESS_CHANGE	Address Only Change Flag.	VARCHAR2(1)	RCRAPP4	RCRAPP4_ADDRESS_CHG_FLAG	NO	NO
ADDRESS_CHANGE_DESC	Address Only Change Flag description.	VARCHAR2(40)	CALCULATION	DECODE(RCRAPP4_ADDRESS_CHG_FLAG)	NO	NO
ADOPTED_AFTER_13		VARCHAR2(1)				NO
ADOPTED_AFTER_13_DESC		VARCHAR2(4000)				NO
AID_ELIGIBILITY_RESPONSE	Drug Offense Conviction indicated.	VARCHAR2(1)	RCRAPP4	RCRAPP4_DRUG_OFFENSE_CONVIC	NO	NO
AID_ELIGIBILITY_RESPONSE_DESC	Aid eligibility response description.	VARCHAR2(25)				NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RCRAPP4	RCRAPP4_AIDY_CODE	NO	NO
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP4	RCRAPP4_SEQ_NO	NO	NO
ASSET_THRESHOLD_EXCEED		NUMBER				NO
BUSINESS_NET_WORTH	Student's business net worth.	NUMBER	RCRAPP4	RCRAPP4_BUS_NET_WORTH	NO	NO
CITIZENSHIP_TYPE	Student citizenship type.	VARCHAR2(1)	RCRAPP4	RCRAPP4_SSA_CITIZEN_IND	NO	NO
CITIZENSHIP_TYPE_DESC	Student citizenship type description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP4_SSA_CITIZEN_IND)	NO	NO
COMBAT_PAY		NUMBER				NO
CORRECTION_SOURCE	Source of the correction.	VARCHAR2(1)	RCRAPP4	RCRAPP4_SOURCE_CORRECTION	NO	NO
CORRECTION_SOURCE_DESC	Correction source description.	VARCHAR2(10)	CALCULATION	DECODE(RCRAPP4_SOURCE_CORRECTION)	NO	NO
CPS_ISIR_PUSHED_IND	CPS Pushed ISIR Flag.	VARCHAR2(1)	CALCULATION	NVL(RCRAPP4_PUSH_ISIR_FLAG)	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DATA_TYPE_AVAILABLE	Type of data available for the FM and/or IM calculations.	VARCHAR2(1)	RCRAPP4	RCRAPP4_TYPE_DATA_AVAIL	NO	NO
DATA_TYPE_AVAILABLE_DESC	Data type description.	VARCHAR2(10)	CALCULATION	DECODE(RCRAPP4_TYPE_DATA_AVAIL)	NO	NO
DEATH_DATE	Date of death associated with the person on this application as reported to the government.	DATE	RCRAPP4	RCRAPP4_DEATH_DATE	NO	NO
DIVIDEND_INCOME	Amount of the student's dividend and interest income received.	NUMBER	RCRAPP4	RCRAPP4_S_DIV_INT_INC	NO	NO
DOD_MATCH		VARCHAR2(1)				NO
DOD_MATCH_DESC		VARCHAR2(4000)				NO
DOD_PARENT_DEATH_DATE		DATE				NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
DUPLICATE_TAX_ID_IND	Duplicate tax id indicator identifies whether more than one person is using the same ID number.	VARCHAR2(1)	CALCULATION	NVL(RCRAPP4_DUP_SSN_IND)	NO	NO
EFC_CHANGE_FLAG	The EFC Change flag indicates if the EFC has increased or decreased.	VARCHAR2(1)	RCRAPP4	RCRAPP4_EFC_CHANGE_IND	NO	NO
EFC_CHANGE_FLAG_DESC	description of the EFC change flag.	VARCHAR2(10)				NO
EFM_DEPENDENCY_STATUS		VARCHAR2(1)				NO
EFM_DEPENDENCY_STATUS_DESC		VARCHAR2(4000)				NO
EMAIL_ADDRESS	Student's e-mail address as reported on PROFILE.	VARCHAR2(128)	RCRAPP4	RCRAPP4_EMAIL_ADDRESS	NO	NO
FATHER_BIRTH_DATE	Father's/Stepfather's date of birth.	DATE	RCRAPP4	RCRAPP4_FATH_BIRTH_DATE	NO	NO
FATHER_FIRST_INITIAL	Father's/Stepfather's first name/initial.	VARCHAR2(1)	RCRAPP4	RCRAPP4_FATH_FIRST_NAME_INI	NO	NO
FATHER_LAST_NAME	Father's Last Name.	VARCHAR2(60)	RCRAPP4	RCRAPP4_FATH_LAST_NAME	NO	NO
FATHER_TAX_ID	Father's tax id.	VARCHAR2(15)	RCRAPP4	RCRAPP4_FATH_SSN	NO	NO
FISAP_TOTAL_INCOME	Indicates the person's total FISAP income.	NUMBER	RCRAPP4	RCRAPP4_FISAP_INC	NO	NO
FM_CONTRIBUTION_OFFICIAL_AMT	Official student contribution amount.	NUMBER	RCRAPP4	RCRAPP4_C_NA_1_CTRB_FOR_STDT	NO	NO
FM_DEPENDENCY_STATUS		VARCHAR2(1)				NO
FM_DEPENDENCY_STATUS_DESC		VARCHAR2(4000)				NO
FM_EST_OTHER_ASSET	Amount of the other asset (override) used in the student FM calculation.	NUMBER	RCRAPP4	RCRAPP4_C_1_OTH_ASSET	NO	NO
FM_FISAP_TOTAL_INCOME		NUMBER				NO
FM_FORMULA	Formula used for the FM calculation.	VARCHAR2(1)	RCRAPP4	RCRAPP4_FORMULA_FOR_CALC	NO	NO
FM_FORMULA_DESC	FM formula description.	VARCHAR2(60)	CALCULATION	DECODE(RCRAPP4_FORMULA_FOR_CALC)	NO	NO
FM_PARENT_CONTRIB_OFFICIAL_AMT	Official parent contribution amount.	NUMBER	RCRAPP4	RCRAPP4_C_NA_1_P_CTRB_FOR_STDT	NO	NO
FM_PARENT_CONTRIB_OFFICIAL_EST	Indicates if the parental contribution amount is official or estimated.	VARCHAR2(1)	RCRAPP4	RCRAPP4_C_NA_1_P_CTRB_OFFL_EST	NO	NO
FM_PARENT_CONTRIB_OFF_EST_DESC	Parent contribution official/estimate description.	VARCHAR2(4000)				NO
FM_PARENT_DATA_AVAILABLE_IND	Indicates whether parent data was available for the FM calculation.	VARCHAR2(1)	RCRAPP4	RCRAPP4_FM_PAR_DATA_AVAIL	NO	NO
FM_PARENT_EST_INCOME_ADJUST	Amount of the income adjustment used in the parent FM calculation.	NUMBER	RCRAPP4	RCRAPP4_C_PAR_1_INC_ADJ	NO	NO
FM_PARENT_EST_OTHER_ASSET	Amount of the other asset (override) used in the parent FM calculation.	NUMBER	RCRAPP4	RCRAPP4_C_PAR_1_OTH_ASSET	NO	NO
FM_PARENT_EST_OTH_INCOME_ALLOW	Amount of the other income allowance (override) used in the parent FM calculation.	NUMBER	RCRAPP4	RCRAPP4_C_PAR_1_OTH_ALLOW	NO	NO
FM_PARENT_WORKSHEET_A_TOTAL	Parents' Worksheet A untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_A	NO	NO
FM_TOTAL_FAMILY_CONTRIBUTION	Total family contribution for the federal methodology calculation.	NUMBER	RCRAPP4	RCRAPP4_C_INST_1_TOT_FAM_CTRB	NO	NO
FM_WORKSHEET_A_TOTAL	Student's Worksheet A untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_A	NO	NO
HOMELESS		VARCHAR2(1)				NO
HOMELESS_DESC		VARCHAR2(4000)				NO
HOME_AMOUNT_PAID	Amount student paid for home.	NUMBER	RCRAPP4	RCRAPP4_HME_PURCH_AMT	NO	NO
HOME_YEAR_PURCHASED	Year student purchased home.	NUMBER	RCRAPP4	RCRAPP4_HME_YR_PURCH	NO	NO
IM_BUDGET_DURATION	Budget duration used for the IM calculation.	NUMBER	RCRAPP4	RCRAPP4_IM_BUDG_DUR_FOR_CALC	NO	NO
IM_CONTRIBUTION_AMOUNT	Student IM contribution amount.	NUMBER	RCRAPP4	RCRAPP4_C_NA_1_IM_CTRB_STDT	NO	NO
IM_CUSTODIAL_PARENT	Custodial parent used for IM only calculation of custodial parent's adjustment contribution.	VARCHAR2(1)	RCRAPP4	RCRAPP4_CUSTODIAL_PARENT	NO	NO
IM_CUSTODIAL_PARENT_DESC	IM custodial parent description.	VARCHAR2(10)	RORMVAL	RORMVAL_DESC	NO	NO
IM_DEPENDENCY_STATUS		VARCHAR2(1)				NO
IM_DEPENDENCY_STATUS_DESC		VARCHAR2(4000)				NO
IM_OTHER_ASSET_ALLOW_OVR	Amount of the other asset allowance (override) used in the student IM calculation.	NUMBER	RCRAPP4	RCRAPP4_C_2_OTH_ASSET_ALLOW	NO	NO
IM_OTHER_ASSET_OVR	Amount of the other asset (override) used in the student IM calculation.	NUMBER	RCRAPP4	RCRAPP4_C_2_OTH_ASSET	NO	NO
IM_PARENT_CONTRIBUTION_AMOUNT	Parent IM contribution amount.	NUMBER	RCRAPP4	RCRAPP4_C_NA_1_P_IM_CTRB_STDT	NO	NO
IM_PARENT_DATA_AVAILABLE_IND	Indicates whether parent data was available for the IM calculation.	VARCHAR2(1)	RCRAPP4	RCRAPP4_IM_PAR_DATA_AVAIL	NO	NO
IM_PARENT_OTH_ASSET_ALLOW_OVR	Amount of the other asset allowance (override) used in the parent IM calculation.	NUMBER	RCRAPP4	RCRAPP4_C_PAR_2_OTH_ASSET_ALLW	NO	NO
IM_TRUST_AMOUNT	Amount of the student trust account used in the student IM calculation.	NUMBER	RCRAPP4	RCRAPP4_C_2_TRUST_VAL	NO	NO
INTERESTED_IN_PLUS_LOAN	This field indicates that a parent is interested in receiving a parent PLUS loan.	VARCHAR2(1)	RCRAPP4	RCRAPP4_PLUS_INT	NO	NO
INTEREST_IN_WORK_STUDY_OR_LOAN	Indicates whether or not the applicant is interested in work study or student loans.	VARCHAR2(1)	RCRAPP4	RCRAPP4_WRK_STDY_LOANS_INT	NO	NO
INTEREST_WORK_STUDY_LOAN_DESC	Applicant is interested in work study or student loans Indicator description.	VARCHAR2(60)	RORMVAL	RORMVAL_DESC	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)	RCRAPP4	RCRAPP4_INFC_CODE	NO	NO
INVESTMENT_NET_WORTH	Student's investment net worth.	NUMBER	RCRAPP4	RCRAPP4_INV_NET_WORTH	NO	NO
LEGAL_RESIDENT_IND	Indicates whether the student was a legal resident before January 1, YYYY.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_LEGAL_RES_IND)	NO	NO
LOAN_INTEREST_IND	Indicates that a student is interested in receiving student loans.	VARCHAR2(1)				NO
MESSAGE_31	A value of '1' indicates F.78 and C30A-I differ by $100 or more	VARCHAR2(1)	RCRAPP4	RCRAPP4_MSG_31	NO	NO
MESSAGE_72	A value of '1' indicates Federal student AGI reduced by F.68	VARCHAR2(1)	RCRAPP4	RCRAPP4_MSG_72	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
MILITARY_REGISTRATION_STATUS	Military registration match flag.	VARCHAR2(1)	RCRAPP4	RCRAPP4_SS_MATCH	NO	NO
MILITARY_REGIST_STATUS_DESC	Military registration match description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP4_SS_MATCH)	NO	NO
MILITARY_REG_REQ_STATUS	Results from the student's request to be registered with the military service.	VARCHAR2(1)	RCRAPP4	RCRAPP4_SS_REG_FLAG	NO	NO
MILITARY_REG_REQ_STATUS_DESC	Student military registration request status description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP4_SS_REG_FLAG)	NO	NO
MOTHER_BIRTH_DATE	Mother's/Stepmother's date of birth.	DATE	RCRAPP4	RCRAPP4_MOTH_BIRTH_DATE	NO	NO
MOTHER_FIRST_INITIAL	Mother's/Stepmother's first name initial.	VARCHAR2(1)	RCRAPP4	RCRAPP4_MOTH_FIRST_NAME_INI	NO	NO
MOTHER_LAST_NAME	Mother's Last Name.	VARCHAR2(60)	RCRAPP4	RCRAPP4_MOTH_LAST_NAME	NO	NO
MOTHER_TAX_ID	Mother's tax id.	VARCHAR2(15)	RCRAPP4	RCRAPP4_MOTH_SSN	NO	NO
NATIONAL_STUDENT_LOAN_SYSTEM	Indicates the results of the tape match against the National Student Loan Data System database.	VARCHAR2(1)	RCRAPP4	RCRAPP4_NSLDS_MATCH	NO	NO
NATIONAL_STUDENT_LOAN_SYS_DESC	National student loan system description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP4_NSLDS_MATCH)	NO	NO
NATIONAL_STUDENT_LOAN_TRAN_NUM	This field indicates the NSLDS transaction number associated with the Need Analysis data for this applicant.	VARCHAR2(2)	RCRAPP4	RCRAPP4_NSLDS_TRAN_NO	NO	NO
OLDEST_LOAN_DATE	This contains the date (MMDDYY) of the student's oldest outstanding loan.	VARCHAR2(4)	RCRAPP4	RCRAPP4_OLDEST_LOAN_DATE	NO	NO
PARENTS_FARM_DEBT	The current debt against the parents' farm.	NUMBER	RCRAPP4	RCRAPP4_P_FARM_DBT_FAF	NO	NO
PARENTS_FARM_VALUE	The current value of the parents' farm	NUMBER	RCRAPP4	RCRAPP4_P_FARM_VAL_FAF	NO	NO
PARENT_1_EMPLOYER	The employer of parent 1.	VARCHAR2(20)	RCRAPP4	RCRAPP4_PAR1_EMPLOYER	NO	NO
PARENT_1_OCCUPATION	The occupation of parent 1.	VARCHAR2(20)	RCRAPP4	RCRAPP4_PAR1_OCCUPATION	NO	NO
PARENT_2_EMPLOYER	The employer of parent 2.	VARCHAR2(20)	RCRAPP4	RCRAPP4_PAR2_EMPLOYER	NO	NO
PARENT_2_OCCUPATION	The occupation of parent 2.	VARCHAR2(20)	RCRAPP4	RCRAPP4_PAR2_OCCUPATION	NO	NO
PARENT_ASSET_THRESHOLD_EXCEED		NUMBER				NO
PARENT_BUSINESS_NET_WORTH	Parent's business net worth.	NUMBER	RCRAPP4	RCRAPP4_PAR_BUS_NET_WORTH	NO	NO
PARENT_COMBAT_PAY		NUMBER				NO
PARENT_DEPEND_CARE_MED_ACCOUNT	Amounts withheld from parent wages for dependent care and medical spending accounts.	NUMBER	RCRAPP4	RCRAPP4_PAR_DEP_CARE_AND_MED	NO	NO
PARENT_DPDNT_CARE_CONTRIBUTION	The parents' contribution to a flexible spending account for dependent care.	NUMBER	RCRAPP4	RCRAPP4_PAR_DEPENDENT_CARE	NO	NO
PARENT_EMAIL_ADDRESS	Parent's Email Address.	VARCHAR2(128)	RCRAPP4	RCRAPP4_P_EMAIL_ADDRESS	NO	NO
PARENT_EXPECTED_TUITION_PAID	Parents expected tuition paid.	NUMBER	RCRAPP4	RCRAPP4_EXP_PAR_TUIT_PD	NO	NO
PARENT_EXP_NO_CHILD_TUITION_PD	Parents expected number of children for whom they are paying tuition.	NUMBER	RCRAPP4	RCRAPP4_EXP_PAR_NO_CHILD_TUIT	NO	NO
PARENT_FARM_NET_WORTH	This field indicates the parent's farm net worth.	NUMBER	RCRAPP4	RCRAPP4_PAR_FARM_NET_WORTH	NO	NO
PARENT_HEALTHCARE_CONTRIBUTION	The parents' contribution to a flexible spending account for health care.	NUMBER	RCRAPP4	RCRAPP4_PAR_FSA_HEALTH_CARE	NO	NO
PARENT_HSA_CONTRIBUTION	The parents' contribution to a health savings account.	NUMBER	RCRAPP4	RCRAPP4_PAR_HEALTH_SAV_ACCOUNT	NO	NO
PARENT_HSA_PRETAX_CONTRIBUTION	The amount withheld from the parent's pre-tax wages for a Heath Savings Account.	NUMBER	RCRAPP4	RCRAPP4_PAR_HSA_PRE_TAX	NO	NO
PARENT_INVESTMENT_NET_WORTH	Parent's investment net worth.	NUMBER	RCRAPP4	RCRAPP4_PAR_INV_NET_WORTH	NO	NO
PARENT_LEGAL_RESIDENT_IND	Indicates whether the parent was a legal resident before January 1, YYYY.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_PAR_LEGAL_RES_IND)	NO	NO
PARENT_NUMBER_OF_BUSINESSES		NUMBER				NO
PARENT_NUMBER_OF_FARMS		NUMBER				NO
PARENT_RESIDENT_SINCE_DATE	Start date of Parent's Residency in State.	VARCHAR2(6)	RCRAPP4	RCRAPP4_P_RES_DATE_MO_YR	NO	NO
PARENT_SHORT_TAX_FORM_IND	Indicates whether the parent is eligible to file a federal short tax form.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_PAR_1040A_ELIG_IND)	NO	NO
PARENT_STATE_FOR_TAXES	The state used for calculation of the parent state and local taxes.	VARCHAR2(2)	RCRAPP4	RCRAPP4_PAR_STATE_FOR_TAXES	NO	NO
PARENT_TAX_FILER	Indicates whether the parents were considered to be tax filers for calculation purposes.	VARCHAR2(1)	RCRAPP4	RCRAPP4_PAR_TAX_FILER	NO	NO
PARENT_TAX_RETURN_FILED	Indicates whether the parent has already filed, will file or will not file a tax return.	VARCHAR2(1)	RCRAPP4	RCRAPP4_PAR_TX_RET_FILED_IND	NO	NO
PARENT_TAX_RETURN_FILED_DESC	Parent tax return filed description.	VARCHAR2(4000)				NO
PARENT_TITLE_IV_INC_EXCLUSION	Parent's Title IV income exclusions such as taxable financial aid and child support paid.	NUMBER	RCRAPP4	RCRAPP4_P_IV_INC	NO	NO
PARENT_TYPE1		VARCHAR2(1)				NO
PARENT_TYPE1_DESC		VARCHAR2(4000)				NO
PARENT_TYPE2		VARCHAR2(1)				NO
PARENT_TYPE2_DESC		VARCHAR2(4000)				NO
PARENT_WORKSHEET_B_TOTAL	Parents' Worksheet B untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_B	NO	NO
PARENT_WORKSHEET_C_TOTAL	Parent's total amount from Worksheet C.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_C	NO	NO
PELL_EFC_OFFICIAL_ESTIMATE	Indicates if the Pell parental contribution amount is official or estimated.	VARCHAR2(1)	RCRAPP4	RCRAPP4_C_NA_1_PELL_OFFL_EST	NO	NO
PELL_EFC_OFFICIAL_EST_DESC	Pell EFC official/estimate description.	VARCHAR2(4000)				NO
PELL_EFFECTIVE_FAMILY_CONT	Student Pell effective family contribution.	NUMBER	RCRAPP4	RCRAPP4_C_NA_1_PELL_PGI	NO	NO
PERM_RESIDENCY_VER_STATUS	Permanent residency verification status.	VARCHAR2(1)	RCRAPP4	RCRAPP4_SEC_INS_MATCH_IND	NO	NO
PERM_RESIDENCY_VER_STATUS_DESC	Permanent residency verification status description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP4_SEC_INS_MATCH_IND)	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP4	RCRAPP4_PIDM	NO	NO
PRISONER_MATCH	Prisoner Match.	VARCHAR2(1)	RCRAPP4	RCRAPP4_PRISONER_MATCH_FLAG	NO	NO
PRI_EFF_FAMILY_CONTRIBUTION	Contains the primary adjusted total contribution from a family.	NUMBER	RCRAPP4	RCRAPP4_PELL_1_EFC	NO	NO
PROFILE_FEE_WAIVER_IND	Indicates whether or not this applicant used a Fee Waiver.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_FEE_WAIVER_IND)	NO	NO
RECORD_MARK	The record mark.	VARCHAR2(1)	RCRAPP4	RCRAPP4_RECORD_MARK	NO	NO
RECORD_TYPE	The record type.	VARCHAR2(1)	RCRAPP4	RCRAPP4_REC_TYPE	NO	NO
RETIREMENT_PLAN_PAYMENT		NUMBER				NO
SAR_C_CHANGE_IND	SAR C Change Flag.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_SAR_C_CHANGE_FLAG)	NO	NO
SAR_EFC	Identifies what the SAR EFC was for a person when they were added in dataload.	NUMBER	RCRAPP4	RCRAPP4_SAR_EFC	NO	NO
SECONDARY_SCHL_STATE_PROV_DESC		VARCHAR2(30)				NO
SECONDARY_SCHOOL		VARCHAR2(12)				NO
SECONDARY_SCHOOL_CITY		VARCHAR2(28)				NO
SECONDARY_SCHOOL_DIPLOMA_IND	Indicates if the person has received a high school diploma/GED.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_HS_GED_RCVD)	NO	NO
SECONDARY_SCHOOL_INVALID		VARCHAR2(1)				NO
SECONDARY_SCHOOL_INVALID_DESC		VARCHAR2(4000)				NO
SECONDARY_SCHOOL_NAME		VARCHAR2(50)				NO
SECONDARY_SCHOOL_STATE_PROV		VARCHAR2(2)				NO
SEC_EFF_FAMILY_CONTRIBUTION	Contains the secondary adjusted total contribution from a family.	NUMBER	RCRAPP4	RCRAPP4_PELL_2_EFC	NO	NO
SHORT_TAX_FORM_IND	Indicates whether the student is eligible to file a federal short tax form.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_1040A_ELIG_IND)	NO	NO
STUDENTS_FARM_DEBT	The current debt against the student's farm.	NUMBER	RCRAPP4	RCRAPP4_S_FARM_DBT_FAF	NO	NO
STUDENTS_FARM_VALUE	The current value of the student's farm.	NUMBER	RCRAPP4	RCRAPP4_S_FARM_VAL_FAF	NO	NO
STUDENT_EIC	The student's EIC.	NUMBER	RCRAPP4	RCRAPP4_S_EIC	NO	NO
STUDENT_RESIDENT_SINCE_DATE	Start date of Student's Residency in State.	VARCHAR2(6)	RCRAPP4	RCRAPP4_S_RES_DATE_MO_YR	NO	NO
STUDENT_STATE_FOR_TAXES	The state used for calculation of the student state and local taxes.	VARCHAR2(2)	RCRAPP4	RCRAPP4_STATE_FOR_TAXES	NO	NO
STUDENT_TAX_FILER	Indicates whether the student was considered to be a tax filer for calculation purposes.	VARCHAR2(1)	RCRAPP4	RCRAPP4_TAX_FILER	NO	NO
SUBSEQUENT_RECORD_SELECTED_VER	Subsequent Record Selected For Verification.	VARCHAR2(1)	RCRAPP4	RCRAPP4_SUB_VERIF_SELECTED	NO	NO
SUPPORT_CHILDREN_IND	Student has children who receive more than half of their support from him/her.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_HAVE_CHILDREN)	NO	NO
SURROGATE_ID	Immutable unique key.	NUMBER	RCRAPP4	RCRAPP4_SURROGATE_ID	NO	NO
TAPE_REPORT_EXTRACT_DATE	The date of the tape report extract.	DATE	RCRAPP4	RCRAPP4_TAPE_RPT_EXTRCT_DATE	NO	NO
TAX_RETURN_FILED	Indicates whether the student has already filed, will file or will not file a tax return.	VARCHAR2(1)	RCRAPP4	RCRAPP4_TX_RET_FILED_IND	NO	NO
TAX_RETURN_FILED_DESC	Student tax return filed description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP4_TX_RET_FILED_IND)	NO	NO
TITLE_IV_INCOME_EXCLUSION	Contains the student's Title IV Income Exclusions such as taxable financial aid and child support paid.	NUMBER	RCRAPP4	RCRAPP4_S_IV_INC	NO	NO
TYPE_OF_FM_CALCULATION	Indicates whether the calculation was an (O)riginal or a (R)ecalculation.	VARCHAR2(1)	RCRAPP4	RCRAPP4_TYPE_FM_CALC	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RCRAPP4	RCRAPP4_USER_ID	NO	NO
VERIFICATION_NUMBER	Government verification number.	VARCHAR2(15)	RCRAPP4	RCRAPP4_VERIF_NUM	NO	NO
VERSION	Optimistic lock token.	NUMBER	RCRAPP4	RCRAPP4_VERSION	NO	NO
VETERAN_MATCH_STATUS	Indicates the value of the Veteran's Administration federal database match flag.	VARCHAR2(1)	RCRAPP4	RCRAPP4_VA_MATCH_FLAG	NO	NO
VETERAN_MATCH_STATUS_DESC	Veteran match status description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP4_VA_MATCH_FLAG)	NO	NO
VISA_CLASSIFICATION	Indicates what a students VISA classification is, see CSS tape layout for valid values.	VARCHAR2(5)	RCRAPP4	RCRAPP4_VISA_CLASS	NO	NO
VISA_CLASSIFICATION_DESC	Visa classification description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP4_VISA_CLASS)	NO	NO
VPDI_CODE	Multi-entity processing code.	VARCHAR2(6)	RCRAPP4	RCRAPP4_VPDI_CODE	NO	NO
WORKSHEET_B_TOTAL	Student's Worksheet B untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_B	NO	NO
WORKSHEET_C_TOTAL	Student and spouse total amount from Worksheet C.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_C	NO	NO
WORK_STUDY_INTEREST_IND	Indicates that a student is interested in receiving work-study assistance.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_WORK_STUDY)	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: