CAN_AMEND_T4_D

(SQL Table)
 Index Back

Amend T4 box

Reporting Slip Box level detail for amending T4.

  • Parent record: CAN_AMEND_T4_S

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    4 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
    5 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
    6 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
    7 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    8 CAN_YE_SLIP_SEQ Number(2,0) SMALLINT NOT NULL This is the Canadian year-end slip sequence number. For T4 and T4A, they have a slip sequence number of 0 (default value). As for RL-1 and RL-2, if a box amount exceeds maximum box amount allowed by MRQ, additional slip will have incremental slip number.
    9 BOX Character(4) VARCHAR2(4) NOT NULL Box

    Prompt Table: T4_TAXFORM_VW

    10 CAN_YE_BOX_TEXT Character(11) VARCHAR2(11) NOT NULL Canadian YE Slip Box Text
    11 PRV_AMOUNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous Amount
    12 CORRECTED_AMOUNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Corrected Amount