# Officers (Prod195/198) Snapshot Missing Records?

**URL:** <http://forum.companieshouse.gov.uk/t/officers-prod195-198-snapshot-missing-records/13042>\
**Category:** Data Issues\
**Created:** [September 30, 2026, 1:50pm UTC](http://forum.companieshouse.gov.uk/t/officers-prod195-198-snapshot-missing-records/13042 "2026-09-30T13:50:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dawn.barnaby](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/d/f08c70/32.png) [@dawn.barnaby](http://forum.companieshouse.gov.uk/u/dawn.barnaby)\
**Post date:** [September 30, 2026, 1:50pm UTC](http://forum.companieshouse.gov.uk/t/officers-prod195-198-snapshot-missing-records/13042/1 "2026-09-30T13:50:49Z")

</div>

I have recently ingested the latest snapshot file (26Sept) and the first update file uploaded after this (29Sept). The update file has 19,550 records, of which 228 I cannot work out how they should be applied. These are all records that don’t have a match to the snapshot file (on company number, old person number and old appointment type), but don’t come under the “New Appointment”, “Nominee” or “Errored Appointment” criteria.

Here’s examples of 5 such records in the Update file:

| **company\_number** | **record\_type** | **app\_date\_origin** | **res\_date\_origin** | **correction\_indicator** | **corporate\_indicator** | **old\_appointment\_type** | **new\_appointment\_type** | **old\_person\_number** | **new\_person\_number** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 16634966 | 2 | 1 | 1 | | | Current Director | Resigned Director | 352842000000 | 352842000000 |
| 07810403 | 2 | 3 | 1 | | | Current Director | Resigned Director | 78605050007 | 78605050005 |
| 09746498 | 2 | 1 | 1 | Y | | Resigned Secretary | Resigned Secretary | 212277000000 | 212277000000 |
| 13595639 | 2 | 3 | 1 | | | Current Director | Resigned Director | 286799000000 | 286799000000 |
| 17108540 | 2 | 3 | | Y | | Resigned Secretary | Current Secretary | 346650000000 | 346650000000 |
