|
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 |
|
|