SETGOVPAYMENT (Historical table)
SETGOVPAYMENTshows specific payment details for Governor services by period.
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) |
Unique participant identifier |
| CONTRACTID |
varchar(10) |
varchar(10) |
Contract Identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Period Identifier |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit ID |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| TLF |
numeric(7, 5) |
numeric(7, 5) |
Transmission Loss Factor of Unit |
| RL6SECRAISE |
numeric(15, 5) |
numeric(15, 5) |
contract enabling price - 6 sec raise |
| RL60SECRAISE |
numeric(15, 5) |
numeric(15, 5) |
contract enabling price - 60 sec raise |
| RL6SECLOWER |
numeric(15, 5) |
numeric(15, 5) |
contract enabling price - 6 sec lower |
| RL60SECLOWER |
numeric(15, 5) |
numeric(15, 5) |
contract enabling price - 60 sec lower |
| DEADBANDUP |
numeric(7, 5) |
numeric(7, 5) |
contracted dead band up |
| DEADBANDDOWN |
numeric(7, 5) |
numeric(7, 5) |
contracted dead band down |
| R6 |
numeric(15, 5) |
numeric(15, 5) |
6 sec raise response for 1% deviation in frequency (droop equation) |
| R60 |
numeric(15, 5) |
numeric(15, 5) |
60 sec raise response for 1% deviation in frequency (droop equation) |
| L6 |
numeric(15, 5) |
numeric(15, 5) |
6 sec lower response for 1% deviation in frequency (droop equation) |
| L60 |
numeric(15, 5) |
numeric(15, 5) |
60 sec lower response for 1% deviation in frequency (droop equation) |
| RL6 |
numeric(15, 5) |
numeric(15, 5) |
6 sec raise response limit equation |
| RL60 |
numeric(15, 5) |
numeric(15, 5) |
60 sec raise response limit equation |
| LL6 |
numeric(15, 5) |
numeric(15, 5) |
6 sec lower response limit equation |
| LL60 |
numeric(15, 5) |
numeric(15, 5) |
6 sec lower response limit equation |
| ENABLING6RPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
6 sec raise enabling payment |
| ENABLING60RPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
60 sec raise enabling payment |
| ENABLING6LPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
6 sec lower enabling payment |
| ENABLING60LPAYMENT |
numeric(15, 5) |
numeric(15, 5) |
60 sec lower enabling payment |
| CONTRACTVERSIONNO |
numeric(3, 0) |
smallint |
AS contract version no |
| OFFERDATE |
datetime(3) |
datetime2(0) |
re-offer offer date |
| OFFERVERSIONNO |
numeric(3, 0) |
smallint |
re-offer offer version |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETGOVPAYMENT_LCX |
nonclustered |
LASTCHANGED |
| SETGOVPAYMENT_NDX2 |
nonclustered |
PARTICIPANTID |
| SETGOVPAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SETGOVPAYMENT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_SETGOVPAYMENT_PARTICIPANTID |
nonclustered |
PARTICIPANTID |
| PK_SETGOVPAYMENT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SETGOVPAYMENT_LCX |
nonclustered |
LASTCHANGED |
| SETGOVPAYMENT_NDX2 |
nonclustered |
PARTICIPANTID |
| SETGOVPAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, PARTICIPANTID, CONTRACTID, PERIODID |