CREATE TABLE`pending_txn` ( `id` INT NOT NULL AUTO_INCREMENT ,  
    `transaction_id` VARCHAR(50) NOT NULL ,  `description` VARCHAR(200) NOT NULL ,  
    `head` VARCHAR(10) NOT NULL ,  `subhead` VARCHAR(10) NOT NULL ,  `amount` INT NOT NULL ,  
    `service_type` VARCHAR(50) NOT NULL ,  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,  
    `patient_name` VARCHAR(150) NOT NULL ,  `patient_id` VARCHAR(50) NOT NULL ,  
    `patient_type` VARCHAR(50) NOT NULL ,  `total_amount` INT NOT NULL ,    
    PRIMARY KEY  (`id`)) ENGINE = InnoDB;

---------------------
---------------------
ALTER TABLE `pending_txn` ADD COLUMN `tx_status` VARCHAR(45) NOT NULL DEFAULT 'pending' AFTER `total_amount`;
ALTER TABLE `pending_txn` ADD COLUMN `client_acc` VARCHAR(45) NOT NULL DEFAULT 'pending' AFTER `total_amount`;
ALTER TABLE `mylikita`.`pending_txn` 
DROP COLUMN `id`,
ADD UNIQUE INDEX `transaction_id_UNIQUE` (`transaction_id` ASC) VISIBLE,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`transaction_id`);

ALTER TABLE `mylikita`.`pending_txn` 
CHANGE COLUMN `transaction_id` `transaction_id` INT NOT NULL ;

ALTER TABLE `mylikita`.`pending_txn` 
CHANGE COLUMN `transaction_id` `transaction_id` INT NOT NULL AUTO_INCREMENT ;


INSERT INTO `lab_setup` (`id`, `subhead`, `qms_dept_id`, `description`, `price`, `old_price`, `sort_index`, `account`, `account_name`, `head`, `unit`, `range_from`, `range_to`, `other_range`, `specimen`, `commission_type`, `percentage`, `noOfLabels`, `label_type`, `report_type`, `print_type`, `collect_sample`, `to_be_analyzed`, `to_be_reported`, `upload_doc`, `created_at`, `updated_at`, `facilityId`, `created_by`, `lab_head`, `lab_code`, `department_code`, `department_name`, `unit_code`, `unit_name`, `selectable`, `label_name`, `payable_head`, `payable_head_name`, `receivable_head_name`, `receivable_head`) VALUES
(1, 1000, 0, 'Best Choice Specialist Hospital', 0, 0, 0, NULL, '', 0, NULL, NULL, NULL, '', '', '', 0, 1, 'single', NULL, NULL, 'no', 'yes', NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 0, '', '', '', '', 'not allowed', 'Optimum Diagnostics', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(2, 2000, 3, 'Hematology', 0, 0, 0, NULL, '', 1000, '', '', '', '', 'No specimen', '', 0, 1, 'grouped', NULL, NULL, 'no', 'yes', NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 0, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Hematology', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(6, 2001, 3, 'PCV', 700, 500, 10, '20001', 'Hematology', 2022, '%', '34', '45', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'PCV', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(7, 2002, 3, 'PTTK/APTT', 2500, 2500, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'PTTK/APTT', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(11, 2003, 3, 'Prothrombin time', 2500, 2500, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Prothrombin time', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(15, 2004, 3, 'Reticulocyte', 7000, 7000, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Reticulocyte', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(16, 2005, 3, 'Thrombin Time', 1000, 1000, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Thrombin Time', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(17, 2006, 3, 'VITAMIN B12', 8000, 8000, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'VITAMIN B12', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(18, 2007, 3, 'Blood group & RH', 1000, 700, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'input', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Blood group & RH', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(19, 2008, 3, 'Direct Coombs Test', 1000, 800, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Direct Coombs Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(20, 2009, 3, 'ESR', 1200, 800, 10, '20001', 'Hematology', 2022, 'mm/hr', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'ESR', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(21, 2010, 3, 'FOLATE', 8000, 8000, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'FOLATE', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(22, 2013, 3, 'Haemoglobin Hb', 600, 500, 10, '20001', 'Hematology', 2022, 'g/dL', '13', '15.5', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Haemoglobin Hb', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(23, 2014, 3, 'Indirect Coombs Test', 1500, 1500, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Indirect Coombs Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(24, 2015, 3, 'Fine Niddle Aspiration', 5000, 4000, 10, '20001', 'Hematology', 2022, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Fine Niddle Aspiration', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(0, 2019, 3, 'Clothing Profile', 5000, 5000, 3, '20001', 'Hematology', 2022, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2021-05-11 07:03:50', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Clothing Profile', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(32, 2020, 3, 'HPLC Test', 8000, 6300, 2, '20001', 'Hematology', 2022, '', '', '', NULL, 'Blood', 'percentage', 15, 2, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(43, 2021, 3, 'Full Blood Count', 2200, 1800, 1, '20001', 'Hematology', 2022, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(64, 2022, 3, 'Others', 0, 0, 0, '20001', 'Hematology', 2000, '', '', '', NULL, '', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Others', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(86, 3000, 3, 'Chemical Pathology', 0, 0, 0, NULL, '', 1000, '', '', '', '', 'No specimen', '', 0, 1, 'grouped', NULL, NULL, 'no', 'yes', NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 0, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Chemical Pathology', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(235, 4000, 3, 'Microbiology', 0, 0, 0, '20003', 'Microbiology', 1000, NULL, NULL, NULL, '', 'No specimen', 'percentage', 15, 1, 'single', NULL, NULL, 'no', 'yes', NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', 'not allowed', 'Microbiology', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(236, 4001, 3, 'AFB', 700, 7000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Sputum', 'percentage', 15, 1, 'single', 'macroscopy', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'AFB', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(237, 4002, 3, 'ASCITIC FLUID M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Ascitic Fluid', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'ASCITIC FLUID M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(239, 4004, 3, 'Blood Culture', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Blood Culture', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(240, 4005, 3, 'Brain Abscess M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Fluid', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'no', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Brain Abscess M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(241, 4006, 3, 'Chlamydia-Serum', 2500, 2500, 4, '20003', 'Microbiology', 4045, '', '', '', '', 'Serum', 'percentage', 15, 1, 'grouped', 'input', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'Chlamydia-Serum', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(243, 4009, 3, 'Ear M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Swab', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'no', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Ear M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(244, 4010, 3, 'Eye Swab M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Swab', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Eye Swab M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(245, 4011, 3, 'Fungal Studies', 1500, 1500, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Fungal Studies', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(246, 4012, 3, 'HBs Ag', 1400, 1000, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'HBs Ag', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(247, 4013, 3, 'HCV Ab', 1400, 1000, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'HCV Ab', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(248, 4014, 3, 'HIV Viral Load', 25000, 25000, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'HIV Viral Load', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(249, 4015, 3, 'HVS Culture', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Swab', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'HVS Culture', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(250, 4016, 3, 'Helicobacter pylori (Using Blood)', 1500, 1500, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'grouped', 'yes', 'yes', 'no', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'Helicobacter pylori (Using Blood)', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(251, 4017, 3, 'Hepatitis B Combo.', 3500, 3000, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'Hepatitis B Combo.', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(252, 4018, 3, 'Hepatitis B Viral Load', 25000, 25000, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'Hepatitis B Viral Load', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(253, 4019, 3, 'Hepatitis C Viral Load', 35000, 35000, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'Hepatitis C Viral Load', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(254, 4020, 3, 'MALARIA PARASITES', 700, 1000, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'MALARIA PARASITES', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(255, 4021, 3, 'Malaria RDTs', 500, 500, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'Malaria RDTs', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(256, 4022, 3, 'PERICARDIAL AFB', 700, 700, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Sputum', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'PERICARDIAL AFB', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(257, 4023, 3, 'PERICARDINAL FLUID AFB', 700, 700, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Fluid', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'PERICARDINAL FLUID AFB', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(258, 4024, 3, 'PERICARDINAL FLUID M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Fluid', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'PERICARDINAL FLUID M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(259, 4025, 3, 'PLURAL FLUID M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Fluid', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'PLURAL FLUID M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(261, 4027, 3, 'Prostatic M/ C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Prostatic C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(262, 4028, 3, 'Pus culture & Sen.', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Pus', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Pus culture & Sen.', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(263, 4029, 3, 'Retroviral Screening', 1700, 1500, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'input', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'Retroviral Screening', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(264, 4030, 3, 'SWAB M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Swab', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'SWAB M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(265, 4031, 3, 'Sputum AFB', 800, 700, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Sputum', 'percentage', 15, 1, 'single', 'macroscopy', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Sputum AFB', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(266, 4032, 3, 'Sputum M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Sputum', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Sputum M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(267, 4033, 3, 'Stool M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Stool', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Stool M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(268, 4034, 3, 'Stool Microscopy', 600, 500, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Stool', 'percentage', 15, 1, 'single', 'macroscopy', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Stool Microscopy', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(269, 4035, 3, 'THROAT SWAB', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Swab', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'THROAT SWAB', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(270, 4036, 3, 'TORCHES', 1000, 1000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'TORCHES', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(271, 4037, 3, 'URETHRAL SWAB M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Swab', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'URETHRAL SWAB M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(272, 4038, 3, 'Urinalysis', 700, 500, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'macroscopy', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Urinalysis', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(273, 4039, 3, 'Urine M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Urine M/C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(274, 4040, 3, 'Urine Microscopy', 600, 500, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'macroscopy', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Urine Microscopy', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(275, 4041, 3, 'VDRL', 1500, 1200, 4, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'input', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'VDRL', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(276, 4042, 3, 'WIDAL TEST Ab.', 800, 1000, 0, '20003', 'Microbiology', 4045, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'singular_group', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '7', 'Serology', '', 'WIDAL TEST Ab.', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(281, 4043, 3, 'Wound M/C/S', 3000, 3000, 4, '20003', 'Microbiology', 4044, '', '', '', '', 'Swab', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Wound C/S', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(282, 4044, 3, 'Microbiology', 0, 0, 0, '20003', 'Microbiology', 4000, '', '', '', NULL, 'Stool', 'percentage', 15, 0, 'single', 'microbiology_form', NULL, 'yes', 'yes', NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', 'not allowed', 'Microbiology', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(288, 4045, 3, 'Serology', 0, 0, 0, '20003', 'Microbiology', 4000, '', '', '', NULL, '', 'percentage', 15, 1, 'single', NULL, NULL, 'yes', 'yes', NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', 'not allowed', 'Serology', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(291, 5000, 0, 'Radiology', 0, 0, 0, NULL, '', 1000, '', '', '', '', 'No specimen', '', 0, 1, 'grouped', NULL, NULL, 'no', 'yes', NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 0, '5000', 'Radiology', '1', 'Radiology', 'not allowed', 'Radiology', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(293, 5001, 6, 'ABDOMEN (KUB) X-RAY', 3500, 3200, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ABDOMEN (KUB) X-RAY', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(294, 5002, 4, 'ABDOMEN CT', 40000, 40000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'Abdomen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ABDOMEN CT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(295, 5003, 5, 'ABDOMINAL DOPPLER USS', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ABDOMINAL DOPPLER USS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(296, 5004, 5, 'ABDOMINAL ULTRASOUND SCAN', 2300, 2000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ABDOMINAL ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(297, 5005, 6, 'ANKLE', 4200, 4000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ANKLE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(298, 5006, 6, 'ANKLE BOTH', 7500, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ANKLE BOTH', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(299, 5008, 6, 'Arm X-ray (Both Arms)', 7500, 7000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Arm X-ray (Both Arms)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(300, 5009, 6, 'Arm X-ray (Single)', 4200, 4000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Arm X-ray (Single)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(301, 5010, 6, 'BARIUM ENEMA', 18000, 18000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 3000, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BARIUM ENEMA', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(302, 5011, 6, 'BARIUM MEAL', 15000, 15000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 3000, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BARIUM MEAL', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(303, 5012, 6, 'BARIUM SWALLOW', 12000, 8000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 3000, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BARIUM SWALLOW', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(304, 5013, 6, 'BOTH HANDS', 5000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BOTH HANDS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(305, 5014, 4, 'BRAIN', 35000, 35000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BRAIN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(306, 5015, 5, 'BREAST ULTRASOUND SCAN', 4000, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 30, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BREAST ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(307, 5016, 5, 'BREAST USS DOPPLER', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BREAST USS DOPPLER', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(308, 5017, 6, 'BUTTOCKS X-RAY', 3000, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BUTTOCKS X-RAY', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(309, 5018, 6, 'Burnning image on DVD/CD', 1000, 1000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', '', 0, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Burnning image on DVD/CD', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(310, 5019, 6, 'CARDIAC MARKERS', 6500, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CARDIAC MARKERS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(311, 5020, 5, 'CAROTID ARTERIES DOPPLER USS', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CAROTID ARTERIES DOPPLER USS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(312, 5021, 4, 'CAVERNOSOGRAM', 20000, 20000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 3000, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CAVERNOSOGRAM', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(313, 5022, 4, 'CHEST', 40000, 40000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CHEST', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(314, 5023, 6, 'CHEST X-RAY (AP AND LAT)', 7000, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 300, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CHEST X-RAY (AP AND LAT)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(315, 5024, 6, 'CHEST X-RAY (AP OR PA VIEWS)', 3500, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 300, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CHEST X-RAY (AP OR PA VIEWS)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(316, 5025, 6, 'CHEST X-RAY (LATERAL VEIW)', 3500, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 300, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CHEST X-RAY (LATERAL VEIW)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(317, 5026, 4, 'CIRCLE OF WILLIS', 60000, 60000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CIRCLE OF WILLIS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(318, 5027, 4, 'CLAVICLES', 3000, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CLAVICLES', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(319, 5028, 4, 'CT-ANGIOGRAM', 55000, 50000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-ANGIOGRAM', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(320, 5029, 4, 'CT-BRONCHOGRAPHY', 40000, 50000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-BRONCHOGRAPHY', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(321, 5030, 4, 'CT-CERVICAL SPINE', 35000, 35000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-CERVICAL SPINE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(322, 5031, 4, 'CT-COLONOGRAPHY', 45000, 50000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-COLONOGRAPHY', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(323, 5032, 4, 'CT-FOOT (BOTH)', 40000, 40000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-FOOT (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(324, 5033, 4, 'CT-IVU', 40000, 40000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-IVU', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(325, 5034, 4, 'CT-LUMBAR SPINE', 35000, 35000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-LUMBAR SPINE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(326, 5035, 4, 'CT-MYELOGRAM', 65000, 50000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-MYELOGRAM', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(327, 5036, 4, 'CT-NECK', 35000, 35000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-NECK', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(328, 5037, 4, 'CT-PARANASAL SINUSES', 35000, 45000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-PARANASAL SINUSES', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(329, 5038, 4, 'CT-PELVIS', 40000, 40000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-PELVIS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(330, 5039, 4, 'CT-SHOULDER', 35000, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-SHOULDER', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(331, 5040, 4, 'CT-THORACIC SPINE', 35000, 35000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-THORACIC SPINE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(332, 5041, 6, 'CXR REPORT', 1000, 800, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CXR REPORT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(333, 5042, 6, 'Cervical X-ray', 4200, 4000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Cervical X-ray', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(334, 5043, 5, 'DOPPLER SCAN OF THE PENIS', 22000, 22000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'DOPPLER SCAN OF THE PENIS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(335, 5044, 5, 'DOPPLER VELOCIMETRY', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'DOPPLER VELOCIMETRY', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(336, 5045, 5, 'ECG', 3500, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 700, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', 'not allowed', 'ECG', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(337, 5046, 5, 'ECG (Rest and Stress)', 40000, 40000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 30, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ECG (Rest and Stress)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(338, 5048, 6, 'ELBOW', 3200, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ELBOW', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(339, 5049, 6, 'ELBOW (BOTH)', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ELBOW (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(340, 5050, 6, 'ERECT AND SUPINE', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ERECT AND SUPINE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(341, 5051, 6, 'FACIAL BONES', 4000, 4000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FACIAL BONES', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(342, 5052, 5, 'FACIAL USS', 3000, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'ULTRASOUND', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FACIAL USS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(343, 5053, 6, 'FEMUR AP/LT', 4200, 3500, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FEMUR AP/LT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(344, 5054, 6, 'FEMUR (BOTH)', 7500, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FEMUR (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(345, 5055, 6, 'FOOT (BOTH)', 6000, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FOOT (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(346, 5056, 6, 'FOOT AP', 4200, 3500, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FOOT AP', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(347, 5057, 6, 'FORE ARM AP/LT', 3200, 3200, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FORE ARM AP/LT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(348, 5058, 6, 'FORE ARM (WRIST & ELBOW)', 6000, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FORE ARM (WRIST & ELBOW)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(349, 5059, 6, 'FORE ARM AP/LT (BOTH)', 5000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'FORE ARM AP/LT (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(350, 5060, 5, 'GLUTEAL ULTRASOUND SCAN', 3000, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'GLUTEAL ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(351, 5061, 6, 'HAND', 3200, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'HAND', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(352, 5062, 6, 'HAND (BOTH)', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'HAND (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236');
INSERT INTO `lab_setup` (`id`, `subhead`, `qms_dept_id`, `description`, `price`, `old_price`, `sort_index`, `account`, `account_name`, `head`, `unit`, `range_from`, `range_to`, `other_range`, `specimen`, `commission_type`, `percentage`, `noOfLabels`, `label_type`, `report_type`, `print_type`, `collect_sample`, `to_be_analyzed`, `to_be_reported`, `upload_doc`, `created_at`, `updated_at`, `facilityId`, `created_by`, `lab_head`, `lab_code`, `department_code`, `department_name`, `unit_code`, `unit_name`, `selectable`, `label_name`, `payable_head`, `payable_head_name`, `receivable_head_name`, `receivable_head`) VALUES
(353, 5063, 5, 'HIGH RESOLUTION (SCROTAL) USS', 3200, 3200, 0, '20004', 'Radiology', 50002, '', '', '', '', 'ULTRASOUND', 'fixed', 700, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'HIGH RESOLUTION (SCROTAL) USS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(354, 5064, 4, 'HIGH RESOLUTION CT SCAN', 50000, 40000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'HIGH RESOLUTION CT SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(355, 5065, 5, 'HIGH RESOLUTION ULTRASOUND SCAN', 3200, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'HIGH RESOLUTION ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(356, 5066, 6, 'HIP', 3200, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'HIP', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(357, 5067, 6, 'HIP X-RAY (Both)', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'HIP X-RAY (Both)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(358, 5068, 6, 'HSG', 13500, 13000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 3000, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'HSG', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(359, 5069, 6, 'IVU', 19000, 17000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 3000, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'IVU', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(360, 5070, 6, 'JAW', 3200, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'JAW', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(361, 5071, 6, 'JAW (AP/RT/LT) OBLIQUE', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'JAW (AP/RT/LT) OBLIQUE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(362, 5072, 6, 'KNEE', 3200, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 700, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'KNEE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(363, 5073, 6, 'KNEE X RAY (BOTH)', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'Radiology', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'KNEE X RAY (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(364, 5075, 4, 'LOW DOSE DEXA. SUPPESSION TEST', 25000, 25000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'LOW DOSE DEXA. SUPPESSION TEST', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(365, 5076, 5, 'LOWER LIMB DOPPLER ULTRASOUND SCAN BILATERAL', 22000, 22000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'LOWER LIMB DOPPLER ULTRASOUND SCAN BILATERAL', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(366, 5077, 5, 'LOWER LIMB DOPPLER ULTRASOUND SCAN UNILATERAL', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'LOWER LIMB DOPPLER ULTRASOUND SCAN UNILATERAL', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(367, 5078, 6, 'LUMBO-SACRAL', 4500, 3500, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 700, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'LUMBO-SACRAL', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(368, 5079, 6, 'Leg X-ray (Bilateral)', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Leg X-ray (Bilateral)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(369, 5081, 6, 'Lower Limb (Both Limbs)', 11000, 11000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Lower Limb (Both Limbs)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(370, 5082, 6, 'Lower Limb (One Limb)', 6000, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'Radiology', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Lower Limb (One Limb)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(371, 5083, 6, 'MCUG', 12000, 12000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 25, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'MCUG', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(372, 5084, 6, 'NECK', 3000, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'NECK', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(373, 5085, 5, 'NECK DOPPLER ULTRASOUND SCAN', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'NECK DOPPLER ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(374, 5086, 5, 'NECK DOPPLER USS', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'NECK DOPPLER USS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(375, 5087, 6, 'NECK/THORACIC AP & LAT', 6000, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'NECK/THORACIC AP & LAT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(376, 5088, 5, 'NECK/THYROID ULTRASOUND SCAN', 3200, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'NECK/THYROID ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(377, 5089, 5, 'OBSTETRIC DOPPLER SCAN', 10000, 10000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'OBSTETRIC DOPPLER SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(378, 5090, 5, 'OBSTETRIC ULTRASOUND SCAN', 2500, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'OBSTETRIC ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(379, 5091, 5, 'OCCULAR ULTRASOUND SCAN', 3000, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'OCCULAR ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(380, 5092, 6, 'ORBITS', 3200, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'Radiology', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ORBITS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(381, 5093, 4, 'ORBITAL CUTS / CT ORBITS', 35000, 35000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ORBITAL CUTS / CT ORBITS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(382, 5094, 6, 'PARANASAL SINUSES', 5000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 12, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'PARANASAL SINUSES', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(383, 5095, 5, 'PAROTID ULTRASOUND SCAN', 3200, 3200, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'PAROTID ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(384, 5096, 5, 'PELVIC ULTRASOUND SCAN', 2500, 2000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'PELVIC ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(385, 5097, 6, 'PELVIS X-RAY', 3200, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'PELVIS X-RAY', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(386, 5098, 6, 'PELVIS X-RAY (BOTH)', 5000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 40, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'PELVIS X-RAY (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(387, 5099, 5, 'PENILE DOPPLER USS/ CAVERNOSOGRAPHY', 22000, 22000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'PENILE DOPPLER USS/ CAVERNOSOGRAPHY', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(388, 5100, 4, 'PETROMASTOID CT', 35000, 35000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'PETROMASTOID CT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(389, 5101, 6, 'POST-NASAL SPACE', 3000, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'POST-NASAL SPACE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(390, 5102, 4, 'PULMONARY ANGIOGRAPHY', 60000, 60000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'CT SCAN', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'PULMONARY ANGIOGRAPHY', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(391, 5103, 5, 'RENAL DOPPLER ULTRASOUND SCAN', 15000, 15000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'RENAL DOPPLER ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(392, 5104, 5, 'RENAL ULTRASOUND SCAN', 3000, 2500, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'RENAL ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(393, 5105, 5, 'ROUTINE ABDOMINO-PELVIC ULTRASOUND SCAN', 3500, 2500, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'ROUTINE ABDOMINO-PELVIC ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(394, 5106, 6, 'RUG', 10500, 10000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 30, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'RUG', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(395, 5107, 6, 'RUG/MCUG', 14500, 10000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 3000, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'RUG/MCUG', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(396, 5108, 4, 'Reporting CT Scan done elsewhere', 5000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Reporting CT Scan done elsewhere', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(397, 5109, 0, 'Reporting Plain Radiographs from elsewhere', 1000, 1000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', '', 0, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Reporting Plain Radiographs from elsewhere', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(398, 5110, 6, 'Reporting Special X-Ray Exam done elsewhere', 3000, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', '', 0, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Reporting Special X-Ray Exam done elsewhere', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(399, 5111, 6, 'SCAPULA', 3200, 3200, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'SCAPULA', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(400, 5112, 5, 'SCROTAL DOPPLER ULTRASOUND SCAN', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'SCROTAL DOPPLER ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(401, 5113, 5, 'SCROTAL ULTRASOUND ', 3200, 3200, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'SCROTAL ULTRASOUND ', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(402, 5114, 6, 'SHOULDER', 3300, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'SHOULDER', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(403, 5115, 6, 'SKULL', 3300, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'SKULL', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(404, 5116, 4, 'SPINE', 25000, 40000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'SPINE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(405, 5117, 5, 'SUPRAPUBIC DOPPLER', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'SUPRAPUBIC DOPPLER', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(406, 5118, 6, 'Shoulder (Both)', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Shoulder (Both)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(407, 5119, 5, 'TESTICULAR DOPPLER SCAN', 13000, 10000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'TESTICULAR DOPPLER SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(408, 5120, 5, 'TESTICULAR ULTRASOUND SCAN', 3300, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'TESTICULAR ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(409, 5121, 6, 'THORACIC AP & LATERAL', 3200, 3200, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'THORACIC AP & LATERAL', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(410, 5122, 6, 'THORACO-LUMBAR', 4000, 4000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 600, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'THORACO-LUMBAR', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(411, 5123, 6, 'THORACO-LUMBO-SACRAL', 6000, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'fixed', 1200, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'THORACO-LUMBO-SACRAL', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(412, 5124, 6, 'TRANS-PERINEAL ULRASOUND SCAN', 3300, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'TRANS-PERINEAL ULRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(413, 5125, 5, 'TRANS-RECTAL ULTRASOUND SCAN', 3300, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'TRANS-RECTAL ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(414, 5126, 5, 'TRANS-VAGINAL ULTRASOUND SCAN', 6000, 5000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'TRANS-VAGINAL ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(415, 5127, 5, 'TRANSCRANIAL DOPPLER ULTRASOUND SCAN', 10000, 10000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'TRANSCRANIAL DOPPLER ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(416, 5128, 5, 'TRANSFRONTANNEL ULTRASOUND SCAN', 3000, 3000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'TRANSFRONTANNEL ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(417, 5129, 6, 'UPPER LIMB (BOTH)', 11000, 11000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'UPPER LIMB (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(418, 5130, 5, 'UPPER LIMB DOPPLER USS', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'UPPER LIMB DOPPLER USS', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(419, 5131, 5, 'UPPER LIMB DOPPLER USS (BOTH)', 22000, 22000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'UPPER LIMB DOPPLER USS (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(420, 5132, 5, 'UPPER LIMB ULTRASOUND SCAN', 13000, 13000, 0, '20004', 'Radiology', 50002, '', '', '', '', 'No specimen', 'percentage', 35, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'UPPER LIMB ULTRASOUND SCAN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(421, 5133, 6, 'UPPER LIMB X-RAY (ONE LIMB)', 6000, 6000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 10, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'UPPER LIMB X-RAY (ONE LIMB)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(422, 5134, 6, 'WRIST', 3200, 3000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 20, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'WRIST', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(423, 5135, 6, 'WRIST (BOTH)', 6000, 5000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 40, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'WRIST (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(424, 5136, 6, 'hs CRP', 2500, 2500, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'hs CRP', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(425, 5137, 5, 'ECHO', 12000, 10000, 0, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', 'not allowed', 'ECHO', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(426, 5138, 6, 'Leg X-ray (Unilateral)', 3200, 3000, 3, '20004', 'Radiology', 5139, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'Leg X-ray (Unilateral)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(427, 5139, 0, 'Others', 0, 0, 1, NULL, '', 5000, NULL, NULL, NULL, NULL, '', '', 0, 1, 'grouped', NULL, 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', 'not allowed', 'Others', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(443, 5140, 5, 'LEG ULTRASOUND', 4000, 4000, 10, '20002', 'Chemical Pathology', 50002, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'LEG ULTRASOUND', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(444, 6000, 0, 'Cardiology', 0, 0, 0, NULL, '', 1000, '', '', '', NULL, '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 0, '6000', 'Cardiology', '', '', '', '', '', '', '', ''),
(446, 6045, 5, 'ECG', 3500, 3400, 0, '20004', 'Radiology', 60003, '', '', '', '', 'No specimen', 'fixed', 700, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '6000', 'Cardiology', '1', 'Cardiology', '', 'ECG', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(447, 6137, 5, 'ECHO', 12000, 10000, 0, '20004', 'Radiology', 60003, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '6000', 'Cardiology', '1', 'Radiology', '', 'ECHO', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(448, 7001, 0, 'Cytology', 0, 0, 0, NULL, '', 1000, '', '', '', NULL, '', '', 0, 0, NULL, '', NULL, '', '', '', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 0, '', '', '', '', '', '', '', '', '', ''),
(8, 20021, 3, 'Control(PTT)', 0, 0, 1, '20001', 'Hematology', 2002, 'secs', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'PTTK/APTT', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(9, 20022, 3, 'Sample(PTT)', 0, 0, 2, '20001', 'Hematology', 2002, 'secs', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'PTTK/APTT', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(10, 20023, 3, 'Ratio(PTT)', 0, 0, 3, '20001', 'Hematology', 2002, NULL, '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'PTTK/APTT', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(12, 20031, 3, 'Control(PT)', 0, 0, 1, '20001', 'Hematology', 2003, 'secs', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Prothrombin time', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(13, 20032, 3, 'Sample(PT)', 0, 0, 2, '20001', 'Hematology', 2003, 'secs', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Prothrombin time', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(14, 20033, 3, 'INR(PT)', 0, 0, 3, '20001', 'Hematology', 2003, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Prothrombin time', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(0, 20191, 3, 'Control (PTT)', 0, 0, 4, '20001', 'Hematology', 2019, 'secs', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2021-05-20 14:10:29', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Clothing Profile', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(0, 20192, 3, 'Sample (PTT)', 0, 0, 5, '20001', 'Hematology', 2019, 'secs', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2021-05-20 14:10:29', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Clothing Profile', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(0, 20193, 3, 'Ratio (PTT)', 0, 0, 6, '20001', 'Hematology', 2019, '', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2021-05-20 14:10:29', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Clothing Profile', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(0, 20194, 3, 'Control (PT)', 0, 0, 1, '20001', 'Hematology', 2019, 'secs', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2021-05-20 14:10:29', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Clothing Profile', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(0, 20195, 3, 'Sample (PT)', 0, 0, 4, '20001', 'Hematology', 2019, 'secs', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2021-05-20 14:10:29', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Clothing Profile', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(0, 20196, 3, 'INR (PT)', 0, 0, 5, '20001', 'Hematology', 2019, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2021-05-20 14:10:29', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Clothing Profile', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(33, 20201, 3, 'HbC(hplc)', 0, 0, 1, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(35, 20202, 3, 'LA1c/CHb-1(hplc)', 0, 0, 9, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(36, 20203, 3, 'HbS(hplc)', 0, 0, 10, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(37, 20204, 3, 'A1a(hplc)', 0, 0, 2, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(38, 20205, 3, 'A1b(hplc)', 0, 0, 3, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(39, 20206, 3, 'A1c(hplc)', 0, 0, 4, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(40, 20207, 3, 'A0(hplc)', 0, 0, 5, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(41, 20208, 3, 'A2(hplc)', 0, 0, 6, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(42, 20209, 3, 'F(hplc)', 0, 0, 7, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(44, 20211, 3, 'WBC', 0, 0, 1, '20001', 'Hematology', 2021, '0.02x10^9/L', '4', '10', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(55, 20212, 3, 'LYM#', 0, 0, 2, '20001', 'Hematology', 2021, '10^9/L', '0.6', '4.1', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(57, 20213, 3, 'MID#', 0, 0, 3, '20001', 'Hematology', 2021, '10^9/L', '0.1', '0.9', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(58, 20214, 3, 'GRA#', 0, 0, 4, '20001', 'Hematology', 2021, '10^9/L', '2', '7.8', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(59, 20215, 3, 'LYM%', 0, 0, 5, '20001', 'Hematology', 2021, '%', '20', '50', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(60, 20216, 3, 'MID%', 0, 0, 6, '20001', 'Hematology', 2021, '%', '3', '10', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(61, 20217, 3, 'GRA%', 0, 0, 7, '20001', 'Hematology', 2021, '%', '40', '70', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(62, 20218, 3, 'RBC', 0, 0, 8, '20001', 'Hematology', 2021, '0.02 10^12/L', '3.8', '5.8', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(63, 20219, 3, 'HGB', 0, 0, 9, '20001', 'Hematology', 2021, '0.0 g/dL', '11', '16.5', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(87, 30001, 3, '2H PP', 800, 500, 10, '20002', 'Chemical Pathology', 300102, 'mmol/L', '3.5', '7.7', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', '2H PP', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(88, 30002, 3, '6 POINT GLUCOSE ', 3500, 3200, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', '6 POINT GLUCOSE ', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(89, 30005, 3, 'ASCITIC FLUID CHEMISTRY', 2000, 1500, 10, '20002', 'Chemical Pathology', 300102, '', '7', '45', '', 'Ascitic Fluid', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'ASCITIC FLUID CHEMISTRY', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(90, 30006, 3, 'ASCITIC FLUID LDH', 1500, 1000, 10, '20002', 'Chemical Pathology', 300102, 'U/I', '200', '400', '', 'Ascitic Fluid', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'ASCITIC FLUID LDH', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(91, 30007, 3, 'ASCITIC FLUID PROTEIN', 1000, 1000, 10, '20002', 'Chemical Pathology', 300102, '', '7', '45', '', 'Ascitic Fluid', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'ASCITIC FLUID PROTEIN', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(92, 30009, 3, 'Acid Phosphatase', 2000, 2000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Acid Phosphatase', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(118, 30011, 3, 'Albumin Creatinine Ratio (ACR)', 5000, 5000, 10, '20002', 'Chemical Pathology', 300102, '', '32', '51', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Albumin Creatinine Ratio (ACR)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(119, 30012, 3, 'BONE CHEMISTRY', 1500, 1000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'BONE CHEMISTRY', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(121, 30021, 3, 'CK MB', 2500, 2500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CK MB', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(122, 30023, 3, 'CREATIVE KINASE', 5000, 5000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CREATIVE KINASE', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236');
INSERT INTO `lab_setup` (`id`, `subhead`, `qms_dept_id`, `description`, `price`, `old_price`, `sort_index`, `account`, `account_name`, `head`, `unit`, `range_from`, `range_to`, `other_range`, `specimen`, `commission_type`, `percentage`, `noOfLabels`, `label_type`, `report_type`, `print_type`, `collect_sample`, `to_be_analyzed`, `to_be_reported`, `upload_doc`, `created_at`, `updated_at`, `facilityId`, `created_by`, `lab_head`, `lab_code`, `department_code`, `department_name`, `unit_code`, `unit_name`, `selectable`, `label_name`, `payable_head`, `payable_head_name`, `receivable_head_name`, `receivable_head`) VALUES
(123, 30024, 3, 'CSF (Chloride, Protein & Glucose)', 1500, 1500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'CSF', 'percentage', 15, 2, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CSF (Chloride, Protein & Glucose)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(124, 30027, 3, 'Calcium', 800, 500, 10, '20002', 'Chemical Pathology', 300102, 'mmol/L', '2.15', '2.55', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Calcium', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(125, 30029, 3, 'Cortisol', 7000, 5000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Cortisol', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(126, 30031, 3, 'Creatinine Clearance', 3000, 2500, 10, '20002', 'Chemical Pathology', 300102, 'mmol/L', '55', '110', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Creatinine Clearance', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(127, 30032, 3, 'D - DIMER', 6000, 6000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'D - DIMER', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(128, 30033, 3, 'DEXAMETHASONE SUPPRESSION TEST', 25000, 25000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'DEXAMETHASONE SUPPRESSION TEST', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(129, 30034, 3, 'ESTRADIOL', 7500, 5500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'ESTRADIOL', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(130, 30035, 3, 'FPG/FBS', 600, 500, 10, '20002', 'Chemical Pathology', 300102, 'mmol/L', '3', '5.8', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'FPG/FBS', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(131, 30036, 3, 'FSH', 5500, 5000, 10, '20002', 'Chemical Pathology', 300102, 'mIU/L', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'FSH', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(132, 30037, 3, 'GFR (Glomerula Filtration Rate)', 5000, 5000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'GFR (Glomerula Filtration Rate)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(133, 30038, 3, 'GH - GLUCOSE SEPERATION TEST', 30000, 30000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'GH - GLUCOSE SEPERATION TEST', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(134, 30039, 3, 'GROWTH HORMONE', 5000, 5000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'GROWTH HORMONE', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(135, 30040, 3, 'Gamma GT', 3500, 500, 10, '20002', 'Chemical Pathology', 300102, 'U/I', '7', '45', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Gamma GT', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(136, 30041, 3, 'Globulin.', 600, 500, 10, '20002', 'Chemical Pathology', 300102, 'g/L', '20', '45', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Globulin.', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(137, 30042, 3, 'Glucose (CSF)', 600, 500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Glucose (CSF)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(138, 30043, 3, 'HCG', 6000, 6000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'HCG', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(139, 30046, 3, 'Hb A1 c (STRIP)', 3500, 3500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Hb A1 c (STRIP)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(140, 30047, 3, 'INSULIN', 6000, 6000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'INSULIN', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(141, 30048, 3, 'Inorganic Phosphorus', 700, 500, 10, '20002', 'Chemical Pathology', 300102, 'mmol/L', '0.94', '1.71', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Inorganic Phosphorus', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(142, 30050, 3, 'KARYOTYPING', 70000, 70000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'KARYOTYPING', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(143, 30051, 3, 'LDH', 1500, 1000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'LDH', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(144, 30053, 3, 'LH', 5500, 5000, 10, '20002', 'Chemical Pathology', 300102, 'mIU/L', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'LH', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(145, 30054, 3, 'LIPASE', 5000, 5000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'LIPASE', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(146, 30057, 3, 'MICROALBUMINURIA', 4000, 4000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'MICROALBUMINURIA', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(147, 30058, 3, 'Magnesium (Mg2+)', 1600, 1400, 10, '20002', 'Chemical Pathology', 300102, 'mmol/L', '0.7', '1.2', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Magnesium (Mg2+)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(148, 30059, 3, 'Myoglobin', 5500, 2500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Myoglobin', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(0, 30061, 3, 'OGTT', 3500, 3500, 0, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 4, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2021-05-11 06:59:27', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'OGTT', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(149, 30063, 3, 'PERICARDIAL FLUID (GLUCOSE & PROTEIN)', 2000, 2000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'No specimen', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'PERICARDIAL FLUID (GLUCOSE & PROTEIN)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(150, 30064, 3, 'PLEURAL FLUID CHEMISTRY (GLUCOSE, PROTEIN, LDH)', 3500, 3500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'PLEURAL FLUID CHEMISTRY (GLUCOSE, PROTEIN, LDH)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(151, 30065, 3, 'PROTEIN ESTIMATION', 2500, 2500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'PROTEIN ESTIMATION', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(152, 30066, 3, 'PSA', 5500, 5000, 10, '20002', 'Chemical Pathology', 300102, 'ng/mL', '0', '4', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'PSA', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(153, 30067, 3, 'Pregnancy Test (BHCG Qualitative)', 700, 500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Pregnancy Test (BHCG Qualitative)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(154, 30070, 3, 'Protein (CSF)', 1000, 1000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'CSF', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Protein (CSF)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(155, 30071, 3, 'RHEUMATOID FACTOR', 6500, 6500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'RHEUMATOID FACTOR', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(156, 30072, 3, 'RPG/RBS', 800, 500, 10, '20002', 'Chemical Pathology', 300102, 'mmol/L', '3.2', '7.7', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'RPG/RBS', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(157, 30073, 3, 'SHORT SYNAETHON STIMULATE TEST', 30000, 30000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'SHORT SYNAETHON STIMULATE TEST', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(158, 30074, 3, 'STOOL REDUCING SUBSTANCES', 2000, 2000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'STOOL REDUCING SUBSTANCES', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(159, 30075, 3, 'T.Protein', 1000, 1000, 10, '20002', 'Chemical Pathology', 300102, 'g/L', '55', '85', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'T.Protein', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(160, 30076, 3, 'T3', 2700, 1500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'T3', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(161, 30077, 3, 'T4', 2700, 1500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'T4', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(162, 30078, 3, 'TSH', 2700, 1500, 10, '20002', 'Chemical Pathology', 300102, 'mIU/L', '66', '181', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'TSH', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(163, 30080, 3, 'Triglycerides', 1000, 1000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Triglycerides', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(164, 30081, 3, 'Troponin-I', 6500, 3000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Troponin-I', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(165, 30083, 3, 'URINARY ALBUMIN ', 5000, 5000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'URINARY ALBUMIN ', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(166, 30084, 3, 'URINARY CREATININE', 1000, 1000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'URINARY CREATININE', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(167, 30085, 3, 'URINARY MICROALBUMIN', 5000, 5000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'URINARY MICROALBUMIN', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(168, 30086, 3, 'URINE CALCIUM', 600, 600, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'URINE CALCIUM', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(169, 30087, 3, 'URINE DRUG', 10000, 10000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'URINE DRUG', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(170, 30088, 3, 'URINE ELECTROLYTE', 3000, 3000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'URINE ELECTROLYTE', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(171, 30089, 3, 'URINE PO4', 500, 500, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'URINE PO4', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(172, 30090, 3, 'URINE REDUCING SUBSTANCES', 2000, 2000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'URINE REDUCING SUBSTANCES', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(173, 30092, 3, 'Uric Acid', 1000, 800, 10, '20002', 'Chemical Pathology', 300102, 'umol/L', '200', '430', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Uric Acid', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(174, 30093, 3, 'WATER DEPRIVATION TEST', 50000, 50000, 10, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'WATER DEPRIVATION TEST', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(175, 30094, 3, 'HbA1c', 6500, 5000, 10, '20002', 'Chemical Pathology', 300102, '%', '4.6', '6', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'HbA1c', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(176, 30095, 3, 'Urea, Electrolyte & Creatinine', 3000, 2500, 4, '20002', 'Chemical Pathology', 300102, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Urea, Electrolyte & Creatinine', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(189, 30096, 3, 'Lipids Profile.', 3300, 3000, 5, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Lipids Profile.', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(198, 30097, 3, 'Liver Function Test (LFT)', 4000, 3000, 6, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(217, 30098, 3, 'Tumor Markers', 0, 0, 2, '20002', 'Chemical Pathology', 3000, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Tumor Markers', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(228, 30099, 3, 'Ceresbrospinal Fluid (CSF)', 0, 0, 7, '20002', 'Chemical Pathology', 300102, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Ceresbrospinal Fluid (CSF)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(277, 40422, 3, 'S. Paratyphi A (O, H)', 0, 0, 2, '20003', 'Microbiology', 4042, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'ho_widal', 'singular_group', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '4000', 'Microbiology', '7', 'Serology', 'not allowed', 'WIDAL TEST Ab.', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(278, 40423, 3, 'S. Paratyphi B (O, H)', 0, 0, 3, '20003', 'Microbiology', 4042, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'ho_widal', 'singular_group', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '4000', 'Microbiology', '7', 'Serology', 'not allowed', 'WIDAL TEST Ab.', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(279, 40424, 3, 'S. Typhi (O, H)', 0, 0, 1, '20003', 'Microbiology', 4042, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'ho_widal', 'singular_group', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '4000', 'Microbiology', '7', 'Serology', 'not allowed', 'WIDAL TEST Ab.', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(280, 40425, 3, 'S. Paratyphi C (O, H)', 0, 0, 4, '20003', 'Microbiology', 4042, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'ho_widal', 'singular_group', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '4000', 'Microbiology', '7', 'Serology', 'not allowed', 'WIDAL TEST Ab.', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(292, 50002, 5, 'Ultrasound', 0, 0, 1, NULL, '', 5000, '', '', '', NULL, 'No specimen', '', 0, 1, 'grouped', NULL, 'single', 'no', 'no', 'yes', 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 5000, 4000, '5000', 'Radiology', '1', 'Radiology', 'not allowed', 'Ultrasound', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(445, 60003, 0, 'Others', 0, 0, 2, NULL, '', 6000, '', '', '', NULL, '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 0, '6000', 'Cardiology', '', '', '', '', '', '', '', ''),
(449, 70011, 0, 'Histology', 0, 0, 0, NULL, '', 7001, '', '', '', NULL, '', '', 0, 0, NULL, '', NULL, '', '', '', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 0, '', '', '', '', '', '', '', '', '', ''),
(3, 200019, 3, 'INR', 2500, 2500, 10, '20001', 'Hematology', 2022, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'INR', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(34, 202010, 3, 'P3(hplc)', 0, 0, 8, '20001', 'Hematology', 2020, '%', '', '', NULL, 'Blood', '', 0, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'HPLC Test', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(45, 202110, 3, 'HCT', 0, 0, 10, '20001', 'Hematology', 2021, '0.10%', '35', '50', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(46, 202111, 3, 'MCV', 0, 0, 11, '20001', 'Hematology', 2021, 'fL', '80', '99', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(47, 202112, 3, 'MCH', 0, 0, 12, '20001', 'Hematology', 2021, 'pg', '26.5', '33.5', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(48, 202113, 3, 'MCHC', 0, 0, 13, '20001', 'Hematology', 2021, 'g/L', '320', '360', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(49, 202114, 3, 'RDW-SD', 0, 0, 14, '20001', 'Hematology', 2021, 'fL', '35', '56', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(50, 202115, 3, 'RDW-CV', 0, 0, 15, '20001', 'Hematology', 2021, '%', '10', '15', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(51, 202116, 3, 'PLT', 0, 0, 16, '20001', 'Hematology', 2021, '8x10^9/L', '100', '300', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(52, 202117, 3, 'MPV', 0, 0, 17, '20001', 'Hematology', 2021, 'fL', '7', '11', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(53, 202118, 3, 'PDW', 0, 0, 18, '20001', 'Hematology', 2021, '%', '10', '18', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(54, 202119, 3, 'PCT', 0, 0, 19, '20001', 'Hematology', 2021, '%', '0.1', '0.5', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(56, 202120, 3, 'P-LCR', 0, 0, 20, '20001', 'Hematology', 2021, '%', '13', '43', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'yes', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(65, 202218, 0, 'Full Blood Count + BLOOD FILM', 2500, 1800, 0, '20001', 'Hematology', 2022, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', NULL, 'singular_group', 'no', NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', '', 'Full Blood Count + BLOOD FILM', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(NULL, 202219, 0, 'LFTs', 0, 0, 0, '20001', 'Hematology', 2022, '', '', '', NULL, 'Blood', '', 0, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'no', '', '2021-10-25 10:44:30', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 0, '', '', '', '', '', 'LFTs', '', '', '', ''),
(93, 300100, 3, 'Hormones', 0, 0, 0, '20002', 'Chemical Pathology', 3000, '', '', '', '', 'Blood', 'percentage', 15, 0, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Hormones', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(112, 300101, 3, 'Serum Proteins', 0, 0, 8, '20002', 'Chemical Pathology', 300102, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Serum Proteins', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(115, 300102, 3, 'Routine Chemistry', 0, 0, 3, NULL, '', 3000, NULL, NULL, NULL, NULL, '', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Others', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(117, 300103, 3, '24 HR VMA/HMMAESTIMATION', 35000, 35000, 10, '20002', 'Chemical Pathology', 300102, NULL, NULL, NULL, NULL, 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', '24 HR VMA/HMMAESTIMATION', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(0, 300612, 0, '2H PP (OGTT)', 0, 0, 3, NULL, '', 30061, 'mmol / l', '3.5', '7.7', NULL, 'Blood', '', 15, 0, 'single', 'table', 'grouped', NULL, NULL, NULL, NULL, '2021-06-25 12:30:09', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(0, 300613, 0, '3 Hr PP (OGTT)', 0, 0, 5, NULL, '', 30061, 'mmol / l', '3.8', '6', NULL, 'Blood', '', 15, 0, 'single', 'table', 'grouped', NULL, NULL, NULL, NULL, '2021-06-25 12:30:09', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(0, 300614, 0, '1 Hr PP (OGTT)', 0, 0, 1, NULL, '', 30061, 'mmol / l', '4', '10.5', NULL, 'Blood', '', 15, 0, 'single', 'table', 'grouped', NULL, NULL, NULL, NULL, '2021-06-25 12:30:09', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(0, 300615, 0, '1 1/2 Hr PP (OGTT)', 0, 0, 2, NULL, '', 30061, 'mmol / l', '', '9.9', NULL, 'Blood', '', 15, 1, 'single', 'table', 'grouped', NULL, NULL, NULL, NULL, '2021-10-20 13:26:48', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(0, 300616, 0, 'FPG/FBS', 0, 0, 0, NULL, '', 30061, 'mmol / l', '3', '5.8', NULL, 'Blood', '', 15, 1, 'single', 'table', 'grouped', NULL, NULL, NULL, NULL, '2021-10-20 13:26:48', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(0, 300617, 0, '2 1/2 Hr PP (OGTT)', 0, 0, 4, NULL, '', 30061, 'mmol / l', '', '9.9', NULL, 'Blood', '', 15, 1, 'single', 'table', 'grouped', NULL, NULL, NULL, NULL, '2021-10-20 13:26:48', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(177, 300951, 3, 'Urea', 0, 0, 1, '20002', 'Chemical Pathology', 30095, 'mmol/L', '2.1', '6.9', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Urea, Electrolyte & Creatinine', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(181, 300952, 3, 'K', 0, 0, 3, '20002', 'Chemical Pathology', 30095, 'mmol/L', '3.4', '5.5', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Urea, Electrolyte & Creatinine', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(182, 300953, 3, 'Na', 0, 0, 2, '20002', 'Chemical Pathology', 30095, 'mmol/L', '134', '145', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Urea, Electrolyte & Creatinine', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(183, 300954, 3, 'CL', 0, 0, 4, '20002', 'Chemical Pathology', 30095, 'mmol/L', '94', '108', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Urea, Electrolyte & Creatinine', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(184, 300955, 3, 'HCO3', 0, 0, 5, '20002', 'Chemical Pathology', 30095, 'mmol/L', '22', '28', '', 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Urea, Electrolyte & Creatinine', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(185, 300956, 3, 'Creatinine', 0, 0, 6, '20002', 'Chemical Pathology', 30095, 'mmol/L', '55', '110', '', 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Urea, Electrolyte & Creatinine', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(186, 300958, 3, 'Urea', 800, 500, 1, '20002', 'Chemical Pathology', 300102, 'mmol/L', '2.1', '6.9', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Urea', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(188, 300959, 3, 'K', 700, 600, 3, '20002', 'Chemical Pathology', 300102, 'mmol/L', '3.4', '5.5', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'K', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(190, 300961, 3, 'Cholesterol', 0, 0, 1, '20002', 'Chemical Pathology', 30096, 'mmol/L', '2.5', '6', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Lipids Profile.', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(192, 300962, 3, 'LDL-Cholesterol', 0, 0, 4, '20002', 'Chemical Pathology', 30096, 'mmol/L', '0.8', '4.3', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Lipids Profile.', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(194, 300963, 3, 'HDL - Cholesterol', 0, 0, 2, '20002', 'Chemical Pathology', 30096, 'mmol/L', '0.8', '2.6', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Lipids Profile.', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(196, 300964, 3, 'Triglycerides', 0, 0, 3, '20002', 'Chemical Pathology', 30096, 'mmol/L', '0.5', '2.8', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Lipids Profile.', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(199, 300971, 3, 'ALP', 0, 0, 1, '20002', 'Chemical Pathology', 30097, 'U/I', '42', '110', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(201, 300972, 3, 'ALT (SGPT)', 0, 0, 2, '20002', 'Chemical Pathology', 30097, 'Iu/L', '0', '44', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(203, 300973, 3, 'AST (SGOT)', 0, 0, 3, '20002', 'Chemical Pathology', 30097, 'U/I', '0', '44', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(205, 300974, 3, 'Gamma GT', 0, 0, 4, '20002', 'Chemical Pathology', 30097, 'U/I', '7', '45', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(207, 300975, 3, 'Bilirubin (Total)', 0, 0, 5, '20002', 'Chemical Pathology', 30097, 'umol/L', '4', '18', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(209, 300976, 3, 'Bilirubin (Direct)', 0, 0, 6, '20002', 'Chemical Pathology', 30097, 'umol/L', '0', '7', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(211, 300977, 3, 'T.Protein', 0, 0, 7, '20002', 'Chemical Pathology', 30097, 'g/L', '55', '85', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(213, 300978, 3, 'Albumin', 0, 0, 8, '20002', 'Chemical Pathology', 30097, 'g/L', '32', '52', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(215, 300979, 3, 'Globulin.', 0, 0, 9, '20002', 'Chemical Pathology', 30097, 'g/L', '20', '45', '', 'Urine', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Liver Function Test (LFT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(218, 300981, 3, 'PSA', 5500, 5500, 0, '20002', 'Chemical Pathology', 30098, 'ng/ml', '0', '4', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'PSA', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236');
INSERT INTO `lab_setup` (`id`, `subhead`, `qms_dept_id`, `description`, `price`, `old_price`, `sort_index`, `account`, `account_name`, `head`, `unit`, `range_from`, `range_to`, `other_range`, `specimen`, `commission_type`, `percentage`, `noOfLabels`, `label_type`, `report_type`, `print_type`, `collect_sample`, `to_be_analyzed`, `to_be_reported`, `upload_doc`, `created_at`, `updated_at`, `facilityId`, `created_by`, `lab_head`, `lab_code`, `department_code`, `department_name`, `unit_code`, `unit_name`, `selectable`, `label_name`, `payable_head`, `payable_head_name`, `receivable_head_name`, `receivable_head`) VALUES
(221, 300982, 3, 'HCG', 6000, 6000, 0, '20002', 'Chemical Pathology', 30098, 'm/u/l', '', '<4', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'HCG', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(222, 300983, 3, 'CEA', 7000, 6000, 0, '20002', 'Chemical Pathology', 30098, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'CEA', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(223, 300984, 3, 'CA 125', 8000, 6000, 0, '20002', 'Chemical Pathology', 30098, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'CA 125', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(224, 300985, 3, 'CA - 15 - 3', 8000, 10000, 0, '20002', 'Chemical Pathology', 30098, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'CA - 15 - 3', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(225, 300986, 3, 'VITAMIN B12', 8000, 8000, 0, '20002', 'Chemical Pathology', 30098, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'VITAMIN B12', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(226, 300987, 3, 'FOLATE', 8000, 8000, 0, '20002', 'Chemical Pathology', 30098, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'FOLATE', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(227, 300989, 3, 'AFP (Alpha Feto Protein)', 7000, 6000, 0, '20002', 'Chemical Pathology', 30098, 'U/L', '0', '5', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'AFP (Alpha Feto Protein)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(229, 300991, 3, 'Glucose (CSF)', 0, 0, 0, '20002', 'Chemical Pathology', 30099, 'mg/dl', '2.5', '4.4', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Ceresbrospinal Fluid (CSF)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(231, 300992, 3, 'Protein (CSF)', 0, 0, 0, '20002', 'Chemical Pathology', 30099, 'mg/dl', '15', '40', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Ceresbrospinal Fluid (CSF)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(233, 300993, 3, 'Chloride (csf)', 0, 0, 0, '20002', 'Chemical Pathology', 30099, 'mmol/L', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Ceresbrospinal Fluid (CSF)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(285, 404434, 3, 'MANTOUX', 1000, 1000, 33, '20003', 'Microbiology', 4044, '', '', '', NULL, '', '', 0, 1, 'single', 'microbiology_form', NULL, NULL, NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'MANTOUX', '5000211', 'Microbiology Payables', 'General Patient Receivables', '4000236'),
(287, 404436, 3, 'ECS M/C/S', 3000, 3000, 0, '20004', 'Radiology', 4044, '', '', '', '', 'Tissue/Vaginal Smear', 'percentage', 15, 1, 'grouped', 'microbiology_form', 'single', 'no', 'yes', 'yes', NULL, '2023-09-20 20:00:20', '', '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'ECS M/C/S', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(466, 404437, 0, 'AFB*3', 0, 0, 0, '20003', 'Microbiology', 4044, '', '', '', NULL, 'Stool', 'percentage', 15, 3, 'single', 'input', 'single', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'AFB*3', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(468, 404438, 0, 'Stool for Occult Blood', 1000, 1000, 0, '20003', 'Microbiology', 4044, '', '', '', NULL, 'Stool', 'percentage', 15, 1, NULL, 'input', NULL, 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Stool for Occult Blood', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(469, 404439, 0, 'Helicobacter pylori (Using Stool)', 2000, 2000, 0, '20003', 'Microbiology', 4044, '', '', '', NULL, 'Stool', 'percentage', 15, 1, NULL, 'input', NULL, 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'Helicobacter pylori (Using Stool)', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(NULL, 404440, 3, 'CSF CULTURE', 3000, 3000, 0, '20003', 'Microbiology', 4044, '', '', '', NULL, 'CSF CULTURE', 'percentage', 15, 1, 'single', 'microbiology_form', 'single', 'yes', 'yes', 'no', NULL, '2021-11-07 16:57:26', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 4000, 4000, '4000', 'Microbiology', '6', 'Microbiology', '', 'CSF CULTURE', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(442, 513999, 6, 'BREAST SCAN (BOTH)', 6000, 5000, 98, '20004', 'Radiology', 5139, '', '', '', NULL, '', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'BREAST SCAN (BOTH)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(450, 700111, 0, 'FNAC', 0, 0, 0, NULL, '', 70011, '', '', '', NULL, '', '', 0, 1, 'single', 'input', 'single', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 0, 0, '', '', '', '', '', 'FNAC', '', '', '', ''),
(4, 2000192, 3, 'Sample (PT)', 0, 0, 0, '20001', 'Hematology', 200019, 'secs', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'INR', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(5, 2000193, 3, 'INR (PT)', 0, 0, 0, '20001', 'Hematology', 200019, 'secs', '', '', NULL, 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 2000, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'INR', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(66, 2022181, 3, 'WBC', 0, 0, 1, '20001', 'Hematology', 202218, '0.02x10^9/L', '4', '10', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(67, 2022182, 3, 'HCT', 0, 0, 10, '20001', 'Hematology', 202218, '0.10%', '35', '50', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(68, 2022183, 3, 'MCV', 0, 0, 11, '20001', 'Hematology', 202218, 'fL', '80', '99', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(69, 2022184, 3, 'MCH', 0, 0, 12, '20001', 'Hematology', 202218, 'pg', '26.5', '33.5', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(70, 2022185, 3, 'MCHC', 0, 0, 13, '20001', 'Hematology', 202218, 'g/L', '320', '360', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(71, 2022186, 3, 'RDW-SD', 0, 0, 14, '20001', 'Hematology', 202218, 'fL', '35', '56', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(72, 2022187, 3, 'RDW-CV', 0, 0, 15, '20001', 'Hematology', 202218, '%', '10', '15', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(73, 2022188, 3, 'PLT', 0, 0, 16, '20001', 'Hematology', 202218, '8x10^9/L', '100', '300', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(74, 2022189, 3, 'MPV', 0, 0, 17, '20001', 'Hematology', 202218, 'fL', '7', '11', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(75, 2022190, 3, 'PDW', 0, 0, 18, '20001', 'Hematology', 202218, '%', '10', '18', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(76, 2022191, 3, 'PCT', 0, 0, 19, '20001', 'Hematology', 202218, '%', '0.1', '0.5', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(77, 2022192, 3, 'LYM#', 0, 0, 2, '20001', 'Hematology', 202218, '10^9/L', '0.6', '4.1', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(78, 2022193, 3, 'P-LCR', 0, 0, 20, '20001', 'Hematology', 202218, '%', '13', '43', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(79, 2022194, 3, 'MID#', 0, 0, 3, '20001', 'Hematology', 202218, '10^9/L', '0.1', '0.9', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(80, 2022195, 3, 'GRA#', 0, 0, 4, '20001', 'Hematology', 202218, '10^9/L', '2', '7.8', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(81, 2022196, 3, 'LYM%', 0, 0, 5, '20001', 'Hematology', 202218, '%', '20', '50', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(82, 2022197, 3, 'MID%', 0, 0, 6, '20001', 'Hematology', 202218, '%', '3', '10', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(83, 2022198, 3, 'GRA%', 0, 0, 7, '20001', 'Hematology', 202218, '%', '40', '70', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(84, 2022199, 3, 'RBC', 0, 0, 8, '20001', 'Hematology', 202218, '0.02 10^12/L', '3.8', '5.8', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(85, 2022200, 3, 'HGB', 0, 0, 9, '20001', 'Hematology', 202218, '0.0 g/dL', '11', '16.5', NULL, 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'singular_group', 'no', 'no', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 2000, '2000', 'Hematology', '2', 'Hematology', 'not allowed', 'Full Blood Count + BLOOD FILM', '5000211', 'Hematology Payables', 'General Patient Receivables', '4000236'),
(94, 3001001, 3, 'Oestrogen', 5000, 5000, 0, '20002', 'Chemical Pathology', 300100, 'pg/ml', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'Oestrogen', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(104, 3001002, 3, 'Prolactin', 5500, 5500, 0, '20002', 'Chemical Pathology', 300100, 'mu/L', '72', '511', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'Prolactin', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(105, 3001003, 3, 'Testosterone', 5500, 5000, 0, '20002', 'Chemical Pathology', 300100, 'ng/ml', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'Testosterone', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(106, 3001004, 3, 'T3', 2700, 1500, 0, '20002', 'Chemical Pathology', 300100, 'nmol/L', '1.3', '3.1', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'T3', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(107, 3001005, 3, 'T4', 2700, 1500, 0, '20002', 'Chemical Pathology', 300100, 'nmol/L', '66', '181', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'T4', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(108, 3001006, 3, 'TSH', 2700, 1500, 0, '20002', 'Chemical Pathology', 300100, 'mIU/L', '0.3', '4.2', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'TSH', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(109, 3001007, 3, 'Troponin-I', 6500, 3000, 0, '20002', 'Chemical Pathology', 300100, 'lng/L', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'Troponin-I', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(110, 3001008, 3, 'RHEUMATOID FACTOR', 6500, 6500, 0, '20002', 'Chemical Pathology', 300100, '', '', '', '', 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'RHEUMATOID FACTOR', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(111, 3001009, 3, 'Progesterone', 5500, 5000, 0, '20002', 'Chemical Pathology', 300100, 'ng/I', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'Progesterone', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(451, 3001010, 0, 'Thyroid Function Test', 8100, 4500, 0, '20002', 'Chemical Pathology', 300100, '', '', '', NULL, 'Blood', 'percentage', 15, 2, NULL, 'table', NULL, 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'TSH, T4, T3', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(113, 3001011, 3, 'T.Protein', 0, 0, 0, '20002', 'Chemical Pathology', 300101, 'g/L', '59', '86', NULL, 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Serum Proteins', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(114, 3001013, 3, 'Globulin.', 0, 0, 0, '20002', 'Chemical Pathology', 300101, 'g/L', '20', '43', NULL, 'Blood', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', 'not allowed', 'Serum Proteins', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(178, 3009510, 3, 'Na', 700, 500, 2, '20002', 'Chemical Pathology', 300102, 'mmol/L', '134', '145', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Na', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(179, 3009511, 3, 'CL', 700, 500, 5, '20002', 'Chemical Pathology', 300102, 'mmol/L', '94', '108', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CL', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(180, 3009512, 3, 'HCO3', 700, 500, 4, '20002', 'Chemical Pathology', 300102, 'mmol/L', '22', '28', '', 'Blood', 'percentage', 15, 1, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'HCO3', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(187, 3009580, 3, 'Creatinine', 1000, 600, 6, '20002', 'Chemical Pathology', 300102, 'mmol/L', '55', '110', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Creatinine', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(191, 3009610, 3, 'Cholesterol', 1200, 1000, 0, '20002', 'Chemical Pathology', 300102, 'mmol/L', '2.5', '6', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Cholesterol', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(193, 3009620, 3, 'LDL-Cholesterol', 1000, 1000, 0, '20002', 'Chemical Pathology', 300102, 'mmol/L', '0.8', '4.3', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'LDL-Cholesterol', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(195, 3009630, 3, 'HDL - Cholesterol', 1000, 1000, 0, '20002', 'Chemical Pathology', 300102, 'mmol/L', '0.8', '2.6', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'HDL - Cholesterol', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(197, 3009640, 3, 'Triglycerides', 1000, 1000, 0, '20002', 'Chemical Pathology', 300102, 'mmol/L', '0.5', '2.8', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Triglycerides', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(200, 3009710, 3, 'ALP', 700, 500, 0, '20002', 'Chemical Pathology', 300102, 'U/I', '42', '110', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'ALP', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(202, 3009720, 3, 'ALT (SGPT)', 700, 500, 0, '20002', 'Chemical Pathology', 300102, 'Iu/L', '0', '44', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'ALT (SGPT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(204, 3009730, 3, 'AST (SGOT)', 700, 500, 0, '20002', 'Chemical Pathology', 300102, 'U/I', '0', '44', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'AST (SGOT)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(206, 3009740, 3, 'Gamma GT', 3500, 500, 0, '20002', 'Chemical Pathology', 300102, 'U/I', '7', '45', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Gamma GT', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(208, 3009750, 3, 'Bilirubin (Total)', 700, 500, 0, '20002', 'Chemical Pathology', 300102, 'umol/L', '4', '18', '', 'Urine', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Bilirubin (Total)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(210, 3009760, 3, 'Bilirubin (Direct)', 700, 500, 0, '20002', 'Chemical Pathology', 300102, 'umol/L', '0', '7', '', 'Urine', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Bilirubin (Direct)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(212, 3009770, 3, 'T.Protein', 1000, 1000, 0, '20002', 'Chemical Pathology', 300102, 'g/L', '55', '85', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'T.Protein', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(214, 3009780, 3, 'Albumin', 1000, 500, 0, '20002', 'Chemical Pathology', 300102, 'g/L', '32', '52', '', 'Urine', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Albumin', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(216, 3009790, 3, 'Globulin.', 600, 500, 0, '20002', 'Chemical Pathology', 300102, 'g/L', '20', '45', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Globulin.', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(219, 3009810, 3, 'Amylase', 2500, 2500, 0, '20002', 'Chemical Pathology', 30098, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'Amylase', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(220, 3009811, 3, 'LIPASE', 5000, 5000, 0, '20002', 'Chemical Pathology', 30098, '', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '4', 'Tumor Markers', '', 'LIPASE', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(NULL, 3009812, 0, 'CA 19.9', 8000, 6000, 0, '20002', 'Chemical Pathology', 30098, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'single', 'table', 'single', 'yes', 'yes', 'no', '', '2021-10-30 16:09:33', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CA 19.9', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(230, 3009910, 3, 'Glucose (CSF)', 600, 500, 0, '20002', 'Chemical Pathology', 300102, 'mg/dl', '2.5', '4.4', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Glucose (CSF)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(232, 3009920, 3, 'Protein (CSF)', 1000, 1000, 0, '20002', 'Chemical Pathology', 300102, 'mg/dl', '15', '40', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Protein (CSF)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(234, 3009930, 3, 'Chloride (csf)', 700, 500, 0, '20002', 'Chemical Pathology', 300102, 'mmol/L', '', '', '', 'Urine', 'percentage', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Chloride (csf)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(455, 3009931, 0, 'OGTT', 0, 0, 0, '20002', 'Chemical Pathology', 300102, '', '', '', NULL, '', 'percentage', 15, 4, NULL, 'table', NULL, 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(461, 3009932, 0, 'Glucose', 0, 0, 0, '20002', 'Chemical Pathology', 300102, 'mmol/L', '3.5', '6', NULL, 'CSF', 'percentage', 15, 2, 'grouped_single', 'table', 'singular_group', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CSF (Chloride, Protein & Glucose)', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(462, 3009933, 0, 'Chloride', 0, 0, 0, '20002', 'Chemical Pathology', 30024, 'mmol/L', '94', '108', NULL, 'CSF', 'percentage', 15, 2, 'grouped_single', 'table', 'singular_group', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CSF (Chloride, Protein & Glucose)', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(463, 3009934, 0, 'Protein', 0, 0, 0, '20002', 'Chemical Pathology', 30024, 'mg/L', '15', '40', NULL, 'CSF', 'percentage', 15, 2, 'grouped_single', 'table', 'singular_group', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CSF (Chloride, Protein & Glucose)', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(428, 5139100, 4, 'CT-SCAN BOTH KNEE', 50000, 50000, 99, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-SCAN BOTH KNEE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(429, 5139101, 4, 'CT-ABDOMEN REPORT', 19200, 19200, 100, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-ABDOMEN REPORT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(430, 5139102, 4, 'CT-IVU REPORT', 19200, 19200, 101, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-IVU REPORT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(431, 5139103, 4, 'CT-BRAIN REPORT', 16800, 16800, 102, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-BRAIN REPORT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(432, 5139104, 4, 'CT-CHEST REPORT', 19200, 19200, 103, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-CHEST REPORT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(433, 5139105, 4, 'CT-FEMUR', 25000, 25000, 104, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-FEMUR', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(434, 5139106, 4, 'CT-FOOT (LEFT)', 20000, 20000, 105, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-FOOT (LEFT)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(435, 5139107, 4, 'CT-FOOT (RIGHT)', 20000, 20000, 106, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-FOOT (RIGHT)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(436, 5139108, 4, 'CT-KNEE', 30000, 30000, 107, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-KNEE', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(437, 5139109, 4, 'CT-PARANASAL REPORT', 16800, 16800, 108, '20004', 'Radiology', 5139, '', '', '', NULL, 'CT-SCAN', '', 0, 1, 'grouped', NULL, 'single', 'no', NULL, NULL, 'no', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'CT-PARANASAL REPORT', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(438, 5139110, 4, 'MRI-BRAIN', 55000, 55000, 109, '20004', 'Radiology', 5139, '', '', '', NULL, 'MRI', '', 0, 1, 'grouped', NULL, NULL, 'no', NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'MRI-BRAIN', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(439, 5139111, 5, 'UMBLICAL DOPPLER', 10000, 10000, 110, '20004', 'Radiology', 5139, '', '', '', NULL, '', '', 0, 1, 'grouped', NULL, NULL, 'no', NULL, NULL, 'yes', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'UMBLICAL DOPPLER', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(440, 5139112, 4, 'VENOGRAM (BILATERAL)', 30000, 30000, 111, '20004', 'Radiology', 5139, '', '', '', NULL, '', '', 0, 1, 'grouped', NULL, NULL, 'no', NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'VENOGRAM (BILATERAL)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(441, 5139113, 4, 'VENOGRAM (UNILATERAL)', 20000, 20000, 112, '20004', 'Radiology', 5139, '', '', '', NULL, '', '', 0, 1, 'grouped', NULL, NULL, 'no', NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 0, 4000, '5000', 'Radiology', '1', 'Radiology', '', 'VENOGRAM (UNILATERAL)', '5000211', 'Radiology Payables', 'General Patient Receivables', '4000236'),
(95, 30010010, 3, 'D - DIMER', 6000, 5000, 0, '20002', 'Chemical Pathology', 300100, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'D - DIMER', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(96, 30010011, 3, 'Cortisol', 7000, 5000, 0, '20002', 'Chemical Pathology', 300100, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'Cortisol', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(97, 30010012, 3, 'C - REACTIVE PROTEIN (CRP)', 6000, 2500, 0, '20002', 'Chemical Pathology', 300100, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'C - REACTIVE PROTEIN (CRP)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(98, 30010013, 3, 'HbA1c', 6500, 5000, 0, '20002', 'Chemical Pathology', 300100, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'HbA1c', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(99, 30010014, 3, 'ESTRADIOL', 7500, 2500, 0, '20002', 'Chemical Pathology', 300100, '', '', '', '', 'Blood', 'percentage', 15, 1, 'grouped', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'ESTRADIOL', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(100, 30010015, 3, 'HbA1c (STRIP)', 3500, 3500, 14, '20002', 'Chemical Pathology', 300100, '', '', '', NULL, 'Blood', '', 15, 1, 'single', 'table', 'grouped', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'HbA1c (STRIP)', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(101, 30010016, 3, 'CRP', 6000, 5000, 15, '20002', 'Chemical Pathology', 300100, '', '', '', NULL, 'Blood', '', 15, 1, 'grouped', 'table', 'single', NULL, NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'CRP', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(102, 30010017, 3, 'SERUM FERRITIN', 7000, 7000, 16, '20002', 'Chemical Pathology', 300100, '', '', '', NULL, 'Blood', '', 15, 1, 'grouped', 'table', NULL, NULL, NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'SERUM FERRITIN', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(103, 30010018, 0, 'QUANT.RH_FACTOR', 6500, 6500, 17, '20002', 'Chemical Pathology', 300100, '', '', '', NULL, 'Blood', 'percentage', 15, 1, 'single', 'table', 'single', 'yes', 'yes', 'yes', NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '5', 'Hormones', '', 'QUANT.RH_FACTOR', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(452, 30010101, 0, 'TSH', 0, 0, 0, '20002', 'Chemical Pathology', 3001010, 'mIU/L', '0.3', '3.8', NULL, 'Blood', 'percentage', 15, 2, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'TSH, T4, T3', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(453, 30010102, 0, 'T4', 0, 0, 0, '20002', 'Chemical Pathology', 3001010, 'nmol/L', '66', '188', NULL, 'Blood', 'percentage', 15, 2, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'TSH, T4, T3', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(454, 30010103, 0, 'T3', 0, 0, 0, '20002', 'Chemical Pathology', 3001010, 'nmol/L', '0.3', '3.8', NULL, 'Blood', 'percentage', 15, 2, 'grouped_single', 'table', 'grouped', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'TSH, T4, T3', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(116, 30010280, 3, 'CONPRHENSIVE GPR ESTIMATION', 20000, 20000, 79, '20002', 'Chemical Pathology', 300102, '', '', '', NULL, 'Blood', '', 15, 1, 'single', 'table', NULL, NULL, NULL, NULL, NULL, '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', 'admin', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'CONPRHENSIVE GPR ESTIMATION', '5000211', 'Chemical Pathology Payables', 'General Patient Receivables', '4000236'),
(456, 30099311, 0, 'FPG/FBS', 0, 0, 0, '20002', 'Chemical Pathology', 3009931, 'mmol/L', '3', '5.8', NULL, '', 'percentage', 15, 4, 'single', 'table', 'singular_group', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(457, 30099312, 0, '1 Hr', 0, 0, 0, '20002', 'Chemical Pathology', 3009931, 'mmol/L', '5', '', NULL, '', 'percentage', 15, 4, 'single', 'table', 'singular_group', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(458, 30099313, 0, '1 Hr', 0, 0, 0, '20002', 'Chemical Pathology', 3009931, 'mmol/L', '5', '', NULL, '', 'percentage', 15, 4, 'single', 'table', 'singular_group', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(459, 30099314, 0, '1 Hr', 0, 0, 0, '20002', 'Chemical Pathology', 3009931, 'mmol/L', '5', '', NULL, '', 'percentage', 15, 4, 'single', 'table', 'singular_group', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(460, 30099315, 0, 'OGTT', 0, 0, 0, '20002', 'Chemical Pathology', 3009931, '', '', '', NULL, '', 'percentage', 15, 4, 'single', 'table', 'singular_group', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'OGTT', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(467, 30099331, 0, 'Pregnancy Test (Urine)', 600, 600, 0, '20002', 'Chemical Pathology', 300102, '', '', '', NULL, 'Urine', 'percentage', 15, 1, 'grouped', 'input', 'grouped', 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'Pregnancy Test (Urine)', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236'),
(470, 30099341, 0, 'U & E, LP and LFT, BC, UA', 0, 0, 0, '20002', 'Chemical Pathology', 300102, '', '', '', NULL, 'Blood', 'percentage', 15, 2, NULL, 'table', NULL, 'yes', 'yes', 'no', '', '2023-09-20 20:00:20', NULL, '1be0a9da-bff9-4ab6-a36c-edfd8ca88f1a', '', 3000, 3000, '3000', 'Chemical Pathology', '3', 'Routine Chemistry', '', 'E/U/Cr, LFT, Lipid Profile, Uric Acid, Inorganic Phosphate', '5000211', 'Trade Payables', 'General Patient Receivables', '4000236');





DROP PROCEDURE IF EXISTS pending_txn ;
DELIMITER $$
    CREATE PROCEDURE pending_txn (IN in_query_type VARCHAR(50), IN in_transaction_id VARCHAR(50), IN in_description VARCHAR(100), 
        IN in_head VARCHAR(20), IN in_subhead VARCHAR(20), IN in_amount INT, IN in_service_type VARCHAR(50), 
        IN in_created_at DATETIME, IN in_patient_name VARCHAR(100), IN in_patient_id VARCHAR(20), 
        IN in_patient_type VARCHAR(50), IN in_total_amount INT, IN in_tx_status VARCHAR(45), 
        IN in_date_from DATE, IN in_date_to DATE, IN in_client_acc VARCHAR(50))
    BEGIN
        IF in_query_type = 'save' THEN
            INSERT INTO pending_txn (description, head,subhead, amount, service_type, 
                created_at, patient_name, patient_id, patient_type, total_amount, tx_status, client_acc)
            VALUES (in_description, in_head, in_subhead, in_amount, in_service_type, 
                in_created_at, in_patient_name, in_patient_id, in_patient_type, in_total_amount, 
                in_tx_status, in_client_acc);
        ELSEIF in_query_type = 'get_by_status' THEN
            SELECT * FROM pending_txn WHERE tx_status=in_tx_status AND DATE(created_at) BETWEEN in_date_from AND in_date_to;
        END IF;
    END
$$

---=============================== === === == === ===
ALTER TABLE `mylikita`.`patientrecords` 
ADD COLUMN `enrollee_no` VARCHAR(45) NULL AFTER `patient_passport`,
ADD COLUMN `insurance_scheme` VARCHAR(45) NULL AFTER `enrollee_no`,
ADD COLUMN `hmo` VARCHAR(45) NULL AFTER `insurance_scheme`,
ADD COLUMN `organization` VARCHAR(45) NULL AFTER `hmo`;
