Package: GAS_BB

Name

GAS_BB

Comment

 


List of tables

Name

Comment

GAS_CAPACITY_TYPE

Capacity Type - The type of capacity detailed. Valid entries are: STORAGE, MDQ

GAS_CONNECTIONPOINT_CAPACITY

Provide details of the gate station capacity on a particular day.

GAS_CONTACT

The registered user list of responsible contact persons for each BB Participant organisation as identified at registration or otherwise

GAS_CONTACT_DETAIL

The registered user list details of responsible contact persons for each BB Participant organisation as identified at registration or otherwise

GAS_DAILY_FLOW_ACTUAL

Provides on each gas day D, the BB facility operatorís daily gas flow data for injections and withdrawals at each connection point for gas day D-1.

GAS_DAILY_STORAGE_ACTUAL

Provide on each gas day D, the actual quantity of natural gas held in each storage facility at the end of the gas day D-1.

GAS_DATA_MODEL_AUDIT

GAS_DATA_MODEL_AUDIT shows the audit trail of scripts applied to this installation of Gas Data Model. Participants should ensure that if a database is cloned the content of this table is copied to the target database

GAS_FACILITY

Provides details of all facilities

GAS_FACILITY_DETAIL

The details of all gas plant facilities over time

GAS_FACILITY_DETAIL_CAPACITY

The standing details on capacity of all gas plant facilities over time

GAS_FACILITY_NODE

Identifies the set of nodes linked to facilities. A facility can have any number of nodes.

GAS_FACILITY_NODE_CONNECTION

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.

GAS_FACILITY_NODE_TRK

A facility tracking record. A parent record relating to sets of child nodes linked to a facility. The set can be found in GAS_FACILITY_NODE.

GAS_FACILITY_OPSTATE

The operating status of all facilities over time

GAS_FACILITY_OWNER

The detail of facility ownership over time

GAS_FACILITY_OWNER_TRK

The tracking of Facility ownership over time

GAS_FACILITY_SUMMARY

A summary of gas FACILITY, capacity and ownership through time

GAS_FACILITY_TYPE

A lookup table identifying the type of facilities stored in AEMOís GBB system

GAS_LINEPACK_ADEQUACY

The linepack adequacy (flag) for each of the (non-exempt) BB pipelines

GAS_LOCATION

Lists all production and demand locations within the Bulletin Board system.

GAS_LOCATION_NODE

Provides a list of nodes within a location.

GAS_LOCATION_NODE_TRK

Provides a record of node tracking.

GAS_LOCATION_OPSTATE

The operating status of all locations over time.

GAS_MARKET

The list of defined Gas Markets against which the Participant Operating Status is activated

GAS_MEDIUM_TERM_CAP_OUTLOOK

Provide the details of activities that may affect the daily capacity of the facility over the next 12 months.

GAS_NAMEPLATE_RATING

Provide the nameplate rating of each facility or information about any planned permanent capacity reduction or expansion due to modification of the facility.

GAS_NODE

A container for up to four connections

GAS_NODE_OPSTATE

The operating status of all facility nodes over time

GAS_NOMINATIONS_FORECAST

For BB pipelines forming part of a Declared Transmission System, provide on each gas day the aggregated scheduled injections and aggregated scheduled withdrawals at each controllable system point for gas day D to D+2.
For all other BB facility operators, provide on each gas day D the aggregated nominated and forecast injections and aggregated nominated and forecast withdrawals for gas day D to D+6.

GAS_NOMINATIONS_FORECAST_AGG

Provides the aggregate of forecast and nominations by location.

GAS_PARTICIPANT

The list of all registered organisations i.e the BB Participants of the Bulletin Board

GAS_PARTICIPANT_CONTACT

The detail of contacts against a gas participant over time

GAS_PARTICIPANT_CONTACT_TRK

The tracking of sets of contacts against a gas participant over time

GAS_PARTICIPANT_DETAIL

The details of all registered organisations i.e the BB Participants of the Bulletin Board over time

GAS_PARTICIPANT_OPSTATE

The operating status of all registered organisations i.e the BB Participants of the Bulletin Board over time

GAS_SEC_CAP_ORDERS

Information related to the bids and offers of secondary pipeline capacity, which is derived from a secondary pipeline capacity trading platform

GAS_SEC_CAP_ORDERS_TRK

Bids and offer tracking information of secondary pipeline capacity

GAS_SEC_CAP_TRADES

Information related to summary trading data, which is derived from a secondary pipeline capacity trading platform.

GAS_SEC_CAP_TRADES_TRK

Information related to summary trading data, which is derived from a secondary pipeline capacity trading platform.

GAS_SHORT_TERM_CAP_OUTLOOK

Provides on each gas day D, the BB facility operatorís good faith estimate of the daily capacity of the BB Facility for gas days D+1 to D+7.

GAS_STATE

List of states.

GAS_UNCONTRACTED_CAP_OUTLOOK

Provide the uncontracted capacity of the facility over the next 12 months.