Untitled
unknown
python
a year ago
81 kB
8
Indexable
import psycopg2 import time # Database connection parameters DATABASE = "tariff_digitization" USER = 'postgres' PASSWORD = "7Yn4mFeLNDXz&tH" HOST = "hospital-tariff-application.ctg23hvzex2r.ap-south-1.rds.amazonaws.com" PORT = '5432' def check_connection(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("select version()") data=cursor.fetchone() print("Connection established to: ", data) conn.close() def check_data(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""explain(format yaml) select * from schedule_of_charges where lower(service_description) like lower('%knee%') order by service_description ASC, serial_id ASC limit 50""") table_names = cursor.fetchall() table_n=[] for table_name in table_names: print(table_name) def install_trigram(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""CREATE EXTENSION IF NOT EXISTS pg_trgm;""") print(cursor.statusmessage) conn.commit() print("trigram installed") conn.close() def update_trigram(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""update pg_opclass set opcdefault=true where opcname='gin_trgm_ops';""") print("opcdefault updated") conn.commit() conn.close() def grant_permission(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""GRANT SELECT, INSERT, UPDATE, DELETE ON pg_catalog.pg_opclass TO postgres""") #results=cursor.fetchall() #for result in results: # print(result) conn.commit() print(cursor.rowcount) print("permission granted successfully") conn.close() def query2(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""select table_name from information_schema.tables where table_schema='public';""") #cursor.execute("""select distinct(hospital_id) from schedule_of_Charges where category='0'""") table=cursor.fetchall() #conn.commit() print(table) print("above is the query ran successfully") conn.close() def query_delete_0_category(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""delete from schedule_of_charges where category='0'""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category1(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""update schedule_of_charges set category = trim(category);""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category2(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Ambulance Charges' where category in ('AMBULANCE\xa0CHARGES', 'Ambulance Charges','normal ambulance','AMBULANCE CHARGES','ambulance charges', 'Ambulamce Charges', 'Ambulance', 'AMBULANCE CHARGE', 'Ambulance CHarges', 'AMBULANCE CHARGES', 'Ambulance Charges', 'Ambulance charges', 'AMBULANCE CHARGES', 'Ambulance Charges', 'Ambulance charges'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category3(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Doctor Charges' where category in ('Doctor\xa0Charges', 'Anaesthesia Fee', 'Anaesthetist Charges', 'Anaesthetist Fees', 'Anaesthetists PAC charges', 'Anesthesiologist', 'Anesthesist Charges', 'ANESTHESIST CHARGES', 'Anesthetist Charges', 'CONSULTANT CHARGES', 'Consultation', 'CONSULTATION', 'CONSULTATION CHARGES', 'Consultation charges', 'Consultation Charges', 'Consultation charges', 'Docto Charges', 'Doctor Charges', 'doctor charges', 'DOCTOR CHARGES', 'Doctor CHARGES', 'Doctor charges', 'Doctor Charges', 'Doctor charges', 'DOCTOR FEE', 'Doctor Fee', 'Doctor Fees', 'Doctor fees', 'Doctor monitoring charges', 'Doctor procedure charges', 'Doctor procedure charges (colonoscopy)', 'Doctor visit charges', 'DOCTORE CHARGES', 'Emergency OPD Consultation (DMCH)', 'Emergency OPD Consultation (HDHI)', 'Emergency Procedures (OPD Basis)', 'Emergency Triage Chargeability', 'Emergency Ward Requisition', 'General OPD Consultation (DMCH)', 'General OPD Consultation (HDHI)', 'Onco Wing Consultation', 'OPD Consultation Charges (Per visit)', 'Private OPD Consultation (DMCH)', 'Private OPD Consultation (HDHI)', 'Professional Charges', 'Professional FeesProfessional Fees Professional Fees', 'Visit Charges', 'Visit Charges', 'Visiting Fees', 'Visiting Fees (DMCH)', 'Visiting Fees (HDHI)', 'Visiting Fees (ONCO)', 'Visiting Fees ICU / NSCU', 'Visiting Fees Private', 'Visiting Fees Private (DMCH)', 'OPD CHARGES', 'Doctor fees', 'anaesthesia charges','Anaesthetist charges','Anesthetist charges','Consultancy Fees','consultant charges','Consultant Charges','consultation','consultation charges','CONSULTATION FEES','Counselling','DIETICIAN','Doctor Charges','DOCTOR Charges','DOCTOR CHARGES','doctor fees','DOCTORS FEES','Doctor Charges','DOCTOT CHARGES','Doctror Charges','Health Checkup','Health Check up','HEALTH CHECK-UP PKG','IP VISIT','Pediatrics','PEDIATRICS','Psychiatrist','Super Speciality','VISIT FEE');end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category4(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Equipment Charges' where category in ('AUDIOMETRY','C- ARM','Equipmemt','equipment','Equipment Char','Equipment Charges','EQUIPMENT Charges','EQUIPMENT CHARGES','EQUIPMENTS CHARGES','EQUIPMENT CHARGES','equipmnet charges','Instrument Charges','Instrument & Equipment','MONITOR CHARGES','OXYGEN CHARGES','VENTILATOR', 'Aipha Bed Charges', 'DVT Pump Charges', 'Equipment', 'EQUIPMENT', 'EQUIPMENT CAHRGES', 'EQUIPMENT CHARGE', 'Equipment charges', 'Equipment Charges', 'equipment charges', 'EQUIPMENT CHARGES', 'EQUIPMENT CHARGES ', 'Equipment ChargesMedical EquipmentsMedical EquipmentsArthroscope Instrument Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsBiolitec Laser Charges - Bilateral', 'Equipment ChargesMedical EquipmentsMedical EquipmentsBiolitec Laser Charges - Unilateral', 'Equipment ChargesMedical EquipmentsMedical EquipmentsBipap Machine Charges (Portable)', 'Equipment ChargesMedical EquipmentsMedical EquipmentsC-Arm ( Single Shot - Surgeon)', 'Equipment ChargesMedical EquipmentsMedical EquipmentsC-Arm Charges Per Hour', 'Equipment ChargesMedical EquipmentsMedical EquipmentsC-Arm Single Shot (Anesthesia)', 'Equipment ChargesMedical EquipmentsMedical EquipmentsCardiac Monitor - Per Day', 'Equipment ChargesMedical EquipmentsMedical EquipmentsCencturion Machine Oph Ot', 'Equipment ChargesMedical EquipmentsMedical EquipmentsClipper Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsCoaglator Machine Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsCoblation Instrument Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsComputer Navigation', 'Equipment ChargesMedical EquipmentsMedical EquipmentsCusa Integra', 'Equipment ChargesMedical EquipmentsMedical EquipmentsCusa Machine', 'Equipment ChargesMedical EquipmentsMedical EquipmentsDebrider - Neuro Ot', 'Equipment ChargesMedical EquipmentsMedical EquipmentsDisposable Core Biopsy Instrument', 'Equipment ChargesMedical EquipmentsMedical EquipmentsErbe Biclamp', 'Equipment ChargesMedical EquipmentsMedical EquipmentsEto Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsFiber Optic Brochoscopy Usage Charges 1/2 Hour', 'Equipment ChargesMedical EquipmentsMedical EquipmentsFiber Optic Brochoscopy Usage Charges Per Hour', 'Equipment ChargesMedical EquipmentsMedical EquipmentsFibre Endure Co2', 'Equipment ChargesMedical EquipmentsMedical EquipmentsFlowtron Excel System ( Calf Length )', 'Equipment ChargesMedical EquipmentsMedical EquipmentsFlowtron Excel System ( Full / Thigh Length)', 'Equipment ChargesMedical EquipmentsMedical EquipmentsHaemotherm Machine', 'Equipment ChargesMedical EquipmentsMedical EquipmentsHarmonic Scalpel', 'Equipment ChargesMedical EquipmentsMedical EquipmentsHfnc Charges Per Day', 'Equipment ChargesMedical EquipmentsMedical EquipmentsHfnc Nasal Prongs', 'Equipment ChargesMedical EquipmentsMedical EquipmentsHfnc Tubings', 'Equipment ChargesMedical EquipmentsMedical EquipmentsHysteroscope Instrument Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsInfusion Pump - Per Day', 'Equipment ChargesMedical EquipmentsMedical EquipmentsLaproscopic Instrument', 'Equipment ChargesMedical EquipmentsMedical EquipmentsLigasure', 'Equipment ChargesMedical EquipmentsMedical EquipmentsLipo Suction Machine Pls Ot', 'Equipment ChargesMedical EquipmentsMedical EquipmentsLuminas Laser - Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsMicrodebrider Ent Ot', 'Equipment ChargesMedical EquipmentsMedical EquipmentsMicroscope - Ent Opthal (Major)', 'Equipment ChargesMedical EquipmentsMedical EquipmentsMicroscope - Ent Opthal (Minor)', 'Equipment ChargesMedical EquipmentsMedical EquipmentsMicroscope - Other Departments', 'Equipment ChargesMedical EquipmentsMedical EquipmentsMidas Neuro Drill', 'Equipment ChargesMedical EquipmentsMedical EquipmentsMorcellator Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsNeuro Doppler Intraoperative', 'Equipment ChargesMedical EquipmentsMedical EquipmentsNeuro Monitoring', 'Equipment ChargesMedical EquipmentsMedical EquipmentsNeuro Navigation System', 'Equipment ChargesMedical EquipmentsMedical EquipmentsNim Eclipse Machine Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsO Arm charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsOt Cssd Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsOxygen Charges Per Day', 'Equipment ChargesMedical EquipmentsMedical EquipmentsOxygen Charges Per Hour', 'Equipment ChargesMedical EquipmentsMedical EquipmentsRf Generator', 'Equipment ChargesMedical EquipmentsMedical EquipmentsRns', 'Equipment ChargesMedical EquipmentsMedical EquipmentsSonosite (Ultrasound) Usage Charges Type I', 'Equipment ChargesMedical EquipmentsMedical EquipmentsSonosite (Ultrasound) Usage Charges Type Ii', 'Equipment ChargesMedical EquipmentsMedical EquipmentsSonosite (Ultrasound) Usage Charges Type Iii', 'Equipment ChargesMedical EquipmentsMedical EquipmentsSurgical Bone Drill - 1/2 Hr To 1 Hr', 'Equipment ChargesMedical EquipmentsMedical EquipmentsSyringe Pump Per Day', 'Equipment ChargesMedical EquipmentsMedical EquipmentsT.K.R. Blade', 'Equipment ChargesMedical EquipmentsMedical EquipmentsUretroscope - Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsVentilation Charges', 'Equipment ChargesMedical EquipmentsMedical EquipmentsVentilation Charges - Bipap', 'Equipment ChargesMedical EquipmentsMedical EquipmentsVentillator Charges (4 Hours)', 'EQUIPMENT\xa0CHARGES', 'Equipments', 'EQUIPMENTS charges', 'Medical Equipment', 'Onco Wing Medical Equipment', 'Pressure Care Medical Equipment', 'Pulse Oxymeter', 'Special Equipment Charges', 'Ventilator Charges', 'Ventillator (HDHI)', 'Equipment ChargesMedical EquipmentsMedical EquipmentsSurgical Bone Drill - More Than 1 Hr', 'Equipment ChargesMedical EquipmentsMedical EquipmentsI -Drive Stapler', 'Equipment ChargesMedical EquipmentsMedical EquipmentsFlexible Ureteroscope Charges');end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category5(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'ICU Charges' where category in ('I.C.U.', 'ICU charges', 'ICU Charges', 'ICU/ICCU/NEURO ICU/CARDIO ICU/BURN ICU CHARGES', 'NICU CHARGES (Per Day)', 'PAEDTRIATIC/NEONATAL ICU', 'CCU Charges', 'CRITICAL CARE', 'Critical Care Unit', 'ICU', 'ICU Charges', 'ICU CHarges', 'ICU Charges', 'ICU CHARGES', 'ICU REQUISITION', 'Intensive care charges', 'PICU'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category6(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Investigation Charges' where category in ('Specialized-\nHormone','Radiology -\nX - RAY','C. T. Scan','Profile','ECHO WITH COLOR DOPP','MEDGENOME LABS','STRESS LAB','ECG','Onco Wing PET-CT','radiology','Investigation CHARGES','INVESTIGATIONS charges','ULTRASOUND','Clinical Laboratory','Fetal Medicine','MICRO BIOLOGY','Radiology -CT','HISTO PATHOLOGY','iNVESTIGATION CHARGES','HISTOPATHOLOGY','Lab Rate','LALPATH','CT SCANNING','LABORATORY','BMD','Investiation Charges','Ultra Sound','ECG [HDHI]','CLINICAL LAB BIOCHEMISTRY KH','PATHOLOGY','MICROBIOLOGY','LAB INVESTIGATION','Radiology -USG','CLINICAL PATHOLOGY','Pulmonary Function Lab','Diagnostic (HDHI)','MRI','Investigtion Charges','Dexa Scan','BIOCHEMISTRY','XRAY','SRL Ranbaxy','XRay [DMCH]','Biochemistry','Clinical Pathology','C. T. Scan Procedures','Specialized- Hormone','SPECIAL INVESTIGATION','Histopathology','M R I','M/S Onquest','ALLERGY AND ASTHAMA','Investigation Charges','Ultra Sound [HDHI]','INVESTIGATION CHARGES','Pathology (HDHI)','XRay [HDHI]','INVESTIGATION Charges','labrotory','Radiology - X - RAY','CT SCAN','RADIO DIAGNOSIS & IMAGING','SPECIAL PATHOLOGY','Radiology ServicesRadiology','investigation','MOLECULAR BIOLOGY','ECHO WITH COLOR DOPPLER','Radiology Diagnostic Services','Lab Diagnostic Services','DMCH MOLECULAR GENETICS LABORATORY','Inestigation','INVESTIGATIO N','CLINICAL PATHOLOGY INTERFACING','Pathology','Laboratory','RADIOLOGY','investigation charges','Radiology Rates','INVESTGATION','BIOPSIES','X-RAY & X-RAY PROCEDURES','INVESTIGATION','NON INVASIVE CARDIAC LAB','SEROLOGY','ULTRA SONOGRAPHY','X - RAY CHARGES','Radiology (HDHI)','Radiology -MRI','Specialized- Hormone','Investivation','Radiology','MRI Scan','LABORATORY CHARGE','Nuclear Medicine','NUCLEAR MEDICINE','Investigations','MOLLUSCUM','Invesigation','CT SCAN - MULTISLICE','Microbiology','IDENTIFICATION TAG','STAT LAB','Colour Doppler','X-RAY RATES','Biochemistry (HDHI)','CYTOLOGY','AUDIOLOGY','GENETICS','RADIOLOGY MAIN CT/MRI','GENETICS LAB','X-RAY','CTS','SURGICAL PATHOLOGY','Investigation charges','CATH LAB','PROFILES','INVESTIGATION SPECIAL','CLINICAL BIOCHEMISTRY','SLEEP LAB','Nuclear Medicine (HDHI)','Investigtion charges','Investigation Charges','PETCT EXAMINATIONS','Invetigation Charges','Investigation','Radiology - X - RAY','CLINICAL LAB- HEMATOLOGY','ALLERGY AND ASTHAMA','BONE BIOPSY','CATH LAB','Clinical Pathology','CLINICAL PATHOLOGY INTERFACING','Colour Doppler','CT SCAN','CT SCAN - MULTISLICE','ECHO WITH COLOR DOPP','ECHO WITH COLOR DOPPLER','Fetal Medicine','Histopathology','HISTOPATHOLOGY','Inestigation','INTERVENTIONAL RADIOLOGY','INVERVENTION RADIOLOGY','Invesigation','INVESTGATION','Investiation Charges','investigation','INVESTIGATIO N','Investigation Charges','INVESTIGATIONS charges','INVESTIGATION SPECIAL','Investigtion charges','Investigtion Charges','Invetigation Charges','LAB INVESTIGATION','LABORATORY CHARGE','Lab Rate','labrotory','NON INVASIVE CARDIAC LAB','Nuclear Medicine','Profile','PROFILES','Pulmonary Function Lab','RADIO DIAGNOSIS & IMAGING','radiology','Radiology -CT','Radiology -MRI','Radiology Rates','Radiology -USG','Radiology - X - RAY','Radiology -|Investigation charges X - RAY','SLEEP LAB','SPECIAL INVESTIGATION','Specialized- Hormone','Specialized-| Hormone','SPECIAL PATHOLOGY','STRESS LAB','ULTRA SONOGRAPHY','XRAY','X - RAY CHARGES','X-RAY RATES','X-RAY & X-RAY PROCEDURES', 'Allergy Tests', 'AUDIOLOGY', 'Biochemical Genetics Charges', 'BIOCHEMISTRY', 'Biochemistry', 'Biochemistry (HDHI)', 'Biochemistry Laboratory Charges', 'BIOPSIES', 'BMD', 'BMT', 'C. T. Scan', 'Cardiac Laboratory', 'Cardiac Laboratory Charges', 'CLINICAL BIOCHEMISTRY', 'CLINICAL LAB BIOCHEMISTRY KH', 'CLINICAL LAB- HEMATOLOGY', 'Clinical Laboratory', 'CLINICAL PATHOLOGY', 'Clinical Pathology Charges', 'CT', 'CT Scan Charges', 'CT SCANNING', 'CTS', 'Cytogenetics Charges', 'CYTOLOGY', 'Dexa Scan', 'Diagnostic (HDHI)', 'DMCH MOLECULAR GENETICS LABORATORY', 'ECG', 'ECG [HDHI]', 'Echo Lab Charges', 'Echo Lab Contrast Charges', 'EEG/EMG lab charges', 'GENETICS', 'GENETICS LAB', 'HISTO PATHOLOGY', 'Histopathology Laboratory Charges', 'HLA Serological & Molecular', 'HLA Serological & Molecular Charges', 'INVESTIGATION', 'Investigation', 'Investigation Charges', 'Investigation Charge', 'Investigation Charges', 'INVESTIGATION Charges', 'INVESTIGATION CHARGES', 'Investigation CHARGES', 'investigation charges', 'iNVESTIGATION CHARGES', 'Investigation charges', 'Investigation charges ', 'Investigation Charges ', 'INVESTIGATION CHARGES ', 'Investigations', 'Investivation', 'IVF Investigations', 'IVF Investigations Charges', 'Lab Diagnostic Services', 'LABORATORY', 'Laboratory', 'LALPATH', 'M R I', 'M/S Onquest', 'MEDGENOME LABS', 'MICRO BIOLOGY', 'MICROBIOLOGY', 'Microbiology', 'Microbiology Laboratory Charges', 'MOLECULAR BIOLOGY', 'Molecular Genetics', 'Molecular Genetics Charges', 'Molecular Haematology Laboratory Charges', 'MOLLUSCUM', 'MRI', 'MRI Charges', 'MRI Scan', 'Nuclear Imaging', 'Nuclear Imaging Charges', 'NUCLEAR MEDICINE', 'Nuclear Medicine (HDHI)', 'Nuclear Medicine Laboratory Charges', 'Nuclear Medicine Therapy Charges', 'Onco Wing PET-CT', 'Paediatric cardiac sciences lab charges', 'Pathology', 'PATHOLOGY', 'Pathology (HDHI)', 'PET CT scan', 'PETCT EXAMINATIONS', 'PIP scan charges', 'Radiology', 'RADIOLOGY', 'Radiology (HDHI)', 'Radiology Diagnostic Services', 'RADIOLOGY MAIN CT/MRI', 'RADIOLOGY PROCEDUR', 'Radiology ServicesRadiology', 'Research Lab Charges', 'Respiratory & Chest Medicine Lab Charges', 'SEROLOGY', 'SRL Ranbaxy', 'STAT LAB', 'Stoma care charge', 'Stoma care charges ( Complex )', 'Stoma care charges ( Easy )', 'Stoma care charges ( Extra Complex )', 'Stoma care charges ( Normal )', 'SURGICAL PATHOLOGY', 'Ultra Sound', 'Ultra Sound [HDHI]', 'ULTRASOUND', 'Ultrasound Charges', 'Ultrasound Procedures', 'X-RAY', 'XRay Charges', 'XRay Mammography Charges', 'XRay [DMCH]', 'XRay [HDHI]', 'C. T. Scan Procedures', 'Haematology Laboratory Charges', 'Investigations');end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category7(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Medicines and Consumables' where category in ('MEDICINE AND CONSUMABLE CHARGES','medicine & consumables','medicine & consumbales','Medicines and consumables','Medicines and Consumables','Ward Consumables','Ward consumables(OT stores)', 'Consumable HDHI', 'CT Scan Dye Charges', 'Medicine & Consumables', 'Medicine & consumables', 'MEDICINE & CONSUMMABLES', 'medicine & consummables', 'MEDICINE AND CONSUMABLES', 'Medicine and consumables Charges', 'MEDICINE CHARGES', 'Medicine Charges', 'Medicine charges', 'Medicines and Consumables', 'MEDICINES AND CONSUMABLES', 'MEDINCINE & CONSUMABLES', 'Onco Wing Pharmacy', 'PHARMACY', 'MEDICINE & CONSUMABLES'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category8(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Miscellaneous Charges' where category in ('Miscellaneous Charges','MORGUE CHARGES','MORTUARY CHARGES','Assessment Service','BILIARY SYSTEM','Charges','GENERAL SERVICES','Hospital Services','Hospital services (others)','MEDICAL GAS CHARGES','miscellaneous','Miscellaneous Charges','MISCELLANEOUS SE','MISCELLENEOUS CHARGE','Miscellenous charges','miscelllaneous charges','Mischellaneous','Nutritional and Functional Assessment Charges','OTHER CHARGE','SPEECH & HEARING', 'Alternative medicine charges', 'BLOOD BANK', 'Blood Bank', 'Blood bank crossmatch charges', 'Blood bank issue charges', 'Blood bank procedure charges', 'Blood gas analysis charges', 'BLOOD_COMPONENTS', 'BLOODBANK', 'Bloodbank', 'Bloodbank-A', 'Cardiac rehabilitation charges', 'Charges in INR', 'Child Psychology', 'CLINICAL PSYCHOLOGY', 'Collection Centre', 'DIET', 'Dietician Consultation', 'Dressing set charges', 'Dressing set charges (CVP line)', 'Dressing set charges (in package)', 'Dressing set charges (Tracheostomy)', 'External Fixators', 'Home Care Nursing Charges AOI', 'Home Care Nursing Charges DMCH', 'Home Care Nursing Charges HDHI', 'Homeopathy charges', 'IMPLANT CHARGES', 'INDOOR CHARGES ', 'Lab Blood Bank', 'Metropolis Health Services', 'Misc. Charges', 'MISCELANEOUS CHARGES', 'MISCELLANEOUS', 'Miscellaneous', 'MISCELLANEOUS ', 'MISCELLANEOUS Charges', 'Miscellaneous Charges', 'MISCELLANEOUS CHARGES', 'Miscellaneous charges', 'MISCELLANEOUS CHARGES ', 'Miscellaneous Services', 'Miscelleneous', 'Miscelleneous ', 'Miscelleneous Charge', 'Miscelleneous Charges', 'MISCELLENEOUS CHARGES', 'Miscellenous Charges', 'MISCLAENAEOUS CHARGES', 'MISCLAENAOEUS CHARGES', 'MISCLAENOUS CHARGES', 'MISCLEANEOUS CHARGES', 'MISCLENAEOUS CHARGES', 'MISCLENAOEUS CHARGES', 'MISCLENEOUS CAHRGES', 'MISCLENEOUS CHARGES', 'MISCLLENAEOUS CHARGES', 'Miscllenaeous charges', 'MONITORING CHARGES', 'OCCUPATIONAL THERAPY', 'Onco Wing Blood Bank', 'PHYSICAL MEDICINE & REHABILITATION', 'PHYSICAL MEDICINE AND REHABILITATION', 'PHYSIO THERAPY DEPAR', 'PHYSIOTHERAPY', 'Physiotherapy', 'Physiotherapy and Occupational Therapy', 'PHYSIOTHERAPY AND REHABILITATION', 'Physiotherapy Inpatient Procedures', 'Physiotherapy Opd Tests Charges', 'Physiotherapy Package', 'Psychiatry', 'PSYCHIATRY', 'Psychiatry Procedures', 'PSYCHOLOGY', 'Psychology Assessment', 'RAM SHARNAM SEWA SADAN', 'SPEECH & HEARING KH', 'Traction ', 'Yoga charges', 'Physiotherapy (HDHI)', 'General Charges (HDHI)', 'CONTRAST CHARGES', 'INVESTIGTION CHARGES', 'Physiotheraphy', 'BLOOD BANK ISSUE', 'Miscelleneous charges', 'miscellaneous charges'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category9(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Non-Medical Charges' where category in ('REGISTRATION','Non-medical CHARGES','Non-Medical Charges','Admission Charges','Medical Administration','Administration Charges','Registration Charges','NonMedical','MORTURY CHARGES','Non-medical', 'Administration Charges','Admission Charges','HIRE AND RENTAL','IDENTIFICATION TAG','Medical Administration','MORGUE CHARGES','MORTUARY CHARGES','MORTURY CHARGES','Non-medical','NonMedical','Non-medical CHARGES','Non-Medical Charges','REGISTRATION','Registration Charges', 'Admin Charges', 'Administration', 'Administrative', 'ADVANCE CHARGES', 'Amin Charges', 'DEPOSIT CHARGES', 'M.L.C CHARGES', 'MRD Charges', 'NON MEDICAL CHARGES', 'Non medical charges', 'Non Medical charges', 'NON- MEDICAL CHARGES', 'Non-Medical', 'non-medical charges', 'Non-medical Charges', 'Non-medical charges', 'NON-MEDICAL CHARGES', 'Non-Medical charges', 'Non-Medical Charges', 'NOT ASSIGNED', 'Registration', 'Registration DMCH', 'Registration HDHI', 'Advance Charges'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category10(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Nursing Charges' where category in ('BURN DRESSING','CSSD','C.S.S.D CHARGES','DRESSING CHARGES','INJECTION','INJECTIONS','Nursing and Hospitals Utilities','NURSING CARE CHARGE','NURSING CHAGES','NURSING CHARGE','nursing charges','Nursing Charges','Nursing Charges', 'Nursing', 'NURSING', 'Nursing & Hospitals Utilities', 'Nursing Care Charges (HDHI)', 'Nursing Care Charges (Onco Wing)', 'Nursing charge', 'NURSING CHARGES', 'Nursing charges', 'Nursing Charges', 'Nursing Charges ', 'Nursing Care Charges (DMCH)'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category11(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'OT Charges' where category in ('Operation Theatre','OPERATION THEATRE','OT','OT Charges','O.T. CHARGES','OT charges CHARGES','ot fees','OT CHARGES','Theatre Charges','VENTILATOR CARE', 'Minot OT Charges', 'O. T. Expenses', 'O.T Charges', 'OPERATION THEATER CHARGES', 'OPERATION THEATRE CHARGES', 'Operation Theatre Charges', 'OT Charge', 'OT Charges', 'OT CHARGES', 'OT CHarges', 'ot charges', 'OT charges', 'OT Charges', 'OT charges', 'OT Equipment', 'OT gas charges', 'OT gases charges', 'OT/CATH LAB CHARGE', 'OT\xa0CHARGES', 'THEATRE CHARGES', 'Theatre ChargesTheatre Charges', 'Operation Theater Charges', 'OT INSTRUMENTS', 'OT GASES CHARGES'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category12(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Package Charges' where category in ('Medical Managment','Medical Managment','CARDIOLOGY PACKAGES','CHEMO PACKAGES','HEALTH CHECKUP PACKAGE','IPD PACKAGES','IP PACKAGE','Non Package','OPD PACKAGES','OPHTHALMOLOGY TARIFF PACKAGES(DAY CARE)','OPTHAL CATARACT PACKAGE','Opthalmology Packages','Pacakge Charges','Package Charges','Package Rates','packages','Packages charges','Pre Employment Checkup','RELIGARE HEALTH INSURANCE PACKAGES','Covid Packages Charges', 'HEALTH CHECK', 'Health Check', 'Heart Transplant Package Charges', 'LITHOTRIPSY PACKAGE', 'Liver tranplant package charges', 'PACKAGE', 'Package', 'Package Cahrges', 'package charges', 'PACKAGE CHARGES', 'Package Charges', 'Package charges', 'PACKAGE CHARGES', 'Package charges', 'PACKAGE CHARHES', 'PACKAGE RATES', 'PACKAGES', 'Packages Charges', 'PEDIATRIC CARDIAC SCIENCES PACKAGES', 'Respiratory medicine package charges', 'Robotic Surgery Package', 'Packages', 'Health Checkup Program', 'AV Fistula package');end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category13(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Procedure Charges' where category in ('Bedside/Ward Procedures/Life Support & Other Bio-Medical Equipment & MICS Charges', 'BONE BIOPSY','INTERVENTIONAL RADIOLOGY','RADIOLOGY PROCEDUR','HIRE AND RENTAL','Bedside/Ward Procedures/Life Support & Other Bio-Medical Equipment & MICS Charges','INVERVENTION RADIOLOGY', 'ABDOMEN','ABSCESS DRAINAGE','ADRENAL GLANDS','AMPUTATIONS/DISARTICULATION','Anaesthesiology','Angiography','ANORECTAL','APPENDIX','ARTHROSCOPY OPERATIONS','AUDIO AND SPEECH THERAPY','Bed Side Procedure','BED SIDE PROCEDURES','Bedside/Ward Procedures/Life Support & Other Bio-Medical', 'Equipment & MICS Charges','BREAST SERVICES','Burns & Plastic Surgery','CALDWELLUC''S OPERATION','CARDIAC OCCUPATIONAL','Cardilogy','CARDIOLOGY/COLOUR DOPPLER','Cardiology Investigation','Cardio Surgery Packages','CARDIO THORACIC & VASCULAR SURGERY (CTVS)','CAROIOLOGY','CASUALTY CHARGES','CATARACT SURGERY','Cathlab Charges','CENTRAL STERLIZATION SURGICAL','Chemotherapy','CHEMOTHERAPY','CIRCUMCISION','CLINICAL PROCEDURES','COLONOSCOPY','COLON RECTUM &ANUS','COSMETIC SURGERY','CRITICAL CARE AND RESPIRATORY MEDICINE','CTVS','Cytology','DENTAL','DESOPHAGEAL SURGERY','Details of Opthal Procedures','Details of Physiotherapy Procedures','DIABETOLOGY','DIALYSIS','EAR','EMERGENCY SERVICE CHARGES','ENDOCRINE SURGERY','ENDOSCOPIC PRECEDURES','ENDOSCOPIC SINSU SURGERY','ENDOSCOPY','ENDOSCOPY CHARGES','ent','E.N.T','ENTEROSCOPY','ENT Procedure Charge','ENT SURGERIES LIST & GRADES','ENT - SURGERY','ERCP','ESWL-GASTROENTROLOGY','ETHAMOIDECTOMY','EXTERNAL ETHMOIDECTOMY','FRACTURES','G 1 SURGERY','GA CHARGES','GAROIOLOGY','GASTEROENTROLGOY','Gastroenterology','Gastroentrology','GASTROENTROLOGY','GENERAL PROCEDURES','General Speciality','GENERAL SURGERY & MEDICINE','GEN SURGERIES LIST','GI SURGERIES LIST','GI SURGERY','Glaucoma','GLAUCOMA SURGERY','GRADE SURGERY','Grade X Surgery List','GROUP-1 (D&C RELATED)','GYANE & OBST','GYNAECOLOGY LAPAROSCOPIC SURGERY','HAEMATOLOGY','HALF OF BODY','HAND SURGERIES LIST','HEAD AND NECK SURGERY','Hematology','HERNIA','HIP SURGERY','Immunology','INTERMEDIATE SURGERY-L1','INTERMEDIATE SURGERY-L2','INTERVENTIONAL NEUROLOGY','INTRAL NASAL ANTROSTOMY','Invasive Procedures','IVC FILTER','IVF','JOINT REPLACEMENT & SPORTS MEDICINE','KNEE REPLACEMENT','LAPAROSCOPIC SURGERY PROCEDURE','LAPROSCOPIC SURGERY PACKAGE','LASER PROCEDURES','LASERS','Lithotripsy Charges','LIVER','MAJOR PLUS SURGERY-L1','MAJOR PLUS SURGERY-L2','MAJOR PLUS SURGERY-L3','MAJOR PLUS SURGERY-L4','MAJOR SURGERY-L1','MAJOR SURGERY-L2','MAJOR SURGERY- L3','Mammogram','MATERIAL CHARGES','MAXILLECOMY','Medical','MEDICAL /SURGICAL PROCEDURE','MICROLARYNGEAL SURGERY','MINOR PROCEDURES','MINOR SURGERY-L1','MINOR SURGERY-L2','MINOR SURGERY (UNDER LA- NON MICROSCOPTC)','MISCELLANEOUS PROCEDURE','NEPHROLOGY/UROLOGY','NEURO SURGERIES LIST','NEURO SURGERY','NEW GIPSA PROCEDURES','Non Invasive Procedure','NOSE','OBS AND GYNAE','Obs & Gynaec','Obs & Gynaecology','OBSTETRICS & GYNAECOLOGY','OBSTETRICS & GYNE','OBSTETRICS & GYNE.','OBST & GYNAECOLOGY SURGERY LIST','OCULAR TRAUMA SURGERY','OCULOPLASTY SURGERY','ONCOLOGY','ONCO SURGERIES LIST','O.P.D. PROCEDURE','OPD PROCEDURE','OPEN CATEGORY CHOLECYSTECTOMY','Ophthalmology','Opthalmology','ORTHO CASES','ORTHOPAEDIC: SPINE SURGERY','ORTHOPAEDICS SURGERIES','Orthopedics','OTHER PROCEDURES','OTHER RADIOLOGY PROCEDURES','Other surgeries','OTO - RHINO - LARYNGOLOGY','OUTSIDE TEST (METROPOLIS)','PACKING','PAEDITARIC SURGERY','PARTIAL TURBINECTOMY','PEDIATRIC SURGERY LIST','PENIS & TESTIS','PHARAPHARYNGEAL SPACE','PHOTOTHERAPY','Plaster Charges','PLASTERING','PLASTIC AND COSMETIC SURGERY','PLASTIC SURGERY LIST','PMR','POLIO SURGERY','Procedure Charges','procedures','PROCEDURES','PROCEDURE S','Procedure Charges Break-up','PULMONARY & MEDIASTINAL','Pulmonary Medicine','PULMONARY MEDICINE','Pulmonary & Respiratory Procedures','PUNCH BIOPSY','Radiation Oncology','REFRACTIVE SURGERY','RETINA AND VITREO-RETINA SURGERY','REVISION KNEE REPLACEMENT','Serology','SERVICE CHARGES','Slab application','SMALL INTESTINES','Specialized- Hematology','SPECIALIZED SKIN & VD PROCEDURES','SPINE SURGERY','SQUINT SURGERY','STYLOIDECTOMY','SUCTION / DEBRIDEMENT','SUPRA MAJOR PLUS -SURGERY-L1','SUPRA MAJOR PLUS -SURGERY-L2','SUPRA MAJOR PLUS -SURGERY-L3','SUPRA MAJOR PLUS -SURGERY-L4','SUPRA MAJOR PLUS -SURGERY-L5','SUPRA MAJOR SURGERY-L1','SUPRA MAJOR SURGERY-L2','SUPRA MAJOR SURGERY-L3','SUPRA MAJOR SURGERY-L4','SUPRA MAJOR SURGERY-L5','Surgeon Procedure','Surgeries','surgery','SURGERY','SURGICAL PREPARATION CHARGES','Surgoen charges','THERAPEUTIC REMOVAL OF GRANULATION','THORACIC SURGERY SURGEON FEE','THROAT','TRANSPALATAL EXCISION','TRANSPALATAL PROCEDURES','TREATMENT CHARGES','UROLOGY INTERMEDIATE PROCEDURE','UROLOGY MAJOR PLUS PROCEDURE','UROLOGY MAJOR PROCEDURE','UROLOGY MINOR PROCEDURE','Urology Procedure','UROLOGY & RENAL TRANSPLANT','UROLOGY SURGICAL LIST','UROLOGY & URO SURGERY','Uro/Nephrology','VASCULAR','VILENT Procedures', 'Access Procedures For Dialysis', 'Accident & Emergency', 'Accident & Emergency (A&E)', 'Aesthetic Surgery', 'Amputations And Disarticulations', 'Anaesthesia', 'ANAESTHESIA CHARGE', 'ANAESTHESIA CHARGES', 'Anaesthesia Charges', 'ANAESTHESIOLOGY', 'ANAESTHESIOLOGY & CRITICAL CARE', 'ANAESTHESIOLOGY Charges', 'ANASTHESIA CHARGES', 'ANESTHESIA', 'Anesthesia (medicines) Charges', 'Anesthesia Charges', 'ANESTHESIA CHARGES', 'Ano‐rectal Operations', 'Aortic Aneurysm Operations', 'Appendicular Operations', 'Arteriar', 'Arthotomy', 'Arthrodesis', 'Arthroscopic Surgery', 'Arthroscopy', 'Bariatric Surgery', 'Bedside Procedure', 'Bedside procedure charges (Glucometry)', 'Bedsore Operations', 'Bone grafting', 'Bone Tumors', 'Bone Tumour Operations', 'BREAST CENTRE', 'Breast Operations', 'BREAST SURGERY', 'Bronchoscopy procedures', 'C. S. S. D', 'C. S. S. D (HDHI)', 'C.T.E.V. ( club foot)', 'Caediology', 'Cardiac Anaesthesia', 'CARDIAC PROCEDURE', 'Cardiac Procedures', 'Cardiac Surgery', 'CARDIAC SURGERY', 'CARDIO PULMONARY R', 'CARDIO-THORACIC', 'CARDIO-THORACIO', 'Cardiology', 'CARDIOLOGY', 'Cardiothoracic', 'Cardiothoracic Surgery', 'CASUALITY AND TRAUM', 'Cath Lab Procedures', 'CENTRAL STERILE SUPPLY DEPT', 'Chest', 'Chronic O.M.', 'Cleft Lip And Palate Operations', 'Closed Reduction And Internal Fixation', 'CORNEA TRANSPLANT', 'Cosmetic Surgeries', 'Critical Care Procedures', 'CRITICAL MEDICINE', 'CRRT Charges (HDHI)', 'Dental', 'Dental Charges', 'DENTAL SURGERY', 'DENTAL SURGERY', 'Dentistry / Dental', 'DENTISTRY AND MAXILLOFACIAL SURGERY', 'DERMATOLOGY', 'Dermatology', 'Dermatology Procedure Charges', 'Diabetic foot clinic procedures', 'Diabetology and Endocrinology', 'Diabetology Laboratory Charges', 'DS - CARDIOLOGY', 'E N T', 'E. C. G.', 'EAR NECK THROAT', 'EMERGENCY', 'Emergency', 'EMERGENCY CHARGES', 'Emergency Charges', 'EMERGENCY MEDICINE', 'Endocrine Operations', 'Endocrinology', 'Endomyocardial Package ‐ Package\nCharges', 'Endomyocardial Package\nPostHeart Tx ‐ Package Charges', 'Endoscopy / G. I.', 'Ent', 'ENT', 'ENT AND COCHLEAR IMPLANT', 'ENT charges', 'ENT OPERATION CHARGES', 'ENT Procedure Charges', 'Eye And Eyelid Operations', 'EYE SURGERY PROCEDURE', 'Fasciotrauma', 'FERTILITY CENTER', 'FETAL MEDICINE', 'Fetal Medicine Charges', 'FOOT CARE', 'Foot Surgery', 'Fracture Neck Femur', 'GAMMA CAMERA', 'GASTEROENTEROLOGY', 'Gastro Surgical', 'Gastro‐duodenal Operations', 'GASTROENTERLOGY', 'GASTROENTEROLOGY', 'Gastroenterology Consultation', 'GENERAL MEDICINE', 'General Operations', 'GENERAL SURGERY', 'Genetics Procedures', 'GI AND BARIATRIC SURGERY', 'GRIPMER FUND', 'Gynae', 'GYNAEC & OBSTETRIC PROCEDURE', 'GYNAECOLOGY', 'Hand Surgery', 'Head And Neck Operations', 'Hepato‐bilio‐pancreatic Operations', 'Hernia Operations', 'Hospital Charge', 'Hospital charges', 'Hospital Charges CIC', 'Hospital charges for haemodialysis', 'Hospital Service', 'HOSPITAL SERVICES', 'HOSPITALITY SERVICES', 'Hydatid Cyst Operations', 'HYPERTENSION (HDHI)', 'IABP Charges (HDHI)', 'IBD Panel (Gastro)', 'Implant Removal G.A.', 'INFECTIOUS DISEASES', 'INFERTILITY/REPRODUCTIVE MEDICINE', 'INPATIENT PROCEDURES', 'Inpatient Services', 'INTEGRATED LIVER CARE', 'INTERVENTIONAL CARDIOLOGY', 'Interventional Neurology', 'Interventional Radiology', 'Interventional Radiology Procedures', 'Intestinal Operations', 'IVF Centre', 'IVF Procedures', 'Kidney Transplantation', 'Knee joint - Amputations', 'KTP Charges', 'lbow Jiont', 'Levels', 'LIFE SCIENCE', 'Liver Transplant / Hepatobiliary Surgery', 'Lymphadenectomy', 'Medical Facility', 'Medical Gastro', 'MEDICAL ONCOLOGY', 'MINOR CASES', 'MINOR PROCEDURE CHARGES', 'Miscellaneous Orthopaedics Procedures', 'Miscellaneous Vascular Operations', 'Morbid Obesity Operations', 'NEONATAL', 'NEONATOL', 'NEONATOLOGY', 'Neonatology Test', 'NEPHROLOGY', 'Nephrology', 'NEPHROLOGY (DIALYSIS)', 'NEPHROLOGY AND KIDNEY TRANSPLANT', 'Nephrology Procedures', 'Nerve Operations', 'NEURO ENDOVASCULAR PROCEDURES', 'NEURO REHABILITATION', 'Neuro Surgery', 'NEURO SURGERY PROCEDURE', 'NEURO-SURGEY', 'Neurology', 'NEUROLOGY', 'NEUROPSYCHOLOGY', 'NEUROSURGERY', 'Neurosurgery', 'NICU', 'NON INVASIVE CARDIOLOGY', 'OB_GYN', 'OBG', 'OBSTETRIC CASES', 'Obstetrics & Gynaecology', 'OBSTETRICS & GYNECOLOGY', 'OBSTETRICS AND GYNAECOLOGY', 'Oesophageal Operations', 'Onco Surgery', 'Onco Wing Accident and Emergency', 'Onco Wing Medical Oncology', 'Onco Wing Nursing and Hospital Utilities', 'Onco Wing Radiation Oncology', 'Onco Wing Registration Oncology', 'Oncology', 'ONCOLOGY - MEDICAL AND SURGICAL', 'Oncology Medical', 'Oncology Procedures', 'ONCOLOGY SURGICAL', 'Open Reduction', 'Open Reduction And Internal Fixation', 'Open Reduction under G.A. and internal fexation', 'Operations For Dislocations', 'Operations For Portal Hypertension', 'OPHTHALMOLOGY', 'Ophthalmology OPD procedure charges', 'Ophthalmology Procedure Charges', 'Ophthalmology Procedures', 'Ophthalomology', 'OPTHALMOLOGY', 'OPTHALMOLOGY OPTHALMOLOGY', 'OPTHALMOLOGY SOPT001', 'OPTHALMOLOGY SOPT002', 'OPTHALMOLOGY SOPT003', 'OPTHALMOLOGY SOPT004', 'OPTHALMOLOGY SOPT005', 'OPTHALMOLOGY SOPT006', 'OPTHALMOLOGY SOPT007', 'OPTHALMOLOGY SOPT008', 'OPTHALMOLOGY SOPT009', 'OPTHALMOLOGY SOPT010', 'OPTHALMOLOGY SOPT011', 'OPTHALMOLOGY SOPT012', 'OPTHALMOLOGY SOPT013', 'OPTHALMOLOGY SOPT014', 'OPTHALMOLOGY SOPT015', 'OPTHALMOLOGY SOPT016', 'OPTHALMOLOGY SOPT017', 'OPTHALMOLOGY SOPT019', 'OPTHALMOLOGY SOPT020', 'OPTHALMOLOGY SOPT021', 'OPTHALMOLOGY SOPT022', 'OPTHALMOLOGY SOPT023', 'OPTHALMOLOGY SOPT024', 'OPTHALMOLOGY SOPT025', 'OPTHALMOLOGY SOPT026', 'OPTHALMOLOGY SOPT027', 'OPTHALMOLOGY SOPT028', 'OPTHALMOLOGY SOPT029', 'OPTHALMOLOGY SOPT030', 'OPTHALMOLOGY SOPT031', 'OPTHALMOLOGY SOPT032', 'OPTHALMOLOGY SOPT033', 'OPTHALMOLOGY SOPT034', 'OPTHALMOLOGY SOPT035', 'OPTHALMOLOGY SOPT036', 'OPTHALMOLOGY SOPT037', 'OPTHALMOLOGY SOPT038', 'OPTHALMOLOGY SOPT039', 'OPTHALMOLOGY SOPT040', 'OPTHALMOLOGY SOPT041', 'OPTHALMOLOGY SOPT042', 'OPTHALMOLOGY SOPT043', 'OPTHALMOLOGY SOPT044', 'OPTHALMOLOGY SOPT045', 'OPTHALMOLOGY SOPT046', 'OPTHALMOLOGY SOPT047', 'OPTHALMOLOGY SOPT048', 'OPTHALMOLOGY SOPT049', 'OPTHALMOLOGY SOPT050', 'OPTHALMOLOGY SOPT051', 'OPTHALMOLOGY SOPT052', 'OPTHALMOLOGY SOPT053', 'OPTHALMOLOGY SOPT054', 'OPTHALMOLOGY SOPT055', 'OPTHALMOLOGY SOPT056', 'OPTHALMOLOGY SOPT057', 'OPTHALMOLOGY SOPT058', 'OPTHALMOLOGY SOPT059', 'OPTHALMOLOGY SOPT060', 'OPTHALMOLOGY SOPT061', 'OPTHALMOLOGY SOPT062', 'OPTHALMOLOGY SOPT063', 'OPTHALMOLOGY SOPT064', 'OPTHALMOLOGY SOPT065', 'OPTHALMOLOGY SOPT066', 'OPTHALMOLOGY SOPT067', 'OPTHALMOLOGY SOPT068', 'OPTHALMOLOGY SOPT069', 'OPTHALMOLOGY SOPT070', 'OPTHALMOLOGY SOPT071', 'OPTHALMOLOGY SOPT073', 'OPTHALMOLOGY SOPT074', 'OPTHALMOLOGY SOPT075', 'OPTHALMOLOGY SOPT076', 'OPTHALMOLOGY SOPT077', 'OPTHALMOLOGY SOPT078', 'OPTHALMOLOGY SOPT079', 'OPTHALMOLOGY SOPT080', 'OPTHALMOLOGY SOPT081', 'OPTHALMOLOGY SOPT082', 'OPTHALMOLOGY SOPT083', 'OPTHALMOLOGY SOPT084', 'OPTHALMOLOGY SOPT085', 'OPTHALMOLOGY SOPT086', 'OPTHALMOLOGY SOPT087', 'OPTHALMOLOGY SOPT088', 'OPTHALMOLOGY SOPT089', 'OPTHALMOLOGY SOPT090', 'OPTHALMOLOGY SOPT091', 'OPTHALMOLOGY SOPT092', 'OPTHALMOLOGY SOPT093', 'OPTHALMOLOGY SOPT094', 'OPTHALMOLOGY SOPT095', 'OPTHALMOLOGY SOPT096', 'OPTHALMOLOGY SOPT097', 'OPTHALMOLOGY SOPT098', 'OPTHALMOLOGY SOPT099', 'OPTHALMOLOGY SOPT100', 'OPTHALMOLOGY SOPT101', 'OPTHALMOLOGY SOPT102', 'OPTHALMOLOGY SOPT103', 'OPTHALMOLOGY SOPT104', 'OPTHALMOLOGY SOPT105', 'OPTHALMOLOGY SOPT106', 'OPTHALMOLOGY SOPT107', 'OPTHALMOLOGY SOPT108', 'OPTHALMOLOGY SOPT109', 'OPTHALMOLOGY SOPT110', 'OPTHALMOLOGY SOPT111', 'OPTHALMOLOGY SOPT112', 'OPTHALMOLOGY SOPT113', 'OPTHALMOLOGY SOPT114', 'OPTHALMOLOGY SOPT115', 'OPTHALMOLOGY SOPT116', 'OPTHALMOLOGY SOPT117', 'OPTHALMOLOGY SOPT118', 'OPTHALMOLOGY SOPT119', 'OPTHALMOLOGY SOPT120', 'OPTHALMOLOGY SOPT121', 'OPTHALMOLOGY SOPT122', 'OPTHALMOLOGY SOPT123', 'OPTHALMOLOGY SOPT124', 'OPTHALMOLOGY SOPT125', 'OPTHALMOLOGY SOPT126', 'OPTHALMOLOGY SOPT127', 'OPTHALMOLOGY SOPT128', 'OPTHALMOLOGY SOPT129', 'OPTHALMOLOGY SOPT130', 'OPTHALMOLOGY SOPT131', 'OPTHALMOLOGY SOPT132', 'OPTHALMOLOGY SOPT133', 'OPTHALMOLOGY SOPT134', 'OPTHALMOLOGY SOPT135', 'OPTHALMOLOGY SOPT136', 'OPTHALMOLOGY SOPT137', 'OPTHALMOLOGY SOPT138', 'OPTHALMOLOGY SOPT139', 'OPTHALMOLOGY SOPT140', 'OPTHALMOLOGY SOPT141', 'OPTHALMOLOGY SOPT142', 'OPTHALMOLOGY SOPT143', 'OPTHALMOLOGY SOPT144', 'OPTHALMOLOGY SOPT145', 'OPTHALMOLOGY SOPT147', 'OPTHALMOLOGY SOPT148', 'OPTHALMOLOGY SOPT149', 'OPTHALMOLOGY SOPT150', 'OPTHALMOLOGY SOPT151', 'OPTHALMOLOGY SOPT153', 'OPTHALMOLOGY SOPT154', 'OPTHALMOLOGY SOPT155', 'OPTHALMOLOGY SOPT156', 'OPTHALMOLOGY SOPT157', 'OPTHALMOLOGY SOPT158', 'OPTHALMOLOGY SOPT159', 'OPTHALMOLOGY SOPT160', 'OPTHALMOLOGY SOPT161', 'OPTHALMOLOGY SOPT162', 'OPTHALMOLOGY SOPT163', 'OPTHALMOLOGY SOPT164', 'OPTHALMOLOGY SOPT165', 'OPTHALMOLOGY SOPT166', 'OPTHALMOLOGY SOPT167', 'OPTHALMOLOGY SOPT168', 'OPTHALMOLOGY SOPT169', 'OPTHALMOLOGY SOPT170', 'OPTHALMOLOGY SOPT171', 'OPTHALMOLOGY SOPT173', 'OPTHALMOLOGY SOPT174', 'OPTHALMOLOGY SOPT175', 'OPTHALMOLOGY SOPT177', 'OPTHALMOLOGY SOPT178', 'OPTHALMOLOGY SOPT179', 'OPTHALMOLOGY SOPT180', 'OPTHALMOLOGY SOPT181', 'OPTHALMOLOGY SOPT182', 'OPTHALMOLOGY SOPT183', 'OPTHALMOLOGY SOPT184', 'OPTHALMOLOGY SOPT185', 'OPTHALMOLOGY SOPT186', 'OPTHALMOLOGY SOPT187', 'OPTHALMOLOGY SOPT188', 'OPTHALMOLOGY SOPT189', 'OPTHALMOLOGY SOPT190', 'OPTHALMOLOGY SOPT191', 'OPTHALMOLOGY SOPT192', 'OPTHALMOLOGY SOPT194', 'OPTHALMOLOGY SOPT195', 'OPTHALMOLOGY SOPT196', 'OPTHALMOLOGY SOPT197', 'OPTHALMOLOGY SOPT198', 'OPTHALMOLOGY SOPT199', 'OPTHALMOLOGY SOPT200', 'OPTHALMOLOGY SOPT201', 'OPTHALMOLOGY SOPT202', 'OPTHALMOLOGY SOPT203', 'OPTHALMOLOGY SOPT204', 'OPTHALMOLOGY SOPT205', 'OPTHALMOLOGY SOPT206', 'OPTHALMOLOGY SOPT207', 'OPTHALMOLOGY SOPT208', 'OPTHALMOLOGY SOPT209', 'OPTHALMOLOGY SOPT210', 'OPTHALMOLOGY SOPT211', 'OPTHALMOLOGY SOPT212', 'OPTHALMOLOGY SOPT213', 'OPTHALMOLOGY SOPT214', 'OPTHALMOLOGY SOPT216', 'OPTHALMOLOGY SOPT217', 'OPTHALMOLOGY SOPT218', 'OPTHALMOLOGY SOPT219', 'OPTHALMOLOGY SOPT220', 'OPTHALMOLOGY SOPT221', 'OPTHALMOLOGY SOPT222', 'OPTHALMOLOGY SOPT223', 'OPTOMETRY', 'ORAL MAXILLOFACIAL SURG', 'ORTHO ONCOLOGY', 'Orthognathic Operations', 'Orthopaedic Implant Removal', 'ORTHOPAEDIC PROCEDURES', 'Orthopaedics', 'ORTHOPAEDICS', 'ORTHOPEDICS', 'Osteomyeltis', 'Osteotomy', 'Osteotomy', 'OTHER CHARGES', 'Other Procedure', 'OTHERS', 'Others', 'PAEDIATRIC CARDIOLOGY', 'PAEDIATRIC CARDIOVASCULAR & THORACIC SURGERY', 'PAEDIATRIC DEPT SERV', 'PAEDIATRIC DEPT SERVI', 'PAEDIATRIC GASTROENTEROLOGY', 'PAEDIATRIC HEMATO ONCOLOGY', 'PAEDIATRIC INTENSIVE CARE', 'PAEDIATRIC NEUROLOG', 'PAEDIATRIC NEUROLOGY', 'PAEDIATRIC PROCEDURE PACKAGE', 'Paediatric Procedures', 'PAEDIATRIC SURGERY', 'PAEDIATRIC SURGERY CHARGES', 'Paediatrics', 'PAEDIATRICS', 'PAEDIATRICS ORTHOPAEDICS', 'PAEDIATRICS SURGERY', 'Pain & Palliative', 'PAIN & PALLIATIVE CARE', 'Pain Control Procedures', 'Pain Management', 'PAIN MANAGEMENT', 'PALLIATIVE MEDICINE', 'PARING CHARGES', 'Patella', 'PEDIATRICS AND NEONATOLOGY', 'PEDODONTICS (DENTAL)', 'Peripheral Aneurysm Operations', 'Peripheral Angioplasty', 'PLASTIC & COSMETIC SURGERY', 'Plastic and Cosmetic Procedure Charges', 'PLASTIC SURGERY', 'Plastic Surgery', 'PLASTIC SURGERY PROCEDURE', 'PLASTIC SURGERYSCOS001', 'PLASTIC SURGERYSCOS002', 'PLASTIC SURGERYSCOS003', 'PLASTIC SURGERYSCOS004', 'PLASTIC SURGERYSCOS005', 'PLASTIC SURGERYSCOS006', 'PLASTIC SURGERYSCOS007', 'PLASTIC SURGERYSCOS008', 'PLASTIC SURGERYSCOS009', 'PLASTIC SURGERYSCOS010', 'PLASTIC SURGERYSCOS011', 'PLASTIC SURGERYSCOS012', 'PLASTIC SURGERYSCOS013', 'PLASTIC SURGERYSCOS014', 'PLASTIC SURGERYSCOS015', 'PLASTIC SURGERYSCOS016', 'PLASTIC SURGERYSCOS017', 'PLASTIC SURGERYSCOS018', 'PLASTIC SURGERYSCOS019', 'PLASTIC SURGERYSCOS020', 'PLASTIC SURGERYSCOS021', 'PLASTIC SURGERYSCOS022', 'PLASTIC SURGERYSCOS023', 'PLASTIC SURGERYSCOS024', 'PLASTIC SURGERYSCOS025', 'PLASTIC SURGERYSCOS026', 'PLASTIC SURGERYSCOS027', 'PLASTIC SURGERYSCOS028', 'PLASTIC SURGERYSCOS029', 'PLASTIC SURGERYSCOS030', 'PLASTIC SURGERYSCOS031', 'PLASTIC SURGERYSCOS032', 'PLASTIC SURGERYSCOS033', 'PLASTIC SURGERYSCOS034', 'PLASTIC SURGERYSCOS035', 'PLASTIC SURGERYSCOS036', 'PLASTIC SURGERYSCOS037', 'PLASTIC SURGERYSCOS038', 'PLASTIC SURGERYSCOS039', 'PLASTIC SURGERYSCOS040', 'PLASTIC SURGERYSCOS041', 'PLASTIC SURGERYSCOS044', 'PLASTIC SURGERYSCOS045', 'PLASTIC SURGERYSCOS046', 'PLASTIC SURGERYSCOS047', 'PLASTIC SURGERYSCOS048', 'PLASTIC SURGERYSCOS049', 'PLASTIC SURGERYSCOS050', 'PLASTIC SURGERYSCOS051', 'PLASTIC SURGERYSCOS052', 'PLASTIC SURGERYSCOS053', 'PLASTIC SURGERYSCOS055', 'PLASTIC SURGERYSCOS056', 'PLASTIC SURGERYSCOS057', 'PLASTIC SURGERYSCOS058', 'PLASTIC SURGERYSCOS059', 'PLASTIC SURGERYSCOS060', 'PLASTIC SURGERYSCOS061', 'PLASTIC SURGERYSCOS062', 'PLASTIC SURGERYSCOS063', 'PLASTIC SURGERYSCOS064', 'PLASTIC SURGERYSCOS065', 'PLASTIC SURGERYSCOS067', 'PLASTIC SURGERYSCOS068', 'PLASTIC SURGERYSCOS069', 'PLASTIC SURGERYSCOS070', 'PLASTIC SURGERYSCOS071', 'PLASTIC SURGERYSCOS072', 'PLASTIC SURGERYSCOS073', 'PLASTIC SURGERYSCOS074', 'PLASTIC SURGERYSCOS075', 'PLASTIC SURGERYSCOS076', 'PLASTIC SURGERYSCOS077', 'PLASTIC SURGERYSCOS078', 'PLASTIC SURGERYSCOS079', 'PLASTIC SURGERYSCOS080', 'PLASTIC SURGERYSPLS001', 'PLASTIC SURGERYSPLS002', 'PLASTIC SURGERYSPLS003', 'PLASTIC SURGERYSPLS004', 'PLASTIC SURGERYSPLS005', 'PLASTIC SURGERYSPLS006', 'PLASTIC SURGERYSPLS007', 'PLASTIC SURGERYSPLS008', 'PLASTIC SURGERYSPLS009', 'PLASTIC SURGERYSPLS010', 'PLASTIC SURGERYSPLS012', 'PLASTIC SURGERYSPLS013', 'PLASTIC SURGERYSPLS014', 'PLASTIC SURGERYSPLS015', 'PLASTIC SURGERYSPLS016', 'PLASTIC SURGERYSPLS017', 'PLASTIC SURGERYSPLS018', 'PLASTIC SURGERYSPLS019', 'PLASTIC SURGERYSPLS020', 'PLASTIC SURGERYSPLS021', 'PLASTIC SURGERYSPLS022', 'PLASTIC SURGERYSPLS023', 'PLASTIC SURGERYSPLS024', 'PLASTIC SURGERYSPLS025', 'PLASTIC SURGERYSPLS026', 'PLASTIC SURGERYSPLS027', 'PLASTIC SURGERYSPLS028', 'PLASTIC SURGERYSPLS029', 'PLASTIC SURGERYSPLS030', 'PLASTIC SURGERYSPLS031', 'PLASTIC SURGERYSPLS032', 'PLASTIC SURGERYSPLS033', 'PLASTIC SURGERYSPLS034', 'PLASTIC SURGERYSPLS035', 'PLASTIC SURGERYSPLS036', 'PLASTIC SURGERYSPLS037', 'PLASTIC SURGERYSPLS038', 'PLASTIC SURGERYSPLS039', 'PLASTIC SURGERYSPLS040', 'PLASTIC SURGERYSPLS041', 'PLASTIC SURGERYSPLS042', 'PLASTIC SURGERYSPLS043', 'PLASTIC SURGERYSPLS044', 'PLASTIC SURGERYSPLS045', 'PLASTIC SURGERYSPLS046', 'PLASTIC SURGERYSPLS047', 'PLASTIC SURGERYSPLS048', 'PLASTIC SURGERYSPLS049', 'PLASTIC SURGERYSPLS050', 'PLASTIC SURGERYSPLS051', 'PLASTIC SURGERYSPLS052', 'PLASTIC SURGERYSPLS054', 'PLASTIC SURGERYSPLS055', 'PLASTIC SURGERYSPLS056', 'PLASTIC SURGERYSPLS057', 'PLASTIC SURGERYSPLS058', 'PLASTIC SURGERYSPLS059', 'PLASTIC SURGERYSPLS060', 'PLASTIC SURGERYSPLS061', 'PLASTIC SURGERYSPLS062', 'PLASTIC SURGERYSPLS063', 'PLASTIC SURGERYSPLS064', 'PLASTIC SURGERYSPLS065', 'PLASTIC SURGERYSPLS066', 'PLASTIC SURGERYSPLS067', 'PLASTIC SURGERYSPLS068', 'PLASTIC SURGERYSPLS069', 'PLASTIC SURGERYSPLS070', 'PLASTIC SURGERYSPLS071', 'PLASTIC SURGERYSPLS072', 'PLASTIC SURGERYSPLS073', 'PLASTIC SURGERYSPLS074', 'PLASTIC SURGERYSPLS075', 'PLASTIC SURGERYSPLS076', 'PLASTIC SURGERYSPLS077', 'PLASTIC SURGERYSPLS078', 'PLASTIC SURGERYSPLS080', 'PLASTIC SURGERYSPLS081', 'PLASTIC SURGERYSPLS082', 'PLASTIC SURGERYSPLS083', 'PLASTIC SURGERYSPLS084', 'PLASTIC SURGERYSPLS085', 'PLASTIC SURGERYSPLS086', 'PLASTIC SURGERYSPLS087', 'PLASTIC SURGERYSPLS088', 'PLASTIC SURGERYSPLS089', 'PLASTIC SURGERYSPLS090', 'PLASTIC SURGERYSPLS091', 'PLASTIC SURGERYSPLS092', 'PLASTIC SURGERYSPLS093', 'PLASTIC SURGERYSPLS094', 'PLASTIC SURGERYSPLS095', 'PLASTIC SURGERYSPLS096', 'PLASTIC SURGERYSPLS097', 'PLASTIC SURGERYSPLS098', 'PLASTIC SURGERYSPLS099', 'PLASTIC SURGERYSPLS100', 'PLASTIC SURGERYSPLS101', 'PLASTIC SURGERYSPLS102', 'PLASTIC SURGERYSPLS103', 'PLASTIC SURGERYSPLS104', 'PLASTIC SURGERYSPLS105', 'PLASTIC SURGERYSPLS106', 'PLASTIC SURGERYSPLS107', 'PLASTIC SURGERYSPLS108', 'PLASTIC SURGERYSPLS109', 'PLASTIC SURGERYSPLS110', 'PLASTIC SURGERYSPLS111', 'PLASTIC SURGERYSPLS112', 'PLASTIC SURGERYSPLS113', 'PLASTIC SURGERYSPLS114', 'PLASTIC SURGERYSPLS115', 'PLASTIC SURGERYSPLS116', 'PLASTIC SURGERYSPLS117', 'PLASTIC SURGERYSPLS118', 'PLASTIC SURGERYSPLS120', 'PLASTIC SURGERYSPLS121', 'PLASTIC SURGERYSPLS122', 'PLASTIC SURGERYSPLS123', 'PLASTIC SURGERYSPLS124', 'PLASTIC SURGERYSPLS125', 'PLASTIC SURGERYSPLS126', 'PLASTIC SURGERYSPLS127', 'PLASTIC SURGERYSPLS128', 'PLASTIC SURGERYSPLS129', 'PLASTIC SURGERYSPLS130', 'PLASTIC SURGERYSPLS131', 'PLASTIC SURGERYSPLS132', 'PLASTIC SURGERYSPLS133', 'PLASTIC SURGERYSPLS134', 'PLASTIC SURGERYSPLS135', 'PLASTIC SURGERYSPLS136', 'PLASTIC SURGERYSPLS137', 'PLASTIC SURGERYSPLS138', 'PLASTIC SURGERYSPLS139', 'PLASTIC SURGERYSPLS140', 'PLASTIC SURGERYSPLS141', 'PLASTIC SURGERYSPLS142', 'PLASTIC SURGERYSPLS143', 'PLASTIC SURGERYSPLS144', 'PLASTIC SURGERYSPLS145', 'PLASTIC SURGERYSPLS146', 'PLASTIC SURGERYSPLS147', 'PLASTIC SURGERYSPLS148', 'PLASTIC SURGERYSPLS149', 'PLASTIC SURGERYSPLS150', 'PLASTIC SURGERYSPLS151', 'PLASTIC SURGERYSPLS152', 'PLASTIC SURGERYSPLS153', 'PLASTIC SURGERYSPLS154', 'PLASTIC SURGERYSPLS155', 'PLASTIC SURGERYSPLS156', 'PLASTIC SURGERYSPLS157', 'PLASTIC SURGERYSPLS158', 'PLASTIC SURGERYSPLS159', 'PLASTIC SURGERYSPLS160', 'PLASTIC SURGERYSPLS161', 'PLASTIC SURGERYSPLS162', 'PLASTIC SURGERYSPLS163', 'PLASTIC SURGERYSPLS164', 'PLASTIC SURGERYSPLS165', 'PLASTIC SURGERYSPLS166', 'PLASTIC SURGERYSPLS167', 'PLASTIC SURGERYSPLS168', 'PLASTIC SURGERYSPLS169', 'PLASTIC SURGERYSPLS170', 'PLASTIC SURGERYSPLS171', 'PLASTIC SURGERYSPLS172', 'PLASTIC SURGERYSPLS173', 'PLASTIC SURGERYSPLS174', 'PLASTIC SURGERYSPLS175', 'PLASTIC SURGERYSPLS176', 'PLASTIC SURGERYSPLS177', 'PLASTIC SURGERYSPLS178', 'PLASTIC SURGERYSPLS179', 'PLASTIC SURGERYSPLS180', 'PLASTIC SURGERYSPLS181', 'PLASTIC SURGERYSPLS182', 'PLASTIC SURGERYSPLS183', 'PLASTIC SURGERYSPLS185', 'PLASTIC SURGERYSPLS186', 'PLASTIC SURGERYSPLS187', 'PLASTIC SURGERYSPLS188', 'PLASTIC SURGERYSPLS189', 'PLASTIC SURGERYSPLS190', 'PLASTIC SURGERYSPLS191', 'PLASTIC SURGERYSPLS192', 'PLASTIC SURGERYSPLS193', 'PLASTIC SURGERYSPLS194', 'PLASTIC SURGERYSPLS195', 'PLASTIC SURGERYSPLS196', 'PLASTIC SURGERYSPLS197', 'PLASTIC SURGERYSPLS198', 'PLASTIC SURGERYSPLS200', 'PLASTIC SURGERYSPLS201', 'PLASTIC SURGERYSPLS202', 'PLASTIC SURGERYSPLS203', 'PLASTIC SURGERYSPLS205', 'PLASTIC SURGERYSPLS206', 'PLASTIC SURGERYSPLS207', 'PLASTIC SURGERYSPLS208', 'PLASTIC SURGERYSPLS209', 'PLASTIC SURGERYSPLS210', 'PLASTIC SURGERYSPLS211', 'PLASTIC SURGERYSPLS212', 'PLASTIC SURGERYSPLS213', 'PLASTIC SURGERYSPLS214', 'PLASTIC SURGERYSPLS215', 'PLASTIC SURGERYSPLS216', 'PLASTIC SURGERYSPLS217', 'PLASTIC SURGERYSPLS218', 'PLASTIC SURGERYSPLS219', 'PLASTIC SURGERYSPLS220', 'PLASTIC SURGERYSPLS221', 'PLASTIC SURGERYSPLS222', 'PLASTIC SURGERYSPLS223', 'PLASTIC SURGERYSPLS224', 'PLASTIC SURGERYSPLS225', 'PLASTIC SURGERYSPLS226', 'PLASTIC SURGERYSPLS227', 'PLASTIC SURGERYSPLS228', 'PLASTIC SURGERYSPLS229', 'PLASTIC SURGERYSPLS230', 'PLASTIC SURGERYSPLS231', 'PLASTIC SURGERYSPLS232', 'PLASTIC SURGERYSPLS233', 'PLASTIC SURGERYSPLS234', 'PLASTIC SURGERYSPLS235', 'PLASTIC SURGERYSPLS237', 'PLASTIC SURGERYSPLS238', 'PLASTIC SURGERYSPLS239', 'PLASTIC SURGERYSPLS240', 'PLASTIC SURGERYSPLS241', 'PLASTIC SURGERYSPLS242', 'PLASTIC SURGERYSPLS243', 'PLASTIC SURGERYSPLS244', 'PLASTIC SURGERYSPLS245', 'PLASTIC SURGERYSPLS246', 'PLASTIC SURGERYSPLS247', 'PLASTIC SURGERYSPLS248', 'PLASTIC SURGERYSPLS249', 'PLASTIC SURGERYSPLS250', 'PLASTIC SURGERYSPLS251', 'PLASTIC SURGERYSPLS252', 'PLASTIC SURGERYSPLS253', 'PLASTIC SURGERYSPLS254', 'PLASTIC SURGERYSPLS255', 'PLASTIC SURGERYSPLS256', 'PLASTIC SURGERYSPLS257', 'PLASTIC SURGERYSPLS258', 'PLASTIC SURGERYSPLS259', 'PLASTIC SURGERYSPLS260', 'PLASTIC SURGERYSPLS261', 'PLASTIC SURGERYSPLS262', 'PLASTIC SURGERYSPLS263', 'PLASTIC SURGERYSPLS264', 'PLASTIC SURGERYSPLS265', 'PLASTIC SURGERYSPLS266', 'PLASTIC SURGERYSPLS267', 'PLASTIC SURGERYSPLS268', 'PLASTIC SURGERYSPLS269', 'PLASTIC SURGERYSPLS270', 'PLASTIC SURGERYSPLS271', 'PLASTIC SURGERYSPLS272', 'PLASTIC SURGERYSPLS273', 'PLASTIC SURGERYSPLS274', 'PLASTIC SURGERYSPLS275', 'PLASTIC SURGERYSPLS276', 'PLASTIC SURGERYSPLS277', 'PLASTIC SURGERYSPLS278', 'PLASTIC SURGERYSPLS279', 'PLASTIC SURGERYSPLS280', 'PLASTIC SURGERYSPLS281', 'PLASTIC SURGERYSPLS282', 'PLASTIC SURGERYSPLS283', 'PLASTIC SURGERYSPLS284', 'PLASTIC SURGERYSPLS285', 'PLASTIC SURGERYSPLS286', 'PLASTIC SURGERYSPLS287', 'PLASTIC SURGERYSPLS288', 'PLASTIC SURGERYSPLS289', 'PLASTIC SURGERYSPLS290', 'PLASTIC SURGERYSPLS291', 'PLASTIC SURGERYSPLS292', 'PLASTIC SURGERYSPLS293', 'PLASTIC SURGERYSPLS294', 'PLASTIC SURGERYSPLS295', 'PLASTIC SURGERYSPLS296', 'PLASTIC SURGERYSPLS297', 'PLASTIC SURGERYSPLS298', 'PLASTIC SURGERYSPLS300', 'PLASTIC SURGERYSPLS301', 'PLASTIC SURGERYSPLS302', 'PLASTIC SURGERYSPLS303', 'PLASTIC SURGERYSPLS304', 'PLASTIC SURGERYSPLS305', 'PLASTIC SURGERYSPLS306', 'PLASTIC SURGERYSPLS307', 'PLASTIC SURGERYSPLS308', 'PLASTIC SURGERYSPLS309', 'PLASTIC SURGERYSPLS310', 'PLASTIC SURGERYSPLS311', 'PLASTIC SURGERYSPLS313', 'PLASTIC SURGERYSPLS314', 'PLASTIC SURGERYSPLS315', 'PLASTIC SURGERYSPLS316', 'PLASTIC SURGERYSPLS317', 'PLASTIC SURGERYSPLS318', 'PLASTIC SURGERYSPLS319', 'PLASTIC SURGERYSPLS320', 'PLASTIC SURGERYSPLS321', 'PLASTIC SURGERYSPLS322', 'PLASTIC SURGERYSPLS323', 'PLASTIC SURGERYSPLS324', 'PLASTIC SURGERYSPLS325', 'PLASTIC SURGERYSPLS326', 'PLASTIC SURGERYSPLS327', 'PLASTIC SURGERYSPLS328', 'PLASTIC SURGERYSPLS329', 'PLASTIC SURGERYSPLS330', 'PLASTIC SURGERYSPLS331', 'PLASTIC SURGERYSPLS332', 'PLASTIC SURGERYSPLS333', 'PLASTIC SURGERYSPLS334', 'PLASTIC SURGERYSPLS335', 'PLASTIC SURGERYSPLS336', 'PLASTIC SURGERYSPLS338', 'PLASTIC SURGERYSPLS339', 'PLASTIC SURGERYSPLS340', 'PLASTIC SURGERYSPLS341', 'PLASTIC SURGERYSPLS342', 'PLASTIC SURGERYSPLS343', 'PLASTIC SURGERYSPLS344', 'PLASTIC SURGERYSPLS345', 'PLASTIC SURGERYSPLS346', 'PLASTIC SURGERYSPLS347', 'PLASTIC SURGERYSPLS348', 'PLASTIC SURGERYSPLS349', 'PLASTIC SURGERYSPLS350', 'PLASTIC SURGERYSPLS351', 'PLASTIC SURGERYSPLS352', 'PLASTIC SURGERYSPLS353', 'PLASTIC SURGERYSPLS354', 'PLASTIC SURGERYSPLS355', 'PLASTIC SURGERYSPLS356', 'PLASTIC SURGERYSPLS357', 'PLASTIC SURGERYSPLS358', 'PLASTIC SURGERYSPLS359', 'PLASTIC SURGERYSPLS360', 'PLASTIC SURGERYSPLS361', 'PLASTIC SURGERYSPLS362', 'PLASTIC SURGERYSPLS363', 'PLASTIC SURGERYSPLS364', 'PLASTIC SURGERYSPLS365', 'PLASTIC SURGERYSPLS366', 'PLASTIC SURGERYSPLS367', 'PLASTIC SURGERYSPLS368', 'PLASTIC SURGERYSPLS369', 'PLASTIC SURGERYSPLS370', 'PLASTIC SURGERYSPLS371', 'PLASTIC SURGERYSPLS372', 'PLASTIC SURGERYSPLS373', 'PLASTIC SURGERYSPLS374', 'PLASTIC SURGERYSPLS375', 'PLASTIC SURGERYSPLS376', 'PLASTIC SURGERYSPLS377', 'PLASTIC SURGERYSPLS378', 'PLASTIC SURGERYSPLS379', 'PLASTIC SURGERYSPLS380', 'PLASTIC SURGERYSPLS382', 'PLASTIC SURGERYSPLS383', 'PLASTIC SURGERYSPLS384', 'PLASTIC SURGERYSPLS385', 'PLASTIC SURGERYSPLS387', 'PLASTIC SURGERYSPLS388', 'PLASTIC SURGERYSPLS389', 'PLASTIC SURGERYSPLS390', 'PLASTIC SURGERYSPLS391', 'PLASTIC SURGERYSPLS393', 'PLASTIC SURGERYSPLS394', 'PLASTIC SURGERYSPLS395', 'PLASTIC SURGERYSPLS396', 'PLASTIC SURGERYSPLS397', 'PLASTIC SURGERYSPLS398', 'PLASTIC SURGERYSPLS399', 'PLASTIC SURGERYSPLS400', 'PLASTIC SURGERYSPLS401', 'PLASTIC SURGERYSPLS402', 'PLASTIC SURGERYSPLS403', 'PLASTIC SURGERYSPLS404', 'PLASTIC SURGERYSPLS406', 'PLASTIC SURGERYSPLS407', 'PLASTIC SURGERYSPLS408', 'PLASTIC SURGERYSPLS409', 'PLASTIC SURGERYSPLS410', 'PLASTIC SURGERYSPLS411', 'PLASTIC SURGERYSPLS412', 'PLASTIC SURGERYSPLS413', 'PLASTIC SURGERYSPLS414', 'PLASTIC SURGERYSPLS415', 'PLASTIC SURGERYSPLS416', 'PLASTIC SURGERYSPLS417', 'PLASTIC SURGERYSPLS418', 'PLASTIC SURGERYSPLS419', 'PLASTIC SURGERYSPLS420', 'PLASTIC SURGERYSPLS422', 'PLASTIC SURGERYSPLS423', 'PLASTIC SURGERYSPLS424', 'PLASTIC SURGERYSPLS425', 'PLASTIC SURGERYSPLS426', 'PLASTIC SURGERYSPLS427', 'PLASTIC SURGERYSPLS428', 'PLASTIC SURGERYSPLS429', 'PLASTIC SURGERYSPLS430', 'PLASTIC SURGERYSPLS431', 'PLASTIC SURGERYSPLS432', 'PLASTIC SURGERYSPLS434', 'PLASTIC SURGERYSPLS435', 'PLASTIC SURGERYSPLS436', 'PLASTIC SURGERYSPLS437', 'PLASTIC SURGERYSPLS438', 'PLASTIC SURGERYSPLS439', 'PLASTIC SURGERYSPLS440', 'PLASTIC SURGERYSPLS441', 'PLASTIC SURGERYSPLS442', 'PLASTIC SURGERYSPLS443', 'PLASTIC SURGERYSPLS444', 'PLASTIC SURGERYSPLS446', 'PLASTIC SURGERYSPLS447', 'PLASTIC SURGERYSPLS448', 'PLASTIC SURGERYSPLS449', 'PLASTIC SURGERYSPLS450', 'PLASTIC SURGERYSPLS451', 'PLASTIC SURGERYSPLS452', 'PLASTIC SURGERYSPLS453', 'PLASTIC SURGERYSPLS454', 'PLASTIC SURGERYSPLS455', 'PLASTIC SURGERYSPLS456', 'PLASTIC SURGERYSPLS457', 'PLASTIC SURGERYSPLS458', 'PLASTIC SURGERYSPLS459', 'PLASTIC SURGERYSPLS460', 'PLASTIC SURGERYSPLS461', 'PLASTIC SURGERYSPLS462', 'PLASTIC SURGERYSPLS463', 'PLASTIC SURGERYSPLS464', 'PLASTIC SURGERYSPLS465', 'PLASTIC SURGERYSPLS466', 'PLASTIC SURGERYSPLS467', 'PLASTIC SURGERYSPLS469', 'PLASTIC SURGERYSPLS470', 'PLASTIC SURGERYSPLS471', 'PLASTIC SURGERYSPLS472', 'PLASTIC SURGERYSPLS473', 'PLASTIC SURGERYSPLS474', 'PLASTIC SURGERYSPLS475', 'PLASTIC SURGERYSPLS476', 'PLASTIC SURGERYSPLS477', 'PLASTIC SURGERYSPLS478', 'PLASTIC SURGERYSPLS479', 'PLASTIC SURGERYSPLS480', 'PLASTIC SURGERYSPLS481', 'PLASTIC SURGERYSPLS483', 'PLASTIC SURGERYSPLS484', 'PLASTIC SURGERYSPLS485', 'PLASTIC SURGERYSPLS486', 'PLASTIC SURGERYSPLS487', 'PLASTIC SURGERYSPLS488', 'PLASTIC SURGERYSPLS489', 'PLASTIC SURGERYSPLS490', 'PLASTIC SURGERYSPLS491', 'PLASTIC SURGERYSPLS492', 'PLASTIC SURGERYSPLS493', 'PLASTIC SURGERYSPLS494', 'PLASTIC SURGERYSPLS495', 'PLASTIC SURGERYSPLS496', 'PLASTIC SURGERYSPLS497', 'PLASTIC SURGERYSPLS498', 'PLASTIC SURGERYSPLS501', 'PLASTIC SURGERYSPLS502', 'PLASTIC SURGERYSPLS504', 'PLASTIC SURGERYSPLS505', 'PLASTIC SURGERYSPLS506', 'PLASTIC SURGERYSPLS507', 'PLASTIC SURGERYSPLS508', 'PLASTIC SURGERYSPLS509', 'PLASTIC SURGERYSPLS510', 'PLASTIC SURGERYSPLS511', 'PLASTIC SURGERYSPLS513', 'PLASTIC SURGERYSPLS514', 'PLASTIC SURGERYSPLS515', 'PLASTIC SURGERYSPLS517', 'PLASTIC SURGERYSPLS518', 'PLASTIC SURGERYSPLS519', 'PLASTIC SURGERYSPLS520', 'PLASTIC SURGERYSPLS521', 'PLASTIC SURGERYSPLS522', 'PLASTIC SURGERYSPLS523', 'PLASTIC SURGERYSPLS524', 'PLASTIC SURGERYSPLS526', 'PLASTIC SURGERYSPLS527', 'PLASTIC SURGERYSPLS528', 'PLASTIC SURGERYSPLS529', 'PLASTIC SURGERYSPLS530', 'PLASTIC SURGERYSPLS531', 'PLASTIC SURGERYSPLS532', 'PLASTIC SURGERYSPLS533', 'PLASTIC SURGERYSPLS534', 'PLASTIC SURGERYSPLS535', 'PLASTIC SURGERYSPLS536', 'PLASTIC SURGERYSPLS537', 'PLASTIC SURGERYSPLS538', 'PLASTIC SURGERYSPLS539', 'PLASTIC SURGERYSPLS540', 'PLASTIC SURGERYSPLS541', 'PLASTIC SURGERYSPLS542', 'PLASTIC SURGERYSPLS543', 'PLASTIC SURGERYSPLS544', 'PLASTIC SURGERYSPLS545', 'PLASTIC SURGERYSPLS546', 'PLASTIC SURGERYSPLS547', 'PLASTIC SURGERYSPLS548', 'PLASTIC SURGERYSPLS549', 'PLASTIC SURGERYSPLS550', 'PLASTIC SURGERYSPLS552', 'PLASTIC SURGERYSPLS553', 'PLASTIC SURGERYSPLS554', 'PLASTIC SURGERYSPLS555', 'PLASTIC SURGERYSPLS556', 'PLASTIC SURGERYSPLS557', 'PLASTIC SURGERYSPLS558', 'PLASTIC SURGERYSPLS559', 'Polytrauma', 'Primary Arthroplasty', 'Procedure', 'PROCEDURE', 'procedure', 'PROCEDURE', 'Procedure Charges', 'PROCEDURE CHARGES', 'PROCEDURE CHARES', 'PROCEDURE CHARGE', 'PROCEDURE CHARGE', 'Procedure Chargea', 'Procedure Charges', 'procedure charges', 'PROCEDURE CHARGES', 'PROCEDURE CHARGES', 'Procedure CHarges', 'Procedure charges', 'PROCEDURE CHARGES', 'Procedure Charges', 'Procedure charges', 'PROCEDURE CHARGES CHARGES', 'Procedure Charges`', 'Procedure ChargesAccident & Emergency', 'Procedure ChargesMedical OncologyMedical Oncology', 'Procedure ChargesMedical OncologyMedical Oncology Mediastinoscopy (B) - Oncm', 'Procedure ChargesMedical OncologyMedical Oncology Micro Laryngoscopy (A) - Oncm', 'Procedure ChargesNephrology DialysisNephrology DialysisAcute Haemodialysis - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisAcute Peritoneal Dialysis Catheter', 'Procedure ChargesNephrology DialysisNephrology DialysisCapd - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCapd -Transfer Set Change - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCapd Catheter Removal In Dialysis - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCapd Dressing And Flushing - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCatheterisation - Double Lumen Ij - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCatheterisation - Femoral - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisChronic Haemodialysis Re Visit - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCvvh - Multifilterate - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCvvh - Prisma - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCvvh/Cvvhd/Cvvhdf/Scuf (For 12 Hr)** - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCvvh/Cvvhd/Cvvhdf/Scuf (For 24 Hr)** - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisCycled Peritorial Diallysis - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis - Cycled Peritorial - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis 1St / Emergency - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis Catheterization - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis Consumable Charges– Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis Emergency - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis Maintenance - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis Noctural - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis Peritoneal - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDialysis Single Use - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisDouble Lumen Hemodialysis Catheter', 'Procedure ChargesNephrology DialysisNephrology DialysisDouble Lumen Ij Cathetaraisation - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisHemo Dialyzer', 'Procedure ChargesNephrology DialysisNephrology DialysisHeparin Free Dialysis - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisHighflex Dialyser Hf80S', 'Procedure ChargesNephrology DialysisNephrology DialysisHighflux Heamodialysis', 'Procedure ChargesNephrology DialysisNephrology DialysisMicro Dialysis - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisNephrology Dialysis (Ricu)', 'Procedure ChargesNephrology DialysisNephrology DialysisNew Dialysis Initiation & Treatment Planning - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisOff Schedule Dialysis - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisPerm Cath - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisPlasmapheresis (Subsequent) - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisPlasmapheresis With Filter - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisPleural/ Ascitic Tapping - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisSlow Dialysis - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisSustained Low Efficiency Dialysis For 10Hr - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisSustained Low Efficiency Dialysis For 6Hr - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisSustained Low Efficiency Dialysis For 8Hr - Neph', 'Procedure ChargesNephrology DialysisNephrology DialysisSuturing Of Central Line In Dialysis - Neph', 'Procedure ChargesNuclear Medicine Nuclear Medicine', 'Procedure ChargesNuclear Medicine Nuclear Medicine Whole Body - Fdg - Pet Ct', 'Procedure ChargesOPTHALMOLOGY Ophthalmology', 'Procedure ChargesPhysiotherapy And Rehabilitation', 'Procedure ChargesPLASTIC SURGERYPlastic & Cosmetic Surgery', 'Procedure ChargesProcedure ChargesProcedure Charges', 'Procedure ChargesProcedure ChargesProcedure Charges AUTOLOGOUS BMT CONDITIONING MULTIPLE MYELOMA CHEMOTHERAPY', 'Procedure ChargesProcedure ChargesProcedure Charges BODY CARE', 'Procedure ChargesProcedure ChargesProcedure Charges BODY WRAPPER', 'Procedure ChargesProcedure ChargesProcedure Charges BONE MARROW BIOPSY & ASPIRATION PROCEDURE PACK', 'Procedure ChargesProcedure ChargesProcedure Charges CATHETER CARE', 'Procedure ChargesProcedure ChargesProcedure Charges CAUTRY MACHINE', 'Procedure ChargesProcedure ChargesProcedure Charges CHEMOTHERAPY CATEGORY 1', 'Procedure ChargesProcedure ChargesProcedure Charges CHEMOTHERAPY CATEGORY 3', 'Procedure ChargesProcedure ChargesProcedure Charges CHEMOTHERAPY CATEGORY 4', 'Procedure ChargesProcedure ChargesProcedure Charges CHEMOTHERAPY CATEGORY 5', 'Procedure ChargesProcedure ChargesProcedure Charges CHEMOTHERAPY CATEGORY 6', 'Procedure ChargesProcedure ChargesProcedure Charges CHEMOTHERAPY CATEGORY 7', 'Procedure ChargesProcedure ChargesProcedure Charges CHEMOTHERAPY CATEGORY 8', 'Procedure ChargesProcedure ChargesProcedure Charges GASTROSCOPY AND ULCER HEMOSTATIS I', 'Procedure ChargesProcedure ChargesProcedure Charges MOUTH CARE', 'Procedure ChargesProcedure ChargesProcedure Charges PREPARATION CHARGES', 'Procedure ChargesProcedure ChargesProcedure Charges TREAD MILL TEST (TMT)', 'Procedure ChargesRespiratory MedicineRespiratory MedicineBaseline Sleep Study - Res Med-Level-1', 'Procedure ChargesRespiratory MedicineRespiratory MedicineBronchoscopy - Crc', 'Procedure ChargesRespiratory MedicineRespiratory MedicineBronchoscopy Fiber Optic - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicineDiffusion Study - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicineEbus (Endobronchial Ultrasound)', 'Procedure ChargesRespiratory MedicineRespiratory MedicineEbus With Tbna', 'Procedure ChargesRespiratory MedicineRespiratory MedicineFnac Lung - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicineImmunotherapy', 'Procedure ChargesRespiratory MedicineRespiratory MedicineIntercostal Drainage - Res Medi', 'Procedure ChargesRespiratory MedicineRespiratory MedicinePft - Spirometry - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicinePleural Aspiration', 'Procedure ChargesRespiratory MedicineRespiratory MedicinePleural Biopsy - Resp Medi', 'Procedure ChargesRespiratory MedicineRespiratory MedicinePleural Tapping - Resp Medi', 'Procedure ChargesRespiratory MedicineRespiratory MedicinePleural Thrombolysis - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicinePleurodesis - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicineTitration Sleep Study - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicineVideo Bronchoscopy - Biopsy - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicineVideo Bronchoscopy - Bronchial Wash - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicineVideo Bronchoscopy - Removal Of Foreign Body - Res Med', 'Procedure ChargesRespiratory MedicineRespiratory MedicineVideo Bronchoscopy - Res Med', 'Procedure ChargesVascular Surgery Vascular Surgery', 'Procedure Chrarges', 'Procedure\xa0Charges\xa0Break-up', 'Procedures', 'Procedures charges', 'PROCEDURES CHARGES', 'PROCEDUREVCHARGES', 'PRODECURE CHARGES', 'PULMONOLOGY', 'RADIATION ONCOLOGY', 'RADIOIODINE THERAPY', 'RADIOTHERAPY', 'Reimplantation Revascularisation Operations', 'REPRODUCTIVE MEDICINE', 'RESPIRATORY MEDICINE', 'Respiratory Medicine', 'RESPIRATORY SERVICES', 'RESPIRATORY THERAPY', 'Resuscitation charges', 'Revision Arthroplasty', 'Rheumatology', 'RHEUMATOLOGY', 'Rheumatology & Immunology', 'Rheumatology Procedures', 'RMS', 'Salivary Gland Operations', 'Shoulder', 'SKIN AND COSMETOLOGY', 'Skin Pharmacy', 'SKIN_STD', 'SPEAKING +SWALLOWIN', 'Spinal Operations', 'Spine', 'SPINE CARE', 'SURGICAL GASTRO ENTI', 'SURGICAL GASTROENTEROLOGY', 'SURGICAL ONCOLOGY', 'Sympathectomy', 'Tendon / Muscle Transfers', 'Tendon Surgery', 'Thoracic Surgery', 'URO GYNECOLOGY', 'Urodynamic doctor procedure charges', 'Urodynamic test charges', 'URODYNAMICS PROCEDURES (OPD)', 'Urology', 'UROLOGY', 'UROLOGY SURGERY', 'UROLOGY & NEPHROLOGY', 'UROLOGY AND NEPHROLOGY', 'V. R. Surgery', 'Varicose Vein Operations', 'Vascular Access Operations', 'Vascular Bypass Grafting', 'Vascular Embolectomy', 'Vascular Endarterectomy', 'Vascular Injury Repair', 'Vascular Procedures', 'Vascular Surgery', 'VERICOSE VEINS SURGERY', 'Vertebral Fusion', 'VIROLOGY', 'PLASTIC SURGERYSPLS516', 'ENDOCRINOLOGY', 'PLASTIC SURGERYSPLS551', 'PLASTIC SURGERYSPLS445', 'Procedure ChargesProcedure ChargesProcedure Charges UNPREPARED COLONOSCOPY', 'OPTHALMOLOGY SOPT146', 'PLASTIC SURGERYSPLS053', 'PLASTIC SURGERYSPLS433', 'PLASTIC SURGERYSPLS011', 'PLASTIC SURGERYSPLS079', 'Procedure ChargesProcedure ChargesProcedure Charges Bronchoscopy With BAL', 'OPTHALMOLOGY SOPT072', 'DILIVERY - CHARGES', 'Obstetrics And Gynaecology', 'OPTHALMOLOGY SOPT193', 'PLASTIC SURGERYSPLS468', 'Procedure ChargesNephrology DialysisNephrology DialysisChronic Haemodialysis First Visit - Neph', 'Athorodesis', 'PLASTIC SURGERYSPLS381', 'PLASTIC SURGERYSPLS204', 'PLASTIC SURGERYSPLS499', 'PLASTIC SURGERYSPLS386', 'OPTHALMOLOGY SOPT152', 'PLASTIC SURGERYSPLS184', 'OPTHALMOLOGY SOPT215', 'PLASTIC SURGERYSPLS119', 'PLASTIC SURGERYSPLS482', 'Capsule Endoscopy', 'PLASTIC SURGERYSPLS236', 'PLASTIC SURGERYSPLS500', 'PLASTIC SURGERYSCOS054', 'PLASTIC SURGERYSPLS337', 'RADIOTHERAPY AND ONCOLOGY', 'PLASTIC SURGERYSPLS392', 'Procedure ChargesProcedure ChargesProcedure Charges CHEMOTHERAPY CATEGORY 2', 'VASCULAR SURGERY', 'D. EMERGENCY ICU PACKAGE Per Day/ITU', 'PLASTIC SURGERYSPLS299', 'PLASTIC SURGERYSPLS199', 'General Surgery', 'PLASTIC SURGERYSPLS421', 'PLASTIC SURGERYSCOS043', 'PLASTIC SURGERYSPLS503', 'OPTHALMOLOGY SOPT176', 'PLASTIC SURGERYSPLS512', 'OPTHALMOLOGY SOPT172', 'Ultra Sound Procedures', 'PLASTIC SURGERYSPLS405', 'PLASTIC SURGERYSPLS312', 'PLASTIC SURGERYSPLS525', 'OPTHALMOLOGY SOPT018', 'Specialized Procedure', 'Gastroenterology Procedures', 'PLASTIC SURGERYSCOS066', 'PLASTIC SURGERYSCOS042'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category14(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Room Charges' where category in ('BABY ROOM (ROOM & NURSING)','bed charges','BED CHARGES/ROOM RENT','Bed / Room Charges','DAY CARE','IPD','ROOM AND G.A. CHARGES','Room Charges','Room Charges','ROOM, GENERAL ANESTHESIA(GA) AND RELATED CHARGES','room rent','ROOM TARIFF','WARD PER HOUR','Wards Others', 'Bed Charge', 'Bed Charges', 'BED CHARGES', 'Bed charges', 'Day Care', 'LABOUR ROOM CHARGES', 'Onco wing Day Care', 'Room', 'ROOM', 'Room / Bed Charges', 'Room Category', 'ROOM CHARGE', 'ROOM Charges', 'Room charges', 'Room Charges', 'room charges', 'Room Charges', 'room charges', 'ROOM CHARGES', 'Room charges', 'ROOM RENT', 'ROOM RENT', 'Room Tariff', 'Room Tariff & IP Consultations', 'Room Rent', 'ROOM CHARGES'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_category15(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""begin; update schedule_of_charges set category = 'Surgeon Charges' where category in ('CORNEA AND OCULAR SURFACE SURGEY','Surgeon Chagres','Surgeon Charges','SURGEON charges','SURGEON CHARGES','Surgeon Fee','surgeon fees','Surgeon Fess','Surgeon''s charges', 'Assisstant Surgeon', 'Assisstant Surgeon Charges', 'ASSISTANT CHARGES', 'Assistant charges', 'ASSISTANT SURGEON CHARGES', 'Operation Fees', 'Operation Fees Private', 'Surg charges', 'Surgeon', 'Surgeon Charges', 'Surgeon Charge', 'Surgeon charges', 'Surgeon Charges', 'surgeon charges', 'SURGEON CHARGES', 'Surgeon Charges', 'Surgeon charges', 'Surgeon Charges', 'SURGEON FEE', 'Surgeon Fees', 'SURGEON FEES', 'SURGEONS CHARGE', 'Surgery', 'SURGERY CHARGES', 'Surgery charges', 'Surgery Levels'); end;""") #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_create_table_roomtype_subcategory(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""create table subcategory_by_hospital_id as select hospital_id, subcategory from schedule_of_charges group by hospital_id, subcategory""") print(cursor.statusmessage) cursor.execute("""create table room_by_hospital_id as select hospital_id, type_of_room from schedule_of_charges group by hospital_id, type_of_room;""") print(cursor.statusmessage) #table=cursor.fetchall() conn.commit() #print(table) print("above is the query ran successfully") conn.close() def query_update_mm_packages(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '50730767' and s3url = 'MM Packages wef 10-08-2020';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '50040372' and s3url = 'MM Packages WEF- 1-Apr-2014.pdf';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '50000700' and s3url = 'MM Packages wef 09-04-2021';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '93108493' and s3url = 'MM Packages wef-10-08-2021';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '80752533' and s3url = 'MM Packages wef 12-10-2020';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '50752260' and s3url = 'MM Packages wef 23-07-2019.pdf';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '50000470' and s3url = 'MM Packages and Investigation WEF- 29-01-2020.pdf';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '50001040' and s3url = 'MM Packages WEF- 22-03-2018.pdf';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '50685865' and s3url = 'MM Packages WEF- 24-09-2022.pdf';""") cursor.execute("""update schedule_of_charges set tariff_type = 'agreed' where hospital_id = '60059217' and s3url = 'MM Packages WEF- 15-01-2021.pdf';""") conn.commit() print("above is the query ran successfully") conn.close() def query_delete_unnamed_null_remarks(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""DELETE from schedule_of_charges where type_of_room in ('Unnamed: 0', 'remarks.1')""") cursor.execute("""BEGIN; DELETE from schedule_of_charges where remarks in ('',' ' ,null) and price_per_unit in ('0', '0.0', '', ' ', null); COMMIT;""") conn.commit() print("above is the query ran successfully") conn.close() def create_index1(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""CREATE INDEX service_desc_trigram_index on schedule_of_charges USING GIN(lower(service_description) gin_trgm_ops);""") print(cursor.statusmessage) conn.commit() print("above1 is the query ran successfully") conn.close() def create_index2(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""CREATE INDEX service_desc_serialID_index on schedule_of_charges(service_description, serial_id);""") print(cursor.statusmessage) print("above2 is the query ran successfully") conn.commit() conn.close() def create_index3(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""CREATE INDEX idx_hospitalId_serviceDesc on schedule_of_charges(hospital_id,lower(service_description));""") print(cursor.statusmessage) conn.commit() print("above2 is the query ran successfully") conn.close() def view_index(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("""select indexname, indexdef from pg_indexes where tablename='schedule_of_charges';""") res=cursor.fetchall() for i in res: print(i) print("above is the query ran successfully") conn.close() def drop_index(): conn=psycopg2.connect(database=DATABASE, user=USER, password=PASSWORD, host=HOST, port=PORT) cursor=conn.cursor() cursor.execute("DROP INDEX IF EXISTS service_desc_trigram_extra_index;") cursor.execute("DROP INDEX IF EXISTS all_col_index;") print(cursor.statusmessage) conn.commit() print("above is the query ran successfully") conn.close() check_connection() start=time.time() #check_data() #install_trigram() #update_trigram() #grant_permission() #query_delete_unnamed_null_remarks() #query_update_mm_packages() #query_delete_0_category() #query_update_category1() #query_update_category2() #query_update_category3() #query_update_category4() #query_update_category5() #query_update_category6() #query_update_category7() #query_update_category8() #query_update_category9() #query_update_category10() #query_update_category11() #query_update_category12() #query_update_category13() #query_update_category14() #query_update_category15() #query_create_table_roomtype_subcategory() query2() #drop_index() #create_index1() #create_index2() #create_index3() #view_index() end=time.time() final_time = end-start print("result in: ", format(final_time))
Editor is loading...
Leave a Comment