This function allows the user to record rates from a particular supplier relevant to a particular location with effective dates OR may record the global rate of a supplier applicable to all locations by leaving the location field blank.
The location or consumption category or the organization / supplier or DOL Code is required to be entered as a parameter before the Show is selected and the existing data is displayed.
The Sort By options are also provided. The user may choose 3 fields on which to sort.
The user may display existing data per sub region, city, location , organisation, tariff plan, consumption category, dol code, action code and between 2 financial periods.
The supplier/organization, consumption category, agreement, sliding scale start and end units, effective date, tariff rate, DOL code and action codes are mandatory fields.
The organization / supplier is part of the key because one may have a situation where there are 2 or more suppliers for the same category e.g. electricity, for the same location / even globally. The organisation is populated from the Location_Master_Organisation table where the type is 2 (vendor/external).The logic being that Location_Master_Organisation holds all valid consumption-related suppliers. The decision to record a rate against a supplier should then come from a valid consumption-related supplier.
The tariff plan is not mandatory. If tariff plans are selected for a specific location (building) and there is no other record without a tariff plan for the same location, the Consumption Master record will require the selection of one of these tariff plans.
It also caters for the agreement – being either a billed tariff or a prepaid tariff.
In addition to the above, it also allows for the capture of a sliding scale of tariff. This means that for a certain number of consumption units e.g. 0 to 1000 units, the tariff may be R1.30 but from 1001 units to 10000 units, the tariff is R1.55 and from 100001 units upwards, the tariff is R2.00 per unit. The system will not allow a record to be added where the from and to units sliding scale makes no sense. It also expects to start from 0.
In order to determine the correct rate for a supplier at a specific location (building), the entry of a record with the location entered is first found. If none exists, existence of a record without a location is searched for. In the event that none exists at all, the tariff verification code will state ‘NO RATE FOUND’ on the Consumption Master data entry.
A field in the grid called New Tariff Rate allows the user to enter the new/increased rate. The user clicks on select, enters the new effective date and rate and clicks on Apply and a new record is created.
The record can never be physically deleted if used in the Consumption Master function but may be marked as inactive. If a mistake was made and it was incorrectly entered, and as yet unused, it may be deleted. This serves to protect the data’s authenticity historically.
All fields in the grid, with the exception of the Comments field, are mandatory.
The relevant table is Equipment_DOL_Consump_Tariff.
A specific profile exists to enable a user to make changes to a carbon consumption record that specifically affect the rate verification. It is called Consumption Tariff STATUS Maintainer. Should the user have this profile and he/she is the person who originally made the change to a specific record, he/she may make changes to the Tariff Verification Status without the system recalculating and thus changing the Tariff Verification Code.