openIDL - TEST Data Requirements TEST

Owned by Sean Bohan

Last updated: Jun 06, 2022

Discussion notes:

<style></style><div class="cells-worksheet" data-sheet-number="0" data-sheet-name="Requirements"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;table-layout:fixed;width:1205pt"> <colgroup> <col style="mso-width-source:userset;width:162px"></col> <col style="width:64px"></col> <col style="mso-width-source:userset;width:107px"></col> <col style="mso-width-source:userset;width:1274px"></col> </colgroup> <tbody> <tr class="x25" style="mso-height-source:userset;height:27.75pt" id="r0"> <td class="x33" style="height:24.75pt;width:121.5pt">Grouping</td> <td class="x34" style="width:48pt">ID</td> <td class="x36" style="width:80.25pt">Date</td> <td class="x35" style="width:955.5pt">Requirement</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r1"> <td class="x22" style="height:20.25pt">Data and Data Integrity</td> <td class="x23">D.1</td> <td class="x37">5/23/2022</td> <td class="x24">Data contained in the carrier data store will conform to OpenIDL data model standards</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r2"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.2</td> <td class="x37">6/1/2022</td> <td class="x28">OpenIDL data model standards shall exist for all Property & Casualty lines of business except Workers Compensation </td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r3"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.3</td> <td class="x37">5/23/2022</td> <td class="x28">Minimal data attributes to be available in carrier data store shall consist of the "Day 1" OpenIDL data model fields, other attributes in the OpenIDL data model are populated at the option of the carrier</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r4"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.4</td> <td class="x37">5/23/2022</td> <td class="x28">Data shall consist of policy and loss transactions over the course of the policy term and lifetime of any associated claims based on source system activity</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r5"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.5</td> <td class="x37">5/23/2022</td> <td class="x28">Data shall be current to the Prior Month + 45 days</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r6"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.6</td> <td class="x37">5/23/2022</td> <td class="x28">Companies shall maintain data in the carrier data store for 5 prior years plus current year</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r7"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.7</td> <td class="x37">6/1/2022</td> <td class="x29">All data contained in the carrier data store is soley owned and controlled by that carrier </td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r8"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.8</td> <td class="x37">6/1/2022</td> <td class="x28">Data shall remain accurate as of a point in time and may be corrected over time if errors in the transmission of data occurs with no obligation to restate prior uses of the data</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r9"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.9</td> <td class="x37">6/1/2022</td> <td class="x28">OpenIDL shall maintain an edit package to be available and used by carriers to test conformance to data model standards and data point interactions similar to the functioning of the AAIS SDMA portal</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r10"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.10</td> <td class="x37">5/23/2022</td> <td class="x28">Data must pass through OpenIDL edit package and be within 5% error tolerance per line and state based similarly to acceptance by AAIS through SDMA portal</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r11"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.11</td> <td class="x37">6/1/2022</td> <td class="x28">The OpenIDL data model standards will foster effective and efficient data extractions such that queries of data can be satisfied within 24 hours of commitment to participate in an information request<span style="mso-spacerun:yes;white-space:nowrap;font-family:"Times New Roman""> </span></td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r12"> <td class="x26" style="height:21pt">Data and Data Integrity</td> <td class="x27">D.12</td> <td class="x37">6/1/2022</td> <td class="x28">Any changes NAIC required fields to the OpenIDL data model will require a minimum of 18 months notice for carriers to conform </td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r13"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.1</td> <td class="x38">6/1/2022</td> <td class="x16">Requests for information shall be specific in detail and communicated through a secured protocol</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r14"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.2</td> <td class="x38">6/1/2022</td> <td class="x16">Forum shall be established for carriers and regulators to discuss and agree to intent and interpretation of information request</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r15"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.3</td> <td class="x38">6/1/2022</td> <td class="x16">Request for information shall<span style="mso-spacerun:yes;font-family:"Times New Roman""> </span>be for aggregated information only, no individual policy, claim, or personally identified information shall be requested or honored</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r16"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.4</td> <td class="x38">6/1/2022</td> <td class="x16">information requests shall identify who has access to the private analytics node</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r17"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.5</td> <td class="x38">5/23/2022</td> <td class="x16">Information requests shall define timeframes for data to be included in the aggregation</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r18"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.6</td> <td class="x38">5/23/2022</td> <td class="x16">Information requests shall define the attributes to be used in aggregation</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r19"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.7</td> <td class="x38">5/23/2022</td> <td class="x16">Information requests shall define the logic for extracting and aggregating data</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r20"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.8</td> <td class="x38">5/23/2022</td> <td class="x16">Information requests shall identify and define the calculations to be used in aggregations, analysis, and reporting</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r21"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.9</td> <td class="x38">5/23/2022</td> <td class="x16">Information requests shall define the specific use of the information</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r22"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.10</td> <td class="x38">6/1/2022</td> <td class="x16">Information requests shall define the permitted accessors to the information and users of data</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r23"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.11</td> <td class="x38">5/23/2022</td> <td class="x16">Information requests shall communicate the proportion of individual carrier information to the population of data in the extraction prior to final commitment to participate</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r24"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.12</td> <td class="x38">5/23/2022</td> <td class="x16">Information requests shall be for one time use only.<span style="mso-spacerun:yes;font-family:"Times New Roman""> </span>Additional uses for data will require a new request. </td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r25"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.13</td> <td class="x38">6/1/2022</td> <td class="x16">Information requests shall identify the path information will flow from its raw form through final reporting<span style="mso-spacerun:yes;font-family:"Times New Roman""> </span>(e.g. carrier data store to private analytics node to Multi-Carrier aggregation mode to Regulator)</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r26"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.14</td> <td class="x38">6/1/2022</td> <td class="x16">Information requests shall identify the form information will flow from its raw form through final reportings (raw data; carrier summarized aggregated and anonymized data; reported data)</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r27"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.15</td> <td class="x38">5/23/2022</td> <td class="x16">Information requests have an expiration date and time from which consent is needed, if applicable</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r28"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.16</td> <td class="x38">6/1/2022</td> <td class="x16">All requests for information, its approval, the disposition of data from its raw form through final reporting shall be tracked, recorded and archived within OpenIDL</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r29"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.17</td> <td class="x38">5/23/2022</td> <td class="x16">Carriers who participate in information requests shall receive a copy of the final information presented as well as their individual carrier results</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r30"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.18</td> <td class="x38">6/1/2022</td> <td class="x16">Carriers decide in which information requests they will participate</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r31"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.19</td> <td class="x38">6/1/2022</td> <td class="x16">Carriers must provide an affirmative response prior to any information being extracted to the private analytics mode</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r32"> <td class="x30" style="height:21pt">Information Requests</td> <td class="x19">IR.20</td> <td class="x38">5/23/2022</td> <td class="x16">Final reports shall be archived by OpenIDL for 3 years</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r33"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.1</td> <td class="x39">5/23/2022</td> <td class="x17">Carrier's raw data will be "walled off" from other entities with access only through permissioned protocols</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r34"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.2</td> <td class="x39">6/1/2022</td> <td class="x17">Carriers raw data shall not leave its control - a secured limited access "private analytics node" may be established for processing information requests</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r35"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.3</td> <td class="x39">6/1/2022</td> <td class="x17">If multiple information requests are being processed at the same time, separate "private analytics nodes" with separate access shall be employed</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r36"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.4</td> <td class="x39">6/1/2022</td> <td class="x17">If multiple information requests are being processed at the same time, the data for each request will be segregated</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r37"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.5</td> <td class="x39">6/1/2022</td> <td class="x17">Carrier data may be transmitted to a private analytics node only as the result of an approved data request via a permissioned access protocol</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r38"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.6</td> <td class="x39">5/23/2022</td> <td class="x17">Carrier data may be transmitted to a private analystics node that has been aggregated and anonymizated through a secured protocol</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r39"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.7</td> <td class="x39">6/1/2022</td> <td class="x17">Carrier data in the private analytics node shall only be used for the purposes for which permissioned access has been granted</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r40"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.8</td> <td class="x39">6/1/2022</td> <td class="x17">Carrier data in the private analystics node shall be immediately purged upon completion of the processing for which permissioned access was granted</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r41"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.9</td> <td class="x39">5/23/2022</td> <td class="x17">No Personally identifiable information (PII) data shall be transmitted </td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r42"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.10</td> <td class="x39">5/23/2022</td> <td class="x17">No altering or embellishing data including appending outside data is permitted throughout the processing of the information request unless approved by carrier</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r43"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.11</td> <td class="x39">5/23/2022</td> <td class="x17">No changes to request, attributes used, extraction patterns, accessors, users, or specific use of the data is permitted post consent</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r44"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.12</td> <td class="x39">5/23/2022</td> <td class="x17">Only authorized approvers may commit carrier to a data request</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r45"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.13</td> <td class="x39">5/23/2022</td> <td class="x17">Data request communication shall be through a communications protocol within OpenIDL and archived within OpenIDL</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r46"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.14</td> <td class="x39">5/23/2022</td> <td class="x17">Individual carrier contribution to a data request will not exceed 15% of the population of premium, losses, exposures, etc. for a given information request</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r47"> <td class="x31" style="height:21pt">Access and Security</td> <td class="x20">AS.15</td> <td class="x39">6/1/2022</td> <td class="x17">OpenIDL is responsible for fulfilling multi-carrier information requests including extraction patterns, aggregations and formatting of final reports</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r48"> <td class="x32" style="height:21pt">Communication</td> <td class="x21">C.1</td> <td class="x40">6/1/2022</td> <td class="x18">All requests for information via OpenIDL will be through a secured communications portal within OpenIDL</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r49"> <td class="x32" style="height:21pt">Communication</td> <td class="x21">C.2</td> <td class="x40">6/1/2022</td> <td class="x18">All communications will be written (electronic) and be archived by OpenIDL for 10 years</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r50"> <td class="x32" style="height:21pt">Communication</td> <td class="x21">C.3</td> <td class="x40">6/1/2022</td> <td class="x18">A non-response to a request for information will<span style="mso-spacerun:yes;font-family:"Times New Roman""> </span>be considered a decline to participate</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r51"> <td class="x32" style="height:21pt">Communication</td> <td class="x21">C.4</td> <td class="x40">6/1/2022</td> <td class="x18">Requests for information must come from an authorized representative of the requesting body</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r52"> <td class="x32" style="height:21pt">Communication</td> <td class="x21">C.5</td> <td class="x40">6/1/2022</td> <td class="x18">Requests for information must state the regulatory authority for the information being sought</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r53"> <td class="x32" style="height:21pt">Communication</td> <td class="x21">C.6</td> <td class="x40">6/1/2022</td> <td class="x18">Agreement to participate in a request for information is conditioned on OpenIDL providing the carrier the proportion of data that carrier is providing to the population of data</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r54"> <td class="x32" style="height:21pt">Communication</td> <td class="x21">C.7</td> <td class="x40">6/1/2022</td> <td class="x18">Final agreement to participate in a request for information is valid once received by the OpenIDL communications portal</td> </tr> <tr class="x25" style="mso-height-source:userset;height:22.5pt" id="r55"> <td class="x32" style="height:21pt">Communication</td> <td class="x21">C.8</td> <td class="x40">6/1/2022</td> <td class="x18">Final agreement to participate may be recinded up to an hour after final agreement is received by the communciations portal to affirm participation</td> </tr> <tr style="display:none"> <td style="width:121.5pt"></td> <td style="width:48pt"></td> <td style="width:80.25pt"></td> <td style="width:955.5pt"></td> </tr> </tbody></table></div>