Data Points
Tableau Data Source Field | Folder | Description |
ACQUISITIONDATE_UTC | System Calc | The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
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 | Root | The name of the campus in which the patient was occupied. |
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 | Root | The first name of the user that completed the milestone. |
COMPLETED_BY_LASTNAME | Root | The last name of the user who completed the milestone. |
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. |
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. |
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 | 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. |
DATEPARTITION | System Calc | System calculation used internally to partition the data for efficient processing. |
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 | 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 | 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 | Root | The local date time when the delay was set for the discharge milestone. |
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 | Root | The UTC date time when the delay was set for the discharge milestone. |
DELAYED_BY_FIRSTNAME | Root | The first name of the user who delayed the milestone. |
DELAYED_BY_LASTNAME | Root | The last name of the user who delayed the milestone. |
ENTITY_ELEMENT_ID | System Calc | This field is not intended for customer report building. |
ESCALATION_LEVEL_TYPE_CODE | System Calc | This field is not intended for customer report building. Discharge milestones do not have an in progress status. |
ESCALATION_LEVEL_TYPE_NAME | System Calc | This field is not intended for customer report building. Discharge milestones do not have an in progress status. |
FIRST_COMPLETED_USER_LOGIN_ID | Root | The username of the user who first marked an individual milestone as complete. |
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 | 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 | Root | The intial user who created the discharge milestone. |
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 | Root | The facility ADT ID value from the location settings associated with the patient's latest home bed. |
HOME_LOCATION | Root | Name of the patient's latest home location. |
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 | Root | The nursing station ADT ID value from the location settings associated with the patient's latest home bed. |
HOME_ROOM_ADT_ID | Root | The room ADT ID value from the location settings associated with the patient's latest home bed. |
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 | System Calc | System calculation used for data partitioning. It is not intended for client reporting. |
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 | Root | The latest user who marked a discharge milestone as complete. |
LAST_DELAY_USER_LOGIN_ID | Root | The latest user who set a delay on a discharge milestone. |
LAST_INPROGRESS_USER_LOGIN_ID | System Calc | This field is not intended for customer report building. |
LAST_ORDERED_USER_LOGIN_ID | Root | The latest user who created the discharge milestone. |
LASTMODDATE | Root | The date and time of the most recent update to the discharge milestone in the local time zone. |
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 | Root | The date and time of the most recent update to the discharge milestone in the UTC time zone. |
LATEST_LASTMODDATE | Root | The latest local date time that any of the dimensions or measures were updated. |
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 | Root | The latest UTC date time when any of the dimensions or measures were updated. |
MEDICAL_RECORD_NUMBER | Root | The medical record number for a person receiving medical treatment. |
MILESTONE_ADT_ID | Root | The ADT ID of the discharge milestone. This field is used for interfacing updates to the appropriate discharge milestone. |
MILESTONE_COMPLETED_DATE | Root | The latest date/time when the milestone was marked as complete in local time. |
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. |
MILESTONE_COMPLETED_DATE_UTC | Root | The latest date/time when the milestone was marked as complete in UTC time. |
MILESTONE_DELAY_REASON | Root | The latest reason the milestone was delayed. |
MILESTONE_DELAY_REASON_CODE_ID | System Calc | This field is not intended for customer report building. |
MILESTONE_DISPLAY_STATUS_TYPE_CODE | System Calc | This field is not intended for customer report building. |
MILESTONE_ENTITY_DETAIL_ID | System Calc | This field is not intended for customer report building. |
MILESTONE_ENTITY_ID | System Calc | This field is not intended for customer report building. |
MILESTONE_ENTITY_TYPE | System Calc | This field is not intended for customer report building. |
MILESTONE_ENTITY_TYPE_CODE | System Calc | This field is not intended for customer report building. |
MILESTONE_ENTITY_TYPE_ID | System Calc | This field is not intended for customer report building. |
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_GROUP_TYPE_CODE | System Calc | This field is not intended for customer report building. |
MILESTONE_GROUP_TYPE_ID | System Calc | This field is not intended for customer report building. |
MILESTONE_ID | System Calc | This field is not intended for customer report building. |
MILESTONE_NAME | Root | The name of the milestone as defined in dictionary management. |
MILESTONE_NOTES | Root | Displays the latest milestone note. |
MILESTONE_STATUS_TYPE | Root | The status of the milestone: ordered, in-progress, and completed. |
MILESTONE_STATUS_TYPE_CODE | System Calc | This field is not intended for customer report building. |
MILESTONE_STATUS_TYPE_ID | System Calc | This field is not intended for customer report building. |
PATIENT_ADMIT_DATE_TIME | Root | Date and local time when the patient was admitted. |
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. |
PATIENT_ADMIT_DATE_TIME_UTC | Root | Date and UTC time when the patient was admitted. |
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 | 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 | Root | The latest UTC date/time when the patient was put into a 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 | Date and local time when the patient was discharged. |
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 | Root | Date and UTC time when the patient was discharged. |
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 | 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 | Root | The projected discharge UTC date time for the patient associated with the discharge milestone. |
PATIENT_FIRSTNAME | Root | Patient's first name. |
PATIENT_ID | System Calc | Unique identification number for the patient from the database. Not intended for client report building. |
PATIENT_LASTNAME | Root | Patient's last name. |
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. |
PATIENT_MIDDLE_INITIAL | Root | Patient's middle initial. |
PATIENT_MISC | Root | The text from the Misc. field in the patient record in Capacity IQ®. |
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 | 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 | Root | The latest UTC date/time when the patient was put into a pending discharge 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_TYPE | Root | The patient type as set in the patient's record in Capacity IQ®. |
PATIENT_VISIT_NUMBER | Root | The patient's visit number/account number. |
TENANTID | System Calc | A unique ID that defines a specific client. Not intended for client report building. |
Unit Id | System Calc | The database identifier for the latest home unit associated with the patient. Not Intended for client report building |
UNIT_CATEGORY | Root | The unit category associated with the latest home unit of the patient. The home unit is determined by the patient's home location. |
UNIT_CATEGORY_CODE | System Calc | This field is not intended for customer report building. |
UNIT_NAME | Root | The name of the latest home unit associated with the patient. |
WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest time when a record is inserted in the Snowflake Data Warehouse. |