PAT_REVIEW_DATA
Description:
Table contains patient entered clinical data review from Welcome Kiosk and MyChart.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
2 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
3 PAT_ENC_DATE_REAL FLOAT No
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the 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.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 PAT_REVIEW_ELG_C_YN VARCHAR No
Patient allergies reviewed by the patient. The response to the prompt, "do you have any additional allergies?"
May contain organization-specific values: No
Category Entries:
Yes
No
6 PAT_REVIEW_ORD_C_YN VARCHAR No
Patient medications reviewed by the patient. The response to the prompt, "do you have any additional medications?"
The category values for this column were already listed for column: PAT_REVIEW_ELG_C_YN
7 PAT_REVIEW_LPL_C_YN VARCHAR No
Patient problems reviewed by the patient. The response to the prompt, "do you have any additional problems?"
The category values for this column were already listed for column: PAT_REVIEW_ELG_C_YN
8 PAT_ALG_RVW_INFO_C_NAME VARCHAR No
The patient's response to the "are these allergies correct?" question in Welcome.
May contain organization-specific values: Yes
Category Entries:
Patient indicated correct
Don't have time
Don't understand
Don't have medications with me
Can't find allergy
Can't find medication
Can't find health issue
Don't know details of allergies
Don't know details of medications
Don't know details of health issues
Exited before allergies were verified
Exited before medications were verified
Exited before health issues were verified
9 PAT_MED_RVW_INFO_C_NAME VARCHAR No
The patient's response to the "are these medications correct?" question in Welcome.
The category values for this column were already listed for column: PAT_ALG_RVW_INFO_C_NAME
10 PAT_PROB_RVW_INFO_C_NAME VARCHAR No
The patient's response to the "are these problems correct?" question in Welcome.
The category values for this column were already listed for column: PAT_ALG_RVW_INFO_C_NAME
11 ENC_PHR_VERIF_INST_UTC_DTTM DATETIME (UTC) No
The last instant that a patient's encounter pharmacy was updated or verified.
12 ENC_PHR_VERIF_AUDIT_CONTEXT_C_NAME VARCHAR No
The context of the last update or verification of a patient's encounter pharmacy.
May contain organization-specific values: No
Category Entries:
End-User
Patient
Background Process
13 ENC_PHR_VERIF_USER_ID VARCHAR No
The user that last updated or verified the patient's encounter pharmacy.
14 ENC_PHR_VERIF_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 ENC_PHR_VERIF_MYPT_ID VARCHAR No
The MyChart user that last updated or verified the patient's encounter pharmacy.