ClientVisitGUID field

Data Element (edit)
Field Name:	ClientVisitGUID
CCMDB Label:	N/A
CCMDB tab:	not stated
Table:	Cognos_import3 table
Data type:	string
Length:	16
Program:	Med and CC
Created/Raw:	Raw
Start Date:	2021-06-17
End Date:	2300-01-01
Sort Index:	1

Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.

• SMW

Legacy implementation right in the table

• Cargo

• Categories

• Forms

_dev_CCMDB_sending Implementation is a work in progress. This will likely replace Hospitalization ID. When we start sending this to CFE, update data_element_start_date to actual added to Centralized Data add to sending

added: no added date action: no action date

• Cargo

• Categories

The ClientVisitGUID field is the identifier used in Cognos to designate a hospitalization. We collect it to help deal with multiple encounters (eg see also Hospitalization ID, Visit Admit DtTm) and with uniquely matching components of Cognos data to profiles.

One advantage would be that ClientVisitGUID remains the same even when other data is corrected for a John Doe. One disadvantage is that not all our profiles are entered from Cognos, and this field would be blank for those that are not. Collectors can't look the field up in EPR, so it would have to come from Cognos data.

Log

2022-08-25 - added code to start sending this field to Centralized data.mdb 2021-06-17 - added this field to L_Log table in CCMDB data.mdb