Pharmacy and Poisons Board: Applications

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

Cake Params
- plugin(null)
- controllerapplications
- actionview
- named(empty)
- pass(array)
  0256
- 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: 49 ms
Total Queries: 54 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `ctr`.`applications` AS `Application` WHERE `Application`.`id` = 256	1	1	1
SELECT `Application`.`id`, `Application`.`user_id`, `Application`.`application_id`, `Application`.`is_child`, `Application`.`trial_status_id`, `Application`.`total_sites`, `Application`.`abstract_of_study`, `Application`.`study_title`, `Application`.`laymans_summary`, `Application`.`short_title`, `Application`.`protocol_no`, `Application`.`reference_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`.`unsubmitted`, `Application`.`initial_date_submitted`, `Application`.`admin_stopped`, `Application`.`admin_stopped_reason`, `Application`.`approved`, `Application`.`approved_reason`, `Application`.`approved_date`, `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`.`ecitizen_invoice`, `Application`.`modified`, `Application`.`created`, `Application`.`ai_content`, `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` = 256 AND `Application`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`application_id`, `Review`.`category`, `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`.`category` = '0' AND `Review`.`application_id` = (256)	4	4	0
SELECT `InternalReview`.`id`, `InternalReview`.`user_id`, `InternalReview`.`application_id`, `InternalReview`.`category`, `InternalReview`.`type`, `InternalReview`.`assessment_type`, `InternalReview`.`title`, `InternalReview`.`text`, `InternalReview`.`summary`, `InternalReview`.`recommendation`, `InternalReview`.`notified`, `InternalReview`.`accepted`, `InternalReview`.`conflict`, `InternalReview`.`status`, `InternalReview`.`created`, `InternalReview`.`modified` FROM `ctr`.`reviews` AS `InternalReview` WHERE `InternalReview`.`category` = '1' AND `InternalReview`.`application_id` = (256)	1	1	0
SELECT `ActiveInspector`.`id`, `ActiveInspector`.`user_id`, `ActiveInspector`.`application_id`, `ActiveInspector`.`type`, `ActiveInspector`.`assessment_type`, `ActiveInspector`.`title`, `ActiveInspector`.`text`, `ActiveInspector`.`summary`, `ActiveInspector`.`recommendation`, `ActiveInspector`.`notified`, `ActiveInspector`.`accepted`, `ActiveInspector`.`conflict`, `ActiveInspector`.`status`, `ActiveInspector`.`created`, `ActiveInspector`.`modified` FROM `ctr`.`active_inspectors` AS `ActiveInspector` WHERE `ActiveInspector`.`application_id` = (256)	1	1	0
SELECT `ManagerReview`.`id`, `ManagerReview`.`user_id`, `ManagerReview`.`application_id`, `ManagerReview`.`category`, `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` = (256)	5	5	0
SELECT `Acceptance`.`id`, `Acceptance`.`user_id`, `Acceptance`.`application_id`, `Acceptance`.`category`, `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` = (256)	0	0	0
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` = (256)	0	0	1	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`.`investigator_role`, `InvestigatorContact`.`created`, `InvestigatorContact`.`modified` FROM `ctr`.`investigator_contacts` AS `InvestigatorContact` WHERE `InvestigatorContact`.`application_id` = (256)	1	1	0
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` = (256)	7	7	0
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` = (256)	1	1	0
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` = (256)	1	1	0
SELECT `AnnualLetter`.`id`, `AnnualLetter`.`application_id`, `AnnualLetter`.`approval_no`, `AnnualLetter`.`type`, `AnnualLetter`.`content`, `AnnualLetter`.`qrcode`, `AnnualLetter`.`approver`, `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` = (256)	1	1	1
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` = (256)	0	0	0
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` = (256)	0	0	0
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` = (256)	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` = (256)	1	1	0
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` = (256)	1	1	1
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` = (256)	1	1	0
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` = (256)	1	1	0
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` = (256)	1	1	0
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`.`date_submitted`, `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` = (256)	4	4	0
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`, `Ciom`.`deleted` FROM `ctr`.`cioms` AS `Ciom` WHERE `Ciom`.`application_id` = (256)	0	0	0
SELECT `StudyRoute`.`id`, `StudyRoute`.`application_id`, `StudyRoute`.`study_route`, `StudyRoute`.`created`, `StudyRoute`.`modified` FROM `ctr`.`study_routes` AS `StudyRoute` WHERE `StudyRoute`.`application_id` = (256)	1	1	0
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` = (256)	1	1	0
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` = (256)	0	0	0
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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	0
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` = (256)	0	0	0
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` = (256)	1	1	0
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_notification_date`, `Deviation`.`sponsor_explanation`, `Deviation`.`study_impact`, `Deviation`.`status`, `Deviation`.`date_submitted`, `Deviation`.`deleted`, `Deviation`.`deleted_date`, `Deviation`.`created`, `Deviation`.`modified` FROM `ctr`.`deviations` AS `Deviation` WHERE `Deviation`.`application_id` = (256)	0	0	0
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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	3	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` = (256)	0	0	3	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	0	0	2	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` = (256)	12	12	2	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` = (256)	0	0	0
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` = (256)	0	0	0
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` = (256)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.05 MB

Message	Memory use
Component initialization	2.42 MB
Controller action start	3.60 MB
Controller render start	8.07 MB
View render complete	8.50 MB

Timers

Total Request Time: 285 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	9.01
Event: Controller.initialize	0.24
Event: Controller.startup	0.43
Controller action	223.85
Event: Controller.beforeRender	14.10
» Processing toolbar data	13.96
Rendering View	2.83
» Event: View.beforeRender	0.03
» Rendering APP/View/Applications/view.ctp	0.44
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	2.00
» » Rendering APP/View/Elements/google-analytics.ctp	0.05
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- application(array)
 Application(array)
 id256
 user_id869
 application_id(null)
 is_child0
 trial_status_id(null)
 total_sites1
 abstract_of_study Malaria continues to be a significant public health concern, particularly in regions where the disease is endemic. New treatment options are needed to improve patient outcomes and address emerging drug resistance.
 study_title antimalaria2
 laymans_summary Malaria remains a major health challenge in many countries. This study aims to evaluate a new treatment for malaria and compare it with the current standard treatment. Adults diagnosed with uncomplicated malaria will be invited to participate and will be randomly assigned to receive either the new treatment or the standard treatment. 
 short_titletest sample
 protocol_noECCT/26/06/01
 reference_no(null)
 version_nov53
 date_of_protocol09-06-2026
 study_drugantimaliria2
 disease_conditionmalaria
 product_type_biologicals1
 product_type_proteins0
 product_type_immunologicals1
 product_type_vaccines1
 product_type_hormones0
 product_type_toxoid0
 product_type_chemical0
 product_type_medical_device0
 product_type_chemical_name
 product_type_medical_device_name
 comparatorNo
 comparator_name
 comparator_registered
 comparator_countries
 ecct_not_applicable0
 ecct_ref_number
 email_addressmkorir600+3@gmail.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_letter0
 applicant_statement1
 applicant_participating_countries(null)
 applicant_addendum0
 applicant_fees1
 applicant_complete_form(null)
 applicant_impd0
 applicant_prev_data0
 applicant_stability_data0
 applicant_analysis_cert0
 applicant_pictorial_sample0
 applicant_gcp_training0
 applicant_dsmb_charter0
 applicant_detailed_budget0
 applicant_indemnity_pi0
 applicant_practice_license0
 applicant_registration_ctr(null)
 applicant_pan_african0
 applicant_hard_copies(null)
 applicant_signed_checklist0
 statistical_analysis_plan0
 applicant_contractual_agreement0
 declaration_applicant0712345678
 declaration_date109-06-2026
 declaration_principal_investigatorprincipal investigator
 declaration_date209-06-2026
 placebo_presentNo
 study_objectives To evaluate the safety and effectiveness of a new antimalarial drug in treating uncomplicated malaria.
 principal_inclusion_criteria Be 18 years and above Have confirmed uncomplicated malaria infection (Plasmodium falciparum) Be able to provide informed consent Be willing to comply with study procedures and follow-up visits
 principal_exclusion_criteria Have severe or complicated malaria Are pregnant or breastfeeding (if the study drug is not proven safe in pregnancy) Have known allergy or hypersensitivity to the study drug or related medications Have serious chronic illnesses (e.g., severe liver, kidney, or heart disease) Have received antimalarial treatment within the last 14 days Are unable to comply with study procedures or follow-up visits Are participating in another clinical trial at the same time
 primary_end_points Treatment success rate at Day 28 
 scope_diagnosis1
 scope_prophylaxis0
 scope_therapy1
 scope_safety1
 scope_efficacy1
 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_study1
 trial_other0
 trial_other_specify
 trial_therapeutic_exploratory0
 trial_therapeutic_confirmatory0
 trial_therapeutic_use0
 design_controlledNo
 site_capacity(null)
 staff_numbers ffghghj
 other_details_explanation kjjnm
 other_details_regulatory_notapproved vbbvbv
 other_details_regulatory_approved nbbn
 other_details_regulatory_rejected bnbbvo
 other_details_regulatory_halted bvvbv
 estimated_duration12 months
 design_controlled_randomised
 design_controlled_open
 design_controlled_single_blind
 design_controlled_double_blind
 design_controlled_parallel_group
 design_controlled_cross_over
 design_controlled_other
 design_controlled_specify
 design_controlled_comparator
 design_controlled_other_medicinal
 design_controlled_placebo
 design_controlled_medicinal_other
 design_controlled_medicinal_specify
 single_site_member_stateYes
 location_of_areammust
 single_site_physical_address123, kk
 single_site_contact_personHOR
 single_site_telephone0712345678
 multiple_sites_member_stateNo
 multiple_countriesNo
 multiple_member_states
 number_of_sites
 multi_country_list
 data_monitoring_committeeNo
 total_enrolment_per_site5
 total_participants_worldwide1000
 population_less_than_18_yearsNo
 population_uteroNo
 population_preterm_newbornNo
 population_newbornNo
 population_infant_and_toddlerNo
 population_childrenNo
 population_adolescentNo
 population_above_18Yes
 population_adultYes
 population_elderlyNo
 gender_female1
 gender_male1
 subjects_healthyYes
 subjects_patientsNo
 subjects_vulnerable_populationsNo
 subjects_women_child_bearingNo
 subjects_women_using_contraceptionNo
 subjects_pregnant_womenNo
 subjects_nursing_womenNo
 subjects_emergency_situationNo
 subjects_incapable_consentNo
 subjects_specify
 subjects_othersNo
 subjects_others_specify
 investigator1_given_namelucy
 investigator1_middle_namelucy
 investigator1_family_namelucy
 investigator1_qualificationqual
 investigator1_professional_addressspicemercy8+1@gmail.com
 investigator1_telephone0712345678
 investigator1_emailspicemercy8+1@gmail.com
 organisations_transferred_No
 number_participants100
 notification bbvb
 approval_date10-06-2026
 submitted1
 deleted0
 deleted_date(null)
 deactivated0
 date_submitted09-06-2026
 unsubmitted0
 initial_date_submitted(null)
 admin_stopped0
 admin_stopped_reason(null)
 approved2
 approved_reasongood
 approved_date(null)
 final_report(null)
 implication_results(null)
 quantity_imported(null)
 quantity_dispensed(null)
 quantity_destroyed(null)
 quantity_exported(null)
 balance_site(null)
 final_date(null)
 ecitizen_invoice460442
 modified2026-06-10 06:33:19
 created2026-06-09 21:11:17
 ai_content(null)
 User(array)
 id869
 usernamePI-CTR
 password66f665cb5031d1734da42d237da0549cefea3a15
 confirm_password66f665cb5031d1734da42d237da0549cefea3a15
 namePI
 emailmkorir600+3@gmail.com
 national_id_number(null)
 sponsor(null)
 sponsor_emailmkorir600+3@gmail.com
 qualification
 phone_no0712345678
 name_of_institution
 institution_physical
 institution_address
 institution_contact
 county_id34
 country_id115
 group_id5
 activation_key
 forgot_password(null)
 is_active1
 deactivated0
 created2026-06-09 21:05:16
 modified2026-07-02 15:48:27
 TrialStatus(array)
 id(null)
 value(null)
 name(null)
 created(null)
 modified(null)
 Review(array)
 0(array)
 id37
 user_id868
 application_id256
 category0
 typereviewer_comment
 assessment_typestatistical
 title(null)
 text(null)
 summaryStudy plan and design comments df
 recommendation(null)
 notified0
 accepted(null)
 conflict(null)
 statusSubmitted
 created2026-06-10 06:05:11
 modified2026-06-10 06:06:48
 1(array)
 id38
 user_id868
 application_id256
 category0
 typereviewer_comment
 assessment_typequality
 title(null)
 text(null)
 summarysjjsnm
 recommendationupload all documents
 notified0
 accepted(null)
 conflict(null)
 statusSummary
 created2026-06-10 06:07:04
 modified2026-06-10 06:09:53
 2(array)
 id39
 user_id867
 application_id256
 category0
 typerequest
 assessment_type(null)
 titlePPB request
 textreview by today
 summary(null)
 recommendationbydd
 notified0
 accepteddeclined
 conflictNo
 statusUnsubmitted
 created2026-06-10 06:10:56
 modified2026-06-10 06:13:04
 3(array)
 id40
 user_id871
 application_id256
 category0
 typerequest
 assessment_type(null)
 titlePPB request
 text
 summary(null)
 recommendation(null)
 notified0
 accepted(null)
 conflict(null)
 statusUnsubmitted
 created2026-06-24 14:00:32
 modified2026-06-24 14:00:32
 InternalReview(array)
 0(array)
 id36
 user_id868
 application_id256
 category1
 typerequest
 assessment_type(null)
 titlePPB request
 text
 summary(null)
 recommendationfine
 notified0
 acceptedaccepted
 conflictNo
 statusUnsubmitted
 created2026-06-10 06:03:30
 modified2026-06-10 06:04:35
 ActiveInspector(array)
 0(array)
 id21
 user_id871
 application_id256
 typerequest
 assessment_type(null)
 titlePPB request
 text
 summary(null)
 recommendationinspecting
 notified0
 acceptedaccepted
 conflictNo
 statusUnsubmitted
 created2026-06-10 15:50:43
 modified2026-06-10 15:50:43
 ManagerReview(array)
 0(array)
 id36
 user_id868
 application_id256
 category1
 typerequest
 assessment_type(null)
 titlePPB request
 text
 summary(null)
 recommendationfine
 notified0
 acceptedaccepted
 conflictNo
 statusUnsubmitted
 created2026-06-10 06:03:30
 modified2026-06-10 06:04:35
 1(array)
 id37
 user_id868
 application_id256
 category0
 typereviewer_comment
 assessment_typestatistical
 title(null)
 text(null)
 summaryStudy plan and design comments df
 recommendation(null)
 notified0
 accepted(null)
 conflict(null)
 statusSubmitted
 created2026-06-10 06:05:11
 modified2026-06-10 06:06:48
 2(array)
 id38
 user_id868
 application_id256
 category0
 typereviewer_comment
 assessment_typequality
 title(null)
 text(null)
 summarysjjsnm
 recommendationupload all documents
 notified0
 accepted(null)
 conflict(null)
 statusSummary
 created2026-06-10 06:07:04
 modified2026-06-10 06:09:53
 3(array)
 id39
 user_id867
 application_id256
 category0
 typerequest
 assessment_type(null)
 titlePPB request
 textreview by today
 summary(null)
 recommendationbydd
 notified0
 accepteddeclined
 conflictNo
 statusUnsubmitted
 created2026-06-10 06:10:56
 modified2026-06-10 06:13:04
 4(array)
 id40
 user_id871
 application_id256
 category0
 typerequest
 assessment_type(null)
 titlePPB request
 text
 summary(null)
 recommendation(null)
 notified0
 accepted(null)
 conflict(null)
 statusUnsubmitted
 created2026-06-24 14:00:32
 modified2026-06-24 14:00:32
 Acceptance(empty)
 Amendment(empty)
 InvestigatorContact(array)
 0(array)
 id181
 application_id256
 given_namemercy
 middle_name
 family_namemercy
 qualificationqual
 professional_addressmkorir600+3@gmail.com
 telephone0734655152
 emailmkorir600+3@gmail.com
 investigator_roleprincipal
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 ApplicationStage(array)
 0(array)
 id342
 application_id256
 stageScreening
 start_date2026-06-09
 statusComplete
 commentManager assign reviewer
 end_date2026-06-10
 created2026-06-09 21:40:35
 modified2026-06-09 21:40:35
 1(array)
 id343
 application_id256
 stageScreeningSubmission
 start_date2026-06-10
 statusComplete
 commentFrom Manager assign
 end_date2026-06-10
 created2026-06-10 06:03:30
 modified2026-06-10 06:03:30
 2(array)
 id344
 application_id256
 stageAssign
 start_date2026-06-10
 statusComplete
 commentReviewer accept
 end_date2026-06-10
 created2026-06-10 06:03:30
 modified2026-06-10 06:03:30
 3(array)
 id345
 application_id256
 stageReview
 start_date2026-06-10
 statusComplete
 commentManager final decision
 end_date2026-06-10
 created2026-06-10 06:04:36
 modified2026-06-10 06:04:36
 4(array)
 id346
 application_id256
 stageReviewSubmission
 start_date2026-06-10
 statusComplete
 commentManager final decision
 end_date2026-06-10
 created2026-06-10 06:33:19
 modified2026-06-10 06:33:19
 5(array)
 id347
 application_id256
 stageFinalDecision
 start_date2026-06-10
 statusComplete
 commentManager final decision
 end_date2026-06-10
 created2026-06-10 06:33:19
 modified2026-06-10 06:33:19
 6(array)
 id348
 application_id256
 stageAnnualApproval
 start_date2026-06-10
 statusCurrent
 commentManager approve
 end_date2027-06-10
 created2026-06-10 06:33:19
 modified2026-06-10 06:33:19
 Pharmacist(array)
 0(array)
 id77
 application_id256
 reg_noPHR/2026/023
 given_namecyr
 premise_nameuniversity medical school
 qualificationqual
 professional_address123,klis
 valid_year2026
 mobile0712345678
 telephone0712345678
 emailspicemercy8+1@gmail.com
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 EthicalCommittee(array)
 0(array)
 id78
 application_id256
 ethical_committeeMoi Teaching and Referral Hospital/Moi University
 submission_date13-01-2026
 erc_numberERC/2026/0296
 initial_approval03-06-2026
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 AnnualLetter(array)
 0(array)
 id98
 application_id256
 approval_noPPB/ECCT/26/06/01/2026(7)
 type0
 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/26/06/01/2026(7) 10th June 2026 mercy mercy, Principal Investigator ECCT/26/06/01, mkorir600+3@gmail.com, Dear Sir/Madam, Re: ECCT/26/06/01 : Initial Approval; test sample :short_title. Reference is made to the above study. We acknowledge receipt of the following documents; <div style="margin-left: 15px;"> 1. Cover Letter (Should list all the submitted documents, their version numbers and dates) <a href="http://45.79.161.190:8080/attachments/download/2358">mlr_9.pdf</a> dated 9th June 2026 Version 1.0 2. The Study Protocol <a href="http://45.79.161.190:8080/attachments/download/2359">mlr_10.pdf</a> dated 9th June 2026 Version 1.0 3. Patient Information leaflet and Informed consent form <a href="http://45.79.161.190:8080/attachments/download/2360">mlr_11.pdf</a> dated 9th June 2026 Version 1.0 4. Investigators Brochure/Package inserts <a href="http://45.79.161.190:8080/attachments/download/2361">mlr_12.pdf</a> dated 9th June 2026 Version 1.0 5. GMP certificate of the investigational product from the site of manufacture <a href="http://45.79.161.190:8080/attachments/download/2362">mlr_13.pdf</a> dated 9th June 2026 Version 1.0 6. Signed investigator(s) CV(s) including that of study Pharmacist (NB: The CV should include the current workload of the Principal Investigator ) <a href="http://45.79.161.190:8080/attachments/download/2363">mlr_14.pdf</a> dated 9th June 2026 Version 1.0 7. 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="http://45.79.161.190:8080/attachments/export/1732"> click here </a> <a href="http://45.79.161.190:8080/attachments/download/2364">mlr_15.pdf</a> dated 9th June 2026 Version 1.0 8. Financial declaration by Sponsor and/or PI <a href="http://45.79.161.190:8080/attachments/export/1736">click here</a> <a href="http://45.79.161.190:8080/attachments/download/2365">mlr_16.pdf</a> dated 9th June 2026 Version 1.0 9. Clinical Trials Insurance cover for study participants <a href="http://45.79.161.190:8080/attachments/download/2366">mlr_17.pdf</a> dated 9th June 2026 Version 1.0 10. Copy of favorable opinion letter from the local Ethics Review Committee (ERC). <a href="http://45.79.161.190:8080/attachments/download/2367">mlr_18.pdf</a> dated 9th June 2026 Version 1.0 11. 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="http://45.79.161.190:8080/attachments/download/2368">mlr_19.pdf</a> dated 9th June 2026 Version 1.0 12. Payment of fees <a href="http://45.79.161.190:8080/attachments/download/2369">mlr_20.pdf</a> dated 9th June 2026 Version 1.0 </div> After review of the documents, the Pharmacy and Poisons Board Expert Committee on Clinical Trials notes the following: :reviewer_summary_comments The Pharmacy and Poisons Board Expert Committee on Clinical Trials grants approval to the study: test sample ECCT/26/06/01. 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 10th June 2027 <ol> <li> You should ensure compliance with Kenya Legal, regulatory and GCP requirements</li> <li> All safety reports should be submitted to ECCT as per the current PPB clinical trials guidelines</li> <li> 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> 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> <div> Yours Sincerely, </div> :signature :approver For Chief Executive Officer 
 qrcodePD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZlcnNpb249IjEuMSIgd2lkdGg9IjE1MCIgaGVpZ2h0PSIxNTAiIHZpZXdCb3g9IjAgMCAxNTAgMTUwIj48cmVjdCB4PSIwIiB5PSIwIiB3aWR0aD0iMTUwIiBoZWlnaHQ9IjE1MCIgZmlsbD0iI2ZmZmZmZiIvPjxnIHRyYW5zZm9ybT0ic2NhbGUoNC41NDUpIj48ZyB0cmFuc2Zvcm09InRyYW5zbGF0ZSgwLDApIj48cGF0aCBmaWxsLXJ1bGU9ImV2ZW5vZGQiIGQ9Ik05IDBMOSAyTDggMkw4IDhMOSA4TDkgOUwxMCA5TDEwIDhMMTEgOEwxMSAxMUwxMiAxMUwxMiAxM0wxMyAxM0wxMyAxMUwxMiAxMUwxMiA4TDEzIDhMMTMgOUwxNiA5TDE2IDEwTDE1IDEwTDE1IDExTDE0IDExTDE0IDEyTDE1IDEyTDE1IDExTDE2IDExTDE2IDEyTDE3IDEyTDE3IDExTDE2IDExTDE2IDEwTDE3IDEwTDE3IDlMMTkgOUwxOSAxMEwxOCAxMEwxOCAxMUwxOSAxMUwxOSAxMEwyMCAxMEwyMCA5TDIxIDlMMjEgMTBMMjIgMTBMMjIgMTFMMjEgMTFMMjEgMTJMMjIgMTJMMjIgMTNMMjAgMTNMMjAgMTRMMTggMTRMMTggMTZMMTcgMTZMMTcgMTVMMTYgMTVMMTYgMTZMMTcgMTZMMTcgMTdMMTYgMTdMMTYgMThMMTQgMThMMTQgMTdMMTUgMTdMMTUgMTVMMTQgMTVMMTQgMTZMMTIgMTZMMTIgMTVMMTMgMTVMMTMgMTRMMTIgMTRMMTIgMTVMMTAgMTVMMTAgMTRMOCAxNEw4IDEzTDEwIDEzTDEwIDEyTDggMTJMOCAxMUwxMCAxMUwxMCAxMEw4IDEwTDggOUw3IDlMNyA4TDIgOEwyIDlMMSA5TDEgOEwwIDhMMCAxMEwxIDEwTDEgMTFMMCAxMUwwIDE1TDEgMTVMMSAxNEwyIDE0TDIgMTZMMyAxNkwzIDE3TDEgMTdMMSAxNkwwIDE2TDAgMjBMMSAyMEwxIDE4TDYgMThMNiAxOUw0IDE5TDQgMjBMNSAyMEw1IDIxTDIgMjFMMiAyMkwzIDIyTDMgMjRMMiAyNEwyIDI1TDMgMjVMMyAyNEw1IDI0TDUgMjVMNyAyNUw3IDI0TDggMjRMOCAyMkw5IDIyTDkgMjFMMTAgMjFMMTAgMjBMMTEgMjBMMTEgMjFMMTMgMjFMMTMgMjJMMTAgMjJMMTAgMjNMOSAyM0w5IDI0TDEwIDI0TDEwIDI1TDggMjVMOCAyNkwxMSAyNkwxMSAyN0w4IDI3TDggMzFMOSAzMUw5IDMwTDEwIDMwTDEwIDI5TDExIDI5TDExIDMwTDEyIDMwTDEyIDI4TDExIDI4TDExIDI3TDEyIDI3TDEyIDI2TDExIDI2TDExIDI1TDEyIDI1TDEyIDI0TDEwIDI0TDEwIDIzTDEzIDIzTDEzIDIyTDE0IDIyTDE0IDIxTDEzIDIxTDEzIDE5TDE0IDE5TDE0IDIwTDE1IDIwTDE1IDI1TDE2IDI1TDE2IDI2TDE0IDI2TDE0IDI0TDEzIDI0TDEzIDI3TDE0IDI3TDE0IDI4TDE1IDI4TDE1IDI3TDE2IDI3TDE2IDI4TDE3IDI4TDE3IDI1TDE5IDI1TDE5IDI2TDE4IDI2TDE4IDI3TDE5IDI3TDE5IDI2TDIwIDI2TDIwIDI3TDIxIDI3TDIxIDI4TDIwIDI4TDIwIDI5TDE5IDI5TDE5IDI4TDE4IDI4TDE4IDI5TDE5IDI5TDE5IDMwTDE4IDMwTDE4IDMyTDE3IDMyTDE3IDMxTDE2IDMxTDE2IDMyTDE3IDMyTDE3IDMzTDIxIDMzTDIxIDMyTDIyIDMyTDIyIDMxTDIzIDMxTDIzIDMzTDMwIDMzTDMwIDMyTDMxIDMyTDMxIDMzTDMyIDMzTDMyIDMyTDMxIDMyTDMxIDMwTDMzIDMwTDMzIDI5TDMwIDI5TDMwIDI4TDMyIDI4TDMyIDI2TDMzIDI2TDMzIDI1TDMyIDI1TDMyIDI2TDMxIDI2TDMxIDI1TDMwIDI1TDMwIDI0TDMxIDI0TDMxIDIzTDMyIDIzTDMyIDI0TDMzIDI0TDMzIDIzTDMyIDIzTDMyIDIyTDMzIDIyTDMzIDIwTDMxIDIwTDMxIDE5TDMyIDE5TDMyIDE3TDMzIDE3TDMzIDE2TDMyIDE2TDMyIDE3TDI5IDE3TDI5IDE2TDMxIDE2TDMxIDE1TDMyIDE1TDMyIDE0TDMzIDE0TDMzIDExTDMyIDExTDMyIDEwTDMzIDEwTDMzIDlMMzIgOUwzMiAxMEwzMSAxMEwzMSA4TDI2IDhMMjYgOUwyNSA5TDI1IDVMMjQgNUwyNCA0TDI1IDRMMjUgM0wyNCAzTDI0IDJMMjUgMkwyNSAwTDIyIDBMMjIgMUwyMSAxTDIxIDNMMjAgM0wyMCAyTDE4IDJMMTggMEwxNiAwTDE2IDFMMTUgMUwxNSAwTDEzIDBMMTMgMkwxMiAyTDEyIDBaTTE5IDBMMTkgMUwyMCAxTDIwIDBaTTE2IDFMMTYgMkwxNCAyTDE0IDNMMTMgM0wxMyA0TDEyIDRMMTIgMkwxMSAyTDExIDRMMTAgNEwxMCAyTDkgMkw5IDVMMTAgNUwxMCA2TDkgNkw5IDdMMTAgN0wxMCA2TDExIDZMMTEgN0wxMiA3TDEyIDZMMTEgNkwxMSA0TDEyIDRMMTIgNUwxMyA1TDEzIDhMMTQgOEwxNCA1TDE1IDVMMTUgNEwxNiA0TDE2IDVMMTcgNUwxNyA3TDE2IDdMMTYgNkwxNSA2TDE1IDdMMTYgN0wxNiA5TDE3IDlMMTcgOEwxOCA4TDE4IDVMMTcgNUwxNyA0TDE5IDRMMTkgOUwyMCA5TDIwIDhMMjEgOEwyMSA5TDI0IDlMMjQgOEwyMSA4TDIxIDdMMjIgN0wyMiA2TDIzIDZMMjMgN0wyNCA3TDI0IDVMMjMgNUwyMyA0TDIyIDRMMjIgM0wyMSAzTDIxIDRMMTkgNEwxOSAzTDE3IDNMMTcgNEwxNiA0TDE2IDJMMTcgMkwxNyAxWk0yMiAxTDIyIDJMMjQgMkwyNCAxWk0xNCAzTDE0IDRMMTUgNEwxNSAzWk0yMSA0TDIxIDVMMjAgNUwyMCA3TDIxIDdMMjEgNkwyMiA2TDIyIDRaTTIgOUwyIDExTDQgMTFMNCAxMkwxIDEyTDEgMTNMNSAxM0w1IDE1TDYgMTVMNiAxNkw1IDE2TDUgMTdMNiAxN0w2IDE4TDggMThMOCAxOUw5IDE5TDkgMjBMMTAgMjBMMTAgMThMMTEgMThMMTEgMTdMMTIgMTdMMTIgMTZMMTEgMTZMMTEgMTdMMTAgMTdMMTAgMTVMOSAxNUw5IDE2TDggMTZMOCAxNEw3IDE0TDcgMTNMNSAxM0w1IDExTDYgMTFMNiAxMkw3IDEyTDcgMTFMNiAxMUw2IDEwTDcgMTBMNyA5TDYgOUw2IDEwTDUgMTBMNSA5TDQgOUw0IDEwTDMgMTBMMyA5Wk0yOCA5TDI4IDEwTDIzIDEwTDIzIDExTDIyIDExTDIyIDEyTDI0IDEyTDI0IDE0TDIzIDE0TDIzIDE1TDIyIDE1TDIyIDE0TDIwIDE0TDIwIDE1TDIyIDE1TDIyIDE2TDIxIDE2TDIxIDE3TDIwIDE3TDIwIDE4TDE5IDE4TDE5IDE3TDE4IDE3TDE4IDE5TDE5IDE5TDE5IDIwTDE3IDIwTDE3IDE5TDE2IDE5TDE2IDIwTDE3IDIwTDE3IDIxTDE2IDIxTDE2IDIyTDE3IDIyTDE3IDIzTDE2IDIzTDE2IDI1TDE3IDI1TDE3IDI0TDE4IDI0TDE4IDIyTDE3IDIyTDE3IDIxTDE5IDIxTDE5IDI0TDIxIDI0TDIxIDI1TDIwIDI1TDIwIDI2TDIxIDI2TDIxIDI3TDIyIDI3TDIyIDI2TDIzIDI2TDIzIDI1TDI0IDI1TDI0IDI0TDI1IDI0TDI1IDIzTDI0IDIzTDI0IDIyTDI2IDIyTDI2IDI0TDI5IDI0TDI5IDIxTDI3IDIxTDI3IDIwTDI4IDIwTDI4IDE4TDI5IDE4TDI5IDE5TDMwIDE5TDMwIDE4TDI5IDE4TDI5IDE3TDI4IDE3TDI4IDE4TDIyIDE4TDIyIDE3TDI3IDE3TDI3IDE2TDI5IDE2TDI5IDE1TDMwIDE1TDMwIDE0TDMxIDE0TDMxIDEyTDMwIDEyTDMwIDE0TDI5IDE0TDI5IDEzTDI4IDEzTDI4IDEwTDI5IDEwTDI5IDExTDMwIDExTDMwIDEwTDI5IDEwTDI5IDlaTTI0IDExTDI0IDEyTDI1IDEyTDI1IDE1TDI2IDE1TDI2IDE0TDI3IDE0TDI3IDEzTDI2IDEzTDI2IDEyTDI3IDEyTDI3IDExTDI2IDExTDI2IDEyTDI1IDEyTDI1IDExWk0xOCAxMkwxOCAxM0wxOSAxM0wxOSAxMlpNMTQgMTNMMTQgMTRMMTcgMTRMMTcgMTNaTTMgMTRMMyAxNUw0IDE1TDQgMTRaTTYgMTRMNiAxNUw3IDE1TDcgMTRaTTYgMTZMNiAxN0w4IDE3TDggMThMOSAxOEw5IDE3TDggMTdMOCAxNlpNMTIgMThMMTIgMTlMMTEgMTlMMTEgMjBMMTIgMjBMMTIgMTlMMTMgMTlMMTMgMThaTTIwIDE4TDIwIDE5TDIxIDE5TDIxIDIwTDI0IDIwTDI0IDIxTDIzIDIxTDIzIDIyTDI0IDIyTDI0IDIxTDI1IDIxTDI1IDIwTDI3IDIwTDI3IDE5TDI1IDE5TDI1IDIwTDI0IDIwTDI0IDE5TDIyIDE5TDIyIDE4Wk02IDE5TDYgMjBMNyAyMEw3IDE5Wk0xOSAyMEwxOSAyMUwyMCAyMUwyMCAyMFpNMzAgMjBMMzAgMjFMMzEgMjFMMzEgMjJMMzIgMjJMMzIgMjFMMzEgMjFMMzEgMjBaTTAgMjFMMCAyNUwxIDI1TDEgMjFaTTUgMjFMNSAyMkw0IDIyTDQgMjNMNSAyM0w1IDI0TDcgMjRMNyAyM0w2IDIzTDYgMjJMOCAyMkw4IDIxWk0yMSAyMUwyMSAyNEwyNCAyNEwyNCAyM0wyMiAyM0wyMiAyMVpNMjYgMjFMMjYgMjJMMjcgMjJMMjcgMjNMMjggMjNMMjggMjJMMjcgMjJMMjcgMjFaTTI1IDI1TDI1IDI4TDI4IDI4TDI4IDI1Wk0yOSAyNUwyOSAyOEwzMCAyOEwzMCAyNVpNMjYgMjZMMjYgMjdMMjcgMjdMMjcgMjZaTTIzIDI3TDIzIDI4TDIxIDI4TDIxIDI5TDIwIDI5TDIwIDMwTDE5IDMwTDE5IDMyTDIxIDMyTDIxIDMxTDIyIDMxTDIyIDI5TDIzIDI5TDIzIDMwTDI0IDMwTDI0IDMyTDI1IDMyTDI1IDMxTDI2IDMxTDI2IDMwTDI3IDMwTDI3IDI5TDI0IDI5TDI0IDI3Wk05IDI4TDkgMjlMMTAgMjlMMTAgMjhaTTEzIDI5TDEzIDMxTDExIDMxTDExIDMyTDEwIDMyTDEwIDMzTDExIDMzTDExIDMyTDEyIDMyTDEyIDMzTDE0IDMzTDE0IDMyTDE1IDMyTDE1IDMxTDE0IDMxTDE0IDI5Wk0xNSAyOUwxNSAzMEwxNyAzMEwxNyAyOVpNMjAgMzBMMjAgMzFMMjEgMzFMMjEgMzBaTTI4IDMwTDI4IDMxTDMwIDMxTDMwIDMwWk04IDMyTDggMzNMOSAzM0w5IDMyWk0wIDBMMCA3TDcgN0w3IDBaTTEgMUwxIDZMNiA2TDYgMVpNMiAyTDIgNUw1IDVMNSAyWk0yNiAwTDI2IDdMMzMgN0wzMyAwWk0yNyAxTDI3IDZMMzIgNkwzMiAxWk0yOCAyTDI4IDVMMzEgNUwzMSAyWk0wIDI2TDAgMzNMNyAzM0w3IDI2Wk0xIDI3TDEgMzJMNiAzMkw2IDI3Wk0yIDI4TDIgMzFMNSAzMUw1IDI4WiIgZmlsbD0iIzAwMDAwMCIvPjwvZz48L2c+PC9zdmc+Cg==
 approvermanager
 approval_date10-06-2026
 expiry_date10-06-2027
 statussubmitted
 deleted0
 deleted_date(null)
 created2026-06-10 06:33:19
 modified2026-06-10 06:33:19
 AmendmentLetter(empty)
 AmendmentApproval(empty)
 AmendmentApprovalSummary(empty)
 Organization(array)
 0(array)
 id77
 application_id256
 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)
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 SiteDetail(array)
 0(array)
 id1766
 application_id256
 county_id(null)
 site_name
 physical_address
 contact_details
 contact_person
 site_capacity(null)
 misc(null)
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 Placebo(array)
 0(array)
 id77
 application_id256
 placebo_present(null)
 pharmaceutical_form
 route_of_administration
 composition
 identical_indp
 major_ingredients
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 Sponsor(array)
 0(array)
 id78
 application_id256
 sponsormmust
 sponsor_typeResearch Institution
 contact_personHead of reseach mmust
 address123,kk
 telephone_number0712345678
 fax_number
 cell_number0712345678
 email_addressreasearch@gmail.com
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 SiteInspection(array)
 0(array)
 id69
 application_id256
 user_id871
 reference_noSI/2026/07
 study_title antimalaria2
 protocol_noECCT/26/06/01
 version_no(null)
 pactr_number
 trial_phaseHuman pharmacology (Phase I) : First administration to humansBioequivalence study
 investigatorslucy lucy Tel: 0712345678 Email: spicemercy8+1@gmail.com
 co_investigators1 mercy mercy Email: mkorir600+3@gmail.com
 study_stageBefore trial commencement
 inspection_countryKenya
 inspector_namesMercy-GCP Inspector
 inspection_dates10/06/20206
 site_address123,kk
 sponsor_address12,gr
 lab_addressaddress
 events_summaryrret
 conclusion(null)
 summary_report(null)
 outcome(null)
 approved1
 summary_approved0
 approved_by(null)
 sent_to_pi0
 deleted0
 deleted_date(null)
 created2026-06-10 15:52:03
 modified2026-06-10 15:58:12
 Sae(array)
 0(array)
 id39
 application_id256
 sae_id(null)
 reference_noSAE/2026/01
 form_typeSAE
 user_id869
 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
 date_submitted(null)
 approved_by(null)
 email_addressmkorir600+3@gmail.com
 reporter_name(null)
 reporter_phone(null)
 reporter_emailmkorir600+3@gmail.com
 deleted0
 deleted_date(null)
 created2026-06-10 09:31:02
 modified2026-06-10 09:31:02
 1(array)
 id40
 application_id256
 sae_id(null)
 reference_noSAE/2026/02
 form_typeSAE
 user_id869
 patient_initialsMJK
 country_id115
 date_of_birth08-06-2000
 age_years26
 genderFemale
 causalityProbable/Likely
 enrollment_date02-01-2026
 administration_date09-01-2026
 latest_date29-04-2026
 reaction_onset19-05-2026
 reaction_end_date03-06-2026
 patient_died0
 prolonged_hospitalization0
 incapacity1
 life_threatening1
 reaction_other0
 reaction_description3ewdef
 relevant_historyVFDD
 manufacturer_nameaddress
 mfr_noMFR/2023/0567
 manufacturer_date02-01-2026
 source_study1
 source_literature0
 source_health_professional0
 report_date(null)
 report_typeInitial
 approved1
 date_submitted2026-06-16 11:10:03
 approved_by(null)
 email_addressmkorir600+3@gmail.com
 reporter_namemcy
 reporter_phone0712345678
 reporter_emailmkorir600+3@gmail.com
 deleted0
 deleted_date(null)
 created2026-06-11 14:45:41
 modified2026-06-16 11:10:03
 2(array)
 id41
 application_id256
 sae_id(null)
 reference_noSAE/2026/03
 form_typeSAE
 user_id869
 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
 date_submitted(null)
 approved_by(null)
 email_addressmkorir600+3@gmail.com
 reporter_name(null)
 reporter_phone(null)
 reporter_emailmkorir600+3@gmail.com
 deleted0
 deleted_date(null)
 created2026-06-15 13:55:10
 modified2026-06-15 13:55:10
 3(array)
 id43
 application_id256
 sae_id(null)
 reference_noSAE/2026/05
 form_typeSAE
 user_id869
 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
 date_submitted(null)
 approved_by(null)
 email_addressmkorir600+3@gmail.com
 reporter_name(null)
 reporter_phone(null)
 reporter_emailmkorir600+3@gmail.com
 deleted0
 deleted_date(null)
 created2026-06-17 10:43:38
 modified2026-06-17 10:43:38
 Ciom(empty)
 StudyRoute(array)
 0(array)
 id561
 application_id256
 study_routerectal
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 Manufacturer(array)
 0(array)
 id77
 application_id256
 manufacturer_nameBid
 address23,carlif
 manufacturer_countryKenya
 manufacturer_phone0712345678
 manufacturer_emailspicemercy8@gmail.com
 manufacturing_activitiesPartial manufacturing
 other_specify
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 Reassignment(empty)
 Attachment(empty)
 AnnualApproval(empty)
 AmendmentChecklist(empty)
 Reminder(empty)
 ParticipantFlow(empty)
 Budget(array)
 0(array)
 id77
 application_id256
 year(null)
 budget_period(null)
 personnel_currencyKES
 personnel10000
 transport_currencyKES
 transport10000
 field_currencyKES
 field10000
 supplies_currencyKES
 supplies10000
 pharmacy_currencyKES
 pharmacy10000
 travel_currencyKES
 travel10000
 regulatory_currencyKES
 regulatory10000
 it_currencyKES
 it10000
 lab_currency(null)
 lab(null)
 others_currencyKES
 others10000
 kemri_currency(null)
 kemri(null)
 wrair_currency(null)
 wrair(null)
 subject_currencyKES
 subject10000
 grand_currencyKES
 grand_total10000
 study_informationnbnb
 personnel_kshs10000
 transport_kshs10000
 field_kshs10000
 supplies_kshs10000
 pharmacy_kshs10000
 travel_kshs10000
 regulatory_kshs10000
 it_kshs10000
 lab_kshs(null)
 others_kshs10000
 grand_total_kshs10000
 subject_kshs10000
 created2026-06-09 21:16:53
 modified2026-06-09 21:40:35
 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(array)
 0(array)
 id2358
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_9.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_9.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_covering_letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates) *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_covering_letter
 version_no1.0
 created2026-06-09 21:34:19
 modified2026-06-09 21:40:35
 pathdoc/mlr_9.pdf
 1(array)
 id2359
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_10.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_10.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_protocol
 descriptionThe Study Protocol *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_protocol
 version_no1.0
 created2026-06-09 21:35:02
 modified2026-06-09 21:35:02
 pathdoc/mlr_10.pdf
 2(array)
 id2360
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_11.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_11.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_patient_information
 descriptionPatient Information leaflet and Informed consent form *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_patient_information
 version_no1.0
 created2026-06-09 21:35:32
 modified2026-06-09 21:35:32
 pathdoc/mlr_11.pdf
 3(array)
 id2361
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_12.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_12.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_investigators_brochure
 descriptionInvestigators Brochure/Package inserts *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_investigators_brochure
 version_no1.0
 created2026-06-09 21:35:52
 modified2026-06-09 21:35:52
 pathdoc/mlr_12.pdf
 4(array)
 id2362
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_13.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_13.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_gmp_certificate
 descriptionGMP certificate of the investigational product from the site of manufacture *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_gmp_certificate
 version_no1.0
 created2026-06-09 21:36:23
 modified2026-06-09 21:36:23
 pathdoc/mlr_13.pdf
 5(array)
 id2363
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_14.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_14.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 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_date09-06-2026
 pocket_nameapplicant_investigators_cv
 version_no1.0
 created2026-06-09 21:37:23
 modified2026-06-09 21:37:23
 pathdoc/mlr_14.pdf
 6(array)
 id2364
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_15.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_15.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 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. click here *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_signed_declaration
 version_no1.0
 created2026-06-09 21:38:12
 modified2026-06-09 21:38:12
 pathdoc/mlr_15.pdf
 7(array)
 id2365
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_16.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_16.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_financial_declaration
 descriptionFinancial declaration by Sponsor and/or PI click here *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_financial_declaration
 version_no1.0
 created2026-06-09 21:38:14
 modified2026-06-09 21:38:14
 pathdoc/mlr_16.pdf
 8(array)
 id2366
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_17.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_17.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_indemnity_cover
 descriptionClinical Trials Insurance cover for study participants *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_indemnity_cover
 version_no1.0
 created2026-06-09 21:38:39
 modified2026-06-09 21:38:39
 pathdoc/mlr_17.pdf
 9(array)
 id2367
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_18.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_18.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_opinion_letter
 descriptionCopy of favorable opinion letter from the local Ethics Review Committee (ERC). *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_opinion_letter
 version_no1.0
 created2026-06-09 21:39:13
 modified2026-06-09 21:39:13
 pathdoc/mlr_18.pdf
 10(array)
 id2368
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_19.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_19.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 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_date09-06-2026
 pocket_nameapplicant_statement
 version_no1.0
 created2026-06-09 21:39:37
 modified2026-06-09 21:39:37
 pathdoc/mlr_19.pdf
 11(array)
 id2369
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/mlr_20.pdf
 foreign_key256
 dirnamedoc
 basenamemlr_20.pdf
 checksuma53cd2c6706cb70a5c7e4f48d0f02d77
 alternative(null)
 groupapplicant_fees
 descriptionPayment of fees *
 year(null)
 file_date09-06-2026
 pocket_nameapplicant_fees
 version_no1.0
 created2026-06-09 21:39:59
 modified2026-06-09 21:40:04
 pathdoc/mlr_20.pdf
 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)
 InternalReview(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/ctr/app/webroot/media/'
MEDIA_STATIC	'/var/www/ctr/app/webroot/media/static/'
MEDIA_FILTER	'/var/www/ctr/app/webroot/media/filter/'
MEDIA_TRANSFER	'/var/www/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	'45.79.161.190:8080'
HTTP_BASE	'http://45.79.161.190:8080'
HTTP_SELF	'/app/webroot/index.php'
HTTP_URI	'/applications/view/256'
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/ctr/app/files/'
LOCALE	'/var/www/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/ctr/app/'
APP_DIR	'app'
APPLIBS	'/var/www/ctr/app/Lib/'
CACHE	'/var/www/ctr/app/tmp/cache/'
CAKE	'/var/www/ctr/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/var/www/ctr/lib'
CORE_PATH	'/var/www/ctr/lib/'
CAKE_VERSION	'2.2.2'
CSS	'/var/www/ctr/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'http://45.79.161.190:8080'
IMAGES	'/var/www/ctr/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/var/www/ctr/app/webroot/js/'
JS_URL	'js/'
LOGS	'/var/www/ctr/app/tmp/logs/'
ROOT	'/var/www/ctr'
TESTS	'/var/www/ctr/app/Test/'
TMP	'/var/www/ctr/app/tmp/'
VENDORS	'/var/www/ctr/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/var/www/ctr/app/webroot/'

PHP Environment

Environment Variable	Value
Php Version	'5.6.40-63+ubuntu18.04.1+deb.sury.org+2'
Redirect Redirect Status	'200'
Redirect Status	'200'
Http Accept	'/'
Http User Agent	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
Http Cookie	'CAKEPHP=v8defreabjk6spv1fi7mptbh22'
Http Accept Encoding	'gzip, br, zstd, deflate'
Http Host	'45.79.161.190:8080'
Http Via	'1.1 squid-proxy-5b96dc6d46-6lvkr (squid/6.13)'
Http X Forwarded For	'10.1.74.197'
Http Cache Control	'max-age=259200'
Http Connection	'keep-alive'
Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
Server Signature	' Apache/2.4.41 (Ubuntu) Server at 45.79.161.190 Port 8080 '
Server Software	'Apache/2.4.41 (Ubuntu)'
Server Name	'45.79.161.190'
Server Addr	'45.79.161.190'
Server Port	'8080'
Remote Addr	'216.73.217.16'
Document Root	'/var/www/ctr'
Request Scheme	'http'
Context Prefix	''
Context Document Root	'/var/www/ctr'
Server Admin	'webmaster@localhost'
Script Filename	'/var/www/ctr/app/webroot/index.php'
Remote Port	'17553'
Redirect Url	'/app/webroot/applications/view/256'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/applications/view/256'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1783062807.881
Request Time	(int) 1783062807

====

Include
+
Included Files

Include Paths
- 0/var/www/ctr/app/Plugin/Media/Lib/mm/src
- 1/var/www/ctr/lib
- 3/usr/share/php
- 4-> /var/www/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/Memory.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:	antimalaria2
Study Objectives:	To evaluate the safety and effectiveness of a new antimalarial drug in treating uncomplicated malaria.
Laymans Summary:	Malaria remains a major health challenge in many countries. This study aims to evaluate a new treatment for malaria and compare it with the current standard treatment. Adults diagnosed with uncomplicated malaria will be invited to participate and will be randomly assigned to receive either the new treatment or the standard treatment.
Abstract of Study:	Malaria continues to be a significant public health concern, particularly in regions where the disease is endemic. New treatment options are needed to improve patient outcomes and address emerging drug resistance.

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 49 ms Total Queries: 54 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 49 ms
Total Queries: 54 queries