การบันทึกกิจกรรม เภสัชกรรม สำหรับงานห้องยา ใน Himpro Destkop

เพิ่มรหัสกิจกรรมเข้าไปในฐานข้อมูล โดยรันคำสั่ง sql ตามคำสั่งด้านล่าง (โดยไอทีเป็นคนดำเนินการ)

set @pcucode = (SELECT codehos FROM hosdata.confighos LIMIT 1);
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0001', 'Medication review and reconciliation', '013-01-00', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0002', 'Medication assessment and management plan', '013-01-01', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0003', 'Therapeutic drug monitoring', '014-03-00', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0004', 'Medication information services', '014-03-01', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0005', 'Medication counseling', '014-95-00', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0006', 'Pharmacogenomics service', '014-98-00', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0007', 'Tele pharmacy services', '014-98-01', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0008', 'Pharmacy refilled clinic', '014-98-02', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0009', 'Medication monitoring and evaluation', '014-03-02', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0010', 'Pharmacy services in cardiovascular diseases', '014-98-10', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0011', 'Pharmacy services in internal medicine', '014-98-11', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0012', 'Pharmacy services in kidney diseases', '014-98-12', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0013', 'Pharmacy services in infectious diseases', '014-98-13', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0014', 'Pharmacy services in neurological diseases', '014-98-14', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0015', 'Pharmacy services in psychiatric disorders', '014-98-15', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0016', 'Pharmacy services in pediatrics', '014-98-16', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0017', 'Pharmacy services in critical ill patients', '014-98-17', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0018', 'Pharmacy services in cancer patients', '014-98-18', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0019', 'Pharmacy services in hematology', '014-98-19', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0020', 'Pharmacy services in nutrition therapy', '014-98-20', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0021', 'Pharmacy services in geriatrics', '014-98-21', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0022', 'pharmacy services in organ transplant patients', '014-98-22', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0023', 'Pharmacy services in palliative care', '014-98-23', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0024', 'pharmacy services in intensive management of adverse drug events', '014-98-24', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0025', 'Pharmacy services in pharmacogenomics and precision medicine', '014-98-25', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0026', 'Cytotoxic/ Chemotherapy', '014-98-03', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0027', 'Parenteral nutrition', '014-98-04', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0028', 'Extemporaneous preparations', '014-98-05', 0, NOW());
INSERT IGNORE INTO `hos`.`oper_code` (`pcucode`, `code`, `name`, `icd9`, `nouse`, `date_update`) VALUES (@pcucode, 'P0029', 'IV admixture', '014-98-06', 0, NOW());