purecode.co.uk

2> Heteregenous Search Interface

A NHS primary/secondary care web application suite required the ability to locate and maintain the identity of patients across multiple systems. This generic search object was developed using Visual Basic with the ability to plug into multiple database and non-database sources and cross-match results and propogate additions and updates.

• search based on partial name, date of birth, multiple reference code standards
• extensible collection of demographic and episodic data
• collation of results and identification of duplicate records based on incomplete data
• intelligent result caching
• batch and on-demand propogation of new patients and record updates
• implemented interface to remote SQL Server systems, CaMIS PAS system
• specified interface to BASO breast cancer systems, SCOPE system, FHS GP systems

• ASP with JScript and VBScript
• Visual Basic and XML
• Microsoft SQL Server, T-SQL Stored Procedures
• Microsoft COM with Transaction Server
• Microsoft OLE-DB and ODBC