Table: GAS_DAILY_FLOW_ACTUAL

GAS_DAILY_FLOW_ACTUAL

Name

GAS_DAILY_FLOW_ACTUAL

Comment

Provides on each gas day D, the BB facility operator’s daily gas flow data for injections and withdrawals at each connection point for gas day D-1.


Primary Key Columns

Name

ConnectionPointId

FacilityId

FlowDirection

GasDate

VersionDateTime


Content

Name

Data Type

Mandatory

Comment

GasDate

DATE

X

Date of gas day

FacilityId

NUMBER(10,0)

X

Unique Facility Identifier

ConnectionPointId

NUMBER(10,0)

X

Unique connection point identifier.

VersionDateTime

DATE

X

Version timestamp of the record

FlowDirection

VARCHAR2(20)

X

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

ActualQuantity

NUMBER(18,3)

 

The actual flow quantity reported in TJ to the nearest gigajoule.

Quality

VARCHAR2(5)

 

Indicates whether meter data for the submission date is available

LastChanged

DATE

 

Date and time record was last modified