Data Completeness

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 Nisto 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 Data

The necessary payroll data must be laid out with the following columns:

• Project Name

• Date

• Hours Worked (count)

• Occupation / Trade (Name or NOC Code)

• Gross Wages ($)

• Nisto People Code or Unique Identifier

  • A Unique Identifier is used in the absence of a Nisto People Code and may be any 6‑digit alphanumeric code. Each payroll line must include either a Nisto People Code or a Unique Identifier. Both must be unique to a single employee and cannot be shared across individuals.

    In practice, most projects begin with Unique Identifiers assigned to all employees. As employees complete the survey, their Unique Identifier is replaced with their permanent Nisto People Code.

• New Hire (Yes / No)

This data is to be uploaded to Nisto Portal as a  .csv file.

Please use this workbook data sheet for all employment data submissions: Link