PL SamePHIN Site Diff chart

From CCMDB Wiki
Jump to navigation Jump to search
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
  • 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.

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: