ISIR_PARENT

(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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 TABLE_ID Character(1) VARCHAR2(1) NOT NULL Child Table Key

    Default Value: 1

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

    Prompt Table: SFA_ISIRSTATEVW

    10 DT_LEGAL_RES Date(10) DATE Date of Legal Residence
    11 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    12 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

    13 NUM_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Nbr in College
    14 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

    15 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
    16 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
    ?=?
    17 AGI Signed Number(11,0) DECIMAL(10) NOT NULL Adjusted Gross Income
    18 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

    19 TAXES_PAID Signed Number(11,0) DECIMAL(10) NOT NULL U.S. Tax Paid
    20 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

    21 FATHER_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Father's Earnings
    22 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

    23 MOTHER_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Mother's Earnings
    24 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

    25 SOC_SEC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL SS Benefits
    26 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

    27 AFDC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL AFDC Benefits
    28 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

    29 CHILD_SUPPORT Signed Number(6,0) DECIMAL(5) NOT NULL Child Support
    30 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

    31 UNTAXED_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Untaxed Income
    32 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

    33 AGE_OLDER_PARENT Character(2) VARCHAR2(2) NOT NULL Age of Older Parent
    34 CASH_SAVINGS Signed Number(11,0) DECIMAL(10) NOT NULL Cash Savings
    35 RE_INVEST_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Value
    36 RE_INVEST_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Debt
    37 BUSINESS_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Business Value
    38 BUSINESS_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Business Debt
    39 FARM_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Investment Farm Value
    40 FARM_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Investment Farm Debt
    41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    42 FATHER_GRADE_LVL Character(1) VARCHAR2(1) NOT NULL Father's Highest Grade Level
    1=Middle School
    2=High School
    3=College
    4=Unknown
    43 MOTHER_GRADE_LVL Character(1) VARCHAR2(1) NOT NULL Mother's Highest Grade Level
    1=Middle School
    2=High School
    3=College
    4=Unknown
    44 TOTAL_FROM_WS3 Signed Number(9,0) DECIMAL(8) NOT NULL Total from Worksheet 3
    45 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

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

    Default Value: N

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

    Default Value: R

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

    Y/N Table Edit

    Default Value: N

    65 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

    66 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

    67 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

    68 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

    69 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

    70 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

    71 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. */
    72 FATHER_1ST_NM_INIT Character(1) VARCHAR2(1) NOT NULL Father's First Name Initial
    73 FATHER_DOB Date(10) DATE Father's Date of Birth
    74 MOTHER_1ST_NM_INIT Character(1) VARCHAR2(1) NOT NULL Mother's First Name Initial
    75 MOTHER_DOB Date(10) DATE Mother's Date of Birth
    76 IWD_PAR_EMAIL Character(50) VARCHAR2(50) NOT NULL Parent's Email Address
    77 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

    78 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

    79 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

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