{"id":4200,"date":"2012-08-06T18:51:02","date_gmt":"2012-08-06T22:51:02","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=4200"},"modified":"2019-04-12T07:52:40","modified_gmt":"2019-04-12T11:52:40","slug":"netherlands-social-fiscal","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/","title":{"rendered":"Generating Test NID Data: Netherlands BSN"},"content":{"rendered":"<p>The Netherlands uses a method to identify their citizens called the\u00a0Burgerservicenummer, or BSN. This has replaced the SoFi number. If you would like more information about the SoFi number, refer to the SoFi section below.<\/p>\n<p><strong>BSN<\/strong><\/p>\n<p>The BSN\u00a0is used in much the same way as the United States Social Security Number, and consists of 9 digits in the format:<\/p>\n<pre>NNNNNNNNN<\/pre>\n<p>Each number is generated randomly with the last digit being a &#8220;check digit.&#8221; The entire number conforms to a technique known as the &#8220;11 check&#8221;.<\/p>\n<p>IRI has created a new library function for <a href=\"http:\/\/www.iri.com\/products\/rowgen\" target=\"_blank\" rel=\"noopener\">IRI RowGen<\/a> users who wish to generate computationally valid test BSN\u00a0numbers. The would invoke the function in a RowGen job that might look like this:<\/p>\n<pre>\/INFILE=RowGen_BSN.placeholder.in\r\n   \/ALIAS=RGBSN\r\n   \/PROCESS=RANDOM\r\n   \/INCOLLECT=1  # Number of records to produce\r\n   \/FIELD=(NATID=natid_gen_netherlands_bsn(), TYPE=ASCII, POSITION=1,\r\n          SEPARATOR=\"\\n\")\r\n\/REPORT\r\n\/OUTFILE=stdout\r\n   \/PROCESS=RECORD\r\n   \/FIELD=(NATID, TYPE=ASCII, POSITION=1, SEPARATOR=\"\\t\")\r\n\r\n<\/pre>\n<p>The output from this routine is:<br \/>\n269740533<\/p>\n<p>Note the sample specification above\u00a0for creating a properly formatted BSN:<\/p>\n<pre>\/FIELD=(FieldName=natid_gen_netherlands_bsn(), TYPE=ASCII, POSITION=1, SEPARATOR=\"\\t\")<\/pre>\n<p>where:<\/p>\n<ul>\n<li><span style=\"line-height: 13px;\">FieldName is the desired name for the field<\/span><\/li>\n<li>\/INCOLLECT determines the number of test values (record) to generate. Multiple output targets (files and tables) can be defined.<\/li>\n<li>There are no parameters for the function because there is no personal information used to generate the BSN<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>SoFi Number<\/strong><\/p>\n<p>The Netherlands&#8217; former number for citizen identification was\u00a0the Social Fiscal number (Sofinummer) or Sofi number. This number was\u00a0used in much the same way as the United States Social Security Number (<a href=\"http:\/\/www.iri.com\/blog\/test-data\/united-states-social-security-number\/\" target=\"_blank\" rel=\"noopener\">US SSN<\/a>), and consists of 9 digits in the format:<\/p>\n<pre>NNNNNNNNN<\/pre>\n<p>Each number is unique and contains personally-identifying information (PII), such as birth date or gender. All numbers conform to a technique called the &#8220;11 check.&#8221;<\/p>\n<p>IRI also has a\u00a0library function for\u00a0<a title=\"RowGen Test Data Generation Software\" href=\"http:\/\/www.iri.com\/products\/rowgen\" target=\"_blank\" rel=\"nofollow noopener\">IRI RowGen<\/a>\u00a0users who wish to generate valid Sofi numbers. The user would invoke the function in a job script that might look like this:<\/p>\n<pre>\/INFILE=RowGen_Sofi_valid.placeholder.in\r\n   \/ALIAS=RGSofi\r\n   \/PROCESS=RANDOM\r\n   \/INCOLLECT=1  # Number of records to produce\r\n   \/FIELD=(NATID=natid_gen_netherlands_sofi(), TYPE=ASCII, POSITION=1,\r\n          SEPARATOR=\"\\n\")\r\n\/REPORT\r\n\/OUTFILE=stdout\r\n   \/PROCESS=RECORD\r\n   \/FIELD=(NATID, TYPE=ASCII, POSITION=1, SEPARATOR=\"\\t\")<\/pre>\n<p>The output from this routine is:<br \/>\n004954932<\/p>\n<p>The specification\u00a0for creating a properly formatted Sofi number\u00a0above,<\/p>\n<pre>\/FIELD=(FieldName=natid_gen_netherlands_sofi(), TYPE=ASCII, POSITION=1, SEPARATOR=\"\\t\")<\/pre>\n<p>shows that:<\/p>\n<ul>\n<li><span style=\"line-height: 13px;\">FieldName is the desired name for the field<\/span><\/li>\n<li>\/INCOLLECT determines the number of test values (record) to generate. Multiple output targets (files and tables) can be defined.<\/li>\n<li>There are no parameters for the function because there is no personal information used to generate the Social Fiscal number<\/li>\n<\/ul>\n<p>If you are interested in using either of these functions in RowGen, please contact your IRI representative.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Netherlands uses a method to identify their citizens called the\u00a0Burgerservicenummer, or BSN. This has replaced the SoFi number. If you would like more information about the SoFi number, refer to the SoFi section below. BSN The BSN\u00a0is used in much the same way as the United States Social Security Number, and consists of 9<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/\" title=\"Generating Test NID Data: Netherlands BSN\">Read More<\/a><\/div>\n","protected":false},"author":20,"featured_media":11887,"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":[29],"tags":[323],"class_list":["post-4200","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-test-data","tag-hotmail"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Generating Test NID Data: Netherlands BSN - 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:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Generating Test NID Data: Netherlands BSN\" \/>\n<meta property=\"og:description\" content=\"The Netherlands uses a method to identify their citizens called the\u00a0Burgerservicenummer, or BSN. This has replaced the SoFi number. If you would like more information about the SoFi number, refer to the SoFi section below. BSN The BSN\u00a0is used in much the same way as the United States Social Security Number, and consists of 9Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-06T22:51:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-12T11:52:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"625\" \/>\n\t<meta property=\"og:image:height\" content=\"461\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Zachary McHenry\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zachary McHenry\" \/>\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:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/\"},\"author\":{\"name\":\"Zachary McHenry\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/78eba25b0948cc80568f172c56e99745\"},\"headline\":\"Generating Test NID Data: Netherlands BSN\",\"datePublished\":\"2012-08-06T22:51:02+00:00\",\"dateModified\":\"2019-04-12T11:52:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/\"},\"wordCount\":369,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg\",\"keywords\":[\"hotmail\"],\"articleSection\":[\"Test Data\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/\",\"url\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/\",\"name\":\"Generating Test NID Data: Netherlands BSN - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg\",\"datePublished\":\"2012-08-06T22:51:02+00:00\",\"dateModified\":\"2019-04-12T11:52:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg\",\"width\":625,\"height\":461,\"caption\":\"dutch t-rex passport\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Generating Test NID Data: Netherlands BSN\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.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:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/78eba25b0948cc80568f172c56e99745\",\"name\":\"Zachary McHenry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f783b98096dabe202c36c6ab81417f89?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f783b98096dabe202c36c6ab81417f89?s=96&d=blank&r=g\",\"caption\":\"Zachary McHenry\"},\"sameAs\":[\"http:\/\/www.iri.com\"],\"url\":\"https:\/\/www.iri.com\/blog\/author\/zachm\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Generating Test NID Data: Netherlands BSN - 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:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/","og_locale":"en_US","og_type":"article","og_title":"Generating Test NID Data: Netherlands BSN","og_description":"The Netherlands uses a method to identify their citizens called the\u00a0Burgerservicenummer, or BSN. This has replaced the SoFi number. If you would like more information about the SoFi number, refer to the SoFi section below. BSN The BSN\u00a0is used in much the same way as the United States Social Security Number, and consists of 9Read More","og_url":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/","og_site_name":"IRI","article_published_time":"2012-08-06T22:51:02+00:00","article_modified_time":"2019-04-12T11:52:40+00:00","og_image":[{"width":625,"height":461,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg","type":"image\/jpeg"}],"author":"Zachary McHenry","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zachary McHenry","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/"},"author":{"name":"Zachary McHenry","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/78eba25b0948cc80568f172c56e99745"},"headline":"Generating Test NID Data: Netherlands BSN","datePublished":"2012-08-06T22:51:02+00:00","dateModified":"2019-04-12T11:52:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/"},"wordCount":369,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg","keywords":["hotmail"],"articleSection":["Test Data"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/","url":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/","name":"Generating Test NID Data: Netherlands BSN - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg","datePublished":"2012-08-06T22:51:02+00:00","dateModified":"2019-04-12T11:52:40+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg","width":625,"height":461,"caption":"dutch t-rex passport"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/test-data\/netherlands-social-fiscal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Generating Test NID Data: Netherlands BSN"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.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:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/78eba25b0948cc80568f172c56e99745","name":"Zachary McHenry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f783b98096dabe202c36c6ab81417f89?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f783b98096dabe202c36c6ab81417f89?s=96&d=blank&r=g","caption":"Zachary McHenry"},"sameAs":["http:\/\/www.iri.com"],"url":"https:\/\/www.iri.com\/blog\/author\/zachm\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/08\/dutch-trex-passport.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/4200"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=4200"}],"version-history":[{"count":26,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/4200\/revisions"}],"predecessor-version":[{"id":12796,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/4200\/revisions\/12796"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11887"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=4200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=4200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=4200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}