Pharmacy and Poisons Board: Applications

History
+
Request History
2 previous requests available
====
Session
+
Session
- Config(array)
  userAgent9c3d2c89526db53b7b69e8c9faa06145
  time1756500206
  countdown10
====
Request
+
Request

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

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `ctr`.`applications` AS `Application` WHERE `Application`.`id` = 11	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`, `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` = 11 AND `Application`.`deleted` = '0' LIMIT 1	1	1	2	maybe slow
SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`application_id`, `Review`.`type`, `Review`.`assessment_type`, `Review`.`title`, `Review`.`text`, `Review`.`summary`, `Review`.`recommendation`, `Review`.`notified`, `Review`.`accepted`, `Review`.`conflict`, `Review`.`status`, `Review`.`created`, `Review`.`modified` FROM `ctr`.`reviews` AS `Review` WHERE `Review`.`application_id` = (11)	2	2	1	maybe slow
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` = (11)	1	1	1
SELECT `ManagerReview`.`id`, `ManagerReview`.`user_id`, `ManagerReview`.`application_id`, `ManagerReview`.`type`, `ManagerReview`.`assessment_type`, `ManagerReview`.`title`, `ManagerReview`.`text`, `ManagerReview`.`summary`, `ManagerReview`.`recommendation`, `ManagerReview`.`notified`, `ManagerReview`.`accepted`, `ManagerReview`.`conflict`, `ManagerReview`.`status`, `ManagerReview`.`created`, `ManagerReview`.`modified` FROM `ctr`.`reviews` AS `ManagerReview` WHERE `ManagerReview`.`application_id` = (11)	2	2	0
SELECT `Acceptance`.`id`, `Acceptance`.`user_id`, `Acceptance`.`application_id`, `Acceptance`.`type`, `Acceptance`.`assessment_type`, `Acceptance`.`title`, `Acceptance`.`text`, `Acceptance`.`summary`, `Acceptance`.`recommendation`, `Acceptance`.`notified`, `Acceptance`.`accepted`, `Acceptance`.`conflict`, `Acceptance`.`status`, `Acceptance`.`created`, `Acceptance`.`modified` FROM `ctr`.`reviews` AS `Acceptance` WHERE `Acceptance`.`type` = 'acceptance' AND `Acceptance`.`application_id` = (11)	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` = (11)	1	1	4	maybe slow
SELECT `InvestigatorContact`.`id`, `InvestigatorContact`.`application_id`, `InvestigatorContact`.`given_name`, `InvestigatorContact`.`middle_name`, `InvestigatorContact`.`family_name`, `InvestigatorContact`.`qualification`, `InvestigatorContact`.`professional_address`, `InvestigatorContact`.`telephone`, `InvestigatorContact`.`email`, `InvestigatorContact`.`created`, `InvestigatorContact`.`modified` FROM `ctr`.`investigator_contacts` AS `InvestigatorContact` WHERE `InvestigatorContact`.`application_id` = (11)	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` = (11)	8	8	1	maybe slow
SELECT `Pharmacist`.`id`, `Pharmacist`.`application_id`, `Pharmacist`.`reg_no`, `Pharmacist`.`given_name`, `Pharmacist`.`premise_name`, `Pharmacist`.`qualification`, `Pharmacist`.`professional_address`, `Pharmacist`.`valid_year`, `Pharmacist`.`mobile`, `Pharmacist`.`telephone`, `Pharmacist`.`email`, `Pharmacist`.`created`, `Pharmacist`.`modified` FROM `ctr`.`pharmacists` AS `Pharmacist` WHERE `Pharmacist`.`application_id` = (11)	1	1	1
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` = (11)	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` = (11)	2	2	1	maybe slow
SELECT `AmendmentLetter`.`id`, `AmendmentLetter`.`application_id`, `AmendmentLetter`.`approval_no`, `AmendmentLetter`.`content`, `AmendmentLetter`.`qrcode`, `AmendmentLetter`.`approver`, `AmendmentLetter`.`approval_date`, `AmendmentLetter`.`expiry_date`, `AmendmentLetter`.`status`, `AmendmentLetter`.`submitted`, `AmendmentLetter`.`deleted`, `AmendmentLetter`.`deleted_date`, `AmendmentLetter`.`created`, `AmendmentLetter`.`modified` FROM `ctr`.`amendment_letters` AS `AmendmentLetter` WHERE `AmendmentLetter`.`application_id` = (11)	0	0	1	maybe slow
SELECT `AmendmentApproval`.`id`, `AmendmentApproval`.`application_id`, `AmendmentApproval`.`approval_no`, `AmendmentApproval`.`amendment`, `AmendmentApproval`.`content`, `AmendmentApproval`.`approver`, `AmendmentApproval`.`approval_date`, `AmendmentApproval`.`status`, `AmendmentApproval`.`deleted`, `AmendmentApproval`.`deleted_date`, `AmendmentApproval`.`created`, `AmendmentApproval`.`modified` FROM `ctr`.`amendment_approvals` AS `AmendmentApproval` WHERE `AmendmentApproval`.`application_id` = (11)	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` = (11)	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` = (11)	1	1	1
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` = (11)	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` = (11)	1	1	1
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` = (11)	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` = (11)	3	3	1	maybe slow
SELECT `Sae`.`id`, `Sae`.`application_id`, `Sae`.`sae_id`, `Sae`.`reference_no`, `Sae`.`form_type`, `Sae`.`user_id`, `Sae`.`patient_initials`, `Sae`.`country_id`, `Sae`.`date_of_birth`, `Sae`.`age_years`, `Sae`.`gender`, `Sae`.`causality`, `Sae`.`enrollment_date`, `Sae`.`administration_date`, `Sae`.`latest_date`, `Sae`.`reaction_onset`, `Sae`.`reaction_end_date`, `Sae`.`patient_died`, `Sae`.`prolonged_hospitalization`, `Sae`.`incapacity`, `Sae`.`life_threatening`, `Sae`.`reaction_other`, `Sae`.`reaction_description`, `Sae`.`relevant_history`, `Sae`.`manufacturer_name`, `Sae`.`mfr_no`, `Sae`.`manufacturer_date`, `Sae`.`source_study`, `Sae`.`source_literature`, `Sae`.`source_health_professional`, `Sae`.`report_date`, `Sae`.`report_type`, `Sae`.`approved`, `Sae`.`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` = (11)	0	0	1	maybe slow
SELECT `Ciom`.`id`, `Ciom`.`application_id`, `Ciom`.`reference_no`, `Ciom`.`user_id`, `Ciom`.`reporter_email`, `Ciom`.`e2b_content`, `Ciom`.`e2b_file`, `Ciom`.`file`, `Ciom`.`dirname`, `Ciom`.`basename`, `Ciom`.`checksum`, `Ciom`.`alternative`, `Ciom`.`group`, `Ciom`.`description`, `Ciom`.`created`, `Ciom`.`modified` FROM `ctr`.`cioms` AS `Ciom` WHERE `Ciom`.`application_id` = (11)	0	0	1	maybe slow
SELECT `StudyRoute`.`id`, `StudyRoute`.`application_id`, `StudyRoute`.`study_route`, `StudyRoute`.`created`, `StudyRoute`.`modified` FROM `ctr`.`study_routes` AS `StudyRoute` WHERE `StudyRoute`.`application_id` = (11)	1	1	1
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` = (11)	1	1	1
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` = (11)	0	0	1	maybe slow
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`file`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`description`, `Attachment`.`year`, `Attachment`.`file_date`, `Attachment`.`pocket_name`, `Attachment`.`version_no`, `Attachment`.`created`, `Attachment`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Attachment__path` FROM `ctr`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Application' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (11)	0	0	3	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` = (11)	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` = (11)	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` = (11)	0	0	1	maybe slow
SELECT `ParticipantFlow`.`id`, `ParticipantFlow`.`application_id`, `ParticipantFlow`.`year`, `ParticipantFlow`.`original_subjects`, `ParticipantFlow`.`consented`, `ParticipantFlow`.`screened`, `ParticipantFlow`.`enrolled`, `ParticipantFlow`.`lost`, `ParticipantFlow`.`lost_reason`, `ParticipantFlow`.`withdrawn`, `ParticipantFlow`.`withdrawal_reason`, `ParticipantFlow`.`self_withdrawal`, `ParticipantFlow`.`self_withdrawal_reasons`, `ParticipantFlow`.`active_subjects`, `ParticipantFlow`.`completed_number`, `ParticipantFlow`.`created`, `ParticipantFlow`.`modified` FROM `ctr`.`participant_flows` AS `ParticipantFlow` WHERE `ParticipantFlow`.`application_id` = (11)	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` = (11)	1	1	1
SELECT `Deviation`.`id`, `Deviation`.`application_id`, `Deviation`.`user_id`, `Deviation`.`reference_no`, `Deviation`.`study_title`, `Deviation`.`deviation_type`, `Deviation`.`deviation_type_dev`, `Deviation`.`pi_name`, `Deviation`.`deviation_date`, `Deviation`.`participant_number`, `Deviation`.`treating_physician`, `Deviation`.`deviation_description`, `Deviation`.`deviation_explanation`, `Deviation`.`deviation_measures`, `Deviation`.`deviation_preclude`, `Deviation`.`sponsor_notified`, `Deviation`.`sponsor_explanation`, `Deviation`.`study_impact`, `Deviation`.`status`, `Deviation`.`deleted`, `Deviation`.`deleted_date`, `Deviation`.`created`, `Deviation`.`modified` FROM `ctr`.`deviations` AS `Deviation` WHERE `Deviation`.`application_id` = (11)	1	1	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` = (11)	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` = (11)	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` = (11)	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` = (11)	0	0	2	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` = (11)	0	0	2	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	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` = (11)	28	28	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` = (11)	0	0	1	maybe slow
SELECT `ProtocolOutsource`.`id`, `ProtocolOutsource`.`user_id`, `ProtocolOutsource`.`application_id`, `ProtocolOutsource`.`outsource_id`, `ProtocolOutsource`.`owner_id`, `ProtocolOutsource`.`created`, `ProtocolOutsource`.`modified` FROM `ctr`.`protocol_outsources` AS `ProtocolOutsource` WHERE `ProtocolOutsource`.`user_id` = (11)	0	0	1	maybe slow
SELECT `Outsource`.`id`, `Outsource`.`application_id`, `Outsource`.`user_id`, `Outsource`.`model`, `Outsource`.`username`, `Outsource`.`name`, `Outsource`.`email`, `Outsource`.`phone_no`, `Outsource`.`institution_physical`, `Outsource`.`name_of_institution`, `Outsource`.`institution_address`, `Outsource`.`institution_contact`, `Outsource`.`county_id`, `Outsource`.`country_id`, `Outsource`.`approved`, `Outsource`.`created`, `Outsource`.`modified`, `Outsource`.`accepted`, `Outsource`.`model_sae`, `Outsource`.`model_ciom`, `Outsource`.`model_dev` FROM `ctr`.`outsources` AS `Outsource` WHERE `Outsource`.`application_id` = (11)	1	1	1

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.45 MB

Message	Memory use
Component initialization	2.40 MB
Controller action start	3.58 MB
Controller render start	8.04 MB
View render complete	8.47 MB

Timers

Total Request Time: 181 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	10.01
Event: Controller.initialize	0.40
Event: Controller.startup	0.44
Controller action	107.53
Event: Controller.beforeRender	15.68
» Processing toolbar data	15.58
Rendering View	2.67
» Event: View.beforeRender	0.03
» Rendering APP/View/Applications/view.ctp	0.36
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.91
» » 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)
 id11
 user_id31
 application_id(null)
 is_child0
 trial_status_id3
 total_sites(null)
 abstract_of_study TBD
 study_title Maanzoni test
 laymans_summary testing 
 short_titlemt
 protocol_noECCT/24/02/01
 reference_no(null)
 version_nov
 date_of_protocol09-02-2024
 study_drugVERICITOLOL IMP
 disease_conditionresp
 product_type_biologicals0
 product_type_proteins0
 product_type_immunologicals0
 product_type_vaccines0
 product_type_hormones0
 product_type_toxoid0
 product_type_chemical1
 product_type_medical_device0
 product_type_chemical_nameVericit
 product_type_medical_device_name
 comparatorNo
 comparator_name
 comparator_registered
 comparator_countries
 ecct_not_applicable0
 ecct_ref_number
 email_addressskerama@ppb.go.ke
 applicant_covering_letter1
 applicant_protocol1
 applicant_patient_information1
 applicant_investigators_brochure1
 applicant_investigators_cv1
 applicant_signed_declaration1
 applicant_financial_declaration1
 applicant_gmp_certificate1
 applicant_indemnity_cover1
 applicant_opinion_letter1
 applicant_approval_letter1
 applicant_statement1
 applicant_participating_countries(null)
 applicant_addendum1
 applicant_fees1
 applicant_complete_form(null)
 applicant_impd1
 applicant_prev_data1
 applicant_stability_data1
 applicant_analysis_cert1
 applicant_pictorial_sample1
 applicant_gcp_training1
 applicant_dsmb_charter1
 applicant_detailed_budget1
 applicant_indemnity_pi1
 applicant_practice_license1
 applicant_registration_ctr(null)
 applicant_pan_african1
 applicant_hard_copies(null)
 applicant_signed_checklist1
 statistical_analysis_plan1
 applicant_contractual_agreement1
 declaration_applicantSK
 declaration_date102-02-2024
 declaration_principal_investigatorKerr
 declaration_date201-02-2024
 placebo_presentNo
 study_objectives efficacy
 principal_inclusion_criteria age 
 principal_exclusion_criteria co-morbid
 primary_end_points Improved respiration
 scope_diagnosis0
 scope_prophylaxis0
 scope_therapy0
 scope_safety0
 scope_efficacy1
 scope_pharmacokinetic0
 scope_pharmacodynamic0
 scope_bioequivalence0
 scope_dose_response0
 scope_pharmacogenetic0
 scope_pharmacogenomic0
 scope_pharmacoecomomic0
 scope_others0
 scope_others_specify
 trial_human_pharmacology0
 trial_administration_humans0
 trial_bioequivalence_study0
 trial_other0
 trial_other_specify
 trial_therapeutic_exploratory0
 trial_therapeutic_confirmatory1
 trial_therapeutic_use0
 design_controlledYes
 site_capacity(null)
 staff_numbers PPB labs has sufficient facilities and staff for the study
 other_details_explanation N/a
 other_details_regulatory_notapproved none 
 other_details_regulatory_approved none
 other_details_regulatory_rejected
 other_details_regulatory_halted
 estimated_duration2 years
 design_controlled_randomisedYes
 design_controlled_openNo
 design_controlled_single_blindNo
 design_controlled_double_blindYes
 design_controlled_parallel_groupYes
 design_controlled_cross_overNo
 design_controlled_otherNo
 design_controlled_specify
 design_controlled_comparatorOxygen
 design_controlled_other_medicinalNo
 design_controlled_placeboNo
 design_controlled_medicinal_otherNo
 design_controlled_medicinal_specify
 single_site_member_stateYes
 location_of_areaPPB Labs
 single_site_physical_addressLenana rd
 single_site_contact_personSK
 single_site_telephone123
 multiple_sites_member_stateNo
 multiple_countriesNo
 multiple_member_states
 number_of_sites
 multi_country_list
 data_monitoring_committeeYes
 total_enrolment_per_site123
 total_participants_worldwide123
 population_less_than_18_yearsNo
 population_uteroNo
 population_preterm_newbornNo
 population_newbornNo
 population_infant_and_toddlerNo
 population_childrenNo
 population_adolescentNo
 population_above_18Yes
 population_adultNo
 population_elderlyNo
 gender_female0
 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_namejj
 investigator1_middle_name
 investigator1_family_nameabc
 investigator1_qualificationM.Pharm
 investigator1_professional_address324
 investigator1_telephone0711111111
 investigator1_emailskerama@ppb.co.ke
 organisations_transferred_No
 number_participants123
 notification ghj
 approval_date06-01-2025
 submitted1
 deleted0
 deleted_date2024-02-21 21:39:13
 deactivated0
 date_submitted31-05-2024
 unsubmitted1
 initial_date_submitted09-02-2024
 admin_stopped1
 admin_stopped_reasonStopped by admin
 approved2
 approved_reasonSample Message
 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_invoice(null)
 modified2025-01-06 10:18:43
 created2024-02-09 05:53:28
 User(array)
 id31
 usernamePrincipal
 password6ceb12322e689b2ccbe6d689757646f85ad2bc00
 confirm_password6ceb12322e689b2ccbe6d689757646f85ad2bc00
 nameP.I
 emailskerama@ppb.go.ke
 national_id_number(null)
 sponsor(null)
 sponsor_emailskerama@ppb.go.ke
 qualification
 phone_no0720251162
 name_of_institution
 institution_physicalPPB Lenana road
 institution_address
 institution_contact
 county_id47
 country_id115
 group_id5
 activation_key(null)
 forgot_password(null)
 is_active1
 deactivated0
 created2024-01-23 13:15:10
 modified2024-02-09 05:53:09
 TrialStatus(array)
 id3
 valueSuspended
 nameSuspended
 created2012-10-19 16:08:38
 modified2020-04-16 10:03:55
 Review(array)
 0(array)
 id8
 user_id2
 application_id11
 typeppb_comment
 assessment_type(null)
 title(null)
 text sample comment here 
 summary(null)
 recommendation sample recommendation here 
 notified0
 accepted(null)
 conflict(null)
 statusUnsubmitted
 created2025-01-06 10:10:45
 modified2025-01-06 10:10:45
 1(array)
 id9
 user_id2
 application_id11
 typeppb_comment
 assessment_type(null)
 title(null)
 text wrong password comment
 summary(null)
 recommendation wrong pass recommendation
 notified0
 accepted(null)
 conflict(null)
 statusUnsubmitted
 created2025-01-06 10:11:22
 modified2025-01-06 10:11:22
 ActiveInspector(array)
 0(array)
 id2
 user_id33
 application_id11
 typerequest
 assessment_type(null)
 titlePPB request
 text
 summary(null)
 recommendationhey
 notified0
 accepteddeclined
 conflictNo
 statusUnsubmitted
 created2024-02-21 21:22:44
 modified2024-02-21 21:22:44
 ManagerReview(array)
 0(array)
 id8
 user_id2
 application_id11
 typeppb_comment
 assessment_type(null)
 title(null)
 text sample comment here 
 summary(null)
 recommendation sample recommendation here 
 notified0
 accepted(null)
 conflict(null)
 statusUnsubmitted
 created2025-01-06 10:10:45
 modified2025-01-06 10:10:45
 1(array)
 id9
 user_id2
 application_id11
 typeppb_comment
 assessment_type(null)
 title(null)
 text wrong password comment
 summary(null)
 recommendation wrong pass recommendation
 notified0
 accepted(null)
 conflict(null)
 statusUnsubmitted
 created2025-01-06 10:11:22
 modified2025-01-06 10:11:22
 Acceptance(empty)
 Amendment(array)
 0(array)
 id3
 application_id11
 trial_status_id(null)
 abstract_of_study(null)
 study_title(null)
 laymans_summary(null)
 protocol_no(null)
 version_no(null)
 date_of_protocol(null)
 study_drug(null)
 disease_condition(null)
 product_type(null)
 product_type_biologicals(null)
 product_type_proteins(null)
 product_type_immunologicals(null)
 product_type_vaccines(null)
 product_type_hormones(null)
 product_type_toxoid(null)
 product_type_chemical(null)
 product_type_medical_device(null)
 product_type_chemical_name(null)
 product_type_medical_device_name(null)
 comparator(null)
 comparator_name(null)
 comparator_registered(null)
 comparator_countries(null)
 previous_dates(null)
 coordinating_investigators(null)
 principal_investigators(null)
 pharmacist(null)
 sponsor_details(null)
 gender(null)
 details_of_sites(null)
 placebos(null)
 scopes(null)
 organizations(null)
 types_and_phases(null)
 ecct_not_applicable0
 ecct_ref_number
 email_address(null)
 applicant_covering_letter(null)
 applicant_protocol(null)
 applicant_patient_information(null)
 applicant_investigators_brochure(null)
 applicant_investigators_cv(null)
 applicant_signed_declaration(null)
 applicant_financial_declaration(null)
 applicant_gmp_certificate(null)
 applicant_indemnity_cover(null)
 applicant_opinion_letter(null)
 applicant_approval_letter(null)
 applicant_statement(null)
 applicant_participating_countries(null)
 applicant_addendum(null)
 applicant_fees(null)
 declaration_applicant(null)
 declaration_date1(null)
 declaration_principal_investigator(null)
 declaration_date2(null)
 placebo_present(null)
 study_objectives(null)
 principal_inclusion_criteria(null)
 principal_exclusion_criteria(null)
 primary_end_points(null)
 scope_diagnosis(null)
 scope_prophylaxis(null)
 scope_therapy(null)
 scope_safety(null)
 scope_efficacy(null)
 scope_pharmacokinetic(null)
 scope_pharmacodynamic(null)
 scope_bioequivalence(null)
 scope_dose_response(null)
 scope_pharmacogenetic(null)
 scope_pharmacogenomic(null)
 scope_pharmacoecomomic(null)
 scope_others(null)
 scope_others_specify(null)
 trial_human_pharmacology(null)
 trial_administration_humans(null)
 trial_bioequivalence_study(null)
 trial_other(null)
 trial_other_specify(null)
 trial_therapeutic_exploratory(null)
 trial_therapeutic_confirmatory(null)
 trial_therapeutic_use(null)
 design_controlled(null)
 site_capacity(null)
 staff_numbers(null)
 other_details_explanation(null)
 other_details_regulatory_notapproved(null)
 other_details_regulatory_approved(null)
 other_details_regulatory_rejected(null)
 other_details_regulatory_halted(null)
 estimated_duration(null)
 design_controlled_randomised(null)
 design_controlled_open(null)
 design_controlled_single_blind(null)
 design_controlled_double_blind(null)
 design_controlled_parallel_group(null)
 design_controlled_cross_over(null)
 design_controlled_other(null)
 design_controlled_specify(null)
 design_controlled_comparator(null)
 design_controlled_other_medicinal(null)
 design_controlled_placebo(null)
 design_controlled_medicinal_other(null)
 design_controlled_medicinal_specify(null)
 single_site_member_state(null)
 location_of_area(null)
 multiple_sites_member_state(null)
 multiple_countries(null)
 multiple_member_states(null)
 number_of_sites(null)
 multi_country_list(null)
 data_monitoring_committee(null)
 total_enrolment_per_site(null)
 total_participants_worldwide
 population_less_than_18_years(null)
 population_utero(null)
 population_preterm_newborn(null)
 population_newborn(null)
 population_infant_and_toddler(null)
 population_children(null)
 population_adolescent(null)
 population_above_18(null)
 population_adult(null)
 population_elderly(null)
 gender_female(null)
 gender_male(null)
 subjects_healthy(null)
 subjects_patients(null)
 subjects_vulnerable_populations(null)
 subjects_women_child_bearing(null)
 subjects_women_using_contraception(null)
 subjects_pregnant_women(null)
 subjects_nursing_women(null)
 subjects_emergency_situation(null)
 subjects_incapable_consent(null)
 subjects_specify(null)
 subjects_others(null)
 subjects_others_specify(null)
 investigator1_given_name(null)
 investigator1_middle_name(null)
 investigator1_family_name(null)
 investigator1_qualification(null)
 investigator1_professional_address(null)
 organisations_transferred_(null)
 number_participants(null)
 notification(null)
 approval_date(null)
 submitted0
 date_submitted(null)
 modified2024-02-13 08:14:41
 created2024-02-13 08:14:41
 InvestigatorContact(array)
 0(array)
 id8
 application_id11
 given_namesk
 middle_name
 family_names
 qualificationM Pharm
 professional_address4423
 telephone342
 emailskerama@ppb.go.ke
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 ApplicationStage(array)
 0(array)
 id82
 application_id11
 stageScreening
 start_date2024-02-09
 statusComplete
 commentManager first comment
 end_date2024-02-09
 created2024-02-09 08:01:04
 modified2024-02-09 08:01:04
 1(array)
 id83
 application_id11
 stageScreeningSubmission
 start_date2024-02-09
 statusComplete
 commentManager final decision
 end_date2024-02-14
 created2024-02-09 10:12:31
 modified2024-02-09 10:12:31
 2(array)
 id84
 application_id11
 stageAssign
 start_date2024-02-14
 statusComplete
 commentManager final decision
 end_date2024-02-14
 created2024-02-14 11:44:56
 modified2024-02-14 11:44:56
 3(array)
 id85
 application_id11
 stageReview
 start_date2024-02-14
 statusComplete
 commentManager final decision
 end_date2024-02-14
 created2024-02-14 11:44:56
 modified2024-02-14 11:44:56
 4(array)
 id86
 application_id11
 stageReviewSubmission
 start_date2024-02-14
 statusComplete
 commentManager final decision
 end_date2025-01-06
 created2024-02-14 11:44:56
 modified2024-02-14 11:44:56
 5(array)
 id87
 application_id11
 stageFinalDecision
 start_date2024-02-14
 statusComplete
 commentManager final decision
 end_date2024-02-14
 created2024-02-14 11:44:56
 modified2024-02-14 11:44:56
 6(array)
 id88
 application_id11
 stageAnnualApproval
 start_date2024-02-14
 statusCurrent
 commentAdmin approve
 end_date2026-01-31
 created2024-02-14 11:44:56
 modified2024-02-14 11:44:56
 7(array)
 id90
 application_id11
 stageUnsubmitted
 start_date2024-02-22
 statusComplete
 commentPrincipal Investigator Re Submission
 end_date2024-05-31
 created2024-02-22 02:09:32
 modified2024-02-22 02:09:32
 Pharmacist(array)
 0(array)
 id8
 application_id11
 reg_no1976
 given_namesk
 premise_name
 qualificationB. Pharma
 professional_address1234
 valid_year2024
 mobile
 telephone
 emailskerama@ppb.go.ke
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 EthicalCommittee(array)
 0(array)
 id8
 application_id11
 ethical_committeeChuka University
 submission_date01-02-2024
 erc_number123
 initial_approval(null)
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 AnnualLetter(array)
 0(array)
 id14
 application_id11
 approval_noECCT/1/2024-ECCT/24/02/01
 type0
 content test
 qrcode(null)
 approver(null)
 approval_date06-01-2025
 expiry_date31-01-2026
 statusapproved
 deleted0
 deleted_date(null)
 created2025-01-06 10:16:45
 modified2025-01-06 10:16:45
 1(array)
 id15
 application_id11
 approval_noECCT/24/02/01/2025(2)
 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. ECCT/24/02/01/2025(2) 6th January 2025 sk s, Principal Investigator ECCT/24/02/01, 4423, Dear Sir/Madam, Re: ECCT/24/02/01 : Initial Approval; Maanzoni test mt. 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/642">text.png</a> dated 2nd May 2024 Version 5 2. The Study Protocol <a href="http://45.79.161.190:8080/attachments/download/643">text_2.png</a> dated 22nd May 2024 Version 6 3. Registration of the study at Pan African Clinical Trials Registry https://pactr.samrc.ac.za <a href="http://45.79.161.190:8080/attachments/download/644">text_3.png</a> dated 7th May 2024 Version 4 4. Patient Information leaflet and Informed consent form <a href="http://45.79.161.190:8080/attachments/download/645">text_4.png</a> dated 7th May 2024 Version 6 5. Investigators Brochure/Package inserts <a href="http://45.79.161.190:8080/attachments/download/646">text_5.png</a> dated 1st May 2024 Version 1 6. Investigational Medicinal Product Dossier (IMPD) <a href="http://45.79.161.190:8080/attachments/download/647">text_6.png</a> dated 1st May 2024 Version 1 7. Adequate data and information from previous studies and Phases to support carrying out of the current study <a href="http://45.79.161.190:8080/attachments/download/648">text_7.png</a> dated 1st May 2024 Version 1 8. Stability data of the investigational product <a href="http://45.79.161.190:8080/attachments/download/649">text_8.png</a> dated 1st May 2024 Version 1 9. GMP certificate of the investigational product from the site of manufacture <a href="http://45.79.161.190:8080/attachments/download/650">text_9.png</a> dated 1st May 2024 Version 1 10. Certificate of Analysis of the investigational product <a href="http://45.79.161.190:8080/attachments/download/651">text_10.png</a> dated 1st May 2024 Version 1 11. Pictorial Sample of the investigational products. This sample should include the text of the labeling to be used <a href="http://45.79.161.190:8080/attachments/download/652">text_11.png</a> dated 1st May 2024 Version 1 12. 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/653">text_12.png</a> dated 1st May 2024 Version 1 13. Evidence of contractual agreement between sponsor and Principal Investigator. <a href="http://45.79.161.190:8080/attachments/download/654">text_13.png</a> dated 1st May 2024 Version 1 14. Evidence of recent GCP training of the core study staff <a href="http://45.79.161.190:8080/attachments/download/655">text_14.png</a> dated 1st May 2024 Version 1 15. DSMB Charter including the composition and meeting schedule <a href="http://45.79.161.190:8080/attachments/download/656">text_15.png</a> dated 1st May 2024 Version 1 16. Detailed budget of the study <a href="http://45.79.161.190:8080/attachments/download/657">text_16.png</a> dated 1st May 2024 Version 1 17. Financial declaration by Sponsor and/or PI <a href="http://45.79.161.190:8080/attachments/download/658">text_17.png</a> dated 1st May 2024 Version 1 18. 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/download/659">text_18.png</a> dated 1st May 2024 Version 1 19. Indemnity cover for PI, investigators and study Pharmacist. <a href="http://45.79.161.190:8080/attachments/download/660">text_19.png</a> dated 1st May 2024 Version 1 20. Clinical Trials Insurance cover for study participants <a href="http://45.79.161.190:8080/attachments/download/661">text_20.png</a> dated 1st May 2024 Version 1 21. Copy of favorable opinion letter from the local Ethics Review Committee (ERC). <a href="http://45.79.161.190:8080/attachments/download/662">text_21.png</a> dated 1st May 2024 Version 1 22. Copy of current Practice Licenses for the Investigators and study Pharmacist <a href="http://45.79.161.190:8080/attachments/download/663">text_22.png</a> dated 1st May 2024 Version 1 23. Copy of approval letter(s) from collaborating institutions or other regulatory authorities, if applicable <a href="http://45.79.161.190:8080/attachments/download/664">text_23.png</a> dated 2nd May 2024 Version 1 24. For multicentre/multi-site studies, a site specific addendum for each of the proposed sites including among other things the sites’ capacity to carry out the study i.e personnel, equipment, laboratory etc <a href="http://45.79.161.190:8080/attachments/download/665">text_24.png</a> dated 1st May 2024 Version 1 25. 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/666">text_25.png</a> dated 1st May 2024 Version 1 26. Payment of fees <a href="http://45.79.161.190:8080/attachments/download/667">text_26.png</a> dated 1st May 2024 Version 1 27. Statistical Analysis Plan <a href="http://45.79.161.190:8080/attachments/download/668">text_27.png</a> dated 1st May 2024 Version 1 28. Signed Checklist <a href="http://45.79.161.190:8080/attachments/download/669">text_28.png</a> dated 1st May 2024 Version 1 </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: Maanzoni test ECCT/24/02/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 6th January 2026 <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 
 qrcode(null)
 approvermanager
 approval_date06-01-2025
 expiry_date06-01-2026
 statussubmitted
 deleted0
 deleted_date(null)
 created2025-01-06 10:18:44
 modified2025-01-06 10:18:44
 AmendmentLetter(empty)
 AmendmentApproval(empty)
 AmendmentApprovalSummary(empty)
 Organization(array)
 0(array)
 id8
 application_id11
 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)
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 SiteDetail(array)
 0(array)
 id17
 application_id11
 county_id42
 site_name
 physical_address
 contact_details
 contact_person
 site_capacity(null)
 misc(null)
 created2013-01-25 21:38:59
 modified2024-05-31 16:12:58
 Placebo(array)
 0(array)
 id8
 application_id11
 placebo_present(null)
 pharmaceutical_form
 route_of_administration
 composition
 identical_indp
 major_ingredients
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 Sponsor(array)
 0(array)
 id7
 application_id11
 sponsoranc
 sponsor_typeResearch Institution
 contact_person
 address3221
 telephone_number0712000000
 fax_number
 cell_number0712000000
 email_addressskerama@ppb.go.ke
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 SiteInspection(array)
 0(array)
 id15
 application_id11
 user_id33
 reference_noSI/2024/15
 study_title Maanzoni test
 protocol_noECCT/24/02/01
 version_no(null)
 pactr_number
 trial_phaseTherapeutic confirmatory (Phase III)
 investigatorsjj abc Tel: 0711111111 Email: skerama@ppb.co.ke
 co_investigators1 sk s Email: skerama@ppb.go.ke
 study_stageBefore trial commencement
 inspection_countryKenya
 inspector_names
 inspection_dates
 site_address
 sponsor_address
 lab_address
 events_summary(null)
 conclusionsummary report conclusion
 summary_reportsummary report details here
 outcomePassed
 approved2
 summary_approved2
 approved_by2
 sent_to_pi1
 deleted0
 deleted_date(null)
 created2024-02-14 09:05:12
 modified2024-02-14 09:14:35
 1(array)
 id26
 application_id11
 user_id2
 reference_noSI/2024/21
 study_title Maanzoni test
 protocol_noECCT/24/02/01
 version_no(null)
 pactr_number(null)
 trial_phaseTherapeutic confirmatory (Phase III)
 investigatorsjj abc Tel: 0711111111 Email: skerama@ppb.co.ke
 co_investigators1 sk s Email: skerama@ppb.go.ke
 study_stage(null)
 inspection_countryKenya
 inspector_names(null)
 inspection_dates(null)
 site_address(null)
 sponsor_address(null)
 lab_address(null)
 events_summary(null)
 conclusion(null)
 summary_report(null)
 outcome(null)
 approved0
 summary_approved0
 approved_by(null)
 sent_to_pi0
 deleted0
 deleted_date(null)
 created2024-02-15 04:52:38
 modified2024-02-15 04:52:38
 2(array)
 id27
 application_id11
 user_id33
 reference_noSI/2024/22
 study_title Maanzoni test
 protocol_noECCT/24/02/01
 version_no(null)
 pactr_number(null)
 trial_phaseTherapeutic confirmatory (Phase III)
 investigatorsjj abc Tel: 0711111111 Email: skerama@ppb.co.ke
 co_investigators1 sk s Email: skerama@ppb.go.ke
 study_stage(null)
 inspection_countryKenya
 inspector_names(null)
 inspection_dates(null)
 site_address(null)
 sponsor_address(null)
 lab_address(null)
 events_summary(null)
 conclusion(null)
 summary_report(null)
 outcome(null)
 approved0
 summary_approved0
 approved_by(null)
 sent_to_pi0
 deleted0
 deleted_date(null)
 created2024-02-15 04:55:36
 modified2024-02-15 04:55:36
 Sae(empty)
 Ciom(empty)
 StudyRoute(array)
 0(array)
 id485
 application_id11
 study_routeoral
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 Manufacturer(array)
 0(array)
 id8
 application_id11
 manufacturer_nameppb Pharma
 address123
 manufacturer_countryKenya
 manufacturer_phone
 manufacturer_emailskerama@ppb.go.ke
 manufacturing_activitiesPackaging
 other_specify
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 Reassignment(empty)
 Attachment(empty)
 AnnualApproval(empty)
 AmendmentChecklist(empty)
 Reminder(empty)
 ParticipantFlow(empty)
 Budget(array)
 0(array)
 id8
 application_id11
 year(null)
 budget_period(null)
 personnel_currencyKES
 personnel
 transport_currencyKES
 transport
 field_currencyKES
 field
 supplies_currencyKES
 supplies
 pharmacy_currencyKES
 pharmacy
 travel_currencyKES
 travel
 regulatory_currencyKES
 regulatory
 it_currencyKES
 it
 lab_currency(null)
 lab(null)
 others_currencyKES
 others
 kemri_currency(null)
 kemri(null)
 wrair_currency(null)
 wrair(null)
 subject_currencyKES
 subject
 grand_currencyKES
 grand_total
 study_information
 personnel_kshs
 transport_kshs
 field_kshs
 supplies_kshs
 pharmacy_kshs
 travel_kshs
 regulatory_kshs
 it_kshs
 lab_kshs(null)
 others_kshs
 grand_total_kshs
 subject_kshs
 created2024-02-09 05:55:16
 modified2024-05-31 16:12:58
 Deviation(array)
 0(array)
 id30
 application_id11
 user_id31
 reference_noDEV/2024/30
 study_title Maanzoni test
 deviation_type(null)
 deviation_type_dev(null)
 pi_namesk s
 deviation_date(null)
 participant_number(null)
 treating_physician(null)
 deviation_description(null)
 deviation_explanation(null)
 deviation_measures(null)
 deviation_preclude(null)
 sponsor_notified0
 sponsor_explanation(null)
 study_impact(null)
 statusUnsubmitted
 deleted0
 deleted_date(null)
 created2024-06-19 16:50:00
 modified2024-06-19 16:50:00
 Document(empty)
 CoverLetter(empty)
 Protocol(empty)
 PatientLeaflet(empty)
 Brochure(empty)
 GmpCertificate(empty)
 Cv(empty)
 Finance(empty)
 Declaration(empty)
 IndemnityCover(empty)
 OpinionLetter(empty)
 ApprovalLetter(empty)
 Statement(empty)
 ParticipatingStudy(empty)
 Addendum(empty)
 Registration(empty)
 Fee(empty)
 Checklist(array)
 0(array)
 id642
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text.png
 foreign_key11
 dirnameimg
 basenametext.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_covering_letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates) *
 year(null)
 file_date02-05-2024
 pocket_nameapplicant_covering_letter
 version_no5
 created2024-05-31 16:10:21
 modified2024-05-31 16:10:21
 pathimg/text.png
 1(array)
 id643
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_2.png
 foreign_key11
 dirnameimg
 basenametext_2.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_protocol
 descriptionThe Study Protocol *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_protocol
 version_no6
 created2024-05-31 16:10:35
 modified2024-05-31 16:10:35
 pathimg/text_2.png
 2(array)
 id644
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_3.png
 foreign_key11
 dirnameimg
 basenametext_3.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_pan_african
 descriptionRegistration of the study at Pan African Clinical Trials Registry https://pactr.samrc.ac.za *
 year(null)
 file_date07-05-2024
 pocket_nameapplicant_pan_african
 version_no4
 created2024-05-31 16:10:44
 modified2024-05-31 16:10:44
 pathimg/text_3.png
 3(array)
 id645
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_4.png
 foreign_key11
 dirnameimg
 basenametext_4.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_patient_information
 descriptionPatient Information leaflet and Informed consent form *
 year(null)
 file_date07-05-2024
 pocket_nameapplicant_patient_information
 version_no6
 created2024-05-31 16:10:50
 modified2024-05-31 16:10:50
 pathimg/text_4.png
 4(array)
 id646
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_5.png
 foreign_key11
 dirnameimg
 basenametext_5.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_investigators_brochure
 descriptionInvestigators Brochure/Package inserts *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_investigators_brochure
 version_no1
 created2024-05-31 16:10:59
 modified2024-05-31 16:10:59
 pathimg/text_5.png
 5(array)
 id647
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_6.png
 foreign_key11
 dirnameimg
 basenametext_6.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_impd
 descriptionInvestigational Medicinal Product Dossier (IMPD) *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_impd
 version_no1
 created2024-05-31 16:11:04
 modified2024-05-31 16:11:04
 pathimg/text_6.png
 6(array)
 id648
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_7.png
 foreign_key11
 dirnameimg
 basenametext_7.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_prev_data
 descriptionAdequate data and information from previous studies and Phases to support carrying out of the current study *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_prev_data
 version_no1
 created2024-05-31 16:11:08
 modified2024-05-31 16:11:08
 pathimg/text_7.png
 7(array)
 id649
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_8.png
 foreign_key11
 dirnameimg
 basenametext_8.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_stability_data
 descriptionStability data of the investigational product *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_stability_data
 version_no1
 created2024-05-31 16:11:13
 modified2024-05-31 16:11:13
 pathimg/text_8.png
 8(array)
 id650
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_9.png
 foreign_key11
 dirnameimg
 basenametext_9.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_gmp_certificate
 descriptionGMP certificate of the investigational product from the site of manufacture *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_gmp_certificate
 version_no1
 created2024-05-31 16:11:18
 modified2024-05-31 16:11:18
 pathimg/text_9.png
 9(array)
 id651
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_10.png
 foreign_key11
 dirnameimg
 basenametext_10.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_analysis_cert
 descriptionCertificate of Analysis of the investigational product *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_analysis_cert
 version_no1
 created2024-05-31 16:11:23
 modified2024-05-31 16:11:23
 pathimg/text_10.png
 10(array)
 id652
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_11.png
 foreign_key11
 dirnameimg
 basenametext_11.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_pictorial_sample
 descriptionPictorial Sample of the investigational products. This sample should include the text of the labeling to be used *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_pictorial_sample
 version_no1
 created2024-05-31 16:11:27
 modified2024-05-31 16:11:27
 pathimg/text_11.png
 11(array)
 id653
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_12.png
 foreign_key11
 dirnameimg
 basenametext_12.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 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_date01-05-2024
 pocket_nameapplicant_investigators_cv
 version_no1
 created2024-05-31 16:11:31
 modified2024-05-31 16:11:31
 pathimg/text_12.png
 12(array)
 id654
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_13.png
 foreign_key11
 dirnameimg
 basenametext_13.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_contractual_agreement
 descriptionEvidence of contractual agreement between sponsor and Principal Investigator. *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_contractual_agreement
 version_no1
 created2024-05-31 16:11:36
 modified2024-05-31 16:11:36
 pathimg/text_13.png
 13(array)
 id655
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_14.png
 foreign_key11
 dirnameimg
 basenametext_14.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_gcp_training
 descriptionEvidence of recent GCP training of the core study staff *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_gcp_training
 version_no1
 created2024-05-31 16:11:40
 modified2024-05-31 16:11:40
 pathimg/text_14.png
 14(array)
 id656
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_15.png
 foreign_key11
 dirnameimg
 basenametext_15.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_dsmb_charter
 descriptionDSMB Charter including the composition and meeting schedule *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_dsmb_charter
 version_no1
 created2024-05-31 16:11:53
 modified2024-05-31 16:11:53
 pathimg/text_15.png
 15(array)
 id657
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_16.png
 foreign_key11
 dirnameimg
 basenametext_16.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_detailed_budget
 descriptionDetailed budget of the study *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_detailed_budget
 version_no1
 created2024-05-31 16:11:58
 modified2024-05-31 16:11:58
 pathimg/text_16.png
 16(array)
 id658
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_17.png
 foreign_key11
 dirnameimg
 basenametext_17.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_financial_declaration
 descriptionFinancial declaration by Sponsor and/or PI *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_financial_declaration
 version_no1
 created2024-05-31 16:12:02
 modified2024-05-31 16:12:02
 pathimg/text_17.png
 17(array)
 id659
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_18.png
 foreign_key11
 dirnameimg
 basenametext_18.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_signed_declaration
 descriptionSigned Declaration by Sponsor or Principal investigator that the study will be carried out according to the protocol and applicable laws, regulations and GCP requirements. *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_signed_declaration
 version_no1
 created2024-05-31 16:12:07
 modified2024-05-31 16:12:07
 pathimg/text_18.png
 18(array)
 id660
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_19.png
 foreign_key11
 dirnameimg
 basenametext_19.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_indemnity_pi
 descriptionIndemnity cover for PI, investigators and study Pharmacist. *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_indemnity_pi
 version_no1
 created2024-05-31 16:12:11
 modified2024-05-31 16:12:11
 pathimg/text_19.png
 19(array)
 id661
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_20.png
 foreign_key11
 dirnameimg
 basenametext_20.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_indemnity_cover
 descriptionClinical Trials Insurance cover for study participants *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_indemnity_cover
 version_no1
 created2024-05-31 16:12:15
 modified2024-05-31 16:12:15
 pathimg/text_20.png
 20(array)
 id662
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_21.png
 foreign_key11
 dirnameimg
 basenametext_21.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_opinion_letter
 descriptionCopy of favorable opinion letter from the local Ethics Review Committee (ERC). *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_opinion_letter
 version_no1
 created2024-05-31 16:12:20
 modified2024-05-31 16:12:20
 pathimg/text_21.png
 21(array)
 id663
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_22.png
 foreign_key11
 dirnameimg
 basenametext_22.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_practice_license
 descriptionCopy of current Practice Licenses for the Investigators and study Pharmacist *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_practice_license
 version_no1
 created2024-05-31 16:12:25
 modified2024-05-31 16:12:25
 pathimg/text_22.png
 22(array)
 id664
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_23.png
 foreign_key11
 dirnameimg
 basenametext_23.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_approval_letter
 descriptionCopy of approval letter(s) from collaborating institutions or other regulatory authorities, if applicable
 year(null)
 file_date02-05-2024
 pocket_nameapplicant_approval_letter
 version_no1
 created2024-05-31 16:12:29
 modified2024-05-31 16:12:29
 pathimg/text_23.png
 23(array)
 id665
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_24.png
 foreign_key11
 dirnameimg
 basenametext_24.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_addendum
 descriptionFor multicentre/multi-site studies, a site specific addendum for each of the proposed sites including among other things the sites’ capacity to carry out the study i.e personnel, equipment, laboratory etc
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_addendum
 version_no1
 created2024-05-31 16:12:33
 modified2024-05-31 16:12:33
 pathimg/text_24.png
 24(array)
 id666
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_25.png
 foreign_key11
 dirnameimg
 basenametext_25.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 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_date01-05-2024
 pocket_nameapplicant_statement
 version_no1
 created2024-05-31 16:12:39
 modified2024-05-31 16:12:39
 pathimg/text_25.png
 25(array)
 id667
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_26.png
 foreign_key11
 dirnameimg
 basenametext_26.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_fees
 descriptionPayment of fees *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_fees
 version_no1
 created2024-05-31 16:12:43
 modified2024-05-31 16:12:43
 pathimg/text_26.png
 26(array)
 id668
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_27.png
 foreign_key11
 dirnameimg
 basenametext_27.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupstatistical_analysis_plan
 descriptionStatistical Analysis Plan *
 year(null)
 file_date01-05-2024
 pocket_namestatistical_analysis_plan
 version_no1
 created2024-05-31 16:12:47
 modified2024-05-31 16:12:47
 pathimg/text_27.png
 27(array)
 id669
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/text_28.png
 foreign_key11
 dirnameimg
 basenametext_28.png
 checksum8386e9b8f6d3abce6c8194805446c9b5
 alternative(null)
 groupapplicant_signed_checklist
 descriptionSigned Checklist *
 year(null)
 file_date01-05-2024
 pocket_nameapplicant_signed_checklist
 version_no1
 created2024-05-31 16:12:51
 modified2024-05-31 16:12:58
 pathimg/text_28.png
 StudyMonitor(empty)
 ProtocolOutsource(empty)
 Outsource(array)
 0(array)
 id1
 application_id11
 user_id78
 model
 usernamemercykamau180
 nameMercy Kamau
 emailmercykamau180@gmail.com
 phone_no0741706403
 institution_physical
 name_of_institution
 institution_address
 institution_contact
 county_id1
 country_id115
 approved1
 created2024-06-24 15:44:43
 modified2024-06-25 09:01:28
 accepted(null)
 model_sae1
 model_ciom0
 model_dev0
- redir
- $request->data(empty)
- $this->validationErrors(array)
 Permission(empty)
 Aro(empty)
 Aco(empty)
 Application(empty)
 User(empty)
 TrialStatus(empty)
 Review(empty)
 ActiveInspector(empty)
 ManagerReview(empty)
 Acceptance(empty)
 Amendment(empty)
 InvestigatorContact(empty)
 ApplicationStage(empty)
 Pharmacist(empty)
 EthicalCommittee(empty)
 AnnualLetter(empty)
 AmendmentLetter(empty)
 AmendmentApproval(empty)
 AmendmentApprovalSummary(empty)
 Organization(empty)
 SiteDetail(empty)
 Placebo(empty)
 Sponsor(empty)
 SiteInspection(empty)
 Sae(empty)
 Ciom(empty)
 StudyRoute(empty)
 Manufacturer(empty)
 Reassignment(empty)
 Attachment(empty)
 AnnualApproval(empty)
 AmendmentChecklist(empty)
 Reminder(empty)
 ParticipantFlow(empty)
 Budget(empty)
 Deviation(empty)
 Document(empty)
 CoverLetter(empty)
 Protocol(empty)
 PatientLeaflet(empty)
 Brochure(empty)
 GmpCertificate(empty)
 Cv(empty)
 Finance(empty)
 Declaration(empty)
 IndemnityCover(empty)
 OpinionLetter(empty)
 ApprovalLetter(empty)
 Statement(empty)
 ParticipatingStudy(empty)
 Addendum(empty)
 Registration(empty)
 Fee(empty)
 Checklist(empty)
 StudyMonitor(empty)
 ProtocolOutsource(empty)
 Outsource(empty)
- Loaded Helpers(array)
 0Html
 1Form
 2Session
 3Text
 4Number
 5SimpleGraph
 6DebugTimer
 7Toolbar
 8HtmlToolbar
====

Environment

App Constants

Constant	Value
MEDIA	'/var/www/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/11'
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=vuknl8kbasbdhassdi2iqf01a0'
Http Accept Encoding	'gzip, br, zstd, deflate'
Http Host	'45.79.161.190:8080'
Http Via	'1.1 squid-proxy-5b5d847c96-qq957 (squid/6.10)'
Http X Forwarded For	'10.3.82.253'
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.29 (Ubuntu) Server at 45.79.161.190 Port 8080 '
Server Software	'Apache/2.4.29 (Ubuntu)'
Server Name	'45.79.161.190'
Server Addr	'45.79.161.190'
Server Port	'8080'
Remote Addr	'216.73.216.36'
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	'56325'
Redirect Url	'/app/webroot/applications/view/11'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/applications/view/11'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1756471406.865
Request Time	(int) 1756471406

====

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:	Maanzoni test
Study Objectives:	efficacy
Laymans Summary:	testing
Abstract of Study:	TBD

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 70 ms Total Queries: 53 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 70 ms
Total Queries: 53 queries