eHealth PHS

Issues noted that
Data type mis match in UAT1 for ph_family_survey table colum last_chg_time(time) is different in UAT2 (last_chg_time(character varying)).informed to ehealth

Communicated to eHealth

Regarding sync issue in family survey data

The log report from UAT1 application server showed a DataType mismatch error for ph_family_survey and a script comparison of UAT1 and UAT2 database showed that
the field last_chg_time of ph_family_survey has a data type of time without time zone in UAT1 and varchar in UAT2.
Please correct for this mismatch in UAT1 to proceed with upload synching of family survey data.

Regarding sync issue in device log data

The logs from device before user’s app login was inserting values 0 for User ID and Institution ID. The foreign key constraint set on ph_device_log prevented data insertion for these fields.
This is now handled using NULL values for User ID and Institution ID. The modified database function is committed in git. Please update the DB function in UAT1.