Info
About Custom Columns
In the Patient Tracking Portal application, custom columns can display specialized patient information that does not appear already in standard list view columns. Custom columns can be setup to display text numbers, or dates.
Example
Examples of this information are Early Warning Sign scores (EWS), Waterlow or Braden scores (pressure sore scores), and MRSA dates. You would configure your EWS to be numeric and MRSA to be a date.
Permissions
Admin Tool Menu + Custom Columns Permissions are required to View/Edit Custom Columns in Dictionary Management
Users do not need special permissions to adjust the data in a custom column on a list view.
Basic Functionality
If custom columns are added to a list view, nursing unit staff can click in the column to edit the information.
ADT Integration
The custom columns can show information that is transferred from the hospital ADT system.
Example
Relating back to our EWS example, If the ADT system has an EWS score for the patient, that can be transferred to the EWS column.
Each custom column allows you to configure the Update Method which determines whether information transferred from the ADT system either:
Replaces existing information
Adds additional data to the column
If data transferred from a patient record in the ADT system does not match the format that the administrator sets for the column at the time that the list view is first opened, then the column appears blank for that patient.
Example
If the column is set up to accept only numerals (EWS) and the data from the patient record in the ADT system is in text format, then the column will be blank. If we send “Five” instead of “5” then our EWS column will not populate.
Visuals - Numeric Custom Columns Only
Numeric custom columns have thresholds to adjust a color in the list view.
Example
On our EWS column we configure it with threshold from 1 to 4 appear green (Low EWS) and values from 4 to 7 appear yellow (Medium EWS). This can give staff a visual indication that action might be required if numbers are in a certain range.
Editing Custom Columns
To Add, Edit, or Delete Custom Columns:
Go to Admin Tool > Dictionary Management .
Go to Admin > Settings > Capacity Management > Miscellaneous > Dictionary Management.
In the Dictionary Name column, click the Custom Columns link.
Do one of the following:
To add, click Add to display the Custom Column>New Column page.
To edit, under Column Name , click the name of a custom column to display the Custom Column>[Name of Column] page.
To create this kind of column . . . | Example of when this kind of column would be used . . . | Do this . . . |
Numeric. Only numbers can appear in these columns. | EWS score, Waterlow, score, Braden score |
|
Date and Time. Only dates and times can appear in this column. | MRSA date |
|
Text. Only alphanumeric characters and text can appear in this column. | Comments |
|
Delete a Custom Column
You cannot delete a custom column that is on a Patient Tracking Portal list view. The column must be removed from all list views before it can be deleted.
Do one of the following on the Dictionary Management>Custom Columns page:
To delete all custom columns, select the check box in the first row and first column of the page.
To delete individual custom columns, select the check boxes for them.
Click Delete Selected Records.
When a confirmation message appears, click OK.