METERDATA_SAPS
The SAPS Meter data for MSRP and Retailer used in the Settlement Calculation.
Package
METER_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CASE_ID |
numeric(15, 0)  |
bigint |
The Metering Case ID used for Settlements |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
The Settlement Date for that Week |
| CONNECTIONPOINT_ID |
varchar(20) |
varchar(20) |
The SAPS Connection Point Id |
| METER_TYPE |
varchar(20) |
varchar(20) |
The Meter Type Identifier , CUSTOMER or MSRP |
| FRMP |
varchar(20) |
varchar(20) |
The Financial Responsible Market Participant |
| LR |
varchar(20) |
varchar(20) |
The Local Retailer |
| PERIODID |
numeric(4, 0) |
smallint |
The Period ID Identifier |
| IMPORTVALUE |
numeric(18, 8) |
numeric(18, 8) |
The Sent Out Energy in MWh |
| EXPORTVALUE |
numeric(18, 8) |
numeric(18, 8) |
The Consumed Energy in MWh |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The Date time of the record last updated or inserted. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| METERDATA_SAPS_PK |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, CONNECTIONPOINT_ID, METER_TYPE, FRMP, LR, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_SAPS |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, CONNECTIONPOINT_ID, METER_TYPE, FRMP, LR, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| METERDATA_SAPS_PK |
clustered, unique, primary key |
CASE_ID, SETTLEMENTDATE, CONNECTIONPOINT_ID, METER_TYPE, FRMP, LR, PERIODID |