This page provides high-level overviews of each data source, including a brief description of the contents and typical data latency.

For detailed information about the specific data points—such as definitions, data structure, and folder organization—please refer to the individual articles for each data source or refer to the data points page.

BTJob is a Standard Lane data source showing Environmental Services data from Capacity IQ®. Each row in this data source shows an individual cleaning job. The unique identifier for this dataset is a combination of Instance_ID and Job_Id. This data source contains historical data and has a latency of ~45-90 minutes.

Care Progression Indicators is a Standard Lane data source that contains Care Progression Group information where there is at least one ordered Care Type. This data source also includes Patient Visit information associated with the Care Progression Group. The unique identifier for this dataset is a combination of Instance ID and Milestone_Entity_Id. This data source contains historical data and has a latency of 3 hours.

Care Progression Indicators Detail is a Standard Lane data source that contains Care Type information for each Ordered Care Progression Group. This data source also includes Patient Visit information associated with the Care Progression Group. Each row consists of Milestone_Entity_Detail_Id. This data source contains historical data and has a latency of 3 hours.

Case Physician CommunicationIQ Case is a Standard Lane data source that provides a historical perspective on physician communication records originating from Transfer IQ®. It encompasses timestamps of various communication events, including the initial contact, the initial response (when the call is returned), and the most recent timestamp associated with physician disposition (Cancelled, Consulted, Declined, Accepted, Admitting). Typically, each row corresponds to a single physician communication card, and multiple rows may exist in cases where communication cards for the physician were deleted. Currently, each row in this data set is uniquely identified by Case_Communication_Id. Prior to 2022, the unique identifier for this dataset is a combination Transfer_Id and Physician_Id. This data source contains historical data and has a latency of ~45-90 minutes.

This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

Census Snapshot is a Standard Lane data source that contains hourly census data for each unit. All measures and dimensions relate to the unit. The unit must have a discipline other than 'None' in order to calculate any measures. Each row in this data set represents a snapshot of a given hour for an individual unit. Each row in this data set is uniquely identified by a combination of Instance ID and Statistic_Snapshot_Id. This data source contains historical data and has a latency of ~45-90 minutes.

Discharge Milestone is a Standard Lane data source that contains historical view of Discharge Milestones recorded, the times they are marked as delayed or completed, and any notes associated with them. Each row in this data set represents an individual discharge milestone for a patient record. The unique identifier for this dataset is a combination of Instance ID and Milestone_Entity_Detail_Id. This data source contains historical data and has a latency of 3 hours.

IQ Behavioral Health is a Standard Lane data source that contains historical details about behavioral health assessments recorded in Transfer IQ®. Each row in this data set represents a single assessment in a Transfer Center Case. A transfer center case may have more than one assessment associated with it. The unique identifier for this dataset is a combination of Behavioral_Id. This data source contains historical data and has a latency of ~45-90 minutes.

IQ Case is a Standard Lane data source that contains transfer case data. Each row in this data set represents an individual transfer center case. The unique identifier for this dataset is a combination of Transfer_Id. This data source contains historical data and has a latency of ~45-90 minutes.

IQ Case Access Audit Log is a Standard Lane data source that contains records for each time a user interacted with a case in Transfer IQ®. Each row in this data set represents an individual instance that a user viewed or edited a case. This data source contains historical data and has a latency of ~45-90 minutes. Data Warehouse Connector customers will need to perform this join within their queries.

IQ Case Escalation Communication is a Standard Lane data source that contains a historical view of escalation communication records from Transfer IQ®. It includes the times they are created, the initial contact recorded, when the call is initially returned (Initial Response), and the latest time an escalation disposition is recorded (cancelled, resolved, unresolved). Each row in this data source represents an individual escalation communication card. The unique identifier for this dataset is a combination of Transfer_Id and Staff_Id or Physician_Id. This data source contains historical data and has a latency of ~45-90 minutes.

This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

IQ Case Escalation Communication Detail data source contains the detailed events occurring in escalation communications in each transfer center case. Each of the events in the communications history will be a unique row in this data set, including the times contacted, the times where the call is returned, and the times when any disposition is set on the communication record. The unique identifier for this dataset is Communication_Id. This data source contains historical data and has a latency of ~45-90 minutes.

This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

IQ Case Facility Communication is a Standard Lane data source that provides a historical perspective on facility communication records originating from Transfer IQ®. It encompasses timestamps of various communication events, including the initial contact, the initial response (when the call is returned), and the most recent timestamp associated with facility disposition (Cancelled, Consulted, Accepted, Redirected and Declined). Each row corresponds to a single facility communication card, and multiple rows may exist in cases where communication cards for the facility were deleted. The unique identifier for this dataset is a combination of Facility_Id and Transfer_Id. This data source contains historical data and has a latency of ~45-90 minutes.

This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

The IQ Case Facility Communication Detail is a Standard Lane data source that captures comprehensive communication events within a facility communication card for each transfer center case. Each event in the communication history is represented as a distinct row in this dataset. It provides timestamps for contact, when a call is returned, and when any disposition is applied to the facility communication record. The unique identifier for this dataset is Communication\_Id. This data source contains historical data and has a latency of ~45-90 minutes.

This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

IQ Case Issue is a Standard Lane data source that contains issue data recorded in transfer cases. Each row in this data set represents an individual issue recorded for a transfer case. This data source includes deleted issues. The unique identifier for this data set is Issue_Id. This data source contains historical data and has a latency of ~45-90 minutes. This data source is joined against the IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

IQ Case Issue Note is a Standard Lane data source that contains notes recorded against issues in a transfer case. Each row in this data set represents a note recorded in an issue. This data source includes deleted notes. The unique identifier for this data set is Issue_Note_Id. This data source contains historical data and has a latency of ~45-90 minutes. This data source is joined against the IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

IQ Case Note is a Standard Lane data source that contains any notes recorded to a transfer center case. Each row represents individual case notes. The unique identifier for this dataset is Note_Id. This data source contains historical data and has a latency of ~45-90 minutes. This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

The IQ Case Physician Communication Detail data source contains the detailed events occurring in physician communications in each transfer center case. Each of the events in the communications history will be a unique row in this data set, including the times contacted, the times when the call is returned, the times conferenced, and the times when any disposition is set on the communication record. The unique identifier for this dataset is Communication_Id. This data source contains historical data and has a latency of ~45-90 minutes.

This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

As pictured below, each history item recorded will be in this data source.

IQ Case Staff Communication is a Standard Lane data source that provides a historical perspective on staff communication records originating from Transfer IQ®. It encompasses timestamps of various communication events, including the initial contact, the initial response (when the call is returned), and the most recent timestamp associated with staff disposition (Cancelled, Declined, Accepted, and Consulted). Typically, each row corresponds to a single staff communication card, and multiple rows may exist in cases where communication cards for the staff member were deleted. The unique identifier for this dataset is Case_Communication\_Id. This data source contains historical data and has a latency of ~45-90 minutes.

This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

IQ Case Staff Communication Detail is a Standard Lane data source that captures comprehensive communication events with a staff member within each transfer center case. Each event in the communication history is represented as a distinct row in this dataset, providing timestamps for contact, when a call is returned, and when any disposition is applied to the staff communication record. The unique identifier for this dataset is Communication_Id. This data source contains historical data and has a latency of ~45-90 minutes. This data source is joined against IQ Case data source within Data IQ®. Data IQ® Warehouse Connector customers will need to perform this join within their queries.

IQ Enterprise structure is a Standard Lane data source that contains the Enterprise Structure configured in the IQ Enterprise Settings. Each row in this data set represents a facility and what hierarchy they are placed within the Enterprise Structure(Enterprise 1 is the top most level of the Enterprise Structure and Enterprise 26 is the lowest level). This data source excludes Deleted Facilities. The unique identifier for this data set is Facility_Id. This data source contains historical data, and has a latency of ~45-90 minutes. This data source in Data IQ® is joined against the IQ Case data source in three possible ways: Referring Facility, Destination Facility, Preferred Facility. Data Warehouse Connector customers will need to perform this join within their queries.

Location Action Status is a Standard Lane Data Source that contains bed location and status level information from Capacity IQ® for beds with EVS Service enabled. The granularity of this data source is at the Location Status Change Level for a given location – meaning each row represents a different status change for a bed and contains the start and end time for that status. If the status change was associated with a patient visit, then the patient visit and MRN information will be available. The unique identifier for this dataset is a combination of Instance ID, Source_Table and Source_table_primarykey_id. This data source has a latency of ~45-90 minutes.

For example, the image below shows the Actions on a two-bed location for two days. Each action has a Status Start Timestamp (when the action began) and a Status End Timestamp (when the status was removed). In the cases where there are 2 rows for an action (Dirty and Pending), both of those actions were started and completed at the same time.

The following image provides a visual example of the actions for a given location:

In this example, Bed 1 was occupied from Midnight until 4 PM, then it was set to a status of Pending/Dirty for about an hour. Then, the action status was briefly changed to action statuses of In Progress and Complete before being Clean for about 5 hours.

In the Blocked Beds standard content, users can see the currently blocked beds by looking at any location that has an Action of “Blocked” and a Status End Timestamp of “Null”. This means that the action has been set to “Blocked”, but that action has not been removed.

This same logic can be used to create a list of currently occupied patients. Any patient that has an Action of “Occupied” and a Status End Timestamp of “Null” are currently occupying a bed in the health system.

For any additional questions, please contact TeleTracking® Support.

Patient Placement is a Standard Lane data source that contains data related to Patient Placements. Each row in this data source represents an individual patient placement request (Preadmits and Pending Transfers). The unique identifier for this data set is a combination of Instance_ID and Placement_Id. This data source contains historical data, and has a latency of ~45-90 minutes.

Patient Visit is a Standard Lane data source that contains a historical view of patient visit records, the latest times they are admitted, marked as pending/confirmed discharge, and actually discharged. This data source also includes all the patient details dimensions. Each row in this data source represents an individual patient visit record on an instance of the Capacity IQ® solution. The unique identifier for this dataset is a combination of Instance_ID and Patient_Visit_Id. The Patient_Visit_Id is a different field from the Patient_Visit_Number. The Patient_Visit_Number is visible on the front end of the Capacity IQ® application, the Patient_Visit_Id is the unique identifier. This data source contains historical data and has a latency of ~45-90 minutes.

Transporter Employee Performance is a Standard Lane data source that contains data related to hourly metrics of each transporter. Each row in this data source contains metrics for a given transporter in a given hour of the day. Details about a transporter will only be available if the transporter was logged in during those hours. The unique identifier for this data set is a combination of Instance_ID, Enterprise_User_ID, Start_Date and Hour. This data source contains historical data and has a latency of 3 hours.

Transport Tracking is a Standard Lane data source which contains a historical view of metrics related to physical patient moves done by Transporters within the Capacity IQ® application. Each row in this data source represents an individual transport job. This includes both patient and item jobs. The unique identifier for this dataset is a combination of Instance_ID and TT_Job_Id. This data source contains historical data and has a latency of ~45-90 minutes.

Volume Analysis is a Standard Lane data source that contains hourly volume data for each unit. The number of admits, discharges, transfers and more are available in this data source. All measures and dimensions relate to the unit. Each row in this data set represents a snapshot of a given hour for an individual unit. The unique identifier for this dataset is a combination of Instance_ID and Statistics_Cumulative_Id. This data source contains historical data and has a latency of ~45-90 minutes.