Upload a Reallocation

This topic explains how to upload a reallocation CSV file to the GSH Gas Supply Hub. An exchange for the wholesale trading of natural gas. Reallocations Reallocation Request Service. See Relevant Rules or Procedures interface.

For a detailed explanation of CSV file transactions, see Guide to GSH CSV File Transactions.

Rules for uploading CSV files

The following rules apply to uploading csv Comma Separated Values. A file format for data using commas as delimiters. files:

  • Participants must already have a prepared csv file on their local computer, CSV file format.

  • The file must contain only one reallocation record.

  • Every record in the file must pass validation. If any record in the file fails validation, the entire file is rejected.

Filename format

There is no compulsory filename format for the reallocations csv file, below is an example only.

REALLOCATIONS_yyyymmdd_ID
REALLOCATIONS_20130405_036356csv

CSV file format

This section explains the data in the reallocations csv file. For a file to be accepted for import it must contain the mandatory data identified in the first column with an asterisk (*). Do not include the asterisk in your file.

Downloading a template file is the easiest way to create your csv file, Downloading a template

The first C record in the file is of the format:

C,<system>,<from>,<to>,<publish date>,<publish time>
For example: GSH, DME1, AEMO Australian Energy Market Operator, 22/11/2013, 10:30:30

Figure 89 Reallocations CSV file example

Table 38 Reallocations CSV file format

Column

Label

Data Entry example

Comments

A*

C, I, or D

C, I, or D

C = a comment field e.g. the description of the file.
I = header information – all data must be in upper case.
D = your data for the reallocation – all data must be in upper case.

B*

REALLOCATION

REALLOCATION

The system identifier - must be REALLOCATION.

B*

PROFILE

PROFILE

 

C*

CREDIT_PARTICIPANT_CODE

02P1

The credit participant code for the reallocation.
Must be a valid GSH Reallocations participant ID.

C*

GAS_DATE

27/05/2013

The gas date in the reallocation period to which the daily amount applies.

D*

DEBIT_PARTICIPANT_CODE

DME1

The debit participant code for the reallocation.
Must be a valid GSH Reallocations participant ID.

D*

AMOUNT

5000

Enter the amount of the agreement. Agreement amounts cannot be negative values. The reallocation agreement amount is specified per day for each day within the reallocation agreement period including the start and end dates. The daily amounts can be either dollar daily amounts or quantity daily amounts, depending on the agreement type. You can specify one agreement amount that applies to each gas day in the reallocation agreement period, or specify different agreement amounts for different gas days within the reallocation agreement period.

E*

AGREEMENT TYPE

fixed_energy

The agreement type of the reallocation, either fixed_dollar or fixed_energy.

F

PRODUCT_GROUP_CODE

GAS-QGP

The product location used to determine the reference price. Compulsory for the Fixed Quantity Amount agreement type.

G

CREDIT_REFERENCE

ABD586t

The credit participant reference in the reallocation.
This field helps participants to identify reallocations quickly according to their own system. There are no restrictions on format or characters used in this field, you can enter text, numbers, or a combination of both.

H

DEBIT_REFERENCE

ASMM6t

The debit participant reference in the reallocation.
This field helps participants to identify reallocations quickly according to their own system. There are no restrictions on format or characters used in this field, you can enter text, numbers, or a combination of both.

I*

START_DATE

27/05/2013

The first gas day of the reallocation.

J*

END_DATE

25/08/2013

The last gas day of the reallocation.

Downloading a template

  1. Click Create Reallocation. For help accessing GSH Reallocations, see Access GSH Reallocations.
  2. The Upload Reallocation interface displays, click Download Template.
  1. On the File Download interface, click Open or Save.
  1. Enter your data in the spreadsheet according to the format in CSV file format.
  1. Save your file (for help Filename format) and follow the instructions for Uploading the CSV file.

Uploading the CSV file

  1. Click Create Reallocation. For help accessing GSH Reallocations, see Access GSH Reallocations.
  2. In the top right-hand corner, click Upload.

  1. The Upload Reallocation interface displays, click Browse.

  1. In the Choose File to Upload dialog box, locate the file you created on your computer and click Open.
  1. The upload button becomes active, click Upload to validate the file.
  2. If your file does not pass validation, the errors display on the screen. Correct any errors and click Upload again.

  1. The Create a Reallocation by Upload interface displays with data from your file uploaded to the reallocation form. Check your entries and make any required changes.
  2. Click the check box to confirm the existence of an underlying contract underpinning the reallocation.
  1. The submit button becomes active, click Submit.

    3. Once a reallocation is submitted it cannot be modified by the submitter, but it can be cancelled before authorisation, Cancelling or Reversing.

  3. A Reallocation Confirmation report is issued to both the submitter and the counterparty.