CAN_USR_TAX_PRV

(SQL Table)
Index Back

CAN Client Prov Tax Parameters

Calculation formula parameters for income tax surtax and other provincial taxes.

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

    Prompt Table: COMPANY_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

    Prompt Table: STATE_TBL

    4 PPT_PCT Number(5,2) DECIMAL(4,2) NOT NULL Provincial Premium Tax Percent
    5 HEALTH_INS_RT Number(8,6) DECIMAL(7,6) NOT NULL Health Insurance Rate