GAD-7, PHQ-9 or EFS forms to share?

PeteBoyd · June 1, 2020, 8:21am

Has anyone created GAD-7, PHQ-9 or Edmonton Frail Scale forms that they can share please?

Nilesh_Hake · June 2, 2020, 9:41am

Hi @PeteBoyd,

I have created the GAD-7 form please let me know if you want the demo for the GAD-7 forms.

Thanks,
Nilesh

PeteBoyd · June 2, 2020, 9:42am

Great, yes please Nilesh.

juggernautsei · June 2, 2020, 11:09am

Is this the PHQ9 that you are looking for? Also, do you need it to auto score and set the severity programmatically?

PeteBoyd · June 3, 2020, 7:38am

Yes this is it, though the editions I’ve been pointed to have a question 10 or part 2, e.g. https://www.med.umich.edu/1info/FHP/practiceguides/depress/phq-9.pdf

Auto scoring and setting severity would be ideal but I would take what’s available.

juggernautsei · June 3, 2020, 11:20am

@PeteBoyd give me a couple of days to get this ready for you. There seems to be a problem with the configuration import @visolve-051. When I try to import the config file that was exported from the system. I get the There was an error on the backup. Hopefully there is a patch for this that @vishal_io has.

PeteBoyd · June 3, 2020, 11:29am

Please don’t worry @juggernautsei, because I need it today. I am happy to pay for features, but in the case of the PHQ-9, apart from the calculation it is easy for me to create this particular form myself and I need it right away – I just wondered if anyone had made one already that they could share immediately. Thank you anyway.

juggernautsei · June 3, 2020, 11:38am

@PeteBoyd here is what you are looking for. The bottom link will take you straight to the forms.

PeteBoyd · June 4, 2020, 1:32pm

Thanks @juggernautsei but Dr Boyd’s PHQ-9 form appears to be written for OpenEMR 4.2 and in 2017 Brady Miller said it will need work to get working for OpenEMR 5. We’ve written our own LBV form for now.

CalvinTy · June 28, 2020, 8:01pm

Pete, can you share the forms with the forum?

mohit · August 5, 2021, 7:25am

@juggernautsei can you please help me how i can also enable this PHQ-9 form.

Or do you have any reference for this please share with me.

It will we great to share with me.
Thanks
Mohit

juggernautsei · August 5, 2021, 2:10pm

That PHQ9 won’t work in version 6.

sjpadgett · August 5, 2021, 2:22pm

@juggernautsei Does this have your plug in for scoring LBF items? If so, would you be willing to donate to the project.
If needed, I’ll fix and put in code…

juggernautsei · August 5, 2021, 2:37pm

Yes, it does have the plugins. I converted this code once before but I think it got lost somewhere out there.

mohit · August 9, 2021, 6:56am

Hi @sjpadgett
Good morning

As per my understand we can also create PHQ-9 form by LBF form, for this we need to go Administration -> Forms -> Layout and after that create PHQ-9 form and save, one more things is that when creating of PHQ-9 form please select access control option to Patient reports.

Please replay me if i was wrong?

Thanks
Mohit.

sjpadgett · August 9, 2021, 6:16pm

Yes, you can create these forms with layout and many folks do. However, @juggernautsei created a plugin for layouts that allows auto help with scoring the forms from layout generated form.

PeteBoyd · August 9, 2021, 6:17pm

I will try to upload my PHQ-9 LBF here ASAP.

sjpadgett · August 9, 2021, 6:21pm

Thanks Pete. I’m sure many will benefit.

PeteBoyd · August 10, 2021, 2:48pm

Here’s the SQL to insert our PHQ-9 layout based visit form from the command-line on Linux:

Patient Health Questionnaire PHQ-9

Version 1.0

Layout - LBFPHQ-9

layout_group_properties

INSERT INTO `layout_group_properties` VALUES ('LBFPHQ-9','','PHQ-9','Patient Health Questionnaire','Clinical',0,1,0,2,9,'','','','','');
INSERT INTO `layout_group_properties` VALUES ('LBFPHQ-9','1','Part 1','Over last 2 wks, how often bothered by any of these problems:','',0,1,0,0,0,'','','','','');
INSERT INTO `layout_group_properties` VALUES ('LBFPHQ-9','2','Score for part 1','','',0,1,0,0,0,'','','','','');
INSERT INTO `layout_group_properties` VALUES ('LBFPHQ-9','3','Part 2','If you checked off any problem on this questionnaire so far,','',0,1,0,0,0,'','','','','');

layout_options

INSERT INTO `layout_options` VALUES ('LBFPHQ-9','appetite','1','Poor appetite or overeating',50,1,2,0,0,'PHQ_9_responses___Part1',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','concentration','1','Trouble concentrating on things, such as reading the newspaper ',70,1,2,0,0,'PHQ_9_responses___Part1',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','depressed','1','Feeling down, depressed, or hopeless',20,1,2,0,0,'PHQ_9_responses___Part1',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','impact','3','How difficult to do work / things at home / get along w/others?',10,1,1,0,0,'PHQ_9_responses___Part2',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','interest','1','Little interest or pleasure in doing things',10,1,2,0,0,'PHQ_9_responses___Part1',1,6,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','more_than_half_total','2','Multiply total no. of \'more than half the days\' responses by 2',20,1,2,0,0,'two_times_table',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','movement','1','Moving/speaking v. slowly, or being fidgety moving around a lot',80,1,2,0,0,'PHQ_9_responses___Part1',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','nearly_daily_total','2','Multiply total no. of \'nearly every day\' responses by 3',30,1,2,0,0,'three_times_table',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','self_worth','1','Feeling bad about yrself / a failure / let yrself/family down',60,1,2,0,0,'PHQ_9_responses___Part1',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','several_days_total','2','Total no. of \'several days\' responses',10,1,2,0,0,'Numbers',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','sleep','1','Trouble falling/staying asleep, sleeping too much',30,1,2,0,0,'PHQ_9_responses___Part1',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','suicidal_or_self_harm','1','Thoughts that you\'d be better off dead or of hurting yourself',90,1,2,0,0,'PHQ_9_responses___Part1',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','tired','1','Feeling tired or having little energy',40,1,2,0,0,'PHQ_9_responses___Part1',1,1,'','','',0,'','F','','');
INSERT INTO `layout_options` VALUES ('LBFPHQ-9','total','2','Total score for part 1',40,1,2,0,0,'Numbers',1,1,'','','',0,'','F','','');

Lists

PHQ_9_responses___Part1 |
PHQ_9_responses___Part2
two_times_table
three_times_table
numbers

PHQ_9_responses___Part1

INSERT INTO `list_options` VALUES ('lists','PHQ_9_responses___Part1','PHQ-9 responses - Part1',345,1,0,'',NULL,'',0,0,1,'',1,'2020-06-04 13:21:34');

INSERT INTO `list_options` VALUES ('PHQ_9_responses___Part1','0','Not at all',0,0,0,'','','',0,0,1,'',1,'2020-06-04 13:23:00');
INSERT INTO `list_options` VALUES ('PHQ_9_responses___Part1','1','Several days',1,0,0,'','','',0,0,1,'',1,'2020-06-04 13:23:00');
INSERT INTO `list_options` VALUES ('PHQ_9_responses___Part1','2','More than half the days',2,0,0,'','','',0,0,1,'',1,'2020-06-04 13:23:00');
INSERT INTO `list_options` VALUES ('PHQ_9_responses___Part1','3','Nearly every day',3,0,0,'','','',0,0,1,'',1,'2020-06-04 13:23:01');

PHQ_9_responses___Part2

INSERT INTO `list_options` VALUES ('lists','PHQ_9_responses___Part2','PHQ-9 responses - Part2',344,1,0,'',NULL,'',0,0,1,'',1,'2020-06-04 13:17:39');
INSERT INTO `list_options` VALUES ('PHQ_9_responses___Part2','0','Not difficult at all',0,0,0,'','','',0,0,1,'',1,'2020-06-04 13:20:41');
INSERT INTO `list_options` VALUES ('PHQ_9_responses___Part2','1','Somewhat difficult',1,0,0,'','','',0,0,1,'',1,'2020-06-04 13:20:41');
INSERT INTO `list_options` VALUES ('PHQ_9_responses___Part2','2','Very difficult',2,0,0,'','','',0,0,1,'',1,'2020-06-04 13:20:41');
INSERT INTO `list_options` VALUES ('PHQ_9_responses___Part2','3','Extremely difficult',3,0,0,'','','',0,0,1,'',1,'2020-06-04 13:20:41');

two_times_table

INSERT INTO `list_options` VALUES ('lists','two_times_table','two times table',342,1,0,'',NULL,'',0,0,1,'',1,'2020-06-04 11:06:52');
INSERT INTO `list_options` VALUES ('two_times_table','0','0',0,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','10','10',5,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','12','12',6,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','14','14',7,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','16','16',8,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','18','18',9,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','2','2',1,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','4','4',2,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','6','6',3,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','8','8',4,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:10');
INSERT INTO `list_options` VALUES ('two_times_table','a12','a12',10,0,0,'',NULL,'',0,0,1,'',1,'2020-06-18 11:18:33');
INSERT INTO `list_options` VALUES ('two_times_table','hhh','hhh',11,0,0,'',NULL,'',0,0,1,'',1,'2020-06-18 11:18:51');

three_times_table

INSERT INTO `list_options` VALUES ('lists','three_times_table','three times table',343,1,0,'',NULL,'',0,0,1,'',1,'2020-06-04 12:02:45');
INSERT INTO `list_options` VALUES ('three_times_table','0','0',0,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:28');
INSERT INTO `list_options` VALUES ('three_times_table','12','12',4,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:27');
INSERT INTO `list_options` VALUES ('three_times_table','15','15',5,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:27');
INSERT INTO `list_options` VALUES ('three_times_table','18','18',6,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:28');
INSERT INTO `list_options` VALUES ('three_times_table','21','21',7,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:28');
INSERT INTO `list_options` VALUES ('three_times_table','24','24',8,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:28');
INSERT INTO `list_options` VALUES ('three_times_table','27','27',9,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:28');
INSERT INTO `list_options` VALUES ('three_times_table','3','3',1,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:27');
INSERT INTO `list_options` VALUES ('three_times_table','6','6',2,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:27');
INSERT INTO `list_options` VALUES ('three_times_table','9','9',3,0,0,'','','',0,0,1,'',1,'2020-06-15 10:03:27');

Numbers

INSERT INTO `list_options` VALUES ('lists','Numbers','Numbers',312,1,0,'',NULL,'',0,0,1,'',1,'2020-05-31 14:02:52');
INSERT INTO `list_options` VALUES ('Numbers','0','0',0,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','1','1',1,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','10','10',10,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','11','11',11,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','12','12',12,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','13','13',13,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','14','14',14,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','15','15',15,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','16','16',16,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','17','17',17,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','18','18',18,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','19','19',19,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','2','2',2,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','20','20',20,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','21','21',21,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','22','22',22,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','23','23',23,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','24','24',24,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','25','25',25,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','26','26',26,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','27','27',27,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','28','28',28,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','29','29',29,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','3','3',3,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','30','30',30,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','31','31',31,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','32','32',32,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','33','33',33,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','34','34',34,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','35','35',35,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','36','36',36,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','37','37',37,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','38','38',38,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','39','39',39,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','4','4',4,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','40','40',40,0,0,'','','',0,0,1,'',1,'2020-06-15 10:05:12');
INSERT INTO `list_options` VALUES ('Numbers','41','41',41,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','42','42',42,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','43','43',43,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','44','44',44,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','45','45',45,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','46','46',46,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','47','47',47,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','48','48',48,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','49','49',49,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','5','5',5,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','50','50',50,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','51','51',51,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','52','52',52,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','53','53',53,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','54','54',54,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','55','55',55,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','56','56',56,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','57','57',57,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','58','58',58,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','59','59',59,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','6','6',6,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','60','60',60,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','61','61',61,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','62','62',62,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','63','63',63,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','64','64',64,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','65','65',65,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','66','66',66,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','67','67',67,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','68','68',68,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','69','69',69,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','7','7',7,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','70','70',70,0,0,'','','',0,0,1,'',1,'2020-06-03 11:57:54');
INSERT INTO `list_options` VALUES ('Numbers','8','8',8,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');
INSERT INTO `list_options` VALUES ('Numbers','9','9',9,0,0,'','','',0,0,1,'',1,'2020-06-29 11:39:22');

Mark_Sarnov · October 24, 2021, 7:48am

Ye Gods! that’s a lot of code.
I was inspired by Ruth Moulton’s GAD-7 form and created a PHQ9 based on that. Here is the zip file that can be unzipped into the ‘contrib’ folder for review and then the ‘forms’ folder for installation.
I am happy to submit it to the dev team if they would be willing to accept it.
Cheers!
Mark Sarnov, MDphq9-contrib.zip (11.7 KB)