Table: BILLING_WDR_DETAIL

BILLING_WDR_DETAIL

Name

BILLING_WDR_DETAIL

Comment

Billing WDR transaction detail summary


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

DRSP

FRMP

REGIONID

WDRRRPERIOD

WEEKNO


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

Contract year of the Billing run

WEEKNO

NUMBER(3,0)

X

Week number of the Billing run

BILLRUNNO

NUMBER(3,0)

X

Billing run number identifier

WDRRRPERIOD

VARCHAR2(20)

X

Unique identifier for the period to which the WDRRR applies. For quarter-based periods, this will be equal to YYYY[Q]NN, for example, 2020Q3 for 2020 Quarter 3.

REGIONID

VARCHAR2(20)

X

Region identifier

FRMP

VARCHAR2(20)

X

Financial Responsible Market Participant Identifier

DRSP

VARCHAR2(20)

X

Demand Response Service Provider Identifier

WDRSQ

NUMBER(18,8)

 

WDR Settlement Quantity capped in MWh

WDRRR

NUMBER(18,8)

 

WDR reimbursement rate in $/MWh

WDRTA

NUMBER(18,8)

 

WDR transaction amount in $ for demand response