Pending Approval

Owned by Soham Ghosh (Unlicensed)
Last updated: Feb 12, 2015
2 min read

Pending Approval Mapping CF

CREATE TABLE IF NOT EXISTS pending_approval_mapping (
 catchment_id varchar,
 last_updated timeuuid,
 health_id varchar,
 PRIMARY KEY (catchment_id, last_updated)
)WITH CLUSTERING ORDER BY (last_updated ASC);
CREATE INDEX idx_pending_approval_mapping_health_id on pending_approval_mapping(health_id);

Search All Pending Approvals by Catchment

  • health_ids and last_updated timeuuids are selected from pending_approval_mapping CF for a given catchment and gte timeuuid. The results are ordered by last_updates asc.
  • For each health_id, patient CF is queried for given_name and surname. 
  • Sample JSON response: 

{
   "hid": "5958385569250672641",
   "given_name": "Sony",
   "sur_name": "Bazzardo",
   "last_updated": "b385af50-a225-11e4-97c2-5fcb9978cb86"
}

Search by HID

  • Pending approvals for a particular patient is stored in the patient CF. When pending approval for a particular patient (by HID) is queried, the result is served from patient CF.
  • The field is 'pending_approvals.' The pending approvals are stored as a JSON string. Class PendingApproval is used to serialize/deserialize the JSON. Updates are grouped by fields.
  • The pending approvals are ordered by field name (lexicographically), then timeuuid in desc order. For each update the timeuuid is captured. See 'field_details' in the JSON below.
  • TODO: Spike user defined types in Cassandra
  • Sample JSON response:

{
   "field_name": "gender",
   "current_value": "M",
   "field_details": {
      "9b450750-b28e-11e4-a7a6-5fcb9978cb86": {
         "value": "O",
         "facility_id": "10000059",
         "created_at": "2015-02-12T08:10:28.805Z"
   },
      "98bc87b0-b28e-11e4-a7a6-5fcb9978cb86": {
         "value": "F",
         "facility_id": "10000059",
         "created_at": "2015-02-12T08:10:24.555Z"
   }

}

Update Fields Marked for Approval

  • When a particular patient field that is marked for approval is updated, patient CF and pending_approval_mapping CF are updated.
  • patient CF - new field details added to the pending_approvals JSON.
  • pending_approval_mapping CF - 
    • Search by health_id (secondary index) and delete the records. 
    • Create new records for each possible catchment (see explanation below). last_updated is set as the latest timeuuid of the pending_approvals in patient CF.
    • Possible catchments - If catchment is 10203040, the possible catchments are 1020, 102030, 10203040. Catchments should have always division and district.
  • All queries run in a batch.

Approve Request

  • The field(s) is updated in patient CF.
  • When a field that is pending for approval is approved, all the updates for that field are removed from the pending_approvals in patient CF. 
  • If there is no other pending_approvals in the patient CF, all pending_approval_mapping CF records for that health_id is deleted.
  • Else, pending_approval_mapping CF  is updated as mentioned above.
  • All queries run in a batch.

Reject Request

  • The field(s) is NOT updated in patient CF.
  • When a field that is pending for approval is rejected, only that particular updates for that field is removed from the pending_approvals in patient CF. 
  • If there is no other pending_approvals in the patient CF, all pending_approval_mapping CF records for that health_id is deleted.
  • Else, pending_approval_mapping CF  is updated as mentioned above.
  • All queries run in a batch.

Â