FAN_ISIR_PAR_VW

(SQL View)
 Index Back

Federal Parent Application

This is a view of the ISIR_PARENT table used for Financial Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.MARITAL_STAT ,A.DFLT_MAR_STAT_IND ,A.LEGAL_RESIDENCE ,A.DT_LEGAL_RES ,A.NUMBER_IN_FAMILY ,A.DFLT_NUM_FAM_IND ,A.NUM_IN_COLLEGE ,A.DFLT_NUM_COLL_IND ,A.TAX_FORM_FILED ,A.NUMBER_EXEMPTIONS ,A.AGI ,A.DFLT_AGI_IND ,A.TAXES_PAID ,A.DFLT_TAXES_PD_IND ,A.FATHER_INCOME ,A.DFLT_DAD_INC_IND ,A.MOTHER_INCOME ,A.DFLT_MOM_INC_IND ,A.SOC_SEC_BENEFITS ,A.DFLT_SS_BEN_IND ,A.AFDC_BENEFITS ,A.DFLT_AFDC_BEN_IND ,A.CHILD_SUPPORT ,A.DFLT_CHLD_SPPT_IND ,A.UNTAXED_INCOME ,A.DFLT_UNTXD_INC_IND ,A.AGE_OLDER_PARENT ,A.CASH_SAVINGS ,A.RE_INVEST_VALUE ,A.RE_INVEST_DEBT ,A.BUSINESS_VALUE ,A.BUSINESS_DEBT ,A.FARM_VALUE ,A.FARM_DEBT ,A.CURRENCY_CD ,A.FATHER_GRADE_LVL ,A.MOTHER_GRADE_LVL ,A.TOTAL_FROM_WS3 ,A.DFLT_WS3_TOT_IND ,A.PROJECTED_YR_INC ,A.ERND_INC_CREDIT ,A.DFLT_EIC_IND ,A.TAX_RETURN_FILED ,A.ELIG_FOR_1040A_EZ ,A.TOTAL_FROM_WKA ,A.INV_NET_WORTH ,A.BUS_NET_WORTH ,A.FARM_NET_WORTH ,A.LEGAL_RES_PRI_94 ,A.DFLT_WSA_TOT_IND ,A.FATHER_SSN ,A.FATHER_LAST_NAME ,A.MOTHER_SSN ,A.MOTHER_LAST_NAME ,A.LEGAL_RES_PRIOR ,A.TOTAL_FROM_WKC ,A.DFLT_WKC_TOT_IND ,A.BLANK_AGI ,A.BLANK_TAXES_PAID ,A.BLANK_FATHER_INC ,A.BLANK_MOTHER_INC ,A.BLANK_TOT_FROM_WS3 ,A.BLANK_TOT_FROM_WKA ,A.BLANK_INV_NET_WRTH ,A.MAR_STATUS_DT ,A.FATHER_1ST_NM_INIT ,A.FATHER_DOB ,A.MOTHER_1ST_NM_INIT ,A.MOTHER_DOB ,A.IWD_PAR_EMAIL ,A.DFLT_FATHERSSN_IND ,A.DFLT_MOTHERSSN_IND ,A.BLANK_CASH_SAV ,A.SFA_SSI_INCOME ,A.SFA_FOOD_STAMPS ,A.SFA_SCHL_LUNCH_PRG ,A.SFA_TANF_BENEFITS ,A.SFA_WIC_BENEFITS ,A.SFA_DISLOCATE_WRK ,A.SFA_EDU_CREDITS ,A.SFA_CHILD_SUP_PAID ,A.SFA_NEED_EMPLOYMNT ,A.SFA_GRANT_AID ,A.SFA_COMBATPAY ,A.SFA_PENSION_PAY ,A.SFA_IRA_PAY ,A.SFA_CHILD_SUP_RECV ,A.SFA_INTERST_INCOME ,A.SFA_IRA_DIST ,A.SFA_UNTAX_PENSION ,A.SFA_MILITARY_ALLOW ,A.SFA_VET_NONEDU_BEN ,A.SFA_UNTAX_INCOME ,A.SFA_COOP_EARN ,A.SFA_BLANK_BUSNET ,A.SFA_BLANK_EDUCREDT ,A.SFA_BLANK_CHILDSUP ,A.SFA_BLANK_NEEDEMPL ,A.SFA_BLANK_GRANTAID ,A.SFA_BLANK_COMBAT ,A.SFA_BLANK_COOPEARN ,A.SFA_BLANK_PENSION ,A.SFA_BLANK_IRA_PAY ,A.SFA_BLANK_CHILDREC ,A.SFA_BLANK_INT_INC ,A.SFA_BLANK_IRA_DIST ,A.SFA_BLANK_UNTAXPEN ,A.SFA_BLANK_MILITARY ,A.SFA_BLANK_VET_NON ,A.SFA_BLANK_UNTAXINC ,A.SFA_PAR_ASSET_THRS ,A.SFA_DFLT_ASM_ASSET ,A.SFA_PAR_TAX_RET ,D.SFA_PAR_FIRSTNAME ,D.SFA_PAR_MIDDLENAME ,D.SFA_PAR_LASTNAME ,D.SFA_PAR_SUFFIX ,D.SFA_PAR_ITIN ,D.SFA_PAR_PHONE ,D.SFA_PAR_STREET ,D.SFA_PAR_CITY ,D.SFA_PAR_STATE ,D.SFA_PAR_ZIPCODE ,D.SFA_PAR_COUNTRY ,D.SFA_PAR_NUM_COLL ,D.SFA_PAR_ETIC ,D.SFA_PAR_HOUSING ,D.SFA_PAR_MEDICAID ,D.SFA_PAR_36B ,D.SFA_PAR_FED_NONE ,D.SFA_PAR_1040 ,D.SFA_PAR_NON_TAX ,D.SFA_PAR_JOINT_TAX ,D.SFA_PAR_TAX_RET_ST ,D.SFA_INC_WORK1 ,D.SFA_TAX_EXEMPT1 ,D.SFA_UNTAX_IRA1 ,D.SFA_IRA_ROLL1 ,D.SFA_UNTAX_PEN1 ,D.SFA_PEN_ROLL1 ,D.SFA_TAX_CREDIT1 ,D.SFA_DEDUCT_IRA1 ,D.SFA_FILED_SCHD1 ,D.SFA_SCHED_CAMT1 ,D.SFA_FED_TAX1 ,D.SFA_TAXES_PAID1 ,D.SFA_BL_INC_WORK1 ,D.SFA_BL_TAX_EXEMPT1 ,D.SFA_BL_UNTAX_IRA1 ,D.SFA_BL_IRA_ROLL1 ,D.SFA_BL_UNTAX_PEN1 ,D.SFA_BL_PEN_ROLL1 ,D.SFA_BL_AGI1 ,D.SFA_BL_DEDUCT_IRA1 ,D.SFA_BL_EDU_CREDIT1 ,D.SFA_BL_SCHED_CAMT1 ,D.SFA_BL_FED_TAX1 ,D.SFA_BL_TAX_PAID1 ,D.SFA_PAR_CONSENT ,D.SFA_PAR_SIGNATURE ,D.SFA_PAR_SIGNDATE ,D.SFA_OTH_FIRSTNAME ,D.SFA_OTH_MIDDLENAME ,D.SFA_OTH_LASTNAME ,D.SFA_OTH_SUFFIX ,D.SFA_OTH_ITIN ,D.SFA_OTH_PHONE ,D.SFA_OTH_EMAILADDR ,D.SFA_OTH_STREET ,D.SFA_OTH_CITY ,D.SFA_OTH_STATE ,D.SFA_OTH_ZIPCODE ,D.SFA_OTH_COUNTRY ,D.SFA_OTH_1040 ,D.SFA_OTH_NON_TAX ,D.SFA_OTH_TAX_RET_ST ,D.SFA_INC_WORK2 ,D.SFA_TAX_EXEMPT2 ,D.SFA_UNTAX_IRA2 ,D.SFA_IRA_ROLL2 ,D.SFA_UNTAX_PEN2 ,D.SFA_PEN_ROLL2 ,D.SFA_AGI ,D.SFA_TAXES_PAID2 ,D.SFA_DEDUCT_IRA2 ,D.SFA_EDU_CREDIT2 ,D.SFA_FILED_SCHD2 ,D.SFA_SCHED_CAMT2 ,D.SFA_FED_TAX2 ,D.SFA_BL_INC_WORK2 ,D.SFA_BL_TAX_EXEMPT2 ,D.SFA_BL_UNTAX_IRA2 ,D.SFA_BL_IRA_ROLL2 ,D.SFA_BL_UNTAX_PEN2 ,D.SFA_BL_PEN_ROLL2 ,D.SFA_BL_AGI2 ,D.SFA_BL_TAX_PAID2 ,D.SFA_BL_DEDUCT_IRA2 ,D.SFA_BL_EDU_CREDIT2 ,D.SFA_BL_SCHED_CAMT2 ,D.SFA_BL_FED_TAX2 ,D.SFA_OTH_CONSENT ,D.SFA_OTH_SIGNATURE ,D.SFA_OTH_SIGNDATE ,D.SFA_ASMD_PAR FROM PS_ISIR_PARENT A LEFT JOIN PS_SFA_ISIR_PAR D ON A.EMPLID = D.EMPLID AND A.TABLE_ID = '1' AND A.INSTITUTION = D.INSTITUTION AND A.AID_YEAR = D.AID_YEAR AND A.EFFDT = D.EFFDT AND A.EFFSEQ = D.EFFSEQ AND A.TABLE_ID = D.TABLE_ID WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ISIR_PARENT B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.TABLE_ID = A.TABLE_ID AND B.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_ISIR_PARENT C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.AID_YEAR = A.AID_YEAR AND C.TABLE_ID = A.TABLE_ID AND C.EFFDT = A.EFFDT)

  • 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: USA_STATE_VW

    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    43 PROJECTED_YR_INC Character(1) VARCHAR2(1) NOT NULL Projected Year Income
    N=No
    Y=Yes
    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
    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 FATHER_SSN Character(9) VARCHAR2(9) NOT NULL Father's SSN
    55 FATHER_LAST_NAME Character(16) VARCHAR2(16) NOT NULL Father's Last Name
    56 MOTHER_SSN Character(9) VARCHAR2(9) NOT NULL Mother's SSN
    57 MOTHER_LAST_NAME Character(16) VARCHAR2(16) NOT NULL Mother's Last Name
    58 LEGAL_RES_PRIOR Character(1) VARCHAR2(1) NOT NULL Legal Resident Before 01-01-95
    1=Yes
    2=No
    59 TOTAL_FROM_WKC Number(8,0) INTEGER NOT NULL Total Amount from WK C
    60 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
    61 BLANK_AGI Character(1) VARCHAR2(1) NOT NULL AGI value is blank
    N=Not Blank
    Y=Blank

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    65 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

    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

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

    Y/N Table Edit

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

    75 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

    76 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

    77 SFA_SSI_INCOME Character(1) VARCHAR2(1) NOT NULL Receives SSI Income
    1=Yes
    2=No
    78 SFA_FOOD_STAMPS Character(1) VARCHAR2(1) NOT NULL Receives Food Stamps
    1=Yes
    2=No
    79 SFA_SCHL_LUNCH_PRG Character(1) VARCHAR2(1) NOT NULL Participates in Sch Lunch Prog
    1=Yes
    2=No
    80 SFA_TANF_BENEFITS Character(1) VARCHAR2(1) NOT NULL TANF Recipient
    1=Yes
    2=No
    81 SFA_WIC_BENEFITS Character(1) VARCHAR2(1) NOT NULL WIC Benefits Recipient
    1=Yes
    2=No
    82 SFA_DISLOCATE_WRK Character(1) VARCHAR2(1) NOT NULL Dislocated Worker
    1=Yes
    2=No
    3=Don't Know
    83 SFA_EDU_CREDITS Number(10,0) DECIMAL(10) NOT NULL Educational Credits
    84 SFA_CHILD_SUP_PAID Number(10,0) DECIMAL(10) NOT NULL Child Support Paid
    85 SFA_NEED_EMPLOYMNT Number(7,0) INTEGER NOT NULL Need-Based Employment
    86 SFA_GRANT_AID Number(10,0) DECIMAL(10) NOT NULL Grant/Scholarship Aid
    87 SFA_COMBATPAY Number(10,0) DECIMAL(10) NOT NULL Combat Pay
    88 SFA_PENSION_PAY Number(7,0) INTEGER NOT NULL Pension Payments
    89 SFA_IRA_PAY Number(7,0) INTEGER NOT NULL IRA Payments
    90 SFA_CHILD_SUP_RECV Number(10,0) DECIMAL(10) NOT NULL Child Support Received
    91 SFA_INTERST_INCOME Number(7,0) INTEGER NOT NULL Interest Income
    92 SFA_IRA_DIST Number(7,0) INTEGER NOT NULL IRA Distributions
    93 SFA_UNTAX_PENSION Number(7,0) INTEGER NOT NULL Untaxed Pensions
    94 SFA_MILITARY_ALLOW Number(10,0) DECIMAL(10) NOT NULL Military/Clergy Allowances
    95 SFA_VET_NONEDU_BEN Number(10,0) DECIMAL(10) NOT NULL Veterans Non-Ed Benefits
    96 SFA_UNTAX_INCOME Number(10,0) DECIMAL(10) NOT NULL Other Untaxed Income
    97 SFA_COOP_EARN Number(7,0) INTEGER NOT NULL Co-op Earnings
    98 SFA_BLANK_BUSNET Character(1) VARCHAR2(1) NOT NULL Business Net Worth is Blank
    N=Not Blank
    Y=Blank
    99 SFA_BLANK_EDUCREDT Character(1) VARCHAR2(1) NOT NULL Educational Credit is Blank
    N=Not Blank
    Y=Blank
    100 SFA_BLANK_CHILDSUP Character(1) VARCHAR2(1) NOT NULL Child Support Paid is Blank
    N=Not Blank
    Y=Blank
    101 SFA_BLANK_NEEDEMPL Character(1) VARCHAR2(1) NOT NULL Need Employment is Blank
    N=Not Blank
    Y=Blank
    102 SFA_BLANK_GRANTAID Character(1) VARCHAR2(1) NOT NULL Grant Aid is Blank
    N=Not Blank
    Y=Blank
    103 SFA_BLANK_COMBAT Character(1) VARCHAR2(1) NOT NULL Combat Pay is Blank
    N=Not Blank
    Y=Blank
    104 SFA_BLANK_COOPEARN Character(1) VARCHAR2(1) NOT NULL Co-op Earnings is Blank
    N=Not Blank
    Y=Blank
    105 SFA_BLANK_PENSION Character(1) VARCHAR2(1) NOT NULL Pension Pay is Blank
    N=Not Blank
    Y=Blank
    106 SFA_BLANK_IRA_PAY Character(1) VARCHAR2(1) NOT NULL Self Employment Pay is Blank
    N=Not Blank
    Y=Blank
    107 SFA_BLANK_CHILDREC Character(1) VARCHAR2(1) NOT NULL Child Support Receive is Blank
    N=Not Blank
    Y=Blank
    108 SFA_BLANK_INT_INC Character(1) VARCHAR2(1) NOT NULL Tax Exempt Interest is Blank
    N=Not Blank
    Y=Blank
    109 SFA_BLANK_IRA_DIST Character(1) VARCHAR2(1) NOT NULL IRA Distributions is Blank
    N=Not Blank
    Y=Blank
    110 SFA_BLANK_UNTAXPEN Character(1) VARCHAR2(1) NOT NULL Untax Pension is Blank
    N=Not Blank
    Y=Blank
    111 SFA_BLANK_MILITARY Character(1) VARCHAR2(1) NOT NULL Military Allowance is Blank
    N=Not Blank
    Y=Blank
    112 SFA_BLANK_VET_NON Character(1) VARCHAR2(1) NOT NULL Veterans Non-Ed Ben is Blank
    N=Not Blank
    Y=Blank
    113 SFA_BLANK_UNTAXINC Character(1) VARCHAR2(1) NOT NULL Other Untax Income is Blank
    N=Not Blank
    Y=Blank
    114 SFA_PAR_ASSET_THRS Character(1) VARCHAR2(1) NOT NULL Parent Asset Threshold Exceed
    1=Yes
    2=No
    115 SFA_DFLT_ASM_ASSET Character(1) VARCHAR2(1) NOT NULL Asset Threshold Exceed Def
    A=Assumption
    B=Blank
    R=Reported
    S=Simulation
    V=Verified
    116 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
    117 SFA_PAR_FIRSTNAME Character(35) VARCHAR2(35) NOT NULL 2425: First Name
    118 SFA_PAR_MIDDLENAME Character(15) VARCHAR2(15) NOT NULL 2425:Middle Name�
    119 SFA_PAR_LASTNAME Character(35) VARCHAR2(35) NOT NULL 2425:Last Name
    120 SFA_PAR_SUFFIX Character(10) VARCHAR2(10) NOT NULL 2425 Parent Suffix
    121 SFA_PAR_ITIN Character(9) VARCHAR2(9) NOT NULL 2425: Parent ITIN
    122 SFA_PAR_PHONE Character(10) VARCHAR2(10) NOT NULL 2425:Parent Phone Number
    123 SFA_PAR_STREET Character(40) VARCHAR2(40) NOT NULL 2425: Street Address
    124 SFA_PAR_CITY Character(30) VARCHAR2(30) NOT NULL 2425:Parent City
    125 SFA_PAR_STATE Character(2) VARCHAR2(2) NOT NULL 2425:Parent State
    126 SFA_PAR_ZIPCODE Character(10) VARCHAR2(10) NOT NULL 2425:Parent Zip Code
    127 SFA_PAR_COUNTRY Character(2) VARCHAR2(2) NOT NULL 2425: Country
    128 SFA_PAR_NUM_COLL Character(2) VARCHAR2(2) NOT NULL 2425:Number in College
    129 SFA_PAR_ETIC Character(1) VARCHAR2(1) NOT NULL 2425:Received EITC
    130 SFA_PAR_HOUSING Character(1) VARCHAR2(1) NOT NULL 2425:Received Federal Housing Assistance
    131 SFA_PAR_MEDICAID Character(1) VARCHAR2(1) NOT NULL 2425:Received Medicaid
    132 SFA_PAR_36B Character(1) VARCHAR2(1) NOT NULL 2425:Received Refundable Credit for 36B Health Plan
    133 SFA_PAR_FED_NONE Character(1) VARCHAR2(1) NOT NULL 2425:Federal Benefits: None of the Above�
    134 SFA_PAR_1040 Character(1) VARCHAR2(1) NOT NULL 2425:Filed 1040 or 1040NR
    1=Yes
    2=No
    135 SFA_PAR_NON_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Non-U.S. Tax Return
    136 SFA_PAR_JOINT_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Joint Return with Current Spouse
    1=Yes
    2=No
    137 SFA_PAR_TAX_RET_ST Character(1) VARCHAR2(1) NOT NULL 2425:Tax Return Filing Status�
    1=Single
    2=Married-Filed Joint Return
    3=Married-Filed Separate Return
    4=Head of Household
    5=Qualifying Surviving Spouse
    138 SFA_INC_WORK1 Number(11,0) DECIMAL(11) NOT NULL 2425:Income Earned from Work
    139 SFA_TAX_EXEMPT1 Number(11,0) DECIMAL(11) NOT NULL 2425:Tax Exempt Interest Income
    140 SFA_UNTAX_IRA1 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of IRA Distributions
    141 SFA_IRA_ROLL1 Number(11,0) DECIMAL(11) NOT NULL 2425:IRA Rollover
    142 SFA_UNTAX_PEN1 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of Pensions
    143 SFA_PEN_ROLL1 Number(11,0) DECIMAL(11) NOT NULL 2425:Pension Rollover
    144 SFA_TAX_CREDIT1 Character(1) VARCHAR2(1) NOT NULL 2425:Earned Income Tax Credit Received During Tax Year?
    145 SFA_DEDUCT_IRA1 Number(12,0) DECIMAL(12) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other
    146 SFA_FILED_SCHD1 Character(1) VARCHAR2(1) NOT NULL 2425:Filed Schedule A, B, D, E, F or H?
    147 SFA_SCHED_CAMT1 Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C Amount�
    148 SFA_FED_TAX1 Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Foreign Income Exempt from Federal Taxation
    149 SFA_TAXES_PAID1 Number(9,0) DECIMAL(9) NOT NULL 2425:Income Tax Paid
    150 SFA_BL_INC_WORK1 Character(1) VARCHAR2(1) NOT NULL 2425: Income Earned from Work Blank
    151 SFA_BL_TAX_EXEMPT1 Character(1) VARCHAR2(1) NOT NULL 2425:Tax Exempt Interest Income Blank
    152 SFA_BL_UNTAX_IRA1 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of IRA Distributions
    153 SFA_BL_IRA_ROLL1 Character(1) VARCHAR2(1) NOT NULL 2425:IRA Rollover
    154 SFA_BL_UNTAX_PEN1 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of Pensions
    155 SFA_BL_PEN_ROLL1 Character(1) VARCHAR2(1) NOT NULL 2425:Pension Rollover blank
    156 SFA_BL_AGI1 Character(1) VARCHAR2(1) NOT NULL 2425:Adjusted Gross Income
    157 SFA_BL_DEDUCT_IRA1 Character(1) VARCHAR2(1) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other blank
    158 SFA_BL_EDU_CREDIT1 Character(1) VARCHAR2(1) NOT NULL 2425: Education Credits Blank
    159 SFA_BL_SCHED_CAMT1 Character(1) VARCHAR2(1) NOT NULL 2425:Schedule C Amount Blank
    160 SFA_BL_FED_TAX1 Character(1) VARCHAR2(1) NOT NULL 2425: Foreign Income Exempt from Federal Taxation blank
    161 SFA_BL_TAX_PAID1 Character(1) VARCHAR2(1) NOT NULL 2425:Income Tax Paid blank
    162 SFA_PAR_CONSENT Character(1) VARCHAR2(1) NOT NULL 2425: Consent to Retrieve and Disclose FTI
    163 SFA_PAR_SIGNATURE Character(1) VARCHAR2(1) NOT NULL 2425:Signature�
    164 SFA_PAR_SIGNDATE Date(10) DATE 2425:Signature Date
    165 SFA_OTH_FIRSTNAME Character(35) VARCHAR2(35) NOT NULL 2425: First Name
    166 SFA_OTH_MIDDLENAME Character(15) VARCHAR2(15) NOT NULL 2425:Middle Name�
    167 SFA_OTH_LASTNAME Character(35) VARCHAR2(35) NOT NULL 2425:Last Name
    168 SFA_OTH_SUFFIX Character(10) VARCHAR2(10) NOT NULL 2425 Spouse Suffix
    169 SFA_OTH_ITIN Character(9) VARCHAR2(9) NOT NULL 2425: Other Parent ITIN
    170 SFA_OTH_PHONE Character(10) VARCHAR2(10) NOT NULL 2425:Spouse Phone Number
    171 SFA_OTH_EMAILADDR Character(50) VARCHAR2(50) NOT NULL 2425:Email Address
    172 SFA_OTH_STREET Character(40) VARCHAR2(40) NOT NULL 2425: Other Parent Street Address
    173 SFA_OTH_CITY Character(30) VARCHAR2(30) NOT NULL 2425:Other Parent City
    174 SFA_OTH_STATE Character(2) VARCHAR2(2) NOT NULL 2425:Parent State
    175 SFA_OTH_ZIPCODE Character(10) VARCHAR2(10) NOT NULL 2425:Parent Zip Code
    176 SFA_OTH_COUNTRY Character(2) VARCHAR2(2) NOT NULL 2425: Country
    177 SFA_OTH_1040 Character(1) VARCHAR2(1) NOT NULL 2425:Filed 1040 or 1040NR
    178 SFA_OTH_NON_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Non-U.S. Tax Return
    179 SFA_OTH_TAX_RET_ST Character(1) VARCHAR2(1) NOT NULL 2425:Tax Return Filing Status�
    180 SFA_INC_WORK2 Number(11,0) DECIMAL(11) NOT NULL 2425:Income Earned from Work
    181 SFA_TAX_EXEMPT2 Number(11,0) DECIMAL(11) NOT NULL 2425:Tax Exempt Interest Income
    182 SFA_UNTAX_IRA2 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of IRA Distributions
    183 SFA_IRA_ROLL2 Number(11,0) DECIMAL(11) NOT NULL 2425:IRA Rollover
    184 SFA_UNTAX_PEN2 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of Pensions
    185 SFA_PEN_ROLL2 Number(11,0) DECIMAL(11) NOT NULL 2425:Pension Rollover
    186 SFA_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
    187 SFA_TAXES_PAID2 Number(9,0) DECIMAL(9) NOT NULL 2425: Income Tax Paid
    188 SFA_DEDUCT_IRA2 Number(12,0) DECIMAL(12) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other
    189 SFA_EDU_CREDIT2 Number(10,0) DECIMAL(10) NOT NULL 2425: Educational Credit
    190 SFA_FILED_SCHD2 Character(1) VARCHAR2(1) NOT NULL 2425:Filed Schedule A, B, D, E, F or H?
    191 SFA_SCHED_CAMT2 Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C Amount�
    192 SFA_FED_TAX2 Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Foreign Income Exempt from Federal Taxation
    193 SFA_BL_INC_WORK2 Character(1) VARCHAR2(1) NOT NULL 2425: Income Earned from Work Blank
    194 SFA_BL_TAX_EXEMPT2 Character(1) VARCHAR2(1) NOT NULL 2425:Tax Exempt Interest Income Blank
    195 SFA_BL_UNTAX_IRA2 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of IRA Distributions
    196 SFA_BL_IRA_ROLL2 Character(1) VARCHAR2(1) NOT NULL 2425:IRA Rollover
    197 SFA_BL_UNTAX_PEN2 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of Pensions
    198 SFA_BL_PEN_ROLL2 Character(1) VARCHAR2(1) NOT NULL 2425:Pension Rollover blank
    199 SFA_BL_AGI2 Character(1) VARCHAR2(1) NOT NULL 2425:Adjusted Gross Income
    200 SFA_BL_TAX_PAID2 Character(1) VARCHAR2(1) NOT NULL 2425:Income Tax Paid blank
    201 SFA_BL_DEDUCT_IRA2 Character(1) VARCHAR2(1) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other blank
    202 SFA_BL_EDU_CREDIT2 Character(1) VARCHAR2(1) NOT NULL 2425: Education Credits Blank
    203 SFA_BL_SCHED_CAMT2 Character(1) VARCHAR2(1) NOT NULL 2425:Schedule C Amount Blank
    204 SFA_BL_FED_TAX2 Character(1) VARCHAR2(1) NOT NULL 2425: Foreign Income Exempt from Federal Taxation blank
    205 SFA_OTH_CONSENT Character(1) VARCHAR2(1) NOT NULL 2425: Consent to Retrieve and Disclose FTI
    206 SFA_OTH_SIGNATURE Character(1) VARCHAR2(1) NOT NULL 2425:Signature�
    207 SFA_OTH_SIGNDATE Date(10) DATE 2425:Signature Date
    208 SFA_ASMD_PAR Character(3) VARCHAR2(3) NOT NULL 2425:Assumed Parent Family Size