Edit data element info: ClientVisitGUID field

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Field Name:
CCMDB Label:
CCMDB tab:
Table:
Data Type:
Length (single, double, byte, integer, long integer, or the string size):
Program:
Created/Raw:
Start Date:
End Date:
Sort Index:
Element Description:

unstructured part of page:

The {{PAGENAME}} 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. == Blank CliendVisitGUIDs == The same scenarios as [[ClientGUID field#Concerns]] could lead to missing lines here. == Log == * 2022-08-25 - added code to start sending this field to [[Centralized_data.accdb]] * 2021-06-17 - added this field to [[L_Log table]] in [[CCMDB data.mdb]] [[Category:Multiple Encounter]] [[Category:Multiple Encounter linking]] [[Category:Multiple encounter finding and confirmation]] [[Category:Cognos2]]

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel

Created_Variables_CC_2021 table
Created_Variables_Common_2021 table
L Como table
L Dxs table
L ICD10 table
L Labs Flowsheet table
L Log table
L PCH table
L Person table
L PHI table
L TISS Form table
L TISS Item table
L TmpV2 table
L_CCI_Component table
L_CCI_Picklist table
L_Como table
L_Dxs table
L_ICD10 table
L_Labs_DSM table
L_Labs_Flowsheet table
L_Log table
L_PCH table
L_Pharm_Flowsheet table
L_PHI table
L_TISS_Form table
L_TISS_Item table
L_TISS76 table
L_TmpV2 table
s_dispo table
s_ICD10 table