|
Name |
|
|
Comment |
SETCPDATAREGION sets out summary meter settlement data for each region. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(22,10) |
X |
Settlement run no |
|
PERIODID |
NUMBER(22,10) |
X |
Settlement Period identifier |
|
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 |
|
|
|