Data Mismatch between Provider Table Primary Key Value ProvNum and ProcedureLog Table for ProvNum
Posted: Fri Dec 08, 2023 7:28 am
Hi Team,
Recently, while trying to access the data via API, we came across a data issue related to Procedure log. We discovered that the primary key value ‘ProvNum’ in the ‘Provider’ table does not match the ‘ProvNum’ in ‘ProcedureLog’ table.
All these records in the ‘ProcedureLog’ table are having ‘ProvNum’ as 0 which do not corresponds to a valid entry in Provider table (i.e., a provider entry with ProvNum 0). Also all these records have proc status as 6 which means deleted. Is there any such use case in Open Dental where deleted Procedures can have ProvNum as 0?
Can you please let us know the root cause of this?
Recently, while trying to access the data via API, we came across a data issue related to Procedure log. We discovered that the primary key value ‘ProvNum’ in the ‘Provider’ table does not match the ‘ProvNum’ in ‘ProcedureLog’ table.
All these records in the ‘ProcedureLog’ table are having ‘ProvNum’ as 0 which do not corresponds to a valid entry in Provider table (i.e., a provider entry with ProvNum 0). Also all these records have proc status as 6 which means deleted. Is there any such use case in Open Dental where deleted Procedures can have ProvNum as 0?
Can you please let us know the root cause of this?