SCHEDULE_SE(SQL Table) |
Index Back |
---|---|
Self_Employment TaxData Collection for Schedule SE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STUDENT_AID |
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: STUDENT_AID |
4 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
5 | SCH_NBR | 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 |