PL SamePHIN Site Diff chart: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "{{DT" to "{{TT")
mNo edit summary
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=hard check
|DIC_coding=query PL_SamePHIN_Site_Diff_chart
|DIC_coding=query PL_SamePHIN_Site_Diff_chart
Line 8: Line 8:
}}
}}


{{TT | _dev_CFE 1
This query compares the chart numbers and PHINs of profiles started in the last 30 days to any charts in our database.
this query has reached the 2GB limit, must see if I can lean it out or otherwise reduce the size }}
 
The query takes several minutes to run. Tina reviewed it 2021-07-15 and could not see further ways to streamline it.


== Related articles ==
== Related articles ==

Revision as of 13:36, 2021 July 15

Data Integrity Checks
Summary: Another record exists for this site with the same PHIN and a different Chart number.
Related: PHIN field, Chart number
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query PL_SamePHIN_Site_Diff_chart
Uses L Problem table: not entered
Status: implemented
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

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.

Related articles

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