LOSSFACTORMODEL
LOSSFACTORMODEL sets out the demand coefficients 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 of the status proposed |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
The unique identifier for the interconnector. |
| REGIONID |
varchar(10) |
varchar(10) |
The unique region identifier for a connection point of the interconnector |
| DEMANDCOEFFICIENT |
numeric(27, 17) |
numeric(27, 17) |
The coefficient applied to the region demand in the calculation of the interconnector loss factor |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| LFMOD_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, REGIONID |
| LOSSFACTORMODEL_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_LOSSFACTORMODEL_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_LOSSFACTORMODEL |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| LFMOD_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, REGIONID |
| LOSSFACTORMODEL_LCX |
nonclustered |
LASTCHANGED |