PAT_PHOTO_HX

Description: |
Contains a list of Document Information (DCS) records that are in each patient's history of photos.

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 | DOCUMENT_ID | VARCHAR | No |
This column contains a list of all photos in the patient's history of photos. They may be images added to the chart or images that were submitted by the patient and ultimately rejected. To make this determination, see Photo History Approval Category (I DCS 50).