PAT_IMG_EXT_PROC

Description: |
This table contains the list of external imaging procedures performed on the patient and entered in the Comparison Studies activity. It includes the procedure (EAP) ID, facility, exam date, and comments.

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 | EXT_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
4 | EXT_PROC_DATE | DATETIME | No |
The performed date of the external procedure that used for comparison studies.
5 | EXT_PROC_CMT | VARCHAR | No |
Comments entered for an external procedure used for comparison studies.
6 | EXT_PROC_DEL_YN | VARCHAR | No |
Indicates whether an external procedure (used for comparison studies) has been deleted. 'Y' indicates the external procedure has been deleted.
May contain organization-specific values: No
Category Entries:
No
Yes
7 | EXT_PROC_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.