SFA_SIM_ISIRSTU

(SQL Table)
Index Back

ISIR Student data

2425: Additional record for ISIR Student data

  • 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 SFA_FAFSA_UUID Character(36) VARCHAR2(36) NOT NULL 2425 FAFSA UUID
    5 SFA_TRANSACT_UUID Character(36) VARCHAR2(36) NOT NULL 2425 FAFSA UUID
    6 SFA_PERSON_UUID Character(36) VARCHAR2(36) NOT NULL 2425 FAFSA UUID
    7 SFA_STUDENT_SUFFIX Character(10) VARCHAR2(10) NOT NULL 2425 Student Suffix
    8 SFA_STUDENT_ITIN Character(9) VARCHAR2(9) NOT NULL 2425: Student ITIN
    9 SFA_STD_STREET Character(40) VARCHAR2(40) NOT NULL 2425: Street Address
    10 SFA_STD_CITY Character(30) VARCHAR2(30) NOT NULL 2425:City
    11 SFA_STD_ZIPCODE Character(10) VARCHAR2(10) NOT NULL 2425:Spouse Zip Code
    12 SFA_STD_COUNTRY Character(2) VARCHAR2(2) NOT NULL 2425: Country
    13 SFA_TEACHER_CERT Character(1) VARCHAR2(1) NOT NULL 2425: Pursuing Teaher Certification
    1=Yes
    2=No
    14 SFA_ORPHAN_DEC Character(1) VARCHAR2(1) NOT NULL 2425: Parent Deceased
    15 SFA_ORPHAN_FOSTER Character(1) VARCHAR2(1) NOT NULL 2425:In Foster Care
    16 SFA_ORPHAN_WARD Character(1) VARCHAR2(1) NOT NULL 2425: Ward of Court
    1=Yes
    17 SFA_STD_CIRCUM Character(1) VARCHAR2(1) NOT NULL 2425:Personal Circumstances: None of the above
    1=Yes
    2=No
    18 SFA_HOMELESS_TRIO Character(1) VARCHAR2(1) NOT NULL 2425:Unaccompanied and Homeless (TRIO)?
    1=Yes
    19 SFA_HOMELESS_FAA Character(1) VARCHAR2(1) NOT NULL 2425:Unaccompanied and Homeless (FAA)?
    1=Yes
    20 SFA_STD_OTHER Character(1) VARCHAR2(1) NOT NULL 2425:None of the above (Other Circumstances)
    1=Yes
    21 SFA_STD_UNUSUAL Character(1) VARCHAR2(1) NOT NULL 2425:Unusual Circumstance
    1=Yes
    22 SFA_STD_UNSUB Character(1) VARCHAR2(1) NOT NULL 2425: Unsub Only
    1=Yes
    2=No
    23 SFA_STD_PARATT Character(1) VARCHAR2(1) NOT NULL 2425:Either Parent Attend College
    1=Yes
    2=No
    3=Dont Know
    24 SFA_STD_PARKILL Character(1) VARCHAR2(1) NOT NULL 2425:Parent Killed in the Line of Duty
    1=Yes
    2=No
    25 SFA_HIGH_SCHL_DIPL Character(1) VARCHAR2(1) NOT NULL 2425: High School Equivalent Diploma
    26 SFA_HIGH_SCHL_DPST Character(2) VARCHAR2(2) NOT NULL 2425: High School Equivalent Diploma State
    27 SFA_STD_ETIC Character(1) VARCHAR2(1) NOT NULL 2425:Received EITC
    1=Yes
    28 SFA_STD_HOUSING Character(1) VARCHAR2(1) NOT NULL 2425:Received Federal Housing Assistance
    1=Yes
    29 SFA_STD_MEDICAID Character(1) VARCHAR2(1) NOT NULL 2425:Received Medicaid
    1=Yes
    30 SFA_STD_36B Character(1) VARCHAR2(1) NOT NULL 2425:Received Refundable Credit for 36B Health Plan
    1=Yes
    31 SFA_STD_FED_NONE Character(1) VARCHAR2(1) NOT NULL 2425:Federal Benefits: None of the Above�
    1=Yes
    32 SFA_STD_1040 Character(1) VARCHAR2(1) NOT NULL 2425:Filed 1040 or 1040NR
    1=Yes
    2=No
    33 SFA_STD_NON_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Non-U.S. Tax Return
    1=Yes
    2=No
    34 SFA_STD_JOINT_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Joint Return with Current Spouse
    1=Yes
    2=No
    35 SFA_STD_TAX_RET Character(1) VARCHAR2(1) NOT NULL 2425: Student Tax Return Filing Status
    1=Yes
    2=No
    36 SFA_INC_WORK1 Number(11,0) DECIMAL(11) NOT NULL 2425:Income Earned from Work
    37 SFA_TAX_EXEMPT1 Number(11,0) DECIMAL(11) NOT NULL 2425:Tax Exempt Interest Income
    38 SFA_UNTAX_IRA1 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of IRA Distributions
    39 SFA_IRA_ROLL1 Number(11,0) DECIMAL(11) NOT NULL 2425:IRA Rollover
    40 SFA_UNTAX_PEN1 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of Pensions
    41 SFA_PEN_ROLL1 Number(11,0) DECIMAL(11) NOT NULL 2425:Pension Rollover
    42 SFA_TAX_CREDIT1 Character(1) VARCHAR2(1) NOT NULL 2425:Earned Income Tax Credit Received During Tax Year?
    43 SFA_DEDUCT_IRA1 Number(12,0) DECIMAL(12) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other
    44 SFA_FILED_SCHD1 Character(1) VARCHAR2(1) NOT NULL 2425:Filed Schedule A, B, D, E, F or H?
    45 SFA_SCHED_CAMT1 Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C Amount�
    46 SFA_FED_TAX1 Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Foreign Income Exempt from Federal Taxation
    47 SFA_TAXES_PAID1 Number(9,0) DECIMAL(9) NOT NULL 2425:Income Tax Paid
    48 SFA_BL_INC_WORK1 Character(1) VARCHAR2(1) NOT NULL 2425: Income Earned from Work Blank
    49 SFA_BL_TAX_EXEMPT1 Character(1) VARCHAR2(1) NOT NULL 2425:Tax Exempt Interest Income Blank
    50 SFA_BL_UNTAX_IRA1 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of IRA Distributions
    51 SFA_BL_IRA_ROLL1 Character(1) VARCHAR2(1) NOT NULL 2425:IRA Rollover
    52 SFA_BL_UNTAX_PEN1 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of Pensions
    53 SFA_BL_PEN_ROLL1 Character(1) VARCHAR2(1) NOT NULL 2425:Pension Rollover blank
    54 SFA_BL_AGI1 Character(1) VARCHAR2(1) NOT NULL 2425:Adjusted Gross Income
    55 SFA_BL_DEDUCT_IRA1 Character(1) VARCHAR2(1) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other blank
    56 SFA_BL_EDU_CREDIT1 Character(1) VARCHAR2(1) NOT NULL 2425: Education Credits Blank
    57 SFA_BL_SCHED_CAMT1 Character(1) VARCHAR2(1) NOT NULL 2425:Schedule C Amount Blank
    58 SFA_BL_FED_TAX1 Character(1) VARCHAR2(1) NOT NULL 2425: Foreign Income Exempt from Federal Taxation blank
    59 SFA_BL_TAX_PAID1 Character(1) VARCHAR2(1) NOT NULL 2425:Income Tax Paid blank
    60 SFA_SCHL_CHOICE_11 Character(6) VARCHAR2(6) NOT NULL 2425:College #11
    61 SFA_SCHL_CHOICE_12 Character(6) VARCHAR2(6) NOT NULL 2425:College #12
    62 SFA_SCHL_CHOICE_13 Character(6) VARCHAR2(6) NOT NULL 2425:College #13
    63 SFA_SCHL_CHOICE_14 Character(6) VARCHAR2(6) NOT NULL 2425:College #14
    64 SFA_SCHL_CHOICE_15 Character(6) VARCHAR2(6) NOT NULL 2425:College #15
    65 SFA_SCHL_CHOICE_16 Character(6) VARCHAR2(6) NOT NULL 2425:College #16
    66 SFA_SCHL_CHOICE_17 Character(6) VARCHAR2(6) NOT NULL 2425:College #17
    67 SFA_SCHL_CHOICE_18 Character(6) VARCHAR2(6) NOT NULL 2425:College #18
    68 SFA_SCHL_CHOICE_19 Character(6) VARCHAR2(6) NOT NULL 2425:College #19
    69 SFA_SCHL_CHOICE_20 Character(6) VARCHAR2(6) NOT NULL 2425:College #20
    70 SFA_STD_CONSENT Character(1) VARCHAR2(1) NOT NULL 2425: Consent to Retrieve and Disclose FTI
    71 SFA_STD_SIGNATURE Character(1) VARCHAR2(1) NOT NULL 2425:Signature�
    72 SFA_STD_SIGNDATE Date(10) DATE 2425:Signature Date
    73 SFA_SPS_FIRSTNAME Character(35) VARCHAR2(35) NOT NULL 2425: First Name
    74 SFA_SPS_MIDDLENAME Character(15) VARCHAR2(15) NOT NULL 2425:Middle Name�
    75 SFA_SPS_LASTNAME Character(35) VARCHAR2(35) NOT NULL 2425:Last Name
    76 SFA_SPS_SUFFIX Character(10) VARCHAR2(10) NOT NULL 2425 Spouse Suffix
    77 SFA_SPS_BIRTHDATE Date(10) DATE 2425:Spouse Birthdate
    78 SFA_SPS_SSN Character(9) VARCHAR2(9) NOT NULL 2425:Social Security Number
    79 SFA_SPS_ITIN Character(9) VARCHAR2(9) NOT NULL 2425: Spouse ITIN
    80 SFA_SPS_PHONE Character(10) VARCHAR2(10) NOT NULL 2425:Spouse Phone Number
    81 SFA_SPS_EMAIL Character(50) VARCHAR2(50) NOT NULL 2425:Spouse Email Address
    82 SFA_SPS_STREET Character(40) VARCHAR2(40) NOT NULL 2425: Spouse Street Address
    83 SFA_SPS_CITY Character(30) VARCHAR2(30) NOT NULL 2425:Spouse City
    84 SFA_SPS_STATE Character(2) VARCHAR2(2) NOT NULL 2425:Spouse State
    85 SFA_SPS_ZIPCODE Character(10) VARCHAR2(10) NOT NULL 2425:Spouse Zip Code
    86 SFA_SPS_COUNTRY Character(2) VARCHAR2(2) NOT NULL 2425: Spouse Country
    87 SFA_SPS_1040 Character(1) VARCHAR2(1) NOT NULL 2425:Filed 1040 or 1040NR
    88 SFA_SPS_NON_TAX Character(1) VARCHAR2(1) NOT NULL 2425:Filed Non-U.S. Tax Return
    89 SFA_SPS_TAX_RET Character(1) VARCHAR2(1) NOT NULL 2425: Spouse Tax Return Filing Status
    90 SFA_INC_WORK2 Number(11,0) DECIMAL(11) NOT NULL 2425:Income Earned from Work
    91 SFA_TAX_EXEMPT2 Number(11,0) DECIMAL(11) NOT NULL 2425:Tax Exempt Interest Income
    92 SFA_UNTAX_IRA2 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of IRA Distributions
    93 SFA_IRA_ROLL2 Number(11,0) DECIMAL(11) NOT NULL 2425:IRA Rollover
    94 SFA_UNTAX_PEN2 Number(11,0) DECIMAL(11) NOT NULL 2425:Untaxed Portions of Pensions
    95 SFA_PEN_ROLL2 Number(11,0) DECIMAL(11) NOT NULL 2425:Pension Rollover
    96 SFA_AGI Signed Number(11,0) DECIMAL(10) NOT NULL 2425:AGI
    97 SFA_TAXES_PAID2 Number(9,0) DECIMAL(9) NOT NULL 2425: Income Tax Paid
    98 SFA_DEDUCT_IRA2 Number(12,0) DECIMAL(12) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other
    99 SFA_EDU_CREDIT2 Number(10,0) DECIMAL(10) NOT NULL 2425: Educational Credit
    100 SFA_FILED_SCHD2 Character(1) VARCHAR2(1) NOT NULL 2425:Filed Schedule A, B, D, E, F or H?
    101 SFA_SCHED_CAMT2 Signed Number(13,0) DECIMAL(12) NOT NULL 2425:Schedule C Amount�
    102 SFA_FED_TAX2 Signed Number(11,0) DECIMAL(10) NOT NULL 2425:Foreign Income Exempt from Federal Taxation
    103 SFA_BL_INC_WORK2 Character(1) VARCHAR2(1) NOT NULL 2425: Income Earned from Work Blank
    104 SFA_BL_TAX_EXEMPT2 Character(1) VARCHAR2(1) NOT NULL 2425:Tax Exempt Interest Income Blank
    105 SFA_BL_UNTAX_IRA2 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of IRA Distributions
    106 SFA_BL_IRA_ROLL2 Character(1) VARCHAR2(1) NOT NULL 2425:IRA Rollover
    107 SFA_BL_UNTAX_PEN2 Character(1) VARCHAR2(1) NOT NULL 2425:Untaxed Portions of Pensions
    108 SFA_BL_PEN_ROLL2 Character(1) VARCHAR2(1) NOT NULL 2425:Pension Rollover blank
    109 SFA_BL_AGI2 Character(1) VARCHAR2(1) NOT NULL 2425:Adjusted Gross Income
    110 SFA_BL_TAX_PAID2 Character(1) VARCHAR2(1) NOT NULL 2425:Income Tax Paid blank
    111 SFA_BL_DEDUCT_IRA2 Character(1) VARCHAR2(1) NOT NULL 2425:Deductible Payments to IRA/Keogh/Other blank
    112 SFA_BL_EDU_CREDIT2 Character(1) VARCHAR2(1) NOT NULL 2425: Education Credits Blank
    113 SFA_BL_SCHED_CAMT2 Character(1) VARCHAR2(1) NOT NULL 2425:Schedule C Amount Blank
    114 SFA_BL_FED_TAX2 Character(1) VARCHAR2(1) NOT NULL 2425: Foreign Income Exempt from Federal Taxation blank
    115 SFA_SPS_CONSENT Character(1) VARCHAR2(1) NOT NULL 2425: Consent to Retrieve and Disclose FTI
    116 SFA_SPS_SIGNATURE Character(1) VARCHAR2(1) NOT NULL 2425:Signature�
    117 SFA_SPS_SIGNDATE Date(10) DATE 2425:Signature Date
    118 SFA_ASMD_STD Character(3) VARCHAR2(3) NOT NULL 2425:Assumed Student Family Size