|
|
| Line 30: |
Line 30: |
| * add the field to sending | | * add the field to sending |
| * review linking and related processes to see what could change to make best use of this | | * review linking and related processes to see what could change to make best use of this |
| }}
| | * remove the [[L_Person table]] - we don't use it and this further means we don't need/use it. as confirmed with Julie here. |
| | | }} |
| {{Discuss |
| |
| * Do we even still need the [[L_Person table]] if we have this field? It contains last updated and death. Since we never got hospital deaths, we probably don't use that field. And I doubt we use the last-updated field - and in any case, it could easily be recreated from data, no need to store it. Unless of course we want to use it so we can streamline the re-checking and re-indexing of data somehow. [[User:Ttenbergen|Ttenbergen]] 09:28, 2022 March 24 (CDT) | |
| ** I haven't used this table [[L_Person table]] and not aware of its purpose. Is it intended to know quickly how many unique patients there are in the database? but without any other relevant data, not useful at all.--[[User:JMojica|JMojica]] 10:20, 2022 March 24 (CDT)
| |
| *** Agreed, not much use, it was added when we thought we would get Hospital Death in the near future. It is also used to contain the PersonID to make sure it's unique, but it really doesn't do a great job with it for now. I just wanted to be sure you are not using it for anything before possibly making big changes to it. [[User:Ttenbergen|Ttenbergen]] 12:10, 2022 March 24 (CDT)}}
| |
|
| |
|
| === Data Processing improvements === | | === Data Processing improvements === |