Condition table

  • Release version: Zurich
  • Updated July 31, 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 model captures detailed information about medical conditions, problems, diagnoses, or other clinical events that require attention. It enables you to track patient-reported or diagnosed conditions along with key clinical attributes, supporting comprehensive healthcare management within your instance.

    Show full answer Show less

    Key Features

    • Condition Details: Records essential data such as condition codes, anatomical locations, categories (e.g., Diagnosis, Problem), clinical statuses (e.g., Active, Remission), and verification statuses (e.g., Confirmed, Provisional) aligned with FHIR standards.
    • Temporal Information: Captures onset dates and ages, as well as the date the condition was recorded in the system, providing a timeline for patient conditions.
    • Associations: Links conditions to patients, healthcare encounters, and source systems, ensuring traceability and context.
    • Identification and Tracking: Supports external identifiers from EMR systems and auto-generates unique condition numbers for easy reference and management.
    • Role-Based Configuration: Requires the snhcls.admin role to configure, ensuring secure management of sensitive healthcare data.

    Practical Use for ServiceNow Customers

    By leveraging the Condition table, customers can systematically document and manage patient conditions within their healthcare workflows. The structured fields enable integration with clinical systems, support compliance with healthcare data standards, and facilitate accurate clinical reporting and analysis. Customizing auto-numbering and categories allows adaptation to specific organizational needs.

    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.