|
Name |
|
|
Comment |
A table with details of gas blend and gas blend curtailment information |
|
Name |
Comment |
Value |
|
Visibility |
Data confidentiality of this table |
Public |
|
Name |
|
CONNECTIONPOINTID |
|
FACILITYID |
|
FLOWDIRECTION |
|
GASYEAR |
|
MONTHNO |
|
VERSIONDATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
GASYEAR |
NUMBER(4,0) |
X |
Year the information applies to |
|
MONTHNO |
NUMBER(4,0) |
X |
Month the information applies to |
|
FACILITYID |
NUMBER(10,0) |
X |
Unique Facility Identifier |
|
VERSIONDATETIME |
DATE |
X |
Version timestamp of the record |
|
CONNECTIONPOINTID |
NUMBER(10,0) |
X |
A unique AEMO defined connection point identifier |
|
FLOWDIRECTION |
VARCHAR2(20) |
X |
Direction of flow for the submission record. Must be one of RECEIPT or DELIVERY |
|
BLENDCURTAILEVENTS |
NUMBER(20,0) |
|
The number of times a gas blend curtailment has occurred in a month to the BB facility or part of it |
|
BLENDCURTAILQTY |
NUMBER(18,3) |
|
Quantity of gas curtailed in TJ |
|
BLENDHIGH |
NUMBER(18,3) |
|
Highest blend level reached in %vol on any gas day in the month |
|
BLENDLOW |
NUMBER(18,3) |
|
Lowest blend level reached in %vol on any gas day in the month |
|
BLENDAVG |
NUMBER(18,3) |
|
The average daily blend level across all gas days in the month provided in %vol terms |
|
GASTYPE |
VARCHAR2(200) |
|
Primary gas added to the gas blend |
|
BLENDLIMIT |
NUMBER(18,3) |
|
Blend level limit applied for the gas day in %vol |
|
MAXGASDATE |
DATE |
|
Gas date in the month when the highest blend level was achieved |
|
MINGASDATE |
DATE |
|
Gas date in the month when the lowest blend level was achieved |
|
LASTCHANGED |
DATE |
|
Date and time record was last modified |
|
|
|