SCHEDULE_SE(SQL Table) |
Index Back |
|---|---|
Self_Employment TaxData Collection for Schedule SE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STUDENT_AID |
|
| 2 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
|
| 3 | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: STUDENT_AID |
|
| 4 | Number(2,0) | SMALLINT NOT NULL | Sequence Number | |
| 5 | Character(4) | VARCHAR2(4) NOT NULL | Schedule Number | |
| 6 | SE_S_NET_PRO_SCH_F | Signed Number(7,0) | DECIMAL(6) NOT NULL | 1 Net Farm Profit Sch F |
| 7 | SE_S_NET_PRO_SCH_C | Signed Number(7,0) | DECIMAL(6) NOT NULL | 2 Net profit Sch C |
| 8 | SE_S_LINE_3 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 3 Combine 1 and 2 |
| 9 | SE_S_NET_SELF_EMP | Signed Number(7,0) | DECIMAL(6) NOT NULL | 4 Net Earnings From Self-Emp |
| 10 | SE_S_SELF_EMP_TAX | Signed Number(7,0) | DECIMAL(6) NOT NULL | 5 Self-Employment Tax |
| 11 | SE_S_DED_HALF_SET | Signed Number(7,0) | DECIMAL(6) NOT NULL | 6 Deduction Half of Self-Emp |
| 12 | SE_L_MINISTER | Character(1) | VARCHAR2(1) NOT NULL |
You are a minister and had
Y/N Table Edit Default Value: Y |
| 13 | SE_L_NET_PRO_SCH_F | Signed Number(7,0) | DECIMAL(6) NOT NULL | 1 Net Farm Profit Sch F |
| 14 | SE_L_NET_PRO_SCH_C | Signed Number(7,0) | DECIMAL(6) NOT NULL | 2 Net Profit Sch C |
| 15 | SE_L_LINE_3 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 3 Combine 1 and 2 |
| 16 | SE_L_LINE_4A | Signed Number(7,0) | DECIMAL(6) NOT NULL | 4a Multiply 3 by 0.9235 |
| 17 | SE_L_LINE_4B | Signed Number(7,0) | DECIMAL(6) NOT NULL | 4b Total of 15 and 17 |
| 18 | SE_L_LINE_4C | Signed Number(7,0) | DECIMAL(6) NOT NULL | 4c Combine 4a and 4b |
| 19 | SE_L_CHURCH_EMP_IN | Signed Number(7,0) | DECIMAL(6) NOT NULL | 5a Church Employee Income |
| 20 | SE_L_LINE_5B | Signed Number(7,0) | DECIMAL(6) NOT NULL | 5b Multiply 5a and 4b |
| 21 | SE_L_NET_SELF_EMP | Signed Number(7,0) | DECIMAL(6) NOT NULL | 6 Net Earnings Self-Employ |
| 22 | SE_L_LINE_7 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 7 Maximum of Combined Wages |
| 23 | SE_L_TOT_SS_WAGES | Signed Number(7,0) | DECIMAL(6) NOT NULL | 8a Total SS Wages and tips |
| 24 | SE_L_UNRPRTED_TIP | Signed Number(7,0) | DECIMAL(6) NOT NULL | 8b Unreported Tips |
| 25 | SE_L_LINE_8C | Signed Number(7,0) | DECIMAL(6) NOT NULL | 8c Add 8a and 8b |
| 26 | SE_L_LINE_9 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 9 Subtract 8c From 7 |
| 27 | SE_L_LINE_10 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 12.4% (net earnings vs. wages) |
| 28 | SE_L_LINE_11 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 11 Multiply 6 by 0.029 |
| 29 | SE_L_SELF_EMP_TAX | Signed Number(7,0) | DECIMAL(6) NOT NULL | 12 Self-Employment Tax |
| 30 | SE_L_DED_HALF_SET | Signed Number(7,0) | DECIMAL(6) NOT NULL | 13 Deduction Half of Self-Em |
| 31 | SE_L_LINE_14 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 14 Max Income For Optnl Mthd |
| 32 | SE_L_LINE_15 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 15 Line 15 |
| 33 | SE_L_LINE_16 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 16 Subtract 15 from 14 |
| 34 | SE_L_LINE_17 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 17 Line 17 |