GNOM_INTPRT_EFFECTS

Description: |
Discrete phenotypic effects predicted by an interpretation.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
GNOM_INTPRT_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | GNOM_INTPRT_ID | NUMERIC | No |
The unique identifier (.1 item) for the interpretation record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | PHENOTYPE_EFFECT_TYPE_C_NAME | VARCHAR | No |
Stores the phenotypic effect type. This determines the possible values for Effect Value in I GNI 3001
May contain organization-specific values: No
Category Entries:
Metabolism
Efficacy
Risk
Transport
Enzyme Activity
5 | PHENOTYPE_EFFECT_VAL_C_NAME | VARCHAR | No |
Stores the phenotypic effect value of the effect type stored in I GNI 3000.
May contain organization-specific values: No
Category Entries:
Indeterminate
Increased function
Normal function
Decreased function
Uncertain function
Unknown function
No function
Ultrarapid metabolizer
Rapid metabolizer
Normal metabolizer
Intermediate metabolizer
Poor metabolizer
Likely ultrarapid metabolizer
Likely rapid metabolizer
Likely normal metabolizer
Likely intermediate metabolizer
Likely poor metabolizer
Possible ultrarapid metabolizer
Possible rapid metabolizer
Possible normal metabolizer
Possible intermediate metabolizer
Possible poor metabolizer
Resistant
Responsive
Benign
Presumed resistant
Presumed responsive
Presumed benign
Presumed non-responsive
Unknown significance
Low risk
High risk
Typical risk
Poor function
Likely increased function
Likely normal function
Likely decreased function
Likely poor function
Possible increased function
Possible normal function
Possible decreased function
Possible poor function
Deficient
Deficient with CNSHA
Normal
Variable
6 | ACT_SCORE_LOW | NUMERIC | No |
This item determines the lowest possible value for the activity score. If the activity score is a single value, this and the upper bound are equal to that value. If the activity score is a range and a lower bound is supplied, this item is equal to the lower bound. When the lower bound is not provided as part of the range, this item is equal to the universal lower bound (0).
7 | ACT_SCORE_UPPER | NUMERIC | No |
This item determines the highest possible value for the activity score. If the activity score is a single value, this and the lower bound are equal to that value. If the activity score is a range and an upper bound is supplied, this item is equal to the upper bound. When the upper bound is not provided as part of the range, this item is equal to the universal upper bound (99999).