Create/Update

Create

• Following CFs are updated when patient is created. All the queries run in batch.

  • patient

  • search mappings tables - nid, brn, uid, phone_no, name+address

  • catchment mapping

Update

• Following CFs are updated, if required, when patient is udpated. All the queries run in batch.

  • patient

  • search mappings tables - nid, brn, uid, phone_no, name+address

  • pending_approval_mapping

  • patient_update_log

• Except for patient the only way to update the CF is to delete and create a new record. So the batch size increases.

Exec Order of Statements in Batch

• See this - https://sharedhealth.atlassian.net/browse/BSHR-554

• For now, it's only implemented for pending_approvals_mapping create/delete.