INT251 - Allocation Agent Publish Metering Data
|
Trigger type |
Event triggered |
|
Published |
Receipt of Allocation Agent Data |
|
Audience |
Allocation Agent and Sub Allocation Agent |
|
Output file name |
int251_v[n]_alloc_agent_data_[p]~yyyymmddhhmmss.csv |
Report purpose
Contains current metering data by Injection and Withdrawal MIRN Meter Identification Reference Number. A unique number that identifies each gas meter..
This report is only for specified Allocation Agent Meters .
This is a Participant specific Report A data report that loads into a data model table. Identified by its type, subtype, and version. For example: BILLING,BILLINGASPAYMENTS,2 , produced on validation of CTM data. The date range contained within the report will reflect the latest reading dates process as part of D+3 energy processing
(i.e. the file will contain energy from the 1st of the (d-3) month to d-3 for Daily processing, and a complete month for Preliminary, Final or Revision processing).
Audience notes
Content notes
Data content
|
Name |
Data Type |
No Nulls |
Primary Key |
CQ |
Comments |
|---|---|---|---|---|---|
|
mirn |
varchar 10 . |
True |
True |
N |
|
|
gas_date |
varchar 20 . |
True |
True |
N |
Gas day being reported e.g. 30 Jun 2007 |
|
ti |
integer |
True |
True |
N |
Time Interval (1-24) where 1 is 6:00 AM |
|
energy_gj |
numeric 18.9 |
True |
False |
N |
hourly energy (Gj) |
|
uafg_adj_energy_gj |
numeric 18.9 |
True |
False |
N |
UAFG adjusted Hourly energy (Gj) |
|
quality_desc |
char 1 |
False |
False |
N |
Gas Meter Data Quality Flags are detailed in Section 6.8 |
|
validation_id |
integer. |
True |
False |
N |
The id of the validation run |
|
version_id |
integer. |
True |
False |
N |
The id of the version. Versions may be validated more than once |
|
extract_type |
char(1) |
True |
False |
N |
The extract type of the source data N = Normal or D+2 data |
|
current_date |
varchar 20 . |
True |
False |
N |
Date and Time Report Produced (e.g. 30 Jun 2007 01:23:45) |