31:[] 2f:{"title":"IAM Case-Handling Data Model","cells":[{"id":0,"value":"md`\n# IAM Case-Handling Data Model\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":140,"value":"md`\nThis notebook outlines an approach to defining a set of common data attribute names to describe independent accountability mechanisms (IAMs), and specifically members of [IAMnet](http://independentaccountabilitymechanism.net/).\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":518,"value":"md`\nIf you're looking for the notebook that addresses case data specifically, [click here](https://observablehq.com/@aaronkyle/iam-case-data-model).\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":564,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":548,"value":"md`\n## IAMnet Member Organizations\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":445,"value":"md`\nPlease note that the acronyms supplied in this table are my own creations. To help reduce ambiguity, I define IAM acronyms to also reference the institution it oversees. Where IAM names are similar, I will use full acronyms. Otherwise I use the prefix.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":84,"value":"iam_member_table = {\nvar html = \"\";\n html+=\"\";\n html+=\"\";\n html+=\"\";\nfor (var i = 1; i < iam_data.length; i++) {\n html+=\"\";\n html+=\"\";\n html+=\"\";\n html+=\"\";\n html+=\"\";\n html+=\"\";\n}\nhtml+=\"

\"+iam_data[0].iam+\"	\"+iam_data[0].iam_acronym+\"	\"+iam_data[0].institution+\"	\"+iam_data[0].institution_acronym+\"
\"+iam_data[i].iam+\"	\"+iam_data[i].iam_acronym+\"	\"+iam_data[i].institution+\"	\"+iam_data[i].institution_acronym+\"

\";\ndocument.getElementById(\"box\").innerHTML = html;\n\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":246,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":252,"value":"md`## IAM Case Handling Process: Toward a Common List of Attributes`","pinned":false,"hidden":false,"mode":"ojs"},{"id":155,"value":"md`\nThere are, of course, any number of ways to describe an IAM. As we'll get into more a bit later, trying to establish common terminology around IAM case handling processes is pretty rough. Each IAM has it's own way of doing things, making it a challenge to draw comparisons.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":515,"value":"md`This is not to say we shouldn't try!`","pinned":false,"hidden":false,"mode":"ojs"},{"id":517,"value":"md`\nSince I wish to draw comparisons about IAM caseloads, I'll start by ironing out a vocabulary for describing their case handling process. \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":292,"value":"md`### IAM Case Handling Processes [High-Level]`","pinned":false,"hidden":false,"mode":"ojs"},{"id":491,"value":"md`\n\nIn defining our data attributes for IAM case handling processes, I'd like to stay as true as possible to how IAMs describe themselves. I'll start by looking at the World Bank Inspection Panel (the Inspection Panel was the first IAM). From there will gradually build out a common set of attribute names as I bring more IAMs into this comparative framework.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":395,"value":"md`#### Inspection Panel`","pinned":false,"hidden":false,"mode":"ojs"},{"id":49,"value":"md` Here's a graphic showing the case handling process of the World Bank's [${iam_data[2].iam}](${iam_data[2].iam_url}):`","pinned":false,"hidden":false,"mode":"ojs"},{"id":340,"value":"md`**Graphic Summary of the [${iam_data[2].iam}](${iam_data[2].iam_url}) Case Handling Process**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":304,"value":"IPN_case_handling = dot`\ndigraph {\n\trankdir = LR;\n\tnode [shape = doublecircle]; Intake Compliance Closure;\n node [shape = circle]; Registration;\n\tIntake -> Registration [ label = \" eligibility screening\" ];\n\tRegistration -> Compliance;\n\tCompliance -> Closure;\n}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":398,"value":"md`\nInspection Panel case handling first receives a compliant (intake), which it assesses against its criterion for accepting the complaint (eligibility)—a process that culminates in case 'registration' for compliance investigation. After the Inspection Panel has completed its investigation, World Bank Group management commit to a remedial action plan, and the case closes from the Inspection Panel process.\n`\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":406,"value":"md`\nLet's quickly try to name each of these component stages as a data attribute. I'll use this as the 'point of origin' for our IAM data model.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":352,"value":"attributes_IPN = [\n { id: 'ibrd_ida',\n institution: 'World Bank',\n intake: 'yes',\n eligibility: 'yes',\n registration: 'yes',\n compliance: 'yes' },\n]","pinned":true,"hidden":false,"mode":"ojs"},{"id":348,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":415,"value":"md`#### CAO`","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"md` At the Office of the [${iam_data[1].iam}](${iam_data[1].iam_url}), the process is quite different.\n\nCAO receives complaints (intake) which are screened to ensure that the complainants are real and not anonymously submitted (validity). Those complaints received that are found to be genuine are acknowledged and then moved into an eligibility stage. Eligible complaints are termed 'cases', assigned a case name, and then transferred into an assessment stage.\n\nFrom assessment, complainants and companies may voluntarily elect to enter a dispute resolution process (ombudsman), otherwise the case transfers to the compliance function for an appraisal—similar to the Inspection Panel's process of complaint eligibility screening and registration.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":343,"value":"md`**Graphic Summary of the [${iam_data[1].iam}](${iam_data[1].iam_url}) Case Handling Process**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":298,"value":"CAO_case_handling = dot`\ndigraph {\n\trankdir = LR;\n\tnode [shape = doublecircle]; Intake Eligibility Assessment Ombudsman Compliance Closure;\n node [shape = smallsquare]; Acknowledgement;\n\tIntake -> Acknowledgement;\n\t Acknowledgement -> Eligibility;\n Eligibility -> Assessment;\n\tAssessment -> Ombudsman;\n\tAssessment -> Compliance;\n\tOmbudsman -> Compliance;\n\tOmbudsman -> Closure;\n\tCompliance -> Closure;\n}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":350,"value":"md`\nJust like we did for the Inspection Panel, let's quickly try to name each of CAO's component stages as a data attribute.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":355,"value":"attributes_CAO = [\n { id: 'ifc_miga',\n institution: 'International Finance Corporation & Multilateral Guarantee Agency',\n intake: 'yes',\n acknowledgement: 'yes',\n eligibility: 'yes',\n dispute_resolution: 'yes',\n compliance: 'yes',\n advisory: 'yes' },\n]","pinned":true,"hidden":false,"mode":"ojs"},{"id":381,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":417,"value":"md`### Toward a Common Vocabulary of IAM High-Level Stages`","pinned":false,"hidden":false,"mode":"ojs"},{"id":528,"value":"md`Here's where the magic happens....`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3,"value":"attribute_IPN_CAO = [\n { // id: 'ibrd_ida', //We won't show this in the table.\n institution: 'World Bank',\n intake: 'yes',\n acknowledgement: 'no',\n eligibility: 'yes', // note: This may be subsumed under `registration`!\n registration: 'yes', // note: This may be equivalent to CAO `acknowledgement`!\n assessment: 'no',\n dispute_resolution: 'no' ,\n compliance: 'yes',\n // advisory: 'no' //We won't show this in the table.\n },\n { // id: 'ifc_miga', //We won't show this in the table.\n institution: 'IFC/MIGA',\n intake: 'yes',\n acknowledgement: 'yes', // note: This may be equivalent to IPN `registration`!\n registration: 'no',\n eligibility: 'yes', // note: The sequencing of the stage termed 'eligibility' at CAO differs from IPN.\n assessment: 'yes',\n dispute_resolution: 'yes',\n compliance: 'yes',\n // advisory: 'yes' //We won't show this in the table.\n },\n]\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":531,"value":"md`\nBoiling this all down, the result would look something like this:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":373,"value":"table(attribute_IPN_CAO)","pinned":false,"hidden":false,"mode":"ojs"},{"id":532,"value":"md`Pretty simple, eh? Of course, this table glosses over all the complexity noted as we were drafting out that list of combined attributes. `","pinned":false,"hidden":false,"mode":"ojs"},{"id":534,"value":"md`Let's try again, this time retaining some of the 'messiness'. We'll need all of this information later on, when we really start digging into our comparisons.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":30,"value":"md`| Institution | Intake | Acknowledgement| Eligibility| Registration | Assessment | Dispute Resolution | Compliance Review / Problem-Solving |\n| ---|\t---| --- | --- | --- | --- | --- | ---|\n| World Bank |\tyes | linked to registration | yes: linked to registration | yes | no | no | yes: investigation, remedial action | \n| IFC/MIGA |\tyes: validity | yes | yes | no | yes: decision -> DR - Compliance | yes: agreement; monitoring | yes: appraisal, investigation, monitoring | \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":578,"value":"md`\nGood enough. It's a messy table but also a solid point of departure for building out a common framework of data attributes. \n\nI'll grow out this list as I continue to work through descriptions of IAM functions. I'll also add in other descriptive data as I come across it. I'll see how far this approach can take us as we go deeper into our comparative work.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":256,"value":"md`\n\nCurrently, my list of descriptive data point on IAM case-handling processes comprises ${iam_attributes.length} attributes. [Check 'em out!](https://observablehq.com/@aaronkyle/iam-case-handling-attributes)\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":124,"value":"iam_attributes = Object.keys(iam_data[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":72,"value":"iam_attrubtes_descriptive = iam_data[0]","pinned":false,"hidden":false,"mode":"ojs"},{"id":559,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":556,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs"},{"id":61,"value":"data_url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQOJQag22Qyn48CyTUuqWCyZkc970keBEHIn6nbGSSW2Y6QFr-FHFjc9YqUN2kAHTgYimHVyIOaVrk8/pub?gid=2055378148&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"iam_data = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let iam_data =[];\n const spreadsheet = await d3.tsv(data_url).then(data => data.forEach(d => iam_data.push(d))); // d3.tsv returns a Promise\n return iam_data;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"import {table} from \"@tmcw/tables/2\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":296,"value":"dot = require(\"@observablehq/graphviz@0.2\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}