trade effluent miscellaneous guidance
TRANSCRIPT
1
Trade Effluent Miscellaneous
Guidance
Version: 1.0
Date: 24 April 2020
Owner: Trade Effluent Issues Committee (TEIC)
2
About this Document This document sets out best practices and workarounds for issues relating to trade effluent issues.
This document will only apply to the items set out within its Table of Content. For the avoidance of
doubt, this document is intended to provide guidance on trade effluent issues and not to be taken as
a market code document.
Out of Scope This document seeks to ensure its readers are kept updated on issues and deliver workarounds to
known Trade Effluent issues. This document shall ensure that all guidance information is aligned
with market codes. All discussed scenarios within this document should be noted within its entirety,
purpose and not deemed as real-life practicalities.
Version History Version Update Date
Version 1.0 Initial Version Creation 24 April 2020
Authorisation and Approval Name Title Date of Issue Version
TEIC Panel sub committee 22 April 2020 Version 1.0
Distribution This document has been distributed to the following people:
Name Title Purpose Date Version
TEIC Panel sub committee Review Version 1.0
Attached Documents There are documents embedded to this specification.
3
Table of Contents Definitions and Acronyms ....................................................................................................................... 4
Setting the Scene .................................................................................................................................... 5
List of Trade Effluent Related Transactions ............................................................................................ 6
1. Calculated Discharges ..................................................................................................................... 7
1.1 Creation of Calculated Discharges .............................................................................................. 7
1.2 Calculated Discharges – Retailer ............................................................................................... 10
1.3 Amending Calculated Discharge Volumes ................................................................................ 11
1.4 Functionality to allow erasure of Calculated Discharge Notified Volume ................................ 13
1.5 Amending the Yearly Volume Estimates (YVEs) of Calculated Discharges ............................... 15
1.6 Removal of Calculated Discharges ............................................................................................ 18
2. Guidance for Trade Effluent Strength Determination / Methodology ......................................... 18
3. Trade Effluent Transactions with Free Field Descriptors .............................................................. 22
4. Best Practice around TE Free Field Descriptors ............................................................................ 24
4
Definitions and Acronyms Terms Acronyms
CMOS Central Market Operating Systems
CD Calculated Discharges
YVE Yearly Volume Estimates
MDVOL Meter Daily Volume
FA Fixed Allowance
PA Percentage Allowance
SVAM Sewerage Volume Adjustment Method
CSD Code Subsidiary Document
WRC Wholesale Retail Code
MVI Medium Volume Interface
HVI High Volume Interface
For all Trade Effluent-related terminologies and definitions, please click here to access the Jargon
Buster. The Jargon Buster provides a breakdown of complex Trade Effluent terminologies for easy
comprehension.
5
Setting the Scene As stipulated within the Market Codes, the Central Systems (CMOS) permits trading parties to share
and maintain data pertaining to supply points. CMOS ensures that customer data is stored and used
for the purpose of reporting and Settlement.
In setting the scene for Trade Effluent related activities, it is worth noting that information relating
to these processes can be found in the following Market Codes:
• Code Subsidiary Document (CSD) 0206 Trade Effluent Processes;
• CSD 0207 Charge Calculation, Aggregation and Allocation;
• CSD 0301 Data Catalogue; and
• WRC Schedule 1 Part 3 Operational Terms.
Trade Effluent activities in CMOS are initiated with the existence of a Sewerage Service for a
Premise. The figure below illustrates the design intent of structures within CMOS.
Figure 1: CMOS Data Structure
NOTE: A successful T168.W transaction requires a Sewerage Service and a Trade Effluent Service
Component (SC). Unlike other Sewerage SCs which can be added via the T140.W (Submit
Sewerage SC) transaction, a Trade Effluent Service Component is created by submitting the
T121.W (Submit new DPID Request) transaction.
Water SPID Sewerage SPID
Customer (e.g. MOSL)
Premises (e.g. 100 MOSL Way)
Supply Points
Service Component Service Component
Tariff Tariff Tariff Data
Meters
DPID
TE Tariff Data
6
List of Trade Effluent Related Transactions The list below states all transactions in the Central Systems (CMOS) that pertain to Trade Effluent
Services (activities). It is worth noting that the list below excludes the relevant .M transactions.
Transaction Number
Transaction Name Description
T104.W Install Meter Creation of Private Water or Private Trade Effluent Meter. Other meter transactions as per Supply meters.
T121.W Submit DPID Submission of a new Discharge Point by Sewerage Wholesaler
T122.W Update Trade Effluent Operating Data
Update of Discharge Point operating data
T123.W Submit Discharge Point Meter Association
Submission by Wholesaler identifying meter associated with a Discharge Point, and the relevant percentage through the meter to be applied to the Discharge Point. The SPID specified must be the Sewerage SPID.
T124.W Submit Discharge Point Meter Disassociation
Submission by Wholesaler of a meter disassociated with a Discharge Point
T125.R Submit Calculated Discharge Volumes
Submission of Trade Effluent calculated volume for Settlement calculations. Each notification should be for the volume measured since the previous submission
T126.W Update Trade Effluent Tariff or Terminate DPID
Submission by Wholesaler of change to Trade Effluent tariff or termination of a Discharge Point
T127.W Update DPID Details Update to a Discharge Point by Wholesaler
T128.W Submit Trade Effluent Special Agreement
Initial submission and ad hoc updates of Special Agreement in effect at a Discharge Point
T136.W Submit Meter Network Data Submission of a Network for a Supply Meter to a Private Water or Private Trade Effluent Meter
T150.W Submit Trade Effluent Volumetric Adjustment
Submission of Trade Effluent Volumetric Adjustment updates from the Wholesaler
T168.W Submit Calculated Discharge Details
Sets up Calculated Discharges at a Discharge Point
T169.W Discontinue Calculated Discharge Details
Allows a Wholesaler to discontinue Calculated Discharges
TCORR178.W Amend DPID Effective Dates
Submission by Wholesaler of a change of DPID Effective From Date. This is a Retrospective Amendment Data Transaction only
TCORR179.W Erase DPID Submission by Wholesaler to Erase a DPID. This is a Retrospective Amendment Data Transaction only
7
1. Calculated Discharges
1.1 Creation of Calculated Discharges A Calculated Discharge is a mechanism in CMOS that allows for the submission of volume that
cannot be derived by deducting allowances from metered water supplied.
1) How Calculated Discharges are used in account set-ups
• SVAM of NONE Any Calculated Discharges that is created will be used in the TE volume calculation. The Calculated
Discharges volume is added after any metered/allowance volume is calculated.
The Calculated Discharges will not impact on the sewerage calculation.
• SVAM of DA Any Calculated Discharges that is created will be used in the TE volume calculation. The Calculated
Discharge volume is added after any metered/allowance volume is calculated.
The DPID’s Domestic Allowance will impact on the sewerage calculation.
• SVAM of SUBSTRACT Any Calculated Discharges that is created will be used in the TE calculation. The Calculated
Discharges volume is added to any Private TE Meter volume.
Sewerage volume is impacted: the total Calculated Discharges volume on the DPID will be subtracted
from the total volume of foul sewerage.
2) Setting up calculated discharges These are set up at Discharge Points (DPIDs) by wholesalers via T168.W (Submit Calculated
Discharge Details). The table below sets out the data items involved within the transaction.
Table 1: T168.W Submit Calculated Discharge Details
Transaction Number T168.W
Transaction Name Submit Calculated Discharge Details
From Wholesaler
To Market Operator
Data Item Number Name Notes
D2001 SPID Required
D6001 DPID Required
D6023 Calculated Discharge ID Required
D6022 Discharge Type Required
D4022 Effective From Date Required
D6025 Submission Frequency Required
D2010 Yearly Volume Estimate Required
D4003 Text Comment Field Optional
Calculated Discharge ID (D6023) can be a unique reference for the discharge. This is a free text field
for wholesalers to provide unique identification references for the discharge.
8
Discharge Type (D6022) refers to the type of effluent emitted from the NHH Customer site. The
types of discharge are;
➢ Contaminated A volume of Trade Effluent that results from contaminated surface water
➢ Estimated A volume of Trade Effluent that is difficult to measure and as such has been estimated by the Wholesaler using data provided by the customer
➢ Generic A volume of Trade Effluent that has to be calculated outside of CMOS due to the complexity of DPID set up
➢ Delayed A volume of Trade Effluent that has been determined following a delay in volumetric measurement capability
➢ Tankered A Trade Effluent volume that results from a liquid volume tankered into the site.
Submission Frequency (D6025) for Calculated Discharge indicate the regularity at which volumes
could be submitted. The frequencies for submission are;
➢ Bi-annually (B); ➢ Monthly (M); or ➢ Never (N).
Only frequencies of B and M require retailer-submitted volume.
Monthly (M)/ Bi-Annually (B)
These frequencies indicate that the created CD will need to have its volumes updated on a regular
basis. The Retailer would need to submit volumes through T125.R or TCORR125. R. The Wholesaler
provides a YVE so, if a CD has an insufficient history of volume, the YVE can be utilised in CD volume
estimation.
Never (N)
This frequency means that the created Calculated Discharge will not require volumes submitted
against it. Instead, the YVE will be used directly in settlement calculations. A daily estimated volume
will be derived from the YVE and this will be applied at the CD between the effective dates on the
T168.W. The image below shows a successful set up of a Calculated Discharge.
It is worth noting that where a new discharge is submitted, a change in the frequency may require
retailer input.
9
Figure 2: Calculated Discharge Set Up
The Effective From Date must always be within two 2 months of the current date. TCORR168 Submit
CD Data can be used to set an alternative Effective From Date.
3) When Calculated Discharges may be used
• When a site is too complex to enable the trade effluent volume to be calculated in CMOS (this
may or may not include supply or private meters). The Calculated volume may be calculated
by the Retailer or Wholesaler depending on the Submission Frequency of the Calculated
Discharge.
• The volume of Trade Effluent cannot practically be measured and so an agreed estimated
volume is used.
• The volume of Trade Effluent is very small compared to the site usage that an agreed
estimated volume is used.
• The volume of Trade Effluent is calculated from standard rainfall / surface areas.
• The volume of Trade Effluent is provided by the Customer (it may not be measureable through
metering or the measurement device is not continuous, or it is a volume in addition to the
metered volume).
• As a work around for a trade effluent volume that originates from a different SPID (i.e. the
premises is split between 2 SPIDs).
• As an alternative to a Trade Effluent Adjustment for a period of time when the Trade Effluent
volume requires alteration due to a site or measurement incident.
Discharge ID
Discharge Type Submission
Frequency
YVE
10
1.2 Calculated Discharges – Retailer This can then sometimes be followed by retailer-submitted volume with T125.R (Submit Calculated
Discharge Volume). The table below sets out the required data items for this transaction.
Table 2: T125.R Submit Calculated Discharge Volumes
Transaction Number T125.R
Transaction Name Submit Calculated Discharge Volumes
From Retailer
To Market Operator
Data Item Number Name Notes
D2001 SPID Required
D6001 DPID Required
D6008 Calculated Discharge Notified Volume Required
D4006 Effective From Date Required
D4024 Effective To Date Required
D6023 Calculated Discharge ID Required
D4003 Text Comment Field Optional
Calculated Discharge Notified Volume (D6008) indicates the volume discharged for the Calculated
Discharge. It is worth mentioning that all volumes in CMOS is notified in m3.
Figure 3: Notified Calculated Discharge Volumes
11
1.3 Amending Calculated Discharge Volumes Calculated Discharges Volumes are modelled in a similar way to meters.
Problem Definition:
Where a retailer has acquired a sewerage SPID which has a DPID and calculated discharges, volumes
may not have been submitted by the previous retailer up until the switching date. There is a defect
(S642) where the outgoing retailer cannot submit discharge volumes through T125.R, for a period
before the SPID Registration Start Date (RSD), after the SPID RSD. The workaround for this issue is to
submit the volume via TCORR125. R.
Where a retailer has submitted an incorrect discharge volume, this cannot be amended thereafter
through TCORR125.R
Figure 4: Calculated Discharge timeline
General Principles on Calculated Discharges:
It is worth noting that if you set the Calculated Discharge with a volume submission to
Never, you will not be able to submit volumes under the respective Calculated Discharge.
Calculated Discharge does not permit the existence of gaps within volume submission.
Calculated Discharge will use the YVE in the absence of volumes.
Settlement for a meter with readings uses the meter reading history. It doesn’t return to
simply using the YVE (or ILE where a YVE does not exist).
A Calculated Discharge with volumes cannot be changed into a Calculated Discharge without
volume submission.
Calculated
discharge’s EFD
01/01/2018
Discharge
volume
Discharge
volume
31/03 01/04 19/08/2018
Currently, TCORR125.R cannot
be used to overwrite either of
these two previously
submitted volumes
12
Workaround and Solution
A functionality deployed in Release 6.5 (26 July 2019) amended the defect to allow amendments of
Calculated Discharge volume via the TCORR125.R transaction. The functionality will ensure that
retailers will be able to amend the Calculated Discharge Volume, but the Effective dates will need to
be left unchanged.
Table 3: TCORR125.R Submit Calculated Discharge Volume Amendment
The highlighted image section within Figure 3 shows the submission of calculated discharge volume
for a discharge point. In order to amend the volume of the discharge, the retailer must issue a
TCORR125. R. The image below shows the amendment via the TCORR125.R transaction.
Figure 5: Successful submission of a TCORR125.R
Transaction Number TCORR125.R
Transaction Name Submit Calculated Discharge Volumes
From Retailer
To Market Operator
Data Item Number Name Notes
D2001 SPID Required
D6001 DPID Required
D6023 Calculated Discharge ID Required
D6008 Calculated Discharge Notified Volume Required
D4006 Effective From Date Required
D4024 Effective To Date Required
D4031 Authorisation Code Required
D4003 Text Comment Field Optional
13
1.4 Functionality to allow erasure of Calculated Discharge Notified Volume In the event where a retailer enters the incorrect volume for a calculated discharge, there is no
process or functionality to amend or remove the errored information. As an initial starting point,
retailers can utilise the TCORR125.R to amend the volume.
The principles for Calculated Discharges do not allow any gaps between the dates of the submission
and thus, requires the dates to remain unchanged. The image below shows a submission of volumes
for a Calculated Discharge. The item highlighted in red is subject to change.
Figure 6: errored Calculated Discharge
Retailers can submit TCORR125.R to amend the volume (i.e. change to 0) to remove the discharge
volume. The image below shows the transaction in LVI (Low Volume Interface) portal, which would
be issued by the retailer.
The item highlighted in RED shows an
Amendment to the Calculated Discharge
Notified Volume (D6008).
The items highlighted in BLUE shows the
Effective From Date (D4006) and the
Effective To Date (D4024) unchanged from
Figure 6.
Figure 7: Amending Calculated Discharge Volume
14
Upon the successful issuance of the TCORR125.R transaction to amend the volume, Figure 8
illustrates the amendment to the Calculated Discharge volume.
Figure 8: Amendment of Calculated Discharge Volume
15
1.5 Amending the Yearly Volume Estimates (YVEs) of Calculated Discharges Similar to the extrapolation of metered volume situations, in the absence of Calculated Discharge
volume, the Yearly Volume Estimate (YVE) is used to estimate volumes and charges. Where the
existing volumes are fewer than 30 days, a blend of the YVE and volume history is used. The YVE is
set via the T168.W Submit Calculated Discharge Data transaction.
If the existing volumes of Calculated Discharge are greater than 30days, the volume history is used
to extrapolate volumes. For example;
Calculated Discharge → Volume of 1825 m3 submitted for 2017-18 → Estimation shall be computed
as→ 1825/365 → CMOS will estimate 5 m3 for the daily Calculated Discharge.
Upon the creation of the Calculated Discharge, the YVE must be specified as there is no transaction
that allows Calculated Discharge to treat YVEs in a similar manner to how meters allocate YVEs for
certain periods. When a YVE is set, it shall remain the same for the entirety of its history and thus
when a new YVE is set for the same Calculated Discharge, it shall be set for the entire period of the
Calculated Discharge, including retrospectively
For example: the YVE of 1000 is set from 1 April 2017 → the YVE is changed to 2000 from 10
December 2018 → the old YVE record is retired and the new YVE shall take effect from the 1 April
2017.
The image below illustrates the YVE data in CMOS LVI portal.
Figure 9: YVE Data in CMOS LVI
To amend the YVE of the Calculated Discharge, the wholesaler must submit a TCORR168.W Submit
Calculated Discharge Data Amendment transaction. The table shows the data items requirement for
the TCORR168.W transaction.
YVE Data
16
Table 4: TCORR168.W Submit Calculated Discharge Details Amendment
Transaction Number TCORR168.W
Transaction Name Submit Calculated Discharge Details Amendments
From Wholesaler
To Market Operator
Data Item Number Name Notes
D2001 SPID Required
D6001 DPID Required
D6023 Calculated Discharge ID Required
D6022 Discharge Type Required
D4006 Effective From Date Required
D4022 Effective To Date Required on Change (Optional)
D6025 Submission Frequency Required
D2010 Yearly Volume Estimate Required
D4031 Authorisation Code Required
D4003 Text Comment Field Optional
Upon a successful submission of the TCORR168.W, CMOS will amend the YVE for the history of the
Calculated Discharge. The image below shows the amendment to the YVE Data.
Figure 10: Amended YVE
New YVE
17
Problem Definition: currently, there is no functionality to allow multiple periods within a Calculated
Discharge to have different YVEs. The workaround requires both trading parties to agree on a
prescribed YVE value for a specified period. Subject to both trading parties agreeing on a YVE value,
the wholesaler shall create a new Calculated Discharge with a different Calculated Discharge ID with
a new YVE. The process shall be repeated for the entirety of the periods.
Figure 11: Submission of T168.W for new Calculated Discharge Details
It is also worth nothing that within the T168.W process, the wholesaler shall set the Submission
Frequency (D6025) to Never (N). This will remove any retailer involvement in the submission process
as no volume can be submitted when the frequency is set to Never (N).
Figure 12: Calculated Discharges with no volumes
18
1.6 Removal of Calculated Discharges Currently, there is no functionality to delete/remove a Calculated Discharge once it is created using
T168.W or TCORR168.W.
As such, should a Calculated Discharge be created in error then it is recommended that a
TCORR168.W transaction is used to amend the YVE to zero, and the Effective From and To dates
amended such that that they sequential (e.g. 1/4/17 and 2/4/17) so that Calculated Discharges not
in use can more easily be identified. Please note that Effective From and To dates cannot be the
same date).
2. Guidance for Trade Effluent Strength Determination /
Methodology Wastewater companies have different ways of determining the charging strength for trade effluent.
These differ from company to company as well as within a company for different categories of
discharge.
To get the strength determination for a specific discharge the best option is to consult the
Wholesaler’s NHH Charges Scheme documentation. Alternatively, a G01 can be raised.
The general principles of TE Strength determination are as follows:
Zero is a valid entry [NO MOGDEN CHARGE]
If a DPID is set up such that it does not incur a volumetric charge relating to the MOGDEN
calculation, then the Ot, St and At (or any other charging determinants) will be zero.
An example of this type of DPID, is one that only incurs a standing charge because it is a Low Risk
Consent.
In some cases, a DPID may only have the R and/ or V components attributed to account, which do
not require values for Ot, St and At (or any other charging determinants).
An example of this type of account, is where a discharge is made to surface water sewer and as such
the discharge only receives service of the ‘Reception and Conveyance’ and no treatment at a sewage
treatment works.
Standard Strength or Regional Strength [STANDARD STRENGTH]
These will be published in a Wholesaler’s NHH Charges Scheme and will include a type of discharge
together with associated strength of Ot, St and At (or any other charging determinands) that it will
apply for such a discharge.
Generally, this type of trade effluent strength is used for lower risk discharges, often of similar types
across many Wholesalers, such as vehicle washing and launderettes.
A Wholesaler may allow a discharge of this type to use alternative trade effluent strengths for
charging, however, this is likely to only be accepted with supportive evidence.
Agreed Strength or Continuous Strength or Fixed Strength or Banded Strength [CONTINUOUS
FIXED STRENGTH]
Generally, this type of trade effluent strength is used for lower risk discharges.
19
However, they may also be used in the following scenarios:
• Batch discharges
• Hard to take representative samples of discharge
• Highly variable discharges
• Small/low risk discharges
Agreed Strengths have been determined by a sampling study or other available information. If a
Retailer believes that an Agreed Strength is not suitable or no longer representative of a discharge,
they should contact the Wholesaler to discuss the process or options for determining/using a
different strength.
Actual samples
There are a number of ways samples results taken throughout the year may be applied to determine
the trade effluent strength.
Whether or not a specific sample analysis is included in the determination is dependent on the
Wholesaler, for example, some may apply a statistical analysis to remove very high or low strength
results, whilst others will include all results if the sample taken was representative of what was being
discharged at the time.
a. Annual Fixed Strength [1YR FIXED STRENGTH]
Samples are taken throughout a year then used to determine a representative charging strength for
the following year. i.e. the previous year’s trade effluent strength will be apply to the current year’s
volume.
It is likely that the sample results will undergo a form of statistical analysis to determine the charging
strength.
As such the Ot, St and At (or any other charging determinants) are the same throughout a year
(generally the FY).
b. 3 yearly Fixed Strength [3YR FIXED STRENGTH]
Samples are taken throughout a 3-year period then used to determine a representative charging
strength for the following 3 years.
It is likely that the sample results will undergo a form of statistical analysis to determine the charging
strength.
As such the Ot, St and At (or any other charging determinants) are the same throughout a 3-year
period.
c. Seasonal Fixed Strength [SEASONAL STRENGTH]
Historical samples are used to determine a representative charging strength for a set period of time
during a year. The Wholesaler would need to be contacted for specific details regarding the seasonal
time periods.
As such the Ot, St and At will vary during the year for specific periods. It is likely that the sample
results will undergo a form of statistical analysis to determine the charging strength.
20
d. Settlement Period Average [SETTLEMENT PERIOD STRENGTH]
Samples taken are used for the settlement periods in which they are taken.
If there is more than one sample taken during the period, then it is likely that an average of the two
will be taken to determine the charging strength.
The Ot, St and At (or any other charging determinants) will vary during a year. Variation month to
month may be significant.
e. Rolling Period Average [12 MONTH ROLLING AVERAGE], [6 MONTH ROLLING AVERAGE] or [3
MONTH ROLLING AVERAGE]
Samples taken through the year apply to specific rolling period averages, for example, 3, 6 or 12
months.
This means that for a 3-month rolling period, a sample taken in May will not only be included in the
May settlement period, but also June and July as well. In other words, a July charge period will
consider all samples taken in July, June and May. An August charge period will consider all samples in
August, July and June, and so on.
The average of relevant results for a settlement period will be used as the trade effluent strength.
The Ot, St and At (or any other charging determinants) will vary during a year. Variation month to
month is limited due to averaging of samples across a number of months.
f. Rolling Sample Number Average [SAMPLE NUMBER ROLLING AVERAGE]
The Ot, St and At are updated whenever a new sample is taken. When a new sample is taken, the
charging strength is calculated using the most recent X number of samples; X being specified in the
Wholesaler Charge Scheme. Therefore, if a sample is taken in the middle of a settlement period,
then new Ot, St and At will be used for the days of the sample date and onwards until another
sample is taken.
The Ot, St and At (or any other charging determinants) will vary during a year and during a month /
charge period.
g. Most Recent Actual Sample [MOST RECENT ACTUAL SAMPLE]
The Ot, St and At for a specific charge period are the most recent sample analysis. i.e. every time a
sample is taken, and the results are available, the Ot, At and St in the market are updated with the
results at that time and will remain until the next sample is taken. Therefore, if a sample is taken in
the middle of a settlement period, then the original Ot, St and At will be used for the days prior to
the new sample date and the new Ot, St and At will be used for the days of the sample date and
onwards.
The frequency of this can be varied so the Ot, St and At (or any other charging determinands) will
vary during a year and possibly during a month.
21
Averaging of Samples
For most scenarios where actual samples are taken, an average of the sample results is used. There
are a number of different ways an average may be calculated;
Straight average of results in mg/l
This means that the sample results are all added together and then divided by the number of results
to get the average value.
Volumetrically adjusted or Weighted average
This means that each sample result is converted into a load by using the associated volume
discharged during the period of the sample. All loads are then added together and divided by the
total volume to determine the charging strength.
The reason for doing this is to take into account a changing discharge profile e.g. low discharge
volumes at a high strength one month, and large discharge volumes of low strength another month.
Statistical analysis combined with either (i) or (ii).
Charging Strength CMOS Option Summary
• NO MOGDEN CHARGE
• STANDARD STRENGTH
• CONTINUOUS FIXED STRENGTH
• 1YR FIXED STRENGTH
• 3YR FIXED STRENGTH
• SEASONAL STRENGTH
• SETTLEMENT PERIOD STRENGTH
• 12 MONTH ROLLING AVERAGE
• 6 MONTH ROLLING AVERAGE
• 3 MONTH ROLLING AVERAGE
• SAMPLE NUMBER ROLLING AVERAGE
• MOST RECENT ACTUAL SAMPLE
• OTHER
NOTE: The above will also apply to other charging parameters Xt, Yt and Zt if these are enabled.
22
3. Trade Effluent Transactions with Free Field Descriptors Data submitted into the Central Systems has been parameterised to allow specific combinations into
the system. Whilst some data are included as a valid set, other data require manual input i.e. a free
field descriptor field.
Data items with free descriptor fields can tend to impact on the calculation of settlement/charges
(such as meter reads, calculated discharge volumes etc.) as long that data logical type is met.
However, some data items may not impact or have minimal impact on operational processes to
trading parties such as Text Comment Field, Secondary Addressable Object etc. The purpose of this
section of the guidance document is to provide best practice information on how to utilise free field
descriptors for Trade Effluent related transactions. The table below shows a list of Trade Effluent
transactions with free field descriptors.
Table 5: Trade Effluent Transactions
Transaction Number
Transaction Name Description Text Comment Field
Visible on LVI
T121.W Submit DPID Submission of a new
Discharge Point by Sewerage Wholesaler
Y N
T122.W Update Trade Effluent Operating Data
Update of Discharge Point operating data
Y N
T123.W
Submit Discharge Point Meter Association
Submission by Wholesaler identifying meter associated with a Discharge Point, and the relevant percentage through the meter to be applied to the Discharge Point. The SPID specified must be the Sewerage SPID.
Y N
T124.W Submit Discharge Point Meter Disassociation
Submission by Wholesaler of a meter disassociated with a Discharge Point
Y N
T125.R
Submit Calculated Discharge Volumes
Submission of Trade Effluent calculated volume for Settlement calculations. Each notification should be for the volume measured since the previous submission
Y N
T126.W
Update Trade Effluent Tariff or Terminate DPID
Submission by Wholesaler of change to Trade Effluent tariff or termination of a Discharge Point
Y N
T127.W Update DPID Details Update to a Discharge
Point by Wholesaler Y N
T128.W Submit Trade Effluent Special Agreement
Initial submission and ad hoc updates of Special
Y N
23
Transaction Number
Transaction Name Description Text Comment Field
Visible on LVI
Agreement in effect at a Discharge Point
T150.W
Submit Trade Effluent Volumetric Adjustment
Submission of Trade Effluent Volumetric Adjustment updates from the Wholesaler
Y N
T168.W Submit Calculated Discharge Details
Sets up Calculated Discharges at a Discharge Point
Y N
T169.W Discontinue Calculated Discharge Details
Allows a Wholesaler to discontinue Calculated Discharges
Y N
TCORR178.W
Amend DPID Effective Dates
Submission by Wholesaler of a change of DPID Effective From Date. This is a Retrospective Amendment Data Transaction only
Y N
TCORR179.W
Erase DPID
Submission by Wholesaler to Erase a DPID. This is a Retrospective Amendment Data Transaction only
Y N/A
24
4. Best Practice around TE Free Field Descriptors This section of the guidance provides best practice information on the utilisation of the TE
transactions with free field descriptors.
Transaction ✅ Best Practise for D4003 Text Comment Field
1) T121.W Submit DPID
Confirmation of discharge type - Consent, STDA. SVL (Short terms) and any further information deemed appropriate
2) T122.W Update Trade Effluent Operating Data
If to be utilised identifier for Fixed Forward, Agreed strengths, variable strengths - ammonia enhancement
3) T123.W Submit Discharge Point Meter Association
Potential to use for confirmation of installation/exchange reason etc
4) T124.W Submit Discharge Point Meter Disassociation
Potential to use for confirmation of removal reason etc
5) T125.R Submit Calculated Discharge Volumes
Explanation from Retailer of how volume was calculated and when it would be reviewed
6) T126.W Update Trade Effluent Tariff or Terminate DPID
Potential to use for confirmation of amendment &/or removal reason etc
7) T127.W Update DPID Details
Confirmation of data updates - what aspect had been updated when completing transaction
8) T128.W Submit Trade Effluent Special Agreement
9) T150.W Submit Trade Effluent Volumetric Adjustment
Break down of allowance and calculation provided
10) T168.W Submit Calculated Discharge Details
Used at current - provides details around calculation to arrive at figure
11) T169.W Discontinue Calculated Discharge Details
Potential to use for confirmation of removal reason etc
12) TCORR178.W Amend DPID Effective Dates
Potential to use for confirmation of amendment reasons
13) TCORR179.W Erase DPID Potential to use for confirmation of removal/erasing reasons
Things to Note:
• D4003 only allows 255 characters; and
• This field may not be available for HVI or MVI interfaces.