> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.emtelligent.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.emtelligent.com/_mcp/server.

# Generating Patient Summaries from Clinical Reports

## Synopsis

This query searches for relevant medical concepts from medical reports for a patient. It returns entities coded to Snomed concepts and organizes them by the UMLS type associated with the Snomed concept. When multiple occurrences of the same concept is detected (e.g. in multiple reports), the query returns the most recent mention.

This example shows the value of populating the **documentmetadata** table after data processing. The Output Database Client supports merging of select metadata fields during the database insert step after structured data is returned by the NLP API. By using this data integration feature, your can use the Output Database to develop queries that return datasets which can be immediately used to generate insights for clinical or research questions where specific patients or cohorts need to be identified.

## Processing Requirements

Because we need to uniquely identify the patient for this query, the patient identifier (MRN or other proxy for patient id), must be stored in the Output Database **documentmetadata** table after processing. Depending on your existing data infrastructure, there are several ways to populate the Output Database with patient identifiers so that they can be correlated with the extracted data. This information should be stored in the **documentmetadata** `subject_id` field in addition to other report specific information such as `chart date`. For more information about populating the `documentmetadata` table with patient identifiers and other report metadata see **Storing Extended Report Metadata** and **Ingesting Input Documents from JSON Files** in the **Output Database Client documentation**.

This query assumes that at least the following `emtellipro-db-client` processing options were enabled:

* `--feature experiencer-relation, snomed-ontology`
* `--store-sections-and-sentences`

For this query, Clinical notes were processed with the following document type:

* `--category Clinical`
* `--subcategory generic`

## Clinical Context

The Unified Medical Language System (UMLS) from the National Library of Medicine (NLM) is a metathesaurus - it takes multiple medical ontologies, and combines and cross-references them. Another feature of the UMLS is that it uses its own semantic type labeling for its many medical ontologies, labeling concepts with semantic types such as `Disease or Syndrome` or `Acquired Abnormality`. The NLP API provides these UMLS semantic types for entities in the 'entity_type' field of the NLP API output and they can be used to identify groups of clinically-relevant concepts.

This query uses a combination of the experiencer CTE seen earlier in this cookbook with SQL `CASE` functionality to further combine multiple UMLS semantic types into broad groupings of patient history items. By combining multiple UMLS semantic types, it broadly groups patient history medical concepts into 6 categories of useful clinical history items:

* Abnormalities / Disorders
* Neoplasia / Cancer
* Injuries / Trauma
* Findings / Symptoms
* Mental / Behavioral Disorders
* Procedures / Care Activities

This kind of query could then be used to build a `clinical helper` applications that would show a snapshot of a patient's medical history, highlighting and organizing information to help clinicians quickly read up on a patient's history.

## SQL query

#### SQL

```sql
WITH explicitpatients_ers AS (SELECT er.id AS expid
            FROM experiencerrelation er
                    JOIN entity e
                            ON er.experiencer_id = e.id -- NOTE: find experience(r) entities
                    JOIN foundentity fe
                            ON fe.id = e.entity_id AND e.type_='found'-- IMPORTANT: e.entity_id not e.id
                    JOIN foundentityconcept fec
                            ON fe.id = fec.found_entity_id
                    JOIN concept c
                            ON c.concept_id = fec.concept_id AND c.ontology = fec.concept_ontology
            WHERE c.ontology = 'snomed' -- alternative ontology 'umls_nci' (UMLS metathesaurus)
                AND e.type_ = 'found'     -- IMPORTANT: this condition is required.
                AND c.concept_id = '116154003'), -- SNOMED CT concept id for patient
    implicitpatients_ers AS (SELECT er.id AS expid
            FROM entity e
                    JOIN experiencerrelation er
                            ON er.experiencer_id = e.id -- NOTE: experience(r) entities
                    JOIN assumedentity ae
                            ON ae.id = e.entity_id
            WHERE e.type_ = 'assumed'
                AND ae.value = 'patient'),
    patient_ers AS ( -- experiencer relations where subject is patient
        SELECT expid
        FROM implicitpatients_ers
        UNION
        SELECT expid
        FROM explicitpatients_ers
),
summary AS (
    SELECT row_number() OVER ( PARTITION BY c.description ORDER BY DATE(dm.chartdate) DESC ) AS rank,
        DATE(dm.chartdate)                                                                AS chartdate,
        CASE fet.type_name
            WHEN 'Disease or Syndrome' THEN 'Abnormalities / Disorders'
            WHEN 'Acquired Abnormality' THEN 'Abnormalities / Disorders'
            WHEN 'Anatomical Abnormality' THEN 'Abnormalities / Disorders'
            WHEN 'Congenital Abnormality' THEN 'Abnormalities / Disorders' --? Add
            WHEN 'Pathologic Function' THEN 'Abnormalities / Disorders'
            WHEN 'Cell or Molecular Dysfunction' THEN 'Abnormalities / Disorders'
            WHEN 'Neoplastic Process' THEN 'Neoplasia / Cancer'
            WHEN 'Injury or Poisoning' THEN 'Injuries / Trauma'
            WHEN 'Sign or Symptom' THEN 'Findings / Symptoms'
            WHEN 'Finding' THEN 'Findings / Symptoms'
            WHEN 'Mental or Behavioral Dysfunction' THEN 'Mental / Behavioral Disorders'
            WHEN 'Diagnostic Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Laboratory Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Laboratory or Test Result' THEN 'Procedures / Care Activities'
            WHEN 'Therapeutic or Preventive Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Health Care Activity' THEN 'Procedures / Care Activities'
            ELSE 'Unknown'
            END                                                                           AS heading,
        c.description                                                                     AS concept,
        fe.text                                                                          AS term
        -- sl.text                                                                           AS sentence
    FROM patient_ers
            JOIN experiencerrelation er
                ON patient_ers.expid = er.id
            JOIN entity e
                ON er.experienced_id = e.id -- NOTE: experience(d) entities
            JOIN foundentity fe
                ON fe.id = e.entity_id AND e.type_ = 'found'
            JOIN foundentityconcept fec ON fe.id = fec.found_entity_id
            JOIN concept c ON c.concept_id = fec.concept_id AND c.ontology = fec.concept_ontology
            JOIN foundentitytype fet ON fet.found_entity_id = fe.id
        -- Uncomment to access patient/chart data if available in documentmetadata:
            JOIN document d ON d.id = e.document_id
            JOIN documentmetadata dm ON d.id = dm.document_id
            JOIN foundentitylocation fel ON fe.id = fel.found_entity_id
            JOIN location l ON fel.location_id = l.id AND (l.type_ = 'sentence')
            JOIN sentencelocation sl ON sl.id = l.location_id
    WHERE c.ontology = 'snomed'
    AND fet.ontology = 'umls'
    AND dm.subject_id = '11110003'
    AND fe.polarity = 'asserted'
    AND fe.uncertainty = 'certain'
    AND fet.type_name IN ('Disease or Syndrome', 'Acquired Abnormality', 'Cell or Molecular Dysfunction',
                            'Anatomical Abnormality', 'Pathologic Function', 'Neoplastic Process',
                            'Injury or Poisoning',
                            'Sign or Symptom', 'Finding', 'Mental or Behavioral Dysfunction', 'Diagnostic Procedure',
                            'Laboratory Procedure', 'Therapeutic or Preventive Procedure', 'Laboratory or Test Result',
                            'Congenital Abnormality', 'Health Care Activity')
)
SELECT * FROM summary WHERE rank = 1 -- get latest mention of any concept
ORDER BY summary.heading, summary.chartdate DESC;
```

#### Snowflake

```sql
WITH distinct_concepts AS (SELECT DISTINCT * FROM concept),
WITH explicitpatients_ers AS (SELECT er.id AS expid
            FROM experiencerrelation er
                    JOIN entity e
                            ON er.experiencer_id = e.id -- NOTE: find experience(r) entities
                    JOIN foundentity fe
                            ON fe.id = e.entity_id AND e.type_='found'-- IMPORTANT: e.entity_id not e.id
                    JOIN foundentityconcept fec
                            ON fe.id = fec.found_entity_id
                    JOIN distinct_concepts c
                            ON c.concept_id = fec.concept_id AND c.ontology = fec.concept_ontology
            WHERE c.ontology = 'snomed' -- alternative ontology 'umls_nci' (UMLS metathesaurus)
                AND e.type_ = 'found'     -- IMPORTANT: this condition is required.
                AND c.concept_id = '116154003'), -- SNOMED CT concept id for patient
    implicitpatients_ers AS (SELECT er.id AS expid
            FROM entity e
                    JOIN experiencerrelation er
                            ON er.experiencer_id = e.id -- NOTE: experience(r) entities
                    JOIN assumedentity ae
                            ON ae.id = e.entity_id
            WHERE e.type_ = 'assumed'
                AND ae.value = 'patient'),
    patient_ers AS ( -- experiencer relations where subject is patient
        SELECT expid
        FROM implicitpatients_ers
        UNION
        SELECT expid
        FROM explicitpatients_ers
),
summary AS (
    SELECT row_number() OVER ( PARTITION BY c.description ORDER BY DATE(dm.chartdate) DESC ) AS rank,
        DATE(dm.chartdate)                                                                as chartdate,
        CASE fet.type_name
            WHEN 'Disease or Syndrome' THEN 'Abnormalities / Disorders'
            WHEN 'Acquired Abnormality' THEN 'Abnormalities / Disorders'
            WHEN 'Anatomical Abnormality' THEN 'Abnormalities / Disorders'
            WHEN 'Congenital Abnormality' THEN 'Abnormalities / Disorders'
            WHEN 'Pathologic Function' THEN 'Abnormalities / Disorders'
            WHEN 'Cell or Molecular Dysfunction' THEN 'Abnormalities / Disorders'
            WHEN 'Neoplastic Process' THEN 'Neoplasia / Cancer'
            WHEN 'Injury or Poisoning' THEN 'Injuries / Trauma'
            WHEN 'Sign or Symptom' THEN 'Findings / Symptoms'
            WHEN 'Finding' THEN 'Findings / Symptoms'
            WHEN 'Mental or Behavioral Dysfunction' THEN 'Mental / Behavioral Disorders'
            WHEN 'Diagnostic Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Laboratory Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Laboratory or Test Result' THEN 'Procedures / Care Activities'
            WHEN 'Therapeutic or Preventive Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Health Care Activity' THEN 'Procedures / Care Activities'
            ELSE 'Unknown'
            END                                                                           as heading,
        c.description                                                                     as concept,
        fe.text                                                                          as anno_text
        -- sl.text                                                                           as sentence
    FROM patient_ers
            JOIN experiencerrelation er
                ON patient_ers.expid = er.id
            JOIN entity e
                ON er.experienced_id = e.id -- NOTE: experience(d) entities
            JOIN foundentity fe
                ON fe.id = e.entity_id AND e.type_ = 'found'
            JOIN foundentityconcept fec ON fe.id = fec.found_entity_id
            JOIN distinct_concepts c ON c.concept_id = fec.concept_id AND c.ontology = fec.concept_ontology
            JOIN foundentitytype fet ON fet.found_entity_id = fe.id
        -- Uncomment to access patient/chart data if available in documentmetadata:
            JOIN document d ON d.id = e.document_id
            JOIN documentmetadata dm ON d.id = dm.document_id
            JOIN foundentitylocation fel ON fe.id = fel.found_entity_id
            JOIN location l ON fel.location_id = l.id AND (l.type_ = 'sentence')
            JOIN sentencelocation sl ON sl.id = l.location_id
    WHERE c.ontology = 'snomed'
    AND fet.ontology = 'umls'
    AND dm.subject_id = '11110003'
    AND fe.polarity = 'asserted'
    AND fe.uncertainty = 'certain'
    AND fet.type_name IN ('Disease or Syndrome', 'Acquired Abnormality', 'Cell or Molecular Dysfunction',
                            'Anatomical Abnormality', 'Pathologic Function', 'Neoplastic Process',
                            'Injury or Poisoning',
                            'Sign or Symptom', 'Finding', 'Mental or Behavioral Dysfunction', 'Diagnostic Procedure',
                            'Laboratory Procedure', 'Therapeutic or Preventive Procedure', 'Laboratory or Test Result',
                            'Congenital Abnormality', 'Health Care Activity')
)
SELECT * FROM summary WHERE rank = 1 -- get latest mention of any concept
ORDER BY summary.heading, summary.chartdate DESC;
```

#### Microsoft SQL Server

```sql
WITH explicitpatients_ers AS (SELECT er.id AS expid
        FROM experiencerrelation er
                JOIN entity e
                        ON er.experiencer_id = e.id -- NOTE: find experience(r) entities
                JOIN foundentity fe
                        ON fe.id = e.entity_id AND e.type_='found'-- IMPORTANT: e.entity_id not e.id
                JOIN foundentityconcept fec
                        ON fe.id = fec.found_entity_id
                JOIN concept c
                        ON c.concept_id = fec.concept_id AND c.ontology = fec.concept_ontology
        WHERE c.ontology = 'snomed' -- alternative ontology 'umls_nci' (UMLS metathesaurus)
            AND e.type_ = 'found'     -- IMPORTANT: this condition is required.
            AND c.concept_id = '116154003'), -- SNOMED CT concept id for patient
implicitpatients_ers AS (SELECT er.id AS expid
        FROM entity e
                JOIN experiencerrelation er
                        ON er.experiencer_id = e.id -- NOTE: experience(r) entities
                JOIN assumedentity ae
                        ON ae.id = e.entity_id
        WHERE e.type_ = 'assumed'
            AND ae.value = 'patient'),
patient_ers AS ( -- experiencer relations where subject is patient
    SELECT expid
    FROM implicitpatients_ers
    UNION
    SELECT expid
    FROM explicitpatients_ers
),
summary AS (
    SELECT row_number() OVER ( PARTITION BY c.description ORDER BY CONVERT( DATE, dm.chartdate) DESC ) AS rank,
        CONVERT(DATE, dm.chartdate)                                                                AS chartdate,
        CASE fet.type_name
            WHEN 'Disease or Syndrome' THEN 'Abnormalities / Disorders'
            WHEN 'Acquired Abnormality' THEN 'Abnormalities / Disorders'
            WHEN 'Anatomical Abnormality' THEN 'Abnormalities / Disorders'
            WHEN 'Congenital Abnormality' THEN 'Abnormalities / Disorders' --? Add
            WHEN 'Pathologic Function' THEN 'Abnormalities / Disorders'
            WHEN 'Cell or Molecular Dysfunction' THEN 'Abnormalities / Disorders'
            WHEN 'Neoplastic Process' THEN 'Neoplasia / Cancer'
            WHEN 'Injury or Poisoning' THEN 'Injuries / Trauma'
            WHEN 'Sign or Symptom' THEN 'Findings / Symptoms'
            WHEN 'Finding' THEN 'Findings / Symptoms'
            WHEN 'Mental or Behavioral Dysfunction' THEN 'Mental / Behavioral Disorders'
            WHEN 'Diagnostic Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Laboratory Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Laboratory or Test Result' THEN 'Procedures / Care Activities' --? Add
            WHEN 'Therapeutic or Preventive Procedure' THEN 'Procedures / Care Activities'
            WHEN 'Health Care Activity' THEN 'Procedures / Care Activities'
            ELSE 'Unknown'
            END                                                                           AS heading,
        c.description                                                                     AS concept,
        fe.text                                                                          AS term
        -- sl.text                                                                           AS sentence
    FROM patient_ers
            JOIN experiencerrelation er
                ON patient_ers.expid = er.id
            JOIN entity e
                ON er.experienced_id = e.id -- NOTE: experience(d) entities
            JOIN foundentity fe
                ON fe.id = e.entity_id AND e.type_ = 'found'
            JOIN foundentityconcept fec ON fe.id = fec.found_entity_id
            JOIN concept c ON c.concept_id = fec.concept_id AND c.ontology = fec.concept_ontology
            JOIN foundentitytype fet ON fet.found_entity_id = fe.id
        -- Uncomment to access patient/chart data if available in documentmetadata:
            JOIN document d ON d.id = e.document_id
            JOIN documentmetadata dm ON d.id = dm.document_id
            JOIN foundentitylocation fel ON fe.id = fel.found_entity_id
            JOIN location l ON fel.location_id = l.id AND (l.type_ = 'sentence')
            JOIN sentencelocation sl ON sl.id = l.location_id
    WHERE c.ontology = 'snomed'
    AND fet.ontology = 'umls'
    AND dm.subject_id = '11110003'
    AND fe.polarity = 'asserted'
    AND fe.uncertainty = 'certain'
    AND fet.type_name IN ('Disease or Syndrome', 'Acquired Abnormality', 'Cell or Molecular Dysfunction',
                            'Anatomical Abnormality', 'Pathologic Function', 'Neoplastic Process',
                            'Injury or Poisoning',
                            'Sign or Symptom', 'Finding', 'Mental or Behavioral Dysfunction', 'Diagnostic Procedure',
                            'Laboratory Procedure', 'Therapeutic or Preventive Procedure', 'Laboratory or Test Result',
                            'Congenital Abnormality', 'Health Care Activity')
)
SELECT * FROM summary WHERE rank = 1 -- get latest mention of any concept
ORDER BY summary.heading, summary.chartdate DESC;
```

| rank | chartdate  | heading                   | concept                                                                                      | term                                                  |
| ---- | ---------- | ------------------------- | -------------------------------------------------------------------------------------------- | ----------------------------------------------------- |
| 1    | 2022-09-30 | Abnormalities / Disorders | Subscapularis tendinitis (disorder)                                                          | subscapularis tendinosis                              |
| 1    | 2022-09-30 | Abnormalities / Disorders | Hypertrophic osteoarthropathy (disorder)                                                     | hypertrophic osteoarthropathy                         |
| 1    | 2022-09-30 | Abnormalities / Disorders | Tendinosis (disorder)                                                                        | tendinosis                                            |
| 1    | 2022-09-30 | Abnormalities / Disorders | Supraspinatus tendinitis (disorder)                                                          | supraspinatus tendinosis                              |
| 1    | 2022-09-30 | Abnormalities / Disorders | Narrowing (morphologic abnormality)                                                          | narrowing                                             |
| 1    | 2022-09-30 | Abnormalities / Disorders | Degenerative abnormality (morphologic abnormality)                                           | degenerative                                          |
| 1    | 2022-08-08 | Abnormalities / Disorders | Hypertensive disorder, systemic arterial (disorder)                                          | Hypertension                                          |
| 1    | 2022-08-08 | Abnormalities / Disorders | Osteoporosis (disorder)                                                                      | Osteoporosis                                          |
| 1    | 2022-08-08 | Abnormalities / Disorders | Ulcer of mouth (disorder)                                                                    | sores in his mouth                                    |
| 1    | 2022-08-08 | Abnormalities / Disorders | Osteoarthritis (disorder)                                                                    | Osteoarthritis                                        |
| 1    | 2022-08-08 | Abnormalities / Disorders | Labile hypertension due to being in a clinical environment (disorder)                        | office hypertension                                   |
| 1    | 2022-03-29 | Abnormalities / Disorders | Synovial cyst of knee (disorder)                                                             | Baker's cyst                                          |
| 1    | 2022-03-29 | Abnormalities / Disorders | Edema (finding)                                                                              | edema                                                 |
| 1    | 2022-03-29 | Abnormalities / Disorders | Soft tissue swelling (finding)                                                               | subcutaneous edema                                    |
| 1    | 2022-03-29 | Abnormalities / Disorders | Edema of bilateral lower limbs (finding)                                                     | Lower extremity edema bilaterally                     |
| 1    | 2022-03-13 | Abnormalities / Disorders | Hypercholesterolemia (disorder)                                                              | Hypercholesterolemia                                  |
| 1    | 2022-03-13 | Abnormalities / Disorders | Alzheimer's disease (disorder)                                                               | Alzheimer's disease                                   |
| 1    | 2022-03-13 | Abnormalities / Disorders | Aortoiliac atherosclerosis (disorder)                                                        | atherosclerotic disease of the aortoiliac vessels     |
| 1    | 2022-03-13 | Abnormalities / Disorders | Gastrointestinal hemorrhage (disorder)                                                       | gastrointestinal bleed                                |
| 1    | 2022-03-13 | Abnormalities / Disorders | Infectious disease (disorder)                                                                | INFECTIOUS DISEASE                                    |
| 1    | 2022-03-13 | Abnormalities / Disorders | Hypervolemia (finding)                                                                       | volume overloaded                                     |
| 1    | 2022-03-13 | Abnormalities / Disorders | Calcification of coronary artery (disorder)                                                  | coronary artery calcification                         |
| 1    | 2022-03-13 | Abnormalities / Disorders | Surgical incision wound (morphologic abnormality)                                            | operative incisions                                   |
| 1    | 2022-03-13 | Abnormalities / Disorders | Cardiac arrest (disorder)                                                                    | arrest                                                |
| 1    | 2022-03-13 | Abnormalities / Disorders | Ulcer of foot (disorder)                                                                     | foot ulcers                                           |
| 1    | 2022-03-13 | Abnormalities / Disorders | Cardiorespiratory arrest (disorder)                                                          | cardiorespiratory arrest                              |
| 1    | 2022-03-13 | Abnormalities / Disorders | Cellulitis of right foot (disorder)                                                          | Right pedal cellulitis                                |
| 1    | 2022-03-13 | Abnormalities / Disorders | Cellulitis of right lower limb (disorder)                                                    | right lower extremity cellulitis                      |
| 1    | 2022-03-13 | Abnormalities / Disorders | Acute kidney injury (disorder)                                                               | acute renal failure                                   |
| 1    | 2022-03-13 | Abnormalities / Disorders | Congestive heart failure (disorder)                                                          | Congestive heart failure                              |
| 1    | 2022-03-13 | Abnormalities / Disorders | Sepsis caused by Gram negative bacteria (disorder)                                           | gram-negative urosepsis                               |
| 1    | 2022-03-13 | Abnormalities / Disorders | Cyst of pancreas (disorder)                                                                  | pancreatic cyst                                       |
| 1    | 2022-03-13 | Abnormalities / Disorders | Triple vessel disease of the heart (disorder)                                                | Coronary artery disease with diffuse 3-vessel disease |
| 1    | 2022-03-13 | Abnormalities / Disorders | Right ventricular failure (disorder)                                                         | right-sided failure                                   |
| 1    | 2022-03-13 | Abnormalities / Disorders | Diabetes mellitus type 2 (disorder)                                                          | Type 2 diabetes mellitus                              |
| 1    | 2022-03-13 | Abnormalities / Disorders | Right dominant coronary system (disorder)                                                    | right-dominant system                                 |
| 1    | 2022-03-13 | Abnormalities / Disorders | Peripheral vascular disease (disorder)                                                       | peripheral vascular disease;                          |
| 1    | 2022-03-13 | Abnormalities / Disorders | Essential hypertension (disorder)                                                            | Essential hypertension                                |
| 1    | 2022-03-13 | Abnormalities / Disorders | Diverticulitis (disorder)                                                                    | diverticulitis                                        |
| 1    | 2022-03-13 | Abnormalities / Disorders | Diverticulosis of colon (finding)                                                            | colonic diverticulosis                                |
| 1    | 2022-03-13 | Abnormalities / Disorders | Multiple diverticula of intestine (finding)                                                  | Diverticulosis                                        |
| 1    | 2022-03-13 | Abnormalities / Disorders | Occlusion of distal portion of anterior descending branch of left coronary artery (disorder) | occlusion of the distal LAD                           |
| 1    | 2022-03-13 | Abnormalities / Disorders | Myocardial infarction (disorder)                                                             | Myocardial infarction                                 |
| 1    | 2022-03-03 | Abnormalities / Disorders | Ganglion cyst (morphologic abnormality)                                                      | ganglion                                              |
| 1    | 2022-03-03 | Abnormalities / Disorders | Morphologically abnormal structure (morphologic abnormality)                                 | defect                                                |
| 1    | 2022-03-03 | Abnormalities / Disorders | Ganglion of wrist (disorder)                                                                 | Wrist ganglion                                        |
| 1    | 2022-02-22 | Abnormalities / Disorders | Gastroesophageal reflux disease (disorder)                                                   | gastroesophageal reflux disease                       |
| 1    | 2022-02-22 | Abnormalities / Disorders | Sinus bradycardia (disorder)                                                                 | Sinus bradycardia                                     |
| 1    | 2022-02-22 | Abnormalities / Disorders | Rectal hemorrhage (disorder)                                                                 | rectal bleeding                                       |
| 1    | 2022-02-16 | Abnormalities / Disorders | Nodule (morphologic abnormality)                                                             | nodules                                               |

## Related links

* [Entity-level Tables](/nlp/database/schema/core/entity-tables)
* [Experiencer Relations](/nlp/database/schema/relations/experiencer)