SETSMALLGENDATA
Publishes metering data and associated settlement values for with registered Small Generator Aggregator participants connection points. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, SET_ENERGY_TRANSACTIONS and SET_ENERGY_GENSET_DETAIL replace SETSMALLGENDATA.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement date |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version number of the record for the settlement date |
| CONNECTIONPOINTID |
varchar(20) |
varchar(20) |
Transmission Node Identifier (TNI) |
| PERIODID |
numeric(3, 0) |
smallint |
Settlements Trading Interval. |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Unique participant identifier |
| REGIONID |
varchar(20) |
varchar(20) |
Region Identifier |
| IMPORTENERGY |
numeric(18, 8) |
numeric(18, 8) |
The import direction value for the meter read (MWh) |
| EXPORTENERGY |
numeric(18, 8) |
numeric(18, 8) |
The export direction value for the meter read (MWh) |
| RRP |
numeric(18, 8) |
numeric(18, 8) |
Regional Reference Price |
| TLF |
numeric(18, 8) |
numeric(18, 8) |
Transmission Loss Factor |
| IMPENERGYCOST |
numeric(18, 8) |
numeric(18, 8) |
Import Energy Cost ($) |
| EXPENERGYCOST |
numeric(18, 8) |
numeric(18, 8) |
Export Energy Cost ($) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time the record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETSMALLGENDATA |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, CONNECTIONPOINTID, PERIODID, PARTICIPANTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETSMALLGENDATA |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, CONNECTIONPOINTID, PERIODID, PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETSMALLGENDATA |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, CONNECTIONPOINTID, PERIODID, PARTICIPANTID |