Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Description |
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. |
ADMIT_SOURCE | ADMIT_SOURCE | Root | The latest admit source recorded in the patient visit record. |
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. |
CARE_TYPE_NAME | CARE_TYPE_NAME | Root | The name of the campus in which the patient was occupied. |
CARE_TYPE_NOTES | CARE_TYPE_NOTES | Root | The name of the Care Type as defined in Care Progression Group setup. |
CARE_TYPE_COMPLETED_DATE | CARE_TYPE_COMPLETED_DATE | Root | The latest date/time the care type was marked as complete in local time. |
CARE_TYPE_COMPLETED_DATE_ENTERPRISE | 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. |
CARE_TYPE_COMPLETED_DATE_UTC | CARE_TYPE_COMPLETED_DATE_UTC | Root | The latest date/time the care type was marked as complete in UTC time. |
CLOUDACQUISITIONDATE_UTC | CLOUDACQUISITIONDATE_UTC | System Calc | The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
COMPLETED_BY_FIRSTNAME | COMPLETED_BY_FIRSTNAME | Root | The first name of the user that completed the care type. |
COMPLETED_BY_LASTNAME | COMPLETED_BY_LASTNAME | Root | The last name of the user that completed the care type. |
CPI_GROUP_ADT_ID | CPI_GROUP_ADT_ID | System Calc | The unique ADT identifier assigned to the care type in dictionary management that is used in EMR messages. |
CPI_GROUP_NAME | CPI_GROUP_NAME | Root | The name of the care progression indicators group associated with the care types ordered for the patient. |
CPI_GROUP_STATUS_TYPE | CPI_GROUP_STATUS_TYPE | Root | The latest status of a care type in the care progression group. This includes Ordered, In progress, and Completed. |
CREATEDDATE | CREATEDDATE | Root | The local date time that the care type for the patient is created. |
CREATEDDATE_ENTERPRISE | 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. |
CREATEDDATE_UTC | CREATEDDATE_UTC | Root | The date and time of when the care type of the patient was created in UTC timezone. |
CUSTOMER_FACILITY_ID | 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 | DATEPARTITION | System Calc | System calculation used internally to partition the data for efficient processing. |
ENTITY_ELEMENT_ID | 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 |
FIRST_COMPLETED_END | FIRST_COMPLETED_END | Root | The initial timestamp when the care type ended ‘Completed’ status, in local timezone. |
FIRST_COMPLETED_END_ENTERPRISE | 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. |
FIRST_COMPLETED_END_UTC | FIRST_COMPLETED_END_UTC | Root | The initial timestamp when the care type ended ‘Completed’ status, in UTC timezone. |
FIRST_COMPLETED_FIRST_NAME | FIRST_COMPLETED_FIRST_NAME | Root | Displays the first name of the user who first completed the care type in the progression. |
FIRST_COMPLETED_LAST_NAME | FIRST_COMPLETED_LAST_NAME | Root | Displays last name of the user who first completed the care type in the progression. |
FIRST_COMPLETED_START | FIRST_COMPLETED_START | Root | The initial timestamp when the Care Type entered the 'Completed' status, displayed in the local timezone. |
FIRST_COMPLETED_START_ENTERPRISE | 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. |
FIRST_COMPLETED_START_UTC | FIRST_COMPLETED_START_UTC | Root | The initial timestamp when the Care Type entered the 'Completed' status, displayed in the UTC timezone. |
FIRST_COMPLETED_USER_LOGIN_ID | FIRST_COMPLETED_USER_LOGIN_ID | System Calc | The username of the user who first marked the care type as complete. |
FIRST_INPROGRESS_END | FIRST_INPROGRESS_END | Root | The initial timestamp when the Care Type ended the 'In Progress' status, displayed in the local timezone. |
FIRST_INPROGRESS_END_ENTERPRISE | 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. |
FIRST_INPROGRESS_END_UTC | FIRST_INPROGRESS_END_UTC | Root | The initial timestamp when the Care Type ended the 'In Progress' status, displayed in the UTC timezone. |
FIRST_INPROGRESS_FIRST_NAME | FIRST_INPROGRESS_FIRST_NAME | Root | The first name of the user who initially moved the care type to ‘In Progress’ status. |
FIRST_INPROGRESS_LAST_NAME | FIRST_INPROGRESS_LAST_NAME | Root | The last name of the user who initially moved the care type to ‘In Progress’ status. |
FIRST_INPROGRESS_START | FIRST_INPROGRESS_START | Root | The initial timestamp when the Care Type entered the 'In Progress' status, displayed in the local timezone. |
FIRST_INPROGRESS_START_ENTERPRISE | 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. |
FIRST_INPROGRESS_START_UTC | FIRST_INPROGRESS_START_UTC | Root | The initial timestamp when the Care Type entered the 'In Progress' status, displayed in the UTC timezone. |
FIRST_INPROGRESS_USER_LOGIN_ID | FIRST_INPROGRESS_USER_LOGIN_ID | System Calc | The username of the user who first marked the care type as ‘In Progress’. |
FIRST_ORDERED_END | FIRST_ORDERED_END | Root | The initial timestamp when the Care Type ended the 'Ordered' status, displayed in the local timezone. |
FIRST_ORDERED_END_ENTERPRISE | 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. |
FIRST_ORDERED_END_UTC | FIRST_ORDERED_END_UTC | Root | The initial timestamp when the Care Type ended the 'Ordered' status, displayed in the UTC timezone. |
FIRST_ORDERED_FIRST_NAME | FIRST_ORDERED_FIRST_NAME | Root | The first name of the user who initially moved the care type to ‘Ordered’ status. |
FIRST_ORDERED_LAST_NAME | FIRST_ORDERED_LAST_NAME | Root | The first name of the user who initially moved the care type to ‘Ordered’ status. |
FIRST_ORDERED_START | FIRST_ORDERED_START | Root | The initial timestamp when the Care Type entered the 'Ordered' status, displayed in the local timezone. |
FIRST_ORDERED_START_ENTERPRISE | 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. |
FIRST_ORDERED_START_UTC | FIRST_ORDERED_START_UTC | Root | The initial timestamp when the Care Type entered the 'Ordered' status, displayed in the UTC timezone. |
FIRST_ORDERED_USER_LOGIN_ID | FIRST_ORDERED_USER_LOGIN_ID | System Calc | The username of the user who first marked the care type as ‘Ordered’. |
GROUP_TOP_LEVEL_MILESTONE_ID | 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 |
HOME_BED_ADT_ID | HOME_BED_ADT_ID | System Calc | The bed ADT ID value from the location settings associated with the patient's latest home bed location. |
HOME_FACILITY_ADT_ID | HOME_FACILITY_ADT_ID | System Calc | The facility ADT ID value from the location settings associated with the patients latest home bed location. |
HOME_LOCATION | HOME_LOCATION | Root | Name of the patient's latest home location. |
HOME_LOCATION_ID | 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. |
HOME_NURSESTATION_ADT_ID | 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. |
HOME_ROOM_ADT_ID | HOME_ROOM_ADT_ID | System Calc | The room ADT ID value from the location settings associated with the patient's latest home bed location. |
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 | Unique identifier of the Capacity IQ® instance used for data partitioning. It is not intended for client reporting. |
LAST_COMPLETED_END | LAST_COMPLETED_END | Root | The latest timestamp when the Care Type ended the 'Completed' status, displayed in local timezone. |
LAST_COMPLETED_END_ENTERPRISE | 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. |
LAST_COMPLETED_END_UTC | LAST_COMPLETED_END_UTC | Root | The latest timestamp when the Care Type ended the 'Completed' status, displayed in UTC timezone. |
LAST_COMPLETED_FIRST_NAME | LAST_COMPLETED_FIRST_NAME | Root | The first name of the user who recently moved the care type to ‘Completed’ status. |
LAST_COMPLETED_LAST_NAME | LAST_COMPLETED_LAST_NAME | Root | The last name of the user who recently moved the care type to ‘Completed’ status. |
LAST_COMPLETED_START | LAST_COMPLETED_START | Root | The latest timestamp when the Care Type entered the 'Completed' status, displayed in local timezone. |
LAST_COMPLETED_START_ENTERPRISE | LAST_COMPLETED_START_ENTERPRISE | Root | The latest timestamp when the Care Type entered the 'Completed' status, displayed in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LAST_COMPLETED_START_UTC | LAST_COMPLETED_START_UTC | Root | The latest timestamp when the Care Type entered the 'Completed' status, displayed in UTC timezone. |
LAST_COMPLETED_USER_LOGIN_ID | LAST_COMPLETED_USER_LOGIN_ID | System Calc | The username of the user who recently marked the care type as ‘Completed'. |
LAST_DELAY_END | LAST_DELAY_END | Root | The timestamp when the most recent delay of the Care Type ended, displayed in local timezone. |
LAST_DELAY_END_ENTERPRISE | 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. |
LAST_DELAY_END_UTC | LAST_DELAY_END_UTC | Root | The timestamp when the most recent delay of the Care Type ended, displayed in UTC timezone. |
LAST_DELAY_FIRST_NAME | LAST_DELAY_FIRST_NAME | Root | The first name of the user that most recently delayed the care type. |
LAST_DELAY_LAST_NAME | LAST_DELAY_LAST_NAME | Root | The last name of the user that most recently delayed the care type. |
LAST_DELAY_START | LAST_DELAY_START | Root | The timestamp when the most recent delay of the Care Type started, displayed in local timezone. |
LAST_DELAY_START_ENTERPRISE | LAST_DELAY_START_ENTERPRISE | Root | The timestamp when the most recent delay of the Care Type started, displayed in enterprise timezone. |
LAST_DELAY_START_UTC | LAST_DELAY_START_UTC | Root | The timestamp when the most recent delay of the Care Type started, displayed in UTC timezone |
LAST_DELAY_USER_LOGIN_ID | LAST_DELAY_USER_LOGIN_ID | System Calc | The username of the user that most recently delayed the Care Type. |
LAST_INPROGRESS_END | LAST_INPROGRESS_END | Root | The latest timestamp when the Care Type ended the 'In Progress' status, displayed in local timezone. |
LAST_INPROGRESS_END_ENTERPRISE | LAST_INPROGRESS_END_ENTERPRISE | Root | The latest timestamp when the Care Type ended the 'In Progress' status, displayed in enterprise timezone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LAST_INPROGRESS_END_UTC | LAST_INPROGRESS_END_UTC | Root | The latest timestamp when the Care Type ended the 'In Progress' status, displayed in UTC timezone. |
LAST_INPROGRESS_FIRST_NAME | LAST_INPROGRESS_FIRST_NAME | Root | The first name of the user who recently moved the care type to ‘In Progress’ status. |
LAST_INPROGRESS_LAST_NAME | LAST_INPROGRESS_LAST_NAME | Root | The last name of the user who recently moved the care type to ‘In Progress’ status. |
LAST_INPROGRESS_START | LAST_INPROGRESS_START | Root | The latest timestamp when the Care Type entered the 'In Progress' status, displayed in local timezone. |
LAST_INPROGRESS_START_ENTERPRISE | 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. |
LAST_INPROGRESS_START_UTC | LAST_INPROGRESS_START_UTC | Root | The latest timestamp when the Care Type entered the 'In Progress' status, displayed in UTC timezone. |
LAST_INPROGRESS_USER_LOGIN_ID | LAST_INPROGRESS_USER_LOGIN_ID | System Calc | The username of the user that most recently moved the Care Type to ‘In Progress’ status. |
LAST_ORDERED_END | LAST_ORDERED_END | Root | The latest timestamp when the Care Type ended the 'Ordered' status, displayed in local timezone. |
LAST_ORDERED_END_ENTERPRISE | 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. |
LAST_ORDERED_END_UTC | LAST_ORDERED_END_UTC | Root | The latest timestamp when the Care Type ended the 'Ordered' status, displayed in UTC timezone. |
LAST_ORDERED_FIRST_NAME | LAST_ORDERED_FIRST_NAME | Root | The first name of the user who recently moved the care type to ‘Ordered’ status. |
LAST_ORDERED_LAST_NAME | LAST_ORDERED_LAST_NAME | Root | The last name of the user who recently moved the care type to ‘Ordered’ status. |
LAST_ORDERED_START | LAST_ORDERED_START | Root | The latest timestamp when the Care Type entered the 'Ordered' status, displayed in local the timezone. |
LAST_ORDERED_START_ENTERPRISE | 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. |
LAST_ORDERED_START_UTC | LAST_ORDERED_START_UTC | Root | The latest timestamp when the Care Type entered the 'Ordered' status, displayed in the UTC timezone. |
LAST_ORDERED_USER_LOGIN_ID | LAST_ORDERED_USER_LOGIN_ID | System Calc | The username of the user that most recently moved the Care Type to ‘Ordered’ status. |
LASTMODDATE | LASTMODDATE | Root | The date and time of the most recent update to the Care Type, displayed in the local time zone. |
LASTMODDATE_STATUS | LASTMODDATE_STATUS | Root | The date and time of the most recent update to the Care Type status, displayed in the local time zone. |
LASTMODDATE_STATUS_ENTERPRISE | 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. |
LASTMODDATE_STATUS_UTC | LASTMODDATE_STATUS_UTC | Root | The date and time of the most recent update to the Care Type status, displayed in the UTC time zone. |
LASTMODDATE_ENTERPRISE | 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. |
LASTMODDATE_UTC | LASTMODDATE_UTC | Root | The date and time of the most recent update to the Care Type, displayed in the UTC time zone. |
LATEST_CARE_TYPE_DELAY_REASON | LATEST_CARE_TYPE_DELAY_REASON | Root | The value selected in the reason for Delay when the care type was delayed. |
LATEST_LASTMODDATE | 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. |
LATEST_LASTMODDATE_ENTERPRISE | 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. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_LASTMODDATE_UTC | 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. |
MILESTONE_ADT_ID | MILESTONE_ADT_ID | System Calc | The Care Type ADT ID as setup in the Care Progression Indicator group settings in Capacity IQ® application. |
MILESTONE_DISPLAY_STATUS_TYPE_CODE | 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. |
MILESTONE_ENTITY_DETAIL_ID | 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. |
MILESTONE_ENTITY_ID | 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. |
MILESTONE_ENTITY_TYPE | 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. |
MILESTONE_ENTITY_TYPE_CODE | 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. |
MILESTONE_GROUP_TYPE | 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. |
MILESTONE_GROUP_TYPE_CODE | 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. |
MILESTONE_ID | 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. |
MILESTONE_STATUS_TYPE_CODE | MILESTONE_STATUS_TYPE_CODE | System Calc | The code that defines the Milestone status. This field is not intended for customer report building. |
PATIENT_ADMIT_DATETIME | PATIENT_ADMIT_DATETIME | Root | The latest local admit date/time of the patient associated with the Care Type. |
PATIENT_ADMIT_DATETIME_ENTERPRISE | 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. |
PATIENT_ADMIT_DATETIME_UTC | PATIENT_ADMIT_DATETIME_UTC | Root | The latest UTC admit date/time of the patient associated with the Care Type. |
PATIENT_CONFIRM_DISCHARGE_DATETIME | PATIENT_CONFIRM_DISCHARGE_DATETIME | Root | The latest local confirmed discharge date/time of the patient associated with the Care Type. |
PATIENT_CONFIRM_DISCHARGE_DATETIME_ENTERPRISE | 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. |
PATIENT_CONFIRM_DISCHARGE_DATETIME_UTC | PATIENT_CONFIRM_DISCHARGE_DATETIME_UTC | Root | The latest UTC confirmed discharge date/time of the patient associated with the Care Type. |
PATIENT_DIAGNOSIS | PATIENT_DIAGNOSIS | Root | The diagnosis of the patient associated with the care type. |
PATIENT_DISCHARGE_DATETIME | PATIENT_DISCHARGE_DATETIME | Root | The latest local discharge date/time of the patient associated with the care type. |
PATIENT_DISCHARGE_DATETIME_ENTERPRISE | 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. |
PATIENT_DISCHARGE_DATETIME_UTC | PATIENT_DISCHARGE_DATETIME_UTC | Root | The latest UTC discharge date/time of the patient associated with the care type. |
PATIENT_EXPECTED_DISCHARGE_DATETIME | PATIENT_EXPECTED_DISCHARGE_DATETIME | Root | The latest local projected discharge date/time of the patient associated with the care type. |
PATIENT_EXPECTED_DISCHARGE_DATETIME_ENTERPRISE | PATIENT_EXPECTED_DISCHARGE_DATETIME_ENTERPRISE | Root | The latest enterprise projected 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. |
PATIENT_EXPECTED_DISCHARGE_DATETIME_UTC | PATIENT_EXPECTED_DISCHARGE_DATETIME_UTC | Root | The latest UTC projected discharge date/time of the patient associated with the care type. |
PATIENT_FIRSTNAME | PATIENT_FIRSTNAME | Root | The first name of the patient associated with the care type. |
PATIENT_ID | 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. |
PATIENT_LASTNAME | PATIENT_LASTNAME | Root | The last name of the patient associated with the care type. |
PATIENT_LEVEL_OF_CARE | 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. |
PATIENT_MRN | PATIENT_MRN | Root | The Medical Record Number of the patient associated with the care type. |
PATIENT_PENDING_DISCHARGE_DATETIME | PATIENT_PENDING_DISCHARGE_DATETIME | Root | The latest local pending discharge date/time of the patient associated with the care type. |
PATIENT_PENDING_DISCHARGE_DATETIME_ENTERPRISE | 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. |
PATIENT_PENDING_DISCHARGE_DATETIME_UTC | PATIENT_PENDING_DISCHARGE_DATETIME_UTC | Root | The latest UTC pending discharge date/time of the patient associated with the care type. |
PATIENT_STATUS_TYPE | 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. |
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. |
PATIENT_TYPE | 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. |
PATIENT_VISIT_NUMBER | PATIENT_VISIT_NUMBER | Root | The patient's visit number/account number of the patient associated with the care type. |
TENANTID | TENANTID | System Calc | The unique identifier associated with the tenant used for internal data partitioning. This field is not intended for client reporting. |
UNIT_CATEGORY_CODE | 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. |
UNIT_NAME | UNIT_NAME | Root | Name of the unit associated with the patient’s latest home location. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted or updated in the Snowflake Data Warehouse in UTC format. |