Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
N/A | 2 Days Ago | Custom Calc | This field displays a date 2 days prior to the current date in local date/time. |
ACQUISITIONDATE_UTC | 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. |
N/A | Actual Before 1:00 PM | Discharge Compliance | Returns the sum number of records where the actual discharge local date/time is before 1:00 PM. |
N/A | Actual Before 11:00 AM | Discharge Compliance | Returns the sum number of records where the actual discharge local date/time is before 11:00 AM. |
N/A | Actual Before 12:00 PM | Discharge Compliance | Returns the sum number of records where the actual discharge local date/time is before 12:00 PM. |
N/A | Actual Before 2:00 PM | Discharge Compliance | Returns the sum number of records where the actual discharge local date/time is before 2:00 PM. |
N/A | Actual Before 3:00 PM | Discharge Compliance | Returns the sum number of records where the actual discharge local date/time is before 3:00 PM. |
N/A | Actual Date Filter | Custom Calc | This is a legacy date filter that includes fewer options than the updated field. Please use 'Actual Date Filter Range V2' for new reports. |
N/A | Actual Date Filter Range V2 | Custom Calc | This is an updated date filter that includes an expanded array of preset date ranges to select using the 'Date Range' parameter. |
ACTUAL_DISCHARGE_TIMESTAMP | Actual Discharge Timestamp | Root | The latest local date time that the patient entered a discharged status. If the discharge status is removed, the discharge date/time will be removed. |
N/A | Actual Discharge Timestamp No Time | Custom Calc | The latest local date that the patient entered a discharged status. If the discharge status is removed, the discharge date will be removed. |
N/A | Actual Discharges Count | Custom Calc | The total number of discharges based on the number of actual discharge date/times recorded. |
ACTUAL_DISCHARGE_TIMESTAMP_ENTERPRISE | ACTUAL_DISCHARGE_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date time that the patient entered a discharged status. If the discharge status is removed, the discharge date/time will be removed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
ACTUAL_DISCHARGE_TIMESTAMP_UTC | ACTUAL_DISCHARGE_TIMESTAMP_UTC | Root | The latest UTC date time that the patient entered a discharged status. If the discharge status is removed, the discharge date/time will be removed. |
N/A | Adjustable Confirmed to Actual Colors | Custom Calc | Checks to see if the Avg Confirmed Discharge to Discharge Time is less than the value set in the Confirmed to Actual Threshold parameter. If it is less the output will be 'Green', otherwise it will be 'Red'. Assign this field to the color in Tableau to have dynamic colors. |
N/A | Adjustable Lower Bound | Custom Calc | Finds the number of cases where the hour of the Actual Discharge Timestamp occurred before the Lower Bound threshold. Then assigns 'Number of Records' to those cases. These are summed to give the total cases meeting the criteria. |
N/A | Adjustable Upper Bound | Custom Calc | Finds the number of cases where the hour of the Actual Discharge Timestamp occurred before the Upper Bound threshold. Then assigns 'Number of Records' to those cases. These are summed to give the total cases meeting the criteria. |
ADMIT_SOURCE | Admit Source | Root | The latest admit source recorded in the patient visit record. |
ADMIT_TIMESTAMP | Admit Timestamp | Root | The latest local admit date/time successfully processed by the HL7 interface or manually admitted in the application. |
N/A | Admit Timestamp (copy) | Custom Calc | The latest local admit date/time successfully processed by the HL7 interface or manually admitted in the application. |
ADMITDATETIME_ENTERPRISE | ADMITDATETIME_ENTERPRISE | Root | The latest enterprise admit date/time successfully processed by the HL7 interface or manually admitted in the application. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
ADMITDATETIME_UTC | ADMITDATETIME_UTC | Root | The latest UTC admit date/time successfully processed by the HL7 interface or manually admitted in the application. |
ADT_DISCHARGE_TIMESTAMP | 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 the noon date time supplied by the ADT user. |
ADT_DISCHARGE_TIMESTAMP_ENTERPRISE | 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 the 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 | 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 the noon date time supplied by the ADT user. |
N/A | Age | System Calc | Calculates the patient's age using years. Will be deprecated in future. Look for Data IQ® communication regarding new fields that will replace this in the near future |
N/A | Age (group) | System Calc | Provides buckets of ages for reporting. Groups ages in 10 year buckets. 0-9, 10-19, 20-29 etc . |
N/A | Age 2 | Custom Calc | Calculates the patient's age using years. Will be deprecated in future. Look for Data IQ® communication regarding new fields that will replace this in the near future. |
N/A | Age group CALC | System Calc | Provides buckets of ages for reporting. If [Age]>= 90 THEN "90+" ELSEIF [Age]>=80 THEN "80-89" ELSEIF [Age]>=70 THEN "70-79" ELSEIF [Age]>=60 THEN "60-69" ELSEIF [Age]>=50 THEN "50-59" ELSEIF [Age]>=40 THEN "40-49" ELSEIF [Age]>=30 THEN "30-39" ELSEIF [Age]>=20 THEN "20-29" ELSEIF [Age]>=10 THEN "10-19" ELSEIF [Age]>=0 THEN "0-9" ELSE "UNKNOWN" END |
N/A | Age group CALC 2 | Custom Calc | Provides buckets of ages for reporting. If [Age 2]>= 90 THEN "90+" ELSEIF [Age 2]>=80 THEN "80-89" ELSEIF [Age 2]>=70 THEN "70-79" ELSEIF [Age 2]>=60 THEN "60-69" ELSEIF [Age 2]>=50 THEN "50-59" ELSEIF [Age 2]>=40 THEN "40-49" ELSEIF [Age 2]>=30 THEN "30-39" ELSEIF [Age 2]>=20 THEN "20-29" ELSEIF [Age 2]>=10 THEN "10-19" ELSEIF [Age 2]>=0 THEN "0-9" ELSE "UNKNOWN" END |
N/A | Age Groups | System Calc | Provides 3 buckets of age groups looking for 'Minor', '18-59', and '60+'. IF [Age] <= 17 THEN "Minor" ELSEIF [Age] > 17 and [Age] < 60 THEN "18-59" ELSEIF [Age] > 59 THEN "60+" END |
N/A | Age Groups (Decade Split) | System Calc | Provides buckets of ages for reporting. IF [Age] <= 9 THEN "0-9" ELSEIF [Age] > 9 and [Age] < 20 THEN "10-19" ELSEIF [Age] >19 and [Age] < 30 THEN "20-29" ELSEIF [Age] >29 and [Age] < 40 THEN "30-39" ELSEIF [Age] >39 and [Age] < 50 THEN "40-49" ELSEIF [Age] >49 and [Age] < 60 THEN "50-59" ELSEIF [Age] >59 and [Age] < 70 THEN "60-69" ELSEIF [Age] >69 and [Age] < 80 THEN "70-79" ELSEIF [Age] >79 and [Age] < 90 THEN "80-89" ELSE "90+" END |
AGE_BUCKET | AGE_BUCKET | Root | Age bucket field from root data source. This field is not intended for client report building. |
AGE_IN_YEARS | AGE_IN_YEARS | Root | Age calculated in years field from root data source. This field is not intended for client report building. |
ATTENDING_PHYSICIAN | 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. |
N/A | 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 | BED_ADT_ID | Root | The bed ADT ID of the latest home location recorded for the patient. |
N/A | Before 11 and 2 | Custom Calc | Indicates if the patient's actual discharge in local time was 'Before 11', 'Before 2', or 'After 2'. This field is not intended for client report building. |
CAMPUS | Campus | Root | The campus associated with the patient visit record when the record was created. |
CAMPUS_CITY | CAMPUS_CITY | Root | The city in which the campus is located. |
CAMPUS_ID | CAMPUS_ID | System Calc | A unique identifier associated with campus. This field is not intended for client report building. |
CAMPUS_STATE | CAMPUS_STATE | Root | The state in which the campus is located. |
CAMPUS_STATE_ABBREVIATION | CAMPUS_STATE_ABBREVIATION | Root | The postal abbreviation for the state in which the campus is located. |
CAMPUS_STREET | CAMPUS_STREET | Root | The street on which the campus is located. |
CAMPUS_ZIP_CODE | CAMPUS_ZIP_CODE | Root | The zip code in which the campus is located. |
CLOUDACQUISITIONDATE_UTC | CLOUDACQUISITIONDATE_UTC | System Calc | The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
N/A | Confirmed Compliance | Discharge Compliance | The number of patient records with a confirmed discharge divided by the number of patients with an actual discharge. This field is not intended for client report building. |
N/A | Confirmed Date Filter | Custom Calc | This is a legacy date filter that includes fewer options than the updated field. Please use 'Confirmed Date Filter Range V2' for new reports. |
N/A | Confirmed Date Filter Range V2 | Custom Calc | This is an updated date filter that includes an expanded array of preset date ranges to select using the 'Date Range' parameter. |
N/A | Confirmed Discharge Before 1:00 PM | Discharge Compliance | Returns the number of records where the confirmed discharge local date/time was before 1:00 PM. |
N/A | Confirmed Discharge Before 11:00 AM | Discharge Compliance | Returns the number of records where the confirmed discharge local date/time was before 11:00 AM. |
N/A | Confirmed Discharge Before 12:00 PM | Discharge Compliance | Returns the number of records where the confirmed discharge local date/time was before 12:00 PM. |
N/A | Confirmed Discharge Before 2:00 PM | Discharge Compliance | Returns the number of records where the confirmed discharge local date/time was before 2:00 PM. |
N/A | Confirmed Discharge Before 3:00 PM | Discharge Compliance | Returns the number of records where the confirmed discharge local date/time was before 3:00 PM. |
CONFIRMED_DISCHARGE_TIMESTAMP | Confirmed Discharge Timestamp | Root | The latest local date/time that the patient visit record was marked as confirmed discharge. |
N/A | Confirmed Discharge Timestamp No Time | Custom Calc | The latest local date that the patient visit record was marked as confirmed discharge. |
CONFIRMED_DISCHARGE_TO_DISCHARGE_TIME | Confirmed Discharge To Discharge Time | Root | The duration in minutes from the latest time the patient was put into a Confirmed Discharge status until actually being discharged. Calculation: Actual Discharge Timestamp minus Confirmed Discharge Timestamp. |
N/A | Confirmed Discharge To Discharge Time Minutes | Custom Calc | The duration in minutes from the latest time the patient was put into a Confirmed Discharge status until actually being discharged. Calculation: Actual Discharge Timestamp minus Confirmed Discharge Timestamp. |
N/A | Confirmed Discharges Count | Custom Calc | The number of patient visit records with a confirmed discharge time recorded. |
N/A | Confirmed to Actual Colors | Custom Calc | Checks to see if the Avg Confirmed Discharge to Discharge Time is less than 120 min. If it is less the output will be 'Green', otherwise it will be 'Red'. Assign this field to the color in Tableau to have dynamic colors. |
N/A | Confirmed Today | Discharge Compliance | The number of patient visit records where the confirmed discharge date time was recorded the same day that the patient was actually discharged. This field is not intended for client report building. |
CONFIRMED_DISCHARGE_TIMESTAMP_ENTERPRISE | CONFIRMED_DISCHARGE_TIMESTAMP_ENTERPRISE | Root | The latest enterprise date and time of day that the patient's status was set to Confirmed Discharge. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
CONFIRMED_DISCHARGE_TIMESTAMP_UTC | CONFIRMED_DISCHARGE_TIMESTAMP_UTC | Root | The latest UTC date and time of day that the patient's status was set to Confirmed Discharge. |
N/A | Count of Pending Discharges | Custom Calc | The number of records where the patient had a pending discharge date/time recorded. |
N/A | COVID Attributes | Custom Calc | A field that evaluates patient attributes for specific values. This field is not intended for client report building. |
N/A | COVID Attributes Label | Custom Calc | A field that evaluates patient attributes for specific values. This field is not intended for client report building. |
CREATEDDATE | Createddate | Root | Created Date in Local Time zone for when the record was entered. |
CREATEDDATE_ENTERPRISE | Createddate Enterprise | System Calc | Created Date in 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 | Createddate Utc | System Calc | Created Date in UTC Time zone for when the record was entered. |
CURRENT_BED_ADT_ID | CURRENT_BED_ADT_ID | Root | The bed ADT ID of the latest current location recorded for the patient. |
CURRENT_CAMPUS | CURRENT_CAMPUS | Root | The campus name associated with the patient's latest current location. |
CURRENT_CAMPUS_ID | 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 | CURRENT_CUSTOMER_FACILITY_ID | Root | The campus account ID value set in the campus settings associated with the patient's latest current location. |
CURRENT_DISCIPLINE | CURRENT_DISCIPLINE | Root | The discipline name associated with the patient's latest current location. |
CURRENT_ENTERPRISE | CURRENT_ENTERPRISE | Root | The enterprise name associated with the patient's latest current location. |
CURRENT_FACILITY_ADT_ID | 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_LOCATION | CURRENT_LOCATION | Root | The location name for the latest current location associated with the patient vist record. |
CURRENT_LOCATION_ID | CURRENT_LOCATION_ID | System Calc | The location ID for the latest current location associated with the patient visit record. This field is not intended for client report building. |
CURRENT_NURSESTATION_ADT_ID | 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 | CURRENT_ROOM_ADT_ID | Root | The room ADT ID of the latest current location recorded for the patient. |
CURRENT_UNIT | CURRENT_UNIT | Root | The unit name of the unit associated with the patient's most recent current location. |
CURRENT_UNIT_CATEGORY | CURRENT_UNIT_CATEGORY | Root | The unit category name of the unit associated with the patient's most recent current location. |
CURRENT_UNIT_CATEGORY_CODE | CURRENT_UNIT_CATEGORY_CODE | System Calc | This field is not intended for client report building. |
CUSTOMER_FACILITY_ID | CUSTOMER_FACILITY_ID | Root | The campus account ID value set in the campus settings for the campus the patient record was created in. |
DATEPARTITION | Datepartition | System Calc | Non-strict dynamic partition column. This field is not intended for client report building. |
DISCHARGE_SOURCE | 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 | 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 discharge location through the IVR. DischargeByOrchestrate - Discharges where the patient was discharged through the CWS application. DischargeByUI - Discharges where discharge was caused by some action in the browser based user interface. DischargeByMobileBT - Discharges where the source was through EVS. DischargeByMobileTT - Discharges where the patient was transported to a discharge location using the mobile application. |
DISCHARGE_SOURCE_PRODUCT_NAME | DISCHARGE_SOURCE_PRODUCT_NAME | Root | The discharge source product for each patient visit record: DischargeByADT, DischargeByBT, DischargeByTT, DischargeByOrchestrate, DischargeByTT, DischargeByUI. |
DISCIPLINE | Discipline | Root | The discipline associate with the unit the patient's latest home location is in. |
ENTERPRISE | Enterprise | Root | The name of the collection of campuses that the patient visit record was created in. |
N/A | Enterprise Confirmed Compliance | Custom Calc | The number of patient visit records with a confirmed discharge date time recorded divided by the number of action discharge date/times. |
N/A | Enterprise Pending Compliance | Custom Calc | The number of patient visit records with a pending discharge date time recorded divided by the number of action discharge date/times. |
EVENT_TIMESTAMP | Event Timestamp | System Calc | This field is not intended for client report building. |
EVENT_TIMESTAMP_ENTERPRISE | EVENT_TIMESTAMP_ENTERPRISE | System Calc | This field is not intended for client report building. |
EVENT_TIMESTAMP_UTC | EVENT_TIMESTAMP_UTC | System Calc | This field is not intended for client report building. |
EXPECTED_ADMIT_TIMESTAMP | EXPECTED_ADMIT_TIMESTAMP | Root | The latest expected admit date in local time for the patient visit record. |
EXPECTED_ADMIT_TIMESTAMP_ENTERPRISE | 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 | EXPECTED_ADMIT_TIMESTAMP_UTC | Root | The latest expected admit date in UTC time for the patient visit record. |
EXPECTED_DISCHARGE_TIMESTAMP | Expected Discharge Timestamp | Root | The latest projected discharge date/time in local time for the patient visit record. |
EXPECTED_DISCHARGE_TIMESTAMP_ENTERPRISE | 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 | EXPECTED_DISCHARGE_TIMESTAMP_UTC | Root | The latest projected discharge date/time in UTC time for the patient visit record. |
FACILITY_ADT_ID | 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. |
N/A | Gender Bar Chart | Custom Calc | Used to find the number of cases where the patient's gender is Female. If not Female then remainder are Male. |
N/A | Help | Custom Calc | A field used by standard content to create a help link. This field is not intended for client report building. |
HOSPITAL_SERVICE | 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 | INSTANCEID | System Calc | This field is not intended for client report building. |
IS_EVER_ADMITTED | Is Ever Admitted | Root | Indicates if the patient was ever admitted or not. |
IS_INHOUSE_ON_DISCHARGE | Is InHouse On Discharge | Root | Indicates that the patient was admitted to the facility prior to discharge. |
ISOLATION_TYPE | Isolation Type | Root | The code indicating the type of isolation that applies to the patient, such as Airborne, Droplet, Contact. |
LASTMODDATE | 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 | Lastmoddate Enterprise | System Calc | The latest date/time in 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 updates 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 | 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 updates to other fields related to the patient table. (Physician, Placement information, etc). |
LATEST_LASTMODDATE_ENTERPRISE | 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 | 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 | 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 | LOCATION | Root | The latest home location name set for the patient visit record. |
LOCATION_ID | LOCATION_ID | Root | The latest home location ID set for the patient visit record. This field is not intended for client report building. |
N/A | Number of Records | Root | The number of records in the data set. Each row in the data set = 1. |
NURSESTATION_ADT_ID | 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 locaiton, it will be derieved from the unit settings. |
OBSERVATION_END_TIMESTAMP | Observation End Timestamp | Root | The latest observation end timestamp in local time. |
OBSERVATION_END_TIMESTAMP_ENTERPRISE | 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 | OBSERVATION_END_TIMESTAMP_UTC | Root | The latest observation end timestamp in UTC time. |
OBSERVATION_START_TIMESTAMP | Observation Start Timestamp | Root | The latest observation start timestamp in local time. |
OBSERVATION_START_TIMESTAMP_ENTERPRISE | 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 | OBSERVATION_START_TIMESTAMP_UTC | Root | The latest observation start timestamp in UTC time. |
PATIENT_ATTRIBUTE_CATEGORIES | Patient Attribute Categories | Root | The active patient attribute categories of the patient attributes associated with the patient visit record. As attributes are removed from the patient record, the category associated with the attribute will also be removed from this field. Values are seperated by a semicolon. |
PATIENT_ATTRIBUTES | 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. Values are seperated by a semicolon. |
PATIENT_ATTRIBUTES_WITH_CATEGORY | Patient Attributes with Category | Root | The active patient attribute categories AND the attribute associated with the patient visit record. As attributes are removed from the patient record, the category associated with the attribute will also be removed from this field. Values are separated by a semicolon. The association between category and attribute is marked with '>>'. i.e. Category Name >> Attribute. |
PATIENT_DIAGNOSIS | Patient Diagnosis | Root | The latest admit diagnosis text associated with the patient visit record. |
PATIENT_DOB | Patient Dob | System Calc | Patient DOB in a string format. This field is not intended for client report building |
N/A | Patient Dob - Split 2 | Custom Calc | Split of the Patient DOB field. This field is not intended for client report building |
N/A | Patient Dob - Split 2 - Split 1 | Custom Calc | Split of the Patient DOB field. This field is not intended for client report building |
PATIENT_DOB_TIMESTAMP | Patient DOB Timestamp | Root | The local date/time of the patient's date of birth. |
PATIENT_DOB_TIMESTAMP_ENTERPRISE | 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 | PATIENT_DOB_TIMESTAMP_UTC | Root | The UTC date/time of the patient's date of birth. |
PATIENT_FIRSTNAME | Patient Firstname | Root | The first name of the person receiving medical treatment. |
PATIENT_GENDER | Patient Gender | Root | The gender set in the patient visit record. |
PATIENT_GENDER_CODE | 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 | Patient Lastname | Root | The last name of the person receiving medical treatment. |
PATIENT_LEVEL_OF_CARE | Patient Level Of Care | Root | The degree of care that the patient requires, such as critical, acute, intermediate. |
PATIENT_MRN | Patient Mrn | Root | The medical record number for person receiving medical treatment. |
PATIENT_STATUS_TYPE | 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 | 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 | PATIENT_TYPE | Root | The patient type as set in the patient's record in Capacity IQ®. |
PATIENT_VISIT_ID | 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 | Patient Visit Number | Root | The patient's External ID (ADT). |
N/A | Pending Compliance | Discharge Compliance | The number of patient visit records with a pending discharge timestamp recorded divided by the number of patient visit records with an actual discharge timestamp recorded. This will give the percentage of patients who had pending discharge set. |
N/A | Pending Date Filter | Custom Calc | This is a legacy date filter that includes fewer options than the updated field. Please use 'Confirmed Date Filter Range V2' for new reports. |
N/A | Pending Date Filter Range V2 | Custom Calc | This is an updated date filter that includes an expanded array of preset date ranges to select using the 'Date Range' parameter. |
N/A | Pending Discharge Before 1:00 PM | Discharge Compliance | Returns the number of records where the pending discharge local date/time was before 1:00 PM. |
N/A | Pending Discharge Before 11:00 AM | Discharge Compliance | Returns the number of records where the pending discharge local date/time was before 11:00 AM. |
N/A | Pending Discharge Before 12:00 PM | Discharge Compliance | Returns the number of records where the pending discharge local date/time was before 12:00 PM. |
N/A | Pending Discharge Before 2:00 PM | Discharge Compliance | Returns the number of records where the pending discharge local date/time was before 2:00 PM. |
N/A | Pending Discharge Before 3:00 PM | Discharge Compliance | Returns the number of records where the pending discharge local date/time was before 3:00 PM. |
PENDING_DISCHARGE_TIMESTAMP | Pending Discharge Timestamp | Root | The latest local date and time of day that the patient's status was set to Pending Discharge. |
N/A | Pending Discharge Timestamp No Time | Custom Calc | The latest local date that the patient's status was set to Pending Discharge. |
PENDING_DISCHARGE_TO_CONFIRMED_DISCHARGE_TIME | Pending Discharge To Confirmed Discharge Time | Root | The duration in minutes from the latest time the patient was in a status of Pending Discharge status until the latest time their status was set to Confirmed Discharge status. Calculation: Confirmed Discharge Timestamp minus Pending Discharge Timestamp. |
Pending Discharge To Discharge Time | 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. |
N/A | Pending Today | Discharge Compliance | The number of records where the patient was actually discharged the same day that they were set to pending discharge. |
PENDING_DISCHARGE_TIMESTAMP_UTC | 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_TIMESTAMP_ENTERPRISE | 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. |
N/A | Placeholder | System Calc | This field is not intended for client report building. |
ROOM_ADT_ID | ROOM_ADT_ID | Root | The room ADT ID of the latest home location recorded for the patient. |
Location IQ®_TAG_ID | Location IQ® Tag ID | Root | The latest Location IQ® TAG ID associated with the patient visit record. This is only present if Capacity IQ® is integrated with Location IQ®. |
SPEC_BED_ADT_ID | SPEC_BED_ADT_ID | Root | The bed ADT ID of the latest specialty location the patient currently occupies. |
SPEC_FACILITY_ADT_ID | SPEC_FACILITY_ADT_ID | Root | The facility ADT ID of the latest specialty location the patient currently occupies. |
SPEC_LOCATION | SPEC_LOCATION | Root | The name of the latest specialty location the patient currently occupies. |
SPEC_LOCATION_CAMPUS | SPEC_LOCATION_CAMPUS | Root | The name of the campus associated with the latest specialty location the patient currently occupies. |
SPEC_LOCATION_CAMPUS_ID | 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_CUSTOMER_FACILITY_ID | SPEC_LOCATION_CUSTOMER_FACILITY_ID | Root | The account ID of the campus associated with the latest specialty location the patient currently occupies. |
SPEC_LOCATION_DISCIPLINE | SPEC_LOCATION_DISCIPLINE | Root | The discipline associated with the patient's current specialty location |
SPEC_LOCATION_ENTERPRISE | 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 | 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 | SPEC_LOCATION_UNIT | Root | The name of the unit associated with the latest specialty location the patient currently occupies. |
SPEC_LOCATION_UNIT_CATEGORY | 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 | 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 | SPEC_NURSESTATION_ADT_ID | Root | The nursing station ADT ID of the latest specialty location the patient currently occupies. |
SPEC_ROOM_ADT_ID | SPEC_ROOM_ADT_ID | Root | The room ADT ID of the latest specialty location the patient currently occupies. |
TENANTID | Tenantid | System Calc | System calculation that is used in data partitioning. Not meant for client reporting. |
N/A | Tenantid Name | System Calc | System calculation that is used in data partitioning. Not meant for client reporting. |
N/A | Time Format Confirmed to Actual Discharge | Custom Calc | Outputs the time between the Confirmed and Actual Discharge timestamps as the number of minutes and number of seconds separated by a colon. Example: Min:Sec |
N/A | Time Format Confirmed to Actual Discharge Minutes | Custom Calc | Outputs the time between the Confirmed and Actual Discharge timestamps as the number of minutes and number of seconds not separated Example: MinSec |
N/A | Today | Custom Calc | Used in relative date filters |
N/A | Unit | Root | The unit that includes the latest home location which the patient physically occupied. |
N/A | 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. |
N/A | Unit Category (group) | Custom Calc | A custom grouping created for specific standard content. This field is not intended for client report building. |
N/A | Unit Category Code | System Calc | This field is not intended for customer report building. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in Snowflake Data Warehouse in UTC format. |
UNIT_CATEGORY_CODE | UNIT_CATEGORY_CODE | System Calc | This field is not intended for customer report building. |
N/A | Yesterday | Custom Calc | The date/time of yesterday relative to the current date. |