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

Ver: