INAS_SIM_PAR

(SQL Table)
 Index Back

Fed Parent Application Data

This record houses all the data from the Free Application for Federal Student Aid (FAFSA). This table is effective dated to allow for changes to the application over time.

  • Parent record: ISIR_CONTROL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: STDNT_AID_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: ISIR_CONTROL

    4 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    5 DFLT_MAR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Marital Status Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    6 LEGAL_RESIDENCE Character(2) VARCHAR2(2) NOT NULL Legal Residence

    Prompt Table: SFA_ISIRSTATEVW

    7 DT_LEGAL_RES Date(10) DATE Date of Legal Residence
    8 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    9 DFLT_NUM_FAM_IND Character(1) VARCHAR2(1) NOT NULL Nbr Family Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified

    Default Value: R

    10 NUM_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Nbr in College
    11 DFLT_NUM_COLL_IND Character(1) VARCHAR2(1) NOT NULL Nbr in College Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified

    Default Value: R

    12 TAX_FORM_FILED Character(1) VARCHAR2(1) NOT NULL Tax Form Filed
    1=Completed 1040A/EZ
    2=Completed 1040
    3=Estimated 1040A/EZ
    4=Estimated 1040
    5=Will Not File
    13 NUMBER_EXEMPTIONS Character(2) VARCHAR2(2) NOT NULL Nbr of Exemptions
    00=00
    01=01
    02=02
    03=03
    04=04
    05=05
    06=06
    07=07
    08=08
    09=09
    1=1
    10=10
    11=11
    12=12
    2=2
    3=3
    4=4
    5=5
    6=6
    7=7
    8=8
    9=9
    ?=?
    14 AGI Signed Number(11,0) DECIMAL(10) NOT NULL Adjusted Gross Income
    15 DFLT_AGI_IND Character(1) VARCHAR2(1) NOT NULL AGI Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified

    Default Value: R

    16 TAXES_PAID Signed Number(11,0) DECIMAL(10) NOT NULL U.S. Tax Paid
    17 DFLT_TAXES_PD_IND Character(1) VARCHAR2(1) NOT NULL Taxes Paid Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified

    Default Value: R

    18 FATHER_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Father's Earnings
    19 DFLT_DAD_INC_IND Character(1) VARCHAR2(1) NOT NULL Father's Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified

    Default Value: R

    20 MOTHER_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Mother's Earnings
    21 DFLT_MOM_INC_IND Character(1) VARCHAR2(1) NOT NULL Mother's Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified

    Default Value: R

    22 SOC_SEC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL SS Benefits
    23 DFLT_SS_BEN_IND Character(1) VARCHAR2(1) NOT NULL Soc Sec Benefits Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified

    Default Value: R

    24 AFDC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL AFDC Benefits
    25 DFLT_AFDC_BEN_IND Character(1) VARCHAR2(1) NOT NULL AFDC Benefit Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified

    Default Value: R

    26 CHILD_SUPPORT Signed Number(6,0) DECIMAL(5) NOT NULL Child Support
    27 DFLT_CHLD_SPPT_IND Character(1) VARCHAR2(1) NOT NULL Child Support Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified

    Default Value: R

    28 UNTAXED_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Untaxed Income
    29 DFLT_UNTXD_INC_IND Character(1) VARCHAR2(1) NOT NULL Untaxed Income Default Set
    A=Assumption
    B=Blank
    R=Reported
    V=Verified

    Default Value: R

    30 AGE_OLDER_PARENT Character(2) VARCHAR2(2) NOT NULL Age of Older Parent
    31 CASH_SAVINGS Signed Number(11,0) DECIMAL(10) NOT NULL Cash Savings
    32 RE_INVEST_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Value
    33 RE_INVEST_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Debt
    34 BUSINESS_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Business Value
    35 BUSINESS_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Business Debt
    36 FARM_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Investment Farm Value
    37 FARM_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Investment Farm Debt
    38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    39 FATHER_GRADE_LVL Character(1) VARCHAR2(1) NOT NULL Father's Highest Grade Level
    1=Middle School
    2=High School
    3=College
    4=Unknown
    40 MOTHER_GRADE_LVL Character(1) VARCHAR2(1) NOT NULL Mother's Highest Grade Level
    1=Middle School
    2=High School
    3=College
    4=Unknown
    41 TOTAL_FROM_WS3 Signed Number(9,0) DECIMAL(8) NOT NULL Total from Worksheet 3
    42 DFLT_WS3_TOT_IND Character(1) VARCHAR2(1) NOT NULL Total from WrkSht 3 Defaulted
    A=Assumption
    B=Blank
    R=Reported
    V=Verified

    Default Value: R

    43 PROJECTED_YR_INC Character(1) VARCHAR2(1) NOT NULL Projected Year Income
    N=No
    Y=Yes

    Default Value: N

    44 ERND_INC_CREDIT Signed Number(11,0) DECIMAL(10) NOT NULL Earned Income Credit
    45 DFLT_EIC_IND Character(1) VARCHAR2(1) NOT NULL Earned Inc Source Ind
    A=Assumption
    B=Blank
    R=Reported
    V=Verified

    Default Value: R

    46 TAX_RETURN_FILED Character(1) VARCHAR2(1) NOT NULL Tax Return Filed?
    1=Already Filed/Completed
    2=Will File
    3=Will Not File
    47 ELIG_FOR_1040A_EZ Character(1) VARCHAR2(1) NOT NULL Eligible For 1040A or 1040EZ
    1=Yes
    2=No/Don't Know
    48 TOTAL_FROM_WKA Number(5,0) INTEGER NOT NULL Total Amount from WK A
    49 INV_NET_WORTH Number(10,0) DECIMAL(10) NOT NULL Investment Net Worth
    50 BUS_NET_WORTH Number(10,0) DECIMAL(10) NOT NULL Business Net Worth
    51 FARM_NET_WORTH Number(6,0) INTEGER NOT NULL Farm Net Worth
    52 LEGAL_RES_PRI_94 Character(1) VARCHAR2(1) NOT NULL Legal Resident Before 01-01-94
    1=Yes
    2=No
    53 DFLT_WSA_TOT_IND Character(1) VARCHAR2(1) NOT NULL Total from Worksheet A
    A=Assumption
    B=Blank
    R=Reported
    V=Verified
    54 TAX_FORM_FILED00 Character(1) VARCHAR2(1) NOT NULL Tax Form Filed 2000
    1=IRS 1040
    2=IRS 1040A/EZ/Telefile
    3=Foreign Tax Return
    4=U.S. Territory Tax Return
    55 LEGAL_RES_PRIOR Character(1) VARCHAR2(1) NOT NULL Legal Resident Before 01-01-95
    1=Yes
    2=No
    56 FATHER_SSN Character(9) VARCHAR2(9) NOT NULL Father's SSN
    57 FATHER_LAST_NAME Character(16) VARCHAR2(16) NOT NULL Father's Last Name
    58 MOTHER_SSN Character(9) VARCHAR2(9) NOT NULL Mother's SSN
    59 MOTHER_LAST_NAME Character(16) VARCHAR2(16) NOT NULL Mother's Last Name
    60 TOTAL_FROM_WKC Number(8,0) INTEGER NOT NULL Total Amount from WK C
    61 DFLT_WKC_TOT_IND Character(1) VARCHAR2(1) NOT NULL Total from WrkSht C Defaulted
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    62 BLANK_AGI Character(1) VARCHAR2(1) NOT NULL AGI value is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    63 BLANK_TAXES_PAID Character(1) VARCHAR2(1) NOT NULL Taxes Paid value is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    64 BLANK_FATHER_INC Character(1) VARCHAR2(1) NOT NULL Father's Income value is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    65 BLANK_MOTHER_INC Character(1) VARCHAR2(1) NOT NULL Mother's Income value is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    66 BLANK_TOT_FROM_WKA Character(1) VARCHAR2(1) NOT NULL Total From Wksheet A is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    67 BLANK_TOT_FROM_WS3 Character(1) VARCHAR2(1) NOT NULL Total From Wksheet B is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    68 BLANK_INV_NET_WRTH Character(1) VARCHAR2(1) NOT NULL Investment Net Worth is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    69 MAR_STATUS_DT Date(10) DATE This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
    70 FATHER_1ST_NM_INIT Character(1) VARCHAR2(1) NOT NULL Father's First Name Initial
    71 FATHER_DOB Date(10) DATE Father's Date of Birth
    72 MOTHER_1ST_NM_INIT Character(1) VARCHAR2(1) NOT NULL Mother's First Name Initial
    73 MOTHER_DOB Date(10) DATE Mother's Date of Birth
    74 IWD_PAR_EMAIL Character(50) VARCHAR2(50) NOT NULL Parent's Email Address
    75 DFLT_FATHERSSN_IND Character(1) VARCHAR2(1) NOT NULL Assumed Father SSN
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified

    Default Value: R

    76 DFLT_MOTHERSSN_IND Character(1) VARCHAR2(1) NOT NULL Assumed Mother SSN
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified

    Default Value: R

    77 BLANK_CASH_SAV Character(1) VARCHAR2(1) NOT NULL Cash savings value is blank
    N=Non Blank
    Y=Blank

    Y/N Table Edit

    Default Value: N

    78 SFA_SSI_INCOME Character(1) VARCHAR2(1) NOT NULL Receives SSI Income
    1=Yes
    2=No
    79 SFA_FOOD_STAMPS Character(1) VARCHAR2(1) NOT NULL Receives Food Stamps
    1=Yes
    2=No
    80 SFA_SCHL_LUNCH_PRG Character(1) VARCHAR2(1) NOT NULL Participates in Sch Lunch Prog
    1=Yes
    2=No
    81 SFA_TANF_BENEFITS Character(1) VARCHAR2(1) NOT NULL TANF Recipient
    1=Yes
    2=No
    82 SFA_WIC_BENEFITS Character(1) VARCHAR2(1) NOT NULL WIC Benefits Recipient
    1=Yes
    2=No
    83 SFA_DISLOCATE_WRK Character(1) VARCHAR2(1) NOT NULL Dislocated Worker
    1=Yes
    2=No
    3=Don't Know
    84 SFA_EDU_CREDITS Number(10,0) DECIMAL(10) NOT NULL Educational Credits
    85 SFA_CHILD_SUP_PAID Number(10,0) DECIMAL(10) NOT NULL Child Support Paid
    86 SFA_NEED_EMPLOYMNT Number(7,0) INTEGER NOT NULL Need-Based Employment
    87 SFA_GRANT_AID Number(10,0) DECIMAL(10) NOT NULL Grant/Scholarship Aid
    88 SFA_COMBATPAY Number(10,0) DECIMAL(10) NOT NULL Combat Pay
    89 SFA_PENSION_PAY Number(7,0) INTEGER NOT NULL Pension Payments
    90 SFA_IRA_PAY Number(7,0) INTEGER NOT NULL IRA Payments
    91 SFA_CHILD_SUP_RECV Number(10,0) DECIMAL(10) NOT NULL Child Support Received
    92 SFA_INTERST_INCOME Number(7,0) INTEGER NOT NULL Interest Income
    93 SFA_IRA_DIST Number(7,0) INTEGER NOT NULL IRA Distributions
    94 SFA_UNTAX_PENSION Number(7,0) INTEGER NOT NULL Untaxed Pensions
    95 SFA_MILITARY_ALLOW Number(10,0) DECIMAL(10) NOT NULL Military/Clergy Allowances
    96 SFA_VET_NONEDU_BEN Number(10,0) DECIMAL(10) NOT NULL Veterans Non-Ed Benefits
    97 SFA_UNTAX_INCOME Number(10,0) DECIMAL(10) NOT NULL Other Untaxed Income
    98 SFA_COOP_EARN Number(7,0) INTEGER NOT NULL Co-op Earnings
    99 SFA_BLANK_BUSNET Character(1) VARCHAR2(1) NOT NULL Business Net Worth is Blank
    N=Not Blank
    Y=Blank
    100 SFA_BLANK_EDUCREDT Character(1) VARCHAR2(1) NOT NULL Educational Credit is Blank
    N=Not Blank
    Y=Blank
    101 SFA_BLANK_CHILDSUP Character(1) VARCHAR2(1) NOT NULL Child Support Paid is Blank
    N=Not Blank
    Y=Blank
    102 SFA_BLANK_NEEDEMPL Character(1) VARCHAR2(1) NOT NULL Need Employment is Blank
    N=Not Blank
    Y=Blank
    103 SFA_BLANK_GRANTAID Character(1) VARCHAR2(1) NOT NULL Grant Aid is Blank
    N=Not Blank
    Y=Blank
    104 SFA_BLANK_COMBAT Character(1) VARCHAR2(1) NOT NULL Combat Pay is Blank
    N=Not Blank
    Y=Blank
    105 SFA_BLANK_COOPEARN Character(1) VARCHAR2(1) NOT NULL Co-op Earnings is Blank
    N=Not Blank
    Y=Blank
    106 SFA_BLANK_PENSION Character(1) VARCHAR2(1) NOT NULL Pension Pay is Blank
    N=Not Blank
    Y=Blank
    107 SFA_BLANK_IRA_PAY Character(1) VARCHAR2(1) NOT NULL Self Employment Pay is Blank
    N=Not Blank
    Y=Blank
    108 SFA_BLANK_CHILDREC Character(1) VARCHAR2(1) NOT NULL Child Support Receive is Blank
    N=Not Blank
    Y=Blank
    109 SFA_BLANK_INT_INC Character(1) VARCHAR2(1) NOT NULL Tax Exempt Interest is Blank
    N=Not Blank
    Y=Blank
    110 SFA_BLANK_IRA_DIST Character(1) VARCHAR2(1) NOT NULL IRA Distributions is Blank
    N=Not Blank
    Y=Blank
    111 SFA_BLANK_UNTAXPEN Character(1) VARCHAR2(1) NOT NULL Untax Pension is Blank
    N=Not Blank
    Y=Blank
    112 SFA_BLANK_MILITARY Character(1) VARCHAR2(1) NOT NULL Military Allowance is Blank
    N=Not Blank
    Y=Blank
    113 SFA_BLANK_VET_NON Character(1) VARCHAR2(1) NOT NULL Veterans Non-Ed Ben is Blank
    N=Not Blank
    Y=Blank
    114 SFA_BLANK_UNTAXINC Character(1) VARCHAR2(1) NOT NULL Other Untax Income is Blank
    N=Not Blank
    Y=Blank
    115 SFA_PAR_ASSET_THRS Character(1) VARCHAR2(1) NOT NULL Parent Asset Threshold Exceed
    1=Yes
    2=No
    116 SFA_DFLT_ASM_ASSET Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceed Def
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    117 SFA_PAR_TAX_RET Character(1) VARCHAR2(1) NOT NULL Parent Tax Return Filing
    1=Single
    2=Married-Joint
    3=Married-Separate
    4=Head of House
    5=Widow(er)
    6=Don't Know
    118 SFA_1040_SCHEDULE Character(1) VARCHAR2(1) NOT NULL 1040 Schedule 1 Filed
    1=No
    2=Yes
    3=Dont Know
    119 TAX_FORM_FILED21 Character(1) VARCHAR2(1) NOT NULL Tax Form Filed 2005
    1=IRS 1040
    3=Foreign Tax Return
    4=U.S. Territory Tax Return