CAN_YE_AMEND_E

(SQL Table)
 Index Back

Amended/Cancelled employee

Highest level record for Canadian Year End amended/cancelled employee data. Data common to all slips is recorded here -- e.g. name.

  • Parent Record Of CAN_AMEND_RL1_S CAN_AMEND_RL2_S CAN_AMEND_T4A_S CAN_AMEND_T4_S

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    3 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    4 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
    5 SIN Character(9) VARCHAR2(9) NOT NULL Social Insurance #
    6 SLIP_SURNAME Character(30) VARCHAR2(30) NOT NULL Surname
    7 SLIP_FIRST_NAME Character(12) VARCHAR2(12) NOT NULL First Name
    8 SLIP_INITIAL Character(1) VARCHAR2(1) NOT NULL Middle Initial
    9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

    Prompt Table: %RECNAME_EDIT

    13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    16 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    17 MAIL_DROP Character(50) VARCHAR2(50) NOT NULL Mail Drop ID
    18 DECEASED Character(1) VARCHAR2(1) NOT NULL Deceased

    Y/N Table Edit

    Default Value: N

    19 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: JOB.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

    20 DELETE_RECORD Character(1) VARCHAR2(1) NOT NULL Delete Record from Query

    Y/N Table Edit

    Default Value: N

    21 COMMENTS Long Character CLOB Comment