Snowflake Field Name

Tableau Data Source Field

Folder

Description

N/A

Acquisitiondate UTC

Root

System calculation that allows us to see when the data was acquired in the source system.

N/A

Campus ID

Root

The identification number of a collection of buildings in the enterprise.

N/A

Campus Name

Root

The name of a collection of buildings in the enterprise.

N/A

Cloudacquisitiondate UTC

Root

System calculation that allows us to see when the data was acquired into the cloud.

N/A

CPI Group Name

Root

The name of the upper level group of which the care progression indicator is part of.

N/A

CPI Group Status Type

Root

The status of the care progression indicator – completed, in progress, or ordered.

N/A

Createddate

Root

Date and time the Care Progression Indicator was initiated.

N/A

Createddate_ENTERPRISE

Root

Enterprise date and time that the Care Progression Indicator was initiated. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

N/A

Createddate_UTC

Root

Date and time in UTC the Care Progression Indicator was initiated.

N/A

Datepartition

Root

Non-strict dynamic partition column.

N/A

First Completed Start

Root

The timestamp that the initial Care Progression Indicator in a group entered 'Completed' status.

N/A

First Delay End

Root

The timestamp that the initial Care Progression Indicator in a group had the delay removed.

N/A

First Delay Start

Root

The timestamp that the initial Care Progression Indicator in a group was delayed.

N/A

First Inprogress Start

Root

The timestamp that the initial Care Progression Indicator in a group entered 'In Progress' status.

N/A

First Ordered Start

Root

The timestamp that the initial Care Progression Indicator in a group entered 'Ordered' status.

N/A

Home Location

Root

Name of the patient's home 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.

N/A

Instanceid

Root

The name of the instance GUID – Non-Strict Dynamic Partition Column.

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.

N/A

Last Completed End

Root

The timestamp that the final Care Progression Indicator in a group entered 'Completed' status.

N/A

Last Completed First Name

Root

The first name of the user that completed the most recent Care Progression Indicator in a group.

N/A

Last Completed Last Name

Root

The last name of the user that completed the most recent Care Progression Indicator in a group.

N/A

Last Completed Start

Root

The timestamp that the most recent Care Progression Indicator entered 'Completed' status.

N/A

Last Delay End

Root

The timestamp that the most recent Care Progression Indicator was delayed.

N/A

Last Delay First Name

Root

The first name of the user that delayed the most recent Care Progression Indicator in a group.

N/A

Last Delay Last Name

Root

The last name of the user that delayed the most recent Care Progression Indicator in a group.

N/A

Last Delay Start

Root

The timestamp that the most recent Care Progression Indicator in a group had the delay removed.

N/A

Last Inprogress Start

Root

The timestamp that the most recent Care Progression Indicator in a group entered 'In Progress' status.

N/A

Last Ordered Start

Root

The timestamp that the most recent Care Progression Indicator in a group entered 'Ordered' status.

LASTMODDATE

Lastmoddate

Root

The date and time of the most recent update to the Care Progression Indicator datasource in the local time zone.

LASTMODDATE_ENTERPRISE

Lastmoddate Enterprise

Root

The date and enterprise time of the most recent update to the Care Progression Indicator datasource. 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 Progression Indicator datasource in UTC.

LATEST_LASTMODDATE_ENTERPRISE

Latest Lastmoddate Enterprise

Root

System calculation that displays the most recent update to the Care Progression Indicator datasource in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

LATEST_LASTMODDATE_UTC

Latest Lastmoddate UTC

Root

System calculation that displays the most recent update to the Care Progression Indicator datasource in UTC time.

PATIENT_ADMIT_DATETIME

Patient Admit Date Time

Root

The local date and time the patient was admitted.

PATIENT_ADMIT_DATETIME_ENTERPRISE

Patient Admit Date Time Enterprise

Root

The enterprise date and time the patient was admitted. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

PATIENT_CONFIRMED_DISCHARGE_DATETIME

Patient Confirmed Discharge Datetime

Root

The local date and time that the patient's status was set to Confirmed Discharge.

PATIENT_CONFIRMED_DISCHARGE_DATETIME_ENTERPRISE

Patient Confirmed Discharge Datetime Enterprise

Root

The enterprise date and time that the patient's status was set to Confirmed Discharge. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

N/A

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.

N/A

Patient Diagnosis Datetime

Root

The local date and time that the patient was actually discharged.

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_EXPECTED_DISCHARGE_DATETIME

Patient Expected Discharge Datetime

Root

The local date and time that the patient is expected to be discharged.

PATIENT_EXPECTED_DISCHARGE_DATETIME

Patient Expected Discharge Datetime Enterprise

Root

The enterprise date and time that the patient is expected to be discharged. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.

N/A

Patient Firstname

Root

Patient's first name.

N/A

Patient ID

Root

Unique identification number for the patient.

N/A

Patient Lastname

Root

Patient's last name.

N/A

Patient Level of Care

Root

The degree of care that the patient requires, such as critical, acute, intermediate.

N/A

Patient Middle Initial

Root

Patient's middle initial.

N/A

Patient MRN

Root

The medical record number for person receiving medical treatment.

PATIENT_PENDING_DISCHARGE_DATETIME

Patient Pending Discharge Datetime

Root

The local date and time that the patient's status was set to Pending Discharge.

PATIENT_PENDING_DISCHARGE_DATETIME_ENTERPRISE

Patient Pending Discharge Datetime Enterprise

Root

The enterprise date and time 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.

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

Patient Type

Root

Name of the category for the patient, such as pre-admit, acute care, inpatient, etc.

N/A

Patient Visit Number

Root

Patient's visit number/account number.

N/A

TenantID

Root

Tenant GUID – Non-Strict Dynamic Partition Column.

N/A

Unit ID

Root

Unique identification number of the unit where the patient is currently located.

N/A

Unit Name

Root

Name of the unit where the patient is currently located.

WAREHOUSEACQUISITIONDATE_UTC

WAREHOUSEACQUISITIONDATE_UTC

System Calc

The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format.