INT282 - Imbalance Allocation
|
Trigger type |
Time triggered |
|
Published |
Daily at 08:00 |
|
Audience |
Market participants |
|
Output file name |
int282_v[n]_imbalance_allocation_[p]~yyyymmddhhmmss.csv |
Report purpose
This report is to provide each Market participant's settlement exposure to the wholesale imbalance, by returning the imbalance allocation specific to each Market participant for each schedule in the gas day.
Participants may wish to use this report to determine if they have over or under injected each day in order to take into account costing given the market price.
Note as the imbalance is based on scheduled amounts the value accumulated in this report will not change at settlement.
Audience notes
The report is produced one business day after the gas day and accumulates daily data over a rolling one-month period.
This report does not include settlement ID as it remains unchanged from the point it is calculated (D+1) to its use in settlements.
Content notes
This report should contain at least one month's worth of data.
Each report contains the:
-
participant organisation identifier
-
gas date
-
hourly time interval (where 1 refers to 6:00 AM to 7:00 AM interval, 2 is the 7:00 AM to 8:00 AM interval and so forth. So a gas day would contain 24 different hourly time intervals)
-
schedule number which indicates the schedule horizon where the imbalance had occurred (for example, schedule1 will refer to 6:00 AM to 6:00 AM and schedule2 will relate to 10:00 AM to 6:00 AM, and so forth)
-
imbalance injection in gigajoule
-
imbalance withdrawal in gigajoule
-
imbalance injection amount (excluding GST)
-
imbalance withdrawal amount (excluding GST)
-
market price (excluding GST)
-
date and time when the report was produced
Data content
|
Name |
Data Type |
No Nulls |
Primary Key |
CQ |
Comments |
|---|---|---|---|---|---|
|
company_id |
integer |
True |
True |
N |
Id number of Market participant |
|
gas_date |
datetime |
True |
True |
N |
Gas day in which the imbalance occurs (e.g. 30 Jun 2007 06:00:00) |
|
ti |
integer |
True |
True |
N |
Time interval (hour 1-24) |
|
schedule_no |
integer |
True |
True |
N |
1-5 indicating which schedule interval in which the imbalance occurred |
|
imb_inj_gj |
numeric(18,9) |
True |
False |
N |
|
|
imb_wdl_gj |
numeric(18,9) |
True |
False |
N |
|
|
imb_inj_amt_gst_ex |
numeric(15,4) |
True |
False |
N |
|
|
imb_wdl_amt_gst_ex |
numeric(15,4) |
True |
False |
N |
|
|
market_price_gst_ex |
numeric(15,4) |
True |
False |
N |
|
|
current_date |
varchar 20 |
True |
False |
N |
Date and Time report produced (e.g. 29 Jun 2007 01:23:45) |