LensReading which lens this session carries.

The work elsewhere

What the source systems say we should have

20 comparisons have been set up between a count this platform can produce and the same count taken from the system that owns the records. 7 agree to the record, 7 differ for a reason somebody wrote down, 4 differ and nobody has explained why, and 2 have never run at all.

Every comparison, worst first

Platform count against the source system’s own total for the same measure over the same period.

DR-0010
Configuration Management Database
Unexplained
Configuration items
Thirteen thousand two hundred items are in the source and not here.
method: Item count against the configuration database’s own inventory. · monthly · J. Petrakis
platform 398,000 items
source 411,200 items
difference 13,200 (3.2%)
13,200 items unaccounted for
DR-0006
Configure, Price and Quote
Unexplained
Quotes issued
Six thousand three hundred quotes exist in the source and not here.
method: Quote count against the quoting tool’s own report. · weekly · A. Whitfield
platform 486,000 quotes
source 492,300 quotes
difference 6,300 (1.3%)
6,300 quotes unaccounted for
DR-0003
Source-to-Pay Suite
Unexplained
Purchase orders open
Four thousand one hundred are orders in a draft state the extract filters out.
method: Open order count against the supplier portal’s own dashboard. · weekly · K. Boateng
platform 812,000 orders
source 819,450 orders
difference 7,450 (0.9%)
3,350 orders unaccounted for
DR-0014
Treasury and Cash Management
Unexplained
Cash positions
Two thousand four hundred positions are in the source and not here.
method: Position count against the treasury system’s own daily statement. · weekly · L. Duarte
platform 96,000 positions
source 98,400 positions
difference 2,400 (2.4%)
2,400 positions unaccounted for
DR-0019
Bank Connectivity Gateway
Never run
Payment instructions
Both sides read zero because neither side has been read.
method: No check has ever run. The gateway is in a not-connected state and there is nothing on either side to compare. · never · L. Duarte
no counts on either side
connection not-connected
DR-0020
Research Notebook and Experiment Data
Never run
Experiment records
Both sides read zero because neither side has been read.
method: No check has ever run. The research notebook is in a not-connected state. · never · P. Iyer
no counts on either side
connection not-connected
DR-0002
Group ERP — Materials and Inventory
Explained
Movement documents
The whole difference is reversal documents, which the extract deliberately excludes and the source report includes.
method: Extract row count against the movements report for the same window. · weekly · R. Nakamura
platform 2,740,000 documents
source 2,748,120 documents
difference 8,120 (0.3%)
all 8,120 accounted for
DR-0004
Invoice Capture and AP Automation
Explained
Invoices captured
Duplicate captures that the tool counts twice and the platform de-duplicates on document number.
method: Captured invoice count against the capture tool’s own log. · weekly · M. Okonjo
platform 1,960,000 invoices
source 1,971,600 invoices
difference 11,600 (0.6%)
all 11,600 accounted for
DR-0008
Recruiting and Applicant Tracking
Explained
Applications in process
Withdrawn applications that the source keeps in the funnel and the platform closes.
method: Pipeline count against the recruiting tool’s own funnel report. · monthly · S. Bergqvist
platform 142,000 applications
source 144,800 applications
difference 2,800 (1.9%)
all 2,800 accounted for
DR-0009
IT Service Management
Explained
Tickets raised
Tickets raised and cancelled inside the same hour, which the extract drops.
method: Ticket count against the service management tool’s own report. · weekly · J. Petrakis
platform 1,240,000 tickets
source 1,243,700 tickets
difference 3,700 (0.3%)
all 3,700 accounted for
DR-0012
Document and Matter Management
Explained
Documents held
Versions of the same document, which the source counts separately and the platform folds together.
method: Document count against the document store’s own index. · monthly · V. Marchetti
platform 3,120,000 documents
source 3,134,400 documents
difference 14,400 (0.5%)
all 14,400 accounted for
DR-0016
Contact Center Platform
Explained
Contacts handled
Abandoned contacts, which the source counts as interactions and the platform does not.
method: Contact count against the contact center’s own interaction report. · weekly · T. Abara
platform 8,600,000 contacts
source 8,643,000 contacts
difference 43,000 (0.5%)
all 43,000 accounted for
DR-0018
Transportation Management
Explained
Shipments dispatched
Consolidated shipments that the source counts per leg and the platform counts once.
method: Shipment count against the transport system’s own dispatch report. · weekly · G. Mwangi
platform 640,000 shipments
source 646,400 shipments
difference 6,400 (1.0%)
all 6,400 accounted for
DR-0001
Group ERP — Financials
Agreed
Journal lines in the period
The two sides agree exactly, which is what a keyed full extract should produce.
method: Total row count returned by the extract compared against the system’s own period report. · weekly · D. Halvorsen
platform 4,180,000 lines
source 4,180,000 lines
difference 0 (0.0%)
counts match exactly
DR-0005
Customer Relationship Management
Agreed
Active accounts
Exact agreement on a simple keyed count.
method: Account count against the platform’s own account report. · weekly · A. Whitfield
platform 3,450,000 accounts
source 3,450,000 accounts
difference 0 (0.0%)
counts match exactly
DR-0007
Core HR and Payroll
Agreed
Employee records
Exact agreement, checked monthly because payroll is the anchor for several other figures.
method: Headcount extract against the payroll register. · monthly · S. Bergqvist
platform 268,000 records
source 268,000 records
difference 0 (0.0%)
counts match exactly
DR-0011
Contract Lifecycle Management
Agreed
Contracts active
Exact agreement.
method: Active contract count against the contract system’s own register. · monthly · V. Marchetti
platform 214,000 contracts
source 214,000 contracts
difference 0 (0.0%)
counts match exactly
DR-0013
Enterprise Data Warehouse
Agreed
Fact rows loaded
Exact agreement, checked daily because everything downstream depends on it.
method: Load counter against the warehouse’s own load log. · daily · N. Ferreira
platform 91,400,000 rows
source 91,400,000 rows
difference 0 (0.0%)
counts match exactly
DR-0015
Indirect Tax Engine
Agreed
Tax determinations
Exact agreement.
method: Determination count against the tax engine’s own log. · monthly · F. Aubert
platform 58,000 determinations
source 58,000 determinations
difference 0 (0.0%)
counts match exactly
DR-0017
Supply and Demand Planning
Agreed
Plan versions
Exact agreement.
method: Version count against the planning system’s own audit trail. · weekly · R. Nakamura
platform 3,300,000 versions
source 3,300,000 versions
difference 0 (0.0%)
counts match exactly

Systems with no comparison at all

These are not systems that agree.

Reporting Semantic Layer
bi-semantic
Marketing Automation
mkt-automation
Digital Analytics
web-analytics
Product Lifecycle Management
plm
Workforce Management
wfm
Planning and Consolidation
fpa
20 of 26 systems of record carry a comparison. The systems themselves

How often each one runs

Cadence is what was agreed with the system owner, not what a scheduler enforces.

weekly
11 comparisons · 55%
monthly
6 comparisons · 30%
never
2 comparisons · 10%
daily
1 comparison · 5%
The widest unexplained difference is DR-0010, Configuration items on Configuration Management Database: 13,200 items of difference that nobody has accounted for.

Actions

What is waiting on a person

A kernel that never checks itself against the world drifts and nobody notices until an auditor does.

7

differences explained and left in place

An explained difference is not a reconciled one.

6

source systems with no drift check at all

Reporting Semantic Layer · Marketing Automation · Digital Analytics · Product Lifecycle Management · Workforce Management · Planning and Consolidation.

4

checks where the difference has no explanation

25,250 records are unaccounted for across them, the largest being Configuration Management Database at 13,200 items.

2

checks that have never run

Bank Connectivity Gateway · Research Notebook and Experiment Data.

Operations

What this desk is allowed to start

A surface that only reports is not operable.

Trigger and bound

This surface compares a platform count against a source system’s own total on a stated cadence and publishes the difference.

Live observability

What the record shows right now

All 20 drift checks by outcome, 4 states in use, covering 20 of the 26 source systems in the estate.

Current distribution

20 checks

Agreed735%
Explained735%
Unexplained420%
Never run210%

Is policy and strategy coming to fruition

Whether the written intent is holding here

Yes on the checking. No on the closing.

Not holding on the record

The intent was that the platform compares itself against the outside and states the difference. 20 checks now run against 20 systems and every difference is published, including the 4 nobody can explain.

What this page is not

A drift check compares the platform count against the source system’s own total for the same measure.