Tableau Data Source Field

Folder

Description

Acquisitiondate

Root

The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building.

Acquisitiondate UTC

Root

The first step in the data ingestion process in UTC format. Used internally for latency calculations. This field is not intended for client report building.

Action

Root

The status change value associated with location status changes (Clean, Occupied, Blocked, etc)

BED_ADT_ID

System Calc

The bed ADT ID of the location associated with the status change.

Bed Size Name

Root

The bed size assigned to the location in the bed settings.

Bt Display Status

Root

The Capacity IQ® EVS display status of the location. If the location is in a status associated with a bed cleaning job, this will be the status of the bed cleaning job.

Bt Display Status Id

System Calc

A unique identifier associated with the display status. This field is not intended for client report building.

BT_DISPLAY_STATUS_TYPE_CODE

System Calc

System calculation used for localization filtering. Displays the display status types (that do not change with language). This field is not intended for client report building.

Building

Root

The building associated with the location which had a status change.

Building Id

Root

The database identifier for the building associated with the location. Not Intended for client report building

Campus

Root

The campus associated with the location having a status change.

Campus ID

Root

A unique identifier associated with campus. This field is not intended for client report building.

Cloudacquisitiondate

System Calc

The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building.

Cloudacquisitiondate UTC

System Calc

The second step in the data ingestion process. The field is is un UTC time. Used internally for latency calculations. This field is not intended for client report building.

Createddate

Root

Created Date in Local Time zone for when the record was entered.

CREATEDDATE_ENTERPRISE

Root

Created Date in enterprise time for when the record was entered. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

Createddate UTC

Root

Created Date in UTC Time zone for when the record was entered.

CUSTOMER_FACILITY_ID

Root

The campus account ID value set in the campus settings for the campus associated with each unit.

DATEPARTITION

System Calc

System calculation used internally to partition the data for efficient processing. This field is not intended for client report building.

Enterprise

Root

The name of a collection of campuses.

Enterprise Id

Root

A unique identifier associated with the enterprise. This field is not intended for client report building.

FACILITY_ADT_ID

System Calc

The facility ADT ID of the location associated with the status change. If this value is NULL in the location settings, it is derived from the campus settings.

Floor

Root

The floor associated with the location which had a status change.

Floor Id

System Calc

A unique identifier associated with the floor. This field is not intended for client report building.

INSTANCEID

System Calc

System calculation used for data partitioning. It is not intended for client reporting.

Isallowbedstacking

Root

Indicates if the location allows multiple occupying patients at the same time.

Isbtlocation

Root

Indicates if the location has been assigned an EVS zone.

Iscountedaspermanent

Root

Indicates if the location is counted as a permanent bed.

Isevsservice

Root

Indicates if the location is has the EVS service setting enabled and is has bed cleaning enabled.

Isholdingbed

Root

Indicates if the bed is a holding bed.

Ishygiene

Root

Indicates if a location needs to be included in a staff members hand hygiene index score.

Isincludedincensus

Root

Indicates if the location bed is included in census counts.

Isisolated

Root

If the location is configured with 'Is Isolated Area' enabled, then True, otherwise false. This setting is only available with Location IQ® and Patient Tracking Enabled.

Isshownonbedboard

Root

Indicates if the location bed is shown on the electronic BedBoard.

Istransportlocation

Root

Indicates if the location is assigned a transport zone.

Lastmoddate

Root

The date of the most recent update to the location status change in local time zone. Use the CreatedDate for reporting purposes.

LASTMODDATE_ENTERPRISE

Root

The Date in enterprise time for when the record was last modified. 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 location status change in UTC. Use the CreatedDate_UTC for reporting purposes.

LATEST_LASTMODDATE_ENTERPRISE

Root

The date of the most recent update to the location status change in the enterprise time zone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

LATEST_LASTMODDATE_UTC

Root

The date of the most recent update to the location status change in UTC. Use the CreatedDate_UTC for reporting purposes.

Location

Root

The location associated with the status change.

Location Id

System Calc

A unique identifier associated with the location. This field is not intended for client report building.

LOCATION_STATUS

Root

The current action (status) of a BedTracking Job or the physical bed's location status.

Location Status Id

System Calc

A unique identifier associated with the location status. This field is not intended for client report building.

LOCATION_STATUS_TYPE_CODE

System Calc

The code for a current action (status) of a BedTracking Job or the physical bed's location status. This field is not intended for client reporting.

Location Type

Root

The type of bed location such as Admit, Discharge, Exam/Treatment Home, Specialty, or Other.

LOCATION_TYPE_CODE

System Calc

The code of bed location such as Admit, Discharge, Exam/Treatment Home, Specialty, or Other. This field is not intended for client reporting.

NURSESTATION_ADT_ID

System Calc

The Nursing Station ADT ID of the location. If the value is empty in the location, it will be derieved from the unit settings.

Reasoncode Id

System Calc

A unique identifier associated with the reason code associated with the status change. This field is not intended for client report building.

Room

Root

The room associated with the location.

ROOM_ADT_ID

System Calc

The room ADT ID of the location associated with the status change.

Room Id

System Calc

A unique identifier associated with the room associated with the status change. This field is not intended for client report building.

Rownum

Root

The number of records in the data set. Each row equals 1.

Status Date Timestamp

Root

Displays the current status start time and date.

STATUS_DATE_TIMESTAMP_ENTERPRISE

Root

Displays the current status start time and date in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

Status Date Timestamp UTC

Root

Displays the current status start time and date in UTC.

Status Reason

Root

Displays the reason for a BedTracking Job, or physical bed's current action (status).

Tenantid

System Calc

System calculation that is used in data partitioning. Not meant for client reporting.

Unit

Root

The unit associated with the location which had a status change.

Unit Category

Root

The unit category associated with the unit that the location is in.

UNIT_CATEGORY_TYPE_CODE

System Calc

The unique identifier for a group of locations and rooms that are all on one floor of a building.

Unit Discipline

Root

The discipline associated with the unit that the location is in.

Unit Id

System Calc

A unique identifier associated with the unit. This field is not intended for client report building.

Warehouseacquisitiondate Utc

System Calc

The latest timestamp that a record is inserted in Snowflake Data Warehouse in UTC format.