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	RCRAPP4	RCRAPP4_HME_PURCH_AMT
HOME_YEAR_PURCHASED	Year student purchased home.	NUMBER	RCRAPP4	RCRAPP4_HME_YR_PURCH
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)	CALCULATION	DECODE(RCRAPP4_CUSTODIAL_PARENT)
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
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)
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)
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_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_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_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_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_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
PROFILE_FEE_WAIVER_IND	Indicates whether or not this applicant used a Fee Waiver.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP4_FEE_WAIVER_IND)
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)
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)
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)
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)
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
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)
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: