|
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 |
|
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. NULL for Billing Week post the IESS rule effective date |
|
LOWER6SEC |
NUMBER(15,5) |
|
Lower 6 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
|
RAISE60SEC |
NUMBER(15,5) |
|
Raise 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
|
LOWER60SEC |
NUMBER(15,5) |
|
Lower 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
|
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. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists. |
|
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. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists. |
|
SYSTEMRESTART |
NUMBER(15,5) |
|
System Restart Recovery. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists |
|
LASTCHANGED |
DATE |
|
The latest date and time a file was updated/inserted |
|
RAISE6SEC_GEN |
NUMBER(15,5) |
|
Raise 6 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
|
LOWER6SEC_GEN |
NUMBER(15,5) |
|
Lower 6 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
|
RAISE60SEC_GEN |
NUMBER(15,5) |
|
Raise 60 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
|
LOWER60SEC_GEN |
NUMBER(15,5) |
|
Lower 60 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
|
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. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists. |
|
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. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists. |
|
SYSTEMRESTART_GEN |
NUMBER(15,5) |
|
System Restart Recovery for Generator. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists. |
|
LOWER5MIN |
NUMBER(15,5) |
|
Recovery amount for the Lower 5 Minute service attributable to customer connection points. NULL for Billing Week post the IESS rule effective date |
|
RAISE5MIN |
NUMBER(15,5) |
|
Recovery amount for the Raise 5 Minute service attributable to customer connection points. NULL for Billing Week post the IESS rule effective date |
|
LOWERREG |
NUMBER(18,8) |
|
Pre-IESS - Recovery amount for the Lower Regulation service attributable to customer connection points(MPF + Residue). Post-IESS the amount in this column represent only the Lower Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs, no Residue Amounts are added to this column value. |
|
RAISEREG |
NUMBER(18,8) |
|
Pre-IESS - Recovery amount for the Raise Regulation service attributable to customer connection points(MPF + Residue). Post-IESS the amount in this column represent only the Raise Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs, no Residue Amounts are added to this column value. |
|
LOWER5MIN_GEN |
NUMBER(16,6) |
|
Recovery amount for the Lower 5 Minute service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date |
|
RAISE5MIN_GEN |
NUMBER(16,6) |
|
Recovery amount for the Raise 5 Minute service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date |
|
LOWERREG_GEN |
NUMBER(16,6) |
|
Recovery amount for the Lower Regulation service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date |
|
RAISEREG_GEN |
NUMBER(16,6) |
|
Recovery amount for the Raise Regulation service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date. NULL for Billing Week post the IESS rule effective date. |
|
AVAILABILITY_REACTIVE |
NUMBER(18,8) |
|
The total availability payment recovery amount (customer).. NULL for Billing Week post the IESS rule effective date |
|
AVAILABILITY_REACTIVE_RBT |
NUMBER(18,8) |
|
The total availability payment rebate recovery amount (customer).. NULL for Billing Week post the IESS rule effective date |
|
AVAILABILITY_REACTIVE_GEN |
NUMBER(18,8) |
|
The total availability payment recovery amount (Generator).. NULL for Billing Week post the IESS rule effective date |
|
AVAILABILITY_REACTIVE_RBT_GEN |
NUMBER(18,8) |
|
The total availability payment rebate recovery amount (Generator).. NULL for Billing Week post the IESS rule effective date |
|
RAISE1SEC |
NUMBER(18,8) |
|
Customer recovery amount for the very fast raise service. NULL for Billing Week post the IESS rule effective date |
|
LOWER1SEC |
NUMBER(18,8) |
|
Customer recovery amount for the very fast lower service. NULL for Billing Week post the IESS rule effective date |
|
RAISE1SEC_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast raise service. NULL for Billing Week post the IESS rule effective date |
|
LOWER1SEC_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast lower service. NULL for Billing Week post the IESS rule effective date |
|
LOWERREG_ACE |
NUMBER(18,8) |
|
The Lower Regulation FCAS Residue Recovery Amount using ACE MWh values. NULL for Billing Week prior to the IESS rule effective date |
|
RAISEREG_ACE |
NUMBER(18,8) |
|
The Raise Regulation FCAS Residue Recovery Amount using ACE MWh values. NULL for Billing Week prior to the IESS rule effective date |
|
RAISE1SEC_ACE |
NUMBER(18,8) |
|
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
|
RAISE1SEC_ASOE |
NUMBER(18,8) |
|
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
|
LOWER1SEC_ACE |
NUMBER(18,8) |
|
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
|
LOWER1SEC_ASOE |
NUMBER(18,8) |
|
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
|
|
|