Serial number

From CCMDB Wiki
Jump to navigation Jump to search

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.

Special-Use Serial Numbers

As of 26 October 2010, special use serial numbers are:

  • Serial numbers <10 are used as test data.
  • Serial numbers 111 to 140 were used for the Peer Audit.
  • a "new" location starts at Serial number 1.

Serial Number Reuse

A serial number in CCMDB.mdb can be re-used once the patient record that used it has been deleted. For example, if you entered a pt twice, with separate numbers and deleted one then you can re-use the deleted number for another patient. (This would have caused problems in HanDBase/PDA, but is fine on the laptops.)

Serial numbering for STB_ICU (MICU, SICU, CCU)

  • serial numbering for STB was as follows:
    • SICU 1-50
    • MICU 51-70
    • CCU 71-100
  • SICU/MICU combined to one unit Jan 15.07 & the new CICU was open. Serial number group sharing stopped.

Start Date

  • from 1999

Stop Date

Nov. 24, 2008 or did we stop it Jan 15.2007?--TOstryzniuk 18:58, 26 October 2010 (CDT)

Serial numbering for HSC_ICU (MICU, SICU, CCU, IICU)

    • MICU 1-30
    • CCU 31-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

Change Date

    • MICU/CCU/IICU-M Serial number: 1-50 (start at study 25145)
    • SICU/IICU-S Serial number: 51-100 (no changes)

Serial numbering for STB_MED (B4, B5, E5) - Legacy

  • 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).
    • E5 - serial numbers 1-20 (these additional pts are entered on B4 PDA using this serial number range for every group of 100).TOstryzniuk 19:24, 4 March 2009 (CST)

Start Date

Started: Sept 17, 2006

Purpose

a workload redistribution assessment was done to even out the workload for patient admissions vs EFT.

Stop Date

March 31, 2010

Serial number share plan for STB-5B

See: STB Medicine Collection Guide

  • 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
  • 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,0.
  • example:
    • Elaine: 2034-2040, Deb: 2041-2043
    • Elaine: 2044-2050, Deb: 2051-2053
    • Elaine: 2054-2060, Deb: 2061-2063 etc.........

Start Date

Started: June 1, 2010

Purpose

  • assignment changes with workload redistribution

Stop Date

none - current

HSC_H4H Serial number share plan guide

Start Date

  • June 1.10

Purpose: workload distribution

H4H HOBS is divided up amongst the data collectors.

  • B3/D5 (Pat) - 3 charts/month on H4H
  • D4 (Fran) - 6 charts/month on H4H
  • A4 (Con) - 6 charts/month on H4H
  • H4 (Gail)- 15 or more depending on number of admissions on H4H
  • H4H is divided up amongst the data collectors

For every 100 numbers:

  • 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
  • 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

an effort is made to assign collectors patients that belong to the service they usually collect on.

Serial Numbering for VIC_MED_N5 & S5

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

Serial Numbering for GRA_MED_N5_W3

  • Week of Feb 20th.2011 - These two wards will now be on one laptop (N5). Stephanie will start the process to decommission the W3 laptop.]
  • serial #s for N5 & W3 were merged starting Feb. 23/12 with Serial # 4799; independent W3 serial #s ended with 4290