PATIENT_PHOTO_ACTION_HX

Description: |
History of actions taken on the Patient Photo checklist section.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | 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.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | PATIENT_PHOTO_ACTION_TAKEN_C_NAME | VARCHAR | No |
The action taken on the Patient Photo checklist section
May contain organization-specific values: No
Category Entries:
Collect
Decline
Ask Later
Ignored
4 | PATIENT_PHOTO_USER_ID | VARCHAR | No |
User who took the action on the Patient Photo checklist section
5 | PATIENT_PHOTO_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | PHOTO_TIMESTAMP_UTC_DTTM | DATETIME (UTC) | No |
Date and time the action was taken on the Patient Photo checklist section
7 | PHOTO_LOGIN_DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
8 | PHOTO_ENC_DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
9 | PHOTO_ENC_DEPARTMENT_DTTM | DATETIME (Local) | No |
Date and time the action was taken on the Patient Photo checklist section in the timezone of the encounter department
10 | PHOTO_LOGIN_DEPARTMENT_DTTM | DATETIME (Local) | No |
Date and time the action was taken on the Patient Photo checklist section in the timezone of the login department