CCMDB Wiki

Lab identification in the DSM data: Difference between revisions

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(11 intermediate revisions by 2 users not shown)
Line 11: Line 11:
=== Start of date range ===
=== Start of date range ===
The Lab_DtTm is compared to the admit time of the patient as follows:  
The Lab_DtTm is compared to the admit time of the patient as follows:  
* <code>" WHERE ([Arrive_DtTm]<=" & LabDtTm_str & ") AND (" & LabDtTm_str & "<=nz([Dispo_DtTm],now())) "</code>
* <code>" WHERE ([Admit_DtTm]<=" & LabDtTm_str & ") AND (" & LabDtTm_str & "<=nz([Dispo_DtTm],now())) "</code>
** ie we start the range with the [[Arrive_DtTm]], not the [[Accept_DtTm]]
** ie we start the range with the [[Admit DtTm]]
{{Discuss | we should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far? }}
 
=== date constraints ===
the data we would want to use, but instead on which data was consistently available. Not all these columns are always filled.
*<code>[Arrive_DtTm]<=CDate(Nz([COLLECTEDDATE],[arriveddate]))+CDate(Nz([CollectedTime],[LabarrivedTime]))</code>
*<code>CDate(Nz([COLLECTEDDATE],[arriveddate]))+CDate(Nz([CollectedTime],[LabarrivedTime]))<=[Dispo_DtTm]</code>


=== counts ===
=== counts ===
We originally did labs as counts.  
We originally did labs as counts, but now store them with results. A count of them can be viewed using query ''L_Labs_Flowsheet_DSM_sum''.
A count of them can be viewed using query ''L_Labs_Flowsheet_DSM_sum''.


=== individual record ===
=== individual record ===
Line 24: Line 27:
=== group of records ===
=== group of records ===
Some other lab tests lead to multiple results and are reported as a group of lines per lab done. The best way to identify them was based on the GRPTEST column in the [[DSM Lab Extract]]. That column is compared to table ''s_group'' by query ''2_D_counts_group_appender'' to populate table ''L_Labs_Flowsheet_DSM''.
Some other lab tests lead to multiple results and are reported as a group of lines per lab done. The best way to identify them was based on the GRPTEST column in the [[DSM Lab Extract]]. That column is compared to table ''s_group'' by query ''2_D_counts_group_appender'' to populate table ''L_Labs_Flowsheet_DSM''.
The s_mapping_lab table in [[Instructions for importing a batch of DSM Data]] defines which labs will be counted as which tests.
On every run of [[Instructions for importing a batch of DSM Data]], there is a check to find out if any new labs are in the new data that are not in the table. During testing, most times included a few new labs. For these new labs it would need to be decided if they are a type we collect before finishing the import.


== Updates / new lab Name or Labels in DSM ==
== Updates / new lab Name or Labels in DSM ==
Line 32: Line 38:




[[Category: DSM Labs Extract]]
[[Category:DSM Labs Extract]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Lab_identification_in_the_DSM_data"