Open apratap opened 4 years ago
The following healthCodes need to be removed from every table including demographics. Maybe create a file on synapse (internal project) with these id's and filter out in each script.
1f0336de-9071-45c3-ba33-d5095e2d259a 16d31193-78d0-4213-b340-d5f052f78bcb 4c13ef3c-4df9-485c-82f8-39973173ee5f f8490e87-a10c-4275-a0a5-f09b6b0f1649 22cf36f5-6ca6-463b-bc31-4887b5e22481 11020820-bfe4-4180-af74-1debef94cb08 4473ea55-f14c-407d-bf89-80f511897749 b0844387-9ff2-45c7-a1f8-1521a9b38a80 876bbf94-d42f-4f9d-8323-b52a12f17ad3 8781aa1a-7ccd-4153-8d41-dc65799961c6 ee1daae6-c2f1-4ccf-bd47-6bc5d2f1236d 29cc0e59-067c-45c1-852a-fd19cab8a604 3e5229ce-5f5b-41ee-9b85-8484c7dfc4cd 6f559fd1-af20-46ed-87e8-64228186b62a 48f07461-0c35-482b-aa47-4864b667e99e fdf42589-ce1c-49ad-83c2-fd1f0219b87b 8343ac66-28e6-41bf-9910-42142fdd6340 9b57fdb4-289f-4611-9542-f732d4466bf5 405df1ec-4879-43bb-b28c-f7bd9ea775e4 f698a007-148a-41a5-be73-80f07fceb4c7 1cb06170-a6a4-4917-9834-ebf76202b8b3 b67716cc-815f-4c2c-a486-3dc528672466 e9aec067-c46c-4ede-b6b9-442518c03447 190509f7-e053-4b32-a5f3-f42c8fc4b52a 130b7353-679d-46ff-afde-bd35ca1d5a57 fefadb5e-88d6-4d6b-bc1d-94c1d53364d0 2510df83-a825-42b0-8004-63e2863e29c9 df02bba2-2ed5-4ed2-8715-bfe3e8d7fa09 096b0e1c-853e-410c-9972-377361dae0a9 a38653f6-279d-42f2-a192-1e4c93d516d0 7249fde8-2a7d-43e4-9785-891620224407 f47604ee-ed3b-4304-a3b8-b301e9d4b38f eced8437-0992-4257-8b6f-2e9e66b2acfe ae333c97-9c9f-4e1d-9dce-cef06f45d888 5571c0f0-271d-407a-9357-cbcfcff83b83 fc4c7caf-438a-40a6-9c2b-a350361b700f acf2c18f-2af6-40a0-bb02-530513910434 be753f83-69ae-40e3-8242-9fba7afcd692 ffa19370-f5ef-4171-bb58-16ffc43427f1 79796dad-19ce-4412-b607-bc579095f184 f818ab4d-aae5-456d-8b8b-1fa486bb9fbf 6d12ba8a-44ef-4dc0-b450-714b96b44c30
https://www.synapse.org/#!Synapse:syn21927918
itismeghasyam
commented
4 years ago
The following healthCodes need to be removed from every table including demographics. Maybe create a file on synapse (internal project) with these id's and filter out in each script.