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
|
|
RCRAPP4
|
RCRAPP4_ACTIVITY_DATE
|
ADDRESS_CHANGE
|
Address Change
|
Address Only Change Flag
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_ADDRESS_CHG_FLAG
|
ADDRESS_CHANGE_DESC
|
Address Change Description
|
Address Only Change Flag description.
|
VARCHAR2(40)
|
|
CALCULATION
|
DECODE(RCRAPP4_ADDRESS_CHG_FLAG)
|
ADOPTED_AFTER_13
|
Adopted After 13
|
|
VARCHAR2(1)
|
|
|
|
ADOPTED_AFTER_13_DESC
|
Adopted After 13 Description
|
|
VARCHAR2(4000)
|
|
|
|
AID_ELIGIBILITY_RESPONSE
|
Financial Aid Eligibility Response
|
Drug Offense Conviction indicated.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_DRUG_OFFENSE_CONVIC
|
AID_ELIGIBILITY_RESPONSE_DESC
|
Financial Aid Eligibility Response Description
|
Aid eligibility response description.
|
VARCHAR2(25)
|
|
|
|
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)
|
|
RCRAPP4
|
RCRAPP4_AIDY_CODE
|
APPLICATION_NUMBER
|
Application Number
|
Financial aid application unique sequence number.
|
NUMBER(3)
|
|
RCRAPP4
|
RCRAPP4_SEQ_NO
|
ASSET_THRESHOLD_EXCEED
|
Asset Threshold Exceed
|
|
NUMBER
|
|
|
|
BUSINESS_NET_WORTH
|
Business Net Worth
|
Student's business net worth.
|
NUMBER(6)
|
|
RCRAPP4
|
RCRAPP4_BUS_NET_WORTH
|
CITIZENSHIP_TYPE
|
Citizenship Type
|
Student citizenship type.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_SSA_CITIZEN_IND
|
CITIZENSHIP_TYPE_DESC
|
Citizenship Type Description
|
Student citizenship type description.
|
VARCHAR2(4000)
|
|
CALCULATION
|
DECODE(RCRAPP4_SSA_CITIZEN_IND)
|
COMBAT_PAY
|
Combat Pay
|
|
NUMBER
|
|
|
|
CORRECTION_SOURCE
|
Correction Source
|
Source of the correction.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_SOURCE_CORRECTION
|
CORRECTION_SOURCE_DESC
|
Correction Source Description
|
Correction source description.
|
VARCHAR2(10)
|
|
CALCULATION
|
DECODE(RCRAPP4_SOURCE_CORRECTION)
|
CPS_ISIR_PUSHED_IND
|
Cps Isir Pushed Indicator
|
CPS Pushed ISIR Flag
|
VARCHAR2(1)
|
|
CALCULATION
|
NVL(RCRAPP4_PUSH_ISIR_FLAG)
|
CURRENT_DATE
|
Current Date
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
|
NA
|
SYSDATE
|
DATA_TYPE_AVAILABLE
|
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 Available Description
|
Data type description.
|
VARCHAR2(10)
|
|
CALCULATION
|
DECODE(RCRAPP4_TYPE_DATA_AVAIL)
|
DEATH_DATE
|
Death Date
|
Date of death associated with the person on this application as reported to the government.
|
DATE
|
|
RCRAPP4
|
RCRAPP4_DEATH_DATE
|
DIVIDEND_INCOME
|
Dividend Income
|
Amount of the student's dividend and interest income received.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_S_DIV_INT_INC
|
DOD_MATCH
|
Dod Match
|
|
VARCHAR2(1)
|
|
|
|
DOD_MATCH_DESC
|
Dod Match Description
|
|
VARCHAR2(4000)
|
|
|
|
DOD_PARENT_DEATH_DATE
|
Dod Parent Death Date
|
|
DATE
|
|
|
|
DOMAIN_VALUE
|
Domain Value
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
|
NA
|
NA
|
DUPLICATE_TAX_ID_IND
|
Duplicate Tax ID Indicator
|
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
|
Effective Family Contribution Change Indicator
|
The EFC Change flag indicates if the EFC has increased or decreased.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_EFC_CHANGE_IND
|
EFC_CHANGE_FLAG_DESC
|
Effective Family Contribution Change Indicator Description
|
description of the EFC change flag.
|
VARCHAR2(10)
|
|
|
|
EFM_DEPENDENCY_STATUS
|
Efm Dependency Status
|
|
VARCHAR2(1)
|
|
|
|
EFM_DEPENDENCY_STATUS_DESC
|
Efm Dependency Status Description
|
|
VARCHAR2(4000)
|
|
|
|
EMAIL_ADDRESS
|
Email Address
|
Student's e-mail address as reported on PROFILE.
|
VARCHAR2(128)
|
|
RCRAPP4
|
RCRAPP4_EMAIL_ADDRESS
|
FATHER_BIRTH_DATE
|
Father Birth Date
|
Father's/Stepfather's date of birth.
|
DATE
|
|
RCRAPP4
|
RCRAPP4_FATH_BIRTH_DATE
|
FATHER_FIRST_INITIAL
|
Father First Initial
|
Father's/Stepfather's first name/initial.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_FATH_FIRST_NAME_INI
|
FATHER_LAST_NAME
|
Father Last Name
|
Father's Last Name.
|
VARCHAR2(60)
|
|
RCRAPP4
|
RCRAPP4_FATH_LAST_NAME
|
FATHER_TAX_ID
|
Father Tax ID
|
Father's tax id.
|
VARCHAR2(15)
|
|
RCRAPP4
|
RCRAPP4_FATH_SSN
|
FISAP_TOTAL_INCOME
|
Fisap Total Income
|
Indicates the person's total FISAP income.
|
NUMBER(7)
|
|
RCRAPP4
|
RCRAPP4_FISAP_INC
|
FM_CONTRIBUTION_OFFICIAL_AMT
|
Federal Method Contribution Official Amount
|
Official student contribution amount.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_C_NA_1_CTRB_FOR_STDT
|
FM_DEPENDENCY_STATUS
|
Federal Method Dependency Status
|
|
VARCHAR2(1)
|
|
|
|
FM_DEPENDENCY_STATUS_DESC
|
Federal Method Dependency Status Description
|
|
VARCHAR2(4000)
|
|
|
|
FM_EST_OTHER_ASSET
|
Federal Method Est Other Asset
|
Amount of the other asset (override) used in the student FM calculation.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_C_1_OTH_ASSET
|
FM_FISAP_TOTAL_INCOME
|
Federal Method Fisap Total Income
|
|
NUMBER
|
|
|
|
FM_FORMULA
|
Federal Method Formula
|
Formula used for the FM calculation.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_FORMULA_FOR_CALC
|
FM_FORMULA_DESC
|
Federal Method Formula Description
|
FM formula description.
|
VARCHAR2(60)
|
|
CALCULATION
|
DECODE(RCRAPP4_FORMULA_FOR_CALC)
|
FM_PARENT_CONTRIB_OFFICIAL_AMT
|
Federal Method Parent Contribution Official Amount
|
Official parent contribution amount.
|
NUMBER(7)
|
|
RCRAPP4
|
RCRAPP4_C_NA_1_P_CTRB_FOR_STDT
|
FM_PARENT_CONTRIB_OFFICIAL_EST
|
Federal Method Parent Contribution 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
|
Federal Method Parent Contribution Off Est Description
|
Parent contribution official/estimate description.
|
VARCHAR2(4000)
|
|
|
|
FM_PARENT_DATA_AVAILABLE_IND
|
Federal Method Parent Data Available Indicator
|
Indicates whether parent data was available for the FM calculation.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_FM_PAR_DATA_AVAIL
|
FM_PARENT_EST_INCOME_ADJUST
|
Federal Method Parent Est Income Adjustment
|
Amount of the income adjustment used in the parent FM calculation.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_C_PAR_1_INC_ADJ
|
FM_PARENT_EST_OTHER_ASSET
|
Federal Method Parent Est Other Asset
|
Amount of the other asset (override) used in the parent FM calculation.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_C_PAR_1_OTH_ASSET
|
FM_PARENT_EST_OTH_INCOME_ALLOW
|
Federal Method Parent Est Oth Income Allow
|
Amount of the other income allowance (override) used in the parent FM calculation.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_C_PAR_1_OTH_ALLOW
|
FM_PARENT_WORKSHEET_A_TOTAL
|
Federal Method Parent Worksheet A Total
|
Parents' Worksheet A untaxed income total.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_PAR_WORKSHEET_A
|
FM_TOTAL_FAMILY_CONTRIBUTION
|
Federal Method Total Family Contribution
|
Total family contribution for the federal methodology calculation.
|
NUMBER(6)
|
|
RCRAPP4
|
RCRAPP4_C_INST_1_TOT_FAM_CTRB
|
FM_WORKSHEET_A_TOTAL
|
Federal Method Worksheet A Total
|
Student's Worksheet A untaxed income total.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_WORKSHEET_A
|
HOMELESS
|
Homeless
|
|
VARCHAR2(1)
|
|
|
|
HOMELESS_DESC
|
Homeless Description
|
|
VARCHAR2(4000)
|
|
|
|
HOME_AMOUNT_PAID
|
Home Amount Paid
|
Amount student paid for home.
|
NUMBER(6)
|
|
RCRAPP4
|
RCRAPP4_HME_PURCH_AMT
|
HOME_YEAR_PURCHASED
|
Home Year Purchased
|
Year student purchased home.
|
NUMBER(4)
|
|
RCRAPP4
|
RCRAPP4_HME_YR_PURCH
|
IM_BUDGET_DURATION
|
Institution Method Budget Duration
|
Budget duration used for the IM calculation.
|
NUMBER(3, 1)
|
|
RCRAPP4
|
RCRAPP4_IM_BUDG_DUR_FOR_CALC
|
IM_CONTRIBUTION_AMOUNT
|
Institution Method Contribution Amount
|
Student IM contribution amount.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_C_NA_1_IM_CTRB_STDT
|
IM_CUSTODIAL_PARENT
|
Institution Method 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
|
Institution Method Custodial Parent Description
|
IM custodial parent description.
|
VARCHAR2(10)
|
|
CALCULATION
|
DECODE(RCRAPP4_CUSTODIAL_PARENT)
|
IM_DEPENDENCY_STATUS
|
Institution Method Dependency Status
|
|
VARCHAR2(1)
|
|
|
|
IM_DEPENDENCY_STATUS_DESC
|
Institution Method Dependency Status Description
|
|
VARCHAR2(4000)
|
|
|
|
IM_OTHER_ASSET_ALLOW_OVR
|
Institution Method Other Asset Allow Ovr
|
Amount of the other asset allowance (override) used in the student IM calculation.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_C_2_OTH_ASSET_ALLOW
|
IM_OTHER_ASSET_OVR
|
Institution Method Other Asset Ovr
|
Amount of the other asset (override) used in the student IM calculation.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_C_2_OTH_ASSET
|
IM_PARENT_CONTRIBUTION_AMOUNT
|
Institution Method Parent Contribution Amount
|
Parent IM contribution amount.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_C_NA_1_P_IM_CTRB_STDT
|
IM_PARENT_DATA_AVAILABLE_IND
|
Institution Method Parent Data Available Indicator
|
Indicates whether parent data was available for the IM calculation.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_IM_PAR_DATA_AVAIL
|
IM_PARENT_OTH_ASSET_ALLOW_OVR
|
Institution Method Parent Oth Asset Allow Ovr
|
Amount of the other asset allowance (override) used in the parent IM calculation.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_C_PAR_2_OTH_ASSET_ALLW
|
IM_TRUST_AMOUNT
|
Institution Method Trust Amount
|
Amount of the student trust account used in the student IM calculation.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_C_2_TRUST_VAL
|
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)
|
|
RCRAPP4
|
RCRAPP4_INFC_CODE
|
INVESTMENT_NET_WORTH
|
Investment Net Worth
|
Student's investment net worth.
|
NUMBER(6)
|
|
RCRAPP4
|
RCRAPP4_INV_NET_WORTH
|
LEGAL_RESIDENT_IND
|
Legal Resident Indicator
|
Indicates whether the student was a legal resident before January 1, YYYY.
|
VARCHAR2(1)
|
|
CALCULATION
|
DECODE(RCRAPP4_LEGAL_RES_IND)
|
LOAN_INTEREST_IND
|
Loan Interest Indicator
|
Indicates that a student is interested in receiving student loans
|
VARCHAR2(1)
|
|
|
|
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
|
MILITARY_REGISTRATION_STATUS
|
Military Registration Status
|
Military registration match flag.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_SS_MATCH
|
MILITARY_REGIST_STATUS_DESC
|
Military Regist Status Description
|
Military registration match description.
|
VARCHAR2(4000)
|
|
CALCULATION
|
DECODE(RCRAPP4_SS_MATCH)
|
MILITARY_REG_REQ_STATUS
|
Military Registration Requirements 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
|
Military Registration Requirements Status Description
|
Student military registration request status description.
|
VARCHAR2(4000)
|
|
CALCULATION
|
DECODE(RCRAPP4_SS_REG_FLAG)
|
MOTHER_BIRTH_DATE
|
Mother Birth Date
|
Mother's/Stepmother's date of birth.
|
DATE
|
|
RCRAPP4
|
RCRAPP4_MOTH_BIRTH_DATE
|
MOTHER_FIRST_INITIAL
|
Mother First Initial
|
Mother's/Stepmother's first name initial.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_MOTH_FIRST_NAME_INI
|
MOTHER_LAST_NAME
|
Mother Last Name
|
Mother's Last Name.
|
VARCHAR2(60)
|
|
RCRAPP4
|
RCRAPP4_MOTH_LAST_NAME
|
MOTHER_TAX_ID
|
Mother Tax ID
|
Mother's tax id.
|
VARCHAR2(15)
|
|
RCRAPP4
|
RCRAPP4_MOTH_SSN
|
NATIONAL_STUDENT_LOAN_SYSTEM
|
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
|
National student loan system description.
|
VARCHAR2(30)
|
|
CALCULATION
|
DECODE(RCRAPP4_NSLDS_MATCH)
|
PARENT_ASSET_THRESHOLD_EXCEED
|
Parent Asset Threshold Exceed
|
|
NUMBER
|
|
|
|
PARENT_BUSINESS_NET_WORTH
|
Parent Business Net Worth
|
Parent's business net worth.
|
NUMBER(6)
|
|
RCRAPP4
|
RCRAPP4_PAR_BUS_NET_WORTH
|
PARENT_COMBAT_PAY
|
Parent Combat Pay
|
|
NUMBER
|
|
|
|
PARENT_DEPEND_CARE_MED_ACCOUNT
|
Parent Depend Care Med Account
|
Amounts withheld from parent wages for dependent care and medical spending accounts.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_PAR_DEP_CARE_AND_MED
|
PARENT_EMAIL_ADDRESS
|
Parent Email Address
|
Parent's Email Address.
|
VARCHAR2(128)
|
|
RCRAPP4
|
RCRAPP4_P_EMAIL_ADDRESS
|
PARENT_EXPECTED_TUITION_PAID
|
Parent Expected Tuition Paid
|
Parents expected tuition paid.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_EXP_PAR_TUIT_PD
|
PARENT_EXP_NO_CHILD_TUITION_PD
|
Parent Expiration Number Child Tuition Pd
|
Parents expected number of children for whom they are paying tuition.
|
NUMBER(1)
|
|
RCRAPP4
|
RCRAPP4_EXP_PAR_NO_CHILD_TUIT
|
PARENT_INVESTMENT_NET_WORTH
|
Parent Investment Net Worth
|
Parent's investment net worth.
|
NUMBER(6)
|
|
RCRAPP4
|
RCRAPP4_PAR_INV_NET_WORTH
|
PARENT_LEGAL_RESIDENT_IND
|
Parent Legal Resident Indicator
|
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
|
Parent Number Of Businesses
|
|
NUMBER
|
|
|
|
PARENT_NUMBER_OF_FARMS
|
Parent Number Of Farms
|
|
NUMBER
|
|
|
|
PARENT_SHORT_TAX_FORM_IND
|
Parent Short Tax Form Indicator
|
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
|
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
|
Parent tax return filed description.
|
VARCHAR2(4000)
|
|
|
|
PARENT_TYPE1
|
Parent Type 1
|
|
VARCHAR2(1)
|
|
|
|
PARENT_TYPE1_DESC
|
Parent Type 1 Description
|
|
VARCHAR2(4000)
|
|
|
|
PARENT_TYPE2
|
Parent Type 2
|
|
VARCHAR2(1)
|
|
|
|
PARENT_TYPE2_DESC
|
Parent Type 2 Description
|
|
VARCHAR2(4000)
|
|
|
|
PARENT_WORKSHEET_B_TOTAL
|
Parent Worksheet B Total
|
Parents' Worksheet B untaxed income total.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_PAR_WORKSHEET_B
|
PARENT_WORKSHEET_C_TOTAL
|
Parent Worksheet C Total
|
Parent's total amount from Worksheet C.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_PAR_WORKSHEET_C
|
PELL_EFC_OFFICIAL_ESTIMATE
|
Pell Effective Family Contribution 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 Effective Family Contribution Official Est Description
|
Pell EFC official/estimate description.
|
VARCHAR2(4000)
|
|
|
|
PELL_EFFECTIVE_FAMILY_CONT
|
Pell Effective Family Contribution
|
Student Pell effective family contribution.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_C_NA_1_PELL_PGI
|
PERM_RESIDENCY_VER_STATUS
|
Perm Residency Ver Status
|
Permanent residency verification status.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_SEC_INS_MATCH_IND
|
PERM_RESIDENCY_VER_STATUS_DESC
|
Perm Residency Ver Status Description
|
Permanent residency verification status description.
|
VARCHAR2(4000)
|
|
CALCULATION
|
DECODE(RCRAPP4_SEC_INS_MATCH_IND)
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER(8)
|
|
RCRAPP4
|
RCRAPP4_PIDM
|
PROFILE_FEE_WAIVER_IND
|
Profile Fee Waiver Indicator
|
Indicates whether or not this applicant used a Fee Waiver.
|
VARCHAR2(1)
|
|
CALCULATION
|
DECODE(RCRAPP4_FEE_WAIVER_IND)
|
RETIREMENT_PLAN_PAYMENT
|
Retirement Plan Payment
|
|
NUMBER
|
|
|
|
SAR_C_CHANGE_IND
|
SAR C Change Indicator
|
SAR C Change Flag
|
VARCHAR2(1)
|
|
CALCULATION
|
DECODE(RCRAPP4_SAR_C_CHANGE_FLAG)
|
SAR_EFC
|
SAR Effective Family Contribution
|
Identifies what the SAR EFC was for a person when they were added in dataload.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_SAR_EFC
|
SECONDARY_SCHL_STATE_PROV_DESC
|
Secondary Schl State Province Description
|
|
VARCHAR2(30)
|
|
|
|
SECONDARY_SCHOOL
|
Secondary School
|
|
VARCHAR2(12)
|
|
|
|
SECONDARY_SCHOOL_CITY
|
Secondary School City
|
|
VARCHAR2(28)
|
|
|
|
SECONDARY_SCHOOL_DIPLOMA_IND
|
Secondary School Diploma Indicator
|
Indicates if the person has received a high school diploma/GED.
|
VARCHAR2(1)
|
|
CALCULATION
|
DECODE(RCRAPP4_HS_GED_RCVD)
|
SECONDARY_SCHOOL_INVALID
|
Secondary School Invalid
|
|
VARCHAR2(1)
|
|
|
|
SECONDARY_SCHOOL_INVALID_DESC
|
Secondary School Invalid Description
|
|
VARCHAR2(4000)
|
|
|
|
SECONDARY_SCHOOL_NAME
|
Secondary School Name
|
|
VARCHAR2(50)
|
|
|
|
SECONDARY_SCHOOL_STATE_PROV
|
Secondary School State Province
|
|
VARCHAR2(2)
|
|
|
|
SHORT_TAX_FORM_IND
|
Short Tax Form Indicator
|
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 Ver
|
Subsequent Record Selected For Verification.
|
VARCHAR2(1)
|
|
RCRAPP4
|
RCRAPP4_SUB_VERIF_SELECTED
|
SUPPORT_CHILDREN_IND
|
Support Children Indicator
|
Student has children who receive more than half of their support from him/her.
|
VARCHAR2(1)
|
|
CALCULATION
|
DECODE(RCRAPP4_HAVE_CHILDREN)
|
TAX_RETURN_FILED
|
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
|
Tax Return Filed Description
|
Student tax return filed description.
|
VARCHAR2(4000)
|
|
CALCULATION
|
DECODE(RCRAPP4_TX_RET_FILED_IND)
|
USER_ID
|
User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
|
RCRAPP4
|
RCRAPP4_USER_ID
|
VERIFICATION_NUMBER
|
Verification Number
|
Government verification number.
|
VARCHAR2(15)
|
|
RCRAPP4
|
RCRAPP4_VERIF_NUM
|
VETERAN_MATCH_STATUS
|
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
|
Veteran match status description.
|
VARCHAR2(4000)
|
|
CALCULATION
|
DECODE(RCRAPP4_VA_MATCH_FLAG)
|
VISA_CLASSIFICATION
|
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
|
Visa classification description.
|
VARCHAR2(4000)
|
|
CALCULATION
|
DECODE(RCRAPP4_VISA_CLASS)
|
WORKSHEET_B_TOTAL
|
Worksheet B Total
|
Student's Worksheet B untaxed income total.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_WORKSHEET_B
|
WORKSHEET_C_TOTAL
|
Worksheet C Total
|
Student and spouse total amount from Worksheet C.
|
NUMBER(5)
|
|
RCRAPP4
|
RCRAPP4_WORKSHEET_C
|
WORK_STUDY_INTEREST_IND
|
Work Study Interest Indicator
|
Indicates that a student is interested in receiving work-study assistance
|
VARCHAR2(1)
|
|
CALCULATION
|
DECODE(RCRAPP4_WORK_STUDY)
|
ZONE_VALUE
|
Zone Value
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
|
NA
|
NA
|