CCMDB Wiki

Serial number: Difference between revisions

← Older edit
No edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(83 intermediate revisions by 7 users not shown)
Line 1: Line 1:
''Pat_ID redirects here because the main office uses the term Serial Number for this.''
''Pat_ID redirects here because the main office uses the term Serial Number for this.''


The only number assigned at the data collector level is the '''serial number''', a number assigned manually from a consecutive sequence managed by each individual unit where data is collected. This means the serial number is unique at the unit level, but not across our data.
<onlyinclude>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]]). </onlyinclude>
 
*IMPORTANT:  on any laptop,  a serial number used must be unique.
 
== Collection Instruction ==
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]].
If you need to change this number after initially entering the patient you need to do this in the [[Patient List]].
{{Guideline Minimal Data Set}}
{{Data Integrity Check List}}


==Special-Use Serial Numbers ==
==Special-Use Serial Numbers ==
As of 26 October 2010, special use serial numbers are:
*Serial numbers <10 are used as [[test data]].
*Serial numbers <10 are used as [[test data]].
*Serial numbers 111 to 140 were used for the [[Peer Audit]].
*Serial numbers 111 to 140 were used for the [[Peer Audit]].
*a "new" location starts at Serial number 1.
*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==
==Serial Number Reuse==
A serial number in [[CCMDB.mdb]] should not be re-used. This creates a problem in TMPV2 database since data is sent multiple times to this database. If serial number is changed [[Statistician]] has added hassled trying to figure out which patient data belongs to.
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.


==Serial numbering for '''HSC_ICU''' (MICU, SICU, CCU, IICU)==
==Legacy HSC_ICU Serial number distribution==
*MICU and CCU share 1 - 50
*MICU and CCU share 1 - 50
*SICU 51-100
*SICU 51-100
*IICU use SICU serial number if pt from SICU to IICU. Use MICU serial number if pt from MICU to IICU.
*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 [[p:Gail Hall-resign, Nov 29, 2018 | 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
== EMIP ==
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.
== Related articles ==
{{Related Articles}}
{{Collapsable
| always= Legacy info
| full=
== Legacy ==
==Legacy - STB_5B: Serial number share plan==
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.
===Start Date===
===Start Date===
*1999 
Started: June 1, 2010
===Changes ===
===Purpose===
*MICU/CCU/IICU-M Serial number: 1-50 (start at study 25145)
*assignment changes with workload redistribution
*SICU/IICU-S  Serial number: 51-100 (no changes)
==== as of 2014-05-26 ====
used to be
*MICU 1-30
*CCU 31-50
until ?
===Stop Date===
===Stop Date===
* none - current - Ttenbergen 14:00, 2014 May 26 (CDT)
Unsure - but no longer used as confirmed by [[p:Joyce Peterson]] Nov 27.14
 
===5B changes '''Jan 21.15'''===
*Must do new and backup in AM '''before starting any collection''' on this day.
*E6 collector [[p:Elaine Nagy]] will continue using the 5B serial number sequence which is about 4290 or so. Will not have to skip any serial numbers anymore. 
*E5 collector [[p:Debbie Page-Newton]] - will
**start at '''serial number 150''' and the location for any 5B patient collected on or after this date,
**will use location '''5B_x'''
***As of June 2015 the E5 collector will no longer pick up any 5B patients, all patients on 5B will be followed by the E6 data collector. [[User:Lkaita|Lisa Kaita]] 10:40, 2015 August 18 (CDT)


==STB_5B: Serial number share plan==
===Legacy 5B===   
*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.  
*Start at: '''5B''' Serial number '''2037'''
*Start at: '''5B''' Serial number '''2037'''
*from every group of 10, Deb will use numbers ending with 1,2,3 and Elaine will use numbers ending with 4,5,6,7,8,9,0.
*from every group of 10, Deb will use numbers ending with 1,2,3 and Elaine will use numbers ending with 4,5,6,7,8,9,0.
Line 38: Line 69:
**Elaine: 2034-2040, Deb: 2041-2043
**Elaine: 2034-2040, Deb: 2041-2043
**Elaine: 2044-2050, Deb: 2051-2053
**Elaine: 2044-2050, Deb: 2051-2053
**Elaine: 2054-2060, Deb: 2061-2063 etc.........
**Elaine: 2054-2060, Deb: 2061-2063 etc.........   
*for vacation the suggest is for the collector that will be away, she would pick up addition 3 patient before going away on vacation.   
*start date: Jun 2, 2010
*A patient that are picked up by Elaine or Deb from 5B for entry must be:
*stop date: Jan 21.15
**entered onto their data collection log sheet AND
**minimal dataset entered into laptop and color generated for [[:Category: OverstayProject|OverstayProject]]
*Vacation coverage on this ward:
**for staff covering on on either E5 or E6, they must also continue collection on 5B during vacation coverage.[[User:TOstryzniuk|Trish Ostryzniuk]] 13:40, 2013 July 8 (CDT)
===Start Date===
Started: June 1, 2010
===Purpose===
*assignment changes with workload redistribution
===Stop Date===
none - current - Ttenbergen 13:55, 2014 May 26 (CDT)


==HSC_H4H Serial number share plan guide==
=== possible inconsistency ===
NOTE: HSC staff, please be mindfull when choosing LOCATION from dropdown list for H4 or H4H. Frequent error selecting the wrong unit between these two and others units also.  Thanks--[[User:TOstryzniuk|Trish Ostryzniuk]] 19:08, 2013 July 9 (CDT)
in [[STB_B5#Workload_splitting]] it said the following; moved here to at least have inconsistent info in one place:  
===Start Date===
*
*June 1.10
**start, approx:  2015-Jan-30
===Purpose: workload distribution===
**stop: 2015_May_28
'''H4H''' HOBS is divided up amongst the data collectors.
=== No Serials for early studies ===
*B3/D5 - 3 charts/month on H4H
There are no serial numbers for early [[Legacy - Study numbers | study numbers]] before incl. Study 13035 CC. There are serials for all medicine studies.
*D4  - 6 charts/month on H4H
*A4  - 6 charts/month on H4H
*H4 - 15 or more depending on number of admissions on H4H
*H4H is divided up amongst the data collectors


For every 100 numbers:
===Legacy H4H Nov 26.04- no longer applicable ===
*H4H For every '''100''' numbers:
*1-10 belongs to the B3/D5 Data Collector-takes 3 patients a month
*1-10 belongs to the B3/D5 Data Collector-takes 3 patients a month
*11-30 belongs to the D4 Data Collector-takes 6 patients a month
*11-30 belongs to the D4 Data Collector-takes 6 patients a month
*31-50 belongs to the A4 Data Collector-takes 6 patients a month
*31-50 belongs to the A4 Data Collector-takes 6 patients a month
*51-100 belongs to the H4 Data Collector-takes the balance of the monthly admissions
*51-100 belongs to the H4 Data Collector-takes the balance of the monthly admissions
 
**Start Date: June 1.2010
an effort is made to assign collectors patients that belong to the service they usually collect on.
**Stop Date: Nov 26.2014
*See: '''[[HSC Medicine Collection Guide]]'''
 
=== Stop Date ===
None - current - Ttenbergen 13:55, 2014 May 26 (CDT)
 
=== EMIP ===
Vic and Grace patients with location <hosp>_[[EMIP]] use their own serial number series
 
== Legacy ==
 
=== 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: '''STB_ICU''' (MICU, SICU, CCU) Serial number sharing plan)===
===LEGACY: '''STB_ICU''' (MICU, SICU, CCU) Serial number sharing plan)===
Line 97: Line 103:
===LEGACY: '''STB_MED''' (B4, B5, E5) Serial number sharing plan===
===LEGACY: '''STB_MED''' (B4, B5, E5) Serial number sharing plan===
*the collector who is assigned to B4 is required to pick up an additional 14 patient per month from B5 and 17 patient from E5 to even out workload.
*the collector who is assigned to B4 is required to pick up an additional 14 patient per month from B5 and 17 patient from E5 to even out workload.
**B5 - serial 86-100 (these additional pts are entered on B4 PDA using this serial number range for every group of 100).
**B5 - serial 86-100 (these additional pts are entered on B4 using this serial number range for every group of 100).
**E5 - serial numbers 1-20  (these additional pts are entered on B4 PDA using this serial number range for every group of 100).[[User:TOstryzniuk|TOstryzniuk]] 19:24, 4 March 2009 (CST)
**E5 - serial numbers 1-20  (these additional pts are entered on B4 using this serial number range for every group of 100).[[User:TOstryzniuk|TOstryzniuk]] 19:24, 4 March 2009 (CST)
[[Category: Legacy Data]]
[[Category:Legacy Data]]
====Start Date====
====Start Date====
Started: Sept 17, 2006
Started: Sept 17, 2006
Line 110: Line 116:
*These two wards are now on one laptop.  Numbers are continuous from date last checked. For example, last N5 serial number was 5555 on a particular data collection day and continuing on S5, the first S5 serial number will be 5556.
*These two wards are now on one laptop.  Numbers are continuous from date last checked. For example, last N5 serial number was 5555 on a particular data collection day and continuing on S5, the first S5 serial number will be 5556.
*To ensure data integrity, have been collecting data one ward per day and utilizing "pre-send checker" tab so locations are accurate.
*To ensure data integrity, have been collecting data one ward per day and utilizing "pre-send checker" tab so locations are accurate.
*[[VIC_Medicine_Collection_Guide#Serial_Numbers VIC Medicine Collection Guide]]


===LEGACY: Serial Numbering for VIC_MED N5_S5_S3===
===LEGACY: Serial Numbering for VIC_MED N5_S5_S3===
====Date changed: July 4.13====
====Date changed: '''July 4.13'''====
Reason: workload redistribution.  With [[:Category: OverstayProject | OverstayProject]] noted more admits to S3.
Reason: workload redistribution.  Noted more admits to S3.
*S3 will now be collected on S4 laptop.   
*S3 will now be collected on S4 laptop.   
**S4 laptop will end at 8747 and start at serial number 8770 and collect S4 & S3 will be collected starting at 8770 on the S4 laptop.   
**S4 laptop will end at 8747 and start at serial number 8770 and collect S4 & S3 will be collected starting at 8770 on the S4 laptop.   
Line 127: Line 131:
**the '''FIRST serial number''' to start to use for al'''l S3, S5 & N5''' patient admissions will start at Serial number '''4957'''.--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:42, 2012 April 2 (CDT)
**the '''FIRST serial number''' to start to use for al'''l S3, S5 & N5''' patient admissions will start at Serial number '''4957'''.--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:42, 2012 April 2 (CDT)


===LEGACY: Serial Numbering for GRA_MED_N5_W3===
== 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,
**April/15 Laptop VGDATACO504433F is used for CTU/EMIPs/OVERs  Laptop VGDATACO is used for N5/S5/S3 VMU
 
==LEGACY: Serial Numbering for GRA_MED_N5_W3==
*Week of February 20, 2012 - These two wards will now be '''on one laptop''' (N5).  [[User: SCortilet | Stephanie]] will start the process to decommission the W3 laptop.  
*Week of February 20, 2012 - These two wards will now be '''on one laptop''' (N5).  [[User: SCortilet | Stephanie]] will start the process to decommission the W3 laptop.  
*February 23, 2012 - serial #s for N5 & W3 were merged starting with Serial # 4799; independent W3 serial #s ended with 4290
*February 23, 2012 - serial #s for N5 & W3 were merged starting with Serial # 4799; independent W3 serial #s ended with 4290
*N5 & W3 are combined onto 1 laptop and have been for at least a year (Stephanie Cortilet 2013-09-26)
*N5 & W3 are combined onto 1 laptop and have been for at least a year (Stephanie Cortilet 2013-09-26)


=== LEGACY: VIC OVER vs EMIP patients ===
== 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.
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.




 
}}
[[Category: Registry Data]]
[[Category:Registry Data]]
[[Category: Identification numbers]]
[[Category:Identification numbers]]
[[Category:Data Collection Guide]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Serial_number"