SFA_SIM_ISIRSTU(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 | 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 |