Table: AVERAGEPRICE30

AVERAGEPRICE30

Name

AVERAGEPRICE30

Comment

Reflects the 30-minute average price (the pre-5MS trading price).


Primary Key Columns

Name

PERIODDATE

REGIONID


Content

Name

Data Type

Mandatory

Comment

PERIODDATE

DATE

X

30-minute interval period, 1 to 48 from the start of the calendar day

REGIONID

VARCHAR2(10)

X

Region Identifier

PERIODID

NUMBER(3,0)

X

The 30-minute interval period, 1 to 48

RRP

NUMBER(15,5)

 

Regional reference price for this period

PRICE_CONFIDENCE

VARCHAR2(20)

 

Result of Manifestly Incorrect Inputs Price Status and OCD_Status - either "FIRM" or "NOT FIRM". Only FIRM if the Dispatch Interval is resolved for both MII and OCD

LASTCHANGED

DATE

 

Last date and time record changed