Definition

The Admin_OrganisationLocation extract represents the many-to-many relationship between healthcare organisations and their physical locations. It records which locations are associated with a given organisation and flags which one serves as the primary (main) location.

Information

The Admin_OrganisationLocation extract is a linking table that resolves the relationship between Admin_Organisation and Admin_Location. A single organisation may operate from multiple sites, and a location may be shared by more than one organisation. The ismainlocation flag distinguishes the primary site from secondary ones.

Each record is uniquely identified by the combination of organisationguid and locationguid.

Key Identifiers

• organisationguid: References the organisation in Admin_Organisation.
• locationguid: References the physical location in Admin_Location.

Status Fields

• ismainlocation: Boolean flag indicating whether this location is the primary (main) site for the organisation.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Organisation Link"]
    n2["Location Link"]
    n3["Active Status & Dates"]
  end

  n17["Organisation 1"] --> container
  n18["Organisation 2"] --> container

  container --> n16["Gather org-location links"]
  n16 --> n14["ETL"]
  n14 --> n15["Admin_OrganisationLocation Model"]