Drinking Water and Wastewater Data Management System

Drinking Water and Wastewater Data Management System

This requirement is for: The Correctional Service of Canada (CSC) institutions Nation wide.

Trade agreement:

Free Trade Agreement (CFTA), World Trade Organisation-Agreement on Government Procurement (WTO-AGP), Canada Ukraine Free-Trade Agreement (CUFTA), Canada Korea Trade Agreement (CKTA), Canada free trade agreements with Chile/Colombia/Honduras/Panama, Canada-Peru Free Trade Agreement, Canada-European Union Comprehensive Economic and Trade Agreement (CETA) and Canada-United Kingdom Trade Continuity Agreement (Canada-UK TCA), Comprehensive and Progressive Agreement for Trans-Pacific Partnership (CPTPP)

Tendering procedures:

All interested suppliers may submit a bid.

Competitive Procurement Strategy:

Lowest priced compliant bid

Set-aside under the Procurement Strategy for Indigenous Business:

This procurement is not subject to any set-asides for Aboriginal Suppliers.

Comprehensive Land Claim Agreement:

This procurement is not subject to a Comprehensive Land Claims Agreement.

Security Requirements:

This contract does not include security requirements.

Nature of Requirements:

The following is a summary of the statement of work for this requirement.

The Correctional Service Canada must continuously monitor its drinking water and wastewater analytical results to ensure drinking water is safe for consumption and wastewater effluents meet all regulatory requirements. In order to effectively do so, CSC requires access to a web-based drinking water and wastewater data management system.

Objectives:

To provide a web-based data management system to record drinking water and wastewater data to enable its staff to effectively monitor the results from an Institutional, Regional, or National level. The Contractor must deliver the data management information service securely over the Web, requiring no information technology other than standard web browsers and internet access. The data system must not require CSC to purchase, install and maintain special servers, network hardware, or PC software. The Contractor must provide a data management system that CSC can use with its existing software and IT equipment. The Contractor must provide a complete and fully functional web-based data management system that meets all of CSC’s requirements.

Deliverables:

The drinking water and wastewater data management system must:

1. Be the sole property of the hosted solution service provider.
2. Be web-based so it can be accessed from any computer with internet access.
3. Be fully functional in English and in French.
4. Have all its required data storage and management hardware and software physically located within Canada.
5. Be available and ready for configuration immediately upon Contract award with no development, or other start up delays, costs, or risks.
6. Be able to perform a full data export and data back up for a 12-month time frame after contract end date.
7. Allow the importation of existing data and integration of historical drinking water and wastewater laboratory and operational data.
8. Contain at least three hierarchical levels of user accounts, as shown below:
i. Level 1 - Administrator: this account level must give full data access including modification privileges to all data and the ability to create accounts;
ii. Level 2 – User: this account level must give full data access and modification privileges to the data sets as assigned by the Administrator, and
iii. Level 3 – Viewer: This account level must give viewing privileges of the data sets assigned by the Administrator.
9. Have user accounts that are password protected. The password must be a minimum of 4 and a maximum of 15 alpha numeric characters.
10. Generate unique sample identification codes for each sampling location. The users must be able to enter a sampling location description for each identification code.
11. Generate automatic alerts (via email or text) to applicable users whenever a result is exceeding the prescribed maximum acceptable concentration or is missing.
12. Allow users to customize the information contained in the alerts based on their preferences. As a minimum, the alert information must include: the name of the parameter, result, alert type, alert level, sample collection date and time, institution name, system name, sampling point name, sampling point comments, analysis/result comment, laboratory name, sample collector name, alert recipient names, related guideline or regulation and link to additional parameter information.
13. Generate and deliver automatic alerts to the Level 1 - Administrator for undefined alerts. Such alert advises the Administrator that there is no alert level set for a certain parameter in the system.
14. Provide a comment box, in response to alerts, to allow staff to enter text information related to the alert and close it upon satisfactory resolution.
15. Contain templates for the creation of data report by hierarchy level (i.e., sample point, building, water source (raw, treatment, distribution), system, institution, and regional and national headquarters). The templates must also allow the grouping of data by, but not limited to, parameter (individual or groups), analysis method, alerts, time frame, tester and sample collector, sample comments, laboratory report number, name of the laboratory, etc.
16. Contain drinking water quality and wastewater standards/guidelines for all provinces in addition to Health Canada’s “The Guidelines for Canadian Drinking Water Quality” most recent edition. This information must be kept up to date and incorporate any changes to the provincial and/or federal guidelines/regulatory limits.
17. Contain an up-to-date index for all drinking water parameters with a Health Canada Maximum Allowable Concentration and conventional wastewater parameters. For each parameter, the index must include a description of the parameter, the current standards and guidelines and regulations, and details on potential health and environmental impacts. This reference information must be included as a hyperlink in all alerts issued.
18. Allow users to create sampling schedules and track recurring and stand-alone sampling events with reminder email alerts.
19. Contain templates for to help users to monitor the completion rate of planned sampling event.
20. Contain electronic worksheets to allow data entry directly into the system and also worksheets that can be printed to record data in the field/site (temperature, flow, pH, etc.).
21. Allow the production of custom sample bottle labels. The labels must include the department, region, type of sample (drinking water or wastewater), institution, sample point name, sampling point locator code and unique bar code.

Any conditions for participation of suppliers not specified in solicitation documentation: none.

Estimated quantity of commodity: see solicitation document statement of work and basis of payment.

Duration of the Contract and Time Frame for Delivery:

Period of the Contract: The Work is to be performed during the period of contract award to 3 year later with the option to renew for two (2) additional one-year periods.

File Number: 21120-24-4572674

Contracting Authority: Stéphanie Gigoux
E-mail: stephanie.gigoux@csc-scc.gc.ca

NOTE TO BIDDERS:

Bidders can obtain the complete statement of work and evaluation criteria by downloading the solicitation document and associated documents from the Canada buys / tender opportunities website.

The Crown reserves the right to negotiate with suppliers on any procurement.

Documents may be submitted in either official language of Canada (English or French).

After contract award, bidders may request a debriefing on the results of the bid solicitation process. Bidders should make the request to the Contracting Authority within fifteen (15) working days of receipt of the results of the bid solicitation process. The debriefing may be in writing, by telephone or in person.

Procurement Assistance Canada (PAC) offers seminars to businesses interested in learning how to sell goods and services to the Government of Canada. The seminars are FREE.

Topics include:
 Overview of the federal government contracting process;
 Searching for opportunities on the Buy and Sell - Tenders website;
 Bidding on opportunities;
 Registering in supplier databases.

The full schedule of seminars can be found on the Buyandsell.gc.ca website, under Event Calendar (https://buyandsell.gc.ca/event-calendar).