eHealth PHS

1. House survey upload completed.
2. Member survey upload completed.
3. need to change date format based on the uat server db.

Include upload_timestamp in all local DB tables.

For handling interruptions in survey data upload sync where unique IDs are generated at server, need a common identifier in both local mobile DB and PH PostgreSQL server. In the current scenario, in between connection drops/app closing may cause data to insert in PH server database but the status of record upload may not get reflected at local mobile database. This can cause duplicate data insertion in server in further data upload syncs from the app.

• Instead of creating new Identifier fields, Generate a transaction identifier from existing house/member survey date currently in date type need to change as datetime..
• Then convert survey date to unix timestamp of 10 digits. Append ashablock Ids(padding of 5 digits suggested) with a character code H for House survey & M for Member survey.eg : H195341693638729.
• Keep this transaction Ids in local db for reference if required.
• Create a new status for sync flag for identifying which is already processed for uploading. only that records might need to resync if any interrupt occurs.
• Search the transaction identifier with dynamically generating transaction ids for each server records only for this pending above records ,if exists, update the local db record matching with same. else create new records in server and update in local db same as normal workflow does.

On checking sample data uploaded in UAT db, following points were noted.
• entry flag in member survey need to update as N for other id types also other than aadhaar. this is for data verification purposes recommended by DBA.
• text array empty values currently saving as {} need to change to null.
• latitude and longitude saving negative values should be restricted.
• notional db field saving wrong format data is some cases