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