DSM Lab Extract: Difference between revisions

(11 intermediate revisions by 2 users not shown)

Line 4:

== Things we still want to implement/fix ==

~~None currently~~

{{DT|

== Inclusion Criteria ==

* A possibility to change the current [[Chart]] entry to be the same with SH format (see [[#DSM Inclusion Criteria/ Process]] for reason why in details).

}}

== DSM Inclusion Criteria/ Process ==

*Must Match using the [[PHIN]] and/or [[Chart]] (provided and/or modified)

**There is an issue that the [[Chart]] format (i.e. without leading zeroes) at SBGH being provided to ~~Alun~~ is not the same with SH format. Because of this, ~~Alun~~ needs to add a step of adding 1x 0 or 2x 00 before the chart number to all SBGH records to help improve the matched results and refer to them as modified MRN.

**There is an issue that the [[Chart]] format (i.e. without leading zeroes) at SBGH being provided to the [[#DSM Contacts]] is not the same with SH format. Because of this, then [[#DSM Contacts]] needs to add a step of adding 1x 0 or 2x 00 before the chart number to all SBGH records to help improve the matched results and refer to them as modified MRN.

**The database will move to a new platform and the idea of changing the current [[~~CHART~~]] to the SH format on the new platform came up. Needs to be discussed further if to be implemented.

***The database will move to a new platform and the idea of changing the current [[Chart]] to the SH format on the new platform came up. Needs to be discussed further if to be implemented.

*Date range

** The minimum timestamp across all timestamps within the test, and across all tests within the request must >= admitted timestamp minus 2x days

Line 17:

Line 19:

=== Aliases ===

There might be some inconsistencies in how the labs are re-linked to patients who arrive as Jon Doe or have aliases in PHIN or Chart for other reason. If we want to include all patients with Aliases, we will need to do something to reconcile with [[Alias ID collection]].

=== Unmatched Cases ===

The patients with aliases when the list was earlier sent will be known after receiving back the extracted Lab because they will be included to the unmatched cases in addition to those who have real no lab data. Below is the action to take:

* Patients with LOS < 1day will be accepted as no lab data.

* Patients with LOS >= 1 day - 5 random samples will be cross checked in EPR by the [[Data Processor]] if indeed have no Lab Data. if any lab data is found, then check the PHIN or CHART if there are any changes (or a case with aliases).

** Re-check some more samples as time permits and do the same step above.

** Any unmatched records confirmed having labs present in the crosschecking will be re-send together in the next batch of sending.

== Requesting data ==

Line 40:

Line 48:

[[Category: DSM Labs Extract]]

[[Category:DSM Labs Extract]]

[[Category: Data Sources]]

[[Category:Data Sources]]

@@ Line 4: / Line 4: @@
 == Things we still want to implement/fix ==
-None currently
+{{DT|
-== Inclusion Criteria ==
+* A possibility to change the current [[Chart]] entry to be the same with SH format  (see [[#DSM Inclusion Criteria/ Process]] for reason why in details).
+}}
+== DSM Inclusion Criteria/ Process ==
 *Must Match using the [[PHIN]] and/or [[Chart]]  (provided and/or modified)
-**There is an issue that the [[Chart]] format (i.e.  without leading zeroes) at SBGH  being  provided to Alun is not the same with SH format.  Because of this, Alun needs to add a step of adding 1x 0 or 2x 00 before the chart number to all SBGH records to help improve the matched results and refer to them as modified MRN.
+**There is an issue that the [[Chart]] format (i.e.  without leading zeroes) at SBGH  being  provided to  the [[#DSM Contacts]] is not the same with SH format.  Because of this, then [[#DSM Contacts]] needs to add a step of adding 1x 0 or 2x 00 before the chart number to all SBGH records to help improve the matched results and refer to them as modified MRN.
-**The database will move to a new platform and the idea of changing the current [[CHART]] to the SH format on the new platform came up. Needs to be discussed further if to be implemented.
+***The database will move to a new platform and the idea of changing the current [[Chart]] to the SH format on the new platform came up. Needs to be discussed further if to be implemented.
 *Date range
 ** The minimum timestamp across all timestamps within the test, and across all tests within the request must >= admitted timestamp minus 2x days
@@ Line 17: / Line 19: @@
 === Aliases ===
 There might be some inconsistencies in how the labs are re-linked to patients who arrive as Jon Doe or have aliases in PHIN or Chart for other reason. If we want to include all patients with Aliases, we will need to do something to reconcile with [[Alias ID collection]].
+=== Unmatched Cases ===
+The patients with aliases when the list was earlier sent will be known after receiving back the extracted Lab because they will be included to the unmatched cases in addition to those who have real no lab data.  Below is the action to take:
+* Patients with LOS < 1day will be accepted as no lab data.
+* Patients with LOS >= 1 day - 5 random samples will be cross checked in EPR by the [[Data Processor]] if indeed have no Lab Data. if any lab data  is found, then check the PHIN or CHART if there are any changes (or a case with aliases).
+** Re-check some more samples as time permits and do the same step above.
+** Any unmatched records confirmed having labs present in the crosschecking will be re-send together in the next batch of sending.
 == Requesting data ==
@@ Line 40: / Line 48: @@
-[[Category: DSM Labs Extract]]
+[[Category:DSM Labs Extract]]
-[[Category: Data Sources]]
+[[Category:Data Sources]]