Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Description |
Bed ADT ID | Bed ADT ID | Root | A unique identifier for the individual bed location. |
Campus ID | Campus ID | Root | The unique identifier of the campus in which the Lost Bed Time took place. |
Campus Name | Campus Name | Root | The name of the campus in which the Lost Bed Time took place. |
Cleaned Timestamp | Cleaned Timestamp | Root | The time the bed was marked as cleaned in local time. |
Cleaned Timestamp Enterprise | Cleaned Timestamp Enterprise | Root | The time the bed was marked as cleaned in enterprise time. |
Cleaned Timestamp Utc | Cleaned Timestamp Utc | Root | The time the bed was marked as cleaned in UTC. |
Customer Facility ID | 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 | Datepartition | Root | System calculation used internally to partition the data. This field is not intended for client report building. |
Enterprise ID | Enterprise ID | Root | The unique identifier of a collection of campuses. |
Enterprise Name | Enterprise Name | Root | The name of a collection of campuses. |
Facility ADT ID | 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 | Instanceid | Root | A system calculation used for data partitioning. It is not intended for client reporting. |
Latest Lastmoddate Utc | Latest Lastmoddate Utc | Root | The date of the most recent update to the assignment in UTC time. |
Location ID | Location ID | Root | The unique identifier of the location associated with the assignment. |
Location Name | Location Name | Root | The location associated with the assignment. |
Lost Bed Time Unique ID | Lost Bed Time Unique ID | Root | The unique identifier for the data source. An ID per occurrence of Lost Bed Time. |
Notified Timestamp | Notified Timestamp | Root | The time of the notification of the cleaning job in local time. |
Notified Timestamp Enterprise | Notified Timestamp Enterprise | Root | The time of the notification of the cleaning job in enterprise time. |
Notified Timestamp Utc | Notified Timestamp Utc | Root | The time of the notification of the cleaning job in UTC. |
Nursestation ADT ID | Nursestation ADT ID | Root | The Nursing Station ADT ID of the assignment location. |
Reoccupied Timestamp | Reoccupied Timestamp | Root | The time the bed was occupied by the next patient in local time. |
Reoccupied Timestamp Enterprise | Reoccupied Timestamp Enterprise | Root | The time the bed was occupied by the next patient in enterprise time. |
Reoccupied Timestamp Utc | Reoccupied Timestamp Utc | Root | The time the bed was occupied by the next patient in UTC. |
Room ADT ID | Room ADT ID | Root | A unique identifier associated with the room. |
Tenantid | Tenantid | Root | Tenant GUID. This is a non-strict dynamic partition column. |
Unit Category Code | Unit Category Code | Root | The grouping of units associated with the unit. |
Unit Category Name | Unit Category Name | Root | The grouping of units associated with the unit. |
Unit Category Type ID | Unit Category Type ID | Root | The grouping of units associated with the unit. |
Unit Discipline | 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 | Unit ID | Root | A unique identifier associated with the unit. |
Unit Name | Unit Name | Root | The unit associated with the location that had Lost Bed Time. |
Unoccupied Timestamp | Unoccupied Timestamp | Root | The time the patient left the bed in local time. |
Unoccupied Timestamp Enterprise | Unoccupied Timestamp Enterprise | Root | The time the patient left the bed in enterprise time. |
Unoccupied Timestamp Utc | Unoccupied Timestamp Utc | Root | The time the patient left the bed in UTC. |
Warehouseacquisitiondate Utc | Warehouseacquisitiondate Utc | Root | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |
Blocked Time | Blocked Time | Root | The amount of time the location was marked as blocked during the occurrence of Lost Bed Time. |
Cleaned To Reoccupied Time | Cleaned To Reoccupied Time | Root | The time between cleaned and reoccupied timestamps. |
Lost Bed Time | Lost Bed Time | Root | The time between unoccupied and reoccupied timestamps. |
Notified To Cleaned Time | Notified To Cleaned Time | Root | The time between notified and cleaned timestamps. |
Unoccupied To Notified Time | Unoccupied To Notified Time | Root | The time between unoccupied and notified timestamps. |