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