Query NDC Postal Code over time: Difference between revisions
Jump to navigation
Jump to search
(New Query for Postal code consistency) |
|||
| Line 22: | Line 22: | ||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Query NDC Bad Postal Code]] | |||
[[Category: Data Processing]] | [[Category: Data Processing]] | ||
[[Category: Postal Codes]] | [[Category: Postal Codes]] | ||
[[Category: Registry checks]] | [[Category: Registry checks]] | ||
Revision as of 14:42, 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 |
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-001-09 Cleaning to start from the beginning of 2017
Related articles
| Related articles: |