LOSSMODEL
LOSSMODEL sets out segment breakpoints in loss model for each interconnector, used by LP Solver modelling of interconnector flows.
Package
MARKET_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Calendar date data set is effective |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version number within effective date |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Interconnector identifier |
| LOSSSEGMENT |
numeric(6, 0) |
int |
Segment Identifier (1 to 80 at present) |
| PERIODID |
varchar(20) |
varchar(20) |
Not used |
| MWBREAKPOINT |
numeric(6, 0) |
int |
MW Value for segment |
| LOSSFACTOR |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| LOSSMODEL_LCX |
nonclustered |
LASTCHANGED |
| LOSSMODEL_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, LOSSSEGMENT |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_LOSSMODEL_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_LOSSMODEL |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, LOSSSEGMENT |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_LOSSMODEL |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, LOSSSEGMENT |