SETGENDATA
SETGENDATA shows meter settlement data for each generation meter point. A regional summary is also provided. 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 SETGENDATA.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Calendar Settlement Date |
| VERSIONNO |
numeric(10, 0) |
smallint |
Settlement run no |
| PERIODID |
numeric(10, 0) |
smallint |
Settlements Trading Interval. |
| STATIONID |
varchar(10) |
varchar(10) |
Station Identifier |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit identifier |
| GENSETID |
varchar(10) |
varchar(10) |
Physical unit identifier |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| GENERGY |
numeric(16, 6) |
numeric(16, 6) |
Generated energy |
| AENERGY |
numeric(16, 6) |
numeric(16, 6) |
Purchased Energy |
| GPOWER |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| APOWER |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| RRP |
numeric(20, 5) |
numeric(20, 5) |
Regional Reference Price |
| EEP |
numeric(16, 6) |
numeric(16, 6) |
Excess Energy Price |
| TLF |
numeric(7, 5) |
numeric(7, 5) |
Transmission Loss Factor |
| CPRRP |
numeric(16, 6) |
numeric(16, 6) |
Connection Point Price = RRP * TLF |
| CPEEP |
numeric(16, 6) |
numeric(16, 6) |
Connection Point Excess Energy Price = EEP * TLF |
| NETENERGY |
numeric(16, 6) |
numeric(16, 6) |
Generated energy |
| ENERGYCOST |
numeric(16, 6) |
numeric(16, 6) |
Cost of net energy $ |
| EXCESSENERGYCOST |
numeric(16, 6) |
numeric(16, 6) |
Cost of excess energy $ |
| APC |
numeric(16, 6) |
numeric(16, 6) |
Administered Price Compensation |
| RESC |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| RESP |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| EXPENERGY |
numeric(15, 6) |
numeric(15, 6) |
Export Energy (Generator Purchases) (MWh) |
| EXPENERGYCOST |
numeric(15, 6) |
numeric(15, 6) |
Export Energy Cost ($) |
| METERRUNNO |
numeric(6, 0) |
smallint |
Identifier of the meter run used in this settlement calculation |
| MDA |
varchar(10) |
varchar(10) |
Metering Data Agent |
| SECONDARY_TLF |
numeric(7, 5) |
numeric(7, 5) |
Secondary Transmission Loss Factor |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETGENDATA_LCX |
nonclustered |
LASTCHANGED |
| SETGENDATA_NDX2 |
nonclustered |
PARTICIPANTID |
| SETGENDATA_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, REGIONID, STATIONID, DUID, GENSETID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SETGENDATA_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_SETGENDATA_PARTICIPANTID |
nonclustered |
PARTICIPANTID |
| PK_SETGENDATA |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, REGIONID, STATIONID, DUID, GENSETID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETGENDATA_LCX |
nonclustered |
LASTCHANGED |
| SETGENDATA_NDX2 |
nonclustered |
PARTICIPANTID |
| SETGENDATA_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, REGIONID, STATIONID, DUID, GENSETID, PERIODID |