INT586 - Customer Movement

Trigger type	Time triggered
Published	Daily
Audience	Registered Participants
Output file name	int586_v[n]_cust_movement_[p]~yyyymmddhhmmss.csv

Report purpose

This report shows the changes in mirn status made in the previous 30 days. This includes what mirns have changed hands, the commissioned status and the date of change in the movement (won/loss) status. Distributors and Retailers may wish to use this report to track their mirn movements and validate wholesale settlements.

Audience notes

This distributor/retailer specific report is produced daily with a rolling 30-day period.

There is no equivalent VIC MIBB Market Information Bulletin Board. The IT interface through which AEMO communicates with gas market participants. report.

Content notes

Each report contains the:

• network name

• site identifier

• gas date

• movement

• status type (which can be commissioned or registered)

• tariff type

• meter type (where PD refers to interval meters, PB refers to basic meters and PC means transmission connected meter)

Data content

Name	Data Type	No Nulls	Primary Key	CQ	Comments
network_name	varchar 40 .	True	False	N
mirn	varchar 10 .	True	True	N	QLDGAS equivalent to National Meter Identifier (NMI)
gas_date	varchar 20 .	True	True	N	Gas day the status of the MIRN changed e.g. 30 Jun 2007
movement	char 5 .	True	True	Y	Won or Lost or None
status_type	char 15 .	True	True	Y	Commissioned Registered (ie Decommissioned or never been Commissioned)
tariff_type	char 1 .	True	False
meter_type	char 4 .	True	False		PD, PC, or PB
last_update_datetime	varchar 20 .	True	False	N	Date and Time the data record was updated in AEMO's database.
current_date	varchar 20 .	True	False	N	Date and time report produced (e.g. 30 Jun 2007 06:00:00)