ClientVisitGUID field: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
|field_name=ClientVisitGUID | |field_name=ClientVisitGUID | ||
|CCMDB_label=N/A | |CCMDB_label=N/A | ||
|in_table= | |in_table=L_Log table | ||
|data_type=string | |data_type=string | ||
|datafield_length=16 | |datafield_length=16 | ||
|program_collecting=Med and CC | |program_collecting=Med and CC | ||
|created_raw=Raw | |created_raw=Raw | ||
|data_element_start_date = | |data_element_start_date=2022-08-29 | ||
|data_element_sort_index=1 | |data_element_sort_index=1.6 | ||
|element_description=Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data. | |element_description=Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data. | ||
}} | }} | ||
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. | 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. | 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 == | == Log == | ||
* 2022-08-25 - added code to start sending this field to [[ | * 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]] | * 2021-06-17 - added this field to [[L_Log table]] in [[CCMDB data.mdb]] | ||