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 |