I started over. This is the result of my upgrade screen. It looks like the upgrade sequence is skipping the group therapy upgrades. Why might it be doing this? Well, I can see that the layout_group_properties table does in fact exist in my 5.0.0 build. Looking at 5_0_0-to-5_0_1_upgrade.sql I can see that within the if statement–#IfNotTable layout_group_properties, the necessary upgrades are contained. So I can see why it appears to be skipping the routine to add ‘group_id’ field to ‘layout_options’ because it is within the if statement. Perhaps #EndIf should be at the closed parentheses?:
OpenEMR Database Upgrade
Processing 5_0_0-to-5_0_1_upgrade.sql ...
ALTER TABLE `list_options` ADD `edit_options` TINYINT(1) NOT NULL DEFAULT '1'
ALTER TABLE `list_options` ADD `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
Skipping section #IfNotTable multiple_db
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `notes`, `activity`) VALUES ('page_validation', 'therapy_groups_add#addGroup', '/interface/therapy_groups/index.php?method=addGroup', 120, '{group_name:{presence: true}}', 1)
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `notes`, `activity`) VALUES ('page_validation', 'therapy_groups_edit#editGroup', '/interface/therapy_groups/index.php?method=groupDetails', 125, '{group_name:{presence: true}}', 1)
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `notes`, `activity`) VALUES ('page_validation', 'tg_add#add-participant-form', '/interface/therapy_groups/index.php?method=groupParticipants', 130, '{participant_name:{presence: true}, group_patient_start:{presence: true}}', 1)
INSERT INTO `list_options` (`list_id`,`option_id`,`title`,`seq`,`is_default`,`option_value`,`mapping`,`notes`,`codes`,`toggle_setting_1`,`toggle_setting_2`,`activity`,`subtype`)VALUES ('page_validation','add_edit_event#theform_groups','/interface/main/calendar/add_edit_event.php?group=true',150,0,0,'','{form_group:{presence: true}}','',0,0,1,'')
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `notes`, `activity`) VALUES ('page_validation', 'common#new-encounter-form', '/interface/forms/newGroupEncounter/common.php', 160, '{pc_catid:{exclusion: ["_blank"]}}', 1)
Skipping section #IfNotTable therapy_groups
Skipping section #IfNotTable therapy_groups_participants
Skipping section #IfNotTable therapy_groups_participant_attendance
Skipping section #IfNotTable therapy_groups_counselors
ALTER TABLE openemr_postcalendar_events ADD pc_gid int(11) DEFAULT 0
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`) VALUES ('lists', 'groupstat', 'Group Statuses', '13', '0', '0')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`) VALUES ('groupstat', '-', '- None', '10', '0', '0', 'FEFDCF|0')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`) VALUES ('groupstat', '=', '= Took Place', '20', '0', '0', 'FF2414|0')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`) VALUES ('groupstat', '>', '> Did Not Take Place', '30', '0', '0', 'BFBFBF|0')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`) VALUES ('groupstat', '<', '< Not Reported', '40', '0', '0', 'FEFDCF|0')
INSERT INTO openemr_postcalendar_categories (`pc_catname`, `pc_catcolor`, `pc_recurrspec`, `pc_duration` ,`pc_cattype` , `pc_active` , `pc_seq`)VALUES ('Group Therapy' , '#BFBFBF' , 'a:5:{s:17:"event_repeat_freq";s:1:"0";s:22:"event_repeat_freq_type";s:1:"0";s:19:"event_repeat_on_num";s:1:"1";s:19:"event_repeat_on_day";s:1:"0";s:20:"event_repeat_on_freq";s:1:"0";}', '3600', '3', '1', '90')
Skipping section #IfNotTable form_groups_encounter
ALTER TABLE `forms` ADD `therapy_group_id` INT(11) DEFAULT NULL
ALTER TABLE `registry` ADD `patient_encounter` TINYINT NOT NULL DEFAULT '1'
ALTER TABLE `registry` ADD `therapy_group_encounter` TINYINT NOT NULL DEFAULT '0'
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`) VALUES ('lists', 'attendstat', 'Group Attendance Statuses', '15', '0', '0')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`, `toggle_setting_1`) VALUES ('attendstat', '-', '- Not Reported', '10', '0', '0', 'FEFDCF|0', '0')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`, `toggle_setting_1`) VALUES ('attendstat', '@', '@ Attended', '20', '0', '0', 'FF2414|0', '1')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`, `toggle_setting_1`) VALUES ('attendstat', '?', '? Did Not Attend', '30', '0', '0', 'BFBFBF|0', '1')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`, `toggle_setting_1`) VALUES ('attendstat', '~', '~ Late Arrival', '40', '0', '0', 'BFBFBF|0', '1')
INSERT INTO list_options (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `notes`, `toggle_setting_1`) VALUES ('attendstat', 'x', 'x Cancelled', '50', '0', '0', 'FEFDCF|0', '0')
INSERT INTO registry (name, state, directory, sql_run, unpackaged, date, priority, category, nickname, patient_encounter, therapy_group_encounter) VALUES ('Group Attendance Form', 1, 'group_attendance', 1, 1, '2015-10-15 00:00:00', 0, 'Clinical', '',0,1)
INSERT INTO registry (name, state, directory, sql_run, unpackaged, date, priority, category, nickname, patient_encounter, therapy_group_encounter) VALUES ('New Group Encounter Form', 1, 'newGroupEncounter', 1, 1, '2015-10-15 00:00:00', 0, 'Clinical', '',0,1)
Skipping section #IfTable form_therapy_groups_attendance
Skipping section #IfNotTable form_group_attendance
INSERT INTO list_options (`list_id`, `option_id`, `title`) VALUES ('lists', 'files_white_list', 'Files type white list')
Skipping section #IfNotTable onsite_documents
Skipping section #IfNotTable onsite_mail
Skipping section #IfNotTable onsite_messages
Skipping section #IfNotTable onsite_online
Skipping section #IfNotTable onsite_portal_activity
Skipping section #IfNotTable onsite_signatures
INSERT INTO categories select (select MAX(id) from categories) + 1, 'Onsite Portal', '', 1, rght, rght + 5 from categories where name = 'Categories'
INSERT INTO categories select (select MAX(id) from categories) + 1, 'Patient', '', (select id from categories where name = 'Onsite Portal'), rght + 1, rght + 2 from categories where name = 'Categories'
INSERT INTO categories select (select MAX(id) from categories) + 1, 'Reviewed', '', (select id from categories where name = 'Onsite Portal'), rght + 3, rght + 4 from categories where name = 'Categories'
UPDATE categories SET rght = rght + 6 WHERE name = 'Categories'
UPDATE categories_seq SET id = (select MAX(id) from categories)
INSERT INTO list_options ( `list_id`, `option_id`, `title`, `seq`, `is_default`, `notes` ) VALUES ('apptstat','^','^ Pending',70,0,'FEFDCF|0')
ALTER TABLE `registry` ADD `aco_spec` varchar(63) NOT NULL default 'encounters|notes'
UPDATE `registry` SET `aco_spec` = 'patients|appt' WHERE directory = 'newpatient'
UPDATE `registry` SET `aco_spec` = 'patients|appt' WHERE directory = 'newGroupEncounter'
UPDATE `registry` SET `aco_spec` = 'encounters|coding' WHERE directory = 'fee_sheet'
UPDATE `registry` SET `aco_spec` = 'encounters|coding' WHERE directory = 'misc_billing_options'
UPDATE `registry` SET `aco_spec` = 'patients|lab' WHERE directory = 'procedure_order'
ALTER TABLE `lbf_data` CHANGE `field_value` `field_value` longtext
ALTER TABLE `issue_types` ADD `aco_spec` varchar(63) NOT NULL default 'patients|med'
ALTER TABLE `categories` ADD `aco_spec` varchar(63) NOT NULL default 'patients|docs'
Skipping section #IfNotColumnType onsite_mail owner varchar(128)
ALTER TABLE `openemr_postcalendar_events` CHANGE `pc_facility` `pc_facility` int(11) NOT NULL DEFAULT '0' COMMENT 'facility id for this event'
ALTER TABLE `form_misc_billing_options` ADD `onset_date` date default NULL
UPDATE `list_options` SET `option_id` = 'DK', `title` = 'Ordering Provider' WHERE `list_id` = 'provider_qualifier_code' AND `option_id` = 'dk'
UPDATE `list_options` SET `option_id` = 'DN', `title` = 'Referring Provider', `is_default` = '1' WHERE `list_id` = 'provider_qualifier_code' AND `option_id` = 'dn'
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `is_default`) VALUES ('provider_qualifier_code', 'DQ', 'Supervising Provider', '30', '0')
ALTER TABLE `users` ADD `main_menu_role` VARCHAR(50) NOT NULL DEFAULT 'standard'
ALTER TABLE `openemr_postcalendar_categories` ADD COLUMN `aco_spec` VARCHAR(63) NOT NULL DEFAULT 'encounters|notes'
INSERT INTO list_options (list_id,option_id,title) VALUES ('lists','apps','Apps')
INSERT INTO list_options (list_id,option_id,title,seq,is_default,activity) VALUES ('apps','*OpenEMR','main/main_screen.php',10,1,0)
INSERT INTO list_options (list_id,option_id,title,seq,is_default,activity) VALUES ('apps','Calendar','main/calendar/index.php',20,0,0)
ALTER TABLE `list_options` CHANGE `list_id` `list_id` VARCHAR(100) NOT NULL DEFAULT ''
ALTER TABLE `list_options` CHANGE `option_id` `option_id` VARCHAR(100) NOT NULL DEFAULT ''
ALTER TABLE `layout_options` CHANGE `list_id` `list_id` VARCHAR(100) NOT NULL DEFAULT ''
ALTER TABLE `layout_options` CHANGE `list_backup_id` `list_backup_id` VARCHAR(100) NOT NULL DEFAULT ''
Skipping section #IfNotTable patient_birthday_alert
INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES('ICD10', 'CMS', '2017-10-01', '2018-ICD-10-PCS-Order-File.zip', '264b342310236f2b3927062d2c72cfe3')
INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES('ICD10', 'CMS', '2017-10-01', '2018-ICD-10-CM-General-Equivalence-Mappings.zip', '787a025fdcf6e1da1a85be779004f670')
UPDATE `supported_external_dataloads` SET `load_filename`='2018-ICD-10-Code-Descriptions.zip' WHERE `load_filename`='2018-ICD-10-Code-Dedcriptions.zip' AND `load_release_date`='2017-10-01'
INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES('ICD10', 'CMS', '2017-10-01', '2018-ICD-10-Code-Descriptions.zip', '6f9c77440132e30f565222ca9bb6599c')
INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES('ICD10', 'CMS', '2017-10-01', '2018-ICD-10-PCS-General-Equivalence-Mappings.zip', 'bb73c80e272da28712887d7979b1cebf')
ALTER TABLE `x12_partners` DROP COLUMN `x12_version`
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `notes`, `activity`) VALUES('page_validation', 'add_edit_event#theform_prov', '/interface/main/calendar/add_edit_event.php?prov=true', 170, '{}', 1)
ALTER TABLE `claims` ADD COLUMN `submitted_claim` TEXT COMMENT 'This claims form claim data'
ALTER TABLE `billing` ADD COLUMN `revenue_code` varchar(6) NOT NULL DEFAULT "" COMMENT 'Item revenue code'
ALTER TABLE `codes` ADD COLUMN `revenue_code` varchar(6) NOT NULL DEFAULT "" COMMENT 'Item revenue code'
ALTER TABLE `users` ADD `weno_prov_id` VARCHAR(15) DEFAULT NULL
ALTER TABLE `prescriptions` ADD `ntx` INT(2) DEFAULT NULL
ALTER TABLE `prescriptions` ADD `rtx` INT(2) DEFAULT NULL
ALTER TABLE `prescriptions` ADD `txDate` DATE NOT NULL
ALTER TABLE `pharmacies` ADD `ncpdp` INT(12) DEFAULT NULL
ALTER TABLE `pharmacies` ADD `npi` INT(12) DEFAULT NULL
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES ('state','PR','Puerto Rico',39,0)
Skipping section #IfNotTable erx_drug_paid
Skipping section #IfNotTable erx_rx_log
Skipping section #IfNotTable erx_narcotics
UPDATE `globals` SET `gl_value`='style_red.css' WHERE `gl_name`='css_header' AND `gl_value`='style_flat_red.css'
UPDATE `globals` SET `gl_value`='style_manila.css' WHERE `gl_name`='css_header' AND `gl_value`='style_tan.css'
UPDATE `globals` SET `gl_value`='style_light.css' WHERE `gl_name`='css_header' AND (`gl_value`='style_babyblu.css' OR `gl_value`='style_metal.css' OR `gl_value`='style_oemr.css' OR `gl_value`='style_purple.css' OR `gl_value`='style_radiant.css' OR `gl_value`='style_sky_blue.css')
UPDATE `user_settings` SET `setting_value`='style_red.css' WHERE `setting_label`='global:css_header' AND `setting_value`='style_flat_red.css'
UPDATE `user_settings` SET `setting_value`='style_manila.css' WHERE `setting_label`='global:css_header' AND `setting_value`='style_tan.css'
UPDATE `user_settings` SET `setting_value`='style_light.css' WHERE `setting_label`='global:css_header' AND (`setting_value`='style_babyblu.css' OR `setting_value`='style_metal.css' OR `setting_value`='style_oemr.css' OR `setting_value`='style_purple.css' OR `setting_value`='style_radiant.css' OR `setting_value`='style_sky_blue.css')
ALTER TABLE `facility` CHANGE `country_code` `country_code` varchar(30) NOT NULL default ''
ALTER TABLE `layout_options` CHANGE `group_name` `group_name` varchar(255) NOT NULL default ''
ALTER TABLE `forms` ADD COLUMN `issue_id` bigint(20) NOT NULL default 0 COMMENT 'references lists.id to identify a case'
ALTER TABLE `forms` ADD COLUMN `provider_id` bigint(20) NOT NULL default 0 COMMENT 'references users.id to identify a provider'
Skipping section #IfNotTable layout_group_properties
Skipping section #ConvertLayoutProperties
ALTER TABLE `openemr_postcalendar_categories` ADD `pc_constant_id` VARCHAR (255) default NULL
UPDATE `openemr_postcalendar_categories` SET pc_constant_id = LOWER(REPLACE (pc_catname,' ', '_'))
ALTER TABLE openemr_postcalendar_categories ADD UNIQUE (`pc_constant_id`)
ALTER TABLE facility ADD facility_taxonomy VARCHAR(15) DEFAULT NULL
Skipping section #IfNotTable medex_icons
Skipping section #IfNotTable medex_outgoing
Skipping section #IfNotTable medex_prefs
Skipping section #IfNotTable medex_recalls
INSERT INTO `background_services` (`name`, `title`, `active`, `running`, `next_run`, `execute_interval`, `function`, `require_once`, `sort_order`) VALUES('MedEx', 'MedEx Messaging Service', 0, 0, '2017-05-09 17:39:10', 0, 'start_MedEx', '/library/MedEx/MedEx_background.php', 100)
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `mapping`, `notes`, `codes`, `toggle_setting_1`, `toggle_setting_2`, `activity`, `subtype`) VALUES('apptstat', 'AVM', 'AVM Confirmed', 110, 0, 0, '', 'F0FFE8|0', '', 0, 0, 1, '')
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `mapping`, `notes`, `codes`, `toggle_setting_1`, `toggle_setting_2`, `activity`, `subtype`) VALUES('apptstat', 'CALL', 'Callback requested', 130, 0, 0, '', 'FFDBE2|5', '', 0, 0, 1, '')
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `mapping`, `notes`, `codes`, `toggle_setting_1`, `toggle_setting_2`, `activity`, `subtype`) VALUES('apptstat', 'SMS', 'SMS Confirmed', 90, 0, 0, '', 'F0FFE8|0', '', 0, 0, 1, '')
INSERT INTO `list_options` (`list_id`, `option_id`, `title`, `seq`, `is_default`, `option_value`, `mapping`, `notes`, `codes`, `toggle_setting_1`, `toggle_setting_2`, `activity`, `subtype`) VALUES('apptstat', 'EMAIL', 'EMAIL Confirmed', 20, 0, 0, '', 'FFEBE3|0', '', 0, 0, 1, '')
ALTER TABLE `log_comment_encrypt` ADD `version` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 for mycrypt and 1 for openssl'
ALTER TABLE form_misc_billing_options CHANGE `icn_resubmission_number` `icn_resubmission_number` VARCHAR(35) DEFAULT NULL
ALTER TABLE `users` ADD `patient_menu_role` VARCHAR(50) NOT NULL DEFAULT 'standard'
Updating global configuration defaults...
Updating Access Controls...
UPGRADING ACCESS CONTROLS TO VERSION 4:
Checking to ensure all the proper ACL(access control list) are present:
'Administrators' group 'write' ACL is present.
'Physicians' group 'write' ACL is present.
'Clinicians' group 'write' ACL is present.
'Clinicians' group 'addonly' ACL is present.
'Front Office' group 'write' ACL is present.
'Accounting' group 'write' ACL is present.
Adding new objects
The 'Patient Reminders (write,addonly optional)' object in the 'Patients' section has been successfully added.
The 'Clinical Reminders/Alerts (write,addonly optional)' object in the 'Patients' section has been successfully added.
The 'Disclosures (write,addonly optional)' object in the 'Patients' section has been successfully added.
The 'Prescriptions (write,addonly optional)' object in the 'Patients' section has been successfully added.
The 'Amendments (write,addonly optional)' object in the 'Patients' section has been successfully added.
The 'Lab Results (write,addonly optional)' object in the 'Patients' section has been successfully added.
Updating the ACLs(Access Control Lists)
Successfully placed the 'Patient Reminders (write,addonly optional)' object of the 'Patients' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Clinical Reminders/Alerts (write,addonly optional)' object of the 'Patients' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Disclosures (write,addonly optional)' object of the 'Patients' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Prescriptions (write,addonly optional)' object of the 'Patients' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Amendments (write,addonly optional)' object of the 'Patients' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Lab Results (write,addonly optional)' object of the 'Patients' section into the 'Physicians' group 'write' ACL.
UPGRADING ACCESS CONTROLS TO VERSION 5:
Checking to ensure all the proper ACL(access control list) are present:
'Administrators' group 'write' ACL is present.
Adding new object sections
The 'Groups' object section has been successfully added.
Adding new objects
The 'Multipledb' object in the 'Administration' section has been successfully added.
The 'View/Add/Update groups' object in the 'Groups' section has been successfully added.
The 'View/Create/Update groups appointment in calendar' object in the 'Groups' section has been successfully added.
The 'Group encounter log' object in the 'Groups' section has been successfully added.
The 'Group detailed log of appointment in patient record' object in the 'Groups' section has been successfully added.
The 'Send message from the permanent group therapist to the personal therapist' object in the 'Groups' section has been successfully added.
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Updating the ACLs(Access Control Lists)
Successfully placed the 'View/Add/Update groups' object of the 'Groups' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'View/Create/Update groups appointment in calendar' object of the 'Groups' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Group encounter log' object of the 'Groups' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Group detailed log of appointment in patient record' object of the 'Groups' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Send message from the permanent group therapist to the personal therapist' object of the 'Groups' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Multipledb' object of the 'Administration' section into the 'Administrators' group 'write' ACL.
UPGRADING ACCESS CONTROLS TO VERSION 6:
Checking to ensure all the proper ACL(access control list) are present:
'Administrators' group 'write' ACL is present.
'Physicians' group 'write' ACL is present.
'Clinicians' group 'addonly' ACL is present.
'Clinicians' group 'write' ACL is present.
'Front Office' group 'view' ACL is present.
'Front Office' group 'write' ACL is present.
'Accounting' group 'view' ACL is present.
'Emergency Login' group 'write' ACL is present.
Adding new object sections
The 'Menu' object in the 'Administration' section has been successfully added.
Adding new objects
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Updating the ACLs(Access Control Lists)
Successfully placed the 'Menu' object of the 'Administration' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Authorize - my encounters' object of the 'Encounters' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Coding - my encounters (write,wsome optional)' object of the 'Encounters' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Notes - my encounters (write,addonly optional)' object of the 'Encounters' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Less-private information (write,addonly optional)' object of the 'Encounters' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Sign Lab Results (write,addonly optional)' object of the 'Patients' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Patient Reminders (write,addonly optional)' object of the 'Patients' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Clinical Reminders/Alerts (write,addonly optional)' object of the 'Patients' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Disclosures (write,addonly optional)' object of the 'Patients' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Prescriptions (write,addonly optional)' object of the 'Patients' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Amendments (write,addonly optional)' object of the 'Patients' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Lab Results (write,addonly optional)' object of the 'Patients' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Authorize - my encounters' object of the 'Encounters' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Coding - my encounters (write,wsome optional)' object of the 'Encounters' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Notes - my encounters (write,addonly optional)' object of the 'Encounters' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Less-private information (write,addonly optional)' object of the 'Encounters' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'View/Create/Update groups appointment in calendar' object of the 'Groups' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Group encounter log' object of the 'Groups' section into the 'Physicians' group 'write' ACL.
Successfully placed the 'Transactions (write optional)' object of the 'Patients' section into the 'Clinicians' group 'addonly' ACL.
Successfully placed the 'Patient Reminders (write,addonly optional)' object of the 'Patients' section into the 'Clinicians' group 'addonly' ACL.
Successfully placed the 'Clinical Reminders/Alerts (write,addonly optional)' object of the 'Patients' section into the 'Clinicians' group 'addonly' ACL.
Successfully placed the 'Disclosures (write,addonly optional)' object of the 'Patients' section into the 'Clinicians' group 'addonly' ACL.
Successfully placed the 'Prescriptions (write,addonly optional)' object of the 'Patients' section into the 'Clinicians' group 'addonly' ACL.
Successfully placed the 'Amendments (write,addonly optional)' object of the 'Patients' section into the 'Clinicians' group 'addonly' ACL.
Successfully placed the 'Lab Results (write,addonly optional)' object of the 'Patients' section into the 'Clinicians' group 'addonly' ACL.
Successfully placed the 'View/Create/Update groups appointment in calendar' object of the 'Groups' section into the 'Clinicians' group 'write' ACL.
Successfully placed the 'Group encounter log' object of the 'Groups' section into the 'Clinicians' group 'write' ACL.
Successfully placed the 'Clinical Reminders/Alerts (write,addonly optional)' object of the 'Patients' section into the 'Front Office' group 'view' ACL.
Successfully placed the 'View/Create/Update groups appointment in calendar' object of the 'Groups' section into the 'Front Office' group 'write' ACL.
Successfully placed the 'Clinical Reminders/Alerts (write,addonly optional)' object of the 'Patients' section into the 'Accounting' group 'view' ACL.
Successfully placed the 'Multipledb' object of the 'Administration' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Menu' object of the 'Administration' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Authorize - my encounters' object of the 'Encounters' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Coding - my encounters (write,wsome optional)' object of the 'Encounters' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Notes - my encounters (write,addonly optional)' object of the 'Encounters' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Less-private information (write,addonly optional)' object of the 'Encounters' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Sign Lab Results (write,addonly optional)' object of the 'Patients' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Patient Reminders (write,addonly optional)' object of the 'Patients' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Clinical Reminders/Alerts (write,addonly optional)' object of the 'Patients' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Disclosures (write,addonly optional)' object of the 'Patients' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Prescriptions (write,addonly optional)' object of the 'Patients' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Amendments (write,addonly optional)' object of the 'Patients' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Lab Results (write,addonly optional)' object of the 'Patients' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'View/Add/Update groups' object of the 'Groups' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'View/Create/Update groups appointment in calendar' object of the 'Groups' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Group encounter log' object of the 'Groups' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Group detailed log of appointment in patient record' object of the 'Groups' section into the 'Emergency Login' group 'write' ACL.
Successfully placed the 'Send message from the permanent group therapist to the personal therapist' object of the 'Groups' section into the 'Emergency Login' group 'write' ACL.
UPGRADING ACCESS CONTROLS TO VERSION 7:
Checking to ensure all the proper ACL(access control list) are present:
'Administrators' group 'write' ACL is present.
'Emergency Login' group 'write' ACL is present.
Adding new object sections
The 'Manage modules' object in the 'Administration' section has been successfully added.
Adding new objects
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Successfully placed the 'Manage modules' object of the 'Administration' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Manage modules' object of the 'Administration' section into the 'Emergency Login' group 'write' ACL.
Updating the ACLs(Access Control Lists)
UPGRADING ACCESS CONTROLS TO VERSION 8:
Checking to ensure all the proper ACL(access control list) are present:
'Administrators' group 'write' ACL is present.
'Emergency Login' group 'write' ACL is present.
Adding new object sections
The 'Documents Delete' object in the 'Patients' section has been successfully added.
Adding new objects
Upgrading objects
Adding ACLs(Access Control Lists) and groups
Successfully placed the 'Documents Delete' object of the 'Patients' section into the 'Administrators' group 'write' ACL.
Successfully placed the 'Documents Delete' object of the 'Patients' section into the 'Emergency Login' group 'write' ACL.
Updating the ACLs(Access Control Lists)
DONE upgrading access controls
Updating version indicators...
Database and Access Control upgrade finished.