Skip to content

BIDOFFERPERIOD_SPARSE

BIDOFFERPERIOD shows 5-minute period-based Energy and Ancillary Service bid data. BIDOFFERPERIOD is a child table of BIDDAYOFFER.

Package

BIDS

Visibility

Private, Public Next-Day

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
DUID varchar(20) 🔑 varchar(20) 🔑 Dispatchable Unit ID
BIDTYPE varchar(10) 🔑 varchar(10) 🔑 The type of bid, one-of ENERGY, RAISE6SEC, RAISE60SEC, RAISE5MIN, RAISEREG, LOWER6SEC, LOWER60SEC, LOWER5MIN, LOWERREG
TRADINGDATE datetime(3) 🔑 date 🔑 The trading date this bid is for
OFFERDATETIME datetime(3) 🔑 datetime2(0) 🔑 Time this bid was processed and loaded
DIRECTION varchar(20) 🔑 varchar(20) 🔑 The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL
PERIODID numeric(3, 0) 🔑 smallint 🔑 Period ID 1 to 288
PERIODIDTO numeric(3, 0) smallint (not nullable) Period ID Ending
MAXAVAIL numeric(8, 3) smallint (not nullable) Maximum availability for this BidType in this period
FIXEDLOAD numeric(8, 3) smallint Fixed unit output MW (Energy bids only) A null value means no fixed load so the unit is dispatched according to bid and market
RAMPUPRATE numeric(6, 0) smallint MW/Min for raise (Energy bids only)
RAMPDOWNRATE numeric(6, 0) smallint MW/Min for lower (Energy bids only)
ENABLEMENTMIN numeric(8, 3) smallint Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only)
ENABLEMENTMAX numeric(8, 3) smallint Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only)
LOWBREAKPOINT numeric(8, 3) smallint Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only)
HIGHBREAKPOINT numeric(8, 3) smallint Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only)
BANDAVAIL1 numeric(8, 3) smallint (not nullable) Availability at price band 1
BANDAVAIL2 numeric(8, 3) smallint (not nullable) Availability at price band 2
BANDAVAIL3 numeric(8, 3) smallint (not nullable) Availability at price band 3
BANDAVAIL4 numeric(8, 3) smallint (not nullable) Availability at price band 4
BANDAVAIL5 numeric(8, 3) smallint (not nullable) Availability at price band 5
BANDAVAIL6 numeric(8, 3) smallint (not nullable) Availability at price band 6
BANDAVAIL7 numeric(8, 3) smallint (not nullable) Availability at price band 7
BANDAVAIL8 numeric(8, 3) smallint (not nullable) Availability at price band 8
BANDAVAIL9 numeric(8, 3) smallint (not nullable) Availability at price band 9
BANDAVAIL10 numeric(8, 3) smallint (not nullable) Availability at price band 10
PASAAVAILABILITY numeric(8, 3) smallint Allows for future use for Energy bids, being the physical plant capability including any capability potentially available within 24 hours
ENERGYLIMIT numeric(15, 5) int The Energy limit applying at the end of this dispatch interval in MWh. For GEN this is a lower energy limit. For LOAD this is an upper energy limit
RECALL_PERIOD numeric(8, 3) numeric(8, 3) The advance notice(in hours) that a Scheduled Resource requires to achieve the PASA Availability MW for this trading interval

Official MMS data model indexes

Index name Index type Index columns (in order)
BIDOFFERPERIOD_PK clustered, unique, primary key TRADINGDATE, BIDTYPE, DUID, OFFERDATETIME, DIRECTION, PERIODID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_BIDOFFERPERIOD_SPARSE clustered, unique, primary key BIDTYPE, TRADINGDATE, DUID, OFFERDATETIME, DIRECTION, PERIODID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
BIDOFFERPERIOD_SPARSE_CCI clustered, columnstore n/a
PK_BIDOFFERPERIOD_SPARSE nonclustered, unique, primary key BIDTYPE, TRADINGDATE, DUID, DIRECTION, OFFERDATETIME, PERIODID