OPH_IPROC_INFO
Description:
This table stores results data for the questions (LQL) configured for use with the Imaging and Procedures visit navigator section.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
This column stores 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 IPROC_QUEST_ID_QUEST_NAME VARCHAR No
The name of the question record.
4 IPROC_PROMPT VARCHAR No
Stores the prompt for multiple response imaging or procedure result form questions.
5 IPROC_COMMENT VARCHAR No
Stores the comment related to an imaging or procedure result finding.
6 IPROC_USER_ID VARCHAR No
Stores the user who entered the most recent imaging or procedure result information.
7 IPROC_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 IPROC_UPDATED_INST_DTTM DATETIME (Local) No
Stores the instant of entry for the most recent imaging or procedure result information.
9 IPROC_LATERALITY_C_NAME VARCHAR No
Stores the laterality for the imaging or procedure result information.
May contain organization-specific values: No
Category Entries:
Right
Left
None