Table: GAS_MEDIUM_TERM_CAP_OUTLOOK

GAS_MEDIUM_TERM_CAP_OUTLOOK

Name

GAS_MEDIUM_TERM_CAP_OUTLOOK

Comment

Provide the details of activities that may affect the daily capacity of the facility over the next 12 months.


Primary Key Columns

Name

CapacityType

DeliveryLocation

FacilityId

FlowDirection

FromGasDate

ReceiptLocation

VersionDateTime


Content

Name

Data Type

Mandatory

Comment

FacilityId

NUMBER(10,0)

X

Unique Facility Identifier

FromGasDate

DATE

X

Start date (inclusive) of the record

ToGasDate

DATE

 

End date (exclusive) of the record

VersionDateTime

DATE

X

Version timestamp of the record

CapacityType

VARCHAR2(20)

X

Capacity Type - Must be either STORAGE or MDQ

FlowDirection

VARCHAR2(20)

X

Direction of flow for the submission record. Must be one of ‘RECEIPT’ or ‘DELIVERY’

ReceiptLocation

NUMBER(10,0)

X

Connection Point ID that best represents the receipt location

DeliveryLocation

NUMBER(10,0)

X

Connection Point ID that best represents the Delivery Location

OutlookQuantity

NUMBER(18,3)

 

Quantity of available capacity during the defined period

CapacityDescription

VARCHAR2(1000)

 

Describes the meaning of the capacity Number Provided

Description

VARCHAR2(1000)

 

Description for reasons or comments directly related to the quantity or change in Outlook quantity in relation to the Facility

ActiveFlag

NUMBER(1,0)

 

Active flag for the record. A value of 1 indicates the record is currently active

DisabledDateTime

DATE

 

Audit timestamp of the record

LastChanged

DATE

 

Date and time record was last modified