SET_ENERGY_REGION_SUMMARY
The Settlement Energy Region Summary report contains the Energy Transactions Summary for all the NEM regions. This report is produced only for Settlement Date post the IESS rule effective date.
Package
SETTLEMENT_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
date |
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 |
| REGIONID |
varchar(20) |
varchar(20) |
The NEM Region Id Identifier |
| CE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Consumed Energy summary for the Region Id |
| UFEA_MWH |
numeric(18, 8) |
numeric(18, 8) |
The UFEA Energy summary for the Region Id |
| ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Consumed Energy summary for the Region Id |
| ASOE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Sent Out Energy summary for the Region Id |
| ACE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Consumed Energy Amount for the Region Id |
| ASOE_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Sent Out Energy Amount for the Region Id |
| TOTAL_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Total Energy summary for the Region Id |
| TOTAL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Total Dollar Amount summary for the Region Id |
| 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_REGION_SUMMARY_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_ENERGY_REGION_SUMMARY |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_ENERGY_REGION_SUMMARY |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID |