|
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 |
|
|
|