5. Data Preparation

Data Completeness

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 cumulatively include data from all preceding months in addition to the new month's data. For instance, the second monthly submission will contain data from the first and second months, while the third will aggregate data from the first three months. This process ensures that with each submission, the dataset will expand to incorporate all prior data plus the data from the latest month. This also ensures that the most recent submission captures previous months’ corrections to the dataset.

Data Requirements

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

The data that is required can be easily exported from most CRM/Accounting and Payroll systems.

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