Package: GAS_BB

Name

GAS_BB

Comment

 


List of tables

Name

Comment

GAS_BASIN

This report displays a list of all basins

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_DEVFACILITY

Details of all Facility Developments

GAS_DEVFACILITY_DETAIL

Details of all Facility Developments over time

GAS_DEVFACILITY_FACILITY

Any facility that is related to dev facility

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_FIELD

Field location

GAS_FIELD_DETAIL

Field details

GAS_FIELDINTEREST

Field Interest annual reporting date

GAS_FIELDINTEREST_DETAIL

This report displays information about Field Interests

GAS_FIELDINTEREST_PARTICIPANT

The responsible participant of the field interest

GAS_FIELDINTEREST_SHARE

Field owner group members

GAS_FIELDINTEREST_SHARETRK

Filed Share tracking details over time

GAS_GSH_TRADES

Provides participants (buyer and seller) a confirmation whenever a trade is executed through auto matching of bids and offers or by off-market trades. Also provides participants with a list of all their future trades when triggered daily after the end of the trades for the current day

GAS_LINEPACK_ADEQUACY

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

GAS_LNG_SHIPMENT

This table displays a list of all LNG shipments

GAS_LNG_TRANSACTION

This table displays LNG transaction aggregated data

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_RESERVES_AND_RESOURCES

This table displays information about Field Reserves and Resources


2