Groups - Static & Dynamic
17 min
groups the groups view in the work centre is used to maintain, view and use patient groups in dynamic groups, patients are automatically added or removed depending on the rules for the groups, for example 'all patients with diabetes' or 'all male patients over 60' these groups look for matching information in the database and are updated accordingly static groups are created from dynamic groups, for a specific date and hold all the information from the database when the group is set up as information in the database changes, the static group will not filing system all three lists of groups in the view are ordered in a hierarchical system with a tree structure of categories and subcategories you can drag and drop patient groups within a list into a new category click on and to expand and collapse the category the toolbar allows you to click to create a new category click to create a new subcategory click to edit a group category name click to delete a category note patient groups under a deleted category are not deleted, they collapse into the level above accessing dynamic groups as a clinician, select the groups view in the clinical menu of the work centre segment bar there is a default list of dynamic groups for all of the chronic diseases click to select a dynamic group click on the process arrow in the groups view toolbar the patients belonging to this group are listed in the patients in group panel because the file number of each patient is shown, the information is contextual you can select a patient line and perform any relevant action directly for that patient by clicking on the relevant toolbar icon or menu option entering or altering the dynamic group criteria click to select the desired dynamic group click on the groups view toolbar this opens the edit group window enter the relevant details filter tab caption free text field used to summarize the rule or rules to be used for filtering use for filtering click on the dropdown arrow and click to select the style of filtering to be used options are general specify a set of rules from a template this is the common setting stored query use a database query to select patient records macro write a program using the macro language to select patient records age click on the dropdown arrow and click to select the option and specify the age in the adjacent field to specify the age of the patients that should be included in the filter gender if desired, click on the dropdown arrow and click to select gender disease code (unlabelled field) use this option to include or exclude patients with a specific disease click on the dropdown arrow and click to select dx code and specify a disease code to have patients with that disease code in their records to be included in the filter no dx code and specify a disease code to have all patients without that disease code in their records to be included in the filter dx description and enter a disease description to have all patients whose record contains the specified text to be included in the filter for example, enter 'depression' if you want to include patients with 'depression' or 'anxiety depression' etc in their records no dx description and enter a disease description to have all patients without that problem description in their records to be included in the filter in populating the group, the system will look in only one of these views of the patient records for the timeframe, select you can further limit the selection according to whether the diagnosis is currently active and/or open options are the status field of a diagnosis determines whether it is active or inactive a 'closed' diagnosis is one that has a ‘to’ date problems encounters invoices ever if you do not wish to limit the timeframe or one of the time periods ('in last 2 weeks', 'in last 24 months') to limit the group to those who have (or have not) had this diagnosis in that timeframe any active , open active , closed inactive , open inactive , closed service (unlabelled field) use this option to include or exclude patients who have (or have not) been invoiced for a certain service code or service description click on the dropdown arrow and click to select is found to include only patients who have had that service is not found to include only patients who have not had that service for the timeframe, choose ever if you do not wish to limit the timeframe or one of the time periods ('in last 2 weeks', 'in last 24 months') to limit the group to those who have (or have not) been invoiced for the service in that timeframe note negative selection criteria (such as is not found or no dx description ) can take a very long time to process, especially with large databases it is recommended that these dynamic groups be processed outside of busy transactional times medications prescribed (unlabelled field) click on the dropdown arrow and click to select for the timeframe, select then enter the name of the medication (or part of it) to have the filter include only patients for whom the specified medication has been prescribed or listed in their usual medications prescription or usual med ever if you do not wish to limit the timeframe or one of the time periods clinical notes (unlabeled field) use the notes contain option to include or exclude patients based on whether or not a specific text string appears in any of their clinical notes click on the dropdown arrow and click to select is found and enter the required text to include only those patients that have at least one contact where the specified text was entered for example 'suspected anorexia' is not found and enter the required text to include only those patients that do not have any contact containing the specified text for the timeframe, select ever if you do not wish to limit the timeframe or one of the time periods using the notes contain search parameter will search the complete database for the word(s) in question this will take a long time, and will use most of profile’s resources we suggest avoiding this search criterion if it’s necessary to do so, set up and run outside of normal business hours when the system is otherwise not being used hri (unlabelled field) and item has the parameters use this option to include or exclude patients based on whether or not a specific hri appears for the patient within the specified period for example, if you wanted to include all patients who have an a1c lab result, you could set it up as shown below filter by patient status click to check this checkbox to limit the filter to those patients whose statuses are among those checked in the list click to check or uncheck the desired statuses patients will only be included in the list if they match all the criteria stated in this window presentation tab the presentation tab allows to choose the columns that will be used to populate the list in the patients in group panel you can add custom columns to display a most recent hri in the time frame for the patients get presentation settings from click on the dropdown arrow and click to select from patient group if assigned to display columns selected in this view only if they are different than the ones selected in the patient groups filter view of the work center always from patient group to always display columns selected in this view always from view filter to always display columns selected in the patient groups filter view of the work center add custom column click to add a custom column delete custom column select a column and click to delete it most recent hri use this option to include a new column with an hri to display this is similar to those in the filter tab item has the parameters click ok creating new dynamic groups two options are available click on the “ new dynamic group ” button in the groups view toolbar right click on a category name and click “ new ” this opens the new dynamic group window in the name field, enter an appropriate name if desired, click to remove the checkmark from the shared checkbox so this group is not available to all other providers if desired, in the status field, click on the dropdown arrow and click to select a status if desired, in the privacy field, click on the dropdown arrow and click to select a privacy setting if desired, in the owner field, click on the ellipsis and select an owner click ok creating new static groups two options are available click on the “ new static group ” button in the groups view toolbar right click on a category name and click “ new ” this opens the new static group window in the name field, enter an appropriate name if desired, click to remove the checkmark from the shared checkbox so this group is not available to all other providers if desired, in the status field, click on the dropdown arrow and click to select a status if desired, in the privacy field, click on the dropdown arrow and click to select a privacy setting if desired, in the owner field, click on the ellipsis and select an owner click ok the edit group window opens select the columns that will be used to populate the list in the patients in group panel click ok creating static groups from a dynamic group click to select a dynamic group holding down your left mouse button, drag the dynamic group to the static groups panel a new static group window opens enter a group’s name and click ok in the presentation tab, select the columns that will be used to populate the list in the patients in group panel click ok to create the group click on the process arrow in the groups view toolbar the patients belonging to this group are listed in the patients in group panel here is an example of a group that can be made that will find a list of patient’s that are diabetic but have not been prescribed metformin in the last 12 months this can be useful to identify any patients that have not come in to have their prescriptions renewed make sure that there is a diabetic dynamic group in profile already, if not, you can make one with the following criteria the above query is looking through the patient’s problem list to see if they have diabetes in the list this is using text description to find the list which should capture patients that have icd 9 250 or anything similar create a group to search for all patients that have not prescribed metformin in the last 12 months i have included an example below the drug and the duration are things that can be customized to suit the need of the clinic, this is only an example this query should not be run on its own though once the 2 queries above have been created, you will then need to make an intersection query this should return a list of all the diabetic patients that have not been prescribed in the past 12 months note patients in your database should have diabetes in their problem list as well as having been prescribed metformin in the last 12 months in order for this example to work undocking groups groups can be undocked to perform additional functions for patients within a group; such as adding them to a care plan click to select the desired dynamic group click on the process arrow in the groups view toolbar the patients belonging to this group are listed in the patients in group panel click on the undock patient group button in the groups view toolbar this opens the patient group in a new window using the checkboxes on the left side, select patient to action the following actions can be performed with the associated buttons add problem – add a problem to the selected patients’ problem lists add alert – add an alert to the selected patients’ files add care plan – add the selected patients to a care plan add intervention – add an intervention for the selected patients toggle appointment quick search panel note patients who already have had the action performed previously will be skipped compound patient groups unions and intersections union a grouping where the patients are included in one group or another example patients who have either asthma or diabetes intersection a grouping where the patients are included in one group and another example patients who have asthma and diabetes click 2 dynamic or static groups upon which you want to base the union or intersection click on the first group, and then while holding the \[shift] or \[ctrl], click on the second group click on the new union , or new intersection button in the groups view toolbar this opens the new compound group window name the group in the presentation tab, select the columns that will be used to populate the list click ok the new group will appear in the unions and intersections area tip\ t hese groups can be made up of dynamic, static, union or intersection groups in any combination comparison the compound group functionality allows to make analysis through comparison between patient groups the comparison can be done through the comparison tab of the edit compound group window example finding the percentage of patients that have asthma and diabetes among the asthma group click to select the desired compound group click on the groups view toolbar this opens the edit compound group window click on the comparison tab enter the relevant details numerator non editable field that is a mirror of the structure in the definition tab denominator click on the dropdown arrow and click to select an option if definition is selected, the structure panel below is enabled using the toolbar and arrows, modify the structure as desired if group is selected, the dropdown menu on the right is enabled select a group from the list reset button click to reset the denominator to its original settings output check to display a comparator panel displayed below the patients in group pane description – free text field type as appropriate numerator – free text field type as appropriate count – check to display a count % – check to display a percentage denominator – free text field type as appropriate count – check to display a count in the presentation tab, select the columns that will be used to populate the list click ok result 2 (10 53%) out of 19 patients have asthma and diabetes note users should use caution when creating unions and intersections of dynamic groups because they have the potential to be very taxing on the server to the point of causing extreme slowness or freezing of profile generally, unions and intersections of dynamic groups should try to be kept to under approximately five groups to reduce the complexity of the database query if more complex queries are needed, find objects queries are a more efficient and less impactful way to query the database