Gas MMS Data Model Report

This document is made available to you on the foll

List of packages

Description of the model AEMO Gas Data Model v2.2

Each table description has a Note providing some i

Visibility refers to the nature of confidentiality

Private: meaning the data is confidential to the P

Package: GAS_BB

Diagram: Entities: Gas Bulletin Board

Table: GAS_BASIN

Table: GAS_CAPACITY_TYPE

Table: GAS_CONNECTIONPOINT_CAPACITY

Table: GAS_CONTACT

Table: GAS_CONTACT_DETAIL

Table: GAS_DAILY_FLOW_ACTUAL

Table: GAS_DAILY_STORAGE_ACTUAL

Table: GAS_DATA_MODEL_AUDIT

Table: GAS_DEVFACILITY

Table: GAS_DEVFACILITY_DETAIL

Table: GAS_DEVFACILITY_FACILITY

Table: GAS_FACILITY

Table: GAS_FACILITY_DETAIL

Table: GAS_FACILITY_DETAIL_CAPACITY

Table: GAS_FACILITY_NODE

Table: GAS_FACILITY_NODE_CONNECTION

Table: GAS_FACILITY_NODE_TRK

Table: GAS_FACILITY_OPSTATE

Table: GAS_FACILITY_OWNER

Table: GAS_FACILITY_OWNER_TRK

Table: GAS_FACILITY_SUMMARY

Table: GAS_FACILITY_TYPE

Table: GAS_FIELD

Table: GAS_FIELD_DETAIL

Table: GAS_FIELDINTEREST

Table: GAS_FIELDINTEREST_DETAIL

Table: GAS_FIELDINTEREST_PARTICIPANT

Table: GAS_FIELDINTEREST_SHARE

Table: GAS_FIELDINTEREST_SHARETRK

Table: GAS_GSH_TRADES

Table: GAS_LINEPACK_ADEQUACY

Table: GAS_LNG_SHIPMENT

Table: GAS_LNG_TRANSACTION

Table: GAS_LOCATION

Table: GAS_LOCATION_NODE

Table: GAS_LOCATION_NODE_TRK

Table: GAS_LOCATION_OPSTATE

Table: GAS_MARKET

Table: GAS_MEDIUM_TERM_CAP_OUTLOOK

Table: GAS_NAMEPLATE_RATING

Table: GAS_NODE

Table: GAS_NODE_OPSTATE

Table: GAS_NOMINATIONS_FORECAST

Table: GAS_NOMINATIONS_FORECAST_AGG

Table: GAS_PARTICIPANT

Table: GAS_PARTICIPANT_CONTACT

Table: GAS_PARTICIPANT_CONTACT_TRK

Table: GAS_PARTICIPANT_DETAIL

Table: GAS_PARTICIPANT_OPSTATE

Table: GAS_RESERVES_AND_RESOURCES

Table: GAS_SEC_CAP_ORDERS

Table: GAS_SEC_CAP_ORDERS_TRK

Table: GAS_SEC_CAP_TRADES

Table: GAS_SEC_CAP_TRADES_TRK

Table: GAS_SHIPPER_LIST

Table: GAS_SHORT_TERM_CAP_OUTLOOK

Table: GAS_SHORT_TERM_SWAP_TRANS

Table: GAS_SHORT_TERM_TRANS

Table: GAS_STATE

Table: GAS_STORAGE_CAPACITY_TRANS

Table: GAS_UNCONTRACTED_CAP_OUTLOOK

Package: GAS_SUPPLY_HUB

Diagram: Entities: Gas Supply Hub

Table: GSH_AUCTION_BID

Table: GSH_AUCTION_BID_PRODUCT

Table: GSH_AUCTION_BID_PROFILE

Table: GSH_AUCTION_BID_STEPS

Table: GSH_AUCTION_BID_SUBMISSION

Table: GSH_AUCTION_BID_TRK

Table: GSH_AUCTION_CURTAIL_NOTICE

Table: GSH_AUCTION_PRICE_VOLUME

Table: GSH_AUCTION_QUANTITIES

Table: GSH_AUCTION_RESULTS

Table: GSH_AUCTION_RUN

Table: GSH_BENCHMARK_PRICE

Table: GSH_CAP_XFR_AUCTION_NOTICE

Table: GSH_CAP_XFR_NOTICE

Table: GSH_CAPACITY_TRANSACTION

Table: GSH_CONTRACT_DETAILS

Table: GSH_CONTRACT_REFERENCES

Table: GSH_DELIVERED_QUANTITY

Table: GSH_DELIVERY_NETT_POINTS

Table: GSH_DELIVERY_NETT_PREFS

Table: GSH_DELIVERY_OBLIGATIONS

Table: GSH_FACILITIES

Table: GSH_HISTORICAL_SUMMARY

Table: GSH_NOTIONAL_POINTS

Table: GSH_ORDERS

Table: GSH_PARK_SERVICES

Table: GSH_PARTICIPANT_CONTACTS

Table: GSH_PARTICIPANT_OPSTATE

Table: GSH_PARTICIPANTS

Table: GSH_PIPELINE_SEGMENTS

Table: GSH_PRD_AUCT_FWD_EXPOSURE

Table: GSH_PRD_BANK_GUARANTEES

Table: GSH_PRD_EST_MARKET_EXPOSURE

Table: GSH_PRD_REALLOCATIONS

Table: GSH_PRD_SECURITY_DEPOSITS

Table: GSH_PRD_SETTLEMENT_AMOUNTS

Table: GSH_PRD_TRADE_FWD_EXPOSURE

Table: GSH_RCPT_DELIV_POINT_PREFS

Table: GSH_REALLOC_DAILY_AMOUNT

Table: GSH_REALLOC_REALLOCATION

Table: GSH_REVISED_AUCT_QUANTITIES

Table: GSH_SECDEPOSIT_INTEREST_RATE

Table: GSH_SERVICE_POINTS

Table: GSH_SHIPPER_CAP_XFR_NOTICE

Table: GSH_SUPP_ADHOC

Table: GSH_SUPP_AUCTION_QUANTITIES

Table: GSH_SUPP_CAPACITY_AUCTION

Table: GSH_SUPP_CAPACITY_TRANSFERS

Table: GSH_SUPP_CAPACITY_VARIANCE

Table: GSH_SUPP_DELIVERED_QUANTITY

Table: GSH_SUPP_DELIVERY_VARIANCE

Table: GSH_SUPP_EXECUTED_TRADES

Table: GSH_SUPP_FEE

Table: GSH_SUPP_PHYSICAL_GAS

Table: GSH_SUPP_REALLOCATIONS

Table: GSH_SUPP_SERVICES

Table: GSH_SUPP_SETTLEMENT_RUN

Table: GSH_SUPP_SETTLEMENT_SUMMARY

Table: GSH_TRADES

Table: GSH_TRADES_STAGING

Table: GSH_TRADING_CONTACTS

Table: GSH_TRANSACTION_SUMMARY

Table: GSH_ZONE_CURTAILMENT

Table: GSH_ZONES