Table: BILLRESERVETRADERRECOVERY

BILLRESERVETRADERRECOVERY

Name

BILLRESERVETRADERRECOVERY

Comment

Provides details of the RERT Recovery Amount for the Market Customers.


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

PAYMENT_ID

PUBLICATION_ID

REGIONID

WEEKNO


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

Billing contract year

WEEKNO

NUMBER(3,0)

X

Billing week number

BILLRUNNO

NUMBER(3,0)

X

Billing posted run number

PUBLICATION_ID

VARCHAR2(40)

X

Unique Publication Identifier for RERT Payment

PAYMENT_ID

NUMBER(3,0)

X

RERT payment number

PAYMENT_AMOUNT

NUMBER(18,8)

 

RERT payment amount

PARTICIPANTID

VARCHAR2(20)

X

Participant identifier.

REGIONID

VARCHAR2(20)

X

Region from which the amount is recovered

PARTICIPANT_DEMAND

NUMBER(18,8)

 

Participant Demand Value used for RERT Recovery. NULL for Billing Week post the IESS rule effective date.

REGION_DEMAND

NUMBER(18,8)

 

Region Demand Value used for RERT Recovery. NULL for Billing Week post the IESS rule effective date.

ELIGIBILITY_START_INTERVAL

DATE

 

Starting Period of RERT Recovery for Usage Payments

ELIGIBILITY_END_INTERVAL

DATE

 

Ending Period of RERT Recovery for Usage Payments

RECOVERY_AMOUNT

NUMBER(18,8)

 

Recovery Amount applicable for each Market Customer

EXCLUDED_ENERGY

NUMBER(18,8)

 

The Energy Value (Scheduled Loads) that is excluded

PARTICIPANT_ACE_MWH

NUMBER(18,8)

 

The Participant ACE MWh Value used in the Recovery of the RERT Amount. NULL for Billing Week prior to the IESS rule effective date

REGION_ACE_MWH

NUMBER(18,8)

 

The Region ACE MWh Value used in the Recovery of the RERT Amount. NULL for Billing Week prior to the IESS rule effective date