EAC/AA Physical Design Technical Specification

258 Pages·2013·3.13 MB·English

EAC/AA Physical Design Technical
Specification

Version Number 17.100

© ELEXON Limited 2013
COMMERCIAL IN CONFIDENCE

EAC/AA Technical Specification Version 17.100

EAC/AA Technical Specification

Status : Draft

Version : 17.100
Date : 27 June 2013

Prepared by : Cognizant
Approved by (Cognizant) : Project Manager

© ELEXON Limited 2013 1
COMMERCIAL IN CONFIDENCE
EAC/AA Technical Specification Version 17.100

Table Of Contents
1 Introduction 5
1.1 Purpose ................................................................................................................ 5
1.2 Scope ................................................................................................................... 5
1.3 Structure of Document ........................................................................................ 5
1.4 Amendment History ............................................................................................ 6
1.5 Summary of Changes ........................................................................................... 9
1.6 Changes Forecast ............................................................................................. 109
1.7 References ..................................................................................................... 1110
1.8 Abbreviations ................................................................................................. 1211
1.9 Intellectual Property Rights and Copyright ................................................... 1311
2 High Level Design Specification ...................................................................................... 1412
2.1 System Overview ........................................................................................... 1412
2.2 System Architecture ...................................................................................... 1613
2.3 System Structure ........................................................................................... 1916
2.4 Subsystem Description .................................................................................. 2218
2.5 Main Control Flows ........................................................................................ 2521
2.6 User Interface Overview ................................................................................ 2521
2.7 Database Overview ........................................................................................ 3228
2.8 Fallback, Backup and Recovery ...................................................................... 3228
2.9 Error Handling ................................................................................................ 3531
2.10 Security .......................................................................................................... 3632
2.11 Operational Design ........................................................................................ 3834
3 Interface Specification ................................................................................................... 4036
3.1 External Interfaces ......................................................................................... 4036
3.2 Internal Interfaces ......................................................................................... 6154
4 Database Specification .................................................................................................. 6860
4.1 General .......................................................................................................... 6860
4.2 Files ................................................................................................................ 6860
4.3 Online Database ............................................................................................ 6961
4.4 Audit Log ........................................................................................................ 9984
4.5 Archive ........................................................................................................... 9985
4.6 Database Sizing ............................................................................................ 10085
5 Subsystem EPD Specifications ....................................................................................... 10186
5.1 Introduction ................................................................................................. 10186
5.2 Subsystem Context ...................................................................................... 10186
5.3 Subsystem Processing .................................................................................. 10489
5.4 Data Usage ................................................................................................... 10590
5.5 Procedure Details ........................................................................................ 10791

© ELEXON Limited 2013 2

COMMERCIAL IN CONFIDENCE
EAC/AA Technical Specification Version 17.100

6 Subsystem ECP Specifications ..................................................................................... 133115
6.1 Introduction ............................................................................................... 133115
6.2 Subsystem Context .................................................................................... 133115
6.3 User Interface ............................................................................................ 133115
6.4 Subsystem Processing ............................................................................... 135117
6.5 Data Usage ................................................................................................ 136118
6.6 Procedure Details ...................................................................................... 137118
7 Subsystem ESC Specifications ..................................................................................... 164143
7.1 Introduction ............................................................................................... 164143
7.2 Subsystem Context .................................................................................... 164143
7.3 Subsystem Processing ............................................................................... 166145
7.4 Data usage ................................................................................................. 166145
7.5 Procedure Details ...................................................................................... 167146
8 Subsystem EFR Specification ...................................................................................... 170149
8.1 Introduction ............................................................................................... 170149
8.2 Subsystem Context .................................................................................... 170149
8.3 Subsystem Processing ............................................................................... 171150
8.4 Data Usage ................................................................................................ 172151
8.5 Procedure Details ...................................................................................... 173151
9 Subsystem ESL Specifications ..................................................................................... 176155
9.1 Introduction ............................................................................................... 176155
9.2 Subsystem Context .................................................................................... 176155
9.3 Subsystem Processing ............................................................................... 177156
9.4 Data Usage ................................................................................................ 177156
9.5 Procedure Details ...................................................................................... 178157
10 Subsystem EAR Specifications .................................................................................... 182160
10.1 Introduction ............................................................................................... 182160
10.2 Subsystem Context .................................................................................... 182160
10.3 Subsystem processing ............................................................................... 184162
10.4 Data usage ................................................................................................. 185163
10.5 Procedure Details ...................................................................................... 186163
11 Technical Specification - Subsystem ERP Specification ................................................. 197173
11.1 Introduction ............................................................................................... 197173
11.2 Subsystem context .................................................................................... 197173
11.3 Subsystem processing ............................................................................... 199175
11.4 Data usage ................................................................................................. 199175
11.5 Procedure details ...................................................................................... 201177
12 Technical Specification - Subsystem EMC Specification................................................ 211186
12.1 Introduction ............................................................................................... 211186
12.2 Subsystem Context .................................................................................... 211186

© ELEXON Limited 2013 3
COMMERCIAL IN CONFIDENCE
EAC/AA Technical Specification Version 17.100

12.3 Subsystem Processing ................................................................................ 212187
12.4 Data Usage ................................................................................................. 213188
12.5 Procedure Details ...................................................................................... 214189
13 Technical Specification - Subsystem EUA Specification................................................. 232205
13.1 Introduction ............................................................................................... 232205
13.2 Subsystem Context .................................................................................... 232205
13.3 Subsystem Processing ................................................................................ 233206
13.4 Data Usage ................................................................................................. 233206
13.5 Procedure Details ...................................................................................... 234207
14 Cross References ........................................................................................................ 242214
14.1 Mapping From Logical Design .................................................................... 243215
14.2 Mapping From Requirements .................................................................... 250220
14.3 Usage of Data............................................................................................. 254223
Appendix A Naming Convention .................................................................................................... 258226

© ELEXON Limited 2013 4

COMMERCIAL IN CONFIDENCE
EAC/AA Technical Specification Version 17.100

1 Introduction
1.1 Purpose
This document [ETSPEC] describes the Physical Design for the EAC/AA system.
The content of this Physical Design is produced in accordance with the Physical Design
Technical Specification Product Description [PDTSPD]. It is derived from the requirements
described in the Estimation of Annual Consumption / Annualised Advance (EAC/AA) System
[EACAAURS], the EAC/AA Logical Design and where appropriate, from the data interfaces
described in Data Interfaces [DIS]. The TA2000 amendments are derived from the
requirements described in the Pool Change Management Circulars 1040 and 1076.
1.2 Scope
This document is the Physical Design stage deliverable for EAC/AA and will be used as the basis
for the physical implementation of the EAC/AA system.
It should be read in conjunction with the following documents:
 EAC/AA Logical Data Design [ELDATA] containing the following:
 the Logical Data Model, which provides a detailed logical
description of the data and its structure;
 the Data Catalogue, which describes the data items for the system.
 EAC/AA Conceptual Model [ECONMOD], containing Event Descriptions
which will be cross-referred to the Function Definitions;
 EAC/AA User Requirements Specification [EACAAURS] containing the
details of the Elementary Process Descriptions.
 Physical Design Technical Specification Product Description [PDTSPD].
 EAC/AA Function Definition and User Catalogue [EFUNDEF].
 Data Interfaces [DIS].
 The SVA November 05 BRS [NOV05BRS].
1.3 Structure of Document
 Section 2 high level design specifications based on the EAC/AA User
Requirements Specification [EACAAURS] and EAC/AA Function Definition
and User Catalogue [EFUNDEF].
 Section 3 contains the Interfaces to the EAC/AA system based on the Data
Interfaces [DIS] and the EAC/AA Function Definition and User Catalogue
[EFUNDEF].

© ELEXON Limited 2013 5
COMMERCIAL IN CONFIDENCE
EAC/AA Technical Specification Version 17.100

 Section 4 contains the description of the database based on the EAC/AA
Logical Data Design [ELDATA].
 Section 5 contains a specification of the EPD subsystem.
 Section 6 contains a specification of the ECP subsystem.
 Section 7 contains a specification of the ESC subsystem.
 Section 8 contains a specification of the EFR subsystem.
 Section 9 contains a specification of the ESL subsystem.
 Section 10 contains a specification of the EAR subsystem.
 Section 11 contains a specification of the ERP subsystem.
 Section 12 contains a specification of the EMC subsystem.
 Section 13 contains a specification of the EUA subsystem.
 Section 14 describes the cross references from the EAC/AA Logical Design
and the EAC/AA User Requirements Specification [EACAAURS] to the
EAC/AA Physical Design [ETSPEC].

1.4 Amendment History
Issue Details
0.900 Draft for internal review
0.901 Further draft for internal review
0.990 Draft for external review
1.000 Issue incorporating changes following external review
(EPL/LOG/168 dated 31/1/97) and the completion of
the Acceptance Procedures Period (APP).
1.100 Issue incorporating changes following the final FAT
and defect reports after the client’s integration tests.
The following ORs have been addressed in this issue.
5.1.215 (CLAR057)
5.1.271 (CLAR061)
5.1.298 (CLAR065)
5.1.299 (CLAR062)
5.1.315 (FAT)
5.1.323 (FAT)
5.1.326 (FAT)

© ELEXON Limited 2013 6

COMMERCIAL IN CONFIDENCE
EAC/AA Technical Specification Version 17.100

Issue Details
5.1.365 (FAT)
5.1.397 (CLAR071)
5.1.970 (Internal)
5.1.1218 (Defects 66 & 81)
5.1.1220 (Internal)
5.1.1693 (LCR048)
5.1.1816 (Defect 428)
5.1.2045 (Defect 2489)
2.000 Issue incorporating changes following external review
of v1.100
2.001 5.1.2217
5.1.2332 (Defect 1415)
5.1.2354 (LCR080)
5.1.2429 (Defect 1501)
Draft Issue consistent with software release R1.2
2.500 Incorporating Internal Review Comments. Draft issue
for external review consistent with software release
R1.2
2.901 Working version for R2 design. Will not be carried
forward into v4.000.
2.990 Working version for R2 design. Will not be carried
forward into v4.000.
3.000 Working version for R2 design. Will not be carried
forward into v4.000.
4.000 Authorised version consistent with software release
R1.3. Incorporating comments from Pool review of
v2.500. Includes OR 5.1.2445 (Logica Internal.)
4.901 Draft for internal review. Merge of v3.000 and
v4.000. Change bars show changes from v3.000.
4.990 Issued to Pool for review. Merge of v3.000 and
v4.000. Change bars show changes from v4.000.
5.000 Authorised Version. Merge of v3.000 and v4.000.
Change bars show changes from v4.000.
5.001 Draft version incorporating the following ORs:
OR2716, OR2723, OR2777
5.900 Draft for internal review incorporating TA2000
changes (SIR R391 / LCR105 & SIR R200 / LCR117).
Change bars show changes from v5.000. Also
incorporates OR2828.
5.901 Draft incorporates OR2834.
5.990 Draft for external review. Also incorporating OR2844.
5.991 Incorporating internal review comments.

© ELEXON Limited 2013 7
COMMERCIAL IN CONFIDENCE
EAC/AA Technical Specification Version 17.100

Issue Details
6.000 Authorised version.
6.001 Draft version incorporating the following ORs:
OR2869 (LCR138)
6.001 OR2894 - Files are processed when there are
additional fields
6.990 Issued to Pool for review.
7.000 Authorised version.
7.990 Incorporating LCR 160/3 (SIR 2296): Reasonableness
Checks for Annualised Advances.
7.991 Incorporating internal review comments.
7.992 Incorporating internal review comments.
OR3019 - PEEX_001 file format should have optional
EAC EFSD.
7.993 Incorporating LCR170/2 - Upgrade to Oracle 8i.
8.000 Authorised version.
8.001 Change to Office 2000
8.002 Changes relating to ELEXON superseding the
Electricity Pool
8.003 Draft incorporates OR3196.
8.990 Updated document references
Version for ELEXON review
8.991 Incorporating ELEXON review comments.
8.992 Incorporating ELEXON review comments.
9.000 Authorised version.
9.001 Incorporating LCR225 - Upgrade to Oracle 9i
9.990 Version for ELEXON review
9.991 Applied ELEXON review comments
10.000 Authorised version
10.001 Incorporating LCR218 - BETTA
Draft incorporating OR3386
10.002 Incorporating LCR223 EAC/AA Calculator Issues
10.990 Updated the Copyright Notice
Version for ELEXON review
10.991 Applied ELEXON review comments.
11.000 Made Definitive
12.000 Updated document references
12.001 Updated for November ’04 release

© ELEXON Limited 2013 8

COMMERCIAL IN CONFIDENCE