Table: GAS_FIELDINTEREST_PARTICIPANT

GAS_FIELDINTEREST_PARTICIPANT

Name

GAS_FIELDINTEREST_PARTICIPANT

Comment

The responsible participant of the field interest


Primary Key Columns

Name

COMPANYID

EFFECTIVEDATE

FIELDINTERESTID

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

FIELDINTERESTID

NUMBER(20,0)

X

A unique AEMO defined Field Interest Identifier

EFFECTIVEDATE

DATE

X

The date on which the record takes effect

VERSIONDATETIME

DATE

X

Time a successful submission is accepted by AEMO systems

COMPANYID

NUMBER(10,0)

X

The company ID of the responsible field owner

AUTHORISEDDATE

DATE

 

Date and time this operating state was authorised

LASTCHANGED

DATE

 

Date and time record was last modified