|
Name |
|
|
Comment |
BILLINGASPAYMENTS shows Ancillary Service payments for each billing period by each of the Ancillary Service types for each participant’s connection points. |
|
BILLINGASPAYMENTS data is confidential to relevant participant. Source Updated with each billing run. Volume The volume is according to the number of Transmission ConnectionPointIDs a Participant may have subject to ancillary payment per billrunno. An indicative maximum is approximately 20 records are inserted per billrunno, or about 220 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONNECTIONPOINTID |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Week No |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection point identifier |
|
RAISE6SEC |
NUMBER(15,5) |
|
Raise 6 Sec Payments |
|
LOWER6SEC |
NUMBER(15,5) |
|
Lower 6 Sec Payments |
|
RAISE60SEC |
NUMBER(15,5) |
|
Raise 60 Sec Payments |
|
LOWER60SEC |
NUMBER(15,5) |
|
Lower 60 Sec Payments |
|
AGC |
NUMBER(15,5) |
|
AGC Payments |
|
FCASCOMP |
NUMBER(15,5) |
|
Frequency Control Compensation Payments |
|
LOADSHED |
NUMBER(15,5) |
|
Load Shed Payments |
|
RGUL |
NUMBER(15,5) |
|
Rapid Generator unit Loading Payments |
|
RGUU |
NUMBER(15,5) |
|
Rapid Generator Unit Unloading Payments |
|
REACTIVEPOWER |
NUMBER(15,5) |
|
Reactive Power Payments |
|
SYSTEMRESTART |
NUMBER(15,5) |
|
System Restart Payments |
|
LASTCHANGED |
DATE |
|
The latest date and time that a file was updated or inserted |
|
LOWER5MIN |
NUMBER(15,5) |
|
Lower 5 Minute Payment |
|
RAISE5MIN |
NUMBER(15,5) |
|
Raise 5 Minute Payment |
|
LOWERREG |
NUMBER(15,5) |
|
Lower 5 Minute Regulation Payment |
|
RAISEREG |
NUMBER(15,5) |
|
Raise 5 Minute Regulation Payment |
|
AVAILABILITY_REACTIVE |
NUMBER(18,8) |
|
The total availability payment |
|
AVAILABILITY_REACTIVE_RBT |
NUMBER(18,8) |
|
The total availability payment rebate |
|
|
|