INJ_ILL_WI_CAN

(SQL Table)
 Index Back

Wage Inclusions - Canada

Injured Worker's wage inclusions - details of items included in regular salary

  • Related Language Record: INJ_ILLWI_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID
    5 WAGE_INCLS_CD Character(2) VARCHAR2(2) NOT NULL Wage Inclusion
    10=Rental
    20=Equipment
    30=Other
    41=Other Earnings Commission
    42=Other Earnings Piecework
    43=Other Earnings Bonus
    44=Other Earnings Flat Rate
    45=Other Earnings Regular
    6 TIME_PERIOD_CD Character(1) VARCHAR2(1) NOT NULL Time Period
    B=Biweekly
    D=Day
    H=Hour
    M=Month
    Q=Quarter
    S=Semi-monthly
    T=Ten-monthly
    W=Week
    Y=Year
    7 INCLS_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Wage Inclusions Amount
    8 DESCRLONG Long Character CLOB Long Description