Cancel table not in sync with base table for UnCancel scenario

[vinayvenu]

https://avni.freshdesk.com/a/tickets/3163

There are scenarios where an encounter is cancelled by one user and filled in by another user. If the first user syncs, ETL creates a row in the _cancel table. When the second user syncs, the program_encounter row is overwritten, but the row in the _cancel table is not deleted.

Acceptance criteria

• When a cancelled encounter is uncancelled on the program_encounter or the encounter table, the corresponding row on the _cancel table is deleted.

[dinesh2096]

• The cancel table is not updated as per the requirement.

env : staging
org : dinesh@dashsix
Individual : Test din oct0101

Refer image :

encounter table :

Cancel Table :

[1t5j0y]

Fix was not deployed to staging. I have triggered deployment to staging now. Please retest.

[dinesh2096]

Pending or qwery:

do we have scope of the web app as well

completed :

QA References :

Click here to watch video

[1t5j0y]

Fix is at ETL level and not dependent on source of data so testing from client should be sufficient.