Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
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. |
ACTION | Action | Root | The status change value associated with either housekeeping bed status changes (In Progress, Pending, Suspended, Delayed) or location status changes (Clean, Occupied, Blocked, etc) |
ACTION_CODE | ACTION_CODE | System Calc | System calculation used for localization filtering. Displays the occupied unit category values (that do not change with language). This field is not intended for client report building. |
ACTION_TYPE | Action Type | Root | The type of status change associated with the action. Status changes related to 'BtJob' include the actions Pending, In Progress, Delayed, Suspended, Cancel, Complete. Status changes related to 'Locationstatus' include Blokd (blocked), Clean, Dirty, Next (Clean Next), Occpd (occupied), Stat, Udef8, and Udef9. |
ACTION_TYPE_ID | ACTION_TYPE_ID | System Calc | The database identifier for the unit associated with the action type. Not Intended for client report building |
BED_ADT_ID | BED_ADT_ID | System Calc | The bed ADT ID of the location associated with the status change. |
BUILDING | Building | Root | The building associated with the location which had a status change. |
BUILDING_ID | Building Id | System Calc | The database identifier for the building associated with the location. Not Intended for client report building |
CAMPUS | Campus | Root | The campus associated with the location having a status change. |
CAMPUS_ID | Campus Id | System Calc | A unique identifier associated with campus. This field is not intended for client report building. |
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. |
CREATEDDATE | Createddate | Root | Created Date in Local Time zone for when the record was entered. |
CREATEDDATE_UTC | Createddate Utc | Root | Created Date in UTC Time zone for when the record was entered. |
CREATEDDATE_ENTERPRISE | CREATEDDATE_ENTERPRISE | Root | Created Date in enterprise time for when the record was entered. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
CUSTOMER_FACILITY_ID | CUSTOMER_FACILITY_ID | Root | The campus account ID value set in the campus settings for the campus associated with each unit. |
N/A | Date Selector | Custom Calc | Used to enable preset date ranges utilizing the Date Range parameter. IF [Date Range] = 'Today' THEN DATEDIFF('day',DATE([Status Start Date]),TODAY()) = 0 ELSEIF [Date Range] = 'Yesterday' THEN DATEDIFF('day',DATE([Status Start Date]),TODAY()) = 1 ELSEIF [Date Range] = 'Last 3 Days' THEN DATEDIFF('day',DATE([Status Start Date]),TODAY()) >= 1 AND DATEDIFF('day',DATE([Status Start Date]),TODAY()) <= 3 ELSEIF [Date Range] = 'Last 7 Days' THEN DATEDIFF('day',DATE([Status Start Date]),TODAY()) >= 1 AND DATEDIFF('day',DATE([Status Start Date]),TODAY()) <= 7 ELSEIF [Date Range] = 'Last 30 Days' THEN DATEDIFF('day',DATE([Status Start Date]),TODAY()) >= 1 AND DATEDIFF('day',DATE([Status Start Date]),TODAY()) <= 30 ELSEIF [Date Range] = 'Last 60 Days' THEN DATEDIFF('day',DATE([Status Start Date]),TODAY()) >= 1 AND DATEDIFF('day',DATE([Status Start Date]),TODAY()) <= 60 ELSEIF [Date Range] = 'Last 90 Days' THEN DATEDIFF('day',DATE([Status Start Date]),TODAY()) >= 1 AND DATEDIFF('day',DATE([Status Start Date]),TODAY()) <= 90 ELSEIF [Date Range] = 'This Month' THEN DATEDIFF('month',DATE([Status Start Date]),TODAY()) = 0 ELSEIF [Date Range] = 'Last Month' THEN DATEDIFF('month',DATE([Status Start Date]),TODAY()) = 1 ELSEIF [Date Range] = 'This Year' THEN DATEDIFF('year',DATE([Status Start Date]), TODAY()) = 0 ELSEIF [Date Range] = 'Last Year' THEN DATEDIFF('year',DATE([Status Start Date]), TODAY()) = 1 ELSEIF [Date Range] = 'Custom Range' THEN DATE([Status Start Date]) >= [Start Date] and DATE([Status Start Date]) <= [End Date] END |
DATEPARTITION | Datepartition | System Calc | System calculation used internally to partition the data for efficient processing. This field is not intended for client report building. |
ENTERPRISE | Enterprise | Root | The name of a collection of campuses. |
ENTERPRISE_ID | Enterprise Id | System Calc | A unique identifier associated with the enterprise. This field is not intended for client report building. |
FACILITY_ADT_ID | FACILITY_ADT_ID | System Calc | The facility ADT ID of the location associated with the status change. If this value is NULL in the location settings, it is derived from the campus settings |
FLOOR | Floor | Root | The floor associated with the location which had a status change. |
FLOOR_ID | Floor Id | System Calc | A unique identifier associated with the floor. This field is not intended for client report building. |
N/A | Help | Custom Calc | A custom calculation used for the hyperlink text to the Data IQ® Online Help. This is not meant for customer reporting. |
INSTANCEID | Instanceid | System Calc | System calculation used for data partitioning. It is not intended for client reporting. |
LASTMODDATE | Lastmoddate | Root | The date of the most recent update to the location status change in local time zone. Use the CreatedDate for reporting purposes. |
LASTMODDATE_UTC | Lastmoddate Utc | Root | The date of the most recent update to the location status change in UTC. Use the CreatedDate_UTC for reporting purposes. |
LASTMODDATE_ENTERPRISE | LASTMODDATE_ENTERPRISE | Root | The Date in enterprise time for when the record was last modified. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LATEST_LASTMODDATE_UTC | Latest Lastmoddate Utc | Root | The date of the most recent update to the location status change in UTC. Use the CreatedDate_UTC for reporting purposes. |
LATEST_LASTMODDATE_ENTERPRISE | LATEST_LASTMODDATE_ENTERPRISE | Root | The date of the most recent update to the location status change in the enterprise time zone. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LOCATION | Location | Root | The location associated with the status change. |
LOCATION_ID | Location Id | System Calc | A unique identifier associated with the location. This field is not intended for client report building. |
NURSESTATION_ADT_ID | NURSESTATION_ADT_ID | System Calc | The Nursing Station ADT ID of the e location. If the value is empty in the location, it will be derieved from the unit settings. |
PATIENT_FIRSTNAME | Patient Firstname | Root | The first name of the patient associated with the status change. Not all location status changes have an associated patient. |
PATIENT_ID | Patient Id | System Calc | A unique identifier associated with the patient associated with the status change. This field is not intended for client report building. |
PATIENT_LASTNAME | Patient Lastname | Root | The last name of the patient associated with the status change. Not all location status changes have an associated patient. |
PATIENT_MRN | Patient Mrn | Root | The Medical Record Number of the patient associated with the status change. Not all location status changes have an associated patient. |
PATIENT_VISIT_NUMBER | Patient Visit Number | Root | The Visit Number of the patient associated with the status change. Not all location status changes have an associated patient. |
REASONCODE_ID | Reasoncode Id | System Calc | A unique identifier associated with the reason code associated with the status change. This field is not intended for client report building. |
ROOM | Room | Root | The room associated with the location. |
ROOM_ID | Room Id | System Calc | A unique identifier associated with the room associated with the status change. This field is not intended for client report building. |
ROOM_ADT_ID | ROOM_ADT_ID | System Calc | The room ADT ID of the location associated with the status change. |
SOURCE_TABLE | Source Table | Root | The database name associated with the action type. |
SOURCE_TABLE_PRIMARYKEY_ID | Source Table Primarykey Id | System Calc | A unique identifier associated with the location status change. This field is not intended for client report building. |
STATUS_END_TIMESTAMP | Status End Timestamp | Root | The local end date time associated with the status change. |
STATUS_END_TIMESTAMP_ENTERPRISE | STATUS_END_TIMESTAMP_ENTERPRISE | Root | The enterprise end date time associated with the status change. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
STATUS_END_TIMESTAMP_UTC | Status End Timestamp Utc | Root | The UTC end date time associated with the status change. |
STATUS_REASON | Status Reason | Root | A reason is recorded for a status change (i.e. Blocked, Suspend, Cancel) |
N/A | Status Start Date | Root | The local start date time associated with the status change. |
STATUS_START_TIMESTAMP | Status Start Timestamp | Root | The local start date time associated with the status change. |
STATUS_START_TIMESTAMP_UTC | Status Start Timestamp Utc | Root | The UTC start date time associated with the status change. |
STATUS_START_TIMESTAMP_ENTERPRISE | STATUS_START_TIMESTAMP_ENTERPRISE | Root | The enterprise start date time associated with the status change. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
TENANTID | Tenantid | System Calc | System calculation that is used in data partitioning. Not meant for client reporting. |
N/A | Today | Custom Calc | The current date based on the enterprise date time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
UNIT | Unit | Root | The unit associated with the location which had a status change. |
UNIT_ID | Unit Id | System Calc | A unique identifier associated with the unit. This field is not intended for client report building. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in Snowflake Data Warehouse in UTC format. |