SETCFG_WDRRR_CALENDAR
Wholesale Demand Response Reimbursement Rate Calendar.
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, for example,2020Q3 for 2020 Quarter 3. |
| REGIONID |
varchar(20) |
varchar(20) |
Unique Identifier for the region id |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
The Version Date time of the latest changes. |
| STARTDATE |
datetime(3) |
datetime2(0) |
Start Date of Period (Inclusive). |
| ENDDATE |
datetime(3) |
datetime2(0) |
End Date of Period (Inclusive). |
| 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_WDRRR_CALENDAR_PK |
clustered, unique, primary key |
WDRRRPERIOD, REGIONID, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SETCFG_WDRRR_CALENDAR |
clustered, unique, primary key |
WDRRRPERIOD, REGIONID, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETCFG_WDRRR_CALENDAR_PK |
clustered, unique, primary key |
WDRRRPERIOD, REGIONID, VERSION_DATETIME |