{"id":10107,"date":"2021-03-15T09:42:21","date_gmt":"2021-03-15T08:42:21","guid":{"rendered":"https:\/\/www.sikuel.it\/?p=10107"},"modified":"2021-07-06T17:03:06","modified_gmt":"2021-07-06T15:03:06","slug":"water-database-remediation","status":"publish","type":"post","link":"https:\/\/www.sikuel.it\/en\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/","title":{"rendered":"TICSI ARERA \u2013 Database Cleanup and Normalisation"},"content":{"rendered":"


\nARERA Resolution 665\/2017, known as TICSI Consolidated Text on Water Service Charges<\/strong>, has indeed introduced a series of new management specificities that oblige a significant and radical reorganisation of the Integrated Water Service Database.
\nThe TICSI redefines new classifications for Water Utilities<\/strong><\/span><\/a> and introduces for Domestic Users a new tariff structure based on the components of the household.
\nTherefore, for the purpose of applying the provisions contained in the resolution, the cleansing and normalisation of the Tax Codes and\/or VAT numbers of the Taxpayers and, primarily, the cadastral references of the individual utilities become necessary.<\/p>\n

The TICSI alignment service involves cleansing and normalising User data, with respect to the liable parties for whom it is registered, by updating their PERSONAL DATA (Tax Code validation, life\/death status, last residence), and that of LAND REGISTRY REFERENCES<\/u> of the properties in its remit.
\nConcurrently, for those who have been cleared, contracts and the number of family members for residents will be updated.<\/p>\n

The proposed activities will primarily focus on cleaning up the data of passive subjects who are account holders in the database, with the aim of cleaning up their tax codes, updating their last known residence, identifying any deceased individuals, and tracing their respective heirs.
\nIn parallel, work will be carried out to identify the Cadastral Reference for each user. This will not only serve as preparatory data for ARERA provisions but will also allow for the auditing of actual contracted users and any potentially unrecorded users (EVASION).<\/p>\n

Finally, the contract types in each redeemed utility will be correctly aligned (as per ARERA provisions) and the number of family members for Domestic Utilities will be updated.
\nIn addition to significantly reducing the rate of undelivered mail, these data-cleaning activities will ensure compliance with regulatory requirements and create the conditions for the database to interface with other external information systems, thereby enabling automatic updates and the tracking of missing items.
\nFor technical and commercial information, please contact us on 0932 667555 or 3486185167<\/p>\n

Photo by Sigmund on Unsplash<\/em><\/h6>","protected":false},"excerpt":{"rendered":"

La Delibera 665\/2017 dell\u2019ARERA, denominata TICSI Testo Integrato Corrispettivi Servizi Idrici, ha di fatto introdotto una serie di nuove specificit\u00e0 gestionali che obbligano ad una importante e radicale riorganizzazione della Base Dati del Servizio Idrico Integrato. Il TICSI\u00a0ridefinisce nuove classificazioni delle Utenze Idriche e introduce per le Utenze Domestiche una nuova struttura tariffaria basata sui […]<\/p>\n","protected":false},"author":1,"featured_media":10119,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[12,14],"tags":[62],"class_list":["post-10107","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-servizio-idrico","category-tributi","tag-arera-idrico"],"acf":[],"yoast_head":"\nTICSI ARERA \u2013 Bonifica e Normalizzazione Base Dati<\/title>\n<meta name=\"description\" content=\"La 665\/2017 ARERA ha introdotto nuove specificit\u00e0 gestionali che obbligano ad una importante bonifica della Base Dati del Servizio Idrico Integrato\" \/>\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.sikuel.it\/en\/water-service\/water-database-remediation\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TICSI ARERA \u2013 Bonifica e Normalizzazione Base Dati\" \/>\n<meta property=\"og:description\" content=\"La 665\/2017 ARERA ha introdotto nuove specificit\u00e0 gestionali che obbligano ad una importante bonifica della Base Dati del Servizio Idrico Integrato\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sikuel.it\/en\/water-service\/water-database-remediation\/\" \/>\n<meta property=\"og:site_name\" content=\"Sikuel\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-15T08:42:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-06T15:03:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sikuel.it\/wp-content\/uploads\/2021\/03\/jace-afsoon-BWAF966uMWM-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"393\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Administrator\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/\"},\"author\":{\"name\":\"Administrator\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#\\\/schema\\\/person\\\/b0afe60423340ee64e43ed05d5eb0b1b\"},\"headline\":\"TICSI ARERA \u2013 Bonifica e Normalizzazione Base Dati\",\"datePublished\":\"2021-03-15T08:42:21+00:00\",\"dateModified\":\"2021-07-06T15:03:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/\"},\"wordCount\":320,\"publisher\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sikuel.it\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/jace-afsoon-BWAF966uMWM-unsplash.jpg\",\"keywords\":[\"Arera Idrico\"],\"articleSection\":[\"Servizio Idrico Integrato\",\"Tributi Locali\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/\",\"url\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/\",\"name\":\"TICSI ARERA \u2013 Bonifica e Normalizzazione Base Dati\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sikuel.it\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/jace-afsoon-BWAF966uMWM-unsplash.jpg\",\"datePublished\":\"2021-03-15T08:42:21+00:00\",\"dateModified\":\"2021-07-06T15:03:06+00:00\",\"description\":\"La 665\\\/2017 ARERA ha introdotto nuove specificit\u00e0 gestionali che obbligano ad una importante bonifica della Base Dati del Servizio Idrico Integrato\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sikuel.it\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/jace-afsoon-BWAF966uMWM-unsplash.jpg\",\"contentUrl\":\"https:\\\/\\\/www.sikuel.it\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/jace-afsoon-BWAF966uMWM-unsplash.jpg\",\"width\":640,\"height\":393},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/servizio-idrico\\\/ticsi-arera-bonifica-base-dati-idrico\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sikuel.it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TICSI ARERA \u2013 Bonifica e Normalizzazione Base Dati\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#website\",\"url\":\"https:\\\/\\\/www.sikuel.it\\\/\",\"name\":\"Sikuel\",\"description\":\"Soluzioni Informatiche per la Gestione del Servizio Idrico e dei Rifiuti\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sikuel.it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#organization\",\"name\":\"Sikuel Srl\",\"url\":\"https:\\\/\\\/www.sikuel.it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.sikuel.it\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Sikuel_mark-2020-03.png\",\"contentUrl\":\"https:\\\/\\\/www.sikuel.it\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Sikuel_mark-2020-03.png\",\"width\":313,\"height\":84,\"caption\":\"Sikuel Srl\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/sikuel-srl\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCvVXHHqJIWLIn7uvmKJA5kg\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sikuel.it\\\/#\\\/schema\\\/person\\\/b0afe60423340ee64e43ed05d5eb0b1b\",\"name\":\"Administrator\",\"sameAs\":[\"http:\\\/\\\/sikuel.dev.elogic.it\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TICSI ARERA \u2013 Database Cleanup and Normalisation","description":"The 665\/2017 ARERA has introduced new management specificities that necessitate significant cleansing of the Integrated Water Service Database.","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.sikuel.it\/en\/water-service\/water-database-remediation\/","og_locale":"en_GB","og_type":"article","og_title":"TICSI ARERA \u2013 Bonifica e Normalizzazione Base Dati","og_description":"La 665\/2017 ARERA ha introdotto nuove specificit\u00e0 gestionali che obbligano ad una importante bonifica della Base Dati del Servizio Idrico Integrato","og_url":"https:\/\/www.sikuel.it\/en\/water-service\/water-database-remediation\/","og_site_name":"Sikuel","article_published_time":"2021-03-15T08:42:21+00:00","article_modified_time":"2021-07-06T15:03:06+00:00","og_image":[{"width":640,"height":393,"url":"https:\/\/www.sikuel.it\/wp-content\/uploads\/2021\/03\/jace-afsoon-BWAF966uMWM-unsplash.jpg","type":"image\/jpeg"}],"author":"Administrator","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/#article","isPartOf":{"@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/"},"author":{"name":"Administrator","@id":"https:\/\/www.sikuel.it\/#\/schema\/person\/b0afe60423340ee64e43ed05d5eb0b1b"},"headline":"TICSI ARERA \u2013 Bonifica e Normalizzazione Base Dati","datePublished":"2021-03-15T08:42:21+00:00","dateModified":"2021-07-06T15:03:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/"},"wordCount":320,"publisher":{"@id":"https:\/\/www.sikuel.it\/#organization"},"image":{"@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sikuel.it\/wp-content\/uploads\/2021\/03\/jace-afsoon-BWAF966uMWM-unsplash.jpg","keywords":["Arera Idrico"],"articleSection":["Servizio Idrico Integrato","Tributi Locali"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/","url":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/","name":"TICSI ARERA \u2013 Database Cleanup and Normalisation","isPartOf":{"@id":"https:\/\/www.sikuel.it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/#primaryimage"},"image":{"@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sikuel.it\/wp-content\/uploads\/2021\/03\/jace-afsoon-BWAF966uMWM-unsplash.jpg","datePublished":"2021-03-15T08:42:21+00:00","dateModified":"2021-07-06T15:03:06+00:00","description":"The 665\/2017 ARERA has introduced new management specificities that necessitate significant cleansing of the Integrated Water Service Database.","breadcrumb":{"@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/#primaryimage","url":"https:\/\/www.sikuel.it\/wp-content\/uploads\/2021\/03\/jace-afsoon-BWAF966uMWM-unsplash.jpg","contentUrl":"https:\/\/www.sikuel.it\/wp-content\/uploads\/2021\/03\/jace-afsoon-BWAF966uMWM-unsplash.jpg","width":640,"height":393},{"@type":"BreadcrumbList","@id":"https:\/\/www.sikuel.it\/servizio-idrico\/ticsi-arera-bonifica-base-dati-idrico\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sikuel.it\/"},{"@type":"ListItem","position":2,"name":"TICSI ARERA \u2013 Bonifica e Normalizzazione Base Dati"}]},{"@type":"WebSite","@id":"https:\/\/www.sikuel.it\/#website","url":"https:\/\/www.sikuel.it\/","name":"Sikuel","description":"IT Solutions for Water and Waste Management","publisher":{"@id":"https:\/\/www.sikuel.it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sikuel.it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.sikuel.it\/#organization","name":"Sikuel Ltd","url":"https:\/\/www.sikuel.it\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sikuel.it\/#\/schema\/logo\/image\/","url":"https:\/\/www.sikuel.it\/wp-content\/uploads\/2021\/03\/Sikuel_mark-2020-03.png","contentUrl":"https:\/\/www.sikuel.it\/wp-content\/uploads\/2021\/03\/Sikuel_mark-2020-03.png","width":313,"height":84,"caption":"Sikuel Srl"},"image":{"@id":"https:\/\/www.sikuel.it\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/sikuel-srl","https:\/\/www.youtube.com\/channel\/UCvVXHHqJIWLIn7uvmKJA5kg"]},{"@type":"Person","@id":"https:\/\/www.sikuel.it\/#\/schema\/person\/b0afe60423340ee64e43ed05d5eb0b1b","name":"Administrator","sameAs":["http:\/\/sikuel.dev.elogic.it"]}]}},"_links":{"self":[{"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/posts\/10107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/comments?post=10107"}],"version-history":[{"count":2,"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/posts\/10107\/revisions"}],"predecessor-version":[{"id":11286,"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/posts\/10107\/revisions\/11286"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/media\/10119"}],"wp:attachment":[{"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/media?parent=10107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/categories?post=10107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sikuel.it\/en\/wp-json\/wp\/v2\/tags?post=10107"}],"curies":[{"name":"I'm sorry, but I don't understand what \"wp\" means. Could you please provide more context or a clearer phrase?","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}