Table: BILLING_SUBST_DEMAND

BILLING_SUBST_DEMAND

Name

BILLING_SUBST_DEMAND

Comment

Demand Values Substituted in Billing Calculation


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

SETTLEMENTDATE

TNI

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 run number

SETTLEMENTDATE

DATE

X

Settlement Date

TNI

VARCHAR2(20)

X

Unique identifier for the connection point

PARTICIPANTID

VARCHAR2(20)

X

Unique identifier for the participant

REGIONID

VARCHAR2(20)

 

Unique identifier for the region to which the TNI belongs to on this settlement date

SUBSTITUTEDEMAND

NUMBER(18,8)

 

Substitute metered quantity for non-energy recovery in MWh for the TNI and participant in the trading interval. A negative value indicates net consumption and a positive value indicates net generation