Info
Dashboard Overview:
The Perioperative Executive Summary interactive report displays data relating to the appointment volume generated within the Workflow IQ® solution. The dashboard displays various metrics such as Total Cases, First-Case On-Time Starts, Same-Day Add-ons and Cancellations, Average First-Case Start Delay, among others.
Data Source Overview:
Workflow Procedure Appointment is a Standard Lane data source showing Appointment data from Workflow IQ®. Each row in this data source shows an individual appointment. The unique identifier for this dataset is an Appointment_Id. This data source contains historical data and has a latency of ~45-90 minutes.
Snowflake Field Name | Tableau Data Source Field | Folder | Description |
Actual Appointment End Timestamp | Actual Appointment End Timestamp | Root | The time that the patient left the OR |
Actual Appointment End Timestamp UTC | Actual Appointment End Timestamp UTC | Root | The time that the patient left the OR in UTC |
Actual Appointment Start Timestamp | Actual Appointment Start Timestamp | Root | The time that the patient entered the OR |
Actual Appointment Start Timestamp UTC | Actual Appointment Start Timestamp UTC | Root | The time that the patient entered the OR in UTC |
Actual Patient Arrival Timestamp | Actual Patient Arrival Timestamp | Root | The time that the patient arrived at registration |
Actual Patient Arrival Timestamp UTC | Actual Patient Arrival Timestamp UTC | Root | The time that the patient arrived at registration in UTC |
Actual Procedure Enterprise | Actual Procedure Enterprise | Root | The parent organization of the actual procedure location |
Actual Procedure Enterprise ID | Actual Procedure Enterprise ID | Root | The ID of the parent organization of the actual procedure location |
Actual Procedure Facility | Actual Procedure Facility | Root | The campus/facility of the actual procedure location |
Actual Procedure Facility ID | Actual Procedure Facility ID | Root | The ID of the campus/facility of the actual procedure location |
Actual Procedure Location | Actual Procedure Location | Root | The specific Operating Room that the procedure occured in |
Actual Procedure Location ID | Actual Procedure Location ID | Root | The ID of the specific Operating Room that the procedure occured in |
Actual Unit | Actual Unit | Root | The specific Unit that the procedure occured in |
Actual Unit ID | Actual Unit ID | Root | The ID of the specific Unit that the procedure occured in |
Appointment Description | Appointment Description | Root | The description of the first procedure the occurs during the appointment |
Appointment ID | Appointment ID | Root | The unique identifying ID of the appointment |
Appointment Status | Appointment Status | Root | The manner in which the procedure was scheduled. Can be 'Scheduled' or 'Add On' |
Appointment Status Localized | Appointment Status Localized | Root | The standardized field for the manner in which the procedure was scheduled. Can be 'Scheduled' or 'Add On' |
Appointment Visit Type | Appointment Visit Type | Root | The defined type of the visit. Can be inpatient, outpatient, or bedside. |
Cancellation Timestamp | Cancellation Timestamp | Root | The time the appointment was cancelled |
Cancellation Timestamp UTC | Cancellation Timestamp UTC | Root | The time the appointment was cancelled in UTC |
Completion Timestamp | Completion Timestamp | Root | The time the appointment was completed |
Completion Timestamp UTC | Completion Timestamp UTC | Root | The time the appointment was completed in UTC |
Createddate | Createddate | Root | The date and time the appointment was created |
Createddate Utc | Createddate Utc | Root | The date and time the appointment was created in UTC |
Customer Facility ID | Customer Facility ID | Root | A unique identifier of the facility associated with the appointment. This is not intended for client report building. |
InstanceID | InstanceID | Root | System calculation used for data partitioning. It is not intended for client reporting. |
Is Addon | Is Addon | Root | Denotes if the case was an add-on case or was scheduled prior to the day of the appointment |
Is First Case | Is First Case | Root | Denotes if the case is the first appointment in the scheduled OR for the day |
Is Same Day Cancellation | Is Same Day Cancellation | Root | Denotes if the case was cancelled on the same day it was scheduled to take place |
Lastmoddate | Lastmoddate | Root | System calculation that displays the most recent update to the application database |
Lastmoddate Utc | Lastmoddate Utc | Root | System calculation that displays the most recent update to the application database in UTC |
Ongoing Timestamp | Ongoing Timestamp | Root | The time the patient's appointment was marked as in progress |
Ongoing Timestamp UTC | Ongoing Timestamp UTC | Root | The time the patient's appointment was marked as in progress in UTC |
Patient Dob | Patient Dob | Root | The patient's date of birth |
Patient First Name | Patient First Name | Root | The patient's first name |
Patient Gender | Patient Gender | Root | The patient's gender |
Patient ID | Patient ID | Root | The unique identifier for a patient |
Patient Last Name | Patient Last Name | Root | The patient's last name |
Patient Mrn | Patient Mrn | Root | The medical record number for the patient |
Patient Visit ID | Patient Visit ID | Root | The unique identifier for the patient's visit |
Patient Visit Number | Patient Visit Number | Root | The visit number for the patient |
Patient Visit Type | Patient Visit Type | Root | The defined type of the visit for the patient. Can be inpatient, outpatient, or bedside. |
Scheduled Department | Scheduled Department | Root | The relevant department responsible for the appointment (Cardiology, Gastro, etc) |
Scheduled Department ID | Scheduled Department ID | Root | The ID of the department responsible for the appointment |
Scheduled Procedure Enterprise | Scheduled Procedure Enterprise | Root | The parent organization of the scheduled procedure location |
Scheduled Procedure Enterprise ID | Scheduled Procedure Enterprise ID | Root | The ID of the parent organization of the scheduled procedure location |
Scheduled Procedure Facility | Scheduled Procedure Facility | Root | The campus/facility of the scheduled procedure location |
Scheduled Procedure Facility ID | Scheduled Procedure Facility ID | Root | The ID of the campus/facility of the scheduled procedure location |
Scheduled Procedure Location | Scheduled Procedure Location | Root | The specific Operating Room that the procedure is scheduled to occur in |
Scheduled Procedure Location ID | Scheduled Procedure Location ID | Root | The ID of the specific Operating Room that the procedure is scheduled to occur in |
Scheduled Timestamp | Scheduled Timestamp | Root | The date and time the appointment is scheduled to begin |
Scheduled Timestamp UTC | Scheduled Timestamp UTC | Root | The date and time the appointment is scheduled to begin in UTC |
Scheduled Unit | Scheduled Unit | Root | The unit name for the location of the appointment |
Scheduled Unit ID | Scheduled Unit ID | Root | The ID of the unit for the location of the appointment |
TenantID | TenantID | Root | The unique identifier associated with the tenant. This field is not intended for client reporting. |
Warehouseacquisitiondate Utc | Warehouseacquisitiondate Utc | Root | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format |
Actual Appointment Duration | Actual Appointment Duration | Root | The length of time the patient was in the OR |
Actual Start Difference | Actual Start Difference | Root | The difference in time between the Scheduled and Actual start timestamps. If the case did not have a delay, this field will be NULL |
Scheduled Duration | Scheduled Duration | Root | The length of time the appointment is scheduled to take |
| Date Filter Range | Root | A field used to determine which records to include based on the created date/time |
| 7 Days Ago | Root | The date 7 days prior to the current date |
| Late vs On Time | Root | Determines if an appointment started late or on time by comparing the Actual Start Difference with the On Time Grace Period parameter |
| Today | Root | The current date based on the enterprise date time |
| Constant | Root | A field used to enable a Level of Detail calculation in Tableau |