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