Table: BILLRESERVETRADERRECOVERY

BILLRESERVETRADERRECOVERY

Name

BILLRESERVETRADERRECOVERY

Comment

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


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

REGION_DEMAND

NUMBER(18,8)

 

Region Demand Value used for RERT Recovery

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