Name |
|
Comment |
A summary of gas FACILITY, capacity and ownership through time |
Name |
CONNECTIONPOINTID |
FACILITYID |
FLOWDIRECTION |
STARTDATE |
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 |
|
|
|