I filter userEditHistory data by the "personSybType" field having the "ClientContact" value and the userEditHistoryFieldChanges by the "columnName" being equal to "status". Retrieving the latest (by dateEffective) status change from history does not coincide with the status field in the ClientContact itself for some contacts.
As a bit of context - out of about 50000 ClientContacts, I have 2817 that have these rather weird status mismatches.
How do I deal with this inconsistency of statuses?
Most probably a related issue - some ClientContacts have no history at all. Is it safe to assume that the event of creating a ClientContact is not reflected in the history tables?