Snowflake Field Name

Tableau Data Source Field

Folder

Description

N/A

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.

N/A

Active Incoming Pre Admit Request

Root

The count of activated bed requests with a target unit selected.

N/A

Active Incoming Transfer Assign

Root

The count of activated in-house transfer requests with a status of Assign (i.e., a bed is assigned).

N/A

Active Incoming Transfer Request

Root

The count of activated in-house transfer requests with a target unit selected.

N/A

Assigned

Root

This number of beds that have a status of Assigned in the unit's latest hourly snapshot.

N/A

Assignment Priority Bed

Root

The priority of a bed as assigned by users.

N/A

Available Beds Minus Blocked

Root

The count of Available Beds minus Blocked Beds.

N/A

Blocked

Root

The number of beds in the unit's latest hourly snapshot with a status of Blocked.

N/A

Campus

Root

The name of a collection of buildings in the enterprise that includes the occupied bed.

N/A

Campus Exclude

Root

Copy of "Campus" used to exclude null campuses.

N/A

Clean

Root

The number of beds with a status of Clean.

N/A

Confirmed Discharge

Root

The number of beds with a status of Confirmed Discharge.

CREATEDDATE_ENTERPRISE

Createddate Enterprise

Root

The date and time of when the capacity snapshot was created in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

N/A

Date Partition

Root

Non-Strict Dynamic Partition Column.

N/A

Dirty

Root

The number of beds with a status of Dirty.

N/A

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.

N/A

Enterprise

Root

The name of a collection of campuses that includes the occupied bed.

EVENT_TIMESTAMP

Event Timestamp

Root

The date and time of day when the capacity snapshot was captured.

EVENT_TIMESTAMP_ENTERPRISE

Event Timestamp Enterprise

Root

The date and time of when the capacity snapshot was captured in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

N/A

Help

Root

"Help".

N/A

Hour

Root

The count of hours.

N/A

Inactive Incoming Pre Admit Assign

Root

The number of inactive bed requests with a status of Assign originating in the Capacity IQ® PreAdmit application.

N/A

Inactive Incoming Pre Admit Request

Root

The number of inactive bed requests originating in the Capacity IQ® PreAdmit application.

N/A

Inactive Incoming Transfer Request

Root

The number of inactive bed requests originating in the Transfer IQ® application.

N/A

Inactive Incoming Transfer Assign

Root

The number of inactive bed requests with a status of Assign originating in the Transfer IQ® application.

N/A

In Progress

Root

The number of beds with a status of In Progress.

LASTMODDATE

Lastmoddate

Root

The date of the most recent update to the transfer case in local time zone.

LASTMODDATE_ENTERPRISE

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

Lastmoddate UTC

Root

The date of the most recent update to the transfer case in UTC.

LATEST_LASTMODDATE_ENTERPRISE

Latest Lastmoddate Enterprise

Root

The latest update to the transfer case in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

N/A

Non Permanent Occupied Beds

Root

The number of Non-Permanent beds in the unit's latest hourly snapshot with a status of Occupied.

N/A

Occupied Census Beds

Root

Occupied beds counted in census.

N/A

Outbound Placement

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 for the most recent hourly snapshot.

N/A

Pending Discharge

Root

The number of beds with a status of Pending Discharge. Calculation: The total number of the Pending Discharge beds.

N/A

Permanent Beds

Root

The number of Permanent beds.

N/A

Permanent Occupied Beds

Root

The number of permanent beds in the unit's latest hourly snapshot that are occupied.

N/A

Physical Bed Pie

Root

Custom calc used to make pie chart (permanent beds minus occupied beds).

N/A

Physical Census %

Root

Physical bed minus the sum of permanent beds to get the calculation of percent census.

N/A

Priority Clean Next

Root

The number of beds with a cleaning priority of Clean Next.

N/A

Priority Dirty

Root

The number of beds with a cleaning priority of Dirty.

N/A

Priority Stat

Root

The number of beds with a cleaning priority of Stat.

N/A

Priority Udef8

Root

The number of beds with a cleaning priority of Udef8.

N/A

Priority Udef9

Root

The number of beds with a cleaning priority of Udef9.

N/A

Requested

Root

The number of beds that have a status of Requested.

N/A

Staffed Beds

Root

The number of staffed beds in the unit's latest hourly snapshot with any status.

N/A

Statistics Snapshot ID

Root

Unique identifier of time at which snapshot was taken.

N/A

Staffed Bed Pie

Root

Custom calc used to make pie chart. Calculation: SUM([Staffed])-SUM([Total Occupied])

N/A

Staffed Census %

Root

Physical bed minus the sum of staffed beds to get the calculation of percent census.

N/A

Suspend

Root

The number of beds in the unit's latest hourly snapshot with a status of Suspend.

N/A

Tenant ID

Root

Tenant GUID - Non-Strict Dynamic Partition Column.

N/A

Total Beds

Root

Total occupied beds plus available plus blocked beds.

N/A

Unit

Root

The target unit selected for activated incoming Pre-Admit and Transfer requests.

N/A

Unit Abbreviation

Root

The shortened name of the target unit selected for activated incoming Pre-Admit and Transfer requests.

N/A

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_ID

Unit Id

System Calc

A unique identifier associated with the unit.

WAREHOUSEACQUISITIONDATE_UTC

WAREHOUSEACQUISITIONDATE_UTC

System Calc

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