|
Name |
|
|
Comment |
GENCONSET sets out generic constraint sets that are invoked and revoked, and may contain many generic constraints (GENCONDATA). |
|
GENCONSET is public data, and is available to all participants. Source GENCONSET updates as sets are updated by AEMO. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
EFFECTIVEDATE |
|
GENCONID |
|
GENCONSETID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|