Condition table

  • Release version: Yokohama
  • Updated January 30, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Condition table

    The Condition [snhclscondition] table in ServiceNow's Healthcare and Life Sciences application captures detailed information about medical conditions, problems, diagnoses, or clinical events that are significant enough to warrant attention. It is essential for tracking patient health issues, clinical statuses, and related healthcare encounters.

    Show full answer Show less

    Key Features

    • Comprehensive Condition Details: Stores medical conditions or diseases reported or diagnosed for a patient, including condition codes, anatomical locations, categories, and clinical statuses.
    • Standardized Categories and Statuses: Uses predefined choice lists aligned with FHIR specifications for categories (e.g., Diagnosis, Problem), clinical statuses (e.g., Active, Inactive, Resolved), and verification statuses (e.g., Confirmed, Provisional, Entered in error).
    • Timing Information: Records onset age and date, and the date/time the condition was recorded in the system.
    • Patient and Encounter Associations: Links each condition to the relevant patient and healthcare encounter, ensuring context and traceability.
    • External System Integration: Supports referencing external EMR identifiers and source systems to maintain interoperability.
    • Auto-generated Unique Identifiers: Each condition is assigned an auto-incremented alpha-numeric number (default format starts at COND00001001), which can be customized.

    Role and Configuration

    Configuration of the Condition table requires the snhcls.admin role. The table aligns with the Healthcare and Life Sciences data model, ensuring consistency and integration within the ServiceNow platform.

    Practical Benefits for ServiceNow Customers

    By leveraging the Condition table, healthcare organizations can accurately document and manage patient conditions, supporting clinical decision-making and care coordination. The alignment with FHIR standards facilitates interoperability with external systems and compliance with healthcare data exchange norms.

    The Condition [sn_hcls_condition] table stores the information about a condition, problem, diagnosis, or other event, situation, issue, or clinical concept that has risen to a level of concern.

    Key features

    • Stores any medical conditions or diseases that a patient may have reported or diagnosed with.
    • Includes the condition code, anatomical location, category, clinical status, date recorded, and date of onset.

    Role required to configure the table: sn_hcls.admin.

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

    Table 1. Condition table fields

    Field

    Data type

    Description

    Anatomical location

    Reference

    Body sites where the condition manifested.

    Category

    Choice list

    Category of the condition.

    The following categories are available by default:
    • Diagnosis
    • Problem

    For more information about the available categories, see condition categories defined in the FHIR specifications.

    Clinical status

    Choice list

    Status of the subject under clinical trial.

    The following statuses are available by default:
    • Active
    • Inactive
    • Recurrence
    • Relapse
    • Remission
    • Resolved

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

    Condition code

    Reference

    Identifier of the condition, problem, or diagnosis.

    Date recorded

    Date/Time

    Date and time when the condition was first recorded into the application.

    This field is automatically set to the current date and time.

    Encounter

    Reference

    Healthcare event during which this condition was created or to which the creation of this record is tightly associated.

    External identifier

    String

    Identifier of the record in an electronic medical record (EMR) system.

    Number

    String

    Alpha-numeric profile identifier of the condition.

    The value is auto-generated and is incremented every time you add a new condition to your ServiceNow instance. The initial value for the Number field is COND00001001.
    Note:
    To customize the number, define the auto-numbering format for the Condition [sn_hcls_condition] table. For more information, see Add auto-numbering records in a table.

    Onset age

    String

    Age at which an individual acquires, develops, or first experiences a condition or symptoms of a disease or disorder.

    Onset date

    Date/Time

    Date and time when the condition began, in the opinion of the clinician.

    Patient

    Reference

    Patient associated with the condition record.

    Source

    Reference

    Source system details of an external healthcare system in a ServiceNow instance.

    Verification status

    Choice list

    Verification status to support or decline the clinical status of the condition.

    The following statuses are available by default:
    • Confirmed
    • Differential
    • Entered in error
    • Provisional
    • Refuted
    • Unconfirmed

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