BILLING_WDR_DETAIL
Billing WDR transaction detail summary.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Contract year of the Billing run |
| WEEKNO |
numeric(3, 0) |
smallint |
Week number of the Billing run |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing run number identifier |
| 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) |
Region identifier |
| FRMP |
varchar(20) |
varchar(20) |
Financial Responsible Market Participant Identifier |
| DRSP |
varchar(20) |
varchar(20) |
Demand Response Service Provider Identifier |
| WDRSQ |
numeric(18, 8) |
numeric(18, 8) |
WDR Settlement Quantity capped in MWh |
| WDRRR |
numeric(18, 8) |
numeric(18, 8) |
WDR reimbursement rate in $/MWh |
| WDRTA |
numeric(18, 8) |
numeric(18, 8) |
WDR transaction amount in $ for demand response |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_WDR_DETAIL_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, WDRRRPERIOD, REGIONID, FRMP, DRSP |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_WDR_DETAIL |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, WDRRRPERIOD, REGIONID, FRMP, DRSP |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLING_WDR_DETAIL_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, WDRRRPERIOD, REGIONID, FRMP, DRSP |