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