🔧 Fix NULL Values

Populate missing Demander and DemanderCode_str fields using delivery point data.

🏠 Dashboard 📋 Manage Records
Total Records with NULL
3,271
Facilities Affected
7
Selected Facility Records
130

📋 Process Steps

1
Select a Facility
Choose a facility from the list below that has NULL values
✅
2
Review Records
View all records with NULL values for the selected facility
👁️
3
Choose Delivery Point
Select a delivery point to populate the NULL fields
📦
4
Update Records
Click the update button to populate all NULL values
⏳

📌 How It Works

This tool identifies records where Demander or DemanderCode_str is NULL or empty.

🏥 Select a Facility 7 facilities with NULL values

BRUNTVILLE CHC
116 records →
CHARLES JOHNSON MEMORIAL HOSPITAL
513 records →
Dr Pixley Ka Isaka Seme Memorial Hospital
706 records →
DUNDEE HOSPITAL
466 records →
HLENGISIZWE COMMUNITY HEALTH CENTRE
600 records →
KWAMASHU CHC
740 records →
PHOENIX CHC
130 records ✓

📄 Records for PHOENIX CHC

130 records with NULL values
✕ Clear Selection
ID Invoice No. Order No. Description Qty Received Current Demander Current DemanderCode Status
44927 20071631 PCH-ORD/24-06-4927 Rapid Diag Dual Test Strips HIV/Syphilis 1 dose (D... 100 NULL NULL ⚠️ NULL
44926 1630707/ PCH-ORD/26-02-5647 Nevirapine 50mg/5mL (Syrup) [100 mL] 60 NULL NULL ⚠️ NULL
44925 1622208/ PCH-ORD/26-01-5624 Lamivudine 150mg (Tablet) [56 Tablet] 200 NULL NULL ⚠️ NULL
44924 1622142/ PCH-ORD/26-01-5624 Tenofovir 300mg/Lamivudine 300mg/Dolutegravir 50mg... 195 NULL NULL ⚠️ NULL
44923 1590889/ PCH-ORD/25-11-5570 Nevirapine 50mg/5mL (Suspension) [100 mL] 60 NULL NULL ⚠️ NULL
44922 1579972/ PCH-ORD/25-10-5555 Nevirapine 50mg/5mL (Suspension) [100 mL] 60 NULL NULL ⚠️ NULL
44921 1562214/ PCH-ORD/25-10-5501 Nevirapine 50mg/5mL (Suspension) [100 mL] 60 NULL NULL ⚠️ NULL
44920 20071630 PCH-ORD/26-04-5736 Hyoscine 20mg/mL (Ampoule) [1 mL] 10 NULL NULL ⚠️ NULL
44919 1650010/ PCH-ORD/26-04-5736 Diclofenac 25mg/mL (Vial) [3 mL] 20 NULL NULL ⚠️ NULL
44918 20071629 PCH-ORD/26-04-5735 Zuclopenthixol Decanoate 200mg/mL (Ampoule) [1 mL] 25 NULL NULL ⚠️ NULL
44917 1650009/ PCH-ORD/26-04-5735 Risperidone 1mg/mL (Solution) [30 mL] 3 NULL NULL ⚠️ NULL
44916 1650040/ PCH-ORD/26-04-5737 Insulin 0 NULL NULL ⚠️ NULL
44915 20071628 PCH-ORD/26-04-5723 Vaccine: Diphtheria 0 NULL NULL ⚠️ NULL
44914 20071627 PCH-ORD/26-04-5722 Metformin 500mg (Tablet) [84 Tablet] 276 NULL NULL ⚠️ NULL
44913 1650426/ PCH-ORD/26-04-5722 Lubricant 200 NULL NULL ⚠️ NULL
44912 1650061/ PCH-ORD/26-04-5721 Immunoglobulin: Rabies 1500iu (Injection) [1 Vial] 50 NULL NULL ⚠️ NULL
44911 1650431/ PCH-ORD/25-01-5156 Vaccine: BCG . (Vial) [20 Dose] 30 NULL NULL ⚠️ NULL
44910 20071626 PCH-ORD/25-01-5152 Test Kit 10 NULL NULL ⚠️ NULL
44909 20071625 PCH-ORD/25-01-5152 Magnesium Sulphate 50% (Injection) [2 mL] 50 NULL NULL ⚠️ NULL
44908 20071624 PCH-ORD/25-01-5152 Insulin 0 NULL NULL ⚠️ NULL
44907 20071623 PCH-ORD/25-01-5152 Insulin 0 NULL NULL ⚠️ NULL
44906 1650031/ PCH-ORD/25-01-5152 Ferrous Sulphate Co 170mg (Tablet) [28 Tablet] 300 NULL NULL ⚠️ NULL
44905 20071622 PCH-ORD/26-04-5718 Metformin 850mg (Tablet) [84 Tablet] 330 NULL NULL ⚠️ NULL
44904 1650021/ PCH-ORD/26-04-5718 Metformin 500mg (Tablet) [56 Tablet] 480 NULL NULL ⚠️ NULL
44903 20071621 PCH-ORD/26-04-5728 Enoxaparin 40mg/0.4mL (Syringe 20 NULL NULL ⚠️ NULL
44902 1650007/ PCH-ORD/26-04-5728 Enoxaparin 40mg/0.4mL (Syringe 20 NULL NULL ⚠️ NULL
44901 20071620 PCH-ORD/26-04-5738 Tiotropium 18UGM (Capsule) [1 Device] 2 NULL NULL ⚠️ NULL
44900 20071619 PCH-ORD/26-04-5738 30 NULL NULL ⚠️ NULL
44899 1653383/ PCH-ORD/26-04-5738 Cyproterone Acetate 4 NULL NULL ⚠️ NULL
44898 1650645/ PCH-ORD/26-04-5739 Brimonidine Tartrate 1.5mg/mL (Eye Drops) [5. mL] 1 NULL NULL ⚠️ NULL
44897 1650645/0085 PCH-ORD/26-04-5739 Amoxycillin 125mg/5mL (Suspension) [100 mL] 18 NULL NULL ⚠️ NULL
44896 20071618 PCH-ORD/26-04-5719 Phenytoin 100mg (Tablet) [84 Tablet] 60 NULL NULL ⚠️ NULL
44895 1655719/0012 PCH-ORD/26-04-5719 Metformin 500mg (Tablet) [56 Tablet] 30 NULL NULL ⚠️ NULL
44894 1650031/0013 PCH-ORD/26-04-5720 Etonogestrel 68mg (.) [1 Implant] 5 NULL NULL ⚠️ NULL
44893 20071617 PCH-ORD/26-04-5727 Topiramate 50mg (Tablet) [60 Tablet] 4 NULL NULL ⚠️ NULL
44892 20071616 PCH-ORD/26-04-5727 Topiramate 50mg (Tablet) [60 Tablet] 1 NULL NULL ⚠️ NULL
44891 20071615 PCH-ORD/26-04-5727 Cyproterone Acetate 1 NULL NULL ⚠️ NULL
44890 1650025/0018 PCH-ORD/26-04-5727 Anastrozole 1mg (Tablet) [30 Tablet] 1 NULL NULL ⚠️ NULL
44889 20071614 PCH-ORD/26-04-5734 Timolol 0.05%. (Eye Drops) [5. mL] 25 NULL NULL ⚠️ NULL
44888 1656503/0017 PCH-ORD/26-04-5734 Latanoprost 50ug/ml (Eye Drops) [3 mL] 20 NULL NULL ⚠️ NULL
44887 20071613 PCH-ORD/26-04-5726 female condoms 1 dose (latex condom) [1 Unit] 9,000 NULL NULL ⚠️ NULL
44886 1656502/0017 PCH-ORD/26-04-5726 Condom 35 NULL NULL ⚠️ NULL
44885 20071612 PCH-ORD/26-04-5729 INSULIN SYRINGE 1ML (Syringe) [1 Needle] 12,000 NULL NULL ⚠️ NULL
44884 20071611 PCH-ORD/26-04-5729 Bottle 0 NULL NULL ⚠️ NULL
44883 1656065/0017 PCH-ORD/26-04-5729 Bag 0 NULL NULL ⚠️ NULL
44882 1656065/0007 PCH-ORD/26-04-5729 Bag 0 NULL NULL ⚠️ NULL
44881 1650048/0098 PCH-ORD/26-04-5740 Brimonidine Tartrate 1.5mg/mL (Eye Drops) [5. mL] 20 NULL NULL ⚠️ NULL
44880 20071610 PCH-ORD/26-02-5648 Water For Injection 10mL (Ampoule) [10 Ampoule] 200 NULL NULL ⚠️ NULL
44879 1655648/0021 PCH-ORD/26-02-5648 Promethazine 25mg (Tablet) [100 Tablet] 5 NULL NULL ⚠️ NULL
44878 1655648/0080 PCH-ORD/26-02-5648 Praziquantel 600mg (Tablet) [6 Tablet] 2 NULL NULL ⚠️ NULL
44877 20071609 PCH-ORD/26-02-5648 Lamotrigine 50mg (Tablet) [56 Tablet] 6 NULL NULL ⚠️ NULL
44876 20071608 PCH-ORD/26-02-5648 Emulsifying BP (Ointment) [500 g] 30 NULL NULL ⚠️ NULL
44875 20071607 PCH-ORD/26-02-5648 Calcium Gluconate 10% (Ampoule) [10 mL] 10 NULL NULL ⚠️ NULL
44874 1655648/0073 PCH-ORD/26-02-5648 Calcium Carbonate 500mg (Tablet) [10 Tablet] 200 NULL NULL ⚠️ NULL
44873 1655644/0050 PCH-ORD/26-02-5644 Oxytocin 210 NULL NULL ⚠️ NULL
44872 1655623/0051 PCH-ORD/26-01-5623 Vaccine: Hepatitis B Adult 20mcg/mL (Vial) [1 vial... 5 NULL NULL ⚠️ NULL
44871 1655623/0070 PCH-ORD/26-01-5623 Phenytoin 50mg/mL (Vial) [5 mL] 100 NULL NULL ⚠️ NULL
44870 1655623/0079 PCH-ORD/26-01-5623 Levonorgestrel 1.5mg (Tablet) [1 Tablet] 20 NULL NULL ⚠️ NULL
44869 1655623/0078 PCH-ORD/26-01-5602 Bicalutamide 50mg (Tablet) [30 Tablet] 2 NULL NULL ⚠️ NULL
44868 1655622/0081 PCH-ORD/26-01-5622 Metformin 500mg (Tablet) [56 Tablet] 199 NULL NULL ⚠️ NULL
44867 1655571/0084 PCH-ORD/26-01-5602 Acyclovir 400mg (Tablet) [60 Tablet] 64 NULL NULL ⚠️ NULL
44866 20071606 PCH-ORD/25-11-5571 Phenytoin 50mg/mL (Vial) [5 mL] 10 NULL NULL ⚠️ NULL
44865 1655571/0072 PCH-ORD/25-11-5571 Clonidine 25mcg (Tablet) [100 Tablet] 1 NULL NULL ⚠️ NULL
44864 1655571/0082 PCH-ORD/25-11-5571 Acyclovir 400mg (Tablet 20 NULL NULL ⚠️ NULL
44863 20071605 PCH-ORD/25-10-5556 Topiramate 25mg (Tablet) [60 Tablet] 5 NULL NULL ⚠️ NULL
44862 1655556/0071 PCH-ORD/25-10-5556 Phenytoin 50mg/mL (Vial) [5 mL] 20 NULL NULL ⚠️ NULL
44861 1655556/0083 PCH-ORD/25-10-5556 Acyclovir 400mg (Tablet 33 NULL NULL ⚠️ NULL
44860 1655502/0069 PCH-ORD/25-10-5502 Phenytoin 50mg/mL (Vial) [5 mL] 80 NULL NULL ⚠️ NULL
44859 1651507/0060 PCH-ORD/26-03-5697 Insulin analogue human 1,770 NULL NULL ⚠️ NULL
44858 1648605/0052 PCH-ORD/26-03-5701 Vaccine: Influenza . (Syringe 700 NULL NULL ⚠️ NULL
44857 1630716/0097 PCH-ORD/26-02-5646 Clotrimazole 1% (Cream) [50 g] 100 NULL NULL ⚠️ NULL
44856 1630712/0026 PCH-ORD/26-02-5646 Salbutamol 100mcg (Inhaler) [200 Device] 300 NULL NULL ⚠️ NULL
44855 1630711/0063 PCH-ORD/26-02-5646 Paracetamol 120mg/5mL (Syrup) [50 mL] 150 NULL NULL ⚠️ NULL
44854 1630684/0024 PCH-ORD/26-02-5646 Vitamin D (Calciferol) 5.000IU (Tablet) [100 Table... 10 NULL NULL ⚠️ NULL
44853 1630683/0022 PCH-ORD/26-02-5646 Amoxycillin 100 NULL NULL ⚠️ NULL
44852 1630656/0046 PCH-ORD/26-02-5646 Azithromycin 500mg (Tablet) [3 Tablet] 200 NULL NULL ⚠️ NULL
44851 1630628/0068 PCH-ORD/26-02-5646 Leflunomide 20mg (Tablet) [30 Tablet] 9 NULL NULL ⚠️ NULL
44850 1630627/0041 PCH-ORD/26-02-5646 Leflunomide 10mg (Tablet) [30 Tablet] 14 NULL NULL ⚠️ NULL
44849 1630604/0003 PCH-ORD/26-02-5646 Paracetamol 120mg/5mL (Syrup) [500 mL] 48 NULL NULL ⚠️ NULL
44848 1630602/0005 PCH-ORD/26-02-5646 Paracetamol 120mg/5mL (Syrup) [100 mL] 427 NULL NULL ⚠️ NULL
44847 1630599/0318 PCH-ORD/26-02-5646 Vitamin 400 NULL NULL ⚠️ NULL
44846 20071604 PCH-ORD/26-02-5646 Latanoprost 50ug/ml (Eye Drops) [3 mL] 92 NULL NULL ⚠️ NULL
44845 1630596/0318 PCH-ORD/26-02-5646 Latanoprost 50ug/ml (Eye Drops) [3 mL] 8 NULL NULL ⚠️ NULL
44844 1630592/0009 PCH-ORD/26-02-5646 Ipratropium 20mcg (Inhaler) [1 Device] 5 NULL NULL ⚠️ NULL
44843 1630577/0094 PCH-ORD/26-02-5646 Aluminium Hydroxide 300mg/5mL (Gel) [500 mL] 60 NULL NULL ⚠️ NULL
44842 1630532/0011 PCH-ORD/26-02-5646 Clopidogrel 75mg (Tablet) [28 Tablet] 100 NULL NULL ⚠️ NULL
44841 1630526/0010 PCH-ORD/26-02-5646 Baclofen 10mg (Tablet) [30 Tablet] 60 NULL NULL ⚠️ NULL
44840 1630500/0062 PCH-ORD/26-02-5646 Paracetamol 500mg (Tablet) [20 Tablet] 1,000 NULL NULL ⚠️ NULL
44839 1630493/0030 PCH-ORD/26-02-5646 Metformin 500mg (Tablet) [84 Tablet] 280 NULL NULL ⚠️ NULL
44838 1630492/0093 PCH-ORD/26-02-5646 Metformin 500mg (Tablet) [56 Tablet] 198 NULL NULL ⚠️ NULL
44837 1630488/0027 PCH-ORD/26-02-5646 Ibuprofen 200mg (Tablet) [15 Tablet] 560 NULL NULL ⚠️ NULL
44836 1630476/0064 PCH-ORD/26-02-5646 Furosemide 40mg (Tablet) [56 Tablet] 400 NULL NULL ⚠️ NULL
44835 1630461/0008 PCH-ORD/26-02-5646 Azithromycin 500mg (Tablet) [2 Tablet] 234 NULL NULL ⚠️ NULL
44834 1630459/0039 PCH-ORD/26-02-5646 Aspirin 300mg (Tablet) [14 Tablet] 1,332 NULL NULL ⚠️ NULL
44833 1630454/0074 PCH-ORD/26-02-5646 Tramadol 50mg (Capsule) [100 Capsule] 120 NULL NULL ⚠️ NULL
44832 1622191/0092 PCH-ORD/26-01-5622 Doxazosin 4mg (Tablet) [30 Tablet] 210 NULL NULL ⚠️ NULL
44831 1622130/0044 PCH-ORD/26-01-5622 Leflunomide 20mg (Tablet) [30 Tablet] 3 NULL NULL ⚠️ NULL
44830 1622124/0002 PCH-ORD/26-01-5622 Paracetamol 120mg/5mL (Syrup) [500 mL] 27 NULL NULL ⚠️ NULL
44829 1622086/0096 PCH-ORD/26-01-5622 Mifepristone/Misoprostol 200/0.2mg(1/4) vag. tab;c... 30 NULL NULL ⚠️ NULL
44828 1622054/0086 PCH-ORD/26-01-5622 Metformin 850mg (Tablet) [84 Tablet] 156 NULL NULL ⚠️ NULL
44827 1622032/0038 PCH-ORD/26-01-5622 Aspirin 300mg (Tablet) [14 Tablet] 637 NULL NULL ⚠️ NULL
44826 1614832/0056 PCH-ORD/26-01-5603 Levonorgestrel 0 NULL NULL ⚠️ NULL
44825 1614830/0054 PCH-ORD/26-01-5603 Levonorgestrel 0 NULL NULL ⚠️ NULL
44824 1614814/0025 PCH-ORD/26-01-5603 Vitamin D (Calciferol) 5.000IU (Tablet) [100 Table... 10 NULL NULL ⚠️ NULL
44823 1614776/0045 PCH-ORD/26-01-5603 Leflunomide 20mg (Tablet) [30 Tablet] 11 NULL NULL ⚠️ NULL
44822 1614775/0040 PCH-ORD/26-01-5603 Leflunomide 10mg (Tablet) [30 Tablet] 7 NULL NULL ⚠️ NULL
44821 1614760/0001 PCH-ORD/26-01-5603 Paracetamol 120mg/5mL (Syrup) [500 mL] 48 NULL NULL ⚠️ NULL
44820 1614653/0061 PCH-ORD/26-01-5603 Paracetamol 500mg (Tablet) [20 Tablet] 413 NULL NULL ⚠️ NULL
44819 20071603 PCH-ORD/26-01-5603 Metformin 500mg (Tablet) [56 Tablet] 232 NULL NULL ⚠️ NULL
44818 20071602 PCH-ORD/26-01-5603 Metformin 500mg (Tablet) [56 Tablet] 190 NULL NULL ⚠️ NULL
44817 20071601 PCH-ORD/26-01-5603 Metformin 500mg (Tablet) [56 Tablet] 53 NULL NULL ⚠️ NULL
44816 1614645/0095 PCH-ORD/26-01-5603 Metformin 500mg (Tablet) [56 Tablet] 5 NULL NULL ⚠️ NULL
44815 20071600 PCH-ORD/26-01-5603 Ibuprofen 200mg (Tablet) [15 Tablet] 197 NULL NULL ⚠️ NULL
44814 1614638/0043 PCH-ORD/26-01-5603 Ibuprofen 200mg (Tablet) [15 Tablet] 103 NULL NULL ⚠️ NULL
44813 1614630/0066 PCH-ORD/26-01-5603 Furosemide 40mg (Tablet) [56 Tablet] 232 NULL NULL ⚠️ NULL
44812 1614613/0037 PCH-ORD/26-01-5603 Aspirin 300mg (Tablet) [14 Tablet] 960 NULL NULL ⚠️ NULL
44811 1590850/0023 PCH-ORD/25-11-5572 Vitamin D (Calciferol) 5.000IU (Tablet) [100 Table... 10 NULL NULL ⚠️ NULL
44810 1590825/0006 PCH-ORD/25-11-5572 Glimepiride 2mg (Tablet) [30 Tablet] 200 NULL NULL ⚠️ NULL
44809 1590779/0004 PCH-ORD/25-11-5572 Paracetamol 120mg/5mL (Syrup) [100 mL] 350 NULL NULL ⚠️ NULL
44808 1590725/0055 PCH-ORD/25-11-5572 Levonorgestrel 0 NULL NULL ⚠️ NULL
44807 1590643/0075 PCH-ORD/25-11-5572 Metformin 500mg (Tablet) [56 Tablet] 673 NULL NULL ⚠️ NULL
44806 1590623/0067 PCH-ORD/25-11-5572 Furosemide 40mg (Tablet) [56 Tablet] 480 NULL NULL ⚠️ NULL
44805 1580233/0016 PCH-ORD/25-10-5557 Vitamin D (Calciferol) 5.000IU (Tablet) [100 Table... 10 NULL NULL ⚠️ NULL
44804 1580106/0053 PCH-ORD/25-10-5557 Levonorgestrel 0 NULL NULL ⚠️ NULL
44803 1580009/0065 PCH-ORD/25-10-5557 Furosemide 40mg (Tablet) [56 Tablet] 368 NULL NULL ⚠️ NULL
44802 1562470/0015 PCH-ORD/25-10-5503 Vitamin D (Calciferol) 5.000IU (Tablet) [100 Table... 10 NULL NULL ⚠️ NULL
44801 1562332/0049 PCH-ORD/26-01-5603 Pantoprazole 40mg (Tablet) [14 Tablet] 1,085 NULL NULL ⚠️ NULL
44800 1562332/0048 PCH-ORD/25-10-5503 Amoxycillin 500mg (Capsule) [15 Capsule] 1,085 NULL NULL ⚠️ NULL
44799 1550211/0047 PCH-ORD/25-08-5454 Pantoprazole 40mg (Tablet) [14 Tablet] 555 NULL NULL ⚠️ NULL
44798 1550149/0031 PCH-ORD/25-08-5454 Metformin 850mg (Tablet) [84 Tablet] 375 NULL NULL ⚠️ NULL
📦 Step 3: Select Delivery Point to Populate NULL Fields
Facility: PHOENIX CHC
Records to Update: 130
Will Update:
Demander ← dem_name
DemanderCode_str ← del_point
← Return to Dashboard