PL SamePHIN Site Diff chart: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
Line 2: | Line 2: | ||
|DIC_summary=Another record exists for this site 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; Chart number | |DIC_related_concepts=PHIN field; Chart number | ||
|DIC_firmness= | |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_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. | This query compares the chart numbers and PHINs of profiles started in the last 30 days to any charts in our database. | ||
Revision as of 13:37, 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: | soft 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: | 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.
Related articles
Related articles: |
|