2. Standardized Employment Data
Data preparation involves compiling data from your project's inception to the current monthly submission date. Specifically, the initial submission will encompass data from the first month. Subsequent monthly submissions will include data from the corresponding month.
Data Requirements
The data that is required can be easily exported from most CRM/Accounting and Payroll systems.
Employment
The necessary payroll data must be laid out in the following way:
Project Name
Date
Hours Worked
Occupation / NOC
Gross Wages
Pehta People Code (NEW FIELD IN YOUR ACCOUNTING SYSTEM)
Unique Identifier (Please include a unique 6-digit alphanumeric code. This is required to ensure accurate headcount analysis.) (NEW FIELD IN YOUR ACCOUNTING SYSTEM)
Salary / Hourly (Optional)
New Hire (Yes / No) - Optional
Off Site (Yes / No) - Optional
Apprentice / Trade (1,2,3,4, Journeyperson, Redseal) - Optional
Rate ($/unit) - Optional
This data is to be uploaded to Pehta Portal as a .csv file.
Please use the following template for each upload. This is the only acceptable format: link.
Sample sheet:
| Project Name | Date | Hours / Days | Occupation / NOC | Gross Wages for Period | Pehta People Code | Unique Identifier | New Hire (Optional) | Off Site (Optional) | Apprentice / Trade (Optional) | Generalized Occupation Level (Optional) | Rate (Optional) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Wildfire Salvage Project | 01-Jun-23 | 76 | Carpenter | $1,729.00 | sdd8979vds | 123547 | Front Line Worker | $22.75 | |||
| Wildfire Salvage Project | 01-Jun-23 | 76 | Operator | $1,976.00 | df54bf51bfb | 123548 | Front Line Worker | $26.00 | |||
| Wildfire Salvage Project | 01-Jun-23 | 76 | Foreman | $2,009.44 | 58vdv78d9s | 123549 | Yes | Middle Management | $26.44 | ||
| Wildfire Salvage Project | 01-Jun-23 | 76 | Electrician | $1,729.00 | sc8d7f9sd9 | 123550 | Front Line Worker | $22.75 | |||
| Wildfire Salvage Project | 01-Jun-23 | 76 | 72310 | $1,729.00 | dc989dds9 | 123551 | 1 | Front Line Worker | $22.75 | ||
| Wildfire Salvage Project | 15-Jun-23 | 76 | 72310 | $1,927.36 | 123552 | Front Line Worker | $25.36 | ||||
| Wildfire Salvage Project | 15-Jun-23 | 76 | 72310 | $3,055.20 | 123553 | Front Line Worker | $40.20 | ||||
| Wildfire Salvage Project | 15-Jun-23 | 76 | Carpenter | $1,729.00 | vdhjf54bfg5 | 123554 | Yes | Front Line Worker | $22.75 | ||
| Wildfire Salvage Project | 15-Jun-23 | 76 | Carpenter | $2,033.00 | gnfb574dv5 | 123555 | Front Line Worker | $26.75 | |||
| Wildfire Salvage Project | 15-Jun-23 | 76 | Carpenter | $1,786.00 | bn45bf4b5n | 123556 | Journeyperson | Front Line Worker | $23.50 | ||
| Wildfire Salvage Project | 15-Jun-23 | 76 | Carpenter | $1,729.00 | sdd8979vds | 123547 | Front Line Worker | $22.75 |