Table: REGIONSTANDINGDATA

REGIONSTANDINGDATA

Name

REGIONSTANDINGDATA

Comment

REGIONSTANDINGDATA sets out standing region data including the region reference node.


Description

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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

EFFECTIVEDATE

REGIONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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