Table: SETCPDATAREGION

SETCPDATAREGION

Name

SETCPDATAREGION

Comment

SETCPDATAREGION sets out summary meter settlement data for each region.


Description

SETCPDATAREGION data is public, so is available to all participants.

Source

SETCPDATAREGION is a summary based on grouping on SETCPDATA and is updated with each settlement run.


Primary Key Columns

Name

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Calendar Settlement Date

VERSIONNO

NUMBER(22,10)

X

Settlement run no

PERIODID

NUMBER(22,10)

X

Settlements Trading Interval.

REGIONID

VARCHAR2(10)

X

Region Identifier

SUMIGENERGY

NUMBER(27,5)

 

Import Gross energy into the pool - MWh

SUMXGENERGY

NUMBER(27,5)

 

Export Gross energy from the pool - MWh

SUMINENERGY

NUMBER(27,5)

 

Import Nett energy into the pool - MWh

SUMXNENERGY

NUMBER(27,5)

 

Export Nett energy from the pool - MWh

SUMIPOWER

NUMBER(22,0)

 

Not used

SUMXPOWER

NUMBER(22,0)

 

Not used

LASTCHANGED

DATE

 

current system date, to enable automatic replication

SUMEP

NUMBER(15,5)

 

Sum of energy price across the region