INT177 - ESV injection withdrawal report

Trigger type

Event triggered

Published

Issue of Final Settlements

Audience

Market participants

Output file name

int177_v[n]_esv_injection_withdrawal_[p]~yyyymmddhhmmss.csv

Report purpose

The Gas Safety Act 1997 section 29 outlines that gas companies are required to pay the Energy The unit must be a generator for the service type: ‘energy’. Loads cannot bid for mandatory restrictions capacity. Safe Victoria (ESV) a levy, over a schedule period. "Determination by Minister of for Energy Industries and Resources", Under Section 29 of the Gas Safety Act 1997, For the year 1 July 2004 to 30 June 2006. In relation to the Levy to Apply to Gas Companies. The report provides the injections and end-use withdrawals from the Gas Transmission System i.e DTS Declared Transmission System (Victoria). Victoria’s gas transmission system, operated by AEMO. and Non-DTS for Market participant, as defined under the Gas Industry Act by the gas retailers.Report A data report that loads into a data model table. Identified by its type, subtype, and version. For example: BILLING,BILLINGASPAYMENTS,2 will include billing mirn i.e DM and logical mirns

Audience notes

Participants specific data provided to the Energy Safe Victoria (ESV) in INT119 can be seen in this report.

Content notes

Data content

Name

Data Type

No Nulls

Primary Key

CQ

Comments

statement_version_id

integer

True

True

N

Unique settlement statement number

Month

varchar(8)

True

True

N

Derived from a gas date (currently 6:00 AM to 6:00 AM) not calendar date. Displayed as MMM-YYYY e.g. Aug-2009

network_name

varchar(40)

True

True

Description of the particular DTS/Non DTS Network

settlement_cat_type

varchar(3)

True

False

Settlement Type e.g. FNL (Final), REV(Revision), NA for Non DTS

company_id

integer

True

False

company id of individual organisation

Mirn

varchar(10)

True

False

N

Meter number

injection_withdrawal

char(1)

True

False

I for Injections/ W for Withdrawal

total_energy_gj

numeric(18,3)

True

False

N

Total injections for individual organisation

OR

Withdrawals for individual organisation
Excluded MIRNS: Exclusions are defined as withdrawals into LNG; Underground Storage and Exports from Victoria (Culcairn, SEAGas and VICHUB)

current_date

datetime

True

False

Current date the report was generated. Calendar datetime displayed as dd mmm yyyy hh:mm:ss