Table: GAS_FIELD_DETAIL

GAS_FIELD_DETAIL

Name

GAS_FIELD_DETAIL

Comment

Field details


Primary Key Columns

Name

EFFECTIVEDATE

FIELDID

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

FIELDID

NUMBER(20,0)

X

A unique AEMO defined Field Identifier

EFFECTIVEDATE

DATE

X

The date on which the record takes effect

VERSIONDATETIME

DATE

X

Time a successful submission is accepted by AEMO systems

FIELDNAME

VARCHAR2(100)

 

The name of the Field in which the Field Interest is located

FIELDSHORTNAME

VARCHAR2(30)

 

The short name of the field

DESCRIPTION

VARCHAR2(400)

 

Additional information relating to the field

LOCATIONDESCRIPTION

VARCHAR2(200)

 

Additional information relating to the location of the field

AUTHORISEDDATE

DATE

 

Date and time this operating state was authorised

LASTCHANGED

DATE

 

Date and time record was last modified