Chart number: Difference between revisions

(4 intermediate revisions by one other user not shown)

Line 19:

=== Dashes near the end of the number ===

~~{{Discuss |~~

EPR sometimes lists something like MRN 123456-1; in that case, we code 1234561, i.e. leave out the dash, but code the trailing number.

*EPR sometimes lists something like MRN 123456-1; in that case, do we code the -1, ~~or do we~~ code ~~1234561, or just 123456?~~

}}

=== Unclear or changing chart numbers ===

Line 32:

Line 30:

== Data Processing ==

The Centralized_data_front_end.~~mdb~~ has queries that make sure that the chart number for each Hospital site is the same for the same patient and make sure the chart number has valid format.

The [[Centralized_data_front_end.accdb]] has queries that make sure that the chart number for each Hospital site is the same for the same patient and make sure the chart number has valid format.

*query PL_SameCHART_Site_Diff_PHIN

*query [[PL_SameCHART_Site_Diff_PHIN]]

*query PL_SamePHIN_Site_Diff_chart

*query [[PL_SamePHIN_Site_Diff_chart]]

*query ~~PL_Chart_9_Digit~~

*query [[PL Chart 9 Digit]]

The [[Data Processor]] fixes any inconsistencies found from these queries by crosschecking from EPR and adds the alias identifier to the tmp project [[Alias ID collection]].

Line 53:

Line 51:

[[Category:Registry Data]]

[[Category:Demographics]]

[[Category:Cognos Report Integrator]]

[[Category:Data Collection Guide]]

@@ Line 19: / Line 19: @@
 === Dashes near the end of the number ===
-{{Discuss |
+EPR sometimes lists something like MRN 123456-1; in that case, we code 1234561, i.e. leave out the dash, but code the trailing number.
-*EPR sometimes lists something like MRN 123456-1; in that case, do we code the -1, or do we code 1234561, or just 123456?
-}}
 === Unclear or changing chart numbers ===
@@ Line 32: / Line 30: @@
 == Data Processing ==
-The Centralized_data_front_end.mdb has queries that make sure that the chart number for each Hospital site is the same for the same patient and make sure the chart number has valid format.
+The [[Centralized_data_front_end.accdb]] has queries that make sure that the chart number for each Hospital site is the same for the same patient and make sure the chart number has valid format.
-*query PL_SameCHART_Site_Diff_PHIN
+*query [[PL_SameCHART_Site_Diff_PHIN]]
-*query PL_SamePHIN_Site_Diff_chart
+*query [[PL_SamePHIN_Site_Diff_chart]]
-*query PL_Chart_9_Digit
+*query [[PL Chart 9 Digit]]
 The [[Data Processor]] fixes any inconsistencies found from these queries by crosschecking from EPR and adds the alias identifier to the tmp project [[Alias ID collection]].
@@ Line 53: / Line 51: @@
 [[Category:Registry Data]]
 [[Category:Demographics]]
+[[Category:Cognos Report Integrator]]
+[[Category:Data Collection Guide]]