ClientGUID field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 59: Line 59:


=== Backfilling ===
=== Backfilling ===
I started discussion with DSS that we would like to eventually back-fill this data. So, for any MRN where we don't have a ClientGUID we would ask for it to be provided. Ancient records won't have a ClientGUID; can we use their methods to create one or should we fill in our PHIN/PseudoPHIN for those?
I started discussion with DSS that we would like to eventually back-fill this data. So, for any MRN where we don't have a ClientGUID we would ask for it to be provided.  
{{Todo
 
| who = Tina
Ancient records won't have a ClientGUID; Chastity doesn't know what method they used to generate the ID so we can't use it to recreate these. We can insert our PHIN/PseudoPHIN for those, but would need to have a cross check method to capture and update if a same PHIN ever comes in new with a ClientGUID.
| todo_added = 2022-06-16
| todo_action = 2022-06-16
| question = 
* Discussing details with Chastity. [[User:Ttenbergen|Ttenbergen]] 11:41, 2022 June 16 (CDT)
}}


=== Log ===
=== Log ===

Revision as of 15:23, 2022 August 4

Data Element (edit)
Field Name: ClientGUID
CCMDB Label: not stated
CCMDB tab: not stated
Table: Cognos_import3 table
Data type: string
Length: 16
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index:

The unique person identifier from Cognos.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


This page is about the ClientGUID field which identifies people, not the ClientVisitGUID which identifies admissions.

Background

Many patients don't have MB PHINs so we generate PseudoPHINs. EPR solves this by using a field ClientGUID, which we get as part of the Cognos EPR Report. If we set up the infrastructure to actually put this into patient records then we might be able to step away from the PseudoPhin process, and should have many fewer link errors.

Concerns

Do we still enter any data that is not from Cognos?

  • Do collectors add all HSC IICU admissions via Cognos now that each IICU service admission is included on all HSC CC laptops? Or are there still exceptions. Ttenbergen 11:41, 2022 June 16 (CDT)
  • SMW


  • Cargo


  • Categories
  • Aside from the odd correction entries, are there scenarios where records are routinely added other than via Cognos? Ttenbergen 11:41, 2022 June 16 (CDT)
  • SMW


  • Cargo


  • Categories

Merged records (John or Jane Doe patient who get identified, and other corrections)

Chastity confirmed there is a merge process for J Does who get identified. Confirming how this works, emailed Chastity 2022-06-16.

  • Chastity confirmed there is a merge process for J Does who get identified. Confirming how this works, emailed Chastity 2022-06-16.
  • Asked Chastity if 3 month updates will be possible.
  • added: 2022-04-13
  • action: 2022-06-30
  • Cargo


  • Categories

Implementation

This would likely replace Person ID field eventually, but we'd keep it until tested; Generate Person IDs would still need to be done to enter this into L_Person table.

_dev_CFE_data, _dev_ccmdb

  • added this field to L_Log table in CCMDB_data
  • add this field to L_Log table in Centralized_Data
  • add code so it's entered on patient generation
  • add the field to sending
  • review linking and related processes to see what could change to make best use of this
  • remove the L_Person table - we don't use it and this further means we don't need/use it. as confirmed with Julie here.
  • added: 2022-03-24
  • action: 2022-08-09
  • Cargo


  • Categories

Data Processing improvements

Having this field might further cut down on Pre-linking checks, or at least on how many problems those find. Or it might add to them, since merges could be messy.

Pagasa confirmed that we already see very few pre-linking checks that are actual errors, and that those are usually from PL_SamePHIN_Site_Diff_chart now: "I have few errors common for HSC assigned a temporary chart which starts to 300 number but patient had already old chart number, another scenario old chart number but single admission nothing to compare with then have a current admission which is the correct one. "

Backfilling

I started discussion with DSS that we would like to eventually back-fill this data. So, for any MRN where we don't have a ClientGUID we would ask for it to be provided.

Ancient records won't have a ClientGUID; Chastity doesn't know what method they used to generate the ID so we can't use it to recreate these. We can insert our PHIN/PseudoPHIN for those, but would need to have a cross check method to capture and update if a same PHIN ever comes in new with a ClientGUID.

Log

Changing D_IDs

Changing D_IDs

Related Articles

Related articles: