Pharmacy and Poisons Board: Applications

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent9c3d2c89526db53b7b69e8c9faa06145
  time1746064096
  countdown10
====
Request
+
Request

Cake Params
- plugin(null)
- controllerapplications
- actionview
- named(empty)
- pass(array)
  01533
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(empty)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Logs

default

Total Time: 3854 ms
Total Queries: 53 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `ctr`.`applications` AS `Application` WHERE `Application`.`id` = 1533	1	1	1
SELECT `Application`.`id`, `Application`.`user_id`, `Application`.`trial_status_id`, `Application`.`abstract_of_study`, `Application`.`study_title`, `Application`.`laymans_summary`, `Application`.`short_title`, `Application`.`protocol_no`, `Application`.`version_no`, `Application`.`date_of_protocol`, `Application`.`study_drug`, `Application`.`disease_condition`, `Application`.`product_type_biologicals`, `Application`.`product_type_proteins`, `Application`.`product_type_immunologicals`, `Application`.`product_type_vaccines`, `Application`.`product_type_hormones`, `Application`.`product_type_toxoid`, `Application`.`product_type_chemical`, `Application`.`product_type_medical_device`, `Application`.`product_type_chemical_name`, `Application`.`product_type_medical_device_name`, `Application`.`comparator`, `Application`.`comparator_name`, `Application`.`comparator_registered`, `Application`.`comparator_countries`, `Application`.`ecct_not_applicable`, `Application`.`ecct_ref_number`, `Application`.`email_address`, `Application`.`applicant_covering_letter`, `Application`.`applicant_protocol`, `Application`.`applicant_patient_information`, `Application`.`applicant_investigators_brochure`, `Application`.`applicant_investigators_cv`, `Application`.`applicant_signed_declaration`, `Application`.`applicant_financial_declaration`, `Application`.`applicant_gmp_certificate`, `Application`.`applicant_indemnity_cover`, `Application`.`applicant_opinion_letter`, `Application`.`applicant_approval_letter`, `Application`.`applicant_statement`, `Application`.`applicant_participating_countries`, `Application`.`applicant_addendum`, `Application`.`applicant_fees`, `Application`.`applicant_complete_form`, `Application`.`applicant_impd`, `Application`.`applicant_prev_data`, `Application`.`applicant_stability_data`, `Application`.`applicant_analysis_cert`, `Application`.`applicant_pictorial_sample`, `Application`.`applicant_gcp_training`, `Application`.`applicant_dsmb_charter`, `Application`.`applicant_detailed_budget`, `Application`.`applicant_indemnity_pi`, `Application`.`applicant_practice_license`, `Application`.`applicant_registration_ctr`, `Application`.`applicant_pan_african`, `Application`.`applicant_hard_copies`, `Application`.`applicant_signed_checklist`, `Application`.`statistical_analysis_plan`, `Application`.`applicant_contractual_agreement`, `Application`.`declaration_applicant`, `Application`.`declaration_date1`, `Application`.`declaration_principal_investigator`, `Application`.`declaration_date2`, `Application`.`placebo_present`, `Application`.`study_objectives`, `Application`.`principal_inclusion_criteria`, `Application`.`principal_exclusion_criteria`, `Application`.`primary_end_points`, `Application`.`scope_diagnosis`, `Application`.`scope_prophylaxis`, `Application`.`scope_therapy`, `Application`.`scope_safety`, `Application`.`scope_efficacy`, `Application`.`scope_pharmacokinetic`, `Application`.`scope_pharmacodynamic`, `Application`.`scope_bioequivalence`, `Application`.`scope_dose_response`, `Application`.`scope_pharmacogenetic`, `Application`.`scope_pharmacogenomic`, `Application`.`scope_pharmacoecomomic`, `Application`.`scope_others`, `Application`.`scope_others_specify`, `Application`.`trial_human_pharmacology`, `Application`.`trial_administration_humans`, `Application`.`trial_bioequivalence_study`, `Application`.`trial_other`, `Application`.`trial_other_specify`, `Application`.`trial_therapeutic_exploratory`, `Application`.`trial_therapeutic_confirmatory`, `Application`.`trial_therapeutic_use`, `Application`.`design_controlled`, `Application`.`site_capacity`, `Application`.`staff_numbers`, `Application`.`other_details_explanation`, `Application`.`other_details_regulatory_notapproved`, `Application`.`other_details_regulatory_approved`, `Application`.`other_details_regulatory_rejected`, `Application`.`other_details_regulatory_halted`, `Application`.`estimated_duration`, `Application`.`design_controlled_randomised`, `Application`.`design_controlled_open`, `Application`.`design_controlled_single_blind`, `Application`.`design_controlled_double_blind`, `Application`.`design_controlled_parallel_group`, `Application`.`design_controlled_cross_over`, `Application`.`design_controlled_other`, `Application`.`design_controlled_specify`, `Application`.`design_controlled_comparator`, `Application`.`design_controlled_other_medicinal`, `Application`.`design_controlled_placebo`, `Application`.`design_controlled_medicinal_other`, `Application`.`design_controlled_medicinal_specify`, `Application`.`single_site_member_state`, `Application`.`location_of_area`, `Application`.`single_site_physical_address`, `Application`.`single_site_contact_person`, `Application`.`single_site_telephone`, `Application`.`multiple_sites_member_state`, `Application`.`multiple_countries`, `Application`.`multiple_member_states`, `Application`.`number_of_sites`, `Application`.`multi_country_list`, `Application`.`data_monitoring_committee`, `Application`.`total_enrolment_per_site`, `Application`.`total_participants_worldwide`, `Application`.`population_less_than_18_years`, `Application`.`population_utero`, `Application`.`population_preterm_newborn`, `Application`.`population_newborn`, `Application`.`population_infant_and_toddler`, `Application`.`population_children`, `Application`.`population_adolescent`, `Application`.`population_above_18`, `Application`.`population_adult`, `Application`.`population_elderly`, `Application`.`gender_female`, `Application`.`gender_male`, `Application`.`subjects_healthy`, `Application`.`subjects_patients`, `Application`.`subjects_vulnerable_populations`, `Application`.`subjects_women_child_bearing`, `Application`.`subjects_women_using_contraception`, `Application`.`subjects_pregnant_women`, `Application`.`subjects_nursing_women`, `Application`.`subjects_emergency_situation`, `Application`.`subjects_incapable_consent`, `Application`.`subjects_specify`, `Application`.`subjects_others`, `Application`.`subjects_others_specify`, `Application`.`investigator1_given_name`, `Application`.`investigator1_middle_name`, `Application`.`investigator1_family_name`, `Application`.`investigator1_qualification`, `Application`.`investigator1_professional_address`, `Application`.`investigator1_telephone`, `Application`.`investigator1_email`, `Application`.`organisations_transferred_`, `Application`.`number_participants`, `Application`.`notification`, `Application`.`approval_date`, `Application`.`submitted`, `Application`.`deleted`, `Application`.`deleted_date`, `Application`.`deactivated`, `Application`.`date_submitted`, `Application`.`is_child`, `Application`.`unsubmitted`, `Application`.`initial_date_submitted`, `Application`.`admin_stopped`, `Application`.`admin_stopped_reason`, `Application`.`approved`, `Application`.`approved_reason`, `Application`.`final_report`, `Application`.`implication_results`, `Application`.`quantity_imported`, `Application`.`quantity_dispensed`, `Application`.`quantity_destroyed`, `Application`.`quantity_exported`, `Application`.`balance_site`, `Application`.`final_date`, `Application`.`modified`, `Application`.`created`, `Application`.`total_sites`, `Application`.`ecitizen_invoice`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`confirm_password`, `User`.`name`, `User`.`email`, `User`.`national_id_number`, `User`.`sponsor`, `User`.`sponsor_email`, `User`.`qualification`, `User`.`phone_no`, `User`.`name_of_institution`, `User`.`institution_physical`, `User`.`institution_address`, `User`.`institution_contact`, `User`.`county_id`, `User`.`country_id`, `User`.`group_id`, `User`.`activation_key`, `User`.`forgot_password`, `User`.`is_active`, `User`.`deactivated`, `User`.`created`, `User`.`modified`, `TrialStatus`.`id`, `TrialStatus`.`value`, `TrialStatus`.`name`, `TrialStatus`.`created`, `TrialStatus`.`modified` FROM `ctr`.`applications` AS `Application` LEFT JOIN `ctr`.`users` AS `User` ON (`Application`.`user_id` = `User`.`id`) LEFT JOIN `ctr`.`trial_statuses` AS `TrialStatus` ON (`Application`.`trial_status_id` = `TrialStatus`.`id`) WHERE `Application`.`id` = 1533 AND `Application`.`deleted` = '0' LIMIT 1	1	1	13	maybe slow
SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`application_id`, `Review`.`type`, `Review`.`assessment_type`, `Review`.`title`, `Review`.`text`, `Review`.`summary`, `Review`.`recommendation`, `Review`.`notified`, `Review`.`accepted`, `Review`.`conflict`, `Review`.`status`, `Review`.`created`, `Review`.`modified` FROM `ctr`.`reviews` AS `Review` WHERE `Review`.`application_id` = (1533)	3	3	9	maybe slow
SELECT `ActiveInspector`.`id`, `ActiveInspector`.`user_id`, `ActiveInspector`.`application_id`, `ActiveInspector`.`description`, `ActiveInspector`.`notified`, `ActiveInspector`.`accepted`, `ActiveInspector`.`created`, `ActiveInspector`.`modified` FROM `ctr`.`active_inspectors` AS `ActiveInspector` WHERE `ActiveInspector`.`application_id` = (1533)	0	0	12	maybe slow
SELECT `ManagerReview`.`id`, `ManagerReview`.`user_id`, `ManagerReview`.`application_id`, `ManagerReview`.`type`, `ManagerReview`.`assessment_type`, `ManagerReview`.`title`, `ManagerReview`.`text`, `ManagerReview`.`summary`, `ManagerReview`.`recommendation`, `ManagerReview`.`notified`, `ManagerReview`.`accepted`, `ManagerReview`.`conflict`, `ManagerReview`.`status`, `ManagerReview`.`created`, `ManagerReview`.`modified` FROM `ctr`.`reviews` AS `ManagerReview` WHERE `ManagerReview`.`application_id` = (1533)	3	3	8	maybe slow
SELECT `Acceptance`.`id`, `Acceptance`.`user_id`, `Acceptance`.`application_id`, `Acceptance`.`type`, `Acceptance`.`assessment_type`, `Acceptance`.`title`, `Acceptance`.`text`, `Acceptance`.`summary`, `Acceptance`.`recommendation`, `Acceptance`.`notified`, `Acceptance`.`accepted`, `Acceptance`.`conflict`, `Acceptance`.`status`, `Acceptance`.`created`, `Acceptance`.`modified` FROM `ctr`.`reviews` AS `Acceptance` WHERE `Acceptance`.`type` = 'acceptance' AND `Acceptance`.`application_id` = (1533)	0	0	9	maybe slow
SELECT `Amendment`.`id`, `Amendment`.`application_id`, `Amendment`.`trial_status_id`, `Amendment`.`abstract_of_study`, `Amendment`.`study_title`, `Amendment`.`laymans_summary`, `Amendment`.`protocol_no`, `Amendment`.`version_no`, `Amendment`.`date_of_protocol`, `Amendment`.`study_drug`, `Amendment`.`disease_condition`, `Amendment`.`product_type`, `Amendment`.`product_type_biologicals`, `Amendment`.`product_type_proteins`, `Amendment`.`product_type_immunologicals`, `Amendment`.`product_type_vaccines`, `Amendment`.`product_type_hormones`, `Amendment`.`product_type_toxoid`, `Amendment`.`product_type_chemical`, `Amendment`.`product_type_medical_device`, `Amendment`.`product_type_chemical_name`, `Amendment`.`product_type_medical_device_name`, `Amendment`.`comparator`, `Amendment`.`comparator_name`, `Amendment`.`comparator_registered`, `Amendment`.`comparator_countries`, `Amendment`.`previous_dates`, `Amendment`.`coordinating_investigators`, `Amendment`.`principal_investigators`, `Amendment`.`pharmacist`, `Amendment`.`sponsor_details`, `Amendment`.`gender`, `Amendment`.`details_of_sites`, `Amendment`.`placebos`, `Amendment`.`scopes`, `Amendment`.`organizations`, `Amendment`.`types_and_phases`, `Amendment`.`ecct_not_applicable`, `Amendment`.`ecct_ref_number`, `Amendment`.`email_address`, `Amendment`.`applicant_covering_letter`, `Amendment`.`applicant_protocol`, `Amendment`.`applicant_patient_information`, `Amendment`.`applicant_investigators_brochure`, `Amendment`.`applicant_investigators_cv`, `Amendment`.`applicant_signed_declaration`, `Amendment`.`applicant_financial_declaration`, `Amendment`.`applicant_gmp_certificate`, `Amendment`.`applicant_indemnity_cover`, `Amendment`.`applicant_opinion_letter`, `Amendment`.`applicant_approval_letter`, `Amendment`.`applicant_statement`, `Amendment`.`applicant_participating_countries`, `Amendment`.`applicant_addendum`, `Amendment`.`applicant_fees`, `Amendment`.`declaration_applicant`, `Amendment`.`declaration_date1`, `Amendment`.`declaration_principal_investigator`, `Amendment`.`declaration_date2`, `Amendment`.`placebo_present`, `Amendment`.`study_objectives`, `Amendment`.`principal_inclusion_criteria`, `Amendment`.`principal_exclusion_criteria`, `Amendment`.`primary_end_points`, `Amendment`.`scope_diagnosis`, `Amendment`.`scope_prophylaxis`, `Amendment`.`scope_therapy`, `Amendment`.`scope_safety`, `Amendment`.`scope_efficacy`, `Amendment`.`scope_pharmacokinetic`, `Amendment`.`scope_pharmacodynamic`, `Amendment`.`scope_bioequivalence`, `Amendment`.`scope_dose_response`, `Amendment`.`scope_pharmacogenetic`, `Amendment`.`scope_pharmacogenomic`, `Amendment`.`scope_pharmacoecomomic`, `Amendment`.`scope_others`, `Amendment`.`scope_others_specify`, `Amendment`.`trial_human_pharmacology`, `Amendment`.`trial_administration_humans`, `Amendment`.`trial_bioequivalence_study`, `Amendment`.`trial_other`, `Amendment`.`trial_other_specify`, `Amendment`.`trial_therapeutic_exploratory`, `Amendment`.`trial_therapeutic_confirmatory`, `Amendment`.`trial_therapeutic_use`, `Amendment`.`design_controlled`, `Amendment`.`site_capacity`, `Amendment`.`staff_numbers`, `Amendment`.`other_details_explanation`, `Amendment`.`other_details_regulatory_notapproved`, `Amendment`.`other_details_regulatory_approved`, `Amendment`.`other_details_regulatory_rejected`, `Amendment`.`other_details_regulatory_halted`, `Amendment`.`estimated_duration`, `Amendment`.`design_controlled_randomised`, `Amendment`.`design_controlled_open`, `Amendment`.`design_controlled_single_blind`, `Amendment`.`design_controlled_double_blind`, `Amendment`.`design_controlled_parallel_group`, `Amendment`.`design_controlled_cross_over`, `Amendment`.`design_controlled_other`, `Amendment`.`design_controlled_specify`, `Amendment`.`design_controlled_comparator`, `Amendment`.`design_controlled_other_medicinal`, `Amendment`.`design_controlled_placebo`, `Amendment`.`design_controlled_medicinal_other`, `Amendment`.`design_controlled_medicinal_specify`, `Amendment`.`single_site_member_state`, `Amendment`.`location_of_area`, `Amendment`.`multiple_sites_member_state`, `Amendment`.`multiple_countries`, `Amendment`.`multiple_member_states`, `Amendment`.`number_of_sites`, `Amendment`.`multi_country_list`, `Amendment`.`data_monitoring_committee`, `Amendment`.`total_enrolment_per_site`, `Amendment`.`total_participants_worldwide`, `Amendment`.`population_less_than_18_years`, `Amendment`.`population_utero`, `Amendment`.`population_preterm_newborn`, `Amendment`.`population_newborn`, `Amendment`.`population_infant_and_toddler`, `Amendment`.`population_children`, `Amendment`.`population_adolescent`, `Amendment`.`population_above_18`, `Amendment`.`population_adult`, `Amendment`.`population_elderly`, `Amendment`.`gender_female`, `Amendment`.`gender_male`, `Amendment`.`subjects_healthy`, `Amendment`.`subjects_patients`, `Amendment`.`subjects_vulnerable_populations`, `Amendment`.`subjects_women_child_bearing`, `Amendment`.`subjects_women_using_contraception`, `Amendment`.`subjects_pregnant_women`, `Amendment`.`subjects_nursing_women`, `Amendment`.`subjects_emergency_situation`, `Amendment`.`subjects_incapable_consent`, `Amendment`.`subjects_specify`, `Amendment`.`subjects_others`, `Amendment`.`subjects_others_specify`, `Amendment`.`investigator1_given_name`, `Amendment`.`investigator1_middle_name`, `Amendment`.`investigator1_family_name`, `Amendment`.`investigator1_qualification`, `Amendment`.`investigator1_professional_address`, `Amendment`.`organisations_transferred_`, `Amendment`.`number_participants`, `Amendment`.`notification`, `Amendment`.`approval_date`, `Amendment`.`submitted`, `Amendment`.`date_submitted`, `Amendment`.`modified`, `Amendment`.`created` FROM `ctr`.`amendments` AS `Amendment` WHERE `Amendment`.`application_id` = (1533)	0	0	73	maybe slow
SELECT `InvestigatorContact`.`id`, `InvestigatorContact`.`application_id`, `InvestigatorContact`.`given_name`, `InvestigatorContact`.`middle_name`, `InvestigatorContact`.`family_name`, `InvestigatorContact`.`qualification`, `InvestigatorContact`.`professional_address`, `InvestigatorContact`.`telephone`, `InvestigatorContact`.`email`, `InvestigatorContact`.`created`, `InvestigatorContact`.`modified` FROM `ctr`.`investigator_contacts` AS `InvestigatorContact` WHERE `InvestigatorContact`.`application_id` = (1533)	1	1	2	maybe slow
SELECT `ApplicationStage`.`id`, `ApplicationStage`.`application_id`, `ApplicationStage`.`stage`, `ApplicationStage`.`start_date`, `ApplicationStage`.`status`, `ApplicationStage`.`comment`, `ApplicationStage`.`end_date`, `ApplicationStage`.`created`, `ApplicationStage`.`modified` FROM `ctr`.`application_stages` AS `ApplicationStage` WHERE `ApplicationStage`.`application_id` = (1533)	8	8	7	maybe slow
SELECT `Pharmacist`.`id`, `Pharmacist`.`application_id`, `Pharmacist`.`reg_no`, `Pharmacist`.`given_name`, `Pharmacist`.`premise_name`, `Pharmacist`.`qualification`, `Pharmacist`.`professional_address`, `Pharmacist`.`valid_year`, `Pharmacist`.`mobile`, `Pharmacist`.`telephone`, `Pharmacist`.`email`, `Pharmacist`.`created`, `Pharmacist`.`modified` FROM `ctr`.`pharmacists` AS `Pharmacist` WHERE `Pharmacist`.`application_id` = (1533)	1	1	18	maybe slow
SELECT `EthicalCommittee`.`id`, `EthicalCommittee`.`application_id`, `EthicalCommittee`.`ethical_committee`, `EthicalCommittee`.`submission_date`, `EthicalCommittee`.`erc_number`, `EthicalCommittee`.`initial_approval`, `EthicalCommittee`.`created`, `EthicalCommittee`.`modified` FROM `ctr`.`ethical_committees` AS `EthicalCommittee` WHERE `EthicalCommittee`.`application_id` = (1533)	1	1	18	maybe slow
SELECT `AnnualLetter`.`id`, `AnnualLetter`.`application_id`, `AnnualLetter`.`approval_no`, `AnnualLetter`.`content`, `AnnualLetter`.`approver`, `AnnualLetter`.`qrcode`, `AnnualLetter`.`approval_date`, `AnnualLetter`.`expiry_date`, `AnnualLetter`.`status`, `AnnualLetter`.`deleted`, `AnnualLetter`.`deleted_date`, `AnnualLetter`.`created`, `AnnualLetter`.`modified` FROM `ctr`.`annual_letters` AS `AnnualLetter` WHERE `AnnualLetter`.`deleted` = '0' AND `AnnualLetter`.`application_id` = (1533)	1	1	807	maybe slow
SELECT `AmendmentLetter`.`id`, `AmendmentLetter`.`application_id`, `AmendmentLetter`.`approval_no`, `AmendmentLetter`.`content`, `AmendmentLetter`.`qrcode`, `AmendmentLetter`.`approver`, `AmendmentLetter`.`approval_date`, `AmendmentLetter`.`expiry_date`, `AmendmentLetter`.`status`, `AmendmentLetter`.`submitted`, `AmendmentLetter`.`deleted`, `AmendmentLetter`.`deleted_date`, `AmendmentLetter`.`created`, `AmendmentLetter`.`modified` FROM `ctr`.`amendment_letters` AS `AmendmentLetter` WHERE `AmendmentLetter`.`application_id` = (1533)	0	0	16	maybe slow
SELECT `AmendmentApproval`.`id`, `AmendmentApproval`.`application_id`, `AmendmentApproval`.`approval_no`, `AmendmentApproval`.`amendment`, `AmendmentApproval`.`content`, `AmendmentApproval`.`approver`, `AmendmentApproval`.`approval_date`, `AmendmentApproval`.`status`, `AmendmentApproval`.`deleted`, `AmendmentApproval`.`deleted_date`, `AmendmentApproval`.`created`, `AmendmentApproval`.`modified` FROM `ctr`.`amendment_approvals` AS `AmendmentApproval` WHERE `AmendmentApproval`.`application_id` = (1533)	0	0	14	maybe slow
SELECT `AmendmentApprovalSummary`.`id`, `AmendmentApprovalSummary`.`application_id`, `AmendmentApprovalSummary`.`approval_no`, `AmendmentApprovalSummary`.`amendment`, `AmendmentApprovalSummary`.`content`, `AmendmentApprovalSummary`.`approver`, `AmendmentApprovalSummary`.`approval_date`, `AmendmentApprovalSummary`.`status`, `AmendmentApprovalSummary`.`deleted`, `AmendmentApprovalSummary`.`deleted_date`, `AmendmentApprovalSummary`.`created`, `AmendmentApprovalSummary`.`modified` FROM `ctr`.`amendment_approvals` AS `AmendmentApprovalSummary` WHERE `AmendmentApprovalSummary`.`status` = 'summary' AND `AmendmentApprovalSummary`.`application_id` = (1533)	0	0	0
SELECT `Organization`.`id`, `Organization`.`application_id`, `Organization`.`organization`, `Organization`.`contact_person`, `Organization`.`address`, `Organization`.`telephone_number`, `Organization`.`all_tasks`, `Organization`.`monitoring`, `Organization`.`regulatory`, `Organization`.`investigator_recruitment`, `Organization`.`ivrs_treatment_randomisation`, `Organization`.`data_management`, `Organization`.`e_data_capture`, `Organization`.`susar_reporting`, `Organization`.`quality_assurance_auditing`, `Organization`.`statistical_analysis`, `Organization`.`medical_writing`, `Organization`.`other_duties`, `Organization`.`other_duties_specify`, `Organization`.`misc`, `Organization`.`created`, `Organization`.`modified` FROM `ctr`.`organizations` AS `Organization` WHERE `Organization`.`application_id` = (1533)	1	1	59	maybe slow
SELECT `SiteDetail`.`id`, `SiteDetail`.`application_id`, `SiteDetail`.`county_id`, `SiteDetail`.`site_name`, `SiteDetail`.`physical_address`, `SiteDetail`.`contact_details`, `SiteDetail`.`contact_person`, `SiteDetail`.`site_capacity`, `SiteDetail`.`misc`, `SiteDetail`.`created`, `SiteDetail`.`modified` FROM `ctr`.`site_details` AS `SiteDetail` WHERE `SiteDetail`.`application_id` = (1533)	1	1	2	maybe slow
SELECT `Placebo`.`id`, `Placebo`.`application_id`, `Placebo`.`placebo_present`, `Placebo`.`pharmaceutical_form`, `Placebo`.`route_of_administration`, `Placebo`.`composition`, `Placebo`.`identical_indp`, `Placebo`.`major_ingredients`, `Placebo`.`created`, `Placebo`.`modified` FROM `ctr`.`placebos` AS `Placebo` WHERE `Placebo`.`application_id` = (1533)	1	1	4	maybe slow
SELECT `Sponsor`.`id`, `Sponsor`.`application_id`, `Sponsor`.`sponsor`, `Sponsor`.`sponsor_type`, `Sponsor`.`contact_person`, `Sponsor`.`address`, `Sponsor`.`telephone_number`, `Sponsor`.`fax_number`, `Sponsor`.`cell_number`, `Sponsor`.`email_address`, `Sponsor`.`created`, `Sponsor`.`modified` FROM `ctr`.`sponsors` AS `Sponsor` WHERE `Sponsor`.`application_id` = (1533)	1	1	1
SELECT `SiteInspection`.`id`, `SiteInspection`.`application_id`, `SiteInspection`.`user_id`, `SiteInspection`.`reference_no`, `SiteInspection`.`study_title`, `SiteInspection`.`protocol_no`, `SiteInspection`.`version_no`, `SiteInspection`.`pactr_number`, `SiteInspection`.`trial_phase`, `SiteInspection`.`investigators`, `SiteInspection`.`co_investigators`, `SiteInspection`.`study_stage`, `SiteInspection`.`inspection_country`, `SiteInspection`.`inspector_names`, `SiteInspection`.`inspection_dates`, `SiteInspection`.`site_address`, `SiteInspection`.`sponsor_address`, `SiteInspection`.`lab_address`, `SiteInspection`.`events_summary`, `SiteInspection`.`conclusion`, `SiteInspection`.`summary_report`, `SiteInspection`.`outcome`, `SiteInspection`.`approved`, `SiteInspection`.`summary_approved`, `SiteInspection`.`approved_by`, `SiteInspection`.`sent_to_pi`, `SiteInspection`.`deleted`, `SiteInspection`.`deleted_date`, `SiteInspection`.`created`, `SiteInspection`.`modified` FROM `ctr`.`site_inspections` AS `SiteInspection` WHERE `SiteInspection`.`deleted` = '0' AND `SiteInspection`.`application_id` = (1533)	0	0	15	maybe slow
SELECT `Sae`.`id`, `Sae`.`application_id`, `Sae`.`sae_id`, `Sae`.`reference_no`, `Sae`.`form_type`, `Sae`.`user_id`, `Sae`.`patient_initials`, `Sae`.`country_id`, `Sae`.`date_of_birth`, `Sae`.`age_years`, `Sae`.`gender`, `Sae`.`causality`, `Sae`.`enrollment_date`, `Sae`.`administration_date`, `Sae`.`latest_date`, `Sae`.`reaction_onset`, `Sae`.`reaction_end_date`, `Sae`.`patient_died`, `Sae`.`prolonged_hospitalization`, `Sae`.`incapacity`, `Sae`.`life_threatening`, `Sae`.`reaction_other`, `Sae`.`reaction_description`, `Sae`.`relevant_history`, `Sae`.`manufacturer_name`, `Sae`.`mfr_no`, `Sae`.`manufacturer_date`, `Sae`.`source_study`, `Sae`.`source_literature`, `Sae`.`source_health_professional`, `Sae`.`report_date`, `Sae`.`report_type`, `Sae`.`approved`, `Sae`.`approved_by`, `Sae`.`email_address`, `Sae`.`reporter_name`, `Sae`.`reporter_phone`, `Sae`.`reporter_email`, `Sae`.`deleted`, `Sae`.`deleted_date`, `Sae`.`created`, `Sae`.`modified` FROM `ctr`.`saes` AS `Sae` WHERE `Sae`.`application_id` = (1533)	2	2	564	maybe slow
SELECT `Ciom`.`id`, `Ciom`.`application_id`, `Ciom`.`reference_no`, `Ciom`.`user_id`, `Ciom`.`reporter_email`, `Ciom`.`e2b_content`, `Ciom`.`e2b_file`, `Ciom`.`file`, `Ciom`.`dirname`, `Ciom`.`basename`, `Ciom`.`checksum`, `Ciom`.`alternative`, `Ciom`.`group`, `Ciom`.`description`, `Ciom`.`created`, `Ciom`.`modified` FROM `ctr`.`cioms` AS `Ciom` WHERE `Ciom`.`application_id` = (1533)	0	0	48	maybe slow
SELECT `StudyRoute`.`id`, `StudyRoute`.`application_id`, `StudyRoute`.`study_route`, `StudyRoute`.`created`, `StudyRoute`.`modified` FROM `ctr`.`study_routes` AS `StudyRoute` WHERE `StudyRoute`.`application_id` = (1533)	1	1	12	maybe slow
SELECT `Manufacturer`.`id`, `Manufacturer`.`application_id`, `Manufacturer`.`manufacturer_name`, `Manufacturer`.`address`, `Manufacturer`.`manufacturer_country`, `Manufacturer`.`manufacturer_phone`, `Manufacturer`.`manufacturer_email`, `Manufacturer`.`manufacturing_activities`, `Manufacturer`.`other_specify`, `Manufacturer`.`created`, `Manufacturer`.`modified` FROM `ctr`.`manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`application_id` = (1533)	1	1	28	maybe slow
SELECT `Reassignment`.`id`, `Reassignment`.`application_id`, `Reassignment`.`orig_user`, `Reassignment`.`new_user`, `Reassignment`.`assigning_user`, `Reassignment`.`created`, `Reassignment`.`modified` FROM `ctr`.`reassignments` AS `Reassignment` WHERE `Reassignment`.`application_id` = (1533)	0	0	13	maybe slow
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`file`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`description`, `Attachment`.`year`, `Attachment`.`file_date`, `Attachment`.`pocket_name`, `Attachment`.`version_no`, `Attachment`.`created`, `Attachment`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Attachment__path` FROM `ctr`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Application' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (1533)	0	0	168	maybe slow
SELECT `AnnualApproval`.`id`, `AnnualApproval`.`model`, `AnnualApproval`.`file`, `AnnualApproval`.`foreign_key`, `AnnualApproval`.`dirname`, `AnnualApproval`.`basename`, `AnnualApproval`.`checksum`, `AnnualApproval`.`alternative`, `AnnualApproval`.`group`, `AnnualApproval`.`description`, `AnnualApproval`.`year`, `AnnualApproval`.`file_date`, `AnnualApproval`.`pocket_name`, `AnnualApproval`.`version_no`, `AnnualApproval`.`created`, `AnnualApproval`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `AnnualApproval__path` FROM `ctr`.`attachments` AS `AnnualApproval` WHERE `AnnualApproval`.`model` = 'AnnualApproval' AND `AnnualApproval`.`foreign_key` = (1533)	0	0	71	maybe slow
SELECT `AmendmentChecklist`.`id`, `AmendmentChecklist`.`model`, `AmendmentChecklist`.`file`, `AmendmentChecklist`.`foreign_key`, `AmendmentChecklist`.`dirname`, `AmendmentChecklist`.`basename`, `AmendmentChecklist`.`checksum`, `AmendmentChecklist`.`alternative`, `AmendmentChecklist`.`group`, `AmendmentChecklist`.`description`, `AmendmentChecklist`.`year`, `AmendmentChecklist`.`file_date`, `AmendmentChecklist`.`pocket_name`, `AmendmentChecklist`.`version_no`, `AmendmentChecklist`.`created`, `AmendmentChecklist`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `AmendmentChecklist__path` FROM `ctr`.`attachments` AS `AmendmentChecklist` WHERE `AmendmentChecklist`.`model` = 'AmendmentChecklist' AND `AmendmentChecklist`.`foreign_key` = (1533)	0	0	71	maybe slow
SELECT `Reminder`.`id`, `Reminder`.`foreign_key`, `Reminder`.`model`, `Reminder`.`user_id`, `Reminder`.`reminder_type`, `Reminder`.`created`, `Reminder`.`modified` FROM `ctr`.`reminders` AS `Reminder` WHERE `Reminder`.`model` = 'Application' AND `Reminder`.`foreign_key` = (1533)	0	0	17	maybe slow
SELECT `ParticipantFlow`.`id`, `ParticipantFlow`.`application_id`, `ParticipantFlow`.`year`, `ParticipantFlow`.`original_subjects`, `ParticipantFlow`.`consented`, `ParticipantFlow`.`screened`, `ParticipantFlow`.`enrolled`, `ParticipantFlow`.`lost`, `ParticipantFlow`.`lost_reason`, `ParticipantFlow`.`withdrawn`, `ParticipantFlow`.`withdrawal_reason`, `ParticipantFlow`.`self_withdrawal`, `ParticipantFlow`.`self_withdrawal_reasons`, `ParticipantFlow`.`active_subjects`, `ParticipantFlow`.`completed_number`, `ParticipantFlow`.`created`, `ParticipantFlow`.`modified` FROM `ctr`.`participant_flows` AS `ParticipantFlow` WHERE `ParticipantFlow`.`application_id` = (1533)	0	0	4	maybe slow
SELECT `Budget`.`id`, `Budget`.`application_id`, `Budget`.`year`, `Budget`.`budget_period`, `Budget`.`personnel_currency`, `Budget`.`personnel`, `Budget`.`transport_currency`, `Budget`.`transport`, `Budget`.`field_currency`, `Budget`.`field`, `Budget`.`supplies_currency`, `Budget`.`supplies`, `Budget`.`pharmacy_currency`, `Budget`.`pharmacy`, `Budget`.`travel_currency`, `Budget`.`travel`, `Budget`.`regulatory_currency`, `Budget`.`regulatory`, `Budget`.`it_currency`, `Budget`.`it`, `Budget`.`lab_currency`, `Budget`.`lab`, `Budget`.`others_currency`, `Budget`.`others`, `Budget`.`kemri_currency`, `Budget`.`kemri`, `Budget`.`wrair_currency`, `Budget`.`wrair`, `Budget`.`subject_currency`, `Budget`.`subject`, `Budget`.`grand_currency`, `Budget`.`grand_total`, `Budget`.`study_information`, `Budget`.`personnel_kshs`, `Budget`.`transport_kshs`, `Budget`.`field_kshs`, `Budget`.`supplies_kshs`, `Budget`.`pharmacy_kshs`, `Budget`.`travel_kshs`, `Budget`.`regulatory_kshs`, `Budget`.`it_kshs`, `Budget`.`lab_kshs`, `Budget`.`others_kshs`, `Budget`.`grand_total_kshs`, `Budget`.`subject_kshs`, `Budget`.`created`, `Budget`.`modified` FROM `ctr`.`budgets` AS `Budget` WHERE `Budget`.`application_id` = (1533)	1	1	5	maybe slow
SELECT `Deviation`.`id`, `Deviation`.`application_id`, `Deviation`.`user_id`, `Deviation`.`reference_no`, `Deviation`.`study_title`, `Deviation`.`deviation_type`, `Deviation`.`deviation_type_dev`, `Deviation`.`pi_name`, `Deviation`.`deviation_date`, `Deviation`.`participant_number`, `Deviation`.`treating_physician`, `Deviation`.`deviation_description`, `Deviation`.`deviation_explanation`, `Deviation`.`deviation_measures`, `Deviation`.`deviation_preclude`, `Deviation`.`sponsor_notified`, `Deviation`.`sponsor_explanation`, `Deviation`.`study_impact`, `Deviation`.`status`, `Deviation`.`deleted`, `Deviation`.`deleted_date`, `Deviation`.`created`, `Deviation`.`modified` FROM `ctr`.`deviations` AS `Deviation` WHERE `Deviation`.`application_id` = (1533)	1	1	363	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`file`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`description`, `Document`.`year`, `Document`.`file_date`, `Document`.`pocket_name`, `Document`.`version_no`, `Document`.`created`, `Document`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Document__path` FROM `ctr`.`attachments` AS `Document` WHERE `Document`.`model` = 'Application' AND `Document`.`group` = 'document' AND `Document`.`foreign_key` = (1533)	0	0	174	maybe slow
SELECT `CoverLetter`.`id`, `CoverLetter`.`model`, `CoverLetter`.`file`, `CoverLetter`.`foreign_key`, `CoverLetter`.`dirname`, `CoverLetter`.`basename`, `CoverLetter`.`checksum`, `CoverLetter`.`alternative`, `CoverLetter`.`group`, `CoverLetter`.`description`, `CoverLetter`.`year`, `CoverLetter`.`file_date`, `CoverLetter`.`pocket_name`, `CoverLetter`.`version_no`, `CoverLetter`.`created`, `CoverLetter`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `CoverLetter__path` FROM `ctr`.`attachments` AS `CoverLetter` WHERE `CoverLetter`.`model` = 'Application' AND `CoverLetter`.`group` = 'cover_letter' AND `CoverLetter`.`foreign_key` = (1533)	0	0	88	maybe slow
SELECT `Protocol`.`id`, `Protocol`.`model`, `Protocol`.`file`, `Protocol`.`foreign_key`, `Protocol`.`dirname`, `Protocol`.`basename`, `Protocol`.`checksum`, `Protocol`.`alternative`, `Protocol`.`group`, `Protocol`.`description`, `Protocol`.`year`, `Protocol`.`file_date`, `Protocol`.`pocket_name`, `Protocol`.`version_no`, `Protocol`.`created`, `Protocol`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Protocol__path` FROM `ctr`.`attachments` AS `Protocol` WHERE `Protocol`.`model` = 'Application' AND `Protocol`.`group` = 'protocol' AND `Protocol`.`foreign_key` = (1533)	0	0	70	maybe slow
SELECT `PatientLeaflet`.`id`, `PatientLeaflet`.`model`, `PatientLeaflet`.`file`, `PatientLeaflet`.`foreign_key`, `PatientLeaflet`.`dirname`, `PatientLeaflet`.`basename`, `PatientLeaflet`.`checksum`, `PatientLeaflet`.`alternative`, `PatientLeaflet`.`group`, `PatientLeaflet`.`description`, `PatientLeaflet`.`year`, `PatientLeaflet`.`file_date`, `PatientLeaflet`.`pocket_name`, `PatientLeaflet`.`version_no`, `PatientLeaflet`.`created`, `PatientLeaflet`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `PatientLeaflet__path` FROM `ctr`.`attachments` AS `PatientLeaflet` WHERE `PatientLeaflet`.`model` = 'Application' AND `PatientLeaflet`.`group` = 'patient_leaflet' AND `PatientLeaflet`.`foreign_key` = (1533)	0	0	69	maybe slow
SELECT `Brochure`.`id`, `Brochure`.`model`, `Brochure`.`file`, `Brochure`.`foreign_key`, `Brochure`.`dirname`, `Brochure`.`basename`, `Brochure`.`checksum`, `Brochure`.`alternative`, `Brochure`.`group`, `Brochure`.`description`, `Brochure`.`year`, `Brochure`.`file_date`, `Brochure`.`pocket_name`, `Brochure`.`version_no`, `Brochure`.`created`, `Brochure`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Brochure__path` FROM `ctr`.`attachments` AS `Brochure` WHERE `Brochure`.`model` = 'Application' AND `Brochure`.`group` = 'brochure' AND `Brochure`.`foreign_key` = (1533)	0	0	70	maybe slow
SELECT `GmpCertificate`.`id`, `GmpCertificate`.`model`, `GmpCertificate`.`file`, `GmpCertificate`.`foreign_key`, `GmpCertificate`.`dirname`, `GmpCertificate`.`basename`, `GmpCertificate`.`checksum`, `GmpCertificate`.`alternative`, `GmpCertificate`.`group`, `GmpCertificate`.`description`, `GmpCertificate`.`year`, `GmpCertificate`.`file_date`, `GmpCertificate`.`pocket_name`, `GmpCertificate`.`version_no`, `GmpCertificate`.`created`, `GmpCertificate`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `GmpCertificate__path` FROM `ctr`.`attachments` AS `GmpCertificate` WHERE `GmpCertificate`.`model` = 'Application' AND `GmpCertificate`.`group` = 'gmp_certificate' AND `GmpCertificate`.`foreign_key` = (1533)	0	0	71	maybe slow
SELECT `Cv`.`id`, `Cv`.`model`, `Cv`.`file`, `Cv`.`foreign_key`, `Cv`.`dirname`, `Cv`.`basename`, `Cv`.`checksum`, `Cv`.`alternative`, `Cv`.`group`, `Cv`.`description`, `Cv`.`year`, `Cv`.`file_date`, `Cv`.`pocket_name`, `Cv`.`version_no`, `Cv`.`created`, `Cv`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Cv__path` FROM `ctr`.`attachments` AS `Cv` WHERE `Cv`.`model` = 'Application' AND `Cv`.`group` = 'cv' AND `Cv`.`foreign_key` = (1533)	0	0	71	maybe slow
SELECT `Finance`.`id`, `Finance`.`model`, `Finance`.`file`, `Finance`.`foreign_key`, `Finance`.`dirname`, `Finance`.`basename`, `Finance`.`checksum`, `Finance`.`alternative`, `Finance`.`group`, `Finance`.`description`, `Finance`.`year`, `Finance`.`file_date`, `Finance`.`pocket_name`, `Finance`.`version_no`, `Finance`.`created`, `Finance`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Finance__path` FROM `ctr`.`attachments` AS `Finance` WHERE `Finance`.`model` = 'Application' AND `Finance`.`group` = 'finance' AND `Finance`.`foreign_key` = (1533)	0	0	70	maybe slow
SELECT `Declaration`.`id`, `Declaration`.`model`, `Declaration`.`file`, `Declaration`.`foreign_key`, `Declaration`.`dirname`, `Declaration`.`basename`, `Declaration`.`checksum`, `Declaration`.`alternative`, `Declaration`.`group`, `Declaration`.`description`, `Declaration`.`year`, `Declaration`.`file_date`, `Declaration`.`pocket_name`, `Declaration`.`version_no`, `Declaration`.`created`, `Declaration`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Declaration__path` FROM `ctr`.`attachments` AS `Declaration` WHERE `Declaration`.`model` = 'Application' AND `Declaration`.`group` = 'declaration' AND `Declaration`.`foreign_key` = (1533)	0	0	71	maybe slow
SELECT `IndemnityCover`.`id`, `IndemnityCover`.`model`, `IndemnityCover`.`file`, `IndemnityCover`.`foreign_key`, `IndemnityCover`.`dirname`, `IndemnityCover`.`basename`, `IndemnityCover`.`checksum`, `IndemnityCover`.`alternative`, `IndemnityCover`.`group`, `IndemnityCover`.`description`, `IndemnityCover`.`year`, `IndemnityCover`.`file_date`, `IndemnityCover`.`pocket_name`, `IndemnityCover`.`version_no`, `IndemnityCover`.`created`, `IndemnityCover`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `IndemnityCover__path` FROM `ctr`.`attachments` AS `IndemnityCover` WHERE `IndemnityCover`.`model` = 'Application' AND `IndemnityCover`.`group` = 'indemnity_cover' AND `IndemnityCover`.`foreign_key` = (1533)	0	0	70	maybe slow
SELECT `OpinionLetter`.`id`, `OpinionLetter`.`model`, `OpinionLetter`.`file`, `OpinionLetter`.`foreign_key`, `OpinionLetter`.`dirname`, `OpinionLetter`.`basename`, `OpinionLetter`.`checksum`, `OpinionLetter`.`alternative`, `OpinionLetter`.`group`, `OpinionLetter`.`description`, `OpinionLetter`.`year`, `OpinionLetter`.`file_date`, `OpinionLetter`.`pocket_name`, `OpinionLetter`.`version_no`, `OpinionLetter`.`created`, `OpinionLetter`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `OpinionLetter__path` FROM `ctr`.`attachments` AS `OpinionLetter` WHERE `OpinionLetter`.`model` = 'Application' AND `OpinionLetter`.`group` = 'opinion_letter' AND `OpinionLetter`.`foreign_key` = (1533)	0	0	70	maybe slow
SELECT `ApprovalLetter`.`id`, `ApprovalLetter`.`model`, `ApprovalLetter`.`file`, `ApprovalLetter`.`foreign_key`, `ApprovalLetter`.`dirname`, `ApprovalLetter`.`basename`, `ApprovalLetter`.`checksum`, `ApprovalLetter`.`alternative`, `ApprovalLetter`.`group`, `ApprovalLetter`.`description`, `ApprovalLetter`.`year`, `ApprovalLetter`.`file_date`, `ApprovalLetter`.`pocket_name`, `ApprovalLetter`.`version_no`, `ApprovalLetter`.`created`, `ApprovalLetter`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `ApprovalLetter__path` FROM `ctr`.`attachments` AS `ApprovalLetter` WHERE `ApprovalLetter`.`model` = 'Application' AND `ApprovalLetter`.`group` = 'approval_letter' AND `ApprovalLetter`.`foreign_key` = (1533)	0	0	70	maybe slow
SELECT `Statement`.`id`, `Statement`.`model`, `Statement`.`file`, `Statement`.`foreign_key`, `Statement`.`dirname`, `Statement`.`basename`, `Statement`.`checksum`, `Statement`.`alternative`, `Statement`.`group`, `Statement`.`description`, `Statement`.`year`, `Statement`.`file_date`, `Statement`.`pocket_name`, `Statement`.`version_no`, `Statement`.`created`, `Statement`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Statement__path` FROM `ctr`.`attachments` AS `Statement` WHERE `Statement`.`model` = 'Application' AND `Statement`.`group` = 'statement' AND `Statement`.`foreign_key` = (1533)	0	0	70	maybe slow
SELECT `ParticipatingStudy`.`id`, `ParticipatingStudy`.`model`, `ParticipatingStudy`.`file`, `ParticipatingStudy`.`foreign_key`, `ParticipatingStudy`.`dirname`, `ParticipatingStudy`.`basename`, `ParticipatingStudy`.`checksum`, `ParticipatingStudy`.`alternative`, `ParticipatingStudy`.`group`, `ParticipatingStudy`.`description`, `ParticipatingStudy`.`year`, `ParticipatingStudy`.`file_date`, `ParticipatingStudy`.`pocket_name`, `ParticipatingStudy`.`version_no`, `ParticipatingStudy`.`created`, `ParticipatingStudy`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `ParticipatingStudy__path` FROM `ctr`.`attachments` AS `ParticipatingStudy` WHERE `ParticipatingStudy`.`model` = 'Application' AND `ParticipatingStudy`.`group` = 'participating_study' AND `ParticipatingStudy`.`foreign_key` = (1533)	0	0	68	maybe slow
SELECT `Addendum`.`id`, `Addendum`.`model`, `Addendum`.`file`, `Addendum`.`foreign_key`, `Addendum`.`dirname`, `Addendum`.`basename`, `Addendum`.`checksum`, `Addendum`.`alternative`, `Addendum`.`group`, `Addendum`.`description`, `Addendum`.`year`, `Addendum`.`file_date`, `Addendum`.`pocket_name`, `Addendum`.`version_no`, `Addendum`.`created`, `Addendum`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Addendum__path` FROM `ctr`.`attachments` AS `Addendum` WHERE `Addendum`.`model` = 'Application' AND `Addendum`.`group` = 'addendum' AND `Addendum`.`foreign_key` = (1533)	0	0	68	maybe slow
SELECT `Registration`.`id`, `Registration`.`model`, `Registration`.`file`, `Registration`.`foreign_key`, `Registration`.`dirname`, `Registration`.`basename`, `Registration`.`checksum`, `Registration`.`alternative`, `Registration`.`group`, `Registration`.`description`, `Registration`.`year`, `Registration`.`file_date`, `Registration`.`pocket_name`, `Registration`.`version_no`, `Registration`.`created`, `Registration`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Registration__path` FROM `ctr`.`attachments` AS `Registration` WHERE `Registration`.`model` = 'Application' AND `Registration`.`group` = 'registration' AND `Registration`.`foreign_key` = (1533)	0	0	75	maybe slow
SELECT `Fee`.`id`, `Fee`.`model`, `Fee`.`file`, `Fee`.`foreign_key`, `Fee`.`dirname`, `Fee`.`basename`, `Fee`.`checksum`, `Fee`.`alternative`, `Fee`.`group`, `Fee`.`description`, `Fee`.`year`, `Fee`.`file_date`, `Fee`.`pocket_name`, `Fee`.`version_no`, `Fee`.`created`, `Fee`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Fee__path` FROM `ctr`.`attachments` AS `Fee` WHERE `Fee`.`model` = 'Application' AND `Fee`.`group` = 'fee' AND `Fee`.`foreign_key` = (1533)	0	0	70	maybe slow
SELECT `Checklist`.`id`, `Checklist`.`model`, `Checklist`.`file`, `Checklist`.`foreign_key`, `Checklist`.`dirname`, `Checklist`.`basename`, `Checklist`.`checksum`, `Checklist`.`alternative`, `Checklist`.`group`, `Checklist`.`description`, `Checklist`.`year`, `Checklist`.`file_date`, `Checklist`.`pocket_name`, `Checklist`.`version_no`, `Checklist`.`created`, `Checklist`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Checklist__path` FROM `ctr`.`attachments` AS `Checklist` WHERE `Checklist`.`model` = 'Checklist' AND `Checklist`.`foreign_key` = (1533)	28	28	65	maybe slow
SELECT `StudyMonitor`.`id`, `StudyMonitor`.`user_id`, `StudyMonitor`.`application_id`, `StudyMonitor`.`amendment_id`, `StudyMonitor`.`owner_id`, `StudyMonitor`.`created`, `StudyMonitor`.`modified` FROM `ctr`.`study_monitors` AS `StudyMonitor` WHERE `StudyMonitor`.`user_id` = (1533)	0	0	1	maybe slow
SELECT `ProtocolOutsource`.`id`, `ProtocolOutsource`.`user_id`, `ProtocolOutsource`.`application_id`, `ProtocolOutsource`.`outsource_id`, `ProtocolOutsource`.`owner_id`, `ProtocolOutsource`.`created`, `ProtocolOutsource`.`modified` FROM `ctr`.`protocol_outsources` AS `ProtocolOutsource` WHERE `ProtocolOutsource`.`user_id` = (1533)	0	0	20	maybe slow
SELECT `Outsource`.`id`, `Outsource`.`application_id`, `Outsource`.`user_id`, `Outsource`.`model`, `Outsource`.`username`, `Outsource`.`name`, `Outsource`.`email`, `Outsource`.`phone_no`, `Outsource`.`institution_physical`, `Outsource`.`name_of_institution`, `Outsource`.`institution_address`, `Outsource`.`institution_contact`, `Outsource`.`county_id`, `Outsource`.`country_id`, `Outsource`.`approved`, `Outsource`.`created`, `Outsource`.`modified`, `Outsource`.`accepted`, `Outsource`.`model_sae`, `Outsource`.`model_ciom`, `Outsource`.`model_dev` FROM `ctr`.`outsources` AS `Outsource` WHERE `Outsource`.`application_id` = (1533)	0	0	1	maybe slow

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 15.81 MB

Message	Memory use
Component initialization	2.39 MB
Controller action start	3.55 MB
Controller render start	9.29 MB
View render complete	9.73 MB

Timers

Total Request Time: 4606 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	138.45
Event: Controller.initialize	3.72
Event: Controller.startup	1.66
Controller action	4307.32
Event: Controller.beforeRender	58.63
» Processing toolbar data	58.41
Rendering View	6.40
» Event: View.beforeRender	0.06
» Rendering APP/View/Applications/view.ctp	0.72
» Event: View.afterRender	0.04
» Event: View.beforeLayout	0.04
» Rendering APP/View/Layouts/default.ctp	4.70
» » Rendering APP/View/Elements/google-analytics.ctp	0.17
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- application(array)
 Application(array)
 id1533
 user_id820
 trial_status_id(null)
 abstract_of_study Server Migration
 study_title Server Migration
 laymans_summary Server Migration
 short_titleServer migration
 protocol_noECCT/25/04/07
 version_no1
 date_of_protocol29-04-2025
 study_drugServer Migration
 disease_conditionServer Migration
 product_type_biologicals1
 product_type_proteins1
 product_type_immunologicals0
 product_type_vaccines0
 product_type_hormones0
 product_type_toxoid0
 product_type_chemical0
 product_type_medical_device0
 product_type_chemical_nameServer Migration
 product_type_medical_device_nameServer Migration
 comparatorNo
 comparator_name
 comparator_registered
 comparator_countries
 ecct_not_applicable0
 ecct_ref_number
 email_addressjkiprotich@intellisoftkenya.com
 applicant_covering_letter1
 applicant_protocol1
 applicant_patient_information1
 applicant_investigators_brochure1
 applicant_investigators_cv1
 applicant_signed_declaration1
 applicant_financial_declaration1
 applicant_gmp_certificate1
 applicant_indemnity_cover1
 applicant_opinion_letter1
 applicant_approval_letter1
 applicant_statement1
 applicant_participating_countries(null)
 applicant_addendum1
 applicant_fees1
 applicant_complete_form(null)
 applicant_impd1
 applicant_prev_data1
 applicant_stability_data1
 applicant_analysis_cert1
 applicant_pictorial_sample1
 applicant_gcp_training1
 applicant_dsmb_charter1
 applicant_detailed_budget1
 applicant_indemnity_pi1
 applicant_practice_license1
 applicant_registration_ctr(null)
 applicant_pan_african1
 applicant_hard_copies(null)
 applicant_signed_checklist1
 statistical_analysis_plan1
 applicant_contractual_agreement1
 declaration_applicantserver migration
 declaration_date129-04-2025
 declaration_principal_investigatorserver migration
 declaration_date229-04-2025
 placebo_presentNo
 study_objectives Server Migration
 principal_inclusion_criteria Server Migration
 principal_exclusion_criteria Server Migration
 primary_end_points Server Migration
 scope_diagnosis1
 scope_prophylaxis1
 scope_therapy0
 scope_safety0
 scope_efficacy0
 scope_pharmacokinetic0
 scope_pharmacodynamic0
 scope_bioequivalence0
 scope_dose_response0
 scope_pharmacogenetic0
 scope_pharmacogenomic0
 scope_pharmacoecomomic0
 scope_others0
 scope_others_specify
 trial_human_pharmacology1
 trial_administration_humans1
 trial_bioequivalence_study0
 trial_other0
 trial_other_specify
 trial_therapeutic_exploratory0
 trial_therapeutic_confirmatory1
 trial_therapeutic_use0
 design_controlledYes
 site_capacity(null)
 staff_numbers Server Migration
 other_details_explanation Server Migration
 other_details_regulatory_notapproved Server Migration
 other_details_regulatory_approved Server Migration
 other_details_regulatory_rejected Server Migration
 other_details_regulatory_halted Server Migration
 estimated_duration12
 design_controlled_randomisedYes
 design_controlled_openNo
 design_controlled_single_blindYes
 design_controlled_double_blindNo
 design_controlled_parallel_groupYes
 design_controlled_cross_overNo
 design_controlled_otherNo
 design_controlled_specify
 design_controlled_comparatorServer Migration
 design_controlled_other_medicinalYes
 design_controlled_placeboNo
 design_controlled_medicinal_otherNo
 design_controlled_medicinal_specify
 single_site_member_stateYes
 location_of_areaServer Migration
 single_site_physical_addressServer Migration
 single_site_contact_personServer Migration
 single_site_telephoneServer Migration
 multiple_sites_member_stateNo
 multiple_countriesNo
 multiple_member_states
 number_of_sites
 multi_country_list
 data_monitoring_committeeNo
 total_enrolment_per_site500
 total_participants_worldwide10000
 population_less_than_18_yearsYes
 population_uteroNo
 population_preterm_newbornNo
 population_newbornNo
 population_infant_and_toddlerNo
 population_childrenNo
 population_adolescentNo
 population_above_18No
 population_adultNo
 population_elderlyNo
 gender_female1
 gender_male1
 subjects_healthyYes
 subjects_patientsNo
 subjects_vulnerable_populationsYes
 subjects_women_child_bearingYes
 subjects_women_using_contraceptionYes
 subjects_pregnant_womenYes
 subjects_nursing_womenNo
 subjects_emergency_situationNo
 subjects_incapable_consentNo
 subjects_specify
 subjects_othersNo
 subjects_others_specify
 investigator1_given_nameServer Migration
 investigator1_middle_name
 investigator1_family_nameServer Migration
 investigator1_qualificationServer Migration
 investigator1_professional_addressServer Migration
 investigator1_telephone0724743788
 investigator1_emailjkiprotich@intellisoftkenya.co.ke
 organisations_transferred_No
 number_participants20
 notification
 approval_date30-04-2025
 submitted1
 deleted0
 deleted_date(null)
 deactivated0
 date_submitted29-04-2025
 is_child0
 unsubmitted1
 initial_date_submitted29-04-2025
 admin_stopped0
 admin_stopped_reason(null)
 approved2
 approved_reasonServer Migration
 final_report(null)
 implication_results(null)
 quantity_imported(null)
 quantity_dispensed(null)
 quantity_destroyed(null)
 quantity_exported(null)
 balance_site(null)
 final_date(null)
 modified2025-04-30 14:39:51
 created2025-04-28 20:07:09
 total_sites2
 ecitizen_invoice368738
 User(array)
 id820
 usernamejkiprotich
 password547f0111bc877d5579f28409dcb3dafc5439c785
 confirm_password547f0111bc877d5579f28409dcb3dafc5439c785
 nameJapheth Kiprotich
 emailjkiprotich@intellisoftkenya.com
 national_id_number(null)
 sponsor(null)
 sponsor_emailjkiprotich@intellisoftkenya.com
 qualificationPatient
 phone_no254724743788
 name_of_institution
 institution_physical
 institution_address
 institution_contact
 county_id47
 country_id115
 group_id5
 activation_key7c486921853cad0dffc9d5e895c4972323c729c8
 forgot_password(null)
 is_active1
 deactivated0
 created2023-03-15 20:00:37
 modified2023-03-15 20:00:37
 TrialStatus(array)
 id(null)
 value(null)
 name(null)
 created(null)
 modified(null)
 Review(array)
 0(array)
 id3939
 user_id734
 application_id1533
 typerequest
 assessment_type(null)
 titlePPB request
 textServer Migration
 summary(null)
 recommendationServer Migration
 notified0
 acceptedaccepted
 conflictNo
 statusUnsubmitted
 created2025-04-29 12:12:31
 modified2025-04-29 12:13:41
 1(array)
 id3940
 user_id734
 application_id1533
 typereviewer_comment
 assessment_typeclinical
 title(null)
 text(null)
 summaryTrial category comments Server Migration Trial phase comments (if in disagreement with the study phase proposed): Server Migration Assessorâ€™s discussion on the clinical development: Server Migration Clinical Trial Rationale comments Server Migration Primary objectives comments Server Migration Secondary objectives comments Server Migration Study population comments Server Migration Inclusion criteria comments Server Migration Exclusion criteria comments Server Migration Vulnerable populations comments Server Migration Study plan and design comments Server Migration Study treatment comments Server Migration Comparator IMP(s) comments Server Migration Placebo comments Server Migration Auxilliary medicinal product(s) comments Server Migration Additional considerations comments Server Migration Safety comments Server Migration Blinding and unblinding comments Server Migration Contraception measures comments Server Migration Discontinuation criteria comments Server Migration Other concomitant comments Server Migration Safety and Monitoring comments Server Migration Reference Safety Information comments Server Migration Data Safety Monitoring Committee comments Server Migration Definition of the end of the trial comments Server Migration Biological samples used in the study comments Server Migration Data protection comments Server Migration Recruitment and informed consent procedures comment Server Migration Comments on the benefit/risk: Server Migration Overall comment/ conclusion on the clinical assessment: Server Migration 1.5.1 REQUESTS FOR ADDITIONAL INFORMATION Server Migration
 recommendationServer Migration
 notified0
 accepted(null)
 conflict(null)
 statusSummary
 created2025-04-29 12:13:55
 modified2025-04-29 12:17:15
 2(array)
 id3944
 user_id96
 application_id1533
 typeppb_comment
 assessment_type(null)
 title(null)
 text Server Migration
 summary(null)
 recommendation Server Migration
 notified0
 accepted(null)
 conflict(null)
 statusUnsubmitted
 created2025-04-30 14:39:29
 modified2025-04-30 14:39:29
 ActiveInspector(empty)
 ManagerReview(array)
 0(array)
 id3939
 user_id734
 application_id1533
 typerequest
 assessment_type(null)
 titlePPB request
 textServer Migration
 summary(null)
 recommendationServer Migration
 notified0
 acceptedaccepted
 conflictNo
 statusUnsubmitted
 created2025-04-29 12:12:31
 modified2025-04-29 12:13:41
 1(array)
 id3940
 user_id734
 application_id1533
 typereviewer_comment
 assessment_typeclinical
 title(null)
 text(null)
 summaryTrial category comments Server Migration Trial phase comments (if in disagreement with the study phase proposed): Server Migration Assessorâ€™s discussion on the clinical development: Server Migration Clinical Trial Rationale comments Server Migration Primary objectives comments Server Migration Secondary objectives comments Server Migration Study population comments Server Migration Inclusion criteria comments Server Migration Exclusion criteria comments Server Migration Vulnerable populations comments Server Migration Study plan and design comments Server Migration Study treatment comments Server Migration Comparator IMP(s) comments Server Migration Placebo comments Server Migration Auxilliary medicinal product(s) comments Server Migration Additional considerations comments Server Migration Safety comments Server Migration Blinding and unblinding comments Server Migration Contraception measures comments Server Migration Discontinuation criteria comments Server Migration Other concomitant comments Server Migration Safety and Monitoring comments Server Migration Reference Safety Information comments Server Migration Data Safety Monitoring Committee comments Server Migration Definition of the end of the trial comments Server Migration Biological samples used in the study comments Server Migration Data protection comments Server Migration Recruitment and informed consent procedures comment Server Migration Comments on the benefit/risk: Server Migration Overall comment/ conclusion on the clinical assessment: Server Migration 1.5.1 REQUESTS FOR ADDITIONAL INFORMATION Server Migration
 recommendationServer Migration
 notified0
 accepted(null)
 conflict(null)
 statusSummary
 created2025-04-29 12:13:55
 modified2025-04-29 12:17:15
 2(array)
 id3944
 user_id96
 application_id1533
 typeppb_comment
 assessment_type(null)
 title(null)
 text Server Migration
 summary(null)
 recommendation Server Migration
 notified0
 accepted(null)
 conflict(null)
 statusUnsubmitted
 created2025-04-30 14:39:29
 modified2025-04-30 14:39:29
 Acceptance(empty)
 Amendment(empty)
 InvestigatorContact(array)
 0(array)
 id1250
 application_id1533
 given_nameServer Migration
 middle_name
 family_nameServer Migration
 qualificationServer Migration
 professional_addressServer Migration
 telephone0724743788
 emailjkiprotich@intellisoftkenya.com
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 ApplicationStage(array)
 0(array)
 id4300
 application_id1533
 stageScreening
 start_date2025-04-29
 statusComplete
 commentManager first comment
 end_date2025-04-29
 created2025-04-29 12:08:41
 modified2025-04-29 12:08:41
 1(array)
 id4301
 application_id1533
 stageScreeningSubmission
 start_date2025-04-29
 statusComplete
 commentManager assign reviewer
 end_date2025-04-29
 created2025-04-29 12:12:13
 modified2025-04-29 12:12:13
 2(array)
 id4302
 application_id1533
 stageAssign
 start_date2025-04-29
 statusComplete
 commentReviewer accept
 end_date2025-04-29
 created2025-04-29 12:12:31
 modified2025-04-29 12:12:31
 3(array)
 id4303
 application_id1533
 stageReview
 start_date2025-04-29
 statusComplete
 commentManager review comment
 end_date2025-04-30
 created2025-04-29 12:13:41
 modified2025-04-29 12:13:41
 4(array)
 id4306
 application_id1533
 stageUnsubmitted
 start_date2025-04-29
 statusComplete
 commentPrincipal Investigator Re Submission
 end_date2025-04-30
 created2025-04-29 13:27:18
 modified2025-04-29 13:27:18
 5(array)
 id4309
 application_id1533
 stageReviewSubmission
 start_date2025-04-30
 statusComplete
 commentManager final decision
 end_date2025-04-30
 created2025-04-30 14:39:29
 modified2025-04-30 14:39:29
 6(array)
 id4310
 application_id1533
 stageFinalDecision
 start_date2025-04-30
 statusComplete
 commentManager final decision
 end_date2025-04-30
 created2025-04-30 14:40:00
 modified2025-04-30 14:40:00
 7(array)
 id4311
 application_id1533
 stageAnnualApproval
 start_date2025-04-30
 statusCurrent
 commentManager approve
 end_date2026-04-30
 created2025-04-30 14:40:00
 modified2025-04-30 14:40:00
 Pharmacist(array)
 0(array)
 id722
 application_id1533
 reg_no1
 given_nameServer Migration
 premise_nameServer Migration
 qualificationServer Migration
 professional_addressServer Migration
 valid_year3020
 mobile0724743788
 telephone0724743788
 emailjkiprotich@intellisoftkenya.com
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 EthicalCommittee(array)
 0(array)
 id746
 application_id1533
 ethical_committeeAfrica International University
 submission_date29-04-2025
 erc_number1
 initial_approval29-04-2025
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 AnnualLetter(array)
 0(array)
 id1297
 application_id1533
 approval_noPPB/ECCT/25/04/07/2025(92)
 content<h3 style="text-align: center;"> <img height="86" src="https://lh7-us.googleusercontent.com/eOWVvo3AHW74GguHveDaqdgy3YwNZqOqOO0QtscRoV4hJfcvt8Q6v4oLN3beVNvClvoD1ncu1RhB5D4iuAY-5R9h1aD2lEGqUorBVcQ0azfxsdvIz-WhbF3rA9-VQomtusnP2bNZTuYLFTC6vQ46nQ" style="background-color: transparent; color: rgb(0, 0, 0); font-family: "Bookman Old Style", serif; font-size: 11pt; white-space-collapse: preserve; margin-left: 0px; margin-top: 0px;" width="116" /></h3> MINISTRY OF HEALTH PHARMACY AND POISONS BOARD <table style="width: 100%; border:0px"> <tbody> <tr> <td style="width: 33.33%; border:0px"> <div id="left-editor"> Telegram: "MINHEALTH", Nairobi Cell phone: 0709 770 100 Email: info@pharmacyboardkenya.org Website: web.pharmacyboardkenya.org </div> </td> <td style="width: 33.33%;border:0px"> </td> <td style="width: 33.33%;border:0px"> <div id="right-editor"> Pharmacy and Poisons Board House Along Lenana Road P.O. Box 27663-00506 NAIROBI </div> </td> </tr> </tbody> </table> <address> </address> <address> When replying please quote</address> Ref. No. PPB/ECCT/25/04/07/2025(92) 30th April 2025 Server Migration Server Migration Server Migration, Principal Investigator ECCT/25/04/07, Server Migration, 0724743788. Dear Sir/Madam, Re: ECCT/25/04/07 : Initial Approval; Server migration. Reference is made to the above study. We acknowledge receipt of the following documents; <div style="margin-left: 15px;"> 1. The Study Protocol <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99459">hello.png</a> dated 29th April 2025 Version 1 2. Cover Letter (Should list all the submitted documents, their version numbers and dates) <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99460">hello_2.png</a> dated 29th April 2025 Version 1 3. Registration of the study at Pan African Clinical Trials Registry https://pactr.samrc.ac.za <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99461">hello_3.png</a> dated 29th April 2025 Version 1 4. Signed Checklist <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99462">hello_4.png</a> dated 29th April 2025 Version 1 5. Patient Information leaflet and Informed consent form <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99463">hello_5.png</a> dated 29th April 2025 Version 1 6. Investigators Brochure/Package inserts <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99464">hello_6.png</a> dated 22nd April 2025 Version 1 7. Investigational Medicinal Product Dossier (IMPD) <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99465">hello_7.png</a> dated 29th April 2025 Version 1 8. Adequate data and information from previous studies and Phases to support carrying out of the current study <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99466">hello_8.png</a> dated 29th April 2025 Version 1 9. Stability data of the investigational product <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99467">hello_9.png</a> dated 29th April 2025 Version 1 10. GMP certificate of the investigational product from the site of manufacture <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99468">hello_10.png</a> dated 29th April 2025 Version 1 11. Evidence of recent GCP training of the core study staff <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99469">hello_11.png</a> dated 29th April 2025 Version 1 12. DSMB Charter including the composition and meeting schedule <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99470">hello_12.png</a> dated 29th April 2025 Version 1 13. Evidence of contractual agreement between sponsor and Principal Investigator. <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99471">hello_13.png</a> dated 29th April 2025 Version 1 14. Signed investigator(s) CV(s) including that of study Pharmacist (NB: The CV should include the current workload of the Principal Investigator ) <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99472">hello_14.png</a> dated 29th April 2025 Version 1 15. Pictorial Sample of the investigational products. This sample should include the text of the labeling to be used <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99473">hello_15.png</a> dated 29th April 2025 Version 1 16. Detailed budget of the study <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99474">hello_16.png</a> dated 29th April 2025 Version 1 17. Signed Declaration by Sponsor or Principal investigator that the study will be carried out according to the protocol and applicable laws, regulations and GCP requirements. <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99475">hello_17.png</a> dated 29th April 2025 Version 1 18. Financial declaration by Sponsor and/or PI <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99476">hello_18.png</a> dated 29th April 2025 Version 1 19. Indemnity cover for PI, investigators and study Pharmacist. <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99477">hello_19.png</a> dated 29th April 2025 Version 1 20. Copy of favorable opinion letter from the local Ethics Review Committee (ERC). <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99478">hello_20.png</a> dated 29th April 2025 Version 1 21. Clinical Trials Insurance cover for study participants <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99479">hello_21.png</a> dated 29th April 2025 Version 1 22. Copy of current Practice Licenses for the Investigators and study Pharmacist <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99480">hello_22.png</a> dated 29th April 2025 Version 1 23. Copy of approval letter(s) from collaborating institutions or other regulatory authorities, if applicable <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99481">hello_23.png</a> dated 29th April 2025 Version 1 24. Statistical Analysis Plan <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99482">hello_24.png</a> dated 29th April 2025 Version 1 25. Payment of fees <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99483">hello_25.png</a> dated 29th April 2025 Version 1 26. A signed statement by the applicant indicating that all information contained in, or referenced by, the application is complete and accurate and is not false or misleading. <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99484">hello_26.png</a> dated 29th April 2025 Version 1 27. For multicentre/multi-site studies, a site specific addendum for each of the proposed sites including among other things the sitesâ€™ capacity to carry out the study i.e personnel, equipment, laboratory etc <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99485">hello_27.png</a> dated 29th April 2025 Version 1 28. Certificate of Analysis of the investigational product <a href="https://ctr.pharmacyboardkenya.org/attachments/download/99486">hello_28.png</a> dated 29th April 2025 Version 1 </div> After review of the documents, the Pharmacy and Poisons Board Expert Committee on Clinical Trials grants approval to the study Server migration. (ECCT/25/04/07). This approval is valid for one year and in case the study extends beyond one year from the date of this letter, you are required to seek approval before proceeding with the study. The expiry date is 30th April 2026. <ol> <li> All safety reports should be submitted to ECCT as per the current PPB clinical trials guidelines.</li> <li> Take note that it is your responsibility to inform the PPB of any changes to the protocol, research design and procedures that could introduce new or more than minimum risk to human subjects.</li> <li> The Pharmacy and Poisons Board requires you to provide regular updates and Quarterly reports, especially on Suspected Unexpected Serious Adverse Reactions (SUSARS) from the study, for monitoring purposes and involve the PPB where necessary.</li> <li> You are also reminded that upon conclusion of the study, you shall be required to submit the executive summary report of the study within 30 days while a copy of the clinical study report in ICH E3 format should be submitted to us within 180 days of the study closure.</li> </ol> Yours Sincerely, <img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFwAAAAyCAYAAADREbxyAAAAAXNSR0IArs4c6QAAAHhlWElmTU0AKgAAAAgABAEaAAUAAAABAAAAPgEbAAUAAAABAAAARgEoAAMAAAABAAIAAIdpAAQAAAABAAAATgAAAAAAAACQAAAAAQAAAJAAAAABAAOgAQADAAAAAQABAACgAgAEAAAAAQAAAFygAwAEAAAAAQAAADIAAAAAlYe4kgAAAAlwSFlzAAAWJQAAFiUBSVIk8AAAE/xJREFUeAHtWmmQXNV1/l7v6yw9PfsqjTQjjcRYEohFAgTCYAjIiJSCDIlNkZTLUI5dldhJuShXOWUTVxawjTEOIVW2wcEQIhJJLEYqA0GjBSnaRmJG24xmYxbN3t3Te/d7+c590wIJY/xDPRapuVJ3v+W+d+/9zjnfWe5oBhvm25whYJmzkeYHUgjMAz7HijAP+Dzgc4zAHA83r+HzgM8xAnM83LyGzwP++yFgJg86O2fPP6BSiss8rfgUarhALSBn+S8BAxpGJmJ47e1e6DwzkMHljPmnEHCNoFqgGRZYdBf0rI63dk1j+ysxjI3EoGlW8OZ5rb/cDj6FgAM68cwaGWgWA+fGknj2uSOorHCjpMzD65cv2CJ82+WmAZ88HwNW0WDNhhP9EfzTD99DSsvgob+ohmZNK7bRrI5Pfs0fqMccAi4OTuhA+NfKIw3JDODkDIR7YRIFf3lGujA0TV1T34Ivz9QlHkWiGezYNYQ33uzH8VMZrLuuDBUldmQMHRZq/e/TZB6KeUhB6pg0Jf5AxslnmxPAxZWJpWtIk3Pp1ixWvLJzBDvfOo0F9UX45ldbaWpmxKGzlyHAsb9Owkvz3Mp7NiKRTFrx/Msn8eaeYVRXFuMrX1qGH//kCL7y4CpiREGyj+J3OfiYJnMRsesczuA8FKdycvKEMcv9+YR9jjicS+SKNAKn09y3vd6Nl148hmuW12GiF3j2hWO8J5qmUCA3K9hhzVrgJCRW0sfbByfwje/vxbadPVi/dhEe+fpyfKY1gJHwOVSViZmIwGQ5v1vDBXCIQKnZ//LzPRgYjqhjhTifznebEw0X7bHQ0xmaEzv2DGD762fw3UfWYXGjA/2DGfzqpVM4cmIKK5cWct1iDTYkqXVT4TT2HzqHra+eRiSWwOf/qBXfejiIilInbFYNb7T1I+jxwyk4WygYBTh5SoH+MVou8iA3pWkQJ064sP56C8Ws8Un5/phn+MilanMCuDlZjdo0g5/+tA0P3L8WS5rcSHHxVbXAiqWVeGvngAJ8IhrDyGgGu/dN4sUtB1ASLML996zCZ68PwuciMHbaiSZ+gFr/zlEEyl2wWC2Kv20iLJPoPxYfE1JGN6NZGCk3nE4hrAwB5x36jnxjnnfAlQnPAtF1No766jr8yV0NDN+ScIhGahasuqoER9qjeOmVYZw8OYGzZ88hGHThkb++G1e3ulFYKAxNwmEoqNjWkFgbGDgbxaKWgOlMxdEKJclYFKSmMWKhpZhU9oHm5o7aj43C7dFR4Oe71ANiJvlveQTchJrrV+Bk6SyHxiLU7FJl+CC9SDvUOY03ftNFbh5D4WE7NqyvwiN/cz2aFrp5V+hBeN1KHidUmoR78kL5AImMDTUVQWJPMQiS5GY1GG9L5KMuqd8czOptHN+GM10TqKhywe+20iHLfRLKB914np+WN8DpHrkw0RrROAM2hh0FhR7YbQ50j8TxH1uOYaifAFhcKK1w4t6NDViwpBSbbg/yGUYzOhMbBQC5lVaggFQY8KKptrDbnaipoYbLdQHbsPMgya4WWgSPST22WWtQj/JL40szFEjPQAK331EFt4uWwfnNBdgyh7wBbgIksKcYb9sRjgDtnVHs+PUhXHWgFGkS+OqVNbie3Fxb6UJ/zzTe3hPG6GQapQER1WxcrPg6B1fuVzSceq3b4PcLyCKQDEHmR1mDcLxos4hCiUOdy5c4xkFGJmd6x7DJV3f+ugn6hX3P37yEB3kEXEChpulOPP30QUYbEeipALwFbnztyytRGbDSYTEYtJE2CGpx0IvJ0BAmJyIoC3hNDBl3SJJ0MWhiNXLNILgelyxBztmPuB86EsLiRX4EfHSuwuH8d3H0MTQ4gVgqgiIfH5ttovlz0UQ18tPElGWx1gxuv3MZvv231+GhBxtg1yKMLrrg8VmRtQnTMuXRNQSL7YjGxzE+McPnnLwufG2+Q0ATSHMfYWppOmkkq+JvajTxyqY1bN3WwQgkziySvC+deF09LY5RvQEcI0waK0QwYCIumWaW9iDOU7pJf5mZfNSz8h4e5Z5Xpxd9fdDvohsXneZNwy1KYeieDAeWLhSzZ2vxwOa7Fs/8fC8+d0cDaoJ0nATMogmEDjitbmaY0peCkgpVrn2o+ieHQuHSXKwLSFJkmoOO9mOTiMXK4HNTYJzA0EiUFBXGqpZKCkfiHEmigJmwhspSP4Xs4rMUlsLShNlMwHJjC7fLgKbgVUepRrJJb212IjmwJVO92JpU5w995U/Dc4OIhnFioo0GF73mmjKsYab4xE+OIRRi6MZJ6lxELJlG6xW1qKkuUIvJynO8Z65JEFaosC/1kcUq1Vxm/USpMfX57JkUeroHKOQ4EsksXvvNELrPhEXJlbO0iMOkxzw7ksUJhp9vvjWI6RipiR2kuiO/Uk6QB4RhhGayQos8ZuXF9AlcA+QjEZTMg8qS6/tJYMuc8w+4zF9N3iQCGzXvC3cvwdD7Ibx1eFLdFDNOc+6tq4oYqrkVtPIMb3JxMkXRIQGfH/a1ZE3DTKdSVD5xzAIAwdQY8ZT5VUUsHNcRCzsp4EW8J3QhkGXpMzTYvDpaW4uRSNvxw6f2YTwsIwhckv7MaqkpXyoKx2TEpKyQeYC8y9xZon+ghFQ3vluUSd7ySS1vlHLhwLIImqICMY1AkQP3bm7E8y914ooGP+rqnHDZssqJpWJpJGn3afK6LrSiVELgZqMUpPgl0MTSBtJRA4N9OnanUxgZHEfb0QmMTqXx6o4pJFmHOXR0FP4AywBaAoloCA2NDbQQOzoPJVDGDLWyoRjjM014/LEOfPXrzZwhB2P4auOPUI+MIxZlI0oagRclsNkZP7GPnfUeVSjjRXnOVJALV/3bzvgekaEpKbW2XC9ZIQcztUuQ4vDqmnQwr8s181hCOPOmXLm4SdyboXLE4llMTUVZF0kilNLwgx+0Izw6ho2bmhFOQWWZGq+TDRCajGE6kmEpNo5sNo5MWofd6YXb7aCWAlFq1Hj/DBYvKIHX40EqmsYMn4tOR1Bf4eX7NMR5raYmiNMnx5BKRlBAQQcrvRikdXmdTlSUlSCeSmJskgJJh1FcXESwM5xrEk67g9rNeWeT8Lht8Lrd8PmcaKgtgd2ho6a2GEUFLrgcEinZ4fXaeB/sa1H9fR4nf+2w5/RsFhSNCQZfK/w0m2Ao0hTzEGFLb3E20igU8rCFRSIzelAXL/iSfpEYMDzKeHo8hlAkRYBTmJzWMcFPb/c4entHmXGGaf4ZFPqKEJueIbBJ3HjzcnhID0WceFkpkxmLFK4y0ONJLF5qYzSSQVdXCk2NFVizhs7OYcHTz3Rg86aV+OyNAQz1zSDEsfft7cbdG5ux590ZtLQUosCdwc+eGYHDlWHdJosHHlyGn3GHKFjowC1rlzIJMjA8FsOeveMoKrbQmdqQyqRIIRbMRJMsoCUQCaUU96dY8QolMoxykkgxIorHM0iR1uSTSabI/0zW7DpKSrwMFKoobC9KSx2ooZA9Liuqq4vpX5Sp0zgUH1FPqaJiSqLNYk6yRyjn0uR4OswJjodU8tDXO8HJJpnUJBBLyG+GsXQSM/zVdEqeEi6tKEBVdRGoHFhzZQBf2LCAmkAtdeko9rsxysX+3aO7sXlDFTbduUAGVyzy1L+fxNWr7Xhg8wrUVRs4yd2dbdtJFeOj2LxxtZrPttdOYPkyOxbVaRgfj6pgsrDYA5dfx4nu03z2BuzaP4hAZSFBiKOyOobyUjBGNzgvG5a0iPJksAR+KkoUgaCOm66uUu/+XV+JhFgrlStCy0tlKSADcVptjAKYCicxSoEkEkywWMro65nBboa7oyNTsEoZwaAGi+lYJX2e5SlVOSMpyb8wM8ITp0No23sGB9v7MU1NjcW4icCB9JSOQHEQZZRoAc2xtcWP6jIrykvcKArQBP1Omp2TvxrTcCuTbVNwH15MS7MLm+5rwpZtB/H5OxaAioD9h8fx31tP4d8eu0WBLVLYt59z2D2Ae++qxI62bnzuhkapyCITF15nuGd1oriAVcP0ME53TpFCUlSQFAYYkVRUOailIZaIWXMnOMmom+7To6ZhPkuDcaQxOhzltSqKQHJUmauZq6qwUIWuophWuFwGP1muXeo9uZbLoj5YYyKh0woMzJDrwqE4RsaisGVSae7A2Im1aDMBpsc+2xtH19lJvL33NPppqtEEaxtaFNdd24z1N9SittyJqgoLudMGj9PBj5UT1jgJug8C9tEmUQL/02KEduRbSExiMAudz8YNzdj77hC2vt5FC1iEF155j5FMMxY0eDAV1fFf23vwwpZOrFq1EGtvrMSru0KsLnbhTI8Fv3hxELt2d+O2uxpRQF5OMJLoGzRQU1qCRIqqqBMYlgoi49ToJeWIkxKSBEKiIinLijlJdCLO0i3SZrMSC9XEwoVW1aSlozCA0K2ASsuXUFc6qkhK1sc1iaLynF1nBaPRNzCJq3VgGXywPfqjvYxdXZihjThsdkrEQpNIIRbVUFcexPVXLaPp2VFbA2oQvRURlT1aH4s+Ukm2MroQt64z3EvyTxYctBSWp2UW8sUmk+OHE1Vaw8tSJ5GpMhDhqlnxC9jw8J8vxRNPHkRDfTGOdg7hj+9qwZO/fA/vHnof16xoxMrPLMatt5TDyff3d5Ieqgrgt7nR0dGFpY0tGO22o3W9C9GQDx0nh/HAvUtYenWD/o1YcjQ9RGqrwrlzUdQ32jAxksb0pEZLBDlYgCpGbR1/2cyaujlvBbBYv2qzAuDcJSHSVWgia5O18lnysYAt50LHKqiXPiII6cJ7NqdboyPyIRW3I0nyd9I07bYAEvE0o4Msxob6WcqMMUxLUYttaiB5WowtHJlh8cjFHZhC1qxdKA54UOi3UKPIo9T4Apq4g87NTY9d6LWzWkjP7RSvIQGVXfSKk5GFgU6mEmkC+L3H/peONYbH/7UNa1Y04O+/dSsaKuy4edPz2HjP7QzjNExMRlnpK+QmRZy+YxyLmwoxPcpiAEswsVgGsSkDHo8Bn8eOlVf6cfJMhPX1AI69N4F39xzHN79xG77/D/txoqsAa68Oovf9CIbfj+KG1SR4NlEIs/0Wc1XTlS9lF7P95Jx9zaWoe0q5cq+R95mPwPbtr908+9BHf0QojMoIPhg+KUUWmqcgdDrNSUYeMaQSVowzKpkKxxCeDmOgJ8b42UKuT7JKaHBXh+Gch+EYi1bBMi8qy+38GxICT053k4rSfNfoFCMYZolFhQXY8877FK6Bxx69B4vLzBkffW+S1OKlL/Cgu30QCW2SStLC90YQG0ohWOJER+cgqzJN1OYw7r9vOQZ7pnC8gmyc0bHuxhIMDc2grW0cGzZeR+s0uHntxju7x3jMPda2ESylNRf6zPBWgfVROC7JFdbqmH3RFEzzuPCdYvg+WoB8lMmcl7wFtVVSt8616tyB+hWWCzGUSsStpKoUaxcRTM8w7e6LY+87MzjaIXuU4ygPct+SEc25KQ9Wry7DF0kDesyNvl4dT/3oMJZxt8fjdDGW9eGaxVUYGszieE8XrlhejwLy7YrWKgI9SQEnGD0NcdQm/NkXF2LRYhd6TxVg8FwC1UE3wzIn6isdaF7gRwmrlGKfmxn7P/9CH5549ghWrajBrbf5yehCe6zPXLCaS3vCOFynL2OMLVtSCtDccOLaqM7EWkJGacJwciSaP0tKvCBn1ETVVb4kxtEwRZ/w+mu9jGU9aFlaCy+1p+2dHoyNZbCgsQDNTVaaPEMqSqfjpIGOs8OkrmEcZbZoZZjGSBiNC6txz631eOBPg3hl+ynsORrGXz7UxPDPiYW1TrSfiuLhv/o1nv7xTdjf1omHv7zOnBlrKZrBPVNapZ3anKWV2aRIwqXpRpprFVANCj2D/rE4Glg19Pq5faczjhK+nqU59bJL/MWwkJUIBeos0Cr8MQE2awsccRblD+ZhOkDT9My+wsrSTwmJmmIn9hYuoKc7gvYjx7kZXI4VV5bjjjs1hpEOCoAx6eyrVywT6ipBd28D/vHJdrWT42Dp9tjxPrz2P8MormzGoisqCZgTzfV+pupMxrQkljV5KZRSBEoC+NJ91yJDP6OxBp4BEyMmTg7W22UXVELeLP8qS/4awMLUXhRInLaPVLesnhkld5iSrGqKVzFXc4lR/tDrmNrnYqAPXb0Uh+RhWZSk9D09cRw+OoUDh6a4CyaZa5xhZRANdUX8eLn7Axzp6MPLr3aijjz/ve+sQzX/VnAyZOAgKWPLtv3MWDNM42tx83W1WL6kgEUqO1wMKb/7eAeuuqoed6wrJKD8a1qlvSLKy7PlDXBFSFJBozlbpDhObe8bSuNA+xD27RljIiKRhB0VFSWw2Kzo6e/FWlb2bltfRmsw43SGxrRu0/L6z+nY/kYHi1RRxstFaGxkonWFDQcOpxgaDuCfv3MNBWnSoiqUXZ540wLzpOFipmrhkgQIFMRcNrxyNCQbNRLCpZjJZhhJFPq5AeFWNkHOFY41e0rpVdV0yFjiKyRTPHV2AvuPxbDl5X3kckYkIyP4z+dukcVQw00GzH1fbrjnz/aYoSl46ROEXGySEBBEiSt1C30Atd7nk+GpxrzOXJbQSpOtMbOvmZmaSZKALc5PiL+pqQSLFpUw8tDw3K8GWLuZMd+i/A85TG3PqZdddl/5A5wgGqwICugCooBnUVrPIVnTUJcFDoIokDOl4q8Z4YhABGCBXUJWg07PYMqu/uCTgpPCv5Xu8Ka1lUy6irB1Z5d6h/zVrfm3KzLm5dnyRilzuVz5IyOr7Bh8Ctr/C8A/BTifn6JY7XybQwTmAZ9DsGWoecDnAZ9jBOZ4uP8DQJlV+8kWec0AAAAASUVORK5CYII=" /> Dr. Samuel Kerama For Chief Executive Officer 
 approverGedion Murimi
 qrcodePD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZlcnNpb249IjEuMSIgd2lkdGg9IjE1MCIgaGVpZ2h0PSIxNTAiIHZpZXdCb3g9IjAgMCAxNTAgMTUwIj48cmVjdCB4PSIwIiB5PSIwIiB3aWR0aD0iMTUwIiBoZWlnaHQ9IjE1MCIgZmlsbD0iI2ZmZmZmZiIvPjxnIHRyYW5zZm9ybT0ic2NhbGUoNC41NDUpIj48ZyB0cmFuc2Zvcm09InRyYW5zbGF0ZSgwLDApIj48cGF0aCBmaWxsLXJ1bGU9ImV2ZW5vZGQiIGQ9Ik0xMCAwTDEwIDFMOSAxTDkgMkw4IDJMOCA4TDkgOEw5IDRMMTIgNEwxMiA1TDEwIDVMMTAgOEwxMSA4TDExIDEwTDEwIDEwTDEwIDlMOSA5TDkgMTBMOCAxMEw4IDlMNyA5TDcgOEwyIDhMMiA5TDEgOUwxIDhMMCA4TDAgOUwxIDlMMSAxMEwwIDEwTDAgMTJMMSAxMkwxIDExTDIgMTFMMiAxMkwzIDEyTDMgMTRMMiAxNEwyIDEzTDAgMTNMMCAxNEwxIDE0TDEgMTVMMCAxNUwwIDE3TDMgMTdMMyAxOEwyIDE4TDIgMjBMMyAyMEwzIDIxTDIgMjFMMiAyMkwzIDIyTDMgMjNMMiAyM0wyIDI1TDUgMjVMNSAyNEw2IDI0TDYgMjVMOCAyNUw4IDI2TDkgMjZMOSAyN0w4IDI3TDggMzFMOSAzMUw5IDI5TDEwIDI5TDEwIDI4TDkgMjhMOSAyN0wxMCAyN0wxMCAyNkwxMSAyNkwxMSAyNUwxMyAyNUwxMyAyOUwxMiAyOUwxMiAyOEwxMSAyOEwxMSAyOUwxMiAyOUwxMiAzMEwxMCAzMEwxMCAzMUwxMSAzMUwxMSAzMkwxMiAzMkwxMiAzM0wxNCAzM0wxNCAzMUwxNiAzMUwxNiAzMkwxNyAzMkwxNyAzM0wxOCAzM0wxOCAzMkwyMCAzMkwyMCAzMUwyMSAzMUwyMSAzMkwyMiAzMkwyMiAzM0wyNSAzM0wyNSAzMkwyNyAzMkwyNyAzM0wyOCAzM0wyOCAzMkwzMSAzMkwzMSAzM0wzMiAzM0wzMiAzMkwzMSAzMkwzMSAzMEwzMyAzMEwzMyAyN0wzMiAyN0wzMiAyNkwzMyAyNkwzMyAyNEwzMiAyNEwzMiAyMkwzMyAyMkwzMyAxOUwzMiAxOUwzMiAxOEwzMyAxOEwzMyAxNkwzMiAxNkwzMiAxN0wyOSAxN0wyOSAxNUwzMCAxNUwzMCAxNkwzMSAxNkwzMSAxNUwzMiAxNUwzMiAxNEwzMyAxNEwzMyAxM0wzMCAxM0wzMCAxMkwzMSAxMkwzMSAxMUwzMiAxMUwzMiAxMkwzMyAxMkwzMyAxMUwzMiAxMUwzMiAxMEwzMyAxMEwzMyA5TDMyIDlMMzIgMTBMMzEgMTBMMzEgOEwyNiA4TDI2IDEwTDI0IDEwTDI0IDlMMjMgOUwyMyA4TDIyIDhMMjIgN0wyMyA3TDIzIDZMMjIgNkwyMiA1TDI0IDVMMjQgNEwyMyA0TDIzIDNMMjIgM0wyMiAyTDIzIDJMMjMgMUwyNCAxTDI0IDNMMjUgM0wyNSAxTDI0IDFMMjQgMEwyMyAwTDIzIDFMMjIgMUwyMiAwTDE4IDBMMTggMUwxNyAxTDE3IDBMMTYgMEwxNiAxTDEzIDFMMTMgMFpNMTIgMUwxMiAyTDkgMkw5IDNMMTMgM0wxMyA1TDEyIDVMMTIgNkwxMSA2TDExIDdMMTIgN0wxMiA4TDE0IDhMMTQgMTBMMTYgMTBMMTYgMTFMMTQgMTFMMTQgMTJMMTIgMTJMMTIgMTBMMTMgMTBMMTMgOUwxMiA5TDEyIDEwTDExIDEwTDExIDEyTDEyIDEyTDEyIDEzTDExIDEzTDExIDE1TDEwIDE1TDEwIDE5TDggMTlMOCAxOEw3IDE4TDcgMTdMOSAxN0w5IDE2TDggMTZMOCAxNUw5IDE1TDkgMTRMMTAgMTRMMTAgMTJMNyAxMkw3IDExTDYgMTFMNiAxMEw3IDEwTDcgOUwyIDlMMiAxMEw0IDEwTDQgMTRMNyAxNEw3IDE1TDYgMTVMNiAxNkw3IDE2TDcgMTdMNiAxN0w2IDE4TDUgMThMNSAxNUwzIDE1TDMgMTZMNCAxNkw0IDE4TDUgMThMNSAxOUw2IDE5TDYgMjBMNyAyMEw3IDE5TDggMTlMOCAyMkw3IDIyTDcgMjFMNiAyMUw2IDIyTDUgMjJMNSAyMEw0IDIwTDQgMTlMMyAxOUwzIDIwTDQgMjBMNCAyNEw1IDI0TDUgMjNMNiAyM0w2IDI0TDggMjRMOCAyNUw5IDI1TDkgMjZMMTAgMjZMMTAgMjVMMTEgMjVMMTEgMjRMMTAgMjRMMTAgMjNMMTIgMjNMMTIgMjRMMTMgMjRMMTMgMjVMMTQgMjVMMTQgMjNMMTUgMjNMMTUgMjJMMTkgMjJMMTkgMjNMMjAgMjNMMjAgMjJMMTkgMjJMMTkgMjFMMjAgMjFMMjAgMjBMMjEgMjBMMjEgMjFMMjIgMjFMMjIgMjBMMjEgMjBMMjEgMTlMMjAgMTlMMjAgMThMMTkgMThMMTkgMTdMMjAgMTdMMjAgMTZMMTkgMTZMMTkgMTVMMjEgMTVMMjEgMTRMMTkgMTRMMTkgMTVMMTggMTVMMTggMTNMMTkgMTNMMTkgMTJMMjAgMTJMMjAgMTNMMjIgMTNMMjIgMTVMMjMgMTVMMjMgMTZMMjUgMTZMMjUgMTVMMjQgMTVMMjQgMTRMMjYgMTRMMjYgMTNMMjcgMTNMMjcgMTRMMjkgMTRMMjkgMTNMMjggMTNMMjggMTBMMjkgMTBMMjkgMTFMMzAgMTFMMzAgMTBMMjkgMTBMMjkgOUwyOCA5TDI4IDEwTDI2IDEwTDI2IDEzTDI0IDEzTDI0IDE0TDIzIDE0TDIzIDEzTDIyIDEzTDIyIDEyTDIzIDEyTDIzIDExTDI0IDExTDI0IDEyTDI1IDEyTDI1IDExTDI0IDExTDI0IDEwTDIzIDEwTDIzIDlMMjIgOUwyMiA4TDIwIDhMMjAgNUwxOCA1TDE4IDZMMTcgNkwxNyA3TDE2IDdMMTYgNkwxNSA2TDE1IDVMMTcgNUwxNyA0TDE2IDRMMTYgM0wxOCAzTDE4IDRMMjAgNEwyMCAzTDIxIDNMMjEgNUwyMiA1TDIyIDNMMjEgM0wyMSAxTDE5IDFMMTkgMkwyMCAyTDIwIDNMMTggM0wxOCAyTDE2IDJMMTYgM0wxNCAzTDE0IDJMMTMgMkwxMyAxWk0xMiA2TDEyIDdMMTMgN0wxMyA2Wk0xNCA2TDE0IDhMMTYgOEwxNiAxMEwxOCAxMEwxOCAxMUwxOSAxMUwxOSAxMEwyMCAxMEwyMCAxMUwyMSAxMUwyMSAxMkwyMiAxMkwyMiAxMUwyMyAxMUwyMyAxMEwyMiAxMEwyMiA5TDE4IDlMMTggOEwxNiA4TDE2IDdMMTUgN0wxNSA2Wk0xOCA2TDE4IDdMMTkgN0wxOSA2Wk0yMSA2TDIxIDdMMjIgN0wyMiA2Wk0yNCA2TDI0IDdMMjUgN0wyNSA2Wk05IDEwTDkgMTFMMTAgMTFMMTAgMTBaTTE2IDExTDE2IDEzTDE4IDEzTDE4IDEyTDE3IDEyTDE3IDExWk02IDEyTDYgMTNMNyAxM0w3IDEyWk0xNCAxMkwxNCAxM0wxMiAxM0wxMiAxNEwxMyAxNEwxMyAxNUwxNCAxNUwxNCAxM0wxNSAxM0wxNSAxMlpNMTUgMTRMMTUgMTVMMTYgMTVMMTYgMTRaTTMwIDE0TDMwIDE1TDMxIDE1TDMxIDE0Wk0xMSAxNUwxMSAxNkwxMiAxNkwxMiAxNVpNMjcgMTVMMjcgMTZMMjYgMTZMMjYgMTdMMjUgMTdMMjUgMTlMMjYgMTlMMjYgMjFMMjQgMjFMMjQgMjBMMjMgMjBMMjMgMjFMMjQgMjFMMjQgMjJMMjEgMjJMMjEgMjNMMjIgMjNMMjIgMjRMMjAgMjRMMjAgMjVMMjIgMjVMMjIgMjZMMjEgMjZMMjEgMjdMMjAgMjdMMjAgMjZMMTkgMjZMMTkgMjdMMTggMjdMMTggMjZMMTcgMjZMMTcgMjdMMTUgMjdMMTUgMjhMMTQgMjhMMTQgMjlMMTMgMjlMMTMgMzFMMTIgMzFMMTIgMzJMMTMgMzJMMTMgMzFMMTQgMzFMMTQgMzBMMTcgMzBMMTcgMzJMMTggMzJMMTggMzFMMjAgMzFMMjAgMzBMMjIgMzBMMjIgMjhMMjMgMjhMMjMgMzBMMjQgMzBMMjQgMjhMMjMgMjhMMjMgMjVMMjIgMjVMMjIgMjRMMjMgMjRMMjMgMjNMMjQgMjNMMjQgMjRMMjUgMjRMMjUgMjNMMjcgMjNMMjcgMjRMMjggMjRMMjggMjNMMjcgMjNMMjcgMjJMMjkgMjJMMjkgMjFMMjcgMjFMMjcgMThMMjYgMThMMjYgMTdMMjcgMTdMMjcgMTZMMjggMTZMMjggMTVaTTEzIDE2TDEzIDE3TDEyIDE3TDEyIDE5TDEzIDE5TDEzIDIwTDEyIDIwTDEyIDIzTDE0IDIzTDE0IDIxTDEzIDIxTDEzIDIwTDE0IDIwTDE0IDE4TDE1IDE4TDE1IDIxTDE4IDIxTDE4IDIwTDIwIDIwTDIwIDE5TDE4IDE5TDE4IDE4TDE3IDE4TDE3IDE3TDE4IDE3TDE4IDE2TDE3IDE2TDE3IDE3TDE2IDE3TDE2IDE2Wk0yMSAxNkwyMSAxN0wyMiAxN0wyMiAxNlpNMTMgMTdMMTMgMThMMTQgMThMMTQgMTdaTTE1IDE3TDE1IDE4TDE2IDE4TDE2IDE3Wk0yOCAxN0wyOCAxOEwyOSAxOEwyOSAxOUwzMCAxOUwzMCAxOEwyOSAxOEwyOSAxN1pNMCAxOEwwIDI1TDEgMjVMMSAxOFpNNiAxOEw2IDE5TDcgMTlMNyAxOFpNMjMgMThMMjMgMTlMMjQgMTlMMjQgMThaTTEwIDE5TDEwIDIwTDkgMjBMOSAyM0w4IDIzTDggMjRMOSAyNEw5IDI1TDEwIDI1TDEwIDI0TDkgMjRMOSAyM0wxMCAyM0wxMCAyMkwxMSAyMkwxMSAxOVpNMTcgMTlMMTcgMjBMMTggMjBMMTggMTlaTTMwIDIwTDMwIDIzTDMxIDIzTDMxIDIyTDMyIDIyTDMyIDIxTDMxIDIxTDMxIDIwWk0yNiAyMUwyNiAyMkwyNyAyMkwyNyAyMVpNNiAyMkw2IDIzTDcgMjNMNyAyMlpNMTYgMjNMMTYgMjVMMTUgMjVMMTUgMjZMMTYgMjZMMTYgMjVMMTcgMjVMMTcgMjRMMTggMjRMMTggMjVMMTkgMjVMMTkgMjRMMTggMjRMMTggMjNaTTI5IDI0TDI5IDI3TDMwIDI3TDMwIDI1TDMxIDI1TDMxIDI2TDMyIDI2TDMyIDI1TDMxIDI1TDMxIDI0Wk0yNSAyNUwyNSAyOEwyOCAyOEwyOCAyNVpNMjYgMjZMMjYgMjdMMjcgMjdMMjcgMjZaTTIxIDI3TDIxIDI4TDIyIDI4TDIyIDI3Wk0zMSAyN0wzMSAyOEwzMCAyOEwzMCAyOUwyOSAyOUwyOSAzMEwyOCAzMEwyOCAyOUwyNiAyOUwyNiAzMEwyOCAzMEwyOCAzMUwyNyAzMUwyNyAzMkwyOCAzMkwyOCAzMUwyOSAzMUwyOSAzMEwzMCAzMEwzMCAyOUwzMSAyOUwzMSAyOEwzMiAyOEwzMiAyN1pNMTYgMjhMMTYgMjlMMTggMjlMMTggMzBMMjAgMzBMMjAgMjlMMTkgMjlMMTkgMjhaTTggMzJMOCAzM0wxMCAzM0wxMCAzMlpNMCAwTDAgN0w3IDdMNyAwWk0xIDFMMSA2TDYgNkw2IDFaTTIgMkwyIDVMNSA1TDUgMlpNMjYgMEwyNiA3TDMzIDdMMzMgMFpNMjcgMUwyNyA2TDMyIDZMMzIgMVpNMjggMkwyOCA1TDMxIDVMMzEgMlpNMCAyNkwwIDMzTDcgMzNMNyAyNlpNMSAyN0wxIDMyTDYgMzJMNiAyN1pNMiAyOEwyIDMxTDUgMzFMNSAyOFoiIGZpbGw9IiMwMDAwMDAiLz48L2c+PC9nPjwvc3ZnPgo=
 approval_date30-04-2025
 expiry_date30-04-2026
 statussubmitted
 deleted0
 deleted_date(null)
 created2025-04-30 14:39:59
 modified2025-04-30 14:39:59
 AmendmentLetter(empty)
 AmendmentApproval(empty)
 AmendmentApprovalSummary(empty)
 Organization(array)
 0(array)
 id1177
 application_id1533
 organization
 contact_person
 address
 telephone_number
 all_tasks
 monitoring
 regulatory
 investigator_recruitment
 ivrs_treatment_randomisation
 data_management
 e_data_capture
 susar_reporting
 quality_assurance_auditing
 statistical_analysis
 medical_writing
 other_duties
 other_duties_specify
 misc(null)
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 SiteDetail(array)
 0(array)
 id1876
 application_id1533
 county_id(null)
 site_name
 physical_address
 contact_details
 contact_person
 site_capacity(null)
 misc(null)
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 Placebo(array)
 0(array)
 id823
 application_id1533
 placebo_present(null)
 pharmaceutical_form
 route_of_administration
 composition
 identical_indp
 major_ingredients
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 Sponsor(array)
 0(array)
 id824
 application_id1533
 sponsorServer Migration
 sponsor_typeResearch Institution
 contact_personjapheth kiprotich
 addressServer Migration
 telephone_number0724743788
 fax_number
 cell_number0724743788
 email_addressjkiprotich@intellisoftkenya.com
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 SiteInspection(empty)
 Sae(array)
 0(array)
 id10245
 application_id1533
 sae_id(null)
 reference_noSAE/2025/724
 form_typeSAE
 user_id820
 patient_initials(null)
 country_id(null)
 date_of_birth(null)
 age_years(null)
 gender(null)
 causality(null)
 enrollment_date(null)
 administration_date(null)
 latest_date(null)
 reaction_onset(null)
 reaction_end_date(null)
 patient_died0
 prolonged_hospitalization0
 incapacity0
 life_threatening0
 reaction_other0
 reaction_description(null)
 relevant_history(null)
 manufacturer_name(null)
 mfr_no(null)
 manufacturer_date(null)
 source_study0
 source_literature0
 source_health_professional0
 report_date(null)
 report_typeInitial
 approved0
 approved_by(null)
 email_addressjkiprotich@intellisoftkenya.com
 reporter_name(null)
 reporter_phone(null)
 reporter_emailjkiprotich@intellisoftkenya.com
 deleted0
 deleted_date(null)
 created2025-04-30 14:38:42
 modified2025-04-30 14:38:42
 1(array)
 id10246
 application_id1533
 sae_id(null)
 reference_noSAE/2025/725
 form_typeSAE
 user_id820
 patient_initialsServer Migration
 country_id115
 date_of_birth30-04-2025
 age_years2
 genderMale
 causalityCertain
 enrollment_date30-04-2025
 administration_date30-04-2025
 latest_date30-04-2025
 reaction_onset30-04-2025
 reaction_end_date(null)
 patient_died0
 prolonged_hospitalization0
 incapacity0
 life_threatening1
 reaction_other0
 reaction_descriptionServer Migration
 relevant_historyServer Migration
 manufacturer_nameServer Migration
 mfr_noServer Migration
 manufacturer_date30-04-2025
 source_study0
 source_literature1
 source_health_professional0
 report_date(null)
 report_typeInitial
 approved1
 approved_by(null)
 email_addressjkiprotich@intellisoftkenya.com
 reporter_nameServer Migration
 reporter_phone0724743788
 reporter_emailjkiprotich@intellisoftkenya.com
 deleted0
 deleted_date(null)
 created2025-04-30 14:40:50
 modified2025-04-30 14:42:31
 Ciom(empty)
 StudyRoute(array)
 0(array)
 id605
 application_id1533
 study_routeoral
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 Manufacturer(array)
 0(array)
 id930
 application_id1533
 manufacturer_nameServer Migration
 addressServer Migration
 manufacturer_countryKenya
 manufacturer_phone0724743788
 manufacturer_emailjkiprotich@intelisoftkenya.com
 manufacturing_activitiesComplete manufacturing activities
 other_specify
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 Reassignment(empty)
 Attachment(empty)
 AnnualApproval(empty)
 AmendmentChecklist(empty)
 Reminder(empty)
 ParticipantFlow(empty)
 Budget(array)
 0(array)
 id580
 application_id1533
 year(null)
 budget_period(null)
 personnel_currencyKES
 personnel100
 transport_currencyKES
 transport100
 field_currencyKES
 field100
 supplies_currencyKES
 supplies100
 pharmacy_currencyKES
 pharmacy100
 travel_currencyKES
 travel100
 regulatory_currencyKES
 regulatory100
 it_currencyKES
 it100
 lab_currency(null)
 lab(null)
 others_currencyKES
 others100
 kemri_currency(null)
 kemri(null)
 wrair_currency(null)
 wrair(null)
 subject_currencyKES
 subject100
 grand_currencyKES
 grand_total100
 study_informationServer Migration
 personnel_kshs100
 transport_kshs100
 field_kshs100
 supplies_kshs100
 pharmacy_kshs100
 travel_kshs100
 regulatory_kshs100
 it_kshs100
 lab_kshs(null)
 others_kshs100
 grand_total_kshs100
 subject_kshs100
 created2025-04-29 08:11:39
 modified2025-04-30 14:38:27
 Deviation(array)
 0(array)
 id17765
 application_id1533
 user_id820
 reference_noDEV/2025/762
 study_title Server Migration
 deviation_typeDeviation
 deviation_type_dev
 pi_nameServer Migration Server Migration
 deviation_date30-04-2025
 participant_numberServer Migration Server Migration
 treating_physicianServer Migration Server Migration
 deviation_descriptionServer Migration Server Migration
 deviation_explanationServer Migration Server Migration
 deviation_measuresServer Migration Server Migration
 deviation_precludeServer Migration Server Migration
 sponsor_notified1
 sponsor_explanation(null)
 study_impactServer Migration Server Migration
 statusSubmitted
 deleted0
 deleted_date(null)
 created2025-04-30 14:46:51
 modified2025-04-30 14:52:00
 Document(empty)
 CoverLetter(empty)
 Protocol(empty)
 PatientLeaflet(empty)
 Brochure(empty)
 GmpCertificate(empty)
 Cv(empty)
 Finance(empty)
 Declaration(empty)
 IndemnityCover(empty)
 OpinionLetter(empty)
 ApprovalLetter(empty)
 Statement(empty)
 ParticipatingStudy(empty)
 Addendum(empty)
 Registration(empty)
 Fee(empty)
 Checklist(array)
 0(array)
 id99459
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello.png
 foreign_key1533
 dirnameimg
 basenamehello.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_protocol
 descriptionThe Study Protocol *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_protocol
 version_no1
 created2025-04-29 08:10:42
 modified2025-04-30 14:38:27
 pathimg/hello.png
 1(array)
 id99460
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_2.png
 foreign_key1533
 dirnameimg
 basenamehello_2.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_covering_letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates) *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_covering_letter
 version_no1
 created2025-04-29 08:10:48
 modified2025-04-29 08:10:48
 pathimg/hello_2.png
 2(array)
 id99461
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_3.png
 foreign_key1533
 dirnameimg
 basenamehello_3.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_pan_african
 descriptionRegistration of the study at Pan African Clinical Trials Registry https://pactr.samrc.ac.za *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_pan_african
 version_no1
 created2025-04-29 08:11:18
 modified2025-04-29 08:11:18
 pathimg/hello_3.png
 3(array)
 id99462
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_4.png
 foreign_key1533
 dirnameimg
 basenamehello_4.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_signed_checklist
 descriptionSigned Checklist *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_signed_checklist
 version_no1
 created2025-04-29 08:11:30
 modified2025-04-29 08:11:39
 pathimg/hello_4.png
 4(array)
 id99463
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_5.png
 foreign_key1533
 dirnameimg
 basenamehello_5.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_patient_information
 descriptionPatient Information leaflet and Informed consent form *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_patient_information
 version_no1
 created2025-04-29 08:11:57
 modified2025-04-29 08:11:57
 pathimg/hello_5.png
 5(array)
 id99464
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_6.png
 foreign_key1533
 dirnameimg
 basenamehello_6.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_investigators_brochure
 descriptionInvestigators Brochure/Package inserts *
 year(null)
 file_date22-04-2025
 pocket_nameapplicant_investigators_brochure
 version_no1
 created2025-04-29 08:12:09
 modified2025-04-29 08:12:09
 pathimg/hello_6.png
 6(array)
 id99465
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_7.png
 foreign_key1533
 dirnameimg
 basenamehello_7.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_impd
 descriptionInvestigational Medicinal Product Dossier (IMPD) *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_impd
 version_no1
 created2025-04-29 08:34:23
 modified2025-04-29 08:34:23
 pathimg/hello_7.png
 7(array)
 id99466
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_8.png
 foreign_key1533
 dirnameimg
 basenamehello_8.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_prev_data
 descriptionAdequate data and information from previous studies and Phases to support carrying out of the current study *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_prev_data
 version_no1
 created2025-04-29 08:34:45
 modified2025-04-29 08:34:45
 pathimg/hello_8.png
 8(array)
 id99467
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_9.png
 foreign_key1533
 dirnameimg
 basenamehello_9.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_stability_data
 descriptionStability data of the investigational product *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_stability_data
 version_no1
 created2025-04-29 08:35:47
 modified2025-04-29 08:35:47
 pathimg/hello_9.png
 9(array)
 id99468
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_10.png
 foreign_key1533
 dirnameimg
 basenamehello_10.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_gmp_certificate
 descriptionGMP certificate of the investigational product from the site of manufacture *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_gmp_certificate
 version_no1
 created2025-04-29 08:36:09
 modified2025-04-29 08:36:09
 pathimg/hello_10.png
 10(array)
 id99469
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_11.png
 foreign_key1533
 dirnameimg
 basenamehello_11.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_gcp_training
 descriptionEvidence of recent GCP training of the core study staff *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_gcp_training
 version_no1
 created2025-04-29 08:40:42
 modified2025-04-29 08:40:42
 pathimg/hello_11.png
 11(array)
 id99470
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_12.png
 foreign_key1533
 dirnameimg
 basenamehello_12.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_dsmb_charter
 descriptionDSMB Charter including the composition and meeting schedule *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_dsmb_charter
 version_no1
 created2025-04-29 08:40:45
 modified2025-04-29 08:40:45
 pathimg/hello_12.png
 12(array)
 id99471
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_13.png
 foreign_key1533
 dirnameimg
 basenamehello_13.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_contractual_agreement
 descriptionEvidence of contractual agreement between sponsor and Principal Investigator. *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_contractual_agreement
 version_no1
 created2025-04-29 08:40:53
 modified2025-04-29 08:40:53
 pathimg/hello_13.png
 13(array)
 id99472
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_14.png
 foreign_key1533
 dirnameimg
 basenamehello_14.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_investigators_cv
 descriptionSigned investigator(s) CV(s) including that of study Pharmacist (NB: The CV should include the current workload of the Principal Investigator ) *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_investigators_cv
 version_no1
 created2025-04-29 08:40:56
 modified2025-04-29 08:40:56
 pathimg/hello_14.png
 14(array)
 id99473
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_15.png
 foreign_key1533
 dirnameimg
 basenamehello_15.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_pictorial_sample
 descriptionPictorial Sample of the investigational products. This sample should include the text of the labeling to be used *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_pictorial_sample
 version_no1
 created2025-04-29 08:41:00
 modified2025-04-29 08:41:00
 pathimg/hello_15.png
 15(array)
 id99474
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_16.png
 foreign_key1533
 dirnameimg
 basenamehello_16.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_detailed_budget
 descriptionDetailed budget of the study *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_detailed_budget
 version_no1
 created2025-04-29 08:41:50
 modified2025-04-29 08:41:50
 pathimg/hello_16.png
 16(array)
 id99475
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_17.png
 foreign_key1533
 dirnameimg
 basenamehello_17.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_signed_declaration
 descriptionSigned Declaration by Sponsor or Principal investigator that the study will be carried out according to the protocol and applicable laws, regulations and GCP requirements. *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_signed_declaration
 version_no1
 created2025-04-29 08:42:31
 modified2025-04-29 08:42:31
 pathimg/hello_17.png
 17(array)
 id99476
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_18.png
 foreign_key1533
 dirnameimg
 basenamehello_18.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_financial_declaration
 descriptionFinancial declaration by Sponsor and/or PI *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_financial_declaration
 version_no1
 created2025-04-29 08:42:34
 modified2025-04-29 08:42:34
 pathimg/hello_18.png
 18(array)
 id99477
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_19.png
 foreign_key1533
 dirnameimg
 basenamehello_19.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_indemnity_pi
 descriptionIndemnity cover for PI, investigators and study Pharmacist. *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_indemnity_pi
 version_no1
 created2025-04-29 08:43:03
 modified2025-04-29 08:43:03
 pathimg/hello_19.png
 19(array)
 id99478
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_20.png
 foreign_key1533
 dirnameimg
 basenamehello_20.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_opinion_letter
 descriptionCopy of favorable opinion letter from the local Ethics Review Committee (ERC). *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_opinion_letter
 version_no1
 created2025-04-29 08:44:53
 modified2025-04-29 08:44:53
 pathimg/hello_20.png
 20(array)
 id99479
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_21.png
 foreign_key1533
 dirnameimg
 basenamehello_21.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_indemnity_cover
 descriptionClinical Trials Insurance cover for study participants *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_indemnity_cover
 version_no1
 created2025-04-29 08:44:55
 modified2025-04-29 08:44:55
 pathimg/hello_21.png
 21(array)
 id99480
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_22.png
 foreign_key1533
 dirnameimg
 basenamehello_22.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_practice_license
 descriptionCopy of current Practice Licenses for the Investigators and study Pharmacist *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_practice_license
 version_no1
 created2025-04-29 08:47:13
 modified2025-04-29 08:47:13
 pathimg/hello_22.png
 22(array)
 id99481
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_23.png
 foreign_key1533
 dirnameimg
 basenamehello_23.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_approval_letter
 descriptionCopy of approval letter(s) from collaborating institutions or other regulatory authorities, if applicable
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_approval_letter
 version_no1
 created2025-04-29 08:47:14
 modified2025-04-29 08:47:14
 pathimg/hello_23.png
 23(array)
 id99482
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_24.png
 foreign_key1533
 dirnameimg
 basenamehello_24.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupstatistical_analysis_plan
 descriptionStatistical Analysis Plan *
 year(null)
 file_date29-04-2025
 pocket_namestatistical_analysis_plan
 version_no1
 created2025-04-29 08:48:42
 modified2025-04-29 08:49:45
 pathimg/hello_24.png
 24(array)
 id99483
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_25.png
 foreign_key1533
 dirnameimg
 basenamehello_25.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_fees
 descriptionPayment of fees *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_fees
 version_no1
 created2025-04-29 08:48:44
 modified2025-04-29 08:48:44
 pathimg/hello_25.png
 25(array)
 id99484
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_26.png
 foreign_key1533
 dirnameimg
 basenamehello_26.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_statement
 descriptionA signed statement by the applicant indicating that all information contained in, or referenced by, the application is complete and accurate and is not false or misleading. *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_statement
 version_no1
 created2025-04-29 08:48:46
 modified2025-04-29 08:48:46
 pathimg/hello_26.png
 26(array)
 id99485
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_27.png
 foreign_key1533
 dirnameimg
 basenamehello_27.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_addendum
 descriptionFor multicentre/multi-site studies, a site specific addendum for each of the proposed sites including among other things the sitesâ€™ capacity to carry out the study i.e personnel, equipment, laboratory etc
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_addendum
 version_no1
 created2025-04-29 08:48:47
 modified2025-04-29 08:48:47
 pathimg/hello_27.png
 27(array)
 id99486
 modelChecklist
 file/var/www/html/ctr/app/webroot/media/transfer/img/hello_28.png
 foreign_key1533
 dirnameimg
 basenamehello_28.png
 checksum888d87eac0117d87869fe6e78d038c34
 alternative(null)
 groupapplicant_analysis_cert
 descriptionCertificate of Analysis of the investigational product *
 year(null)
 file_date29-04-2025
 pocket_nameapplicant_analysis_cert
 version_no1
 created2025-04-29 08:49:40
 modified2025-04-29 08:49:40
 pathimg/hello_28.png
 StudyMonitor(empty)
 ProtocolOutsource(empty)
 Outsource(empty)
- redir
- $request->data(empty)
- $this->validationErrors(array)
 Permission(empty)
 Aro(empty)
 Aco(empty)
 Application(empty)
 User(empty)
 TrialStatus(empty)
 Review(empty)
 ActiveInspector(empty)
 ManagerReview(empty)
 Acceptance(empty)
 Amendment(empty)
 InvestigatorContact(empty)
 ApplicationStage(empty)
 Pharmacist(empty)
 EthicalCommittee(empty)
 AnnualLetter(empty)
 AmendmentLetter(empty)
 AmendmentApproval(empty)
 AmendmentApprovalSummary(empty)
 Organization(empty)
 SiteDetail(empty)
 Placebo(empty)
 Sponsor(empty)
 SiteInspection(empty)
 Sae(empty)
 Ciom(empty)
 StudyRoute(empty)
 Manufacturer(empty)
 Reassignment(empty)
 Attachment(empty)
 AnnualApproval(empty)
 AmendmentChecklist(empty)
 Reminder(empty)
 ParticipantFlow(empty)
 Budget(empty)
 Deviation(empty)
 Document(empty)
 CoverLetter(empty)
 Protocol(empty)
 PatientLeaflet(empty)
 Brochure(empty)
 GmpCertificate(empty)
 Cv(empty)
 Finance(empty)
 Declaration(empty)
 IndemnityCover(empty)
 OpinionLetter(empty)
 ApprovalLetter(empty)
 Statement(empty)
 ParticipatingStudy(empty)
 Addendum(empty)
 Registration(empty)
 Fee(empty)
 Checklist(empty)
 StudyMonitor(empty)
 ProtocolOutsource(empty)
 Outsource(empty)
- Loaded Helpers(array)
 0Html
 1Form
 2Session
 3Text
 4Number
 5SimpleGraph
 6DebugTimer
 7Toolbar
 8HtmlToolbar
====

Environment

App Constants

Constant	Value
MEDIA	'/var/www/html/ctr/app/webroot/media/'
MEDIA_STATIC	'/var/www/html/ctr/app/webroot/media/static/'
MEDIA_FILTER	'/var/www/html/ctr/app/webroot/media/filter/'
MEDIA_TRANSFER	'/var/www/html/ctr/app/webroot/media/transfer/'
MEDIA_URL	'media/'
MEDIA_STATIC_URL	'media/static/'
MEDIA_FILTER_URL	'media/filter/'
MEDIA_TRANSFER_URL	'media/transfer/'
HTTP_HOST	'ctr.pharmacyboardkenya.org'
HTTP_BASE	'http://ctr.pharmacyboardkenya.org'
HTTP_SELF	'/app/webroot/index.php'
HTTP_URI	'/applications/view/1533'
CHOWN_PUBLIC	(int) 504
LF	''
NL	''
CR	''
TB	''
BR	' '
WINDOWS	false
FORMAT_DB_DATETIME	'Y-m-d H:i:s'
FORMAT_DB_DATE	'Y-m-d'
FORMAT_DB_TIME	'H:i:s'
DEFAULT_DATETIME	'0000-00-00 00:00:00'
DEFAULT_DATE	'0000-00-00'
DEFAULT_TIME	'00:00:00'
FILES	'/var/www/html/ctr/app/files/'
LOCALE	'/var/www/html/ctr/app/locale/'
CLASS_USER	'User'
VALID_ALPHA	'/^[a-zA-Z]+$/'
VALID_ALPHA_UNDERSCORES	'/^[a-zA-Z_]+$/'
VALID_ALPHA_MINUS_UNDERSCORES	'/^[a-zA-Z_-]+$/'
VALID_ALPHA_WHITESPACES	'/^[a-zA-Z ]+$/'
VALID_ALPHANUMERIC_UNDERSCORES	'/^[\da-zA-Z_]+$/'
VALID_ALPHANUMERIC_MINUS_UNDERSCORES	'/^[\da-zA-Z_-]+$/'
VALID_ALPHANUMERIC_WHITESPACES	'/^[\da-zA-Z ]+$/'
VALID_ALPHANUMERIC_WHITESPACES_UNDERSCORES	'/^[\da-zA-Z _]+$/'
VALID_NUMERIC_UNDERSCORES	'/^[\d_]+$/'
VALID_NUMERIC_WHITESPACES	'/^[\d ]+$/'
VALID_NUMERIC_WHITESPACES_UNDERSCORES	'/^[\d _]+$/'
VALID_INTEGERS	'/^[\d]+$/'
FORMAT_NICE_YMDHMS	'd.m.Y, H:i:s'
FORMAT_NICE_YMDHM	'd.m.Y, H:i'
FORMAT_NICE_YM	'm.Y'
FORMAT_NICE_YMD	'd.m.Y'
FORMAT_NICE_MD	'd.m.'
FORMAT_NICE_D	'd'
FORMAT_NICE_W_NUM	'w'
FORMAT_NICE_W_ABBR	'D'
FORMAT_NICE_W_FULL	'l'
FORMAT_NICE_M	'm'
FORMAT_NICE_M_ABBR	'M'
FORMAT_NICE_M_FULL	'F'
FORMAT_NICE_Y_ABBR	'y'
FORMAT_NICE_Y	'Y'
FORMAT_NICE_HM	'H:i'
FORMAT_NICE_HMS	'H:i:s'
FORMAT_LOCAL_WA_YMDHMS	'%a, %d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_WF_YMDHMS	'%A, %d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_WA_YMDHM	'%a, %d.%m.%Y, %H:%M'
FORMAT_LOCAL_WF_YMDHM	'%A, %d.%m.%Y, %H:%M'
FORMAT_LOCAL_YMDHMS	'%d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_YMDHM	'%d.%m.%Y, %H:%M'
FORMAT_LOCAL_YMD	'%d.%m.%Y'
FORMAT_LOCAL_MD	'%d.%m.'
FORMAT_LOCAL_D	'%d'
FORMAT_LOCAL_W_NUM	'%w'
FORMAT_LOCAL_W_ABBR	'%a'
FORMAT_LOCAL_W_FULL	'%A'
FORMAT_LOCAL_M	'%m'
FORMAT_LOCAL_M_ABBR	'%b'
FORMAT_LOCAL_M_FULL	'%B'
FORMAT_LOCAL_Y_ABBR	'%y'
FORMAT_LOCAL_YMS_ABBR	'%d.%m.%y'
FORMAT_LOCAL_Y	'%Y'
FORMAT_LOCAL_H	'%H'
FORMAT_LOCAL_S	'%S'
FORMAT_LOCAL_HM	'%H:%M'
FORMAT_LOCAL_HMS	'%H:%M:%S'
CHAR_LESS	'<'
CHAR_GREATER	'>'
CHAR_QUOTE	'"'
CHAR_APOSTROPHE	'''
CHAR_ARROWS	'»'
CHAR_ARROWS_R	'»'
CHAR_ARROWS_L	'«'
CHAR_AVERAGE	'Ø'
CHAR_INFIN	'∞'
CHAR_MILL	'‰'
CHAR_PLUSMN	'±'
CHAR_HELLIP	'…'
CHAR_CIRCA	'≈'
CHAR_CHECKBOX_EMPTY	'☐]'
CHAR_CHECKBOX_MAKRED	'☑'
CHAR_CHECKMARK	'✓'
CHAR_CHECKMARK_BOLD	'✔'
CHAR_BALLOT	'✗'
CHAR_BALLOT_BOLD	'✘'
CHAR_ABOUT	'≈'
CHAR_RPIME	'′'
CHAR_DOUBLE_RPIME	'″'

CakePHP Constants

Constant	Value
APP	'/var/www/html/ctr/app/'
APP_DIR	'app'
APPLIBS	'/var/www/html/ctr/app/Lib/'
CACHE	'/var/www/html/ctr/app/tmp/cache/'
CAKE	'/var/www/html/ctr/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/var/www/html/ctr/lib'
CORE_PATH	'/var/www/html/ctr/lib/'
CAKE_VERSION	'2.2.2'
CSS	'/var/www/html/ctr/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'https://ctr.pharmacyboardkenya.org'
IMAGES	'/var/www/html/ctr/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/var/www/html/ctr/app/webroot/js/'
JS_URL	'js/'
LOGS	'/var/www/html/ctr/app/tmp/logs/'
ROOT	'/var/www/html/ctr'
TESTS	'/var/www/html/ctr/app/Test/'
TMP	'/var/www/html/ctr/app/tmp/'
VENDORS	'/var/www/html/ctr/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/var/www/html/ctr/app/webroot/'

PHP Environment

Environment Variable	Value
Php Version	'5.6.40-81+ubuntu20.04.1+deb.sury.org+1'
Redirect Redirect Https	'on'
Redirect Redirect Ssl Tls Sni	'ctr.pharmacyboardkenya.org'
Redirect Redirect Status	'200'
Redirect Https	'on'
Redirect Ssl Tls Sni	'ctr.pharmacyboardkenya.org'
Redirect Status	'200'
Https	'on'
Ssl Tls Sni	'ctr.pharmacyboardkenya.org'
Http Accept	'/'
Http User Agent	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
Http Accept Encoding	'gzip, br, zstd, deflate'
Http Host	'ctr.pharmacyboardkenya.org'
Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
Server Signature	' Apache/2.4.41 (Ubuntu) Server at ctr.pharmacyboardkenya.org Port 443 '
Server Software	'Apache/2.4.41 (Ubuntu)'
Server Name	'ctr.pharmacyboardkenya.org'
Server Addr	'192.168.10.21'
Server Port	'443'
Remote Addr	'18.119.172.58'
Document Root	'/var/www/html/ctr'
Request Scheme	'https'
Context Prefix	''
Context Document Root	'/var/www/html/ctr'
Server Admin	'webmaster@localhost'
Script Filename	'/var/www/html/ctr/app/webroot/index.php'
Remote Port	'41711'
Redirect Url	'/app/webroot/applications/view/1533'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/applications/view/1533'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1746035296.302
Request Time	(int) 1746035296

====

Include
+
Included Files

Include Paths
- 0/var/www/html/ctr/app/Plugin/Media/Lib/mm/src
- 1/var/www/html/ctr/lib
- 3/usr/share/php
- 4-> /var/www/html/ctr/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/TreeBehavior.php
  1CORE/Model/Behavior/ContainableBehavior.php
  2CORE/Model/Behavior/AclBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AclComponent.php
  1CORE/Controller/Component/Acl/DbAcl.php
  2CORE/Controller/Component/Acl/AclInterface.php
  3CORE/Controller/Component/AuthComponent.php
  4CORE/Controller/Component/RequestHandlerComponent.php
  5CORE/Controller/Component/SessionComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/ConnectionManager.php
  1CORE/Model/Permission.php
  2CORE/Model/Model.php
  3CORE/Model/BehaviorCollection.php
  4CORE/Model/Aro.php
  5CORE/Model/AclNode.php
  6CORE/Model/Aco.php
  7CORE/Model/ModelBehavior.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/ClassRegistry.php
  6CORE/Utility/Set.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Behavior(array)
  0APP/Model/Behavior/SoftDeleteBehavior.php
  1APP/Model/Behavior/TimestampBehavior.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/ApplicationsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Application.php
  2APP/Model/User.php
  3APP/Model/TrialStatus.php
  4APP/Model/Review.php
  5APP/Model/ActiveInspector.php
  6APP/Model/Amendment.php
  7APP/Model/InvestigatorContact.php
  8APP/Model/ApplicationStage.php
  9APP/Model/Pharmacist.php
  10APP/Model/EthicalCommittee.php
  11APP/Model/AnnualLetter.php
  12APP/Model/AmendmentLetter.php
  13APP/Model/AmendmentApproval.php
  14APP/Model/Organization.php
  15APP/Model/SiteDetail.php
  16APP/Model/Placebo.php
  17APP/Model/Sponsor.php
  18APP/Model/SiteInspection.php
  19APP/Model/Sae.php
  20APP/Model/Ciom.php
  21APP/Model/StudyRoute.php
  22APP/Model/Manufacturer.php
  23APP/Model/Reassignment.php
  24APP/Model/Attachment.php
  25APP/Model/Reminder.php
  26APP/Model/ParticipantFlow.php
  27APP/Model/Budget.php
  28APP/Model/Deviation.php
  29APP/Model/StudyMonitor.php
  30APP/Model/ProtocolOutsource.php
  31APP/Model/Outsource.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  CakePdf(array)
  Config(array)
  0CakePdf/Config/bootstrap.php
  1CakePdf/Config/routes.php
  CakeResque(array)
  Config(array)
  0CakeResque/Config/bootstrap.php
  Plugin(array)
  0CakeResque/Lib/CakeResque.php
  1CakeResque/vendor/kamisama/php-resque-ex/lib/Resque.php
  2CakeResque/vendor/kamisama/php-resque-ex/lib/Resque/Event.php
  3CakeResque/vendor/kamisama/php-resque-ex/lib/Resque/Exception.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Media(array)
  Config(array)
  0Media/Config/bootstrap.php
  Plugin(array)
  0Media/Lib/mm/src/Mime/Type.php
  1Media/Lib/mm/src/Mime/Type/Magic/Adapter/Fileinfo.php
  2Media/Lib/mm/src/Mime/Type/Magic/Adapter.php
  3Media/Lib/mm/src/Mime/Type/Glob/Adapter/Freedesktop.php
  4Media/Lib/mm/src/Mime/Type/Glob/Adapter.php
  5Media/Lib/mm/src/Media/Process.php
  6Media/Lib/mm/src/Media/Info.php
  Behavior(array)
  0Media/Model/Behavior/TransferBehavior.php
  1Media/Model/Behavior/CouplerBehavior.php
  2Media/Model/Behavior/MetaBehavior.php
  Search(array)
  Component(array)
  0Search/Controller/Component/PrgComponent.php
  Behavior(array)
  0Search/Model/Behavior/SearchableBehavior.php
  Shim(array)
  Config(array)
  0Shim/Config/bootstrap.php
  Tools(array)
  Config(array)
  0Tools/Config/bootstrap.php
====

Study Title:	Server Migration
Study Objectives:	Server Migration
Laymans Summary:	Server Migration
Abstract of Study:	Server Migration

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 3854 ms Total Queries: 53 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 3854 ms
Total Queries: 53 queries