Chart number: Difference between revisions
Ttenbergen (talk | contribs) m →Pt Doe: m |
Ttenbergen (talk | contribs) m breaking out content and making sure it's linked |
||
| 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. | 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 == | ||
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. | |||
=== Unclear or changing chart numbers === | |||
See | |||
* [[Alias ID collection]] | |||
* [[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.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_SameCHART_Site_Diff_PHIN | ||
| Line 24: | Line 30: | ||
*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 | 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. | In addition, the [[Statistician]] uses SAS to check key identifiers so they are consistent for same patient including Hosp chart etc. | ||
{{PHI_Data}} | {{PHI_Data}} | ||
Revision as of 18:45, 7 May 2017
| Data Element (edit) | |
| Field Name: | Chart |
| CCMDB Label: | Chart |
| CCMDB tab: | Top Row |
| Table: | L_Log |
| 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.
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.
Unclear or changing chart numbers
See
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.
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.
Template:CCMDB Data Integrity Checks
CCMDB.mdb uses function Validate_chart() to validate the Chart number.
- 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