Chart number: Difference between revisions

(11 intermediate revisions by 2 users not shown)

Line 4:

| CCMDB_tab = Top Row

| element_description = The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.

| in_table = L_Log

| in_table = L_Log table, L_PHI table

| data_type = string

| datafield_length = 8

Line 17:

=== Leading Zeros ===

If your chart number system uses leading zeros, '''don't enter the leading zeros''', start with the first non-zero number.

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

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.

=== Unclear or changing chart numbers ===

Line 23:

Line 26:

* [[John or Jane Doe patient]]

* [[Stolen identities]]

== 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 36:

Line 41:

== {{~~CCMDB~~ Data Integrity ~~Checks|implemented~~}} ==

== Cross checks ==

~~[[CCMDB.mdb]] uses function Validate_chart() to validate the Chart number.~~

== Related articles ==

* check that the entry is numerical

* check to ensure that [[PHIN field]] and Chart number are not identical.

* no further checks at this time because chart numbers are different at different hospitals

[[Category:Identification numbers]]

[[Category:Registry Data]]

[[Category:Demographics]]

[[Category:Cognos Report Integrator]]

[[Category:Data Collection Guide]]

@@ Line 4: / Line 4: @@
 | CCMDB_tab = Top Row
 | element_description = The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.
-| in_table = L_Log
+| in_table = L_Log table, L_PHI table
 | data_type = string
 | datafield_length = 8
@@ Line 17: / Line 17: @@
 === Leading Zeros ===
 If your chart number system uses leading zeros, '''don't enter the leading zeros''', start with the first non-zero number.
+=== Dashes near the end of the number ===
+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.
 === Unclear or changing chart numbers ===
@@ Line 23: / Line 26: @@
 * [[John or Jane Doe patient]]
 * [[Stolen identities]]
+{{Guideline Minimal Data Set}}
 == 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 36: / Line 41: @@
 {{PHI_Data}}
-== {{CCMDB Data Integrity Checks|implemented}} ==
+== Cross checks ==
-[[CCMDB.mdb]] uses function Validate_chart() to validate the Chart number.
+{{Data Integrity Check List}}
+== Related articles ==
+{{Related Articles}}
-* check that the entry is numerical
-* check to ensure that [[PHIN field]] and Chart number are not identical.
-* no further checks at this time because chart numbers are different at different hospitals
 [[Category:Identification numbers]]
 [[Category:Registry Data]]
 [[Category:Demographics]]
+[[Category:Cognos Report Integrator]]
+[[Category:Data Collection Guide]]