| REGIONID |
varchar(10)  |
varchar(10) |
Region Identifier |
| CONTRACTYEAR |
numeric(4, 0) |
smallint |
Contract Year |
| WEEKNO |
numeric(3, 0) |
smallint |
Week No |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Billing Run No. |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant Identifier |
| RAISE6SEC |
numeric(15, 5) |
numeric(15, 5) |
Raise 6 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
| LOWER6SEC |
numeric(15, 5) |
numeric(15, 5) |
Lower 6 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
| RAISE60SEC |
numeric(15, 5) |
numeric(15, 5) |
Raise 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
| LOWER60SEC |
numeric(15, 5) |
numeric(15, 5) |
Lower 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
| AGC |
numeric(15, 5) |
numeric(15, 5) |
AGC Recovery - Not used since circa 2000 |
| FCASCOMP |
numeric(15, 5) |
numeric(15, 5) |
Frequency Control Compensation Recovery - Not used since circa 2000 |
| LOADSHED |
numeric(15, 5) |
numeric(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 |
numeric(15, 5) |
numeric(15, 5) |
Rapid Generator Unit Loading Recovery - Not used since December 2001 |
| RGUU |
numeric(15, 5) |
numeric(15, 5) |
Rapid Generator Unit Unloading Recovery - Not used since December 2001 |
| REACTIVEPOWER |
numeric(15, 5) |
numeric(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 |
numeric(15, 5) |
numeric(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 |
datetime(3) |
datetime2(0) |
The latest date and time a file was updated/inserted |
| RAISE6SEC_GEN |
numeric(15, 5) |
numeric(15, 5) |
Raise 6 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
| LOWER6SEC_GEN |
numeric(15, 5) |
numeric(15, 5) |
Lower 6 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
| RAISE60SEC_GEN |
numeric(15, 5) |
numeric(15, 5) |
Raise 60 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
| LOWER60SEC_GEN |
numeric(15, 5) |
numeric(15, 5) |
Lower 60 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
| AGC_GEN |
numeric(15, 5) |
numeric(15, 5) |
AGC Recovery for Generator |
| FCASCOMP_GEN |
numeric(15, 5) |
numeric(15, 5) |
Frequency Control Compensation Recovery for Generator |
| LOADSHED_GEN |
numeric(15, 5) |
numeric(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 |
numeric(15, 5) |
numeric(15, 5) |
Rapid Generator unit Loading Recovery for. Generator - Not used since December 2001 |
| RGUU_GEN |
numeric(15, 5) |
numeric(15, 5) |
Rapid Generator Unit Unloading Recovery for Generator - Not used since December 2001 |
| REACTIVEPOWER_GEN |
numeric(15, 5) |
numeric(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 |
numeric(15, 5) |
numeric(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 |
numeric(15, 5) |
numeric(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 |
numeric(15, 5) |
numeric(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 |
numeric(18, 8) |
numeric(15, 5) |
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. For Billing Weeks past FPP Rule Effective Date this column is not used. Always show 0. |
| RAISEREG |
numeric(18, 8) |
numeric(15, 5) |
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. For Billing Weeks past FPP Rule Effective Date this column is not used. Always show 0. |
| LOWER5MIN_GEN |
numeric(16, 6) |
numeric(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 |
numeric(16, 6) |
numeric(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 |
numeric(16, 6) |
numeric(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 |
numeric(16, 6) |
numeric(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 |
numeric(18, 8) |
numeric(18, 8) |
The total availability payment recovery amount (customer).. NULL for Billing Week post the IESS rule effective date |
| AVAILABILITY_REACTIVE_RBT |
numeric(18, 8) |
numeric(18, 8) |
The total availability payment rebate recovery amount (customer).. NULL for Billing Week post the IESS rule effective date |
| AVAILABILITY_REACTIVE_GEN |
numeric(18, 8) |
numeric(18, 8) |
The total availability payment recovery amount (Generator).. NULL for Billing Week post the IESS rule effective date |
| AVAILABILITY_REACTIVE_RBT_GEN |
numeric(18, 8) |
numeric(18, 8) |
The total availability payment rebate recovery amount (Generator).. NULL for Billing Week post the IESS rule effective date |
| LOWER1SEC |
numeric(18, 8) |
numeric(18, 8) |
Customer recovery amount for the very fast lower service. NULL for Billing Week post the IESS rule effective date |
| LOWER1SEC_GEN |
numeric(18, 8) |
numeric(18, 8) |
Generator recovery amount for the very fast lower service. NULL for Billing Week post the IESS rule effective date |
| RAISE1SEC |
numeric(18, 8) |
numeric(18, 8) |
Customer recovery amount for the very fast raise service. NULL for Billing Week post the IESS rule effective date |
| RAISE1SEC_GEN |
numeric(18, 8) |
numeric(18, 8) |
Generator recovery amount for the very fast raise service. NULL for Billing Week post the IESS rule effective date |
| AVAILABILITY_REACTIVE_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Reactive Power Ancillary Service Availability Payment Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| AVAILABILITY_REACTIVE_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Reactive Power Ancillary Service Availability Payment Recovery Amount for the Participant and Region from ASOE MWh Portion. For Pre-IESS Settlement dates this column will have NULL value. For Pre-IESS Settlement dates this column will have NULL value. |
| AVAILABILITY_REACTIVE_RBT_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Reactive Power Ancillary Service Availability Rebate Payment Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| AVAILABILITY_REACTIVE_RBT_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Reactive Power Ancillary Service Availability Rebate Payment Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| LOADSHED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Load Shed Ancillary Service Recovery Amount for for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| LOADSHED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Load Shed Ancillary Service Recovery Amount for for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| LOWER1SEC_ACE |
numeric(18, 8) |
numeric(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 |
numeric(18, 8) |
numeric(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 |
| LOWER5MIN_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| LOWER5MIN_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Lower5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| LOWER60SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| LOWER60SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Lower60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| LOWER6SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| LOWER6SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Lower6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date value. |
| LOWERREG_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower Regulation FCAS Residue Recovery Amount using ACE MWh values. NULL for Billing Week prior to the IESS rule effective date |
| RAISE1SEC_ACE |
numeric(18, 8) |
numeric(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 |
numeric(18, 8) |
numeric(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 |
| RAISE5MIN_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| RAISE5MIN_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Raise5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| RAISE60SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| RAISE60SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Raise60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| RAISE6SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| RAISE6SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Raise6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| RAISEREG_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise Regulation FCAS Residue Recovery Amount using ACE MWh values. NULL for Billing Week prior to the IESS rule effective date |
| REACTIVEPOWER_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Reactive Power Ancillary Service Recovery Amount for for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| REACTIVEPOWER_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Reactive Power Ancillary Service Recovery Amount for for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| SYSTEMRESTART_ACE |
numeric(18, 8) |
numeric(18, 8) |
The System Restart Ancillary Service Recovery Amount for for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
| SYSTEMRESTART_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The System Restart Ancillary Service Recovery Amount for for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date, |
| LOWERREG_USED |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Lower Reg Service Used Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| LOWERREG_UNUSED |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Lower Reg Service Unused Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| RAISEREG_USED |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Raise Reg Service Used Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| RAISEREG_UNUSED |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Raise Reg Service Unused Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| LOWERREG_USED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Lower Reg Service Used ACE Residual Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| LOWERREG_USED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Lower Reg Service Used ASOE Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| LOWERREG_USED_RESIDUAL |
numeric(18, 8) |
numeric(18, 8) |
LOWERREG_USED_ACE + LOWERREG_USED_ASOE |
| RAISEREG_USED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Raise Reg Service Used ACE Residual Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| RAISEREG_USED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Raise Reg Service Used ASOE Residual Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| RAISEREG_USED_RESIDUAL |
numeric(18, 8) |
numeric(18, 8) |
RAISEREG_USED_ACE + RAISEREG_USED_ASOE |
| LOWERREG_UNUSED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Lower Reg Service Unused ACE Residual Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| LOWERREG_UNUSED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Lower Reg Service Unused ASOE Residual Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| LOWERREG_UNUSED_RESIDUAL |
numeric(18, 8) |
numeric(18, 8) |
LOWERREG_UNUSED_ACE + LOWERREG_UNUSED_ASOE |
| RAISEREG_UNUSED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Raise Reg Service Unused ACE Residual Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| RAISEREG_UNUSED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The FCAS Raise Reg Service Unused ASOE Residual Amount for the Billing Week. This column will be NULL for Billing Week Prior to FPP Rule Effective Date |
| RAISEREG_UNUSED_RESIDUAL |
numeric(18, 8) |
numeric(18, 8) |
RAISEREG_UNUSED_ACE + RAISEREG_UNUSED_ASOE |