Rt I68 Recon Var Profile Alloc

Record Format Document

RT_I68_RECON_VAR_PROFILE_ALLOC

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: / 3.1A
Status: / Approved
Date: / 09-Jul-2015

Version Control

Version / COR / Issue Date / Implementation Date / Summary of Change
2L / Current Live Version
3FA / 1154 / 30-Sep-2014 / 1-Oct-2015 / File issued for representation
EUC_IDENTIFIER renamed to END_USER_CATEGORY
CUM_DAILY_ALLOC_SHR_VOL_FACTOR, length 16, decimal 15
CUM_DAILY_ALLOCATED_ENERGY_FACTOR, length 16, decimal 15
CUM_DAILY_ALLOC_SHR_ENRGY_FACTOR, length 16, decimal 15
3A / 1154 / 12-Dec-2014 / 1-Oct-2015 / Approved
3.1FA / 1154 / 09-Jun-2015 / TBC / File issued for representation
CUM_GAS_VARIANCE length extended to 18
TOTAL amended
3.1A / 1154 / 09-Jul-2015 / Project Nexus Implementation Date / Approved

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 / A code identifying the type of information that this record represents CONTEXT: I68
LDZ_IDENTIFIER / M / T / 4 / 0 / This field identifies the LDZ to which the supply meter point is associated
EUC_DESCRIPTION / O / T / 12 / 0 / Acronym for the makeup of an End User Category (EUC). EUC's categorize end users in terms of their LDZ, AQ lower limit, AQ upper limit, meter read frequency, BGIC code, winter start, and end month and the ratio of upper and lower limit.
EUC_IDENTIFIER
END_USER_CATEGORY / M / N / 10 / 0 / A unique reference for the End User Category. This is auditable value which was output to the shipper on the Offer details and may be different to that used on Confirmation and Transfer of Ownership.
PRODUCTION_DATE / M / D / 8 / 0 / The Date on which the Reconciliation Factor applies
FORMAT:'YYYYMMDD'
CUM_GAS_VARIANCE_PRICE / O / N / 18
16
10 / 157 / Multiply the daily Energy Factor by the daily Gas Variance Price and then add the previous day's total to obtain a cumulative Gas Variance Price.
CUM_DAILY_ALLOC_SHR_VOL_FACTOR / O / N / 1016 / 715 / A factor calculated by dividing the Daily Allocated Shrinkage Energy Factor by the Calorific value for the LDZ and adding to the previous day’s volume factor. This factor is then used by the Reconciliation Process.
CUM_DAILY_ALLOCATED_ENERGY_FACTOR / O / N / 1016 / 715 / A factor calculated by dividing the daily allocated quantity for the LDZ/EUC by the sum of the AQ's for the LDZ/EUC and adding to the previous days total to create a cumulative factor. This factor is then used in the Reconciliation process.
CUM_DAILY_ALLOC_SHR_ENRGY_FACTOR / O / N / 1016 / 715 / A factor calculated by dividing the daily allocated quantity for the LDZ/EUC by the sum of the AQ's for the LDZ/EUC, accounting for Shrinkage % for the LDZ and adding to the previous days total to create a cumulative factor. This factor is then used in the Reconciliation process.
Total / 103
95
71

RT_I68_RECON_VAR_PROFILE_ALLOCPage 1 of 4Issue Date: 09/07/2015

Version:3.1AImplementation Date: Project Nexus Implementation Date