Gas Data Model 2.2
Data Model changes summary
|
Package |
Table name |
Change |
Details |
|---|---|---|---|
|
GAS_SUPPLY_HUB |
GSH_TRADES_STAGING |
New |
EFP Trades staging data from traders |
|
GSH_TRADES |
Modified |
Provide participants (buyer and seller) a confirmation whenever a trade is executed through auto matching of bids and offers or by off-Market trades The report also provides participants a list of all their future trades when triggered daily after the end of the trades for the current day |
|
|
GSH_DELIVERY_OBLIGATIONS |
Modified |
Provides participants with their Delivery Obligations at each location. Delivery Obligation quantities are results of the delivery netting process |
|
|
GAS_BB |
GAS_BASIN |
New |
A list of all basins |
|
GAS_DEVFACILITY |
New |
Details of all Facility Developments |
|
|
GAS_DEVFACILITY_DETAIL |
New |
Details of all Facility Developments over time |
|
|
GAS_DEVFACILITY_FACILITY |
New |
Any facility related to the dev facility |
|
|
GAS_FIELD |
New |
Field location |
|
|
GAS_FIELD_DETAIL |
New |
Field details |
|
|
GAS_FIELDINTEREST |
New |
Field Interest annual reporting date |
|
|
GAS_FIELDINTEREST_DETAIL |
New |
Information about Field Interests |
|
|
GAS_FIELDINTEREST_PARTICIPANT |
New |
The responsible participant of the field interest |
|
|
GAS_FIELDINTEREST_SHARE |
New |
Field owner group members |
|
|
GAS_FIELDINTEREST_SHARETRK |
New |
Filed Share tracking details over time |
|
|
GAS_LNG_SHIPMENT |
New |
A list of all LNG shipments |
|
|
GAS_LNG_TRANSACTION |
New |
LNG transaction aggregated data |
|
|
GAS_RESERVES_AND_RESOURCES |
New |
Information about Field Reserves and Resources |
|
|
GAS_SHIPPER_LIST |
New |
A list of shippers who have contracted primary Storage, Compression or Pipeline capacity |
|
|
GAS_SHORT_TERM_TRANS |
New |
Information regarding short-term gas transactions |
|
|
GAS_SHORT_TERM_SWAP_TRANS |
New |
Information regarding short-term gas swap transactions |
|
|
GAS_STORAGE_CAPACITY_TRANS |
New |
Gas storage capacity transactions |
|
|
GAS_GSH_TRADES |
New |
Provide the participants (buyer and seller) a confirmation whenever a trade is executed through auto matching of bids and offers or by off-Market trades. The report 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_DAILY_STORAGE_ACTUAL |
Modified |
New field – CushionGasQuantity |
|
|
GAS_FACILITY |
Modified |
New field – FacilityShortName |
|
|
GAS_FACILITY_DETAIL |
Modified |
GasDayStartHour no longer populated |
|
|
GAS_FACILITY_NODE_CONNECTION |
Modified |
New fields – ConnectionPointShortNam + Exemption Description |
|
|
GAS_FACILITY_SUMMARY |
Modified |
GasDayStartHour no longer populated |
|
|
GAS_PARTICIPANT_DETAIL |
Modified |
New field OrganisationTypeName |
Package: GAS_SUPPLY_HUB
New table: GSH_TRADES_STAGING
|
Comment |
Provides trading participants a confirmation whenever an EFP trade is submitted to AEMO |
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GSH\REPORTS\ |
|
>Primary key (in order) |
RECORD_ID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
RECORD_ID |
VARCHAR2(20) |
The unique identifier of the record |
Y |
|
MARKET_ID |
VARCHAR2(20) |
The unique Market ID |
N |
|
PARTICIPANT_ID |
VARCHAR2(20) |
The unique identifier of the participant |
N |
|
GAS_FUTURE_ID |
VARCHAR2(20) |
The EFP Trade ID for matching trades |
N |
|
PRODUCT_GROUP_CODE |
VARCHAR2(20) |
AEMO uses a default value only: GAS-WAL. Data submitted by participants is not stored |
N |
|
PRODUCT_TYPE_CODE |
VARCHAR2(20) |
AEMO uses a default value only: NG Months. Data submitted by participants is not stored |
N |
|
DELIVERY_POINT |
VARCHAR2(40) |
AEMO uses a default value only: WAL HP Trade Point. Data submitted by participants is not stored |
N |
|
START_DATE |
DATE |
The gas start day for the EFP trade period |
N |
|
END_DATE |
DATE |
The gas end day for the EFP trade period |
N |
|
TRADE_TYPE |
VARCHAR2(20) |
Buy or Sell |
N |
|
VOLUME |
NUMBER(18,8) |
Trade quantities measured in GJ for each Gas Day in the Delivery Period |
N |
|
PRICE |
NUMBER(18,8) |
Trade price |
N |
|
STATUS |
VARCHAR2(20) |
Submission Status: PENDING, FAIL, MATCH, OVERRIDE |
N |
|
VALIDATION_MSG |
VARCHAR2(255) |
Submission validation message |
N |
|
SUBMITTED_TIME |
DATE |
Data submission time |
N |
|
LASTCHANGED |
DATE |
The date and time the report is generated |
N |
Modified table: GSH_TRADES
|
Comment |
Provides participants (buyer and seller) a confirmation whenever a trade is executed through auto matching of bids and offers or by off-Market trades. The report also provides participants a list of all their EFP trades when triggered daily after the end of the trades for the current day |
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
Each time there is an EFP Trade submission, match, and trade creation |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GSH\REPORTS\ |
|
Primary key (in order) |
MARKET_ID, TRADE_ID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
GAS_FUTURE_ID |
VARCHAR2(20) |
The EFP Trade ID for matching trades |
N |
Modified table: GSH_DELIVERY_OBLIGATIONS
|
Comment |
Provides participants with their Delivery Obligations at each location. Delivery Obligation quantities are results of the delivery netting process |
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
On table update |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GSH\REPORTS\ |
|
Primary key (in order) |
NETTING_TRANSACTION_ID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
RECEIPT_POINT |
VARCHAR2(40) |
Receipt point specified by the buyer or seller in an order submission for capacity products |
N |
Package: GAS_BB
New table: GAS_BASIN
|
Comment |
This report displays a list of all basins |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
BASINID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
BASINID |
NUMBER(20,0) |
A unique AEMO defined Facility Identifier |
Y |
|
BASINNAME |
VARCHAR2(100) |
The name of the basin. If short name exists, then short name included in report |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_DEVFACILITY
|
Comment |
Details of all Facility Developments |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
DEVFACILITYID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
DEVFACILITYID |
NUMBER(20,0) |
A unique AEMO defined Development Facility Identifier |
Y |
|
DESCRIPTION |
VARCHAR2(100) |
Description of development facility |
N |
|
FACILITYTYPE |
VARCHAR2(40) |
The facility development type |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_DEVFACILITY_DETAIL
|
Comment |
Details of all Facility Developments over time |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
DEVFACILITYID+EFFECTIVEDATE+VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
DEVFACILITYID |
NUMBER(20,0) |
A unique AEMO defined Development Facility Identifier |
Y |
|
EFFECTIVEDATE |
DATE |
The effective date of the submission |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
PROPOSEDNAME |
VARCHAR2(100) |
The name of the Facility development |
N |
|
MINNAMEPLATE |
NUMBER(18,3) |
The lower estimate of nameplate rating capacity |
N |
|
MAXNAMEPLATE |
NUMBER(18,3) |
The upper estimate of nameplate rating capacity |
N |
|
LOCATION |
VARCHAR2(200) |
The location of the development facility |
N |
|
PLANNEDCOMMISSIONFROM |
VARCHAR2(7) |
The planned start date of commissioning |
N |
|
PLANNEDCOMMISSIONTO |
VARCHAR2(7) |
The planned end date of commissioning |
N |
|
DEVELOPMENTSTAGE |
VARCHAR2(200) |
The current stage of the development facility being, PROPOSED, COMMITTED, CANCELLED, ENDED |
N |
|
COMMENTS |
VARCHAR2(400) |
Any additional comments included in the submission |
N |
|
AUTHORISEDDATE |
DATE |
Date and time this operating state was authorised |
N |
|
AUTHORISEDBY |
VARCHAR2(30) |
Reporting entity for the facility |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_DEVFACILITY_FACILITY
|
Comment |
Any facility that is related to dev facility |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
DEVFACILITYID+EFFECTIVEDATE+VERSIONDATETIME+FACILITYID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
DEVFACILITYID |
NUMBER(20,0) |
A unique AEMO defined Development Facility Identifier |
Y |
|
EFFECTIVEDATE |
DATE |
The effective date of the submission |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
FACILITYID |
NUMBER(20,0) |
Unique facility identifier |
Y |
New table: GAS_FIELD
|
Comment |
Field location |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FIELDID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FIELDID |
NUMBER(20,0) |
A unique AEMO defined Field Identifier |
Y |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
|
STATEID |
NUMBER(10,0) |
The state ID the field interest is in |
N |
|
STATE |
VARCHAR2(5) |
The state the field interest is in |
N |
New table: GAS_FIELD_DETAIL
|
Comment |
Field details |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FIELDID+EFFECTIVEDATE+VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FIELDID |
NUMBER(20,0) |
A unique AEMO defined Field Identifier |
Y |
|
EFFECTIVEDATE |
DATE |
The date on which the record takes effect |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
FIELDNAME |
VARCHAR2(100) |
The name of the Field in which the Field Interest is located |
N |
|
FIELDSHORTNAME |
VARCHAR2(30) |
The short name of the field |
N |
|
DESCRIPTION |
VARCHAR2(400) |
Additional information relating to the field |
N |
|
LOCATIONDESCRIPTION |
VARCHAR2(200) |
Additional information relating to the location of the field |
N |
|
AUTHORISEDDATE |
DATE |
Date and time this operating state was authorised |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_FIELDINTEREST
|
Comment |
Field Interest annual reporting date |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FIELDINTERESTID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FIELDINTERESTID |
NUMBER(20,0) |
A unique AEMO defined Field Interest Identifier |
Y |
|
FIELDID |
NUMBER(20,0) |
A unique AEMO defined Field Identifier |
N |
|
ANNUALREPORTINGDATE |
VARCHAR2(30) |
The annual reporting date of the field interest |
N |
New table: GAS_FIELDINTEREST_DETAIL
|
Comment |
This report displays information about Field Interests |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FIELDINTERESTID+EFFECTIVEDATE+VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FIELDINTERESTID |
NUMBER(20,0) |
A unique AEMO defined Field Interest Identifier |
Y |
|
EFFECTIVEDATE |
DATE |
The date on which the record takes effect |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
PETROLEUMTENEMENTS |
VARCHAR2(300) |
The petroleum tenements which are the subject of the BB field interest |
N |
|
PROCESSINGFACILITIES |
VARCHAR2(300) |
The processing facility used to process gas from the field |
N |
|
RESOURCECLASSIFICATION |
VARCHAR2(100) |
Classification of the resources in the field as conventional or unconventional |
N |
|
RESOURCESUBCLASSIFICATION |
VARCHAR2(100) |
Any further sub-classification of the resources |
N |
|
NATUREOFGAS |
VARCHAR2(100) |
The nature of the gas in the field using classifications in the BB Procedures |
N |
|
TENEMENTSHARE |
NUMBER(10,3) |
The field interest share of the petroleum tenements |
N |
|
AUTHORISEDDATE |
DATE |
Date and time this operating state was authorised |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_FIELDINTEREST_PARTICIPANT
|
Comment |
The responsible participant of the field interest |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FIELDINTERESTID+EFFECTIVEDATE+VERSIONDATETIME+COMPANYID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FIELDINTERESTID |
NUMBER(20,0) |
A unique AEMO defined Field Interest Identifier |
Y |
|
EFFECTIVEDATE |
DATE |
The date on which the record takes effect |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
COMPANYID |
NUMBER(10,0) |
The company ID of the responsible field owner |
Y |
|
AUTHORISEDDATE |
DATE |
Date and time this operating state was authorised |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_FIELDINTEREST_SHARE
|
Comment |
Field owner group members |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FIELDINTERESTID+EFFECTIVEDATE+VERSIONDATETIME+REPORTEDCOMPANY |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FIELDINTERESTID |
NUMBER(20,0) |
A unique AEMO defined Field Interest Identifier |
Y |
|
EFFECTIVEDATE |
DATE |
The date on which the record takes effect |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
REPORTEDCOMPANY |
VARCHAR2(100) |
Member of the field owner group |
Y |
|
PERCENTAGESHARE |
NUMBER(18,8) |
The percentage share of the group member |
N |
New table: GAS_FIELDINTEREST_SHARETRK
Comment | Filed Share tracking details over time |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FIELDINTERESTID+EFFECTIVEDATE+VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FIELDINTERESTID |
NUMBER(20,0) |
A unique AEMO defined Field Interest Identifier |
Y |
|
EFFECTIVEDATE |
DATE |
The date on which the record takes effect |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
AUTHORISEDDATE |
DATE |
Date and time this operating state was authorised |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_LNG_SHIPMENT
|
Comment |
This table displays a list of all LNG shipments |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Time trigger daily at 3:00 PM AEST |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
TRANSACTIONID+FACILITYID+VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
TRANSACTIONID |
VARCHAR2(40) |
Unique shipment identifier |
Y |
|
FACILITYID |
NUMBER(20,0) |
Unique facility identifier |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
SHIPMENTDATE |
DATE |
For LNG export facility, the departure date. For LNG import facility, the date unloading commences at the LNG import facility |
N |
|
VOLUMEPJ |
NUMBER(18,8) |
Volume of the shipment in PJ |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_LNG_TRANSACTION
|
Comment |
This table displays LNG transaction aggregated data |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Time trigger daily at 3:00 PM AEST |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
TRANSACTIONSTARTDATE |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
TRANSACTIONSTARTDATE |
DATE |
Transaction start date |
Y |
|
TRANSACTIONENDDATE |
DATE |
Transaction end date |
N |
|
VOLWEIGHTPRICE |
NUMBER(18,8) |
The volume weighted price for the reporting period |
N |
|
VOLUMEPJ |
NUMBER(18,8) |
The total volume of the transactions |
N |
|
SUPPLYPERIODSTART |
DATE |
The earliest start date of all transactions captured in the reporting period |
N |
|
SUPPLYPERIODEND |
DATE |
The latest end date of all transactions captured in the reporting period |
N |
New table: GAS_RESERVES_AND_RESOURCES
|
Comment |
This table displays information about Field Reserves and Resources |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Time trigger every 30 mins |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FIELDINTERESTID+EFFECTIVEDATE+VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FIELDINTERESTID |
NUMBER(20,0) |
A unique AEMO defined Field Interest Identifier |
Y |
|
EFFECTIVEDATE |
DATE |
The date on which the record takes effect |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
DEVELOPEDRESERVE1P |
NUMBER(18,3) |
An estimate of the BB field interest 1P developed reserves |
N |
|
DEVELOPEDRESERVE2P |
NUMBER(18,3) |
An estimate of the BB field interest 2P developed reserves |
N |
|
DEVELOPEDRESERVE3P |
NUMBER(18,3) |
An estimate of the BB field interest 3P developed reserves |
N |
|
UNDEVELOPEDRESERVE1P |
NUMBER(18,3) |
An estimate of the BB field interest 1P undeveloped reserves |
N |
|
UNDEVELOPEDRESERVE2P |
NUMBER(18,3) |
An estimate of the BB field interest 2P undeveloped reserves |
N |
|
UNDEVELOPEDRESERVE3P |
NUMBER(18,3) |
An estimate of the BB field interest 3P undeveloped reserves |
N |
|
RESOURCES2C |
NUMBER(18,3) |
An estimate of the BB field interest 2C resources |
N |
|
PRODUCTIONCHANGERESERVE2P |
NUMBER(18,3) |
An estimate of the total movement in the BB field interest 2P reserves since the end of prior reporting year due to the production of gas |
N |
|
PROVEDAREAEXTENSIONRESERVE2P |
NUMBER(18,3) |
An estimate of the total movement in the BB field interest 2P reserves since the end of prior reporting year due to the extension of a field’s proved area |
N |
|
PERCENTAGECHANGERESERVE2P |
NUMBER(18,3) |
An estimate of the total movement in the BB field interest 2P reserves since the end of prior reporting year due to a percentage change in the BB field interest |
N |
|
UPWARDREVISION3PRESERVETO2P |
NUMBER(18,3) |
An estimate of the total movement in the BB field interest 2P reserves since the end of prior reporting year due to an upward revision of 2P reserves arising from the reclassification of 3P reserves or resources to 2P reserves |
N |
|
DOWNWARDREVISION2PRESERVETO3P |
NUMBER(18,3) |
An estimate of the total movement in the BB field interest 2P reserves since the end of prior reporting year due to a downward revision of 2P reserves arising from the reclassification of 2P reserves to 3P reserves or resources |
N |
|
OTHERREVISIONSRESERVE2P |
NUMBER(18,3) |
An estimate of the total movement in the BB field interest 2P reserves since the end of prior reporting year due to other revisions |
N |
|
MATURITYSUBCLASS2P |
VARCHAR2(100) |
The project maturity sub-class for the 2P reserves |
N |
|
MATURITYSUBCLASS2C |
VARCHAR2(100) |
The project maturity sub-class for the 2C resources |
N |
|
MINDATE2P |
DATE |
The earliest estimated date for the production of the 2P reserves |
N |
|
MAXDATE2P |
DATE |
The latest estimated date for the production of the 2P reserves |
N |
|
MINDATE2C |
DATE |
The earliest estimated date for the production of the 2C resources |
N |
|
MAXDATE2C |
DATE |
The latest estimated date for the production of the 2C resources |
N |
|
EXPECTEDBARRIERS2C |
VARCHAR2(400) |
A list of any barriers to the commercial recovery of the 2C resources |
N |
|
RESOURCESESTIMATEMETHOD |
VARCHAR2(200) |
The resources assessment method used to prepare the reserves and resources estimates |
N |
|
CONVERSIONFACTORQTYTCFTOPJ |
NUMBER(18,3) |
The conversion factor used to convert quantities measured in trillions of cubic feet to PJ |
N |
|
ECONOMICASSUMPTION |
VARCHAR2(400) |
The key economic assumptions in the forecast case used to prepare the reserves and resource estimates and the source of the assumptions |
N |
|
UPDATEREASON |
VARCHAR2(400) |
The reason for the update |
N |
|
PREPAREDBY |
VARCHAR2(100) |
The name of the person who prepared the estimates |
N |
|
INDEPENDENTESTIMATE |
VARCHAR2(3) |
Whether the qualified gas industry professional who prepared, or supervised the preparation of, the reserves and resources estimates is independent of the BB reporting entity |
N |
|
AUTHORISEDDATE |
DATE |
Date and time this operating state was authorised |
N |
|
LASTCHANGED |
DATE |
Date and time record was last modified |
N |
New table: GAS_SHIPPER_LIST
|
Comment |
A list of shippers who have contracted primary Storage, Compression or Pipeline capacity |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FACILITYID+EFFECTIVEDATE+VERSIONDATETIME+SHIPPERNAME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FACILITYID |
NUMBER(20) |
A unique AEMO defined Facility Identifier. |
Y |
|
EFFECTIVEDATE |
DATE |
Gas date that corresponding record takes effect |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
SHIPPERNAME |
VARCHAR2(200) |
The name of the shipper who holds the capacity |
Y |
New table: GAS_SHORT_TERM_TRANS
|
Comment |
These reports display information regarding short-term gas transactions |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Time trigger daily at 3:00 PM AEST |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
PERIODSTARTDATE+STATE |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
PERIODSTARTDATE |
DATE |
The time period start date |
Y |
|
PERIODENDDATE |
DATE |
The time period end date |
N |
|
STATE |
VARCHAR2(5) |
The state where the transaction occurred |
Y |
|
QUANTITY |
NUMBER(18,8) |
Total volume of the transactions where trade date is in the reporting period for the given state |
N |
|
VOLUMEWEIGHTEDPRICE |
NUMBER(18,8) |
Volume weighted price of transactions where trade date is in the reporting period for the given State |
N |
|
TRANSACTIONTYPE |
VARCHAR2(255) |
Transaction Type is Supply for these short-term transactions reports |
N |
|
SUPPLYPERIODSTART |
DATE |
The earliest start date of all transactions in the reporting period for the given state |
N |
|
SUPPLYPERIODEND |
DATE |
The latest end date of all transactions in the reporting period for the given state |
N |
New table: GAS_SHORT_TERM_SWAP_TRANS
|
Comment |
These reports display information regarding short-term gas swap transactions |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Time trigger daily at 3:00 PM AEST |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
PERIODSTARTDATE+STATE |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
PERIODSTARTDATE |
DATE |
The time period start date |
Y |
|
PERIODENDDATE |
DATE |
The time period end date |
N |
|
STATE |
VARCHAR2(5) |
The state where the transaction occurred |
Y |
|
QUANTITY |
NUMBER(18,8) |
Total volume of the transactions where trade date is in the reporting period for the given state |
N |
|
VOLUMEWEIGHTEDPRICE |
NUMBER(18,8) |
Volume weighted price of transactions where trade date is in the reporting period for the given State |
N |
|
TRANSACTIONTYPE |
VARCHAR2(255) |
Whether the swap is a location swap, time swap or both location and time swap |
N |
|
SUPPLYPERIODSTART |
DATE |
The earliest start date of all transactions in the reporting period for the given state |
N |
|
SUPPLYPERIODEND |
DATE |
The latest end date of all transactions in the reporting period for the given state |
N |
New table: GAS_STORAGE_CAPACITY_TRANS
|
Comment |
Gas storage capacity transactions |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Time trigger every 30 mins |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
TRADEID+VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
TRADEID |
NUMBER(20,0) |
A unique AEMO defined Transaction Identifier |
Y |
|
VERSIONDATETIME |
DATE |
Time a successful submission is accepted by AEMO systems |
Y |
|
TRADEDATE |
DATE |
The date the transaction was entered into |
N |
|
FROMGASDATE |
DATE |
The start date of the transaction |
N |
|
TOGASDATE |
DATE |
The end date of the transaction |
N |
|
FACILITYID |
NUMBER(20,0) |
The gas storage facility ID for the facility by means of which the service is provided |
N |
|
PRIORITY |
VARCHAR2(255) |
The priority given to the service to which the transaction relates |
N |
|
MAXIMUMSTORAGEQUANTITY |
NUMBER(18,3) |
The storage capacity the subject of the transaction (in GJ) |
N |
|
INJECTIONCAPACITY |
NUMBER(18,3) |
The injection capacity (in GJ/day) |
N |
|
WITHDRAWALCAPACITY |
NUMBER(18,3) |
The withdrawal capacity (in GJ/day) |
N |
|
PRICE |
NUMBER(18,3) |
The transaction price (in $/GJ/day or where relevant, in $/GJ) |
N |
|
PRICESTRUCTURE |
VARCHAR2(255) |
The price structure applicable to the transaction |
N |
|
PRICEESCALATIONMECHANISM |
VARCHAR2(255) |
Any price escalation mechanism applicable to the transaction |
N |
|
CANCELLED |
NUMBER(1,0) |
Whether the record has been cancelled |
N |
|
LASTCHANGED |
DATE |
The date the record was last updated |
N |
New table: GAS_GSH_TRADES
|
Comment |
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 |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Time trigger |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
TRADE_DATE+TRANSACTION_TYPE+PRODUCT+LOCATION+TRADE_PRICE |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
TRADE_DATE |
DATE |
Date and time the trade is executed |
Y |
|
TRANSACTION_TYPE |
VARCHAR2(20) |
The type of the trade. Valid values are AUTO_MATCHED, OFF_MARKET_TRADE |
Y |
|
PRODUCT |
VARCHAR2(80) |
The product delivery period for the Gas Supply Hub market |
Y |
|
LOCATION |
VARCHAR2(100) |
Product location for the Gas Supply Hub market |
Y |
|
NO_OF_TRADES |
NUMBER(10) |
Count of number of trades |
N |
|
TRADE_PRICE |
NUMBER(18,8) |
Price value of the trade in $/GJ |
Y |
|
DAILY_QTY_GJ |
NUMBER(18,8) |
Volume of gas transacted on the Trading Platform in GJ/day |
N |
|
START_DATE |
DATE |
The start gas day for the order delivery period |
N |
|
END_DATE |
DATE |
The end gas day for the order delivery period |
N |
|
MANUAL_TRADE |
VARCHAR2(50) |
Whether the trade is a manual trade |
N |
|
LASTCHANGED |
DATE |
The date the record was last updated |
N |
Modified table: GAS_DAILY_STORAGE_ACTUAL
|
Comment |
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 |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
GASDATE, FACILITYID, VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
CUSHIONGASQUANTITY |
NUMBER(18,3) |
The quantity of natural gas that must be retained in the Storage or LNGImport facility to maintain the required pressure and deliverability rates |
N |
Modified table: GAS_FACILITY
|
Comment |
Provides details of all facilities and associated nodes and connection points. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FACILITYID |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
FACILITYSHORTNAME |
VARCHAR2(30) |
An abbreviation of the facility name |
N |
Modified table: GAS_FACILITY_DETAIL
|
Comment |
The list of all gas Facilities. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FACILITYID, EFFECTIVEDATE, VERSIONDATETIME |
Modified columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
GASDAYSTARTHOUR |
NUMBER(2,0) |
Column no longer populated |
N |
Modified table: GAS_FACILITY_NODE_CONNECTION
|
Comment |
Identifies the set of connection points associated with a node. There are up to four connection points to a node, and up to two connection points for each facility or node combination. For example, a pipeline might be connected to a storage facility via a node. Two connection points in the node are connected to the pipe and two connection points to the storage facility. Each pair of connections is a delivery or a receipt type of connection |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FACILITYID, EFFECTIVEDATE, VERSIONDATETIME, NODEID, CONNECTIONPOINTID, FLOWDIRECTION |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
CONNECTIONPOINTSHORTNAME |
VARCHAR2(30) |
An abbreviation of the connection point name |
N |
|
EXEMPTIONDESCRIPTION |
VARCHAR2(200) |
Description of the exemption |
N |
Modified table: GAS_FACILITY_SUMMARY
|
Comment |
The standing details on capacity of all gas plant facilities over time |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
FACILITYID, STARTDATE, CONNECTIONPOINTID, FLOWDIRECTION |
Modified columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
GASDAYSTARTHOUR |
NUMBER(2,0) |
Column No longer populated |
N |
Modified table: GAS_PARTICIPANT_DETAIL
|
Comment |
The details of all registered organisations i.e the BB Participants of the Bulletin Board over time |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Participant submission |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GASBB\REPORTS\ |
|
Primary key (in order) |
COMPANYID, EFFECTIVEDATE, VERSIONDATETIME |
New columns
|
Field Name |
Data type |
Comment |
PK |
|---|---|---|---|
|
ORGANISATIONTYPENAME |
VARCHAR2(40) |
The type of organisation |
N |
File interface changes
|
Package ID |
File ID |
Description |
Batcher file masks |
Frequency |
Change |
Auto-subscription |
|---|---|---|---|---|---|---|
|
GAS_SUPPLY_HUB |
GSH_TRADE_SINGLE |
Visibility: private Provides a confirmation to Trading Participants (buyer and seller) when a trade is executed through auto matching of bids, offers, submissions or by off-Market trades |
*_TRADEEXECUTION_* |
On trade submission |
Modified |
No |
|
|
GSH_TRADE_RANGE |
Visibility: private Triggered daily at the end of the Gas Day, providing Trading Participants with a list of their EFP trades |
*_TRADEEXECUTION_* |
Daily |
Modified |
No |
|
|
GSH.FUTURE_TRADE_SINGLE |
Visibility: private Contains all relevant records from EFP Trade submissions. Trading Participant only see their own submissions |
*_FUTURE_SUBMISSION_* |
On future trade submission |
New |
Yes |
|
GAS_BB |
GASBB3_BASIN |
Visibility: public This report displays a list of all basins |
*_GAS_BASIN_*.CSV |
On |
New |
Yes |
|
GASBB3_DEVFACILITY |
Visibility: public Details of all Facility Developments |
*_GASBB3_DEVFACILITY_*.CSV |
On |
New |
Yes |
|
|
GASBB3_DEVFACILITY_DETAIL |
Visibility: public Details of all Facility Developments over time |
*_GASBB3_DEVFACILITY_DETAIL_*.CSV |
On |
New |
Yes |
|
|
GASBB3_DEVFACILITY_FACILITY |
Visibility: public Any facility related to the dev facility |
*_GASBB3_DEVFACILITY_FACILITY_*.CSV |
On |
New |
Yes |
|
|
GASBB3_FIELD |
Visibility: public Field location |
*_GASBB3_FIELD_*.CSV |
On |
New |
Yes |
|
|
GASBB3_FIELD_DETAIL |
Visibility: public Field details |
*_GASBB3_FIELD_DETAIL_*.CSV |
On |
New |
Yes |
|
|
GASBB3_FIELDINTEREST |
Visibility: public Field Interest annual reporting date |
*_GASBB3_FIELD_INTEREST_*.CSV |
On |
New |
Yes |
|
|
GASBB3_FIELDINTEREST_DETAIL |
Visibility: public Information about Field Interests |
*_GASBB3_FIELDINTEREST_DETAIL_*.CSV |
On |
New |
Yes |
|
|
GASBB3_FIELDINTEREST_PARTICIPANT |
Visibility: public The responsible participant of the field interest |
*_GASBB3_FIELD_INTEREST_PARTICIPANT_*.CSV |
On |
New |
Yes |
|
|
GASBB3_FIELDINTEREST_SHARE |
Visibility: public Field owner group members |
*_GASBB3_FIELD_INTEREST_SHARE_*.CSV |
On |
New |
Yes |
|
|
GASBB3_FIELDINTEREST_SHARETRK |
Visibility: public Filed Share tracking details over time |
*_GASBB3_FIELD_INTEREST_SHARE_TRK_*.CSV |
On |
New |
Yes |
|
|
GASBB3_LNG_SHIPMENT |
Visibility: public A list of all LNG shipments |
*_GASBB3_LNG_SHIPMENT_*.CSV |
On |
New |
Yes |
|
|
GASBB3_LNG_TRANSACTION |
Visibility: public LNG transaction aggregated data |
*_GASBB3_LNG_TRANSACTION_*.CSV |
Time trigger |
New |
Yes |
|
|
GASBB3_RESERVES_AND_RESOURCES |
Visibility: public Information about Field Reserves and Resources |
*_GASBB3_RESERVES_AND_RESOURCES_*.CSV |
On |
New |
Yes |
|
|
GASBB3_SHIPPER_LIST |
Visibility: public A list of shippers who have contracted primary Storage, Compression or Pipeline capacity |
*_GASBB3_SHIPPER_LIST_*.CSV |
On |
New |
Yes |
|
|
GASBB3_SHORT_TERM_TRANS |
Visibility: public Information regarding short-term gas transactions |
*_GASBB3_SHORT_TERM_TRANS_*.CSV |
Time trigger |
New |
Yes |
|
|
GASBB3_SHORT_TERM_SWAP_TRANS |
Visibility: public Information regarding short-term gas swap transactions |
*_GASBB3_SHORT_TERM_SWAP_TRANS_*.CSV |
Time trigger |
New |
Yes |
|
|
GASBB3_STORAGE_CAPACITY_TRANS |
Visibility: public Gas storage capacity transactions |
*_GASBB3_STORAGE_CAPACITY_TRANS_*.CSV |
On |
New |
Yes |
|
|
GASBB3_GSH_TRADES |
Visibility: public Provide the participants (buyer and seller) a confirmation whenever a trade is executed through auto matching of bids and offers or by off-Market trades. The report also provides participants with a list of all their future trades when triggered daily after the end of the trades for the current day |
*_GASBB3_GSH_TRADES_*.CSV |
Time trigger |
New |
Yes |
|
|
GASBB3_DAILY_STORAGE_ACTUAL |
Visibility: public 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 |
*_GASBB3_DAILY_STORAGE_ACTUAL_*.CSV |
On |
Modified |
No |
|
|
GASBB3_FACILITY |
Visibility: public Provides details of all facilities and associated nodes and connection points. |
*_GASBB3_FACILITY*.CSV |
On |
Modified |
No |
|
|
GASBB3_FACILITY_NODE_TRK |
Visibility: public Identifies the set of connection points associated with a node. There are up to four connection points to a node, and up to two connection points for each facility or |
*_GASBB3_FACILITY_NODE_TRK_*.CSV |
On |
Modified |
No |
|
|
GASBB3_PARTICIPANT_DETAIL |
Visibility: public The details of all registered organisations i.e the BB Participants of the Bulletin Board over time |
*_GASBB3_PARTICIPANT_DETAIL_*.CSV |
On |
Modified |
No |
Participant interfaces changes
|
Package Name |
Gas Data Model table |
File ID |
CSV report type |
Change |
|---|---|---|---|---|
|
GAS_SUPPLY_HUB |
GSH_TRADES_STAGING |
GSH_FUTURE_TRADE_SINGLE |
GSH,GSH_TRADE_STAGING, TRADES_STAGING, 1 |
New |
|
GSH_TRADES |
GSH_TRADE_SINGLE |
GSH,GSH_TRADES,TRADES,4 |
Modified |
|
|
GAS_BB |
GSH_TRADES |
GSH_TRADE_RANGE |
GSH,GSH_TRADES,TRADES,4 |
Modified |
|
GAS_BASIN |
GASBB3_BASIN |
GASBB3,GAS_BASIN,1 |
New |
|
|
GAS_DEVFACILITY |
GASBB3_DEVFACILITY |
GASBB3,GAS_DEVFACILITY,1 |
New |
|
|
GAS_DEVFACILITY_DETAIL |
GASBB3_DEVFACILITY_DETAIL |
GASBB3,GAS_DEVFACILITY_DETAIL,1 |
New |
|
|
GAS_DEVFACILITY_FACILITY |
GASBB3_DEVFACILITY_FACILITY |
GASBB3,GAS_DEVFACILITY_FACILITY,1 |
New |
|
|
GAS_FIELD |
GASBB3_FIELD |
GASBB3,GAS_FIELD,1 |
New |
|
|
GAS_FIELD_DETAIL |
GASBB3_FIELD_DETAIL |
GASBB3,GAS_FIELD_DETAIL,1 |
New |
|
|
GAS_FIELDINTEREST |
GASBB3_FIELDINTEREST |
GASBB3,GAS_FIELDINTEREST,1 |
New |
|
|
GAS_FIELDINTEREST_DETAIL |
GASBB3_FIELDINTEREST_DETAIL |
GASBB3,GAS_FIELDINTEREST_DETAIL,1 |
New |
|
|
GAS_FIELDINTEREST_PARTICIPANT |
GASBB3_FIELDINTEREST_PARTICIPANT |
GASBB3,GAS_FIELDINTEREST_PARTICIPANT,1 |
New |
|
|
GAS_FIELDINTEREST_SHARE |
GASBB3_FIELDINTEREST_SHARE |
GASBB3,GAS_FIELDINTEREST_SHARE,1 |
New |
|
|
GAS_FIELDINTEREST_SHARETRK |
GASBB3_FIELDINTEREST_SHARETRK |
GASBB3,GAS_FIELDINTEREST_SHARETRK,1 |
New |
|
|
GAS_LNG_SHIPMENT |
GASBB3_LNG_SHIPMENT |
GASBB3,GAS_LNG_SHIPMENT,1 |
New |
|
|
GAS_LNG_TRANSACTION |
GASBB3_LNG_TRANSACTION |
GASBB3,GAS_LNG_TRANSACTION,1 |
New |
|
|
GAS_RESERVES_AND_RESOURCES |
GASBB3_RESERVES_AND_RESOURCES |
GASBB3,GAS_RESERVES_AND_RESOURCES,1 |
New |
|
|
GAS_SHIPPER_LIST |
GASBB3_SHIPPER_LIST |
GASBB3,GAS_SHIPPER_LIST,1 |
New |
|
|
GAS_SHORT_TERM_TRANS |
GASBB3_SHORT_TERM_TRANS |
GASBB3,GAS_SHORT_TERM_TRANS,1 |
New |
|
|
GAS_SHORT_TERM_SWAP_TRANS |
GASBB3_SHORT_TERM_SWAP_TRANS |
GASBB3,GAS_SHORT_TERM_SWAP_TRANS,1 |
New |
|
|
GAS_STORAGE_CAPACITY_TRANS |
GASBB3_STORAGE_CAPACITY_TRANS |
GASBB3,GAS_STORAGE_CAPACITY_TRANS,1 |
New |
|
|
GAS_GSH_TRADES |
GASBB3_GSH_TRADES |
GASBB3,GAS_GSH_TRADES,1 |
New |
|
|
GAS_DAILY_STORAGE_ACTUAL |
GASBB3_DAILY_STORAGE_ACTUAL |
GASBB3,GAS_DAILY_STORAGE_ACTUAL,2 |
Modified |
|
|
GAS_FACILITY |
GASBB3_FACILITY |
GASBB3,GAS_FACILITY,2 |
Modified |
|
|
GAS_FACILITY_NODE_CONNECTION |
GASBB3_FACILITY_NODE_TRK |
GASBB3,GAS_FACILITY_NODE_CONNECTION,2 |
Modified |
|
|
GAS_PARTICIPANT_DETAIL |
GASBB3_PARTICIPANT_DETAIL |
GASBB3,GAS_PARTICIPANT_DETAIL,2 |
Modified |
Discontinued reports
|
Gas Data Model table |
File ID |
CSV report type |
Replaced by |
|---|---|---|---|
|
GSH_TRADES |
GSH_TRADE_SINGLE |
GSH,GSH_TRADES,TRADES,3 |
GSH,GSH_TRADES,TRADES,4 |
|
GSH_TRADES |
GSH_TRADE_RANGE |
GSH,GSH_TRADES,TRADES,3 |
GSH,GSH_TRADES,TRADES,4 |
Non-functional changes
- Gas Data Model The definition of the interface to participants of data published by AEMO for gas or electricity. A database conforming to the Data Model can contain a local copy of all current participant-specific data recorded in the main database. The Data Model includes database tables, indexes, and primary keys. Report A data report that loads into a data model table. Identified by its type, subtype, and version. For example: BILLING,BILLINGASPAYMENTS,2 v2.2
- Gas Data Model Upgrade Report v2.2
- Gas Table to File to Report v2.2
- Market Data NEMweb Public market data in csv file format: http://www.nemweb.com.au/
- Data Subscription A web application in the Markets Portal used to subscribe to Data Interchange files and to obtain the latest MMS Data Model. These files are typically csv files containing public data and participant’s private data. AEMO recommends participant use of the Data Interchange suite of products, supplied by AEMO, to automate receiving and storage of the files to their systems. AEMO provides working sample software for FTP access (Participant Batcher) to MarketNet and working sample software for Data Interchange.
- Data Interchange A set of cooperating applications used to replicate data between AEMO's energy market systems and a participant's DBMS conforming to the MMS Data Model. Online Help