Table: PD7DAY_PRICESOLUTION

PD7DAY_PRICESOLUTION

Name

PD7DAY_PRICESOLUTION

Comment

PD7DAY price solution


Primary Key Columns

Name

INTERVAL_DATETIME

INTERVENTION

REGIONID

RUN_DATETIME


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVENTION

NUMBER(2,0)

X

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

INTERVAL_DATETIME

DATE

X

The unique identifier for the interval within this study

REGIONID

VARCHAR2(20)

X

Region Identifier

RRP

NUMBER(15,5)

 

Region Reference Price (Energy)

LOWER1SECRRP

NUMBER(15,5)

 

Regional Lower 1Sec Price - RegionSolution element L1Price attribute

LOWER6SECRRP

NUMBER(15,5)

 

Region Reference Price (Lower6Sec)

LOWER60SECRRP

NUMBER(15,5)

 

Region Reference Price (Lower60Sec)

LOWER5MINRRP

NUMBER(15,5)

 

Region Reference Price (Lower5Min)

LOWERREGRRP

NUMBER(15,5)

 

Region Reference Price (LowerReg)

RAISE1SECRRP

NUMBER(15,5)

 

Regional Raise 1Sec Price - R1Price attribute after capping/flooring

RAISE6SECRRP

NUMBER(15,5)

 

Region Reference Price (Raise6Sec)

RAISE60SECRRP

NUMBER(15,5)

 

Region Reference Price (Raise60Sec)

RAISE5MINRRP

NUMBER(15,5)

 

Region Reference Price (Raise5Min)

RAISEREGRRP

NUMBER(15,5)

 

Region Reference Price (RaiseReg)

LASTCHANGED

DATE

 

Last date and time record changed