Table: GAS_FACILITY_DETAIL

GAS_FACILITY_DETAIL

Name

GAS_FACILITY_DETAIL

Comment

The details of all gas plant facilities over time


Primary Key Columns

Name

EffectiveDate

FacilityId

VersionDateTime


Content

Name

Data Type

Mandatory

Comment

FacilityId

NUMBER(10,0)

X

Unique Facility Identifier

EffectiveDate

DATE

X

Effective date of the record

VersionDateTime

DATE

X

Version timestamp of the record

GasDayStartHour

Number(2,0)

 

Column no longer populated

AuthorisedDate

DATE

 

Date and time this operating state was authorised

AuthorisedBy

VARCHAR2(30)

 

User that authorised the change

LastChanged

DATE

 

Date and time record was last modified