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