Data Interchange
This section explains the 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. tables required to receive the Delivery Netting See Relevant Rules or Procedures Preferences Report A data report that loads into a data model table. Identified by its type, subtype, and version. For example: BILLING,BILLINGASPAYMENTS,2.
For help using Data Interchange, see Concise Guide to Data Interchange.
Table: GSH_DELIVERY_NETT_PREFS
|
Name |
GSH_DELIVERY_NETT_PREFS |
|
Comment |
Provide a history of Delivery Netting Preferences entered through the new Delivery Netting web interface. |
|
Visibility |
Private |
|
Trigger |
Produced when participants update delivery netting preferences in the Web Portal. |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GSH\REPORTS |
|
Primary key |
MARKET_ID, PARTICIPANT_CODE, PRODUCT_LOCATION, VERSION_DATETIME |
Columns
|
Field name |
Data type |
Comment |
|
MARKET_ID |
VARCHAR2(20) |
Unique Market ID |
|
PARTICIPANT_CODE |
VARCHAR2(20) |
The participant code |
|
PRODUCT_LOCATION |
VARCHAR2(80) |
Product location for the GSH market |
|
VERSION_DATETIME |
DATE |
Date and time preference entered |
|
START_DATE |
DATE |
Date preference takes effect from |
|
END_DATE |
DATE |
Date preference takes effect until |
|
CHOSEN_POSITION |
VARCHAR2(20) |
Type of position used. Valid values are:
|
|
USE_TRANSACTIONS |
VARCHAR2(1) |
Whether original delivery points specified in trades will be used:
|
|
USE_GROUPS |
VARCHAR2(1) |
Indicates if positions are matched using groups:
|
|
LAST_UPDATED |
DATE |
The date & time the preference was updated |
|
LAST_UPDATED_BY |
VARCHAR2(20) |
The user name who updated the preference |
|
LASTCHANGED |
DATE |
The date & time the report was generated |
Table: GSH_DELIVERY_NETT_POINTS
|
Name |
GSH_DELIVERY_NETT_POINTS |
|
Comment |
List of delivery Delivery Netting Preferences if delivery points are overridden. Child record of GSH_DELIVERY_NETT_PREFS |
|
Visibility |
Private |
|
Trigger |
Produced when participants update delivery netting preferences in the Web Portal. |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\GSH\REPORTS |
|
Primary key |
MARKET_ID, PARTICIPANT_CODE, PRODUCT_LOCATION, VERSION_DATETIME, POSITION_TYPE, PRIORITY |
Columns
|
Field name |
Data type |
Comment |
|
MARKET_ID |
VARCHAR2(20) |
Unique Market ID |
|
PARTICIPANT_CODE |
VARCHAR2(20) |
The participant code |
|
PRODUCT_LOCATION |
VARCHAR2(80) |
Product location for the GSH market |
|
VERSION_DATETIME |
DATE |
Date and time preference entered |
|
POSITION_TYPE |
VARCHAR2(20) |
Type of position used. Valid values are:
|
|
PRIORITY |
NUMBER(3,0) |
Order of priority for overriding delivery points |
|
DELIVERY_POINT |
VARCHAR2(40) |
Name of delivery point |
|
VOLUME |
NUMBER(18,8) |
Amount (Gj) to assign to delivery point |
|
LAST_UPDATED |
DATE |
The date & time the preference was updated |
|
LASTCHANGED |
DATE |
The date & time the report was generated |