Query NDC Bad Postal Code: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
PTorres (talk | contribs)
PTorres (talk | contribs)
Line 9: Line 9:


==What are we doing with it?==
==What are we doing with it?==
Made a query for the bad PostalCode today with Tina.
*Made a query for the bad PostalCode today with Tina.
Find out that we have 621 records includes blanks and incorrect PostalCode.
**Find out that we have 621 problem records includes blanks and incorrect PostalCode.
No decision made yet how to fix the problem.
***No decision made yet how to fix the problem.
 
[[User:PTorres|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
*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.
**Tina to hook into [[CFE]] so Pagasa can run weekly AND also update Master Postal code checker.mdb.

Revision as of 12:16, 29 September 2014

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