What data will be in this new data source?
This new data source will contain the most recent value of your Capacity IQ® Custom Columns. The data source is in our Fast Lane and is named CURRENT_PATIENT_CUSTOM_DATA_teletracking_V2. It has the standard 5-10 min latency. The data source will contain the most recent value per Custom Column for patients who still exist within the Current Patient Visit data source.
Should I use this data sources individually or use it with other data sources?
The data source can be used as standalone data source or can be blended into other data sources. To make blending simple, we have included a variety of Patient related fields in this data source.
How is the data organized in this data source?
Because there could be an unlimited number of Custom Fields generated by any customer, we have decided to have separate fields for ‘Custom Field Name’, ‘Custom Field Column Type’, and ‘Custom Field Value’.
What should I do with the ‘Custom Field Column Type’?
Since there can be multiple column types set for Custom Columns in Capacity IQ® (text, date, integer, etc.) we have decided to make this field show what the column type is set to within Capacity IQ®. By default, all Custom Field values will come across as text values in Data IQ®. If you have a field that is a date or an integer, you will only need to convert these in Tableau. If all custom columns are not the same type, please follow the directions below to create a single custom calculation in Tableau for each Custom Field Name value.
What are the use cases where I would want to blend this data with other data sources?
There are a variety of use cases for this, but this really depends on what your health system is doing with Custom Columns in Capacity IQ®. Perhaps you have a Custom Field that you want to use as a filter in other data sources. To do this you will just need to create a custom calculation for the specific Custom Field name/value pair. After creating this you can blend this across data sources to be used as a filter.
I want a single column in Tableau for each Custom Field Name value - how should I do this?
To do this you will want to use the following custom calculation within Tableau:
IF [Custom Field Name] = 'Preferred Patient Name' THEN [Custom Field Value]
ELSE NULL
END
This calculation creates a unique custom calculation for the specified text in ‘Custom Field Name’. In the example above you can call this custom calculation ‘Preferred Patient Name’. If you had another ‘Custom Field Name’ value that you wanted to create a custom calculation from you would just need to swap the text in the calculation. If you want to make one for ‘Discharge Notes’, then you would only need to swap ‘Discharge Notes’ into the text of the custom calculation and change the name of the custom calculation.
I am seeing a patient’s Custom Field Value as NULL when it should not be - why is this?
It is important to note that a handful of customers may see the value for a particular custom field of a patient appear as NULL when it should not. This is due to the workflow of the interface configuration between the customer and the EMR. This causes the value to not always be included in the events we use to generate the custom field data. Due to this, for this small subset of customer and Custom Field Values, the data may appear unexpectedly appear NULL. This issue is expected to autocorrect when the next update comes-in.