Data Points
Tableau Data Source Field | Folder | Description |
Acquisitiondate Utc | System Calc | The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
Actual Discharge Timestamp | Root | The latest local date time that the patient entered a discharged status. If the discharge status is removed, the dsicharge date/time will be removed. |
ACTUAL_DISCHARGE_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date time that the patient entered a discharged status. If the discharge status is removed, the dsicharge date/time will be removed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
ACTUAL_DISCHARGE_TIMESTAMP_UTC | Root | The latest UTC date time that the patient entered a discharged status. If the discharge status is removed, the dsicharge date/time will be removed. |
Admit Source | Root | The latest admit source recorded in the patient visit record. |
Admit Timestamp | Root | The latest local admit date/time successfully processed by the HL7 interface or manually admitted in the application. |
Admitdatetime Enterprise | Root | The latest enterprise date/time the patient record was admitted to their initial home bed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Admitdatetime Utc | Root | The latest utc date/time the patient record was admitted to their initial home bed. |
Adt Discharge Timestamp | Root | The latest local date/time we recieved from the HL7 transaction that the patient was discharged. This date/time may be backdated; For example, if the ADT user enters the discharge in the ADT system at 5pm, but notes that the patient was physically discharged at noon, then this will be noon date time supplied by the ADT user. |
ADT_DISCHARGE_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date/time we recieved from the HL7 transaction that the patient was discharged. This date/time may be backdated; For example, if the ADT user enters the discharge in the ADT system at 5pm, but notes that the patient was physically discharged at noon, then this will be noon date time supplied by the ADT user. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
ADT_DISCHARGE_TIMESTAMP_UTC | Root | The latest utc date/time we recieved from the HL7 transaction that the patient was discharged. This date/time may be backdated; For example, if the ADT user enters the discharge in the ADT system at 5pm, but notes that the patient was physically discharged at noon, then this will be noon date time supplied by the ADT user. |
Attending Physician | Root | The latest physician marked as 'attending' in the patient record. The name physician who is responsible for the patient's care while the patient is in the hospital. The name appears in Last Name, First Name format. |
ATTENDING_PHYSICIAN_ADT_ID | Root | The ADT ID of the latest physician marked as 'attending' in the patient record. The name physician who is responsible for the patient's care while the patient is in the hospital. |
BED_ADT_ID | Root | The bed ADT ID of the latest home location recorded for the patient. |
Campus | Root | The campus associated with the patient visit record when the record was created. |
Campus City | Root | The city in which the campus is located. |
Campus Id | System Calc | A unique identifier associated with campus. This field is not intended for client report building. |
Campus State | Root | The state in which the campus is located. |
Campus State Abbreviation | Root | The postal abbreviation for the state in which the campus is located. |
Campus Street | Root | The street on which the campus is located. |
Campus Zip Code | Root | The zip code in which the campus is located. |
Cloudacquisitiondate Utc | Root | The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
Confirmed Discharge Timestamp | Root | The latest local date/time that the patient visit record was marked as confirmed discharge. |
Confirmed Discharge To Discharge Time | Root | The duration in minutes that the patient was in a Confirmed Discharge status until actually being discharged. Calculation: Actual Discharge Timestamp minus Confirmed Discharge Timestamp |
CONFIRMED_DISCHARGE_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date/time that the patient visit record was marked as confirmed discharge. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
CONFIRMED_DISCHARGE_TIMESTAMP_UTC | Root | The latest utc date/time that the patient visit record was marked as confirmed discharge. |
Createddate | Root | Created Date in Local Time zone for when the record was entered. |
Createddate Enterprise | Root | Created Date in the enterprise Time zone 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. |
Current Campus | Root | The campus name associated with the patient's latest current location. |
Current Discipline | Root | The discipline name associated with the patient's latest current location. |
Current Enterprise | Root | The enterprise name associated with the patient's latest current location. |
Current Location | Root | The location name for the latest current location associated with the patient vist record. |
Current Location Id | Root | The location ID for the latest current location associated with the patient vist record. This field is not intended for client report building |
Current Unit | Root | The unit name of the unit associated with the patient's most recent current location. |
Current Unit Category | Root | The unit category name of the unit associated with the patient's most recent current location. |
CURRENT_BED_ADT_ID | Root | The bed ADT ID of the latest current location recorded for the patient. |
CURRENT_CAMPUS_ID | System Calc | The campus ID associated with the patient's latest current location. This field is not intended for client report building. |
CURRENT_CUSTOMER_FACILITY_ID | Root | The campus account ID value set in the campus settings associated with the patient's latest current location. |
CURRENT_FACILITY_ADT_ID | Root | The facility ADT ID of the latest current location recorded for the patient. If this value is NULL in the location settings, it is derived from the campus settings |
CURRENT_NURSESTATION_ADT_ID | Root | The Nursing Station ADT ID of the latest current location recorded for the patient. If this value is NULL in the location settings, it is derived from the unit settings |
CURRENT_ROOM_ADT_ID | Root | The room ADT ID of the latest current location recorded for the patient. |
CURRENT_UNIT_CATEGORY_CODE | System Calc | This field is not intended for client report building. |
CUSTOMER_FACILITY_ID | Root | The campus account ID value set in the campus settings for the campus the patient record was created in. |
Datepartition | System Calc | Non-strict dynamic partition column. This field is not intended for client report building. |
Discharge Source | Root | The first recorded discharge source for each patient visit record. Handheld - Any action performed in the mobile application that results in discharging the patient. IVR Channel - Any action performed in the Interactive Voice Response system that results in discharging the patient. NaviOR- Any action performed in the CWS application that results in discharging the patient. Windows Service - Any action from the HL7 transactions that results in discharging the patient. Workstation - Any action from the teletracking user interface that results in dischargine the patient. Location IQ® - A discharge resulting from when a patient's Location Tracking tag or badge is located in a discharge location, or when their patient badge is placed in a discharge drop box. |
Discharge Source Product | Root | The first recorded discharge source product recorded for each patient visit record. DischargeByADT - Discharges where the HL7 transactions that results in discharging the patient. DischargeByBT - Discharges where the source was through the IVR for EVS. DischargeByTT - Where the patient status was transported to a location set up as a discharge location. DischargeByOrchestrate - Clinical Workflow® suite DischargeByUI - Discharges where discharge was caused by some action in the browser based user interface. DischargeByMobileBT - Discharges where the source was through the Capacity IQ® EVS Mobile application. DischargeByMobileTT - Where the patient status was transported to a location using the mobile application and the destination location was set up as a discharge location. |
DISCHARGE_SOURCE_PRODUCT_NAME | Root | The discharge source product for each patient visit record: DischargeByADT, DischargeByBT, DischargeByTT, DischargeByOrchestrate, DischargeByTT, DischargeByUI. |
Discipline | Root | The discipline associate with the unit the patient's latest home location is in. |
Enterprise | Root | The name of the collection of campuses that the patient visit record was created in. |
Event Timestamp | System Calc | This field is not intended for client report building. |
EVENT_TIMESTAMP_ENTERPRISE | System Calc | This field is not intended for client report building. |
EVENT_TIMESTAMP_UTC | System Calc | This field is not intended for client report building. |
Expected Discharge Timestamp | Root | The latest projected discharge date/time in local time for the patient visit record |
EXPECTED_ADMIT_TIMESTAMP | Root | The latest expected admit date in local time for the patient visit record. |
EXPECTED_ADMIT_TIMESTAMP_ENTERPRISE | Root | The latest expected admit date in enterprise time for the patient visit record. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
EXPECTED_ADMIT_TIMESTAMP_UTC | Root | The latest expected admit date in UTC time for the patient visit record. |
EXPECTED_DISCHARGE_TIMESTAMP_ENTERPRISE | Root | The latest projected discharge date/time in enterprise time for the patient visit record. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
EXPECTED_DISCHARGE_TIMESTAMP_UTC | Root | The latest projected discharge date/time in UTC time for the patient visit record. |
FACILITY_ADT_ID | Root | The facility ADT ID of the latest home location recorded for the patient. If this value is NULL in the location settings, it is derived from the campus settings |
Hospital Service | Root | The latest hospital service recorded in the patient visit record. The type of treatment or surgery for the patient (i.e., Oncology, Obstetrics, Adolescent, or Cardiology) is called Hospital Service or Service Line. |
Instanceid | System Calc | This field is not intended for client report building. |
Is Ever Admitted | Root | Indicates if the patient was ever admitted or not. |
Is Inhouse On Discharge | Root | Indicates that the patient was admitted to the facility prior to discharge. |
IS_INHOUSE_ON_DISCHARGE_BOOL | Root | Indicates that the patient was admitted to the facility prior to discharge. |
Isolation Type | Root | The code indicating the type of isolation that applies to the patient, such as Airborne, Droplet, Contact. |
Lastmoddate | System Calc | The latest date/time in local time that the patient visit record was modified in the database, and only include updates to the patient table. It is recommended to use the latest last mod date if you are filtering for records that are modified on a specified date/time, as this will include updates to other fields related to the patient table. (Physician, Placement information, etc). |
Lastmoddate Enterprise | System Calc | The latest date/time enterprise time that the patient visit record was modified in the database, and only include updates to the patient table. It is recommended to use the latest last mod date if you are filtering for records that are modified on a specified date/time, as this will include update to other fields related to the patient table. (Physician, Placement information, etc). The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Lastmoddate Utc | System Calc | The latest date/time in utc time that the patient visit record was modified in the database, and only include updates to the patient table. It is recommended to use the latest last mod date if you are filtering for records that are modified on a specified date/time, as this will include update to other fields related to the patient table. (Physician, Placement information, etc). |
Latest Lastmoddate Enterprise | Root | The latest date/time in enterprise time that the patient vist entry in the data source had an update. It is recommended to use the latest last mod date if you are filtering for records that are modified on a specified date/time, as this will include update to other fields related to the patient table. (Physician, Placement information, etc). The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Latest Lastmoddate Utc | Root | The latest date/time in utc time that the patient vist entry in the data source had an update. It is recommended to use the latest last mod date if you are filtering for records that are modified on a specified date/time, as this will include update to other fields related to the patient table. (Physician, Placement information, etc) |
Length Of Stay | Root | The duration in days from when the patient was admitted until the patient was discharged. Calculation: Actual Discharge Timestamp minus Admit Timestamp. |
LOCATION | Root | The latest home location name set for the patient visit record. |
LOCATION_ID | Root | The latest home location ID set for the patient visit record. This field is not intended for client report building. |
Number of Records | Root | The number of records in the data set. Each row in the data set = 1. |
NURSESTATION_ADT_ID | Root | The Nursing Station ADT ID of the latest home location associated with the patient visit record. If the value is empty in the location, it will be derived from the unit settings. |
Observation End Timestamp | Root | The latest observation end timestamp in local time. |
Observation Start Timestamp | Root | The latest observation start timestamp in local time. |
OBSERVATION_END_TIMESTAMP_ENTERPRISE | Root | The latest observation end timestamp in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
OBSERVATION_END_TIMESTAMP_UTC | Root | The latest observation end timestamp in UTC time. |
OBSERVATION_START_TIMESTAMP_ENTERPRISE | Root | The latest observation start timestamp in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
OBSERVATION_START_TIMESTAMP_UTC | Root | The latest observation start timestamp in UTC time. |
Patient Attribute Categories | Root | The type of patient attribute. For example, "Fall Risk". |
Patient Attributes | Root | The active patient attributes associated with the patient visit record. As attributes are removed from the patient record, they will be removed from this field. |
Patient Attributes With Category | Root | The custom attribute(s) associated with the patient’s visit and their category. This includes isolation attributes. |
Patient Diagnosis | Root | The latest admit diagnosis text associated with the patient visit record. |
Patient Dob | System Calc | Patient DOB in a string format. This field is not intended for client report building |
Patient Dob Timestamp | Root | The local date/time of the patient's date of birth. |
PATIENT_DOB_TIMESTAMP_ENTERPRISE | Root | The enterprise date/time of the patient's date of birth. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
PATIENT_DOB_TIMESTAMP_UTC | Root | The UTC date/time of the patient's date of birth. |
Patient Firstname | Root | The first name of the person receiving medical treatment. |
Patient Gender | Root | The gender set in the patient visit record. |
PATIENT_GENDER_CODE | System Calc | A field used in our standard content to support multi-language workbooks. This field is not intended for client report building. |
Patient Lastname | Root | The last name of the person receiving medical treatment. |
Patient Level Of Care | Root | The degree of care that the patient requires, such as critical, acute, intermediate. |
Patient Mrn | Root | The medical record number for person receiving medical treatment. |
Patient Status Type | Root | The latest patient status type set on the patient record. The values can include ConfirmedDischarge, Discharged, InHouse, OutPatient, PendingDischarge, PendingTransfer, PreAdmit, VisitCanceled. |
PATIENT_STATUS_TYPE_CODE | System Calc | A field used in our standard content to support multi-language workbooks. This field is not intended for client report building. |
PATIENT_TYPE | Root | The patient type as set in the patient's record in Capacity IQ®. |
Patient Visit Id | System Calc | The Database or Internal Record ID for a patient's visit. This field is not intended for client report building |
Patient Visit Number | Root | The patient's External ID (ADT). |
Pending Discharge Timestamp | Root | The latest local date and time of day that the patient's status was set to Pending Discharge. |
PENDING_DISCHARGE_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date and time of day that the patient's status was set to Pending Discharge. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
PENDING_DISCHARGE_TIMESTAMP_UTC | Root | The latest utc date and time of day that the patient's status was set to Pending Discharge. |
Pending Discharge To Confirmed Discharge Time | Custom Calc | The latest local date that the patient's status was set to Pending Discharge. |
Pending Discharge To Discharge Time | Root | The duration in minutes from the latest time the patient was in a status of Pending Discharge status until the latest actual discharge. Calculation: Actual Discharge Timestamp minus Pending Discharge Timestamp |
PENDING_TRANSFER_TIMESTAMP | Root | The latest local date time when the job was marked as pending. |
PENDING_TRANSFER_TIMESTAMP_ENTERPRISE | Root | The latest date and enterprise time that a transport job was in an in pending status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
PENDING_TRANSFER_TIMESTAMP_UTC | Root | The latest date and UTC time that a transport job was in an in pending status. |
ROOM_ADT_ID | Root | The Room ADT ID set in the location settings of the location the transport job took the patient to. |
Rtls Tag Id | Root | The latest Location IQ® TAG/Badge ID associated with the patient visit record. This is only present if Capacity IQ® is integrated with Location IQ®. |
Location IQ®_TAG_ATTACH_TIMESTAMP | Root | The latest local date/time that and Location Tracking tag/badge was associated with the patient. |
Location IQ®_TAG_ATTACH_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date/time that and Location Tracking tag/badge was associated with the patient. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Location IQ®_TAG_ATTACH_TIMESTAMP_UTC | Root | The latest utc date/time that and Location Tracking tag/badge was associated with the patient. |
Location IQ®_TAG_DETACH_TIMESTAMP | Root | The latest local date/time that and Location Tracking tag/badge was detached from the patient. |
Location IQ®_TAG_DETACH_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date/time that and Location Tracking tag/badge was detached from the patient. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
Location IQ®_TAG_DETACH_TIMESTAMP_UTC | Root | The latest utc date/time that and Location Tracking tag/badge was detached from the patient. |
Location IQ®_TAG_UNIQUE_ID | Root | The unique identifier of an Location Tracking tag. |
SPEC_BED_ADT_ID | Root | The bed ADT ID of the latest specialty location the patient currently occupies. |
SPEC_CUSTOMER_FACILITY_ID | Root | The campus account ID of the campus associated with the latest occupied specialty location |
SPEC_FACILITY_ADT_ID | Root | The facility ADT ID of the latest specialty location the patient currently occupies. |
SPEC_LOCATION | Root | The name of the latest specialty location the patient currently occupies. |
SPEC_LOCATION_CAMPUS | Root | The name of the campus associated with the latest specialty location the patient currently occupies. |
SPEC_LOCATION_CAMPUS_ID | System Calc | The database identifier of the campus associated with the latest specialty location the patient currently occupies. This field is not intended for client report building. |
SPEC_LOCATION_DISCIPLINE | Root | The database identifier of the campus associated with the latest specialty location the patient currently occupies. This field is not intended for client report building. |
SPEC_LOCATION_ENTERPRISE | Root | The name of the enterprise associated with the campus associated with the latest specialty location the patient currently occupies. |
SPEC_LOCATION_ID | System Calc | The database identifier of the latest specialty location the patient currently occupies. This field is not intended for client report building. |
SPEC_LOCATION_UNIT | Root | The name of the unit associated with the latest specialty location the patient currently occupies. |
SPEC_LOCATION_UNIT_CATEGORY | Root | The name of the unit category associated with the unit associated with the latest specialty location the patient currently occupies. |
SPEC_LOCATION_UNIT_CATEGORY_CODE | System Calc | A field used in our standard content to support multi-language workbooks. This field is not intended for client report building. |
SPEC_NURSESTATION_ADT_ID | Root | The nursing station ADT ID of the latest specialty location the patient currently occupies. |
SPEC_ROOM_ADT_ID | Root | The room ADT ID of the latest specialty location the patient currently occupies. |
Tenantid | System Calc | System calculation that is used in data partitioning. Not meant for client reporting. |
TRANSFER_TIMESTAMP | Root | The latest local date time of an ADT transfer processed by the integration engine for this patient visit. |
TRANSFER_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date time of an ADT transfer processed by the integration engine for this patient visit. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
TRANSFER_TIMESTAMP_UTC | Root | The latest UTC date time of an ADT transfer processed by the integration engine for this patient visit. |
Triggered By | System Calc | This field is not intended for customer report building. |
Unit | Root | The unit that includes the latest home location which the patient physically occupied. |
Unit Category | Root | The unit category associated with the latest home unit of the patient. The home unit is determined by the patient's home location. |
UNIT_CATEGORY_CODE | System Calc | This field is not intended for customer report building. |
WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in Snowflake Data Warehouse in UTC format. |