Record Format Document
RT_P17_TRANSPORTER_ASSET_PORTFOLIO
Copyright Xoserve 2014©, all rights reserved.
No part of this publication may be reproduced in any material form (including photocopying and restoring in any medium or electronic means and whether or not transiently or incidentally) without the written permission of Xoserve except in accordance with the provisions of the Copyright, Designs and Patents Act 1998.
Author: / XoserveOwner: / Xoserve
Version: / 3
Status: / For Approval
Date: / 30-Sep-2014
Version Control
Version / COR / Issue Date / Implementation Date / Summary of Change2 / Current Live Version
3 / 1154 / 30-Sep-2014 / 01-Oct-2015 / File issued for representation
Notes
Note 1OPT - Optional/Mandatory (O - Optional, M - Mandatory)
DOM - Domain (T - text, N - Numeric, D - Date (YYYYMMDD), M - Timestamp)
LNG - Number of characters
DEC - Number of decimal places
Note 2
All text fields will be enclosed in double quotes ("")
Record Type Definition
RECORD/FIELD NAME / OPT / DOM / LNG / DEC / DESCRIPTIONTRANSACTION_TYPE / M / T / 3 / 0 / Code to identify the type of request that the record represents. VALUE: P17
SUPPLY_METER_POINT METER_POINT_REFERENCE / M / N / 10 / 0 / A unique identifier for the point at which a meter is, has been or will be connected to the gas network. These references are less volatile than meter or service identifiers and do not change if the meter is replaced or the service is relayed to the same position. New Supply Meter Point References will only be created for new services or when a service is relayed to a different position.Unique identifier for a point at which a meter is, has been, or, will be connected to the gas network.
MAINS_PRESSURE_TYPE PRESSURE_TIER / O / T / 1 / 0 / Code to indicate Mains Pressure Type. The Transporterransco is unable to support provision of this information.
VALUES: L = Low; up to 75 mbar
M = Medium; 76 mbar - 2 bar
I = Intermediate; 2.1 bar - 7 bar H = High; 7.1 bar - 19 bar
S = Supergrid; 19.1 bar & above
U = Unknown
METER_INSTALLATION_DATE
INSTALLATION_DATE / M / D / 8 / 0 / Date on which meter was fitted. FORMAT: YYYYMMDD
GAS_ACT_OWNERGAS_ACT_METER_OWNERSHIP_TYPE / M / T / 1 / 0 / Unique code which identifies the role the market participant is acting in. Allowable values : T - GAO Transporter , S - GAO Supplier , C - GAO Consumer Code to indicate the Gas Act Owner of the Asset. VALUES: T - Transco Owned Meter, S - Supplier Owned Meter, C - Customer Owned Meter, U – Unknown.
METER_ASSET_MANAGERMAM_ABBREVIATED_NAME / M / T / 12 / 0 / The Short code for the MAM associated with the meter on the date of the portfolio extract. This will be populated with UNKNOWN if there is no current MAM recorded as on the date of the portfolio extract.Unique identifier used to describe the meter asset manager. DEFAULT: ‘UNKNOWN‘
PRODUCT_ID / O / T / 10 / 0 / The Market Domain Data (MDD) Forum identifies the Meter Models based on the Product Id. In order to store this information a new attribute PRODUCT_ID will be added to the METER_MODEL. The MDD Forum will provide this information. Market Domain Data Forum defined value to identify a set of assets with common attributes.
METER_TYPE / M / T / 1 / 0 / The type of meter. Code to determine the type of the meter. VALUES: D – Diaphragm of unknown material,
L – Leather Diaphragm,
R – Rotary,
S – Synthetic Diaphragm,
T – Turbine,
U – Ultrasonic,
Z – Unknown.
METER_CAPACITY / M / N / 10 / 4 / The amount of gas that can be passed through the meter in a given time period. This is the manufacturer's maximum value. ALLOWABLE VALUES: If the imperial indicator is set to Y, the capacity should be expressed in cubic feet per hour. If the imperial indicator is set to N, the capacity should be expressed in cubic metres per hour.The amount of gas that can be passed through the meter in a given time period.
METER_MODEL_NAME / M / T / 10 / 0 / The model description of the meter.Code to uniquely identify the meter model.E.g.: E6, U6.
IMPERIAL_METER_INDICATOR / M / T / 1 / 0 / Indicator identifying if the meter measures volume of gas consumed in metric or imperial units. Code to indicate whether the meter measures the volume of gas in imperial or metric units.
VALUES: Y - Imperial,
N – Metric.
METER_MANUFACTURER_CODE / M / T / 3 / 0 / Short code version of the meter manufacturer’s name. Identifies the Short code of meter manufacturer of the meter.
METER_MANUFACTURED_YEAR / M / N / 4 / 0 / The year in which the meter was manufactured expressed as a century date (e.g. 1981)Year of manufacture for the asset as stamped on the asset. FORMAT: YYYY.
METER_SERIAL_NUMBER / M / T / 14 / 0 / The manufacturers meter serial number. CONTEXT: The serial number of the meter from which the meter read was taken.The manufacturer's serial number including alphanumeric characters. E.g.:E6E12345678901.
DAILY_READ_EQUIPMENT_FITTEDDATALOGGER_FITTED / M / T / 1 / 0 / Code to indicate if a chargeable DM data logger is fitted. VALUES: Y – Chargeable DM Data logger Daily Read Equipment is fitted, N – Chargeable DM Data logger Daily Read Equipment is not fitted.
CONVERTER_FITTED / M / T / 1 / 0 / Code to indicate if a converter is fitted.VALUES: Y – Converter is fitted, N – Converter is not fitted.
Total / 90
91
RT_P17_TRANSCO_ASSET_PORTFOLIO1 of 7Issue Date: 30-Sep-2014
Version: 3 For ApprovalImplementationDate: 1-Oct-2015