Data Points
Tableau Data Source Field | Folder | Description |
Acquisitiondate UTC | Root | System calculation that allows us to see when the data was acquired in the source system. |
Campus | Root | The identification number of a collection of buildings in the enterprise. |
Campus ID | Root | The name of a collection of buildings in the enterprise. |
Cloudacquisitiondate UTC | Root | System calculation that allows us to see when the data was acquired in the cloud. |
Completed By First Name | Root | The first name of the user that completed the milestone. |
Completed By Last Name | Root | The last name of the user that completed the milestone. |
Createddate | Root | Date and time the milestone was initiated. |
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. |
Createddate UTC | Root | Date and time in UTC the milestone was initiated. |
Datepartition | Root | Non-strict dynamic partition column. |
Delay End | Root | The date and time the milestone delay was completed. |
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. |
Delay End UTC | Root | The date and time in UTC the milestone delay was completed. |
Delay Start | Root | The date and time the milestone was delayed. |
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. |
Delay Start UTC | Root | The date and time in UTC the milestone was delayed. |
Delayed By Firstname | Root | The first name of the user that delayed the milestone. |
Delayed By Lastname | Root | The last name of the user that delayed the milestone. |
First Completed End | Root | The date and time of the first completion for a Transfer Milestone. Transfer Milestones can be started multiple times. |
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. |
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. |
First Completed First Name | Root | The first name of the agent who first completed the Transfer Milestone. |
First Completed Last Name | Root | The last name of the agent who first completed the Transfer Milestone. |
First Completed Start | Root | The date and time of the first start for a Transfer Milestone. Transfer Milestones can be started multiple times. |
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. |
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. |
First Ordered End | Root | The date and time the first order for a Transfer Milestone was ended. |
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. |
First Ordered End UTC | Root | The date and time in UTC the first order for a Transfer Milestone was ended. |
First Ordered First Name | Root | The first name of the agent who ordered the Transfer Milestone first. |
First Ordered Last Name | Root | The last name of the agent who ordered the Transfer Milestone first. |
First Ordered Start | Root | The date and time the first order for a Transfer Milestone was started. |
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. |
First Ordered Start UTC | Root | The date and time in UTC the first order for a Transfer Milestone was started. |
Home Location | Root | The name of the bed the patient is occupying. |
Home Location ID | Root | The unique identifier of the bed the patient is occupying. |
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. |
InstanceID | Root | The name of the instance GUID - Non-Strict Dynamic Partition Column. |
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. |
Last Completed End | Root | The date and time of the last completion for a Transfer Milestone. Transfer Milestones can be started multiple times. |
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. |
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. |
Last Completed First Name | Root | The first name of the agent who last completed the Transfer Milestone. |
Last Completed Last Name | Root | The last name of the agent who last completed the Transfer Milestone. |
Last Completed Start | Root | The date and time of the last start for a Transfer Milestone. Transfer Milestones can be started multiple times. |
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. |
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. |
Last Ordered End | Root | The date and time the last order for a Transfer Milestone was ended. |
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. |
Last Ordered End UTC | Root | The date and time in UTC the last order for a Transfer Milestone was ended. |
Last Ordered First Name | Root | The first name of the agent who ordered the Transfer Milestone last. |
Last Ordered Last Name | Root | The last name of the agent who ordered the Transfer Milestone last. |
Last Ordered Start | Root | The date and time the last order for a Transfer Milestone was started. |
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. |
Last Ordered Start UTC | Root | The date and time in UTC the last order for a Transfer Milestone was started. |
Latest Lastmoddate | Root | The date and time of the most recent update to the transfer milestone datasource in the local time zone. |
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. |
Latest Lastmoddate UTC | Root | The date and time of the most recent update to the transfer milestone datasource in UTC. |
Milestone ADT ID | Root | The unique identifier for the milestone ADT ID. |
Milestone Completed Date | Root | Date and time the milestone was completed. |
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. |
Milestone Completed Date UTC | Root | Date and time in UTC the milestone was completed. |
Milestone Delay Reason | Root | The reason the milestone was delayed. |
Milestone Delay Reason Code ID | Root | The unique identifier for the reason the milestone was delayed. |
Milestone Entity Type | Root | The type of milestone entity, such as Placement. |
Milestone Entity Type ID | Root | The unique identifier for the type of milestone entity, such as Placement. |
Milestone Group Type | Root | The milestone group type, such as Transfer or Discharge. |
Milestone Group ID | Root | The unique identifier for the milestone group type, such as Transfer or Discharge. |
Milestone ID | Root | Unique identifier for an individual milestone. |
Milestone Name | Root | Actual name of the milestone. |
Milestone Notes | Root | Displays the latest milestone note. |
Milestone Status Type | Root | The status of the milestone: ordered, in-progress, completed. |
Milestone Status Type ID | Root | The unique identifier of the status of the milestone. |
Origin Enterprise | Root | The name of a collection of campuses where the patient was located before being moved. |
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. |
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. |
Origin Unit | Root | The unit that includes the bed where the patient was located before being moved. |
Origin Unit ID | Root | The unique identifier for the unit that includes the bed where the patient was located before being moved. |
Patient Admit Date Time | Root | Date and time the patient was admitted. |
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. |
Patient Confirm Discharge Date Time | Root | The latest date/time in local time zone the patient was moved into Confirmed Discharge Status. |
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. |
Patient Confirm Discharge Date Time UTC | Root | The latest date/time in UTC the patient was moved into Confirmed Discharge Status. |
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. |
Patient Discharge Date Time | Root | The date and time the patient was actually discharged. |
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. |
Patient Discharge Date Time UTC | Root | The date and time in UTC the patient was actually discharged. |
Patient Expected Discharge Date Time | Root | The date and time the patient was expected to be discharged. |
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. |
Patient Expected Discharge Date Time UTC | Root | The date and time in UTC the patient was expected to be discharged. |
Patient Firstname | Root | Patient's first name. |
Patient ID | Root | Unique identification number for the patient. |
Patient Lastname | Root | Patient's last name. |
Patient Level of Care | Root | The degree of care that the patient requires, such as critical, acute, intermediate. |
Patient Mrn | Root | The medical record number for the person receiving medical treatment. |
Patient Pending Transfer Date Time | Root | The date and time the transfer request was set to pending status. |
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. |
Patient Pending Transfer Date Time UTC | Root | The date and time in UTC the transfer request was set to pending status. |
Patient Status Type | Root | The latest patient status type set on the patient record. The values can include ConfirmedDischarge, Discharged, InHouse, OutPatient, PendingDischarge, PendingTransfer, PreAdmit, VisitCanceled. |
Patient Status Type Code | System Calc | 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. |
Patient Transfer Date Time | Root | The date and time the transfer actually occurred. |
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. |
Patient Transfer Date Time UTC | Root | The date and time in UTC the transfer actually occurred. |
Patient Visit Number | Root | Patient's visit number/account number. |
Placement ID | Root | The unique identifier for a home location (bed) that is assigned to a patient in a health system. |
Placement Status | Root | The status of the placement such as, Requested, Assigned, Completed, Cancelled, or Unknown. |
Target Campus | Root | The intended campus that the transfer request will be completed in. |
Target Unit | Root | The intended unit that the transfer request will be completed in. |
Target Unit ID | Root | The unique identifier for the intended unit that the transfer request will be completed in. |
TenantID | Root | Tenant GUID - Non-Strict Dynamic Partition Column. |
Transfer Assignment Date Time | Root | The date and time that a bed request status changed to Assign. |
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. |
Transfer Assignment Date Time UTC | Root | The date and time in UTC that a bed request status changed to Assign. |
Transfer Request Date Time | Root | The date and time that a transfer was first requested with a target unit selected. |
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. |
Transfer Request Date Time UTC | Root | The date and time in UTC that a transfer was first requested with a target unit selected. |
Unit Category | Root | The grouping of units associated with the target unit selected for activated incoming Pre Admit and Transfer requests. |
Unit Name | Root | Name of the unit where the patient is currently located. |
Unit Targeted Timestamp | Root | The date and time that the Targeted Unit was selected for the patient. |
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. |
Warehouseacquisitiondate UTC | Root | System calculation that allows us to see when the data was acquired into the data warehouse. |