Difference between revisions of "Query NDC Postal Code over time"

From CCMDB Wiki
Jump to navigationJump to search
m
 
Line 10: Line 10:
 
}}
 
}}
  
We compare the consistency of [[Postal Code field]] during a continuous hospital admission.
+
We compare the consistency of [[Postal Code field]] during a continuous hospital admission. Also see [[query NDC_Bad_Postal_Code]].
  
 
== CFE Data Integrity Checks Steps ==
 
== CFE Data Integrity Checks Steps ==

Latest revision as of 14:15, 2020 January 15

Data Integrity Checks
Summary: Cross check of postal codes for consistency during a continuous hospital admission
Related: Postal Code field
Firmness: hard check
Timing:
App: Centralized data front end.accdb
Coding: query NDC_Postal_Code_over_time
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2020-01-09
Backlogged: true


  • Cargo


  • SMW


  • Categories: 

We compare the consistency of Postal Code field during a continuous hospital admission. Also see query NDC_Bad_Postal_Code.

CFE Data Integrity Checks Steps

Comparisons are done after vetting via NDC query NDC_Postal_Code_over_time in CFE.

  • Steps will be:

Start Date

2020-01-09 Cleaning to start from the beginning of 2017

Related articles

Related articles:

Query NDC Bad Postal Code