POL00069730
POL00069730
Cash Declaration info re Marine Drive
Ref: _d:\gij\pathway\messagestores\68 1 8.marine drive\marine drive\cashdeclarationkey.doc
Author: Gareth I Jenkins
Date: 13/11/2006 15:08:00
1. Introduction
We have been asked to provide details of Cash Declarations at Marine Drive Post
Office between 12" March and 2" April 2004 inclusive.
This note explains the process followed and describes the way the information is
presented in a separate spreadsheet.
2. Process Followed
All messages from Marine Drive (FAD 213337) for the required period were
extracted from the Audit archive by the Security team in the normal way and the raw
transaction data put onto a CD.
I then loaded the data into Excel and noted there were 59,852 items in the log file for
that period.
I then selected all items associated with Declarations (where there was an attribute of
“<DrawerltemDeclarationId:>” present in the log) together with the Overnight Cash
on hand summaries (Objects whose Collection name started with “ONCH).
From these I then manually removed those items associated with Stock declarations.
This resulted in 593 entries remaining which are presented in the spreadsheet.
3. Background information on Declarations
In 2004 there were two separate types of Cash Declaration:
= ONCH (Overnight Cash on Hand)
= Cash Declaration
In both cases the Cash is declared by denomination and the total value recorded.
ONCH declarations should be done each day and the Cash Declarations should be
done before Balancing the Branch.
In addition information from the ONVCH declarations is picked up and passed to the
Central Cash Planning system in SAP ADS and the details of what was passed have
been extracted.
4. Spreadsheet Information
There are two sheets in the spreadsheet:
= Cash Declarations
= SAP ADS feed
c:\documents and settings\njm!\local settings\temporary internet files\olk6f\cashdeclarationkey.doc Printed at
17:22:41 on 28/12/2006 Page 1 of 2
They are described
41
in the following sections.
Cash Declarations
This has the following columns:
Column Heading
Counter
Date
Time
Declaration Id
Prod Name
Value
Today's ONCH Value
Decl Value
Type
Cumulative
Check
Meaning ee bas
Counter number that recorded the information
Date recorded
Time recorded
Declaration Id used in the Declaration
Denomination of Cash
Value declared
Total of the declaration for an ONCH
Declaration
Total of Declaration for a Cash Declaration
Type of Item
Cumulative total of denominations
Confirmation that the cumulative total matches
the ONCH or Decl total
POL00069730
POL00069730
Notes
Seems to have been 11
until 22° March and 01
from 23" March onwards
Values of:
ONCH
Decl
Item
Always OK!
Note that on some days multiple declarations were made. I’ve marked all but the last
one in red.
4.2 SAP ADS feed
This has the following columns:
Column Heading
<Id:
<Num:
<Date:
<Time:
<IncompleteONCH:
<LastONCHDate:
<LastONCHTime:
Total Value
Meaning ee oes
Counter number that recorded the information
Message number
Date recorded
Time recorded
Indicate whether ONCH was incomplete
Date of last declaration
Time of last declaration
Total Value of declaration
Notes
Always “N” which means
it was always completed
I've checked that this
does always match the
last declaration for the
day
c:\documents and settings\njm\local settings\temporary internet files\olk6f\cashdeclarationkey.doc
17:22:41 on 28/12/2006
Page 2 of 2
Printed at