Table: GAS_DEVFACILITY_DETAIL

GAS_DEVFACILITY_DETAIL

Name

GAS_DEVFACILITY_DETAIL

Comment

Details of all Facility Developments over time


Primary Key Columns

Name

DEVFACILITYID

EFFECTIVEDATE

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

DEVFACILITYID

NUMBER(20,0)

X

A unique AEMO defined Development Facility Identifier

EFFECTIVEDATE

DATE

X

The effective date of the submission

VERSIONDATETIME

DATE

X

Time a successful submission is accepted by AEMO systems

PROPOSEDNAME

VARCHAR2(100)

 

The name of the Facility development

MINNAMEPLATE

NUMBER(18,3)

 

The lower estimate of nameplate rating capacity

MAXNAMEPLATE

NUMBER(18,3)

 

The upper estimate of nameplate rating capacity

LOCATION

VARCHAR2(200)

 

The location of the development facility

PLANNEDCOMMISSIONFROM

VARCHAR2(7)

 

The planned start date of commissioning

PLANNEDCOMMISSIONTO

VARCHAR2(7)

 

The planned end date of commissioning

DEVELOPMENTSTAGE

VARCHAR2(200)

 

The current stage of the development facility being, PROPOSED, COMMITTED, CANCELLED, ENDED

COMMENTS

VARCHAR2(400)

 

Any additional comments included in the submission

AUTHORISEDDATE

DATE

 

Date and time this operating state was authorised

AUTHORISEDBY

VARCHAR2(30)

 

Reporting entity for the facility

LASTCHANGED

DATE

 

Date and time record was last modified