|
Name |
|
|
Comment |
BILLINGASRECOVERY shows participant charges for Ancillary Services for the billing period. This view shows the billing amounts for Ancillary Service Recovery. |
|
BILLINGASRECOVERY data is confidential to relevant participant. Source Updated with each billing run. Volume Approximately 5 records are inserted per billrunno, or about 55 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
X |
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 |
|
RAISE6SEC |
NUMBER(15,5) |
|
Raise 6 Sec Recovery |
|
LOWER6SEC |
NUMBER(15,5) |
|
Lower 6 Sec Recovery |
|
RAISE60SEC |
NUMBER(15,5) |
|
Raise 60 Sec Recovery |
|
LOWER60SEC |
NUMBER(15,5) |
|
Lower 60 Sec Recovery |
|
AGC |
NUMBER(15,5) |
|
AGC Recovery - Not used since circa 2000 |
|
FCASCOMP |
NUMBER(15,5) |
|
Frequency Control Compensation Recovery - Not used since circa 2000 |
|
LOADSHED |
NUMBER(15,5) |
|
Load Shed Recovery |
|
RGUL |
NUMBER(15,5) |
|
Rapid Generator Unit Loading Recovery - Not used since December 2001 |
|
RGUU |
NUMBER(15,5) |
|
Rapid Generator Unit Unloading Recovery - Not used since December 2001 |
|
REACTIVEPOWER |
NUMBER(15,5) |
|
Reactive Power Recovery |
|
SYSTEMRESTART |
NUMBER(15,5) |
|
System Restart Recovery |
|
LASTCHANGED |
DATE |
|
The latest date and time a file was updated/inserted |
|
RAISE6SEC_GEN |
NUMBER(15,5) |
|
Raise 6 Sec Recovery for Generator |
|
LOWER6SEC_GEN |
NUMBER(15,5) |
|
Lower 6 Sec Recovery for Generator |
|
RAISE60SEC_GEN |
NUMBER(15,5) |
|
Raise 60 Sec Recovery for Generator |
|
LOWER60SEC_GEN |
NUMBER(15,5) |
|
Lower 60 Sec Recovery for Generator |
|
AGC_GEN |
NUMBER(15,5) |
|
AGC Recovery for Generator |
|
FCASCOMP_GEN |
NUMBER(15,5) |
|
Frequency Control Compensation Recovery for Generator |
|
LOADSHED_GEN |
NUMBER(15,5) |
|
Load Shed Recovery for Generator |
|
RGUL_GEN |
NUMBER(15,5) |
|
Rapid Generator unit Loading Recovery for. Generator - Not used since December 2001 |
|
RGUU_GEN |
NUMBER(15,5) |
|
Rapid Generator Unit Unloading Recovery for Generator - Not used since December 2001 |
|
REACTIVEPOWER_GEN |
NUMBER(15,5) |
|
Reactive Power Recovery for Generator |
|
SYSTEMRESTART_GEN |
NUMBER(15,5) |
|
System Restart Recovery for Generator |
|
LOWER5MIN |
NUMBER(15,5) |
|
Recovery amount for the Lower 5 Minute service attributable to customer connection points |
|
RAISE5MIN |
NUMBER(15,5) |
|
Recovery amount for the Raise 5 Minute service attributable to customer connection points |
|
LOWERREG |
NUMBER(15,5) |
|
Recovery amount for the Lower Regulation service attributable to customer connection points |
|
RAISEREG |
NUMBER(15,5) |
|
Recovery amount for the Raise Regulation Second service attributable to customer connection points |
|
LOWER5MIN_GEN |
NUMBER(16,6) |
|
Recovery amount for the Lower 5 Minute service attributable to generator connection points |
|
RAISE5MIN_GEN |
NUMBER(16,6) |
|
Recovery amount for the Raise 5 Minute service attributable to generator connection points |
|
LOWERREG_GEN |
NUMBER(16,6) |
|
Recovery amount for the Lower Regulation service attributable to generator connection points |
|
RAISEREG_GEN |
NUMBER(16,6) |
|
Recovery amount for the Raise Regulation Second service attributable to generator connection points |
|
AVAILABILITY_REACTIVE |
NUMBER(18,8) |
|
The total availability payment recovery amount (customer). |
|
AVAILABILITY_REACTIVE_RBT |
NUMBER(18,8) |
|
The total availability payment rebate recovery amount (customer). |
|
AVAILABILITY_REACTIVE_GEN |
NUMBER(18,8) |
|
The total availability payment recovery amount (Generator). |
|
AVAILABILITY_REACTIVE_RBT_GEN |
NUMBER(18,8) |
|
The total availability payment rebate recovery amount (Generator). |
|
|
|