Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Description |
ACQUISITION_DATE | Acquisition Date | Root | System calculation that allows us to see when the data was acquired in the source system. |
ACQUISITION_DATE_UTC | 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 | Actual Discharge Timestamp | Root | The date and time of day that the patient was actually discharged. |
ACTUAL_DISCHARGE_TIMESTAMP_ENTERPRISE | 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 | Attribute Category | Root | The type of grouping for a patient attribute. For example, Admit Status, Interventions, Organism. |
ATTRIBUTE_CATEGORY_ID | 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 | Attribute End Timestamp | Root | Date and time the attribute was removed from a patient. |
ATTRIBUTE_END_TIMESTAMP_ENTERPRISE | 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 | Attribute End Timestamp UTC | Root | Date and time in UTC the attribute was removed from a patient. |
ATTRIBUTE_ID | Attribute ID | Root | The unique identifier custom attribute(s) associated with the patient's visit. This includes isolation attributes. |
ATTRIBUTE_NAME | Attribute Name | Root | The custom attribute(s) associated with the patient's visit. This includes isolation attributes. |
ATTRIBUTE_START_TIMESTAMP | Attribute Start Timestamp | Root | Date and time the attribute was applied to a patient. |
ATTRIBUTE_START_TIMESTAMP_ENTERPRISE | 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 | Attribute Start Timestamp UTC | Root | Date and time in UTC the attribute was applied to a patient. |
ATTRIBUTE_TOTAL_DURATION | Attribute Total Duration | Root | The total duration in minutes from Attribute Start Timestamp to Attribute End Timestamp. |
ATTRIBUTE_TYPE | Attribute Type | Root | Whether the attribute is a Custom Attribute or Isolation. |
ATTRIBUTE_TYPE_ID | Attribute Type Id | Root | The unique identifier that determines if it is a custom attribute or isolation attribute. |
BED_ADT_ID | 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 | Campus | Root | The name of a collection of buildings in the enterprise. |
CAMPUS_ID | Campus ID | Root | The unique identifier of a collection of buildings in the enterprise. |
CLOUDACQUISITION_DATE | Cloudacquisition Date | Root | System calculation that allows us to see when the data was acquired into the cloud. |
CLOUDACQUISITION_DATE_UTC | Cloudacquisition Date UTC | Root | System calculation that allows us to see when the data was acquired into the cloud in UTC. |
CREATEDDATE | Createddate | Root | Created Date in Local Time zone for when the record was entered. |
CREATEDDATE_ENTERPRISE | 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 | Createddate UTC | Root | Created Date in UTC for when the record was entered. |
DISCIPLINE | 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 | 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 | Instanceid | Root | The name of the instance GUID — Non–Strict Dynamic Partition Column. |
IS_BED_MATCHING | Is Bed Matching | Root | The patient's admission location had an attribute matching what was set for the patient. |
LASTMODDATE_ENTERPRISE | 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 | Latest Lastmoddate | Root | The date of the most recent update to the Patient Visit record in local time zone. |
LATEST_LASTMODDATE_ENTERPRISE | 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 | Latest Lastmoddate UTC | Root | The date of the most recent update to the Patient Visit record in UTC. |
LOCATION | Location | Root | The name of the individual bed location. |
LOCATION_ID | Location ID | Root | The unique identifier of the individual bed location. |
NURSESTATION_ADT_ID | 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 | Patient Firstname | Root | Patient's first name. |
PATIENT_LASTNAME | Patient Lastname | Root | Patient's last name. |
PATIENT_MRN | Patient Mrn | Root | Patient's medical record number as defined by ADT mapping. |
PATIENT_STATUS_TYPE | Patient Status Type | Root | Capacity IQ® patient status type to filter outpatients, confirmed discharge, pending discharge, preadmit. |
PATIENT_VISIT_ID | Patient Visit ID | Root | The Database or Internal Record ID for a patient's visit. |
PATIENT_VISIT_NUMBER | Patient Visit Number | Root | The patient's External ID (ADT). |
ROOM_ADT_ID | 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 | TenantID | Root | The name of the tenant GUID — Non–Strict Dynamic Partition Column. |
UNIT | Unit | Root | The name of the unit that includes the location which the patient physically occupied. |
UNIT_ID | Unit ID | Root | The unique identifier of the unit that includes the location which the patient physically occupied. |
WAREHOUSEACQUISITIONDATE_UTC | Warehouseacquisitiondate UTC | Root | System calculation that allows us to see when the data was acquired in the source system in UTC. |