CAN_TAX_PROVNCT

(SQL Table)
Index Back

CAN Provincial Net Claim Table

Provincial Net Claim amounts for income surtax calculation.

  • Parent record: CAN_TAX_PROV
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    2 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    3 CIT_NCA Number(10,2) DECIMAL(9,2) NOT NULL Net Claim Amount Threshold
    4 CIT_Y Number(8,2) DECIMAL(7,2) NOT NULL Provincial Tax Reduction (Y)