June 25, 2020 at 8:12 pm
Jeffrey - if only it was that simple. The individual fields are stored and then the application combines them all together. The documents are built in "sections" which is why the fields are named that way. The bit before the underscore is the section, with the bit after it being the actual question. A lot of the time, all the questions are completed which is why we need all the fields to be imported.
I really doesn't matter how the application puts the document together - what matters is how it is sent to you and how you parse that data into your structure. I know for a fact that SNOMED codes do not exceed 18 characters - so unless they are sending you a bunch of non-relevant data in that column/field there is no reason to use varchar(max).
If you have a value in every field (column) then you would have a relevant row in the associated Concerns table. For every section where there is no data provided you would not have a row...that would save space and improve performance.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 26, 2020 at 12:18 pm
This was removed by the editor as SPAM
Viewing 2 posts - 31 through 31 (of 31 total)
You must be logged in to reply to this topic. Login to reply