CCMDB Wiki

PL SamePHIN Site Diff chart: Difference between revisions

← Older edit
m Text replacement - "{{DT" to "{{TT"
m Text replacement - "|DIC_LProblem=no" to "|DIC_LProblem=No"
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Another record exists for this [[Service/Location]] with the same [[PHIN ]] and a different [[Chart number]].
|DIC_summary=Another record exists for this site with the same [[PHIN]] and a different [[Chart number]].
|DIC_related_concepts=PHIN field; Service/Location field; Chart number
|DIC_related_concepts=PHIN field; Chart number
|DIC_firmness=hard check
|DIC_firmness=soft check
|DIC_timing=always
|DIC_coding=query PL_SamePHIN_Site_Diff_chart
|DIC_coding=query PL_SamePHIN_Site_Diff_chart
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=No
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
}}
This query compares the chart numbers and PHINs of profiles started in the last 30 days to any charts in our database.


{{TT | _dev_CFE 1
The query takes several minutes to run. Tina reviewed it 2021-07-15 and could not see further ways to streamline it.
this query has reached the 2GB limit, must see if I can lean it out or otherwise reduce the size }}
 
== Log ==
* 2022-04-13 - didn't have an explicit D_ID field so would not have worked with PatientList; wonder if it's been used at all
* 2021-07-15 - updated to overcome 2GB limit, it now only compares the required data components, and the second datset is only the last 30 days


== Related articles ==
== Related articles ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=PL_SamePHIN_Site_Diff_chart"