HOSxP_PCU :
http://bms-hosxp.com/HOSxP_PCU_Setup_3.54.10.31.exe Checking structure phase 2
ALTER TABLE provis_service_op MODIFY COLUMN `instype` char(4)
ALTER TABLE provis_proced_op ADD `serv_per` varchar(15) NULL
ALTER TABLE provis_person_pp MODIFY COLUMN `bgroup` char(2)
ALTER TABLE provis_person_pp MODIFY COLUMN `religion` char(2)
ALTER TABLE provis_person_pp MODIFY COLUMN `occupa` char(4)
ALTER TABLE provis_person_op MODIFY COLUMN `bgroup` char(2)
ALTER TABLE provis_person_op MODIFY COLUMN `religion` char(2)
ALTER TABLE provis_person_op MODIFY COLUMN `occupa` char(4)
ALTER TABLE provis_person MODIFY COLUMN `occupa` char(4)
ALTER TABLE provis_direct_service_op MODIFY COLUMN `instype` char(4)
ALTER TABLE provis_direct_person_op MODIFY COLUMN `bgroup` char(2)
ALTER TABLE provis_direct_person_op MODIFY COLUMN `religion` char(2)
ALTER TABLE provis_direct_person_op MODIFY COLUMN `occupa` char(4)
ALTER TABLE patient_cancer_accessory ADD `staff3` int NULL
ALTER TABLE patient_cancer_accessory ADD `staff2` int NULL
ALTER TABLE patient_cancer_accessory ADD `staff1` int NULL
Checking structure phase 1