4. Data Preparation

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.

Data Requirements

Download the EIDA data upload template here and follow the instructions below: Link

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

The necessary payroll data must be laid out as column headers:

• Date

• Project Name

• Offsite (Yes or Blank)

• Hours Worked

• Apprenticeship Level / Status (1, 2, 3, 4, Journeyperson, Red Seal, or Blank),

• Occupation / Trade

• 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.