briankip

-- RUN THESE ONLY ONCE

-- INDEXING TEST TABLE 

-- Helps improve performance

alter table blis_301.test add index (external_lab_no);


-- PRELIMINARY MIGRATION BEFORE MIGRATING REJECTION REASONS AND SPECIMEN

briankip

-- Script to migrate patients data from old-blis to new blis
-- 0 warnings
-- Some records have no calculatable date of birth, I have put the DOB as the timestamp


insert into iblis.patients 
	(patient_number, name, dob, gender, external_patient_number, created_at)

select  patient_id, name, 
	(case WHEN dob = '0000-00-00'

briankip

Withdrawal amount	Charges
< 2,500	25
2,501 - 5,000	45
5,001 - 10,000	75
10,001 - 20,000	145
20,001 - 35,000	170
35,001 - 50,000	195
50,001 - 100,000	225

briankip

A single place to find most charges related to m-pesa

MPESA TARIFFS

Min	Max	Registered	Unregistered	Via Agent
10	49	1	N/A	N/A
50	100	3	N/A	10
101	500	11	66	27
501	1,000	15	66	27