Postal Code field: Difference between revisions

Line 49: Line 49:
* cross-checking our data's [[Province field]] for out-of-province patients
* cross-checking our data's [[Province field]] for out-of-province patients


== {{CCMDB Data Integrity Checks|implemented}} ==
== CCMDB Data Integrity Checks ==
Implemented in ''Function Validate_PostalCode()'' and ''Function is_valid_postalcode''
* [[Check Function Validate_PostalCode]]
* will reject empty field
* 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]]==