OrganizationAffiliations

The OrganizationAffiliations file contains information about organizationAffiliation entities, which link together organizations, locations and the health plans that they accept using the respective identifiers (organizationId, locationId, planId) for those entities.

Filename format

organizationaffiliations_##.json

JSON schema

JSON schema for OrganizationAffiliation file

{
    "$schema": "https://json-schema.org/draft/2019-09/schema",
    "$id": "https://defacto.health/insurances/organizationaffiliations.schema.json",
    "title": "Healthcare locations",
    "description": "The link between organizations, locations and health plans.",
    "type": "object",
    "properties":
    {
        "organizationAffiliations":
        {
            "type": "array",
            "description": "Array of all organizationAffiliation entities collected by Defacto Health",
            "items":
            {
                "type": "object",
                "properties":
                {
                    "organizationId": {
                        "type": "integer",
                        "description": "Defacto Health generated identifier for the organization, unique across all organizations."
                    },
                    "locationId": {
                        "type": "integer",
                        "description": "Defacto Health generated identifier for the location, unique across all locations."
                    },
                    "planIds": {
                        "type": "array",
                        "description": "Array of Defacto Health generated identifiers for the health plans accepted by this organization, unique across all plans across all carriers."
                    }
                },
                "required":
                [
                    "organizationId",
                    "locationId",
                    "planIds"
                ]
            }
        }
    }
}

Sample JSON

Sample JSON for OrganizationAffiliation file

{
    "organizationAffiliations":
    [
        {
            "organizationId": 34,
            "locationId": 56,
            "planIds": [76, 842]
        },
        {
            "organizationId": 88,
            "locationId": 346,
            "planIds": [5, 786, 3467]
        }
    ]
}

Attributes

Attribute	Type	Description	Required	Constraints	Example
organizationId	integer	Defacto Health generated identifier for the carrier, unique across all organizations.	yes	Must be present in Organizations file	34
locationId	integer	Defacto Health generated identifier for the location, unique across all locations.	no	Must be present in Locations file	56
planIds	array[integer]	Defacto Health generated identifier for the health plan, unique across all plans across all carriers.	no	Must be present in CarrierPlans file	[45,76]