SETGOVRECOVERY (Historical table)
SETGOVRECOVERY shows reimbursements for the Governor Ancillary Services to be recovered from participants.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement Date |
| VERSIONNO |
numeric(3, 0) |
smallint |
Settlement Run No. |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant to pay recovery |
| PERIODID |
numeric(3, 0) |
smallint |
Trading Interval |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| CONTRACTID |
varchar(10) |
varchar(10) |
- |
| ENABLING6RPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Enabling Payment 6 Second Raise |
| ENABLING60RPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Enabling Payment 60 Second Raise |
| ENABLING6LPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Enabling Payment 6 Second Lower |
| ENABLING60LPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
Enabling Payment 60 Second Lower |
| PARTICIPANTDEMAND |
numeric(15, 5) |
numeric(15, 5) |
Participant Demand in Region |
| REGIONDEMAND |
numeric(15, 5) |
numeric(15, 5) |
Total Regional Demand |
| ENABLING6RRECOVERY |
numeric(15, 5) |
numeric(15, 5) |
Enabling Recovery 6 Second Raise |
| ENABLING60RRECOVERY |
numeric(15, 5) |
numeric(15, 5) |
Enabling Recovery 60 Second Raise |
| ENABLING6LRECOVERY |
numeric(15, 5) |
numeric(15, 5) |
Enabling Recovery 6 Second Lower |
| ENABLING60LRECOVERY |
numeric(15, 5) |
numeric(15, 5) |
Enabling Recovery 60 Second Lower |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| ENABLING6LRECOVERY_GEN |
numeric(15, 5) |
numeric(15, 5) |
Enabling Recovery 6 Second Lower for Generator |
| ENABLING6RRECOVERY_GEN |
numeric(15, 5) |
numeric(15, 5) |
Enabling Recovery 6 Second Raise for Generator |
| ENABLING60LRECOVERY_GEN |
numeric(15, 5) |
numeric(15, 5) |
Enabling Recovery 60 Second Lower for Generator |
| ENABLING60RRECOVERY_GEN |
numeric(15, 5) |
numeric(15, 5) |
Enabling Recovery 60 Second Raise for Generator |
| PARTICIPANTDEMAND_GEN |
numeric(15, 5) |
numeric(15, 5) |
Participant Demand in Region for Generator |
| REGIONDEMAND_GEN |
numeric(15, 5) |
numeric(15, 5) |
Total Regional Demand for Generator |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETGOVRECOVERY_LCX |
nonclustered |
LASTCHANGED |
| SETGOVRECOVERY_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SETGOVRECOVERY_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SETGOVRECOVERY |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETGOVRECOVERY_LCX |
nonclustered |
LASTCHANGED |
| SETGOVRECOVERY_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, PERIODID, REGIONID |