Medication Allergy List

From OpenEMR Project Wiki
Revision as of 20:44, 26 January 2010 by Bradymiller (talk | contribs) (→‎Links)

MU Requirements

Meaningful Use Measures:

At least 80% of all unique patients seen by the EP have at least one entry (or an indication of “none” if the patient has no medication allergies) recorded as structured data.


Certification Criteria for EHR:

Enable a user to electronically record, modify, and retrieve a patient’s active medication allergy list as well as medication allergy history for longitudinal care (i.e., over multiple office visits).

Proposed Solution

Medication Allergy List can be found in Issues section of each patient's Medical Record.

Medicationallergy1.png

It will be easier to access in the new GUI developed by Tony. See Allergy.

Medicationallergy2.png


The proposed solution is as follows:

1. Add a "medication_allergy_status" field to "patient_data" table. The default for this field is "none". This status is displayed under Allergy (new GUI).

2. As soon as an allergy is created for a patient, the status is changed to "yes". The "None" wording in the GUI is replaced by the allergy entered.

3. Create a new table since there are over 400 records of allergy from Lexi-comp medication database.

Effected Code, Tables, etc

CREATE TABLE IF NOT EXISTS `medication_allergies` ( 

 `allergy_id` bigint(20) NOT NULL AUTO_INCREMENT,
 `allergy_name` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`allergy_id`)

) ENGINE=MyISAM DEFAULT AUTO_INCREMENT=1 ;


-- -- Table structure for table `patient_data` --

DROP TABLE IF EXISTS `patient_data`; CREATE TABLE `patient_data` ( 

 `id` bigint(20) NOT NULL auto_increment,
 `title` varchar(255) NOT NULL default ,
 `language` varchar(255) NOT NULL default ,
 `financial` varchar(255) NOT NULL default ,
 `fname` varchar(255) NOT NULL default ,
 `lname` varchar(255) NOT NULL default ,
 `mname` varchar(255) NOT NULL default ,
 `DOB` date default NULL,
 `street` varchar(255) NOT NULL default ,
 `postal_code` varchar(255) NOT NULL default ,
 `city` varchar(255) NOT NULL default ,
 `state` varchar(255) NOT NULL default ,
 `country_code` varchar(255) NOT NULL default ,
 `drivers_license` varchar(255) NOT NULL default ,
 `ss` varchar(255) NOT NULL default ,
 `occupation` longtext,
 `phone_home` varchar(255) NOT NULL default ,
 `phone_biz` varchar(255) NOT NULL default ,
 `phone_contact` varchar(255) NOT NULL default ,
 `phone_cell` varchar(255) NOT NULL default ,
 `pharmacy_id` int(11) NOT NULL default '0',
 `status` varchar(255) NOT NULL default ,
 `contact_relationship` varchar(255) NOT NULL default ,
 `date` datetime default NULL,
 `sex` varchar(255) NOT NULL default ,
 `referrer` varchar(255) NOT NULL default ,
 `referrerID` varchar(255) NOT NULL default ,
 `providerID` int(11) default NULL,
 `email` varchar(255) NOT NULL default ,
 `ethnoracial` varchar(255) NOT NULL default ,
 `interpretter` varchar(255) NOT NULL default ,
 `migrantseasonal` varchar(255) NOT NULL default ,
 `family_size` varchar(255) NOT NULL default ,
 `monthly_income` varchar(255) NOT NULL default ,
 `homeless` varchar(255) NOT NULL default ,
 `financial_review` datetime default NULL,
 `pubpid` varchar(255) NOT NULL default ,
 `pid` bigint(20) NOT NULL default '0',
 `genericname1` varchar(255) NOT NULL default ,
 `genericval1` varchar(255) NOT NULL default ,
 `genericname2` varchar(255) NOT NULL default ,
 `genericval2` varchar(255) NOT NULL default ,
 `hipaa_mail` varchar(3) NOT NULL default ,
 `hipaa_voice` varchar(3) NOT NULL default ,
 `hipaa_notice` varchar(3) NOT NULL default ,
 `hipaa_message` varchar(20) NOT NULL default ,
 `hipaa_allowsms` VARCHAR( 3 ) NOT NULL DEFAULT 'NO',
 `hipaa_allowemail` VARCHAR( 3 ) NOT NULL DEFAULT 'NO',
 `squad` varchar(32) NOT NULL default ,
 `fitness` int(11) NOT NULL default '0',
 `referral_source` varchar(30) NOT NULL default ,
 `usertext1` varchar(255) NOT NULL DEFAULT ,
 `usertext2` varchar(255) NOT NULL DEFAULT ,
 `usertext3` varchar(255) NOT NULL DEFAULT ,
 `usertext4` varchar(255) NOT NULL DEFAULT ,
 `usertext5` varchar(255) NOT NULL DEFAULT ,
 `usertext6` varchar(255) NOT NULL DEFAULT ,
 `usertext7` varchar(255) NOT NULL DEFAULT ,
 `usertext8` varchar(255) NOT NULL DEFAULT ,
 `userlist1` varchar(255) NOT NULL DEFAULT ,
 `userlist2` varchar(255) NOT NULL DEFAULT ,
 `userlist3` varchar(255) NOT NULL DEFAULT ,
 `userlist4` varchar(255) NOT NULL DEFAULT ,
 `userlist5` varchar(255) NOT NULL DEFAULT ,
 `userlist6` varchar(255) NOT NULL DEFAULT ,
 `userlist7` varchar(255) NOT NULL DEFAULT ,
 `pricelevel` varchar(255) NOT NULL default 'standard',
 `regdate`     date DEFAULT NULL COMMENT 'Registration Date',
 `contrastart` date DEFAULT NULL COMMENT 'Date contraceptives initially used',
 UNIQUE KEY `pid` (`pid`),
 KEY `id` (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;


-- -- Table structure for table `lists` --

DROP TABLE IF EXISTS `lists`; CREATE TABLE `lists` ( 

 `id` bigint(20) NOT NULL auto_increment,
 `date` datetime default NULL,
 `type` varchar(255) default NULL,
 `title` varchar(255) default NULL,
 `begdate` date default NULL,
 `enddate` date default NULL,
 `returndate` date default NULL,
 `occurrence` int(11) default '0',
 `classification` int(11) default '0',
 `referredby` varchar(255) default NULL,
 `extrainfo` varchar(255) default NULL,
 `diagnosis` varchar(255) default NULL,
 `activity` tinyint(4) default NULL,
 `comments` longtext,
 `pid` bigint(20) default NULL,
 `user` varchar(255) default NULL,
 `groupname` varchar(255) default NULL,
 `outcome` int(11) NOT NULL default '0',
 `destination` varchar(255) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;


The affected file is "\htdocs\openemr\interface\patient_file\summary\add_edit_issue.php".

Owner and Status

Design - Tony and Thomas

Coding - TBA

Links

Retrieved from "https://www.open-emr.org/wiki/index.php?title=Medication_Allergy_List&oldid=7047"