Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
N/A | 30 Days Ago | Custom Calc | The date 30 days prior to the current date. The current date is based on the time zone set in the IP platform enterprise settings. |
ACQUISITIONDATE | Acquisitiondate | System Calc | The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
ACQUISITIONDATE_UTC | Acquisitiondate UTC | System Calc | The first step in the data ingestion process in UTC format. Used internally for latency calculations. This field is not intended for client report building. |
N/A | Avg Minutes Dispatched Per Call | Custom Calc | The average total minutes that a transporter is in a dispatch status per transport. Calculation: SUM([Total Dispatch Minutes])/SUM([Dispatch Count]) |
N/A | Avg Minutes Dispatched To Complete | Custom Calc | The average total minues that a transporter is in either a dispated or inprogress state per transport. Calculation: SUM([Total Dispatch Minutes])+SUM([Total Inprogress Minutes]))/SUM([Dispatch Count]) |
N/A | Avg Minutes In Progress Per Call | Custom Calc | The average total minutes that a transporter spends in progress per transport. Calculation: SUM([Total Inprogress Minutes])/SUM([Dispatch Count]) |
BASE_BED_ADT_ID | Base Bed Adt Id | System Calc | The bed ADT ID associated with the transporter's base location. |
BASE_FACILITY_ADT_ID | Base Facility Adt Id | System Calc | The facility ADT ID associated with the transporter's base location. |
BASE_LOCATION | Base Location | Root | The bed location that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool. |
BASE_LOCATION_CAMPUS_ID | Base Location Campus Id | System Calc | The unique identifier of the campus associated with the transporter's base location. |
BASE_LOCATION_CAMPUS_NAME | Base Location Campus Name | Root | The campus that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool. |
BASE_LOCATION_CUSTOMER_FACILITY_ID | Base Location Customer Facility Id | Root | A unique identifier for the campus associated with the base Location. This is defined in the Capacity IQ® campus settings. Commonly used with the Data IQ® Warehouse Connector to allow joining against an external identifier in an enterprise data warehouse. |
BASE_LOCATION_ID | Base Location Id | System Calc | The unique identifier of the base location of the transporter. |
BASE_NURSESTATION_ADT_ID | Base Nursestation Adt Id | System Calc | The nurse station ADT ID associated with the transporter's base location. |
BASE_ROOM_ADT_ID | Base Room Adt Id | Root | The room ADT ID associated with the transporter's base location. |
BREAK_COUNT | Break Count | Root | The total number of breaks the transporter logged during the date range selected. |
CLOUDACQUISITIONDATE | Cloudacquisitiondate | System Calc | The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
CLOUDACQUISITIONDATE_UTC | Cloudacquisitiondate UTC | System Calc | The second step in the data ingestion process. The field is is un UTC time. Used internally for latency calculations. This field is not intended for client report building. |
COMPLETED_JOB_COUNT | Completed Job Count | Root | Total number of completed jobs the transporter logged during the date range selected (both item and patient jobs). |
COMPLETED_JOB_COUNT_FOR_ITEM_JOBS | Completed Job Count For Item Jobs | Root | Total number of completed item jobs the transporter logged during the date range selected. |
COMPLETED_JOB_COUNT_FOR_PATIENT_JOBS | Completed Job Count For Patient Jobs | Root | Total number of completed patient jobs the transporter logged during the date range selected. |
N/A | Completed Jobs | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Completed Jobs (copy) | Custom Calc | This field is a duplicate of Completed jobs. It is not inteded for client report building. |
N/A | Completed Jobs Per Hour | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Date Filter Range | Custom Calc | This field is used by standard content. It is not intended for client report building. |
DATEPARTITION | Datepartition | System Calc | System calculation used internally to partition the data for efficient processing. This field is not intended for client report building. |
N/A | Delay Time | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Delays | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Delays Per Hour | Custom Calc | This field is used by standard content. It is not intended for client report building. |
DISPATCH_COUNT | Dispatch Count | Root | Total number of dispatched jobs the transporter logged during the date range selected (both item and patient jobs). |
DISPATCH_COUNT_FOR_ITEM_JOBS | Dispatch Count For Item Jobs | Root | Total number of dispatched item jobs the transporter logged during the date range selected. |
DISPATCH_COUNT_FOR_PATIENT_JOBS | Dispatch Count For Patient Jobs | Root | Total number of dispatched patient jobs the transporter logged during the date range selected. |
N/A | Dispatch Time Min | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Dispatch To Complete Time Min | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Dispatches | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Dispatches Per Hour | Custom Calc | This field is used by standard content. It is not intended for client report building. |
ENTERPRISE_NAME | Enterprise Name | Root | The name of a collection of campuses associated with the base location of the transporter. |
ENTERPRISE_USER_ID | Enterprise User ID | Root | The unique identifier of a collection of campuses associated with the transporter |
N/A | Help | Custom Calc | This field is used by standard content. It is not intended for client report building. |
HOUR | Hour | Root | Hour (in local timezone) for which the transporter statistics were calculated. |
N/A | Hours Worked | Custom Calc | The count of hours worked. |
IN_PROGRESS_JOB_COUNT | In Progress Job Count | Root | Total number of jobs that were in the In Progress status during the date range selected. |
IN_PROGRESS_JOB_COUNT_FOR_ITEM_JOBS | In Progress Job Count For Item Jobs | Root | Total number of item jobs that were in the In Progress status during the date range selected. |
IN_PROGRESS_JOB_COUNT_FOR_PATIENT_JOBS | In Progress Job Count For Patient Jobs | Root | Total number of patient jobs that were in the In Progress status during the date range selected. |
N/A | In Progress Time Min | Custom Calc | This field is used by standard content. It is not intended for client report building. |
INSTANCEID | Instanceid | Root | System calculation used for data partitioning. It is not intended for client reporting. |
LATEST_LASTMODDATE | Latest Lastmoddate | Root | The date of the most recent update to the hour associated with the transport employee metrics. |
LATEST_LASTMODDATE_ENTERPRISE | Latest Lastmoddate Enterprise | Root | The date of the most recent update to to the hour associated with the transport employee metrics in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_LASTMODDATE_UTC | Latest Lastmoddate UTC | Root | The date of the most recent update to to the hour associated with the transport employee metrics in UTC. Use the CreatedDate_UTC for reporting purposes. |
N/A | Nondelayed Job Count | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Number of Records | Custom Calc | The number of records included in the data. Each row equals 1. |
N/A | Percent of Jobs Without Delays | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Productive Time Min | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Rejects | Custom Calc | This field is used by standard content. It is not intended for client report building. |
N/A | Rejects Per Hour | Custom Calc | This field is used by standard content. It is not intended for client report building. |
START_DATE | Start Date | Root | Date (in local timezone) the transporter statistics were calculated. |
START_DATE_UTC | Start Date UTC | Root | Date (in UTC timezone) the transporter statistics were calculated. |
STATISTICS_DATE_TIME | Statistics Date Time | Root | Displays the date and time of the transport statistics in local time. |
STATISTICS_DATE_TIME_ENTERPRISE | Statistics Date Time Enterprise | Root | Displays the date and time of the transport statistics in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
STATISTICS_DATE_TIME_UTC | Statistics Date Time UTC | Root | Displays the date and time of the transport statistics in UTC. |
TENANTID | Tenantid | System Calc | System calculation that is used in data partitioning. Not meant for client reporting. |
N/A | Today | Custom Calc | The current date based on the time zone set in the IQ platform settings. |
TOTAL_ASSIST_RECEIVED | Total Assist Received | Root | Displays the total number of assists the transporter received during the date range selected. |
TOTAL_ASSIST_REQUESTED | Total Assist Requested | Root | Displays the total number of assists the transporter requested during the date range selected. |
TOTAL_AVAILABLE_BREAKLUNCH_MINUTES | Total Available Breaklunch Minutes | Root | Total number of unused (available) break or lunch minutes. |
TOTAL_AVAILABLE_MINUTES | Total Available Minutes | Root | Total number of minutes that the transporter was in the Available status. |
TOTAL_BREAKLUNCH_MINUTES | Total Breaklunch Minutes | Root | Total number of minutes that the transporter on a break or at lunch. |
TOTAL_DELAY_COUNT | Total Delay Count | Root | Total number of delays the transporter logged during the date range selected. |
TOTAL_DELAY_COUNT_FOR_ITEM_JOBS | Total Delay Count For Item Jobs | Root | Total number of delays the transporter logged for item jobs during the date range selected. |
TOTAL_DELAY_COUNT_FOR_PATIENT_JOBS | Total Delay Count For Patient Jobs | Root | Total number of delays the transporter logged for patient jobs during the date range selected. |
TOTAL_DELAY_MINUTES | Total Delay Minutes | Root | Total number of minutes that the transporter was in any Delayed status. |
TOTAL_DELAY_MINUTES_FOR_ITEM_JOBS | Total Delay Minutes For Item Jobs | Root | Total number of minutes that the transporter was in any Delayed status for item jobs. |
TOTAL_DELAY_MINUTES_FOR_PATIENT_JOBS | Total Delay Minutes For Patient Jobs | Root | Total number of minutes that the transporter was in any Delayed status for patient jobs. |
TOTAL_DISPATCH_DELAY_MINUTES | Total Dispatch Delay Minutes | Root | Total number of minutes that the transporter was in the Delayed status during dispatched jobs. |
TOTAL_DISPATCH_DELAY_MINUTES_FOR_ITEM_JOBS | Total Dispatch Delay Minutes For Item Jobs | Root | Total number of minutes that the transporter was in the Delayed status during dispatched item jobs. |
TOTAL_DISPATCH_DELAY_MINUTES_FOR_PATIENT_JOBS | Total Dispatch Delay Minutes For Patient Jobs | Root | Total number of minutes that the transporter was in the Delayed status during dispatched patient jobs. |
TOTAL_DISPATCH_MINUTES | Total Dispatch Minutes | Root | Total number of minutes that the transporter was in the Dispatch status. |
TOTAL_DISPATCH_MINUTES_FOR_ITEM_JOBS | Total Dispatch Minutes For Item Jobs | Root | Total number of minutes that the transporter was in the Dispatch status for an item job. |
TOTAL_DISPATCH_MINUTES_FOR_PATIENT_JOBS | Total Dispatch Minutes For Patient Jobs | Root | Total number of minutes that the transporter was in the Dispatch status for a patient job. |
TOTAL_INPROGRESS_DELAY_MINUTES | Total In Progress Delay Minutes | Root | Total number of minutes that the transporter was in the Delay status during In Progress jobs. |
TOTAL_INPROGRESS_DELAY_MINUTES_FOR_ITEM_JOBS | Total In Progress Delay Minutes For Item Jobs | Root | Total number of minutes that the transporter was in the Delay status during In Progress item jobs. |
TOTAL_INPROGRESS_DELAY_MINUTES_FOR_PATIENT_JOBS | Total In Progress Delay Minutes For Patient Jobs | Root | Total number of minutes that the transporter was in the Delay status during In Progress patient jobs. |
TOTAL_INPROGRESS_MINUTES | Total In Progress Minutes | Root | Total number of minutes that the transporter was in the In Progress Status. |
TOTAL_INPROGRESS_MINUTES_FOR_ITEM_JOBS | Total In Progress Minutes For Item Jobs | Root | Total number of minutes that the transporter was in the In Progress Status for item jobs. |
TOTAL_INPROGRESS_MINUTES_FOR_PATIENT_JOBS | Total In Progress Minutes For Patient Jobs | Root | Total number of minutes that the transporter was in the In Progress Status for patient jobs. |
TOTAL_JOB_REJECT_COUNT | Total Job Reject Count | Root | Total number of rejected jobs (both items and patients). |
TOTAL_JOB_REJECT_COUNT_FOR_ITEM_JOBS | Total Job Reject Count For Item Jobs | Root | Total number of rejected item transport jobs. |
TOTAL_JOB_REJECT_COUNT_FOR_PATIENT_JOBS | Total Job Reject Count For Patient Jobs | Root | Total number of rejected patient transport jobs. |
TOTAL_LOGGED_IN_MINUTES | Total Logged In Minutes | Root | Total number of hours the employee is logged into the system during the date range selected. |
TOTAL_MINUTES_DISPATCHED_TO_COMPLETED | Total Minutes Dispatched To Completed | Root | Total number of minutes that the transporter spent in the dispatched status until the job was complete. |
TOTAL_MINUTES_DISPATCHED_TO_COMPLETED_FOR_ITEM_JOBS | Total Minutes Dispatched To Completed For Item Jobs | Root | Total number of minutes that the transporter spent in the dispatched status (for item jobs) until the job was complete. |
TOTAL_MINUTES_DISPATCHED_TO_COMPLETED_FOR_PATIENT_JOBS | Total Minutes Dispatched To Completed For Patient Jobs | Root | Total number of minutes that the transporter spent in the dispatched status (for patient jobs) until the job was complete. |
TOTAL_PRODUCTIVE_MINUTES | Total Productive Minutes | Root | Total amount of minutes the transporter was either dispatched or in progress. |
TOTAL_PRODUCTIVE_MINUTES_FOR_ITEM_JOBS | Total Productive Minutes For Item Jobs | Root | Total amount of minutes the transporter was either dispatched or in progress for item jobs. |
TOTAL_PRODUCTIVE_MINUTES_FOR_PATIENT_JOBS | Total Productive Minutes For Patient Jobs | Root | Total amount of minutes the transporter was either dispatched or in progress for patient jobs. |
N/A | Transporter | Custom Calc | The first and last name of the transporter assocaited with the hourly calculations |
TRANSPORTER_ESCALATION_LEVEL_TYPE_NAME | Transporter Escalation Level Type Name | Root | Level at which this transporter receives alerts. |
TRANSPORTER_FIRST_NAME | Transporter First Name | Root | First name of the transporter. |
TRANSPORTER_IS_LOGGED_ON | Transporter Is Logged On | Root | Displays 'true' if the transporter is active. |
TRANSPORTER_IVRID | Transporter Ivrid | Root | Identification code for the IVR system that identifies the transporter. |
TRANSPORTER_LAST_NAME | Transporter Last Name | Root | Last name of the transporter. |
TRANSPORTER_LOGIN_ID | Transporter Login Id | Root | The username of the transporter associated with the hourly calculations |
TRANSPORTER_MEMBERSHIP_TYPE_NAME | Transporter Membership Type Name | Root | Type of membership assigned to the transporter (Fixed, Variable, or All). |
N/A | Transporter Name | Root | The first and last name of the transporter associated with the hourly calculations |
TRANSPORTER_POSITION_TYPE_NAME | Transporter Position Type Name | Root | Position Type of the transporter (Transport Supervisor, or EVS Supervisor). |
TRANSPORTER_ROLE_NAME | Transporter Role Name | Root | Name of the functional group to which the transporter is assigned. |
WAREHOUSEACQUISITIONDATE_UTC | Warehouseacquisitiondate Utc | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |
N/A | Yesterday | Custom Calc | The date prior to the current date. The current date is determined based on the time zone set in the IQ platform settings. |