Chart number: Difference between revisions

(34 intermediate revisions by 5 users not shown)

Line 1:

Chart number ~~is the number 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. It is unique to that patient.~~

{{Data_element

| field_name = Chart

| CCMDB_label = Chart

| 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 table, L_PHI table

| data_type = string

| datafield_length = 8

| program_collecting = Med and CC

| created_raw = Raw

| data_element_sort_index = 6

}}

~~EXCEPTION: Patient~~ is ~~admitted as an unknown "Pt Doe". They are given~~ a ~~new chart number~~. ~~After discharge~~ the ~~old records will be "married"~~ to the ~~new ones~~.~~--[[User:CMarks|CMarks]] 12:43~~, ~~5 August 2011 (CDT)~~

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.

== Collection instructions ==

=== Leading Zeros ===

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

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

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

~~[[CCMDB~~.~~mdb]] uses function Validate_chart() to validate~~ the ~~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.

~~Because~~ chart numbers ~~are different at different hospitals, all that is being checked right now is that the entry is numerical.~~

=== Unclear or changing chart numbers ===

See

* [[Alias ID collection]]

* [[John or Jane Doe patient]]

* [[Stolen identities]]

~~There is a check to ensure that [[PHIN field]] and [[Chart number]] are not identical.~~

[[Category: Identification numbers]]

== Data Processing ==

[[Category: Registry Data]]

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.

== Cross checks ==

== Related articles ==

[[Category:Identification numbers]]

[[Category:Registry Data]]

[[Category:Demographics]]

[[Category:Cognos Report Integrator]]

[[Category:Data Collection Guide]]

@@ Line 1: / Line 1: @@
-Chart number is the number 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. It is unique to that patient.
+{{Data_element
+| field_name = Chart
+| CCMDB_label = Chart
+| 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 table, L_PHI table
+| data_type = string
+| datafield_length = 8
+| program_collecting = Med and CC
+| created_raw = Raw
+| data_element_sort_index = 6
+}}
-EXCEPTION: Patient is admitted as an unknown "Pt Doe". They are given a new chart number. After discharge the old records will be "married" to the new ones.--[[User:CMarks|CMarks]] 12:43, 5 August 2011 (CDT)
+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.
+== Collection instructions ==
+=== Leading Zeros ===
+If your chart number system uses leading zeros, '''don't enter the leading zeros''', start with the first non-zero number.
-== {{CCMDB Data Integrity Checks}} ==
+=== Dashes near the end of the number ===
-[[CCMDB.mdb]] uses function Validate_chart() to validate the 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.
-Because chart numbers are different at different hospitals, all that is being checked right now is that the entry is numerical.
+=== Unclear or changing chart numbers ===
+See
+* [[Alias ID collection]]
+* [[John or Jane Doe patient]]
+* [[Stolen identities]]
-There is a check to ensure that [[PHIN field]] and [[Chart number]] are not identical.
+{{Guideline Minimal Data Set}}
-[[Category: Identification numbers]]
+== Data Processing ==
-[[Category: Registry Data]]
+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}}
+== Cross checks ==
+{{Data Integrity Check List}}
+== Related articles ==
+{{Related Articles}}
+[[Category:Identification numbers]]
+[[Category:Registry Data]]
+[[Category:Demographics]]
+[[Category:Cognos Report Integrator]]
+[[Category:Data Collection Guide]]