Table: GENCONSETTRK

GENCONSETTRK

Name

GENCONSETTRK

Comment

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


Description

GENCONSETTRK data is public to all participants.

Source

Ad hoc updates occur to GENCONSETTRK.


Primary Key Columns

Name

EFFECTIVEDATE

GENCONSETID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

GENCONSETID

VARCHAR2(20)

X

Unique ID for the Constraint Set

EFFECTIVEDATE

DATE

X

Date this record becomes effective

VERSIONNO

NUMBER(3,0)

X

Version no of the record for the given effective date

DESCRIPTION

VARCHAR2(256)

 

Description of the constraint

AUTHORISEDBY

VARCHAR2(15)

 

The person who authorised the constraint set

AUTHORISEDDATE

DATE

 

The date and time of authorising the constraint set

LASTCHANGED

DATE

 

Last date and time record changed

COVERAGE

VARCHAR2(64)

 

The region the constraint set is located in or a special grouping (e.g. CHIMERA)

MODIFICATIONS

VARCHAR2(256)

 

Details of the changes made to this version of the constraint set

SYSTEMNORMAL

VARCHAR2(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

VARCHAR2(256)

 

Detail of the plant that is not in service