Edit Data Integrity Check: PL SamePHIN Site Diff chart

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Summary (what is the check, one-liner):
links to related pages:
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown hard check soft check
Timing (does this query run for all records or only complete ones):	None/unknown complete always
Name of the function or query this is implemented as:	query PL_SamePHIN_Site_Diff_chart
Implementation date:
Implementation Status:
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown Yes No
App:
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

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]]

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel