SPDCONNECTIONPOINTCONSTRAINT
SPDCONNECTIONPOINTCONSTRAINT sets out details of connections point constraints issued in dispatch, predispatch and STPASA.
Package
GENERIC_CONSTRAINT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONNECTIONPOINTID |
varchar(12)  |
varchar(12) |
Connection Point Identifier |
| EFFECTIVEDATE |
datetime(3) |
date |
Effective date of this record |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no of this record for the effective date |
| GENCONID |
varchar(20) |
varchar(20) |
Generic Constraint Identifier |
| BIDTYPE |
varchar(12) |
varchar(12) |
Bid Type Identifier; one of (RAISE6SEC, RAISE60SEC, RAISE5MIN, LOWER6SEC, LOWER60SEC, LOWER5MIN, RAISEREG, LOWERREG) |
| FACTOR |
numeric(16, 6) |
numeric(9, 6) (not nullable) |
Constraint factor |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SPDCONNECTIONPOINTCONSTRA_LCX |
nonclustered |
LASTCHANGED |
| SPDCONNECTIONPTCONSTRAINT_PK |
clustered, unique, primary key |
GENCONID, EFFECTIVEDATE, VERSIONNO, BIDTYPE, CONNECTIONPOINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_SPDCONNECTIONPOINTCONSTRAINT_CONNECTIONPOINTID |
nonclustered |
CONNECTIONPOINTID |
| PK_SPDCONNECTIONPOINTCONSTRAINT |
clustered, unique, primary key |
GENCONID, EFFECTIVEDATE, VERSIONNO, BIDTYPE, CONNECTIONPOINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IDX_CONNECTIONPOINTID |
nonclustered |
CONNECTIONPOINTID |
| SPDCONNECTIONPTCONSTRAINT_PK |
clustered, unique, primary key |
GENCONID, EFFECTIVEDATE, VERSIONNO, BIDTYPE, CONNECTIONPOINTID |