IP_EDU_HANDOUT_TRACK_HX

Description: |
Stores a history of all education patient materials marked as given or viewed by the patient.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PED_ID | NUMERIC | No |
The unique identifier (.1 item) for the education 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 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | HANDOUT_LINK_HX | VARCHAR | No |
Stores the handout link history for all patient handouts received by the patient.
6 | HANDOUT_NAME_HX | VARCHAR | No |
The handout name history for all patient handouts received.
7 | GIVEN_HX_USER_ID | VARCHAR | No |
Stores the user ID for all handouts that have been directly marked as given to the patient.
8 | GIVEN_HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | VIEWED_HX_MYPT_ID | VARCHAR | No |
Stores the history of all MyChart accounts that viewed the patient material.
10 | RECEVD_HX_INST_DTTM | DATETIME (Local) | No |
The instant history for any patient material that was received by the patient.
11 | SMARTTEXT_ID | VARCHAR | No |
The ETX ID history for all clinical references that have been viewed by the patient.
12 | SMARTTEXT_ID_SMARTTEXT_NAME | VARCHAR | No |
The name of the SmartText record.
13 | FDI_HX_CLIENT_IDENT | VARCHAR | No |
Stores the history of FDI Client IDs for all FDI handouts received by the patient
14 | DELETED_YN | VARCHAR | No |
Whether this handout has been marked as given or if the given status has been deleted.
May contain organization-specific values: No
Category Entries:
No
Yes
15 | HANDOUT_MAX_PROGRESS_HX | INTEGER | No |
Stores the max progress history in seconds of the video/audio handouts viewed by patient or proxies.
16 | HANDOUT_DURATION_HX | INTEGER | No |
Stores the duration history in seconds of the video/audio handouts assigned to patient.