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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


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