Condition table

  • Release version: Xanadu
  • Updated August 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 in ServiceNow is designed to capture and manage information about medical conditions, problems, diagnoses, and other clinical concepts that require attention. This table is essential for healthcare providers in tracking patient health information effectively.

    Show full answer Show less

    Key Features

    • Data Storage: Records various medical conditions reported or diagnosed in patients.
    • Field Details: Includes critical fields such as condition code, anatomical location, category, clinical status, dates of recording and onset, and patient reference.
    • Role Configuration: Requires the role 'snhcls.admin' for setup and configuration.
    • Auto-Numbering: The system auto-generates a unique profile identifier for each condition, starting from COND00001001, which can be customized.
    • Verification Status: Supports clinical status verification with various options like Confirmed, Provisional, and Unconfirmed.

    Key Outcomes

    By utilizing the Condition table, ServiceNow customers can streamline the management of patient conditions, enhance documentation accuracy, and facilitate better clinical decision-making. This ultimately contributes to improved patient care and operational efficiency within healthcare settings.

    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.