Condition table
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.
| 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. |
Parent Topic:Healthcare and Life Sciences data model tables