Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
N/A | Admit | Root | Total number of admission transactions. |
N/A | Assigned | Root | Total number of patients assigned to a location. |
N/A | Blocked | Root | Total number of times a location entered the blocked status. |
N/A | Campus | Root | Displays the campus from which the census data is captured. |
N/A | Cancel Admit | Root | Total volume of cancelled admissions transactions. |
N/A | Clean | Root | Total number of times a location entered the clean status. |
N/A | Clean Next | Root | Total number of times a location entered the cleannext status. |
N/A | ConfirmedDischarge | Root | Total number of times a confirmed discharge was entered. |
CREATEDDATE_ENTERPRISE | Created Date Enterprise | Root | The date and time of when volume data was created for each unit in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
N/A | Dirty | Root | Total number of times a location entered the dirty status. |
N/A | Discharge | Root | Total number of discharge transactions that removed a patient from their corresponding location. |
N/A | InProgress | Root | Total number of times a location entered the in progress status. |
LATEST_LASTMODDATE_ENTERPRISE | Latest Lastmoddate Enterprise | Root | The date and time of the latest update to volume data for each unit, displayed in the enterprise time zone. |
N/A | Occupied | Root | Total number of times a location entered the occupied status. |
N/A | PendingDischarge | Root | Total number of times a pending discharge was entered. |
N/A | PendTransfer | Root | Total number of times a pending discharge was entered. |
N/A | ReAdmit | Root | Total number of times a patient was removed from a location and then readmitted. |
N/A | Requested | Root | Total number of requests entered into the system. |
N/A | Stat | Root | Total number of times a location entered the Stat status. |
N/A | TransfersIn | Root | Total number of transfer transactions that resulted in an occupied bed within the corresponding unit. |
N/A | TransfersOut | Root | Total number of transfer transactions that resulted in a patient moving to another unit. |
N/A | Unit | Root | Displays the unit (the name of patient unit) from which the data is captured. |
N/A | UDef8 | Root | Total number of times a location entered the Udef8 (user defined-8) status. |
N/A | UDef9 | Root | Total number of times a location entered the Udef9 (user defined-9) status. |
N/A | UnOccupied | Root | Total un-occupied volume. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |