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
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:
Date
Project Name
Rate
Hours Worked
Gross Wages
Occupation / Trade
New Hire
Nisto People Code
This data is to be uploaded to Nisto Portal as a .csv, .xlsx, or .xls file.
To see a sample data set of what we expect to see - please download it here: Link
Procurement
The necessary procurement data must be laid out in the following way:
Company Name
Type of Offering (Goods, Service or Material)
Cumulative Procurement Value ($)
Category of Social Value Supplier (Social Enterprise, Indigenous Business, Diverse-Owned Business, Social Purpose)
Vendor Certification (Third-Party Certified, Self-Attestation, other)
Vendor Certification Proof (Yes Submitted to Liasion, No)
Any Additional Text
This data is to be emailed as a .csv, .xlsx, or .xls file.