ETL not showing updated Zscores

[mahalakshme]

Related ticket: https://avni.freshdesk.com/a/tickets/3216

Issue:

As part of release 6.1.0 , migration for this card was run. Though observations in program_encounter table show the updated values, but ETL tables doesn't show updated values. From this report, last ETL run for the org in focus also seems to be successful.
Migration run: avniproject/avni-product#1463 (comment)

Example:

• On doing the following,

select * from jss.individual_phulwari_growth_monitoring where individual_id=1299188 order by id desc;

you will find that the 'Weight for age z-score' is -8.5 for the first encounter visit in ETL table which is the old incorrect value.

• If you check in the corresponding program encounter observation it is correctly updated as -6.71

[1t5j0y]

Issue suspected to be due to ETL for the org running while the updates were in progress (and moving etl sync status for the table after the updated time).

Recreated ETL schema for the affected org and values seem to be in sync.

Updated manual db update guide to reflect this learning.