Healthcare location table

  • Release version: Xanadu
  • Updated February 1, 2024
  • 1 minute to read

    • The Healthcare Location [sn_hcls_location] table stores details of the location associated with your healthcare organization.

    Key features

    • Models locations of different physical types including a site, a hospital building, a research lab, a parking lot, or a patient’s home.
    • Enables a location to include multiple locations.
    • Related lists for procedures, care specialities, and conditions are shown for records created via the Codeset location [sn_hcls_codeset_location] table.
    • Maps with devices via the Medical device install base item [sn_hcls_medical_device_install_base_item] table.
    • Maps with practitioners via the Practitioner location [sn_hcls_practitioner_facility] table.

    Role required to configure the table: sn_hcls.admin.

    For more information, see Healthcare and Life Sciences data model.

    Table 1. Healthcare location table fields

    Field

    Data type

    Description

    Altitude

    Floating Point Number

    Altitude of the absolute geographic location.

    Description

    String

    More details about the location that could be displayed as further information to identify the location beyond its name.

    Identifier

    String

    The associated identifier of the patient.

    Location

    Reference

    Physical location of this healthcare location.

    Entry selected here populates address fields.

    Name

    String

    Name to identify the healthcare location.

    Number

    String

    Patient ID number associated with the patient’s name.

    This field is read-only.

    Managing Organization

    Reference

    Organization which manages this location.

    Parent location

    Reference

    Sys_id of the parent location associated with this location.

    Physical type

    Choice list

    Physical form of the location.

    The following types are available by default:
    • Area
    • Bed
    • Building
    • Cabinet
    • Corridor
    • Jurisdiction
    • Level
    • Room
    • Road
    • Site
    • Vehicle
    • Wing
    • Ward

    For more information about the available physical types, see location types defined in the FHIR specifications.

    Status

    Choice list

    Option to indicate whether the healthcare location is in use.

    The following statuses are available by default:
    • Active
    • Inactive
    • Suspended

    For more information about the available statuses, see location statuses defined in the FHIR specifications.