Chart number: Difference between revisions

(31 intermediate revisions by 4 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

}}

~~== Pt Doe ==~~

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.

~~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)~~

* so do you enter the new chart number, then? Does Julie reconcile these? how common is ~~this? Ttenbergen 16:23, 2013 May 22 (EDT) {{discussion}}~~

**We use the ~~number that Admitting gave John Doe for his entire stay. Julie~~ has to ~~marry~~ the ~~old with the new~~. ~~I don't know if she changes the~~ number ~~on our file. Admitting marries both numbers after~~ the patient ~~is discharged and again I am unsure what~~ number ~~is used~~.~~--[[User:CMarks|CMarks]] 14:15, 2013 May 24 (EDT)~~

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

== Collection instructions ==

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

=== Leading Zeros ===

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

* check that the ~~entry is numerical~~

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

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

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.

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

[[Category: Identification numbers]]

=== Unclear or changing chart numbers ===

[[Category: Registry Data]]

See

* [[Alias ID collection]]

* [[John or Jane Doe patient]]

* [[Stolen identities]]

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

== 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
+}}
-== Pt Doe ==
+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.
-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)
-* so do you enter the new chart number, then? Does Julie reconcile these? how common is this? Ttenbergen 16:23, 2013 May 22 (EDT) {{discussion}}
-**We use the number that Admitting gave John Doe for his entire stay. Julie has to marry the old with the new. I don't know if she changes the number on our file. Admitting marries both numbers after the patient is discharged and again I am unsure what number is used.--[[User:CMarks|CMarks]] 14:15, 2013 May 24 (EDT)
-== {{CCMDB Data Integrity Checks}} ==
+== Collection instructions ==
-[[CCMDB.mdb]] uses function Validate_chart() to validate the Chart number.
+=== Leading Zeros ===
+If your chart number system uses leading zeros, '''don't enter the leading zeros''', start with the first non-zero number.
-* check that the entry is numerical
+=== Dashes near the end of the number ===
-* check to ensure that [[PHIN field]] and [[Chart number]] are not identical.
+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.
-* no further checks at this time because chart numbers are different at different hospitals
-[[Category: Identification numbers]]
+=== Unclear or changing chart numbers ===
-[[Category: Registry Data]]
+See
+* [[Alias ID collection]]
+* [[John or Jane Doe patient]]
+* [[Stolen identities]]
+{{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}}
+== 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]]