Laptop identifier: Difference between revisions
Ttenbergen (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
Line 16: | Line 16: | ||
* H9 - old HSC_ICUa - '''[[p:Joanna Velasco]]''' | * H9 - old HSC_ICUa - '''[[p:Joanna Velasco]]''' | ||
* H8 - old HSC_ICUb - '''[[p:Joyce Peterson]]''' | * H8 - old HSC_ICUb - '''[[p:Joyce Peterson]]''' | ||
* H7 - old HSC_ICUd - ''' | * H7 - old HSC_ICUd - '''[[p:Michelle Lagadi]]''' | ||
* H6 - [[HSC_A4]] - ''' | * H6 - [[HSC_A4]] - '''[[p:Lisa Kaita]]''' | ||
* H5 - '''[[p:Iris DeLeon]]''' | * H5 - '''[[p:Iris DeLeon]]''' | ||
** all medicine patients in [[HSC_B3]] and [[HSC_WRS3]] regardless of which service is looking after the patient | ** all medicine patients in [[HSC_B3]] and [[HSC_WRS3]] regardless of which service is looking after the patient | ||
Line 24: | Line 24: | ||
** All Nephrology patients for Kidney Transplant directly admitted to [[HSC_B2]] (High Obs) | ** All Nephrology patients for Kidney Transplant directly admitted to [[HSC_B2]] (High Obs) | ||
** [[HSC EMIP]]s admitted from the 1st to the 14th of the month. | ** [[HSC EMIP]]s admitted from the 1st to the 14th of the month. | ||
* H4 - [[HSC_D5]] and [[HSC_D4_COVID]] - '''[[p: | * H4 - [[HSC_D5]] and [[HSC_D4_COVID]] - '''[[p:Brynn Lezak]]''' As of May 27th 2020, this laptop now collects | ||
** D4, along with the D service patients on H6, WRS2 and B2. | ** 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. | ** 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. | ** 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]] - ''' | * H3 - [[HSC_H4]] - '''[[p:Katrina Uy]]''' | ||
* S9 - old [[STB_ACCU]] - '''[[p:Marla Penner]]''' | * S9 - old [[STB_ACCU]] - '''[[p:Marla Penner]]''' | ||
* S8 - old [[STB_CICU]] - '''[[p:Stephanie Cortilet]]''' | * S8 - old [[STB_CICU]] - '''[[p:Stephanie Cortilet]]''' |
Revision as of 16:04, 2020 August 24
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 - p:Michelle Lagadi
- H6 - HSC_A4 - p:Lisa Kaita
- 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:Brynn Lezak 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 - p:Katrina Uy
- 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
- if no line starts with the word Laptop_Identifier
- 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