{"id":2485,"date":"2012-08-14T18:52:03","date_gmt":"2012-08-14T22:52:03","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=2485"},"modified":"2017-11-06T12:47:02","modified_gmt":"2017-11-06T17:47:02","slug":"data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/","title":{"rendered":"Data Masking: Masking Social Security and other National IDs"},"content":{"rendered":"

Data masking<\/a> is one method to combat the nearly 72,000 documented breaches of personally identifiable information (PII) that occur every day. With data privacy breaches<\/a> still at unacceptably high levels, how can companies protect PII such as their national ID numbers across their myriad sources of data?<\/p>\n

IRI’s data masking solutions are delivered in the FieldShield<\/a> product. FieldShield is a uniquely powerful data-centric security tool that shields fields in ODBC-connected database tables and most (very large) flat file formats. FieldShield allows compliance teams and DBAs to choose a specific data privacy function for each field, based on potential recipients and each field’s need for security, realism, and recoverability.<\/p>\n

If the column value needs to be secured now but recovered later, an encryption routine makes sense. If the value is numeric and needs to look real, a FieldShield user could choose a format-preserving encryption algorithm. If the field were a person’s name, a pseudonym function would work better. However, if the data need to be totally secure and not recovered, then masking all, or part of that field with characters like a* or x would be more appropriate.<\/p>\n

In the United States, it is common to see the ‘x’ data masking character for social security and credit card numbers.\u00a0 The IRI Workbench GUI for FieldShield<\/a> offers pre-defined masks for multiple national ID numbers, credit card numbers (12 digits), and whole-field redaction where all field digits are replaced.<\/p>\n

FieldShield users can also customize their data masking behavior using offset values, offset lengths, and desired data masking characters. Consider the following input sample, where the third field may be a national identification card number:<\/p>\n

Robert,07\/01\/1969,ABC12345\r\nDonald,11\/21\/1966,DEF34567\r\nPeter,05\/31\/1955,GHI56789\r\nMary,12\/01\/1989,JKL90123\r\nJill,03\/28\/2001,MNO45678<\/span><\/pre>\n
That third field, called ID_CODE, could be masked as shown in this FieldShield dialog editor for data masking:<\/p>\n
\"\"<\/a><\/p>\n
Here is an output sample with data masking applied:<\/p>\n
Robert,07\/01\/1969,^^^12@@@
\nDonald,11\/21\/1966,^^^34@@@
\nPeter,05\/31\/1955,^^^56@@@
\nMary,12\/01\/1989,^^^90@@@
\nJill,03\/28\/2001,^^^45@@@<\/span><\/p>\n
While social security and credit card number masking have been the most common requirements that IRI is called to address, FieldShield also supports data masking functions for other national ID numbers in their native formats:<\/p>\n
\"NID<\/a><\/p>\n
We invite our customers and resellers outside the United States to suggest or request the development of more pre-defined masks that satisfy either national ID formats or specific business needs. Any data privacy masks we create can be added to our library and included in the IRI Workbench for front-end selection.<\/p>\n
Leave a comment below, or contact us at fieldshield@iri.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
Data masking is one method to combat the nearly 72,000 documented breaches of personally identifiable information (PII) that occur every day. With data privacy breaches still at unacceptably high levels, how can companies protect PII such as their national ID numbers across their myriad sources of data? IRI’s data masking solutions are delivered in the<\/p>\n
Read More<\/a><\/div>\n","protected":false},"author":9,"featured_media":6958,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[858,859],"class_list":["post-2485","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","tag-date-masking","tag-ssn-data-masking"],"acf":[],"yoast_head":"\nData Masking: Masking Social Security and other National IDs - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Masking: Masking Social Security and other National IDs - IRI\" \/>\n<meta property=\"og:description\" content=\"Data masking is one method to combat the nearly 72,000 documented breaches of personally identifiable information (PII) that occur every day. With data privacy breaches still at unacceptably high levels, how can companies protect PII such as their national ID numbers across their myriad sources of data? IRI’s data masking solutions are delivered in theRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-14T22:52:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-06T17:47:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"511\" \/>\n\t<meta property=\"og:image:height\" content=\"586\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Rob Howard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rob Howard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/\"},\"author\":{\"name\":\"Rob Howard\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/2b9e439554aaae94b5d95f2a60960b24\"},\"headline\":\"Data Masking: Masking Social Security and other National IDs\",\"datePublished\":\"2012-08-14T22:52:03+00:00\",\"dateModified\":\"2017-11-06T17:47:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/\"},\"wordCount\":411,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg\",\"keywords\":[\"date masking\",\"ssn data masking\"],\"articleSection\":[\"Data Masking\/Protection\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/\",\"name\":\"Data Masking: Masking Social Security and other National IDs - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg\",\"datePublished\":\"2012-08-14T22:52:03+00:00\",\"dateModified\":\"2017-11-06T17:47:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg\",\"width\":511,\"height\":586},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Masking: Masking Social Security and other National IDs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/2b9e439554aaae94b5d95f2a60960b24\",\"name\":\"Rob Howard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecbf077139a1916a46ef758d91956312?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecbf077139a1916a46ef758d91956312?s=96&d=blank&r=g\",\"caption\":\"Rob Howard\"},\"url\":\"https:\/\/beta.iri.com\/blog\/author\/robh\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Masking: Masking Social Security and other National IDs - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/","og_locale":"en_US","og_type":"article","og_title":"Data Masking: Masking Social Security and other National IDs - IRI","og_description":"Data masking is one method to combat the nearly 72,000 documented breaches of personally identifiable information (PII) that occur every day. With data privacy breaches still at unacceptably high levels, how can companies protect PII such as their national ID numbers across their myriad sources of data? IRI’s data masking solutions are delivered in theRead More","og_url":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/","og_site_name":"IRI","article_published_time":"2012-08-14T22:52:03+00:00","article_modified_time":"2017-11-06T17:47:02+00:00","og_image":[{"width":511,"height":586,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg","type":"image\/jpeg"}],"author":"Rob Howard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rob Howard","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/"},"author":{"name":"Rob Howard","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/2b9e439554aaae94b5d95f2a60960b24"},"headline":"Data Masking: Masking Social Security and other National IDs","datePublished":"2012-08-14T22:52:03+00:00","dateModified":"2017-11-06T17:47:02+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/"},"wordCount":411,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg","keywords":["date masking","ssn data masking"],"articleSection":["Data Masking\/Protection"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/","url":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/","name":"Data Masking: Masking Social Security and other National IDs - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg","datePublished":"2012-08-14T22:52:03+00:00","dateModified":"2017-11-06T17:47:02+00:00","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg","width":511,"height":586},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/data-protection\/data-privacy-with-fieldshield-masking-dates-and-other-important-data-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Masking: Masking Social Security and other National IDs"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/2b9e439554aaae94b5d95f2a60960b24","name":"Rob Howard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecbf077139a1916a46ef758d91956312?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecbf077139a1916a46ef758d91956312?s=96&d=blank&r=g","caption":"Rob Howard"},"url":"https:\/\/beta.iri.com\/blog\/author\/robh\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/03\/mask_nidwmenu.jpg","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/2485"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=2485"}],"version-history":[{"count":58,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/2485\/revisions"}],"predecessor-version":[{"id":11243,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/2485\/revisions\/11243"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/6958"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=2485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=2485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=2485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}