IMG_COMP_EXTERNAL
Description:
This stores comparison study data for externally performed procedures.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier for the order record.
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 COMP_EXT_LINE INTEGER No
The line number that corresponds with the patient's list of externally performed studies. Use it to join to the table PAT_IMG_EXT_PROCS on the LINE column.
4 EXT_CHNG_AMT_C_NAME VARCHAR No
The comparison studies amount of change category ID for the external procedure order in the COMP_EXT_LINE column.
May contain organization-specific values: Yes
Category Entries:
No Comparison
No Significant Change
Significant Change
Not Otherwise Specified