Table: GAS_FACILITY_NODE_CONNECTION

GAS_FACILITY_NODE_CONNECTION

Name

GAS_FACILITY_NODE_CONNECTION

Comment

Identifies the set of connections associated with a node. There are up to four. Up to two for each facility/node combination.
For example, a pipe might be connected to a store via a node. Two of the connections in the node are connected to the pipe and two to the store. Each pair of connections is a delivery or a receipt type of connection.


Primary Key Columns

Name

ConnectionPointId

EffectiveDate

FacilityId

FlowDirection

NodeId

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

NodeId

NUMBER(10,0)

X

Unique Node Identifier

ConnectionPointId

NUMBER(10,0)

X

Unique connection point identifier.

FlowDirection

VARCHAR2(20)

X

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

IsExempt

NUMBER(1,0)

 

Submissions are not required if this is set to 1.

HasAggregationPriority

NUMBER(1,0)

 

If 1, this will be used for aggregating.

ConnectionPointName

VARCHAR2(200)

 

Name of the Connection point

Mirn

VARCHAR2(20)

 

Meter Installation Registration Number – (MIRN). Unique identifier for the Victorian DTS delivery or supply point, used to retrieve the Daily Actual Flow and Nomination and Forecast from DWGM.

HasForecast

NUMBER(1,0)

 

Used to determine the MIRN required for Nomination and Forecast from DWGM.

CONNECTIONPOINTSHORTNAME

VARCHAR2(30)

 

An abbreviation of the connection point name

EXEMPTIONDESCRIPTION

VARCHAR2(200)

 

Description of the exemption