Chart number: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
Jvelasco (talk | contribs)
CCMDB_legit, Bureaucrats
942 edits
No edit summary
 
(36 intermediate revisions by 5 users not shown)
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.


== Integrity Check ==
=== 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 has been a request to also ensure that the number is not equal to the [[PHIN field]].
{{Guideline Minimal Data Set}}


[[Category: Identification numbers]]
== 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:Registry Data]]
[[Category:Demographics]]
[[Category:Cognos Report Integrator]]
[[Category:Data Collection Guide]]

Latest revision as of 14:06, 2020 July 17

Data Element (edit)
Field Name: Chart
CCMDB Label: Chart
CCMDB tab: Top Row
Table: L_Log table, L_PHI table
Data type: string
Length: 8
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 6

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

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


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.

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

See

Minimal Data Set

This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.

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.

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.

L_PHI vs L_Log

This field is stored in the L_PHI table in CFE but in the L_Log table in CCMDB.accdb. See L_PHI table for details why.

Cross checks

Data Integrity Checks (automatic list)

 AppStatus
Check duplicate patientCCMDB.accdbimplemented
Query check minimal data set incompleteCCMDB.accdbimplemented
Function PHIN same as ChartCCMDB.accdbimplemented
Function Validate ChartCCMDB.accdbimplemented
PL SamePHIN Site Diff chartCentralized data front end.accdbimplemented
PL SameCHART Site Diff PHINCentralized data front end.accdbimplemented
PL Chart 9 DigitCentralized data front end.accdbimplemented

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Chart_number&oldid=145240"