SETLOCALAREAENERGY
SETLOCALAREAENERGY shows the UFE, AGE and associated values for each local area and trading interval in a settlement run.
Package
SETTLEMENT_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement date of the settlement run |
| SETTLEMENTRUNNO |
numeric(3, 0) |
smallint |
Settlement run number of the settlement run |
| LOCALAREAID |
varchar(30) |
varchar(30) |
Unique identifier for the local area |
| PERIODID |
numeric(3, 0) |
smallint |
Settlement Trading Interval |
| UFE |
numeric(18, 8) |
numeric(18, 8) |
Total unaccounted-for energy for the local area in this trading interval, in MWh |
| DDME |
numeric(18, 8) |
numeric(18, 8) |
DDME component of UFE for the local area in this trading interval, in MWh. |
| TME |
numeric(18, 8) |
numeric(18, 8) |
TME component of UFE for the local area in this trading interval, in MWh. |
| ADME |
numeric(18, 8) |
numeric(18, 8) |
ADME component of UFE for the local area in this trading interval, in MWh. |
| ADMELA |
numeric(18, 8) |
numeric(18, 8) |
The sum of all DME amounts for each Market Customer FRMP and TNI in the local area, in this trading interval. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date time for the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETLOCALAREAENERGY_PK |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, LOCALAREAID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETLOCALAREAENERGY |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, LOCALAREAID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETLOCALAREAENERGY_PK |
clustered, unique, primary key |
SETTLEMENTDATE, SETTLEMENTRUNNO, LOCALAREAID, PERIODID |