Pat_ID redirects here because the main office uses the term Serial Number for this.
The Pat_ID / Serial number is consecutive number to identify a ward/unit admission. It is unique per patient ward/unit admission, but not across our data (see D_ID).
- IMPORTANT: on any laptop, a serial number used must be unique.
see Adding a patient
The number is assigned automatically, see Facilitated Management of Serial numbers.
If you need to change this number after initially entering the patient you need to do this in the Patient List.
Minimal Data Set
This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.
Data Integrity Checks (SMW)
|Query check minimal data set incomplete||CCMDB.accdb||implemented|
Special-Use Serial Numbers
- Serial numbers <10 are used as test data.
- Serial numbers 111 to 140 were used for the Peer Audit.
- a "new" Laptop identifier starts at Serial number 150. (If this changes, Facilitated Management of Serial numbers will need to change as well)
Serial Number Reuse
A serial number in CCMDB.accdb should not be re-used. TISS and sending to L_PHI will run into problems when these numbers are re-used. If serial number is changed Statistician has added hassle trying to figure out which patient data belongs to.
Legacy HSC_ICU Serial number distribution
- MICU and CCU share 1 - 50
- SICU 51-100
- IICU use SICU serial number if pt from SICU to IICU. Use MICU serial number if pt from MICU to IICU.
Start Date 1999
Stop Date: Changes much prior to May 26, 2014 or earlier
- MICU/CCU/IICU-M Serial number: 1-50 (start at study 25145) as reported by Gail Hall--Nov 14.14
- SICU/IICU-S Serial number: 51-100 (no changes) p:Joyce Peterson no longer follow as reported Nov 7.14
Vic and Grace patients with location <hosp>_EMIP use their own serial number series.
STB and HSC have letter postfixes for the EMIPs so each laptop uses own serial sequence.
Elaine has been assigned to E6&5B and Deb to E5. Workload distribution plan: Deb will pick up the FIRST THREE NEW admissions to 5B every month. In the past there has been confusing rules as to which patients Debbie picks up. There is a new rule (effective 11-Aug-14) that will simplify the issue so that anyone doing vacation or sick relief can sort it out. The new rule is: Debbie picks up the first three patients that arrive on 5b from 00:00 hrs, on the first day of the month. It does not matter if they don’t’ get transferred to the 5b/c service attending immediately, two or three days later, or never. When they arrive from 5e or 6e, they are discharged from the e5 or e6 database, and entered into the 5b database.
Started: June 1, 2010
Unsure - but no longer used as confirmed by p:Joyce Peterson Nov 27.14
5B changes Jan 21.15
in STB_B5#Workload_splitting it said the following; moved here to at least have inconsistent info in one place:
No Serials for early studies
There are no serial numbers for early study numbers before incl. Study 13035 CC. There are serials for all medicine studies.
Legacy H4H Nov 26.04- no longer applicable
LEGACY: STB_ICU (MICU, SICU, CCU) Serial number sharing plan)
Nov. 24, 2008 or did we stop it Jan 15.2007?--TOstryzniuk 18:58, 26 October 2010 (CDT)
LEGACY: STB_MED (B4, B5, E5) Serial number sharing plan
Started: Sept 17, 2006
a workload redistribution assessment was done to even out the workload for patient admissions vs EFT.
March 31, 2010
LEGACY: Serial Numbering for VIC_MED_N5 & S5
LEGACY: Serial Numbering for VIC_MED N5_S5_S3
Date changed: July 4.13
Reason: workload redistribution. Noted more admits to S3.
Date changed: April 1.12
moved from "VIC_Medicine_Collection_Guide"
N5 & S5 Data merge to one laptop
N5 & S5 data were merged onto one laptop. Serial numbering for new admissions after merge started at 3264. Irrespective of which ward they are from (N5 or S5), sequence is continuous.
Date of merge N5 & S5
January 5, 2011
S3 collection merge to N5 & S5 laptop
S3 data has merged with N5 & S5 beginning with serial number 4957.
Date of merge S3 with N5 & S5
As of April 1 2012,
LEGACY: Serial Numbering for GRA_MED_N5_W3
LEGACY: VIC OVER vs EMIP patients
At VIC: the OVER patients which used to be together with EMIP serial sequence from May 2007 will no longer continue starting Jan 28, 2013. The serial sequence will be used entirely by EMIP.