Chart number: Difference between revisions

(15 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 14:

The number is assigned to a patient by Admitting. This is done once the patient has been seen by Triage in ER or new to the hospital for clinics, testing and various workups. This number remains the patient's chart number for all hospital visits, admissions, tests, etc.

== ~~No leading zeros~~ ==

== Collection instructions ==

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

=== Leading Zeros ===

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

== ~~Pt Doe~~ ==

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

~~Patient is admitted as an unknown "Pt Doe". They are given a new chart 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.

*At HSC the ~~chart number for Doe starts with: 300 then 5 digits. Total 8 digits.~~

*During a patients stay or after discharge from hospital, Health records may find a match to previous chart and they merge 300.....chart number with original chart number.

*Data Collectors use the number ~~that Admitting gave John Doe for his entire stay unless they notice the update of chart number if MR finds it before discharge.~~

*Data Collectors also enter in ~~the [[Alias ID collection]] in the tmp project the alternate MRN~~, ~~Name or other identifier~~, ~~eg PHIN~~.

~~=== 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~~.

*query PL_SameCHART_Site_Diff_PHIN

*query PL_SamePHIN_Site_Diff_chart

*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~~]].

=== Unclear or changing chart numbers ===

See

* [[Alias ID collection]]

* [[John or Jane Doe patient]]

* [[Stolen identities]]

~~In addition, the~~ [[~~Statistician~~]] ~~uses SAS to check key identifiers so they are consistent~~ for same patient ~~including Hosp~~ chart ~~etc~~.

== Data Processing ==

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_SamePHIN_Site_Diff_chart]]

*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]].

In addition, the [[Statistician]] uses SAS to check key identifiers so they are consistent for same patient including Hosp chart etc.

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

== 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:Identification numbers]]

[[Category: Registry Data]]

[[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 14: / Line 14: @@
 The number is assigned to a patient by Admitting. This is done once the patient has been seen by Triage in ER or new to the hospital for clinics, testing and various workups. This number remains the patient's chart number for all hospital visits, admissions, tests, etc.
-== No leading zeros ==
+== Collection instructions ==
-If your chart number system uses leading zeros, don't enter the leading zeros, start with the first non-zero number.
+=== Leading Zeros ===
+If your chart number system uses leading zeros, '''don't enter the leading zeros''', start with the first non-zero number.
-== Pt Doe ==
+=== Dashes near the end of the number ===
-Patient is admitted as an unknown "Pt Doe". They are given a new chart 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.
-*At HSC the chart number for Doe starts with: 300 then 5 digits. Total 8 digits.
-*During a patients stay or after discharge from hospital,  Health records may find a match to previous chart and they merge 300.....chart number with original chart number.
-*Data Collectors use the number that Admitting gave John Doe for his entire stay unless they notice the update of chart number if MR finds it before discharge.
-*Data Collectors also enter in the [[Alias ID collection]] in the tmp project the alternate MRN, Name or other identifier, eg PHIN.
-=== 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.
-*query PL_SameCHART_Site_Diff_PHIN
-*query PL_SamePHIN_Site_Diff_chart
-*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]].
+=== Unclear or changing chart numbers ===
+See
+* [[Alias ID collection]]
+* [[John or Jane Doe patient]]
+* [[Stolen identities]]
-In addition, the [[Statistician]] uses SAS to check key identifiers so they are consistent for same patient including Hosp chart etc.
+{{Guideline Minimal Data Set}}
+== Data Processing ==
+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_SamePHIN_Site_Diff_chart]]
+*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]].
+In addition, the [[Statistician]] uses SAS to check key identifiers so they are consistent for same patient including Hosp chart etc.
 {{PHI_Data}}
-== {{CCMDB Data Integrity Checks}} ==
+== 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:Identification numbers]]
-[[Category: Registry Data]]
+[[Category:Registry Data]]
+[[Category:Demographics]]
+[[Category:Cognos Report Integrator]]
+[[Category:Data Collection Guide]]