|
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 |
| Unspecified |
|
|
| 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: |
| Provider Judgment |
| Currently Irrelevant |
| Wrong Patient |
| Wrong Phenotype |
| Not Observed |
| Too Specific |
| Not Specific Enough |
|
|
