Condition table

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 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 is essential for storing information about medical conditions, problems, diagnoses, and other clinical concepts that are significant to patient care. It helps healthcare professionals track and manage patient conditions effectively.

    Show full answer Show less

    Key Features

    • Comprehensive Data Storage: Captures various details including condition codes, anatomical locations, categories, clinical statuses, and dates related to the condition.
    • Role Requirement: Configuration of this table requires the snhcls.admin role.
    • Default Categories: Includes categories such as Diagnosis and Problem, aligning with FHIR specifications.
    • Clinical Status Options: Supports statuses like Active, Inactive, and Remission, also compliant with FHIR standards.
    • Auto-generated Identifiers: The Number field auto-increments with each new condition, facilitating easy tracking.

    Key Outcomes

    By utilizing the Condition table, ServiceNow customers can efficiently record and manage patient conditions, ensuring accurate tracking of clinical data and improving patient care outcomes. Understanding the fields and their purposes allows for better data entry and management practices within the healthcare system.

    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.