PAT_PHENO

Description: |
This table contains information about a patient's phenotypes as they are documented over time.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_PHENO_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_PHENO_ID | NUMERIC | No |
The unique identifier for the phenotype 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 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
4 | PAT_ENC_CSN_ID | NUMERIC | No |
The contact serial number for the patient encounter when the phenotypic term was assigned or updated.
5 | UPDATE_USER_ID | VARCHAR | No |
The user that updated the patient phenotype.
6 | UPDATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | COMMENT_NOTE_CSN_ID | NUMERIC | No |
The contact serial number for a comment providing additional details surrounding the patient phenotype.
8 | PAT_PHENO_STATUS_C_NAME | VARCHAR | No |
The current status of the patient phenotype.
May contain organization-specific values: No
Category Entries:
Positive
Negative
Resolved
Removed
9 | CREATION_LOCAL_DTTM | DATETIME (Local) | No |
The instant that the phenotype contact was created.
10 | DOC_DATE | DATETIME | No |
The date a phenotype was documented or updated. This may differ from CONTACT_DATE in the circumstance of historical records being imported into the database.
11 | PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
12 | PAT_PHENO_ENTRY_SRC_C_NAME | VARCHAR | No |
The entry source for the creation or update of a phenotype.
May contain organization-specific values: No
Category Entries:
Manual Entry
Imported
AI Extracted
13 | PAT_PHENO_REMOVAL_RSN_C_NAME | VARCHAR | No |
The removal reason category ID for the patient phenotype.
May contain organization-specific values: No
Category Entries:
Entered in error
More appropriate term found
More specific term found
More general term found
Not provided
14 | PAT_PHENO_VERIF_STAT_C_NAME | VARCHAR | No |
Populated for phenotypes generated by AI extraction. Indicates whether the phenotype has been reconciled or dismissed by a human.
May contain organization-specific values: No
Category Entries:
Unverified
Verified
Dismissed
15 | PAT_PHENO_RSN_DISMISS_C_NAME | VARCHAR | No |
Discrete reason for dismissing or verifying a phenotype extracted by AI. Used for generative AI feedback metrics.
May contain organization-specific values: Yes
Category Entries:
Not specific enough
Too specific
Not relevant for patient
Phenotype not in note
Other