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.

GRACE

• G9 - GRA_MICU - p:Gladys Ens
• G8 - GRA_N3, GRA_N5 (N3a, N5a), GRA_EMIP- p:Mindy Crawley
• G7 - GRA_N5/GRA_S3 - p:Sherry Urbanski

HSC

• H9 - old HSC_ICUa - p:Joanna Velasco
• H8 - old HSC_ICUb - p:Joyce Peterson
• H7 - old HSC_ICUd - p:Michelle Lagadi
• H6 - HSC_A4 - p:Lisa Kaita
• H5 - HSC_B3 and HSC_WRS3 - p:Iris DeLeon - regardless of which medicine physician service is looking after the patient in these units
  • Patients transferred FROM HSC_B3 and FROM HSC_WRS3 to contingency units (H6, WRS2) and HSC_B2 (HOBS)
  • HSC_WRS2 patients under unknown medicine physician service
  • All Nephrology patients for Kidney Transplant directly admitted to HSC_B2 (HOBS)
  • HSC EMIPs admitted from the 1st to the 14th of the month.

EMIP's HSC - who does 15- end of month? See HSC EMIP - please avoid duplicating that info here.

• SMW

• Cargo

• Categories

• H4 - HSC_D4 p:Brynn Lezak As of May 27th 2020.
  • was collecting HSC_D5, HSC_D4_COVID on this laptop when ward changes happened
  • D4 along with the D service patients on H6, WRS2 and B2.
  • medicine service physician that is "Unknown" from D4, as well as H6 are also collected on this laptop.
  • HSC_EMIPs are collected at HSC by date, not by service, so this laptop will potentially have any ,medicine physician service 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 - p:Katrina Uy

STB

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