SET_ENERGY_TRANSACTIONS
The Settlement Energy Transactions report contains the Energy Transactions data for all the Participants based on their ACE and ASOE at each customer and generator Connection Point ID. This table is populated The Settlement Energy Transactions report contains the Energy Transactions data for all the Participants based on their ACE and ASOE at each customer and generator Connection Point ID. This table is populated only if Settlement Date is 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 |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant Id Identifier |
| CONNECTIONPOINTID |
varchar(20) |
varchar(20) |
The Connection Point associated with the Energy Transaction reads. |
| METER_TYPE |
varchar(20) |
varchar(20) |
The type of meter reads received. Eg Customer, Generator, BDU, NREG etc. |
| REGIONID |
varchar(20) |
varchar(20) |
The NEM Region Id Identifier |
| RRP |
numeric(18, 8) |
numeric(18, 8) |
The Regional Reference Price for the Region |
| 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. |
| CE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Consumed Energy . Energy received in the meter reads (DLF Adjusted) |
| UFEA_MWH |
numeric(18, 8) |
numeric(18, 8) |
The UFE Allocation Amount applied to the Participant |
| ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Consumed Energy MWh ( CE_MWh + UFEA) for the ConnectionPointId |
| ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Sent Out Energy for the ConnectionPointId . Energy received in the meter reads adjusted by DLF. |
| TOTAL_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Total MWh Value for the Participant. ACE_MWh + ASOE_MWh |
| ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The dollar amount for Adjusted Consumed Energy MWh (ACE_MWh * TLF * RRP) |
| ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The dollar amount for Adjusted Sent Out Energy MWh (ASOE_MWh * TLF * RRP) |
| TOTAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Total Dollar Value for the Participant. ACE_Amount + ASOE_Amount |
| CASE_ID |
numeric(10, 0) |
numeric(10, 0) |
The Metering Case ID |
| DME_MWH |
numeric(18, 8) |
numeric(18, 8) |
The DME MWh (Distribution Connected) that is used in the UFEA Calculation. |
| AGGREGATE_READ_FLAG |
numeric(3, 0) |
numeric(3, 0) |
The Flag is 1 if the meter data source is from Aggregate Reads Meter Data, Else 0 |
| INDIVIDUAL_READ_FLAG |
numeric(3, 0) |
numeric(3, 0) |
The Flag is 1 if the meter data source is from Individual Reads Meter Data, Else 0 |
| 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_TRANSACTIONS_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, CONNECTIONPOINTID, METER_TYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_ENERGY_TRANSACTIONS |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, CONNECTIONPOINTID, METER_TYPE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_ENERGY_TRANSACTIONS_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, CONNECTIONPOINTID, METER_TYPE |