BILLINGASPAYMENTS
BILLINGASPAYMENTS shows Ancillary Service payments for each billing period by each of the Ancillary Service types for each participant's connection points.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
Contract Year |
| WEEKNO |
numeric(3, 0) |
smallint |
Week No |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing Run No. |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant Identifier |
| CONNECTIONPOINTID |
varchar(10) |
varchar(10) |
Connection point identifier |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| RAISE6SEC |
numeric(15, 5) |
numeric(15, 5) |
Raise 6 Sec Payments |
| LOWER6SEC |
numeric(15, 5) |
numeric(15, 5) |
Lower 6 Sec Payments |
| RAISE60SEC |
numeric(15, 5) |
numeric(15, 5) |
Raise 60 Sec Payments |
| LOWER60SEC |
numeric(15, 5) |
numeric(15, 5) |
Lower 60 Sec Payments |
| AGC |
numeric(15, 5) |
numeric(15, 5) |
AGC Payments |
| FCASCOMP |
numeric(15, 5) |
numeric(15, 5) |
Frequency Control Compensation Payments |
| LOADSHED |
numeric(15, 5) |
numeric(15, 5) |
Load Shed Payments |
| RGUL |
numeric(15, 5) |
numeric(15, 5) |
Rapid Generator unit Loading Payments |
| RGUU |
numeric(15, 5) |
numeric(15, 5) |
Rapid Generator Unit Unloading Payments |
| REACTIVEPOWER |
numeric(15, 5) |
numeric(15, 5) |
Reactive Power Payments |
| SYSTEMRESTART |
numeric(15, 5) |
numeric(15, 5) |
System Restart Payments |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The latest date and time that a file was updated or inserted |
| LOWER5MIN |
numeric(15, 5) |
numeric(15, 5) |
Lower 5 Minute Payment |
| RAISE5MIN |
numeric(15, 5) |
numeric(15, 5) |
Raise 5 Minute Payment |
| LOWERREG |
numeric(15, 5) |
numeric(15, 5) |
Lower 5 Minute Regulation Payment |
| RAISEREG |
numeric(15, 5) |
numeric(15, 5) |
Raise 5 Minute Regulation Payment |
| AVAILABILITY_REACTIVE |
numeric(18, 8) |
numeric(18, 8) |
The total availability payment |
| AVAILABILITY_REACTIVE_RBT |
numeric(18, 8) |
numeric(18, 8) |
The total availability payment rebate |
| LOWER1SEC |
numeric(18, 8) |
numeric(18, 8) |
Payment amount for the very fast lower service |
| RAISE1SEC |
numeric(18, 8) |
numeric(18, 8) |
Payment amount for the very fast raise service |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGASPAYMENTS_LCX |
nonclustered |
LASTCHANGED |
| BILLINGASPAYMENTS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLINGASPAYMENTS |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGASPAYMENTS_LCX |
nonclustered |
LASTCHANGED |
| BILLINGASPAYMENTS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, CONNECTIONPOINTID |