Table: GENCONSET

GENCONSET

Name

GENCONSET

Comment

GENCONSET sets out generic constraint sets that are invoked and revoked, and may contain many generic constraints (GENCONDATA).


Description

GENCONSET is public data, and is available to all participants.

Source

GENCONSET updates as sets are updated by AEMO.


Primary Key Columns

Name

EFFECTIVEDATE

GENCONID

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

GENCONID

VARCHAR2(20)

X

Generic Contraint ID

GENCONEFFDATE

DATE

 

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

NUMBER(3,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

LASTCHANGED

DATE

 

Last date and time record changed