GENCONSETTRK

GENCONSETTRK assists in determining the correct version of a generic constraint set that has been invoked in GENCONSETINVOKE.

Package

GENERIC_CONSTRAINT

Public

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
DESCRIPTION	varchar(256)	varchar(256)	Description of the constraint
AUTHORISEDBY	varchar(15)	varchar(15)	The person who authorised the constraint set
AUTHORISEDDATE	datetime(3)	datetime2(0)	The date and time of authorising the constraint set
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed
COVERAGE	varchar(64)	varchar(64)	The region the constraint set is located in or a special grouping (e.g. CHIMERA)
MODIFICATIONS	varchar(256)	varchar(256)	Details of the changes made to this version of the constraint set
SYSTEMNORMAL	varchar(1)	varchar(1)	Not used as of 2005 End of Year Release [was Flag to indicate if the constraint set is a system normal (1) or and an outage set (0)]
OUTAGE	varchar(256)	varchar(256)	Detail of the plant that is not in service

Index name	Index type	Index columns (in order)
GENCONSETTRK_LCX	nonclustered	LASTCHANGED
GENCONSETTRK_PK	clustered, unique, primary key	GENCONSETID, EFFECTIVEDATE, VERSIONNO

Index name	Index type	Index columns (in order)
IX_GENCONSETTRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_GENCONSETTRK	clustered, unique, primary key	GENCONSETID, EFFECTIVEDATE, VERSIONNO

Index name	Index type	Index columns (in order)
GENCONSETTRK_LCX	nonclustered	LASTCHANGED
PK_GENCONSETTRK	clustered, unique, primary key	GENCONSETID, EFFECTIVEDATE, VERSIONNO