2. Standardized Employment Data
Data preparation requires pulling a complete dataset from your payroll system each month, starting from the project’s first month through to the current month.
Do not just add the new month’s data onto last month’s spreadsheet.
Each monthly submission must be a full re‑export from payroll, which will include:
All previous months’ payroll records,
Any updates or corrections (such as newly assigned Pehta People Codes applied to past records), and
The most recent month’s data.
This process ensures that every submission reflects the most accurate and up‑to‑date dataset available.
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 or Unique Identifier (Please include the 12-digit Pehta People Code or a unique 6-digit alphanumeric code. This is required to ensure accurate headcount analysis.) (NEW FIELD IN YOUR ACCOUNTING SYSTEM)
Is Training (This is to denote that the hours and Wages associated with this line was related to training).
Is Trainer (This is to denote that the training noted above - the individual was performing the training)
This data is to be uploaded to Pehta Portal as a .xls/.csv file.
Please use the following template for each upload. This is the only acceptable format: link.
Sample sheet:
