ClientVisitGUID field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 2: | Line 2: | ||
|field_name=ClientVisitGUID | |field_name=ClientVisitGUID | ||
|CCMDB_label=N/A | |CCMDB_label=N/A | ||
|in_table=Cognos_import3 table | |in_table=Cognos_import3 table, L_Log table | ||
|data_type=string | |data_type=string | ||
|datafield_length=16 | |datafield_length=16 | ||
Revision as of 11:15, 24 May 2023
| Data Element (edit) | |
| Field Name: | ClientVisitGUID |
| CCMDB Label: | N/A |
| CCMDB tab: | not stated |
| Table: | Cognos_import3 table, L_Log 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 |
| Data Dependencies(Reports/Indicators/Data Elements): | No results |
Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.
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