|
Name |
|
|
Comment |
A summary of gas FACILITY, capacity and ownership through time |
|
Name |
Comment |
Value |
|
Visibility |
Data confidentiality of this table |
Public |
|
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 the type of facility. Refer to the GAS_FACILITY_TYPE table |
|
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 |
|
|
|