ANCILLARY_RECOVERY_SPLIT
ANCILLARY_RECOVERY_SPLIT holds the actual customer portion for each service and payment type. A single EFFECTIVEDATE / VERSIONNO combination applies to all services (i. e. the latest EFFECTIVEDATE / VERSIONNO is not retrieved for a single service, but applies to a data set).
Package
SETTLEMENT_CONFIG
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
Calendar settlement date record becomes effective. |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version number of the record for the given date. |
| SERVICE |
varchar(10) |
varchar(10) |
Ancillary service name (e.g. AGC, FCASCOMP) |
| PAYMENTTYPE |
varchar(20) |
varchar(20) |
A payment type associated with the service (can be ENABLING, AVAILABILITY, USAGE, or COMPENSATION). |
| CUSTOMER_PORTION |
numeric(8, 5) |
numeric(8, 5) |
The percentage value of the recovery funded by market customers. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| ACE_PORTION |
numeric(18, 8) |
numeric(8, 5) |
The percentage value of the recovery funded using the ACE MWh Values. This field is only used for Settlement post IESS rule effective date. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| ANCILLARY_RECOVERY_SPLIT_LCX |
nonclustered |
LASTCHANGED |
| ANCILLARY_RECOVERY_SPLIT_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, SERVICE, PAYMENTTYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_ANCILLARY_RECOVERY_SPLIT_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_ANCILLARY_RECOVERY_SPLIT |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, SERVICE, PAYMENTTYPE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| ANCILLARY_RECOVERY_SPLIT_LCX |
nonclustered |
LASTCHANGED |
| ANCILLARY_RECOVERY_SPLIT_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, SERVICE, PAYMENTTYPE |