Table: GAS_NOMINATIONS_FORECAST_AGG

GAS_NOMINATIONS_FORECAST_AGG

Name

GAS_NOMINATIONS_FORECAST_AGG

Comment

Provides the aggregate of forecast and nominations by location.


Primary Key Columns

Name

FacilityId

GasDate

LocationId

VersionDateTime


Content

Name

Data Type

Mandatory

Comment

GasDate

DATE

X

Date of gas day

FacilityId

NUMBER(10,0)

X

Unique Facility Identifier

LocationId

NUMBER(10,0)

X

Unique Node Location Identifier

VersionDateTime

DATE

X

Version date time of the record

Demand

NUMBER(18,3)

 

Usage type expressed in TJ. Three decimal places is not shown if the value has trailing zeros after the decimal place.

Supply

NUMBER(18,3)

 

Usage type expressed in TJ. Three decimal places is not shown if the value has trailing zeros after the decimal place

TransferIn

NUMBER(18,3)

 

Usage type expressed in TJ. Only applicable to BB pipelines. Three decimal places is not shown if the value has trailing zeros after the decimal place.

TransferOut

NUMBER(18,3)

 

Usage type expressed in TJ. Only applicable to BB pipelines. Three decimal places is not shown if the value has trailing zeros after the decimal place.

Completeness

NUMBER(3,0)

 

Completeness of aggregated figure in percentage

LastChanged

DATE

 

Last changed date for the record