PL SamePHIN Site Diff chart: Difference between revisions
Ttenbergen (talk | contribs) Created page with "{{Data Integrity Check}}" |
Ttenbergen (talk | contribs) m Text replacement - "|DIC_LProblem=no" to "|DIC_LProblem=No" |
||
| (12 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check}} | {{Data Integrity Check | ||
|DIC_summary=Another record exists for this site with the same [[PHIN]] and a different [[Chart number]]. | |||
|DIC_related_concepts=PHIN field; Chart number | |||
|DIC_firmness=soft check | |||
|DIC_timing=always | |||
|DIC_coding=query PL_SamePHIN_Site_Diff_chart | |||
|DIC_status=implemented | |||
|DIC_LProblem=No | |||
|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. | |||
The query takes several minutes to run. Tina reviewed it 2021-07-15 and could not see further ways to streamline it. | |||
== 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}} | |||
[[Category:Registry checks]] | |||
[[Category:PL queries]] | |||
[[Category:Data Processing]] | |||