PAT_INDICATOR

Description: |
The PAT_INDICATOR table contains information about your patient genomic indicator records. These include disease-related and drug-related genomic indicators linked to patients.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_INDICATOR_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_INDICATOR_ID | NUMERIC | No |
This column contains the unique identifier (.1 item) for the pt indicators record.
2 | GENOMIC_INDICATR_ID | NUMERIC | No |
This column contains the Genomic Indicator linked to this record.
3 | GENOMIC_INDICATR_ID_RESOLVED_PAT_FRIENDLY_NAME | VARCHAR | No |
This column provides an always populated name column that prioritizes the patient friendly name and if there is none specified, falls back to the clinical name.
4 | PAT_ID | VARCHAR | No |
The column contains the unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
5 | OVERVIEW_NOTE_ID | VARCHAR | No |
This column contains the overview note for the genomic indicator as linked to the patient. Patient-specific details about the genomic indicator are stored in the note networked to this item.
6 | RECORD_CREATION_DT | DATETIME | No |
This column contains the date the record was created.
7 | INSTANT_OF_UPD_DTTM | DATETIME (Local) | No |
This column contains the instant the record was last locked/unlocked.
8 | CREATION_SOURCE_C_NAME | VARCHAR | No |
The creation source for this patient genomic indicator. Blank values are treated as manually created indicators by the translation engine.
May contain organization-specific values: No
Category Entries:
Manual Entry
Translation Engine
Import
Translation Utility
Problem List Utility
9 | ACT_SCORE_LOWER | NUMERIC | No |
This item represents the lower bound of the manually entered activity score for the patient genomic indicator.
10 | ACT_SCORE_UPPER | NUMERIC | No |
This item represents the upper bound of the manually entered activity score for the patient genomic indicator.
11 | ACT_SCORE_SOURCE_C_NAME | VARCHAR | No |
This item represents whether the activity score in PGI 1040/1041 was sourced from manual entry, genotype-activity score mapping tables, or directly from a variant result.
May contain organization-specific values: No
Category Entries:
Resulted on a linked variant
Interpreted from a mapping table
Manually entered