GENCONSET
GENCONSET sets out generic constraint sets that are invoked and revoked, and may contain many generic constraints (GENCONDATA).
Package
GENERIC_CONSTRAINT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| GENCONSETID |
varchar(20)  |
varchar(20) |
Unique ID for the Constraint Set |
| EFFECTIVEDATE |
datetime(3) |
date |
Date this record becomes effective |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no of the record for the given effective date |
| GENCONID |
varchar(20) |
varchar(20) |
Generic Contraint ID |
| GENCONEFFDATE |
datetime(3) |
datetime2(0) |
Since market start in 1998 these fields have not been used and any data that has been populated in the fields should be ignored |
| GENCONVERSIONNO |
numeric(3, 0) |
smallint |
Since market start in 1998 these fields have not been used and any data that has been populated in the fields should be ignored |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENCONSET_LCX |
nonclustered |
LASTCHANGED |
| GENCONSET_PK |
clustered, unique, primary key |
GENCONSETID, EFFECTIVEDATE, VERSIONNO, GENCONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GENCONSET_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_GENCONSET |
clustered, unique, primary key |
GENCONSETID, EFFECTIVEDATE, VERSIONNO, GENCONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENCONSET_LCX |
nonclustered |
LASTCHANGED |
| PK_GENCONSET |
clustered, unique, primary key |
GENCONSETID, EFFECTIVEDATE, VERSIONNO, GENCONID |