Untitled

mail@pastecode.io avatar
unknown
python
2 months ago
81 kB
4
Indexable
Never
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 &AMP 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 &AMP 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))
Leave a Comment