SFA_ISIR_PAR(SQL Table) |
Index Back |
|---|---|
ISIR Parent Data2425:Additional record for ISIR Parent 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_PAR_FIRSTNAME | Character(35) | VARCHAR2(35) NOT NULL | 2425: First Name |
| 8 | SFA_PAR_MIDDLENAME | Character(15) | VARCHAR2(15) NOT NULL | 2425:Middle Name� |
| 9 | SFA_PAR_LASTNAME | Character(35) | VARCHAR2(35) NOT NULL | 2425:Last Name |
| 10 | SFA_PAR_SUFFIX | Character(10) | VARCHAR2(10) NOT NULL | 2425 Parent Suffix |
| 11 | SFA_PAR_ITIN | Character(9) | VARCHAR2(9) NOT NULL | 2425: Parent ITIN |
| 12 | SFA_PAR_PHONE | Character(10) | VARCHAR2(10) NOT NULL | 2425:Parent Phone Number |
| 13 | SFA_PAR_STREET | Character(40) | VARCHAR2(40) NOT NULL | 2425: Street Address |
| 14 | SFA_PAR_CITY | Character(30) | VARCHAR2(30) NOT NULL | 2425:Parent City |
| 15 | SFA_PAR_STATE | Character(2) | VARCHAR2(2) NOT NULL | 2425:Parent State |
| 16 | SFA_PAR_ZIPCODE | Character(10) | VARCHAR2(10) NOT NULL | 2425:Parent Zip Code |
| 17 | SFA_PAR_COUNTRY | Character(2) | VARCHAR2(2) NOT NULL | 2425: Country |
| 18 | SFA_PAR_NUM_COLL | Character(2) | VARCHAR2(2) NOT NULL | 2425:Number in College |
| 19 | SFA_PAR_ETIC | Character(1) | VARCHAR2(1) NOT NULL | 2425:Received EITC |
| 20 | SFA_PAR_HOUSING | Character(1) | VARCHAR2(1) NOT NULL | 2425:Received Federal Housing Assistance |
| 21 | SFA_PAR_MEDICAID | Character(1) | VARCHAR2(1) NOT NULL | 2425:Received Medicaid |
| 22 | SFA_PAR_36B | Character(1) | VARCHAR2(1) NOT NULL | 2425:Received Refundable Credit for 36B Health Plan |
| 23 | SFA_PAR_FED_NONE | Character(1) | VARCHAR2(1) NOT NULL | 2425:Federal Benefits: None of the Above� |
| 24 | SFA_PAR_1040 | Character(1) | VARCHAR2(1) NOT NULL |
2425:Filed 1040 or 1040NR
1=Yes 2=No |
| 25 | SFA_PAR_NON_TAX | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed Non-U.S. Tax Return |
| 26 | SFA_PAR_JOINT_TAX | Character(1) | VARCHAR2(1) NOT NULL |
2425:Filed Joint Return with Current Spouse
1=Yes 2=No |
| 27 | 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 |
| 28 | SFA_INC_WORK1 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Income Earned from Work |
| 29 | SFA_TAX_EXEMPT1 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Tax Exempt Interest Income |
| 30 | SFA_UNTAX_IRA1 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Untaxed Portions of IRA Distributions |
| 31 | SFA_IRA_ROLL1 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:IRA Rollover |
| 32 | SFA_UNTAX_PEN1 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Untaxed Portions of Pensions |
| 33 | SFA_PEN_ROLL1 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Pension Rollover |
| 34 | SFA_TAX_CREDIT1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Earned Income Tax Credit Received During Tax Year? |
| 35 | SFA_DEDUCT_IRA1 | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Deductible Payments to IRA/Keogh/Other |
| 36 | SFA_FILED_SCHD1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed Schedule A, B, D, E, F or H? |
| 37 | SFA_SCHED_CAMT1 | Signed Number(13,0) | DECIMAL(12) NOT NULL | 2425:Schedule C Amount� |
| 38 | SFA_FED_TAX1 | Signed Number(11,0) | DECIMAL(10) NOT NULL | 2425:Foreign Income Exempt from Federal Taxation |
| 39 | SFA_TAXES_PAID1 | Number(9,0) | DECIMAL(9) NOT NULL | 2425:Income Tax Paid |
| 40 | SFA_BL_INC_WORK1 | Character(1) | VARCHAR2(1) NOT NULL | 2425: Income Earned from Work Blank |
| 41 | SFA_BL_TAX_EXEMPT1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Tax Exempt Interest Income Blank |
| 42 | SFA_BL_UNTAX_IRA1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Untaxed Portions of IRA Distributions |
| 43 | SFA_BL_IRA_ROLL1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:IRA Rollover |
| 44 | SFA_BL_UNTAX_PEN1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Untaxed Portions of Pensions |
| 45 | SFA_BL_PEN_ROLL1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Pension Rollover blank |
| 46 | SFA_BL_AGI1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Adjusted Gross Income |
| 47 | SFA_BL_DEDUCT_IRA1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Deductible Payments to IRA/Keogh/Other blank |
| 48 | SFA_BL_EDU_CREDIT1 | Character(1) | VARCHAR2(1) NOT NULL | 2425: Education Credits Blank |
| 49 | SFA_BL_SCHED_CAMT1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Schedule C Amount Blank |
| 50 | SFA_BL_FED_TAX1 | Character(1) | VARCHAR2(1) NOT NULL | 2425: Foreign Income Exempt from Federal Taxation blank |
| 51 | SFA_BL_TAX_PAID1 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Income Tax Paid blank |
| 52 | SFA_PAR_CONSENT | Character(1) | VARCHAR2(1) NOT NULL | 2425: Consent to Retrieve and Disclose FTI |
| 53 | SFA_PAR_SIGNATURE | Character(1) | VARCHAR2(1) NOT NULL | 2425:Signature� |
| 54 | SFA_PAR_SIGNDATE | Date(10) | DATE | 2425:Signature Date |
| 55 | SFA_OTH_FIRSTNAME | Character(35) | VARCHAR2(35) NOT NULL | 2425: First Name |
| 56 | SFA_OTH_MIDDLENAME | Character(15) | VARCHAR2(15) NOT NULL | 2425:Middle Name� |
| 57 | SFA_OTH_LASTNAME | Character(35) | VARCHAR2(35) NOT NULL | 2425:Last Name |
| 58 | SFA_OTH_SUFFIX | Character(10) | VARCHAR2(10) NOT NULL | 2425 Spouse Suffix |
| 59 | SFA_OTH_ITIN | Character(9) | VARCHAR2(9) NOT NULL | 2425: Other Parent ITIN |
| 60 | SFA_OTH_PHONE | Character(10) | VARCHAR2(10) NOT NULL | 2425:Spouse Phone Number |
| 61 | SFA_OTH_EMAILADDR | Character(50) | VARCHAR2(50) NOT NULL | 2425:Email Address |
| 62 | SFA_OTH_STREET | Character(40) | VARCHAR2(40) NOT NULL | 2425: Other Parent Street Address |
| 63 | SFA_OTH_CITY | Character(30) | VARCHAR2(30) NOT NULL | 2425:Other Parent City |
| 64 | SFA_OTH_STATE | Character(2) | VARCHAR2(2) NOT NULL | 2425:Parent State |
| 65 | SFA_OTH_ZIPCODE | Character(10) | VARCHAR2(10) NOT NULL | 2425:Parent Zip Code |
| 66 | SFA_OTH_COUNTRY | Character(2) | VARCHAR2(2) NOT NULL | 2425: Country |
| 67 | SFA_OTH_1040 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed 1040 or 1040NR |
| 68 | SFA_OTH_NON_TAX | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed Non-U.S. Tax Return |
| 69 | SFA_OTH_TAX_RET_ST | Character(1) | VARCHAR2(1) NOT NULL | 2425:Tax Return Filing Status� |
| 70 | SFA_INC_WORK2 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Income Earned from Work |
| 71 | SFA_TAX_EXEMPT2 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Tax Exempt Interest Income |
| 72 | SFA_UNTAX_IRA2 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Untaxed Portions of IRA Distributions |
| 73 | SFA_IRA_ROLL2 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:IRA Rollover |
| 74 | SFA_UNTAX_PEN2 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Untaxed Portions of Pensions |
| 75 | SFA_PEN_ROLL2 | Number(11,0) | DECIMAL(11) NOT NULL | 2425:Pension Rollover |
| 76 | SFA_AGI | Signed Number(11,0) | DECIMAL(10) NOT NULL | 2425:AGI |
| 77 | SFA_TAXES_PAID2 | Number(9,0) | DECIMAL(9) NOT NULL | 2425: Income Tax Paid |
| 78 | SFA_DEDUCT_IRA2 | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Deductible Payments to IRA/Keogh/Other |
| 79 | SFA_EDU_CREDIT2 | Number(10,0) | DECIMAL(10) NOT NULL | 2425: Educational Credit |
| 80 | SFA_FILED_SCHD2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Filed Schedule A, B, D, E, F or H? |
| 81 | SFA_SCHED_CAMT2 | Signed Number(13,0) | DECIMAL(12) NOT NULL | 2425:Schedule C Amount� |
| 82 | SFA_FED_TAX2 | Signed Number(11,0) | DECIMAL(10) NOT NULL | 2425:Foreign Income Exempt from Federal Taxation |
| 83 | SFA_BL_INC_WORK2 | Character(1) | VARCHAR2(1) NOT NULL | 2425: Income Earned from Work Blank |
| 84 | SFA_BL_TAX_EXEMPT2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Tax Exempt Interest Income Blank |
| 85 | SFA_BL_UNTAX_IRA2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Untaxed Portions of IRA Distributions |
| 86 | SFA_BL_IRA_ROLL2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:IRA Rollover |
| 87 | SFA_BL_UNTAX_PEN2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Untaxed Portions of Pensions |
| 88 | SFA_BL_PEN_ROLL2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Pension Rollover blank |
| 89 | SFA_BL_AGI2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Adjusted Gross Income |
| 90 | SFA_BL_TAX_PAID2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Income Tax Paid blank |
| 91 | SFA_BL_DEDUCT_IRA2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Deductible Payments to IRA/Keogh/Other blank |
| 92 | SFA_BL_EDU_CREDIT2 | Character(1) | VARCHAR2(1) NOT NULL | 2425: Education Credits Blank |
| 93 | SFA_BL_SCHED_CAMT2 | Character(1) | VARCHAR2(1) NOT NULL | 2425:Schedule C Amount Blank |
| 94 | SFA_BL_FED_TAX2 | Character(1) | VARCHAR2(1) NOT NULL | 2425: Foreign Income Exempt from Federal Taxation blank |
| 95 | SFA_OTH_CONSENT | Character(1) | VARCHAR2(1) NOT NULL | 2425: Consent to Retrieve and Disclose FTI |
| 96 | SFA_OTH_SIGNATURE | Character(1) | VARCHAR2(1) NOT NULL | 2425:Signature� |
| 97 | SFA_OTH_SIGNDATE | Date(10) | DATE | 2425:Signature Date |
| 98 | SFA_ASMD_PAR | Character(3) | VARCHAR2(3) NOT NULL | 2425:Assumed Parent Family Size |