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 -  BSHR-554 - Getting issue details... STATUS
• For now, it's only implemented for pending_approvals_mapping create/delete.