SETCFG_SAPS_SETT_PRICE
The Settlement Price for SAPS Energy in each Region.
Package
SETTLEMENT_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| FROMDATE |
datetime(3)  |
datetime2(0) |
The From Date of the SAPS Pricing Application Period |
| TODATE |
datetime(3) |
datetime2(0) |
The To Date of the SAPS Pricing Application Period |
| REGIONID |
varchar(20) |
varchar(20) |
The Region ID for which the calculated SAPS Price is applicable |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
The Date time of the record generation |
| SAPS_RRP |
numeric(18, 8) |
numeric(18, 8) |
The Region Reference Price for SAPS in the Region |
| ISFIRM |
numeric(3, 0) |
bit |
Whether the SAPS Price is Firm or Non-Firm |
| 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) |
| SETCFG_SAPS_SETT_PRICE_PK |
clustered, unique, primary key |
FROMDATE, TODATE, REGIONID, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETCFG_SAPS_SETT_PRICE |
clustered, unique, primary key |
FROMDATE, TODATE, REGIONID, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETCFG_SAPS_SETT_PRICE_PK |
clustered, unique, primary key |
FROMDATE, TODATE, REGIONID, VERSION_DATETIME |