SETCFG_WDR_REIMBURSE_RATE
Settlements WDR transactions.
Package
SETTLEMENT_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| WDRRRPERIOD |
varchar(20)  |
varchar(20) |
Unique identifier for the period to which the WDRRR applies. For quarter-based periods, this will be equal to YYYY[Q]NN, e.g. 2020Q3 for 2020 Quarter 3. |
| REGIONID |
varchar(20) |
varchar(20) |
Unique identifier for the region |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
The Version Date time of the latest changes. |
| WDRRR |
numeric(18, 8) |
numeric(18, 8) |
WDRRR value for the period and region ($/MWh) |
| ISFIRM |
numeric(3, 0) |
tinyint |
A flag to indicate that the WDRRR value is FIRM for the period and region, i.e. it is based on a complete set of firm prices from dispatch. Possible Values are 1 and 0 |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date for the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETCFG_WDR_REIMBURSE_RATE_PK |
clustered, unique, primary key |
WDRRRPERIOD, REGIONID, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETCFG_WDR_REIMBURSE_RATE |
clustered, unique, primary key |
WDRRRPERIOD, REGIONID, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETCFG_WDR_REIMBURSE_RATE_PK |
clustered, unique, primary key |
WDRRRPERIOD, REGIONID, VERSION_DATETIME |