Query NDC Postal Code over time: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
PTorres (talk | contribs)
PTorres (talk | contribs)
Line 14: Line 14:
== CFE Data Integrity Checks Steps ==
== CFE Data Integrity Checks Steps ==
Comparisons are done after [[vetting]] via NDC query ''NDC_Postal_Code_over_time'' in [[CFE]].
Comparisons are done after [[vetting]] via NDC query ''NDC_Postal_Code_over_time'' in [[CFE]].
Steps will be:  
*Steps will be:


==Start Date==
==Start Date==

Revision as of 13:44, 2020 January 9

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 entered
Status: implemented
Implementation Date: 2020-01-09
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

We compare the consistency of Postal Code field during a continuous hospital admission.

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