|
Name |
|
|
Comment |
BIDTYPES, together with the associated tracking data in BIDTYPESTRK, define a set of ancillary services with bidding parameters from a given date. |
|
BIDTYPES is public to participants Source BIDTYPES updates when the static data relating to an ancillary service type is modified. Volume Expect modifications to be rare. Allow for approximately 20 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
EFFECTIVEDATE |
DATE |
X |
Market date starting at 04:30 inclusive |
|
VERSIONNO |
NUMBER(3,0) |
X |
Record version number |
|
DESCRIPTION |
VARCHAR2(64) |
|
Description of this Bid Type |
|
NUMBEROFBANDS |
NUMBER(3,0) |
|
Number of active bands (1 to 10) |
|
NUMDAYSAHEADPRICELOCKED |
NUMBER(2,0) |
|
Number of days prior to the Market Day when prices are locked from 12:30pm |
|
VALIDATIONRULE |
VARCHAR2(10) |
|
ENERGY or AS validation rules to apply. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
SPDALIAS |
VARCHAR2(10) |
|
Alias for this BIDTYPE used in the SPD Solver |
|
Name |
|
|
Comment |
BIDTYPESTRK, together with the associated data in BIDTYPES, define a set of ancillary services with bidding parameters from a given date. |
|
BIDTYPESTRK is public to participants Source BIDTYPESTRK updates when the static data relating to an ancillary service type is modified. Volume Expect modifications to be rare. Allow for approximately 20 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Market date starting at 04:30 inclusive |
|
VERSIONNO |
NUMBER(3,0) |
X |
Record version number |
|
AUTHORISEDDATE |
DATE |
|
Date of record authorisation. A NULL value indicates the record is not authorised. |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User that authorised record. A NULL value indicates the record is not authorised. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
Stores the proportion of enabled regulation FCAS dispatch that is typically consumed for frequency regulation. Used to calculate the projected state of charge for energy storage systems. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
EFFECTIVEDATE |
|
PERIODID |
|
REGIONID |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
The effective date for this regulation FCAS usage factor |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version with respect to effective date |
|
REGIONID |
VARCHAR2(20) |
X |
Unique RegionID |
|
BIDTYPE |
VARCHAR2(20) |
X |
The type of regulation FCAS service [RAISEREG,LOWERREG] |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID (1 - 48) within the calendar day to which this usage factor applies |
|
USAGE_FACTOR |
NUMBER(8,3) |
|
The proportion of cleared regulation FCAS that is assumed to be used within a dispatch interval. Expressed as a fractional amount between 0 and 1 |
|
LASTCHANGED |
DATE |
|
The last time the data has been changed/updated |
|
Name |
|
|
Comment |
Stores the proportion of enabled regulation FCAS dispatch that is typically consumed for frequency regulation. Used to calculate the projected state of charge for energy storage systems. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
The effective date for this regulation FCAS usage factor |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of the date with respect to effective date |
|
AUTHORISEDDATE |
DATE |
|
The date time that this set of usage factors was authorised |
|
LASTCHANGED |
DATE |
|
The last time the data has been changed/updated |
|
Name |
|
|
Comment |
INTERCONNECTOR sets out valid identifiers for each interconnector. |
|
INTERCONNECTOR is public data, available to all participants. Source INTERCONNECTOR changes infrequently, usually annually. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERCONNECTORID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Unique Id of this interconnector |
|
REGIONFROM |
VARCHAR2(10) |
|
Starting region of the interconnect |
|
RSOID |
VARCHAR2(10) |
|
Not used |
|
REGIONTO |
VARCHAR2(10) |
|
Ending region of the interconnect |
|
DESCRIPTION |
VARCHAR2(64) |
|
Description of interconnector |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
INTERCONNECTORALLOC shows allocations of interconnector residues to Network Service Providers. |
|
INTERCONNECTORALLOC data is confidential to the relevant participant. Source INTERCONNECTORALLOC changes infrequently, typically annually. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
REGIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective Date of Allocation Details |
|
VERSIONNO |
NUMBER(5,0) |
X |
Version No in respect to effective date |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
ALLOCATION |
NUMBER(12,5) |
|
Allocation % / 100 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
INTERCONNECTORCONSTRAINT sets out Interconnector limit data used as defaults in dispatch, predispatch and STPASA and used by SPD in calculating flows. INTERCONNECTORCONSTRAINT includes an additional field to restrict an interconnector from support transfer of FCAS. |
|
INTERCONNECTORCONSTRAINT is public data, available to all participants. Source INTERCONNECTORCONSTRAINT changes infrequently, typically annually. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
INTERCONNECTORID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RESERVEOVERALLLOADFACTOR |
NUMBER(5,2) |
|
SPD Factor |
|
FROMREGIONLOSSSHARE |
NUMBER(5,2) |
|
Loss share attributable to from region |
|
EFFECTIVEDATE |
DATE |
X |
Date that this limit is effective from |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version for this date |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Unique Id of this interconnector |
|
MAXMWIN |
NUMBER(15,5) |
|
Limit of energy flowing into the RegionFrom |
|
MAXMWOUT |
NUMBER(15,5) |
|
Limit of energy flowing out of the Region |
|
LOSSCONSTANT |
NUMBER(15,6) |
|
Constant Loss factor |
|
LOSSFLOWCOEFFICIENT |
NUMBER(27,17) |
|
Linear coefficient of loss factor calculation |
|
EMSMEASURAND |
VARCHAR2(40) |
|
Identifies the EMS entity that represents the interconnector flow |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
DYNAMICRHS |
VARCHAR2(1) |
|
Not used |
|
IMPORTLIMIT |
NUMBER(6,0) |
|
Interconnector import limit |
|
EXPORTLIMIT |
NUMBER(6,0) |
|
Interconnector export limit |
|
OUTAGEDERATIONFACTOR |
NUMBER(15,5) |
|
SPD Factor |
|
NONPHYSICALLOSSFACTOR |
NUMBER(15,5) |
|
Factor for non-physical losses rerun |
|
OVERLOADFACTOR60SEC |
NUMBER(15,5) |
|
Interconnector overload for 60 sec |
|
OVERLOADFACTOR6SEC |
NUMBER(15,5) |
|
Interconnector overload for 6 sec |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
FCASSUPPORTUNAVAILABLE |
NUMBER(1,0) |
|
Flag to indicate that the interconnector cannot support FCAS Transfers |
|
ICTYPE |
VARCHAR2(10) |
|
Interconnector type - Currently either "REGULATED" or "MNSP" |
|
Name |
|
|
Comment |
INTRAREGIONALLOC shows allocations of intra-regional residues to participants. |
|
INTRAREGIONALLOC data is confidential to the relevant participant. Source The data in INTRAREGIONALLOC changes infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
PARTICIPANTID |
|
REGIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective Date of Allocation Details |
|
VERSIONNO |
NUMBER(5,0) |
X |
Version No in respect to effective date |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
ALLOCATION |
NUMBER(12,5) |
|
Allocation Percent / 100 |
|
LASTCHANGED |
DATE |
|
Last changed date/time |
|
Name |
|
|
Comment |
LOSSFACTORMODEL sets out the demand coefficients for each interconnector, used by LP Solver modelling of interconnector flows. |
|
LOSSFACTORMODEL is public data, so is available to all participants. Source LOSSFACTORMODEL only changes annually, when there is a change in the interconnector. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
INTERCONNECTORID |
|
REGIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Calendar date data set is effective |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number within effective date of the status proposed |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
The unique identifier for the interconnector. |
|
REGIONID |
VARCHAR2(10) |
X |
The unique region identifier for a connection point of the interconnector |
|
DEMANDCOEFFICIENT |
NUMBER(27,17) |
|
The coefficient applied to the region demand in the calculation of the interconnector loss factor |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
LOSSMODEL sets out segment breakpoints in loss model for each interconnector, used by LP Solver modelling of interconnector flows. |
|
LOSSMODEL data is public, so is available to all participants. Source LOSSMODEL only changes annually, when there is a change in the interconnector. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
INTERCONNECTORID |
|
LOSSSEGMENT |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Calendar date data set is effective |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number within effective date |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector identifier |
|
PERIODID |
VARCHAR2(20) |
|
Not used |
|
LOSSSEGMENT |
NUMBER(6,0) |
X |
Segment Identifier (1 to 80 at present) |
|
MWBREAKPOINT |
NUMBER(6,0) |
|
MW Value for segment |
|
LOSSFACTOR |
NUMBER(16,6) |
|
Not used |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
MARKET_PRICE_THRESHOLDS sets out the market cap , floor and administered price thresholds applying to the electricity market |
|
MARKET_PRICE_THRESHOLDS data is public, so is available to all participants. Source MARKET_PRICE_THRESHOLDS only changes when a change is made to a market price threshold. This table changes infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Calendar date that this record becomes effective |
|
VERSIONNO |
NUMBER(4,0) |
X |
version no for the effective date |
|
VOLL |
NUMBER(15,5) |
|
value of lost load if total supply falls short of demand after load management then involuntary load |
|
MARKETPRICEFLOOR |
NUMBER(15,5) |
|
The floor price that the spot market price will not fall below. |
|
ADMINISTERED_PRICE_THRESHOLD |
NUMBER(15,5) |
|
Threshold value beyond which Aggregate Prices per Region over 336 Trade Intervals (Energy), or 2016 Dispatch Intervals (FCAS), will result in an Administered Price declaration |
|
AUTHORISEDDATE |
DATE |
|
date data authorised |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
user authorising |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
REGION sets out valid region IDs. |
|
REGION data is public, so is available to all participants. Source REGION updates if a change is ever made to a region. This table is static data and is likely to change very infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
REGIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
X |
Differentiates this region from all other regions |
|
DESCRIPTION |
VARCHAR2(64) |
|
Full description of region |
|
REGIONSTATUS |
VARCHAR2(8) |
|
Status of the region e.g. working, inactive, archive. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
REGIONSTANDINGDATA sets out standing region data including the region reference node. |
|
REGIONSTANDINGDATA data is public, so is available to all participants. Source REGIONSTANDINGDATA only changes when a change is made to a region. This table changes infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
REGIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of this record, only the latest date applies |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version No of the standing data that should be effective on this date |
|
REGIONID |
VARCHAR2(10) |
X |
Differentiates this region from all other regions |
|
RSOID |
VARCHAR2(10) |
|
the unique identifier of the participant with responsibility for the region. |
|
REGIONALREFERENCEPOINTID |
VARCHAR2(10) |
|
unique id of a connection point, being the reference point for this region |
|
PEAKTRADINGPERIOD |
NUMBER(3,0) |
|
Period identifier of the peak trading period of this connection point |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
SCALINGFACTOR |
NUMBER(15,5) |
|
Scaling factor for regional FCAS requirement |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
TRANSMISSIONLOSSFACTOR shows the Transmission Loss factors applied at each connection point. |
|
TRANSMISSIONLOSSFACTOR is public data, and is available to all participants. Source TRANSMISSIONLOSSFACTOR updates when new connection points are created or loss factors change. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONNECTIONPOINTID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRANSMISSIONLOSSFACTOR |
NUMBER(15,5) |
X |
Used in Bidding, Dispatch and Settlements. For Bidding and Dispatch, where the DUID is a BDU with DISPATCHTYPE of BIDIRECTIONAL, the TLF for the load component of the BDU. For Settlements, where dual TLFs apply, the primary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is negative (net load). |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of record |
|
VERSIONNO |
NUMBER(22,0) |
X |
Version no of record for given effective date |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection Point ID |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
LASTCHANGED |
DATE |
|
Record creation timestamp |
|
SECONDARY_TLF |
NUMBER(18,8) |
|
Used in Bidding, Dispatch and Settlements, only populated where Dual TLFs apply. For Bidding and Dispatch, the TLF for the generation component of a BDU, when null the TRANSMISSIONLOSSFACTOR is used for both the load and generation components. For Settlements, the secondary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is positive (net generation). |
|
|
|