Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Description |
N/A | 1 | Custom Calc | A custom calculation that marks each row in the dataset as 1 for aggregation purposes. Not intended for client report building. |
ACQUISITIONDATE_UTC | Acquisitiondate Utc | System Calc | The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
CAMPUS_ID | Campus Id | System Calc | The unique identifier of the campus where the patient was occupied. This field is not intended for client reporting. |
CAMPUS_NAME | Campus Name | Root | The name of the campus in which the patient was occupied. |
CLOUDACQUISITIONDATE_UTC | 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. |
COMPLETED_BY_FIRSTNAME | Completed By Firstname | Root | The first name of the user who completed the milestone. |
COMPLETED_BY_LASTNAME | Completed By Lastname | Root | The last name of the user who completed the milestone. |
CREATEDDATE | CREATEDDATE | Root | The latest local date time that 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. |
N/A | CREATEDDATE (Date Only) | Custom Calc | The latest local date that the discharge milestones are created. Discharge milestones are created when the patient enters a pending or confirmed discharge status, when we recieve a discharge milestone order, or when the discharge milestones are manually added to a patient record. |
CREATEDDATE_ENTERPRISE | CREATEDDATE_ENTERPRISE | Root | The latest enterprise date time when the discharge milestones are created. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. 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. |
CREATEDDATE_UTC | 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. |
CUSTOMER_FACILITY_ID | CUSTOMER_FACILITY_ID | Root | 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. |
DATEPARTITION | Datepartition | System Calc | System calculation used internally to partition the data for efficient processing. |
N/A | Delay Duration | Root | The sum number of minutes when a discharge delay reason was recorded. This field requires that a delay end date be present in order to calculate the duration. |
DELAY_END | 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. |
DELAY_END_ENTERPRISE | 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. |
DELAY_END_UTC | 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. |
DELAY_START | Delay Start | Root | The local date time when the delay was set for the discharge milestone. |
DELAY_START_ENTERPRISE | 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. |
DELAY_START_UTC | Delay Start Utc | Root | The UTC date time when the delay was set for the discharge milestone. |
DELAYED_BY_FIRSTNAME | Delayed By Firstname | Root | The first name of the user who delayed the milestone. |
DELAYED_BY_LASTNAME | Delayed By Lastname | Root | The last name of the user who delayed the milestone. |
FIRST_COMPLETED_USER_LOGIN_ID | FIRST_COMPLETED_USER_LOGIN_ID | Root | The username of the user who first marked an individual milestone as complete. |
FIRST_DELAY_USER_LOGIN_ID | FIRST_DELAY_USER_LOGIN_ID | Root | The username of the user who first set a delay reason on a milestone. |
FIRST_INPROGRESS_USER_LOGIN_ID | 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. |
FIRST_ORDERED_USER_LOGIN_ID | FIRST_ORDERED_USER_LOGIN_ID | Root | The initial user who created the discharge milestone. |
N/A | Help | Custom Calc | This is a field used by our standard content to affix a help link. Not intended for client report building. |
HOME_LOCATION | Home Location | Root | Name of the patient's latest home location. |
HOME_BED_ADT_ID | HOME_BED_ADT_ID | Root | The bed ADT ID value from the location settings associated with the patient's latest home bed. |
HOME_FACILITY_ADT_ID | HOME_FACILITY_ADT_ID | Root | The facility ADT ID value from the location settings associated with the patients latest home bed. |
HOME_LOCATION_ID | HOME_LOCATION_ID | System Calc | The database identifier of the patient's latest home location. This is not intended for client report building. |
HOME_NURSESTATION_ADT_ID | HOME_NURSESTATION_ADT_ID | Root | The nursing station ADT ID value from the location settings associated with the patient's latest home bed. |
HOME_ROOM_ADT_ID | HOME_ROOM_ADT_ID | Root | The room ADT ID value from the location settings associated with the patient's latest home bed. |
HOSPITAL_SERVICE | 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 | Instanceid | System Calc | System calculation used for data partitioning. It is not intended for client reporting. |
IS_VISIBLE | 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_USER_LOGIN_ID | LAST_COMPLETED_USER_LOGIN_ID | Root | The latest user who marked a discharge milestone as complete. |
LAST_DELAY_USER_LOGIN_ID | LAST_DELAY_USER_LOGIN_ID | Root | The latest user who set a delay on a discharge milestone. |
LAST_INPROGRESS_USER_LOGIN_ID | LAST_INPROGRESS_USER_LOGIN_ID | System Calc | This field is not intended for customer report building. Discharge milestones do not have an in progress status. |
LAST_ORDERED_USER_LOGIN_ID | LAST_ORDERED_USER_LOGIN_ID | Root | The latest user who created the discharge milestone. |
LASTMODDATE | Lastmoddate | Root | The date and time of the most recent update to the discharge milestone in the local time zone. |
LASTMODDATE_ENTERPRISE | 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. |
LASTMODDATE_UTC | Lastmoddate Utc | Root | The date and time of the most recent update to the discharge milestone in the UTC time zone. |
LATEST_LASTMODDATE_ENTERPRISE | 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. |
LATEST_LASTMODDATE_UTC | Latest Lastmoddate Utc | Root | The latest UTC date time when any of the dimensions or measures were updated. |
N/A | Length of Stay | Root | The difference in minutes between the patient's admit date/time and the patient's discharge date/time. |
MEDICAL_RECORD_NUMBER | Medical Record Number | Root | The medical record number for a person receiving medical treatment. |
MILESTONE_COMPLETED_DATE | Milestone Completed Date | Root | The latest date/time the milestone was marked as complete in local time. |
MILESTONE_COMPLETED_DATE_ENTERPRISE | Milestone Completed Date Enterprise | Root | The latest date/time when the milestone was marked as complete inenterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
MILESTONE_COMPLETED_DATE_UTC | Milestone Completed Date Utc | Root | The latest date/time when the milestone was marked as complete in UTC time. |
MILESTONE_DELAY_REASON | Milestone Delay Reason | Root | The latest reason the milestone was delayed. |
N/A | Milestone Duration | Root | The difference in minutes between the milestones created date/time and the milestone completed date/time. |
MILESTONE_ENTITY_TYPE | Milestone Entity Type | System Calc | This field is not intended for customer report building. |
MILESTONE_GROUP_TYPE | 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. |
MILESTONE_NAME | Milestone Name | Root | The name of the milestone as defined in dictionary management. |
MILESTONE_STATUS_TYPE | Milestone Status Type | Root | The status of the milestone: ordered, in-progress, and completed. |
MILESTONE_ENTITY_DETAIL_ID | MILESTONE_ENTITY_DETAIL_ID | System Calc | This field is not intended for customer report building. |
MILESTONE_NOTES | MILESTONE_NOTES | Root | Displays the latest milestone note. |
N/A | Number of Completed Milestones | Root | A distinct count of milestone completed date/times. |
N/A | Number of Delays | Root | A distinct count of milestone delay start date/times. |
N/A | Number of Milestones | Root | A distinct count of milestone created date/times. |
PATIENT_ADMIT_DATE_TIME | Patient Admit Date Time | Root | Date and local time when the patient was admitted. |
PATIENT_ADMIT_DATE_TIME_ENTERPRISE | Patient Admit Date Time Enterprise | Root | Date and enterprise time when the patient was admitted. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
PATIENT_ADMIT_DATE_TIME_UTC | Patient Admit Date Time Utc | Root | Date and UTC time when the patient was admitted. |
PATIENT_DIAGNOSIS | 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 | Patient Discharge Date Time | Root | Date and local time when the patient was discharged. |
PATIENT_DISCHARGE_DATE_TIME_ENTERPRISE | 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. |
PATIENT_DISCHARGE_DATE_TIME_UTC | Patient Discharge Date Time Utc | Root | Date and UTC time when the patient was discharged. |
PATIENT_FIRSTNAME | Patient Firstname | Root | The patient's first name. |
PATIENT_ID | Patient Id | System Calc | Unique identification number for the patient from the database. Not intended for client report building. |
PATIENT_LASTNAME | Patient Lastname | Root | The patient's last name. |
PATIENT_LEVEL_OF_CARE | Patient Level Of Care | Root | The degree of care that the patient requires, such as critical, acute, and intermediate, which is set in the patient's Capacity IQ® record. |
PATIENT_MIDDLE_INITIAL | Patient Middle Initial | Root | The patient's middle initial. |
PATIENT_MISC | Patient Misc | Root | The text from the Misc. field in the patient record in Capacity IQ®. |
PATIENT_TYPE | Patient Type | Root | The patient type as set in the patient's record in Capacity IQ®. |
PATIENT_VISIT_NUMBER | Patient Visit Number | Root | The patient's visit number/account number. |
PATIENT_CONFIRM_DISCHARGE_DATE_TIME | PATIENT_CONFIRM_DISCHARGE_DATE_TIME | Root | The latest local date/time when the patient was put into a confirmed discharge status. |
PATIENT_CONFIRM_DISCHARGE_DATE_TIME_ENTERPRISE | 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. |
PATIENT_CONFIRM_DISCHARGE_DATE_TIME_UTC | PATIENT_CONFIRM_DISCHARGE_DATE_TIME_UTC | Root | The latest UTC date/time when the patient was put into a confirmed discharge status. |
PATIENT_EXPECTED_DISCHARGE_DATE_TIME | PATIENT_EXPECTED_DISCHARGE_DATE_TIME | Root | The projected discharge local date time for the patient associated with the discharge milestone. |
PATIENT_EXPECTED_DISCHARGE_DATE_TIME_ENTERPRISE | 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. |
PATIENT_EXPECTED_DISCHARGE_DATE_TIME_UTC | PATIENT_EXPECTED_DISCHARGE_DATE_TIME_UTC | Root | The projected discharge UTC date time for the patient associated with the discharge milestone. |
PATIENT_PENDING_DISCHARGE_DATE_TIME | PATIENT_PENDING_DISCHARGE_DATE_TIME | Root | The latest local date/time when the patient was put into a pending discharge status. |
PATIENT_PENDING_DISCHARGE_DATE_TIME_ENTERPRISE | 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. |
PATIENT_PENDING_DISCHARGE_DATE_TIME_UTC | PATIENT_PENDING_DISCHARGE_DATE_TIME_UTC | Root | The latest UTC date/time when the patient was put into a pending discharge status. |
PATIENT_STATUS_TYPE | Patient Status Type | Root | The latest patient status type set on the patient record. The values can include ConfirmedDischarge, Discharged, InHouse, OutPatient, PendingDischarge, PendingTransfer, PreAdmit, VisitCanceled. |
PATIENT_STATUS_TYPE_CODE | Patient Status Type Code | System Calc | 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. |
N/A | Quarter of 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. |
TENANTID | Tenantid | System Calc | A unique ID that defines a specific client. Not intended for client report building. |
UNIT_ID | Unit Id | System Calc | The database identifier for the latest home unit associated with the patient. Not Intended for client report building. |
UNIT_NAME | Unit Name | Root | The name of the latest home unit associated with the patient. |
UNIT_CATEGORY | 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. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |
N/A | Year of 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. |