Data Points
Tableau Data Source Field | Folder | Description |
Active Incoming Preadmit Assign | Root | The count of activated bed requests with a status of Assign (i.e., a bed is assigned). Calculation: The total number of active bed requests that have beds assigned to the patient and are from the Capacity IQ® PreAdmit application |
Active Incoming Pre Admit Request | Root | The count of activated bed requests with a target unit selected. |
Active Incoming Transfer Assign | Root | The count of activated in-house transfer requests with a status of Assign (i.e., a bed is assigned). |
Active Incoming Transfer Request | Root | The count of activated in-house transfer requests with a target unit selected. |
Available Beds | Root | This field includes beds marked as "Is Permanent" and excludes beds that are Blocked, Occupied, or Dirty. |
Assignment Priority Bed | Root | The priority of a bed as assigned by users. |
Campus | Root | The name of a collection of buildings in the enterprise that includes the occupied bed. |
Campus City | Root | City of campus location. |
Campus Date Time | Root | The date and time of day when the event was captured. |
Campus Date Time Enterprise | Root | The date and time of day the event was captured in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Campus Date Time UTC | Root | The date and time of day the event was captured UTC. |
Campus State | Root | The state in which the campus is located. |
Campus State Abbreviation | Root | The postal abbreviation for the state in which the campus is located. |
Campus Street | Root | Street address of the campus location. |
Campus Zip | Root | ZIP code of campus location. |
Clean | Root | The number of beds with a status of Clean. |
Confirmed Discharge | Root | The number of beds with a status of Confirmed Discharge. |
CONFIRMED_DISCHARGE_TODAY | Root | The number of patients that are confirmed to discharge having Projected Discharge date in the Capacity IQ® application set to prior to the end of the day Today. |
COVID-19 Confirmed | Root | Number of patients in house (not discharged) diagnosed positive for COVID-19; based on Patient Attribute of “COV%19” or “COV%19%+” or “COV%19 Pos%” or “COV%19 C%” (Pos% for variants of ‘positive’ and C% for variants of ‘confirmed’). |
COVID-19 Negative | Root | The number of patients that have tested negative for COVID-19 in the facility. |
COVID-19 PUI | Root | Number of patients in-house (not discharged) under investigation for COVID-19 based on Patient Attribute of “COV%19 PUI” or “COV%19 S%” or “COV%19 Pen%” (S% for variants of ‘Suspected' or ‘Screening’ and Pen% for variants of ‘Pending’). |
Dirty | Root | The number of beds with a status of Dirty. |
Discipline | Root | The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn that include the occupied bed. |
Discipline ID | Root | The unique identifier assigned to different disciplines in the facility. |
Enterprise | Root | The name of a collection of campuses that includes the occupied bed. |
Inactive Incoming Pre Admit Assign | Root | The number of inactive bed requests with a status of Assign originating in the Capacity IQ® PreAdmit application. |
Inactive Incoming Pre Admit Request | Root | The number of inactive bed requests originating in the Capacity IQ® PreAdmit application. |
Inactive Incoming Transfer Request | Root | The number of inactive bed requests originating in the Transfer IQ® application. |
Inactive Incoming Transfer Assign | Root | The number of inactive bed requests with a status of Assign originating in the Transfer IQ® application. |
INCOMING_PREADMIT_ASSIGN_TODAY
| Root | The projected number of new patients with a bed assigned to the unit having the Bed Requested Date in the Capacity IQ® application set to now till the end of the day Today. |
INCOMING_PREADMIT_REQUEST_TODAY
| Root | The projected number of new patients targeted to the unit having the Bed Requested Date in the Capacity IQ® application set to now till the end of the day Today. |
INCOMING_TRANSFER_ASSIGN_TODAY
| Root | The projected number of internal transfer patients with a bed assigned to the unit having the Bed Requested Date in the Capacity IQ® application set to now till the end of the day Today. |
INCOMING_TRANSFER_REQUEST_TODAY
| Root | The projected number of internal transfer patients targeted to the unit having the Bed Requested Date in the Capacity IQ® application set to now till the end of the day Today. |
In Progress | Root | The number of beds with a status of In Progress. |
Lastmoddate | Root | The date of the most recent update to the transfer case in local time zone. |
Lastmoddate Enterprise | Root | The date of the most recent update to the transfer case in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Lastmoddate UTC | Root | The date of the most recent update to the transfer case in UTC. |
Near Nurse Clean Beds | Root | Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Near Nurse%” that are in Clean status. |
Near Nurse Occupied Beds | Root | Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Near Nurse%” that are in Occupied status. |
Near Nurse Other Beds | Root | Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Near Nurse%” excluding beds that are Occupied or Clean. |
Negative Pressure Clean Beds | Root | Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Negative Air%” or “Negative Pres%” that are in Clean status. |
Negative Pressure Occupied Beds | Root | Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Negative Air%” or “Negative Pres%” that are in Occupied status. |
Negative Pressure Other Beds | Root | Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Negative Air%” or “Negative Pres%” excluding beds that are Occupied or Clean. |
Occupied Non-permanent | Root | The number of Non-Permanent beds with a status of Occupied. |
Occupied Permanent | Root | The number of permanent beds that are occupied. |
Outgoing Assigned | Root | Count of outgoing requests that have been assigned. |
OUTGOING_ASSIGNED_TODAY | Root | The projected number of internal transfer patients with a bed assigned in another unit having the Bed Requested Date in the Capacity IQ® application set to prior to the end of the day Today. |
Outgoing Unassigned | Root | Count of outgoing requests that have not been assigned. |
OUTGOING_UNASSIGNED_TODAY | Root | The projected number of internal transfer patients targeted to another unit having the Bed Requested Date in the Capacity IQ® application set to prior to the end of the day Today. |
Pending Discharge | Root | The number of beds with a status of Pending Discharge. Calculation: The total number of the Pending Discharge beds. |
PENDING_DISCHARGE_TODAY | Root | The number of patients that are pending to discharge having Projected Discharge date in the Capacity IQ® application set to prior to the end of the day Today. |
Permanent Beds | Root | The number of Permanent beds. |
Priority Clean Next | Root | The number of beds with a cleaning priority of Clean Next. |
Priority Dirty | Root | The number of beds with a cleaning priority of Dirty. |
Priority Stat | Root | The number of beds with a cleaning priority of Stat. |
Priority Udef8 | Root | The number of beds with a cleaning priority of Udef8. |
Priority Udef9 | Root | The number of beds with a cleaning priority of Udef9. |
Requested | Root | The number of beds that have a status of Requested. |
Staffed Bed Count | Root | The number of staffed beds with any status. |
Suspended | Root | The number of beds with a status of Suspend. |
Tenant ID | Root | Tenant GUID - Non-Strict Dynamic Partition Column. |
Total Blocked | Root | The number of beds with a status of Blocked. |
Total Incoming Placement Count | Root | Count of incoming placement requests. |
Total Occupied | Root | Count of occupied beds. |
Total Outgoing Placement Count | Root | In the unit's latest hourly snapshot, the number of requests to transfer patients to another unit. Calculation: The total number of requests to transfer patients to another unit. |
Total Virtual Blocked | Root | Count of virtual blocked beds. |
Unit | Root | The target unit selected for activated incoming Pre Admit and Transfer requests. |
Unit Abbreviation | Root | The shortened name of the target unit selected for activated incoming Pre Admit and Transfer requests. |
Unit Category Name | Root | The grouping of units that is associated with the target unit selected for activated incoming Pre Admit and Transfer requests. |
Unit Category Name (group) | Root | The grouping of unit groups that are associated with the target unit selected for activated incoming Pre Admit and Transfer requests. |
Unit ID | Root | The unique identifier assigned to a unit. |
Ventilator Intervention | Root | Number of patients in house (not discharged) with Patient Attribute “Vent%”. |