Table: GAS_FACILITY_DETAIL_CAPACITY

GAS_FACILITY_DETAIL_CAPACITY

Name

GAS_FACILITY_DETAIL_CAPACITY

Comment

The standing details on capacity of all gas plant facilities over time


Primary Key Columns

Name

CAPACITYTYPE

EFFECTIVEDATE

FACILITYID

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

FACILITYID

NUMBER(10,0)

X

Unique Facility identifier

EFFECTIVEDATE

DATE

X

Date capacity comes into effect

CAPACITYTYPE

VARCHAR2(20)

X

Capacity Type - Must be either STORAGE or MDQ.

VERSIONDATETIME

DATE

X

Version timestamp of the record.

LOWRANGE

NUMBER(3,0)

 

Percentage value used for (low) validation of capacity outlook

HIRANGE

NUMBER(3,0)

 

Percentage value used for (high) validation of capacity outlook

UNITS

VARCHAR2(5)

 

Unit of measurement. Only TJ is used

COMMENTS

VARCHAR2(255)

 

Free text description of record

AUTHORISEDDATE

DATE

 

Date and time this operating state was authorised

AUTHORISEDBY

VARCHAR2(30)

 

User which authorised the change