PY_CEWS_CO_DEF

(SQL Table)
Index Back

CEWS company definition table

Canada Emergency Wage Subsidy company definition table.

  • Parent record: PY_CEWS_DEF_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_CEWS_START_DT Date(10) DATE NOT NULL Claim Period Begin Date
    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_VW

    3 PY_CEWS_SUB_PCT Number(6,3) DECIMAL(5,3) NOT NULL Subsidy Percent
    4 PY_CEWS_WKLY_AMT Number(11,2) DECIMAL(10,2) NOT NULL Subsidy Per Employee
    5 PY_CEWS_14_DAYS Character(1) VARCHAR2(1) NOT NULL Apply 14 Day Exclusion Rule

    Y/N Table Edit

    Default Value: N