Product Requirement Document: Treatment Quality Monitoring (TQM)

Introduction

The waste value chain has 5 main stages:

1. Generation

2. Containment

3. Transport

4. Treatment

5. Reuse

For effective waste management, all of these stages need to be focused on. For example, improper containment of Faecal Sludge can lead to percolation of chemicals into the groundwater and its contamination, or ineffective transportation management can lead to waste being dumped illegally into surface water or land. Similarly, an essential part of effective waste management is the proper treatment of Waste.

Ineffective treatment of waste and its discharge into the environment has a direct adverse impact on the environment and water quality. Effluents are often discharged into surface water sources. The poor quality of wastewater effluents is responsible for the degradation of the receiving surface water body and the health of its users.

Quality and re-use have a direct relationship: Treated waste output can be reused, be it recycled water or as compost. Acceptance of this by consumers will largely depend on its quality and the value it provides. Nobody wants water in their flush that stinks, or manure that does not fertilise plants enough.

Currently, there is little to no visibility of how waste is being handled and treated at the treatment plant. Keeping this in mind, a Treatment Quality Monitoring (TQM) will be introduced as an extension to DIGIT Sanitation.

Objective

The objective is to improve the quality of treated waste

Our hypothesis of how treatment quality can be improved is as follows:

1. Define Treatment Processes and Testing Requirements: Mapping of plants and treatment processes will allow for a consolidated view to the state/TSUs/stakeholders of the treatment processes operational at plants. Additionally, this will allow for the definition of treatment requirements, frequencies and benchmarks at the state level for various processes and its adoption by plants. This further allows for analysis at the process level of treatment quality, and provides insights for improvements overtime.

2. Ensure Regular Testing: Operationalising regular and high-frequency testing will allow for the detection of deviations from benchmarks at the earliest.

3. Quick Issue Resolution: Identification of deviations and its diagnosis via an analysis of current and historical data will allow for quick issue resolution.

4. Deepen Enquiry: Is a particular plant consistently performing badly? Is a particular treatment process regularly leading to poor quality output? Which step in the process flow is the deviation starting from? Do quality test results fluctuate often? Looking at trends in data can help deepen enquiry and identify problem areas.

Improvement in processes or a need for further enquiry can be operationalised by redefining treatment processes and testing requirements.

Definitions

Plant	A facility that takes raw materials as inputs and converts them into a set out expected outputs through a series of setup processes and with the use of equipment operated by people.
Treatment Process	Sequential series of steps required to translate input to output.
Stages	Each step within the treatment Process. Each job may have one or many input quality parameters and one or many output quality parameters.
Assets	Physical infrastructure required to execute a job in a treatment Process
Parameters	Criteria used to measure input and output for a job. Each parameter will have a unit of measurement.
Frequency	The duration of time between two subsequent tests
Benchmarks	Acceptable value ranges for each parameter
Testing Standards	A combination of a Parameter, acceptable benchmark of the parameter and its frequency of testing. For example, ph >= 7 tested weekly

Success Criteria

Goal	Category	Objective	How will it be measured via the product	How will we know TQM is successful
Zero deaths, diseases, and environmental contamination resulting from poor sanitation	Primary	To ensure treated waste is as per the quality standards	The percentage of plants with output quality is as per benchmarks	Increase in the percentage of plants with output quality as per benchmarks over time
Zero deaths, diseases, and environmental contamination resulting from poor sanitation	Secondary	To ensure treated waste is tested regularly for quick identification of issues	The percentage compliance against testing schedule	Increase in the percentage compliance against testing schedule over time

Design Guidelines

1	The TQM module should be configurable for multiple waste streams such as faecal sludge, solid waste, medical waste, waste water etc.
2	The TQM module should be usable by itself without the need to set up/deploy the rest of the DIGIT FSM modules
3	In the design of DIGIT Sanitation v1.3, treatment plant operators are employees of a ULB Based on our learnings, treatment plants can be managed by: Self-help groups (as in the case of Orissa and Trichy, Tamil Nadu). In such a case, a member of the SHG performs the role of a treatment plant operator. Direct employees of the ULB (as in the case of some plants in Tamil Nadu). Vendors who were outsourced on a build and manage model. Which requires the capability to enable vendors and individuals to be able to manage the operations, access and use the system.
4	Currently, in the product, there is a 1-to-1 mapping between ULBs and plants. The TQM module should allow for tagging as per the following: Many plant - 1 boundary 1 boundary - 1 plant Multiple boundaries - 1 plant
4	There are multiple operating models when it comes to lab testing and O&M of a treatment plant. Roles in the system need to be defined to support various operating models. Case 1: The treatment quality workflow defined in the PRD has two steps: Submission of sample to a lab Uploading test results In the case of Orissa, where labs for testing the quality of treated waste are in-house, both these workflow steps are performed by the same person. However, in Tamil Nadu, testing is outsourced to a central lab for 3 or 4 plants. In this case, the functionality to record test results will be provided to the labs.

Proposed Solution

Given the objective to improve quality of treated waste and the steps required to achieve it, the following are needed at each stage:

Keeping this in mind, the following components will be available in the TQM module:

Components	Description	Functionality
Schedule of Tests	This component will be used by treatment plant operators and ULB employees to see the schedule of tests	View schedule of Lab tests and track compliance. Track compliance of IoT test results and cases of failures.
Recording Test Results	This component will be used by treatment plant operators and ULB employees to upload results manually and track IoT readings	Create digital records of quality test results Alerts in the following cases: IoT device not working Lab results do not match IoT results
Anomaly Detection	This component will be used by treatment plant operators and ULB employees to interpret test results	Identify in real-time/near real time when results of a particular test are not as per benchmarks. Alerts in the following cases: Results not upto benchmark
Dashboards	This module will give stakeholders insights and information regarding operations of the treatment plant. Users can use this to drill down and identify plants and processes where compliance to testing and/or test results are not upto benchmarks. Dashboards will also help users see trends over time to see patterns and identify long-term problem areas.	Dashboard to analyse trends in treatment quality and compliance with treatment schedule. Drill-down will be made available from state to ULB and to a plant level. Dashboard to analyse patterns in issues. Drill-down will be made available from state to ULB and to a plant level.

The aim of the modules is to provide the users of the system information and control at each level - from defining how operations will be run, to updating status against pending operational tasks and viewing operational data to draw insights to refine operations.

What is the value being generated?

Through the above, we are looking to address the following challenges:

Category	Challenge	How will the product address?
Informational	No knowledge of treatment and disposal processes	Awareness on when waste has to be tested and for which parameters.
Changing Standards for treated waste	Operationalising changing standards of waste by configuring additional parameters/frequency for testing.
Operational	No record keeping of waste quality	Record and maintain digital records of treatment quality.
No mechanism to monitor treatment Plant operators	Track and measure compliance against testing schedule.
No clear definitions of responsibilities for the ULB	Setup via roles who are responsible for quality testing and issue resolution.

The following value will be created for users:

User	Value Bundle
State administration/Pollution control board/Stakeholders (DDWS, WATSAN boards, WATCO etc)	Ease of monitoring treatment quality, treatment quality trends and detect variations across plants. Ease of monitoring and ensuring compliance to quality treatment schedule across plants. Ability to change testing parameters and frequency basis test results across plants/for a particular plant.
Urban local body	Ease of monitoring treatment quality and treatment quality trends and detect variations. Ease of monitoring and ensuring compliance to quality treatment schedule. Centralised view of issues across plants. Ability to change testing and maintenance frequency basis test results.
Treatment plant operators/Vendors managing treatment plants	Timely reminders to perform testing. Ease of sharing records with ULB/stakeholders.

Scope

Treatment Quality Monitoring Workflow

The objective of the treatment quality module is to allow data observability of the parameters of treatment quality to improve the performance of the treatment plant. There are two ways to capture data:

1. Manual input.

2. Automated capture of test results via configured IoT sensors. While the use of sensors reduces manual intervention in the process, the availability of infrastructure on the ground is a challenge.

Once the initial setup is done, the following image illustrates how the system will be used to monitor treatment quality:

Identified gaps:

1. Irregularity in laboratory testing.

2. Unavailability of actionable information on quality.

The flow will be as follows:

The scope of the Treatment Quality Module is as follows:

1. Register Testing Standards

A plant may have one or multiple treatment processes. For example:

1. An FSTP is dedicated to the treatment of faecal sludge such as the aerobic treatment process.

2. A co-treatment plant has two treatment processes: Faecal sludge and septage together.

A treatment process has multiple stages/steps. In case of a plant with multiple processes, stages may converge.

Define input/output quality testing requirements:

Each stage may have multiple input types and output types (for example, effluents and biosolids), and each stage may need to have the input and output quality tested for each of the input and output types.

The state and the ULB admin should be able to perform the following actions:

• Define if one or many Input types needs to be tested for a particular stage.

• Define if one or many output types need to be tested for a particular stage.

• Enable/disable testing of a particular input/output type for a particular stage.

The UI screen for this should be enabled with the launch of workbench.

Define testing parameters, benchmarks and frequency:

• Testing parameters and benchmarks are set at the national/state level and adhered to by plants. However. based on the geographical location, the benchmarks may vary.

• Testing frequencies are set at the state level and adhered to by plants. These may be adjusted for plants, basis testing results.

• Each output and input type will have one or more testing standards (parameters, benchmarks, and frequency). For example, for output type ‘effluent’, one may need to test PH (daily), BOD (weekly) and COD (weekly).

• For a particular plant, testing will be done by one or multiple methods including:

- Manual testing in a lab

- Testing via IoT devices

The frequency of this will be different.

The state and the ULB admin should be able to perform the following actions:

• Define one or multiple testing standards (parameter, benchmark, and frequency) at an instance level.

• Edit testing Standards (parameter, benchmark, and frequency) for a plant.

• Define different standards for manual and IoT-based testing for a particular input/output type for a stage.

This does not require a UI screen.

1. Generation of Schedule

Schedule for tests will be auto-generated for various parameters based on the frequency.

For manual tests, the schedule will be used to:

• Display a list of upcoming tests to the plant operator and stakeholders.

• Generation of alerts for upcoming tests.

• Escalation in case of non-adherence to the test schedule.

For IoT tests, the schedule will be used to:

• Generate alerts in case a reading is not received as per the schedule.

Workflow:

Generation of Schedule: For the generation of schedule of testing:

For manual testing:

a. For 1 particular stage of the treatment process:

1. Multiple parameters that have the same frequency to be combined to one test.

2. For parameters with different frequency, different tests should be created.

b. For 2 different stages of the treatment process:

1. The same parameter with the same frequency will be two different tests.

For IoT testing:

a. Multiple parameters captured by the same device will be a single test.

View Schedule:

The schedule will be available for view and action to the following users:

a. For Labs

1. ULB employee: [X] days prior to test date (Inbox). [X] here is configurable.

2. Treatment plant operator: [Y] days prior to test date (Inbox). [Y] here is configurable.

3. Treatment plant operator: [Z] days prior to test date (as a pending task in the UI). [Z] here is configurable.

4. Tests will continue to remain in the inbox/pending tasks list as long as test results are not submitted.

b. For IoT Testing:

1. No schedule will be displayed to users.

2. Generation of alerts in case reading is not received as per schedule.

Escalations:

For Manual Testing: Escalations are triggered in the following case via an in-app alert:

Role	Escalation
Governing Body + ULB employee	Test results pending beyond [X] days as per test schedule

Record Test Results:

Test results may be recorded in 2 ways:

1. Manual Recording by user (lab testing).

2. Automated recording via integration with IoT device.

For Manual Recording (Lab Testing)-

Recording of test results will be done by the user in two cases:

1. Recording results against schedule.

2. Recording Results on demand: Adhoc tests conducted/instructed by governing authorities.

Recording Results Against Schedule-

The process flow will start with the treatment plant operator receiving a notification regarding an upcoming test. The following is the process flow for the manual recording of test results:

Recording Results: Workflow

Test Result Status	Roles	Action	Next Status
Scheduled	FSTPO ULB employee	Submit sample for testing	Pending results
Pending results	FSTPO ULB employee	Update Results	Submitted

1. The status of a scheduled test is auto set as “Scheduled”.

2. The sample has to be submitted to the lab (internal or external) for testing. The status of the same will be updated in the system by the user to “Pending Results”.

3. On recording test results, the status will be updated to “Scheduled”.

Recording Results On Demand-

The functionality will be made available to the record results on demand to the user.

1. No workflow will be available in case of recording results on demand.

2. The user will be able to record results by filling a form.

3. Selection of a lab used for testing is optional in this case.

4. Status of submitted results will be set as ‘Submitted’.

Automated Recording Via Integration with IoT Device-

In case of integration with IoT devices, results against scheduled tests will be recorded. Alerts in case of non upload are mentioned in the alerts section below.

Anomaly Detection:

Anomalies will be generated in case of the following:

1. Lab results not as per the benchmark.

2. IoT device results are not as per the benchmark.

3. Lab results and device results do not match.

4. Device not working.

Lab results not as per the benchmark-

This is to be generated when the manual test results uploaded by the test uploader are not as per the benchmarks defined (adjusted for deviations, configurable at plant level).

IoT results not as per the benchmark-

This is to be generated when the loT test results recorded via the integration are not as per the benchmarks defined for [X] days (adjusted for deviations defined while setting testing parameters).

Generation of alerts: Device results and lab results do not match-

In case the data that is recorded by the sensor does not match the data in the lab test result, an auto alert will be generated.

Date to be matched on	Sample collection Date If IoT result is not available for the sample collection date, the closest date after for which the IoT data is available will be considered
Deviation allowed	X%

Generation of alert: No reading received from the device-

In case no reading is received from the sensor based on the schedule, an auto alert will be generated in the system.

Treatment Quality Monitoring: Functional Specifications

1. Treatment Process

Attribute	Type	Mandatory	Comments	Validation Required?
Treatment Process ID	Numeric	Y	Auto-generated numeric value which will act as a unique identifier for a process flow	N, this value should be system generated
Process Name	Text	Y	This is the commonly used identifier for the process flow	Max characters - 256
Status	Array	Y	Status of the process flow	Active/Inactive, Single Select
Treatment Process Type	Array	Y	The dropdown will be auto populated basis the list of waste maintained in the MDMS	Single Select
Treatment Process Subtype	Array	Y	The dropdown will be auto populated basis the list of waste maintained in the MDMS	Single Select

1. Plants

Attribute	Type	Mandatory	Comments	Validation Required?
Plant ID	Numeric	Y	Auto-generated numeric value which will act as a unique identifier for a plan.	Auto-generated
Plant Name	Text	Y	This is the commonly used identifier for the plant	Maximum charatcters - 128
Plant Type	Array	Y		Single select only, faecal sludge, solid waste, co-treatment
Tenant Id	Text	Y
Status	Array	Y	Status of the plant	Active/inactive, single select
Geolocation	Lat,Long	Y		Capture the exact latitude-longitude

1. Stages

Attribute	Type	Mandatory	Comments	Validation Required?
Stage ID	Numeric	Y	Auto-generated numeric value which will act as a unique identifier for a Job ID	Auto-generated
Stage Name	Text	Y	This is the commonly-used identifier for the Job	Maximum characters - 128 Minimum xharacters - NA
Status	Boolean	Y	Status of the stage	Active/inactive, single select
Input Quality Measurement Required	Boolean	Y	This selection will allow the user to set up if the input quality for the particular input type needs to be monitored. A user should be able to enable and disable input quality measurement requirement independently for each type	Yes/no, single select
Output Type	Array	Y	The dropdown will be auto-populated basis the list of output types	Multi-select
Output Quality Measurement Required	Boolean	Y	This selection will allow the user to set up if the output quality for the particular job needs to be monitored. A user should be able to enable and disable the output quality measurement requirement independently for each type	Yes/no, single select

1. Testing Parameters

Attribute	Type	Mandatory	Validation
Quality Parameter	Array	Y	Selecting from the predefined of the above-mentioned quality parameters and standards. single select
Quality Parameter Unit of Measurement	Array	Y	Selection of the unit of measurement (mg/L, Absolute value etc). Single select
Benchmark Rule	Array	Y	Options include X>=,<=R, =<Y and >=Z, single select
Benchmark Value	Numeric	Y	Entered by user, numeric only
Testing Frequency - Manual (Days)	Numeric	Y	Selecting a custom frequency range for laboratory testing based on consent to operate, numeric only
Monitoring Frequency - Quality Sensor (Days)	Numeric	N	Selecting a custom frequency Note: Should be optional if the ULB/state choses not to have sensor-based monitoring. Numeric only

1. Configure IoT Devices

Attribute	Type	Required?	Comments
Configuration Date	Datetime	Y
Device Type	Text	Y	Selection from the device master data [“GPS Sensor”, “pH Sensor”, “Accelerometer”, “Light Sensor”]
Plant	Text	Y
Treatment Process	Text	Y
Stage	Text	Y
Output Type	Text	Y
Parameters	Array	Y	The parameters are monitored by the device
Monitoring Frequency	Numeric	Y	Custom frequency for the device
Calibration Date	Datetime	Y	Input from the user about any change in the calibration/maintenance of the device
Calibration Accuracy	Array	Y	Range to indicate the permissible deviation in the accuracy
IsConnected?	Boolean	Y	To indicate the connectivity of the device
Connectivity History	?	Y	Date-wise device audit log to know the connectivity status
Verification History	?		Date-wise device verification log to know the days when device input was verified with laboratory results

1. Testing Schedule

Attribute	Type	Mandataroy	Validation
Test ID	Alphanumeric	View only	Auto-generated on the creation of schedule
Plant Name	Text	View only	Auto-populated on the creation of schedule
Treatment Process	Text	View only	Auto-populated on the creation of schedule
Treatment Process Type	Text	View only	Auto-populated on the creation of schedule
Stage	Text	View only	Auto-populated on the creation of schedule
Output Type	Text	View only	Auto-populated on the creation of schedule
Test Type	Array		Lab/IoT, auto-selected to Lab
Parameter 1…n	Text	View only	Auto-populated on the creation of schedule
Testing Date	Date	View only	Date calculated through the predefined laboratory testing schedule
SLA	Numeric	View only	Difference between the current date and testing date: The compliance to a testing schedule can be checked through this field. However, the actions based on failed/successful compliance falls under vendor management, which is not in scope currently and will be taken up separately under vendor management
Status	Text	View only	Status to be auto set to ‘Scheduled’

1. Test Results

Attribute	Type	Required?	Comments
Test ID	Numeric	Y	Auto-generated by system
Plant Name	Array	View only	Auto-populated on the creation of schedule, single select for on-demand test
Treatment Process	Array	View only	Auto-populated on the creation of schedule, single select for on-demand test
Treatment Process Type	Array	View only	Auto-populated on the creation of schedule, single select for on-demand test
Stage	Array	View only	Auto-populated on the creation of schedule, single select for on-demand test
Output Type	Array	View only	Auto-populated on the creation of schedule, single select for on-demand test
Test Type	Array		Lab/IoT, auto-selected to lab for on demand
Lab Submitted to	Text	Y	This will not be required in case test type = IoT
Quality Parameter 1	Numeric	Y	Validation to be applied at impel
Quality Parameter 2	Numeric	Y	Validation to be applied at impel
Quality Parameter 3	Numeric	Y	Validation to be applied at impel
Quality Parameter n	Numeric	Y	Validation to be applied at impel
Collection Time	Date	Y	This is the date-time during which the user updates status to pending Results. for IoT, this is the time sensor records reading
Attachment	Document	Y	For a given collection location, photo or PDF proof of laboratory result mentioning the information of above-mentioned parameters

1. Alert: Lab and IoT Result Not As Per the Benchmark; Lab and Device Results Do Not Match

Attribute	Type	Required?	Comments
Alert DateTime	Datetime	Y	Auto-captured based on date-time
Alert Type	Text	Y	Auto-captured Lab test results not as per the benchmark
Plant Name	Text	Y
Process Name	Text	Y
Process Type	Text	Y
Parameter 1…n	Text	Y
UoM	Text	Y
Benchmark	Number	Y
Results	Number	Y
Test Type	Text	Y	Auto-selected to lab/IoT, or both

1. Alert: No Reading Received From the Device

Attribute	Type	Required?	Comments
Alert DateTime	Datetime	Y	Auto captured based on date-time
Alert Type	Text	Y	Auto captured No reading received from the device
Plant Name	Text	Y
Process Name	Text	Y
Process Type	Text	Y
Device ID	Numeric	Y

Sensor Monitoring

Below is an illustration of the communication between monitoring sensor and DIGIT:

• Monitoring sensor - Communicates the actual readings (in AMP etc) to the vendor’s system.

• Sensor vendor - Converts the readings into the values against the parameters.

• Sensor adaptor - Communicates the values through the standardised APIs designed by DIGIT.

• Sensors will be installed at one or multiple stages of the plant, and device details will be recorded in the system.

• Sensor monitoring: The user will have a view of all the devices available at the plant along with their status using the sensor monitoring tab at the front end.

Treatment Quality Monitoring: Dashboard

The TQM dashboard will be made available to both the TRP, the ULB admin and the state admin. The access to data in the dashboard will be based on the following roles:

1. TRP will be available to view dashboard only for the assigned plant.

2. The ULB admin will be able to view the dashboard for all the plants in the ULB.

3. The state admin will be able to view the dashboard for all the plants in the ULB.

Navigation:

On landing on the dashboard, the user can navigate across treatment process types, to view the dashboard specific to the treatment process type.

Filters:

1. Date range: Users should be able to filter based on the date range.

2. ULB: Users should be able to filter based on the ULB. For plant TRP and ULB employees, the ULB is auto-selected to the ULB the plant and employee is tagged to. For a state user, all ULBs are available.

3. Plant: Users should be able to filter based on the plant: For plant TRP, plants that the TRP is tagged to is auto-selected. For ULB employees, plants tagged to the ULB to which the employee belongs should be available in the dropdown. For a state user, all plants are available.

Other functionalities:

Share:

• Users should be able to share a filtered dashboard over WhatsApp in an image format.

• Users should be able to share filtered charts/tables over WhatsApp in an image format.

Download:

• Users should be able to download the filtered dashboard in PDF and image formats.

• Users should be able to download filtered charts/tables in PDF and image formats.

Metrics:

Overall KPIs- The dashboard will display the following KPIs:

• Total incoming sludge: The sum of the total sludge that is disposed of at the plant for the selected time period.

• Number of trips: A count of the total incoming vehicles at the treatment plant for the selected time period.

• Overall quality: The number of tests where all parameters are as per the benchmarks as compared to the total number of test results recorded.

• Compliance percentage: The percentage of tests where results have been recorded.

• Total alerts: A count of the total alerts raised of the following types: Test results not as per the benchmark, no reading from the IoT device, and lab results and IoT results not matching.

Treatment Quality Overview:

KPIs:

• Total plants: A count of the unique plants for the particular treatment process.

• Count of plants who have passed the treatment quality as per the last recorded test.

• Count of plants who have failed the treatment quality as per the last recorded test.

• Treatment quality is said to have passed if all parameters for final output(s) of a treatment process are as per the benchmarks.

• Treatment quality is said to have failed if one or more parameters for final output(s) of a treatment process is not as per the benchmarks.

Map:

A map view of the location of each plant will be displayed as part of the dashboard. Plants here will be colour coded, based on whether it has passed/failed the treatment quality. (Red = Failed, Green = passed).

Table:

A table will be available on the plant-wise details of the test results (pass/fail) and compliance percentage. This will be as per the last test result. The user will also be able to see a change in the compliance percentage as compared to the last month. A drilldown will be made available for a plant via this table. For TRP users and ULBs where only one plant is tagged for the process type, the drilled table is automatically visible.On drilldown, the following is viewable to the user:

1. Heading - Name of the plant.

2. Table displaying the following fields:

a. Stage, output type, value of parameters, and compliance percentage.

b. Button to view the trends for a particular stage.

1. Toggle to toggle between IoT readings and lab results.

Trends of parameter readings:

This chart will be available once the user clicks on the view trend button in the table button.

The table shows the trend for one parameter over time, and provides a view of the benchmark for comparison. A toggle is available to navigate between the parameters. Detailed metric details for the Treatment Quality Monitoring dashboard are viewable below:

S.No

Section Heading

Chart Heading

Subheading

Definitions ((This will appear on the dashboard whenever a user hovers on the metric wherever applicable))

Chart Type

X-Axis

Y-Axis

Value

Columns

How to calculate

Boundary

Dtill down/Toggle

Comparsion KPIs, if any

Show comparison in

Specific to State/ULB/ TRP/all

Tooltip on Hover on Data Point

Input Fields

1

Input

Total Incoming Sludge

NA

Total Incoming sludge from registered and unregistered vehicles

KPI

NA

NA

Total Incoming Sludge

NA

Total incoming sludge = (Volume of Waste Disposed for Registered Vehicles) + (Volume of Waste Disposed for Unregistered Vehicles)

State, Plant ULB

NA

NA

NA

NA

2

Input

# incoming trips

NA

Number of trips disposed at the Treatment plant

KPI

NA

NA

Count of Trips to the Treatment plant from registered and unregistered vehicles

NA

Number of trips disposed = Count(DISTINCT Trip ID)

State, Plant ULB

NA

NA

NA

NA

3

Treatment Quality

Overall Quality

NA

% of tests where all parameters are as per benchmarks

KPI

NA

NA

% of test results meeting benchmarks

NA

Overall Quality = (Number of tests where all parameters meet benchmarks / Total number of tests) * 100

State, Plant ULB

NA

NA

NA

NA

4

Treatment Quality

Compliance

NA

% of tests where results have been recorded

KPI

NA

NA

% of tests with Status as submitted out of total tests

Compliance % = (Count of Test ID in status 'Submitted' / Count (Distinct Trip ID) * 100

State, Plant ULB

NA

NA

NA

NA

5

Alerts

Total Alerts

NA

Total Alerts raised by the system in the following categories: 1) Test Results not as per benchmark 2) No reading from IoT device 3) Lab results and IoT results not matching

KPI

NA

NA

Total Alerts

Count(DISTINCT AlertID)

State, Plant ULB

NA

NA

NA

NA

6

Treatment Quality Plants

Total Plants

NA

NA

NA

NA

NA

Count of Plants

Count (Distinct PlantID)

State, Plant ULB

NA

NA

NA

NA

7

Treatment Quality Plants

Treatment Quality Passed

NA

Treatment quality is considered passed if all parameters of both Biosolids and Effluents are as per benchmarks for the output of the Treatment Process in the last test recorded.

NA

NA

NA

Count of Plants with Treatment Quality Passed

Treatment Quality for Output type =IF(COUNTIF(All Parameters Meet Benchmarks, FALSE) = 0, "Treatment Quality for Output type passed ", "Treatment Quality for Output type failed") Treatment Quality for Plant passed = =IF(COUNTIF(Treatment Quality for Output type, FALSE) = 0, " Treatment Quality Passed ", "Treatment Quality Failed")

State, Plant ULB

NA

NA

NA

NA

8

Treatment Quality Plants

Treatment Quality Failed

NA

Treatment quality is considered failed when 1 or more parameters of Biosolids or Effluents are not as per benchmarks for the output of the Treatment Process in the last test recorded.

NA

NA

NA

Count of Plants with Treatment Quality Failed

Count (Distinct PlantID) - Treatment Quality Passed

State, Plant ULB

NA

NA

NA

NA

9

Treatment Quality Plants

NA

NA

NA

Map

NA

NA

Point = Geolocation of Plant Plant Icon Colour - Green if Treatment Quality Passed, Red if Treatment Quality Failed

Same as S.No 7 and S.No 8

State, Plant ULB

NA

NA

NA

NA

Name of Plant

10

Treatment Quality Plants

NA

NA

NA

Table

NA

NA

NA

Plant Name, Test Result, Compliance %

Test Result Same as S.No 7 and S.No 8

State, Plant ULB

NA

NA

NA

NA

11

Treatment Quality Plants

NA

NA

NA

Table

NA

NA

NA

Stage, Output Type, Parameters 1...n, Compliance %

Mentioned above

State, Plant ULB

NA

Compliance %

% from last month

NA

12

Trend in [Parameter Name] Readings

NA

NA

NA

Multi-Line Chart

Test Dates

Parameter Value

- Value of Device Reading - Value of Lab results

NA

NA

Plant

NA

NA

NA

NA

Date Lab result - X Device Reading - Y

Guided navigation:

If the user clicks on the help button, it will give a walkthrough of the entire screen, including the role of each button placed with two buttons:

• Skip: If the user wants to skip the walkthrough at any point.

• Next: It will proceed to the next action aligned.

Treatment Quality Monitoring: Noun Verb Mapping

Entities	Actions
Create	Read	Search	Update	Delete	Deactivate
Test Schedule	X			X	X
Status	X
Lab Result (Evidence)				X	X
Device Result				X	X
Anomalieis	X

Roles

There are multiple business models when it comes to lab testing and O&M of a treatment plant. In case of some FSTPs in Tamil Nadu, treatment plant operators are employees of a vendor who have a build-and-manage-model, and are directly responsible for resolving issues. Some FSTPs have an in-house lab to test the quality, whereas others send samples to other labs for testing. In certain cases, the ULB employee is responsible for testing and resolution of issues. Keeping this in mind, it is imperative that we design roles in the system in a flexible way such that the product can be implemented in various models.

Super Admin	All
Plant Admin	Create, edit and disable plants Create, edit and disable Workcentres Create, edit and disable assets Create, edit and disable Devices Map assets and devices Map process flow and workcentres Map assets and jobs Set up escalation matrix
Process Admin	Create, edit and disable process flow Create, edit and disable Jobs Map jobs and process flow
Test Viewer	1) View upcoming tests and status
Plant Operator	1) Update status of test to Sample Submitted
Test Uploader	1) Upload test results
Dashboard Viewer	1) View dashboards

See noun verb mapping for roles below:

Platform: Master: Overall Scope
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows					X
Jobs					X
Standards					x
Plant					X
Workcentre					X
Assets					X
Test Schedule	X			X	X
Status	X				X
Lab Result (Evidence)					X
Device Result				X	X
Anomalieis	X				X
Issue					x
Dashboards	x				x
Plant Admin
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows	x			x	x	x
Jobs	x			x	x	x
Standards	x			x	x	x
Plant					X
Workcentre					X
Assets					X
Test Schedule	X	X	X	X	X
Status	X	X	X	X	X
Lab Result (Evidence)	X	X	X	X	X
Device Result	X	X	X	X	X
Anomalieis	X	X	X	X	X
Issue	X	X	X	X	x
Dashboards	X	X	X	X	x
Process Admin
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows
Jobs
Standards
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule	X	X	X	X	X
Status	X	X	X	X	X
Lab Result (Evidence)	X	X	X	X	X
Device Result	X	X	X	X	X
Anomalieis	X	X	X	X	X
Issue	X	X	X	X	x
Dashboards	X	X	X	X	x
Process Admin
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows
Jobs
Standards
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule	X	X	X	X	X
Status	X	X	X	X	X
Lab Result (Evidence)	X	X	X	X	X
Device Result	X	X	X	X	X
Anomalieis	X	X	X	X	X
Issue	X	X	X	X	x
Dashboards	X	X	X	X	x
Test Viewer
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows	X	X	X	X	X	X
Jobs	X	X	X	X	X	X
Standards	X	X	X	X	X	X
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule	X			X	X
Status	X	X	X	X	X
Lab Result (Evidence)	X	X	X	X	X
Device Result	X	X	X	X	X
Anomalieis	X	X	X	X	X
Issue	X	X	X	X	x
Dashboards	X	X	X	X	x
Plant Operator
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows	X	X	X	X	X	X
Jobs	X	X	X	X	X	X
Standards	X	X	X	X	X	X
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule				X	X
Status					X
Lab Result (Evidence)					X
Device Result	X			X	X
Anomalieis	X		X	X	X
Issue	X	X	X	X	x
Dashboards	X	X	X	X	x
Test Uploader
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows	X	X	X	X	X	X
Jobs	X	X	X	X	X	X
Standards	X	X	X	X	X	X
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule				X	X
Status					X
Lab Result (Evidence)					X
Device Result	X			X	X
Anomalieis	X		X	X	X
Issue	X	X	X	X	x
Dashboards	X	X	X	X	x
Plant Operator
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows	X	X	X	X	X	X
Jobs	X	X	X	X	X	X
Standards	X	X	X	X	X	X
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule				X	X
Status					X
Lab Result (Evidence)	X	X	X	X	X
Device Result	X	X	X	X	X
Anomalieis	X	X	X	X	X
Issue	X	X	X	X	x
Dashboards	X	X	X	X	x
Issue Creator
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows	X	X	X	X	X	X
Jobs	X	X	X	X	X	X
Standards	X	X	X	X	X	X
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule	X	X	X	X	X
Status	X	X	X	X	X
Lab Result (Evidence)	X	X	X	X	X
Device Result	X	X	X	X	X
Anomalieis	X	X	X	X	X
Issue				X	x
Dashboards	X	X	X	X	x
Issue Editor (different for different types of issues)
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows	X	X	X	X	X	X
Jobs	X	X	X	X	X	X
Standards	X	X	X	X	X	X
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule	X	X	X	X	X
Status	X	X	X	X	X
Lab Result (Evidence)	X	X	X	X	X
Device Result	X	X	X	X	X
Anomalieis	X	X	X	X	X
Issue	X				x
Dashboards	X	X	X	X	x
Dashboards
Entity	Actions
Create (C)	Read (R)	Search (S)	Update (U)	Delete (D)	Deactivate
Process Flows	X	X	X	X	X	X
Jobs	X	X	X	X	X	X
Standards	X	X	X	X	X	X
Plant	X	X	X	X	X	X
Workcentre	X	X	X	X	X	X
Assets	X	X	X	X	X	X
Test Schedule	X	X	X	X	X
Status	X	X	X	X	X
Lab Result (Evidence)	X	X	X	X	X
Device Result	X	X	X	X	X
Anomalies	X	X	X	X	X
Issue	X	X	X	X	X
Dashboards	X			X	x

User Interface Design (Exemplar)

Landing Page: Plant Operator

The user will land on the home page post login. The following actions can be performed by the user:

1. The plant name is visible on the top right hand corner of the screen.

2. A help button is available for the user to get a guided view of the page. This is available on every page.

3. Cards are viewable for the following modules:

a. Vehicle log module (record incoming vehicles)

b. Treatment quality module

c. View dashboard

Clicking on each of these cards will take the user to the Homepage for the specific module.

1. List of pending tasks: This will show the list of tests pending within the next [X] days. The next action item in the task workflow will be displayed beside a pending task for a user to take prompt action. A button for “View All Pending Tasks” will be displayed which will redirect the user to “All Pending Tasks”.

Treatment Quality Module (TQM) Home Page

On clicking on the treatment quality card, the user is redirected to the TQM home page. The following actions can be performed by the user:

1. View and take action on upcoming tests using the inbox. The inbox will show a count of upcoming tests beside it.

2. View past test results: Past results from both lab and IoT devices will be displayed here.

3. View IoT readings: The user can access the record of IoT readings here.

4. Sensor Monitoring: The user can access a list of IoT devices along with their status here.

5. View dashboard: The user will be directed to the treatment quality dashboard.

6. View performance: This widget will show the performance of the plant in regards to treatment quality and will display the following KPIs:

a. Test compliance: Compliance percentage of plant with regards to the treatment quality and its comparison to state level compliance percentage.

b. Last treatment quality result - Pass/fail and date of the test.

c. Count of alerts raised in the past 30 days.

d. Distribution of alerts based on the alert category.

1. Go back to the Landing page using the back button.

2. A help button is available for the user to get a guided view of the page. This is available on every page.

View List of Upcoming Tests

On clicking on inbox, the user is redirected to the list of upcoming tests. This will show only a list of lab tests. The user can perform the following tasks:

1. Total count of upcoming tests are displayed beside the inbox in brackets.

2. View list of upcoming tests. The following will be the fields displayed:

1. Total count of upcoming tests are displayed beside the inbox in brackets.

2. View list of upcoming tests. The following will be the fields displayed:

a. Test ID.

b. Treatment process (in case there is only 1 treatment process for the plant, this field will not be displayed).

c. Stage: This will display the process stage where the sample is to be collected from.

d. Output type: Biosolids/effluents.

e. Pending date: This is the test date as per schedule.

f. Status: status of the test.

g. SLA: Show difference between test due date and today.

1. An action item available based on the next status in the workflow will be displayed:

a. For test results in the scheduled stage, update status will be displayed.

b. For tests in the pending results stage, update results will be displayed.

1. Filter tests: On clicking on filter, a pop-up will be displayed:

a. The following filters are available:

1. Treatment process: (In case there is only 1 treatment process for the plant, this field will not be displayed). This will be a dropdown showing the values for treatment processes configured for the plant. The selected treatment process is displayed here on selection. If not, the field is left blank.

2. Output type: This will be a dropdown showing values for output types configured for the plant. The selected output type is displayed here on selection. If not, the field is left blank.

3. Status: This will be a dropdown showing values for the status in the treatment quality workflow. The selected status is displayed here on selection. If not, the field is left blank.

4. Date range: Selection of date range (calendar view): Selected date range is displayed here on selection. If not, the field is left blank.

b. On selecting values for the filters above, a user can click on filter to filter the inbox.

c. To clear filters, a user can click on clear all.

d. To close the pop-up, a user can click on the cross on the top right hand corner of the screen.

1. Sort: On clicking on sort, a pop-up will be displayed:

a. Tests can be sorted by the pending date:

Date (Latest first)

Date (Latest Last)

b. On selecting values for sort above, the user can click on sort to sort the inbox.

c. To clear sort, a user can click on clear all.

d. To close the pop-up, a user can click on the cross on the top right hand corner of the screen.

1. Go back to the landing page using the back button.

2. A help button is available for the user to get a guided view of the page. This is available on every page.

View Test Details

Test Details can be viewed by the user in 2 ways:

• Via the pending tasks.

• Via inbox.

View Test Details Via Pending Tasks

• The list of pending tasks can be accessed via the landing page for TQM. This will show the list of tests pending within the next [X] days.

• The next action item in the task workflow will be displayed as a button beside a pending task for a user to take prompt action. On clicking on the button, the user will be redirected to the test details page.

View Test Details Via Inbox

A list of tests can be accessed on the inbox. An action item is available based on the next status in the workflow will be displayed:

1. For test results in the scheduled stage, the update status will be displayed.

2. For tests in the pending results stage, the update results will be displayed.

On clicking on the action item, the user will be redirected to the test details page.

The test details page will consist of 2 cards:

1. The first card will display the following fields:

• Test ID

• Treatment Process

• Stage

• Output Type

• Pending Date

• Status

• Parameters to be tested along with their unit of measurement

• SLA (This will be displayed in Red/green basis SLA. If today>Pending date, this is red, If today<pending date, then green).

1. The second card will be based on the test status:

• For tests in status ‘Scheduled’, the user will be asked to select a lab.

• For tests in status “Pending Results”, the user will be asked to add test results

The user can go back using the back button - The redirection will be based on the page the user has accessed the test details page from. A help button is available for the user to get a guided view of the page. This is available on every page.

Update Tests

Tests can be updated by the user from the test details page. The test details page will display the next action item for the user based on the workflow test. For tests with the wWorkflow status ‘Scheduled’, the user will be prompted to confirm if sample has been submitted to the lab for testing.

The user can perform the following actions:

1. Select a lab from a dropdown list configured in the MDMS.

2. Update status of the test. The button will be deactivated if Lab is not selected, and will only be activated once selection is made. Once the user clicks on update status, he/she is redirected back to the page from which test details were accessed and a snack bar confirms the status update and the action Item button shows updated next step.

In case an update of status fails, the user will remain on the same page and a failure message will be displayed to the user.

For tests with the workflow status “Pending Status”, the user will be prompted to fill test results.

The user can perform the following actions:

1. Update parameter readings (mandatory fields) The following validations will be applied:

a. Only numerical values will be viewable here. In case of non numerical values, the following error message is displayed “Only numeric values allowed. Please input in the required format”.

1. Attach documents (non-mandatory): The following validations will be applied:

a. Only files in the following formats will be supported: .png, .jpg. .pdf. In case a file of unsupported format is selected, the following error will be displayed “The file type is not supported. Please upload in the following formats: .pdf, .png, .jpg”.

b. File size of maximum X mb allowed. In case file size is larger than permitted value, the following error will be displayed “The file size is too large. Please upload a file below x mbs”.

1. Submit test results by clicking on the ‘Submit’ button. The button will be deactivated if all is not selected, and will only be activated once selection is made. On clicking the submit button, a pop-up will be displayed to the user to confirm submission.

The following actions will be made available to the user:

1. Confirm submission by clicking on the ‘Submit’ button.

2. Go back to the test details page by clicking on the “Go back” button.

On clicking the submit button and failure to submit test results, the user will remain on the same page and a failure message will be displayed.

On clicking the submit button and successful submission of the test results, the user will be redirected to the summary page and a snack bar will confirm the submission.

At this stage, the user will be displayed the summary of test results and whether it has passed/failed based on a comparison between the values entered by the user and the benchmarks. In case all values are as per the benchmarks, the test results will be displayed as ‘Pass’. All values will be shown in green and the user receives feedback that all results are as per benchmarks. The user can go back to the home page by clicking on the ‘Back’ button.

In case one or more values are not as per the benchmarks, the test results will be displayed as ‘Fail’. All values as per benchmarks will be shown in green. Values not as per the benchmarks are shown in red. The user is provided with information that the test results are not as per benchmark. The user can go back to the Home page by clicking on the ‘Back’ button.

View Past Test Results

Past test results (both IoT and Lab) can be viewed via the TQM landing page and by clicking on past tests.

On clicking on past tests, the user is redirected to the list of past tests.

The user can perform the following tasks:

1. View the list of past tests. The following will be the fields displayed:

a. Test ID.

b. Treatment process (in case there is only 1 treatment process for the plant, this field will not be displayed).

c. Stage: This will display the process stage where the sample is to be collected from.

d. Output type: Biosolids/effluents

e. Pending date: This is the test date as per schedule.

f. Test result: Pass/fail.

2. View test details: The user can view test details by clicking on “View Results” button on each card.

1. Filter tests: On clicking on Filter, a pop-up will be displayed. The following filters are available:

i. Treatment process: (in case there is only 1 treatment process for the plant, this field will not be displayed). This will be a dropdown showing values for Treatment Processes configured for the plant. The selected treatment process is displayed here on selection. If not, the field is left blank.

ii. Output type: This will be a dropdown showing values for the output types configured for the plant. The selected output type is displayed here on selection. If not, the field is left blank.

iii. Test type: This will be a dropdown showing values for the test type (IoT/Lab). The selected test type is displayed here on selection. If not, the field is left blank.

iv. Date range: The selection of date range (calendar view) - The selected date range is displayed here on selection. If not, the field is left blank.

On selecting values for filters above, the user can click on filter to filter the inbox. To clear filters, the user can click on clear all. To close the pop-up, a user can click on the cross on the top right hand corner of the screen. On selection of the filter, the selected filter is displayed on the screen. On clicking the cross button near the displayed filter, the filter is removed.

1. Sort: On clicking on sort, a pop-up will be displayed:

a. Tests can be sorted by the pending date:

1. Date (Latest first)

2. Date (Latest last)

b. On selecting values for sort above, the user can click on sort to sort the inbox.

c. To clear sort, the user can click on clear all.

d. To close the pop-up, the user can click on the cross on the top right hand corner of the screen.

1. In case filters/sort/search is applied and the user navigates to the test details page, on going back, the values of the filters/sort/search should remain the same.

1. The user can download the list of tests, filtered by selection in Excel and PDF format.

2. Go back to the Landing page using the back button.

3. A help button is available for the user to get a guided view of the page. This is available on every page.

On clicking the “View Results” button, the user will be redirected to the test summary page.

The page will have 2 cards:

The first card will display the following fields:

• Test ID.

• Treatment Process.

• Stage.

• Output Type.

• Test Type.

• Lab Name/Device ID: This will show Lab Name/Device ID based on the Test type.

• Test submitted on.

• Test Results: Pass/Fail.

The second card will display the following fields:

• Parameters, their unit of measurement and the values of the parameters recorded. The values will be read/green basis whether they are as per benchmarks or not.

The user can go back to the list of tests by clicking on the ‘Back’ button, both on the top and bottom of the page.

View IoT Readings

IoT readings can be viewed via the TQM landing page and clicking on view IoT readings.

On clicking on View IoT readings, the user is redirected to the view tests page filter on test type: IoT.

The functionality of the page remains the same as the “View Past Tests” page.

Sensor Monitoring

Sensor monitoring can be accessed by clicking on the sensor monitoring link on the TQM landing page.

On clicking on sensor monitoring, the list of IoT devices are displayed.

The following details are displayed on the page:

• Total number of IoT devices is displayed beside the page heading in brackets.

• A card is available for each device. The following details will be displayed:

- Device ID.

- Treatment Process.

- Stage.

- Output Type.

- Last Calibrated Date.

- Device Status.

- Verification Status.

- Last Verification Date.

- Parameters that the device monitors.

The user can perform the following actions:

1. Filter devices: On clicking on filter, a pop-up will be displayed.

a. The following filters are available:

i. Treatment process: (in case there is only 1 treatment process for the plant, this field will not be displayed). This will be a dropdown showing values for the treatment processes configured for the plant. The selected treatment process is displayed here on selection. If not, the field is left blank.

ii. Output type: This will be a dropdown showing values for the output types configured for the plant. The selected output type is displayed here on selection. If not, the field is left blank.

iii. Device status: This will be a radio button showing active/inactive

iv. Parameters: This will be a multi-select displaying all parameters configured on the backend.

b. On selecting values for filters above, the user can click on filter to filter the inbox.

c. To clear filters, the user can click on clear all.

d. To close the pop up, the user can click on the cross on the top right hand corner of the screen.

e. On selection of the filter, the selected filter is displayed on the screen. On clicking the cross button near the displayed filter, the filter is removed.

1. Search: On clicking on search, a pop-up will be displayed.

a. The user can search a device by device ID. Part search to be enabled.

View Dashboard

Dashboards can be accessed by clicking on the “View Dashboards” link on the TQM landing page.

Navigation:

On landing on the dashboard, the user can navigate across the treatment process types to view the dashboard specific to the treatment process type.

Filter:

Date range: Users should be able to filter based on the date range basis which dashboard is to be filtered.

Other functionalities:

Share:

• Users should be able to share a filtered dashboard over WhatsApp in an image format.

• Users should be able to share filtered charts/tables over WhatsApp in an image format.

Download:

• Users should be able to download the filtered dashboard in PDF and image formats.

• Users should be able to download filtered charts/tables in PDF and image formats.

Metrics:

• Total incoming sludge: The sum of the total sludge that is disposed of at the plant for the selected time period.

• Number of trips: A count of the total incoming vehicles at the treatment plant for the selected time period.

• Overall quality: The number of tests where all parameters are as per the benchmarks as compared to the total number of test results recorded.

• Compliance percentage: The percentage of tests where results have been recorded.

• Total alerts: A count of the total alerts raised of the following types: Test results not as per the benchmark, no reading from the IoT device, and lab results and IoT results not matching.

Treatment Quality Overview:

KPIs:

• Total tests - A count of the total tests for the filtered date range.

• A count of tests that have passed treatment quality.

• A count of tests that have failed the treatment quality.

Table:

1. Heading - Name of the plant.

2. Table displaying the following fields:

a. Stage, output type, value of parameters, and compliance percentage.

b. Button to view the trends for a particular stage.

1. Toggle to toggle between IoT readings and lab results.

Trends of parameter readings:

This chart will be available once the user clicks on the view trend button in the table button.

The table shows the trend for one parameter over time, and provides a view of the benchmark for comparison. A toggle is available to navigate between the parameters. Detailed metric details for the Treatment Quality Monitoring dashboard are viewable below:

S.No

Section Heading

Chart Heading

Subheading

Definitions ((This will appear on the dashboard whenever a user hovers on the metric wherever applicable))

Chart Type

X-Axis

Y-Axis

Value

Columns

How to calculate

Boundary

Dtill down/Toggle

Comparsion KPIs, if any

Show comparison in

Specific to State/ULB/ TRP/all

Tooltip on Hover on Data Point

Input Fields

1

Input

Total Incoming Sludge

NA

Total Incoming sludge from registered and unregistered vehicles

KPI

NA

NA

Total Incoming Sludge

NA

Total incoming sludge = (Volume of Waste Disposed for Registered Vehicles) + (Volume of Waste Disposed for Unregistered Vehicles)

State, Plant ULB

NA

NA

NA

NA

2

Input

# incoming trips

NA

Number of trips disposed at the Treatment plant

KPI

NA

NA

Count of Trips to the Treatment plant from registered and unregistered vehicles

NA

Number of trips disposed = Count(DISTINCT Trip ID)

State, Plant ULB

NA

NA

NA

NA

3

Treatment Quality

Overall Quality

NA

% of tests where all parameters are as per benchmarks

KPI

NA

NA

% of test results meeting benchmarks

NA

Overall Quality = (Number of tests where all parameters meet benchmarks / Total number of tests) * 100

State, Plant ULB

NA

NA

NA

NA

4

Treatment Quality

Compliance

NA

% of tests where results have been recorded

KPI

NA

NA

% of tests with Status as submitted out of total tests

Compliance % = (Count of Test ID in status 'Submitted' / Count (Distinct Trip ID) * 100

State, Plant ULB

NA

NA

NA

NA

5

Alerts

Total Alerts

NA

Total Alerts raised by the system in the following categories: 1) Test Results not as per benchmark 2) No reading from IoT device 3) Lab results and IoT results not matching

KPI

NA

NA

Total Alerts

Count(DISTINCT AlertID)

State, Plant ULB

NA

NA

NA

NA

6

Treatment Quality Plants

Total Plants

NA

NA

NA

NA

NA

Count of Plants

Count (Distinct PlantID)

State, Plant ULB

NA

NA

NA

NA

7

Treatment Quality Plants

Treatment Quality Passed

NA

Treatment quality is considered passed if all parameters of both Biosolids and Effluents are as per benchmarks for the output of the Treatment Process in the last test recorded.

NA

NA

NA

Count of Plants with Treatment Quality Passed

Treatment Quality for Output type =IF(COUNTIF(All Parameters Meet Benchmarks, FALSE) = 0, "Treatment Quality for Output type passed ", "Treatment Quality for Output type failed") Treatment Quality for Plant passed = =IF(COUNTIF(Treatment Quality for Output type, FALSE) = 0, " Treatment Quality Passed ", "Treatment Quality Failed")

State, Plant ULB

NA

NA

NA

NA

8

Treatment Quality Plants

Treatment Quality Failed

NA

Treatment quality is considered failed when 1 or more parameters of Biosolids or Effluents are not as per benchmarks for the output of the Treatment Process in the last test recorded.

NA

NA

NA

Count of Plants with Treatment Quality Failed

Count (Distinct PlantID) - Treatment Quality Passed

State, Plant ULB

NA

NA

NA

NA

9

Treatment Quality Plants

NA

NA

NA

Map

NA

NA

Point = Geolocation of Plant Plant Icon Colour - Green if Treatment Quality Passed, Red if Treatment Quality Failed

Same as S.No 7 and S.No 8

State, Plant ULB

NA

NA

NA

NA

Name of Plant

10

Treatment Quality Plants

NA

NA

NA

Table

NA

NA

NA

Plant Name, Test Result, Compliance %

Test Result Same as S.No 7 and S.No 8

State, Plant ULB

NA

NA

NA

NA

11

Treatment Quality Plants

NA

NA

NA

Table

NA

NA

NA

Stage, Output Type, Parameters 1...n, Compliance %

Mentioned above

State, Plant ULB

NA

Compliance %

% from last month

NA

12

Trend in [Parameter Name] Readings

NA

NA

NA

Multi-Line Chart

Test Dates

Parameter Value

- Value of Device Reading - Value of Lab results

NA

NA

Plant

NA

NA

NA

NA

Date Lab result - X Device Reading - Y

Landing Page: ULB Employee

A card for Treatment Quality Monitoring will be made available on the landing page of the employee.

1. The treatment quality contain the following:

a. An overview of the total pending tests and how many are nearing SLA.

b. View upcoming tests using the inbox. The inbox will show a count of upcoming tests beside in brackets.

c. View past test results: Past results from both lab and IoT devices will be displayed here.

d. View IoT readings: The user can access the record of IoT readings here.

e. Sensor monitoring: The user can access a list of IoT devices along with their status here.

f. View dashboard: The user will be directed to the treatment quality dashboard.

Clicking on each of these links will take the user to the specific page.

1. Notifications: This will show the list of alerts regarding TQM. Currently, this will display the tests that have crossed SLA for greater than 7 days. The user can view the details of the test by clicking on the “View Details” button. The user can dismiss the notification by clicking on the cross button.

2. Rest of the functionality will remain the same as the current ULB employee landing page.

View List of Upcoming Tests

On clicking on Inbox, the user is redirected to the list of upcoming tests. This will show only a list of lab tests. The user can perform the following tasks:

1. The total count of upcoming tests are displayed beside the inbox in brackets.

2. View a list of upcoming tests. The list of upcoming tests will be sorted by the pending date, where the test with the highest SLA is displayed first. The following fields will be displayed:

a. Test ID

b. Plant Name

c. Treatment Process

d. Pending Date: This is the test date as per schedule

e. Status: Status of the test

f. SLA: Show difference between test due date and today. This will be displayed in red if test due date<today and in green if today>test due date.

The user can view test details by clicking on the test ID.

1. Filter tests: Filters are displayed on the left hand panel of the screen. The following filters are available:

i. Treatment process: This will be multi-select showing values for the treatment processes configured for the ULB. The selected treatment process will be displayed as a tick on the multi-select box. If not, it is left blank.

ii. Stages: This will be a dropdown showing values for stages configured for the plant. The selected stage is displayed here on selection. If not, the field is left blank.

iii. Status: This will be a multi-select showing values for the status in the treatment quality workflow.

On selecting values for filters above, the user can click on filter to filter the inbox. To clear filters, the user can click on the refresh icon on the top right of the filter panel.

1. Sort: Tests can be sorted by the pending date by clicking on the date column.

2. Search:

   a. Tests can be searched using the following:

i. Test ID.

ii. Plant Name.

b. Part search to be enabled for both.

c. Users can fill either test ID or plant or both and click on the search button.

d. Users can clear search by clicking on the clear search link.

1. In case filters/sort/search is applied and the user navigates to the test details page, on going back, the values of the filters/sort/search should remain the same.

2. Redirecting to other links in the TQM module: Users can redirect to other pages in the TQM module via the links provided on the top left of the page. The following links will be displayed:

a. View Past Results

b. View IoT Results

c. Sensor Monitoring

d. View Dashboard

View Test Details

A test details page can be accessed by clicking on the test ID in the inbox. The test details page will consist of the following fields:

• The following information will be displayed. In case the information on any field is not available such as the lab name/value against parameters based on the status of the test, the value against the fields will be displayed as “To be Updated”

- Test ID

- Plant Name

- Treatment Process

- Stage

- Output Type

- Test Type

- Test Scheduled on

- Status

- Lab Name

- Sample submitted on

- Test results submitted on

- SLA (This will be displayed in red/green based on the SLA. If today>pending date, this is red, If today<pending date, then green for open tests. For closed tests, SLA will be displayed).

- Table containing the following details:

i. S.No

ii. Parameter

iii. UoM

iv. Benchmark

v. Value Recorded - The value will be displayed in red/green based on comparison to the benchmark

vi. Overall Test results - Pass/Fail

- Attached documents, if any. The user should be able to view the document by clicking on the document icon. No icon will be present if documents are not attached.

- Test Timeline

• The user can go back using the breadcrumbs of the page.

• The user can download the test report by clicking on the 'Download' button.

View Past Test Results

Past test results (both IoT and Lab) can be viewed via the TQM landing page and clicking on past tests.

On clicking on past test results, the user is redirected to the list of past tests.

The user can perform the following tasks:

1. View the list of past tests. The results will be sorted on the test date. The following will be the fields displayed:

a. Test ID

b. Plant

c. Treatment Process (in case the there is only 1 treatment process for the plant, this field will not be displayed).

d. Test Type

e. Test Date: This is the date the test results are updated

f. Test Result: Pass/Fail

1. View test details: The user can view test details by clicking on the “Test ID” link in each row.

2. Search tests: The user can search based on the following:

i Test ID: Input text field, part search should be enabled.

ii. Plant: Dropdown of list of plants in the ULB.

iii. Treatment process: Dropdown of list oftTreatment Process in the ULB.

iv. Test type: This will be a dropdown showing values for the test type (IoT/Lab). The selected test type is displayed here on selection. If not, the field is left blank.

v. Date range: Selection of date range (calendar view): The selected date range is displayed here on selection. If not, the field is left blank.

On selecting values for search above, the user can click on search to filter the inbox. To clear search and view all past tests, the user can click on “Clear Search”.

1. Sort: Tests can be sorted by the pending date by clicking on the date column.

2. In case filters/sort/search is applied and the user navigates to the test details page, on going back, the values of the filters/sort/search should remain the same.

3. Download test results in Excel and PDF formats using the download button.

4. The user can go back using the breadcrumbs on the top of the page. In case the user has navigated to the test details page from the past test results list, on clicking back, the user should be redirected to the test details page.

On clicking on any test ID button, the user will be redirected to the test details page (same as redirection from the inbox).

View IoT Readings

IoT readings can be viewed via the TQM landing page and clicking on “View IoT Reading”.

On clicking on IoT readings, the user is redirected to the list of past tests, with the search on test type selected as IoT and the results filtered for IoT readings only. All other functionality will remain the same.

Sensor Monitoring

The list of devices can be viewed via the TQM landing page and by clicking on ‘Sensor Monitoring’’.

On clicking on sensor monitoring, the user is redirected to the list of devices.

The user can perform the following:

• View total devices: The total number of IoT devices is displayed beside the page heading in brackets.

• A row is available for each device. The following details will be displayed:

- Device ID

- Plant

- Treatment Process

- Stage

- Output Type

- Device Status

- Parameters: One or multiple parameters that the device is monitoring.

The user can perform the following actions:

a. Search Devices: On clicking on the filter, a pop up will be displayed. The following filters are available:

1. Device ID: Part search should be available here.

2. Plant: Dropdown based on plants configured in the MDMS.

3. Treatment process: Dropdown-based on the treatment process type.

4. Stage: Dropdown-based stage of selected treatment process.

5. Output type: This will be a drop down showing values for Output types configured for the plant.

6. Device status: Dropdown contains active/Inactive as options.

b. On selecting values for filters above, the user can click on Search to filter the inbox.

c. To clear search, the user can click on clear all.

Record Test Result

Since actors such as PCB might conduct adhoc tests, a provision will be provided to the user to record test results without a schedule. A user can record test results by clicking on the “Add Test Result” link on the card.

Clicking on the “Add Test Result” button will redirect the user to the “Add Test Result” page.

The following fields need to be entered by the user:

• Plant Name: This is a dropdown based on the list of plants available in the system. For a state level user, this should display all plants in the state. For a ULB, it should also display the names tagged to the ULB.

• Treatment Process: This is a dropdown based on the list of treatment processes in the plant selected.

• Treatment Stage: This is a dropdown based on the list of stages in the treatment process selected.

• Output Type: This is a dropdown based on the output types available in the stage

• Values against parameters. Atlease 1 parameter needs to be filled for the submit button to be enabled. If no parameter is filled and the user clicks on the submit button, an error message is displayed as a snack bar.

• Attachments, if any.

Once the user clicks on the Submit button, the test results page is displayed.

This is the same as the “View Test Results” page with the following changes:

• TesttType will be displayed as Lab.

• Status, lab name and SLA field are not displayed.

• Workflow will not be displayed.

The user can go back to the “Add Test Results” page via the breadcrumbs.

View Dashboard

The TQM Dashboard will be made available to both the ULB employee and the state employee, and can be accessed by clicking on the dashboard link on the landing page.

On clicking on the dashboard, the user is directed to the dashboard view.

The access to data in the dashboard will be based on the following roles:

1. ULB admin will be able to view the dashboard for all plants in the ULB.

2. A state admin will be able to view the dashboard for all plants in the ULB.

Navigation:

On landing on the dashboard, the user can navigate across the treatment process types to view the dashboard specific to the treatment process type.

Filters:

1. Date range: Users should be able to filter based on the date range.

2. ULB: Users should be able to filter based on the ULB. For a ULB employee, the ULB is auto-selected to the ULB the plant and employee is tagged to. For a state user, all ULBs are available.

3. Plant: Users should be able to filter based on the plant. For ULB employees, plants tagged to the ULB to which the employee belongs should be available in the dropdown. For state users, all plants are available.

Other functionalities:

• Share:

- Users should be able to share a filtered dashboard over WhatsApp in an image format.

- Users should be able to share filtered charts/tables over WhatsApp in an image format.

• Download:

- Users should be able to download the filtered dashboard in PDF and image formats.

- Users should be able to download the filtered charts/tables in PDF and image formats.

Metrics

Overall KPIs:

The dashboard will display the following KPIs:

• Total incoming sludge: The sum of the total sludge that is disposed of at the plant for the selected time period.

• Number of trips: A count of total incoming vehicles at the treatment plant for the selected time period.

• Overall quality: The number of tests where all parameters are as per benchmarks as compared to the total number of test results recorded.

• Compliance percentage: The percentage of tests where results have been recorded

• Total alerts: A Count of total alerts raised of the following types: Test results not as per benchmark, the number reading from IoT device, and lab results and IoT results not matching.

Treatment quality overview:

KPIs:

• Total plants - A count of the unique plants for the particular treatment process.

• Count of plants who have passed the treatment quality as per the last recorded test.

• Count of plants who have failed the treatment quality as per the last recorded test.

Treatment quality is said to have passed if all parameters for final output(s) of a treatment process are as per benchmarks. Treatment quality is said to have failed if 1 or more parameters for final output(s) of a treatment process is not as per benchmarks.

Map:

A map view of the location of each plant will be displayed as part of the dashboard. Plants here will be colour coded, based on whether it has passed/failed the treatment quality. (Red = failed, Green = passed).

Table:

A table will be available to plant-wise details of test results (pass/fail), and the compliance percentage. This will be as per the last test result. The user will also be able to see a change in compliance percentage compared to the last month. A drilldown will be made available for a plant via this table. For TRP users and ULBs, where only 1 plant is tagged for the process type, the drilled table is automatically visible.

On drilldown, the following is viewable to the user:

1. Heading - Name of plant.

2. Table displaying the following fields:

a. Stage, output type, value of parameters, and compliance percentage.

b. Button to view the trends for a particular stage.

1. Toggle to toggle between IoT readings and lab results.The selected test type will appear highlighted.

2. If there are multiple process flows, then the user can switch between process flows by using the buttons. The selected process flow will appear highlighted.

Trends of parameter readings:

This chart will be available once the user clicks on the view trend button in the table button.

The table shows the trend for one parameter over time and provides a view of the benchmark for comparison. A toggle is available to navigate between parameters.

Out of Scope

The following is out of scope:

1. Testing for parameters beyond those defined for a plant. If testing needs to be recorded for an additional parameter, these need to be configured for a plant first before testing can be performed.

2. Verification of test result documents uploaded by the user: While the system will mandate the user to upload the test result document, verification of the document and ensuring correctness of the information recorded is not in scope.

3. There is some initial uptake in the market for mobile treatment units, which bring treatment onsite to the citizen. Here treatment is done within the mobile treatment unit. We are unaware of how this technology works in terms of recording and storing treatment quality and hence this is out of scope.

4. Editing test results once recorded by the user in case of manual testing.

5. Editing IoT device readings.

6. Recording of the data trail in cases when testing parameters have been added/deleted/updated.

7. Testing parameters may be changed at any point. However, test schedules may already be generated and testing will be done based on old parameters defined when the test schedule is generated.

8. No tracking of reason if test results are not recorded as per schedule.

9. In case a schedule for a test is available, but the user fills the test results directly via the “Record Result” page, this will not be adjusted.

10. Escalation in case of non-compliance to the testing schedule will be done once per test. If test results are still not recorded, no further action will be taken.

11. UI for defining testing requirements and adding/disabling/editing testing parameters.

12. As per our field study, one plant has only one treatment process per treatment process type. The dashboard does not cover calculations for a plant that may have 2 processes for the same treatment process type. For example, For faecal sludge, the plant will either run an aerobic or an anaerobic process and not 2 process flows, one for aerobic and one for anaerobic.

13. Activating/deactivating IoT devices from the frontend.

Assumptions

Theme	Assumption
Testing Parameters and Standards	Testing parameters are a defined set for a particular process type, stage and input/output type combination, and so do not vary at a high frequency. Hence, they can be configured in the MDMS.
Testing	1 user will be responsible for managing the treatment quality of 1 plant for a process type. Multiple parameters at one stage of a plant with the same testing frequency are tested together and monitored as one test. Governing bodies such as the PCB perform adhoc tests, and will use the system to create a record of the results for the same.
Anomaly Detection	For a test result containing multiple parameters, if 1 parameter is not as per benchmark, we can categorise the test results as not as per benchmarks Since IoT readings will be captured at high frequency, anomalies will be generated only if the test value for a parameter is not as per benchmarks for [X] days.
IoT Integration	A standard adaptor will be made available for IoT integration. However, the adaptor may need to be modified on a case basis during implementation.

Reference Policies

Effluent Parameters

While each state is free to monitor the parameters applicable in their context, the platform mandates MOEFCC’s October 13, 2017 Notification as the minimum requirement for effluent quality monitoring.

Parameter	Unit	Value Range	Location
pH	-	6.5 - 9	Anywhere
BOD	mg/L	20	Metro Cities and all State Capitals except in the State of Arunachal Pradesh, Assam, Manipur, Meghalaya Mizoram, Nagaland, Tripura Sikkim, Himachal Pradesh, Uttarakhand, Jammu and Kashmir and Union Territory of Andaman and Nicobar Islands, Dadar and Nagar Haveli Daman and Diu and Lakshadweep
30	Other areas
TSS	mg/L	< 50	Metro Cities and all State Capitals except in the State of Arunachal Pradesh, Assam, Manipur, Meghalaya Mizoram, Nagaland, Tripura Sikkim, Himachal Pradesh, Uttarakhand, Jammu and Kashmir and Union Territory of Andaman and Nicobar Islands, Dadar and Nagar Haveli Daman and Diu and Lakshadweep
< 100	Other areas
F. Coliform	N/100mL	< 1000	Anywhere
COD	mg/L		(?)

*Metro Cities are Mumbai, Delhi, Kolkata, Chennai, Bengaluru, Hyderabad, Ahmedabad, and Pune.

During implementation, these will be setup by the system integrators as per the state policy.

Biosolids Parameters

Regulations for biosolids are unclear - we currently don't have a definitive GoI-notified standard for faecal sludge-derived biosolids. The Advisory and Primer on FSSM (along with the CPHEEO Manual) recommended US EPA Class A Biosolids criteria (looking at E Coli/F Coli, Salmonella, Helminth Eggs). The National Policy on FSSM issued after all these three makes mention of SWM Rules, 2016, as the guiding document for processed sludge quality.

Taking from the Quality in Faecal Sludge Management (Benchmarks, Standards, and Specifications) by NFSSMA and Plain English Guide Part 503 Biosolids Rule, SWM Rules 2016, the platform mandates minimum parameters as listed below, while keeping the flexibility for the States to choose or add as per its context.

Parameter	Unit	Value Range
Temperature	Degree Celsius	(?)
Moisture	Percentage	(?)
E.Coli OR F. Coli	MPN	< 1000 MPN (E-coli)/g Total solids OR < 1000 CFU (Faecal coliform)/g Total solids by dry weight)
Heavy metals (Arsenic, cadmium, chromium, copper, lead, mercury, nickel, zinc)	grams	(?)

Medical Waste: Brazil

The following are the acceptable parameters for medical waste according to Brazilian Standard NBR: