INT337 - Current FRO

Trigger type	Event triggered
Published	Issue of Settlement Statement
Audience	Market participant and Distributor
Output file name	int337_v[n]_bm_fro_[p]~yyyymmddhhmmss.csv

Report purpose

This report shows the MIRNs associated with a retailer. Retailers may wish to use this report to get a listing of all their MIRNs that they own.

Note this report lists ALL MIRNs in the AEMO Australian Energy Market Operator Meter Register The meter register data stored in MSATS, which includes both the metering register and other data. regardless of the MIRN Meter Identification Reference Number. A unique number that identifies each gas meter. status. The MIRN status can be Registered, Commissioned, De-commissioned, or De-registered. Section 1.0 of the Victorian Retail Market Procedures lists the definitions for each MIRN states. Section 2.8 of the Victorian Retail Market Procedures Distributors lists the meter management obligations and notices to AEMO and Retailers.

Audience notes

A report is generated when the settlement statement is issued, for example:

• Preliminary

• Final

• Revised

This is so that any retrospective transfers that may have applied in settlements will be in the report. The report shows the financially responsible organisation for MIRNs on the last day of the month for the settlement month it was produced.

The report contains a large csv Comma Separated Values. A file format for data using commas as delimiters. file that is compressed into a zip format.

For distributors, this report shows the basic MIRNs which they are a distributor of.

For retailers, this report shows the basic MIRNs that they are the financially responsible organisation (fro).

Content notes

Each report contains the:

• gas date

• mirn identifier

• fro details

• mirn checksum (used to validate that the correct mirn is assigned)

• base load (the summer load for that site)

• temperature sensitivity factor (the factor used along with the base load to estimate daily consumption)

• post code

• date and time when the report was produced

Data content

Name	Data Type	No Nulls	Primary Key	CQ	Comments
gas_date	varchar 20	True	False	N	Date for which data has been generated (e.g. 29 Jun 2007)
mirn	varchar 10	True	True	N	Vicgas equivalent to National Metering Identitifier (NMI) for which Current FRO is requested
fro_name	varchar 40	True	False	N	This field is optional in the request.
fro_from_date	varchar 20	True	False	N	Date participant has been fro from for this mirn (e.g. 29 Jun 2007)
mirn_checksum	char 1	False	False	N
base_load	Numeric(9,1)	False	False	N
temp_sensitivity_factor	Numeric(9,2)	False	False	N
postcode	char 4.	False	False	N
current_date	varchar 20	True	False	N	Date and Time report generated e.g. 29 Jun 2007 06:00:00)