Record Format Document

RT_M93_DOMESTIC_PORTFOLIO_RECORD

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: / Xoserve
Owner: / Xoserve
Version: / 2
Status: / For Approval
Date: / 30-Sep-2014

Version Control

Version / COR / Issue Date / Implementation Date / Summary of Change
1 / Current Live Version
0.1 / 1154 / 01-Aug-2014 / 1-Oct-2015 / Preliminary file issued for representation
MPO_REFERENCE renamed to SUPPLY_METER_POINT length 10
INCODE renamed to POSTCODE_INCODE
OUTCODE renamed to POSTCODE_OUTCODE
CNF_REFERENCE_NUM renamed to SUPPLY_POINT_CONFIRMATION_REFERENCE length 10
SERIAL_NUMBER renamed to METER_SERIAL_NUMBER
METER_AQ renamed to SUPPLY_METER_POINT_AQ
METER_POINT_AQ_FORMULA_YEAR new field
2 / 1154 / 30-Sep-2014 / 1-Oct-2015 / File issued for representation

Notes

Note 1
OPT - 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 / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying thetype of request that this recordrepresents.VALUE : M93
SUPPLY_METER_POINTMPO_REFERENCE / M / N / 1015 / 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..DEFINITION: This relates to the uniquereference number for a point where a meter issituated,or has been or will beconnected to the gas network.
POSTCODE_OUTCODEINCODE / M / T / 4 / 0 / Standard PAF outcode as defined in the PAF digest.DEFINITION: This records the standard PAF outcode (the first part of the postcode, eg. PE13).
POSTCODE_INCODEOUTCODE / M / T / 4 / 0 / Standard PAF incode as defined in the PAF digest.DEFINITION: This holds the standard PAF incode (the second part of the postcode,eg. 2EW).
SUPPLY_POINT_CONFIRMATION_REFERENCECNF_REFERENCE_NUM / M / N / 1015 / 00 / A sequential number that uniquely identifies the Confirmation.DEFINITION: This records a sequentialnumber to uniquely identify aspecfic confirmation.This number is allocated when the confirmation is created, whether rejected or accepted.
LDZ_IDENTIFIER / M / T / 4 / 0 / This field identifies the LDZ to which the Supply Meter Point is associated. DEFINITION: This holds a uniquereference code for the Local Distribution Zone (LDZ).
METER_SERIAL_NUMBERSERIAL_ NUMBER / M / T / 14 / 0 / The manufacturers meter serial number. DEFINITION: This holds the manufacturers meter serial number including all embedded spaces and alphabetic characters.
SUPPLY_METER_POINT_AQMETER_AQ / M / N / 15 / 0 / This field identifies the total Annual Quantity associated with the Supply Meter Point.DEFINITION: This holds a field related to the value of the Annual Quantity for a given date.
PORTFOLIO_EFFECTIVE_DATE / M / D / 8 / 0 / .DEFINITION: Portfolio effective date. Format YYYYMMDD.
FORMULA YEAR SMP AQ / O / N / 15 / 0 / The Supply Meter Point AQ that is fixed throughout the formula year for determination of Transportation rates.
Total / 87 82

RT_M93_DOMESTIC_PORTFOLIO_RECORDPage 1 of 4Issue Date: 30-Sep-2014

Version: 2 For ApprovalImplementationDate: 1-Oct-2015