SET_ENERGY_GENSET_DETAIL
The Settlement Energy Genset report contains the Energy Transactions data for each generation meter point. This report is produced only for Settlement Date post the IESS rule effective date.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
The Settlement Date of the Billing Week |
| VERSIONNO |
numeric(3, 0) |
smallint |
The Settlement Run No |
| PERIODID |
numeric(3, 0) |
smallint |
The Period ID Identifier |
| STATIONID |
varchar(20) |
varchar(20) |
The StationId identifier associated with the GensetId |
| DUID |
varchar(20) |
varchar(20) |
The DUID for the meter associated with the GensetId |
| GENSETID |
varchar(20) |
varchar(20) |
The GensetId for the Meter Id received |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant Id Identifier |
| REGIONID |
varchar(20) |
varchar(20) |
The Region Id for the Connection Point associated with the DUID |
| CONNECTIONPOINTID |
varchar(20) |
varchar(20) |
The Connection Point associated with the DUID |
| RRP |
numeric(18, 8) |
numeric(18, 8) |
The Regional Reference Price for the Settlement Period |
| TLF |
numeric(18, 8) |
numeric(18, 8) |
The Transmission Loss Factor applied to the Connection Point Id. TLF is calculated based on the Net Flow at the TNI. |
| METERID |
varchar(20) |
varchar(20) |
The Meter ID Identifier (NMI) |
| CE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Consumed Energy for the Meter Id . Energy received in the meter reads (DLF Adjusted) |
| UFEA_MWH |
numeric(18, 8) |
numeric(18, 8) |
The UFEA allocation amount applied to the Meter Data |
| ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Consumed Energy for the Meter Id (CE_MWh + UFEA) |
| ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Sent Out Energy for the Meter Id. |
| TOTAL_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Total MWh for the Meter Id (ACE_MWh + ASOE_MWh) |
| DME_MWH |
numeric(18, 8) |
numeric(18, 8) |
The DME MWh value that is used to calculate the UFEA Allocation Amount |
| ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Consumed Energy Dollar Amount |
| ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Sent Out Energy Dollar Amount |
| TOTAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Total Amount for the Meter Id (ACE_Amount + ASOE_Amount) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The Last changed Date time of the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_ENERGY_GENSET_DETAIL_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, STATIONID, DUID, GENSETID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_ENERGY_GENSET_DETAIL |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, STATIONID, DUID, GENSETID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_ENERGY_GENSET_DETAIL_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, STATIONID, DUID, GENSETID |