Duplicate Entries in the PROPERTY_LETTINGS_WON_INSTRUCTIONS Table

[Jejin]

Two entries in the PROPERTY_LETTINGS_WON_INSTRUCTIONS Table for the same transaction. Both the entries have the values but a unique ID.

19f7839ce3cf716750e4619ed462b542 095be0f908ba5b21e6eeb10d824d505a

Is this an issue with the data load and will be sorted in the next refresh ?

Thanks Jejin

[plittlewood-rpt]

Hi @Jejin this is because the property status changed in this manner as you can see from the property journal (see below). It was a deliberate decision to NOT de-duplicate the data in the analytics schema so that it remained consistent with the data in AgencyCloud, but I can see why this might be seen as problematic. I'll keep this ticket open so we can discuss the possibility of deduplication in some tables, including this one.

[Jejin]

Thank you for your prompt response and explanation. Are you suggesting that both the transactions are maintained as it happened within the same minute ? For other records in the table only the last instruction transaction is maintained.

[plittlewood-rpt]

Can you give me an example of where you are seeing that only the last instruction transaction is maintained? Happy to have a look to confirm :) thanks

[github-actions[bot]]

We have recently requested additional information relating to the issue you have raised. Please can you take the time to review this ticket and where applicable, provide the information requested. For more information on our processes, please click here

[HollyJoyPhillips]

Hi @Jejin, are you happy for us to close this ticket or can you provide an example as request in the above comment please?