Data Points - Fast Lane

This data has a latency of 5 minutes and includes data for only a 24-hour period. These data sources are used for Command Center Dashboards to get the most up-to-date data.

The data points in the table below can be filtered by selecting from the drop-down lists or by searching for text in the entire table. The columns can also be sorted.

The following list describes each of the available Folder options:

Root - These are fields that come directly from the data source.
Custom Calculations - These are calculations that were built in Tableau for the purpose of standard content usage. They could be fields for filtering, coloring thresholds, or extrapolating specific data from a field.
System Calculations - These are fields in the database that are used for data processing and monitoring. They are not intended for client reporting.

Data Source	Tableau Data Source Field	Folder	Description
Data Source	Tableau Data Source Field	Folder
Census Current	Active Incoming Preadmit Assign	Root	The count of activated bed requests with a status of Assign (i.e., a bed is assigned). Calculation: The total number of active bed requests that have beds assigned to the patient and are from the Capacity IQ® PreAdmit application
Census Current	Active Incoming Pre Admit Request	Root	The count of activated bed requests with a target unit selected.
Census Current	Active Incoming Transfer Assign	Root	The count of activated in-house transfer requests with a status of Assign (i.e., a bed is assigned).
Census Current	Active Incoming Transfer Request	Root	The count of activated in-house transfer requests with a target unit selected.
Census Current	Available Beds	Root	This field includes beds marked as "Is Permanent" and excludes beds that are Blocked, Occupied, or Dirty.
Census Current	Assignment Priority Bed	Root	The priority of a bed as assigned by users.
Census Current	Campus	Root	The name of a collection of buildings in the enterprise that includes the occupied bed.
Census Current	Campus City	Root	City of campus location.
Census Current	Campus Date Time	Root	The date and time of day when the event was captured.
Census Current	Campus Date Time Enterprise	Root	The date and time of day the event was captured in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Census Current	Campus Date Time UTC	Root	The date and time of day the event was captured UTC.
Census Current	Campus State	Root	The state in which the campus is located.
Census Current	Campus State Abbreviation	Root	The postal abbreviation for the state in which the campus is located.
Census Current	Campus Street	Root	Street address of the campus location.
Census Current	Campus Zip	Root	ZIP code of campus location.
Census Current	Clean	Root	The number of beds with a status of Clean.
Census Current	Confirmed Discharge	Root	The number of beds with a status of Confirmed Discharge.
Census Current	CONFIRMED_DISCHARGE_TODAY	Root	The number of patients that are confirmed to discharge having Projected Discharge date in the Capacity IQ® application set to prior to the end of the day Today.
Census Current	COVID-19 Confirmed	Root	Number of patients in house (not discharged) diagnosed positive for COVID-19; based on Patient Attribute of “COV%19” or “COV%19%+” or “COV%19 Pos%” or “COV%19 C%” (Pos% for variants of ‘positive’ and C% for variants of ‘confirmed’).
Census Current	COVID-19 Negative	Root	The number of patients that have tested negative for COVID-19 in the facility.
Census Current	COVID-19 PUI	Root	Number of patients in-house (not discharged) under investigation for COVID-19 based on Patient Attribute of “COV%19 PUI” or “COV%19 S%” or “COV%19 Pen%” (S% for variants of ‘Suspected' or ‘Screening’ and Pen% for variants of ‘Pending’).
Census Current	Dirty	Root	The number of beds with a status of Dirty.
Census Current	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 include the occupied bed.
Census Current	Discipline ID	Root	The unique identifier assigned to different disciplines in the facility.
Census Current	Enterprise	Root	The name of a collection of campuses that includes the occupied bed.
Census Current	Inactive Incoming Pre Admit Assign	Root	The number of inactive bed requests with a status of Assign originating in the Capacity IQ® PreAdmit application.
Census Current	Inactive Incoming Pre Admit Request	Root	The number of inactive bed requests originating in the Capacity IQ® PreAdmit application.
Census Current	Inactive Incoming Transfer Request	Root	The number of inactive bed requests originating in the Transfer IQ® application.
Census Current	Inactive Incoming Transfer Assign	Root	The number of inactive bed requests with a status of Assign originating in the Transfer IQ® application.
Census Current	INCOMING_PREADMIT_ASSIGN_TODAY	Root	The projected number of new patients with a bed assigned to the unit having the Bed Requested Date in the Capacity IQ® application set to now till the end of the day Today.
Census Current	INCOMING_PREADMIT_REQUEST_TODAY	Root	The projected number of new patients targeted to the unit having the Bed Requested Date in the Capacity IQ® application set to now till the end of the day Today.
Census Current	INCOMING_TRANSFER_ASSIGN_TODAY	Root	The projected number of internal transfer patients with a bed assigned to the unit having the Bed Requested Date in the Capacity IQ® application set to now till the end of the day Today.
Census Current	INCOMING_TRANSFER_REQUEST_TODAY	Root	The projected number of internal transfer patients targeted to the unit having the Bed Requested Date in the Capacity IQ® application set to now till the end of the day Today.
Census Current	In Progress	Root	The number of beds with a status of In Progress.
Census Current	Lastmoddate	Root	The date of the most recent update to the transfer case in local time zone.
Census Current	Lastmoddate Enterprise	Root	The date of the most recent update to the transfer case in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Census Current	Lastmoddate UTC	Root	The date of the most recent update to the transfer case in UTC.
Census Current	Near Nurse Clean Beds	Root	Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Near Nurse%” that are in Clean status.
Census Current	Near Nurse Occupied Beds	Root	Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Near Nurse%” that are in Occupied status.
Census Current	Near Nurse Other Beds	Root	Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Near Nurse%” excluding beds that are Occupied or Clean.
Census Current	Negative Pressure Clean Beds	Root	Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Negative Air%” or “Negative Pres%” that are in Clean status.
Census Current	Negative Pressure Occupied Beds	Root	Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Negative Air%” or “Negative Pres%” that are in Occupied status.
Census Current	Negative Pressure Other Beds	Root	Number of beds (permanent and non-permanent marked for inclusion in census) with the Bed Attribute “Negative Air%” or “Negative Pres%” excluding beds that are Occupied or Clean.
Census Current	Occupied Non-permanent	Root	The number of Non-Permanent beds with a status of Occupied.
Census Current	Occupied Permanent	Root	The number of permanent beds that are occupied.
Census Current	Outgoing Assigned	Root	Count of outgoing requests that have been assigned.
Census Current	OUTGOING_ASSIGNED_TODAY	Root	The projected number of internal transfer patients with a bed assigned in another unit having the Bed Requested Date in the Capacity IQ® application set to prior to the end of the day Today.
Census Current	Outgoing Unassigned	Root	Count of outgoing requests that have not been assigned.
Census Current	OUTGOING_UNASSIGNED_TODAY	Root	The projected number of internal transfer patients targeted to another unit having the Bed Requested Date in the Capacity IQ® application set to prior to the end of the day Today.
Census Current	Pending Discharge	Root	The number of beds with a status of Pending Discharge. Calculation: The total number of the Pending Discharge beds.
Census Current	PENDING_DISCHARGE_TODAY	Root	The number of patients that are pending to discharge having Projected Discharge date in the Capacity IQ® application set to prior to the end of the day Today.
Census Current	Permanent Beds	Root	The number of Permanent beds.
Census Current	Priority Clean Next	Root	The number of beds with a cleaning priority of Clean Next.
Census Current	Priority Dirty	Root	The number of beds with a cleaning priority of Dirty.
Census Current	Priority Stat	Root	The number of beds with a cleaning priority of Stat.
Census Current	Priority Udef8	Root	The number of beds with a cleaning priority of Udef8.
Census Current	Priority Udef9	Root	The number of beds with a cleaning priority of Udef9.
Census Current	Requested	Root	The number of beds that have a status of Requested.
Census Current	Staffed Bed Count	Root	The number of staffed beds with any status.
Census Current	Suspended	Root	The number of beds with a status of Suspend.
Census Current	Tenant ID	Root	Tenant GUID - Non-Strict Dynamic Partition Column.
Census Current	Total Blocked	Root	The number of beds with a status of Blocked.
Census Current	Total Incoming Placement Count	Root	Count of incoming placement requests.
Census Current	Total Occupied	Root	Count of occupied beds.
Census Current	Total Outgoing Placement Count	Root	In the unit's latest hourly snapshot, the number of requests to transfer patients to another unit. Calculation: The total number of requests to transfer patients to another unit.
Census Current	Total Virtual Blocked	Root	Count of virtual blocked beds.
Census Current	Unit	Root	The target unit selected for activated incoming Pre Admit and Transfer requests.
Census Current	Unit Abbreviation	Root	The shortened name of the target unit selected for activated incoming Pre Admit and Transfer requests.
Census Current	Unit Category Name	Root	The grouping of units that is associated with the target unit selected for activated incoming Pre Admit and Transfer requests.
Census Current	Unit Category Name (group)	Root	The grouping of unit groups that are associated with the target unit selected for activated incoming Pre Admit and Transfer requests.
Census Current	Unit ID	Root	The unique identifier assigned to a unit.
Census Current	Ventilator Intervention	Root	Number of patients in house (not discharged) with Patient Attribute “Vent%”.
Current Bed Status	Acquisitiondate	Root	The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building.
Current Bed Status	Acquisitiondate UTC	Root	The first step in the data ingestion process in UTC format. Used internally for latency calculations. This field is not intended for client report building.
Current Bed Status	Action	Root	The status change value associated with location status changes (Clean, Occupied, Blocked, etc)
Current Bed Status	BED_ADT_ID	System Calc	The bed ADT ID of the location associated with the status change.
Current Bed Status	Bed Size Name	Root	The bed size assigned to the location in the bed settings.
Current Bed Status	Bt Display Status	Root	The Capacity IQ® EVS display status of the location. If the location is in a status associated with a bed cleaning job, this will be the status of the bed cleaning job.
Current Bed Status	Bt Display Status Id	System Calc	A unique identifier associated with the display status. This field is not intended for client report building.
Current Bed Status	BT_DISPLAY_STATUS_TYPE_CODE	System Calc	System calculation used for localization filtering. Displays the display status types (that do not change with language). This field is not intended for client report building.
Current Bed Status	Building	Root	The building associated with the location which had a status change.
Current Bed Status	Building Id	Root	The database identifier for the building associated with the location. Not Intended for client report building
Current Bed Status	Campus	Root	The campus associated with the location having a status change.
Current Bed Status	Campus ID	Root	A unique identifier associated with campus. This field is not intended for client report building.
Current Bed Status	Cloudacquisitiondate	System Calc	The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building.
Current Bed Status	Cloudacquisitiondate UTC	System Calc	The second step in the data ingestion process. The field is is un UTC time. Used internally for latency calculations. This field is not intended for client report building.
Current Bed Status	Createddate	Root	Created Date in Local Time zone for when the record was entered.
Current Bed Status	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.
Current Bed Status	Createddate UTC	Root	Created Date in UTC Time zone for when the record was entered.
Current Bed Status	CUSTOMER_FACILITY_ID	Root	The campus account ID value set in the campus settings for the campus associated with each unit.
Current Bed Status	DATEPARTITION	System Calc	System calculation used internally to partition the data for efficient processing. This field is not intended for client report building.
Current Bed Status	Enterprise	Root	The name of a collection of campuses.
Current Bed Status	Enterprise Id	Root	A unique identifier associated with the enterprise. This field is not intended for client report building.
Current Bed Status	FACILITY_ADT_ID	System Calc	The facility ADT ID of the location associated with the status change. If this value is NULL in the location settings, it is derived from the campus settings.
Current Bed Status	Floor	Root	The floor associated with the location which had a status change.
Current Bed Status	Floor Id	System Calc	A unique identifier associated with the floor. This field is not intended for client report building.
Current Bed Status	INSTANCEID	System Calc	System calculation used for data partitioning. It is not intended for client reporting.
Current Bed Status	Isallowbedstacking	Root	Indicates if the location allows multiple occupying patients at the same time.
Current Bed Status	Isbtlocation	Root	Indicates if the location has been assigned an EVS zone.
Current Bed Status	Iscountedaspermanent	Root	Indicates if the location is counted as a permanent bed.
Current Bed Status	Isevsservice	Root	Indicates if the location is has the EVS service setting enabled and is has bed cleaning enabled.
Current Bed Status	Isholdingbed	Root	Indicates if the bed is a holding bed.
Current Bed Status	Ishygiene	Root	Indicates if a location needs to be included in a staff members hand hygiene index score.
Current Bed Status	Isincludedincensus	Root	Indicates if the location bed is included in census counts.
Current Bed Status	Isisolated	Root	If the location is configured with 'Is Isolated Area' enabled, then True, otherwise false. This setting is only available with Location IQ® and Patient Tracking Enabled.
Current Bed Status	Isshownonbedboard	Root	Indicates if the location bed is shown on the electronic BedBoard.
Current Bed Status	Istransportlocation	Root	Indicates if the location is assigned a transport zone.
Current Bed Status	Lastmoddate	Root	The date of the most recent update to the location status change in local time zone. Use the CreatedDate for reporting purposes.
Current Bed Status	LASTMODDATE_ENTERPRISE	Root	The Date in enterprise time for when the record was last modified. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Bed Status	Lastmoddate UTC	Root	The date of the most recent update to the location status change in UTC. Use the CreatedDate_UTC for reporting purposes.
Current Bed Status	LATEST_LASTMODDATE_ENTERPRISE	Root	The date of the most recent update to the location status change in the enterprise time zone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Bed Status	LATEST_LASTMODDATE_UTC	Root	The date of the most recent update to the location status change in UTC. Use the CreatedDate_UTC for reporting purposes.
Current Bed Status	Location	Root	The location associated with the status change.
Current Bed Status	Location Id	System Calc	A unique identifier associated with the location. This field is not intended for client report building.
Current Bed Status	LOCATION_STATUS	Root	The current action (status) of a BedTracking Job or the physical bed's location status.
Current Bed Status	Location Status Id	System Calc	A unique identifier associated with the location status. This field is not intended for client report building.
Current Bed Status	LOCATION_STATUS_TYPE_CODE	System Calc	The code for a current action (status) of a BedTracking Job or the physical bed's location status. This field is not intended for client reporting.
Current Bed Status	Location Type	Root	The type of bed location such as Admit, Discharge, Exam/Treatment Home, Specialty, or Other.
Current Bed Status	LOCATION_TYPE_CODE	System Calc	The code of bed location such as Admit, Discharge, Exam/Treatment Home, Specialty, or Other. This field is not intended for client reporting.
Current Bed Status	NURSESTATION_ADT_ID	System Calc	The Nursing Station ADT ID of the location. If the value is empty in the location, it will be derieved from the unit settings.
Current Bed Status	Reasoncode Id	System Calc	A unique identifier associated with the reason code associated with the status change. This field is not intended for client report building.
Current Bed Status	Room	Root	The room associated with the location.
Current Bed Status	ROOM_ADT_ID	System Calc	The room ADT ID of the location associated with the status change.
Current Bed Status	Room Id	System Calc	A unique identifier associated with the room associated with the status change. This field is not intended for client report building.
Current Bed Status	Rownum	Root	The number of records in the data set. Each row equals 1.
Current Bed Status	Status Date Timestamp	Root	Displays the current status start time and date.
Current Bed Status	STATUS_DATE_TIMESTAMP_ENTERPRISE	Root	Displays the current status start time and date in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Bed Status	Status Date Timestamp UTC	Root	Displays the current status start time and date in UTC.
Current Bed Status	Status Reason	Root	Displays the reason for a BedTracking Job, or physical bed's current action (status).
Current Bed Status	Tenantid	System Calc	System calculation that is used in data partitioning. Not meant for client reporting.
Current Bed Status	Unit	Root	The unit associated with the location which had a status change.
Current Bed Status	Unit Category	Root	The unit category associated with the unit that the location is in.
Current Bed Status	UNIT_CATEGORY_TYPE_CODE	System Calc	The unique identifier for a group of locations and rooms that are all on one floor of a building.
Current Bed Status	Unit Discipline	Root	The discipline associated with the unit that the location is in.
Current Bed Status	Unit Id	System Calc	A unique identifier associated with the unit. This field is not intended for client report building.
Current Bed Status	Warehouseacquisitiondate Utc	System Calc	The latest timestamp that a record is inserted in Snowflake Data Warehouse in UTC format.
Current BedTracking Employee Status	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.
Current BedTracking Employee Status	BASE_CAMPUS	Root	The campus that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool.
Current BedTracking Employee Status	BASE_CAMPUS_ADT_ID	System Calc	The ADT ID of the campus associated with user based on their base location.
Current BedTracking Employee Status	BASE_CAMPUS_ID	System Calc	A system identifier for the base campus of the employee based on their base location, not visible to users of the application.
Current BedTracking Employee Status	BASE_CUSTOMER_FACILITY_ID	Root	A unique identifier for a given campus that is defined in the Capacity IQ® campus settings for use with Transfer IQ® facility IDs—used more widely in DWC. This is the campus associated with the user's base location.
Current BedTracking Employee Status	BASE_LOCATION	Root	The bed location that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool.
Current BedTracking Employee Status	BASE_LOCATION_ADT_ID	System Calc	The ADT ID of the location associated with user based on their base location.
Current BedTracking Employee Status	BASE_LOCATION_ID	System Calc	A system identifier for the base location of the employee, not visible to users of the application.
Current BedTracking Employee Status	BASE_ROOM_ADT_ID	System Calc	The ADT ID of the room associated with user based on their base location.
Current BedTracking Employee Status	BASE_UNIT	Root	The unit that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool.
Current BedTracking Employee Status	BASE_UNIT_ADT_ID	System Calc	The ADT ID of the unit that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool.
Current BedTracking Employee Status	BASE_UNIT_DISCIPLINE	Root	The name of the discipline that is associated with the unit that is associated with the user's base location. This a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn.
Current BedTracking Employee Status	BASE_UNIT_DISCIPLINE_ID	System Calc	The IS of the discipline that is associated with the unit that is associated with the user's base location. This a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn.
Current BedTracking Employee Status	BASE_UNIT_ID	System Calc	A system identifier for the base unit of the employee, not visible to users of the application.
Current BedTracking Employee Status	CLOUDACQUISITIONDATE_UTC	System Calc	The second step in the data ingestion process that is used internally for latency calculations. This field is not intended for client report building.
Current BedTracking Employee Status	EMPLOYEE_LOGIN_ID	System Calc	The unique username associated with the employee.
Current BedTracking Employee Status	EMPLOYEE_NAME	Root	Full name (in the format of FN MI LN) of the employee
Current BedTracking Employee Status	EMPLOYEE_STATUS_TIMESTAMP	Root	The latest date and local time of day when the employee status is updated
Current BedTracking Employee Status	EMPLOYEE_STATUS_TIMESTAMP_ENTERPRISE	Root	The latest enterprise date and time of day when the employee status is updated. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current BedTracking Employee Status	EMPLOYEE_STATUS_TIMESTAMP_UTC	Root	The latest date and UTC time of day when the employee status is updated
Current BedTracking Employee Status	EMPLOYEE_STATUS_TYPE	Root	The status of the employee. Values can include: In Progress, Available, Break, Lunch, Logged In
Current BedTracking Employee Status	EMPLOYEE_STATUS_TYPE_CODE	System Calc	System calculation used for localization filtering that displays the Employee Status Type. This field is not intended for client report building.
Current BedTracking Employee Status	EMPLOYEE_STATUS_TYPE_ID	System Calc	A system identifier for the Employee Status Type not visible to users of the application.
Current BedTracking Employee Status	EMPLOYEE_USER_ID	System Calc	The id of the user. This field is not intended for client report building.
Current BedTracking Employee Status	ENTERPRISE	Root	The name of a collection of campuses.
Current BedTracking Employee Status	INSTANCEID	System Calc	System calculation used for data partitioning. This field is not intended for client reporting.
Current BedTracking Employee Status	LASTMODDATE	System Calc	System calculation that displays the most recent update to the application database in local time. This field is not intended for client reporting.
Current BedTracking Employee Status	LASTMODDATE_ENTERPRISE	System Calc	System calculation that displays the most recent update to the application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This field is not intended for client reporting.
Current BedTracking Employee Status	LASTMODDATE_UTC	System Calc	System calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting.
Current BedTracking Employee Status	LATEST_LASTMODDATE	System Calc	System calculation that displays the most recent update to the application database in local time. This field is not intended for client reporting.
Current BedTracking Employee Status	LATEST_LASTMODDATE_ENTERPRISE	System Calc	System calculation that displays the most recent update to the application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This field is not intended for client reporting.
Current BedTracking Employee Status	LATEST_LASTMODDATE_UTC	System Calc	System calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting.
Current BedTracking Employee Status	TENANTID	System Calc	The unique identifier associated with the tenant. This field is not intended for client reporting.
Current BedTracking Employee Status	WAREHOUSEACQUISITIONDATE_UTC	System Calc	The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format.
Current Care Progression Indicators Detail	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.
Current Care Progression Indicators Detail	ADMIT_SOURCE	Root	The latest admit source recorded in the patient visit record.
Current Care Progression Indicators Detail	CAMPUS_ID	System Calc	The unique identifier of the campus where the patient was occupied. This field is not intended for client reporting.
Current Care Progression Indicators Detail	CAMPUS_NAME	Root	The name of the campus in which the patient was occupied.
Current Care Progression Indicators Detail	CARE_TYPE_NAME	Root	The name of the campus in which the patient was occupied.
Current Care Progression Indicators Detail	CARE_TYPE_NOTES	Root	The name of the Care Type as defined in Care Progression Group setup.
Current Care Progression Indicators Detail	CARE_TYPE_COMPLETED_DATE	Root	The latest date/time the care type was marked as complete in local time.
Current Care Progression Indicators Detail	CARE_TYPE_COMPLETED_DATE_ENTERPRISE	Root	The latest date/time the care type was marked as completed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	CARE_TYPE_COMPLETED_DATE_UTC	Root	The latest date/time the care type was marked as complete in UTC time.
Current Care Progression Indicators Detail	CARE_TYPE_COMPLETED_DATE_UTC	Root	The latest date/time the care type was marked as complete in UTC time.
Current Care Progression Indicators Detail	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.
Current Care Progression Indicators Detail	COMPLETED_BY_FIRSTNAME	Root	The first name of the user that completed the care type.
Current Care Progression Indicators Detail	COMPLETED_BY_LASTNAME	Root	The last name of the user that completed the care type.
Current Care Progression Indicators Detail	CPI_GROUP_ADT_ID	System Calc	The unique ADT identifier assigned to the care type in dictionary management that is used in EMR messages.
Current Care Progression Indicators Detail	CPI_GROUP_NAME	Root	The name of the care progression indicators group associated with the care types ordered for the patient.
Current Care Progression Indicators Detail	CPI_GROUP_STATUS_TYPE	Root	The latest status of a care type in the care progression group. This includes Ordered, In progress, and Completed.
Current Care Progression Indicators Detail	CREATEDDATE	Root	The local date time that the care type for the patient is created.
Current Care Progression Indicators Detail	CREATEDDATE_ENTERPRISE	Root	The date and time of when the care type of the patient was created in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	CREATEDDATE_UTC	Root	The date and time of when the care type of the patient was created in UTC timezone.
Current Care Progression Indicators Detail	CUSTOMER_FACILITY_ID	Root	A unique identifier for a given campus that is defined in the Capacity IQ® campus settings. Commonly used with the Data IQ® Warehouse Connector to allow joining against an external identifier in an enterprise data warehouse.
Current Care Progression Indicators Detail	DATEPARTITION	System Calc	System calculation used internally to partition the data for efficient processing.
Current Care Progression Indicators Detail	ENTITY_ELEMENT_ID	System Calc	The Database or Internal Record ID for a patient's visit associated with the care type. This field is not intended for client report building
Current Care Progression Indicators Detail	FIRST_COMPLETED_END	Root	The initial timestamp when the care type ended ‘Completed’ status, in local timezone.
Current Care Progression Indicators Detail	FIRST_COMPLETED_END_ENTERPRISE	Root	The initial timestamp when the care type ended ‘Completed’ status, in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	FIRST_COMPLETED_END_UTC	Root	The initial timestamp when the care type ended ‘Completed’ status, in UTC timezone.
Current Care Progression Indicators Detail	FIRST_COMPLETED_FIRST_NAME	Root	Displays the first name of the user who first completed the care type in the progression.
Current Care Progression Indicators Detail	FIRST_COMPLETED_LAST_NAME	Root	Displays last name of the user who first completed the care type in the progression.
Current Care Progression Indicators Detail	FIRST_COMPLETED_START	Root	The initial timestamp when the Care Type entered the 'Completed' status, displayed in the local timezone.
Current Care Progression Indicators Detail	FIRST_COMPLETED_START_ENTERPRISE	Root	The initial timestamp when the Care Type entered the 'Completed' status, displayed in the enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	FIRST_COMPLETED_START_UTC	Root	The initial timestamp when the Care Type entered the 'Completed' status, displayed in the UTC timezone.
Current Care Progression Indicators Detail	FIRST_COMPLETED_USER_LOGIN_ID	System Calc	The username of the user who first marked the care type as complete.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_END	Root	The initial timestamp when the Care Type ended the 'In Progress' status, displayed in the local timezone.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_END_ENTERPRISE	Root	The initial timestamp when the Care Type ended the 'In Progress' status, displayed in the enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_END_UTC	Root	The initial timestamp when the Care Type ended the 'In Progress' status, displayed in the UTC timezone.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_FIRST_NAME	Root	The first name of the user who initially moved the care type to ‘In Progress’ status.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_LAST_NAME	Root	The last name of the user who initially moved the care type to ‘In Progress’ status.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_START	Root	The initial timestamp when the Care Type entered the 'In Progress' status, displayed in the local timezone.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_START_ENTERPRISE	Root	The initial timestamp when the Care Type entered the 'In Progress' status, displayed in the enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_START_UTC	Root	The initial timestamp when the Care Type entered the 'In Progress' status, displayed in the UTC timezone.
Current Care Progression Indicators Detail	FIRST_INPROGRESS_USER_LOGIN_ID	System Calc	The username of the user who first marked the care type as ‘In Progress’.
Current Care Progression Indicators Detail	FIRST_ORDERED_END	Root	The initial timestamp when the Care Type ended the 'Ordered' status, displayed in the local timezone.
Current Care Progression Indicators Detail	FIRST_ORDERED_END_ENTERPRISE	Root	The initial timestamp when the Care Type ended the 'Ordered' status, displayed in the enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	FIRST_ORDERED_END_UTC	Root	The initial timestamp when the Care Type ended the 'Ordered' status, displayed in the UTC timezone.
Current Care Progression Indicators Detail	FIRST_ORDERED_FIRST_NAME	Root	The first name of the user who initially moved the care type to ‘Ordered’ status.
Current Care Progression Indicators Detail	FIRST_ORDERED_LAST_NAME	Root	The first name of the user who initially moved the care type to ‘Ordered’ status.
Current Care Progression Indicators Detail	FIRST_ORDERED_START	Root	The initial timestamp when the Care Type entered the 'Ordered' status, displayed in the local timezone.
Current Care Progression Indicators Detail	FIRST_ORDERED_START_ENTERPRISE	Root	The initial timestamp when the Care Type entered the 'Ordered' status, displayed in the enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	FIRST_ORDERED_START_UTC	Root	The initial timestamp when the Care Type entered the 'Ordered' status, displayed in the UTC timezone.
Current Care Progression Indicators Detail	FIRST_ORDERED_USER_LOGIN_ID	System Calc	The username of the user who first marked the care type as ‘Ordered’.
Current Care Progression Indicators Detail	GROUP_TOP_LEVEL_MILESTONE_ID	System Calc	The Database or Internal Record ID for a Care Progression Group associated with the care type. This field is not intended for client report building
Current Care Progression Indicators Detail	HOME_BED_ADT_ID	System Calc	The bed ADT ID value from the location settings associated with the patient's latest home bed location.
Current Care Progression Indicators Detail	HOME_FACILITY_ADT_ID	System Calc	The facility ADT ID value from the location settings associated with the patients latest home bed location.
Current Care Progression Indicators Detail	HOME_LOCATION	Root	Name of the patient's latest home location.
Current Care Progression Indicators Detail	HOME_LOCATION_ID	System Calc	The database identifier or internal record ID of the patient's latest home location. This is not intended for client report building.
Current Care Progression Indicators Detail	HOME_NURSESTATION_ADT_ID	System Calc	The nursing station (or unit) ADT ID value from the location settings associated with the patient's latest home bed location.
Current Care Progression Indicators Detail	HOME_ROOM_ADT_ID	System Calc	The room ADT ID value from the location settings associated with the patient's latest home bed location.
Current Care Progression Indicators Detail	HOSPITAL_SERVICE	Root	The latest hospital service recorded in the patient visit record. The type of treatment or surgery for the patient (e.g., Oncology, Obstetrics, Adolescent, or Cardiology) is called Hospital Service or Service Line.
Current Care Progression Indicators Detail	INSTANCEID	System Calc	Unique identifier of the Capacity IQ® instance used for data partitioning. It is not intended for client reporting.
Current Care Progression Indicators Detail	LAST_COMPLETED_END	Root	The latest timestamp when the Care Type ended the 'Completed' status, displayed in local timezone.
Current Care Progression Indicators Detail	LAST_COMPLETED_END_ENTERPRISE	Root	The latest timestamp when the Care Type ended the 'Completed' status, displayed in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	LAST_COMPLETED_END_UTC	Root	The latest timestamp when the Care Type ended the 'Completed' status, displayed in UTC timezone.
Current Care Progression Indicators Detail	LAST_COMPLETED_FIRST_NAME	Root	The first name of the user who recently moved the care type to ‘Completed’ status.
Current Care Progression Indicators Detail	LAST_COMPLETED_LAST_NAME	Root	The last name of the user who recently moved the care type to ‘Completed’ status.
Current Care Progression Indicators Detail	LAST_COMPLETED_START	Root	The latest timestamp when the Care Type entered the 'Completed' status, displayed in local timezone.
Current Care Progression Indicators Detail	LAST_COMPLETED_START_ENTERPRISE	Root	The latest timestamp when the Care Type entered the 'Completed' status, displayed in enterprise timezone.
Current Care Progression Indicators Detail	LAST_COMPLETED_START_UTC	Root	The latest timestamp when the Care Type entered the 'Completed' status, displayed in UTC timezone.
Current Care Progression Indicators Detail	LAST_COMPLETED_USER_LOGIN_ID	System Calc	The username of the user who recently marked the care type as ‘Completed'.
Current Care Progression Indicators Detail	LAST_DELAY_END	Root	The timestamp when the most recent delay of the Care Type ended, displayed in local timezone.
Current Care Progression Indicators Detail	LAST_DELAY_END_ENTERPRISE	Root	The timestamp when the most recent delay of the Care Type ended, displayed in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	LAST_DELAY_END_UTC	Root	The timestamp when the most recent delay of the Care Type ended, displayed in UTC timezone.
Current Care Progression Indicators Detail	LAST_DELAY_FIRST_NAME	Root	The first name of the user that most recently delayed the care type.
Current Care Progression Indicators Detail	LAST_DELAY_LAST_NAME	Root	The last name of the user that most recently delayed the care type.
Current Care Progression Indicators Detail	LAST_DELAY_START	Root	The timestamp when the most recent delay of the Care Type started, displayed in local timezone.
Current Care Progression Indicators Detail	LAST_DELAY_START_ENTERPRISE	Root	The timestamp when the most recent delay of the Care Type started, displayed in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	LAST_DELAY_START_UTC	Root	The timestamp when the most recent delay of the Care Type started, displayed in UTC timezone
Current Care Progression Indicators Detail	LAST_DELAY_USER_LOGIN_ID	System Calc	The username of the user that most recently delayed the Care Type.
Current Care Progression Indicators Detail	LAST_INPROGRESS_END	Root	The latest timestamp when the Care Type ended the 'In Progress' status, displayed in local timezone.
Current Care Progression Indicators Detail	LAST_INPROGRESS_END_ENTERPRISE	Root	The latest timestamp when the Care Type ended the 'In Progress' status, displayed in enterprise timezone.
Current Care Progression Indicators Detail	LAST_INPROGRESS_END_UTC	Root	The latest timestamp when the Care Type ended the 'In Progress' status, displayed in UTC timezone.
Current Care Progression Indicators Detail	LAST_INPROGRESS_FIRST_NAME	Root	The first name of the user who recently moved the care type to ‘In Progress’ status.
Current Care Progression Indicators Detail	LAST_INPROGRESS_LAST_NAME	Root	The last name of the user who recently moved the care type to ‘In Progress’ status.
Current Care Progression Indicators Detail	LAST_INPROGRESS_START	Root	The latest timestamp when the Care Type entered the 'In Progress' status, displayed in local timezone.
Current Care Progression Indicators Detail	LAST_INPROGRESS_START_ENTERPRISE	Root	The latest timestamp when the Care Type entered the 'In Progress' status, displayed in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	LAST_INPROGRESS_START_UTC	Root	The latest timestamp when the Care Type entered the 'In Progress' status, displayed in UTC timezone.
Current Care Progression Indicators Detail	LAST_INPROGRESS_USER_LOGIN_ID	System Calc	The username of the user that most recently moved the Care Type to ‘In Progress’ status.
Current Care Progression Indicators Detail	LAST_ORDERED_END	Root	The latest timestamp when the Care Type ended the 'Ordered' status, displayed in local timezone.
Current Care Progression Indicators Detail	LAST_ORDERED_END_ENTERPRISE	Root	The latest timestamp when the Care Type ended the 'Ordered' status, displayed in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	LAST_ORDERED_END_UTC	Root	The latest timestamp when the Care Type ended the 'Ordered' status, displayed in UTC timezone.
Current Care Progression Indicators Detail	LAST_ORDERED_FIRST_NAME	Root	The first name of the user who recently moved the care type to ‘Ordered’ status.
Current Care Progression Indicators Detail	LAST_ORDERED_LAST_NAME	Root	The last name of the user who recently moved the care type to ‘Ordered’ status.
Current Care Progression Indicators Detail	LAST_ORDERED_START	Root	The latest timestamp when the Care Type entered the 'Ordered' status, displayed in local the timezone.
Current Care Progression Indicators Detail	LAST_ORDERED_START_ENTERPRISE	Root	The latest timestamp when the Care Type entered the 'Ordered' status, displayed in the enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	LAST_ORDERED_START_UTC	Root	The latest timestamp when the Care Type entered the 'Ordered' status, displayed in the UTC timezone.
Current Care Progression Indicators Detail	LAST_ORDERED_USER_LOGIN_ID	System Calc	The username of the user that most recently moved the Care Type to ‘Ordered’ status.
Current Care Progression Indicators Detail	LASTMODDATE	Root	The date and time of the most recent update to the Care Type, displayed in the local time zone.
Current Care Progression Indicators Detail	LASTMODDATE_ENTERPRISE	Root	The date and time of the most recent update to the Care Type, displayed in the enterprise time zone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	LASTMODDATE_STATUS	Root	The date and time of the most recent update to the Care Type status, displayed in the local time zone.
Current Care Progression Indicators Detail	LASTMODDATE_STATUS_UTC	Root	The date and time of the most recent update to the Care Type status, displayed in the UTC time zone.
Current Care Progression Indicators Detail	LASTMODDATE_STATUS_ENTERPRISE	Root	The date and time of the most recent update to the Care Type status, displayed in the enterprise time zone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	LASTMODDATE_UTC	Root	The date and time of the most recent update to the Care Type, displayed in the UTC time zone.
Current Care Progression Indicators Detail	LATEST_CARE_TYPE_DELAY_REASON	Root	The value selected in the reason for Delay when the care type was delayed.
Current Care Progression Indicators Detail	LATEST_LASTMODDATE	Root	The latest timestamp that the Care Type 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 Care Type table. (Patient etc), displayed in the local timezone.
Current Care Progression Indicators Detail	LATEST_LASTMODDATE_ENTERPRISE	Root	The latest timestamp that the Care Type 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 Care Type table. (Patient etc), displayed in the enterprise timezone.
Current Care Progression Indicators Detail	LATEST_LASTMODDATE_UTC	Root	The latest timestamp that the Care Type 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 Care Type table. (Patient etc), displayed in the UTC timezone.
Current Care Progression Indicators Detail	MILESTONE_ADT_ID	System Calc	The Care Type ADT ID as setup in the Care Progression Indicator group settings in Capacity IQ® application.
Current Care Progression Indicators Detail	MILESTONE_DISPLAY_STATUS_TYPE_CODE	System Calc	Code for the Care Type status. A field used in our standard content to support multi-language workbooks. This field is not intended for client report building.
Current Care Progression Indicators Detail	MILESTONE_ENTITY_DETAIL_ID	System Calc	The unique database identifier or internal record ID of the Care Type detail of the patient. This field is not intended for customer report building.
Current Care Progression Indicators Detail	MILESTONE_ENTITY_ID	System Calc	The unique database identifier or internal record ID of the Care progression group of the patient. This field is not intended for customer report building.
Current Care Progression Indicators Detail	MILESTONE_ENTITY_TYPE	System Calc	The value that defines the type of the Milestone (ex., Care Progression, Discharge etc.,). This field is not intended for customer report building.
Current Care Progression Indicators Detail	MILESTONE_ENTITY_TYPE_CODE	System Calc	The code that defines the type of the Milestone (ex., Care Progression, Discharge etc.,). This field is not intended for customer report building.
Current Care Progression Indicators Detail	MILESTONE_GROUP_TYPE	System Calc	This is a field used to include only the discharge milestones in this data source. This field is not intended for client report building.
Current Care Progression Indicators Detail	MILESTONE_GROUP_TYPE_CODE	System Calc	The code that defines the type of the Milestone group. This field is not intended for customer report building.
Current Care Progression Indicators Detail	MILESTONE_ID	System Calc	The unique database identifier or internal record ID of the Care progression group. This field is not intended for customer report building.
Current Care Progression Indicators Detail	MILESTONE_STATUS_TYPE_CODE	System Calc	The code that defines the Milestone status. This field is not intended for customer report building.
Current Care Progression Indicators Detail	PATIENT_ADMIT_DATETIME	Root	The latest local admit date/time of the patient associated with the Care Type.
Current Care Progression Indicators Detail	PATIENT_ADMIT_DATETIME_ENTERPRISE	Root	The latest enterprise admit date/time of the patient associated with the Care Type. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	PATIENT_ADMIT_DATETIME_UTC	Root	The latest UTC admit date/time of the patient associated with the Care Type.
Current Care Progression Indicators Detail	PATIENT_CONFIRM_DISCHARGE_DATETIME	Root	The latest local confirmed discharge date/time of the patient associated with the Care Type.
Current Care Progression Indicators Detail	PATIENT_CONFIRM_DISCHARGE_DATETIME_ENTERPRISE	Root	The latest enterprise confirmed discharge date/time of the patient associated with the Care Type. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	PATIENT_CONFIRM_DISCHARGE_DATETIME_UTC	Root	The latest UTC confirmed discharge date/time of the patient associated with the Care Type.
Current Care Progression Indicators Detail	PATIENT_DIAGNOSIS	Root	The diagnosis of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_DISCHARGE_DATETIME	Root	The latest local discharge date/time of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_DISCHARGE_DATETIME_ENTERPRISE	Root	The latest enterprise discharge date/time of the patient associated with the care type. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	PATIENT_DISCHARGE_DATETIME_UTC	Root	The latest UTC discharge date/time of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_EXPECTED_DISCHARGE_DATETIME	Root	The latest local projected discharge date/time of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_EXPECTED_DISCHARGE_DATETIME_ENTERPRISE	Root	The latest enterprise projected discharge date/time of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_EXPECTED_DISCHARGE_DATETIME_UTC	Root	The latest UTC projected discharge date/time of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_FIRSTNAME	Root	The first name of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_ID	System Calc	The database identifier or the internal record ID of Patient's visit ID. This field is not intended for customer report building.
Current Care Progression Indicators Detail	PATIENT_LASTNAME	Root	The last name of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_LEVEL_OF_CARE	Root	The latest level of care of the patient associated with the care type. Ex., The degree of care that the patient requires, such as critical, acute, and intermediate, which is set in the patient details in Capacity IQ® application.
Current Care Progression Indicators Detail	PATIENT_MRN	Root	The Medical Record Number of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_PENDING_DISCHARGE_DATETIME	Root	The latest local pending discharge date/time of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_PENDING_DISCHARGE_DATETIME_ENTERPRISE	Root	The latest Enterprise pending discharge date/time of the patient associated with the care type. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Care Progression Indicators Detail	PATIENT_PENDING_DISCHARGE_DATETIME_UTC	Root	The latest UTC pending discharge date/time of the patient associated with the care type.
Current Care Progression Indicators Detail	PATIENT_STATUS_TYPE	Root	The latest status of the patient associated with care type. The values can include ConfirmedDischarge, Discharged, InHouse, OutPatient, PendingDischarge, PendingTransfer, PreAdmit, VisitCanceled.
Current Care Progression Indicators Detail	PATIENT_STATUS_TYPE_CODE	System Calc	The key that represents patient status of the patient during the visit. This field is used in standard content for multi-language support. This field is not intended for client report building.
Current Care Progression Indicators Detail	PATIENT_TYPE	Root	The value ‘patient type’ of the patient associated with the care type. Patient type is set in the patient details in Capacity IQ® application.
Current Care Progression Indicators Detail	PATIENT_VISIT_NUMBER	Root	The patient's visit number/account number of the patient associated with the care type.
Current Care Progression Indicators Detail	TENANTID	System Calc	The unique identifier associated with the tenant used for internal data partitioning. This field is not intended for client reporting.
Current Care Progression Indicators Detail	UNIT_CATEGORY_CODE	System Calc	The code of the category the unit belongs to. This field is used in standard content for multi-language support. This field is not intended for client report building.
Current Care Progression Indicators Detail	UNIT_NAME	Root	Name of the unit associated with the patient’s latest home location.
Current Care Progression Indicators Detail	WAREHOUSEACQUISITIONDATE_UTC	System Calc	The latest timestamp that a record is inserted or updated in the Snowflake Data Warehouse in UTC format.
Current Discharge Milestones	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.
Current Discharge Milestones	CAMPUS_ID	System Calc	The unique identifier of the campus where the patient was occupied. This field is not intended for client reporting.
Current Discharge Milestones	CAMPUS_NAME	Root	The name of the campus in which the patient was occupied.
Current Discharge Milestones	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.
Current Discharge Milestones	COMPLETED_BY_FIRSTNAME	Root	The first name of the user that completed the milestone.
Current Discharge Milestones	COMPLETED_BY_LASTNAME	Root	The last name of the user who completed the milestone.
Current Discharge Milestones	CREATEDDATE	Root	The latest local date time when the discharge milestones are created. Discharge milestones are created when the patient enters a pending or confirmed discharge status, when we receive a discharge milestone order, or when the discharge milestones are manually added to a patient record.
Current Discharge Milestones	CREATEDDATE_ENTERPRISE	Root	The latest enterprise date time when the discharge milestones are created. Discharge milestones are created when the patient enters a pending or confirmed discharge status, when we receive a discharge milestone order, or when the discharge milestones are manually added to a patient record. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	CREATEDDATE_UTC	Root	The latest UTC date time when the discharge milestones are created. Discharge milestones are created when the patient enters a pending or confirmed discharge status, when we receive a discharge milestone order, or when the discharge milestones are manually added to a patient record.
Current Discharge Milestones	CUSTOMER_FACILITY_ID	Root	A unique identifier for a given campus that is defined in the Capacity IQ® campus settings. Commonly used with the Data IQ® Warehouse Connector to allow joining against an external identifier in an enterprise data warehouse.
Current Discharge Milestones	DATEPARTITION	System Calc	System calculation used internally to partition the data for efficient processing.
Current Discharge Milestones	DELAY_END	Root	The local date time when the delay was ended. A delay ends when either the delay reason is removed or the milestone is marked as complete.
Current Discharge Milestones	DELAY_END_ENTERPRISE	Root	The enterprise date time when the delay was ended. A delay ends when either the delay reason is removed or the milestone is marked as complete. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	DELAY_END_UTC	Root	The UTC date time when the delay was ended. A delay ends when either the delay reason is removed or the milestone is marked as complete.
Current Discharge Milestones	DELAY_START	Root	The local date time when the delay was set for the discharge milestone.
Current Discharge Milestones	DELAY_START_ENTERPRISE	Root	The enterprise date time when the delay was set for the discharge milestone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	DELAY_START_UTC	Root	The UTC date time when the delay was set for the discharge milestone.
Current Discharge Milestones	DELAYED_BY_FIRSTNAME	Root	The first name of the user who delayed the milestone.
Current Discharge Milestones	DELAYED_BY_LASTNAME	Root	The last name of the user who delayed the milestone.
Current Discharge Milestones	ENTITY_ELEMENT_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	ESCALATION_LEVEL_TYPE_CODE	System Calc	This field is not intended for customer report building. Discharge milestones do not have an in progress status.
Current Discharge Milestones	ESCALATION_LEVEL_TYPE_NAME	System Calc	This field is not intended for customer report building. Discharge milestones do not have an in progress status.
Current Discharge Milestones	FIRST_COMPLETED_USER_LOGIN_ID	Root	The username of the user who first marked an individual milestone as complete.
Current Discharge Milestones	FIRST_DELAY_USER_LOGIN_ID	Root	The username of the user who first set a delay reason on a milestone.
Current Discharge Milestones	FIRST_INPROGRESS_USER_LOGIN_ID	System Calc	This field is not intended for customer report building. Discharge milestones do not have an in progress status.
Current Discharge Milestones	FIRST_ORDERED_USER_LOGIN_ID	Root	The intial user who created the discharge milestone.
Current Discharge Milestones	HOME_BED_ADT_ID	Root	The bed ADT ID value from the location settings associated with the patient's latest home bed.
Current Discharge Milestones	HOME_FACILITY_ADT_ID	Root	The facility ADT ID value from the location settings associated with the patient's latest home bed.
Current Discharge Milestones	HOME_LOCATION	Root	Name of the patient's latest home location.
Current Discharge Milestones	HOME_LOCATION_ID	System Calc	The database identifier of the patient's latest home location. This is not intended for client report building.
Current Discharge Milestones	HOME_NURSESTATION_ADT_ID	Root	The nursing station ADT ID value from the location settings associated with the patient's latest home bed.
Current Discharge Milestones	HOME_ROOM_ADT_ID	Root	The room ADT ID value from the location settings associated with the patient's latest home bed.
Current Discharge Milestones	Hospital Service	Root	The latest hospital service recorded in the patient visit record. The type of treatment or surgery for the patient (e.g., Oncology, Obstetrics, Adolescent, or Cardiology) is called Hospital Service or Service Line.
Current Discharge Milestones	INSTANCEID	System Calc	System calculation used for data partitioning. It is not intended for client reporting.
Current Discharge Milestones	IS_VISIBLE	Root	Indicates if milestones related to Discharge and Transfer events should be visible or not. Milestones that are not visible will be removed from the Snowflake warehouse to eliminate report confusion.
Current Discharge Milestones	LAST_COMPLETED_USER_LOGIN_ID	Root	The latest user who marked a discharge milestone as complete.
Current Discharge Milestones	LAST_DELAY_USER_LOGIN_ID	Root	The latest user who set a delay on a discharge milestone.
Current Discharge Milestones	LAST_INPROGRESS_USER_LOGIN_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	LAST_ORDERED_USER_LOGIN_ID	Root	The latest user who created the discharge milestone.
Current Discharge Milestones	LASTMODDATE	Root	The date and time of the most recent update to the discharge milestone in the local time zone.
Current Discharge Milestones	LASTMODDATE_ENTERPRISE	Root	The date and time of the most recent update to the discharge milestone in the enterprise time zone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	LASTMODDATE_UTC	Root	The date and time of the most recent update to the discharge milestone in the UTC time zone.
Current Discharge Milestones	LATEST_LASTMODDATE	Root	The latest local date time that any of the dimensions or measures were updated.
Current Discharge Milestones	LATEST_LASTMODDATE_ENTERPRISE	Root	The latest enterprise date time when any of the dimensions or measures were updated. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	LATEST_LASTMODDATE_UTC	Root	The latest UTC date time when any of the dimensions or measures were updated.
Current Discharge Milestones	MEDICAL_RECORD_NUMBER	Root	The medical record number for a person receiving medical treatment.
Current Discharge Milestones	MILESTONE_ADT_ID	Root	The ADT ID of the discharge milestone. This field is used for interfacing updates to the appropriate discharge milestone.
Current Discharge Milestones	MILESTONE_COMPLETED_DATE	Root	The latest date/time when the milestone was marked as complete in local time.
Current Discharge Milestones	MILESTONE_COMPLETED_DATE_ENTERPRISE	Root	The latest date/time when the milestone was marked as complete in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	MILESTONE_COMPLETED_DATE_UTC	Root	The latest date/time when the milestone was marked as complete in UTC time.
Current Discharge Milestones	MILESTONE_DELAY_REASON	Root	The latest reason the milestone was delayed.
Current Discharge Milestones	MILESTONE_DELAY_REASON_CODE_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_DISPLAY_STATUS_TYPE_CODE	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_ENTITY_DETAIL_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_ENTITY_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_ENTITY_TYPE	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_ENTITY_TYPE_CODE	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_ENTITY_TYPE_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_GROUP_TYPE	Root	This is a field used to include only the discharge milestones in this data source. This field is not intended for client report building.
Current Discharge Milestones	MILESTONE_GROUP_TYPE_CODE	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_GROUP_TYPE_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_NAME	Root	The name of the milestone as defined in dictionary management.
Current Discharge Milestones	MILESTONE_NOTES	Root	Displays the latest milestone note.
Current Discharge Milestones	MILESTONE_STATUS_TYPE	Root	The status of the milestone: ordered, in-progress, and completed.
Current Discharge Milestones	MILESTONE_STATUS_TYPE_CODE	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	MILESTONE_STATUS_TYPE_ID	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	PATIENT_ADMIT_DATE_TIME	Root	Date and local time when the patient was admitted.
Current Discharge Milestones	PATIENT_ADMIT_DATE_TIME_ENTERPRISE	Root	The enterprise time and date when the patient was admitted. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	PATIENT_ADMIT_DATE_TIME_UTC	Root	Date and UTC time when the patient was admitted.
Current Discharge Milestones	PATIENT_CONFIRM_DISCHARGE_DATE_TIME	Root	The latest local date/time when the patient was put into a confirmed discharge status.
Current Discharge Milestones	PATIENT_CONFIRM_DISCHARGE_DATE_TIME_ENTERPRISE	Root	The latest enterprise date/time when the patient was put into a confirmed discharge status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	PATIENT_CONFIRM_DISCHARGE_DATE_TIME_UTC	Root	The latest UTC date/time when the patient was put into a confirmed discharge status.
Current Discharge Milestones	PATIENT_DIAGNOSIS	Root	The cause of the patient's disease or injury that is believed to be the primary reason that the patient needs medical attention at the current time.
Current Discharge Milestones	PATIENT_DISCHARGE_DATE_TIME	Root	Date and local time when the patient was discharged.
Current Discharge Milestones	PATIENT_DISCHARGE_DATE_TIME_ENTERPRISE	Root	Date and enterprise time when the patient was discharged. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	PATIENT_DISCHARGE_DATE_TIME_UTC	Root	Date and UTC time when the patient was discharged.
Current Discharge Milestones	PATIENT_EXPECTED_DISCHARGE_DATE_TIME	Root	The projected discharge local date time for the patient associated with the discharge milestone.
Current Discharge Milestones	PATIENT_EXPECTED_DISCHARGE_DATE_TIME_ENTERPRISE	Root	The projected discharge enterprise date time for the patient associated with the discharge milestone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	PATIENT_EXPECTED_DISCHARGE_DATE_TIME_UTC	Root	The projected discharge UTC date time for the patient associated with the discharge milestone.
Current Discharge Milestones	PATIENT_FIRSTNAME	Root	Patient's first name.
Current Discharge Milestones	PATIENT_ID	System Calc	Unique identification number for the patient from the database. Not intended for client report building.
Current Discharge Milestones	PATIENT_LASTNAME	Root	Patient's last name.
Current Discharge Milestones	PATIENT_LEVEL_OF_CARE	Root	The degree of care that the patient requires, such as critical, acute, and intermediate, which is set in the paient's Capacity IQ® record.
Current Discharge Milestones	PATIENT_MIDDLE_INITIAL	Root	Patient's middle initial.
Current Discharge Milestones	PATIENT_MISC	Root	The text from the Misc. field in the patient record in Capacity IQ®.
Current Discharge Milestones	PATIENT_PENDING_DISCHARGE_DATE_TIME	Root	The latest local date/time when the patient was put into a pending discharge status.
Current Discharge Milestones	PATIENT_PENDING_DISCHARGE_DATE_TIME_ENTERPRISE	Root	The latest enterprise date/time when the patient was put into a pending discharge status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Discharge Milestones	PATIENT_PENDING_DISCHARGE_DATE_TIME_UTC	Root	The latest UTC date/time when the patient was put into a pending discharge status.
Current Discharge Milestones	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.
Current Discharge Milestones	Patient Status Type Code	System Calc	The key that represents patient status of the patient during the visit. This field is used in standard content for multi-language support. This field is not intended for client report building.
Current Discharge Milestones	PATIENT_TYPE	Root	The patient type as set in the patient's record in Capacity IQ®.
Current Discharge Milestones	PATIENT_VISIT_NUMBER	Root	The patient's visit number/account number.
Current Discharge Milestones	TENANTID	System Calc	A unique ID that defines a specific client. Not intended for client report building.
Current Discharge Milestones	Unit Id	System Calc	The database identifier for the latest home unit associated with the patient. Not Intended for client report building
Current Discharge Milestones	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.
Current Discharge Milestones	UNIT_CATEGORY_CODE	System Calc	This field is not intended for customer report building.
Current Discharge Milestones	UNIT_NAME	Root	The name of the latest home unit associated with the patient.
Current Discharge Milestones	WAREHOUSEACQUISITIONDATE_UTC	System Calc	The latest time when a record is inserted in the Snowflake Data Warehouse.
Current IQ Case	2 Days Ago	Custom Calc	This takes the current date and subtracts it by two days.
Current IQ Case	Accept	Custom Calc	If the disposition contains "Accept", then display Accept. This field is not intended for client report building.
Current IQ Case	Accept Number	Custom Calc	If the disposition contains "Accept", then the record will be included in the number of records. This field is not intended for client report building.
Current IQ Case	Accepting Physician	Root	The first Physician to be marked as the 'accepting' physician by selecting an 'accepted' disposition for the physician communication record.
Current IQ Case	Admitting Physician	Root	The name of the physician who agrees to admit the patient into the facility.
Current IQ Case	Adult Vs Pediatric	Custom Calc	Determines if a patient is an adult or pediatric patient based upon the Patient Age field IF [Patient Age] = "17" THEN "Pediatric" ELSEIF [Patient Age] = "16" THEN "Pediatric" ELSEIF [Patient Age] = "15" THEN "Pediatric" ELSEIF [Patient Age] = "14" THEN "Pediatric" ELSEIF [Patient Age] = "13" THEN "Pediatric" ELSEIF [Patient Age] = "12" THEN "Pediatric" ELSEIF [Patient Age] = "11" THEN "Pediatric" ELSEIF [Patient Age] = "10" THEN "Pediatric" ELSEIF [Patient Age] = "9" THEN "Pediatric" ELSEIF [Patient Age] = "8" THEN "Pediatric" ELSEIF [Patient Age] = "7" THEN "Pediatric" ELSEIF [Patient Age] = "6" THEN "Pediatric" ELSEIF [Patient Age] = "5" THEN "Pediatric" ELSEIF [Patient Age] = "4" THEN "Pediatric" ELSEIF [Patient Age] = "3" THEN "Pediatric" ELSEIF [Patient Age] = "2" THEN "Pediatric" ELSEIF [Patient Age] = "1" THEN "Pediatric" ELSEIF [Patient Age] = "0" THEN "Pediatric" ELSEIF CONTAINS([Patient Age], "d") THEN "Pediatric" ELSEIF CONTAINS([Patient Age], "m") THEN "Pediatric" ELSE "Adult" END"
Current IQ Case	Alerts	Root	The latest Medical Alert(s) selected in the transfer case. If there are more than one medical alerts selected, then the field will include each alert with a comma separator.
Current IQ Case	Allergies	Root	The latest Allergies selected in the transfer case. If there is more than one allergy selected, then the field will include each allergy with a comma separator.
Current IQ Case	Assigned Bed Number	Root	The bed assigned to the placement request created on the outcomes tab.
Current IQ Case	Assigned To Occupied Time	Root	The duration from when a bed was assigned to a patient until the patient physically occupied the bed. The bed request must be created from the Transfer Center Case for this duration to be available. Calculation: Bed Occupied Timestamp minus Bed Assigned Timestamp
Current IQ Case	Bed Assigned Timestamp	Root	The platform date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit application or the Patient Tracking Portal application.
Current IQ Case	Bed Assigned Timestamp Utc	Root	The UTC date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit application or the PatientTracking Portal® application.
Current IQ Case	Bed Occupied Timestamp	Root	The platform date and time of day that the patient was admitted and the Pt Status column changed to Inhouse in the Capacity IQ® list view.
Current IQ Case	Bed Occupied Timestamp Utc	Root	The UTC date and time of day that the patient was admitted and the Pt Status column changed to Inhouse in the Capacity IQ® list view.
Current IQ Case	Bed Request Activated	Root	If the column displays a value of True, the placement request is activated, and the patient needs a bed now.
Current IQ Case	Bed Request Status Type	Root	The type of bed requested for the patient (assigned, completed, etc.).
Current IQ Case	Bed Request Status Type Localized	Root	The type of bed requested for the patient (assigned, completed, etc.). This field is not intended for client report building.
Current IQ Case	Bed Request Targeted Unit	Root	The unit that includes the bed that is preferred for the patient. This is the target unit listed in the bed request detailes of the patient placement detail pane.
Current IQ Case	Bed Requested Timestamp	Root	The platform date and time of day that a bed request was created.
Current IQ Case	Bed Requested Timestamp Utc	Root	The UTC date and time of day that a bed request was created.
Current IQ Case	Bed Type Value	System Calc	This field is not intended for client report building.
Current IQ Case	Calculated Age	Custom Calc	The current year minus the year of the the patient's DOB
Current IQ Case	Caller1 Name	Root	The latest user recorded in the Caller 1 field.
Current IQ Case	Campus Name	Root	The name of the destination facility that accepts the transfer patient.
Current IQ Case	Cancel Number	Custom Calc	If the disposition contains "Cancel", then the record will be included in the number of records. This field is not intended for client report building.
Current IQ Case	Cancels	Custom Calc	A calculated field that changes a lower case 'cancel' to the standard of 'Cancel'. This field is not intended for client report building.
Current IQ Case	Case Complete Datetime	Root	The latest platform date/time the case was completed.
Current IQ Case	Case Complete Datetime Utc	Root	The latest UTC date/time the case was completed.
Current IQ Case	Case Created Date	Root	The latest platform date/time the case was Created.
Current IQ Case	Case Created Date No Time	Custom Calc	A calculated field to derive the date portion of the created date/time. This field is not intended for client report building.
Current IQ Case	Case Created Date Utc	Root	The latest date/time the case was Created in UTC time.
Current IQ Case	Case Created To Occupied Time	Root	The duration from when a transfer case was created until the patient physically occupied a bed. Calculation: Bed Occupied Timestamp minus Case Created Timestamp
Current IQ Case	Case Disposition	Root	The latest disposition recorded for the Transfer IQ® Case.
Current IQ Case	Case Disposition Reason	Root	The latest disposition reason recorded for the Transfer IQ® Case.
Current IQ Case	Case Disposition Timestamp	Root	The platform date and time that a case disposition was recorded for the transfer case.
Current IQ Case	Case Disposition Timestamp Utc	Root	The UTC date and time that a case disposition was recorded for the transfer case.
Current IQ Case	Case Needs Review	Root	A flag that indicates if the 'Case Needs Review' check box is marked on the transfer case.
Current IQ Case	Case Number	Root	The identifying number that appears below the patient's name in the case details header.
Current IQ Case	Case Owner	Root	The user whose name appears in the case's Case Owner field. This name can be changed.
Current IQ Case	Case Owner Username	Root	The company’s unique login identifier associated with the employee who owns the case.
Current IQ Case	Case Transfer Reason	Root	The reason that a patient needs to be transferred from one facility to another, such as Lack of Capacity, On-Call Specialist Not Available, Family Request, Patient Needs Higher Level of Care, Psych-Involuntary, Psych-Voluntary.
Current IQ Case	Case Type	Root	A description of the kind of transfer case. This is recorded in the 'Case Type' field in the transfer case.
Current IQ Case	Consult Number	Custom Calc	If the disposition contains "consult", then the record will be included in the number of records. This field is not intended for client report building.
Current IQ Case	Current Month Records	Custom Calc	The volume of transfer cases in the current month.
Current IQ Case	Current Month Records Wallboard	Custom Calc	The volume of transfer cases in the current month. Not intended for client report building.
Current IQ Case	Current Team	Root	The latest value set for the Case Team in the Transfer IQ® Case.
Current IQ Case	Customer Facility Id	System Calc	If a facility is integrated with Capacity IQ®, and the destination facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility.
Current IQ Case	Datepartition	System Calc	System calculation used internally to partition the data for efficient processing. This field is not intended for client report building.
Current IQ Case	Decline Number	Custom Calc	If the disposition contains "decline", then the record will be included in the number of records. This field is not intended for client report building.
Current IQ Case	Declines	Custom Calc	A calculated field that changes a lower case 'decline' to the standard of 'Decline'. This field is not intended for client report building.
Current IQ Case	Destination Customer Facility Id	System Calc	If a facility is integrated with the Capacity IQ®, and the destination facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility.
Current IQ Case	Destination Facility Category	Root	The facility category assigned to the destination facility of the Transfer IQ® Case.
Current IQ Case	Destination Facility Id	System Calc	The unique GUID identifier for the facility that admits the patient. This field is not intended for client report building.
Current IQ Case	Destination Unit	Root	The unit preferred for the patient and recorded in the Target Unit field.
Current IQ Case	Destination Zipcode	Root	The zip code of the health care facility that actually admits the patient.
Current IQ Case	Facility Id	System Calc	A unique GUID identifier of the facility associated with the referring facility. This is not intended for client report building.
Current IQ Case	First Physician Contact Name	Root	The first Physician to have the Contacted button selected in Physician Communication.
Current IQ Case	First Physician Contact Timestamp	Root	The initial local date/time the Physician have the Contacted button selected in Physician Communication.
Current IQ Case	First Physician Contact Timestamp Utc	Root	The initial UTC date/time the Physician have the Contacted button selected in Physician Communication.
Current IQ Case	Format Time To Accept	Custom Calc	A custom format of 'Time to Accept'. Time to accept is the number of minutes between the case created date and the disposition date time. This field is not intended for client report building.
Current IQ Case	Help	Custom Calc	A custom field used in standard content as a placehold for the help button. This field is not intended for client report building.
Current IQ Case	Hospital Specialty	Root	The specialty recorded under the requested services in the Transfer IQ® Case.
Current IQ Case	Initial Case Complete Datetime	Root	The initial platform date time when a transfer case is completed.
Current IQ Case	Initial Case Complete Datetime Utc	Root	The initial date time set in UTC when a transfer case is completed.
Current IQ Case	Initial Team	Root	The initial value set for the Case Team in the Transfer IQ® Case.
Current IQ Case	Instanceid	System Calc	The unique identifier associated with the instance. For Transfer IQ®, this will be the same as the Tenant ID. This field is not intended for client reporting.
Current IQ Case	Internal Transport offered	Root	A flag value indicating if the 'Appropriate internal transport services have been offered.' checkbox has been check for the transfer case.
Current IQ Case	Isolations	Root	The isolation selected in the isolation type field for the transfer case.
Current IQ Case	Lastmoddate	Root	The platform date/time that the transfer case record was updated.
Current IQ Case	Lastmoddate Utc	Root	The UTC date/time that the transfer case record was updated.
Current IQ Case	Latest Bed Request Activated Timestamp	Root	The platform date/time that the placement request associated with the transfer case was activated.
Current IQ Case	Latest Bed Request Activated Timestamp Utc	Root	The latest UTC date/time that the placement request associated with the transfer case was activated.
Current IQ Case	Latest Lastmoddate Utc	System Calc	This is the most recent timestamp in UTC indicating when any data point within a record was last updated.
Current IQ Case	Legend Shape Calc	Custom Calc	A calculated field used in standard content for shape formatting. This field is not intended for client report building.
Current IQ Case	Less Than Today	Custom Calc	A calculated field that determines if the created date was any day prior to the current date.
Current IQ Case	Level of Care	Root	The degree of care that the patient requires (for example, Critical, Acute, Intermediate). This is recorded in the Requested Level of Care field of the transfer case.
Current IQ Case	Number of Records	Root	The number of transfer cases. Each row in the data set equals 1.
Current IQ Case	Number of Records 1	Custom Calc	IF [Number of Records] > 1 THEN [Number of Records] ELSEIF CONTAINS([Case Disposition], "Null") THEN 0 END
Current IQ Case	Onset of Symptoms Date	Root	The platform date/time recorded for the onset of symptoms.
Current IQ Case	Onset of Symptoms Date Utc	Root	The UTC date/time recorded for the onset of symptoms.
Current IQ Case	Organisms	Root	The latest Organism(s) selected in the transfer case. If there are more than one Organisms selected, then the field will include each Organism with a comma separator.
Current IQ Case	Patient Age	Root	The age of the person receiving medical treatment at the time of the visit.
Current IQ Case	Patient Dob	Root	The date of birth of the person receiving medical treatment.
Current IQ Case	Patient First Name	Root	The first name of the person receiving medical treatment.
Current IQ Case	Patient Gender	Root	The gender recorded in the transfer case.
Current IQ Case	Patient Gender Localized	System Calc	A patient gender used in our standard content for language localization. This field is not intended for client report building.
Current IQ Case	Patient Last Name	Root	The last name of the person receiving medical treatment.
Current IQ Case	Patient Middleinitial	Root	The middle initial of the person receiving medical treatment.
Current IQ Case	Patient Mrn	Root	The medical record number for person receiving medical treatment.
Current IQ Case	Patient Qualifies For Auto Acceptance	Root	A flag indicating if the 'Patient qualifies for automatic acceptance' is currently selected
Current IQ Case	Patient Status	Root	The value selected for the Patient Code Status in the transfer case.
Current IQ Case	Patient Suffix	Root	The suffix name of the person receiving medical treatment.
Current IQ Case	Patient Type	Root	The patient type selected in the patient details.
Current IQ Case	Percent Change Colors	Custom Calc	Used to define colors by looking if the percent change is less than or equal to -10% IF [Percent Change Months] <= -.1 THEN "Drop In Transfers" ELSE "Transfers" END
Current IQ Case	Percent Change Months	Custom Calc	Finds the percentage difference from the current month and prior month (SUM([Current Month Records Wallboard])/SUM([Prior Month Records Wallboard]))-1
Current IQ Case	Preferred Customer Facility Id	System Calc	If a facility is integrated with the Capacity IQ®, and the preferred facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility.
Current IQ Case	Preferred Facility	Root	The facility that is preferred for the patient recorded in the transfer case.
Current IQ Case	Preferred Facility Id	System Calc	The ID of the facility that is preferred for the patient recorded in the transfer case. This field is not intended for client report building.
Current IQ Case	Preferred Facility Redirect Reason	Root	This is the reason that the patient will be going to a facility other than the one they indicated as preferred
Current IQ Case	Primary Care Physician	Root	The primary care physician recorded in the transfer case.
Current IQ Case	Primary Diagnosis	Root	The cause of the patient's disease or injury that is believed to be the primary reason that the patient needs medical attention at the current time.
Current IQ Case	Primary Payor	Root	The name of the health insurance carrier that takes first responsibility to pay for the patient's care.
Current IQ Case	Primary Payor Category	Root	The grouping of health insurance carriers that the primary payor belongs to.
Current IQ Case	Prior Month Records	Custom Calc	Finds the number of records in the data that have a Case Created Date in the previous month IF DATEPART('month',[Case Created Date]) = (DATEPART('month',TODAY())-1) THEN [Number of Records] Else 0 END
Current IQ Case	Prior Month Records Wallboard	Custom Calc	Finds the number of records in the data that have a Case Created Date in the previous month IF DATEPART('month',[Case Created Date]) = (DATEPART('month',TODAY())-1) THEN [Number of Records] Else 0 END
Current IQ Case	Procedure	Root	The procedure recorded in the transfer case.
Current IQ Case	Records Filter	Custom Calc	Used to include only data where the current and prior months have at least 1 record [Current Month Records] + [Prior Month Records] >= 1
Current IQ Case	Referral Withdrawn	Root	A withdrawn referral is a referral that was canceled before being imported into Transfer IQ®.
Current IQ Case	Referring Customer Facility Id	System Calc	If a facility is integrated with the Capacity IQ®, and the referring facility recorded in the case has an external identifier, it will display the value set in the campus settings for that facility.
Current IQ Case	Referring Facility	Root	The health care facility that requests a transfer for a patient.
Current IQ Case	Referring Facility Category	Root	The grouping of facilities that the referring facility belongs to.
Current IQ Case	Referring Facility Id	System Calc	The unique identifier for the referring facility. This field is not intended for client report building.
Current IQ Case	Referring Facility Notified Datetime	Root	The platform date/time the referring facility notified staff.
Current IQ Case	Referring Facility Notified Datetime Utc	Root	The utc date/time the referring facility notified staff.
Current IQ Case	Referring Facility Notified Staff Name	Root	The name of the staff recorded under 'referring facility notified staff' section of the transfer case.
Current IQ Case	Referring Physician	Root	Name of the physician who requests the transfer.
Current IQ Case	Referring Unit	Root	The unit that includes the location from which the patient was referred.
Current IQ Case	Referring Zipcode	Root	The zip code of the health care facility that requests a transfer for a patient.
Current IQ Case	Requested Level of Care	Root	This is the level of care that the referring facility/referring provider has requested is needed for the patient. This data point can come from Referral IQ® and/or be populated from within the Transfer IQ® application on the Patient Tab of the Patient's Case Record. Note: This may be the same or different as the Level of Care indicated at the time of bed request or the Level of Care noted at the time of the patient's admission.
Current IQ Case	Requested To Assigned Time	Root	The duration from when a bed was requested until a bed was assigned to the patient. Calculation: Bed Assigned Timestamp minus Bed Requested Timestamp
Current IQ Case	Requested To Occupied Time	Root	The duration from when a bed was requested for a patient in the transfer case until the patient physically occupied the bed. Calculation: Bed Occupied Timestamp minus Bed Requested Timestamp
Current IQ Case	Return Patient To Referring Facility	Root	A flag indicating if the 'Return patient to referring facility upon completion of case' check box is currently selected.
Current IQ Case	Secondary Diagnosis	Root	The cause of the patient's disease or injury that is believed to be the secondary reason that the patient needs medical attention at the current time.
Current IQ Case	Secondary Payor	Root	The name of the health insurance carrier that takes second responsibility to pay for the patient's care.
Current IQ Case	Secondary Payor Category	Root	The grouping of health insurance carriers that the secondary payor belongs to.
Current IQ Case	Service Line	Root	The type of treatment or surgery for the patient (i.e., Oncology, Obstetrics, Adolescent, or Cardiology) is called Hospital Service or Service Line. The service line is derived from the specialty in the case, and the associated service line configured in the data dictionary.
Current IQ Case	Service offered At Referring Facility	Root	A flag indicating if the checkbox is currently selected for "The referring facility offers this service"
Current IQ Case	Source	Root	The application where the transfer case originated. Values: If the case was created in Transfer IQ®, source = TC If the case was created by importing a referral, source = CAP
Current IQ Case	Tenantid	System Calc	The unique identifier associated with the tenant. This field is not intended for client reporting.
Current IQ Case	Tertiary Payor	Root	The name of the health insurance carrier that takes third responsibility to pay for the patient's care.
Current IQ Case	Tertiary Payor Category	Root	The grouping of health insurance carriers to which the tertiary payor belongs.
Current IQ Case	Time To Accept	Custom Calc	The difference in time (in minutes) between the Case Created Date and the Case Disposition Timestamp DATEDIFF('minute', [Case Created Date],[Case Disposition Timestamp])
Current IQ Case	Time To Accept Colors	Custom Calc	Used to define the colors for the difference in time (in minutes) between the Case Created Date and the Case Disposition Timestamp IF AVG([Time To Accept]) > 15 THEN "Red" ELSEIF AVG([Time To Accept]) <= 15 THEN "Green" ELSE "No Data" END
Current IQ Case	Transfer Id	System Calc	A unique identifier of the transfer case. This is not intended for client report building.
Current IQ Case	Transport Arrival Datetime	Root	The platform date/time recorded for the patient arrival.
Current IQ Case	Transport Arrival Datetime Utc	Root	The UTC date/time recorded for the patient arrival.
Current IQ Case	Transport Directed To	Root	The value recorded for the 'Directed to field'. This is typically the place or location transport is directed to.
Current IQ Case	Transport Dispatch Datetime	Root	The platform date/time recorded for transport dispatch.
Current IQ Case	Transport Dispatch Datetime Utc	Root	The UTC date/time recorded for transport dispatch.
Current IQ Case	Transport Eta	Root	The platform date/time recorded for transport ETA.
Current IQ Case	Transport Eta Utc	Root	The UTC date/time recorded for transport ETA.
Current IQ Case	Transport Mode	Root	The transport mode recorded for the transfer case.
Current IQ Case	Treatments	Root	The treatments recorded for the transfer case. If multiple treatments are recorded in a given transfer case, they will be all be included as comma seperated values
Current IQ Case	Visit Number	Root	The identifier recorded for one of the patient's hospital stays.
Current IQ Case	Volume	Custom Calc	Each row in this data set is 1. When this field is aggregated, it can be used to show the sum, average, etc volume for a given period of time, or by other dimension fields.
Current IQ Case	Warehouseacquisitiondate Utc	System Calc	The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format.
Current Patient Attributes	Acquisition Date	Root	System calculation that allows us to see when the data was acquired in the source system.
Current Patient Attributes	Acquisition Date UTC	Root	System calculation that allows us to see when the data was acquired in the source system in UTC.
Current Patient Attributes	Actual Discharge Timestamp	Root	The date and time of day that the patient was actually discharged.
Current Patient Attributes	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.
Current Patient Attributes	Attribute Category	Root	The type of grouping for a patient attribute. For example, Admit Status, Interventions, Organism.
Current Patient Attributes	Attribute Category ID	Root	The unique identifier for the type of grouping for a patient attribute. For example, Admit Status, Interventions, Organism.
Current Patient Attributes	Attribute End Timestamp	Root	Date and time the attribute was removed from a patient.
Current Patient Attributes	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.
Current Patient Attributes	Attribute End Timestamp UTC	Root	Date and time in UTC the attribute was removed from a patient.
Current Patient Attributes	Attribute ID	Root	The unique identifier custom attribute(s) associated with the patient's visit. This includes isolation attributes.
Current Patient Attributes	Attribute Name	Root	The custom attribute(s) associated with the patient's visit. This includes isolation attributes.
Current Patient Attributes	Attribute Start Timestamp	Root	Date and time the attribute was applied to a patient.
Current Patient Attributes	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.
Current Patient Attributes	Attribute Start Timestamp UTC	Root	Date and time in UTC the attribute was applied to a patient.
Current Patient Attributes	Attribute Total Duration	Root	The total duration in minutes from Attribute Start Timestamp to Attribute End Timestamp.
Current Patient Attributes	Attribute Type	Root	Whether the attribute is a Custom Attribute or Isolation.
Current Patient Attributes	Attribute Type Id	Root	The unique identifier that determines if it is a custom attribute or isolation attribute.
Current Patient Attributes	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.
Current Patient Attributes	Campus	Root	The name of a collection of buildings in the enterprise.
Current Patient Attributes	Campus ID	Root	The unique identifier of a collection of buildings in the enterprise.
Current Patient Attributes	Cloudacquisition Date	Root	System calculation that allows us to see when the data was acquired into the cloud.
Current Patient Attributes	Cloudacquisition Date UTC	Root	System calculation that allows us to see when the data was acquired into the cloud in UTC.
Current Patient Attributes	Createddate	Root	Created Date in Local Time zone for when the record was entered.
Current Patient Attributes	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.
Current Patient Attributes	Createddate UTC	Root	Created Date in UTC for when the record was entered.
Current Patient Attributes	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.
Current Patient Attributes	FACILITY_ADT_ID	System Calc	A unique identifier for an individual facility. This is the Facility ADT ID that is associated with the location.
Current Patient Attributes	Instanceid	Root	The name of the instance GUID — Non–Strict Dynamic Partition Column.
Current Patient Attributes	Is Bed Matching	Root	The patient's admission location had an attribute matching what was set for the patient.
Current Patient Attributes	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.
Current Patient Attributes	Latest Lastmoddate	Root	The date of the most recent update to the Patient Visit record in local time zone.
Current Patient Attributes	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.
Current Patient Attributes	Latest Lastmoddate UTC	Root	The date of the most recent update to the Patient Visit record in UTC.
Current Patient Attributes	Location	Root	The name of the individual bed location.
Current Patient Attributes	Location ID	Root	The unique identifier of the individual bed location.
Current Patient Attributes	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.
Current Patient Attributes	Patient Firstname	Root	Patient's first name.
Current Patient Attributes	Patient Lastname	Root	Patient's last name.
Current Patient Attributes	Patient Mrn	Root	Patient's medical record number as defined by ADT mapping.
Current Patient Attributes	Patient Status Type	Root	Capacity IQ® patient status type to filter outpatients, confirmed discharge, pending discharge, preadmit.
Current Patient Attributes	Patient Visit ID	Root	The Database or Internal Record ID for a patient's visit.
Current Patient Attributes	Patient Visit Number	Root	The patient's External ID (ADT).
Current Patient Attributes	ROOM_ADT_ID	System Calc	A unique identifier for an individual room. This is the Room ADT ID that is associated with the location.
Current Patient Attributes	TenantID	Root	The name of the tenant GUID — Non–Strict Dynamic Partition Column.
Current Patient Attributes	Unit	Root	The name of the unit that includes the location which the patient physically occupied.
Current Patient Attributes	Unit ID	Root	The unique identifier of the unit that includes the location which the patient physically occupied.
Current Patient Attributes	Warehouseacquisitiondate UTC	Root	System calculation that allows us to see when the data was acquired in the source system in UTC.
Current Patient Custom Data	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.
Current Patient Custom Data	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.
Current Patient Custom Data	CREATEDDATE	Root	Created Date in Local Time zone for when the patient custom column was created in Capacity IQ®.
Current Patient Custom Data	CREATEDDATE ENTERPRISE	Root	Created Date in Enterprise time zone for when the patient custom column was created in Capacity IQ®. The enterprise time is in the timezone configured in the Operations
Current Patient Custom Data	CREATEDDATE UTC	Root	Created Date in UTC Time zone for when the patient custom column was created in Capacity IQ®.
Current Patient Custom Data	CUSTOMER FACILITY ID	System Calc	A unique identifier for a given campus that is defined in the Capacity IQ® campus settings under the Campus Account ID field. Commonly used with the Data IQ® Warehouse Connector to allow joining against an external identifier in an enterprise data warehouse.
Current Patient Custom Data	CUSTOM FIELD COLUMN TYPE	Root	The column type of the custom column in Capacity IQ®. Example: text, numeric, datetime, boolean.
Current Patient Custom Data	CUSTOM FIELD DESCRIPTION	Root	The custom column description in Capacity IQ®
Current Patient Custom Data	CUSTOM FIELD HEADER	Root	The value of the custom header in Capacity IQ®
Current Patient Custom Data	CUSTOM FIELD ID	Root	The unique identifier of the custom column in Capacity IQ®
Current Patient Custom Data	CUSTOM FIELD NAME	Root	The displayed name of the custom column in Capacity IQ®
Current Patient Custom Data	CUSTOM FIELD VALUE	Root	The value set for the custom column in Capacity IQ®
Current Patient Custom Data	LASTMODDATE	System Calc	System calculation that displays the most recent update to the custom data field in local time. This field is not intended for client reporting.
Current Patient Custom Data	LASTMODDATE ENTERPRISE	System Calc	System calculation that displays the most recent update to the custom data field in enterprise time. This field is not intended for client reporting. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Custom Data	LASTMODDATE UTC	System Calc	System calculation that displays the most recent update to the custom data field in UTC time. This field is not intended for client reporting.
Current Patient Custom Data	LATEST LASTMODDATE ENTERPRISE	System Calc	This is the most recent timestamp in Enterprise timezone indicating when any data point within a record was last updated. The enterprise time is in the timezone configured in the IQ Platform enterprise settings.
Current Patient Custom Data	LATEST LASTMODDATE UTC	System Calc	This is the most recent timestamp in UTC timezone indicating when any data point within a record was last updated.
Current Patient Custom Data	PATIENT CAMPUS	Root	The campus associated with the patient visit record when the record was created
Current Patient Custom Data	PATIENT CAMPUS ID	System Calc	A unique identifier associated with campus.
Current Patient Custom Data	PATIENT DIAGNOSIS	Root	The latest admit diagnosis text associated with the patient visit record.
Current Patient Custom Data	PATIENT DISCHARGE TIMESTAMP	Root	The latest local timestamp the patient entered a discharged status
Current Patient Custom Data	PATIENT DISCHARGE TIMESTAMP ENTERPRISE	Root	The latest enterprise timestamp when the patient entered a discharged status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Custom Data	PATIENT DISCHARGE TIMESTAMP UTC	Root	The latest UTC timestamp the patient entered a discharged status
Current Patient Custom Data	PATIENT DOB	Root	The date of birth of the patient receiving medical treatment.
Current Patient Custom Data	PATIENT FIRSTNAME	Root	The First name of the patient
Current Patient Custom Data	PATIENT GENDER	Root	Gender set in the patient visit record
Current Patient Custom Data	PATIENT GENDER CODE	System Calc	The gender code mearked for the patient. This field is used in standard content for multi-language support. This field is not intended for client report building.ort multi-language workbooks. This field is not intended for client report building.
Current Patient Custom Data	PATIENT HOME LOCATION ID	System Calc	The database identifier or internal record ID of the patient's latest home location. This is not intended for client report building.
Current Patient Custom Data	PATIENT HOME LOCATION	System Calc	The latest home location of the patient
Current Patient Custom Data	PATIENT IS EVER ADMITTED	Root	Indicates if the patient was ever admitted or not
Current Patient Custom Data	PATIENT LASTNAME	Root	The Last name of the patient
Current Patient Custom Data	PATIENT LEVEL OF CARE	Root	The degree of care that the patient requires, such as critical, acute, intermediate.
Current Patient Custom Data	PATIENT LEVEL OF CARE ID	System Calc	Unique identifier associated with Patient's LevelofCare
Current Patient Custom Data	PATIENT MIDDLE INITIAL	Root	The Middle Initial of the patient
Current Patient Custom Data	PATIENT MRN	Root	The medical record number for a person receiving medical treatment.
Current Patient Custom Data	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.
Current Patient Custom Data	PATIENT STATUS TYPE CODE	Root	The key that represents the status of the patient. This field is used in standard content for multi-language support. This field is not intended for client report building.
Current Patient Custom Data	PATIENT STATUS TYPE ID	System Calc	This field is Patient's PatientStatusTypeID
Current Patient Custom Data	PATIENT TYPE	Root	The patient type as set in the patient's record in Capacity IQ®.
Current Patient Custom Data	PATIENT VISIT ID	Root	Unique identifier associated for the patient visit. Not intended for client report building.
Current Patient Custom Data	PATIENT VISIT NUMBER	Root	The patient's visit number/account number.
Current Patient Custom Data	WAREHOUSEACQUISITIONDATE UTC	System Calc	The timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format.
Current Patient Placement	Adjustable ED Request to Occupied Colors	Custom Calc	IF [Adjustable ED Request to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Adjustable ED Request to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [Adjustable ED Request to Occupied Variance] <= 0 THEN "Within Threshold" ELSE """ END
Current Patient Placement	Adjustable ED Request to Occupied Variance	Custom Calc	(AVG([ED Bed Request To Bed Occupy Time]-[ED Request to Occupied Time]))/[ED Request to Occupied Time]
Current Patient Placement	Adjustable Request to Occupied Colors	Custom Calc	IF [Adjustable Request to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Adjustable Request to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [Adjustable Request to Occupied Variance] <= 0 THEN "Within Threshold" ELSE "" END
Current Patient Placement	Adjustable Request to Occupied Variance	Custom Calc	(AVG([Bedrequested To Bedoccupied Time]-[Request to Occupied Time]))/[Request to Occupied Time]
Current Patient Placement	Adjustable RTM Compliance	Custom Calc	IF [RTM Compliance %]>= [RTM Compliance] THEN "Green" ELSE "Red" END
Current Patient Placement	Adjustable RTM to Assigned Time Colors	Custom Calc	IF [Adjustable RTM to Assigned Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Adjustable RTM to Assigned Variance] > 0 THEN "Approaching Threshold" ELSEIF [Adjustable RTM to Assigned Variance] <=0 THEN "Within Threshold" ELSE "" END
Current Patient Placement	Adjustable RTM to Assigned Variance	Custom Calc	(AVG([Rtm To Bedassigned Time]-[RTM to Assigned Time]))/[RTM to Assigned Time]
Current Patient Placement	Adjustable RTM to Occupied Colors	Custom Calc	IF [Adjustable RTM to Occupied Variance] > 0.1 THEN "Outside Threshold" ELSEIF [Adjustable RTM to Occupied Variance] > 0 THEN "Approaching Threshold" ELSEIF [Adjustable RTM to Occupied Variance] <= 0 THEN "Within Threshold" ELSE "" END
Current Patient Placement	Adjustable RTM to Occupied Variance	Custom Calc	(AVG([Rtm To Bedoccupied Time]-[RTM to Occupied Time]))/[RTM to Occupied Time]
Current Patient Placement	Admitting Patient Physician Type Code	System Calc	This field is not intended for customer report building.
Current Patient Placement	Attending Patient Physician Type Code	System Calc	This field is not intended for customer report building.
Current Patient Placement	Bed Assigned Timestamp	Root	The date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit application or Patient Tracking Portal application.
Current Patient Placement	Bed Assigned Timestamp Enterprise	Root	The enterprise date and time that a bed is allocated to a patient in the Capacity IQ® PreAdmit application or Patient Tracking Portal application. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	Bed Clean Timestamp	Root	The date and time that a bed was marked clean.
Current Patient Placement	Bed Clean Timestamp Enterprise	Root	The enterprise date and time that a bed was marked clean. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	Bed Occupied Timestamp	Root	The date and time that the patient began to physically occupy the bed when the placement was completed.
Current Patient Placement	Bed Occupied Timestamp Enterprise	Root	The enterprise date and time that the patient began to physically occupy the bed when the placement was completed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	Bed Request Cancelled Timestamp Enterprise	Root	The date and time that the placement request was cancelled in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	Bed Request Timestamp	Root	The date and time the placement request was created.
Current Patient Placement	Bed Request Timestamp Enterprise	Root	The date and time the placement request was created in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	Bed Requested to Bed Assigned Time	Root	The duration from when the patient's bed was requested until the bed was assigned to the patient. Calculation: Bed Assigned Timestamp minus Bed Requested Timestamp
Current Patient Placement	Bed Requested to Bed Occupied Time	Root	The duration from when the patient's bed was requested until the patient began to physically occupy the bed. Calculation: Bed Occupied Timestamp minus Bed Requested Timestamp
Current Patient Placement	Completed Placements	Custom Calc	IF [Placement Status]="Completed" THEN 1 ELSE 0 END
Current Patient Placement	Created Date Enterprise	Root	The enterprise date and time the placement request was created. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	Is Activated	Root	If the column displays a value of True, the placement request is activated, and the patient needs a bed now.
Current Patient Placement	Lastmoddate	Root	The date of the most recent update to the patient record in local time zone.
Current Patient Placement	Lastmoddate Enterprise	Root	The date of the most recent updated to the patient record in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	Lastmoddate UTC	Root	The date of the most recent updated to the patient record in UTC.
Current Patient Placement	Latest Lastmoddate Enterprise	Root	The date of the latest patient record in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	Occupied Timer	Root	The time from when the patient is RTM, a bed is assigned, and a clean bed is available to the time the patient physically occupies the bed.
Current Patient Placement	Origin Campus	Root	The name of a collection of buildings in the enterprise that includes the bed where the patient was located before being moved.
Current Patient Placement	Origin Unit	Root	The unit that includes the bed where the patient was located before being moved.
Current Patient Placement	Origin Unit Category	Root	The category to which the origin unit belongs.
Current Patient Placement	Patient Age Current	Custom Calc	The time in years between the Patient's date of birth and today. Calculation: DATEDIFF('year', [Patient Dob], NOW()).
Current Patient Placement	Patient Age Initial	Custom Calc	The time in years between the Patient's date of birth and the case created date. Calculation: DATEDIFF('year', [Patient Dob], [Case Created Date]).
Current Patient Placement	Placement ID	Root	The identified for a home location (bed) that is assigned to a patient in a health system.
Current Patient Placement	Placement Status	Root	The status of the placement such as, Requested, Assigned, Completed, Cancelled, or Unknown.
Current Patient Placement	RTM Before Assigned Count	Custom Calc	IF DATEDIFF('minute', [Rtm Timestamp],[Bed Assigned Timestamp])>0 THEN 1 ELSE 0 END
Current Patient Placement	RTM Compliance %	Custom Calc	sum( IF [Placement Status]="Completed" THEN[RTM before assigned count] END)/SUM([Completed Placements])
Current Patient Placement	RTM Timestamp	Root	The date and time that the patient was marked Ready to Move (RTM).
Current Patient Placement	RTM Timestamp Enterprise	Root	The date and time that the patient was marked Ready to Move (RTM) in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Placement	RTM to Bed Assigned Time	Root	The duration from when the patient was marked Ready to Move (RTM) until a bed was allocated to the patient. Calculation: Bed Assigned Timestamp minus RTM Timestamp
Current Patient Placement	RTM to Bed Occupied Time	Root	The duration from when the patient was marked Ready to Move (RTM) until the patient began to physically occupy the bed. Calculation: Bed Occupied Timestamp minus RTM Timestamp
Current Patient Placement	Tenant ID	Root	Tenant GUID - Non-Strict Dynamic Partition Column.
Current Patient Placement	Time Format ED Request to Occupied	Custom Calc	IIF(int(AVG([ED Bed Request To Bed Occupy Time]60)) % 60 == 60,0,AVG([ED Bed Request To Bed Occupy Time]60) % 60)// seconds + INT(AVG([ED Bed Request To Bed Occupy Time]60)/60) 100 //minutes
Current Patient Placement	Time Format Request to Assigned	Custom Calc	IIF(int(AVG([Bedrequested To Bedassigned Time]60)) % 60 == 60,0,AVG([Bedrequested To Bedassigned Time]60) % 60)// seconds + INT(AVG([Bedrequested To Bedassigned Time]60)/60) 100 //minutes
Current Patient Placement	Time Format Requested to Occupied	Custom Calc	IIF(int(AVG([Bedrequested To Bedoccupied Time]60)) % 60 == 60,0,AVG([Bedrequested To Bedoccupied Time]60) % 60)// seconds + INT(AVG([Bedrequested To Bedoccupied Time]60)/60) 100 //minutes
Current Patient Placement	Time Format RTM to Assigned	Custom Calc	IIF(int(AVG([Rtm To Bedassigned Time]60)) % 60 == 60,0,AVG([Rtm To Bedassigned Time]60) % 60)// seconds + INT(AVG([Rtm To Bedassigned Time]60)/60) 100 //minutes
Current Patient Placement	Time Format RTM to Occupied	Custom Calc	IIF(int(AVG([Rtm To Bedoccupied Time]60)) % 60 == 60,0,AVG([Rtm To Bedoccupied Time]60) % 60)// seconds + INT(AVG([Rtm To Bedoccupied Time]60)/60) 100 //minutes
Current Patient Placement	Unit Targeted Timestamp Enterprise	Root	The first date and time that the Targeted Unit was selected for the patient in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	Admit Source	Root	The latest admit source recorded in the patient visit record.
Current Patient Visit	Admit Timestamp	Root	The latest local admit date/time successfully processed by the HL7 interface or manually admitted in the application.
Current Patient Visit	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.
Current Patient Visit	Admitdatetime Utc	Root	The latest utc date/time the patient record was admitted to their initial home bed.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	BED_ADT_ID	Root	The bed ADT ID of the latest home location recorded for the patient.
Current Patient Visit	Campus	Root	The campus associated with the patient visit record when the record was created.
Current Patient Visit	Campus City	Root	The city in which the campus is located.
Current Patient Visit	Campus Id	System Calc	A unique identifier associated with campus. This field is not intended for client report building.
Current Patient Visit	Campus State	Root	The state in which the campus is located.
Current Patient Visit	Campus State Abbreviation	Root	The postal abbreviation for the state in which the campus is located.
Current Patient Visit	Campus Street	Root	The street on which the campus is located.
Current Patient Visit	Campus Zip Code	Root	The zip code in which the campus is located.
Current Patient Visit	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.
Current Patient Visit	Confirmed Discharge Timestamp	Root	The latest local date/time that the patient visit record was marked as confirmed discharge.
Current Patient Visit	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
Current Patient Visit	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.
Current Patient Visit	CONFIRMED_DISCHARGE_TIMESTAMP_UTC	Root	The latest utc date/time that the patient visit record was marked as confirmed discharge.
Current Patient Visit	Createddate	Root	Created Date in Local Time zone for when the record was entered.
Current Patient Visit	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.
Current Patient Visit	Createddate Utc	Root	Created Date in UTC Time zone for when the record was entered.
Current Patient Visit	Current Campus	Root	The campus name associated with the patient's latest current location.
Current Patient Visit	Current Discipline	Root	The discipline name associated with the patient's latest current location.
Current Patient Visit	Current Enterprise	Root	The enterprise name associated with the patient's latest current location.
Current Patient Visit	Current Location	Root	The location name for the latest current location associated with the patient vist record.
Current Patient Visit	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 Patient Visit	Current Unit	Root	The unit name of the unit associated with the patient's most recent current location.
Current Patient Visit	Current Unit Category	Root	The unit category name of the unit associated with the patient's most recent current location.
Current Patient Visit	CURRENT_BED_ADT_ID	Root	The bed ADT ID of the latest current location recorded for the patient.
Current Patient Visit	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 Patient Visit	CURRENT_CUSTOMER_FACILITY_ID	Root	The campus account ID value set in the campus settings associated with the patient's latest current location.
Current Patient Visit	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 Patient Visit	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 Patient Visit	CURRENT_ROOM_ADT_ID	Root	The room ADT ID of the latest current location recorded for the patient.
Current Patient Visit	CURRENT_UNIT_CATEGORY_CODE	System Calc	This field is not intended for client report building.
Current Patient Visit	CUSTOMER_FACILITY_ID	Root	The campus account ID value set in the campus settings for the campus the patient record was created in.
Current Patient Visit	Datepartition	System Calc	Non-strict dynamic partition column. This field is not intended for client report building.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	DISCHARGE_SOURCE_PRODUCT_NAME	Root	The discharge source product for each patient visit record: DischargeByADT, DischargeByBT, DischargeByTT, DischargeByOrchestrate, DischargeByTT, DischargeByUI.
Current Patient Visit	Discipline	Root	The discipline associate with the unit the patient's latest home location is in.
Current Patient Visit	Enterprise	Root	The name of the collection of campuses that the patient visit record was created in.
Current Patient Visit	Event Timestamp	System Calc	This field is not intended for client report building.
Current Patient Visit	EVENT_TIMESTAMP_ENTERPRISE	System Calc	This field is not intended for client report building.
Current Patient Visit	EVENT_TIMESTAMP_UTC	System Calc	This field is not intended for client report building.
Current Patient Visit	Expected Discharge Timestamp	Root	The latest projected discharge date/time in local time for the patient visit record
Current Patient Visit	EXPECTED_ADMIT_TIMESTAMP	Root	The latest expected admit date in local time for the patient visit record.
Current Patient Visit	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.
Current Patient Visit	EXPECTED_ADMIT_TIMESTAMP_UTC	Root	The latest expected admit date in UTC time for the patient visit record.
Current Patient Visit	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.
Current Patient Visit	EXPECTED_DISCHARGE_TIMESTAMP_UTC	Root	The latest projected discharge date/time in UTC time for the patient visit record.
Current Patient Visit	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
Current Patient Visit	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.
Current Patient Visit	Instanceid	System Calc	This field is not intended for client report building.
Current Patient Visit	Is Ever Admitted	Root	Indicates if the patient was ever admitted or not.
Current Patient Visit	Is Inhouse On Discharge	Root	Indicates that the patient was admitted to the facility prior to discharge.
Current Patient Visit	IS_INHOUSE_ON_DISCHARGE_BOOL	Root	Indicates that the patient was admitted to the facility prior to discharge.
Current Patient Visit	Isolation Type	Root	The code indicating the type of isolation that applies to the patient, such as Airborne, Droplet, Contact.
Current Patient Visit	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).
Current Patient Visit	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.
Current Patient Visit	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).
Current Patient Visit	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.
Current Patient Visit	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)
Current Patient Visit	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.
Current Patient Visit	LOCATION	Root	The latest home location name set for the patient visit record.
Current Patient Visit	LOCATION_ID	Root	The latest home location ID set for the patient visit record. This field is not intended for client report building.
Current Patient Visit	Number of Records	Root	The number of records in the data set. Each row in the data set = 1.
Current Patient Visit	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.
Current Patient Visit	Observation End Timestamp	Root	The latest observation end timestamp in local time.
Current Patient Visit	Observation Start Timestamp	Root	The latest observation start timestamp in local time.
Current Patient Visit	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.
Current Patient Visit	OBSERVATION_END_TIMESTAMP_UTC	Root	The latest observation end timestamp in UTC time.
Current Patient Visit	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.
Current Patient Visit	OBSERVATION_START_TIMESTAMP_UTC	Root	The latest observation start timestamp in UTC time.
Current Patient Visit	Patient Attribute Categories	Root	The type of patient attribute. For example, "Fall Risk".
Current Patient Visit	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.
Current Patient Visit	Patient Attributes With Category	Root	The custom attribute(s) associated with the patient’s visit and their category. This includes isolation attributes.
Current Patient Visit	Patient Diagnosis	Root	The latest admit diagnosis text associated with the patient visit record.
Current Patient Visit	Patient Dob	System Calc	Patient DOB in a string format. This field is not intended for client report building
Current Patient Visit	Patient Dob Timestamp	Root	The local date/time of the patient's date of birth.
Current Patient Visit	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.
Current Patient Visit	PATIENT_DOB_TIMESTAMP_UTC	Root	The UTC date/time of the patient's date of birth.
Current Patient Visit	Patient Firstname	Root	The first name of the person receiving medical treatment.
Current Patient Visit	Patient Gender	Root	The gender set in the patient visit record.
Current Patient Visit	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.
Current Patient Visit	Patient Lastname	Root	The last name of the person receiving medical treatment.
Current Patient Visit	Patient Level Of Care	Root	The degree of care that the patient requires, such as critical, acute, intermediate.
Current Patient Visit	Patient Mrn	Root	The medical record number for person receiving medical treatment.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	PATIENT_TYPE	Root	The patient type as set in the patient's record in Capacity IQ®.
Current Patient Visit	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
Current Patient Visit	Patient Visit Number	Root	The patient's External ID (ADT).
Current Patient Visit	Pending Discharge Timestamp	Root	The latest local date and time of day that the patient's status was set to Pending Discharge.
Current Patient Visit	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.
Current Patient Visit	PENDING_DISCHARGE_TIMESTAMP_UTC	Root	The latest utc date and time of day that the patient's status was set to Pending Discharge.
Current Patient Visit	Pending Discharge To Confirmed Discharge Time	Custom Calc	The latest local date that the patient's status was set to Pending Discharge.
Current Patient Visit	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
Current Patient Visit	PENDING_TRANSFER_TIMESTAMP	Root	The latest local date time when the job was marked as pending.
Current Patient Visit	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.
Current Patient Visit	PENDING_TRANSFER_TIMESTAMP_UTC	Root	The latest date and UTC time that a transport job was in an in pending status.
Current Patient Visit	ROOM_ADT_ID	Root	The Room ADT ID set in the location settings of the location the transport job took the patient to.
Current Patient Visit	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®.
Current Patient Visit	Location IQ®_TAG_ATTACH_TIMESTAMP	Root	The latest local date/time that and Location Tracking tag/badge was associated with the patient.
Current Patient Visit	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.
Current Patient Visit	Location IQ®_TAG_ATTACH_TIMESTAMP_UTC	Root	The latest utc date/time that and Location Tracking tag/badge was associated with the patient.
Current Patient Visit	Location IQ®_TAG_DETACH_TIMESTAMP	Root	The latest local date/time that and Location Tracking tag/badge was detached from the patient.
Current Patient Visit	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.
Current Patient Visit	Location IQ®_TAG_DETACH_TIMESTAMP_UTC	Root	The latest utc date/time that and Location Tracking tag/badge was detached from the patient.
Current Patient Visit	Location IQ®_TAG_UNIQUE_ID	Root	The unique identifier of an Location Tracking tag.
Current Patient Visit	SPEC_BED_ADT_ID	Root	The bed ADT ID of the latest specialty location the patient currently occupies.
Current Patient Visit	SPEC_CUSTOMER_FACILITY_ID	Root	The campus account ID of the campus associated with the latest occupied specialty location
Current Patient Visit	SPEC_FACILITY_ADT_ID	Root	The facility ADT ID of the latest specialty location the patient currently occupies.
Current Patient Visit	SPEC_LOCATION	Root	The name of the latest specialty location the patient currently occupies.
Current Patient Visit	SPEC_LOCATION_CAMPUS	Root	The name of the campus associated with the latest specialty location the patient currently occupies.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	SPEC_LOCATION_ENTERPRISE	Root	The name of the enterprise associated with the campus associated with the latest specialty location the patient currently occupies.
Current Patient Visit	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.
Current Patient Visit	SPEC_LOCATION_UNIT	Root	The name of the unit associated with the latest specialty location the patient currently occupies.
Current Patient Visit	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.
Current Patient Visit	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.
Current Patient Visit	SPEC_NURSESTATION_ADT_ID	Root	The nursing station ADT ID of the latest specialty location the patient currently occupies.
Current Patient Visit	SPEC_ROOM_ADT_ID	Root	The room ADT ID of the latest specialty location the patient currently occupies.
Current Patient Visit	Tenantid	System Calc	System calculation that is used in data partitioning. Not meant for client reporting.
Current Patient Visit	TRANSFER_TIMESTAMP	Root	The latest local date time of an ADT transfer processed by the integration engine for this patient visit.
Current 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.
Current Patient Visit	TRANSFER_TIMESTAMP_UTC	Root	The latest UTC date time of an ADT transfer processed by the integration engine for this patient visit.
Current Patient Visit	Triggered By	System Calc	This field is not intended for customer report building.
Current Patient Visit	Unit	Root	The unit that includes the latest home location which the patient physically occupied.
Current Patient Visit	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.
Current Patient Visit	UNIT_CATEGORY_CODE	System Calc	This field is not intended for customer report building.
Current Patient Visit	WAREHOUSEACQUISITIONDATE_UTC	System Calc	The latest timestamp that a record is inserted in Snowflake Data Warehouse in UTC format.
Current Transfer Milestones	Acquisitiondate UTC	Root	System calculation that allows us to see when the data was acquired in the source system.
Current Transfer Milestones	Campus	Root	The identification number of a collection of buildings in the enterprise.
Current Transfer Milestones	Campus ID	Root	The name of a collection of buildings in the enterprise.
Current Transfer Milestones	Cloudacquisitiondate UTC	Root	System calculation that allows us to see when the data was acquired in the cloud.
Current Transfer Milestones	Completed By First Name	Root	The first name of the user that completed the milestone.
Current Transfer Milestones	Completed By Last Name	Root	The last name of the user that completed the milestone.
Current Transfer Milestones	Createddate	Root	Date and time the milestone was initiated.
Current Transfer Milestones	Createddate Enterprise	Root	Date and time in enterprise time the milestone was initiated. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Createddate UTC	Root	Date and time in UTC the milestone was initiated.
Current Transfer Milestones	Datepartition	Root	Non-strict dynamic partition column.
Current Transfer Milestones	Delay End	Root	The date and time the milestone delay was completed.
Current Transfer Milestones	Delay End Enterprise	Root	The date and time in enterprise time the milestone delay was completed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Delay End UTC	Root	The date and time in UTC the milestone delay was completed.
Current Transfer Milestones	Delay Start	Root	The date and time the milestone was delayed.
Current Transfer Milestones	Delay Start Enterprise	Root	The date and time in enterprise time the milestone was delayed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Delay Start UTC	Root	The date and time in UTC the milestone was delayed.
Current Transfer Milestones	Delayed By Firstname	Root	The first name of the user that delayed the milestone.
Current Transfer Milestones	Delayed By Lastname	Root	The last name of the user that delayed the milestone.
Current Transfer Milestones	First Completed End	Root	The date and time of the first completion for a Transfer Milestone. Transfer Milestones can be started multiple times.
Current Transfer Milestones	First Completed End Enterprise	Root	The date and time in enterprise time of the first completion for a Transfer Milestone. Transfer Milestones can be started multiple times. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	First Completed End UTC	Root	The date and time in UTC of the first completion for a Transfer Milestone. Transfer Milestones can be started multiple times.
Current Transfer Milestones	First Completed First Name	Root	The first name of the agent who first completed the Transfer Milestone.
Current Transfer Milestones	First Completed Last Name	Root	The last name of the agent who first completed the Transfer Milestone.
Current Transfer Milestones	First Completed Start	Root	The date and time of the first start for a Transfer Milestone. Transfer Milestones can be started multiple times.
Current Transfer Milestones	First Completed Start Enterprise	Root	The date and time in enterprise time of the first start for a Transfer Milestone. Transfer Milestones can be started multiple times. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	First Completed Start UTC	Root	The date and time in UTC of the first start for a Transfer Milestone. Transfer Milestones can be started multiple times.
Current Transfer Milestones	First Ordered End	Root	The date and time the first order for a Transfer Milestone was ended.
Current Transfer Milestones	First Ordered End Enterprise	Root	The date and time in enterprise time the first order for a Transfer Milestone was ended. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	First Ordered End UTC	Root	The date and time in UTC the first order for a Transfer Milestone was ended.
Current Transfer Milestones	First Ordered First Name	Root	The first name of the agent who ordered the Transfer Milestone first.
Current Transfer Milestones	First Ordered Last Name	Root	The last name of the agent who ordered the Transfer Milestone first.
Current Transfer Milestones	First Ordered Start	Root	The date and time the first order for a Transfer Milestone was started.
Current Transfer Milestones	First Ordered Start Enterprise	Root	The date and time in enterprise time the first order for a Transfer Milestone was started. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	First Ordered Start UTC	Root	The date and time in UTC the first order for a Transfer Milestone was started.
Current Transfer Milestones	Home Location	Root	The name of the bed the patient is occupying.
Current Transfer Milestones	Home Location ID	Root	The unique identifier of the bed the patient is occupying.
Current Transfer Milestones	Hospital Service	Root	The latest hospital service recorded in the patient visit record. The type of treatment or surgery for the patient (e.g., Oncology, Obstetrics, Adolescent, or Cardiology) is called Hospital Service or Service Line.
Current Transfer Milestones	InstanceID	Root	The name of the instance GUID - Non-Strict Dynamic Partition Column.
Current Transfer Milestones	IS_VISIBLE	Root	Indicates if milestones related to Discharge and Transfer events should be visible or not. Milestones that are not visible will be removed from the Snowflake warehouse to eliminate report confusion.
Current Transfer Milestones	Last Completed End	Root	The date and time of the last completion for a Transfer Milestone. Transfer Milestones can be started multiple times.
Current Transfer Milestones	Last Completed End Enterprise	Root	The date and time in enterprise time of the last completion for a Transfer Milestone. Transfer Milestones can be started multiple times. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Last Completed End UTC	Root	The date and time in UTC of the last completion for a Transfer Milestone. Transfer Milestones can be started multiple times.
Current Transfer Milestones	Last Completed First Name	Root	The first name of the agent who last completed the Transfer Milestone.
Current Transfer Milestones	Last Completed Last Name	Root	The last name of the agent who last completed the Transfer Milestone.
Current Transfer Milestones	Last Completed Start	Root	The date and time of the last start for a Transfer Milestone. Transfer Milestones can be started multiple times.
Current Transfer Milestones	Last Completed Start Enterprise	Root	The date and time in enterprise time of the last start for a Transfer Milestone. Transfer Milestones can be started multiple times. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Last Completed Start UTC	Root	The date and time in UTC of the last start for a Transfer Milestone. Transfer Milestones can be started multiple times.
Current Transfer Milestones	Last Ordered End	Root	The date and time the last order for a Transfer Milestone was ended.
Current Transfer Milestones	Last Ordered End Enterprise	Root	The date and time in enterprise time the last order for a Transfer Milestone was ended. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Last Ordered End UTC	Root	The date and time in UTC the last order for a Transfer Milestone was ended.
Current Transfer Milestones	Last Ordered First Name	Root	The first name of the agent who ordered the Transfer Milestone last.
Current Transfer Milestones	Last Ordered Last Name	Root	The last name of the agent who ordered the Transfer Milestone last.
Current Transfer Milestones	Last Ordered Start	Root	The date and time the last order for a Transfer Milestone was started.
Current Transfer Milestones	Last Ordered Start Enterprise	Root	The date and time in enterprise time the last order for a Transfer Milestone was started. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Last Ordered Start UTC	Root	The date and time in UTC the last order for a Transfer Milestone was started.
Current Transfer Milestones	Latest Lastmoddate	Root	The date and time of the most recent update to the transfer milestone datasource in the local time zone.
Current Transfer Milestones	Latest Lastmoddate Enterprise	Root	The date and time of the most recent update to the transfer milestone datasource in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Latest Lastmoddate UTC	Root	The date and time of the most recent update to the transfer milestone datasource in UTC.
Current Transfer Milestones	Milestone ADT ID	Root	The unique identifier for the milestone ADT ID.
Current Transfer Milestones	Milestone Completed Date	Root	Date and time the milestone was completed.
Current Transfer Milestones	Milestone Completed Date Enterprise	Root	Date and time in enterprise time the milestone was completed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Milestone Completed Date UTC	Root	Date and time in UTC the milestone was completed.
Current Transfer Milestones	Milestone Delay Reason	Root	The reason the milestone was delayed.
Current Transfer Milestones	Milestone Delay Reason Code ID	Root	The unique identifier for the reason the milestone was delayed.
Current Transfer Milestones	Milestone Entity Type	Root	The type of milestone entity, such as Placement.
Current Transfer Milestones	Milestone Entity Type ID	Root	The unique identifier for the type of milestone entity, such as Placement.
Current Transfer Milestones	Milestone Group Type	Root	The milestone group type, such as Transfer or Discharge.
Current Transfer Milestones	Milestone Group ID	Root	The unique identifier for the milestone group type, such as Transfer or Discharge.
Current Transfer Milestones	Milestone ID	Root	Unique identifier for an individual milestone.
Current Transfer Milestones	Milestone Name	Root	Actual name of the milestone.
Current Transfer Milestones	Milestone Notes	Root	Displays the latest milestone note.
Current Transfer Milestones	Milestone Status Type	Root	The status of the milestone: ordered, in-progress, completed.
Current Transfer Milestones	Milestone Status Type ID	Root	The unique identifier of the status of the milestone.
Current Transfer Milestones	Origin Enterprise	Root	The name of a collection of campuses where the patient was located before being moved.
Current Transfer Milestones	ORIGIN_FACILITY_ADT_ID	System Calc	A unique identifier for an individual facility. This is the Facility ADT ID that is associated with the facility where the patient was located before being moved.
Current Transfer Milestones	ORIGIN_NURSESTATION_ADT_ID	System Calc	A unique identifier for an individual nurse station. This is the Nursestation ADT ID that is associated with the nursestation where the patient was located before moving.
Current Transfer Milestones	Origin Unit	Root	The unit that includes the bed where the patient was located before being moved.
Current Transfer Milestones	Origin Unit ID	Root	The unique identifier for the unit that includes the bed where the patient was located before being moved.
Current Transfer Milestones	Patient Admit Date Time	Root	Date and time the patient was admitted.
Current Transfer Milestones	Patient Admit Date Time Enterprise	Root	Date and time the patient was admitted in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Patient Confirm Discharge Date Time	Root	The latest date/time in local time zone the patient was moved into Confirmed Discharge Status.
Current Transfer Milestones	Patient Confirm Discharge Date Time Enterprise	Root	The latest date/time in enterprise time the patient was moved into Confirmed Discharge Status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Patient Confirm Discharge Date Time UTC	Root	The latest date/time in UTC the patient was moved into Confirmed Discharge Status.
Current Transfer Milestones	Patient Diagnosis	Root	The cause of the patient's disease or injury that is believed to be the primary reason that the patient needs medical attention at the current time.
Current Transfer Milestones	Patient Discharge Date Time	Root	The date and time the patient was actually discharged.
Current Transfer Milestones	Patient Discharge Date Time Enterprise	Root	The date and time in enterprise time the patient was actually discharged. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Patient Discharge Date Time UTC	Root	The date and time in UTC the patient was actually discharged.
Current Transfer Milestones	Patient Expected Discharge Date Time	Root	The date and time the patient was expected to be discharged.
Current Transfer Milestones	Patient Expected Discharge Date Time Enterprise	Root	The date and time in enterprise time the patient was expected to be discharged. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Patient Expected Discharge Date Time UTC	Root	The date and time in UTC the patient was expected to be discharged.
Current Transfer Milestones	Patient Firstname	Root	Patient's first name.
Current Transfer Milestones	Patient ID	Root	Unique identification number for the patient.
Current Transfer Milestones	Patient Lastname	Root	Patient's last name.
Current Transfer Milestones	Patient Level of Care	Root	The degree of care that the patient requires, such as critical, acute, intermediate.
Current Transfer Milestones	Patient Mrn	Root	The medical record number for the person receiving medical treatment.
Current Transfer Milestones	Patient Pending Transfer Date Time	Root	The date and time the transfer request was set to pending status.
Current Transfer Milestones	Patient Pending Transfer Date Time Enterprise	Root	The date and time in enterprise time the transfer request was set to pending status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Patient Pending Transfer Date Time UTC	Root	The date and time in UTC the transfer request was set to pending status.
Current Transfer Milestones	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.
Current Transfer Milestones	Patient Status Type Code	System Calc	The key that represents patient status of the patient during the visit. This field is used in standard content for multi-language support. This field is not intended for client report building.
Current Transfer Milestones	Patient Transfer Date Time	Root	The date and time the transfer actually occurred.
Current Transfer Milestones	Patient Transfer Date Time Enterprise	Root	The date and time in enterprise time the transfer actually occurred. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Patient Transfer Date Time UTC	Root	The date and time in UTC the transfer actually occurred.
Current Transfer Milestones	Patient Visit Number	Root	Patient's visit number/account number.
Current Transfer Milestones	Placement ID	Root	The unique identifier for a home location (bed) that is assigned to a patient in a health system.
Current Transfer Milestones	Placement Status	Root	The status of the placement such as, Requested, Assigned, Completed, Cancelled, or Unknown.
Current Transfer Milestones	Target Campus	Root	The intended campus that the transfer request will be completed in.
Current Transfer Milestones	Target Unit	Root	The intended unit that the transfer request will be completed in.
Current Transfer Milestones	Target Unit ID	Root	The unique identifier for the intended unit that the transfer request will be completed in.
Current Transfer Milestones	TenantID	Root	Tenant GUID - Non-Strict Dynamic Partition Column.
Current Transfer Milestones	Transfer Assignment Date Time	Root	The date and time that a bed request status changed to Assign.
Current Transfer Milestones	Transfer Assignment Date Time Enterprise	Root	The date and time in enterprise time that a bed request status changed to Assign. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Transfer Assignment Date Time UTC	Root	The date and time in UTC that a bed request status changed to Assign.
Current Transfer Milestones	Transfer Request Date Time	Root	The date and time that a transfer was first requested with a target unit selected.
Current Transfer Milestones	Transfer Request Date Time Enterprise	Root	The date and time in enterprise time that a transfer was first requested with a target unit selected. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Transfer Request Date Time UTC	Root	The date and time in UTC that a transfer was first requested with a target unit selected.
Current Transfer Milestones	Unit Category	Root	The grouping of units associated with the target unit selected for activated incoming Pre Admit and Transfer requests.
Current Transfer Milestones	Unit Name	Root	Name of the unit where the patient is currently located.
Current Transfer Milestones	Unit Targeted Timestamp	Root	The date and time that the Targeted Unit was selected for the patient.
Current Transfer Milestones	Unit Targeted Timestamp Enterprise	Root	The date and time that the Targeted Unit was selected for the patient in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current Transfer Milestones	Warehouseacquisitiondate UTC	Root	System calculation that allows us to see when the data was acquired into the data warehouse.
Current TransportTracking	ACQUISITIONDATE_UTC	Root	The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building.
Current TransportTracking	APPOINTMENT_TIMESTAMP	Root	Displays the local date and time of the Transport Appointment.
Current TransportTracking	APPOINTMENT_TIMESTAMP_ENTERPRISE	Root	Displays the enterprise date and time of the Transport Appointment. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	APPOINTMENT_TIMESTAMP_UTC	Root	Displays the UTC date and time of the Transport Appointment.
Current TransportTracking	ASSISTANCE_REQUESTED	Root	A flag indicating that the original transporter requested additional transporters to help complete the job.
Current TransportTracking	CANCELLED_BY_USER	Root	Displays the Transporter who cancelled the job.
Current TransportTracking	CANCELLED_BY_USER_LOGIN_ID	Root	The username of the user who cancelled the transport job.
Current TransportTracking	CANCELLED_REASON	Root	The value selected in the Reason for Cancel list when the transport request was cancelled.
Current TransportTracking	CANCELLED_TIMESTAMP	Root	The latest local date time when the job was marked as cancelled.
Current TransportTracking	CANCELLED_TIMESTAMP_ENTERPRISE	Root	The latest enterprise date time when the job was marked as cancelled. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	CANCELLED_TIMESTAMP_UTC	Root	The latest UTC date time when the job was marked as cancelled.
Current TransportTracking	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.
Current TransportTracking	Completed By User	Root	Name of the employee who set the transport job to a status of Completed.
Current TransportTracking	COMPLETED_BY_USER_LOGIN_ID	Root	The username of the user who completed the transport job.
Current TransportTracking	Completed Timestamp	Root	The latest local date time when the job was marked as completed.
Current TransportTracking	Completed Timestamp Enterprise	Root	The latest enterprise date time when the job was marked as completed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	Completed Timestamp Utc	Root	The latest utc date time when the job was marked as completed.
Current TransportTracking	Createddate	Root	The date and local time that a transport job was created in Capacity IQ®.
Current TransportTracking	Createddate Enterprise	Root	The date and enterprise time that a transport job was created. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	Createddate Utc	Root	The date and UTC time that a transport job was created.
Current TransportTracking	DATEPARTITION	Root	System calculation used internally to partition the data for efficient processing.
Current TransportTracking	DESTINATION_BED_ADT_ID	Root	The bed ADT ID set in the location settings of the location the transport job took the patient to.
Current TransportTracking	DESTINATION_BUILDING	Root	The physical structure within a facility where medical care is provided and where an item or patient was delivered for a transport job.
Current TransportTracking	Destination Campus	Root	The name of a collection of buildings in the enterprise associated with the location where an item or patient was delivered for a transport job. These are defined in the Enterprise information of the Capacity IQ® application.
Current TransportTracking	DESTINATION_CAMPUSID	Root	An internal campus database identifier. This field is not intended for report building.
Current TransportTracking	DESTINATION_CUSTOMER_FACILITY_ID	Root	The campus account ID associated with the location the transport job took the patient to. This value is set in the campus settings.
Current TransportTracking	DESTINATION_DISCIPLINE	Root	The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, or Burn where an item or patient was delivered for a transport job.
Current TransportTracking	DESTINATION_ENTERPRISE	Root	The name of the enterprise associated with the location where an item or patient was delivered for a transport job. These are defined in the Enterprise information of the Capacity IQ® application.
Current TransportTracking	DESTINATION_FACILITY_ADT_ID	Root	The Facility ADT ID for the destination location the transport job took the patient to.
Current TransportTracking	DESTINATION_FLOOR	Root	The floor of the unit that the destination location of the transport job is associated with.
Current TransportTracking	DESTINATION_LOCATION	Root	The identifier for the bed where an item or patient was delivered for a transport job.
Current TransportTracking	DESTINATION_LOCATION_ID	Root	An internal location database identifier. This field is not intended for report building.
Current TransportTracking	DESTINATION_LOCATION_TYPE	Root	The identifier for the bed type where an item or patient was delivered for a transport job.
Current TransportTracking	DESTINATION_LOCATION_TYPE_CODE	System Calc	The code for the bed type where an item or patient was delivered for a transport job. This field is not intended for client report building.
Current TransportTracking	DESTINATION_NURSESTATION_ADT_ID	Root	The Nursing Station ADT ID for the destination location the transport job took the patient to.
Current TransportTracking	DESTINATION_ROOM	Root	The location name for the bed where an item or patient was taken to for a transport job.
Current TransportTracking	DESTINATION_ROOM_ADT_ID	Root	The Room ADT ID set in the location settings of the location the transport job took the patient to.
Current TransportTracking	Destination Unit	Root	The unit associated with the location where an item or patient was delivered for a transport job.
Current TransportTracking	DESTINATION_UNIT_CATEGORY	System Calc	The unit category of the unit associated with the destination location of a transport job.
Current TransportTracking	DESTINATION_UNIT_CATEGORY_CODE	System Calc	The unit category code of the unit associated with the destination location of a transport job. This field is not intended for client report building.
Current TransportTracking	DIAGNOSIS	Root	The identity of the nature and cause of the patient's disease or injury.
Current TransportTracking	DISPATCHED_BY_USER	Root	Displays the Transporter who is set to Dispatch status for the job.
Current TransportTracking	DISPATCHED_BY_USER_LOGIN_ID	Root	Displays the Transporter username who is set to Dispatch status for the job.
Current TransportTracking	DISPATCHED_TIMESTAMP	Root	The latest local date time when the job was marked as dispatched.
Current TransportTracking	DISPATCHED_TIMESTAMP_ENTERPRISE	Root	The date and enterprise time that a transport job was dispatched in Capacity IQ®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	DISPATCHED_TIMESTAMP_UTC	Root	The date and UTC time that a transport job was dispatched in Capacity IQ®.
Current TransportTracking	DISPATCHED_TO_CANCELLED_TIME	Root	The total time for a transport job that was cancelled from when the job had a Dispatched status for the first time until it was in cancelled status, including any time that the job was in a Delay status. Dispatch_to_cancelled_Time is calculated as: 10:45 – 10:00 = 45 min. Calculation: cancelled Timestamp minus First Dispatched Timestamp.
Current TransportTracking	DISPATCHED_TO_COMPLETED_TIME	Root	The time that it took to transport the item or patient from when the job had a Dispatched status for the first time until it was in Completed status, including any time that the job was in a Delay status. Calculation: Completed Timestamp minus First Dispatched Timestamp.
Current TransportTracking	Dispatch To Completed Minutes	Root	The time that it took to transport the item or patient from when the job had a Dispatched status for the first time until it was in Completed status, including any time that the job was in a Delay status. Calculation: Completed Timestamp minus First Dispatched Timestamp.
Current TransportTracking	DOB	Root	The local date time of the date of birth of the person receiving medical treatment.
Current TransportTracking	EMPLOYEE_CATEGORY	Root	The employee category of the latest primary transporter on a transport job.
Current TransportTracking	EVENT_TIMESTAMP	Root	The latest local date time when the job was marked as pending.
Current TransportTracking	EVENT_TIMESTAMP_ENTERPRISE	Root	The latest enterprise date time when the job was marked as pending. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	EVENT_TIMESTAMP_UTC	Root	The latest utc date time when the job was marked as pending.
Current TransportTracking	FIRST_DELAY_REASON_CODE	Root	The initial reason that a transport job was delayed. Jobs that do not have a delay at time of appointment but have one added later will show a reason code of NULL, but the timestamp will still be collected.
Current TransportTracking	GENDER	Root	The gender marked in the patient visit record for the patient receiving the transport.
Current TransportTracking	GENDER_CODE	System Calc	The gender code marked in the patient visit record for the patient receiving the transport. This is a field used to assist with multi language deployment of teletracking standard content, and is not intended for client report building.
Current TransportTracking	Inprogress Timestamp	Root	The latest local date time when the job was marked as in-progress.
Current TransportTracking	Inprogress Timestamp Enterprise	Root	The latest enterprise date time when the job was marked as in-progress. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	Inprogress Timestamp Utc	Root	The latest UTC date time when the job was marked as in-progress.
Current TransportTracking	Inprogress To Completed Minutes	Root	The time in minutes that it took to transport an item or patient from when the job had an In Progress status for the first time until it was in Completed status, including any time that the job was in a Delay status. Calculation: Completed Timestamp minus First In Progress Timestamp.
Current TransportTracking	INPROGRESS_TO_COMPLETED_TIME	Root	The time that it took to transport the item or patient from when the job had an In Progress status for the first time until it was in Completed status, including any time that the job was in a Delay status. Calculation: Completed Timestamp minus First In Progress Timestamp.
Current TransportTracking	INSTANCEID	System Calc	System calculation used for data partitioning. It is not intended for client reporting.
Current TransportTracking	IS_ROUND_TRIP_JOB	Root	Displays true if the job is a round trip. A transporter might take a patient to a destination and then be asked to wait there briefly and then take the patient back. (For example, if a patient is having a test that takes five minutes, the lab technician might ask the transporter to wait during the test.) However, because of dispatching rules, if a new pending job is created, a different transporter might be assigned to take the patient back. If transporters who are asked to wait and take patients back have the Round Trips permission (assigned in the Admin Tool or Admin > Settings > Capacity Management component), then they can sign in to the IVR and enter a Round Trip option to assign themselves to take the patient back when the patient is ready. This will allow that transporter to return the patient to the origin location. When the code is entered, the original job is completed and a second job (to return the patient) is immediately created and assigned to the employee, in a status of Dispatched.
Current TransportTracking	Lastmoddate	Root	The local date of the most recent update to the transport job in the local time zone.
Current TransportTracking	Lastmoddate Enterprise	Root	The date of the most recent update to the transport job in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	Lastmoddate Utc	Root	The date of the most recent update to the transport job in UTC.
Current TransportTracking	LATEST_DELAY_REASON_CODE	Root	The last reason that a transport job was delayed. Jobs that do not have a delay at time of appointment but have one added later will show a reasoncode of NULL, but the timestamp will still be collected.
Current TransportTracking	LATEST_DELAY_TYPE	Root	Indicates if the latest delay type was recored while the transport job.
Current TransportTracking	LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP	Root	The local date and time that the latest assist delay ended while the job was in Dispatch status. This is a delay that is set by an assisting Transporter on the job.
Current TransportTracking	LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time that the latest assist delay ended while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	LATEST_DISPATCH_ASSIST_DELAY_END_TIMESTAMP_UTC	Root	The local date and time that the latest assist delay ended while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job.
Current TransportTracking	LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP	Root	The local date and time that the latest assist delay began while the job was in Dispatch status with an assistant transporter.
Current TransportTracking	LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time that the latest assist delay started while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	LATEST_DISPATCH_ASSIST_DELAY_START_TIMESTAMP_UTC	Root	The local date and time that the latest assist delay started while the job was in Dispatch status. This is a latest delay that is set after the required number of assisting transporters have joined the job.
Current TransportTracking	LATEST_DISPATCH_DELAY_END_TIMESTAMP	Root	The local date and time that the latest delay ended while the job was in Dispatch status.
Current TransportTracking	LATEST_DISPATCH_DELAY_END_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time that the latest assist delay ended while the job was in Dispatch status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	LATEST_DISPATCH_DELAY_END_TIMESTAMP_UTC	Root	The UTC date and time that the latest assist delay ended while the job was in Dispatch status.
Current TransportTracking	LATEST_DISPATCH_DELAY_START_TIMESTAMP	Root	The local date and time that the latest delay began while the job was in Dispatch status.
Current TransportTracking	LATEST_DISPATCH_DELAY_START_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time that the latest delay began while the job was in Dispatch status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	LATEST_DISPATCH_DELAY_START_TIMESTAMP_UTC	Root	The UTC date and time that the latest delay began while the job was in Dispatch status.
Current TransportTracking	LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP	Root	The local date and time that the latest assist delay ended while the job was in Inprogress status. This is a delay that is set by an assisting Transporter on the job.
Current TransportTracking	LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time that the latest assist delay ended while the job was in Inprogress status.The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This is a latest delay that is set after the required number of assisting transporters have joined the job.
Current TransportTracking	LATEST_INPROGRESS_ASSIST_DELAY_END_TIMESTAMP_UTC	Root	The UTC date and time that the latest assist delay ended while the job was in Inprogress status. This is a latest delay that is set after the required number of assisting transporters have joined the job.
Current TransportTracking	LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP	Root	The local date and time that the latest assist delay began while the job was in Inprogress status. This is a delay that is set by an assisting Transporter on the job.
Current TransportTracking	LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time that the latest assist delay started while the job was in In progress status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This is a latest delay that is set after the required number of assisting transporters have joined the job.
Current TransportTracking	LATEST_INPROGRESS_ASSIST_DELAY_START_TIMESTAMP_UTC	Root	The UTC account date and time that the latest assist delay started while the job was in In progress status. This is a latest delay that is set after the required number of assisting transporters have joined the job.
Current TransportTracking	LATEST_INPROGRESS_DELAY_END_TIMESTAMP	Root	The local date and time that the latest delay ended while the job was in Inprogress status.
Current TransportTracking	LATEST_INPROGRESS_DELAY_END_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time that the latest delay ended while the job was in Inprogress status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	LATEST_INPROGRESS_DELAY_END_TIMESTAMP_UTC	Root	The UTC date and time that the latest delay ended while the job was in Inprogress status.
Current TransportTracking	LATEST_INPROGRESS_DELAY_START_TIMESTAMP	Root	The local date and time that the latest delay began while the job was in Inprogress status.
Current TransportTracking	LATEST_INPROGRESS_DELAY_START_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time that the latest delay began while the job was in Inprogress status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	LATEST_INPROGRESS_DELAY_START_TIMESTAMP_UTC	Root	The UTC date and time that the latest delay began while the job was in Inprogress status.
Current TransportTracking	LATEST_LASTMODDATE_ENTERPRISE	Root	System calculation that displays the most recent update to the application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This field is not intended for client reporting.
Current TransportTracking	LATEST_LASTMODDATE_UTC	Root	System calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting.
Current TransportTracking	LATEST_RESCHEDULE_TIMESTAMP	Root	The local date and time of the latest reschedule for a job.
Current TransportTracking	LATEST_RESCHEDULE_TIMESTAMP_ENTERPRISE	Root	The enterprise date and time of the latest reschedule for an appointment job. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	LATEST_RESCHEDULE_TIMESTAMP_UTC	Root	The UTC date and time of the latest reschedule for an appointment job.
Current TransportTracking	MODE_OF_TRANSPORT	Root	The means by which the patient is transported, such as stretcher, wheelchair, ambulatory, bed. This is in the travel requirements of the transport job.
Current TransportTracking	MRN	Root	The medical record number associated with the patient record.
Current TransportTracking	Number of Records	Root	The number of transport jobs. Each row in the data set equals 1.
Current TransportTracking	ORIGIN_BED_ADT_ID	Root	The bed ADT ID set in the location settings of the location the transport job took the patient from.
Current TransportTracking	ORIGIN_BUILDING	Root	The physical structure within a facility where medical care is provided and where an item or patient was picked up for a transport job.
Current TransportTracking	Origin Campus	Root	The name of a collection of buildings in the enterprise that the origin location is associated with. This defined in the enterprise information of the Capacity IQ® application.
Current TransportTracking	ORIGIN_CAMPUSID	Root	An internal campus database identifier. This field is not intended for report building.
Current TransportTracking	ORIGIN_CUSTOMER_FACILITY_ID	Root	The campus account ID associated with the location the transport job took the patient from. This value is set in the campus settings.
Current TransportTracking	ORIGIN_DISCIPLINE	Root	The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn where an item or patient was picked up for a transport job.
Current TransportTracking	ORIGIN_ENTERPRISE	Root	The name of the enterprise associated with the location where an item or patient was picked up from for a transport job. These are defined in the Enterprise information of the Capacity IQ® application.
Current TransportTracking	ORIGIN_FACILITY_ADT_ID	Root	The Facility ADT ID for the origin location the transport job took the patient from.
Current TransportTracking	ORIGIN_FLOOR	Root	The floor of the unit that the origin location of the transport job is associated with.
Current TransportTracking	ORIGIN_LOCATION	Root	The location name for the bed where an item or patient was picked up for a transport job.
Current TransportTracking	ORIGIN_LOCATION_ID	System Calc	An internal location database identifier. This field is not intended for report building.
Current TransportTracking	ORIGIN_LOCATION_TYPE	Root	The identifier for the bed type where an item or patient was picked up for a transport job.
Current TransportTracking	ORIGIN_LOCATION_TYPE_CODE	System Calc	The code for the bed type where an item or patient was picked up for a transport job. This field is not intended for client report building.
Current TransportTracking	ORIGIN_NURSESTATION_ADT_ID	Root	The Nursing Station ADT ID for the origin location the transport job took the patient from.
Current TransportTracking	ORIGIN_ROOM	Root	The identifier for the room associated with the location where an item or patient was picked up for a transport job.
Current TransportTracking	ORIGIN_ROOM_ADT_ID	Root	The Room ADT ID set in the location settings of the location the transport job took the patient from.
Current TransportTracking	Origin Unit	Root	The unit associated with the location where the patient was located before being moved.
Current TransportTracking	ORIGIN_UNIT_CATEGORY	Root	The category of the unit associated with the origin location of the transport job.
Current TransportTracking	ORIGIN_UNIT_CATEGORY_CODE	System Calc	The category code of the unit associated with the origin location of the transport job. This field is intended for standard content language localization, and not intended for client report building.
Current TransportTracking	PATIENT_NAME	Root	The first and last name of the person receiving medical treatment.
Current TransportTracking	Pending Timestamp	Root	The latest local date time when the job was marked as pending.
Current TransportTracking	Pending Timestamp Enterprise	Root	The latest date and enterprise time that a transport job was in an in pending status in Capacity IQ®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking	Pending Timestamp Utc	Root	The latest date and UTC time that a transport job was in an in pending status in Capacity IQ®.
Current TransportTracking	Pending To Completed Minutes	Root	The time in minutes that it took to transport the item or patient from when the job had a Pending status until it was in Completed status, including any time that the job was in a Delay status. Pending_to_ Completed_Time is calculated as: 10:45 – 10:00 = 45 min. Calculation: Completed Timestamp minus First Pending Timestamp.
Current TransportTracking	PENDING_TO_COMPLETED_TIME	Root	The time that it took to transport the item or patient from when the job had a Pending status until it was in Completed status, including any time that the job was in a Delay status. Pending_to_ Completed_Time is calculated as: 10:45 – 10:00 = 45 min. Calculation: Completed Timestamp minus First Pending Timestamp.
Current TransportTracking	Pending To Dispatch Minutes	Root	The total duration in minutes from when a transport job was set to Pending status until it was set to a Dispatch status. Pending_to_Dispatch_Time is calculated as: 10:10 – 10:00 = 10 minutes Calculation: Dispatched Timestamp minus Pending Timestamp.
Current TransportTracking	PENDING_TO_DISPATCH_TIME	Root	The total duration in minutes from when a transport job was set to Pending status until it was set to a Dispatch status. Pending_to_Dispatch_Time is calculated as: 10:10 – 10:00 = 10 minutes Calculation: Dispatched Timestamp minus Pending Timestamp
Current TransportTracking	PENDING_TO_INPROGRESS_TIME	Root	The total duration in minutes from when a transport job was set to Pending status until it was set to Dispatch status. Calculation: Dispatched Timestamp minus Pending Timestamp
Current TransportTracking	RECHEDULED_REASON_CODE	Root	The reason that a job was rescheduled for a different date and time.
Current TransportTracking	Tenantid	Root	System calculation that is used in data partitioning. Not meant for client reporting.
Current TransportTracking	TOTAL_DELAY_TIME	Root	Sum of the duration for all delay statuses.
Current TransportTracking	TOTAL_INPROGRESS_TIME	Root	Sum of all Dispatch to In Progress times. Takes into account any delays in order to give an idea of total time in In Progress status for a job.
Current TransportTracking	TOTAL_TRANSPORTERS	Root	The total number of transporters that were actually involved in the transport job.
Current TransportTracking	TRAVEL_REQUIREMENT_1	Root	The first travel requirement for a job, such as "fall precaution, ventilator, bring therapy equipment."
Current TransportTracking	TRAVEL_REQUIREMENT_2	Root	The second travel requirement for a job, such as "fall precaution, ventilator, bring therapy equipment."
Current TransportTracking	TRAVEL_REQUIREMENT_3	Root	The third travel requirement for a job, such as "fall precaution, ventilator, bring therapy equipment."
Current TransportTracking	TRAVEL_REQUIREMENT_4	Root	The fourth travel requirement for a job, such as "fall precaution, ventilator, bring therapy equipment."
Current TransportTracking	Tt Job Id	Root	The identifier for a transport job. This job ID appears on the user interface.
Current TransportTracking	TT_JOB_STATUS	Root	The latest status that the transport job has. This includes: Appointment Cancel Complete Delay/Dispatch Delay/InProgress Dispatched InProgress Pending Possible Refer to the Capacity IQ® Transport help page for details about each status.
Current TransportTracking	TT_JOB_STATUS_CODE	System Calc	The latest status code that the transport job has. This is a field used to assist with multi language deployment of teletracking standard content, and is not intended for client report building.
Current TransportTracking	TT_JOB_TYPE	Root	What the transport job is transporting. This will either be an item type job, or a patient type job.
Current TransportTracking	VISIT_NUMBER	Root	The patient's External ID (ADT). This represents the visit number in the Capacity IQ® application.
Current TransportTracking	WAREHOUSEACQUISITIONDATE_UTC	System Calc	The latest timestamp that a record is inserted in Snowflake Data Warehouse in UTC format.
Current TransportTracking Employee Status	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.
Current TransportTracking Employee Status	BASE_CAMPUS	Root	The campus that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool.
Current TransportTracking Employee Status	BASE_CAMPUS_ADT_ID	System Calc	The ADT ID of the campus associated with user based on their base location.
Current TransportTracking Employee Status	BASE_CAMPUS_ID	System Calc	A system identifier for the base campus of the employee based on their base location, not visible to users of the application.
Current TransportTracking Employee Status	BASE_CUSTOMER_FACILITY_ID	Root	A unique identifier for a given campus that is defined in the Capacity IQ® campus settings for use with Transfer IQ® facility IDs—used more widely in DWC. This is the campus associated with the user's base location.
Current TransportTracking Employee Status	BASE_LOCATION	Root	The bed location that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool.
Current TransportTracking Employee Status	BASE_LOCATION_ADT_ID	System Calc	The ADT ID of the location associated with user based on their base location.
Current TransportTracking Employee Status	BASE_LOCATION_ID	System Calc	A system identifier for the base location of the employee, not visible to users of the application.
Current TransportTracking Employee Status	BASE_ROOM_ADT_ID	System Calc	The ADT ID of the room associated with user based on their base location.
Current TransportTracking Employee Status	BASE_UNIT	Root	The unit that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool.
Current TransportTracking Employee Status	BASE_UNIT_ADT_ID	System Calc	The ADT ID of the unit that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool.
Current TransportTracking Employee Status	BASE_UNIT_DISCIPLINE	Root	The name of the discipline that is associated with the unit that is associated with the user's base location. This a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn.
Current TransportTracking Employee Status	BASE_UNIT_DISCIPLINE_ID	System Calc	The IS of the discipline that is associated with the unit that is associated with the user's base location. This a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn.
Current TransportTracking Employee Status	BASE_UNIT_ID	System Calc	A system identifier for the base unit of the employee, not visible to users of the application.
Current TransportTracking Employee Status	CLOUDACQUISITIONDATE_UTC	System Calc	The second step in the data ingestion process that is used internally for latency calculations. This field is not intended for client report building.
Current TransportTracking Employee Status	EMPLOYEE_LOGIN_ID	System Calc	The unique username associated with the employee.
Current TransportTracking Employee Status	EMPLOYEE_NAME	Root	Full name (in the format of FN MI LN) of the employee
Current TransportTracking Employee Status	EMPLOYEE_STATUS_TIMESTAMP	Root	The latest date and local time of day when the employee status is updated
Current TransportTracking Employee Status	EMPLOYEE_STATUS_TIMESTAMP_ENTERPRISE	Root	The latest date and enterprise time of day when the employee status is updated. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
Current TransportTracking Employee Status	EMPLOYEE_STATUS_TIMESTAMP_UTC	Root	The latest date and UTC time of day when the employee status is updated
Current TransportTracking Employee Status	EMPLOYEE_STATUS_TYPE	Root	The status of the employee. Values can include: Dispatched, Delay/Dispatched, In Progress, Delay/In Progress, Assist, Break/Lunch, In, Available, Out
Current TransportTracking Employee Status	EMPLOYEE_STATUS_TYPE_CODE	System Calc	System calculation used for localization filtering that displays the Employee Status Type. This field is not intended for client report building.
Current TransportTracking Employee Status	EMPLOYEE_STATUS_TYPE_ID	System Calc	A system identifier for the Employee Status Type not visible to users of the application.
Current TransportTracking Employee Status	EMPLOYEE_USER_ID	System Calc	The id of the user. This field is not intended for client report building.
Current TransportTracking Employee Status	ENTERPRISE	Root	The name of a collection of campuses.
Current TransportTracking Employee Status	INSTANCEID	System Calc	System calculation used for data partitioning. This field is not intended for client reporting.
Current TransportTracking Employee Status	LASTMODDATE	System Calc	System calculation that displays the most recent update to the application database in local time. This field is not intended for client reporting.
Current TransportTracking Employee Status	LASTMODDATE_ENTERPRISE	System Calc	System calculation that displays the most recent update to the application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.This field is not intended for client reporting.
Current TransportTracking Employee Status	LASTMODDATE_UTC	System Calc	System calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting.
Current TransportTracking Employee Status	LATEST_LASTMODDATE	System Calc	System calculation that displays the most recent update to the application database in local time. This field is not intended for client reporting.
Current TransportTracking Employee Status	LATEST_LASTMODDATE_ENTERPRISE	System Calc	System calculation that displays the most recent update to the application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.This field is not intended for client reporting.
Current TransportTracking Employee Status	LATEST_LASTMODDATE_UTC	System Calc	System calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting.
Current TransportTracking Employee Status	TENANTID	System Calc	The unique identifier associated with the tenant. This field is not intended for client reporting.
Current TransportTracking Employee Status	WAREHOUSEACQUISITIONDATE_UTC	System Calc	The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format.
EVS Streaming	ACQUISITIONDATE_UTC	System Calc	The first step in the data ingestion process. It is used internally for latency calculations. This field is not intended for client report building.
EVS Streaming	Adjustable Clean Time Color	Custom Calc	A custom calculation used to determine colors/shapes for Clean Time best practices. It leverages the Clean Time Threshold parameter, which can be used to easily change thresholds.
EVS Streaming	Adjustable Clean Time Variance Calc	Custom Calc	A custom calculation that shows the percent difference of the clean time compared to the threshold.
EVS Streaming	Adjustable Overall Turn Color	Custom Calc	A custom calculation used to determine colors/shapes for Turn Time best practices. It leverages the Turn Time Threshold parameter, which can be used to easily change thresholds.
EVS Streaming	Adjustable Response Time Color	Custom Calc	A custom calculation used to determine colors/shapes for Response Time best practices. It leverages the Response Time Threshold parameter, which can be used to easily change thresholds.
EVS Streaming	Adjustable Response Time Variance Calc	Custom Calc	A custom calculation that shows the percent difference of the response time compared to the threshold.
EVS Streaming	Adjustable Turn Time Variance Calc	Custom Calc	A custom calculation that shows the percent difference of the turn time compared to the threshold.
EVS Streaming	Adjusted Cleans Flag	Root	A "Y" (yes) or "N" (no) value that shows bed cleaning jobs where clean time ≤5 minutes OR ≥ 60 minutes OR an original response ≥ 120 minutes. Calculation: Total In Progress Time ≤55 minutes OR > 60 minutes OR Response Time ≥120 minutes. This will not be applicable for Daily Cleans.
EVS Streaming	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 for the bed cleaning job. This field is helpful in DWC. This will not be applicable for Daily Cleans.
EVS Streaming	BED_COUNT	Root	The number of beds in the room associated with the Daily Clean job
EVS Streaming	BLOCKED_BED_REASON	Root	Displays the reason why a bed was blocked during the duration of the bed cleaning job. This will be the most recent reason code for a blocked bed status while it was being cleaned. For example, if a bed is blocked during the course of a bed cleaning job, we will record the most recent reason for the blocked status during that cleaning job. This will not be applicable for Daily Cleans.
EVS Streaming	BT Job ID	Root	The identifier assigned to the bed cleaning job that appears on the user interface.
EVS Streaming	BT_JOB_SOURCE	Root	The Job source is determined by how the job was created in the Capacity IQ^® application. Possible values include: Work Station - The job is created by an EVS user in a web browser. Handheld - The job is created by an EVS employee in the mobile application, typically through a found bed. Windows Service - The job is created through automated services, such as the HL7 Interface or Location IQ®. This will not be applicable for Daily Cleans.
EVS Streaming	BT_JOB_SOURCE_CODE	System Calc	Workstation - The job is created by an EVS user in a web browser. This will not be applicable for Daily Cleans.
EVS Streaming	BUILDING	Root	The physical structure where medical care is provided and which includes the bed that was cleaned.
EVS Streaming	BUILDING_ID	Root	The unique identifier for the building where the cleaning job took place.
EVS Streaming	Campus Name	Root	The name of the destination facility that accepts the transfer patient.
EVS Streaming	CAMPUS_ID	Root	The unique identifier for the campus where the cleaning job took place.
EVS Streaming	Cancelled Timestamp	Root	The date and local time of day when the bed cleaning job was cancelled.
EVS Streaming	Cancelled Timestamp Enterprise	Root	The date and time of day in enterprise time when the bed cleaning job was cancelled. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
EVS Streaming	Cancelled Timestamp UTC	Root	The date and time of day in UTC when the bed cleaning job was cancelled.
EVS Streaming	CANCELLED_BY_USER	Root	The user who cancelled the bed cleaning job.
EVS Streaming	CANCELLED_BY_USER_LOGIN_ID	System Calc	The unique username associated with the user who cancelled the bed cleaning job.
EVS Streaming	CANCELLED_REASON	Root	The reason indicated when a user cancels a bed cleaning job.
EVS Streaming	Clean Time	Custom Calc	The date difference in minutes between the inprogress timestamp and the completed timestamp.
EVS Streaming	CLOUDACQUISITIONDATE_UTC	Root	The second step in the data ingestion process that is used internally for latency calculations. This field is not intended for client report building.
EVS Streaming	Completed Timestamp	Root	The date and local time of day when a bed cleaning job was marked as complete.
EVS Streaming	Completed Timestamp Enterprise	Root	The date and enterprise time of day when a bed cleaning job was marked as complete. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
EVS Streaming	Completed Timestamp UTC	Root	The date and UTC time of day when a bed cleaning job was marked as complete.
EVS Streaming	COMPLETED_BY_USER	Root	The user who set the bed cleaning job to a Completed status.
EVS Streaming	COMPLETED_BY_USER_LOGIN_ID	System Calc	The unique username associated with the user who completed the bed cleaning job.
EVS Streaming	Created Timestamp	Root	The date and local time when a bed cleaning job was created in Capacity IQ^®.
EVS Streaming	Created Timestamp (copy)	Custom Calc	A version of the Created Timestamp that only displays the date (without the timestamp). This is useful in custom calculations where a timestamp is not needed.
EVS Streaming	Created Timestamp Enterprise	Root	The date and local enterprise time when a bed cleaning job was created in Capacity IQ^®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
EVS Streaming	Created Timestamp UTC	Root	The date and local UTC time when a bed cleaning job was created in Capacity IQ^®.
EVS Streaming	CREATEDDATE	Root	The date and local time when a bed cleaning job was created in Capacity IQ^®.
EVS Streaming	CREATEDDATE_ENTERPRISE	Root	The date and enterprise time when a bed cleaning job was created in Capacity IQ^®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
EVS Streaming	CREATEDDATE_UTC	Root	The date and local UTC time when a bed cleaning job was created in Capacity IQ^®.
EVS Streaming	CUSTOMER_FACILITY_ID	System Calc	A unique identifier for a given campus that is defined in the Capacity IQ^® campus settings for use with Transfer IQ® facility IDs—used more widely in DWC.
EVS Streaming	DATEPARTITION	System Calc	System calculation used internally to partition the data for efficient processing.
EVS Streaming	DELAY_TO_INPROGRESS	Root	It shows the time duration between the first delay and latest inprogress timestamp. This will not be applicable for Daily Cleans.
EVS Streaming	DISCIPLINE	Root	The discipline set on the unit for the location of the bed cleaning job. The name of a group of specially related units, such as Behavioral Health, Med/Surgical, and Burn Units.
EVS Streaming	DISCIPLINE_ID	System Calc	A system identifier for the unique discipline not visible to users of the application.
EVS Streaming	EMPLOYEE_CATEGORY	Root	The group assigned to an EVS employee who most recently updated the job status. For example, if the job was cancelled, this will show the employee category of the employee who cancelled the job.
EVS Streaming	ENTERPRISE	Root	The name of a collection of campuses that includes the bed that was cleaned.
EVS Streaming	ENTERPRISE_ID	System Calc	A system identifier for the unique enterprise not visible to users of the application.
EVS Streaming	EVENT_TIMESTAMP	Root	The date and local time that a bed cleaning job was created in Capacity IQ®.
EVS Streaming	EVENT_TIMESTAMP_ENTERPRISE	Root	The date and enterprise time that a bed cleaning job was created in Capacity IQ®. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
EVS Streaming	EVENT_TIMESTAMP_UTC	Root	The date and UTC time that a bed cleaning job was created in Capacity IQ®.
EVS Streaming	FACILITY_ADT_ID	System Calc	The Facility ADT ID in the location settings for a bed cleaning job—used in DWC for easier reporting.
EVS Streaming	FIRST_DELAY_REASON	Root	The initial reason that a bed cleaning job was delayed. This will not be applicable for Daily Cleans.
EVS Streaming	FIRST_DELAY_TIMESTAMP	Root	The first date and local time when a bed cleaning job was initially delayed. This will not be applicable for Daily Cleans.
EVS Streaming	FIRST_DELAY_TIMESTAMP_ENTERPRISE	Root	The first date and enterprise time when a bed cleaning job was initially delayed. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This will not be applicable for Daily Cleans.
EVS Streaming	FIRST_DELAY_TIMESTAMP_UTC	Root	The first date and UTC time when a bed cleaning job was initially delayed. This will not be applicable for Daily Cleans.
EVS Streaming	FIRST_SUSPENDED_REASON	Root	The initial reason that a bed cleaning job was suspended. This will not be applicable for Daily Cleans.
EVS Streaming	FIRST_SUSPENDED_TIMESTAMP	Root	The first date and local time when a bed cleaning job was initially suspended. This will not be applicable for Daily Cleans.
EVS Streaming	FIRST_SUSPENDED_TIMESTAMP_ENTERPRISE	Root	The first date and enterprise time when a bed cleaning job was initially suspended. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This will not be applicable for Daily Cleans.
EVS Streaming	FIRST_SUSPENDED_TIMESTAMP_UTC	Root	The first date and UTC time when a bed cleaning job was initially suspended. This will not be applicable for Daily Cleans.
EVS Streaming	FLOOR	Root	This field identifies the floor associated with the location of the bed cleaning job.
EVS Streaming	FLOOR_ID	System Calc	A system identifier for the unique floor not visible to users of the application.
EVS Streaming	In Progress Timestamp	Root	The latest date and local time of day when the bed cleaning job was set to an In Progress status. If a job was suspended and subsequently completed, this will display the more current In Progress Timestamp and not the initial one.
EVS Streaming	In Progress Timestamp Enterprise	Root	The latest date and enterprise time of day when the bed cleaning job was set to an In Progress status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. If a job was suspended and subsequently completed, this will display the more current In Progress Timestamp and not the initial one.
EVS Streaming	In Progress Timestamp UTC	Root	The latest date and UTC time of day when the bed cleaning job was set to an In Progress status. If a job was suspended and subsequently completed, this will display the more current In Progress Timestamp and not the initial one.
EVS Streaming	Initial Priority Status Type	Root	The initial location status for a bed cleaning job. Typically, this value will be Dirty, Stat, or Clean Next. This value could be Clean or Occupied if the job was a Found Bed or a Spill Clean. This will not be applicable for Daily Cleans.
EVS Streaming	Initial Priority Status Type (group)	Custom Calc	This is a custom group for our CC dashboards. The groupings include "Dirty" for dirty cleans, high priority includes "CleanNext" and "Stat," and "Other" for all other initial priority statuses.
EVS Streaming	Initial Priority Status Type Code	System Calc	The initial location status code for a bed cleaning job. This field is not intended for client report building. This will not be applicable for Daily Cleans.
EVS Streaming	INSTANCEID	System Calc	A system calculation used for data partitioning. It is not intended for client reporting.
EVS Streaming	IS_ADJUSTED_CLEAN	Root	A "true" or "false" value showing bed cleaning jobs where clean time ≤5 minutes OR ≥ 60 minutes OR an original response ≥ 120 minutes. Calculation: Total In Progress Time ≤55 minutes OR > 60 minutes OR Response Time ≥120 minutes. This will not be applicable for Daily Cleans.
EVS Streaming	IS_UDEF8	Root	If the latest location status for a bed cleaning job is "UDEF8," then this will be "true." Otherwise, it will be "false." This will not be applicable for Daily Cleans.
EVS Streaming	IS_UDEF9	Root	If the latest location status for a bed cleaning job is "UDEF9," then this will be "true." Otherwise, it will be "false." This will not be applicable for Daily Cleans.
EVS Streaming	ISOLATION_TYPE	Root	An isolation indicating the type of isolation that applies to the cleaning job, such as Airborne, Droplet, and Contact. This will not be applicable for Daily Cleans.
EVS Streaming	JOB_CREATE_REASON_TYPE	Root	The reason a bed cleaning job was created. The values for Bed Cleans and Spill Cleans include: Discharge - When the patient is discharged from the location. Transfer - When a patient is transferred to a different location that changes their home location. Found Bed - When an EVS employee puts a bed Inprogress using the Found Bed functionality. Other - When a cleaning request is created directly after releasing a blocked bed—when a patient has a bed request created while in a specialty location—any other scenario that does not match the other Job Create reason types. Cancel Admint - When an ADT message discharges a patient due to cancelling their admission. Spill - When a spill clean request is entered. Found Spill - When a spill clean request is entered by an EVS employee using the Found Spill functionality. For Daily Clean Jobs, the values are: Job Sweep, Supervisor Job Reopen
EVS Streaming	JOB_CREATE_REASON_TYPE_CODE	System Calc	System calculation used for localization filtering—displays the Job Create reason type. This field is not intended for client report building.
EVS Streaming	JOB_ID	Root	The identifier assigned to the bed cleaning job that appears on the user interface.
EVS Streaming	JOB_STATUS_TYPE	Root	The current status of a bed cleaning job - Complete, In Progress, Cancel, Pending, or Suspended. For Daily Cleans : To Do, In Progress, Clean, InComplete
EVS Streaming	JOB_STATUS_TYPE_CODE	System Calc	A system calculation used for localization filtering—displays the Job Status type. This field is not intended for client report building.
EVS Streaming	JOB_STATUS_TYPE_ID	System Calc	A system identifier for the Job Status type not visible to users of the application.
EVS Streaming	JOB_TYPE	Root	This field indicates if a cleaning job is for a Bed Clean, Spill Clean, MultiStage clean, or Daily clean.
EVS Streaming	JOB_TYPE_CODE	System Calc	A system calculation used for localization filtering—displays the job type. This field is not intended for client report building.
EVS Streaming	JOB_TYPE_ID	System Calc	A system identifier for the job type not visible to users of the application.
EVS Streaming	Lastmoddate	System Calc	A system calculation that displays the most recent update to the application database in local time. This field is not intended for client reporting.
EVS Streaming	Lastmoddate Enterprise	System Calc	A system calculation that displays the most recent update to the application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.This field is not intended for client reporting.
EVS Streaming	Lastmoddate UTC	System Calc	A system calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting.
EVS Streaming	LAST_UPGRADE_STATUS	Root	This field displays the latest upgrade status of a cleaning job's priority. This differs from the Initial Priority Status—includes Blocked, Clean Next, Next, Stat, Udef8, and Udef9. This will not be applicable for Daily Cleans.
EVS Streaming	LAST_UPGRADE_STATUS_CODE	System Calc	A system calculation used for localization filtering—displays the Last Upgrade Status. This field is not intended for client report building.
EVS Streaming	LAST_UPGRADE_STATUS_RESPONSE	Root	For cleaning jobs that have been upgraded to Stat or Clean Next, this shows the duration from the time of the upgrade to the response timestamp.
EVS Streaming	LATEST_LASTMODDATE_ENTERPRISE	System Calc	System calculation that displays the most recent update in enterprise time format to any of the data points in this data source. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This field is not intended for client reporting.
EVS Streaming	LATEST_LASTMODDATE_UTC	System Calc	System calculation that displays the most recent update in UTC format to any of the data points in this data source. This field is not intended for client reporting.
EVS Streaming	LOCATION	Root	The name of the bed that was cleaned.
EVS Streaming	LOCATION_ID	System Calc	A system identifier for the location not visible to users of the application.
EVS Streaming	Number of Records	Root	The number of rows in the database. Each row represents a different bed cleaning job.
EVS Streaming	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 for the bed cleaning job. This field is helpful in DWC.
EVS Streaming	Original Response Time	Root	It displays the time from the job creation to first response timestamp (the response timestamp could be in-progress or delayed).
EVS Streaming	OVERALL_TURNTIME	Root	Displays the time from the case created timestamp to the completed timestamp. This will not be applicable for Daily Clean Jobs because Daily Cleans sit for an extended periods of time.
EVS Streaming	OVERALL_TURN_TIME	Root	The total number of minutes from when a bed cleaning job was created until it was completed, including the duration in which the job was Suspended or Delayed. Jobs with a cancelled status are excluded. Calculation: Completed Timestamp minus Created Timestamp. This will not be applicable for Daily Cleans.
EVS Streaming	REOPENED_BY_USER	Root	The user who reopened the Daily Clean job.
EVS Streaming	REOPENED_BY_USER_LOGIN_ID	Root	The unique username associated with the user that reopened the daily clean job.
EVS Streaming	REOPENED_REASON	Root	The reason indicated when a user reopens a Daily Clean job.
EVS Streaming	REOPENED_TIMESTAMP	Root	The local date and time of day that the daily clean job was reopened.
EVS Streaming	REOPENED_TIMESTAMP_ENTERPRISE	Root	The date and time of day when the daily clean job was reopened in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.
EVS Streaming	REOPENED_TIMESTAMP_UTC	Root	The date and time of day that the daily clean job was reopened in UTC.
EVS Streaming	REQUESTER	Root	The name of the individual who requested a bed cleaning job.
EVS Streaming	REQUESTER_LOGIN_ID	System Calc	A username for the individual who requested the cleaning job.
EVS Streaming	Response Time	Custom Calc	Response Time = Datediff (minutes) between Initial Created Timestamp and Latest In Progress Timestamp. This will not be applicable for Daily Cleans.
EVS Streaming	Initial_Response_Time	Root	It displays the time from the job creation to first response timestamp (the response timestamp could be in-progress or delayed).
EVS Streaming	ROOM	Root	The name of the room where the bed cleaning job took place.
EVS Streaming	ROOM_ADT_ID	System Calc	A unique identifier for an individual room. This is the Room ADT ID that is associated with the location for the bed cleaning job. This field is helpful in DWC.
EVS Streaming	ROOM_ID	System Calc	A system identifier for the room not visible to users of the application.
EVS Streaming	SPILL_CLEAN_TYPE	Root	This field shows the specific type of spill clean, such as Bodily Fluids, Mop Job, and Coffee Spill. This will not be applicable for Daily Cleans.
EVS Streaming	Suspend Timestamp	Root	The latest date and local time when a bed cleaning job was suspended. This value will be overwritten with the latest suspend timestamp if there are multiple within a single job. This will not be applicable for Daily Cleans.
EVS Streaming	Suspend Timestamp Enterprise	Root	The latest date and enterprise time when a bed cleaning job was suspended. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. This value will be overwritten with the latest suspend timestamp if there are multiple within a single job. This will not be applicable for Daily Cleans.
EVS Streaming	Suspend Timestamp UTC	Root	The latest date and UTC time when a bed cleaning job was suspended. This value will be overwritten with the latest suspend timestamp if there are multiple within a single job. This will not be applicable for Daily Cleans.
EVS Streaming	SUSPEND_TO_INPROGRESS	Root	This field displays the duration from the first suspended timestamp to the latest in progress timestamp. This will not be applicable for Daily Cleans.
EVS Streaming	Tenant ID	System Calc	A system calculation that is used in data partitioning—not meant for client reporting.
EVS Streaming	TOTAL_INPROGRESS_TIME	Root	The sum of all time spent inprogress for a given cleaning job. If a job is delayed and resumed, the total inprogress time will only include the time spent inprogress on a job.
EVS Streaming	UDEF8	Root	If the latest location status for a bed cleaning job is "UDEF8," then this will be "Y." Otherwise, it will be "N." This will not be applicable for Daily Cleans.
EVS Streaming	UDEF9	Root	If the latest location status for a bed cleaning job is "UDEF9," then this will be "Y." Otherwise, it will be "N." This will not be applicable for Daily Cleans.
EVS Streaming	Unit Name	Root	The unit name for the location of a bed cleaning job.
EVS Streaming	UNIT_CATEGORY	Root	The grouping of units, which contains the unit where a bed cleaning job took place.
EVS Streaming	UNIT_CATEGORY_CODE	System Calc	A system calculation used for localization filtering—displays the Unit Category. This field is not intended for client report building.
EVS Streaming	UNIT_CATEGORY_ID	System Calc	A system identifier for the unit category not visible to users of the application.
EVS Streaming	UNIT_ID	System Calc	A system identifier for the unit not visible to users of the application.
EVS Streaming	Volume	Custom Calc	The number of bed cleaning jobs, which includes all bed cleaning jobs.
EVS Streaming	WAREHOUSEACQUISITIONDATE_UTC	System Calc	The latest time when a record/BT Job is inserted in the Snowflake Data Warehouse.
Data Source	Tableau Data Source Field	Folder	Description