|
Name |
|
|
Comment |
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). |
|
ANCILLARY_RECOVERY_SPLIT is public data, and is available to all participants. Source This table is updated infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
EFFECTIVEDATE |
|
PAYMENTTYPE |
|
SERVICE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Calendar settlement date record becomes effective. |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of the record for the given date. |
|
SERVICE |
VARCHAR2(10) |
X |
Ancillary service name (e.g. AGC, FCASCOMP) |
|
PAYMENTTYPE |
VARCHAR2(20) |
X |
A payment type associated with the service (can be ENABLING, AVAILABILITY, USAGE, or COMPENSATION). |
|
CUSTOMER_PORTION |
NUMBER(8,5) |
|
The percentage value of the recovery funded by market customers. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|