Postal Code Master table: Difference between revisions

(7 intermediate revisions by the same user not shown)

Line 1:

{{DISPLAYTITLE:Postal_Code_Master table}}Postal_Code_Master table in [[[[Centralized data.accdb]]]] is used by [[query NDC_Bad_Postal_Code]] to detect by exclusion [[Postal Code]] entries that are likely invalid.

{{DISPLAYTITLE:Postal_Code_Master table}}Postal_Code_Master table in [[Centralized data.accdb]] is used by [[query NDC_Bad_Postal_Code]] to detect by exclusion [[Postal Code]] entries that are likely invalid.

The table on its own would be about 71MB, (30MB with all extra info stripped out) which is why the check was not included in [[CCMDB.accdb]].

Line 12:

|| '''PCODE''' || text(6) || the postal code

|-

|| rhaname || text(17) || name of ~~regional health authority~~ that the postal code is in

|| rhaname || text(17) || name of [[Manitoba RHAs]] that the postal code is in

|-

|| CA_name || text(22) ||

Line 39:

== Data Integrity Checks ==

~~{{Discuss | JALT~~

Management of this table has always been driven only by resolving inconsistencies [[query NDC_Bad_Postal_Code]]; our [[Data Processor]] updates Master when she finds that a previously unused code shows up in our data and is found to exist on the Canada Post website. See [[Query NDC_Bad_Postal_Code#CFE Data Integrity Checks Steps]].

* Management of this table has always been driven only by resolving inconsistencies [[query NDC_Bad_Postal_Code]], and ~~there have not~~ been ~~cross checks for this table itself~~. We ~~found 2025-06 that there were inconsistencies between postal codes and province entries in~~ this ~~table~~, ~~and Pagasa~~ found ~~duplicate postal codes~~. ~~Also, we do not~~ have a ~~central process to update~~ postal ~~codes as new ones are added to the system~~. Do we ~~need~~ a ~~formal~~ process? ~~Is the current ad-hoc process enough~~. ~~Or do we need a decision on allowing these inconsistencies and just documenting them?~~ [[User:Ttenbergen|Ttenbergen]] 15~~:55~~, ~~24 June~~ 2025 (CDT)

== Maintenance and Validation of Master table ==

We maintain our own [[Postal_Code_Master table]] because access to a canonical record set has always been problematic. We have at times received copies of this data, but not found a source for regular updates.

We have a directory with various postal code lists we have used for comparison over time at

* {{S:\MED\MED CCMED|CCMDB_Special_Projects\PostalCode}}

The file '''''!ReadMe Postal Code Data.docx''''' in that directory has additional information.

{{DJ |

* Do we want a regular update process? See comments in that file. [[User:Ttenbergen|Ttenbergen]] 12:15, 4 August 2025 (CDT)

}}

@@ Line 1: / Line 1: @@
-{{DISPLAYTITLE:Postal_Code_Master table}}Postal_Code_Master table in [[[[Centralized data.accdb]]]] is used by [[query NDC_Bad_Postal_Code]] to detect by exclusion [[Postal Code]] entries that are likely invalid.
+{{DISPLAYTITLE:Postal_Code_Master table}}Postal_Code_Master table in [[Centralized data.accdb]] is used by [[query NDC_Bad_Postal_Code]] to detect by exclusion [[Postal Code]] entries that are likely invalid.
 The table on its own would be about 71MB, (30MB with all extra info stripped out) which is why the check was not included in [[CCMDB.accdb]].
@@ Line 12: / Line 12: @@
 || '''PCODE''' || text(6) || the postal code
 |-
-|| rhaname || text(17) || name of regional health authority that the postal code is in
+|| rhaname || text(17) || name of [[Manitoba RHAs]] that the postal code is in
 |-
 || CA_name || text(22) ||
@@ Line 39: / Line 39: @@
 == Data Integrity Checks ==
-{{Discuss | JALT
+Management of this table has always been driven only by resolving inconsistencies [[query NDC_Bad_Postal_Code]]; our [[Data Processor]] updates Master when she finds that a previously unused code shows up in our data and is found to exist on the Canada Post website. See [[Query NDC_Bad_Postal_Code#CFE Data Integrity Checks Steps]].
-* Management of this table has always been driven only by resolving inconsistencies [[query NDC_Bad_Postal_Code]], and there have not been cross checks for this table itself. We found 2025-06 that there were inconsistencies between postal codes and province entries in this table, and Pagasa found duplicate postal codes. Also, we do not have a central process to update postal codes as new ones are added to the system. Do we need a formal process? Is the current ad-hoc process enough. Or do we need a decision on allowing these inconsistencies and just documenting them? [[User:Ttenbergen|Ttenbergen]] 15:55, 24 June 2025 (CDT)
+== Maintenance and Validation of Master table ==
+We maintain our own [[Postal_Code_Master table]] because access to a canonical record set has always been problematic. We have at times received copies of this data, but not found a source for regular updates.
+We have a directory with various postal code lists we have used for comparison over time at
+* {{S:\MED\MED CCMED|CCMDB_Special_Projects\PostalCode}}
+The file '''''!ReadMe Postal Code Data.docx''''' in that directory has additional information.
+{{DJ |
+* Do we want a regular update process? See comments in that file. [[User:Ttenbergen|Ttenbergen]] 12:15, 4 August 2025 (CDT)
 }}