Identifying users who aren't actively entering data

[mahalakshme]

Requirement:

To figure out the users who have not entered the data for past 5 days.

AC:

• Have a ETL/integration service job to identify the users who meet all the following criteria:
  - Didn't enter/edit any registrations or encounters in the past 5 days
  - The number of days should be configurable easily
  - Should belong to 'Primary Users' user group
  - Should not consider users who have completed endline for all the work orders in their catchment
• Store the users identified above in some ETL/some table temporarily(Needed just for testability)

Technical suggestions:

• Option 1: integration service that executes custom query to figure out the users.
• Option 2: ETL bg job that uses ETL tables to figure out the users
• Option 3: ETL bg job that uses custom query to figure out the users

Approaches discarded because of complexity or suitability: Background job in Avni, Using Avni APIs, Dalgo

Independent of the approach followed, the same ETL and integration service should be usable in Avni as well without forking.

Out of scope:

Sending messages to such users using Glific.

Inputs:

• int., service access to ETL database?
• window to not send msg again - 1 day - run every 10 mins
• • report - to whom sent/failed message
• • job monitoring
• /executeQuery?
• add spike
• add 30 percent estimate