Data Points
Tableau Data Source Field | Folder | Description |
ACQUISITIONDATE_UTC | System Calc | The first step in the data ingestion process. It is used internally for latency calculations. This field is not intended for client report building. |
Adjustable Clean Time Color | Custom Calc | A custom calculation used to determine colors/shapes for Clean Time best practices. It leverages the Clean Time Threshold parameter, which can be used to easily change thresholds. |
Adjustable Clean Time Variance Calc | Custom Calc | A custom calculation that shows the percent difference of the clean time compared to the threshold. |
Adjustable Overall Turn Color | Custom Calc | A custom calculation used to determine colors/shapes for Turn Time best practices. It leverages the Turn Time Threshold parameter, which can be used to easily change thresholds. |
Adjustable Response Time Color | Custom Calc | A custom calculation used to determine colors/shapes for Response Time best practices. It leverages the Response Time Threshold parameter, which can be used to easily change thresholds. |
Adjustable Response Time Variance Calc | Custom Calc | A custom calculation that shows the percent difference of the response time compared to the threshold. |
Adjustable Turn Time Variance Calc | Custom Calc | A custom calculation that shows the percent difference of the turn time compared to the threshold. |
Adjusted Cleans Flag | Root | A "Y" (yes) or "N" (no) value that shows bed cleaning jobs where clean time ≤5 minutes OR ≥ 60 minutes OR an original response ≥ 120 minutes. Calculation: Total In Progress Time ≤55 minutes OR > 60 minutes OR Response Time ≥120 minutes. This will not be applicable for Daily Cleans. |
BED_ADT_ID | System Calc | A unique identifier for the indiviual bed location. This is the bed ADT ID that is associated with the location for the bed cleaning job. This field is helpful in DWC. This will not be applicable for Daily Cleans. |
BED_COUNT | Root | The number of beds in the room associated with the Daily Clean job |
BLOCKED_BED_REASON | Root | Displays the reason why a bed was blocked during the duration of the bed cleaning job. This will be the most recent reason code for a blocked bed status while it was being cleaned. For example, if a bed is blocked during the course of a bed cleaning job, we will record the most recent reason for the blocked status during that cleaning job. This will not be applicable for Daily Cleans. |
BT Job ID | Root | The identifier assigned to the bed cleaning job that appears on the user interface. |
BT_JOB_SOURCE | Root | The Job source is determined by how the job was created in the Capacity IQ® application. Possible values include:Work Station - The job is created by an EVS user in a web browser.Handheld - The job is created by an EVS employee in the mobile application, typically through a found bed.Windows Service - The job is created through automated services, such as the HL7 Interface or Location IQ®. This will not be applicable for Daily Cleans. |
BT_JOB_SOURCE_CODE | System Calc | Workstation - The job is created by an EVS user in a web browser. This will not be applicable for Daily Cleans. |
BUILDING | Root | The physical structure where medical care is provided and which includes the bed that was cleaned. |
BUILDING_ID | Root | The unique identifier for the building where the cleaning job took place. |
Campus Name | Root | The name of the destination facility that accepts the transfer patient. |
CAMPUS_ID | Root | The unique identifier for the campus where the cleaning job took place. |
Cancelled Timestamp | Root | The date and local time of day when the bed cleaning job was cancelled. |
Cancelled Timestamp Enterprise | Root | The date and time of day in enterprise time when the bed cleaning job was cancelled. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Cancelled Timestamp UTC | Root | The date and time of day in UTC when the bed cleaning job was cancelled. |
CANCELLED_BY_USER | Root | The user who cancelled the bed cleaning job. |
CANCELLED_BY_USER_LOGIN_ID | System Calc | The unique username associated with the user who cancelled the bed cleaning job. |
CANCELLED_REASON | Root | The reason indicated when a user cancels a bed cleaning job. |
Clean Time | Custom Calc | The date difference in minutes between the inprogress timestamp and the completed timestamp. |
CLOUDACQUISITIONDATE_UTC | Root | The second step in the data ingestion process that is used internally for latency calculations. This field is not intended for client report building. |
Completed Timestamp | Root | The date and local time of day when a bed cleaning job was marked as complete. |
Completed Timestamp Enterprise | Root | The date and enterprise time of day when a bed cleaning job was marked as complete. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Completed Timestamp UTC | Root | The date and UTC time of day when a bed cleaning job was marked as complete. |
COMPLETED_BY_USER | Root | The user who set the bed cleaning job to a Completed status. |
COMPLETED_BY_USER_LOGIN_ID | System Calc | The unique username associated with the user who completed the bed cleaning job. |
Created Timestamp | Root | The date and local time when a bed cleaning job was created in Capacity IQ®. |
Created Timestamp (copy) | Custom Calc | A version of the Created Timestamp that only displays the date (without the timestamp). This is useful in custom calculations where a timestamp is not needed. |
Created Timestamp Enterprise | Root | The date and local enterprise time when a bed cleaning job was created in Capacity IQ®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Created Timestamp UTC | Root | The date and local UTC time when a bed cleaning job was created in Capacity IQ®. |
CREATEDDATE | Root | The date and local time when a bed cleaning job was created in Capacity IQ®. |
CREATEDDATE_ENTERPRISE | Root | The date and enterprise time when a bed cleaning job was created in Capacity IQ®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
CREATEDDATE_UTC | Root | The date and local UTC time when a bed cleaning job was created in Capacity IQ®. |
CUSTOMER_FACILITY_ID | System Calc | A unique identifier for a given campus that is defined in the Capacity IQ® campus settings for use with Transfer IQ® facility IDs—used more widely in DWC. |
DATEPARTITION | System Calc | System calculation used internally to partition the data for efficient processing. |
DELAY_TO_INPROGRESS | Root | It shows the time duration between the first delay and latest inprogress timestamp. This will not be applicable for Daily Cleans. |
DISCIPLINE | Root | The discipline set on the unit for the location of the bed cleaning job. The name of a group of specially related units, such as Behavioral Health, Med/Surgical, and Burn Units. |
DISCIPLINE_ID | System Calc | A system identifier for the unique discipline not visible to users of the application. |
EMPLOYEE_CATEGORY | Root | The group assigned to an EVS employee who most recently updated the job status. For example, if the job was cancelled, this will show the employee category of the employee who cancelled the job. |
ENTERPRISE | Root | The name of a collection of campuses that includes the bed that was cleaned. |
ENTERPRISE_ID | System Calc | A system identifier for the unique enterprise not visible to users of the application. |
EVENT_TIMESTAMP | Root | The date and local time that a bed cleaning job was created in Capacity IQ®. |
EVENT_TIMESTAMP_ENTERPRISE | Root | The date and enterprise time that a bed cleaning job was created in Capacity IQ®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
EVENT_TIMESTAMP_UTC | Root | The date and UTC time that a bed cleaning job was created in Capacity IQ®. |
FACILITY_ADT_ID | System Calc | The Facility ADT ID in the location settings for a bed cleaning job—used in DWC for easier reporting. |
FIRST_DELAY_REASON | Root | The initial reason that a bed cleaning job was delayed. This will not be applicable for Daily Cleans. |
FIRST_DELAY_TIMESTAMP | Root | The first date and local time when a bed cleaning job was initially delayed. This will not be applicable for Daily Cleans. |
FIRST_DELAY_TIMESTAMP_ENTERPRISE | Root | The first date and enterprise time when a bed cleaning job was initially delayed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This will not be applicable for Daily Cleans. |
FIRST_DELAY_TIMESTAMP_UTC | Root | The first date and UTC time when a bed cleaning job was initially delayed. This will not be applicable for Daily Cleans. |
FIRST_SUSPENDED_REASON | Root | The initial reason that a bed cleaning job was suspended. This will not be applicable for Daily Cleans. |
FIRST_SUSPENDED_TIMESTAMP | Root | The first date and local time when a bed cleaning job was initially suspended. This will not be applicable for Daily Cleans. |
FIRST_SUSPENDED_TIMESTAMP_ENTERPRISE | Root | The first date and enterprise time when a bed cleaning job was initially suspended. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This will not be applicable for Daily Cleans. |
FIRST_SUSPENDED_TIMESTAMP_UTC | Root | The first date and UTC time when a bed cleaning job was initially suspended. This will not be applicable for Daily Cleans. |
FLOOR | Root | This field identifies the floor associated with the location of the bed cleaning job. |
FLOOR_ID | System Calc | A system identifier for the unique floor not visible to users of the application. |
In Progress Timestamp | Root | The latest date and local time of day when the bed cleaning job was set to an In Progress status. If a job was suspended and subsequently completed, this will display the more current In Progress Timestamp and not the initial one. |
In Progress Timestamp Enterprise | Root | The latest date and enterprise time of day when the bed cleaning job was set to an In Progress status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. If a job was suspended and subsequently completed, this will display the more current In Progress Timestamp and not the initial one. |
In Progress Timestamp UTC | Root | The latest date and UTC time of day when the bed cleaning job was set to an In Progress status. If a job was suspended and subsequently completed, this will display the more current In Progress Timestamp and not the initial one. |
Initial Priority Status Type | Root | The initial location status for a bed cleaning job. Typically, this value will be Dirty, Stat, or Clean Next. This value could be Clean or Occupied if the job was a Found Bed or a Spill Clean. This will not be applicable for Daily Cleans. |
Initial Priority Status Type (group) | Custom Calc | This is a custom group for our CC dashboards. The groupings include "Dirty" for dirty cleans, high priority includes "CleanNext" and "Stat," and "Other" for all other initial priority statuses. |
Initial Priority Status Type Code | System Calc | The initial location status code for a bed cleaning job. This field is not intended for client report building. This will not be applicable for Daily Cleans. |
INSTANCEID | System Calc | A system calculation used for data partitioning. It is not intended for client reporting. |
IS_ADJUSTED_CLEAN | Root | A "true" or "false" value showing bed cleaning jobs where clean time ≤5 minutes OR ≥ 60 minutes OR an original response ≥ 120 minutes. Calculation: Total In Progress Time ≤55 minutes OR > 60 minutes OR Response Time ≥120 minutes. This will not be applicable for Daily Cleans. |
IS_UDEF8 | Root | If the latest location status for a bed cleaning job is "UDEF8," then this will be "true." Otherwise, it will be "false." This will not be applicable for Daily Cleans. |
IS_UDEF9 | Root | If the latest location status for a bed cleaning job is "UDEF9," then this will be "true." Otherwise, it will be "false." This will not be applicable for Daily Cleans. |
ISOLATION_TYPE | Root | An isolation indicating the type of isolation that applies to the cleaning job, such as Airborne, Droplet, and Contact. This will not be applicable for Daily Cleans. |
JOB_CREATE_REASON_TYPE | Root | The reason a bed cleaning job was created. The values for Bed Cleans and Spill Cleans include:Discharge - When the patient is discharged from the location.Transfer - When a patient is transferred to a different location that changes their home location.Found Bed - When an EVS employee puts a bed Inprogress using the Found Bed functionality.Other - When a cleaning request is created directly after releasing a blocked bed—when a patient has a bed request created while in a specialty location—any other scenario that does not match the other Job Create reason types.Cancel Admint - When an ADT message discharges a patient due to cancelling their admission.Spill - When a spill clean request is entered.Found Spill - When a spill clean request is entered by an EVS employee using the Found Spill functionality. For Daily Clean Jobs, the values are: Job Sweep, Supervisor Job Reopen |
JOB_CREATE_REASON_TYPE_CODE | System Calc | System calculation used for localization filtering—displays the Job Create reason type. This field is not intended for client report building. |
JOB_ID | Root | The identifier assigned to the bed cleaning job that appears on the user interface. |
JOB_STATUS_TYPE | Root | The current status of a bed cleaning job - Complete, In Progress, Cancel, Pending, or Suspended. For Daily Cleans : To Do, In Progress, Clean, InComplete |
JOB_STATUS_TYPE_CODE | System Calc | A system calculation used for localization filtering—displays the Job Status type. This field is not intended for client report building. |
JOB_STATUS_TYPE_ID | System Calc | A system identifier for the Job Status type not visible to users of the application. |
JOB_TYPE | Root | This field indicates if a cleaning job is for a Bed Clean, Spill Clean, MultiStage clean, or Daily clean. |
JOB_TYPE_CODE | System Calc | A system calculation used for localization filtering—displays the job type. This field is not intended for client report building. |
JOB_TYPE_ID | System Calc | A system identifier for the job type not visible to users of the application. |
Lastmoddate | System Calc | A system calculation that displays the most recent update to the application database in local time. This field is not intended for client reporting. |
Lastmoddate Enterprise | System Calc | A system calculation that displays the most recent update to the application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.This field is not intended for client reporting. |
Lastmoddate UTC | System Calc | A system calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting. |
LAST_UPGRADE_STATUS | Root | This field displays the latest upgrade status of a cleaning job's priority. This differs from the Initial Priority Status—includes Blocked, Clean Next, Next, Stat, Udef8, and Udef9. This will not be applicable for Daily Cleans. |
LAST_UPGRADE_STATUS_CODE | System Calc | A system calculation used for localization filtering—displays the Last Upgrade Status. This field is not intended for client report building. |
LAST_UPGRADE_STATUS_RESPONSE | Root | For cleaning jobs that have been upgraded to Stat or Clean Next, this shows the duration from the time of the upgrade to the response timestamp. |
LATEST_LASTMODDATE_ENTERPRISE | System Calc | System calculation that displays the most recent update in enterprise time format to any of the data points in this data source. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This field is not intended for client reporting. |
LATEST_LASTMODDATE_UTC | System Calc | System calculation that displays the most recent update in UTC format to any of the data points in this data source. This field is not intended for client reporting. |
LOCATION | Root | The name of the bed that was cleaned. |
LOCATION_ID | System Calc | A system identifier for the location not visible to users of the application. |
Number of Records | Root | The number of rows in the database. Each row represents a different bed cleaning job. |
NURSESTATION_ADT_ID | System Calc | A unique identifier for an individual nurse station. This is the Nursestation ADT ID that is associated with the location for the bed cleaning job. This field is helpful in DWC. |
Original Response Time | Root | It displays the time from the job creation to first response timestamp (the response timestamp could be in-progress or delayed). |
OVERALL_TURNTIME | Root | Displays the time from the case created timestamp to the completed timestamp. This will not be applicable for Daily Clean Jobs because Daily Cleans sit for an extended periods of time. |
OVERALL_TURN_TIME | Root | The total number of minutes from when a bed cleaning job was created until it was completed, including the duration in which the job was Suspended or Delayed. Jobs with a cancelled status are excluded. Calculation: Completed Timestamp minus Created Timestamp. This will not be applicable for Daily Cleans. |
REOPENED_BY_USER | Root | The user who reopened the Daily Clean job. |
REOPENED_BY_USER_LOGIN_ID | Root | The unique username associated with the user that reopened the daily clean job. |
REOPENED_REASON | Root | The reason indicated when a user reopens a Daily Clean job. |
REOPENED_TIMESTAMP | Root | The local date and time of day that the daily clean job was reopened. |
REOPENED_TIMESTAMP_ENTERPRISE | Root | The date and time of day when the daily clean job was reopened in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
REOPENED_TIMESTAMP_UTC | Root | The date and time of day that the daily clean job was reopened in UTC. |
REQUESTER | Root | The name of the individual who requested a bed cleaning job. |
REQUESTER_LOGIN_ID | System Calc | A username for the individual who requested the cleaning job. |
Response Time | Custom Calc | Response Time = Datediff (minutes) between Initial Created Timestamp and Latest In Progress Timestamp. This will not be applicable for Daily Cleans. |
Initial_Response_Time | Root | It displays the time from the job creation to first response timestamp (the response timestamp could be in-progress or delayed). |
ROOM | Root | The name of the room where the bed cleaning job took place. |
ROOM_ADT_ID | System Calc | A unique identifier for an individual room. This is the Room ADT ID that is associated with the location for the bed cleaning job. This field is helpful in DWC. |
ROOM_ID | System Calc | A system identifier for the room not visible to users of the application. |
SPILL_CLEAN_TYPE | Root | This field shows the specific type of spill clean, such as Bodily Fluids, Mop Job, and Coffee Spill. This will not be applicable for Daily Cleans. |
Suspend Timestamp | Root | The latest date and local time when a bed cleaning job was suspended. This value will be overwritten with the latest suspend timestamp if there are multiple within a single job. This will not be applicable for Daily Cleans. |
Suspend Timestamp Enterprise | Root | The latest date and enterprise time when a bed cleaning job was suspended. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This value will be overwritten with the latest suspend timestamp if there are multiple within a single job. This will not be applicable for Daily Cleans. |
Suspend Timestamp UTC | Root | The latest date and UTC time when a bed cleaning job was suspended. This value will be overwritten with the latest suspend timestamp if there are multiple within a single job. This will not be applicable for Daily Cleans. |
SUSPEND_TO_INPROGRESS | Root | This field displays the duration from the first suspended timestamp to the latest in progress timestamp. This will not be applicable for Daily Cleans. |
Tenant ID | System Calc | A system calculation that is used in data partitioning—not meant for client reporting. |
TOTAL_INPROGRESS_TIME | Root | The sum of all time spent inprogress for a given cleaning job. If a job is delayed and resumed, the total inprogress time will only include the time spent inprogress on a job. |
UDEF8 | Root | If the latest location status for a bed cleaning job is "UDEF8," then this will be "Y." Otherwise, it will be "N." This will not be applicable for Daily Cleans. |
UDEF9 | Root | If the latest location status for a bed cleaning job is "UDEF9," then this will be "Y." Otherwise, it will be "N." This will not be applicable for Daily Cleans. |
Unit Name | Root | The unit name for the location of a bed cleaning job. |
UNIT_CATEGORY | Root | The grouping of units, which contains the unit where a bed cleaning job took place. |
UNIT_CATEGORY_CODE | System Calc | A system calculation used for localization filtering—displays the Unit Category. This field is not intended for client report building. |
UNIT_CATEGORY_ID | System Calc | A system identifier for the unit category not visible to users of the application. |
UNIT_ID | System Calc | A system identifier for the unit not visible to users of the application. |
Volume | Custom Calc | The number of bed cleaning jobs, which includes all bed cleaning jobs. |
WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest time when a record/BT Job is inserted in the Snowflake Data Warehouse. |