Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
ACQUISITIONDATE_UTC | ACQUISITIONDATE_UTC | System Calc | The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
N/A | Adjustable Dispatch to Complete Color | Adjustable Custom Calculations | A field used in standard content to determine if we display an "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable Dispatch to Complete Color Text | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable Dispatch to Complete Variance | Adjustable Custom Calculations | A field in standard content that compares the average metric time to the Dispatch to Complete parameter value. Returns a percentage of the parameter goal. |
N/A | Adjustable InProgress to Complete Colors | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable InProgress to Complete Colors Text | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable InProgress to Complete Variance | Adjustable Custom Calculations | A field in standard content that compares the average metric time to the Inprogress to Complete parameter value. Returns a percentage of the parameter goal. |
N/A | Adjustable Pending to Complete Colors | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable Pending to Complete Colors Text | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable Pending to Complete Variance | Adjustable Custom Calculations | A field in standard content that compares the average metric time to the Pending to Complete parameter value. Returns a percentage of the parameter goal. |
N/A | Adjustable Pending to Dispatch Color | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable Pending to Dispatch Color Text | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable Pending to Dispatch Variance | Adjustable Custom Calculations | A field in standard content that compares the average metric time to the Pending to Dispatch parameter value. Returns a percentage of the parameter goal. |
N/A | Adjustable Pending to Inprogress Color | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable Pending to Inprogress Color Text | Adjustable Custom Calculations | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Adjustable Pending to InProgress Variance | Adjustable Custom Calculations | A field in standard content that compares the average metric time to the Pending to In Progress parameter value. Returns a percentage of the parameter goal. |
APPOINTMENT_TIMESTAMP | APPOINTMENT_TIMESTAMP | Root | Displays the local date and time of the Transport Appointment. |
APPOINTMENT_TIMESTAMP_ENTERPRISE | APPOINTMENT_TIMESTAMP_ENTERPRISE | Root | Displays the enterprise date and time of the Transport Appointment. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
APPOINTMENT_TIMESTAMP_UTC | APPOINTMENT_TIMESTAMP_UTC | Root | Displays the UTC date and time of the Transport Appointment. |
Assistance Requested | Assistance Requested | Root | A flag indicating that the original transporter requested additional transporters to help complete the job. |
N/A | Average Dispatch To Complete Time Variance | Custom Calc | A field in standard content that compares the average metric time to a specified goal of 20 minutes. Returns a percentage of the parameter goal. |
N/A | Average Dispatch to InProgress Time Variance | Root | A field in standard content that compares the average metric time to the time set in the parameter settings. Returns a percentage of the parameter goal. The formula for this is: (AVG([Dispatch to In-Progress Time])-[Pending to In Progress])/[Pending to In Progress] |
N/A | Average Inprogress To Complete Variance | Custom Calc | A field in standard content that compares the average metric time a specified goal of 10 minutes. Returns a percentage of the parameter goal. |
N/A | Average Pending To Dispatch Variance | Custom Calc | A field in standard content that compares the average metric time to a specified goal of 5 minutes. Returns a percentage of the parameter goal. |
N/A | Average Request To In Progress Time Variance | Custom Calc | A field in standard content that compares the average metric time to a specified goal of 15 minutes. Returns a percentage of the parameter goal. |
N/A | Avg Pending To Complete Time Variance | Custom Calc | A field in standard content that compares the average metric time a specified goal of 30 minutes. Returns a percentage of the parameter goal. |
Cancelled Reason | Cancelled Reason | Root | The value selected in the Reason for Cancel list when the transport request was cancelled. |
Cancelled Timestamp | Cancelled Timestamp | Root | The latest local date time when the job was marked as cancelled. |
N/A | Cancelled Timestamp No Time | Custom Calc | Local Date of the cancelled timestamp. |
CANCELLED_BY_USER | CANCELLED_BY_USER | Root | Displays the Transporter who cancelled the job. |
CANCELLED_BY_USER_LOGIN_ID | CANCELLED_BY_USER_LOGIN_ID | Root | The username of the user who cancelled the transport job. |
CANCELLED_TIMESTAMP_ENTERPRISE | CANCELLED_TIMESTAMP_ENTERPRISE | Root | Displays the latest cancelled date time for a transport job in terms of enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
CANCELLED_TIMESTAMP_UTC | CANCELLED_TIMESTAMP_UTC | Root | Displays the latest cancelled date time for a transport job in terms of UTC. |
CLOUDACQUISITIONDATE_UTC | CLOUDACQUISITIONDATE_UTC | System Calc | The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
N/A | CLOUDACQUISITIONDATE_UTC | System Calc | The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
N/A | COLOR Dispatch to Complete | Custom Calc | A field used in standard content to determine if the color indicator for a specific metric should display 'red' or 'green'. If the average time for the metric exceeds the parameter value set, it will display 'red', otherwise it will display 'green.' |
N/A | COLOR Dispatch to Inprogress | Custom Calc | A field used in standard content to determine if the color indicator for a specific metric should display 'red' or 'green'. If the average time for the metric exceeds the parameter value set, it will display 'red', otherwise it will display 'green.' |
N/A | COLOR Pending to Complete | Custom Calc | A field used in standard content to determine if the color indicator for a specific metric should display 'red' or 'green'. If the average time for the metric exceeds the parameter value set, it will display 'red', otherwise it will display 'green.' |
N/A | COLOR Pending to Dispatch | Custom Calc | A field used in standard content to determine if the color indicator for a specific metric should display 'red' or 'green'. If the average time for the metric exceeds the parameter value set, it will display 'red', otherwise it will display 'green.' |
N/A | COLOR Request to Inprogress | Custom Calc | A field used in standard content to determine if the color indicator for a specific metric should display 'red' or 'green'. If the average time for the metric exceeds the parameter value set, it will display 'red', otherwise it will display 'green.' |
Completed By User | Completed By User | Root | Name of the employee who set the transport job to a status of Completed. |
Completed Timestamp | Completed Timestamp | Root | The latest local date time when the job was marked as completed. |
N/A | Completed Timestamp No Time | Custom Calc | Local date of the completed timestamp. |
COMPLETED_BY_USER_LOGIN_ID | COMPLETED_BY_USER_LOGIN_ID | Root | The username of the user who completed the transport job. |
COMPLETED_TIMESTAMP_ENTERPRISE | COMPLETED_TIMESTAMP_ENTERPRISE | Root | Displays the latest completed date time for a transport job in terms of enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
COMPLETED_TIMESTAMP_UTC | COMPLETED_TIMESTAMP_UTC | Root | Displays the latest completed date time for a transport job in terms of UTC. |
Createddate | Createddate | Root | The date and local time that a transport job was created in Capacity IQ®. |
N/A | Createddate (copy) | Custom Calc | Date of the job created date based on the local instance timezone. |
CREATEDDATE_ENTERPRISE | Createddate Enterprise | Root | The date and enterprise time that a transport job was created. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Createddate Utc | Createddate Utc | Root | The date and UTC time that a transport job was created. |
N/A | Current Month | Custom Calc | A field used in standard content to derive the current month. |
N/A | Current Month Days | Custom Calc | A field used in standard content to determine if the month of the created date for a record matches the current month Parameter. |
N/A | Current Month Records | Custom Calc | A field used in standard content to determine if the month of the created date for a record matches the current month Parameter. |
N/A | Date Filter | Custom Calc | A field used in standard content to determine if we include certain records based on the created date/time. Uses the Date Range parameter to determine if it should included today's data, yesterday, in the last 7 days, last month, or a custom date range using the start and end date parameters. |
N/A | Date Filter Cancelled | Custom Calc | A field used in standard content to determine if we include certain records based on the cancelled date/time. Uses the Date type parameter to determine if it should included today's data, yesterday, in the last 7 days, last month, or a custom date range using the start and end date parameters. |
N/A | Date Filter Cancelled Range | Custom Calc | A field used in standard content to determine if we include certain records based on the cancelled date/time. Uses the Date Range parameter to determine if it should included today's data, yesterday, in the last 7 days, last month, or a custom date range using the start and end date parameters. |
N/A | Date Filter Range | Custom Calc | A field used in standard content to determine if we include certain records based on the created date/time. Uses the Date Range parameter to determine if it should included today's data, yesterday, in the last 7 days, last month, or a custom date range using the start and end date parameters. |
N/A | Date Filter Range v2 | Custom Calc | A field used in standard content to determine if we include certain records based on the created date/time. Uses the Date Range parameter to determine if it should included today's data, yesterday, in the last 7 days, last month, or a custom date range using the start and end date parameters. |
Datepartition | Datepartition | System Calc | System calculation used internally to partition the data for efficient processing. |
N/A | Datepartition | System Calc | System calculation used internally to partition the data for efficient processing. |
N/A | Days Per Month | Custom Calc | A field used in standard content to derive the number of day in the month that the record was created. |
Destination Building | Destination Building | Root | The physical structure within a facility where medical care is provided and where an item or patient was delivered for a transport job. |
Destination Campus | Destination Campus | Root | The name of a collection of buildings in the enterprise associated with the location where an item or patient was delivered for a transport job. These are defined in the Enterprise information of the Capacity IQ® application. |
Destination Discipline | Destination Discipline | Root | The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, or Burn where an item or patient was delivered for a transport job. |
Destination Enterprise | Destination Enterprise | Root | The name of the enterprise associated with the location where an item or patient was delivered for a transport job. These are defined in the Enterprise information of the Capacity IQ® application. |
Destination Floor | Destination Floor | Root | The floor of the unit that the destination location of the transport job is associated with. |
Destination Location | Destination Location | Root | The identifier for the bed where an item or patient was delivered for a transport job. |
Destination Location Type | Destination Location Type | Root | The identifier for the bed type where an item or patient was delivered for a transport job. |
Destination Room | Destination Room | Root | The location name for the bed where an item or patient was taken to for a transport job. |
Destination Unit | Destination Unit | Root | The unit associated with the location where an item or patient was delivered for a transport job. |
Destination Unit Category | Destination Unit Category | Root | The unit category of the unit associated with the destination location of a transport job. |
DESTINATION_UNIT_CATEGORY_CODE | DESTINATION_UNIT_CATEGORY_CODE | System Calc | The unit category code of the unit associated with the destination location of a transport job. This field is not intended for client report building. |
DESTINATION_BED_ADT_ID | DESTINATION_BED_ADT_ID | Root | The bed ADT ID set in the location settings of the location the transport job took the patient to. |
DESTINATION_CAMPUSID | DESTINATION_CAMPUSID | System Calc | An internal campus database identifier. This field is not intended for report building. |
DESTINATION_CUSTOMER_FACILITY_ID | DESTINATION_CUSTOMER_FACILITY_ID | Root | The campus account ID associated with the location the transport job took the patient to. This value is set in the campus settings. |
DESTINATION_FACILITY_ADT_ID | DESTINATION_FACILITY_ADT_ID | Root | The Facility ADT ID set in the location settings of the location the transport job took the patient to. |
DESTINATION_LOCATION_ID | DESTINATION_LOCATION_ID | System Calc | An internal location database identifier. This field is not intended for report building. |
DESTINATION_LOCATION_TYPE_CODE | DESTINATION_LOCATION_TYPE_CODE | System Calc | This is a field used to assist with multilingual deployment of TeleTracking® standard content, and is not intended for client report building. |
DESTINATION_NURSESTATION_ADT_ID | DESTINATION_NURSESTATION_ADT_ID | Root | The Nursing Station ADT ID set in the location settings of the location the transport job took the patient to. |
DESTINATION_ROOM_ADT_ID | DESTINATION_ROOM_ADT_ID | Root | The Room ADT ID set in the location settings of the location the transport job took the patient to. |
Diagnosis | Diagnosis | Root | The identity of the nature and cause of the patient's disease or injury. |
N/A | Dispatch To Complete Compliance | Custom Calc | 1-(SUM([Dispatch to Complete Out of Threshold])/COUNT([Dispatched To Completed Time])) Shows the percentage of transports within the 'Dispatch to Complete' threshold. |
N/A | Dispatch To Complete Out of Threshold | Custom Calc | {INCLUDE [Tt Job Id]: IF AVG([Dispatched To Completed Time]) > [Dispatch to Complete] THEN COUNT([Tt Job Id]) ELSE 0 END} Calculates the number of transports with a Dispatch to Completed time outside of the 'Dispatch to Complete' threshold |
N/A | Dispatch To Complete Threshold Label | Custom Calc | IF [Average Dispatch To Complete Time Variance] > 0.2 THEN "Above Threshold" ELSEIF [Average Dispatch To Complete Time Variance] > 0 THEN "Approaching Threshold" ELSE "Within Threshold" END |
N/A | Dispatch To Complete Threshold Label Text | Custom Calc | IF AVG([Dispatched To Completed Time]) > [Dispatch to Complete] THEN COUNT([Tt Job Id]) |
N/A | Dispatch To In-Progress Compliance | Custom Calc | 1-(SUM([Dispatch to Complete Out of Threshold])/COUNT([Dispatch to In-Progress Time])) Shows the percentage of transports within the 'Dispatch to In Progress' threshold. |
N/A | Dispatch To In-Progress Out of Threshold | Custom Calc | {INCLUDE [Tt Job Id]: IF AVG([Dispatch to In-Progress Time]) > [Dispatch to In Progress] THEN COUNT([Tt Job Id]) ELSE 0 END} Calculates the number of transports with a Dispatch to In Progress time outside of the 'Dispatch to In Progress' threshold. |
N/A | Dispatch To InProgress Threshold Label | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Dispatch To InProgress Threshold Label Text | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Dispatch to In-Progress Time | Custom Calc | The difference in minutes between the dispatched timestamp and the in progress timestamp. |
Dispatched Timestamp | Dispatched Timestamp | Root | The latest local date time when the job was marked as dispatched. |
Dispatched To Cancelled Time | Dispatched To Cancelled Time | Root | The total time for a transport job that was cancelled from when the job had a Dispatched status for the first time until it was in cancelled status, including any time that the job was in a Delay status. Dispatch_to_cancelled_Time is calculated as: 10:45 – 10:00 = 45 min. |
Dispatched To Cancelled Time Format | Dispatched To Cancelled Time Format | Custom Calc | A field in standard content that displays the specific metric in a time format of HH:MM |
Dispatched To Completed Time | Dispatched To Completed Time | Root | The time that it took to transport the item or patient from when the job had a Dispatched status for the first time until it was in Completed status, including any time that the job was in a Delay status. Calculation: Completed Timestamp minus First Dispatched Timestamp. |
DISPATCHED_BY_USER | DISPATCHED_BY_USER | Root | Displays the Transporter who is set to Dispatch status for the job. |
DISPATCHED_BY_USER_LOGIN_ID | DISPATCHED_BY_USER_LOGIN_ID | Root | Displays the Transporter username who is set to Dispatch status for the job. |
DISPATCHED_TIMESTAMP_ENTERPRISE | DISPATCHED_TIMESTAMP_ENTERPRISE | Root | The date and enterprise time that a transport job was dispatched in Capacity IQ®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
DISPATCHED_TIMESTAMP_UTC | DISPATCHED_TIMESTAMP_UTC | Root | The date and UTC time that a transport job was dispatched in Capacity IQ®. |
Employee Category | Employee Category | Root | The employee category of the latest primary transporter on a transport job. |
Event Timestamp | Event Timestamp | Root | The latest local date time when the transport job was marked as pending. |
EVENT_TIMESTAMP_ENTERPRISE | EVENT_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date time when the transport job was marked as pending. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
EVENT_TIMESTAMP_UTC | EVENT_TIMESTAMP_UTC | Root | The latest UTC date time when the transport job was marked as pending. |
FIRST_DELAY_REASON_CODE | FIRST_DELAY_REASON_CODE | Root | The initial reason that a transport job was delayed. Jobs that do not have a delay at time of appointment but have one added later will show a reason code of NULL, but the timestamp will still be collected. |
Gender | Gender | Root | The gender marked in the patient visit record for the patient receiving the transport. |
GENDER_CODE | GENDER_CODE | System Calc | The gender code marked in the patient visit record for the patient receiving the transport. This is a field used to assist with multi language deployment of teletracking standard content, and is not intended for client report building. |
N/A | Help | Custom Calc | A field used in standard content as a placehold text for our online help link. |
N/A | In Progress To Complete Compliance | Custom Calc | 1-(SUM([Inprogress to Complete Out of Threshold])/COUNT([Inprogress To Completed Time])) Shows the percentage of transports within the 'In Progress to Complete' threshold . |
N/A | In Progress To Complete Out of Threshold | Custom Calc | {INCLUDE [Tt Job Id]: IF AVG([Inprogress To Completed Time]) > [Inprogress to Complete] THEN COUNT([Tt Job Id]) ELSE 0 END} Calculates the number of transports with an In Progress to Complete time outside of the 'In Progress to Complete' threshold |
N/A | InProgress To Complete Threshold Label | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | InProgress To Complete Threshold Label Text | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
Inprogress To Completed Time | Inprogress To Completed Time | Root | The time that it took to transport the item or patient from when the job had an In Progress status for the first time until it was in Completed status, including any time that the job was in a Delay status. Calculation: Completed Timestamp minus First In Progress Timestamp. |
Inprogress Timestamp | Inprogress Timestamp | Root | The latest local date time when the job was marked as in-progress. |
INPROGRESS_TIMESTAMP_ENTERPRISE | INPROGRESS_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date time that the transport job was put in 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 UTC date time that the transport job was put in an in progress status. |
INSTANCEID | INSTANCEID | System Calc | System calculation used for data partitioning. It is not intended for client reporting. |
IS_ROUND_TRIP_JOB | IS_ROUND_TRIP_JOB | Root | Displays true if the job is a round trip. A transporter might take a patient to a destination and then be asked to wait there briefly and then take the patient back. (For example, if a patient is having a test that takes five minutes, the lab technician might ask the transporter to wait during the test.) However, because of dispatching rules, if a new pending job is created, a different transporter might be assigned to take the patient back. If transporters who are asked to wait and take patients back have the Round Trips permission (assigned in the Admin Tool or Admin > Settings > Capacity Management component), then they can sign in to the IVR and enter a Round Trip option to assign themselves to take the patient back when the patient is ready. This will allow that transporter to return the patient to the origin location. When the code is entered, the original job is completed and a second job (to return the patient) is immediately created and assigned to the employee, in a status of Dispatched |
IS_ROUND_TRIP_JOB_BOOL | IS_ROUND_TRIP_JOB_BOOL | Root | Displays true if the job is a round trip. A transporter might take a patient to a destination and then be asked to wait there briefly and then take the patient back. (For example, if a patient is having a test that takes five minutes, the lab technician might ask the transporter to wait during the test.) However, because of dispatching rules, if a new pending job is created, a different transporter might be assigned to take the patient back. If transporters who are asked to wait and take patients back have the Round Trips permission (assigned in the Admin Tool or Admin > Settings > Capacity Management component), then they can sign in to the IVR and enter a Round Trip option to assign themselves to take the patient back when the patient is ready. This will allow that transporter to return the patient to the origin location. When the code is entered, the original job is completed and a second job (to return the patient) is immediately created and assigned to the employee, in a status of Dispatched |
Job Type Label | Job Type Label | Custom Calc | This indicates if the transport job was for a patient or for an item. |
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. 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 | 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. |
LATEST_DELAY_REASON_CODE | LATEST_DELAY_REASON_CODE | Root | The last reason that a transport job was delayed. Jobs that do not have a delay at time of appointment but have one added later will show a reasoncode of NULL, but the timestamp will still be collected. |
LATEST_DELAY_TYPE | LATEST_DELAY_TYPE | Root | Indicates if the latest delay type was recored while the transport job. |
LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP | LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP | Root | The local date and time that the latest assist delay ended while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. |
LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP_ENTERPRISE | LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time that the latest assist delay ended while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP_UTC | LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP_UTC | Root | The UTC date and time that the latest assist delay ended while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. |
LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP | LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP | Root | The local date and time that the latest assist delay started while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. |
LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP_ENTERPRISE | LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time that the latest assist delay began while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP_UTC | LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP_UTC | Root | The UTC date and time that the latest assist delay began while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. |
LATEST_DISPATCH_DELAY_END_TIMESTAMP | LATEST_DISPATCH_DELAY_END_TIMESTAMP | Root | The local date and time that the latest delay ended while the job was in Dispatch status. |
LATEST_DISPATCH_DELAY_END_TIMESTAMP_ENTERPRISE | LATEST_DISPATCH_DELAY_END_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time that the latest assist delay ended while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_DISPATCH_DELAY_END_TIMESTAMP_UTC | LATEST_DISPATCH_DELAY_END_TIMESTAMP_UTC | Root | The UTC date and time that the latest assist delay ended while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. |
LATEST_DISPATCH_DELAY_START_TIMESTAMP | LATEST_DISPATCH_DELAY_START_TIMESTAMP | Root | The local date and time that the latest delay began while the job was in Dispatch status. |
LATEST_DISPATCH_DELAY_START_TIMESTAMP_ENTERPRISE | LATEST_DISPATCH_DELAY_START_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time that the latest delay began while the job was in Dispatch status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_DISPATCH_DELAY_START_TIMESTAMP_UTC | LATEST_DISPATCH_DELAY_START_TIMESTAMP_UTC | Root | The UTC date and time that the latest delay began while the job was in Dispatch status. |
LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP | LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP | Root | The local date and time that the latest assist delay ended while the job was in the In progress status. This is a delay that is set after the required number of assisting transporters have joined the job. |
LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP_ENTERPRISE | LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time that the latest assist delay ended while the job was in the In progress status. This is a latest delay that is set after the required number of assisting transporters have joined the job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP_UTC | LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP_UTC | Root | The UTC date and time that the latest assist delay ended while the job was in the In progress status. This is a latest delay that is set after the required number of assisting transporters have joined the job. |
LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP | LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP | Root | The local date and time that the latest assist delay started while the job was in the In progress status. This is a latest delay that is set after the required number of assisting transporters have joined the job. |
LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP_ENTERPRISE | LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time that the latest assist delay started while the job was in the In progress status. This is a latest delay that is set after the required number of assisting transporters have joined the job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP_UTC | LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP_UTC | Root | The UTC date and time that the latest assist delay started while the job was in the In progress status. This is a latest delay that is set after the required number of assisting transporters have joined the job. |
LATEST_INPROGRESS_DELAY_END_TIMESTAMP | LATEST_INPROGRESS_DELAY_END_TIMESTAMP | Root | The local date and time that the latest delay ended while the job was in Inprogress status. |
LATEST_INPROGRESS_DELAY_END_TIMESTAMP_ENTERPRISE | LATEST_INPROGRESS_DELAY_END_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time that the latest delay ended while the job was in Inprogress status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_INPROGRESS_DELAY_END_TIMESTAMP_UTC | LATEST_INPROGRESS_DELAY_END_TIMESTAMP_UTC | Root | The UTC date and time that the latest delay ended while the job was in Inprogress status. |
LATEST_INPROGRESS_DELAY_START_TIMESTAMP | LATEST_INPROGRESS_DELAY_START_TIMESTAMP | Root | The local date and time that the latest delay began while the job was in Inprogress status. |
LATEST_INPROGRESS_DELAY_START_TIMESTAMP_ENTERPRISE | LATEST_INPROGRESS_DELAY_START_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time that the latest delay began while the job was in Inprogress status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_INPROGRESS_DELAY_START_TIMESTAMP_UTC | LATEST_INPROGRESS_DELAY_START_TIMESTAMP_UTC | Root | The UTC date and time that the latest delay began while the job was in Inprogress status. |
LATEST_LASTMODDATE_ENTERPRISE | LATEST_LASTMODDATE_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. |
LATEST_RESCHEDULE_TIMESTAMP | LATEST_RESCHEDULE_TIMESTAMP | Root | The local date and time of the latest reschedule for an appointment job. |
LATEST_RESCHEDULE_TIMESTAMP_ENTERPRISE | LATEST_RESCHEDULE_TIMESTAMP_ENTERPRISE | Root | The enterprise date and time of the latest reschedule for an appointment job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_RESCHEDULE_TIMESTAMP_UTC | LATEST_RESCHEDULE_TIMESTAMP_UTC | Root | The UTC date and time of the latest reschedule for an appointment job. |
N/A | Leap Year Days | Custom Calc | A field used in standard content to derive if the year of the created date is in a year which is a leap year. |
N/A | LOD Number of Records | Custom Calc | Returns the sum number of records for the entire data source. Dimension filters only apply if they are context filters. |
Mode Of Transport | Mode Of Transport | Root | The means by which the patient is transported, such as stretcher, wheelchair, ambulatory, bed. This is in the travel requirements of the transport job. |
N/A | Month Colors | Custom Calc | A field used in standard content to indicate if the month of the created date matches the 'current month' parameter value. |
N/A | Month Selector (Denominator) | Custom Calc | A field used in standard content to determine if a record is in the current month. |
N/A | Number of Days | Custom Calc | Not to be used for client calculations |
N/A | Number of Jobs | Custom Calc | The count of transport jobs. |
Number of Records | Number of Records | Root | The number of transport jobs. Each row in the data set equals 1. |
Origin Building | Origin Building | Root | The physical structure within a facility where medical care is provided and where an item or patient was picked up for a transport job. |
Origin Campus | Origin Campus | Root | The name of a collection of buildings in the enterprise that the origin location is associated with. This defined in the enterprise information of the Capacity IQ® application. |
Origin Discipline | Origin Discipline | Root | The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn where an item or patient was picked up for a transport job. |
Origin Enterprise | Origin Enterprise | Root | The name of the enterprise associated with the location where an item or patient was picked up from for a transport job. These are defined in the Enterprise information of the Capacity IQ® application. |
Origin Floor | Origin Floor | Root | The floor of the unit that the origin location of the transport job is associated with. |
Origin Location | Origin Location | Root | The location name for the bed where an item or patient was picked up for a transport job. |
Origin Location Type | Origin Location Type | Root | The identifier for the bed type where an item or patient was picked up for a transport job. |
Origin Room | Origin Room | Root | The identifier for the room associated with the location where an item or patient was picked up for a transport job. |
Origin Unit | Origin Unit | Root | The unit associated with the location where the patient was located before being moved. |
Origin Unit Category | Origin Unit Category | Root | The category of the unit associated with the origin location of the transport job. |
ORIGIN_UNIT_CATEGORY_CODE | Origin Unit Category Code | System Calc | The category code of the unit associated with the origin location of the transport job. This field is intended for standard content language localization, and not intended for client report building. |
ORIGIN_BED_ADT_ID | ORIGIN_BED_ADT_ID | Root | The bed ADT ID set in the location settings of the location the transport job took the patient from. |
ORIGIN_CAMPUSID | ORIGIN_CAMPUSID | System Calc | An internal campus database identifier. This field is not intended for report building. |
ORIGIN_CUSTOMER_FACILITY_ID | ORIGIN_CUSTOMER_FACILITY_ID | Root | The campus account ID associated with the location the transport job took the patient from. This value is set in the campus settings. |
ORIGIN_FACILITY_ADT_ID | ORIGIN_FACILITY_ADT_ID | Root | The Facility ADT ID set in the location settings of the location the transport job took the patient from. |
ORIGIN_LOCATION_ID | ORIGIN_LOCATION_ID | System Calc | An internal location database identifier. This field is not intended for report building. |
ORIGIN_LOCATION_TYPE_CODE | ORIGIN_LOCATION_TYPE_CODE | Root | This is a field used to assist with multi language deployment of teletracking standard content, and is not intended for client report building. |
ORIGIN_NURSESTATION_ADT_ID | ORIGIN_NURSESTATION_ADT_ID | Root | The Nursing Station ADT ID set in the location settings of the location the transport job took the patient from. |
ORIGIN_ROOM_ADT_ID | ORIGIN_ROOM_ADT_ID | Root | The Room ADT ID set in the location settings of the location the transport job took the patient from. |
Patient DOB | Patient DOB | Root | The local date time of the date of birth of the person receiving medical treatment. |
Patient MRN | Patient MRN | Root | The medical record number for person receiving medical treatment. |
Patient Name | Patient Name | Root | The first and last name of the person receiving medical treatment. |
Pending Timestamp | Pending Timestamp | Root | The latest local date time when the job was marked as pending. |
N/A | Pending Timestamp (copy) | Custom Calc | Local date of the pending timestamp. |
N/A | Pending To Complete Compliance | Custom Calc | 1-(SUM([Pending to Complete Out of Threshold])/COUNT([Pending To Completed Time])) Shows the percentage of transports within the 'Pending to Complete' threshold. |
N/A | Pending To Complete Out of Threshold | Custom Calc | {INCLUDE [Tt Job Id]: IF AVG([Pending To Completed Time]) > [Pending to Complete] THEN COUNT([Tt Job Id]) ELSE 0 END} Calculates the number of transports with a Pending to Complete time outside of the 'Pending to Complete' threshold. |
N/A | Pending To Complete Threshold Label | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Pending To Complete Threshold Label Text | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
Pending To Completed Time | Pending To Completed Time | Root | The time that it took to transport the item or patient from when the job had a Pending status until it was in Completed status, including any time that the job was in a Delay status. Pending_to_ Completed_Time is calculated as: 10:45 – 10:00 = 45 min. Calculation: Completed Timestamp minus First Pending Timestamp. |
N/A | Pending To Dispatch Compliance | Custom Calc | 1-(SUM([Pending to Dispatch Out of Threshold])/COUNT([Pending To Dispatch Time])) Shows the percentage of transports within the 'Pending to Dispatch' threshold. |
N/A | Pending To Dispatch Out of Threshold | Custom Calc | {INCLUDE [Tt Job Id]: IF AVG([Pending To Dispatch Time]) > [Pending to Dispatch] THEN COUNT([Tt Job Id]) ELSE 0 END} Calculates the number of transports with a Pending to Complete time outside of the 'Pending to Dispatch' threshold. |
N/A | Pending To Dispatch Threshold Label | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Pending To Dispatch Threshold Label Text | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
Pending To Dispatch Time | Pending To Dispatch Time | Root | The total duration in minutes from when a transport job was set to Pending status until it was set to a Dispatch status. Pending_to_Dispatch_Time is calculated as: 10:10 – 10:00 = 10 minutes Calculation: Dispatched Timestamp minus Pending Timestamp. |
Pending To In Progress Time | Pending To In Progress Time | Root | The total duration in minutes from when a transport job was set to Pending status until it was set to Dispatch status. Calculation: Dispatched Timestamp minus Pending Timestamp. |
N/A | Pending To InProgress Compliance | Custom Calc | 1-(SUM([Pending to Inprogress Out of Threshold])/COUNT([Request to Inprogress])) Shows the percentage of transports within the 'Pending to In Progress' threshold. |
N/A | Pending To InProgress Out of Threshold | Custom Calc | {INCLUDE [Tt Job Id]: IF AVG([Request to Inprogress]) > [Pending to In Progress] THEN COUNT([Tt Job Id]) ELSE 0 END} Calculates the number of transports with a Pending to Complete time outside of the 'Pending to In Progress' threshold. |
PENDING_TIMESTAMP_ENTERPRISE | PENDING_TIMESTAMP_ENTERPRISE | Root | The latest date and enterprise time that a transport job was in an in pending status in Capacity IQ®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
PENDING_TIMESTAMP_UTC | PENDING_TIMESTAMP_UTC | Root | The latest date and local time that a transport job was in an in pending status in Capacity IQ®. |
RECHEDULED_REASON_CODE | RECHEDULED_REASON_CODE | Root | The latest reason that a job was rescheduled to a different date and time. |
N/A | Request to in Progress Threshold Label | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Request To In Progress Threshold Label Text | Custom Calc | A field used in standard content to determine if we display a "above threshold" indicator, "Approaching Threshold", or "Within Threshold. If the Average Dispatch to Complete time is below the goal set in the parameter controls, it will display "Within Threshold" if it exceeds the goal, but is withing 20% of meeting the goal, it will display approaching threshold. If it exceeds the goal by more than 20%, it will display "Above Threshold." |
N/A | Request To In Progress Time | Custom Calc | The difference in minutes between the pending timestamp and the in progress timestamp. |
N/A | Request to Inprogress | Custom Calc | The difference in minutes between the dispatched timestamp and the in progress timestamp. |
Tenantid | Tenantid | System Calc | System calculation that is used in data partitioning. Not meant for client reporting. |
N/A | Time Format Dispatch To Complete | Custom Calc | A field in standard content that displays the specific metric in a time format of HH:MM |
N/A | Time Format Dispatch To In Progress | Custom Calc | A field in standard content that displays the specific metric in a time format of HH:MM |
N/A | Time Format In Progress To Completed | Custom Calc | A field in standard content that displays the specific metric in a time format of HH:MM |
N/A | Time Format Pending To Complete | Custom Calc | A field in standard content that displays the specific metric in a time format of HH:MM |
N/A | Time Format Pending To Dispatch | Custom Calc | A field in standard content that displays the specific metric in a time format of HH:MM |
N/A | Time Format Request To In Progress | Custom Calc | A field in standard content that displays the specific metric in a time format of HH:MM |
Total Delay Time | Total Delay Time | Root | Sum of the duration for all delay statuses. |
N/A | Total Delay Time Format | Custom Calc | A field in standard content that displays the specific metric in a time format of HH:MM |
Total Inprogress Time | Total Inprogress Time | Root | Sum of all Dispatch to In Progress times. Takes into account any delays in order to give an idea of total time in In Progress status for a job. |
Total Transporters | Total Transporters | Root | The total number of transporters that were actually involved in the transport job. |
N/A | Transport Jobs Per Day | Custom Calc | A field used in our standard content to derive the daily average number of transports in a month. |
TRAVEL_REQUIREMENT_1 | TRAVEL_REQUIREMENT_1 | Root | The first travel requirement for a job, such as "fall precaution, ventilator, bring therapy equipment." |
TRAVEL_REQUIREMENT_2 | TRAVEL_REQUIREMENT_2 | Root | The second travel requirement for a job, such as "fall precaution, ventilator, bring therapy equipment." |
TRAVEL_REQUIREMENT_3 | TRAVEL_REQUIREMENT_3 | Root | The third travel requirement for a job, such as "fall precaution, ventilator, bring therapy equipment." |
TRAVEL_REQUIREMENT_4 | TRAVEL_REQUIREMENT_4 | Root | The fourth travel requirement for a job, such as "fall precaution, ventilator, bring therapy equipment." |
Tt Job Id | Tt Job Id | Root | The identifier for a transport job. This job ID appears on the user interface. |
Tt Job Status | Tt Job Status | Root | The latest status that the transport job has. This includes:
Refer to the Capacity IQ® Transport help page for details about each status. |
Tt Job Type | Tt Job Type | Root | What the transport job is transporting. This will either be an item type job, or a patient type job. |
TT_JOB_STATUS_CODE | TT_JOB_STATUS_CODE | System Calc | This is a field used to assist with multi language deployment of teletracking standard content, and is not intended for client report building. |
Visit Number | Visit Number | Root | The patient's External ID (ADT). This represents the visit number in the Capacity IQ® application. |