INTERCONNECTORCONSTRAINT
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.
Package
MARKET_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Date that this limit is effective from |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version for this date |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Unique Id of this interconnector |
| RESERVEOVERALLLOADFACTOR |
numeric(5, 2) |
numeric(5, 2) |
SPD Factor |
| FROMREGIONLOSSSHARE |
numeric(5, 2) |
numeric(5, 2) |
Loss share attributable to from region |
| MAXMWIN |
numeric(15, 5) |
numeric(15, 5) |
Limit of energy flowing into the RegionFrom |
| MAXMWOUT |
numeric(15, 5) |
numeric(15, 5) |
Limit of energy flowing out of the Region |
| LOSSCONSTANT |
numeric(15, 6) |
numeric(15, 6) |
Constant Loss factor |
| LOSSFLOWCOEFFICIENT |
numeric(27, 17) |
numeric(27, 17) |
Linear coefficient of loss factor calculation |
| EMSMEASURAND |
varchar(40) |
varchar(40) |
Identifies the EMS entity that represents the interconnector flow |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorising record |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date record authorised |
| DYNAMICRHS |
varchar(1) |
varchar(1) |
Not used |
| IMPORTLIMIT |
numeric(6, 0) |
smallint |
Interconnector import limit |
| EXPORTLIMIT |
numeric(6, 0) |
smallint |
Interconnector export limit |
| OUTAGEDERATIONFACTOR |
numeric(15, 5) |
numeric(15, 5) |
SPD Factor |
| NONPHYSICALLOSSFACTOR |
numeric(15, 5) |
numeric(15, 5) |
Factor for non-physical losses rerun |
| OVERLOADFACTOR60SEC |
numeric(15, 5) |
numeric(15, 5) |
Interconnector overload for 60 sec |
| OVERLOADFACTOR6SEC |
numeric(15, 5) |
numeric(15, 5) |
Interconnector overload for 6 sec |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| FCASSUPPORTUNAVAILABLE |
numeric(1, 0) |
tinyint |
Flag to indicate that the interconnector cannot support FCAS Transfers |
| ICTYPE |
varchar(10) |
varchar(10) |
Interconnector type - Currently either \"REGULATED\" or \"MNSP\" |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| INTCCONSTRAINT_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID |
| INTERCONNECTORCONSTRAINT_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_INTERCONNECTORCONSTRAINT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_INTERCONNECTORCONSTRAINT |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| INTCCONSTRAINT_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID |
| INTERCONNECTORCONSTRAINT_LCX |
nonclustered |
LASTCHANGED |