Query NDC Postal Code over time: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = Cross check of [[Postal Code field|postal codes]] for consistency during a continuous hospital admission | |DIC_summary=Cross check of [[Postal Code field|postal codes]] for consistency during a continuous hospital admission | ||
| DIC_related_concepts = Postal Code field | |DIC_related_concepts=Postal Code field | ||
| DIC_firmness = hard check | |DIC_firmness=hard check | ||
|DIC_coding=query ''NDC_Postal_Code_over_time'' | |||
|DIC_implementation_date=2020-01-09 | |||
| DIC_coding = query ''NDC_Postal_Code_over_time'' | |DIC_status=implemented | ||
|DIC_LProblem=No | |||
| DIC_implementation_date = 2020-01-09 | |DIC_app=Centralized data front end.accdb | ||
|DIC_backlogged=No | |||
}} | }} | ||
We compare the consistency of [[Postal Code field]] during a continuous hospital admission. Also see [[query NDC_Bad_Postal_Code]]. | |||
We compare the consistency of [[Postal Code field]] during a continuous hospital admission. | |||
== 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== | ||
2020- | 2020-01-09 | ||
Cleaning to start from the beginning of 2017 | Cleaning to start from the beginning of 2017 | ||
| Line 26: | Line 26: | ||
[[Category: Data Processing]] | [[Category:Data Processing]] | ||
[[Category: Postal Codes]] | [[Category:Postal Codes]] | ||
[[Category: Registry checks]] | [[Category:Registry checks]] | ||
Latest revision as of 10:55, 30 July 2025
| Data Integrity Checks | |
| Summary: | Cross check of postal codes for consistency during a continuous hospital admission |
| Related: | Postal Code field |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query NDC_Postal_Code_over_time |
| Uses L Problem table: | No |
| Status: | implemented |
| Implementation Date: | 2020-01-09 |
| Backlogged: | No |
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: |