SET_FCAS_PAYMENT
SET_FCAS_PAYMENT sets out the enabling payment details for frequency controlled Ancillary Services.
Package
SETTLEMENT_DATA
Visibility
Private
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 |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Settlements Trading Interval. |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant identifier |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| LOWER6SEC_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Lower 6 Second Payment |
| RAISE6SEC_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Raise 6 Second Payment |
| LOWER60SEC_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Lower 60 Second Payment |
| RAISE60SEC_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Raise 60 Second Payment |
| LOWER5MIN_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Lower 5 Minute Payment |
| RAISE5MIN_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Raise 5 Minute Payment |
| LOWERREG_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Lower 5 Minute Regulation Payment |
| RAISEREG_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Raise 5 Minute Regulation Payment |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| LOWER1SEC_PAYMENT |
numeric(18, 8) |
numeric(18, 8) |
Payment amount for the very fast lower service |
| RAISE1SEC_PAYMENT |
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) |
| SET_FCAS_PAYMENT_LCHD_IDX |
nonclustered |
LASTCHANGED |
| SET_FCAS_PAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, DUID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SET_FCAS_PAYMENT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_SET_FCAS_PAYMENT |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, DUID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_FCAS_PAYMENT_LCHD_IDX |
nonclustered |
LASTCHANGED |
| SET_FCAS_PAYMENT_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, DUID, PERIODID |