Postal Code Master table: Difference between revisions

Revision as of 19:33, 2022 August 31

Postal_Code_Master table in Centralized_data.mdb 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.

field	type	description
PCODE	text(6)	the postal code
rhacode	text(17)	code of regional health authority that the postal code is in
rhaname	text(22)	name of regional health authority that the postal code is in
CA	text(27)
CA_name	text(255)
NC	text(255)
NC_Name	text(255)
latitude	number(single)
longitude	number(single)
province	text(4)
town	text(40)

@@ Line 10: / Line 10: @@
 !| description
 |-
-|| '''PCODE''' || text(255) || the postal code
+|| '''PCODE''' || text(6) || the postal code
 |-
-|| rhacode || text(255)|| code of regional health authority that the postal code is in
+|| rhacode || text(17)|| code of regional health authority that the postal code is in
 |-
-|| rhaname || text(255) || name of regional health authority that the postal code is in
+|| rhaname || text(22) || name of regional health authority that the postal code is in
 |-
-|| CA || text(255) ||
+|| CA || text(27) ||
 |-
 || CA_name || text(255) ||
@@ Line 24: / Line 24: @@
 || NC_Name|| text(255) ||
 |-
-|| latitude || number(double) ||
+|| latitude || number(single) ||
 |-
-|| longitude || number(double) ||
+|| longitude || number(single) ||
 |-
-|| province || text(255) ||
+|| province || text(4) ||
 |-
-|| town || text(255) ||
+|| town || text(40) ||
 |}
+== Log ==
+* 2022-08-?? - made field sizes smaller / more appropriate recently
 == Contents ==