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