ClientGUID field: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 23: | Line 23: | ||
* Lisa, any idea why this might be happening from a collection perspective? Is the problem in what we receive the right info from Cognos, or is there an issue in the collection process that makes this happen? [[User:Ttenbergen|Ttenbergen]] 09:52, 2024 December 5 (CST) | * Lisa, any idea why this might be happening from a collection perspective? Is the problem in what we receive the right info from Cognos, or is there an issue in the collection process that makes this happen? [[User:Ttenbergen|Ttenbergen]] 09:52, 2024 December 5 (CST) | ||
* Julie, do we need to flag anywhere further that this data is suspect? [[User:Ttenbergen|Ttenbergen]] 09:52, 2024 December 5 (CST) | * Julie, do we need to flag anywhere further that this data is suspect? [[User:Ttenbergen|Ttenbergen]] 09:52, 2024 December 5 (CST) | ||
}} | }} | ||
{{Collapsable | always=Query: | full= . | |||
SELECT PCG_duplicates.Person_ID, PCG_duplicates.CountOfClientGUID, L_Log.D_ID, L_Log.ClientGUID, L_Log.Visit_Admit_DtTm | |||
FROM (SELECT PCG_pairs.Person_ID, Count(PCG_pairs.ClientGUID) AS CountOfClientGUID | |||
FROM (SELECT DISTINCT L_Log.Person_ID, L_Log.ClientGUID | |||
FROM L_Log | |||
WHERE (((L_Log.[RecordStatus])="vetted") AND ((L_Log.[Dispo_DtTm])>=#1/1/2022#) AND ((L_Log.[ClientGUID]) Is Not Null)) ) AS PCG_pairs | |||
GROUP BY PCG_pairs.Person_ID | |||
HAVING (((Count(PCG_pairs.ClientGUID))>1)) ) AS PCG_duplicates INNER JOIN L_Log ON PCG_duplicates.Person_ID = L_Log.Person_ID | |||
WHERE (((L_Log.ClientGUID) Is Not Null)) | |||
ORDER BY PCG_duplicates.Person_ID, L_Log.ClientGUID; | |||
}} | |||
==== Data that is entered without a ClientGUID ==== | ==== Data that is entered without a ClientGUID ==== | ||