CAN_AMEND_RL1_S

(SQL Table)
 Index Back

Amended/Cancelled RL-1 slip

Reporting Slip level data for amended/cancelled RL-1. Information common to or about the slip is recorded here.

  • Parent record: CAN_YE_AMEND_E

    • # 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 REPORTING_ID Character(16) VARCHAR2(16) NOT NULL Tax Reporting ID
    10 UI_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from EI Premiums
    A=UI Based On Yearly Calculation
    A=UI Based On Yearly Calculation
    E=Calculation Based on EI Rates
    N=UI Based On Pay Period Rules
    N=UI Based On Pay Period Rules
    Y=Exempt From EI Premiums
    11 RELEVE_SLIP_NO Character(9) VARCHAR2(9) NOT NULL RL-1 Slip Number
    12 PROVENANCE Character(6) VARCHAR2(6) NOT NULL RL-2 Provenance
    13 PROVENANCE2 Character(6) VARCHAR2(6) NOT NULL RL-2 Provenance 2
    14 RELEVE2_SLIP_NO Character(9) VARCHAR2(9) NOT NULL RL-2 Slip Number
    15 EMPLOYMENT_CODE Character(2) VARCHAR2(2) NOT NULL Employment Code
    11=Placement Agency-Self-Employed
    12=Taxi Driver/Psgr-Carry Vehicle
    13=Barber or Hairdresser
    14=Withdrawal-Deferred Salary Pln
    15=Seasonal Agricultural Wrkr Pgm
    16=Detached EE-Soc Sec Agreement
    17=Fisher
    16 SIN_CONTRB_SPOUSE Character(9) VARCHAR2(9) NOT NULL Spouse SIN
    17 NAME_CONTRB_SPOUSE Character(12) VARCHAR2(12) NOT NULL Spouse Last Name
    18 YE_PROC_TYPE Character(1) VARCHAR2(1) NOT NULL YE Process Type
    A=Amend Slip
    C=Cancel Slip
    D=Delete Slip
    N=Reissue New Slip

    Prompt Table: PROC_TYPE_RV_VW

    19 AMEND_STATUS Character(1) VARCHAR2(1) NOT NULL Amend/Cancel Status
    C=Closed
    O=Open
    V=Void