TAXFORM_TAX

(SQL Table)
 Index Back

Taxform Tax Definition

Defines taxes used to compute the value for box.

  • Parent record: TAXFORM_BOX

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
    A=T4A Slip
    B=Business Payrolls Survey - CAN
    C=WCB Assessable Earnings
    E=Record of Employment
    F=940 - Annual Employer's FUTA
    I=W-2VI
    J=W-2cVI
    M=W-2GU
    N=W-2cGU
    P=W-2PR
    Q=W-2cPR
    R=RL-1 Slip
    S=W-2AS
    T=T4 Slip
    U=W-2cAS
    V=RL-2 Slip
    W=W-2
    X=W-2c
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 BOX Character(4) VARCHAR2(4) NOT NULL Box
    4 JURISDICTION_TYPE Character(1) VARCHAR2(1) NOT NULL Jurisdiction Type
    F=Federal
    L=Local
    S=State
    5 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    6 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: LOCAL_TAX_TBL

    7 TAX_CLASS Character(1) VARCHAR2(1) NOT NULL Tax Balance Class
    8 AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Amount Type
    G=Gross
    M=Minus Tax
    N=No-Limit Gross
    T=Tax