Laptop identifier

The laptop identifier is used to

• set out which directoriey/File Locations on the Regional Server is used for a laptop's News and Backup
• make a unique D_ID

The identifiers are stored in entry "Laptop_Identifier" in Settings (CCMBD.mdb) / A_Info table.

The naming convention is a letter for the site and a 1 digit number that has no inherent meaning other than to ID a laptop.

You can find the Laptop Identifier on a sticker on the laptop, or in the top right of the Main Form (CCMDB.accdb).

Laptop Identifier Assignment

Also see Site and Location table and the tables linked from there. We need to be careful so that info doesn't become inconsistent. Not building structure for it on the wiki since hopefully this will go away with PatientFollow Project.

• G9 - GRA_MICU - p:Gladys Ens
• G8 - GRA_N3, GRA_N5 (N3a, N5a) - p:Mindy Crawley
• G7 - GRA_N5/GRA_S3 - p:Sherry Urbanski
• H9 - old HSC_ICUa - p:Joanna Velasco
• H8 - old HSC_ICUb - p:Joyce Peterson
• H7 - old HSC_ICUd - vacant so different staff cover
• H6 - HSC_A4 - vacant so different staff cover
• H5 - p:Iris DeLeon
  • all medicine patients in HSC_B3 and HSC_WRS3 regardless of which service is looking after the patient
  • Patients transferred from HSC_B3 and HSC_WRS3 to contingency units (H6, WRS2) and High Obs unit(B2)
  • HSC_WRS2 patients under unknown service
  • All Nephrology patients for Kidney Transplant directly admitted to HSC_B2 (High Obs)
  • HSC EMIPs admitted from the 1st to the 14th of the month.
• H4 - HSC_D5 and HSC_D4_COVID - p:Michelle Lagadi As of May 27th 2020, this laptop now collects
  • D4, along with the D service patients on H6, WRS2 and B2.
  • Service "Unknown" patients from D4, as well as H6 are also collected on this laptop.
  • EMIP's are collected at HSC by date, not by service, so this laptop will potentially have any services EMIP's between a certain period of time. This exact dates that we collect on will be changing over the next few months, as vacant positions are filled.
• H3 - HSC_H4 - vacant so different staff cover
• S9 - old STB_ACCU - p:Marla Penner
• S8 - old STB_CICU - p:Stephanie Cortilet
• S7 - old STB_MICU (MISI) - p:Valerie Penner
• S6 - old STB_MedB (STB_B5/STB_IMCU) - p:Mailah Damian
• S5 - old STB_MedA (STB_E6_B) - p:Pamela Piche

Should this be updated to STB_E6?

• SMW

• Cargo

• Categories

• • Currently displaced E6 unit (A7S/A7W) entered as location A7B, Covid unit E6C, all covid suspect units (currently A6S is designated) but could include any 6th floor unit per service: A service as E5 with boarding location and B service as A7B with boarding location.
• S4 - old STB_MedD (STB_E5) - p:Debbie Page Newton

Setting the laptop identifier

Make sure you check Changing a Laptop identifier before you change this to make sure your change won't break anythign!

• open CCMDB.accdb
• click the Settings button
• on the left side, in the "General Settings" panel, find the line that has the word Laptop_Identifier in the left "field_name" column
  • if no line starts with the word Laptop_Identifier
    • make a new line and copy-paste the word Laptop_Identifier into the left, field_name column
    • put your laptop identifier (see #Laptop Identifier Assignment) in the right, "field_data" column
• click "OK" to exit out of the Settings window
• add a RED DOT sticker (use left-overs from Overstay) to the top right corner of the laptop and put the laptop identifier on there for easy reference.

Implementation

In CCMDB.accdb, the function Laptop_Identifier() will return this.

Background

We are using:

• single digits numbers for ease of filling TISS (it doesn't accept letters for that field)
• descending numbers to make it less likely that someone accidentally enters old page number rather than laptop ID
• single letters to minimize the increase in data