BILLRESERVETRADERRECOVERY
Provides details of the RERT Recovery Amount for the Market Customers.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Billing contract year |
| WEEKNO |
numeric(3, 0) |
tinyint |
Billing week number |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing posted run number |
| PUBLICATION_ID |
varchar(40) |
varchar(40) |
Unique Publication Identifier for RERT Payment |
| PAYMENT_ID |
numeric(3, 0) |
smallint |
RERT payment number |
| PAYMENT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
RERT payment amount |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Participant identifier. |
| REGIONID |
varchar(20) |
varchar(20) |
Region from which the amount is recovered |
| PARTICIPANT_DEMAND |
numeric(18, 8) |
numeric(18, 8) |
Participant Demand Value used for RERT Recovery. NULL for Billing Week post the IESS rule effective date. |
| REGION_DEMAND |
numeric(18, 8) |
numeric(18, 8) |
Region Demand Value used for RERT Recovery. NULL for Billing Week post the IESS rule effective date. |
| ELIGIBILITY_START_INTERVAL |
datetime(3) |
datetime2(0) |
Starting Period of RERT Recovery for Usage Payments |
| ELIGIBILITY_END_INTERVAL |
datetime(3) |
datetime2(0) |
Ending Period of RERT Recovery for Usage Payments |
| RECOVERY_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Recovery Amount applicable for each Market Customer |
| EXCLUDED_ENERGY |
numeric(18, 8) |
numeric(18, 8) |
The Energy Value (Scheduled Loads) that is excluded |
| PARTICIPANT_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Participant ACE MWh Value used in the Recovery of the RERT Amount. NULL for Billing Week prior to the IESS rule effective date |
| REGION_ACE_MWH |
numeric(18, 8) |
numeric(18, 8) |
The Region ACE MWh Value used in the Recovery of the RERT Amount. NULL for Billing Week prior to the IESS rule effective date |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLRESERVETRADERRECOVERY_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PUBLICATION_ID, PARTICIPANTID, REGIONID, PAYMENT_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLRESERVETRADERRECOVERY |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PUBLICATION_ID, PARTICIPANTID, REGIONID, PAYMENT_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLRESERVETRADERRECOVERY_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PUBLICATION_ID, PARTICIPANTID, REGIONID, PAYMENT_ID |