SCHEDULE_SE

(SQL Table)
Index Back

Self_Employment Tax

Data Collection for Schedule SE

  • Parent record: VERIFICATION
  • # 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