Name |
|
Comment |
REGIONSTANDINGDATA sets out standing region data including the region reference node. |
REGIONSTANDINGDATA data is public, so is available to all participants. Source REGIONSTANDINGDATA only changes when a change is made to a region. This table changes infrequently. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Public |
Name |
EFFECTIVEDATE |
REGIONID |
VERSIONNO |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
EFFECTIVEDATE |
DATE |
X |
Effective date of this record, only the latest date applies |
VERSIONNO |
NUMBER(3,0) |
X |
Version No of the standing data that should be effective on this date |
REGIONID |
VARCHAR2(10) |
X |
Differentiates this region from all other regions |
RSOID |
VARCHAR2(10) |
|
the unique identifier of the participant with responsibility for the region. |
REGIONALREFERENCEPOINTID |
VARCHAR2(10) |
|
unique id of a connection point, being the reference point for this region |
PEAKTRADINGPERIOD |
NUMBER(3,0) |
|
Period identifier of the peak trading period of this connection point |
AUTHORISEDDATE |
DATE |
|
Date record authorised |
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
SCALINGFACTOR |
NUMBER(15,5) |
|
Scaling factor for regional FCAS requirement |
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|