How to setup and configure NSW OEH regulatory data pack. (Pre POEO 2015)
Mandalay CS is capable of capturing transactions in a format that can then provided to the NSW Office of Environment and Heritage using preexisting system reports. These reports can be used to produce a raw extract of weighbridge data or in a format that can be translated into the Section 88 Report.
To be able to use this feature the system needs to be loaded with a data pack that can be provided by Mandalay Technologies.
This article explains configuration and setup of data in Mandalay CS once the data pack has been deployed.
Note: There may be an additional subscription cost for the deployment of this data pack.
OEH EPA Data Pack
The data pack consists of:
- OEH categories and Vehicle Type Weight Conversions
- Reporting views
- Standard OEH reports (as described in Section 8). A report to generate information required to complete a Section 88 report, as well as a detailed EPA Export Data report, and some analysis reports to assist in submission
This section advises how the OEH data can be linked to your existing reference data to automatically populate the OEH data for transactions.
Waste Stream
The primary OEH category for recording on all transactions is the waste stream.
Waste Stream Favorites
Waste Stream can be linked to various items via Favourites in Administration:
- Products
- Clients
Tip: If your products can be cleanly grouped by waste stream, you would associate one waste stream to the product, and it would then automatically be selected in ticketing, and recorded on the ticket.
If the product is only used by a subset of waste streams (eg, C&I or C&D) you can associate both with the product, and then the ticketing operator will only need to select between the two option.
Waste Sub-Stream
The Municipal waste stream waste needs to be further refined by sub-stream. Non-municipal waste streams need to use the “N/A” (not applicable) was sub-stream.
Waste Sub-Stream Favorites
Waste Sub-Stream can be linked to various items via Favorites in Administration:
- Products
- Clients
Tip: If your products can be cleanly grouped by waste sub-stream, you would associate one waste sub-stream to the product, and it would then automatically be selected in ticketing, and recorded on the ticket.
As all non-municipal sub streams are all “N/A”, it may be possible to simply link ‘Not Municipal” as the sub-stream for commercial only clients.
Material Composition
Material Composition can be linked to various items via Favorites in Administration:
- Products
- Clients
- Vehicles
Tip: If your products can be cleanly grouped by material composition, you would associate one material composition to the Product, and it would then automatically be selected in ticketing, and recorded on the ticket.
Vehicle Types
Vehicle Types are only required to be captured if you are using vehicle type weight conversions (deemed weights). If not, this can be left blank, and it will default to the required “N/A” in the reports.
However, if you wish to record the OEH Vehicle types, simply link these in the vehicle tab in Administration.
Local Government Areas
Local Government Areas and their associated regions (eg, SMA, RRA, ERA) are all preloaded in the data pack. This can be used to determine which regions transactions come from and go to, and can be linked to your locations.
This information is currently not used in either the Section 88 report or the EPA Export Data report. However, you may wish to record this data.
Each Site can have the LGA it belongs to linked in administration (See locations screen above).
For external locations, it may also be useful to identify which region they come from, in order to determine the rate to use. However, if your sites are in the Sydney Metropolitan Area (SMA), the rate in use will be the SMA rate irrespective of the source, this may not be required. However, if your site is in another region, it may be necessary to distinguish between waste from different regions to determine the applicable rate, if your facility accepts materials from other regions.
Client Configured OEH Data
Site Facilities
In order to generate the Section 88 Report, all site facilities have to be identified. This is done by linking site locations to a Facility category.
Note: If your site has multiple facilities, you will need to setup your facilities. If you have multiple facilities and do not create the facilities for them, you will only be able to generate the OEH reports by site.
You can create the Facilities in the categories tab in Administration. Change the Category filter to Facility.
- Set the name of the facility.
- Enter the EPA license number in the Code field.
Single Facility for Site
If your site only has a single licensed facility, you will only need to set the Facility at the top level location of the site. All locations underneath this location will inherit the facility ID of the parent.
Note: The defaulting of the facility will not show in the sub locations when your select them but any reporting will make use of the inheritance.
Multiple Facilities for Site
If your site has multiple facilities, you can set the default one at the top level (see the step above), and then override the facility for the sub facility.
Note: Note that the facility configuration can be done at any time prior to generation of the submission reports. The submission reports reflect the current configuration of the facilities.
Vehicles
There are two attributes of vehicles that you may wish to configure.
- Vehicle Type - If you are using weight conversions for net weight determination, you will need the vehicle type configured.
- Actual License Plate - If you are using asset numbers as shortcuts for the license plates used in ticketing so they sort differently, you may wish to configure the Actual License Plate in administration. This will then appear on the Export EPA Data report.
Deduction Identification Numbers
There are three exemptions in effect that require a Deduction Identification Number (DIN):
- Approved community services exemptions
- Approved emergency incidents exemptions
- Approved usage deductions
These are handled by exemption events. Generic exemption types have been included in the data pack for community services, emergency incidents, and approved usage.
However, for emergency incidents, you may wish to create your own events for the specific incidents.
Community Services Exemptions
Community services exemptions are typically against a client. It is simplest to configure these in admin against the client. To do this, go to the Clients tab in admin, and select the default “Community Services” event, and enter their EPA Approval Number in the Levy Exemption Code field. Then, when tickets are generated for this client, the exemption will automatically be applied, and their approval number recorded.
Approved Emergency Incidents
For emergency incidents, you may wish to create new events for each incident, and record the specific Approval Number in the default code for that event. That specific event can be linked to either a location, a product, or manually selected in ticketing.
Approved Usage
For Approved Usage recording, the default loaded “Approved Usage” event must be used.
This should then be recorded against an “Onsite Usage” location as a Destination Exemption Event, and the DIN entered. A Levy Exemption Note should also be set here to populate the “Approved Purpose” note required for the Section 88 report.
- Select the Approved Usage event for the destination on site
- Enter the DIN number
- Enter the purpose
Note: You cannot create and use your own events for Approved Usage as the OEH reports need to be able to make the distinction between the exemptions and the Approved Usage Deductions.
The operator can select the exemption in ticketing and manually enter the DIN. The notes are the notes that will show on the section 88 report as the “approved purpose"
- Select the Approved Usage event for the destination on site
- Enter the DIN number
- Enter the purpose