Schedule Reconciliation Problem

Project Description

We have challenges reconciling data related to Subject Visits.  It is difficult to aggregate this data accurately when values used to represent a Visit vary with sources.  We currently have 3 sources of visit data:

                Protocol Document

                EDC

                IRT

We are seeking a data scientist who can propose an AI technique that can be used to automate generating a concordance mapping between the systems?  It would need to detect similarities between the Names and with supporting actual dates data -  determine the mapping with high confidence.   Our efforts to manually manage this issue has never gotten any traction.

There is a business need to not only reconcile the naming, but to then be able to enhance the data with known values about the visit- Whas this a Dosing visit, Unplanned Visit, End of Study Visit, Payable Visit?