How is my data reported in the NSW EPA WARRP summary report?
Overview
This article is to help Mandalay customers understand how the WARRP summary report available in Facility Management Data Export derives its information from the transaction data captured in the Facility Ticketing module. It assume the reader already has an understanding of the NSW EPA regulatory reporting requirements and knowledge of how to setup the Mandalay Facility system to capture regulatory data to meet the NSW EPA requirements.
The WARRP report available in WBR is designed to be run after all transactions for a month have been recorded and adjusted where necessary. If will group all transaction data by the year\month of the transaction, the facility that the transactions was recorded against and then each section that is required to be reported in the WARR Portal.
Transactions
The NSW EPA does not specify how a transaction should be reported in the WARR Portal where more than one material type exists, so to ensure all material types are reported, the WARRP summary report is designed to report on each item included in the transaction. This also removes the need to process any roll up logic that would be required if each item had to be merged into one re-portable entry.
Non Reported Transaction Items
The following types of transactions are excluded from the WARPP summary.
- Any transaction item where a Service or Visitor exemption has been recorded.
- Incomplete transactions. These are transactions where the Date Out has not been recorded.
- Inactive transactions.
- Internal movements within the same facility where no exemption has been recorded.
Note: These transactions are only excluded from that WARRP summary report, they are still included in the Audit Export report.
Reporting Date
The month and year used in reporting the summary data is based on the Date Out recorded in the transaction. This is the effective date of the transaction, which means its possible to record a transaction in the following month and have it report against month the transaction is effective for.
Using the Date Out field means that any adjustments to transactions after submission of the month will require to report to be rerun for that month.
Facilities
The Mandalay Facility system has the concept of a site. This is generally a physical site and does not always represent an are of a site that may be licensed separately. For example a landfill site may have a separate area licensed as a transfer station. The landfill and the transfer station in this example are considered separate facilities of the same physical site.
To allow reporting to be separated by facility the WARRP report will use the transaction's destination locations, Facility property to identify which facility is recorded against. If the destination location does not have a Facility property the report will look at any ancestor locations to determine the Facility to report. See this article for more information on how to setup a facility against a location.
For customers that move waste between the facilities, each facility will need to have a transaction recorded against it. So that a waste transfer need only be recorded once when being processed the Facility system has a feature in the contracts module to record 2 transactions for a cross facility internal movement.
Note: The Internal Movement contract feature is only intended for movements within the same physical site. Movements between physical sites should be recorded at 2 separate transactions at each site.
Tonnes
The tonnes value represented in the WARRP summary is represented of any weight recorded against an individual transaction item. This can be the net weight as recorded over the weighbridge using the Gross and the Tare weight or the nominal weigh as defined against the product. The net weight recorded against a weighed product will always be adjusted to not include the weight of any additional non weighed items added to the transaction. Because of the net weight adjustment the sum of the weights recorded against each item in the transaction will always total the Gross minus Tare net weight for the transaction.
Known Weight Calculation Issues
Because the system will automatically deduct the nominal weight from the vehicles net weight, its possible for a negative net weight be recorded against the weighed product. This will occur where the nominal weight of all the items is higher than the recorded vehicle net weight. In these cases the WARRP report will show the full nominal weight but will include the negative tonnes against the weighed product. This is to ensure that the vehicles net weight is being reported to the EPA.
In cases like this its is advised to review the nominal weigh used for the non weighed product.
Sections
The WARRP summary report is split into 4 main sections that are designed to represent the section of the WARR portal page where the monthly submissions are processed. Each section, except Processed Waste, is then broken down into sub sections that represent the same subsections available in the WARR portal.
If there is no data to required for a specific section/sub section, then no information will be presented in the report. If you don't see data in a section that you are expecting to see data for, then you will need to review the current regulatory classification setup in your system
Waste Received
Waste received is for any transaction on inbound movements. To be classified an inbound movement the source location must be under the external locations branch of the location tree and the destination location must be child of the site being reported against. When the internal movement contract process is used a special system location of Internal Movement is used in both transactions and is linked to the external location branch so ensure it is reported as waste received at the destination facility.
This section is split into 4 sub sections. Each section represents the different waste streams that can be applied to a transaction.
- Commercial and Industrial - CI
- Construction and Demolition - CD
- Municipal Solid Waste - MSW
- Unknown - UNK
Within each sub section has the same data grouping will aggregate the tonnages reported. The grouping is based on source type, material type and then any additional data that may be applicable (e.g. DIN number or source facility name)
Source Type
There are 7 specifics source types that can be presented in the summary report and each type is derived in a specific way.
- Exemption - The name of the exemption event used will be shown. (See exemptions section below for more details)
- Another Facility - Any transaction where the waste sub stream is NA and the source location has a numeric code recorded against the facility property. Each facility will will present its own summary value.
- Custom Source - Any transaction where the waste sub stream is NA and the source location does not have a numeric code recorded against the facility property of the location will appear. The facility name will be presented. (See custom source types for more details on custom source types)
- Other Generator - Any transaction where the waste sub stream is NA and there is no facility defined in the source location.
- Other Domestic Kerbside Collection - Any transaction where the sub stream is 'Domestic waste (other than garden organics)' and the waste stream is MSW.
- Other General Public - Any transaction where the sub stream is 'Other domestic waste (other than garden organics)' and the waste stream is MSW.
- Other Council - Any transaction where the sub stream is 'Other council waste (other than garden organics)' and the waste stream is MSW.
- Other Garden Organics Collection - Any transaction where the sub stream is 'Garden Organics' and the waste stream is MSW.
Note: If a transaction has a non NA sub stream and does not have a waste stream of MSW then the source type will be blank. This means the transaction is invalid and should be corrected.
Material Type
The material type used against the transaction item will be used when reporting a transaction items tonnes and is used as the second level of grouping within the Waste Received sub section. Both the code and the name will be presented.
Exemptions
Exemptions are only applicable at landfill facilities so any exemptions recorded at transfer stations are ignored and will be treated as non exempt. The definition of a landfill is defined where a destination location or one of its ancestors in the location trees, has a purpose is set as Disposal.
Custom Source Types
Its possible to define a custom source type by creating a Facility category that has no code. The name of this facility will then be presented for waste received where the source location is linked to that Facility category. This can be helpful when NSW EPA releases new source types (e.g. container deposit scheme)
Processed Waste
The Processed Waste section is specifically for reporting on any on site processes that meet the Resource Recovery Orders. Any internal movement within the same facility, that has an exemption recorded against it, that is not the Approved Usage exemption, will have its tonnes recorded in this section. The tonnage value is a total of all internal movements with an exemption so there is no break down by RRO.
An internal movement is defined as a transaction where the source and the destination location if linked to the same site ID. As this report considers multiple facilities within the same physical site, the source and destination location also have to the relate to the same Facility.
Note: Any internal movement transaction where no exemption exits will not be reported in this report.
Deductions - Approved Operation Purposes
Deductions for Approved Operation Purposes are for any internal movements within the same facility that have and Approved Usage exemption recorded against it. This is essentially the same as the Processed Waste section but the exemption must the Approved Usage exemption that is available in the NSW EPA data pack.
Note: Any internal movement transaction where no exemption exits will not be reported in this report.
The Approved Usage exempt transactions will be aggregated by DIN number and the Waste Stream recorded on the transaction.
Deductions - Waste transported from site
This deduction section is for any re portable outbound transaction. To be classified an outbound movement the destination location must be under the external locations branch of the location tree and the source location must be child of the site being reported against. When the internal movement contract process is used a special system location of Internal Movement is used in both transactions and is linked to the external location branch so ensure it is reported as deduction at the source facility.
This section is split into 5 sub sections. Each section represents the different destination purposes.
- Waste transported from site for disposal at a licensed waste facility - Any outbound transaction where the destination location has a Facility category applied to it that has a valid EPA license code recorded and the Destination Purpose for the location, is set to Disposal.
- Waste transported from site for lawful recovery at a licensed waste facility - Any outbound transaction where the destination location has a Facility category applied to it that has a valid EPA license code recorded and the Destination Purpose for the location, is set to either Re-use, Recovery or Recycling.
- Waste transported from site under a Resource Recover Order- Any outbound transaction that has an exemption that is not the Approved Usage exemption provided as part of the data pack.
- Waste transported from site for lawful recovery (not a licensed waste facility) - Any outbound transaction that has a destination locations without a Facility or has a Facility without a code. Using a facility without a code allows for custom destination type (e.g Interstate).
- Unknown - This section is for outbound movements that don't meet any of the above sections requirements and will need further investigation to determine why these outbound transaction are not be reported correctly
The tonnes presented in the outbound deductions section is grouped by the destination Facility set on the transaction or in the case of RRO transactions the RRO code will be used. The tonnes will then be grouped by waste type and then waste stream.
WARRP Details
In addition to the WARRP summary a WARRP Details Data Export is also available. This means that its possible to see the details of the data used in the summary report. The details view will show the section and sub section that each transaction will be reported under
EPA Audit Export
Along with the summary report explained above an additional export is available in Facility Management Data Export that can be used to provide an export of data based on the NSW EPAs Waste Levy Benchmark Requirements . The state government will require an extract for this data for a given reporting period. The export can be found in Facility Management Data Export , the report is called "NSW EPA Audit Export". Details on the data produced by this report can be found here.
Using the Audit Extract to Audit the WARRP Summary
The difference in how the data is reported in the two reports makes it difficult to reconcile. The WARRP summary will allow the weight recorded against each item recorded in a transaction where as the NSW EPA requirements for the audit data only allow the weight be recorded against the weighed item and doesn't allow nominal weight adjustments for each items products like mattresses.
Example
Below is an example of a transaction where nominal weight each items have been used in a transaction.
This transaction would then appear in the WARRP report like this. The nominal weight for each non weighed product is displayed and the adjusted net weight is shown for the primary weighed item.
Note: this is not the WBR WARRP report but represents the data used to generate the report.
The Audit Extract would then show this transaction in the following way. The primary weighed item is reporting the total net weight for the transaction and the non weighed items have to show no value for the net weight. This is because of the definition for the Net column in the Waste Levy Benchmark Requirements (see below)
Update: Changes to the EPA Audit Export
Following recent discussions with the NSW EPA. The audit export will change for customers that upgrade to 3.7. This version will include 2 new fields that will assist in reconciliation between the WARRP summary and the Audit Export. The new columns are:
- Nominal Weight - This will show the net weight applied to a non weighed item. This is generally applied through the nominal weight value.
- Adjusted Net - This will reflect the net weight applied to an item in the transaction. Where weighed and non weighed items are included in one transaction, the weighed items adjusted net will reflect the weighbridge calculated net weight minus any nominal weights applied to the non weighed items.