Data Points
Tableau Data Source Field | Folder | Description |
Bed ADT ID | Root | A unique identifier for the individual bed location. |
Campus ID | Root | The unique identifier of the campus in which the Lost Bed Time took place. |
Campus Name | Root | The name of the campus in which the Lost Bed Time took place. |
Cleaned Timestamp | Root | The time the bed was marked as cleaned in local time. |
Cleaned Timestamp Enterprise | Root | The time the bed was marked as cleaned in enterprise time. |
Cleaned Timestamp Utc | Root | The time the bed was marked as cleaned in UTC. |
Customer Facility ID | Root | If a facility is integrated with the Capacity IQ, and the facility recorded in the staff communication history entry has an external identifier, it will display the value set in the campus settings for that facility. |
Datepartition | Root | System calculation used internally to partition the data. This field is not intended for client report building. |
Enterprise ID | Root | The unique identifier of a collection of campuses. |
Enterprise Name | Root | The name of a collection of campuses. |
Facility ADT ID | Root | The facility ADT ID of the location associated with the Lost Bed Time. If this value is NULL in the location settings, it is derived from the campus settings. |
Instanceid | Root | A system calculation used for data partitioning. It is not intended for client reporting. |
Latest Lastmoddate Utc | Root | The date of the most recent update to the assignment in UTC time. |
Location ID | Root | The unique identifier of the location associated with the assignment. |
Location Name | Root | The location associated with the assignment. |
Lost Bed Time Unique ID | Root | The unique identifier for the data source. An ID per occurrence of Lost Bed Time. |
Notified Timestamp | Root | The time of the notification of the cleaning job in local time. |
Notified Timestamp Enterprise | Root | The time of the notification of the cleaning job in enterprise time. |
Notified Timestamp Utc | Root | The time of the notification of the cleaning job in UTC. |
Nursestation ADT ID | Root | The Nursing Station ADT ID of the assignment location. |
Reoccupied Timestamp | Root | The time the bed was occupied by the next patient in local time. |
Reoccupied Timestamp Enterprise | Root | The time the bed was occupied by the next patient in enterprise time. |
Reoccupied Timestamp Utc | Root | The time the bed was occupied by the next patient in UTC. |
Room ADT ID | Root | A unique identifier associated with the room. |
Tenantid | Root | Tenant GUID. This is a non-strict dynamic partition column. |
Unit Category Code | Root | The grouping of units associated with the unit. |
Unit Category Name | Root | The grouping of units associated with the unit. |
Unit Category Type ID | Root | The grouping of units associated with the unit. |
Unit Discipline | Root | The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavioral Health, Med/Surgical, or Burn, that includes the assignment location. |
Unit ID | Root | A unique identifier associated with the unit. |
Unit Name | Root | The unit associated with the location that had Lost Bed Time. |
Unoccupied Timestamp | Root | The time the patient left the bed in local time. |
Unoccupied Timestamp Enterprise | Root | The time the patient left the bed in enterprise time. |
Unoccupied Timestamp Utc | Root | The time the patient left the bed in UTC. |
Warehouseacquisitiondate Utc | Root | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |
Blocked Time | Root | The amount of time the location was marked as blocked during the occurrence of Lost Bed Time. |
Cleaned To Reoccupied Time | Root | The time between cleaned and reoccupied timestamps. |
Lost Bed Time | Root | The time between unoccupied and reoccupied timestamps. |
Notified To Cleaned Time | Root | The time between notified and cleaned timestamps. |
Unoccupied To Notified Time | Root | The time between unoccupied and notified timestamps. |