Table: GAS_FACILITY_SUMMARY

GAS_FACILITY_SUMMARY

Name

GAS_FACILITY_SUMMARY

Comment

A summary of gas FACILITY, capacity and ownership through time


Primary Key Columns

Name

CONNECTIONPOINTID

FACILITYID

FLOWDIRECTION

STARTDATE


Content

Name

Data Type

Mandatory

Comment

FACILITYID

Number(10,0)

X

Unique Facility Identifier

STARTDATE

DATE

X

Effective date of the record

ENDDATE

DATE

 

End date of the record

NODEID

Number(10,0)

 

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’

CONNECTIONPOINTNAME

Varchar2 (200)

 

Name of the Connection point

STATEID

Number(10,0)

 

Unique state identifier

STATE

Varchar2 (5)

 

Name of the state

FACILITYNAME

Varchar2 (100)

 

Name of the Facility

FACILITYTYPE

Varchar2 (40)

 

Describes type of Facility.Valid entries are: PIPE, PROD or STOR

FACILITYTYPEDESCRIPTION

Varchar2 (800)

 

Description of the facility type

GASDAYSTARTHOUR

Number(2,0)

 

Column No longer populated

COMPANYID

Number(10,0)

 

Unique company identifier

COMPANYNAME

Varchar2 (50)

 

Name of company

LOCATIONID

Number(10,0)

 

Unique Node Location Identifier

LOCATIONNAME

Varchar2 (100)

 

Name of the location.

LOCATIONTYPE

Varchar2 (40)

 

Type of location

LASTCHANGED

DATE

 

Last changed date for the record