Postal code collection: Difference between revisions

TOstryzniuk (talk | contribs)
{{CCMDB Data Integrity Checks}}: integrity checks changed.
Line 33: Line 33:


== {{CCMDB Data Integrity Checks}} ==
== {{CCMDB Data Integrity Checks}} ==
Unlike other tmp entries, this entry is not checked as part of the pre-send checker.
Unlike other tmp entries, this entry is not checked as part of the pre-send checker, it is sent when checking TMP complete.  
* international postal codes are not allowed.
PC must be '''''one ''of the following'''
* entry must be structured like a proper postal code:
* blank postal code, postal code missing check box checked
** must be in UPPER case
* postal code missing check box '''''un'''''checked and letter number letter number letter number  
** no spaces allowed
** must be letter number letter number letter number  
** example only: ''X1X1X1''
** example only: ''X1X1X1''
confirmed 2014-Jul-07 that this check will prevent final-check for tmp when no postal code is entered.


=== province - PC consistency ===
We used to have a consistency check between province and postal code. It was eliminated because there are weird special cases where consistency between province, PHIN and postal code gave false-positives. The check between PHIN and Province is more important for us, so we eliminated the check for PC vs Province.
== other integrity checks ==
== other integrity checks ==
see [[Postal code cross check]]
see [[Postal code cross check]]