Data Masking Components: State Province Dynamic
  • Request Trial Request
    a trial
  • Request Demo Request
    a demo
  • Request Quote Request
    a quote
Search
OpenNavigationArticle
SSIS Data Masking Components
OpenNavigationArticle
Open Navigation Article
Data Masking Components: State Province Dynamic
  • Request Trial Request
    a trial
  • Request Demo Request
    a demo
  • Request Quote Request
    a quote

State Province Dynamic


Purpose

This component identifies whether a value represents a U.S. state or Canadian province and substitutes it with a corresponding value from a valid list, based on the appropriate country. The component validates input values against the ISO 3166-2 standard for country subdivisions, which defines official codes for U.S. states (US-XX) and Canadian provinces (CA-XX).

Key Behaviors:

  • Determines if the input is a U.S. state or Canadian province
  • Substitutes values using the corresponding list of valid state/province names or codes
  • Preserves the original format (e.g., full name or abbreviation)

The Dynamic version maintains referential integrity by ensuring the same original value always maps to the same masked value within the dataset. The mapping is not one-to-one—multiple original values may be grouped and replaced with a shared substitute, supporting consistent anonymization while reducing reversibility.

Algorithm

Variation of Random Character Permutation Algorithm

TutorialIcon Go to Tutorial

Data Masking Components: State Province Dynamic

DownloadUserGuide Download Manual
About Hush-Hush Contact Us

E-mail: info@mask-me.net

tel: 855.968.4874

Privacy Policy Terms of Use