Supporting Facility Migration
rx_implementation · facility.facility → del_point.dem_name
Total Rows
795
Have Supporting Facility
794
Match facility + del_point
216
Will Change
0
Unmatched (need fix)
67
Backup Table
Yes

Migration Workflow

Follow these steps in order. Each step is safe to re-run. Backup → Log → Apply.

Only rows where facility.facility matches Supporting_Facility (case + whitespace insensitive) AND the facility's demandercode exists in del_point.del_point will be updated. Every changed row is recorded in rx_sf_migration_backup so you can roll back.

Preview — What would change

0 rows

Nothing left to migrate

All matching rows are already using del_point.dem_name.

Leftovers — Not matched, need manual review

67 rows
ID District Current Value Facility Match? Fix Manually
#94 ETHEKWINI CHARLES JAMES TB HOSPITAL not in facility
#82 ETHEKWINI HLENGISIZWE CHC not in facility
#83 ETHEKWINI HLENGISIZWE CHC not in facility
#76 ETHEKWINI HLENGISIZWE CHC not in facility
#77 ETHEKWINI HLENGISIZWE CHC not in facility
#78 ETHEKWINI HLENGISIZWE CHC not in facility
#79 ETHEKWINI HLENGISIZWE CHC not in facility
#80 ETHEKWINI HLENGISIZWE CHC not in facility
#81 ETHEKWINI HLENGISIZWE CHC not in facility
#882 Ethekwini KWAZULU-NATAL CHILDRENS HOSPITAL not in facility
#103 ETHEKWINI KZN CHILDRENS HOSPITAL not in facility
#102 ETHEKWINI VICTORIA MXENGE HOSPITAL not in facility
#667 KING CETSHWAYO ESHOWE HOSPITAL not in facility
#669 KING CETSHWAYO ESHOWE HOSPITAL not in facility
#671 KING CETSHWAYO ESHOWE HOSPITAL not in facility
#672 KING CETSHWAYO ESHOWE HOSPITAL not in facility
#665 KING CETSHWAYO ESHOWE HOSPITAL not in facility
#666 KING CETSHWAYO ESHOWE HOSPITAL not in facility
#799 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#800 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#801 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#721 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#795 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#255 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#796 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#797 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#798 UGU MFUNDO ARNOLD LUCHABA CHC not in facility
#312 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#728 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#738 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#314 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#729 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#739 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#315 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#730 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#747 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#316 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#732 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#749 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#317 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#733 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#318 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#724 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#735 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#308 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#326 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#726 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#736 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#311 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#727 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#737 UMGUNGUNDLOVU HARRY GWALA HOSPITAL not in facility
#908 Umgungundlovu Umgungundlovu district Umgungundlovu district · 0000001
#433 UMZINYATHI CHARLES JOHNSON MEMORIAL HOSPITAL not in facility
#446 UMZINYATHI CHARLES JOHNSON MEMORIAL HOSPITAL not in facility
#448 UMZINYATHI CHARLES JOHNSON MEMORIAL HOSPITAL not in facility
#449 UMZINYATHI CHARLES JOHNSON MEMORIAL HOSPITAL not in facility
#432 UMZINYATHI POMEROY CHC not in facility
#533 UTHUKELA ST CHADS CHC not in facility
#534 UTHUKELA ST CHADS CHC not in facility
#535 UTHUKELA ST CHADS CHC not in facility
#536 UTHUKELA ST CHADS CHC not in facility
#528 UTHUKELA ST CHADS CHC not in facility
#537 UTHUKELA ST CHADS CHC not in facility
#529 UTHUKELA ST CHADS CHC not in facility
#538 UTHUKELA ST CHADS CHC not in facility
#530 UTHUKELA ST CHADS CHC not in facility
#531 UTHUKELA ST CHADS CHC not in facility
Enter a value that already exists in del_point.dem_name. If the correct dem_name isn't there yet, add it to del_point first, then return here.

Migration Log (rx_sf_migration_backup)

367 rows logged
ID Old Value New Value Matched Facility Demandercode
#27 NEWCASTLE HOSPITAL
#28 NIEMEYER MEMORIAL HOSPITAL
#29 NIEMEYER MEMORIAL HOSPITAL
#30 NIEMEYER MEMORIAL HOSPITAL
#31 NIEMEYER MEMORIAL HOSPITAL
#32 KwaDabeka CHC
#35 KwaDabeka CHC
#37 KwaDabeka CHC
#42 KWAMASHU CHC
#43 KWAMASHU CHC
#44 KWAMASHU CHC
#45 KWAMASHU CHC
#46 KWAMASHU CHC
#51 INANDA CHC
#53 KwaDabeka CHC
#54 KwaDabeka CHC
#56 KwaDabeka CHC
#58 KwaDabeka CHC
#59 KwaDabeka CHC
#60 KwaDabeka CHC
#61 KwaDabeka CHC
#62 KWAMASHU CHC
#63 KWAMASHU CHC
#64 KWAMASHU CHC
#65 KWAMASHU CHC
#66 KWAMASHU CHC
#67 Inanda CHC
#68 INANDA CHC
#69 INANDA CHC
#70 INANDA CHC
#71 INANDA CHC
#72 NEWTOWN A CHC
#73 NEWTOWN A CHC
#74 PHOENIX CHC
#75 PHOENIX CHC
#86 Osindisweni Hospital
#88 ST MARYS HOSPITAL MARIANHILL
#89 ST MARYS HOSPITAL MARIANHILL
#100 KING DINUZULU HOSPITAL COMPLEX
#101 KING DINUZULU HOSPITAL COMPLEX
#106 PRINCE MSHIYENI MEMORIAL HOSPITAL
#107 PRINCE MSHIYENI MEMORIAL HOSPITAL
#108 PRINCE MSHIYENI MEMORIAL HOSPITAL
#109 PRINCE MSHIYENI MEMORIAL HOSPITAL
#110 PRINCE MSHIYENI MEMORIAL HOSPITAL
#111 PRINCE MSHIYENI MEMORIAL HOSPITAL
#112 PRINCE MSHIYENI MEMORIAL HOSPITAL
#113 PRINCE MSHIYENI MEMORIAL HOSPITAL
#114 PRINCE MSHIYENI MEMORIAL HOSPITAL
#115 PRINCE MSHIYENI MEMORIAL HOSPITAL
#116 PRINCE MSHIYENI MEMORIAL HOSPITAL
#117 PRINCE MSHIYENI MEMORIAL HOSPITAL
#118 PRINCE MSHIYENI MEMORIAL HOSPITAL
#119 PRINCE MSHIYENI MEMORIAL HOSPITAL
#120 PRINCE MSHIYENI MEMORIAL HOSPITAL
#121 PRINCE MSHIYENI MEMORIAL HOSPITAL
#122 PRINCE MSHIYENI MEMORIAL HOSPITAL
#123 PRINCE MSHIYENI MEMORIAL HOSPITAL
#124 PRINCE MSHIYENI MEMORIAL HOSPITAL
#125 PRINCE MSHIYENI MEMORIAL HOSPITAL
#126 PRINCE MSHIYENI MEMORIAL HOSPITAL
#127 PRINCE MSHIYENI MEMORIAL HOSPITAL
#128 RK KHAN HOSPITAL
#129 RK KHAN HOSPITAL
#131 Wentworth Hospital
#132 WENTWORTH HOSPITAL
#133 CHRIST THE KING HOSPITAL
#134 CHRIST THE KING HOSPITAL
#135 CHRIST THE KING HOSPITAL
#136 CHRIST THE KING HOSPITAL
#137 CHRIST THE KING HOSPITAL
#138 CHRIST THE KING HOSPITAL
#139 CHRIST THE KING HOSPITAL
#140 CHRIST THE KING HOSPITAL
#141 CHRIST THE KING HOSPITAL
#142 CHRIST THE KING HOSPITAL
#143 CHRIST THE KING HOSPITAL
#144 CHRIST THE KING HOSPITAL
#145 CHRIST THE KING HOSPITAL
#146 RIETVLEI DISTRICT HOSPITAL
#147 RIETVLEI DISTRICT HOSPITAL
#148 RIETVLEI DISTRICT HOSPITAL
#149 RIETVLEI DISTRICT HOSPITAL
#150 RIETVLEI DISTRICT HOSPITAL
#151 RIETVLEI DISTRICT HOSPITAL
#152 RIETVLEI DISTRICT HOSPITAL
#153 RIETVLEI DISTRICT HOSPITAL
#154 RIETVLEI DISTRICT HOSPITAL
#155 RIETVLEI DISTRICT HOSPITAL
#156 RIETVLEI DISTRICT HOSPITAL
#157 RIETVLEI DISTRICT HOSPITAL
#158 RIETVLEI DISTRICT HOSPITAL
#159 RIETVLEI DISTRICT HOSPITAL
#160 RIETVLEI DISTRICT HOSPITAL
#161 RIETVLEI DISTRICT HOSPITAL
#171 E. G. & USHER MEMORIAL HOSPITAL
#172 E. G. & USHER MEMORIAL HOSPITAL
#173 E. G. & USHER MEMORIAL HOSPITAL
#174 E. G. & USHER MEMORIAL HOSPITAL
#175 E. G. & USHER MEMORIAL HOSPITAL
#176 E. G. & USHER MEMORIAL HOSPITAL
#177 E. G. & USHER MEMORIAL HOSPITAL
#178 PHOLELA CHC
#179 PHOLELA CHC
#180 PHOLELA CHC
#181 PHOLELA CHC
#182 PHOLELA CHC
#183 PHOLELA CHC
#184 PHOLELA CHC
#185 PHOLELA CHC
#186 PHOLELA CHC
#187 PHOLELA CHC
#188 PHOLELA CHC
#190 UMZIMKHULU PSYCHIATRIC HOSPITAL
#191 NDWEDWE CHC
#192 NdweDwe CHC
#193 NdweDwe CHC
#194 NdweDwe CHC
#195 NDWEDWE CHC
#196 GJGMR HOSPITAL
#197 GJGMR HOSPITAL
#198 GJGMR HOSPITAL
#199 GJGMR HOSPITAL
#200 GJGMR HOSPITAL
#201 GJGMR HOSPITAL
#203 GJGMR HOSPITAL
#204 GJGMR HOSPITAL
#205 GJGMR HOSPITAL
#206 GJGMR HOSPITAL
#207 UMPHUMULO HOSPITAL
#208 Umphumulo Hospital
#209 Umphumulo Hospital
#210 UMPHUMULO HOSPITAL
#211 UMPHUMULO HOSPITAL
#212 UMPHUMULO HOSPITAL
#213 UMPHUMULO HOSPITAL
#214 UMPHUMULO HOSPITAL
#215 UMPHUMULO HOSPITAL
#216 UMPHUMULO HOSPITAL
#257 GJ CROOKES HOSPITAL
#258 GJ CROOKES HOSPITAL
#259 GJ CROOKES HOSPITAL
#260 GJ CROOKES HOSPITAL
#261 GJ CROOKES HOSPITAL
#262 GJ CROOKES HOSPITAL
#263 GJ CROOKES HOSPITAL
#264 GJ CROOKES HOSPITAL
#265 GJ CROOKES HOSPITAL
#266 GJ CROOKES HOSPITAL
#267 MURCHISON DISTRICT HOSPITAL
#268 MURCHISON DISTRICT HOSPITAL
#269 MURCHISON DISTRICT HOSPITAL
#270 MURCHISON DISTRICT HOSPITAL
#271 MURCHISON DISTRICT HOSPITAL
#272 MURCHISON DISTRICT HOSPITAL
#273 MURCHISON DISTRICT HOSPITAL
#274 ST ANDREWS HOSPITAL
#275 ST ANDREWS HOSPITAL
#276 ST ANDREWS HOSPITAL
#277 ST ANDREWS HOSPITAL
#278 ST ANDREWS HOSPITAL
#279 ST ANDREWS HOSPITAL
#280 ST ANDREWS HOSPITAL
#281 ST ANDREWS HOSPITAL
#282 ST ANDREWS HOSPITAL
#283 ST ANDREWS HOSPITAL
#284 ST ANDREWS HOSPITAL
#285 ST ANDREWS HOSPITAL
#286 ST ANDREWS HOSPITAL
#287 Port Shepstone Hospital
#288 Port Shepstone Hospital
#290 Port Shepstone Hospital
#291 Port Shepstone Hospital
#292 Port Shepstone Hospital
#293 Port Shepstone Hospital
#294 Port Shepstone Hospital
#295 Port Shepstone Hospital
#296 Port Shepstone Hospital
#297 Port Shepstone Hospital
#298 Port Shepstone Hospital
#307 DORIS GOODWIN HOSPITAL
#328 GREYS HOSPITAL
#329 NORTHDALE HOSPITAL
#330 NORTHDALE HOSPITAL
#331 NORTHDALE HOSPITAL
#332 NORTHDALE HOSPITAL
#333 NORTHDALE HOSPITAL
#334 NORTHDALE HOSPITAL
#335 NORTHDALE HOSPITAL
#336 NORTHDALE HOSPITAL
#337 NORTHDALE HOSPITAL
#338 NORTHDALE HOSPITAL
#345 EAST BOOM CHC
#346 EAST BOOM CHC
#347 EAST BOOM CHC
#348 EAST BOOM CHC
#349 EAST BOOM CHC
#350 EAST BOOM CHC
#351 EAST BOOM CHC
#352 EAST BOOM CHC
#353 EAST BOOM CHC
#354 EAST BOOM CHC
#355 IMBALENHLE CHC
#356 IMBALENHLE CHC
#357 IMBALENHLE CHC
#358 IMBALENHLE CHC
#359 IMBALENHLE CHC
#360 IMBALENHLE CHC
#361 IMBALENHLE CHC
#362 IMBALENHLE CHC
#363 IMBALENHLE CHC
#473 DUNDEE HOSPITAL
#474 DUNDEE HOSPITAL
#475 DUNDEE HOSPITAL
#476 DUNDEE HOSPITAL
#477 DUNDEE HOSPITAL
#478 DUNDEE HOSPITAL
#479 DUNDEE HOSPITAL
#480 DUNDEE HOSPITAL
#481 GREYTOWN HOSPITAL
#482 GREYTOWN HOSPITAL
#483 GREYTOWN HOSPITAL
#484 GREYTOWN HOSPITAL
#485 GREYTOWN HOSPITAL
#486 GREYTOWN HOSPITAL
#487 GREYTOWN HOSPITAL
#488 GREYTOWN HOSPITAL
#489 GREYTOWN HOSPITAL
#490 GREYTOWN HOSPITAL
#491 GREYTOWN HOSPITAL
#492 GREYTOWN HOSPITAL
#493 GREYTOWN HOSPITAL
#494 GREYTOWN HOSPITAL
#495 GREYTOWN HOSPITAL
#496 EMMAUS HOSPITAL
#497 EMMAUS HOSPITAL
#498 EMMAUS HOSPITAL
#499 EMMAUS HOSPITAL
#500 EMMAUS HOSPITAL
#501 EMMAUS HOSPITAL
#502 EMMAUS HOSPITAL
#503 EMMAUS HOSPITAL
#504 ESTCOURT HOSPITAL
#505 ESTCOURT HOSPITAL
#506 ESTCOURT HOSPITAL
#507 ESTCOURT HOSPITAL
#508 ESTCOURT HOSPITAL
#509 ESTCOURT HOSPITAL
#510 ESTCOURT HOSPITAL
#511 ESTCOURT HOSPITAL
#512 ESTCOURT HOSPITAL
#513 ESTCOURT HOSPITAL
#514 ESTCOURT HOSPITAL
#515 ESTCOURT HOSPITAL
#516 ESTCOURT HOSPITAL
#517 LADYSMITH HOSPITAL
#518 LADYSMITH HOSPITAL
#519 LADYSMITH HOSPITAL
#520 LADYSMITH HOSPITAL
#521 LADYSMITH HOSPITAL
#522 LADYSMITH HOSPITAL
#523 LADYSMITH HOSPITAL
#524 LADYSMITH HOSPITAL
#525 LADYSMITH HOSPITAL
#526 LADYSMITH HOSPITAL
#527 LADYSMITH HOSPITAL
#539 EDUMBE CHC
#540 EDUMBE CHC
#541 EDUMBE CHC
#542 EDUMBE CHC
#543 EDUMBE CHC
#544 EDUMBE CHC
#545 EDUMBE CHC
#546 EDUMBE CHC
#547 EDUMBE CHC
#559 ITSHELEJUBA HOSPITAL
#560 ITSHELEJUBA HOSPITAL
#561 ITSHELEJUBA HOSPITAL
#562 ITSHELEJUBA HOSPITAL
#563 ITSHELEJUBA HOSPITAL
#564 ITSHELEJUBA HOSPITAL
#565 ITSHELEJUBA HOSPITAL
#566 ITSHELEJUBA HOSPITAL
#567 VRYHEID HOSPITAL
#568 ITSHELEJUBA HOSPITAL
#569 ITSHELEJUBA HOSPITAL
#570 ITSHELEJUBA HOSPITAL
#613 VRYHEID HOSPITAL
#614 VRYHEID HOSPITAL
#615 VRYHEID HOSPITAL
#616 VRYHEID HOSPITAL
#617 VRYHEID HOSPITAL
#618 VRYHEID HOSPITAL
#619 VRYHEID HOSPITAL
#620 VRYHEID HOSPITAL
#621 VRYHEID HOSPITAL
#622 VRYHEID HOSPITAL
#623 VRYHEID HOSPITAL
#624 VRYHEID HOSPITAL
#625 VRYHEID HOSPITAL
#626 VRYHEID HOSPITAL
#627 VRYHEID HOSPITAL
#628 VRYHEID HOSPITAL
#629 VRYHEID HOSPITAL
#630 VRYHEID HOSPITAL
#631 VRYHEID HOSPITAL
#632 THULASIZWE TB MDR HOSPITAL
#633 THULASIZWE TB MDR HOSPITAL
#634 VRYHEID HOSPITAL
#690 ST MARYS KWAMAGWAZA HOSPITAL
#691 ST MARYS KWAMAGWAZA HOSPITAL
#692 ST MARYS KWAMAGWAZA HOSPITAL
#693 ST MARYS KWAMAGWAZA HOSPITAL
#694 ST MARYS KWAMAGWAZA HOSPITAL
#695 ST MARYS KWAMAGWAZA HOSPITAL
#696 ST MARYS KWAMAGWAZA HOSPITAL
#697 ST MARYS KWAMAGWAZA HOSPITAL
#698 ST MARYS KWAMAGWAZA HOSPITAL
#713 MAHATMA GANDHI MEMORIAL HOSPITAL
#714 MURCHISON DISTRICT HOSPITAL
#715 OTHOBOTHINI CHC
#716 OTHOBOTHINI CHC
#717 OTHOBOTHINI CHC
#718 OTHOBOTHINI CHC
#719 OTHOBOTHINI CHC
#720 OTHOBOTHINI CHC
#725 LADYSMITH HOSPITAL
#741 POMEROY CHC
#742 POMEROY CHC
#743 POMEROY CHC
#744 POMEROY CHC
#745 POMEROY CHC
#746 POMEROY CHC
#761 ST. APOLLINARIS HOSPITAL
#762 ST. APOLLINARIS HOSPITAL
#763 ST. APOLLINARIS HOSPITAL
#764 ST. APOLLINARIS HOSPITAL
#765 ST. APOLLINARIS HOSPITAL
#766 ST. APOLLINARIS HOSPITAL
#768 ST. APOLLINARIS HOSPITAL
#783 DR PIXLEY KA ISAKA SEME MEMORIAL HOSPITAL
#802 ESHOWE DISTRICT HOSPITAL
#803 ESHOWE DISTRICT HOSPITAL
#804 EKOMBE DISTRICT HOSPITAL
#805 EKOMBE DISTRICT HOSPITAL
#807 EKOMBE DISTRICT HOSPITAL
#808 Ekombe District Hospital
#810 EKOMBE DISTRICT HOSPITAL
#811 EKOMBE DISTRICT HOSPITAL
#812 EKOMBE DISTRICT HOSPITAL
#813 EKOMBE DISTRICT HOSPITAL
#823 EKOMBE DISTRICT HOSPITAL
#824 ESHOWE DISTRICT HOSPITAL
#825 ESHOWE DISTRICT HOSPITAL
#826 ESHOWE DISTRICT HOSPITAL
#827 ESHOWE DISTRICT HOSPITAL
#828 ESHOWE DISTRICT HOSPITAL
#829 ESHOWE DISTRICT HOSPITAL
#861 MAHATMA GANDHI MEMORIAL HOSPITAL
#874 GJGMR Hospital
#895 St Marys KwaMagwaza Hospital
#897 St Marys KwaMagwaza Hospital
#902 St Marys KwaMagwaza Hospital
#904 St Marys KwaMagwaza Hospital
#905 St Marys KwaMagwaza Hospital
#906 Osindisweni Hospital
#907 St Marys Hospital Marianhill