Postal Code field: Difference between revisions

Line 50: Line 50:


== {{CCMDB Data Integrity Checks|implemented}} ==
== {{CCMDB Data Integrity Checks|implemented}} ==
Implemented:
Implemented in ''Function Validate_PostalCode()'' and ''Function is_valid_postalcode''
* will reject empty field  
* will reject empty field  
* will reject invalid postal code
* will reject invalid postal code (ie not PC Like "[A-X]#[A-Z]#[A-Z]#")
 
Cross-checks of PC against [[Province]] were implemented at some point but then discontinued due to false positives. ''Function pc_province_match''. Comments in there:
' 2016-07-25
' it was decided long ago not to check this by the steering committee because
' it gave false positives.
' 2016-11-14 emailed team to find out if we should revisit


==[[CFE]]-[[Postal code cross check]]==
==[[CFE]]-[[Postal code cross check]]==