SFA_PF_PARNT_ST

(SQL Table)
 Index Back

Inst Parent App Staging Data

This record stages institutional application data.

  • Parent record: SFA_PF_CNTRL_ST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_PF_QUEUE_INST Number(9,0) DECIMAL(9) NOT NULL Load Instance
    2 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: STUDENT_AID

    5 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Electronic Renewal Aplication
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan
    6 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    7 LEGAL_RESIDENCE Character(2) VARCHAR2(2) NOT NULL Legal Residence

    Prompt Table: HCR_ST_NM_VW_I

    8 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    9 NUM_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Nbr in College
    10 PARENTS_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Parents in College
    0=Neither
    1=One Parent
    2=Both Parents
    ?=?
    11 DIVORCED_SEPARATED Character(1) VARCHAR2(1) NOT NULL Parents Separated/Divorced
    1=Yes
    2=No
    12 SFA_PF_PRNT_LN_EXP Character(10) VARCHAR2(10) NOT NULL Annual Educ Loan Expense
    13 SFA_PF_DENTAL_EXP Character(10) VARCHAR2(10) NOT NULL Medical/Dental
    14 SFA_PF_TUIT_PD_AMT Character(10) VARCHAR2(10) NOT NULL Other Tuition Paid
    15 TUIT_PD_NBR Character(1) VARCHAR2(1) NOT NULL Number of Tuition Paid
    16 SFA_PF_EXP_MED_DNT Character(10) VARCHAR2(10) NOT NULL Medical/Dental Expenses
    17 SFA_PF_EXP_TUIT_PD Character(10) VARCHAR2(10) NOT NULL Private Tuition Paid
    18 EXPCT_TUIT_PD_NUM Character(1) VARCHAR2(1) NOT NULL Nbr Tuitions
    19 SFA_PF_EXP_FAT_INC Character(10) VARCHAR2(10) NOT NULL Father's Earnings
    20 SFA_PF_EXP_MOT_INC Character(10) VARCHAR2(10) NOT NULL Mother's Earnings
    21 SFA_PF_EXP_OTH_INC Character(11) VARCHAR2(11) NOT NULL Other Taxable Income
    22 SFA_PF_EXP_OTH_UTX Character(10) VARCHAR2(10) NOT NULL Untaxed Income and Benefits
    23 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
    24 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
    ?=?

    Default Value: 00

    25 CHAR_AGI Character(11) VARCHAR2(11) NOT NULL Adjusted Gross Income
    26 SFA_PF_SAL_TIPS Character(10) VARCHAR2(10) NOT NULL Wages, Sal, & Tips
    27 SFA_PF_INT_INCOME Character(10) VARCHAR2(10) NOT NULL Interest Income
    28 SFA_PF_DIVIDND_INC Character(10) VARCHAR2(10) NOT NULL Dividend Income
    29 SFA_PF_INC_BUS_FRM Character(11) VARCHAR2(11) NOT NULL Business/Farm Income
    30 SFA_PF_OTH_TAX_INC Character(11) VARCHAR2(11) NOT NULL Other Taxable Income
    31 SFA_PF_ADJ_TO_INC Character(10) VARCHAR2(10) NOT NULL Adjustments to Income
    32 IWD_PAR_TAX_PAID Character(10) VARCHAR2(10) NOT NULL Income Tax Paid
    33 SFA_PF_ITEMIZD_DED Character(10) VARCHAR2(10) NOT NULL Itemized Deductions
    34 SFA_PAR_SUP_PAID Character(10) VARCHAR2(10) NOT NULL Parents Child Support Paid
    35 SFA_PAR_SUP_RECV Character(10) VARCHAR2(10) NOT NULL Parents Child Support Received
    36 SFA_PF_SOC_SEC_BEN Character(10) VARCHAR2(10) NOT NULL Social Scrty Benefit Family
    37 SFA_PF_AFDC_BENEF Character(10) VARCHAR2(10) NOT NULL AFDC Benefits
    38 SFA_PF_DED_IRA_PMT Character(10) VARCHAR2(10) NOT NULL IRA/Keogh Payments
    39 SFA_PF_TX_DFR_PLAN Character(10) VARCHAR2(10) NOT NULL Tax Deferred Plans
    40 SFA_PF_DEP_MED_EXP Character(5) VARCHAR2(5) NOT NULL Medical, etc. Spend Accts.
    41 IWD_PAR_EIC Character(10) VARCHAR2(10) NOT NULL Earned Income Credit
    42 SFA_PF_LIV_ALLOWNC Character(10) VARCHAR2(10) NOT NULL Living Allowance
    43 SFA_PF_TX_EXM_INC Character(10) VARCHAR2(10) NOT NULL Tax-Exempt Interest
    44 AGE_OLDER_PARENT Character(2) VARCHAR2(2) NOT NULL Age of Older Parent
    45 IWD_PAR_CASH Character(7) VARCHAR2(7) NOT NULL Cash and Savings
    46 SFA_PF_MORTGAG_PMT Character(10) VARCHAR2(10) NOT NULL Monthly Mortgage/Rent Payment
    47 SFA_PF_PAR_INVEST Character(10) VARCHAR2(10) NOT NULL Investment Net Worth
    48 SFA_PF_INVEST_DEBT Character(10) VARCHAR2(10) NOT NULL Investment Debt
    49 SFA_PF_HOME_VALUE Character(10) VARCHAR2(10) NOT NULL Home Value
    50 SFA_PF_HOME_DEBT Character(10) VARCHAR2(10) NOT NULL Home Debt
    51 HOME_PURCH_YEAR Character(4) VARCHAR2(4) NOT NULL Home Purchase Year
    52 SFA_PF_HOME_PURCH Character(10) VARCHAR2(10) NOT NULL Home Purchase Price
    53 LIVE_ON_FARM Character(1) VARCHAR2(1) NOT NULL Reside on Farm
    1=Yes
    2=No
    N=No
    Y=Yes
    54 SFA_PF_RE_INV_VAL Character(10) VARCHAR2(10) NOT NULL Real Estate/Investment Value
    55 SFA_PF_RE_INV_DEBT Character(10) VARCHAR2(10) NOT NULL Real Estate/Investment Debt
    56 OTH_RE_PURCH_YR Character(4) VARCHAR2(4) NOT NULL Other Real Estate Purchase Yr
    57 SFA_PF_RE_PRCH_AMT Character(10) VARCHAR2(10) NOT NULL Real Estate Purchase Amount
    58 SFA_PF_BUS_VALUE Character(10) VARCHAR2(10) NOT NULL Business Value
    59 SFA_PF_BUS_DEBT Character(10) VARCHAR2(10) NOT NULL Business Debt
    60 SFA_PF_FARM_VALUE Character(10) VARCHAR2(10) NOT NULL Investment Farm Value
    61 SFA_PF_FARM_DEBT Character(10) VARCHAR2(10) NOT NULL Investment Farm Debt
    62 SFA_PF_PRIOR_AGI Character(11) VARCHAR2(11) NOT NULL Year AGI
    63 SFA_PF_PRIOR_TX_PD Character(10) VARCHAR2(10) NOT NULL Year Taxes Paid
    64 SFA_PF_PRIOR_DEDUC Character(10) VARCHAR2(10) NOT NULL Year Itemized Deductions
    65 SFA_PF_PRI_UTX_INC Character(10) VARCHAR2(10) NOT NULL Year Untaxed Income
    66 AGE_FATHER Character(2) VARCHAR2(2) NOT NULL Father's Age
    67 AGE_MOTHER Character(2) VARCHAR2(2) NOT NULL Mother's Age
    68 DIV_SEP_IND Character(1) VARCHAR2(1) NOT NULL Divorced/Separated/Remarried
    69 SFA_PF_NO_CUST_CON Character(10) VARCHAR2(10) NOT NULL Non-Custodial Parent's Contrib
    70 SFA_PF_SIB_ASSETS Character(10) VARCHAR2(10) NOT NULL Assets Held by Siblings
    71 SFA_PF_HOPE_LL_CRD Character(10) VARCHAR2(10) NOT NULL Hope Lifetime Learning Credit
    72 YEAR_DIVORCE Character(4) VARCHAR2(4) NOT NULL Year of Divorce
    73 YEAR_SEPARATION Character(4) VARCHAR2(4) NOT NULL Year of Separation
    74 CHLD_NUM_AESA_CLC Character(1) VARCHAR2(1) NOT NULL Number Children Under 18
    75 CHLD_AGES_CESA_CLC Character(3) VARCHAR2(3) NOT NULL Sum of Childrens Ages < 18
    76 SFA_PF_FOR_INC_EXC Character(10) VARCHAR2(10) NOT NULL Foreign Income Exclusions
    77 SFA_PF_OTHUTAX_INC Character(10) VARCHAR2(10) NOT NULL Parents Other Untaxed Income
    78 SFA_PF_SS_BEN_FAM Character(5) VARCHAR2(5) NOT NULL Social Security Benefit Family
    79 SFA_PF_TUI_FEE_DED Character(10) VARCHAR2(10) NOT NULL Tuition and Fee Deduction
    80 SFA_CUST_PAR Character(1) VARCHAR2(1) NOT NULL Custodial Parent
    1=Father
    2=Mother
    F=Father
    M=Mother
    81 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    82 SFA_PF_DOB_PAR1 Character(10) VARCHAR2(10) NOT NULL Parent 1 Date of Birth
    83 SFA_PF_DOB_PAR2 Character(10) VARCHAR2(10) NOT NULL Parent 2 Date of Birth
    84 SFA_PF_DT_REMARRAG Character(10) VARCHAR2(10) NOT NULL Date of Remarriage
    85 TAX_FORM_FILED_07 Character(2) VARCHAR2(2) NOT NULL Tax Form Filed
    01=Estimated 1040
    02=Estimated 1040A
    03=Estimated 1040EZ
    04=Estimated Canadian
    05=Estimated Puerto Rican
    06=Estimated Other Non-US Return
    07=Completed 1040
    08=Completed 1040A
    09=Completed 1040EZ
    10=Completed Canadian
    11=Completed Puerto Rican
    12=Completed Other Non-US Return
    13=Will Not File
    86 SFA_TAX_FILED_STAT Character(1) VARCHAR2(1) NOT NULL Tax Filed Status
    1=Completed
    2=Will File but Not Completed
    3=Will Not File Not Required to
    87 SFA_MEANS_TSTD_BEN Character(1) VARCHAR2(1) NOT NULL Means Tested Benefits
    1=Yes
    2=No
    N=No
    Y=Yes
    88 SFA_EMPL_GT_100 Character(1) VARCHAR2(1) NOT NULL FTE Employees > 100
    1=Yes
    2=No
    N=No
    Y=Yes
    89 SFA_SELF_EMPL Character(1) VARCHAR2(1) NOT NULL Self Employed
    1=Yes
    2=No
    N=No
    Y=Yes
    90 SFA_RECEIVE_TANF Character(1) VARCHAR2(1) NOT NULL Receive TANF
    1=Yes
    2=No
    N=No
    Y=Yes
    91 SFA_RECEIVE_SSI Character(1) VARCHAR2(1) NOT NULL Receive SSI
    1=Yes
    2=No
    N=No
    Y=Yes
    92 SFA_PF_FAT_RT_ASST Character(10) VARCHAR2(10) NOT NULL Father Retirement Assets
    93 SFA_PF_MAT_RT_ASST Character(10) VARCHAR2(10) NOT NULL Mother Retirement Assets
    94 SFA_HOUSING_STAT Character(1) VARCHAR2(1) NOT NULL Housing Status
    1=Own Home
    2=Rent
    3=Living With Others
    4=Provided by Employer
    95 SFA_NTRL_P_STAT08 Character(1) VARCHAR2(1) NOT NULL Natural Parent Status
    1=Married
    2=Separated
    3=Divorced
    4=Never Married Living Separate
    5=Never Married Living Together
    6=Widowed
    96 SFA_PAR1_OCCUP Character(50) VARCHAR2(50) NOT NULL Occupation Parent 1
    97 SFA_PAR1_EMPLOYER Character(50) VARCHAR2(50) NOT NULL Employer Parent 1
    98 SFA_PAR2_OCCUP Character(50) VARCHAR2(50) NOT NULL Occupation Parent 2
    99 SFA_PAR2_EMPLOYER Character(50) VARCHAR2(50) NOT NULL Employer Parent 2
    100 SFA_PF_NUM_BUSINES Character(1) VARCHAR2(1) NOT NULL Number of Businesses
    101 SFA_PF_NUM_OF_FARM Character(1) VARCHAR2(1) NOT NULL Number of Farms
    102 SFA_DISLOCATED_WRK Character(1) VARCHAR2(1) NOT NULL Dislocated Worker?

    Y/N Table Edit

    103 SFA_PAR_COMBAT_PAY Character(10) VARCHAR2(10) NOT NULL Parents Combat Pay
    104 SFA_PF_CTRY_RES_CD Character(2) VARCHAR2(2) NOT NULL Country of Residence Code
    105 SFA_PAR_IRA_DIST Character(7) VARCHAR2(7) NOT NULL Parents IRA Distributions
    106 SFA_PAR_UNTAX_PEN Character(7) VARCHAR2(7) NOT NULL Parents Untaxed Pensions
    107 SFA_PAR_EDU_CREDIT Character(10) VARCHAR2(10) NOT NULL Parents Educational Credits
    108 SFA_PAR_MIL_ALLOW Character(10) VARCHAR2(10) NOT NULL Parents Mil/Clergy Allowance
    109 SFA_PF_FAMSPIN_STG Character(10) VARCHAR2(10) NOT NULL Family Support Income
    110 SFA_PF_OWE_PAR_STG Character(10) VARCHAR2(10) NOT NULL Owed to Parent by Others
    111 SFA_PF_DEBTINC_STG Character(10) VARCHAR2(10) NOT NULL Annual Debt Income
    112 SFA_PF_VALASST_STG Character(10) VARCHAR2(10) NOT NULL Value of Other Assets
    113 SFA_PF_UTILEXP_STG Character(10) VARCHAR2(10) NOT NULL Utilities Expenses
    114 SFA_PF_FOODEXP_STG Character(10) VARCHAR2(10) NOT NULL Food Expenses
    115 SFA_PF_CLTHEXP_STG Character(10) VARCHAR2(10) NOT NULL Clothing Expenses
    116 SFA_PF_HOUSEXP_STG Character(10) VARCHAR2(10) NOT NULL Household Expenses
    117 SFA_PF_AMT2OTH_STG Character(10) VARCHAR2(10) NOT NULL Amount Owed to Others
    118 SFA_PF_DEBTPAY_STG Character(10) VARCHAR2(10) NOT NULL Annual Debt Payment
    119 SFA_PF_AUTOMNT_STG Character(10) VARCHAR2(10) NOT NULL Automobile Maintenance
    120 SFA_PF_PROPINS_STG Character(10) VARCHAR2(10) NOT NULL Property Insurance
    121 SFA_PF_VACCOST_STG Character(10) VARCHAR2(10) NOT NULL Vacation Cost
    122 SFA_PF_ENTCOST_STG Character(10) VARCHAR2(10) NOT NULL Entertainment Cost
    123 SFA_PF_EMPHOME_STG Character(2) VARCHAR2(2) NOT NULL Number Employed in Home
    124 SFA_PF_PD_HOME_STG Character(10) VARCHAR2(10) NOT NULL Amount Paid to Home Employee
    125 SFA_PF_OTHEXP_STG Character(10) VARCHAR2(10) NOT NULL Other Expenses
    126 SFA_PF_IMUNTAX_INC Character(10) VARCHAR2(10) NOT NULL IM Other Untaxed Income
    127 SFA_PF_EXP_PRT_LN Character(10) VARCHAR2(10) NOT NULL Repay Educational Loans
    128 SFA_PF_FATHER_INC Character(10) VARCHAR2(10) NOT NULL Father's Earnings
    129 SFA_PF_MOTHER_INC Character(10) VARCHAR2(10) NOT NULL Mother's Earnings
    130 SFA_PF_FAM_SUP_INC Number(10,0) DECIMAL(10) NOT NULL Family Support Income
    131 OWN_BUSINESS_FARM Character(1) VARCHAR2(1) NOT NULL Own a Business or Farm
    1=Yes
    2=No
    132 SFA_PF_EXP_CHDSUPD Character(10) VARCHAR2(10) NOT NULL Expected Child Sppt Paid
    133 SFA_PF_PARTYP1_STG Character(1) VARCHAR2(1) NOT NULL Parent Type 1
    1=Father
    2=Mother
    3=Step Father
    4=Step Mother
    5=Legal Guardian
    8=Other
    134 SFA_PF_PARTYP2_STG Character(1) VARCHAR2(1) NOT NULL Parent Type 2
    1=Father
    2=Mother
    3=Step Father
    4=Step Mother
    5=Legal Guardian
    8=Other
    135 SFA_PF_ATT_COLLCD1 Character(1) VARCHAR2(1) NOT NULL Attended College Code 1
    F=Yes, Full Time
    H=Yes, Half Time
    N=No, Will not Attend
    136 SFA_PF_ATT_COLLCD2 Character(1) VARCHAR2(1) NOT NULL Attended College Code 2
    F=Yes, Full Time
    H=Yes, Half Time
    N=No, Will not Attend
    137 SFA_PF_COLL_TYPCD1 Character(1) VARCHAR2(1) NOT NULL College Type Code 1
    1=2 -Year Public
    2=2-Year Private
    3=4-Year Public
    4=4-Year Private
    5=Graduate/Professional
    6=Proprietary
    7=Other
    138 SFA_PF_COLL_TYPCD2 Character(1) VARCHAR2(1) NOT NULL College Type Code 2
    1=2 -Year Public
    2=2-Year Private
    3=4-Year Public
    4=4-Year Private
    5=Graduate/Professional
    6=Proprietary
    7=Other
    139 SFA_PF_PAR1_COMPAG Character(2) VARCHAR2(2) NOT NULL Computed Age 1
    140 SFA_PF_PAR2_COMPAG Character(2) VARCHAR2(2) NOT NULL Computed Age 2
    141 SFA_STU_LIVES_WITH Character(1) VARCHAR2(1) NOT NULL Student Lives With
    1=Father
    2=Mother
    3=Neither Parent
    142 SFA_STU_MOST_SUPRT Character(1) VARCHAR2(1) NOT NULL Student Most Support From
    1=Father
    2=Mother
    143 SFA_PF_VANNOEDBNCH Character(10) VARCHAR2(10) NOT NULL VA Non-Education Benefits
    144 SFA_PF_TRAVEL_PLAN Character(1) VARCHAR2(1) NOT NULL Travel Payment Plan
    1=Parents' income/savings
    2=Student's income/savings
    3=Gift from relatives
    4=Scholarship or grant
    5=Sponsor funds
    6=Government funds
    7=Agency/Foundation funds
    8=Other
    145 SFA_PF_P_CASH_ST Character(10) VARCHAR2(10) NOT NULL Cash, Savings, and Checking
    146 SFA_PF_P_IRADIS_ST Character(10) VARCHAR2(10) NOT NULL Untaxed IRA Distributions
    147 SFA_PF_P_UTXPEN_ST Character(10) VARCHAR2(10) NOT NULL Untaxed Pension Distribution
    148 SFA_PF_BUSN_RET1 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 1
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    149 SFA_PF_BUSN_RET2 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 2
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    150 SFA_PF_BUSN_RET3 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 3
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    151 SFA_PF_BUSN_RET4 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 4
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    152 SFA_PF_BUSN_RET5 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 5
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    153 SFA_PF_BUSN_RET6 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 6
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    154 SFA_PF_BUSN_RET7 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 7
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    155 SFA_PF_BUSN_RET8 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 8
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    156 SFA_PF_BUSN_RET9 Character(1) VARCHAR2(1) NOT NULL Business Return Filed 9
    1=Schedule C
    2=Form 1065
    3=Form 1120
    4=Form 1120-S
    5=Schedule E
    6=Other Return
    157 SFA_PF_FOOD_STAMPS Character(1) VARCHAR2(1) NOT NULL Received Food Stamps
    N=No
    Y=Yes
    158 SFA_PF_FREE_LUNCH Character(1) VARCHAR2(1) NOT NULL Received Free Lunch
    N=No
    Y=Yes
    159 SFA_PF_RCVD_WIC Character(1) VARCHAR2(1) NOT NULL Received WIC
    N=No
    Y=Yes
    160 SFA_PF_HLSAVACN_ST Character(10) VARCHAR2(10) NOT NULL Health Savings Account
    161 SFA_PF_FSAHCARE_ST Character(10) VARCHAR2(10) NOT NULL FSA Health Care
    162 SFA_PF_FSADCARE_ST Character(10) VARCHAR2(10) NOT NULL FSA Dependent Care
    163 SFA_PF_FATHER_NAME Character(20) VARCHAR2(20) NOT NULL Parent Name 1
    164 SFA_PF_MOTHER_NAME Character(20) VARCHAR2(20) NOT NULL Parent Name 2
    165 SFA_PF_NCPNAME Character(20) VARCHAR2(20) NOT NULL Non-Custodial Parent Name
    166 SFA_PF_PAR_F_EDLVL Character(1) VARCHAR2(1) NOT NULL Parent Education Level Code
    1=Middle school/Jr. high
    2=High school
    3=College/university or beyond
    4=Other/unknown
    167 SFA_PF_PAR_M_EDLVL Character(1) VARCHAR2(1) NOT NULL Parent Education Level Code
    1=Middle school/Jr. high
    2=High school
    3=College/university or beyond
    4=Other/unknown
    168 SFA_PF_MED_TAX_STG Character(10) VARCHAR2(10) NOT NULL Additional Medicare Tax
    169 SFA_PF_HSA_TAX_STG Character(10) VARCHAR2(10) NOT NULL HSA Pre Tax Contribution
    170 SFA_PF_TX_FL_STA Character(1) VARCHAR2(1) NOT NULL Tax Filing Status Code
    1=Single
    2=Married filing jointly
    3=Married filing separately
    4=Head of Household
    5=Qualifying widow with dep
    171 SFA_PF_PAR1_INCOME Character(10) VARCHAR2(10) NOT NULL Parent1 Earned Income
    172 SFA_PF_PAR2_INCOME Character(10) VARCHAR2(10) NOT NULL Parent2 Earned Income
    173 SFA_PF_OTHTAX_INC Character(11) VARCHAR2(11) NOT NULL Other Taxable Income
    174 SFA_PF_OTHUTX_INC Character(10) VARCHAR2(10) NOT NULL Other Untaxed Income
    175 SFA_PF_PAR1_LASTNM Character(35) VARCHAR2(35) NOT NULL Last Name 1
    176 SFA_PF_PAR1_FNAME Character(35) VARCHAR2(35) NOT NULL First Name 1
    177 SFA_PF_PAR1_EMAIL Character(50) VARCHAR2(50) NOT NULL Email Address 1
    178 SFA_PF_PAR1_EMPIND Character(1) VARCHAR2(1) NOT NULL Self Employed Indicator 1
    N=No
    Y=Yes
    179 SFA_PF_PAR1UEMPIND Character(1) VARCHAR2(1) NOT NULL Unemployed Indicator 1
    N=No
    Y=Yes
    180 SFA_PF_PAR2_LASTNM Character(35) VARCHAR2(35) NOT NULL Last Name 2
    181 SFA_PF_PAR2_FNAME Character(35) VARCHAR2(35) NOT NULL First Name 2
    182 SFA_PF_PAR2_EMAIL Character(50) VARCHAR2(50) NOT NULL Email Address 2
    183 SFA_PF_PAR2_EMPIN Character(1) VARCHAR2(1) NOT NULL Self Employed Indicator 2
    N=No
    Y=Yes
    184 SFA_PF_PAR2UEMPIND Character(1) VARCHAR2(1) NOT NULL Unemployed Indicator 2
    N=No
    Y=Yes
    185 SFA_PF_CHLD_SUP_18 Character(10) VARCHAR2(10) NOT NULL Child Support Rcvd For Student
    186 SFA_PF_NBR_REALEST Character(1) VARCHAR2(1) NOT NULL Number Of Real Estates
    187 SFA_PF_CHLDSPENDDT Character(7) VARCHAR2(7) NOT NULL Child Support End Date
    188 SFA_PF_RCVD_MEDAID Character(1) VARCHAR2(1) NOT NULL Received Medicaid
    N=No
    Y=Yes
    189 SFA_PF_LNAME Character(35) VARCHAR2(35) NOT NULL Last Name
    190 SFA_PF_FNAME Character(35) VARCHAR2(35) NOT NULL First Name
    191 SFA_PF_AGMNT_EDSUP Character(1) VARCHAR2(1) NOT NULL Agreement Educational Support
    N=No
    Y=Yes
    192 SFA_PF_HHOLD_TYPE Character(1) VARCHAR2(1) NOT NULL HouseHold Type
    A=HHA
    B=HHB
    C=HHA / HHB
    193 SFA_PF_HHB_IND Character(1) VARCHAR2(1) NOT NULL HHB Indicated
    N=No
    Y=Yes
    194 SFA_PF_YEAR_MARR19 Character(4) VARCHAR2(4) NOT NULL Year Of Marriage
    195 SFA_PF_CUST_PARENT Character(2) VARCHAR2(2) NOT NULL Biological Adoptive Parent
    P1=Parent1
    P2=Parent2
    196 SFA_PF_NSBAP_RESP Character(14) VARCHAR2(14) NOT NULL No Second BAP Response
    197 SFA_PF_EXADV_TX_ST Character(10) VARCHAR2(10) NOT NULL Excess Adv Tax Premium Credit
    198 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    199 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    200 CITY Character(30) VARCHAR2(30) NOT NULL City
    201 STATE Character(6) VARCHAR2(6) NOT NULL State
    202 SFA_PF_POSTAL_CODE Character(17) VARCHAR2(17) NOT NULL Postal Code
    203 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    204 SFA_PAR1_VETERAN Character(1) VARCHAR2(1) NOT NULL Veteran 1
    N=No
    Y=Yes
    205 SFA_PAR2_VETERAN Character(1) VARCHAR2(1) NOT NULL Veteran 2
    N=No
    Y=Yes
    206 SFA_ALIMONY_RECD Character(10) VARCHAR2(10) NOT NULL Alimony Received
    207 SFA_QUAL_BSINC_DED Character(10) VARCHAR2(10) NOT NULL Qualified Income Deduction
    208 SFA_UT_IRA_PENSION Character(10) VARCHAR2(10) NOT NULL Untax IRA Annuity Pension
    209 SFA_PF_SCH1_IND Character(1) VARCHAR2(1) NOT NULL Schedule 1 Indicator
    N=No
    Y=Yes
    210 SFA_DT_ALM_PD_ST Character(10) VARCHAR2(10) NOT NULL Deductible Alimony Paid
    211 SFA_TOT_ALM_RCD_ST Character(10) VARCHAR2(10) NOT NULL Total Alimony Received
    212 SFA_UT_IRA_DISB_ST Character(10) VARCHAR2(10) NOT NULL Untaxed IRA Distribution
    213 SFA_UT_PENAN_DB_ST Character(10) VARCHAR2(10) NOT NULL Untaxed Pension Annuity Distb
    214 SFA_HOME_PRIDBT_ST Character(10) VARCHAR2(10) NOT NULL Home Primary Debt
    215 SFA_TOT_ALM_PD_ST Character(10) VARCHAR2(10) NOT NULL Total Alimony Paid
    216 SFA_PF_ANT_CHNG Character(1) VARCHAR2(1) NOT NULL Anticipated Changes
    N=No
    Y=Yes
    217 SFA_PF_CRTN_RSN_CD Character(2) VARCHAR2(2) NOT NULL This field is used to hold the Correction Record Indictor of the Profile files
    1=Changing from Ind to Dependent
    10=Financial Support
    11=Other
    2=Need to add a Business or Farm
    3=Made a mistake
    4=Change in Employment
    5=COVID 19
    6=Medical Dental Expenses
    7=Catastrophic Event
    8=Elder Care
    9=Nonrecurring Income
    218 SFA_PF_CRTN_RSN_TX Long Character CLOB Correction Explanation