Snowflake Field Name

Tableau Data Source Field

Folder

Description

ACQUISITIONDATE_UTC

Acquisition Date UTC

System Calc

The first step in the data ingestion process that is used internally for latency calculations. This field is not intended for client report building.

N/A

Adjustable Clean Time Color

Custom Calc

A custom calculation that is used to determine colors/shapes for Clean Time best practices. It leverages the Clean Time Threshold parameter to easily change thresholds.

N/A

Adjustable Clean Time Color Text

Custom Calc

A custom calculation that is used to determine colors/shapes for Clean Time best practices. It leverages the Clean Time Threshold parameter to easily change thresholds.

N/A

Adjustable Clean Time Variance Calc

Custom Calc

A custom calculation that shows the percent difference of the clean time compared to the threshold.

N/A

Adjustable Clean Time Variance Value

Custom Calc

A custom calculation that shows the difference of the clean time compared to the threshold.

N/A

Adjustable Overall Turn Color

Custom Calc

A custom calculation that is used to determine colors/shapes for Turn Time best practices. It leverages the Turn Time Threshold parameter to easily change thresholds.

N/A

Adjustable Overall Turn Color Text

Custom Calc

A custom calculation that is used to determine colors/shapes for Turn Time best practices. It leverages the Turn Time Threshold parameter to easily change thresholds.

N/A

Adjustable Response Time Color

Custom Calc

A custom calculation that is used to determine colors/shapes for Response Time best practices. It leverages the Response Time Threshold parameter to easily change thresholds.

N/A

Adjustable Response Time Color Text

Custom Calc

A custom calculation that is used to determine colors/shapes for Response Time best practices. It leverages the Response Time Threshold parameter to easily change thresholds.

N/A

Adjustable Response Time Variance Calc

Custom Calc

A custom calculation that shows the percent difference of the Response Time compared to the threshold.

N/A

Adjustable Response Time Variance Value

Custom Calc

A custom calculation that shows the difference of the Response Time compared to the threshold.

N/A

Adjustable Turn Time Variance Calc

Custom Calc

A custom calculation that shows the percent difference of the Turn Time compared to the threshold.

N/A

Adjustable Turn Time Variance Value

Custom Calc

A custom calculation that shows the difference of the Turn Time compared to the threshold.

N/A

Adjusted Cleans Count

Custom Calc

A custom calculation that shows the number of adjusted clean jobs. Other non-adjusted clean jobs will show as Null.

N/A

Adjusted Cleans Count 0

Custom Calc

A custom calculation that shows the number of adjusted clean jobs. Other non-adjusted clean jobs will show as "0" instead of Null.

ADJUSTED_CLEANS_FLAG

Adjusted Cleans Flag

Root

A "Y" (yes) or "N" (no) 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.

N/A

Adjusted Cleans Flag Alias

Custom Calc

A Yes or 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.

N/A

Average Clean time Variance Calc

Custom Calc

A custom calculation that shows the percent difference of the clean time compared to the best practice threshold of 30 minutes.

N/A

Average Response Time Variance Calc

Custom Calc

A custom calculation that shows the difference of the Response Time compared to the best practice threshold of 30 minutes.

N/A

Average Turn Time Variance Calc

Custom Calc

A custom calculation that shows the difference of the Turn Time compared to the best practice threshold of 60 minutes.

BED_ADT_ID

BED_ADT_ID

System Calc

A unique identifier for the individual 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

BED_COUNT

Root

The number of beds in the room associated with the Daily Clean job.

BLOCKED_BED_REASON

Blocked Bed Reason

Root

Displays the reason that 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_SOURCE

BT Job Source

Root

The job source is determined by how the job was created in the Capacity IQ® application. Possible values include:

BT_JOB_SOURCE_CODE

BT_JOB_SOURCE_CODE

System Calc

System calculation used for localization filtering. Displays the BT Job Source fields (that do not change with language). This field is not intended for client report building. This will not be applicable for Daily Cleans.

BUILDING

Building

Root

The physical structure within a facility where medical care is provided and which includes the bed that was cleaned.

BUILDING_ID

BUILDING_ID

Root

The unique identifier for the building where the cleaning job took place.

CAMPUS

Campus

Root

The name of a collection of buildings in the enterprise that includes the bed that was cleaned. A campus is part of the logical hierarchy of an enterprise.

CAMPUSID

CAMPUSID

Root

The unique identifier for the campus where the cleaning job took place.

CANCELLED_BY_USER

Cancelled By User

Root

The user who cancelled the bed cleaning job.

CANCELLED_BY_USER_LOGIN_ID

CANCELLED_BY_USER_LOGIN_ID

System Calc

The unique username associated with the user who cancelled the bed cleaning job.

CANCELLED_REASON

Cancelled Reason

Root

The reason indicated when a user cancels a bed cleaning job.

CANCELLED_TIMESTAMP

Cancelled Timestamp

Root

The date and local time of day when the bed cleaning job was cancelled.

CANCELLED_TIMESTAMP_ENTERPRISE

CANCELLED_TIMESTAMP_ENTERPRISE

Root

The date and time of day when the bed cleaning job was cancelled in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

CANCELLED_TIMESTAMP_UTC

CANCELLED_TIMESTAMP_UTC

Root

The date and time of day when the bed cleaning job was cancelled in UTC.

N/A

Clean Beds

Custom Calc

A custom calculation that shows the number of completed cleaning jobs.

N/A

Clean Time on Target

Custom Calc

A custom calculation that compares the average clean time to the adjustable Clean Time Threshold parameter. It shows jobs as "within threshold" and "out of threshold."

N/A

Clean Time Threshold Criteria Color

Custom Calc

A custom calculation that shows the percent difference of the clean time compared to the best practice metric of 30 minutes.

N/A

Clean Time Threshold Criteria Color Text

Custom Calc

A custom calculation that shows the percent difference of the clean time compared to the best practice metric of 30 minutes.

N/A

Clean Time Variance Value

Custom Calc

A custom calculation that shows the difference of the clean time compared to the best practice metric of 30 minutes.

CLOUDACQUISITION_DATE_UTC

CLOUDACQUISITION_DATE_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_BY_USER

Completed By User

Root

The user who set the bed cleaning job to a Completed status.

COMPLETED_BY_USER_LOGIN_ID

COMPLETED_BY_USER_LOGIN_ID

System Calc

The unique username associated with the user who completed the bed cleaning job.

COMPLETED_TIMESTAMP

Completed Timestamp

Root

The date and local time of day when a bed cleaning job was marked as complete.

COMPLETED_TIMESTAMP_ENTERPRISE

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

COMPLETED_TIMESTAMP_UTC

Root

The date and UTC time of day when a bed cleaning job was marked as complete.

CREATEDDATE

Created Date

System Calc

The date and local time when a bed cleaning job was created in Capacity IQ®.

CREATEDDATE_ENTERPRISE

Created Date Enterprise

System Calc

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

Created Date Utc

System Calc

The date and UTC time when a bed cleaning job was created in Capacity IQ®.

CREATED_TIMESTAMP

Created Timestamp

System Calc

The date and UTC time when a bed cleaning job was created in Capacity IQ®.

N/A

Created Timestamp (copy)

Root

The date and local time when a bed cleaning job was created in Capacity IQ®.

CREATED_TIMESTAMP_ENTERPRISE

CREATED_TIMESTAMP_ENTERPRISE

System Calc

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.

CREATED_TIMESTAMP_UTC

CREATED_TIMESTAMP_UTC

Root

The date and local UTC time when a bed cleaning job was created in Capacity IQ®.

N/A

Current Month Number

Custom Calc

A custom calculation that displays the month number of the current month.

CUSTOMER_FACILITY_ID

CUSTOMER_FACILITY_ID

Root

A unique identifier for a given campus that is defined in the Capacity IQ® campus settings for use with Transfer IQ® facility IDs and used more widely in DWC.

N/A

Date Selector

Custom Calc

A custom calculation that gives users more filtering options via a changeable parameter. This calculation references the Created Date field, and it allows users to select filtering to the current day, previous day, previous week, previous month, or a custom range.

N/A

Date Selector (Range)

Custom Calc

A custom calculation that gives users more filtering options via a changeable parameter. This calculation references the Created Date field, and it allows users to select filtering to the current day, previous day, previous week, previous month, or a custom range. The labels were cleaned up to give more context (for example: "Last 7 Days" instead of "Week").

DATEPARTITION

Datepartition

System Calc

System calculation used internally to partition the data for efficient processing.

DELAY_TO_IN_PROGRESS

Delay To In Progress

Root

Shows the time duration between the first delay and latest Inprogress timestamp. This will not be applicable for Daily Cleans.

DISCIPLINE

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

DISCIPLINE_ID

System Calc

A system identifier for the unique discipline not visible to users of the application.

EMPLOYEE_CATEGORY

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

Enterprise

Root

The name of a collection of campuses that includes the bed that was cleaned.

ENTERPRISE_ID

ENTERPRISE_ID

System Calc

A system identifier for the unique enterprise not visible to users of the application.

EVENT_TIMESTAMP

Event Timestamp

Root

The date and local time when a bed cleaning job was created in Capacity IQ®.

EVENT_TIMESTAMP_ENTERPRISE

EVENT_TIMESTAMP_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.

EVENT_TIMESTAMP_UTC

EVENT_TIMESTAMP_UTC

Root

The date and UTC time when a bed cleaning job was created in Capacity IQ®.

FACILITY_ADT_ID

FACILITY_ADT_ID

System Calc

The Facility ADT ID in the location settings for a bed cleaning job that is used in DWC for easier reporting.

FIRST_DELAY_REASON

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

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

FIRST_DELAY_TIMESTAMP_ENTERPRISE

Root

The first date and enterprise time that 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

FIRST_DELAY_TIMESTAMP_UTC

Root

The first date and UTC time that a bed cleaning job was initially delayed. This will not be applicable for Daily Cleans.

FIRST_SUSPENDED_REASON

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

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

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

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

Floor

Root

Identifies the floor associated with the location of the bed cleaning job.

FLOOR_ID

FLOOR_ID

System Calc

A system identifier for the unique floor not visible to users of the application.

N/A

Found Beds

Custom Calc

A custom calculation that displays a count of jobs that were created by the bed cleaning staff without first being notified, indicating that the bed was found dirty.

N/A

Help

Custom Calc

A custom calculation that is used for the hyperlink text to the Data IQ® Online Help. This is not meant for customer reporting.

IN_PROGRESS_TIMESTAMP

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.

INITIAL_PRIORITY_STATUS_TYPE

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_CODE

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.

INPROGRESS_TIMESTAMP_ENTERPRISE

INPROGRESS_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.

INPROGRESS_TIMESTAMP_UTC

INPROGRESS_TIMESTAMP_UTC

Root

The latest date and UTC time of day when the bed cleaning job was set to an In Progress status.

INSTANCEID

INSTANCEID

System Calc

A system calculation used for data partitioning. It is not intended for client reporting.

IS_ADJUSTED_CLEAN

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

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

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

Isolation Type

Root

Isolation that indicates 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

Job Create Reason Type

Root

The reason a bed cleaning job was created. The values for this include:

For Daily Clean Jobs, the values are: Job Sweep, Supervisor Job Reopen

JOB_CREATE_REASON_TYPE_CODE

JOB_CREATE_REASON_TYPE_CODE

System Calc

System calculation used for localization filtering that displays the Job Create Reason Type. This field is not intended for client report building.

JOB_ID

Job Id

Root

The identifier assigned to the bed cleaning job that appears on the user interface.

JOB_STATUS_TYPE

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

JOB_STATUS_TYPE_CODE

System Calc

System calculation used for localization filtering that displays the Job Status Type. This field is not intended for client report building.

JOB_STATUS_TYPE_ID

JOB_STATUS_TYPE_ID

System Calc

A system identifier for the Job Status Type not visible to users of the application.

JOB_TYPE

Job Type

Root

Indicates if a cleaning job is for a Bed Clean, Spill Clean, MultiStage Clean, or Daily Clean.

JOB_TYPE_CODE

JOB_TYPE_CODE

System Calc

System calculation used for localization filtering that displays the Job Type. This field is not intended for client report building.

JOB_TYPE_ID

JOB_TYPE_ID

System Calc

A system identifier for the Job Type not visible to users of the application.

LASTMODDATE

Lastmoddate

System Calc

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

Lastmoddate Enterprise

System Calc

System calculation that displays the most recent update to the application database in enterprise

time. This field is not intended for client reporting. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

LASTMODDATE_UTC

Lastmoddate Utc

System Calc

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

Last Upgrade Status

Root

Displays the latest upgrade status of a cleaning job's priority. This differs from the Initial Upgrade Status and includes Blocked, Clean Next, Stat, Udef8, and Udef9. This will not be applicable for Daily Cleans.

LAST_UPGRADE_STATUS_CODE

LAST_UPGRADE_STATUS_CODE

System Calc

System calculation used for localization filtering that displays the Last Upgrade Status. This field is not intended for client report building. This will not be applicable for Daily Cleans.

LAST_UPGRADE_STATUS_RESPONSE

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. This will not be applicable for Daily Cleans.

LATEST_LASTMODDATE_ENTERPRISE

LatestLastmoddate Enterprise

System Calc

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.

LATEST_LASTMODDATE_UTC

Latest Lastmoddate UTC

System Calc

System calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting.

LOCATION

Location

Root

The name of the bed that was cleaned. This will not be applicable for Daily Clean Jobs because Daily Cleans are at the room level.

LOCATION_ID

LOCATION_ID

System Calc

A system identifier for the location not visible to users of the application. This will not be applicable for Daily Cleans.

N/A

Month Colors

Custom Calc

A custom caclulation that is used to identify the current month compared to a previous month.

N/A

Number of Cleans

Custom Calc

A custom calculation showing the number of jobs that had an inprogress duration.

NUMBER_OF_RECORDS

Number of Records

Root

The number of rows in the database. Each row represents a different bed cleaning job.

N/A

Number of Responses

Custom Calc

A custom calculation showing the number of jobs that had a response timestamp.

N/A

Number of Turns

Custom Calc

A custom calculation showing the number of jobs that had a Turn Time timestamp.

NURSESTATION_ADT_ID

NURSESTATION_ADT_ID

System Calc

A unique identifier for an individual nurse station. This is the nurse station ADT ID that is associated with the location for the bed cleaning job. This field is helpful in DWC.

N/A

Overall Turn Threshold Criteria Color

Custom Calc

A custom calculation showing the percent difference of the Turn Time compared to the best practice metric of 60 minutes.

N/A

Overall Turn Threshold Criteria Color Text

Custom Calc

A custom calculation showing the percent difference of the Turn Time compared to the best practice metric of 60 minutes.

OVERALL_TURN_TIME

Overall Turn Time

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.

N/A

Productivity %

Custom Calc

A custom calculation that shows the number of bed cleans compared to all requested jobs for the day.

N/A

Remaining Beds

Custom Calc

A custom calculation that shows the number of beds that have a cleaning request but have not yet been cleaned. This can include cancelled and suspended jobs as well.

REOPENED_BY_USER

REOPENED_BY_USER

Root

The user who reopened the Daily Clean job.

REOPENED_BY_USER_LOGIN_ID

REOPENED_BY_USER_LOGIN_ID

Root

The unique username associated with the user that reopened the daily clean job.

REOPENED_REASON

REOPENED_REASON

Root

The reason indicated when a user reopens a Daily Clean job.

REOPENED_TIMESTAMP

REOPENED_TIMESTAMP

Root

The local date and time of day that the daily clean job was reopened.

REOPENED_TIMESTAMP_ENTERPRISE

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

REOPENED_TIMESTAMP_UTC

Root

The date and time of day that the daily clean job was reopened in UTC.

REQUESTER

Requester

Root

The name of the individual who requested a bed cleaning job.

REQUESTER_LOGIN_ID

REQUESTER_LOGIN_ID

System Calc

A username for the individual who requested the cleaning job.

RESPONSE_TIME

Response Time

Root

Displays the time from the job creation to the first response timestamp (the response timestamp could be in-progress or delayed). This will not be applicable for Daily Cleans because Daily Cleans sit for an extended period of time.

N/A

Response Time on Target

Custom Calc

A custom calculation that compares the Response Time to the Adjustable Response Time threshold. It is used in color and shape calculations.

N/A

Response Time Threshold Criteria Colors

Custom Calc

A custom calculation showing the percent difference of the Response Time compared to the best practice metric of 30 minutes.

N/A

Response Time Threshold Criteria Colors Text

Custom Calc

A custom calculation showing the percent difference of the Response Time compared to the best practice metric of 30 minutes.

N/A

Response Time Variance Value

Custom Calc

A custom calculation showing the difference of the Response Time compared to the best practice metric of 30 minutes.

ROOM

Room

Root

The name of the room where the bed cleaning job took place.

ROOM_ADT_ID

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

ROOM_ID

System Calc

A system identifier for the room not visible to users of the application.

SPILL_CLEAN_TYPE

SPILL_CLEAN_TYPE

Root

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

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

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

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_IN_PROGRESS

Suspend To In Progress

Root

Displays the duration from the first suspended timestamp to the latest In Progress Timestamp. This will not be applicable for Daily Cleans.

TENANTID

Tenantid

System Calc

System calculation used in data partitioning that is not meant for client reporting.

N/A

Time Format Overall Turn Time

Custom Calc

A custom calculation that displays the Turn Time in MM:SS format.

N/A

Time Format Response Time

Custom Calc

A custom calculation that displays the Response Time in MM:SS format.

N/A

Time Format Total In Progress Time

Custom Calc

A custom calculation that displays the In Progress Time in MM:SS format.

TOTAL_INPROGRESS_TIME

Total Inprogress Time

Root

Sum of all time spent in-progress for a given cleaning job. If a job is delayed and resumed, the Total Inprogress Time will only include the time spent in-progress on a job.

N/A

Total Percent Bar

Custom Calc

A custom calculation that is used as a placeholder value. It is not intended for client reporting.

N/A

Total Requested Jobs

Custom Calc

A custom calculation that shows the total number of requested jobs, including cancelled and suspended jobs.

N/A

Turn Time On Target

Custom Calc

A custom calculation that compares the Turn Time to the Adjustable Turn Time threshold (used in color and shape calculations).

N/A

Turn Time Variance Value

Custom Calc

A custom calculation that compares the Turn Time to the Adjustable Turn Time threshold (used in color and shape calculations).

UDEF8

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

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

Unit

Root

The unit name for the location of a bed cleaning job.

UNIT_CATEGORY

Unit Category

Root

The grouping of units, which contains the unit where a bed cleaning job took place.

UNIT_CATEGORY_CODE

UNIT_CATEGORY_CODE

System Calc

System calculation used for localization filtering that displays the Unit Category. This field is not intended for client report building.

UNIT_CATEGORY_ID

UNIT_CATEGORY_ID

System Calc

A system identifier for the unit category not visible to users of the application.

UNIT_ID

UNIT_ID

System Calc

A system identifier for the unit not visible to users of the application.

WAREHOUSEACQUISITIONDATE_UTC

WAREHOUSEACQUISITIONDATE_UTC

System Calc

The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format.