Can you explain how you would troubleshoot a data discrepancy between Socure’s API and a client’s internal records?
Use the provided Socure API result and client record tables to identify records whose latest completed API decision differs from the client’s internal decision, including records present on only one side.
client_id, record_id, api_decision, internal_decision, api_received_at, internal_updated_at, and discrepancy_type.client_id ascending.| Column | Type | Description |
|---|---|---|
| request_idPK | VARCHAR(20) | Unique Socure API request identifier |
| client_id | VARCHAR(20) | Client record identifier supplied to Socure |
| decision | VARCHAR(20) | Decision returned by the Socure API |
| api_status | VARCHAR(20) | Processing status of the API request |
| received_at | TIMESTAMPTZ | Time the API result was received |
| Column | Type | Description |
|---|---|---|
| record_idPK | VARCHAR(20) | Client system record identifier |
| client_id | VARCHAR(20) | Identifier used to reconcile with Socure |
| internal_decision | VARCHAR(20) | Decision stored in the client system |
| updated_at | TIMESTAMPTZ | Time the client record was last updated |