Query NDC Bad Postal Code

We cross-check the postal codes we collect as part of Postal Code field collection against a list of known-good postal codes.

Template:CFE Data Integrity Checks Steps

Comparison

Comparisons are done as part of vetting via NDC query NDC_Bad_Postal_Code in CFE. Steps will be:

<we need to fill these in when we have completed the first-time updates, we deferred decision on the steps today to when we have done partial cleaning and know how much is left.>

... when you update Table Postal_Code_Master you only need to fill in the fields postal code, town and MB_RHA, we will eliminate the other fields.

updating the codes

Codes are stored in Table Postal Code Master. Codes can be manually added to or imported into this table when a new master set becomes available.

File Locations

old master imports can be found at X:\CCMDB\z_archive\PostalCode

Where was it obtained

• From Randy Martens to Julie Mojica

integrated with

• http://geocoder.ca/?freedata=1

Wikipedia Postal codes listings across Canada

Wikipedia, Postal codes in Canada

• at the top of the article shows the the first letter that a postal code starts with for a province.

Map showing first letter used in postal codes across Canada

RHA Listings

• see Manitoba RHAs

Start Date

2014-09-29 Cleaning to start end of August 2016

Outside Province Postal Code

• • If the first letter is not correct you need to check EPR or internet to put the correct Postal code.
    • If the first letter is correct dont need to check and find out the exact Postal code leave it.
      • If you cannot find the Postal code and not in the Postal Code Master list put in the L_problem list(means you seen it true error )

````