Check Function Validate PostalCode

From CCMDB Wiki
Jump to navigationJump to search
Data Integrity Checks
Summary: Validates that Postal Code field only contains characters in format allowed for a postal code
Related: Postal Code field
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: Function Validate_PostalCode
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2016-03-24
Backlogged: true


  • Cargo


  • SMW


  • Categories: 

Implementation date was earlier than that when we had this in a tmp field; it has been checked for longer than this.

Implemented in Function Validate_PostalCode() and Function is_valid_postalcode

  • will reject empty field
  • will reject invalid postal code (ie not PC Like "[A-X]#[A-Z]#[A-Z]#")

Declined portion of checks

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


Related articles

Related articles: