Postal Code field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
How to collect if there is no postal code. rolling out with next version.
cross-checks
Line 3: Line 3:
The [[Postal_Code field]] will contain [[Postal code collection]] data.
The [[Postal_Code field]] will contain [[Postal code collection]] data.


The field will move to a different tab probably, not sure yet how things will look when the old fields are all cleaned out. Thoughts? {{discussion}}
The field will move to a different tab probably, not sure yet how things will look when the old fields are all cleaned out.


== Collection Instruction ==
== Collection Instruction ==
Line 20: Line 20:
== {{CCMDB Data Integrity Checks}} ==
== {{CCMDB Data Integrity Checks}} ==
{{discussion}}
{{discussion}}
* will no longer need query ''s_tmp_Postal_duplicate''
* will reject empty field
Need to re-implement existing checks for this field.
* will reject invalid postal code
see also [[#postal code missing]]
* will reject invalid combinations of postal code and [[Province]].


== Implementation ==
== Implementation ==

Revision as of 14:28, 2016 May 5

This field is currently being implemented, please check the instructions and put a discussion for anything that isn't clear. 

The Postal_Code field will contain Postal code collection data.

The field will move to a different tab probably, not sure yet how things will look when the old fields are all cleaned out.

Collection Instruction

Enter the Postal code

  • no space
  • upper case letters
  • example only: X0X0X0

When the postal code is not available enter "N/A" or click the "N/A" button to enter it for you.

Special Cases

Consider special cases from Postal code collection for now, I will move those over here when we set the old field to legacy. Please comment here though if the instructions for old field would not work in new setup.

Data Use

Postal code collection will be moved to or referenced from here.

Template:CCMDB Data Integrity Checks

Template:Discussion

  • will reject empty field
  • will reject invalid postal code
  • will reject invalid combinations of postal code and Province.

Implementation

Legacy

Data started out being collected in the tmp field.