Pharmacy and Poisons Board: Applications

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

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

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `ctr`.`applications` AS `Application` WHERE `Application`.`id` = 2	1	1	0
SELECT `Application`.`id`, `Application`.`user_id`, `Application`.`application_id`, `Application`.`is_child`, `Application`.`trial_status_id`, `Application`.`trial_status_date`, `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`.`protocol_not_ai_generated`, `Application`.`placebo_present`, `Application`.`study_objectives`, `Application`.`principal_inclusion_criteria`, `Application`.`principal_exclusion_criteria`, `Application`.`primary_end_points`, `Application`.`scope_diagnosis`, `Application`.`scope_prophylaxis`, `Application`.`scope_therapy`, `Application`.`scope_safety`, `Application`.`scope_efficacy`, `Application`.`scope_pharmacokinetic`, `Application`.`scope_pharmacodynamic`, `Application`.`scope_bioequivalence`, `Application`.`scope_dose_response`, `Application`.`scope_pharmacogenetic`, `Application`.`scope_pharmacogenomic`, `Application`.`scope_pharmacoecomomic`, `Application`.`scope_others`, `Application`.`scope_others_specify`, `Application`.`trial_human_pharmacology`, `Application`.`trial_administration_humans`, `Application`.`trial_bioequivalence_study`, `Application`.`trial_other`, `Application`.`trial_other_specify`, `Application`.`trial_therapeutic_exploratory`, `Application`.`trial_therapeutic_confirmatory`, `Application`.`trial_therapeutic_use`, `Application`.`design_controlled`, `Application`.`site_capacity`, `Application`.`staff_numbers`, `Application`.`other_details_explanation`, `Application`.`other_details_regulatory_notapproved`, `Application`.`other_details_regulatory_approved`, `Application`.`other_details_regulatory_rejected`, `Application`.`other_details_regulatory_halted`, `Application`.`estimated_duration`, `Application`.`design_controlled_randomised`, `Application`.`design_controlled_open`, `Application`.`design_controlled_single_blind`, `Application`.`design_controlled_double_blind`, `Application`.`design_controlled_parallel_group`, `Application`.`design_controlled_cross_over`, `Application`.`design_controlled_other`, `Application`.`design_controlled_specify`, `Application`.`design_controlled_comparator`, `Application`.`design_controlled_other_medicinal`, `Application`.`design_controlled_placebo`, `Application`.`design_controlled_medicinal_other`, `Application`.`design_controlled_medicinal_specify`, `Application`.`single_site_member_state`, `Application`.`location_of_area`, `Application`.`single_site_physical_address`, `Application`.`single_site_contact_person`, `Application`.`single_site_telephone`, `Application`.`multiple_sites_member_state`, `Application`.`multiple_countries`, `Application`.`multiple_member_states`, `Application`.`number_of_sites`, `Application`.`multi_country_list`, `Application`.`data_monitoring_committee`, `Application`.`total_enrolment_per_site`, `Application`.`total_participants_worldwide`, `Application`.`population_less_than_18_years`, `Application`.`population_utero`, `Application`.`population_preterm_newborn`, `Application`.`population_newborn`, `Application`.`population_infant_and_toddler`, `Application`.`population_children`, `Application`.`population_adolescent`, `Application`.`population_above_18`, `Application`.`population_adult`, `Application`.`population_elderly`, `Application`.`gender_female`, `Application`.`gender_male`, `Application`.`subjects_healthy`, `Application`.`subjects_patients`, `Application`.`subjects_vulnerable_populations`, `Application`.`subjects_women_child_bearing`, `Application`.`subjects_women_using_contraception`, `Application`.`subjects_pregnant_women`, `Application`.`subjects_nursing_women`, `Application`.`subjects_emergency_situation`, `Application`.`subjects_incapable_consent`, `Application`.`subjects_specify`, `Application`.`subjects_others`, `Application`.`subjects_others_specify`, `Application`.`investigator1_given_name`, `Application`.`investigator1_middle_name`, `Application`.`investigator1_family_name`, `Application`.`investigator1_qualification`, `Application`.`investigator1_professional_address`, `Application`.`investigator1_telephone`, `Application`.`investigator1_email`, `Application`.`organisations_transferred_`, `Application`.`number_participants`, `Application`.`notification`, `Application`.`approval_date`, `Application`.`submitted`, `Application`.`deleted`, `Application`.`deleted_date`, `Application`.`deactivated`, `Application`.`date_submitted`, `Application`.`unsubmitted`, `Application`.`initial_date_submitted`, `Application`.`admin_stopped`, `Application`.`admin_stopped_reason`, `Application`.`approved`, `Application`.`approved_reason`, `Application`.`approved_date`, `Application`.`final_report`, `Application`.`implication_results`, `Application`.`quantity_imported`, `Application`.`quantity_dispensed`, `Application`.`quantity_destroyed`, `Application`.`quantity_exported`, `Application`.`balance_site`, `Application`.`final_date`, `Application`.`ecitizen_invoice`, `Application`.`modified`, `Application`.`created`, `Application`.`ai_content`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`confirm_password`, `User`.`name`, `User`.`email`, `User`.`national_id_number`, `User`.`sponsor`, `User`.`sponsor_email`, `User`.`qualification`, `User`.`phone_no`, `User`.`name_of_institution`, `User`.`institution_physical`, `User`.`institution_address`, `User`.`institution_contact`, `User`.`county_id`, `User`.`country_id`, `User`.`group_id`, `User`.`activation_key`, `User`.`forgot_password`, `User`.`is_active`, `User`.`deactivated`, `User`.`created`, `User`.`modified`, `TrialStatus`.`id`, `TrialStatus`.`value`, `TrialStatus`.`name`, `TrialStatus`.`created`, `TrialStatus`.`modified` FROM `ctr`.`applications` AS `Application` LEFT JOIN `ctr`.`users` AS `User` ON (`Application`.`user_id` = `User`.`id`) LEFT JOIN `ctr`.`trial_statuses` AS `TrialStatus` ON (`Application`.`trial_status_id` = `TrialStatus`.`id`) WHERE `Application`.`id` = 2 AND `Application`.`deleted` = '0' LIMIT 1	1	1	3	maybe slow
SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`application_id`, `Review`.`category`, `Review`.`type`, `Review`.`assessment_type`, `Review`.`title`, `Review`.`text`, `Review`.`summary`, `Review`.`recommendation`, `Review`.`notified`, `Review`.`accepted`, `Review`.`conflict`, `Review`.`status`, `Review`.`created`, `Review`.`modified`, `Review`.`deadline_alert_checked_on` FROM `ctr`.`reviews` AS `Review` WHERE `Review`.`category` = '0' AND `Review`.`application_id` = (2)	0	0	2	maybe slow
SELECT `InternalReview`.`id`, `InternalReview`.`user_id`, `InternalReview`.`application_id`, `InternalReview`.`category`, `InternalReview`.`type`, `InternalReview`.`assessment_type`, `InternalReview`.`title`, `InternalReview`.`text`, `InternalReview`.`summary`, `InternalReview`.`recommendation`, `InternalReview`.`notified`, `InternalReview`.`accepted`, `InternalReview`.`conflict`, `InternalReview`.`status`, `InternalReview`.`created`, `InternalReview`.`modified`, `InternalReview`.`deadline_alert_checked_on` FROM `ctr`.`reviews` AS `InternalReview` WHERE `InternalReview`.`category` = '1' AND `InternalReview`.`application_id` = (2)	0	0	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` = (2)	1	1	1
SELECT `ManagerReview`.`id`, `ManagerReview`.`user_id`, `ManagerReview`.`application_id`, `ManagerReview`.`category`, `ManagerReview`.`type`, `ManagerReview`.`assessment_type`, `ManagerReview`.`title`, `ManagerReview`.`text`, `ManagerReview`.`summary`, `ManagerReview`.`recommendation`, `ManagerReview`.`notified`, `ManagerReview`.`accepted`, `ManagerReview`.`conflict`, `ManagerReview`.`status`, `ManagerReview`.`created`, `ManagerReview`.`modified`, `ManagerReview`.`deadline_alert_checked_on` FROM `ctr`.`reviews` AS `ManagerReview` WHERE `ManagerReview`.`application_id` = (2)	0	0	1	maybe slow
SELECT `Acceptance`.`id`, `Acceptance`.`user_id`, `Acceptance`.`application_id`, `Acceptance`.`category`, `Acceptance`.`type`, `Acceptance`.`assessment_type`, `Acceptance`.`title`, `Acceptance`.`text`, `Acceptance`.`summary`, `Acceptance`.`recommendation`, `Acceptance`.`notified`, `Acceptance`.`accepted`, `Acceptance`.`conflict`, `Acceptance`.`status`, `Acceptance`.`created`, `Acceptance`.`modified`, `Acceptance`.`deadline_alert_checked_on` FROM `ctr`.`reviews` AS `Acceptance` WHERE `Acceptance`.`type` = 'acceptance' AND `Acceptance`.`application_id` = (2)	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` = (2)	1	1	6	maybe slow
SELECT `InvestigatorContact`.`id`, `InvestigatorContact`.`application_id`, `InvestigatorContact`.`given_name`, `InvestigatorContact`.`middle_name`, `InvestigatorContact`.`family_name`, `InvestigatorContact`.`qualification`, `InvestigatorContact`.`professional_address`, `InvestigatorContact`.`telephone`, `InvestigatorContact`.`email`, `InvestigatorContact`.`investigator_role`, `InvestigatorContact`.`created`, `InvestigatorContact`.`modified` FROM `ctr`.`investigator_contacts` AS `InvestigatorContact` WHERE `InvestigatorContact`.`application_id` = (2)	1	1	1
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` = (2)	7	7	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` = (2)	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` = (2)	1	1	1
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` = (2)	1	1	2	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` = (2)	1	1	1
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` = (2)	1	1	1
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` = (2)	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` = (2)	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` = (2)	1	1	2	maybe slow
SELECT `Placebo`.`id`, `Placebo`.`application_id`, `Placebo`.`placebo_present`, `Placebo`.`pharmaceutical_form`, `Placebo`.`route_of_administration`, `Placebo`.`composition`, `Placebo`.`identical_indp`, `Placebo`.`major_ingredients`, `Placebo`.`created`, `Placebo`.`modified` FROM `ctr`.`placebos` AS `Placebo` WHERE `Placebo`.`application_id` = (2)	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` = (2)	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` = (2)	5	5	2	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` = (2)	0	0	3	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`, `Ciom`.`deleted` FROM `ctr`.`cioms` AS `Ciom` WHERE `Ciom`.`application_id` = (2)	3	3	2	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` = (2)	2	2	1	maybe slow
SELECT `Manufacturer`.`id`, `Manufacturer`.`application_id`, `Manufacturer`.`manufacturer_name`, `Manufacturer`.`address`, `Manufacturer`.`manufacturer_country`, `Manufacturer`.`manufacturer_phone`, `Manufacturer`.`manufacturer_email`, `Manufacturer`.`manufacturing_activities`, `Manufacturer`.`other_specify`, `Manufacturer`.`created`, `Manufacturer`.`modified` FROM `ctr`.`manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`application_id` = (2)	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` = (2)	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` = (2)	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` = (2)	12	12	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` = (2)	17	17	3	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` = (2)	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` = (2)	0	0	1	maybe slow
SELECT `Budget`.`id`, `Budget`.`application_id`, `Budget`.`year`, `Budget`.`budget_period`, `Budget`.`personnel_currency`, `Budget`.`personnel`, `Budget`.`transport_currency`, `Budget`.`transport`, `Budget`.`field_currency`, `Budget`.`field`, `Budget`.`supplies_currency`, `Budget`.`supplies`, `Budget`.`pharmacy_currency`, `Budget`.`pharmacy`, `Budget`.`travel_currency`, `Budget`.`travel`, `Budget`.`regulatory_currency`, `Budget`.`regulatory`, `Budget`.`it_currency`, `Budget`.`it`, `Budget`.`lab_currency`, `Budget`.`lab`, `Budget`.`others_currency`, `Budget`.`others`, `Budget`.`kemri_currency`, `Budget`.`kemri`, `Budget`.`wrair_currency`, `Budget`.`wrair`, `Budget`.`subject_currency`, `Budget`.`subject`, `Budget`.`grand_currency`, `Budget`.`grand_total`, `Budget`.`study_information`, `Budget`.`personnel_kshs`, `Budget`.`transport_kshs`, `Budget`.`field_kshs`, `Budget`.`supplies_kshs`, `Budget`.`pharmacy_kshs`, `Budget`.`travel_kshs`, `Budget`.`regulatory_kshs`, `Budget`.`it_kshs`, `Budget`.`lab_kshs`, `Budget`.`others_kshs`, `Budget`.`grand_total_kshs`, `Budget`.`subject_kshs`, `Budget`.`created`, `Budget`.`modified` FROM `ctr`.`budgets` AS `Budget` WHERE `Budget`.`application_id` = (2)	1	1	2	maybe slow
SELECT `Deviation`.`id`, `Deviation`.`application_id`, `Deviation`.`user_id`, `Deviation`.`reference_no`, `Deviation`.`study_title`, `Deviation`.`deviation_type`, `Deviation`.`deviation_type_dev`, `Deviation`.`pi_name`, `Deviation`.`deviation_date`, `Deviation`.`participant_number`, `Deviation`.`treating_physician`, `Deviation`.`deviation_description`, `Deviation`.`deviation_explanation`, `Deviation`.`deviation_measures`, `Deviation`.`deviation_preclude`, `Deviation`.`sponsor_notified`, `Deviation`.`sponsor_notification_date`, `Deviation`.`sponsor_explanation`, `Deviation`.`study_impact`, `Deviation`.`status`, `Deviation`.`date_submitted`, `Deviation`.`deleted`, `Deviation`.`deleted_date`, `Deviation`.`created`, `Deviation`.`modified` FROM `ctr`.`deviations` AS `Deviation` WHERE `Deviation`.`application_id` = (2)	8	8	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`file`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`description`, `Document`.`year`, `Document`.`file_date`, `Document`.`pocket_name`, `Document`.`version_no`, `Document`.`created`, `Document`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Document__path` FROM `ctr`.`attachments` AS `Document` WHERE `Document`.`model` = 'Application' AND `Document`.`group` = 'document' AND `Document`.`foreign_key` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	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` = (2)	0	0	0
SELECT `ProtocolOutsource`.`id`, `ProtocolOutsource`.`user_id`, `ProtocolOutsource`.`application_id`, `ProtocolOutsource`.`outsource_id`, `ProtocolOutsource`.`owner_id`, `ProtocolOutsource`.`created`, `ProtocolOutsource`.`modified` FROM `ctr`.`protocol_outsources` AS `ProtocolOutsource` WHERE `ProtocolOutsource`.`user_id` = (2)	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` = (2)	0	0	1	maybe slow
SELECT `TrialStatus`.`id` FROM `ctr`.`trial_statuses` AS `TrialStatus` WHERE `TrialStatus`.`name` = 'Suspended' LIMIT 1	1	1	0
SELECT `TrialStatus`.`id` FROM `ctr`.`trial_statuses` AS `TrialStatus` WHERE `TrialStatus`.`name` = 'Stopped' LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 15.44 MB

Message	Memory use
Component initialization	2.43 MB
Controller action start	3.61 MB
Controller render start	8.42 MB
View render complete	8.86 MB

Timers

Total Request Time: 442 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	52.24
Event: Controller.initialize	1.64
Event: Controller.startup	0.59
Controller action	303.40
Event: Controller.beforeRender	22.60
» Processing toolbar data	22.46
Rendering View	4.67
» Event: View.beforeRender	0.03
» Rendering APP/View/Applications/view.ctp	0.49
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	3.78
» » Rendering APP/View/Elements/google-analytics.ctp	0.07
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- publicActions(array)
 approved(array)
 labelApproved
 date13-01-2025
 stopped(array)
 labelStopped
 date29-02-2024
- application(array)
 Application(array)
 id2
 user_id29
 application_id(null)
 is_child0
 trial_status_id4
 trial_status_date2024-02-29 09:07:33
 total_sites2
 abstract_of_study Abstract
 study_title Sample Title
 laymans_summary Some Summary
 short_titleShort Title
 protocol_noECCT/24/01/01
 reference_no(null)
 version_nov12
 date_of_protocol09-01-2024
 study_drugName
 disease_conditionSome condition
 product_type_biologicals1
 product_type_proteins1
 product_type_immunologicals1
 product_type_vaccines1
 product_type_hormones0
 product_type_toxoid0
 product_type_chemical1
 product_type_medical_device1
 product_type_chemical_namechemical name
 product_type_medical_device_namemedical device
 comparatorYes
 comparator_nameSome
 comparator_registeredSome
 comparator_countriesSome
 ecct_not_applicable0
 ecct_ref_number
 email_addressjkiprotich@intellisoftkenya.com
 applicant_covering_letter1
 applicant_protocol1
 applicant_patient_information1
 applicant_investigators_brochure1
 applicant_investigators_cv1
 applicant_signed_declaration1
 applicant_financial_declaration1
 applicant_gmp_certificate1
 applicant_indemnity_cover1
 applicant_opinion_letter1
 applicant_approval_letter1
 applicant_statement1
 applicant_participating_countries(null)
 applicant_addendum1
 applicant_fees1
 applicant_complete_form(null)
 applicant_impd1
 applicant_prev_data1
 applicant_stability_data1
 applicant_analysis_cert1
 applicant_pictorial_sample1
 applicant_gcp_training1
 applicant_dsmb_charter1
 applicant_detailed_budget1
 applicant_indemnity_pi1
 applicant_practice_license1
 applicant_registration_ctr(null)
 applicant_pan_african1
 applicant_hard_copies(null)
 applicant_signed_checklist1
 statistical_analysis_plan1
 applicant_contractual_agreement1
 declaration_applicantsome
 declaration_date109-01-2024
 declaration_principal_investigatorsome
 declaration_date209-01-2024
 protocol_not_ai_generated0
 placebo_presentNo
 study_objectives objectives
 principal_inclusion_criteria inclusion
 principal_exclusion_criteria exclusion
 primary_end_points end points
 scope_diagnosis1
 scope_prophylaxis1
 scope_therapy1
 scope_safety1
 scope_efficacy1
 scope_pharmacokinetic1
 scope_pharmacodynamic1
 scope_bioequivalence1
 scope_dose_response1
 scope_pharmacogenetic1
 scope_pharmacogenomic1
 scope_pharmacoecomomic1
 scope_others0
 scope_others_specify
 trial_human_pharmacology1
 trial_administration_humans0
 trial_bioequivalence_study1
 trial_other0
 trial_other_specify
 trial_therapeutic_exploratory1
 trial_therapeutic_confirmatory0
 trial_therapeutic_use0
 design_controlledNo
 site_capacity(null)
 staff_numbers some capacity
 other_details_explanation some
 other_details_regulatory_notapproved some
 other_details_regulatory_approved some
 other_details_regulatory_rejected some
 other_details_regulatory_halted some
 estimated_duration3some
 design_controlled_randomised
 design_controlled_open
 design_controlled_single_blind
 design_controlled_double_blind
 design_controlled_parallel_group
 design_controlled_cross_over
 design_controlled_other
 design_controlled_specify
 design_controlled_comparator
 design_controlled_other_medicinal
 design_controlled_placebo
 design_controlled_medicinal_other
 design_controlled_medicinal_specify
 single_site_member_stateNo
 location_of_area
 single_site_physical_address
 single_site_contact_person
 single_site_telephone
 multiple_sites_member_stateNo
 multiple_countriesYes
 multiple_member_states4
 number_of_sites
 multi_country_listsome four states here
 data_monitoring_committeeYes
 total_enrolment_per_site30
 total_participants_worldwide50
 population_less_than_18_yearsYes
 population_uteroYes
 population_preterm_newbornNo
 population_newbornYes
 population_infant_and_toddlerNo
 population_childrenYes
 population_adolescentNo
 population_above_18Yes
 population_adultYes
 population_elderlyNo
 gender_female1
 gender_male1
 subjects_healthyYes
 subjects_patientsYes
 subjects_vulnerable_populationsYes
 subjects_women_child_bearingNo
 subjects_women_using_contraceptionYes
 subjects_pregnant_womenNo
 subjects_nursing_womenYes
 subjects_emergency_situationNo
 subjects_incapable_consentYes
 subjects_specifysome
 subjects_othersNo
 subjects_others_specify
 investigator1_given_namesome
 investigator1_middle_namesome
 investigator1_family_namesome
 investigator1_qualificationsome
 investigator1_professional_addresssome
 investigator1_telephone254700234871
 investigator1_emailsample@gmail.com
 organisations_transferred_No
 number_participants20
 notification None
 approval_date13-01-2025
 submitted1
 deleted0
 deleted_date(null)
 deactivated0
 date_submitted22-05-2024
 unsubmitted1
 initial_date_submitted22-05-2024
 admin_stopped1
 admin_stopped_reasonVillation
 approved2
 approved_reasonHey
 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_invoice301439
 modified2025-02-13 09:04:41
 created2024-01-09 05:09:48
 ai_content(null)
 User(array)
 id29
 usernamejkiprotich
 password547f0111bc877d5579f28409dcb3dafc5439c785
 confirm_password547f0111bc877d5579f28409dcb3dafc5439c785
 nameJapheth Kiprotich
 emailjkiprotich@intellisoftkenya.com
 national_id_number32645167
 sponsor(null)
 sponsor_emailjkiprotich@intellisoftkenya.com
 qualificationDentist
 phone_no254724743788
 name_of_institution
 institution_physical
 institution_address
 institution_contact
 county_id47
 country_id115
 group_id5
 activation_key
 forgot_password0
 is_active1
 deactivated0
 created2024-01-19 06:00:03
 modified2024-10-16 14:11:49
 TrialStatus(array)
 id4
 valueStopped
 nameStopped
 created2012-10-19 16:08:51
 modified2020-04-16 10:04:18
 Review(empty)
 InternalReview(empty)
 ActiveInspector(array)
 0(array)
 id1
 user_id33
 application_id2
 typerequest
 assessment_type(null)
 titlePPB request
 text
 summary(null)
 recommendationdone
 notified0
 acceptedaccepted
 conflictNo
 statusUnsubmitted
 created2024-02-21 21:01:34
 modified2024-02-21 21:01:34
 ManagerReview(empty)
 Acceptance(empty)
 Amendment(array)
 0(array)
 id2
 application_id2
 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-06 11:57:22
 created2024-02-06 11:57:22
 InvestigatorContact(array)
 0(array)
 id2
 application_id2
 given_namesome name principal
 middle_namesome name principal
 family_namesome name principal
 qualificationsome qualofication
 professional_addresssome address
 telephone254700282716
 emailsome@gmail.com
 investigator_roleprincipal
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 ApplicationStage(array)
 0(array)
 id1
 application_id2
 stageScreening
 start_date2024-01-09
 statusComplete
 commentManager assign reviewer
 end_date2024-01-09
 created2024-01-09 06:12:54
 modified2024-01-09 06:12:54
 1(array)
 id2
 application_id2
 stageScreeningSubmission
 start_date2024-01-09
 statusComplete
 commentFrom Manager assign
 end_date2024-01-09
 created2024-01-09 08:35:13
 modified2024-01-09 08:35:13
 2(array)
 id3
 application_id2
 stageAssign
 start_date2024-01-09
 statusComplete
 commentReviewer accept
 end_date2024-01-09
 created2024-01-09 08:35:13
 modified2024-01-09 08:35:13
 3(array)
 id4
 application_id2
 stageReview
 start_date2024-01-09
 statusComplete
 commentManager review comment
 end_date2024-01-12
 created2024-01-09 08:41:17
 modified2024-01-09 08:41:17
 4(array)
 id16
 application_id2
 stageReviewSubmission
 start_date2024-01-12
 statusComplete
 commentManager final decision
 end_date2024-01-12
 created2024-01-12 08:09:56
 modified2024-01-12 08:09:56
 5(array)
 id17
 application_id2
 stageFinalDecision
 start_date2024-01-12
 statusComplete
 commentManager final decision
 end_date2024-01-12
 created2024-01-12 08:20:17
 modified2024-01-12 08:20:17
 6(array)
 id18
 application_id2
 stageAnnualApproval
 start_date2024-01-12
 statusCurrent
 commentManager letter approve
 end_date2025-02-16
 created2024-01-12 08:20:17
 modified2024-01-12 08:20:17
 Pharmacist(array)
 0(array)
 id2
 application_id2
 reg_no232
 given_namesome name
 premise_name
 qualificationsome qualification
 professional_addresssome address
 valid_year2024
 mobile
 telephone
 emailsome@gmail.com
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 EthicalCommittee(array)
 0(array)
 id2
 application_id2
 ethical_committeeAIC Kijabe Hospital
 submission_date09-01-2024
 erc_numbersomev34
 initial_approval09-01-2024
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 AnnualLetter(array)
 0(array)
 id60
 application_id2
 approval_noECCT/24/01/01/2025(32)
 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/01/01/2025(32) 13th January 2025 , Principal Investigator ECCT/24/01/01, some address, Dear Sir/Madam, Re: ECCT/24/01/01 : Initial Approval; Sample Title Short Title. Reference is made to the above study. We acknowledge receipt of the following documents; <div style="margin-left: 15px;"> 1. Cover Letter (Should list all the submitted documents, their version numbers and dates) <a href="http://45.79.161.190:8080/attachments/download/558">icon_adr.png</a> dated: 22nd May 2024 Version 1 2. The Study Protocol <a href="http://45.79.161.190:8080/attachments/download/559">icon_adr_2.png</a> dated: 22nd May 2024 Version 1 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/560">icon_adr_3.png</a> dated: 22nd May 2024 Version 1 4. Patient Information leaflet and Informed consent form <a href="http://45.79.161.190:8080/attachments/download/561">icon_adr_4.png</a> dated: 22nd May 2024 Version 1 5. Investigators Brochure/Package inserts <a href="http://45.79.161.190:8080/attachments/download/562">icon_adr_5.png</a> dated: 22nd May 2024 Version 1 6. Investigational Medicinal Product Dossier (IMPD) <a href="http://45.79.161.190:8080/attachments/download/563">icon_adr_6.png</a> dated: 22nd 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/564">icon_adr_7.png</a> dated: 22nd May 2024 Version 1 8. Stability data of the investigational product <a href="http://45.79.161.190:8080/attachments/download/565">icon_adr_8.png</a> dated: 22nd 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/566">icon_adr_9.png</a> dated: 22nd May 2024 Version 1 10. Certificate of Analysis of the investigational product <a href="http://45.79.161.190:8080/attachments/download/567">icon_adr_10.png</a> dated: 22nd 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/568">icon_adr_11.png</a> dated: 22nd 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/569">icon_adr_12.png</a> dated: 22nd May 2024 Version 1 13. Evidence of contractual agreement between sponsor and Principal Investigator. <a href="http://45.79.161.190:8080/attachments/download/570">icon_adr_13.png</a> dated: 22nd 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/571">icon_adr_14.png</a> dated: 22nd May 2024 Version 1 15. DSMB Charter including the composition and meeting schedule <a href="http://45.79.161.190:8080/attachments/download/572">icon_adr_15.png</a> dated: 22nd May 2024 Version 1 16. Detailed budget of the study <a href="http://45.79.161.190:8080/attachments/download/573">icon_adr_16.png</a> dated: 22nd May 2024 Version 1 17. Financial declaration by Sponsor and/or PI <a href="http://45.79.161.190:8080/attachments/download/574">icon_adr_17.png</a> dated: 22nd 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/575">icon_adr_18.png</a> dated: 22nd May 2024 Version 1 19. Indemnity cover for PI, investigators and study Pharmacist. <a href="http://45.79.161.190:8080/attachments/download/576">icon_adr_19.png</a> dated: 22nd May 2024 Version 1 20. Clinical Trials Insurance cover for study participants <a href="http://45.79.161.190:8080/attachments/download/577">icon_adr_20.png</a> dated: 22nd 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/578">icon_adr_21.png</a> dated: 22nd 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/579">icon_adr_22.png</a> dated: 15th 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/580">icon_adr_23.png</a> dated: 15th 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/581">icon_adr_24.png</a> dated: 22nd 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/582">icon_adr_25.png</a> dated: 15th May 2024 Version 1 26. Payment of fees <a href="http://45.79.161.190:8080/attachments/download/583">icon_adr_26.png</a> dated: 15th May 2024 Version 1 27. Statistical Analysis Plan <a href="http://45.79.161.190:8080/attachments/download/584">icon_adr_27.png</a> dated: 15th May 2024 Version 1 28. Signed Checklist <a href="http://45.79.161.190:8080/attachments/download/585">icon_adr_28.png</a> dated: 15th May 2024 Version 1 </div> After review of the documents, the Pharmacy and Poisons Board Expert Committee on Clinical Trials notes the following: The Pharmacy and Poisons Board Expert Committee on Clinical Trials grants approval to the study: Sample Title ECCT/24/01/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 13th 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_date13-01-2025
 expiry_date13-01-2026
 statussubmitted
 deleted0
 deleted_date(null)
 created2025-01-13 15:28:34
 modified2025-01-13 15:28:34
 AmendmentLetter(array)
 0(array)
 id6
 application_id2
 approval_noPPB/ECCT/24/01/01/2024(6)
 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> Dear Sir/Madam, Re: ECCT/24/01/01 : Amendment Approval; Sample Title . Reference is made to the above study. We acknowledge receipt of the following documents; <div style="margin-left: 15px;"> 1. test 15th files <a href="http://45.79.161.190:8080/attachments/download/778">table_manage.html</a> dated 6th February 2024 Version 54 2. sample description <a href="http://45.79.161.190:8080/attachments/download/779">email_detail.html</a> dated 22nd February 2024 Version 54 3. Some First Amendment File <a href="http://45.79.161.190:8080/attachments/download/780">email_detail_2.html</a> dated 29th January 2024 Version 4 4. second <a href="http://45.79.161.190:8080/attachments/download/781">email_detail_3.html</a> dated 6th February 2024 Version 4 5. Second File <a href="http://45.79.161.190:8080/attachments/download/782">table_manage_2.html</a> dated 6th February 2024 Version 5 6. Third file <a href="http://45.79.161.190:8080/attachments/download/783">table_manage_3.html</a> dated 30th January 2024 Version 6 7. hey hey hye <a href="http://45.79.161.190:8080/attachments/download/784">email_detail_4.html</a> dated 23rd February 2024 Version v45 8. w <a href="http://45.79.161.190:8080/attachments/download/785">table_manage_4.html</a> dated 16th February 2024 Version 444</div> After review of the documents, the Pharmacy and Poisons Board Expert Committee on Clinical Trials grants amendment approval to the study Sample Title . (ECCT/24/01/01). Yours Sincerely, :signature :approver For Chief Executive Officer 
 qrcodePD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZlcnNpb249IjEuMSIgd2lkdGg9IjE1MCIgaGVpZ2h0PSIxNTAiIHZpZXdCb3g9IjAgMCAxNTAgMTUwIj48cmVjdCB4PSIwIiB5PSIwIiB3aWR0aD0iMTUwIiBoZWlnaHQ9IjE1MCIgZmlsbD0iI2ZmZmZmZiIvPjxnIHRyYW5zZm9ybT0ic2NhbGUoNC41NDUpIj48ZyB0cmFuc2Zvcm09InRyYW5zbGF0ZSgwLDApIj48cGF0aCBmaWxsLXJ1bGU9ImV2ZW5vZGQiIGQ9Ik04IDBMOCAyTDEwIDJMMTAgM0w4IDNMOCA0TDEwIDRMMTAgM0wxMSAzTDExIDRMMTIgNEwxMiA1TDkgNUw5IDZMOCA2TDggOEw1IDhMNSA5TDcgOUw3IDEwTDUgMTBMNSAxMUw0IDExTDQgMTJMNSAxMkw1IDExTDcgMTFMNyAxMkw2IDEyTDYgMTNMMiAxM0wyIDEyTDMgMTJMMyAxMUwyIDExTDIgMTBMMyAxMEwzIDlMNCA5TDQgOEwyIDhMMiA5TDEgOUwxIDhMMCA4TDAgMTBMMSAxMEwxIDExTDAgMTFMMCAxNEwyIDE0TDIgMTVMMCAxNUwwIDE2TDIgMTZMMiAxNUwzIDE1TDMgMTdMMCAxN0wwIDE4TDEgMThMMSAxOUwwIDE5TDAgMjJMMiAyMkwyIDIzTDEgMjNMMSAyNEwwIDI0TDAgMjVMMSAyNUwxIDI0TDIgMjRMMiAyM0wzIDIzTDMgMjVMNCAyNUw0IDIzTDUgMjNMNSAyNEw2IDI0TDYgMjVMNyAyNUw3IDI0TDggMjRMOCAyM0w3IDIzTDcgMjJMOCAyMkw4IDIxTDkgMjFMOSAyMkwxMCAyMkwxMCAyM0w5IDIzTDkgMjVMOCAyNUw4IDI4TDEyIDI4TDEyIDI1TDE0IDI1TDE0IDI0TDEzIDI0TDEzIDIzTDEyIDIzTDEyIDIyTDEwIDIyTDEwIDIxTDEzIDIxTDEzIDIyTDE0IDIyTDE0IDIzTDE1IDIzTDE1IDI0TDE2IDI0TDE2IDIyTDE3IDIyTDE3IDIzTDE4IDIzTDE4IDIyTDIwIDIyTDIwIDIxTDE3IDIxTDE3IDIwTDE5IDIwTDE5IDE5TDE3IDE5TDE3IDE4TDE5IDE4TDE5IDE3TDIwIDE3TDIwIDE2TDIxIDE2TDIxIDE3TDIyIDE3TDIyIDE0TDIzIDE0TDIzIDEzTDI1IDEzTDI1IDE0TDI0IDE0TDI0IDE1TDIzIDE1TDIzIDE4TDI0IDE4TDI0IDE3TDI1IDE3TDI1IDE0TDI2IDE0TDI2IDExTDI3IDExTDI3IDEyTDI4IDEyTDI4IDEzTDI3IDEzTDI3IDE1TDI5IDE1TDI5IDE2TDI4IDE2TDI4IDE5TDI2IDE5TDI2IDE4TDI3IDE4TDI3IDE2TDI2IDE2TDI2IDE4TDI1IDE4TDI1IDE5TDI0IDE5TDI0IDIxTDIzIDIxTDIzIDI0TDI0IDI0TDI0IDI2TDIyIDI2TDIyIDI1TDIxIDI1TDIxIDI0TDIwIDI0TDIwIDIzTDE5IDIzTDE5IDI0TDE3IDI0TDE3IDI1TDE1IDI1TDE1IDI2TDEzIDI2TDEzIDI3TDE1IDI3TDE1IDI2TDE3IDI2TDE3IDI3TDE2IDI3TDE2IDI4TDEzIDI4TDEzIDMwTDExIDMwTDExIDI5TDggMjlMOCAzMUw5IDMxTDkgMzBMMTAgMzBMMTAgMzJMOCAzMkw4IDMzTDEwIDMzTDEwIDMyTDExIDMyTDExIDMzTDEzIDMzTDEzIDMyTDE1IDMyTDE1IDMxTDE3IDMxTDE3IDMyTDE2IDMyTDE2IDMzTDE4IDMzTDE4IDMxTDE5IDMxTDE5IDMzTDI0IDMzTDI0IDMyTDI3IDMyTDI3IDMxTDI4IDMxTDI4IDMyTDI5IDMyTDI5IDMxTDMwIDMxTDMwIDMwTDMxIDMwTDMxIDI5TDMyIDI5TDMyIDMwTDMzIDMwTDMzIDI4TDMxIDI4TDMxIDI3TDMwIDI3TDMwIDI5TDI5IDI5TDI5IDI2TDMwIDI2TDMwIDI1TDMyIDI1TDMyIDI0TDMzIDI0TDMzIDE5TDMyIDE5TDMyIDE4TDMzIDE4TDMzIDE3TDMxIDE3TDMxIDE0TDMyIDE0TDMyIDEyTDMxIDEyTDMxIDEzTDMwIDEzTDMwIDEwTDMxIDEwTDMxIDExTDMzIDExTDMzIDhMMzEgOEwzMSA5TDMwIDlMMzAgOEwyOSA4TDI5IDEwTDI4IDEwTDI4IDlMMjcgOUwyNyA4TDI2IDhMMjYgOUwyNCA5TDI0IDhMMjUgOEwyNSA0TDI0IDRMMjQgM0wyNSAzTDI1IDJMMjQgMkwyNCAxTDI1IDFMMjUgMEwyMSAwTDIxIDFMMjAgMUwyMCAwTDE5IDBMMTkgMUwxOCAxTDE4IDNMMTcgM0wxNyA0TDE2IDRMMTYgM0wxNSAzTDE1IDFMMTQgMUwxNCAyTDEyIDJMMTIgM0wxMSAzTDExIDJMMTAgMkwxMCAxTDExIDFMMTEgMFpNMTIgMEwxMiAxTDEzIDFMMTMgMFpNMTYgMEwxNiAyTDE3IDJMMTcgMFpNMTkgMUwxOSAzTDIwIDNMMjAgNkwxOSA2TDE5IDVMMTggNUwxOCA0TDE3IDRMMTcgN0wxOCA3TDE4IDEwTDE5IDEwTDE5IDExTDIwIDExTDIwIDEyTDE5IDEyTDE5IDE0TDE3IDE0TDE3IDEzTDE2IDEzTDE2IDEyTDE4IDEyTDE4IDExTDE2IDExTDE2IDlMMTQgOUwxNCA1TDE2IDVMMTYgNEwxNSA0TDE1IDNMMTIgM0wxMiA0TDE0IDRMMTQgNUwxMiA1TDEyIDZMMTEgNkwxMSA3TDEwIDdMMTAgNkw5IDZMOSA3TDEwIDdMMTAgOEw4IDhMOCAxMEwxMCAxMEwxMCAxMUwxMSAxMUwxMSAxMEwxMiAxMEwxMiAxMUwxMyAxMUwxMyAxMkw5IDEyTDkgMTFMOCAxMUw4IDEyTDkgMTJMOSAxM0wxMCAxM0wxMCAxNEwxMSAxNEwxMSAxM0wxMiAxM0wxMiAxNUwxMSAxNUwxMSAxNkwxMCAxNkwxMCAxNUw4IDE1TDggMTRMNyAxNEw3IDEzTDYgMTNMNiAxNEw3IDE0TDcgMTVMNiAxNUw2IDE2TDcgMTZMNyAxN0w2IDE3TDYgMThMNSAxOEw1IDE2TDQgMTZMNCAxN0wzIDE3TDMgMThMMiAxOEwyIDE5TDEgMTlMMSAyMEwyIDIwTDIgMTlMMyAxOUwzIDE4TDQgMThMNCAyMEw1IDIwTDUgMjFMMyAyMUwzIDIzTDQgMjNMNCAyMkw3IDIyTDcgMjFMNiAyMUw2IDIwTDggMjBMOCAxOUw5IDE5TDkgMjFMMTAgMjFMMTAgMjBMMTMgMjBMMTMgMjFMMTQgMjFMMTQgMTlMMTUgMTlMMTUgMjFMMTYgMjFMMTYgMjBMMTcgMjBMMTcgMTlMMTUgMTlMMTUgMTdMMTYgMTdMMTYgMThMMTcgMThMMTcgMTdMMTkgMTdMMTkgMTZMMTggMTZMMTggMTVMMTkgMTVMMTkgMTRMMjIgMTRMMjIgMTJMMjUgMTJMMjUgMTFMMjIgMTFMMjIgMTBMMjEgMTBMMjEgOUwyMCA5TDIwIDhMMjIgOEwyMiA1TDIzIDVMMjMgOEwyNCA4TDI0IDRMMjIgNEwyMiAyTDIwIDJMMjAgMVpNMTIgNkwxMiA3TDExIDdMMTEgOUwxMiA5TDEyIDEwTDEzIDEwTDEzIDExTDE0IDExTDE0IDlMMTMgOUwxMyA2Wk0xNSA2TDE1IDdMMTYgN0wxNiA2Wk0xOCA2TDE4IDdMMTkgN0wxOSA4TDIwIDhMMjAgN0wyMSA3TDIxIDZMMjAgNkwyMCA3TDE5IDdMMTkgNlpNMTkgOUwxOSAxMEwyMCAxMEwyMCAxMUwyMSAxMUwyMSAxMEwyMCAxMEwyMCA5Wk0zMSA5TDMxIDEwTDMyIDEwTDMyIDlaTTEgMTFMMSAxMkwyIDEyTDIgMTFaTTI4IDExTDI4IDEyTDI5IDEyTDI5IDExWk0xNCAxMkwxNCAxM0wxMyAxM0wxMyAxNUwxNCAxNUwxNCAxNkwxNiAxNkwxNiAxNUwxNSAxNUwxNSAxMlpNMjggMTNMMjggMTRMMjkgMTRMMjkgMTVMMzAgMTVMMzAgMTNaTTMgMTRMMyAxNUw0IDE1TDQgMTRaTTExIDE2TDExIDE3TDEyIDE3TDEyIDE4TDEwIDE4TDEwIDE3TDkgMTdMOSAxOUwxMiAxOUwxMiAxOEwxNCAxOEwxNCAxN0wxMiAxN0wxMiAxNlpNMjkgMTZMMjkgMTdMMzAgMTdMMzAgMThMMjkgMThMMjkgMjBMMjYgMjBMMjYgMTlMMjUgMTlMMjUgMjFMMjQgMjFMMjQgMjRMMjcgMjRMMjcgMjNMMjggMjNMMjggMjRMMjkgMjRMMjkgMjBMMzEgMjBMMzEgMjJMMzAgMjJMMzAgMjRMMzIgMjRMMzIgMjNMMzEgMjNMMzEgMjJMMzIgMjJMMzIgMjBMMzEgMjBMMzEgMTlMMzAgMTlMMzAgMThMMzEgMThMMzEgMTdMMzAgMTdMMzAgMTZaTTcgMTdMNyAxOEw2IDE4TDYgMTlMNyAxOUw3IDE4TDggMThMOCAxN1pNMjAgMThMMjAgMjBMMjEgMjBMMjEgMjJMMjIgMjJMMjIgMjBMMjEgMjBMMjEgMThaTTI2IDIxTDI2IDIyTDI1IDIyTDI1IDIzTDI3IDIzTDI3IDIxWk02IDIzTDYgMjRMNyAyNEw3IDIzWk0xMCAyM0wxMCAyNUwxMSAyNUwxMSAyNEwxMiAyNEwxMiAyM1pNMTcgMjVMMTcgMjZMMTggMjZMMTggMjVaTTI1IDI1TDI1IDI4TDI4IDI4TDI4IDI1Wk05IDI2TDkgMjdMMTAgMjdMMTAgMjZaTTIxIDI2TDIxIDI3TDE5IDI3TDE5IDI5TDE3IDI5TDE3IDMxTDE4IDMxTDE4IDMwTDE5IDMwTDE5IDMxTDIwIDMxTDIwIDMyTDI0IDMyTDI0IDMxTDI2IDMxTDI2IDMwTDI4IDMwTDI4IDMxTDI5IDMxTDI5IDI5TDI2IDI5TDI2IDMwTDI0IDMwTDI0IDI5TDIzIDI5TDIzIDMwTDI0IDMwTDI0IDMxTDIyIDMxTDIyIDMwTDIwIDMwTDIwIDI5TDIxIDI5TDIxIDI3TDIyIDI3TDIyIDI2Wk0yNiAyNkwyNiAyN0wyNyAyN0wyNyAyNlpNMjMgMjdMMjMgMjhMMjQgMjhMMjQgMjdaTTE0IDI5TDE0IDMwTDEzIDMwTDEzIDMxTDEyIDMxTDEyIDMyTDEzIDMyTDEzIDMxTDE1IDMxTDE1IDMwTDE2IDMwTDE2IDI5Wk0zMiAzMUwzMiAzMkwzMyAzMkwzMyAzMVpNMzAgMzJMMzAgMzNMMzEgMzNMMzEgMzJaTTAgMEwwIDdMNyA3TDcgMFpNMSAxTDEgNkw2IDZMNiAxWk0yIDJMMiA1TDUgNUw1IDJaTTI2IDBMMjYgN0wzMyA3TDMzIDBaTTI3IDFMMjcgNkwzMiA2TDMyIDFaTTI4IDJMMjggNUwzMSA1TDMxIDJaTTAgMjZMMCAzM0w3IDMzTDcgMjZaTTEgMjdMMSAzMkw2IDMyTDYgMjdaTTIgMjhMMiAzMUw1IDMxTDUgMjhaIiBmaWxsPSIjMDAwMDAwIi8+PC9nPjwvZz48L3N2Zz4K
 approvermanager
 approval_date2024-06-19
 expiry_date2025-03-07
 statusamd-5
 submitted1
 deleted0
 deleted_date(null)
 created2024-06-19 10:19:16
 modified2024-06-19 10:20:02
 AmendmentApproval(array)
 0(array)
 id6
 application_id2
 approval_no(null)
 amendmentamd-5
 contenttest
 approver(null)
 approval_date19-06-2024
 statusapproved
 deleted0
 deleted_date(null)
 created2024-06-19 10:19:15
 modified2024-06-19 10:19:15
 AmendmentApprovalSummary(empty)
 Organization(array)
 0(array)
 id2
 application_id2
 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-01-09 05:37:44
 modified2024-06-25 08:22:28
 SiteDetail(array)
 0(array)
 id1639
 application_id2
 county_id(null)
 site_name
 physical_address
 contact_details
 contact_person
 site_capacity(null)
 misc(null)
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 Placebo(array)
 0(array)
 id2
 application_id2
 placebo_present(null)
 pharmaceutical_form
 route_of_administration
 composition
 identical_indp
 major_ingredients
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 Sponsor(array)
 0(array)
 id14
 application_id2
 sponsorsome sponsor
 sponsor_typeIndustry
 contact_personsome contact person
 addressaddress
 telephone_number0700432422
 fax_number
 cell_number0700434343
 email_addresssponsor@gmail.com
 created2024-05-22 16:52:09
 modified2024-06-25 08:22:28
 SiteInspection(array)
 0(array)
 id8
 application_id2
 user_id2
 reference_noSI/2024/08
 study_title Sample Title
 protocol_noECCT/24/01/01
 version_no(null)
 pactr_number(null)
 trial_phaseHuman pharmacology (Phase I) : Bioequivalence study Therapeutic exploratory (Phase II)
 investigatorssome some Tel: 254700234871 Email: sample@gmail.com
 co_investigators1 some name some name Email: some@gmail.com
 study_stage(null)
 inspection_countrysome four states here
 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-01 10:09:06
 modified2024-02-01 10:09:06
 1(array)
 id18
 application_id2
 user_id2
 reference_noSI/2024/18
 study_title Sample Title
 protocol_noECCT/24/01/01
 version_no(null)
 pactr_number(null)
 trial_phaseHuman pharmacology (Phase I) : Bioequivalence study Therapeutic exploratory (Phase II)
 investigatorssome some Tel: 254700234871 Email: sample@gmail.com
 co_investigators1 some name some name Email: some@gmail.com
 study_stage(null)
 inspection_countrysome four states here
 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-14 14:50:38
 modified2024-02-14 14:50:38
 2(array)
 id19
 application_id2
 user_id33
 reference_noSI/2024/19
 study_title Sample Title
 protocol_noECCT/24/01/01
 version_no(null)
 pactr_number
 trial_phaseHuman pharmacology (Phase I) : Bioequivalence studyTherapeutic exploratory (Phase II)
 investigatorssome some Tel: 254700234871 Email: sample@gmail.com
 co_investigators1 some name some name Email: some@gmail.com
 study_stageBefore trial commencement
 inspection_countrysome four states here
 inspector_names
 inspection_dates
 site_address
 sponsor_address
 lab_address
 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-14 15:07:31
 modified2024-02-14 15:08:36
 3(array)
 id20
 application_id2
 user_id33
 reference_noSI/2024/20
 study_title Sample Title
 protocol_noECCT/24/01/01
 version_no(null)
 pactr_number(null)
 trial_phaseHuman pharmacology (Phase I) : Bioequivalence study Therapeutic exploratory (Phase II)
 investigatorssome some Tel: 254700234871 Email: sample@gmail.com
 co_investigators1 some name some name Email: some@gmail.com
 study_stage(null)
 inspection_countrysome four states here
 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-14 17:44:57
 modified2024-02-14 17:44:57
 4(array)
 id28
 application_id2
 user_id33
 reference_noSI/2024/23
 study_title Sample Title
 protocol_noECCT/24/01/01
 version_no(null)
 pactr_number(null)
 trial_phaseHuman pharmacology (Phase I) : Bioequivalence study Therapeutic exploratory (Phase II)
 investigatorssome some Tel: 254700234871 Email: sample@gmail.com
 co_investigators1 some name some name Email: some@gmail.com
 study_stage(null)
 inspection_countrysome four states here
 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 05:16:53
 modified2024-02-15 05:16:53
 Sae(empty)
 Ciom(array)
 0(array)
 id6
 application_id2
 reference_no(null)
 user_id48
 reporter_emailj.k.i.p.r.o.tich@intellisoftkenya.com
 e2b_content<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE ichicsr SYSTEM "http://eudravigilance.ema.europa.eu/dtd/icsr21xml.dtd"> <ichicsr lang="en"> <ichicsrmessageheader lang="en"> <messagetype>ichicsr</messagetype> <messageformatversion>2.1</messageformatversion> <messageformatrelease>2.0</messageformatrelease> <messagenumb>KE-PPB-2024-1663</messagenumb> <messagesenderidentifier>PPB</messagesenderidentifier> <messagereceiveridentifier>KE</messagereceiveridentifier> <messagedateformat>204</messagedateformat> <messagedate>20240527125941</messagedate> </ichicsrmessageheader> <safetyreport lang="en"> <safetyreportversion>1</safetyreportversion> <safetyreportid>KE-PPB-AEFI/2024/22</safetyreportid> <primarysourcecountry>KE</primarysourcecountry> <occurcountry>KE</occurcountry> <transmissiondateformat/> <transmissiondate/> <reporttype>1</reporttype> <serious>2</serious> <seriousnessdeath>2</seriousnessdeath> <seriousnesslifethreatening>2</seriousnesslifethreatening> <seriousnesshospitalization>2</seriousnesshospitalization> <seriousnessdisabling>2</seriousnessdisabling> <seriousnesscongenitalanomali>2</seriousnesscongenitalanomali> <seriousnessother>2</seriousnessother> <receivedateformat>102</receivedateformat> <receivedate>20240527</receivedate> <receiptdateformat>102</receiptdateformat> <receiptdate>20240527</receiptdate> <additionaldocument>2</additionaldocument> <documentlist></documentlist> <fulfillexpeditecriteria>2</fulfillexpeditecriteria> <authoritynumb>KE-PPB-AEFI/2024/22</authoritynumb> <companynumb/> <duplicate/> <casenullification/> <nullificationreason/> <medicallyconfirm>1</medicallyconfirm> <primarysource> <reportergivename>Christine</reportergivename> <reporterfamilyname> </reporterfamilyname> <reporterorganization>Kasarani A 2</reporterorganization> <reporterdepartment/> <reporterstreet/> <reportercity/> <reporterstate/> <reporterpostcode/> <reportercountry>KE</reportercountry> <qualification>1</qualification> <literaturereference/> <studyname/> <sponsorstudynumb/> <observestudytype/> </primarysource> <sender> <sendertype>3</sendertype> <senderorganization>Pharmacy and Poisons Board</senderorganization> <senderdepartment>Department of Pharmacovigilance</senderdepartment> <sendertitle>Dr.</sendertitle> <sendergivename>Christabel</sendergivename> <sendermiddlename>N.</sendermiddlename> <senderfamilyname>Khaemba</senderfamilyname> <senderstreetaddress>P.O. Box:27663-00506</senderstreetaddress> <sendercity>Nairobi</sendercity> <senderstate/> <senderpostcode>00506</senderpostcode> <sendercountrycode>KE</sendercountrycode> <sendertel>720608811</sendertel> <sendertelextension/> <sendertelcountrycode>254</sendertelcountrycode> <senderfax>2713409</senderfax> <senderfaxextension>20</senderfaxextension> <senderfaxcountrycode>254</senderfaxcountrycode> <senderemailaddress>pv@pharmacyboardkenya.org</senderemailaddress> </sender> <receiver> <receivertype/> <receiverorganization/> <receiverdepartment/> <receivertitle/> <receivergivename/> <receivermiddlename/> <receiverfamilyname/> <receiverstreetaddress/> <receivercity/> <receiverstate/> <receiverpostcode/> <receivercountrycode/> <receivertel/> <receivertelextension/> <receivertelcountrycode/> <receiverfax/> <receiverfaxextension/> <receiverfaxcountrycode/> <receiveremailaddress/> </receiver> <patient> <patientinitial>L.M</patientinitial> <patientgpmedicalrecordnumb>22222</patientgpmedicalrecordnumb> <patientspecialistrecordnumb>22222</patientspecialistrecordnumb> <patienthospitalrecordnumb>22222</patienthospitalrecordnumb> <patientinvestigationnumb/> <patientbirthdateformat>102</patientbirthdateformat> <patientbirthdate>20060118</patientbirthdate> <patientonsetage/><patientonsetageunit/> <gestationperiod/> <gestationperiodunit/> <patientagegroup/> <patientweight/> <patientheight/> <patientsex>1</patientsex> <lastmenstrualdateformat/> <patientlastmenstrualdate/> <patientmedicalhistorytext></patientmedicalhistorytext> <resultstestsprocedures/> <patientdeath> <patientdeathdateformat/> <patientdeathdate/> <patientautopsyyesno/> </patientdeath> <reaction> <primarysourcereaction> Severe, </primarysourcereaction> <reactionmeddraversionllt>23.0</reactionmeddraversionllt> <reactionmeddrallt>Swelling</reactionmeddrallt> <reactionmeddraversionpt/> <reactionmeddrapt/> <termhighlighted/> <reactionstartdateformat>102</reactionstartdateformat><reactionstartdate>20240524</reactionstartdate> <reactionenddateformat/> <reactionenddate/> <reactionduration/> <reactiondurationunit/> <reactionfirsttime/> <reactionfirsttimeunit/> <reactionlasttime/> <reactionlasttimeunit/> <reactionoutcome>1</reactionoutcome> </reaction> <drug> <drugcharacterization>1</drugcharacterization> <medicinalproduct>Bivalent oral Polio vaccine</medicinalproduct> <obtaindrugcountry/> <drugbatchnumb>4444444</drugbatchnumb> <drugauthorizationnumb/> <drugauthorizationcountry/> <drugauthorizationholder/> <drugstructuredosagenumb>1</drugstructuredosagenumb> <drugstructuredosageunit><pre class="cake-error"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-trace').style.display = (document.getElementById('cakeErr6654598d02eb4-trace').style.display == 'none' ? '' : 'none');">Notice (8)</a>: Undefined variable: sadrListOfDrug [APP/View/Aefis/xml/download_r2.ctp, line 260]<div id="cakeErr6654598d02eb4-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-code').style.display = (document.getElementById('cakeErr6654598d02eb4-code').style.display == 'none' ? '' : 'none')">Code</a> <a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-context').style.display = (document.getElementById('cakeErr6654598d02eb4-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr6654598d02eb4-code" class="cake-code-dump" style="display: none;"><code> <drugstructuredosagenumb><?php echo $listOfVaccine['dosage']; ?></drugstructuredosagenumb></code> <code> <drugstructuredosageunit><?php</code> <code> echo $sadrListOfDrug['Dose']['icsr_code'];</code></pre><pre id="cakeErr6654598d02eb4-context" class="cake-context" style="display: none;">$viewFile = '/var/www/pvers/app/View/Aefis/xml/download_r2.ctp' $dataForView = array( 'debugToolbarPanels' => array( 'history' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'history_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'session' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'session_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'request' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'request_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'sql_log' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'sql_log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'timer' => array( 'content' => null, 'elementName' => 'timer_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'log' => array( 'content' => object(DebugKitLog) {}, 'elementName' => 'log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'variables' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'variables_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'environment' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'environment_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'include' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'include_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ) ), 'debugToolbarJavascript' => array( 'libs' => 'DebugKit./js/js_debug_toolbar' ), 'debugToolbarCss' => array( (int) 0 => 'DebugKit./css/debug_toolbar.css' ), 'aefi' => array( 'Aefi' => array( 'id' => '1663', 'user_id' => '9282', 'pqmp_id' => null, 'reference_no' => 'AEFI/2024/22', 'aefi_id' => null, 'county_id' => '42', 'sub_county_id' => '237', 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => '6', 'report_type' => 'Initial', 'name_of_institution' => 'Kasarani A 2', 'institution_code' => '', 'patient_name' => 'L.M', 'guardian_name' => '', 'patient_address' => '', 'patient_phone' => '', 'patient_village' => '', 'ip_no' => '22222', 'date_of_birth' => array( [maximum depth reached] ), 'age_months' => null, 'age_group' => null, 'patient_ward' => '', 'patient_county' => '', 'patient_sub_county' => '', 'vaccination_center' => '', 'vaccination_county' => '', 'vaccination_type' => 'static', 'gender' => 'Male', 'bcg' => false, 'convulsion' => false, 'urticaria' => false, 'high_fever' => false, 'abscess' => false, 'local_reaction' => '1', 'anaphylaxis' => false, 'meningitis' => false, 'paralysis' => false, 'toxic_shock' => false, 'complaint_other' => false, 'complaint_other_specify' => null, 'description_of_reaction' => 'Swelling of feet.', 'date_aefi_started' => '24-05-2024', 'time_aefi_started' => array( [maximum depth reached] ), 'aefi_symptoms' => 'Swelling', 'serious' => 'No', 'serious_yes' => null, 'serious_other' => '', 'medical_history' => '', 'treatment_given' => '', 'specimen_collected' => '', 'outcome' => 'Recovered/Resolved', 'reporter_name' => 'Christine ', 'reporter_email' => 'Cgichuki@intellisoftkenya.com', 'reporter_phone' => '0700212343', 'reporter_date' => '27-05-2024', 'submitted' => '2', 'submitted_date' => '2024-05-27 11:59:49', 'active' => '1', 'device' => '0', 'copied' => '0', 'archived' => '0', 'archived_date' => null, 'deleted' => false, 'deleted_date' => null, 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49', 'person_submitting' => '', 'reporter_name_diff' => '', 'reporter_designation_diff' => null, 'reporter_email_diff' => '', 'reporter_phone_diff' => '', 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'reactions' => array( [maximum depth reached] ) ), 'County' => array( 'id' => '42', 'county_name' => 'Kisumu', 'org_unit' => 'tAbBVBbueqD', 'created' => '2012-06-15 10:27:02', 'modified' => '2012-06-15 10:27:02' ), 'SubCounty' => array( 'id' => '237', 'county_id' => '42', 'sub_county_name' => 'KISUMU EAST', 'county_name' => 'Kisumu', 'Province' => 'NYANZA', 'Pop_2009' => '150124', 'RegVoters' => '55267', 'AreaSqKms' => '136', 'CAWards' => '5', 'MainEthnicGroup' => 'LUO', 'created' => null, 'modified' => null ), 'Designation' => array( 'id' => '6', 'name' => 'Physician', 'category' => '1', 'created' => null, 'modified' => '2021-02-27 17:50:26' ), 'AefiOriginal' => array( 'id' => null, 'user_id' => null, 'pqmp_id' => null, 'reference_no' => null, 'aefi_id' => null, 'county_id' => null, 'sub_county_id' => null, 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => null, 'report_type' => null, 'name_of_institution' => null, 'institution_code' => null, 'patient_name' => null, 'guardian_name' => null, 'patient_address' => null, 'patient_phone' => null, 'patient_village' => null, 'ip_no' => null, 'date_of_birth' => null, 'age_months' => null, 'age_group' => null, 'patient_ward' => null, 'patient_county' => null, 'patient_sub_county' => null, 'vaccination_center' => null, 'vaccination_county' => null, 'vaccination_type' => null, 'gender' => null, 'bcg' => null, 'convulsion' => null, 'urticaria' => null, 'high_fever' => null, 'abscess' => null, 'local_reaction' => null, 'anaphylaxis' => null, 'meningitis' => null, 'paralysis' => null, 'toxic_shock' => null, 'complaint_other' => null, 'complaint_other_specify' => null, 'description_of_reaction' => null, 'date_aefi_started' => null, 'time_aefi_started' => null, 'aefi_symptoms' => null, 'serious' => null, 'serious_yes' => null, 'serious_other' => null, 'medical_history' => null, 'treatment_given' => null, 'specimen_collected' => null, 'outcome' => null, 'reporter_name' => null, 'reporter_email' => null, 'reporter_phone' => null, 'reporter_date' => null, 'submitted' => null, 'submitted_date' => null, 'active' => null, 'device' => null, 'copied' => null, 'archived' => null, 'archived_date' => null, 'deleted' => null, 'deleted_date' => null, 'created' => null, 'modified' => null, 'person_submitting' => null, 'reporter_name_diff' => null, 'reporter_designation_diff' => null, 'reporter_email_diff' => null, 'reporter_phone_diff' => null, 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'AefiOriginal' => array([maximum depth reached]) ), 'AefiDescription' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ), 'Attachment' => array(), 'AefiListOfVaccine' => array( (int) 0 => array( [maximum depth reached] ) ), 'ExternalComment' => array() ), 'root' => '/', 'redir' => 'manager' ) $debugToolbarPanels = array( 'history' => array( 'content' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ) ), 'elementName' => 'history_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'session' => array( 'content' => array( 'Config' => array( [maximum depth reached] ), 'Auth' => array( [maximum depth reached] ) ), 'elementName' => 'session_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'request' => array( 'content' => array( 'params' => array( [maximum depth reached] ), 'url' => 'aefis/download/1663/2.xml', 'query' => array([maximum depth reached]), 'data' => array([maximum depth reached]), 'get' => array([maximum depth reached]), 'currentRoute' => object(CakeRoute) {} ), 'elementName' => 'request_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'sql_log' => array( 'content' => array( 'connections' => array( [maximum depth reached] ), 'threshold' => (int) 20 ), 'elementName' => 'sql_log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'timer' => array( 'content' => null, 'elementName' => 'timer_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'log' => array( 'content' => object(DebugKitLog) {}, 'elementName' => 'log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'variables' => array( 'content' => array( 'aefi' => array( [maximum depth reached] ), 'root' => '/', 'redir' => 'manager', '$request->data' => array([maximum depth reached]) ), 'elementName' => 'variables_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'environment' => array( 'content' => array( 'php' => array( [maximum depth reached] ), 'cake' => array( [maximum depth reached] ), 'app' => array( [maximum depth reached] ) ), 'elementName' => 'environment_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'include' => array( 'content' => array( 'core' => array( [maximum depth reached] ), 'app' => array( [maximum depth reached] ), 'plugins' => array( [maximum depth reached] ), 'paths' => array( [maximum depth reached] ) ), 'elementName' => 'include_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ) ) $debugToolbarJavascript = array( 'libs' => 'DebugKit./js/js_debug_toolbar' ) $debugToolbarCss = array( (int) 0 => 'DebugKit./css/debug_toolbar.css' ) $aefi = array( 'Aefi' => array( 'id' => '1663', 'user_id' => '9282', 'pqmp_id' => null, 'reference_no' => 'AEFI/2024/22', 'aefi_id' => null, 'county_id' => '42', 'sub_county_id' => '237', 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => '6', 'report_type' => 'Initial', 'name_of_institution' => 'Kasarani A 2', 'institution_code' => '', 'patient_name' => 'L.M', 'guardian_name' => '', 'patient_address' => '', 'patient_phone' => '', 'patient_village' => '', 'ip_no' => '22222', 'date_of_birth' => array( 'day' => '18', 'month' => '01', 'year' => '2006' ), 'age_months' => null, 'age_group' => null, 'patient_ward' => '', 'patient_county' => '', 'patient_sub_county' => '', 'vaccination_center' => '', 'vaccination_county' => '', 'vaccination_type' => 'static', 'gender' => 'Male', 'bcg' => false, 'convulsion' => false, 'urticaria' => false, 'high_fever' => false, 'abscess' => false, 'local_reaction' => '1', 'anaphylaxis' => false, 'meningitis' => false, 'paralysis' => false, 'toxic_shock' => false, 'complaint_other' => false, 'complaint_other_specify' => null, 'description_of_reaction' => 'Swelling of feet.', 'date_aefi_started' => '24-05-2024', 'time_aefi_started' => array( 'hour' => '00', 'min' => '00' ), 'aefi_symptoms' => 'Swelling', 'serious' => 'No', 'serious_yes' => null, 'serious_other' => '', 'medical_history' => '', 'treatment_given' => '', 'specimen_collected' => '', 'outcome' => 'Recovered/Resolved', 'reporter_name' => 'Christine ', 'reporter_email' => 'Cgichuki@intellisoftkenya.com', 'reporter_phone' => '0700212343', 'reporter_date' => '27-05-2024', 'submitted' => '2', 'submitted_date' => '2024-05-27 11:59:49', 'active' => '1', 'device' => '0', 'copied' => '0', 'archived' => '0', 'archived_date' => null, 'deleted' => false, 'deleted_date' => null, 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49', 'person_submitting' => '', 'reporter_name_diff' => '', 'reporter_designation_diff' => null, 'reporter_email_diff' => '', 'reporter_phone_diff' => '', 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'reactions' => array( (int) 0 => array( [maximum depth reached] ) ) ), 'County' => array( 'id' => '42', 'county_name' => 'Kisumu', 'org_unit' => 'tAbBVBbueqD', 'created' => '2012-06-15 10:27:02', 'modified' => '2012-06-15 10:27:02' ), 'SubCounty' => array( 'id' => '237', 'county_id' => '42', 'sub_county_name' => 'KISUMU EAST', 'county_name' => 'Kisumu', 'Province' => 'NYANZA', 'Pop_2009' => '150124', 'RegVoters' => '55267', 'AreaSqKms' => '136', 'CAWards' => '5', 'MainEthnicGroup' => 'LUO', 'created' => null, 'modified' => null ), 'Designation' => array( 'id' => '6', 'name' => 'Physician', 'category' => '1', 'created' => null, 'modified' => '2021-02-27 17:50:26' ), 'AefiOriginal' => array( 'id' => null, 'user_id' => null, 'pqmp_id' => null, 'reference_no' => null, 'aefi_id' => null, 'county_id' => null, 'sub_county_id' => null, 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => null, 'report_type' => null, 'name_of_institution' => null, 'institution_code' => null, 'patient_name' => null, 'guardian_name' => null, 'patient_address' => null, 'patient_phone' => null, 'patient_village' => null, 'ip_no' => null, 'date_of_birth' => null, 'age_months' => null, 'age_group' => null, 'patient_ward' => null, 'patient_county' => null, 'patient_sub_county' => null, 'vaccination_center' => null, 'vaccination_county' => null, 'vaccination_type' => null, 'gender' => null, 'bcg' => null, 'convulsion' => null, 'urticaria' => null, 'high_fever' => null, 'abscess' => null, 'local_reaction' => null, 'anaphylaxis' => null, 'meningitis' => null, 'paralysis' => null, 'toxic_shock' => null, 'complaint_other' => null, 'complaint_other_specify' => null, 'description_of_reaction' => null, 'date_aefi_started' => null, 'time_aefi_started' => null, 'aefi_symptoms' => null, 'serious' => null, 'serious_yes' => null, 'serious_other' => null, 'medical_history' => null, 'treatment_given' => null, 'specimen_collected' => null, 'outcome' => null, 'reporter_name' => null, 'reporter_email' => null, 'reporter_phone' => null, 'reporter_date' => null, 'submitted' => null, 'submitted_date' => null, 'active' => null, 'device' => null, 'copied' => null, 'archived' => null, 'archived_date' => null, 'deleted' => null, 'deleted_date' => null, 'created' => null, 'modified' => null, 'person_submitting' => null, 'reporter_name_diff' => null, 'reporter_designation_diff' => null, 'reporter_email_diff' => null, 'reporter_phone_diff' => null, 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'AefiOriginal' => array() ), 'AefiDescription' => array( (int) 0 => array( 'id' => '1663', 'aefi_id' => '1663', 'description' => 'Swelling', 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49' ), (int) 1 => array( 'id' => '1663', 'aefi_id' => '1663', 'description' => 'Severe', 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49' ) ), 'Attachment' => array(), 'AefiListOfVaccine' => array( (int) 0 => array( 'id' => '922', 'aefi_id' => '1663', 'saefi_id' => null, 'vaccine_id' => '14', 'vaccine_name' => '', 'vaccination_date' => '24-05-2024', 'vaccination_time' => array( [maximum depth reached] ), 'vaccine_manufacturer' => 'KKKTTTR', 'vaccination_route' => 'Intramuscular', 'vaccination_site' => 'left arm', 'dosage' => '1', 'icsr_code' => null, 'batch_number' => '4444444', 'expiry_date' => '27-05-2025', 'diluent_batch_number' => 'N/A', 'diluent_manufacturer' => 'YYYYY', 'diluent_expiry_date' => '19-05-2025', 'suspected_drug' => null, 'created' => '2024-05-27 11:56:22', 'modified' => '2024-05-27 11:59:49', 'Vaccine' => array( [maximum depth reached] ) ) ), 'ExternalComment' => array() ) $root = '/' $redir = 'manager' $arr = array( (int) 0 => 'Christine', (int) 1 => '' ) $birthdatef = (int) 102 $outcomes = array( 'Recovered/Resolved' => (int) 1, 'Recovering/Resolving' => (int) 2, 'Recovered/Resolved with sequelae' => (int) 3, 'Not recovered/Not resolved/Ongoing' => (int) 4, 'Fatal' => (int) 5, 'Unknown' => (int) 6 ) $listOfVaccine = array( 'id' => '922', 'aefi_id' => '1663', 'saefi_id' => null, 'vaccine_id' => '14', 'vaccine_name' => '', 'vaccination_date' => '24-05-2024', 'vaccination_time' => array( 'hour' => '12', 'min' => '20' ), 'vaccine_manufacturer' => 'KKKTTTR', 'vaccination_route' => 'Intramuscular', 'vaccination_site' => 'left arm', 'dosage' => '1', 'icsr_code' => null, 'batch_number' => '4444444', 'expiry_date' => '27-05-2025', 'diluent_batch_number' => 'N/A', 'diluent_manufacturer' => 'YYYYY', 'diluent_expiry_date' => '19-05-2025', 'suspected_drug' => null, 'created' => '2024-05-27 11:56:22', 'modified' => '2024-05-27 11:59:49', 'Vaccine' => array( 'id' => '14', 'vaccine_name' => 'Bivalent oral Polio vaccine', 'description' => 'Liquid Suspension - 20 doses per vial', 'health_program' => 'National Vaccines and immunisation program', 'created' => '2021-02-01 11:44:27', 'modified' => '2021-02-01 11:44:27', 'deleted' => false, 'deleted_date' => null ) ) $num = (int) 0</pre><pre class="stack-trace">include - APP/View/Aefis/xml/download_r2.ctp, line 260 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 XmlView::render() - CORE/Cake/View/XmlView.php, line 105 Controller::render() - CORE/Cake/Controller/Controller.php, line 968 AefisController::download() - APP/Controller/AefisController.php, line 1383 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 118</pre></div></pre></drugstructuredosageunit> <drugseparatedosagenumb/> <drugintervaldosageunitnumb/> <drugintervaldosagedefinition/> <drugcumulativedosagenumb/> <drugcumulativedosageunit/> <drugdosagetext>1</drugdosagetext> <drugdosageform/> <drugadministrationroute/> <drugparadministration/> <reactiongestationperiod/> <reactiongestationperiodunit/> <drugindicationmeddraversion/> <drugindication/> <drugstartdateformat>102</drugstartdateformat> <drugstartdate>20240524</drugstartdate> <drugstartperiod/> <drugstartperiodunit/> <druglastperiod/> <druglastperiodunit/> <drugenddateformat/> <drugenddate/> <drugtreatmentduration/> <drugtreatmentdurationunit/> <actiondrug/> <drugrecurreadministration/> <drugadditional>N/A</drugadditional> <activesubstance> <activesubstancename></activesubstancename> </activesubstance> <drugreactionrelatedness> <drugreactionassesmeddraversion>23.0</drugreactionassesmeddraversion> <drugreactionasses>Swelling</drugreactionasses> <drugassessmentsource/> <drugassessmentmethod/> <drugresult/> </drugreactionrelatedness> </drug> <summary> <narrativeincludeclinical>Swelling of feet.</narrativeincludeclinical> <reportercomment/> <senderdiagnosismeddraversion>23.0</senderdiagnosismeddraversion> <senderdiagnosis></senderdiagnosis> <sendercomment/> </summary> </patient> </safetyreport> </ichicsr>
 e2b_file(null)
 file/var/www/ctr/app/webroot/media/transfer/gen/aefi_r2_1663_2.xml
 dirnamegen
 basenameaefi_r2_1663_2.xml
 checksum679f13cf2382fa26784dc1f5e377d34c
 alternative(null)
 group(null)
 descriptionsasa
 created2024-05-28 11:57:03
 modified2024-05-28 11:57:03
 deleted(null)
 1(array)
 id7
 application_id2
 reference_no(null)
 user_id48
 reporter_emailj.k.i.p.r.o.tich@intellisoftkenya.com
 e2b_content<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE ichicsr SYSTEM "http://eudravigilance.ema.europa.eu/dtd/icsr21xml.dtd"> <ichicsr lang="en"> <ichicsrmessageheader lang="en"> <messagetype>ichicsr</messagetype> <messageformatversion>2.1</messageformatversion> <messageformatrelease>2.0</messageformatrelease> <messagenumb>KE-PPB-2024-1663</messagenumb> <messagesenderidentifier>PPB</messagesenderidentifier> <messagereceiveridentifier>KE</messagereceiveridentifier> <messagedateformat>204</messagedateformat> <messagedate>20240527125941</messagedate> </ichicsrmessageheader> <safetyreport lang="en"> <safetyreportversion>1</safetyreportversion> <safetyreportid>KE-PPB-AEFI/2024/22</safetyreportid> <primarysourcecountry>KE</primarysourcecountry> <occurcountry>KE</occurcountry> <transmissiondateformat/> <transmissiondate/> <reporttype>1</reporttype> <serious>2</serious> <seriousnessdeath>2</seriousnessdeath> <seriousnesslifethreatening>2</seriousnesslifethreatening> <seriousnesshospitalization>2</seriousnesshospitalization> <seriousnessdisabling>2</seriousnessdisabling> <seriousnesscongenitalanomali>2</seriousnesscongenitalanomali> <seriousnessother>2</seriousnessother> <receivedateformat>102</receivedateformat> <receivedate>20240527</receivedate> <receiptdateformat>102</receiptdateformat> <receiptdate>20240527</receiptdate> <additionaldocument>2</additionaldocument> <documentlist></documentlist> <fulfillexpeditecriteria>2</fulfillexpeditecriteria> <authoritynumb>KE-PPB-AEFI/2024/22</authoritynumb> <companynumb/> <duplicate/> <casenullification/> <nullificationreason/> <medicallyconfirm>1</medicallyconfirm> <primarysource> <reportergivename>Christine</reportergivename> <reporterfamilyname> </reporterfamilyname> <reporterorganization>Kasarani A 2</reporterorganization> <reporterdepartment/> <reporterstreet/> <reportercity/> <reporterstate/> <reporterpostcode/> <reportercountry>KE</reportercountry> <qualification>1</qualification> <literaturereference/> <studyname/> <sponsorstudynumb/> <observestudytype/> </primarysource> <sender> <sendertype>3</sendertype> <senderorganization>Pharmacy and Poisons Board</senderorganization> <senderdepartment>Department of Pharmacovigilance</senderdepartment> <sendertitle>Dr.</sendertitle> <sendergivename>Christabel</sendergivename> <sendermiddlename>N.</sendermiddlename> <senderfamilyname>Khaemba</senderfamilyname> <senderstreetaddress>P.O. Box:27663-00506</senderstreetaddress> <sendercity>Nairobi</sendercity> <senderstate/> <senderpostcode>00506</senderpostcode> <sendercountrycode>KE</sendercountrycode> <sendertel>720608811</sendertel> <sendertelextension/> <sendertelcountrycode>254</sendertelcountrycode> <senderfax>2713409</senderfax> <senderfaxextension>20</senderfaxextension> <senderfaxcountrycode>254</senderfaxcountrycode> <senderemailaddress>pv@pharmacyboardkenya.org</senderemailaddress> </sender> <receiver> <receivertype/> <receiverorganization/> <receiverdepartment/> <receivertitle/> <receivergivename/> <receivermiddlename/> <receiverfamilyname/> <receiverstreetaddress/> <receivercity/> <receiverstate/> <receiverpostcode/> <receivercountrycode/> <receivertel/> <receivertelextension/> <receivertelcountrycode/> <receiverfax/> <receiverfaxextension/> <receiverfaxcountrycode/> <receiveremailaddress/> </receiver> <patient> <patientinitial>L.M</patientinitial> <patientgpmedicalrecordnumb>22222</patientgpmedicalrecordnumb> <patientspecialistrecordnumb>22222</patientspecialistrecordnumb> <patienthospitalrecordnumb>22222</patienthospitalrecordnumb> <patientinvestigationnumb/> <patientbirthdateformat>102</patientbirthdateformat> <patientbirthdate>20060118</patientbirthdate> <patientonsetage/><patientonsetageunit/> <gestationperiod/> <gestationperiodunit/> <patientagegroup/> <patientweight/> <patientheight/> <patientsex>1</patientsex> <lastmenstrualdateformat/> <patientlastmenstrualdate/> <patientmedicalhistorytext></patientmedicalhistorytext> <resultstestsprocedures/> <patientdeath> <patientdeathdateformat/> <patientdeathdate/> <patientautopsyyesno/> </patientdeath> <reaction> <primarysourcereaction> Severe, </primarysourcereaction> <reactionmeddraversionllt>23.0</reactionmeddraversionllt> <reactionmeddrallt>Swelling</reactionmeddrallt> <reactionmeddraversionpt/> <reactionmeddrapt/> <termhighlighted/> <reactionstartdateformat>102</reactionstartdateformat><reactionstartdate>20240524</reactionstartdate> <reactionenddateformat/> <reactionenddate/> <reactionduration/> <reactiondurationunit/> <reactionfirsttime/> <reactionfirsttimeunit/> <reactionlasttime/> <reactionlasttimeunit/> <reactionoutcome>1</reactionoutcome> </reaction> <drug> <drugcharacterization>1</drugcharacterization> <medicinalproduct>Bivalent oral Polio vaccine</medicinalproduct> <obtaindrugcountry/> <drugbatchnumb>4444444</drugbatchnumb> <drugauthorizationnumb/> <drugauthorizationcountry/> <drugauthorizationholder/> <drugstructuredosagenumb>1</drugstructuredosagenumb> <drugstructuredosageunit><pre class="cake-error"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-trace').style.display = (document.getElementById('cakeErr6654598d02eb4-trace').style.display == 'none' ? '' : 'none');">Notice (8)</a>: Undefined variable: sadrListOfDrug [APP/View/Aefis/xml/download_r2.ctp, line 260]<div id="cakeErr6654598d02eb4-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-code').style.display = (document.getElementById('cakeErr6654598d02eb4-code').style.display == 'none' ? '' : 'none')">Code</a> <a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-context').style.display = (document.getElementById('cakeErr6654598d02eb4-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr6654598d02eb4-code" class="cake-code-dump" style="display: none;"><code> <drugstructuredosagenumb><?php echo $listOfVaccine['dosage']; ?></drugstructuredosagenumb></code> <code> <drugstructuredosageunit><?php</code> <code> echo $sadrListOfDrug['Dose']['icsr_code'];</code></pre><pre id="cakeErr6654598d02eb4-context" class="cake-context" style="display: none;">$viewFile = '/var/www/pvers/app/View/Aefis/xml/download_r2.ctp' $dataForView = array( 'debugToolbarPanels' => array( 'history' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'history_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'session' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'session_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'request' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'request_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'sql_log' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'sql_log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'timer' => array( 'content' => null, 'elementName' => 'timer_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'log' => array( 'content' => object(DebugKitLog) {}, 'elementName' => 'log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'variables' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'variables_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'environment' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'environment_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'include' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'include_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ) ), 'debugToolbarJavascript' => array( 'libs' => 'DebugKit./js/js_debug_toolbar' ), 'debugToolbarCss' => array( (int) 0 => 'DebugKit./css/debug_toolbar.css' ), 'aefi' => array( 'Aefi' => array( 'id' => '1663', 'user_id' => '9282', 'pqmp_id' => null, 'reference_no' => 'AEFI/2024/22', 'aefi_id' => null, 'county_id' => '42', 'sub_county_id' => '237', 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => '6', 'report_type' => 'Initial', 'name_of_institution' => 'Kasarani A 2', 'institution_code' => '', 'patient_name' => 'L.M', 'guardian_name' => '', 'patient_address' => '', 'patient_phone' => '', 'patient_village' => '', 'ip_no' => '22222', 'date_of_birth' => array( [maximum depth reached] ), 'age_months' => null, 'age_group' => null, 'patient_ward' => '', 'patient_county' => '', 'patient_sub_county' => '', 'vaccination_center' => '', 'vaccination_county' => '', 'vaccination_type' => 'static', 'gender' => 'Male', 'bcg' => false, 'convulsion' => false, 'urticaria' => false, 'high_fever' => false, 'abscess' => false, 'local_reaction' => '1', 'anaphylaxis' => false, 'meningitis' => false, 'paralysis' => false, 'toxic_shock' => false, 'complaint_other' => false, 'complaint_other_specify' => null, 'description_of_reaction' => 'Swelling of feet.', 'date_aefi_started' => '24-05-2024', 'time_aefi_started' => array( [maximum depth reached] ), 'aefi_symptoms' => 'Swelling', 'serious' => 'No', 'serious_yes' => null, 'serious_other' => '', 'medical_history' => '', 'treatment_given' => '', 'specimen_collected' => '', 'outcome' => 'Recovered/Resolved', 'reporter_name' => 'Christine ', 'reporter_email' => 'Cgichuki@intellisoftkenya.com', 'reporter_phone' => '0700212343', 'reporter_date' => '27-05-2024', 'submitted' => '2', 'submitted_date' => '2024-05-27 11:59:49', 'active' => '1', 'device' => '0', 'copied' => '0', 'archived' => '0', 'archived_date' => null, 'deleted' => false, 'deleted_date' => null, 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49', 'person_submitting' => '', 'reporter_name_diff' => '', 'reporter_designation_diff' => null, 'reporter_email_diff' => '', 'reporter_phone_diff' => '', 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'reactions' => array( [maximum depth reached] ) ), 'County' => array( 'id' => '42', 'county_name' => 'Kisumu', 'org_unit' => 'tAbBVBbueqD', 'created' => '2012-06-15 10:27:02', 'modified' => '2012-06-15 10:27:02' ), 'SubCounty' => array( 'id' => '237', 'county_id' => '42', 'sub_county_name' => 'KISUMU EAST', 'county_name' => 'Kisumu', 'Province' => 'NYANZA', 'Pop_2009' => '150124', 'RegVoters' => '55267', 'AreaSqKms' => '136', 'CAWards' => '5', 'MainEthnicGroup' => 'LUO', 'created' => null, 'modified' => null ), 'Designation' => array( 'id' => '6', 'name' => 'Physician', 'category' => '1', 'created' => null, 'modified' => '2021-02-27 17:50:26' ), 'AefiOriginal' => array( 'id' => null, 'user_id' => null, 'pqmp_id' => null, 'reference_no' => null, 'aefi_id' => null, 'county_id' => null, 'sub_county_id' => null, 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => null, 'report_type' => null, 'name_of_institution' => null, 'institution_code' => null, 'patient_name' => null, 'guardian_name' => null, 'patient_address' => null, 'patient_phone' => null, 'patient_village' => null, 'ip_no' => null, 'date_of_birth' => null, 'age_months' => null, 'age_group' => null, 'patient_ward' => null, 'patient_county' => null, 'patient_sub_county' => null, 'vaccination_center' => null, 'vaccination_county' => null, 'vaccination_type' => null, 'gender' => null, 'bcg' => null, 'convulsion' => null, 'urticaria' => null, 'high_fever' => null, 'abscess' => null, 'local_reaction' => null, 'anaphylaxis' => null, 'meningitis' => null, 'paralysis' => null, 'toxic_shock' => null, 'complaint_other' => null, 'complaint_other_specify' => null, 'description_of_reaction' => null, 'date_aefi_started' => null, 'time_aefi_started' => null, 'aefi_symptoms' => null, 'serious' => null, 'serious_yes' => null, 'serious_other' => null, 'medical_history' => null, 'treatment_given' => null, 'specimen_collected' => null, 'outcome' => null, 'reporter_name' => null, 'reporter_email' => null, 'reporter_phone' => null, 'reporter_date' => null, 'submitted' => null, 'submitted_date' => null, 'active' => null, 'device' => null, 'copied' => null, 'archived' => null, 'archived_date' => null, 'deleted' => null, 'deleted_date' => null, 'created' => null, 'modified' => null, 'person_submitting' => null, 'reporter_name_diff' => null, 'reporter_designation_diff' => null, 'reporter_email_diff' => null, 'reporter_phone_diff' => null, 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'AefiOriginal' => array([maximum depth reached]) ), 'AefiDescription' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ), 'Attachment' => array(), 'AefiListOfVaccine' => array( (int) 0 => array( [maximum depth reached] ) ), 'ExternalComment' => array() ), 'root' => '/', 'redir' => 'manager' ) $debugToolbarPanels = array( 'history' => array( 'content' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ) ), 'elementName' => 'history_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'session' => array( 'content' => array( 'Config' => array( [maximum depth reached] ), 'Auth' => array( [maximum depth reached] ) ), 'elementName' => 'session_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'request' => array( 'content' => array( 'params' => array( [maximum depth reached] ), 'url' => 'aefis/download/1663/2.xml', 'query' => array([maximum depth reached]), 'data' => array([maximum depth reached]), 'get' => array([maximum depth reached]), 'currentRoute' => object(CakeRoute) {} ), 'elementName' => 'request_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'sql_log' => array( 'content' => array( 'connections' => array( [maximum depth reached] ), 'threshold' => (int) 20 ), 'elementName' => 'sql_log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'timer' => array( 'content' => null, 'elementName' => 'timer_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'log' => array( 'content' => object(DebugKitLog) {}, 'elementName' => 'log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'variables' => array( 'content' => array( 'aefi' => array( [maximum depth reached] ), 'root' => '/', 'redir' => 'manager', '$request->data' => array([maximum depth reached]) ), 'elementName' => 'variables_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'environment' => array( 'content' => array( 'php' => array( [maximum depth reached] ), 'cake' => array( [maximum depth reached] ), 'app' => array( [maximum depth reached] ) ), 'elementName' => 'environment_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'include' => array( 'content' => array( 'core' => array( [maximum depth reached] ), 'app' => array( [maximum depth reached] ), 'plugins' => array( [maximum depth reached] ), 'paths' => array( [maximum depth reached] ) ), 'elementName' => 'include_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ) ) $debugToolbarJavascript = array( 'libs' => 'DebugKit./js/js_debug_toolbar' ) $debugToolbarCss = array( (int) 0 => 'DebugKit./css/debug_toolbar.css' ) $aefi = array( 'Aefi' => array( 'id' => '1663', 'user_id' => '9282', 'pqmp_id' => null, 'reference_no' => 'AEFI/2024/22', 'aefi_id' => null, 'county_id' => '42', 'sub_county_id' => '237', 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => '6', 'report_type' => 'Initial', 'name_of_institution' => 'Kasarani A 2', 'institution_code' => '', 'patient_name' => 'L.M', 'guardian_name' => '', 'patient_address' => '', 'patient_phone' => '', 'patient_village' => '', 'ip_no' => '22222', 'date_of_birth' => array( 'day' => '18', 'month' => '01', 'year' => '2006' ), 'age_months' => null, 'age_group' => null, 'patient_ward' => '', 'patient_county' => '', 'patient_sub_county' => '', 'vaccination_center' => '', 'vaccination_county' => '', 'vaccination_type' => 'static', 'gender' => 'Male', 'bcg' => false, 'convulsion' => false, 'urticaria' => false, 'high_fever' => false, 'abscess' => false, 'local_reaction' => '1', 'anaphylaxis' => false, 'meningitis' => false, 'paralysis' => false, 'toxic_shock' => false, 'complaint_other' => false, 'complaint_other_specify' => null, 'description_of_reaction' => 'Swelling of feet.', 'date_aefi_started' => '24-05-2024', 'time_aefi_started' => array( 'hour' => '00', 'min' => '00' ), 'aefi_symptoms' => 'Swelling', 'serious' => 'No', 'serious_yes' => null, 'serious_other' => '', 'medical_history' => '', 'treatment_given' => '', 'specimen_collected' => '', 'outcome' => 'Recovered/Resolved', 'reporter_name' => 'Christine ', 'reporter_email' => 'Cgichuki@intellisoftkenya.com', 'reporter_phone' => '0700212343', 'reporter_date' => '27-05-2024', 'submitted' => '2', 'submitted_date' => '2024-05-27 11:59:49', 'active' => '1', 'device' => '0', 'copied' => '0', 'archived' => '0', 'archived_date' => null, 'deleted' => false, 'deleted_date' => null, 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49', 'person_submitting' => '', 'reporter_name_diff' => '', 'reporter_designation_diff' => null, 'reporter_email_diff' => '', 'reporter_phone_diff' => '', 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'reactions' => array( (int) 0 => array( [maximum depth reached] ) ) ), 'County' => array( 'id' => '42', 'county_name' => 'Kisumu', 'org_unit' => 'tAbBVBbueqD', 'created' => '2012-06-15 10:27:02', 'modified' => '2012-06-15 10:27:02' ), 'SubCounty' => array( 'id' => '237', 'county_id' => '42', 'sub_county_name' => 'KISUMU EAST', 'county_name' => 'Kisumu', 'Province' => 'NYANZA', 'Pop_2009' => '150124', 'RegVoters' => '55267', 'AreaSqKms' => '136', 'CAWards' => '5', 'MainEthnicGroup' => 'LUO', 'created' => null, 'modified' => null ), 'Designation' => array( 'id' => '6', 'name' => 'Physician', 'category' => '1', 'created' => null, 'modified' => '2021-02-27 17:50:26' ), 'AefiOriginal' => array( 'id' => null, 'user_id' => null, 'pqmp_id' => null, 'reference_no' => null, 'aefi_id' => null, 'county_id' => null, 'sub_county_id' => null, 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => null, 'report_type' => null, 'name_of_institution' => null, 'institution_code' => null, 'patient_name' => null, 'guardian_name' => null, 'patient_address' => null, 'patient_phone' => null, 'patient_village' => null, 'ip_no' => null, 'date_of_birth' => null, 'age_months' => null, 'age_group' => null, 'patient_ward' => null, 'patient_county' => null, 'patient_sub_county' => null, 'vaccination_center' => null, 'vaccination_county' => null, 'vaccination_type' => null, 'gender' => null, 'bcg' => null, 'convulsion' => null, 'urticaria' => null, 'high_fever' => null, 'abscess' => null, 'local_reaction' => null, 'anaphylaxis' => null, 'meningitis' => null, 'paralysis' => null, 'toxic_shock' => null, 'complaint_other' => null, 'complaint_other_specify' => null, 'description_of_reaction' => null, 'date_aefi_started' => null, 'time_aefi_started' => null, 'aefi_symptoms' => null, 'serious' => null, 'serious_yes' => null, 'serious_other' => null, 'medical_history' => null, 'treatment_given' => null, 'specimen_collected' => null, 'outcome' => null, 'reporter_name' => null, 'reporter_email' => null, 'reporter_phone' => null, 'reporter_date' => null, 'submitted' => null, 'submitted_date' => null, 'active' => null, 'device' => null, 'copied' => null, 'archived' => null, 'archived_date' => null, 'deleted' => null, 'deleted_date' => null, 'created' => null, 'modified' => null, 'person_submitting' => null, 'reporter_name_diff' => null, 'reporter_designation_diff' => null, 'reporter_email_diff' => null, 'reporter_phone_diff' => null, 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'AefiOriginal' => array() ), 'AefiDescription' => array( (int) 0 => array( 'id' => '1663', 'aefi_id' => '1663', 'description' => 'Swelling', 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49' ), (int) 1 => array( 'id' => '1663', 'aefi_id' => '1663', 'description' => 'Severe', 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49' ) ), 'Attachment' => array(), 'AefiListOfVaccine' => array( (int) 0 => array( 'id' => '922', 'aefi_id' => '1663', 'saefi_id' => null, 'vaccine_id' => '14', 'vaccine_name' => '', 'vaccination_date' => '24-05-2024', 'vaccination_time' => array( [maximum depth reached] ), 'vaccine_manufacturer' => 'KKKTTTR', 'vaccination_route' => 'Intramuscular', 'vaccination_site' => 'left arm', 'dosage' => '1', 'icsr_code' => null, 'batch_number' => '4444444', 'expiry_date' => '27-05-2025', 'diluent_batch_number' => 'N/A', 'diluent_manufacturer' => 'YYYYY', 'diluent_expiry_date' => '19-05-2025', 'suspected_drug' => null, 'created' => '2024-05-27 11:56:22', 'modified' => '2024-05-27 11:59:49', 'Vaccine' => array( [maximum depth reached] ) ) ), 'ExternalComment' => array() ) $root = '/' $redir = 'manager' $arr = array( (int) 0 => 'Christine', (int) 1 => '' ) $birthdatef = (int) 102 $outcomes = array( 'Recovered/Resolved' => (int) 1, 'Recovering/Resolving' => (int) 2, 'Recovered/Resolved with sequelae' => (int) 3, 'Not recovered/Not resolved/Ongoing' => (int) 4, 'Fatal' => (int) 5, 'Unknown' => (int) 6 ) $listOfVaccine = array( 'id' => '922', 'aefi_id' => '1663', 'saefi_id' => null, 'vaccine_id' => '14', 'vaccine_name' => '', 'vaccination_date' => '24-05-2024', 'vaccination_time' => array( 'hour' => '12', 'min' => '20' ), 'vaccine_manufacturer' => 'KKKTTTR', 'vaccination_route' => 'Intramuscular', 'vaccination_site' => 'left arm', 'dosage' => '1', 'icsr_code' => null, 'batch_number' => '4444444', 'expiry_date' => '27-05-2025', 'diluent_batch_number' => 'N/A', 'diluent_manufacturer' => 'YYYYY', 'diluent_expiry_date' => '19-05-2025', 'suspected_drug' => null, 'created' => '2024-05-27 11:56:22', 'modified' => '2024-05-27 11:59:49', 'Vaccine' => array( 'id' => '14', 'vaccine_name' => 'Bivalent oral Polio vaccine', 'description' => 'Liquid Suspension - 20 doses per vial', 'health_program' => 'National Vaccines and immunisation program', 'created' => '2021-02-01 11:44:27', 'modified' => '2021-02-01 11:44:27', 'deleted' => false, 'deleted_date' => null ) ) $num = (int) 0</pre><pre class="stack-trace">include - APP/View/Aefis/xml/download_r2.ctp, line 260 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 XmlView::render() - CORE/Cake/View/XmlView.php, line 105 Controller::render() - CORE/Cake/Controller/Controller.php, line 968 AefisController::download() - APP/Controller/AefisController.php, line 1383 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 118</pre></div></pre></drugstructuredosageunit> <drugseparatedosagenumb/> <drugintervaldosageunitnumb/> <drugintervaldosagedefinition/> <drugcumulativedosagenumb/> <drugcumulativedosageunit/> <drugdosagetext>1</drugdosagetext> <drugdosageform/> <drugadministrationroute/> <drugparadministration/> <reactiongestationperiod/> <reactiongestationperiodunit/> <drugindicationmeddraversion/> <drugindication/> <drugstartdateformat>102</drugstartdateformat> <drugstartdate>20240524</drugstartdate> <drugstartperiod/> <drugstartperiodunit/> <druglastperiod/> <druglastperiodunit/> <drugenddateformat/> <drugenddate/> <drugtreatmentduration/> <drugtreatmentdurationunit/> <actiondrug/> <drugrecurreadministration/> <drugadditional>N/A</drugadditional> <activesubstance> <activesubstancename></activesubstancename> </activesubstance> <drugreactionrelatedness> <drugreactionassesmeddraversion>23.0</drugreactionassesmeddraversion> <drugreactionasses>Swelling</drugreactionasses> <drugassessmentsource/> <drugassessmentmethod/> <drugresult/> </drugreactionrelatedness> </drug> <summary> <narrativeincludeclinical>Swelling of feet.</narrativeincludeclinical> <reportercomment/> <senderdiagnosismeddraversion>23.0</senderdiagnosismeddraversion> <senderdiagnosis></senderdiagnosis> <sendercomment/> </summary> </patient> </safetyreport> </ichicsr>
 e2b_file(null)
 file/var/www/ctr/app/webroot/media/transfer/gen/aefi_r2_1663_3.xml
 dirnamegen
 basenameaefi_r2_1663_3.xml
 checksum679f13cf2382fa26784dc1f5e377d34c
 alternative(null)
 group(null)
 descriptionsasa
 created2024-05-28 11:59:44
 modified2024-05-28 11:59:44
 deleted(null)
 2(array)
 id8
 application_id2
 reference_no(null)
 user_id48
 reporter_emailj.k.i.p.r.o.tich@intellisoftkenya.com
 e2b_content<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE ichicsr SYSTEM "http://eudravigilance.ema.europa.eu/dtd/icsr21xml.dtd"> <ichicsr lang="en"> <ichicsrmessageheader lang="en"> <messagetype>ichicsr</messagetype> <messageformatversion>2.1</messageformatversion> <messageformatrelease>2.0</messageformatrelease> <messagenumb>KE-PPB-2024-1663</messagenumb> <messagesenderidentifier>PPB</messagesenderidentifier> <messagereceiveridentifier>KE</messagereceiveridentifier> <messagedateformat>204</messagedateformat> <messagedate>20240527125941</messagedate> </ichicsrmessageheader> <safetyreport lang="en"> <safetyreportversion>1</safetyreportversion> <safetyreportid>KE-PPB-AEFI/2024/22</safetyreportid> <primarysourcecountry>KE</primarysourcecountry> <occurcountry>KE</occurcountry> <transmissiondateformat/> <transmissiondate/> <reporttype>1</reporttype> <serious>2</serious> <seriousnessdeath>2</seriousnessdeath> <seriousnesslifethreatening>2</seriousnesslifethreatening> <seriousnesshospitalization>2</seriousnesshospitalization> <seriousnessdisabling>2</seriousnessdisabling> <seriousnesscongenitalanomali>2</seriousnesscongenitalanomali> <seriousnessother>2</seriousnessother> <receivedateformat>102</receivedateformat> <receivedate>20240527</receivedate> <receiptdateformat>102</receiptdateformat> <receiptdate>20240527</receiptdate> <additionaldocument>2</additionaldocument> <documentlist></documentlist> <fulfillexpeditecriteria>2</fulfillexpeditecriteria> <authoritynumb>KE-PPB-AEFI/2024/22</authoritynumb> <companynumb/> <duplicate/> <casenullification/> <nullificationreason/> <medicallyconfirm>1</medicallyconfirm> <primarysource> <reportergivename>Christine</reportergivename> <reporterfamilyname> </reporterfamilyname> <reporterorganization>Kasarani A 2</reporterorganization> <reporterdepartment/> <reporterstreet/> <reportercity/> <reporterstate/> <reporterpostcode/> <reportercountry>KE</reportercountry> <qualification>1</qualification> <literaturereference/> <studyname/> <sponsorstudynumb/> <observestudytype/> </primarysource> <sender> <sendertype>3</sendertype> <senderorganization>Pharmacy and Poisons Board</senderorganization> <senderdepartment>Department of Pharmacovigilance</senderdepartment> <sendertitle>Dr.</sendertitle> <sendergivename>Christabel</sendergivename> <sendermiddlename>N.</sendermiddlename> <senderfamilyname>Khaemba</senderfamilyname> <senderstreetaddress>P.O. Box:27663-00506</senderstreetaddress> <sendercity>Nairobi</sendercity> <senderstate/> <senderpostcode>00506</senderpostcode> <sendercountrycode>KE</sendercountrycode> <sendertel>720608811</sendertel> <sendertelextension/> <sendertelcountrycode>254</sendertelcountrycode> <senderfax>2713409</senderfax> <senderfaxextension>20</senderfaxextension> <senderfaxcountrycode>254</senderfaxcountrycode> <senderemailaddress>pv@pharmacyboardkenya.org</senderemailaddress> </sender> <receiver> <receivertype/> <receiverorganization/> <receiverdepartment/> <receivertitle/> <receivergivename/> <receivermiddlename/> <receiverfamilyname/> <receiverstreetaddress/> <receivercity/> <receiverstate/> <receiverpostcode/> <receivercountrycode/> <receivertel/> <receivertelextension/> <receivertelcountrycode/> <receiverfax/> <receiverfaxextension/> <receiverfaxcountrycode/> <receiveremailaddress/> </receiver> <patient> <patientinitial>L.M</patientinitial> <patientgpmedicalrecordnumb>22222</patientgpmedicalrecordnumb> <patientspecialistrecordnumb>22222</patientspecialistrecordnumb> <patienthospitalrecordnumb>22222</patienthospitalrecordnumb> <patientinvestigationnumb/> <patientbirthdateformat>102</patientbirthdateformat> <patientbirthdate>20060118</patientbirthdate> <patientonsetage/><patientonsetageunit/> <gestationperiod/> <gestationperiodunit/> <patientagegroup/> <patientweight/> <patientheight/> <patientsex>1</patientsex> <lastmenstrualdateformat/> <patientlastmenstrualdate/> <patientmedicalhistorytext></patientmedicalhistorytext> <resultstestsprocedures/> <patientdeath> <patientdeathdateformat/> <patientdeathdate/> <patientautopsyyesno/> </patientdeath> <reaction> <primarysourcereaction> Severe, </primarysourcereaction> <reactionmeddraversionllt>23.0</reactionmeddraversionllt> <reactionmeddrallt>Swelling</reactionmeddrallt> <reactionmeddraversionpt/> <reactionmeddrapt/> <termhighlighted/> <reactionstartdateformat>102</reactionstartdateformat><reactionstartdate>20240524</reactionstartdate> <reactionenddateformat/> <reactionenddate/> <reactionduration/> <reactiondurationunit/> <reactionfirsttime/> <reactionfirsttimeunit/> <reactionlasttime/> <reactionlasttimeunit/> <reactionoutcome>1</reactionoutcome> </reaction> <drug> <drugcharacterization>1</drugcharacterization> <medicinalproduct>Bivalent oral Polio vaccine</medicinalproduct> <obtaindrugcountry/> <drugbatchnumb>4444444</drugbatchnumb> <drugauthorizationnumb/> <drugauthorizationcountry/> <drugauthorizationholder/> <drugstructuredosagenumb>1</drugstructuredosagenumb> <drugstructuredosageunit><pre class="cake-error"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-trace').style.display = (document.getElementById('cakeErr6654598d02eb4-trace').style.display == 'none' ? '' : 'none');">Notice (8)</a>: Undefined variable: sadrListOfDrug [APP/View/Aefis/xml/download_r2.ctp, line 260]<div id="cakeErr6654598d02eb4-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-code').style.display = (document.getElementById('cakeErr6654598d02eb4-code').style.display == 'none' ? '' : 'none')">Code</a> <a href="javascript:void(0);" onclick="document.getElementById('cakeErr6654598d02eb4-context').style.display = (document.getElementById('cakeErr6654598d02eb4-context').style.display == 'none' ? '' : 'none')">Context</a><pre id="cakeErr6654598d02eb4-code" class="cake-code-dump" style="display: none;"><code> <drugstructuredosagenumb><?php echo $listOfVaccine['dosage']; ?></drugstructuredosagenumb></code> <code> <drugstructuredosageunit><?php</code> <code> echo $sadrListOfDrug['Dose']['icsr_code'];</code></pre><pre id="cakeErr6654598d02eb4-context" class="cake-context" style="display: none;">$viewFile = '/var/www/pvers/app/View/Aefis/xml/download_r2.ctp' $dataForView = array( 'debugToolbarPanels' => array( 'history' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'history_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'session' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'session_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'request' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'request_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'sql_log' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'sql_log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'timer' => array( 'content' => null, 'elementName' => 'timer_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'log' => array( 'content' => object(DebugKitLog) {}, 'elementName' => 'log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'variables' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'variables_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'environment' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'environment_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'include' => array( 'content' => array( [maximum depth reached] ), 'elementName' => 'include_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ) ), 'debugToolbarJavascript' => array( 'libs' => 'DebugKit./js/js_debug_toolbar' ), 'debugToolbarCss' => array( (int) 0 => 'DebugKit./css/debug_toolbar.css' ), 'aefi' => array( 'Aefi' => array( 'id' => '1663', 'user_id' => '9282', 'pqmp_id' => null, 'reference_no' => 'AEFI/2024/22', 'aefi_id' => null, 'county_id' => '42', 'sub_county_id' => '237', 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => '6', 'report_type' => 'Initial', 'name_of_institution' => 'Kasarani A 2', 'institution_code' => '', 'patient_name' => 'L.M', 'guardian_name' => '', 'patient_address' => '', 'patient_phone' => '', 'patient_village' => '', 'ip_no' => '22222', 'date_of_birth' => array( [maximum depth reached] ), 'age_months' => null, 'age_group' => null, 'patient_ward' => '', 'patient_county' => '', 'patient_sub_county' => '', 'vaccination_center' => '', 'vaccination_county' => '', 'vaccination_type' => 'static', 'gender' => 'Male', 'bcg' => false, 'convulsion' => false, 'urticaria' => false, 'high_fever' => false, 'abscess' => false, 'local_reaction' => '1', 'anaphylaxis' => false, 'meningitis' => false, 'paralysis' => false, 'toxic_shock' => false, 'complaint_other' => false, 'complaint_other_specify' => null, 'description_of_reaction' => 'Swelling of feet.', 'date_aefi_started' => '24-05-2024', 'time_aefi_started' => array( [maximum depth reached] ), 'aefi_symptoms' => 'Swelling', 'serious' => 'No', 'serious_yes' => null, 'serious_other' => '', 'medical_history' => '', 'treatment_given' => '', 'specimen_collected' => '', 'outcome' => 'Recovered/Resolved', 'reporter_name' => 'Christine ', 'reporter_email' => 'Cgichuki@intellisoftkenya.com', 'reporter_phone' => '0700212343', 'reporter_date' => '27-05-2024', 'submitted' => '2', 'submitted_date' => '2024-05-27 11:59:49', 'active' => '1', 'device' => '0', 'copied' => '0', 'archived' => '0', 'archived_date' => null, 'deleted' => false, 'deleted_date' => null, 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49', 'person_submitting' => '', 'reporter_name_diff' => '', 'reporter_designation_diff' => null, 'reporter_email_diff' => '', 'reporter_phone_diff' => '', 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'reactions' => array( [maximum depth reached] ) ), 'County' => array( 'id' => '42', 'county_name' => 'Kisumu', 'org_unit' => 'tAbBVBbueqD', 'created' => '2012-06-15 10:27:02', 'modified' => '2012-06-15 10:27:02' ), 'SubCounty' => array( 'id' => '237', 'county_id' => '42', 'sub_county_name' => 'KISUMU EAST', 'county_name' => 'Kisumu', 'Province' => 'NYANZA', 'Pop_2009' => '150124', 'RegVoters' => '55267', 'AreaSqKms' => '136', 'CAWards' => '5', 'MainEthnicGroup' => 'LUO', 'created' => null, 'modified' => null ), 'Designation' => array( 'id' => '6', 'name' => 'Physician', 'category' => '1', 'created' => null, 'modified' => '2021-02-27 17:50:26' ), 'AefiOriginal' => array( 'id' => null, 'user_id' => null, 'pqmp_id' => null, 'reference_no' => null, 'aefi_id' => null, 'county_id' => null, 'sub_county_id' => null, 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => null, 'report_type' => null, 'name_of_institution' => null, 'institution_code' => null, 'patient_name' => null, 'guardian_name' => null, 'patient_address' => null, 'patient_phone' => null, 'patient_village' => null, 'ip_no' => null, 'date_of_birth' => null, 'age_months' => null, 'age_group' => null, 'patient_ward' => null, 'patient_county' => null, 'patient_sub_county' => null, 'vaccination_center' => null, 'vaccination_county' => null, 'vaccination_type' => null, 'gender' => null, 'bcg' => null, 'convulsion' => null, 'urticaria' => null, 'high_fever' => null, 'abscess' => null, 'local_reaction' => null, 'anaphylaxis' => null, 'meningitis' => null, 'paralysis' => null, 'toxic_shock' => null, 'complaint_other' => null, 'complaint_other_specify' => null, 'description_of_reaction' => null, 'date_aefi_started' => null, 'time_aefi_started' => null, 'aefi_symptoms' => null, 'serious' => null, 'serious_yes' => null, 'serious_other' => null, 'medical_history' => null, 'treatment_given' => null, 'specimen_collected' => null, 'outcome' => null, 'reporter_name' => null, 'reporter_email' => null, 'reporter_phone' => null, 'reporter_date' => null, 'submitted' => null, 'submitted_date' => null, 'active' => null, 'device' => null, 'copied' => null, 'archived' => null, 'archived_date' => null, 'deleted' => null, 'deleted_date' => null, 'created' => null, 'modified' => null, 'person_submitting' => null, 'reporter_name_diff' => null, 'reporter_designation_diff' => null, 'reporter_email_diff' => null, 'reporter_phone_diff' => null, 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'AefiOriginal' => array([maximum depth reached]) ), 'AefiDescription' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ), 'Attachment' => array(), 'AefiListOfVaccine' => array( (int) 0 => array( [maximum depth reached] ) ), 'ExternalComment' => array() ), 'root' => '/', 'redir' => 'manager' ) $debugToolbarPanels = array( 'history' => array( 'content' => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ), (int) 2 => array( [maximum depth reached] ), (int) 3 => array( [maximum depth reached] ) ), 'elementName' => 'history_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'session' => array( 'content' => array( 'Config' => array( [maximum depth reached] ), 'Auth' => array( [maximum depth reached] ) ), 'elementName' => 'session_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'request' => array( 'content' => array( 'params' => array( [maximum depth reached] ), 'url' => 'aefis/download/1663/2.xml', 'query' => array([maximum depth reached]), 'data' => array([maximum depth reached]), 'get' => array([maximum depth reached]), 'currentRoute' => object(CakeRoute) {} ), 'elementName' => 'request_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'sql_log' => array( 'content' => array( 'connections' => array( [maximum depth reached] ), 'threshold' => (int) 20 ), 'elementName' => 'sql_log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'timer' => array( 'content' => null, 'elementName' => 'timer_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'log' => array( 'content' => object(DebugKitLog) {}, 'elementName' => 'log_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'variables' => array( 'content' => array( 'aefi' => array( [maximum depth reached] ), 'root' => '/', 'redir' => 'manager', '$request->data' => array([maximum depth reached]) ), 'elementName' => 'variables_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'environment' => array( 'content' => array( 'php' => array( [maximum depth reached] ), 'cake' => array( [maximum depth reached] ), 'app' => array( [maximum depth reached] ) ), 'elementName' => 'environment_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ), 'include' => array( 'content' => array( 'core' => array( [maximum depth reached] ), 'app' => array( [maximum depth reached] ), 'plugins' => array( [maximum depth reached] ), 'paths' => array( [maximum depth reached] ) ), 'elementName' => 'include_panel', 'plugin' => 'DebugKit', 'title' => null, 'disableTimer' => true ) ) $debugToolbarJavascript = array( 'libs' => 'DebugKit./js/js_debug_toolbar' ) $debugToolbarCss = array( (int) 0 => 'DebugKit./css/debug_toolbar.css' ) $aefi = array( 'Aefi' => array( 'id' => '1663', 'user_id' => '9282', 'pqmp_id' => null, 'reference_no' => 'AEFI/2024/22', 'aefi_id' => null, 'county_id' => '42', 'sub_county_id' => '237', 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => '6', 'report_type' => 'Initial', 'name_of_institution' => 'Kasarani A 2', 'institution_code' => '', 'patient_name' => 'L.M', 'guardian_name' => '', 'patient_address' => '', 'patient_phone' => '', 'patient_village' => '', 'ip_no' => '22222', 'date_of_birth' => array( 'day' => '18', 'month' => '01', 'year' => '2006' ), 'age_months' => null, 'age_group' => null, 'patient_ward' => '', 'patient_county' => '', 'patient_sub_county' => '', 'vaccination_center' => '', 'vaccination_county' => '', 'vaccination_type' => 'static', 'gender' => 'Male', 'bcg' => false, 'convulsion' => false, 'urticaria' => false, 'high_fever' => false, 'abscess' => false, 'local_reaction' => '1', 'anaphylaxis' => false, 'meningitis' => false, 'paralysis' => false, 'toxic_shock' => false, 'complaint_other' => false, 'complaint_other_specify' => null, 'description_of_reaction' => 'Swelling of feet.', 'date_aefi_started' => '24-05-2024', 'time_aefi_started' => array( 'hour' => '00', 'min' => '00' ), 'aefi_symptoms' => 'Swelling', 'serious' => 'No', 'serious_yes' => null, 'serious_other' => '', 'medical_history' => '', 'treatment_given' => '', 'specimen_collected' => '', 'outcome' => 'Recovered/Resolved', 'reporter_name' => 'Christine ', 'reporter_email' => 'Cgichuki@intellisoftkenya.com', 'reporter_phone' => '0700212343', 'reporter_date' => '27-05-2024', 'submitted' => '2', 'submitted_date' => '2024-05-27 11:59:49', 'active' => '1', 'device' => '0', 'copied' => '0', 'archived' => '0', 'archived_date' => null, 'deleted' => false, 'deleted_date' => null, 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49', 'person_submitting' => '', 'reporter_name_diff' => '', 'reporter_designation_diff' => null, 'reporter_email_diff' => '', 'reporter_phone_diff' => '', 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'reactions' => array( (int) 0 => array( [maximum depth reached] ) ) ), 'County' => array( 'id' => '42', 'county_name' => 'Kisumu', 'org_unit' => 'tAbBVBbueqD', 'created' => '2012-06-15 10:27:02', 'modified' => '2012-06-15 10:27:02' ), 'SubCounty' => array( 'id' => '237', 'county_id' => '42', 'sub_county_name' => 'KISUMU EAST', 'county_name' => 'Kisumu', 'Province' => 'NYANZA', 'Pop_2009' => '150124', 'RegVoters' => '55267', 'AreaSqKms' => '136', 'CAWards' => '5', 'MainEthnicGroup' => 'LUO', 'created' => null, 'modified' => null ), 'Designation' => array( 'id' => '6', 'name' => 'Physician', 'category' => '1', 'created' => null, 'modified' => '2021-02-27 17:50:26' ), 'AefiOriginal' => array( 'id' => null, 'user_id' => null, 'pqmp_id' => null, 'reference_no' => null, 'aefi_id' => null, 'county_id' => null, 'sub_county_id' => null, 'vigiflow_ref' => null, 'vigiflow_date' => null, 'vigiflow_message' => null, 'webradr_ref' => null, 'webradr_date' => null, 'webradr_message' => null, 'designation_id' => null, 'report_type' => null, 'name_of_institution' => null, 'institution_code' => null, 'patient_name' => null, 'guardian_name' => null, 'patient_address' => null, 'patient_phone' => null, 'patient_village' => null, 'ip_no' => null, 'date_of_birth' => null, 'age_months' => null, 'age_group' => null, 'patient_ward' => null, 'patient_county' => null, 'patient_sub_county' => null, 'vaccination_center' => null, 'vaccination_county' => null, 'vaccination_type' => null, 'gender' => null, 'bcg' => null, 'convulsion' => null, 'urticaria' => null, 'high_fever' => null, 'abscess' => null, 'local_reaction' => null, 'anaphylaxis' => null, 'meningitis' => null, 'paralysis' => null, 'toxic_shock' => null, 'complaint_other' => null, 'complaint_other_specify' => null, 'description_of_reaction' => null, 'date_aefi_started' => null, 'time_aefi_started' => null, 'aefi_symptoms' => null, 'serious' => null, 'serious_yes' => null, 'serious_other' => null, 'medical_history' => null, 'treatment_given' => null, 'specimen_collected' => null, 'outcome' => null, 'reporter_name' => null, 'reporter_email' => null, 'reporter_phone' => null, 'reporter_date' => null, 'submitted' => null, 'submitted_date' => null, 'active' => null, 'device' => null, 'copied' => null, 'archived' => null, 'archived_date' => null, 'deleted' => null, 'deleted_date' => null, 'created' => null, 'modified' => null, 'person_submitting' => null, 'reporter_name_diff' => null, 'reporter_designation_diff' => null, 'reporter_email_diff' => null, 'reporter_phone_diff' => null, 'reporter_date_diff' => null, 'assigned_to' => null, 'assigned_by' => null, 'assigned_date' => null, 'AefiOriginal' => array() ), 'AefiDescription' => array( (int) 0 => array( 'id' => '1663', 'aefi_id' => '1663', 'description' => 'Swelling', 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49' ), (int) 1 => array( 'id' => '1663', 'aefi_id' => '1663', 'description' => 'Severe', 'created' => '2024-05-27 11:21:49', 'modified' => '2024-05-27 11:59:49' ) ), 'Attachment' => array(), 'AefiListOfVaccine' => array( (int) 0 => array( 'id' => '922', 'aefi_id' => '1663', 'saefi_id' => null, 'vaccine_id' => '14', 'vaccine_name' => '', 'vaccination_date' => '24-05-2024', 'vaccination_time' => array( [maximum depth reached] ), 'vaccine_manufacturer' => 'KKKTTTR', 'vaccination_route' => 'Intramuscular', 'vaccination_site' => 'left arm', 'dosage' => '1', 'icsr_code' => null, 'batch_number' => '4444444', 'expiry_date' => '27-05-2025', 'diluent_batch_number' => 'N/A', 'diluent_manufacturer' => 'YYYYY', 'diluent_expiry_date' => '19-05-2025', 'suspected_drug' => null, 'created' => '2024-05-27 11:56:22', 'modified' => '2024-05-27 11:59:49', 'Vaccine' => array( [maximum depth reached] ) ) ), 'ExternalComment' => array() ) $root = '/' $redir = 'manager' $arr = array( (int) 0 => 'Christine', (int) 1 => '' ) $birthdatef = (int) 102 $outcomes = array( 'Recovered/Resolved' => (int) 1, 'Recovering/Resolving' => (int) 2, 'Recovered/Resolved with sequelae' => (int) 3, 'Not recovered/Not resolved/Ongoing' => (int) 4, 'Fatal' => (int) 5, 'Unknown' => (int) 6 ) $listOfVaccine = array( 'id' => '922', 'aefi_id' => '1663', 'saefi_id' => null, 'vaccine_id' => '14', 'vaccine_name' => '', 'vaccination_date' => '24-05-2024', 'vaccination_time' => array( 'hour' => '12', 'min' => '20' ), 'vaccine_manufacturer' => 'KKKTTTR', 'vaccination_route' => 'Intramuscular', 'vaccination_site' => 'left arm', 'dosage' => '1', 'icsr_code' => null, 'batch_number' => '4444444', 'expiry_date' => '27-05-2025', 'diluent_batch_number' => 'N/A', 'diluent_manufacturer' => 'YYYYY', 'diluent_expiry_date' => '19-05-2025', 'suspected_drug' => null, 'created' => '2024-05-27 11:56:22', 'modified' => '2024-05-27 11:59:49', 'Vaccine' => array( 'id' => '14', 'vaccine_name' => 'Bivalent oral Polio vaccine', 'description' => 'Liquid Suspension - 20 doses per vial', 'health_program' => 'National Vaccines and immunisation program', 'created' => '2021-02-01 11:44:27', 'modified' => '2021-02-01 11:44:27', 'deleted' => false, 'deleted_date' => null ) ) $num = (int) 0</pre><pre class="stack-trace">include - APP/View/Aefis/xml/download_r2.ctp, line 260 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::render() - CORE/Cake/View/View.php, line 473 XmlView::render() - CORE/Cake/View/XmlView.php, line 105 Controller::render() - CORE/Cake/Controller/Controller.php, line 968 AefisController::download() - APP/Controller/AefisController.php, line 1383 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 118</pre></div></pre></drugstructuredosageunit> <drugseparatedosagenumb/> <drugintervaldosageunitnumb/> <drugintervaldosagedefinition/> <drugcumulativedosagenumb/> <drugcumulativedosageunit/> <drugdosagetext>1</drugdosagetext> <drugdosageform/> <drugadministrationroute/> <drugparadministration/> <reactiongestationperiod/> <reactiongestationperiodunit/> <drugindicationmeddraversion/> <drugindication/> <drugstartdateformat>102</drugstartdateformat> <drugstartdate>20240524</drugstartdate> <drugstartperiod/> <drugstartperiodunit/> <druglastperiod/> <druglastperiodunit/> <drugenddateformat/> <drugenddate/> <drugtreatmentduration/> <drugtreatmentdurationunit/> <actiondrug/> <drugrecurreadministration/> <drugadditional>N/A</drugadditional> <activesubstance> <activesubstancename></activesubstancename> </activesubstance> <drugreactionrelatedness> <drugreactionassesmeddraversion>23.0</drugreactionassesmeddraversion> <drugreactionasses>Swelling</drugreactionasses> <drugassessmentsource/> <drugassessmentmethod/> <drugresult/> </drugreactionrelatedness> </drug> <summary> <narrativeincludeclinical>Swelling of feet.</narrativeincludeclinical> <reportercomment/> <senderdiagnosismeddraversion>23.0</senderdiagnosismeddraversion> <senderdiagnosis></senderdiagnosis> <sendercomment/> </summary> </patient> </safetyreport> </ichicsr>
 e2b_file(null)
 file/var/www/ctr/app/webroot/media/transfer/gen/aefi_r2_1663_4.xml
 dirnamegen
 basenameaefi_r2_1663_4.xml
 checksum679f13cf2382fa26784dc1f5e377d34c
 alternative(null)
 group(null)
 descriptionsample
 created2024-05-28 12:00:40
 modified2024-05-28 12:00:40
 deleted(null)
 StudyRoute(array)
 0(array)
 id479
 application_id2
 study_routecutaneous
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 1(array)
 id480
 application_id2
 study_routeoral
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 Manufacturer(array)
 0(array)
 id2
 application_id2
 manufacturer_namemanufacturer
 addressaddress
 manufacturer_countryBosnia and Herzegovina
 manufacturer_phone0700432982
 manufacturer_emailsample@gmail.com
 manufacturing_activitiesComplete manufacturing activities
 other_specify
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 Reassignment(empty)
 Attachment(empty)
 AnnualApproval(array)
 0(array)
 id237
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/animation_1707379052491.json
 foreign_key2
 dirnamegen
 basenameanimation_1707379052491.json
 checksume9e9aea1965ee523141544bb5a50af55
 alternative(null)
 groupCover Letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates)
 year2024
 file_date01-02-2024
 pocket_nameCover Letter
 version_no1
 created2024-02-11 17:38:59
 modified2024-02-11 17:38:59
 pathgen/animation_1707379052491.json
 1(array)
 id238
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_14
 foreign_key2
 dirnamegen
 basenameapplications_14
 checksum23b870253070dd812562ee86358d6ef0
 alternative(null)
 groupCover Letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates)
 year2024
 file_date29-01-2024
 pocket_nameCover Letter
 version_no222
 created2024-02-13 02:12:30
 modified2024-02-13 02:12:30
 pathgen/applications_14
 2(array)
 id241
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_12
 foreign_key2
 dirnamegen
 basenameapplications_12
 checksumdf5b1671a7724e27989e187cd203e0ee
 alternative(null)
 groupprogress_report
 descriptionAnnual progress report
 year2024
 file_date07-02-2024
 pocket_nameprogress_report
 version_no2
 created2024-02-13 02:26:26
 modified2024-02-13 02:26:26
 pathgen/applications_12
 3(array)
 id258
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_15
 foreign_key2
 dirnamegen
 basenameapplications_15
 checksumd77f98ccd77b4e2202a1168790ca962e
 alternative(null)
 groupCover Letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates)
 year2024
 file_date29-01-2024
 pocket_nameCover Letter
 version_no222
 created2024-02-14 09:54:35
 modified2024-02-14 09:54:35
 pathgen/applications_15
 4(array)
 id259
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_15
 foreign_key2
 dirnamegen
 basenameapplications_15
 checksumd77f98ccd77b4e2202a1168790ca962e
 alternative(null)
 groupprogress_report
 descriptionAnnual progress report
 year2024
 file_date07-02-2024
 pocket_nameprogress_report
 version_no2
 created2024-02-14 09:54:38
 modified2024-02-14 09:54:38
 pathgen/applications_15
 5(array)
 id260
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_15
 foreign_key2
 dirnamegen
 basenameapplications_15
 checksumd77f98ccd77b4e2202a1168790ca962e
 alternative(null)
 groupCover Letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates)
 year2021
 file_date29-01-2024
 pocket_nameCover Letter
 version_no222
 created2024-02-14 10:02:47
 modified2024-02-14 10:02:47
 pathgen/applications_15
 6(array)
 id261
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_15
 foreign_key2
 dirnamegen
 basenameapplications_15
 checksumd77f98ccd77b4e2202a1168790ca962e
 alternative(null)
 groupprogress_report
 descriptionAnnual progress report
 year2021
 file_date07-02-2024
 pocket_nameprogress_report
 version_no2
 created2024-02-14 10:02:53
 modified2024-02-14 10:02:53
 pathgen/applications_15
 7(array)
 id262
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/site_inspection_assessment_13
 foreign_key2
 dirnamegen
 basenamesite_inspection_assessment_13
 checksum6104f059e8c41fa45b9b0f9fd5bd6eaa
 alternative(null)
 group2
 descriptionAnother One
 year2021
 file_date29-01-2024
 pocket_name2
 version_no222
 created2024-02-14 10:03:04
 modified2024-02-14 10:03:04
 pathgen/site_inspection_assessment_13
 8(array)
 id263
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_15
 foreign_key2
 dirnamegen
 basenameapplications_15
 checksumd77f98ccd77b4e2202a1168790ca962e
 alternative(null)
 groupsae_susar_log
 descriptionSAE and SUSAR cumulative logs
 year2021
 file_date07-02-2024
 pocket_namesae_susar_log
 version_no2
 created2024-02-14 10:03:11
 modified2024-02-14 10:03:11
 pathgen/applications_15
 9(array)
 id1607
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/img/screenshot_from_2025_02_13_07_26_10_36.png
 foreign_key2
 dirnameimg
 basenamescreenshot_from_2025_02_13_07_26_10_36.png
 checksuma1ef82d2a45a33dad33905dbdb6adf74
 alternative(null)
 groupcover_letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates)
 year2025
 file_date29-01-2024
 pocket_namecover_letter
 version_no222
 created2025-02-13 09:04:27
 modified2025-02-13 09:04:27
 pathimg/screenshot_from_2025_02_13_07_26_10_36.png
 10(array)
 id1608
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/img/screenshot_from_2025_02_13_07_26_10_37.png
 foreign_key2
 dirnameimg
 basenamescreenshot_from_2025_02_13_07_26_10_37.png
 checksuma1ef82d2a45a33dad33905dbdb6adf74
 alternative(null)
 groupprogress_report
 descriptionAnnual progress report
 year2025
 file_date07-02-2024
 pocket_nameprogress_report
 version_no2
 created2025-02-13 09:04:34
 modified2025-02-13 09:04:34
 pathimg/screenshot_from_2025_02_13_07_26_10_37.png
 11(array)
 id1610
 modelAnnualApproval
 file/var/www/ctr/app/webroot/media/transfer/img/screenshot_from_2025_02_13_07_26_10_38.png
 foreign_key2
 dirnameimg
 basenamescreenshot_from_2025_02_13_07_26_10_38.png
 checksuma1ef82d2a45a33dad33905dbdb6adf74
 alternative(null)
 groupsae_susar_log
 descriptionSAE and SUSAR cumulative logs
 year2025
 file_date29-01-2024
 pocket_namesae_susar_log
 version_no222
 created2025-02-13 09:04:41
 modified2025-02-13 09:04:41
 pathimg/screenshot_from_2025_02_13_07_26_10_38.png
 AmendmentChecklist(array)
 0(array)
 id440
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_43
 foreign_key2
 dirnamegen
 basenameapplications_43
 checksum0bb11589d2b4001472fa062e31b304c3
 alternative(null)
 grouptest 15th
 descriptiontest 15th files
 yearamd-4
 file_date2024-02-07
 pocket_nametest 15th
 version_no4
 created2024-02-29 05:46:39
 modified2024-02-29 05:46:39
 pathgen/applications_43
 1(array)
 id441
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_42
 foreign_key2
 dirnamegen
 basenameapplications_42
 checksumd4df02e3925870a027a422089a0dbf15
 alternative(null)
 groupone
 descriptionSome First Amendment File
 yearamd-4
 file_date2024-02-06
 pocket_nameone
 version_no54
 created2024-02-29 05:46:42
 modified2024-02-29 05:46:42
 pathgen/applications_42
 2(array)
 id442
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_42
 foreign_key2
 dirnamegen
 basenameapplications_42
 checksumd4df02e3925870a027a422089a0dbf15
 alternative(null)
 groupsecond
 descriptionsecond
 yearamd-4
 file_date2024-02-22
 pocket_namesecond
 version_no54
 created2024-02-29 05:46:46
 modified2024-02-29 05:46:46
 pathgen/applications_42
 3(array)
 id443
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_42
 foreign_key2
 dirnamegen
 basenameapplications_42
 checksumd4df02e3925870a027a422089a0dbf15
 alternative(null)
 groupTwo
 descriptionSecond File
 yearamd-4
 file_date2024-01-29
 pocket_nameTwo
 version_no4
 created2024-02-29 05:46:49
 modified2024-02-29 05:46:49
 pathgen/applications_42
 4(array)
 id444
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_43
 foreign_key2
 dirnamegen
 basenameapplications_43
 checksum0bb11589d2b4001472fa062e31b304c3
 alternative(null)
 groupThree
 descriptionThird file
 yearamd-4
 file_date2024-02-06
 pocket_nameThree
 version_no4
 created2024-02-29 05:46:52
 modified2024-02-29 05:46:52
 pathgen/applications_43
 5(array)
 id445
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_41
 foreign_key2
 dirnamegen
 basenameapplications_41
 checksum4413b264ad10df0801464a1072095c29
 alternative(null)
 grouplook here
 descriptionhey hey hye
 yearamd-4
 file_date2024-02-06
 pocket_namelook here
 version_no5
 created2024-02-29 05:46:55
 modified2024-02-29 05:46:55
 pathgen/applications_41
 6(array)
 id446
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_43
 foreign_key2
 dirnamegen
 basenameapplications_43
 checksum0bb11589d2b4001472fa062e31b304c3
 alternative(null)
 groupaa
 descriptionw
 yearamd-4
 file_date2024-01-30
 pocket_nameaa
 version_no6
 created2024-02-29 05:46:58
 modified2024-02-29 05:46:58
 pathgen/applications_43
 7(array)
 id447
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_41
 foreign_key2
 dirnamegen
 basenameapplications_41
 checksum4413b264ad10df0801464a1072095c29
 alternative(null)
 groupamendment
 descriptionsome description
 yearamd-4
 file_date2024-02-23
 pocket_name(null)
 version_nov45
 created2024-02-29 05:47:16
 modified2024-02-29 05:48:05
 pathgen/applications_41
 8(array)
 id448
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/applications_40
 foreign_key2
 dirnamegen
 basenameapplications_40
 checksumcf9592e39a000dc3a3d00f9f4976b5d7
 alternative(null)
 groupamendment
 descriptionnext file
 yearamd-4
 file_date2024-02-16
 pocket_name(null)
 version_no444
 created2024-02-29 05:47:44
 modified2024-02-29 05:48:03
 pathgen/applications_40
 9(array)
 id778
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/table_manage.html
 foreign_key2
 dirnamegen
 basenametable_manage.html
 checksum84c2e53230bfb0f93cc0d110b1a7db3e
 alternative(null)
 grouptest 15th
 descriptiontest 15th files
 yearamd-5
 file_date2024-02-06
 pocket_nametest 15th
 version_no54
 created2024-06-19 10:08:32
 modified2024-06-19 10:08:32
 pathgen/table_manage.html
 10(array)
 id779
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/email_detail.html
 foreign_key2
 dirnamegen
 basenameemail_detail.html
 checksum6cc0f6d7aaf07ea846ded713a078ce97
 alternative(null)
 groupDuring the call
 descriptionsample description
 yearamd-5
 file_date2024-02-22
 pocket_nameDuring the call
 version_no54
 created2024-06-19 10:08:39
 modified2024-06-19 10:08:39
 pathgen/email_detail.html
 11(array)
 id780
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/email_detail_2.html
 foreign_key2
 dirnamegen
 basenameemail_detail_2.html
 checksum6cc0f6d7aaf07ea846ded713a078ce97
 alternative(null)
 groupone
 descriptionSome First Amendment File
 yearamd-5
 file_date2024-01-29
 pocket_nameone
 version_no4
 created2024-06-19 10:08:52
 modified2024-06-19 10:08:52
 pathgen/email_detail_2.html
 12(array)
 id781
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/email_detail_3.html
 foreign_key2
 dirnamegen
 basenameemail_detail_3.html
 checksum6cc0f6d7aaf07ea846ded713a078ce97
 alternative(null)
 groupsecond
 descriptionsecond
 yearamd-5
 file_date2024-02-06
 pocket_namesecond
 version_no4
 created2024-06-19 10:08:59
 modified2024-06-19 10:08:59
 pathgen/email_detail_3.html
 13(array)
 id782
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/table_manage_2.html
 foreign_key2
 dirnamegen
 basenametable_manage_2.html
 checksum84c2e53230bfb0f93cc0d110b1a7db3e
 alternative(null)
 groupTwo
 descriptionSecond File
 yearamd-5
 file_date2024-02-06
 pocket_nameTwo
 version_no5
 created2024-06-19 10:09:08
 modified2024-06-19 10:09:08
 pathgen/table_manage_2.html
 14(array)
 id783
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/table_manage_3.html
 foreign_key2
 dirnamegen
 basenametable_manage_3.html
 checksum84c2e53230bfb0f93cc0d110b1a7db3e
 alternative(null)
 groupThree
 descriptionThird file
 yearamd-5
 file_date2024-01-30
 pocket_nameThree
 version_no6
 created2024-06-19 10:09:16
 modified2024-06-19 10:09:16
 pathgen/table_manage_3.html
 15(array)
 id784
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/email_detail_4.html
 foreign_key2
 dirnamegen
 basenameemail_detail_4.html
 checksum6cc0f6d7aaf07ea846ded713a078ce97
 alternative(null)
 grouplook here
 descriptionhey hey hye
 yearamd-5
 file_date2024-02-23
 pocket_namelook here
 version_nov45
 created2024-06-19 10:09:24
 modified2024-06-19 10:09:24
 pathgen/email_detail_4.html
 16(array)
 id785
 modelAmendmentChecklist
 file/var/www/ctr/app/webroot/media/transfer/gen/table_manage_4.html
 foreign_key2
 dirnamegen
 basenametable_manage_4.html
 checksum84c2e53230bfb0f93cc0d110b1a7db3e
 alternative(null)
 groupaa
 descriptionw
 yearamd-5
 file_date2024-02-16
 pocket_nameaa
 version_no444
 created2024-06-19 10:09:32
 modified2024-06-19 10:09:32
 pathgen/table_manage_4.html
 Reminder(empty)
 ParticipantFlow(empty)
 Budget(array)
 0(array)
 id2
 application_id2
 year(null)
 budget_period(null)
 personnel_currencyKES
 personnel1
 transport_currencyKES
 transport1
 field_currencyKES
 field1
 supplies_currencyKES
 supplies1
 pharmacy_currencyKES
 pharmacy1
 travel_currencyKES
 travel1
 regulatory_currencyKES
 regulatory1
 it_currencyKES
 it1
 lab_currency(null)
 lab(null)
 others_currencyKES
 others1
 kemri_currency(null)
 kemri(null)
 wrair_currency(null)
 wrair(null)
 subject_currencyKES
 subject1
 grand_currencyKES
 grand_total1
 study_informationsome info
 personnel_kshs1
 transport_kshs1
 field_kshs1
 supplies_kshs1
 pharmacy_kshs1
 travel_kshs1
 regulatory_kshs1
 it_kshs1
 lab_kshs(null)
 others_kshs1
 grand_total_kshs1
 subject_kshs1
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 Deviation(array)
 0(array)
 id2
 application_id2
 user_id29
 reference_noDEV/2024/02
 study_title Sample Title
 deviation_type(null)
 deviation_type_dev(null)
 pi_namesome name some name some name
 deviation_date(null)
 participant_number(null)
 treating_physician(null)
 deviation_description(null)
 deviation_explanation(null)
 deviation_measures(null)
 deviation_preclude(null)
 sponsor_notified0
 sponsor_notification_date(null)
 sponsor_explanation(null)
 study_impact(null)
 statusUnsubmitted
 date_submitted(null)
 deleted0
 deleted_date(null)
 created2024-02-13 03:12:51
 modified2024-02-13 03:12:51
 1(array)
 id3
 application_id2
 user_id33
 reference_noDEV/2024/03
 study_title Sample Title
 deviation_type(null)
 deviation_type_dev(null)
 pi_namesome name some name some name
 deviation_date(null)
 participant_number(null)
 treating_physician(null)
 deviation_description(null)
 deviation_explanation(null)
 deviation_measures(null)
 deviation_preclude(null)
 sponsor_notified0
 sponsor_notification_date(null)
 sponsor_explanation(null)
 study_impact(null)
 statusUnsubmitted
 date_submitted(null)
 deleted0
 deleted_date(null)
 created2024-02-22 03:19:15
 modified2024-02-22 03:19:15
 2(array)
 id4
 application_id2
 user_id33
 reference_noDEV/2024/04
 study_title Sample Title
 deviation_typeViolation
 deviation_type_dev(null)
 pi_namesome name some name some name
 deviation_date(null)
 participant_numberSJAK
 treating_physicianGHJGJ
 deviation_descriptionJHGJHGHJ
 deviation_explanationKJJK
 deviation_measuresKJHJ
 deviation_precludeHKHJKH
 sponsor_notified1
 sponsor_notification_date(null)
 sponsor_explanation(null)
 study_impactKJHKHKJHJ
 statusSubmitted
 date_submitted(null)
 deleted0
 deleted_date(null)
 created2024-02-22 03:19:31
 modified2024-02-22 03:22:49
 3(array)
 id5
 application_id2
 user_id29
 reference_noDEV/2024/05
 study_title Sample Title
 deviation_type(null)
 deviation_type_dev(null)
 pi_namesome name some name some name
 deviation_date(null)
 participant_number(null)
 treating_physician(null)
 deviation_description(null)
 deviation_explanation(null)
 deviation_measures(null)
 deviation_preclude(null)
 sponsor_notified0
 sponsor_notification_date(null)
 sponsor_explanation(null)
 study_impact(null)
 statusUnsubmitted
 date_submitted(null)
 deleted0
 deleted_date(null)
 created2024-02-22 03:20:54
 modified2024-02-22 03:20:54
 4(array)
 id10
 application_id2
 user_id37
 reference_noDEV/2024/10
 study_title Sample Title
 deviation_type(null)
 deviation_type_dev(null)
 pi_namesome name principal some name principal some name principal
 deviation_date(null)
 participant_number(null)
 treating_physician(null)
 deviation_description(null)
 deviation_explanation(null)
 deviation_measures(null)
 deviation_preclude(null)
 sponsor_notified0
 sponsor_notification_date(null)
 sponsor_explanation(null)
 study_impact(null)
 statusUnsubmitted
 date_submitted(null)
 deleted0
 deleted_date(null)
 created2024-05-23 14:45:54
 modified2024-05-23 14:45:54
 5(array)
 id17
 application_id2
 user_id48
 reference_noDEV/2024/17
 study_title Sample Title
 deviation_type(null)
 deviation_type_dev(null)
 pi_namesome name principal some name principal some name principal
 deviation_date(null)
 participant_number(null)
 treating_physician(null)
 deviation_description(null)
 deviation_explanation(null)
 deviation_measures(null)
 deviation_preclude(null)
 sponsor_notified0
 sponsor_notification_date(null)
 sponsor_explanation(null)
 study_impact(null)
 statusUnsubmitted
 date_submitted(null)
 deleted0
 deleted_date(null)
 created2024-05-28 11:37:46
 modified2024-05-28 11:37:46
 6(array)
 id18
 application_id2
 user_id48
 reference_noDEV/2024/18
 study_title Sample Title
 deviation_type(null)
 deviation_type_dev(null)
 pi_namesome name principal some name principal some name principal
 deviation_date(null)
 participant_number(null)
 treating_physician(null)
 deviation_description(null)
 deviation_explanation(null)
 deviation_measures(null)
 deviation_preclude(null)
 sponsor_notified0
 sponsor_notification_date(null)
 sponsor_explanation(null)
 study_impact(null)
 statusUnsubmitted
 date_submitted(null)
 deleted0
 deleted_date(null)
 created2024-05-28 11:38:20
 modified2024-05-28 11:38:20
 7(array)
 id21
 application_id2
 user_id48
 reference_noDEV/2024/21
 study_title Sample Title
 deviation_type(null)
 deviation_type_dev(null)
 pi_namesome name principal some name principal some name principal
 deviation_date(null)
 participant_number(null)
 treating_physician(null)
 deviation_description(null)
 deviation_explanation(null)
 deviation_measures(null)
 deviation_preclude(null)
 sponsor_notified0
 sponsor_notification_date(null)
 sponsor_explanation(null)
 study_impact(null)
 statusUnsubmitted
 date_submitted(null)
 deleted0
 deleted_date(null)
 created2024-06-10 17:22:20
 modified2024-06-10 17:22:20
 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)
 id558
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr.png
 foreign_key2
 dirnameimg
 basenameicon_adr.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_covering_letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates) *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_covering_letter
 version_no1
 created2024-05-22 16:47:12
 modified2024-06-25 08:22:28
 pathimg/icon_adr.png
 1(array)
 id559
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_2.png
 foreign_key2
 dirnameimg
 basenameicon_adr_2.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_protocol
 descriptionThe Study Protocol *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_protocol
 version_no1
 created2024-05-22 16:47:21
 modified2024-06-25 08:22:28
 pathimg/icon_adr_2.png
 2(array)
 id560
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_3.png
 foreign_key2
 dirnameimg
 basenameicon_adr_3.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_pan_african
 descriptionRegistration of the study at Pan African Clinical Trials Registry https://pactr.samrc.ac.za *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_pan_african
 version_no1
 created2024-05-22 16:47:32
 modified2024-06-25 08:22:28
 pathimg/icon_adr_3.png
 3(array)
 id561
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_4.png
 foreign_key2
 dirnameimg
 basenameicon_adr_4.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_patient_information
 descriptionPatient Information leaflet and Informed consent form *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_patient_information
 version_no1
 created2024-05-22 16:47:41
 modified2024-06-25 08:22:28
 pathimg/icon_adr_4.png
 4(array)
 id562
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_5.png
 foreign_key2
 dirnameimg
 basenameicon_adr_5.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_investigators_brochure
 descriptionInvestigators Brochure/Package inserts *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_investigators_brochure
 version_no1
 created2024-05-22 16:47:51
 modified2024-06-25 08:22:28
 pathimg/icon_adr_5.png
 5(array)
 id563
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_6.png
 foreign_key2
 dirnameimg
 basenameicon_adr_6.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_impd
 descriptionInvestigational Medicinal Product Dossier (IMPD) *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_impd
 version_no1
 created2024-05-22 16:48:03
 modified2024-06-25 08:22:28
 pathimg/icon_adr_6.png
 6(array)
 id564
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_7.png
 foreign_key2
 dirnameimg
 basenameicon_adr_7.png
 checksum60526c0bd26868fb0b0ca867ce950514
 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_date22-05-2024
 pocket_nameapplicant_prev_data
 version_no1
 created2024-05-22 16:48:11
 modified2024-06-25 08:22:28
 pathimg/icon_adr_7.png
 7(array)
 id565
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_8.png
 foreign_key2
 dirnameimg
 basenameicon_adr_8.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_stability_data
 descriptionStability data of the investigational product *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_stability_data
 version_no1
 created2024-05-22 16:48:19
 modified2024-06-25 08:22:28
 pathimg/icon_adr_8.png
 8(array)
 id566
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_9.png
 foreign_key2
 dirnameimg
 basenameicon_adr_9.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_gmp_certificate
 descriptionGMP certificate of the investigational product from the site of manufacture *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_gmp_certificate
 version_no1
 created2024-05-22 16:48:27
 modified2024-06-25 08:22:28
 pathimg/icon_adr_9.png
 9(array)
 id567
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_10.png
 foreign_key2
 dirnameimg
 basenameicon_adr_10.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_analysis_cert
 descriptionCertificate of Analysis of the investigational product *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_analysis_cert
 version_no1
 created2024-05-22 16:48:36
 modified2024-06-25 08:22:28
 pathimg/icon_adr_10.png
 10(array)
 id568
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_11.png
 foreign_key2
 dirnameimg
 basenameicon_adr_11.png
 checksum60526c0bd26868fb0b0ca867ce950514
 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_date22-05-2024
 pocket_nameapplicant_pictorial_sample
 version_no1
 created2024-05-22 16:48:44
 modified2024-06-25 08:22:28
 pathimg/icon_adr_11.png
 11(array)
 id569
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_12.png
 foreign_key2
 dirnameimg
 basenameicon_adr_12.png
 checksum60526c0bd26868fb0b0ca867ce950514
 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_date22-05-2024
 pocket_nameapplicant_investigators_cv
 version_no1
 created2024-05-22 16:48:54
 modified2024-06-25 08:22:28
 pathimg/icon_adr_12.png
 12(array)
 id570
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_13.png
 foreign_key2
 dirnameimg
 basenameicon_adr_13.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_contractual_agreement
 descriptionEvidence of contractual agreement between sponsor and Principal Investigator. *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_contractual_agreement
 version_no1
 created2024-05-22 16:49:05
 modified2024-06-25 08:22:28
 pathimg/icon_adr_13.png
 13(array)
 id571
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_14.png
 foreign_key2
 dirnameimg
 basenameicon_adr_14.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_gcp_training
 descriptionEvidence of recent GCP training of the core study staff *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_gcp_training
 version_no1
 created2024-05-22 16:49:23
 modified2024-06-25 08:22:28
 pathimg/icon_adr_14.png
 14(array)
 id572
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_15.png
 foreign_key2
 dirnameimg
 basenameicon_adr_15.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_dsmb_charter
 descriptionDSMB Charter including the composition and meeting schedule *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_dsmb_charter
 version_no1
 created2024-05-22 16:49:28
 modified2024-06-25 08:22:28
 pathimg/icon_adr_15.png
 15(array)
 id573
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_16.png
 foreign_key2
 dirnameimg
 basenameicon_adr_16.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_detailed_budget
 descriptionDetailed budget of the study *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_detailed_budget
 version_no1
 created2024-05-22 16:49:36
 modified2024-06-25 08:22:28
 pathimg/icon_adr_16.png
 16(array)
 id574
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_17.png
 foreign_key2
 dirnameimg
 basenameicon_adr_17.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_financial_declaration
 descriptionFinancial declaration by Sponsor and/or PI *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_financial_declaration
 version_no1
 created2024-05-22 16:49:44
 modified2024-06-25 08:22:28
 pathimg/icon_adr_17.png
 17(array)
 id575
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_18.png
 foreign_key2
 dirnameimg
 basenameicon_adr_18.png
 checksum60526c0bd26868fb0b0ca867ce950514
 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_date22-05-2024
 pocket_nameapplicant_signed_declaration
 version_no1
 created2024-05-22 16:49:54
 modified2024-06-25 08:22:28
 pathimg/icon_adr_18.png
 18(array)
 id576
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_19.png
 foreign_key2
 dirnameimg
 basenameicon_adr_19.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_indemnity_pi
 descriptionIndemnity cover for PI, investigators and study Pharmacist. *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_indemnity_pi
 version_no1
 created2024-05-22 16:50:03
 modified2024-06-25 08:22:28
 pathimg/icon_adr_19.png
 19(array)
 id577
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_20.png
 foreign_key2
 dirnameimg
 basenameicon_adr_20.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_indemnity_cover
 descriptionClinical Trials Insurance cover for study participants *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_indemnity_cover
 version_no1
 created2024-05-22 16:50:11
 modified2024-06-25 08:22:28
 pathimg/icon_adr_20.png
 20(array)
 id578
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_21.png
 foreign_key2
 dirnameimg
 basenameicon_adr_21.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_opinion_letter
 descriptionCopy of favorable opinion letter from the local Ethics Review Committee (ERC). *
 year(null)
 file_date22-05-2024
 pocket_nameapplicant_opinion_letter
 version_no1
 created2024-05-22 16:50:20
 modified2024-06-25 08:22:28
 pathimg/icon_adr_21.png
 21(array)
 id579
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_22.png
 foreign_key2
 dirnameimg
 basenameicon_adr_22.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_practice_license
 descriptionCopy of current Practice Licenses for the Investigators and study Pharmacist *
 year(null)
 file_date15-05-2024
 pocket_nameapplicant_practice_license
 version_no1
 created2024-05-22 16:50:28
 modified2024-06-25 08:22:28
 pathimg/icon_adr_22.png
 22(array)
 id580
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_23.png
 foreign_key2
 dirnameimg
 basenameicon_adr_23.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_approval_letter
 descriptionCopy of approval letter(s) from collaborating institutions or other regulatory authorities, if applicable
 year(null)
 file_date15-05-2024
 pocket_nameapplicant_approval_letter
 version_no1
 created2024-05-22 16:50:37
 modified2024-06-25 08:22:28
 pathimg/icon_adr_23.png
 23(array)
 id581
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_24.png
 foreign_key2
 dirnameimg
 basenameicon_adr_24.png
 checksum60526c0bd26868fb0b0ca867ce950514
 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_date22-05-2024
 pocket_nameapplicant_addendum
 version_no1
 created2024-05-22 16:50:45
 modified2024-06-25 08:22:28
 pathimg/icon_adr_24.png
 24(array)
 id582
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_25.png
 foreign_key2
 dirnameimg
 basenameicon_adr_25.png
 checksum60526c0bd26868fb0b0ca867ce950514
 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_date15-05-2024
 pocket_nameapplicant_statement
 version_no1
 created2024-05-22 16:50:52
 modified2024-06-25 08:22:28
 pathimg/icon_adr_25.png
 25(array)
 id583
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_26.png
 foreign_key2
 dirnameimg
 basenameicon_adr_26.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_fees
 descriptionPayment of fees *
 year(null)
 file_date15-05-2024
 pocket_nameapplicant_fees
 version_no1
 created2024-05-22 16:51:01
 modified2024-06-25 08:22:28
 pathimg/icon_adr_26.png
 26(array)
 id584
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_27.png
 foreign_key2
 dirnameimg
 basenameicon_adr_27.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupstatistical_analysis_plan
 descriptionStatistical Analysis Plan *
 year(null)
 file_date15-05-2024
 pocket_namestatistical_analysis_plan
 version_no1
 created2024-05-22 16:51:10
 modified2024-06-25 08:22:28
 pathimg/icon_adr_27.png
 27(array)
 id585
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/img/icon_adr_28.png
 foreign_key2
 dirnameimg
 basenameicon_adr_28.png
 checksum60526c0bd26868fb0b0ca867ce950514
 alternative(null)
 groupapplicant_signed_checklist
 descriptionSigned Checklist *
 year(null)
 file_date15-05-2024
 pocket_nameapplicant_signed_checklist
 version_no1
 created2024-05-22 16:51:17
 modified2024-06-25 08:22:28
 pathimg/icon_adr_28.png
 StudyMonitor(empty)
 ProtocolOutsource(empty)
 Outsource(empty)
- redir
- $request->data(empty)
- $this->validationErrors(array)
 Permission(empty)
 Aro(empty)
 Aco(empty)
 Application(empty)
 User(empty)
 TrialStatus(empty)
 Review(empty)
 InternalReview(empty)
 ActiveInspector(empty)
 ManagerReview(empty)
 Acceptance(empty)
 Amendment(empty)
 InvestigatorContact(empty)
 ApplicationStage(empty)
 Pharmacist(empty)
 EthicalCommittee(empty)
 AnnualLetter(empty)
 AmendmentLetter(empty)
 AmendmentApproval(empty)
 AmendmentApprovalSummary(empty)
 Organization(empty)
 SiteDetail(empty)
 Placebo(empty)
 Sponsor(empty)
 SiteInspection(empty)
 Sae(empty)
 Ciom(empty)
 StudyRoute(empty)
 Manufacturer(empty)
 Reassignment(empty)
 Attachment(empty)
 AnnualApproval(empty)
 AmendmentChecklist(empty)
 Reminder(empty)
 ParticipantFlow(empty)
 Budget(empty)
 Deviation(empty)
 Document(empty)
 CoverLetter(empty)
 Protocol(empty)
 PatientLeaflet(empty)
 Brochure(empty)
 GmpCertificate(empty)
 Cv(empty)
 Finance(empty)
 Declaration(empty)
 IndemnityCover(empty)
 OpinionLetter(empty)
 ApprovalLetter(empty)
 Statement(empty)
 ParticipatingStudy(empty)
 Addendum(empty)
 Registration(empty)
 Fee(empty)
 Checklist(empty)
 StudyMonitor(empty)
 ProtocolOutsource(empty)
 Outsource(empty)
- Loaded Helpers(array)
 0Html
 1Form
 2Session
 3Text
 4Number
 5SimpleGraph
 6DebugTimer
 7Toolbar
 8HtmlToolbar
====

Environment

App Constants

Constant	Value
MEDIA	'/var/www/ctr/app/webroot/media/'
MEDIA_STATIC	'/var/www/ctr/app/webroot/media/static/'
MEDIA_FILTER	'/var/www/ctr/app/webroot/media/filter/'
MEDIA_TRANSFER	'/var/www/ctr/app/webroot/media/transfer/'
MEDIA_URL	'media/'
MEDIA_STATIC_URL	'media/static/'
MEDIA_FILTER_URL	'media/filter/'
MEDIA_TRANSFER_URL	'media/transfer/'
HTTP_HOST	'45.79.161.190:8080'
HTTP_BASE	'http://45.79.161.190:8080'
HTTP_SELF	'/app/webroot/index.php'
HTTP_URI	'/applications/view/2'
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 Accept Encoding	'gzip, br, zstd, deflate'
Http Host	'45.79.161.190:8080'
Http Via	'1.1 squid-proxy-5b96dc6d46-5rn9l (squid/6.13)'
Http X Forwarded For	'10.3.233.74'
Http Cache Control	'max-age=259200'
Http Connection	'keep-alive'
Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
Server Signature	' Apache/2.4.41 (Ubuntu) Server at 45.79.161.190 Port 8080 '
Server Software	'Apache/2.4.41 (Ubuntu)'
Server Name	'45.79.161.190'
Server Addr	'45.79.161.190'
Server Port	'8080'
Remote Addr	'216.73.216.151'
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	'22310'
Redirect Url	'/app/webroot/applications/view/2'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/applications/view/2'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1790915788.871
Request Time	(int) 1790915788

====

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
====

Protocol No:	ECCT/24/01/01	Date of Protocol:	09-01-2024
Status:	Approved	Date Approved:	13-01-2025
Status:	Stopped	Date Stopped:	29-02-2024

Study Title:	Sample Title
Study Objectives:	objectives
Laymans Summary:	Some Summary
Abstract of Study:	Abstract

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 87 ms Total Queries: 56 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 87 ms
Total Queries: 56 queries