Mandalay CS 3.2Regulatory ReportingNew South WalesHow to setup and configure NSW OEH regulatory data pack. (Pre POEO 2015)

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

Waste Stream

The primary OEH category for recording on all transactions is the waste stream.

 

Waste Stream Favorites

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

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 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

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

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

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.

Weight Conversion

Weight Conversion

There is a weight conversion table in Administration that contains the OEH weight conversions loaded by the data pack.

Warning: There is currently no need to edit this pre-loaded data, so do not use this tab, or give any users permissions to edit it.

Client Configured OEH Data

Site Facilities

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.

  1. Set the name of the facility.
  2. Enter the EPA license number in the Code field.

Single Facility for Site

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

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

Vehicles

There are two attributes of vehicles that you may wish to configure.

  1. Vehicle Type - If you are using weight conversions for net weight determination, you will need the vehicle type configured.
  2. 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

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

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

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.

  1. Select the Approved Usage event for the destination on site
  2. Enter the DIN number
  3. 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"

  1. Select the Approved Usage event for the destination on site
  2. Enter the DIN number
  3. Enter the purpose