SET_ENERGY_TRAN_SAPS
The table shows the Transaction Details for the SAPS Connection Points. The table contains both the MSRPs and Retailers data.
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 for the SAPS TNI |
| TNI |
varchar(20) |
varchar(20) |
The SAPS Connection Point Identifier |
| REGIONID |
varchar(20) |
varchar(20) |
The SAPS Region ID |
| SAPS_RRP |
numeric(18, 8) |
numeric(18, 8) |
The SAPS Settlement Price for the Region |
| CONSUMED_ENERGY_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Energy MWh Consumed for that TNI for the Participant ID |
| SENTOUT_ENERGY_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Energy MWh Sent Out for the TNI for the Participant Id |
| CONSUMED_ENERGY_COST |
numeric(18, 8) |
numeric(18, 8) |
The Cost of the Consumed Energy |
| SENTOUT_ENERGY_COST |
numeric(18, 8) |
numeric(18, 8) |
The Cost of the Sent Out Energy |
| 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_TRAN_SAPS_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, TNI |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_ENERGY_TRAN_SAPS |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, TNI |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_ENERGY_TRAN_SAPS_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, TNI |