Pharmacy and Poisons Board: Applications

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

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

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

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

Sql Logs

default

Total Time: 49 ms
Total Queries: 53 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `ctr`.`applications` AS `Application` WHERE `Application`.`id` = 14	1	1	0
SELECT `Application`.`id`, `Application`.`user_id`, `Application`.`application_id`, `Application`.`is_child`, `Application`.`trial_status_id`, `Application`.`total_sites`, `Application`.`abstract_of_study`, `Application`.`study_title`, `Application`.`laymans_summary`, `Application`.`short_title`, `Application`.`protocol_no`, `Application`.`reference_no`, `Application`.`version_no`, `Application`.`date_of_protocol`, `Application`.`study_drug`, `Application`.`disease_condition`, `Application`.`product_type_biologicals`, `Application`.`product_type_proteins`, `Application`.`product_type_immunologicals`, `Application`.`product_type_vaccines`, `Application`.`product_type_hormones`, `Application`.`product_type_toxoid`, `Application`.`product_type_chemical`, `Application`.`product_type_medical_device`, `Application`.`product_type_chemical_name`, `Application`.`product_type_medical_device_name`, `Application`.`comparator`, `Application`.`comparator_name`, `Application`.`comparator_registered`, `Application`.`comparator_countries`, `Application`.`ecct_not_applicable`, `Application`.`ecct_ref_number`, `Application`.`email_address`, `Application`.`applicant_covering_letter`, `Application`.`applicant_protocol`, `Application`.`applicant_patient_information`, `Application`.`applicant_investigators_brochure`, `Application`.`applicant_investigators_cv`, `Application`.`applicant_signed_declaration`, `Application`.`applicant_financial_declaration`, `Application`.`applicant_gmp_certificate`, `Application`.`applicant_indemnity_cover`, `Application`.`applicant_opinion_letter`, `Application`.`applicant_approval_letter`, `Application`.`applicant_statement`, `Application`.`applicant_participating_countries`, `Application`.`applicant_addendum`, `Application`.`applicant_fees`, `Application`.`applicant_complete_form`, `Application`.`applicant_impd`, `Application`.`applicant_prev_data`, `Application`.`applicant_stability_data`, `Application`.`applicant_analysis_cert`, `Application`.`applicant_pictorial_sample`, `Application`.`applicant_gcp_training`, `Application`.`applicant_dsmb_charter`, `Application`.`applicant_detailed_budget`, `Application`.`applicant_indemnity_pi`, `Application`.`applicant_practice_license`, `Application`.`applicant_registration_ctr`, `Application`.`applicant_pan_african`, `Application`.`applicant_hard_copies`, `Application`.`applicant_signed_checklist`, `Application`.`statistical_analysis_plan`, `Application`.`applicant_contractual_agreement`, `Application`.`declaration_applicant`, `Application`.`declaration_date1`, `Application`.`declaration_principal_investigator`, `Application`.`declaration_date2`, `Application`.`placebo_present`, `Application`.`study_objectives`, `Application`.`principal_inclusion_criteria`, `Application`.`principal_exclusion_criteria`, `Application`.`primary_end_points`, `Application`.`scope_diagnosis`, `Application`.`scope_prophylaxis`, `Application`.`scope_therapy`, `Application`.`scope_safety`, `Application`.`scope_efficacy`, `Application`.`scope_pharmacokinetic`, `Application`.`scope_pharmacodynamic`, `Application`.`scope_bioequivalence`, `Application`.`scope_dose_response`, `Application`.`scope_pharmacogenetic`, `Application`.`scope_pharmacogenomic`, `Application`.`scope_pharmacoecomomic`, `Application`.`scope_others`, `Application`.`scope_others_specify`, `Application`.`trial_human_pharmacology`, `Application`.`trial_administration_humans`, `Application`.`trial_bioequivalence_study`, `Application`.`trial_other`, `Application`.`trial_other_specify`, `Application`.`trial_therapeutic_exploratory`, `Application`.`trial_therapeutic_confirmatory`, `Application`.`trial_therapeutic_use`, `Application`.`design_controlled`, `Application`.`site_capacity`, `Application`.`staff_numbers`, `Application`.`other_details_explanation`, `Application`.`other_details_regulatory_notapproved`, `Application`.`other_details_regulatory_approved`, `Application`.`other_details_regulatory_rejected`, `Application`.`other_details_regulatory_halted`, `Application`.`estimated_duration`, `Application`.`design_controlled_randomised`, `Application`.`design_controlled_open`, `Application`.`design_controlled_single_blind`, `Application`.`design_controlled_double_blind`, `Application`.`design_controlled_parallel_group`, `Application`.`design_controlled_cross_over`, `Application`.`design_controlled_other`, `Application`.`design_controlled_specify`, `Application`.`design_controlled_comparator`, `Application`.`design_controlled_other_medicinal`, `Application`.`design_controlled_placebo`, `Application`.`design_controlled_medicinal_other`, `Application`.`design_controlled_medicinal_specify`, `Application`.`single_site_member_state`, `Application`.`location_of_area`, `Application`.`single_site_physical_address`, `Application`.`single_site_contact_person`, `Application`.`single_site_telephone`, `Application`.`multiple_sites_member_state`, `Application`.`multiple_countries`, `Application`.`multiple_member_states`, `Application`.`number_of_sites`, `Application`.`multi_country_list`, `Application`.`data_monitoring_committee`, `Application`.`total_enrolment_per_site`, `Application`.`total_participants_worldwide`, `Application`.`population_less_than_18_years`, `Application`.`population_utero`, `Application`.`population_preterm_newborn`, `Application`.`population_newborn`, `Application`.`population_infant_and_toddler`, `Application`.`population_children`, `Application`.`population_adolescent`, `Application`.`population_above_18`, `Application`.`population_adult`, `Application`.`population_elderly`, `Application`.`gender_female`, `Application`.`gender_male`, `Application`.`subjects_healthy`, `Application`.`subjects_patients`, `Application`.`subjects_vulnerable_populations`, `Application`.`subjects_women_child_bearing`, `Application`.`subjects_women_using_contraception`, `Application`.`subjects_pregnant_women`, `Application`.`subjects_nursing_women`, `Application`.`subjects_emergency_situation`, `Application`.`subjects_incapable_consent`, `Application`.`subjects_specify`, `Application`.`subjects_others`, `Application`.`subjects_others_specify`, `Application`.`investigator1_given_name`, `Application`.`investigator1_middle_name`, `Application`.`investigator1_family_name`, `Application`.`investigator1_qualification`, `Application`.`investigator1_professional_address`, `Application`.`investigator1_telephone`, `Application`.`investigator1_email`, `Application`.`organisations_transferred_`, `Application`.`number_participants`, `Application`.`notification`, `Application`.`approval_date`, `Application`.`submitted`, `Application`.`deleted`, `Application`.`deleted_date`, `Application`.`deactivated`, `Application`.`date_submitted`, `Application`.`unsubmitted`, `Application`.`initial_date_submitted`, `Application`.`admin_stopped`, `Application`.`admin_stopped_reason`, `Application`.`approved`, `Application`.`approved_reason`, `Application`.`approved_date`, `Application`.`final_report`, `Application`.`implication_results`, `Application`.`quantity_imported`, `Application`.`quantity_dispensed`, `Application`.`quantity_destroyed`, `Application`.`quantity_exported`, `Application`.`balance_site`, `Application`.`final_date`, `Application`.`ecitizen_invoice`, `Application`.`modified`, `Application`.`created`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`confirm_password`, `User`.`name`, `User`.`email`, `User`.`national_id_number`, `User`.`sponsor`, `User`.`sponsor_email`, `User`.`qualification`, `User`.`phone_no`, `User`.`name_of_institution`, `User`.`institution_physical`, `User`.`institution_address`, `User`.`institution_contact`, `User`.`county_id`, `User`.`country_id`, `User`.`group_id`, `User`.`activation_key`, `User`.`forgot_password`, `User`.`is_active`, `User`.`deactivated`, `User`.`created`, `User`.`modified`, `TrialStatus`.`id`, `TrialStatus`.`value`, `TrialStatus`.`name`, `TrialStatus`.`created`, `TrialStatus`.`modified` FROM `ctr`.`applications` AS `Application` LEFT JOIN `ctr`.`users` AS `User` ON (`Application`.`user_id` = `User`.`id`) LEFT JOIN `ctr`.`trial_statuses` AS `TrialStatus` ON (`Application`.`trial_status_id` = `TrialStatus`.`id`) WHERE `Application`.`id` = 14 AND `Application`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`application_id`, `Review`.`type`, `Review`.`assessment_type`, `Review`.`title`, `Review`.`text`, `Review`.`summary`, `Review`.`recommendation`, `Review`.`notified`, `Review`.`accepted`, `Review`.`conflict`, `Review`.`status`, `Review`.`created`, `Review`.`modified` FROM `ctr`.`reviews` AS `Review` WHERE `Review`.`application_id` = (14)	0	0	0
SELECT `ActiveInspector`.`id`, `ActiveInspector`.`user_id`, `ActiveInspector`.`application_id`, `ActiveInspector`.`type`, `ActiveInspector`.`assessment_type`, `ActiveInspector`.`title`, `ActiveInspector`.`text`, `ActiveInspector`.`summary`, `ActiveInspector`.`recommendation`, `ActiveInspector`.`notified`, `ActiveInspector`.`accepted`, `ActiveInspector`.`conflict`, `ActiveInspector`.`status`, `ActiveInspector`.`created`, `ActiveInspector`.`modified` FROM `ctr`.`active_inspectors` AS `ActiveInspector` WHERE `ActiveInspector`.`application_id` = (14)	1	1	0
SELECT `ManagerReview`.`id`, `ManagerReview`.`user_id`, `ManagerReview`.`application_id`, `ManagerReview`.`type`, `ManagerReview`.`assessment_type`, `ManagerReview`.`title`, `ManagerReview`.`text`, `ManagerReview`.`summary`, `ManagerReview`.`recommendation`, `ManagerReview`.`notified`, `ManagerReview`.`accepted`, `ManagerReview`.`conflict`, `ManagerReview`.`status`, `ManagerReview`.`created`, `ManagerReview`.`modified` FROM `ctr`.`reviews` AS `ManagerReview` WHERE `ManagerReview`.`application_id` = (14)	0	0	0
SELECT `Acceptance`.`id`, `Acceptance`.`user_id`, `Acceptance`.`application_id`, `Acceptance`.`type`, `Acceptance`.`assessment_type`, `Acceptance`.`title`, `Acceptance`.`text`, `Acceptance`.`summary`, `Acceptance`.`recommendation`, `Acceptance`.`notified`, `Acceptance`.`accepted`, `Acceptance`.`conflict`, `Acceptance`.`status`, `Acceptance`.`created`, `Acceptance`.`modified` FROM `ctr`.`reviews` AS `Acceptance` WHERE `Acceptance`.`type` = 'acceptance' AND `Acceptance`.`application_id` = (14)	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` = (14)	2	2	1	maybe slow
SELECT `InvestigatorContact`.`id`, `InvestigatorContact`.`application_id`, `InvestigatorContact`.`given_name`, `InvestigatorContact`.`middle_name`, `InvestigatorContact`.`family_name`, `InvestigatorContact`.`qualification`, `InvestigatorContact`.`professional_address`, `InvestigatorContact`.`telephone`, `InvestigatorContact`.`email`, `InvestigatorContact`.`created`, `InvestigatorContact`.`modified` FROM `ctr`.`investigator_contacts` AS `InvestigatorContact` WHERE `InvestigatorContact`.`application_id` = (14)	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` = (14)	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` = (14)	1	1	0
SELECT `EthicalCommittee`.`id`, `EthicalCommittee`.`application_id`, `EthicalCommittee`.`ethical_committee`, `EthicalCommittee`.`submission_date`, `EthicalCommittee`.`erc_number`, `EthicalCommittee`.`initial_approval`, `EthicalCommittee`.`created`, `EthicalCommittee`.`modified` FROM `ctr`.`ethical_committees` AS `EthicalCommittee` WHERE `EthicalCommittee`.`application_id` = (14)	1	1	0
SELECT `AnnualLetter`.`id`, `AnnualLetter`.`application_id`, `AnnualLetter`.`approval_no`, `AnnualLetter`.`type`, `AnnualLetter`.`content`, `AnnualLetter`.`qrcode`, `AnnualLetter`.`approver`, `AnnualLetter`.`approval_date`, `AnnualLetter`.`expiry_date`, `AnnualLetter`.`status`, `AnnualLetter`.`deleted`, `AnnualLetter`.`deleted_date`, `AnnualLetter`.`created`, `AnnualLetter`.`modified` FROM `ctr`.`annual_letters` AS `AnnualLetter` WHERE `AnnualLetter`.`deleted` = '0' AND `AnnualLetter`.`application_id` = (14)	0	0	1	maybe slow
SELECT `AmendmentLetter`.`id`, `AmendmentLetter`.`application_id`, `AmendmentLetter`.`approval_no`, `AmendmentLetter`.`content`, `AmendmentLetter`.`qrcode`, `AmendmentLetter`.`approver`, `AmendmentLetter`.`approval_date`, `AmendmentLetter`.`expiry_date`, `AmendmentLetter`.`status`, `AmendmentLetter`.`submitted`, `AmendmentLetter`.`deleted`, `AmendmentLetter`.`deleted_date`, `AmendmentLetter`.`created`, `AmendmentLetter`.`modified` FROM `ctr`.`amendment_letters` AS `AmendmentLetter` WHERE `AmendmentLetter`.`application_id` = (14)	0	0	0
SELECT `AmendmentApproval`.`id`, `AmendmentApproval`.`application_id`, `AmendmentApproval`.`approval_no`, `AmendmentApproval`.`amendment`, `AmendmentApproval`.`content`, `AmendmentApproval`.`approver`, `AmendmentApproval`.`approval_date`, `AmendmentApproval`.`status`, `AmendmentApproval`.`deleted`, `AmendmentApproval`.`deleted_date`, `AmendmentApproval`.`created`, `AmendmentApproval`.`modified` FROM `ctr`.`amendment_approvals` AS `AmendmentApproval` WHERE `AmendmentApproval`.`application_id` = (14)	0	0	0
SELECT `AmendmentApprovalSummary`.`id`, `AmendmentApprovalSummary`.`application_id`, `AmendmentApprovalSummary`.`approval_no`, `AmendmentApprovalSummary`.`amendment`, `AmendmentApprovalSummary`.`content`, `AmendmentApprovalSummary`.`approver`, `AmendmentApprovalSummary`.`approval_date`, `AmendmentApprovalSummary`.`status`, `AmendmentApprovalSummary`.`deleted`, `AmendmentApprovalSummary`.`deleted_date`, `AmendmentApprovalSummary`.`created`, `AmendmentApprovalSummary`.`modified` FROM `ctr`.`amendment_approvals` AS `AmendmentApprovalSummary` WHERE `AmendmentApprovalSummary`.`status` = 'summary' AND `AmendmentApprovalSummary`.`application_id` = (14)	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` = (14)	1	1	0
SELECT `SiteDetail`.`id`, `SiteDetail`.`application_id`, `SiteDetail`.`county_id`, `SiteDetail`.`site_name`, `SiteDetail`.`physical_address`, `SiteDetail`.`contact_details`, `SiteDetail`.`contact_person`, `SiteDetail`.`site_capacity`, `SiteDetail`.`misc`, `SiteDetail`.`created`, `SiteDetail`.`modified` FROM `ctr`.`site_details` AS `SiteDetail` WHERE `SiteDetail`.`application_id` = (14)	1	1	1
SELECT `Placebo`.`id`, `Placebo`.`application_id`, `Placebo`.`placebo_present`, `Placebo`.`pharmaceutical_form`, `Placebo`.`route_of_administration`, `Placebo`.`composition`, `Placebo`.`identical_indp`, `Placebo`.`major_ingredients`, `Placebo`.`created`, `Placebo`.`modified` FROM `ctr`.`placebos` AS `Placebo` WHERE `Placebo`.`application_id` = (14)	1	1	0
SELECT `Sponsor`.`id`, `Sponsor`.`application_id`, `Sponsor`.`sponsor`, `Sponsor`.`sponsor_type`, `Sponsor`.`contact_person`, `Sponsor`.`address`, `Sponsor`.`telephone_number`, `Sponsor`.`fax_number`, `Sponsor`.`cell_number`, `Sponsor`.`email_address`, `Sponsor`.`created`, `Sponsor`.`modified` FROM `ctr`.`sponsors` AS `Sponsor` WHERE `Sponsor`.`application_id` = (14)	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` = (14)	5	5	1	maybe slow
SELECT `Sae`.`id`, `Sae`.`application_id`, `Sae`.`sae_id`, `Sae`.`reference_no`, `Sae`.`form_type`, `Sae`.`user_id`, `Sae`.`patient_initials`, `Sae`.`country_id`, `Sae`.`date_of_birth`, `Sae`.`age_years`, `Sae`.`gender`, `Sae`.`causality`, `Sae`.`enrollment_date`, `Sae`.`administration_date`, `Sae`.`latest_date`, `Sae`.`reaction_onset`, `Sae`.`reaction_end_date`, `Sae`.`patient_died`, `Sae`.`prolonged_hospitalization`, `Sae`.`incapacity`, `Sae`.`life_threatening`, `Sae`.`reaction_other`, `Sae`.`reaction_description`, `Sae`.`relevant_history`, `Sae`.`manufacturer_name`, `Sae`.`mfr_no`, `Sae`.`manufacturer_date`, `Sae`.`source_study`, `Sae`.`source_literature`, `Sae`.`source_health_professional`, `Sae`.`report_date`, `Sae`.`report_type`, `Sae`.`approved`, `Sae`.`date_submitted`, `Sae`.`approved_by`, `Sae`.`email_address`, `Sae`.`reporter_name`, `Sae`.`reporter_phone`, `Sae`.`reporter_email`, `Sae`.`deleted`, `Sae`.`deleted_date`, `Sae`.`created`, `Sae`.`modified` FROM `ctr`.`saes` AS `Sae` WHERE `Sae`.`application_id` = (14)	0	0	0
SELECT `Ciom`.`id`, `Ciom`.`application_id`, `Ciom`.`reference_no`, `Ciom`.`user_id`, `Ciom`.`reporter_email`, `Ciom`.`e2b_content`, `Ciom`.`e2b_file`, `Ciom`.`file`, `Ciom`.`dirname`, `Ciom`.`basename`, `Ciom`.`checksum`, `Ciom`.`alternative`, `Ciom`.`group`, `Ciom`.`description`, `Ciom`.`created`, `Ciom`.`modified` FROM `ctr`.`cioms` AS `Ciom` WHERE `Ciom`.`application_id` = (14)	0	0	0
SELECT `StudyRoute`.`id`, `StudyRoute`.`application_id`, `StudyRoute`.`study_route`, `StudyRoute`.`created`, `StudyRoute`.`modified` FROM `ctr`.`study_routes` AS `StudyRoute` WHERE `StudyRoute`.`application_id` = (14)	1	1	0
SELECT `Manufacturer`.`id`, `Manufacturer`.`application_id`, `Manufacturer`.`manufacturer_name`, `Manufacturer`.`address`, `Manufacturer`.`manufacturer_country`, `Manufacturer`.`manufacturer_phone`, `Manufacturer`.`manufacturer_email`, `Manufacturer`.`manufacturing_activities`, `Manufacturer`.`other_specify`, `Manufacturer`.`created`, `Manufacturer`.`modified` FROM `ctr`.`manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`application_id` = (14)	1	1	0
SELECT `Reassignment`.`id`, `Reassignment`.`application_id`, `Reassignment`.`orig_user`, `Reassignment`.`new_user`, `Reassignment`.`assigning_user`, `Reassignment`.`created`, `Reassignment`.`modified` FROM `ctr`.`reassignments` AS `Reassignment` WHERE `Reassignment`.`application_id` = (14)	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`file`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`description`, `Attachment`.`year`, `Attachment`.`file_date`, `Attachment`.`pocket_name`, `Attachment`.`version_no`, `Attachment`.`created`, `Attachment`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Attachment__path` FROM `ctr`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Application' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (14)	4	4	2	maybe slow
SELECT `AnnualApproval`.`id`, `AnnualApproval`.`model`, `AnnualApproval`.`file`, `AnnualApproval`.`foreign_key`, `AnnualApproval`.`dirname`, `AnnualApproval`.`basename`, `AnnualApproval`.`checksum`, `AnnualApproval`.`alternative`, `AnnualApproval`.`group`, `AnnualApproval`.`description`, `AnnualApproval`.`year`, `AnnualApproval`.`file_date`, `AnnualApproval`.`pocket_name`, `AnnualApproval`.`version_no`, `AnnualApproval`.`created`, `AnnualApproval`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `AnnualApproval__path` FROM `ctr`.`attachments` AS `AnnualApproval` WHERE `AnnualApproval`.`model` = 'AnnualApproval' AND `AnnualApproval`.`foreign_key` = (14)	0	0	2	maybe slow
SELECT `AmendmentChecklist`.`id`, `AmendmentChecklist`.`model`, `AmendmentChecklist`.`file`, `AmendmentChecklist`.`foreign_key`, `AmendmentChecklist`.`dirname`, `AmendmentChecklist`.`basename`, `AmendmentChecklist`.`checksum`, `AmendmentChecklist`.`alternative`, `AmendmentChecklist`.`group`, `AmendmentChecklist`.`description`, `AmendmentChecklist`.`year`, `AmendmentChecklist`.`file_date`, `AmendmentChecklist`.`pocket_name`, `AmendmentChecklist`.`version_no`, `AmendmentChecklist`.`created`, `AmendmentChecklist`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `AmendmentChecklist__path` FROM `ctr`.`attachments` AS `AmendmentChecklist` WHERE `AmendmentChecklist`.`model` = 'AmendmentChecklist' AND `AmendmentChecklist`.`foreign_key` = (14)	0	0	2	maybe slow
SELECT `Reminder`.`id`, `Reminder`.`foreign_key`, `Reminder`.`model`, `Reminder`.`user_id`, `Reminder`.`reminder_type`, `Reminder`.`created`, `Reminder`.`modified` FROM `ctr`.`reminders` AS `Reminder` WHERE `Reminder`.`model` = 'Application' AND `Reminder`.`foreign_key` = (14)	0	0	0
SELECT `ParticipantFlow`.`id`, `ParticipantFlow`.`application_id`, `ParticipantFlow`.`year`, `ParticipantFlow`.`original_subjects`, `ParticipantFlow`.`consented`, `ParticipantFlow`.`screened`, `ParticipantFlow`.`enrolled`, `ParticipantFlow`.`lost`, `ParticipantFlow`.`lost_reason`, `ParticipantFlow`.`withdrawn`, `ParticipantFlow`.`withdrawal_reason`, `ParticipantFlow`.`self_withdrawal`, `ParticipantFlow`.`self_withdrawal_reasons`, `ParticipantFlow`.`active_subjects`, `ParticipantFlow`.`completed_number`, `ParticipantFlow`.`created`, `ParticipantFlow`.`modified` FROM `ctr`.`participant_flows` AS `ParticipantFlow` WHERE `ParticipantFlow`.`application_id` = (14)	0	0	0
SELECT `Budget`.`id`, `Budget`.`application_id`, `Budget`.`year`, `Budget`.`budget_period`, `Budget`.`personnel_currency`, `Budget`.`personnel`, `Budget`.`transport_currency`, `Budget`.`transport`, `Budget`.`field_currency`, `Budget`.`field`, `Budget`.`supplies_currency`, `Budget`.`supplies`, `Budget`.`pharmacy_currency`, `Budget`.`pharmacy`, `Budget`.`travel_currency`, `Budget`.`travel`, `Budget`.`regulatory_currency`, `Budget`.`regulatory`, `Budget`.`it_currency`, `Budget`.`it`, `Budget`.`lab_currency`, `Budget`.`lab`, `Budget`.`others_currency`, `Budget`.`others`, `Budget`.`kemri_currency`, `Budget`.`kemri`, `Budget`.`wrair_currency`, `Budget`.`wrair`, `Budget`.`subject_currency`, `Budget`.`subject`, `Budget`.`grand_currency`, `Budget`.`grand_total`, `Budget`.`study_information`, `Budget`.`personnel_kshs`, `Budget`.`transport_kshs`, `Budget`.`field_kshs`, `Budget`.`supplies_kshs`, `Budget`.`pharmacy_kshs`, `Budget`.`travel_kshs`, `Budget`.`regulatory_kshs`, `Budget`.`it_kshs`, `Budget`.`lab_kshs`, `Budget`.`others_kshs`, `Budget`.`grand_total_kshs`, `Budget`.`subject_kshs`, `Budget`.`created`, `Budget`.`modified` FROM `ctr`.`budgets` AS `Budget` WHERE `Budget`.`application_id` = (14)	1	1	0
SELECT `Deviation`.`id`, `Deviation`.`application_id`, `Deviation`.`user_id`, `Deviation`.`reference_no`, `Deviation`.`study_title`, `Deviation`.`deviation_type`, `Deviation`.`deviation_type_dev`, `Deviation`.`pi_name`, `Deviation`.`deviation_date`, `Deviation`.`participant_number`, `Deviation`.`treating_physician`, `Deviation`.`deviation_description`, `Deviation`.`deviation_explanation`, `Deviation`.`deviation_measures`, `Deviation`.`deviation_preclude`, `Deviation`.`sponsor_notified`, `Deviation`.`sponsor_explanation`, `Deviation`.`study_impact`, `Deviation`.`status`, `Deviation`.`deleted`, `Deviation`.`deleted_date`, `Deviation`.`created`, `Deviation`.`modified` FROM `ctr`.`deviations` AS `Deviation` WHERE `Deviation`.`application_id` = (14)	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`file`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`description`, `Document`.`year`, `Document`.`file_date`, `Document`.`pocket_name`, `Document`.`version_no`, `Document`.`created`, `Document`.`modified`, (CONCAT_WS('/', dirname, basename)) AS `Document__path` FROM `ctr`.`attachments` AS `Document` WHERE `Document`.`model` = 'Application' AND `Document`.`group` = 'document' AND `Document`.`foreign_key` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	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` = (14)	0	0	0
SELECT `Outsource`.`id`, `Outsource`.`application_id`, `Outsource`.`user_id`, `Outsource`.`model`, `Outsource`.`username`, `Outsource`.`name`, `Outsource`.`email`, `Outsource`.`phone_no`, `Outsource`.`institution_physical`, `Outsource`.`name_of_institution`, `Outsource`.`institution_address`, `Outsource`.`institution_contact`, `Outsource`.`county_id`, `Outsource`.`country_id`, `Outsource`.`approved`, `Outsource`.`created`, `Outsource`.`modified`, `Outsource`.`accepted`, `Outsource`.`model_sae`, `Outsource`.`model_ciom`, `Outsource`.`model_dev` FROM `ctr`.`outsources` AS `Outsource` WHERE `Outsource`.`application_id` = (14)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 19.44 MB

Message	Memory use
Component initialization	2.40 MB
Controller action start	3.58 MB
Controller render start	8.05 MB
View render complete	8.49 MB

Timers

Total Request Time: 211 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	10.76
Event: Controller.initialize	0.26
Event: Controller.startup	0.42
Controller action	90.87
Event: Controller.beforeRender	45.00
» Processing toolbar data	44.90
Rendering View	2.71
» Event: View.beforeRender	0.03
» Rendering APP/View/Applications/view.ctp	0.39
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.94
» » Rendering APP/View/Elements/google-analytics.ctp	0.05
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- application(array)
 Application(array)
 id14
 user_id26
 application_id(null)
 is_child0
 trial_status_id(null)
 total_sites(null)
 abstract_of_study Test Abstract
 study_title Test
 laymans_summary Layman's summary of the Test Protocol
 short_titleTest Protocol
 protocol_noECCT/24/04/01
 reference_no(null)
 version_no1.0.0
 date_of_protocol01-04-2024
 study_drugTest Protocol Drug
 disease_conditionTest Disease
 product_type_biologicals1
 product_type_proteins1
 product_type_immunologicals0
 product_type_vaccines0
 product_type_hormones0
 product_type_toxoid0
 product_type_chemical0
 product_type_medical_device0
 product_type_chemical_name
 product_type_medical_device_name
 comparatorYes
 comparator_name
 comparator_registered
 comparator_countries
 ecct_not_applicable0
 ecct_ref_number
 email_addressjayoma@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_applicant+2541190291827
 declaration_date109-04-2024
 declaration_principal_investigatorJavan
 declaration_date202-04-2024
 placebo_presentNo
 study_objectives Test objective
 principal_inclusion_criteria Test Inclusion criteria
 principal_exclusion_criteria Test exclusion criteria
 primary_end_points Primary endpoints
 scope_diagnosis0
 scope_prophylaxis0
 scope_therapy1
 scope_safety0
 scope_efficacy0
 scope_pharmacokinetic0
 scope_pharmacodynamic0
 scope_bioequivalence1
 scope_dose_response0
 scope_pharmacogenetic0
 scope_pharmacogenomic0
 scope_pharmacoecomomic0
 scope_others0
 scope_others_specify
 trial_human_pharmacology1
 trial_administration_humans1
 trial_bioequivalence_study0
 trial_other0
 trial_other_specify
 trial_therapeutic_exploratory1
 trial_therapeutic_confirmatory1
 trial_therapeutic_use0
 design_controlledNo
 site_capacity(null)
 staff_numbers Test people
 other_details_explanation test reason
 other_details_regulatory_notapproved test regulatory
 other_details_regulatory_approved test reg
 other_details_regulatory_rejected
 other_details_regulatory_halted
 estimated_duration2 months
 design_controlled_randomised
 design_controlled_open
 design_controlled_single_blind
 design_controlled_double_blind
 design_controlled_parallel_group
 design_controlled_cross_over
 design_controlled_other
 design_controlled_specify
 design_controlled_comparator
 design_controlled_other_medicinal
 design_controlled_placebo
 design_controlled_medicinal_other
 design_controlled_medicinal_specify
 single_site_member_stateYes
 location_of_areaMrcuty Test Site
 single_site_physical_address67
 single_site_contact_personContact Person
 single_site_telephone+25478019287
 multiple_sites_member_stateNo
 multiple_countriesYes
 multiple_member_states40
 number_of_sites
 multi_country_listtest
 data_monitoring_committeeYes
 total_enrolment_per_site200
 total_participants_worldwide20000000
 population_less_than_18_yearsNo
 population_uteroNo
 population_preterm_newbornNo
 population_newbornNo
 population_infant_and_toddlerNo
 population_childrenNo
 population_adolescentNo
 population_above_18Yes
 population_adultYes
 population_elderlyYes
 gender_female1
 gender_male1
 subjects_healthyYes
 subjects_patientsYes
 subjects_vulnerable_populationsYes
 subjects_women_child_bearingYes
 subjects_women_using_contraceptionYes
 subjects_pregnant_womenYes
 subjects_nursing_womenYes
 subjects_emergency_situationYes
 subjects_incapable_consentNo
 subjects_specify
 subjects_othersNo
 subjects_others_specify
 investigator1_given_nameGiven Investigator Name
 investigator1_middle_name
 investigator1_family_nameFamily Name
 investigator1_qualificationBsc. Medicine
 investigator1_professional_addressProfessional Address
 investigator1_telephone+25470192846
 investigator1_emailfamilyname@yahoo.com
 organisations_transferred_No
 number_participants2000
 notification
 approval_date17-10-2024
 submitted1
 deleted0
 deleted_date(null)
 deactivated0
 date_submitted09-04-2024
 unsubmitted0
 initial_date_submitted(null)
 admin_stopped0
 admin_stopped_reason(null)
 approved2
 approved_reasonProceed
 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_invoice301246
 modified2024-10-17 10:41:16
 created2024-04-09 08:38:17
 User(array)
 id26
 usernamejavan
 passwordee68d9627812445cb0ccfd02e319d77ad0f9f4c9
 confirm_passwordee68d9627812445cb0ccfd02e319d77ad0f9f4c9
 nameJavan
 emailjayoma@intellisoftkenya.com
 national_id_number89019283
 sponsor(null)
 sponsor_emailjayoma@intellisoftkenya.com
 qualificationtest
 phone_no+254702674563
 name_of_institutiontest
 institution_physicaltest street
 institution_addresstest address
 institution_contacttest contacts
 county_id47
 country_id115
 group_id5
 activation_key
 forgot_password(null)
 is_active1
 deactivated0
 created2024-01-17 15:58:25
 modified2024-05-21 07:37:41
 TrialStatus(array)
 id(null)
 value(null)
 name(null)
 created(null)
 modified(null)
 Review(empty)
 ActiveInspector(array)
 0(array)
 id10
 user_id33
 application_id14
 typerequest
 assessment_type(null)
 titlePPB request
 text
 summary(null)
 recommendation
 notified0
 acceptedaccepted
 conflictNo
 statusUnsubmitted
 created2024-04-11 08:19:04
 modified2024-04-11 08:19:04
 ManagerReview(empty)
 Acceptance(empty)
 Amendment(array)
 0(array)
 id8
 application_id14
 trial_status_id(null)
 abstract_of_study test
 study_title Layman summary for aammendments
 laymans_summarytest layman
 protocol_no(null)
 version_no2.0
 date_of_protocol21-05-2024
 study_drugStudy Drug
 disease_condition
 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
 principal_investigators
 pharmacist
 sponsor_details
 gender
 details_of_sites
 placebos
 scopes
 organizations
 types_and_phases
 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
 declaration_date1(null)
 declaration_principal_investigator
 declaration_date2(null)
 placebo_present
 study_objectives
 principal_inclusion_criteria
 principal_exclusion_criteria
 primary_end_points
 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
 site_capacity(null)
 staff_numbers
 other_details_explanation
 other_details_regulatory_notapproved
 other_details_regulatory_approved
 other_details_regulatory_rejected
 other_details_regulatory_halted
 estimated_duration
 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_state
 location_of_area
 multiple_sites_member_state
 multiple_countries
 multiple_member_states
 number_of_sites
 multi_country_list
 data_monitoring_committee
 total_enrolment_per_site
 total_participants_worldwide
 population_less_than_18_years
 population_utero
 population_preterm_newborn
 population_newborn
 population_infant_and_toddler
 population_children
 population_adolescent
 population_above_18
 population_adult
 population_elderly
 gender_female(null)
 gender_male(null)
 subjects_healthy
 subjects_patients
 subjects_vulnerable_populations
 subjects_women_child_bearing
 subjects_women_using_contraception
 subjects_pregnant_women
 subjects_nursing_women
 subjects_emergency_situation
 subjects_incapable_consent
 subjects_specify
 subjects_others
 subjects_others_specify
 investigator1_given_name(null)
 investigator1_middle_name(null)
 investigator1_family_name(null)
 investigator1_qualification(null)
 investigator1_professional_address(null)
 organisations_transferred_(null)
 number_participants
 notification
 approval_date(null)
 submitted1
 date_submitted2024-05-21 07:43:01
 modified2024-05-21 07:43:01
 created2024-05-21 07:41:33
 1(array)
 id9
 application_id14
 trial_status_id(null)
 abstract_of_study
 study_title
 laymans_summary
 protocol_no(null)
 version_no
 date_of_protocol(null)
 study_drug
 disease_condition
 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
 principal_investigators
 pharmacist
 sponsor_details
 gender
 details_of_sites
 placebos
 scopes
 organizations
 types_and_phases
 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
 declaration_date1(null)
 declaration_principal_investigator
 declaration_date2(null)
 placebo_present
 study_objectives
 principal_inclusion_criteria
 principal_exclusion_criteria
 primary_end_points
 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
 site_capacity(null)
 staff_numbers
 other_details_explanation
 other_details_regulatory_notapproved
 other_details_regulatory_approved
 other_details_regulatory_rejected
 other_details_regulatory_halted
 estimated_duration
 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_state
 location_of_area
 multiple_sites_member_state
 multiple_countries
 multiple_member_states
 number_of_sites
 multi_country_list
 data_monitoring_committee
 total_enrolment_per_site
 total_participants_worldwide
 population_less_than_18_years
 population_utero
 population_preterm_newborn
 population_newborn
 population_infant_and_toddler
 population_children
 population_adolescent
 population_above_18
 population_adult
 population_elderly
 gender_female(null)
 gender_male(null)
 subjects_healthy
 subjects_patients
 subjects_vulnerable_populations
 subjects_women_child_bearing
 subjects_women_using_contraception
 subjects_pregnant_women
 subjects_nursing_women
 subjects_emergency_situation
 subjects_incapable_consent
 subjects_specify
 subjects_others
 subjects_others_specify
 investigator1_given_name(null)
 investigator1_middle_name(null)
 investigator1_family_name(null)
 investigator1_qualification(null)
 investigator1_professional_address(null)
 organisations_transferred_(null)
 number_participants
 notification
 approval_date(null)
 submitted1
 date_submitted2024-05-21 08:08:46
 modified2024-05-21 08:08:46
 created2024-05-21 08:02:10
 InvestigatorContact(array)
 0(array)
 id11
 application_id14
 given_nameJavan
 middle_name
 family_nameTest
 qualificationMsc Medicine
 professional_addressTets Professional Address
 telephone+2547910292871
 emailjavan@gmail.com
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 ApplicationStage(array)
 0(array)
 id106
 application_id14
 stageScreening
 start_date2024-04-09
 statusComplete
 commentManager assign reviewer
 end_date2024-04-09
 created2024-04-09 09:34:57
 modified2024-04-09 09:34:57
 1(array)
 id107
 application_id14
 stageScreeningSubmission
 start_date2024-04-09
 statusComplete
 commentFrom Manager assign
 end_date2024-04-09
 created2024-04-09 09:41:52
 modified2024-04-09 09:41:52
 2(array)
 id108
 application_id14
 stageAssign
 start_date2024-04-09
 statusComplete
 commentReviewer accept
 end_date2024-04-09
 created2024-04-09 09:41:52
 modified2024-04-09 09:41:52
 3(array)
 id109
 application_id14
 stageReview
 start_date2024-04-09
 statusComplete
 commentManager final decision
 end_date2024-05-21
 created2024-04-09 09:45:31
 modified2024-04-09 09:45:31
 4(array)
 id110
 application_id14
 stageReviewSubmission
 start_date2024-05-21
 statusComplete
 commentManager final decision
 end_date2024-05-21
 created2024-05-21 17:11:55
 modified2024-05-21 17:11:55
 5(array)
 id111
 application_id14
 stageFinalDecision
 start_date2024-05-21
 statusComplete
 commentManager final decision
 end_date2024-05-21
 created2024-05-21 17:11:55
 modified2024-05-21 17:11:55
 6(array)
 id112
 application_id14
 stageAnnualApproval
 start_date2024-05-21
 statusCurrent
 commentManager approve
 end_date2025-05-21
 created2024-05-21 17:11:55
 modified2024-05-21 17:11:55
 Pharmacist(array)
 0(array)
 id11
 application_id14
 reg_no19029
 given_nameTest Pharmacist
 premise_name
 qualificationDiploma
 professional_addressPhysical Address
 valid_year2024
 mobile
 telephone
 emailpharamcist@gmail.com
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 EthicalCommittee(array)
 0(array)
 id12
 application_id14
 ethical_committeeThe Nairobi Hospital
 submission_date01-04-2024
 erc_numberREF/01928/21
 initial_approval02-04-2024
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 AnnualLetter(empty)
 AmendmentLetter(empty)
 AmendmentApproval(empty)
 AmendmentApprovalSummary(empty)
 Organization(array)
 0(array)
 id11
 application_id14
 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-04-09 08:47:06
 modified2024-04-09 09:34:57
 SiteDetail(array)
 0(array)
 id1657
 application_id14
 county_id(null)
 site_name
 physical_address
 contact_details
 contact_person
 site_capacity(null)
 misc(null)
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 Placebo(array)
 0(array)
 id11
 application_id14
 placebo_present(null)
 pharmaceutical_form
 route_of_administration
 composition
 identical_indp
 major_ingredients
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 Sponsor(array)
 0(array)
 id10
 application_id14
 sponsorSponsor
 sponsor_typeIndustry
 contact_person
 addressAddress
 telephone_number+254790192873
 fax_number
 cell_number+254718290192
 email_addressemail@ac.ke
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 SiteInspection(array)
 0(array)
 id39
 application_id14
 user_id2
 reference_noSI/2024/32
 study_title Test
 protocol_noECCT/24/04/01
 version_no(null)
 pactr_number(null)
 trial_phaseHuman pharmacology (Phase I) : First administration to humans Therapeutic exploratory (Phase II) Therapeutic confirmatory (Phase III)
 investigatorsGiven Investigator Name Family Name Tel: +25470192846 Email: familyname@yahoo.com
 co_investigators1 Javan Test Email: javan@gmail.com
 study_stage(null)
 inspection_countryKenya test
 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-04-11 08:19:06
 modified2024-04-11 08:19:06
 1(array)
 id43
 application_id14
 user_id2
 reference_noSI/2024/36
 study_title Test
 protocol_noECCT/24/04/01
 version_no(null)
 pactr_number(null)
 trial_phaseHuman pharmacology (Phase I) : First administration to humans Therapeutic exploratory (Phase II) Therapeutic confirmatory (Phase III)
 investigatorsGiven Investigator Name Family Name Tel: +25470192846 Email: familyname@yahoo.com
 co_investigators1 Javan Test Email: javan@gmail.com
 study_stage(null)
 inspection_countryKenya test
 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-05-21 11:21:48
 modified2024-05-21 11:21:48
 2(array)
 id44
 application_id14
 user_id2
 reference_noSI/2024/37
 study_title Test
 protocol_noECCT/24/04/01
 version_no(null)
 pactr_number(null)
 trial_phaseHuman pharmacology (Phase I) : First administration to humans Therapeutic exploratory (Phase II) Therapeutic confirmatory (Phase III)
 investigatorsGiven Investigator Name Family Name Tel: +25470192846 Email: familyname@yahoo.com
 co_investigators1 Javan Test Email: javan@gmail.com
 study_stage(null)
 inspection_countryKenya test
 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-05-21 11:21:53
 modified2024-05-21 11:21:53
 3(array)
 id47
 application_id14
 user_id2
 reference_noSI/2024/40
 study_title Test
 protocol_noECCT/24/04/01
 version_no(null)
 pactr_number(null)
 trial_phaseHuman pharmacology (Phase I) : First administration to humans Therapeutic exploratory (Phase II) Therapeutic confirmatory (Phase III)
 investigatorsGiven Investigator Name Family Name Tel: +25470192846 Email: familyname@yahoo.com
 co_investigators1 Javan Test Email: javan@gmail.com
 study_stage(null)
 inspection_countryKenya test
 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-05-23 14:04:37
 modified2024-05-23 14:04:37
 4(array)
 id53
 application_id14
 user_id33
 reference_noSI/2024/46
 study_title Test
 protocol_noECCT/24/04/01
 version_no(null)
 pactr_number657
 trial_phaseQuidem non quam inventore eum dolor dolor sit aliquid
 investigatorsSed architecto qui a
 co_investigatorsEveniet laudantium
 study_stageAfter completion of trial
 inspection_countryNostrum sapiente omn
 inspector_namesRepellendus Suscipi
 inspection_datesNon eligendi volupta
 site_addressVeniam vel laudanti
 sponsor_addressConsequat Inventore
 lab_addressNisi veniam volupta
 events_summaryOmnis sit voluptate
 conclusionSite did not meet criteria!
 summary_report(null)
 outcomeFailed Inspection
 approved1
 summary_approved0
 approved_by(null)
 sent_to_pi0
 deleted0
 deleted_date(null)
 created2024-10-17 10:45:26
 modified2024-10-17 10:45:52
 Sae(empty)
 Ciom(empty)
 StudyRoute(array)
 0(array)
 id488
 application_id14
 study_routeendotracheal
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 Manufacturer(array)
 0(array)
 id11
 application_id14
 manufacturer_nameTest Manufacturer
 addressTest Manufacturer
 manufacturer_countryKenya
 manufacturer_phone
 manufacturer_emailtestmail@yahoo.com
 manufacturing_activitiesPartial manufacturing
 other_specify
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 Reassignment(empty)
 Attachment(array)
 0(array)
 id1114
 modelApplication
 file/var/www/ctr/app/webroot/media/transfer/img/logo_42.png
 foreign_key14
 dirnameimg
 basenamelogo_42.png
 checksumc0a119cbad26d41a09d41f4c87635f4e
 alternative(null)
 groupattachment
 descriptionsample1
 year(null)
 file_date(null)
 pocket_name(null)
 version_no(null)
 created2024-12-17 08:32:50
 modified2025-01-06 08:17:50
 pathimg/logo_42.png
 1(array)
 id1115
 modelApplication
 file/var/www/ctr/app/webroot/media/transfer/img/logo_43.png
 foreign_key14
 dirnameimg
 basenamelogo_43.png
 checksumc0a119cbad26d41a09d41f4c87635f4e
 alternative(null)
 groupattachment
 descriptionsample2
 year(null)
 file_date(null)
 pocket_name(null)
 version_no(null)
 created2024-12-17 08:32:56
 modified2025-01-06 08:17:50
 pathimg/logo_43.png
 2(array)
 id1116
 modelApplication
 file/var/www/ctr/app/webroot/media/transfer/img/logo_44.png
 foreign_key14
 dirnameimg
 basenamelogo_44.png
 checksumc0a119cbad26d41a09d41f4c87635f4e
 alternative(null)
 groupattachment
 descriptionsample3
 year(null)
 file_date(null)
 pocket_name(null)
 version_no(null)
 created2024-12-17 08:33:01
 modified2025-01-06 08:17:50
 pathimg/logo_44.png
 3(array)
 id1117
 modelApplication
 file/var/www/ctr/app/webroot/media/transfer/img/logo_45.png
 foreign_key14
 dirnameimg
 basenamelogo_45.png
 checksumc0a119cbad26d41a09d41f4c87635f4e
 alternative(null)
 groupattachment
 descriptionsample4
 year(null)
 file_date(null)
 pocket_name(null)
 version_no(null)
 created2024-12-17 08:33:05
 modified2025-01-06 08:17:50
 pathimg/logo_45.png
 AnnualApproval(empty)
 AmendmentChecklist(empty)
 Reminder(empty)
 ParticipantFlow(empty)
 Budget(array)
 0(array)
 id11
 application_id14
 year(null)
 budget_period(null)
 personnel_currencyUSD
 personnel1000
 transport_currencyUSD
 transport1000
 field_currencyUSD
 field1000
 supplies_currencyUSD
 supplies1000
 pharmacy_currencyUSD
 pharmacy1000
 travel_currencyUSD
 travel1000
 regulatory_currencyUSD
 regulatory1000
 it_currencyUSD
 it1000
 lab_currency(null)
 lab(null)
 others_currencyUSD
 others1000
 kemri_currency(null)
 kemri(null)
 wrair_currency(null)
 wrair(null)
 subject_currencyUSD
 subject1000
 grand_currencyUSD
 grand_total1000
 study_information
 personnel_kshs1000
 transport_kshs1000
 field_kshs1000
 supplies_kshs1000
 pharmacy_kshs1000
 travel_kshs1000
 regulatory_kshs1000
 it_kshs1000
 lab_kshs(null)
 others_kshs1000
 grand_total_kshs1000
 subject_kshs1000
 created2024-04-09 08:47:06
 modified2024-04-09 09:34:57
 Deviation(empty)
 Document(empty)
 CoverLetter(empty)
 Protocol(empty)
 PatientLeaflet(empty)
 Brochure(empty)
 GmpCertificate(empty)
 Cv(empty)
 Finance(empty)
 Declaration(empty)
 IndemnityCover(empty)
 OpinionLetter(empty)
 ApprovalLetter(empty)
 Statement(empty)
 ParticipatingStudy(empty)
 Addendum(empty)
 Registration(empty)
 Fee(empty)
 Checklist(array)
 0(array)
 id500
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_covering_letter
 descriptionCover Letter (Should list all the submitted documents, their version numbers and dates) *
 year(null)
 file_date02-04-2024
 pocket_nameapplicant_covering_letter
 version_no1.0
 created2024-04-09 09:21:15
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122.pdf
 1(array)
 id501
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_protocol
 descriptionThe Study Protocol *
 year(null)
 file_date02-04-2024
 pocket_nameapplicant_protocol
 version_no2.0
 created2024-04-09 09:21:45
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1.pdf
 2(array)
 id502
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_2.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_2.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_pan_african
 descriptionRegistration of the study at Pan African Clinical Trials Registry https://pactr.samrc.ac.za *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_pan_african
 version_no3.1
 created2024-04-09 09:22:04
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_2.pdf
 3(array)
 id503
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_3.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_3.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_patient_information
 descriptionPatient Information leaflet and Informed consent form *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_patient_information
 version_no2.1
 created2024-04-09 09:22:25
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_3.pdf
 4(array)
 id504
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_4.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_4.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_investigators_brochure
 descriptionInvestigators Brochure/Package inserts *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_investigators_brochure
 version_no2.1
 created2024-04-09 09:22:43
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_4.pdf
 5(array)
 id505
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_5.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_5.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_impd
 descriptionInvestigational Medicinal Product Dossier (IMPD) *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_impd
 version_no4.2
 created2024-04-09 09:23:02
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_5.pdf
 6(array)
 id506
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_2.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_2.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_prev_data
 descriptionAdequate data and information from previous studies and Phases to support carrying out of the current study *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_prev_data
 version_no2.1
 created2024-04-09 09:23:22
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_2.pdf
 7(array)
 id507
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_3.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_3.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_stability_data
 descriptionStability data of the investigational product *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_stability_data
 version_no3.2
 created2024-04-09 09:23:43
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_3.pdf
 8(array)
 id508
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_4.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_4.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_gmp_certificate
 descriptionGMP certificate of the investigational product from the site of manufacture *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_gmp_certificate
 version_no4.2
 created2024-04-09 09:24:04
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_4.pdf
 9(array)
 id509
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_5.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_5.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_analysis_cert
 descriptionCertificate of Analysis of the investigational product *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_analysis_cert
 version_no4.1
 created2024-04-09 09:24:21
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_5.pdf
 10(array)
 id510
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_6.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_6.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 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_date02-04-2024
 pocket_nameapplicant_pictorial_sample
 version_no2.1
 created2024-04-09 09:24:40
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_6.pdf
 11(array)
 id511
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_6.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_6.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_investigators_cv
 descriptionSigned investigator(s) CV(s) including that of study Pharmacist (NB: The CV should include the current workload of the Principal Investigator ) *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_investigators_cv
 version_no2.2
 created2024-04-09 09:25:10
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_6.pdf
 12(array)
 id512
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_7.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_7.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_contractual_agreement
 descriptionEvidence of contractual agreement between sponsor and Principal Investigator. *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_contractual_agreement
 version_no2.1
 created2024-04-09 09:25:46
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_7.pdf
 13(array)
 id513
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_8.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_8.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_gcp_training
 descriptionEvidence of recent GCP training of the core study staff *
 year(null)
 file_date03-04-2024
 pocket_nameapplicant_gcp_training
 version_no2.5
 created2024-04-09 09:26:04
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_8.pdf
 14(array)
 id514
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_7.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_7.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupstatistical_analysis_plan
 descriptionStatistical Analysis Plan *
 year(null)
 file_date02-04-2024
 pocket_namestatistical_analysis_plan
 version_no2.3
 created2024-04-09 09:27:27
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_7.pdf
 15(array)
 id515
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_9.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_9.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_fees
 descriptionPayment of fees *
 year(null)
 file_date02-04-2024
 pocket_nameapplicant_fees
 version_no2.56
 created2024-04-09 09:27:45
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_9.pdf
 16(array)
 id516
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_10.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_10.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 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_date03-04-2024
 pocket_nameapplicant_statement
 version_no2.3
 created2024-04-09 09:28:07
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_10.pdf
 17(array)
 id517
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_8.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_8.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_dsmb_charter
 descriptionDSMB Charter including the composition and meeting schedule *
 year(null)
 file_date08-04-2024
 pocket_nameapplicant_dsmb_charter
 version_no5.1
 created2024-04-09 09:30:42
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_8.pdf
 18(array)
 id518
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_11.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_11.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_detailed_budget
 descriptionDetailed budget of the study *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_detailed_budget
 version_no2.1
 created2024-04-09 09:30:58
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_11.pdf
 19(array)
 id519
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_12.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_12.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_financial_declaration
 descriptionFinancial declaration by Sponsor and/or PI *
 year(null)
 file_date08-04-2024
 pocket_nameapplicant_financial_declaration
 version_no2.0
 created2024-04-09 09:31:14
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_12.pdf
 20(array)
 id520
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_9.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_9.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_signed_declaration
 descriptionSigned Declaration by Sponsor or Principal investigator that the study will be carried out according to the protocol and applicable laws, regulations and GCP requirements. *
 year(null)
 file_date01-04-2024
 pocket_nameapplicant_signed_declaration
 version_no9.1
 created2024-04-09 09:31:36
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_9.pdf
 21(array)
 id521
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_10.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_10.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_indemnity_pi
 descriptionIndemnity cover for PI, investigators and study Pharmacist. *
 year(null)
 file_date08-04-2024
 pocket_nameapplicant_indemnity_pi
 version_no3.2
 created2024-04-09 09:31:50
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_10.pdf
 22(array)
 id522
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_13.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_13.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_indemnity_cover
 descriptionClinical Trials Insurance cover for study participants *
 year(null)
 file_date02-04-2024
 pocket_nameapplicant_indemnity_cover
 version_no3.1
 created2024-04-09 09:32:09
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_13.pdf
 23(array)
 id523
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_14.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_14.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_opinion_letter
 descriptionCopy of favorable opinion letter from the local Ethics Review Committee (ERC). *
 year(null)
 file_date03-04-2024
 pocket_nameapplicant_opinion_letter
 version_no3.1
 created2024-04-09 09:32:25
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_14.pdf
 24(array)
 id524
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_15.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_15.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_practice_license
 descriptionCopy of current Practice Licenses for the Investigators and study Pharmacist *
 year(null)
 file_date03-04-2024
 pocket_nameapplicant_practice_license
 version_no3.1
 created2024-04-09 09:32:40
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_15.pdf
 25(array)
 id525
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_11.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_11.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_approval_letter
 descriptionCopy of approval letter(s) from collaborating institutions or other regulatory authorities, if applicable
 year(null)
 file_date02-04-2024
 pocket_nameapplicant_approval_letter
 version_no4.5
 created2024-04-09 09:33:01
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_11.pdf
 26(array)
 id526
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/1_free_cisa_study_guide.pdf
 foreign_key14
 dirnamedoc
 basename1_free_cisa_study_guide.pdf
 checksum88f30993746876b3092310cc09efe02a
 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_date03-04-2024
 pocket_nameapplicant_addendum
 version_no7
 created2024-04-09 09:33:20
 modified2024-04-09 09:34:57
 pathdoc/1_free_cisa_study_guide.pdf
 27(array)
 id527
 modelChecklist
 file/var/www/ctr/app/webroot/media/transfer/doc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_12.pdf
 foreign_key14
 dirnamedoc
 basename01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_12.pdf
 checksuma654718fa9d2f4f7a7dce17070a1bcce
 alternative(null)
 groupapplicant_signed_checklist
 descriptionSigned Checklist *
 year(null)
 file_date02-04-2024
 pocket_nameapplicant_signed_checklist
 version_no2.0
 created2024-04-09 09:33:42
 modified2024-04-09 09:34:57
 pathdoc/01_asean_cybersecurity_cooperation_paper_2021_2025_final_23_0122_1_12.pdf
 StudyMonitor(empty)
 ProtocolOutsource(empty)
 Outsource(empty)
- redir
- $request->data(empty)
- $this->validationErrors(array)
 Permission(empty)
 Aro(empty)
 Aco(empty)
 Application(empty)
 User(empty)
 TrialStatus(empty)
 Review(empty)
 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/14'
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-5b5d847c96-qq957 (squid/6.10)'
Http X Forwarded For	'10.3.82.253'
Http Cache Control	'max-age=259200'
Http Connection	'keep-alive'
Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
Server Signature	' Apache/2.4.29 (Ubuntu) Server at 45.79.161.190 Port 8080 '
Server Software	'Apache/2.4.29 (Ubuntu)'
Server Name	'45.79.161.190'
Server Addr	'45.79.161.190'
Server Port	'8080'
Remote Addr	'216.73.216.36'
Document Root	'/var/www/ctr'
Request Scheme	'http'
Context Prefix	''
Context Document Root	'/var/www/ctr'
Server Admin	'webmaster@localhost'
Script Filename	'/var/www/ctr/app/webroot/index.php'
Remote Port	'55338'
Redirect Url	'/app/webroot/applications/view/14'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/applications/view/14'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1756471431.565
Request Time	(int) 1756471431

====

Include
+
Included Files

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

Study Title:	Test
	Layman summary for aammendments
Study Objectives:	Test objective
Laymans Summary:	Layman's summary of the Test Protocol
1	test layman
Abstract of Study:	Test Abstract
1	test

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 49 ms Total Queries: 53 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 49 ms
Total Queries: 53 queries