PAY_TAX_CAN_VW

(SQL View)
 Index Back

CAN Payroll Province Info

This record contains employee paycheck tax information for Canadian payroll.

SELECT DISTINCT COMPANY ,PAYGROUP ,PAY_END_DT ,OFF_CYCLE ,PAGE_NUM ,LINE_NUM ,SEPCHK ,PROVINCE ,WAGE_LOSS_PLAN ,MAX(UI_ER_RT) FROM PS_PAY_TAX_CAN GROUP BY COMPANY ,PAYGROUP ,PAY_END_DT ,OFF_CYCLE ,PAGE_NUM ,LINE_NUM ,SEPCHK ,PROVINCE ,WAGE_LOSS_PLAN

  • Parent record: PAY_CHECK

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

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    8 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    9 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
    10 UI_ER_RT Number(6,4) DECIMAL(5,4) NOT NULL EI Employer Rate