RegaDB

REPORTER:
Fossie (approved by Paul)

SUMMARY:
This feature request is for a new automated backend job to import ConventieIALallePat data into RegaDB. The field mapping is attached. I suggest you create a folder and cron job setup like we have now for the LIS imports so that I (or other data management people) can post the data when it's ready for import. It should run before the LIS data runs.

NOTE:
There is a query in KWS called "ConventieIALallePat" that lists all patients with HIV+ve diagnosis in the "problem list" in KWS. This includes adults and kids, ative and LTFU. The query is a convenient way to update RegaDB because:
1. It can be extracted as often as needed. It can be extracted once a week for example, and imported into RegaDB before the LIS imports. Any new patients will be added to the database before the LIS export runs meaning that there will be less "patient not found" errors.
2. There are other useful fields that are currently added manually such as EMD, date of diagnosis and patcode. Importing electronically will save time and more importantly, improve data quality.