Table: SPDCONNECTIONPOINTCONSTRAINT

SPDCONNECTIONPOINTCONSTRAINT

Name

SPDCONNECTIONPOINTCONSTRAINT

Comment

SPDCONNECTIONPOINTCONSTRAINT sets out details of connections point constraints issued in dispatch, predispatch and STPASA.


Description

The addition of the BIDTYPE field to SPDCONNECTIONPOINTCONSTRAINT allows constraints to be applied to a dispatchable unit energy and/or Frequency Controlled Ancillary Services dispatch.

SPDCONNECTIONPOINTCONSTRAINTdata is public, so is available to all participants.

Source

SPDCONNECTIONPOINTCONSTRAINT updates whenever new connection point constraints are created.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

BIDTYPE

CONNECTIONPOINTID

EFFECTIVEDATE

GENCONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONNECTIONPOINTID

VARCHAR2(12)

X

Connection Point Identifier

EFFECTIVEDATE

DATE

X

Effective date of this record

VERSIONNO

NUMBER(3,0)

X

Version no of this record for the effective date

GENCONID

VARCHAR2(20)

X

Generic Constraint Identifier

FACTOR

NUMBER(16,6)

 

Constraint factor

LASTCHANGED

DATE

 

Last date and time record changed

BIDTYPE

VARCHAR2(12)

X

Bid Type Identifier; one of (RAISE6SEC, RAISE60SEC, RAISE5MIN, LOWER6SEC, LOWER60SEC, LOWER5MIN, RAISEREG, LOWERREG)