INT381 - Tie Breaking Event

Trigger type	Time triggered
Published	Daily at 06:00
Audience	Public
Output file name	int381_v4_tie_breaking_event_[p]~yyyymmddhhmiss.csv

Report purpose

This report provides information about tie-breaking events that occurred on each gas D on the following gas day D+1.

Audience notes

This report details the tie-breaking events from the previous gas day for the 5 intraday scheduling intervals.

This report does not take into account MPs submitting bids that are inconsistent with their accreditations constraint. In an event MPs bids exceed their accreditation, a tie breaking event may be incorrectly reported.

Content notes

Each row in the report provides details for each mirn the tie-breaking events for the previous gas days 5 intraday schedules.

Data content

Name	Data Type	No Nulls	Primary Key	CQ	Comments
gas_date	Varchar 20	True	False	N	The date of gas day being reported (for example, 30 Jun 2012)
schedule_interval	Int	True	True	N	(1,2,3,4 or 5)
transmission_id	Int	True	True	N	Schedule ID from which results were drawn
mirn	Varchar 10	True	True	N	Meter Registration Identification Number of the system point
tie_breaking_event	Int	False	False	Y	Total tie-breaking event
cc_bids	Int	False	False	Y	If the tie-breaking bids have CC allocated to them, list number of bids with CC allocated to them
non_cc_bids	Int	False	False	Y	If the tie-breaking bids do not have CC allocated to them, list number of bids with no CC allocated to them
part_cc_bids	Int	False	False	Y	If the tie-breaking bids have part CC allocated to them, list number of bids with part CC allocated to them.
gas_not_scheduled	numeric(18,9)	False	False	Y	Aggregate tie breaking bids - aggregate tie breaking bids scheduled
current_date	Datetime	True	False	N	Date and time report produced (for example, 30 Jun 2012 06:00:00)