OR_LOG_PANEL_TIME2

Description: |
The OR_LOG_PANEL_TIME2 table contains OR management system log panel timing information for the second panel.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
LOG_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | LOG_ID | VARCHAR | No |
The unique ID of the surgical log the panel time refers to.
2 | LINE | INTEGER | No |
The line number of the panel time in the surgical log.
3 | PANEL_TIME_EVENT_C_NAME | VARCHAR | No |
The event set up to take place in a panel in the surgical log.
May contain organization-specific values: Yes
4 | PANEL_START_TIME | DATETIME (Local) | No |
The date and time the event began in the surgical log.
5 | PANEL_END_TIME | DATETIME (Local) | No |
The date and time the event ended in the surgical log.
6 | PANEL_EVENT_ELPSD | INTEGER | No |
Indicates the total amount of time for the event in the surgical log.
7 | PANEL_PROC_ID | VARCHAR | No |
The unique ID of the surgical procedure, if this event is associated with a particular procedure.
8 | PANEL_PROC_ID_PROC_NAME | VARCHAR | No |
The name of the surgical procedure record.
9 | PANEL_EVENT_C_NAME | VARCHAR | No |
The panel level event. This line will be blank when a procedure level event was documented.
The category values for this column were already listed for column: PANEL_TIME_EVENT_C_NAME
10 | PROCEDURE_EVENT_C_NAME | VARCHAR | No |
The procedure level event. This line will be blank when a panel level event was documented.
The category values for this column were already listed for column: PANEL_TIME_EVENT_C_NAME
11 | INST_PNL2_INTER_UTC_DTTM | DATETIME (UTC) | No |
Instant of update for an event in panel 2. This will be used for Event Interval functionality.