Query NDC Bad Postal Code

From CCMDB Wiki
Jump to navigation Jump to search

What is it?

Is an mdb that has a list of all postal codes in the province of Manitoba

Where was it obtain

From Randy Martens to Julie Mojica

Current Location

X:\CCMDB\PostalCode\Postal_Code_Checker_Master.mdb

What are we doing with it?

  • Made a query for the bad PostalCode today with Tina.
    • Find out that we have 621 problem records includes blanks and incorrect PostalCode.
      • No decision made yet how to fix the problem.

PTorres 13:16, 2014 September 29 (CDT)

  • Plan include in the CFE for the main office and have and NDC for the weekly vetting process
    • Tina to hook into CFE so Pagasa can run weekly AND also update Master Postal code checker.mdb.
  • Outlook Appointment set up for Monday Sept 29 with Pagasa.Trish Ostryzniuk 17:38, 2014 September 24 (CDT)

Start Date

Template:Potential Change