Serial number: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
Line 1: Line 1:
''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.
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.



Revision as of 14:03, 15 July 2011

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.