Data Points
Tableau Data Source Field | Folder | Description |
Acquisition Date | Root | System calculation that allows us to see when the data was acquired in the source system. |
Acquisition Date UTC | Root | System calculation that allows us to see when the data was acquired in the source system in UTC. |
Actual Discharge Timestamp | Root | The date and time of day that the patient was actually discharged. |
Actual Discharge Timestamp Enterprise | Root | The date and time of day (in enterprise time) that the patient was actually discharged. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Attribute Category | Root | The type of grouping for a patient attribute. For example, Admit Status, Interventions, Organism. |
Attribute Category ID | Root | The unique identifier for the type of grouping for a patient attribute. For example, Admit Status, Interventions, Organism. |
Attribute End Timestamp | Root | Date and time the attribute was removed from a patient. |
Attribute End Timestamp Enterprise | Root | Date and time in enterprise time the attribute was removed from a patient. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Attribute End Timestamp UTC | Root | Date and time in UTC the attribute was removed from a patient. |
Attribute ID | Root | The unique identifier custom attribute(s) associated with the patient's visit. This includes isolation attributes. |
Attribute Name | Root | The custom attribute(s) associated with the patient's visit. This includes isolation attributes. |
Attribute Start Timestamp | Root | Date and time the attribute was applied to a patient. |
Attribute Start Timestamp Enterprise | Root | Date and time in enterprise time the attribute was applied to a patient. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Attribute Start Timestamp UTC | Root | Date and time in UTC the attribute was applied to a patient. |
Attribute Total Duration | Root | The total duration in minutes from Attribute Start Timestamp to Attribute End Timestamp. |
Attribute Type | Root | Whether the attribute is a Custom Attribute or Isolation. |
Attribute Type Id | Root | The unique identifier that determines if it is a custom attribute or isolation attribute. |
BED_ADT_ID | System Calc | A unique identifier for the indiviual bed location. This is the bed ADT ID that is associated with the location. |
Campus | Root | The name of a collection of buildings in the enterprise. |
Campus ID | Root | The unique identifier of a collection of buildings in the enterprise. |
Cloudacquisition Date | Root | System calculation that allows us to see when the data was acquired into the cloud. |
Cloudacquisition Date UTC | Root | System calculation that allows us to see when the data was acquired into the cloud in UTC. |
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 for when the record was entered. |
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 includes the bed that was cleaned. |
FACILITY_ADT_ID | System Calc | A unique identifier for an individual facility. This is the Facility ADT ID that is associated with the location. |
Instanceid | Root | The name of the instance GUID — Non–Strict Dynamic Partition Column. |
Is Bed Matching | Root | The patient's admission location had an attribute matching what was set for the patient. |
Lastmoddate Enterprise | Root | The date of the most recent update to the Patient Visit record in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Latest Lastmoddate | Root | The date of the most recent update to the Patient Visit record in local time zone. |
Latest Lastmoddate Enterprise | Root | The date of the most recent update to the Patient Visit record in enterprise time. 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 Patient Visit record in UTC. |
Location | Root | The name of the individual bed location. |
Location ID | Root | The unique identifier of the individual bed location. |
NURSESTATION_ADT_ID | System Calc | A unique identifier for an individual nurse station. This is the Nursestation ADT ID that is associated with the location. |
Patient Firstname | Root | Patient's first name. |
Patient Lastname | Root | Patient's last name. |
Patient Mrn | Root | Patient's medical record number as defined by ADT mapping. |
Patient Status Type | Root | Capacity IQ® patient status type to filter outpatients, confirmed discharge, pending discharge, preadmit. |
Patient Visit ID | Root | The Database or Internal Record ID for a patient's visit. |
Patient Visit Number | Root | The patient's External ID (ADT). |
ROOM_ADT_ID | System Calc | A unique identifier for an individual room. This is the Room ADT ID that is associated with the location. |
TenantID | Root | The name of the tenant GUID — Non–Strict Dynamic Partition Column. |
Unit | Root | The name of the unit that includes the location which the patient physically occupied. |
Unit ID | Root | The unique identifier of the unit that includes the location which the patient physically occupied. |
Warehouseacquisitiondate UTC | Root | System calculation that allows us to see when the data was acquired in the source system in UTC. |