Pharmacy and Poisons Board: Applications

Protocol No.	Study Title	Principal Investigator(s)	Name of Site / County	Pages	Clear
Application Submission Dates-to- clear!

#	Protocol No	Study Title	Investigator(s) & Site(s)
21.	ECCT/25/07/01	Test Sample sample	Principal Investigator(s) 1. Kiprotich Keter Japheth Site(s) in Kenya sample sample	View
22.	ECCT/24/01/01	Short Title Sample Title	Principal Investigator(s) 1. some name principal some name principal some name principal Site(s) in Kenya 1.	View
23.	ECCT/24/12/01	Et eius sit aut et fugiat adi sample	Principal Investigator(s) 1. Lawrence Jennings Aladdin Powers Elton Delgado Site(s) in Kenya 1. Chastity Horne (Samburu county)	View
24.	ECCT/24/05/02	Esse incididunt officia vitae Some study title	Principal Investigator(s) 1. Tara Carr Eaton Guthrie Conan Greene Site(s) in Kenya 1. Kane Durham (Trans Nzoia county) 2. next (Busia county)	View
25.	ECCT/24/04/01	Test Protocol Test	Principal Investigator(s) 1. Javan Test Site(s) in Kenya Mrcuty Test Site	View

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

Cake Params
- plugin(null)
- controllerapplications
- actionindex
- named(array)
  page5
  sortstudy_title
  directionasc
- pass(empty)
- isAjax(false)
- paging(array)
  Application(array)
  page5
  current5
  count26
  prevPage(true)
  nextPage(true)
  pageCount6
  order(array)
  Application.study_titleasc
  limit5
  options(array)
  page5
  order(array)
  Application.study_titleasc
  sortstudy_title
  directionasc
  paramTypenamed
Post data
- Application(empty)
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: 7 ms
Total Queries: 9 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Application`.`id`, `Application`.`user_id`, `Application`.`application_id`, `Application`.`is_child`, `Application`.`trial_status_id`, `Application`.`total_sites`, `Application`.`abstract_of_study`, `Application`.`study_title`, `Application`.`laymans_summary`, `Application`.`short_title`, `Application`.`protocol_no`, `Application`.`reference_no`, `Application`.`version_no`, `Application`.`date_of_protocol`, `Application`.`study_drug`, `Application`.`disease_condition`, `Application`.`product_type_biologicals`, `Application`.`product_type_proteins`, `Application`.`product_type_immunologicals`, `Application`.`product_type_vaccines`, `Application`.`product_type_hormones`, `Application`.`product_type_toxoid`, `Application`.`product_type_chemical`, `Application`.`product_type_medical_device`, `Application`.`product_type_chemical_name`, `Application`.`product_type_medical_device_name`, `Application`.`comparator`, `Application`.`comparator_name`, `Application`.`comparator_registered`, `Application`.`comparator_countries`, `Application`.`ecct_not_applicable`, `Application`.`ecct_ref_number`, `Application`.`email_address`, `Application`.`applicant_covering_letter`, `Application`.`applicant_protocol`, `Application`.`applicant_patient_information`, `Application`.`applicant_investigators_brochure`, `Application`.`applicant_investigators_cv`, `Application`.`applicant_signed_declaration`, `Application`.`applicant_financial_declaration`, `Application`.`applicant_gmp_certificate`, `Application`.`applicant_indemnity_cover`, `Application`.`applicant_opinion_letter`, `Application`.`applicant_approval_letter`, `Application`.`applicant_statement`, `Application`.`applicant_participating_countries`, `Application`.`applicant_addendum`, `Application`.`applicant_fees`, `Application`.`applicant_complete_form`, `Application`.`applicant_impd`, `Application`.`applicant_prev_data`, `Application`.`applicant_stability_data`, `Application`.`applicant_analysis_cert`, `Application`.`applicant_pictorial_sample`, `Application`.`applicant_gcp_training`, `Application`.`applicant_dsmb_charter`, `Application`.`applicant_detailed_budget`, `Application`.`applicant_indemnity_pi`, `Application`.`applicant_practice_license`, `Application`.`applicant_registration_ctr`, `Application`.`applicant_pan_african`, `Application`.`applicant_hard_copies`, `Application`.`applicant_signed_checklist`, `Application`.`statistical_analysis_plan`, `Application`.`applicant_contractual_agreement`, `Application`.`declaration_applicant`, `Application`.`declaration_date1`, `Application`.`declaration_principal_investigator`, `Application`.`declaration_date2`, `Application`.`placebo_present`, `Application`.`study_objectives`, `Application`.`principal_inclusion_criteria`, `Application`.`principal_exclusion_criteria`, `Application`.`primary_end_points`, `Application`.`scope_diagnosis`, `Application`.`scope_prophylaxis`, `Application`.`scope_therapy`, `Application`.`scope_safety`, `Application`.`scope_efficacy`, `Application`.`scope_pharmacokinetic`, `Application`.`scope_pharmacodynamic`, `Application`.`scope_bioequivalence`, `Application`.`scope_dose_response`, `Application`.`scope_pharmacogenetic`, `Application`.`scope_pharmacogenomic`, `Application`.`scope_pharmacoecomomic`, `Application`.`scope_others`, `Application`.`scope_others_specify`, `Application`.`trial_human_pharmacology`, `Application`.`trial_administration_humans`, `Application`.`trial_bioequivalence_study`, `Application`.`trial_other`, `Application`.`trial_other_specify`, `Application`.`trial_therapeutic_exploratory`, `Application`.`trial_therapeutic_confirmatory`, `Application`.`trial_therapeutic_use`, `Application`.`design_controlled`, `Application`.`site_capacity`, `Application`.`staff_numbers`, `Application`.`other_details_explanation`, `Application`.`other_details_regulatory_notapproved`, `Application`.`other_details_regulatory_approved`, `Application`.`other_details_regulatory_rejected`, `Application`.`other_details_regulatory_halted`, `Application`.`estimated_duration`, `Application`.`design_controlled_randomised`, `Application`.`design_controlled_open`, `Application`.`design_controlled_single_blind`, `Application`.`design_controlled_double_blind`, `Application`.`design_controlled_parallel_group`, `Application`.`design_controlled_cross_over`, `Application`.`design_controlled_other`, `Application`.`design_controlled_specify`, `Application`.`design_controlled_comparator`, `Application`.`design_controlled_other_medicinal`, `Application`.`design_controlled_placebo`, `Application`.`design_controlled_medicinal_other`, `Application`.`design_controlled_medicinal_specify`, `Application`.`single_site_member_state`, `Application`.`location_of_area`, `Application`.`single_site_physical_address`, `Application`.`single_site_contact_person`, `Application`.`single_site_telephone`, `Application`.`multiple_sites_member_state`, `Application`.`multiple_countries`, `Application`.`multiple_member_states`, `Application`.`number_of_sites`, `Application`.`multi_country_list`, `Application`.`data_monitoring_committee`, `Application`.`total_enrolment_per_site`, `Application`.`total_participants_worldwide`, `Application`.`population_less_than_18_years`, `Application`.`population_utero`, `Application`.`population_preterm_newborn`, `Application`.`population_newborn`, `Application`.`population_infant_and_toddler`, `Application`.`population_children`, `Application`.`population_adolescent`, `Application`.`population_above_18`, `Application`.`population_adult`, `Application`.`population_elderly`, `Application`.`gender_female`, `Application`.`gender_male`, `Application`.`subjects_healthy`, `Application`.`subjects_patients`, `Application`.`subjects_vulnerable_populations`, `Application`.`subjects_women_child_bearing`, `Application`.`subjects_women_using_contraception`, `Application`.`subjects_pregnant_women`, `Application`.`subjects_nursing_women`, `Application`.`subjects_emergency_situation`, `Application`.`subjects_incapable_consent`, `Application`.`subjects_specify`, `Application`.`subjects_others`, `Application`.`subjects_others_specify`, `Application`.`investigator1_given_name`, `Application`.`investigator1_middle_name`, `Application`.`investigator1_family_name`, `Application`.`investigator1_qualification`, `Application`.`investigator1_professional_address`, `Application`.`investigator1_telephone`, `Application`.`investigator1_email`, `Application`.`organisations_transferred_`, `Application`.`number_participants`, `Application`.`notification`, `Application`.`approval_date`, `Application`.`submitted`, `Application`.`deleted`, `Application`.`deleted_date`, `Application`.`deactivated`, `Application`.`date_submitted`, `Application`.`unsubmitted`, `Application`.`initial_date_submitted`, `Application`.`admin_stopped`, `Application`.`admin_stopped_reason`, `Application`.`approved`, `Application`.`approved_reason`, `Application`.`approved_date`, `Application`.`final_report`, `Application`.`implication_results`, `Application`.`quantity_imported`, `Application`.`quantity_dispensed`, `Application`.`quantity_destroyed`, `Application`.`quantity_exported`, `Application`.`balance_site`, `Application`.`final_date`, `Application`.`ecitizen_invoice`, `Application`.`modified`, `Application`.`created`, `Application`.`ai_content` FROM `ctr`.`applications` AS `Application` WHERE `Application`.`submitted` = '1' AND `Application`.`approved` = 2 AND `Application`.`deactivated` = '0' AND `Application`.`deleted` = '0' ORDER BY `Application`.`study_title` asc LIMIT 20, 5	5	5	6	maybe slow
SELECT `InvestigatorContact`.`id`, `InvestigatorContact`.`application_id`, `InvestigatorContact`.`given_name`, `InvestigatorContact`.`middle_name`, `InvestigatorContact`.`family_name`, `InvestigatorContact`.`qualification`, `InvestigatorContact`.`professional_address`, `InvestigatorContact`.`telephone`, `InvestigatorContact`.`email`, `InvestigatorContact`.`investigator_role`, `InvestigatorContact`.`created`, `InvestigatorContact`.`modified` FROM `ctr`.`investigator_contacts` AS `InvestigatorContact` WHERE `InvestigatorContact`.`application_id` IN (231, 2, 125, 41, 14)	5	5	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` IN (231, 2, 125, 41, 14)	6	6	1	maybe slow
SELECT `County`.`id`, `County`.`county_name`, `County`.`created`, `County`.`modified` FROM `ctr`.`counties` AS `County` WHERE `County`.`id` = 26	1	1	0
SELECT `County`.`id`, `County`.`county_name`, `County`.`created`, `County`.`modified` FROM `ctr`.`counties` AS `County` WHERE `County`.`id` = 40	1	1	0
SELECT `County`.`id`, `County`.`county_name`, `County`.`created`, `County`.`modified` FROM `ctr`.`counties` AS `County` WHERE `County`.`id` = 25	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` IN (231, 2, 125, 41, 14)	5	5	0
SELECT COUNT(*) AS `count` FROM `ctr`.`applications` AS `Application` WHERE `Application`.`submitted` = '1' AND `Application`.`approved` = 2 AND `Application`.`deactivated` = '0' AND `Application`.`deleted` = '0'	1	1	0
SELECT `TrialStatus`.`id`, `TrialStatus`.`name` FROM `ctr`.`trial_statuses` AS `TrialStatus` WHERE 1 = 1	12	12	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 8.43 MB

Message	Memory use
Component initialization	2.41 MB
Controller action start	3.58 MB
Controller render start	4.46 MB
View render complete	4.95 MB

Timers

Total Request Time: 124 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	47.60
Event: Controller.initialize	1.50
Event: Controller.startup	0.85
Controller action	35.92
Event: Controller.beforeRender	13.04
» Processing toolbar data	12.92
Rendering View	8.97
» Event: View.beforeRender	0.03
» Rendering APP/View/Applications/index.ctp	0.21
» » Rendering APP/View/Elements/google-recommend.ctp	0.05
» Rendering APP/View/Elements/application/public_index.ctp	6.15
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	2.15
» » Rendering APP/View/Elements/google-analytics.ctp	0.06
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- trial_statuses(array)
 1Recruiting
 2Not yet recruiting
 3Suspended
 4Stopped
 5Completed
 6In follow-up
 7Analysing
 8Writing-up
 9Application withdrawn
 10Paused or preparation for extension of study
 11Revoked
 12Ongoing Closeout Phase
- applications(array)
 0(array)
 Application(array)
 id231
 user_id29
 application_id(null)
 is_child0
 trial_status_id6
 total_sites2
 abstract_of_study\n Sample\n
 study_title\n Sample sample\n
 laymans_summary\n test\n
 short_titleTest
 protocol_noECCT/25/07/01
 reference_no
 version_no3
 date_of_protocol11-07-2025
 study_drugSample
 disease_conditionSample
 product_type_biologicals1
 product_type_proteins0
 product_type_immunologicals1
 product_type_vaccines0
 product_type_hormones0
 product_type_toxoid0
 product_type_chemical1
 product_type_medical_device0
 product_type_chemical_namesample
 product_type_medical_device_name
 comparatorYes
 comparator_namesample
 comparator_registeredsample
 comparator_countriessample,sample
 ecct_not_applicable0
 ecct_ref_number
 email_addressjkiprotich@intellisoftkenya.com
 applicant_covering_letter1
 applicant_protocol1
 applicant_patient_information1
 applicant_investigators_brochure1
 applicant_investigators_cv1
 applicant_signed_declaration1
 applicant_financial_declaration1
 applicant_gmp_certificate1
 applicant_indemnity_cover1
 applicant_opinion_letter1
 applicant_approval_letter0
 applicant_statement1
 applicant_participating_countries(null)
 applicant_addendum0
 applicant_fees1
 applicant_complete_form(null)
 applicant_impd0
 applicant_prev_data0
 applicant_stability_data0
 applicant_analysis_cert0
 applicant_pictorial_sample0
 applicant_gcp_training0
 applicant_dsmb_charter0
 applicant_detailed_budget0
 applicant_indemnity_pi0
 applicant_practice_license0
 applicant_registration_ctr(null)
 applicant_pan_african1
 applicant_hard_copies(null)
 applicant_signed_checklist0
 statistical_analysis_plan0
 applicant_contractual_agreement0
 declaration_applicantsample sample
 declaration_date111-07-2025
 declaration_principal_investigatorSample Sample
 declaration_date211-07-2025
 placebo_presentNo
 study_objectives\n sample sample\n
 principal_inclusion_criteria\n saample\n
 principal_exclusion_criteria\n sample\n
 primary_end_points\n sample\n
 scope_diagnosis1
 scope_prophylaxis1
 scope_therapy0
 scope_safety0
 scope_efficacy0
 scope_pharmacokinetic0
 scope_pharmacodynamic0
 scope_bioequivalence0
 scope_dose_response0
 scope_pharmacogenetic0
 scope_pharmacogenomic0
 scope_pharmacoecomomic0
 scope_others0
 scope_others_specify
 trial_human_pharmacology1
 trial_administration_humans1
 trial_bioequivalence_study0
 trial_other0
 trial_other_specify
 trial_therapeutic_exploratory1
 trial_therapeutic_confirmatory0
 trial_therapeutic_use0
 design_controlledNo
 site_capacity(null)
 staff_numbers\n sample sample\n
 other_details_explanation\n sample sample\n
 other_details_regulatory_notapproved\n sample\n
 other_details_regulatory_approved\n sample\n
 other_details_regulatory_rejected\n sample\n
 other_details_regulatory_halted\n sample\n
 estimated_duration3
 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_areasample sample
 single_site_physical_addresssample sample
 single_site_contact_personsample
 single_site_telephone0733098232
 multiple_sites_member_stateNo
 multiple_countriesNo
 multiple_member_states
 number_of_sites
 multi_country_list
 data_monitoring_committeeNo
 total_enrolment_per_site40
 total_participants_worldwide40
 population_less_than_18_yearsYes
 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_healthyNo
 subjects_patientsNo
 subjects_vulnerable_populationsNo
 subjects_women_child_bearingNo
 subjects_women_using_contraceptionNo
 subjects_pregnant_womenNo
 subjects_nursing_womenNo
 subjects_emergency_situationNo
 subjects_incapable_consentNo
 subjects_specify
 subjects_othersNo
 subjects_others_specify
 investigator1_given_namesample sample
 investigator1_middle_namesample
 investigator1_family_namesample sample
 investigator1_qualificationsample
 investigator1_professional_addresssample
 investigator1_telephone0700543987
 investigator1_emailsample@gmail.com
 organisations_transferred_No
 number_participants30
 notification\n Sample docs\n
 approval_date30-09-2025
 submitted1
 deleted0
 deleted_date(null)
 deactivated0
 date_submitted11-07-2025
 unsubmitted0
 initial_date_submitted(null)
 admin_stopped0
 admin_stopped_reason(null)
 approved2
 approved_reasontest
 approved_date(null)
 final_report\n test\n
 implication_results\n test\n
 quantity_imported3
 quantity_dispensed3
 quantity_destroyed3
 quantity_exported3
 balance_site3
 final_date2025-09-30
 ecitizen_invoice363835
 modified2026-02-17 10:47:21
 created2025-03-27 12:53:06
 ai_content(null)
 InvestigatorContact(array)
 0(array)
 id146
 application_id231
 given_nameKiprotich
 middle_nameKeter
 family_nameJapheth
 qualificationNurse
 professional_addresssample
 telephone0724743789
 emailitsjkiprotich@gmail.com
 investigator_roleprincipal
 created2025-03-27 12:53:06
 modified2025-07-11 17:33:23
 SiteDetail(array)
 0(array)
 id205
 application_id231
 county_id(null)
 site_name
 physical_address
 contact_details
 contact_person
 site_capacity(null)
 misc(null)
 created2013-10-18 13:57:09
 modified2025-07-11 17:33:23
 County(empty)
 Sponsor(array)
 0(array)
 id56
 application_id231
 sponsorsample sample
 sponsor_typeIndustry
 contact_person
 addresssample
 telephone_number07005439282
 fax_number
 cell_number07005439292
 email_addresssample@gmail.com
 created2025-03-27 12:54:56
 modified2025-07-11 17:33:23
 1(array)
 Application(array)
 id2
 user_id29
 application_id(null)
 is_child0
 trial_status_id4
 total_sites2
 abstract_of_study\n Abstract\n
 study_title\n Sample Title\n
 laymans_summary\n Some Summary\n
 short_titleShort Title
 protocol_noECCT/24/01/01
 reference_no(null)
 version_nov12
 date_of_protocol09-01-2024
 study_drugName
 disease_conditionSome condition
 product_type_biologicals1
 product_type_proteins1
 product_type_immunologicals1
 product_type_vaccines1
 product_type_hormones0
 product_type_toxoid0
 product_type_chemical1
 product_type_medical_device1
 product_type_chemical_namechemical name
 product_type_medical_device_namemedical device
 comparatorYes
 comparator_nameSome
 comparator_registeredSome
 comparator_countriesSome
 ecct_not_applicable0
 ecct_ref_number
 email_addressjkiprotich@intellisoftkenya.com
 applicant_covering_letter1
 applicant_protocol1
 applicant_patient_information1
 applicant_investigators_brochure1
 applicant_investigators_cv1
 applicant_signed_declaration1
 applicant_financial_declaration1
 applicant_gmp_certificate1
 applicant_indemnity_cover1
 applicant_opinion_letter1
 applicant_approval_letter1
 applicant_statement1
 applicant_participating_countries(null)
 applicant_addendum1
 applicant_fees1
 applicant_complete_form(null)
 applicant_impd1
 applicant_prev_data1
 applicant_stability_data1
 applicant_analysis_cert1
 applicant_pictorial_sample1
 applicant_gcp_training1
 applicant_dsmb_charter1
 applicant_detailed_budget1
 applicant_indemnity_pi1
 applicant_practice_license1
 applicant_registration_ctr(null)
 applicant_pan_african1
 applicant_hard_copies(null)
 applicant_signed_checklist1
 statistical_analysis_plan1
 applicant_contractual_agreement1
 declaration_applicantsome
 declaration_date109-01-2024
 declaration_principal_investigatorsome
 declaration_date209-01-2024
 placebo_presentNo
 study_objectives\n objectives\n
 principal_inclusion_criteria\n inclusion\n
 principal_exclusion_criteria\n exclusion\n
 primary_end_points\n end points\n
 scope_diagnosis1
 scope_prophylaxis1
 scope_therapy1
 scope_safety1
 scope_efficacy1
 scope_pharmacokinetic1
 scope_pharmacodynamic1
 scope_bioequivalence1
 scope_dose_response1
 scope_pharmacogenetic1
 scope_pharmacogenomic1
 scope_pharmacoecomomic1
 scope_others0
 scope_others_specify
 trial_human_pharmacology1
 trial_administration_humans0
 trial_bioequivalence_study1
 trial_other0
 trial_other_specify
 trial_therapeutic_exploratory1
 trial_therapeutic_confirmatory0
 trial_therapeutic_use0
 design_controlledNo
 site_capacity(null)
 staff_numbers\n some capacity\n
 other_details_explanation\n some\n
 other_details_regulatory_notapproved\n some\n
 other_details_regulatory_approved\n some\n
 other_details_regulatory_rejected\n some\n
 other_details_regulatory_halted\n some\n
 estimated_duration3some
 design_controlled_randomised
 design_controlled_open
 design_controlled_single_blind
 design_controlled_double_blind
 design_controlled_parallel_group
 design_controlled_cross_over
 design_controlled_other
 design_controlled_specify
 design_controlled_comparator
 design_controlled_other_medicinal
 design_controlled_placebo
 design_controlled_medicinal_other
 design_controlled_medicinal_specify
 single_site_member_stateNo
 location_of_area
 single_site_physical_address
 single_site_contact_person
 single_site_telephone
 multiple_sites_member_stateNo
 multiple_countriesYes
 multiple_member_states4
 number_of_sites
 multi_country_listsome four states here
 data_monitoring_committeeYes
 total_enrolment_per_site30
 total_participants_worldwide50
 population_less_than_18_yearsYes
 population_uteroYes
 population_preterm_newbornNo
 population_newbornYes
 population_infant_and_toddlerNo
 population_childrenYes
 population_adolescentNo
 population_above_18Yes
 population_adultYes
 population_elderlyNo
 gender_female1
 gender_male1
 subjects_healthyYes
 subjects_patientsYes
 subjects_vulnerable_populationsYes
 subjects_women_child_bearingNo
 subjects_women_using_contraceptionYes
 subjects_pregnant_womenNo
 subjects_nursing_womenYes
 subjects_emergency_situationNo
 subjects_incapable_consentYes
 subjects_specifysome
 subjects_othersNo
 subjects_others_specify
 investigator1_given_namesome
 investigator1_middle_namesome
 investigator1_family_namesome
 investigator1_qualificationsome
 investigator1_professional_addresssome
 investigator1_telephone254700234871
 investigator1_emailsample@gmail.com
 organisations_transferred_No
 number_participants20
 notification\n None\n
 approval_date13-01-2025
 submitted1
 deleted0
 deleted_date(null)
 deactivated0
 date_submitted22-05-2024
 unsubmitted1
 initial_date_submitted22-05-2024
 admin_stopped1
 admin_stopped_reasonVillation
 approved2
 approved_reasonHey
 approved_date(null)
 final_report(null)
 implication_results(null)
 quantity_imported(null)
 quantity_dispensed(null)
 quantity_destroyed(null)
 quantity_exported(null)
 balance_site(null)
 final_date(null)
 ecitizen_invoice301439
 modified2025-02-13 09:04:41
 created2024-01-09 05:09:48
 ai_content(null)
 InvestigatorContact(array)
 0(array)
 id2
 application_id2
 given_namesome name principal
 middle_namesome name principal
 family_namesome name principal
 qualificationsome qualofication
 professional_addresssome address
 telephone254700282716
 emailsome@gmail.com
 investigator_roleprincipal
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 SiteDetail(array)
 0(array)
 id1639
 application_id2
 county_id(null)
 site_name
 physical_address
 contact_details
 contact_person
 site_capacity(null)
 misc(null)
 created2024-01-09 05:37:44
 modified2024-06-25 08:22:28
 County(empty)
 Sponsor(array)
 0(array)
 id14
 application_id2
 sponsorsome sponsor
 sponsor_typeIndustry
 contact_personsome contact person
 addressaddress
 telephone_number0700432422
 fax_number
 cell_number0700434343
 email_addresssponsor@gmail.com
 created2024-05-22 16:52:09
 modified2024-06-25 08:22:28
 2(array)
 Application(array)
 id125
 user_id29
 application_id(null)
 is_child0
 trial_status_id10
 total_sites5
 abstract_of_study\n sample\n
 study_title\n sample\n
 laymans_summary\n sample\n
 short_titleEt eius sit aut et fugiat adi
 protocol_noECCT/24/12/01
 reference_no(null)
 version_noDolorem veniam pariatur Consequat Numquam et digniss
 date_of_protocol01-12-2024
 study_drugId debitis rerum natus molestiae reprehenderit doloremque recusandae Ratione perspiciatis velit minim delectus similique suscipit fugiat
 disease_conditionTempor numquam voluptas amet aut tempore repellendus Magni pariatur
 product_type_biologicals0
 product_type_proteins0
 product_type_immunologicals1
 product_type_vaccines0
 product_type_hormones1
 product_type_toxoid0
 product_type_chemical0
 product_type_medical_device1
 product_type_chemical_nameStone Atkins
 product_type_medical_device_nameAnthony Lawrence
 comparatorNo
 comparator_nameSydnee Woods
 comparator_registeredEt sint officia eos asperiore
 comparator_countriesVel anim voluptatem
 ecct_not_applicable0
 ecct_ref_number
 email_addressjkiprotich@intellisoftkenya.com
 applicant_covering_letter1
 applicant_protocol1
 applicant_patient_information1
 applicant_investigators_brochure1
 applicant_investigators_cv1
 applicant_signed_declaration1
 applicant_financial_declaration1
 applicant_gmp_certificate1
 applicant_indemnity_cover1
 applicant_opinion_letter1
 applicant_approval_letter1
 applicant_statement1
 applicant_participating_countries(null)
 applicant_addendum1
 applicant_fees1
 applicant_complete_form(null)
 applicant_impd1
 applicant_prev_data1
 applicant_stability_data1
 applicant_analysis_cert1
 applicant_pictorial_sample1
 applicant_gcp_training1
 applicant_dsmb_charter1
 applicant_detailed_budget1
 applicant_indemnity_pi1
 applicant_practice_license1
 applicant_registration_ctr(null)
 applicant_pan_african1
 applicant_hard_copies(null)
 applicant_signed_checklist1
 statistical_analysis_plan1
 applicant_contractual_agreement1
 declaration_applicantQuo tenetur ex ut tempora consequatur rerum qui amet officiis sed molestiae fuga Quibusdam velit eu soluta voluptates amet
 declaration_date117-12-2024
 declaration_principal_investigatorSint explicabo Sint quos omnis quia aliquid non ullamco ipsum quia dignissimos qui et consequat Voluptatum cupidatat aut
 declaration_date217-12-2024
 placebo_presentYes
 study_objectives\n sample\n
 principal_inclusion_criteria\n sample\n
 principal_exclusion_criteria\n sample\n
 primary_end_points\n sample\n
 scope_diagnosis1
 scope_prophylaxis0
 scope_therapy0
 scope_safety1
 scope_efficacy0
 scope_pharmacokinetic0
 scope_pharmacodynamic1
 scope_bioequivalence0
 scope_dose_response0
 scope_pharmacogenetic0
 scope_pharmacogenomic1
 scope_pharmacoecomomic0
 scope_others0
 scope_others_specify
 trial_human_pharmacology0
 trial_administration_humans0
 trial_bioequivalence_study1
 trial_other0
 trial_other_specify
 trial_therapeutic_exploratory1
 trial_therapeutic_confirmatory0
 trial_therapeutic_use0
 design_controlledYes
 site_capacity(null)
 staff_numbers\n sample\n
 other_details_explanation\n sample\n
 other_details_regulatory_notapproved\n sample\n
 other_details_regulatory_approved\n sample\n
 other_details_regulatory_rejected\n sample\n
 other_details_regulatory_halted\n sample\n
 estimated_duration4
 design_controlled_randomisedNo
 design_controlled_openYes
 design_controlled_single_blindNo
 design_controlled_double_blindNo
 design_controlled_parallel_groupYes
 design_controlled_cross_overYes
 design_controlled_otherNo
 design_controlled_specify
 design_controlled_comparatorRecusandae Fuga Ut est
 design_controlled_other_medicinalYes
 design_controlled_placeboYes
 design_controlled_medicinal_otherNo
 design_controlled_medicinal_specify
 single_site_member_stateNo
 location_of_area
 single_site_physical_address
 single_site_contact_person
 single_site_telephone
 multiple_sites_member_stateYes
 multiple_countriesNo
 multiple_member_states
 number_of_sites543
 multi_country_list
 data_monitoring_committeeYes
 total_enrolment_per_siteQuidem in duis fugia
 total_participants_worldwideSit ut quae amet at tempor et commodo voluptas quod neque adipisci nemo labore Nam officia ut commodi
 population_less_than_18_yearsYes
 population_uteroNo
 population_preterm_newbornNo
 population_newbornNo
 population_infant_and_toddlerNo
 population_childrenNo
 population_adolescentYes
 population_above_18Yes
 population_adultNo
 population_elderlyNo
 gender_female1
 gender_male0
 subjects_healthyYes
 subjects_patientsYes
 subjects_vulnerable_populationsYes
 subjects_women_child_bearingYes
 subjects_women_using_contraceptionNo
 subjects_pregnant_womenNo
 subjects_nursing_womenYes
 subjects_emergency_situationYes
 subjects_incapable_consentYes
 subjects_specifyFacilis quia totam u
 subjects_othersYes
 subjects_others_specifyNulla ipsam dolore i
 investigator1_given_nameDominique Solomon
 investigator1_middle_nameHyacinth Bond
 investigator1_family_nameIndira Shaffer
 investigator1_qualificationRerum adipisicing magnam qui rerum nemo dicta eligendi quis inventore provident accusantium aperiam ipsum enim qui asperiores
 investigator1_professional_addressSit aut at tenetur enim culpa
 investigator1_telephone+1 (956) 653-5189
 investigator1_emailpydekizef@mailinator.com
 organisations_transferred_Yes
 number_participantsVoluptatum aliqua I
 notification\n sample\n
 approval_date17-12-2024
 submitted1
 deleted0
 deleted_date(null)
 deactivated0
 date_submitted17-12-2024
 unsubmitted1
 initial_date_submitted17-12-2024
 admin_stopped0
 admin_stopped_reason(null)
 approved2
 approved_reason
 approved_date(null)
 final_report(null)
 implication_results(null)
 quantity_imported(null)
 quantity_dispensed(null)
 quantity_destroyed(null)
 quantity_exported(null)
 balance_site(null)
 final_date(null)
 ecitizen_invoice(null)
 modified2025-01-07 08:39:12
 created2024-11-29 09:22:21
 ai_content(null)
 InvestigatorContact(array)
 0(array)
 id81
 application_id125
 given_nameLawrence Jennings
 middle_nameAladdin Powers
 family_nameElton Delgado
 qualificationUllam deleniti aliqua Excepteur nisi id dolorum vel ipsum a irure repudiandae molestias aut quos suscipit et dolore reprehenderit eu
 professional_addressUt facere ea aliquam eveniet
 telephone+1 (328) 771-3449
 emailxycuqez@mailinator.com
 investigator_roleprincipal
 created2024-12-17 08:32:23
 modified2025-01-06 11:48:30
 SiteDetail(array)
 0(array)
 id1705
 application_id125
 county_id25
 site_nameChastity Horne
 physical_addressA alias veritatis aute asperiores voluptatem anim id irure veniam qui
 contact_detailsPO Box 91937
 contact_personAtque esse sint consectetur qui tempor dicta sit illo id consectetur illo qui quo soluta
 site_capacity(null)
 misc(null)
 created2024-12-17 08:32:23
 modified2025-01-06 11:48:30
 County(array)
 id25
 county_nameSamburu
 created2012-06-15 10:24:58
 modified2012-06-15 10:24:58
 Sponsor(array)
 0(array)
 id33
 application_id125
 sponsorDolore sunt reprehenderit voluptas commodi asperiores
 sponsor_typeIndustry
 contact_personAd consequatur nulla aut quo explicabo Eligendi similique ex cum sed voluptas sint sit dolorem nulla asperiores suscipit
 addressQuis ipsa voluptatum non officia nisi minus officia est et
 telephone_number+1 (498) 749-6935
 fax_number+1 (547) 888-9241
 cell_number+1 (941) 425-9332
 email_addresscidesy@mailinator.com
 created2024-12-17 08:32:23
 modified2025-01-06 11:48:30
 3(array)
 Application(array)
 id41
 user_id29
 application_id(null)
 is_child0
 trial_status_id7
 total_sites(null)
 abstract_of_study\n some abstract information\n
 study_title\n Some study title\n
 laymans_summary\n summay\n
 short_titleEsse incididunt officia vitae
 protocol_noECCT/24/05/02
 reference_no(null)
 version_noExercitationem esse quibusdam consectetur qui ut eu e
 date_of_protocol01-05-2024
 study_drugLabore accusantium at nisi magna pariatur Reprehenderit libero qui optio
 disease_conditionDolore aspernatur eveniet voluptatem molestiae ut non reiciendis aute enim magna
 product_type_biologicals0
 product_type_proteins0
 product_type_immunologicals1
 product_type_vaccines1
 product_type_hormones0
 product_type_toxoid0
 product_type_chemical1
 product_type_medical_device0
 product_type_chemical_nameAlvin Harvey
 product_type_medical_device_nameLee Waters
 comparatorYes
 comparator_name
 comparator_registeredQuae iure esse repudiandae ven
 comparator_countriesAmet et dolores ex
 ecct_not_applicable0
 ecct_ref_number
 email_addressjkiprotich@intellisoftkenya.com
 applicant_covering_letter1
 applicant_protocol1
 applicant_patient_information1
 applicant_investigators_brochure1
 applicant_investigators_cv1
 applicant_signed_declaration1
 applicant_financial_declaration1
 applicant_gmp_certificate1
 applicant_indemnity_cover1
 applicant_opinion_letter1
 applicant_approval_letter1
 applicant_statement1
 applicant_participating_countries(null)
 applicant_addendum1
 applicant_fees1
 applicant_complete_form(null)
 applicant_impd1
 applicant_prev_data1
 applicant_stability_data1
 applicant_analysis_cert1
 applicant_pictorial_sample1
 applicant_gcp_training1
 applicant_dsmb_charter1
 applicant_detailed_budget1
 applicant_indemnity_pi1
 applicant_practice_license1
 applicant_registration_ctr(null)
 applicant_pan_african1
 applicant_hard_copies(null)
 applicant_signed_checklist1
 statistical_analysis_plan1
 applicant_contractual_agreement1
 declaration_applicantBlanditiis rem voluptas blanditiis omnis sit iure ratione accusantium nostrum perspiciatis nihil quasi debitis
 declaration_date116-05-2024
 declaration_principal_investigatorAccusamus porro et esse ut obcaecati labore voluptatem Doloribus distinctio Nostrud enim aliqua Accusamus officia et recusandae Pariatur Officia
 declaration_date222-05-2024
 placebo_presentYes
 study_objectives\n study objectives\n
 principal_inclusion_criteria\n inclusion criteria\n
 principal_exclusion_criteria\n exclusion criteria\n
 primary_end_points\n primary end points\n
 scope_diagnosis0
 scope_prophylaxis1
 scope_therapy1
 scope_safety0
 scope_efficacy0
 scope_pharmacokinetic1
 scope_pharmacodynamic1
 scope_bioequivalence0
 scope_dose_response1
 scope_pharmacogenetic0
 scope_pharmacogenomic1
 scope_pharmacoecomomic1
 scope_others0
 scope_others_specify
 trial_human_pharmacology0
 trial_administration_humans1
 trial_bioequivalence_study0
 trial_other0
 trial_other_specifyDo harum aut mollit
 trial_therapeutic_exploratory0
 trial_therapeutic_confirmatory1
 trial_therapeutic_use0
 design_controlledNo
 site_capacity(null)
 staff_numbers\n some capacity\n
 other_details_explanation\n tets\n
 other_details_regulatory_notapproved\n test\n
 other_details_regulatory_approved\n etst \n
 other_details_regulatory_rejected\n neame \n
 other_details_regulatory_halted\n some details\n
 estimated_durationCupidatat quisquam omnis ipsum magna minim sunt reprehenderit odio ducimus maxime tenetur
 design_controlled_randomised
 design_controlled_open
 design_controlled_single_blind
 design_controlled_double_blind
 design_controlled_parallel_group
 design_controlled_cross_over
 design_controlled_other
 design_controlled_specify
 design_controlled_comparator
 design_controlled_other_medicinal
 design_controlled_placebo
 design_controlled_medicinal_other
 design_controlled_medicinal_specify
 single_site_member_stateNo
 location_of_area
 single_site_physical_address
 single_site_contact_person
 single_site_telephone
 multiple_sites_member_stateYes
 multiple_countriesNo
 multiple_member_states
 number_of_sites754
 multi_country_list
 data_monitoring_committeeNo
 total_enrolment_per_siteNihil iusto nostrud
 total_participants_worldwideAd omnis culpa quam ullamco adipisicing error possimus elit quis quidem eius harum necessitatibus amet culpa velit do
 population_less_than_18_yearsYes
 population_uteroNo
 population_preterm_newbornYes
 population_newbornNo
 population_infant_and_toddlerYes
 population_childrenNo
 population_adolescentYes
 population_above_18Yes
 population_adultNo
 population_elderlyYes
 gender_female1
 gender_male1
 subjects_healthyYes
 subjects_patientsNo
 subjects_vulnerable_populationsYes
 subjects_women_child_bearingNo
 subjects_women_using_contraceptionNo
 subjects_pregnant_womenNo
 subjects_nursing_womenYes
 subjects_emergency_situationNo
 subjects_incapable_consentYes
 subjects_specifyNobis amet pariatur
 subjects_othersNo
 subjects_others_specify
 investigator1_given_nameCasey Bowers
 investigator1_middle_nameYoshio Cervantes
 investigator1_family_nameKelsey Fernandez
 investigator1_qualificationDoloribus non provident sequi et aliquip aperiam eaque exercitation ut aliquip atque ut in
 investigator1_professional_addressNulla ad soluta vero mollit praesentium anim nisi natus nobis eaque voluptas autem quae ratione earum sed
 investigator1_telephone+1 (887) 512-8391
 investigator1_emailjoniqixobu@mailinator.com
 organisations_transferred_Yes
 number_participantsDeserunt placeat ut
 notification\n some comments\n
 approval_date21-06-2024
 submitted1
 deleted0
 deleted_date(null)
 deactivated0
 date_submitted24-05-2024
 unsubmitted0
 initial_date_submitted(null)
 admin_stopped0
 admin_stopped_reason(null)
 approved2
 approved_reasonTest Report
 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_invoice301940
 modified2025-02-28 14:54:21
 created2024-05-24 10:59:06
 ai_content(null)
 InvestigatorContact(array)
 0(array)
 id16
 application_id41
 given_nameTara Carr
 middle_nameEaton Guthrie
 family_nameConan Greene
 qualificationAliqua Esse perferendis minima aliqua Earum pariatur Deleniti consectetur dolor occaecat obcaecati minus et
 professional_addressNeque nostrum odit praesentium odit libero facere minim velit voluptatem similique cum qui eu vitae eiusmod nisi
 telephone+1 (189) 138-1399
 emailsynubu@mailinator.com
 investigator_roleprincipal
 created2024-05-24 11:00:45
 modified2024-05-24 15:13:22
 SiteDetail(array)
 0(array)
 id1662
 application_id41
 county_id26
 site_nameKane Durham
 physical_addressEt sunt quod in sapiente consequatur
 contact_detailsPO Box 73395
 contact_personRerum voluptates sunt consequuntur minus excepturi ut aliqua Quia consectetur nihil consequatur
 site_capacity(null)
 misc(null)
 created2024-05-24 11:00:45
 modified2024-05-24 15:13:22
 County(array)
 id26
 county_nameTrans Nzoia
 created2012-06-15 10:25:05
 modified2012-06-15 10:25:05
 1(array)
 id1669
 application_id41
 county_id40
 site_namenext
 physical_addressother
 contact_detailssample
 contact_person4
 site_capacity(null)
 misc(null)
 created2024-05-24 14:52:54
 modified2024-05-24 15:13:22
 County(array)
 id40
 county_nameBusia
 created2012-06-15 10:26:51
 modified2012-06-15 10:26:51
 Sponsor(array)
 0(array)
 id16
 application_id41
 sponsorQuod sunt eligendi illum ab perferendis officia nihil et quia in nulla dolor
 sponsor_typeOthers
 contact_personInventore labore veniam in numquam laborum Magnam quos beatae qui natus
 addressSaepe commodo culpa omnis aspernatur proident et
 telephone_number+1 (248) 754-8124
 fax_number+1 (533) 843-5666
 cell_number+1 (647) 568-5631
 email_addresslojocip@mailinator.com
 created2024-05-24 11:00:45
 modified2024-05-24 15:13:22
 4(array)
 Application(array)
 id14
 user_id26
 application_id(null)
 is_child0
 trial_status_id(null)
 total_sites(null)
 abstract_of_study\n Test Abstract\n
 study_title\n Test\n
 laymans_summary\n Layman's summary of the Test Protocol\n
 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\n Test objective\n
 principal_inclusion_criteria\n Test Inclusion criteria\n
 principal_exclusion_criteria\n Test exclusion criteria\n
 primary_end_points\n Primary endpoints\n
 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\n Test people\n
 other_details_explanation\n test reason\n
 other_details_regulatory_notapproved\n test regulatory\n
 other_details_regulatory_approved\n test reg\n
 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
 ai_content(null)
 InvestigatorContact(array)
 0(array)
 id11
 application_id14
 given_nameJavan
 middle_name
 family_nameTest
 qualificationMsc Medicine
 professional_addressTets Professional Address
 telephone+2547910292871
 emailjavan@gmail.com
 investigator_roleprincipal
 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
 County(empty)
 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
- page_options(array)
 55
 1010
- redir
- $request->data(array)
 Application(empty)
- $this->validationErrors(array)
 Permission(empty)
 Aro(empty)
 Aco(empty)
 Application(empty)
 User(empty)
 TrialStatus(empty)
 InvestigatorContact(empty)
 Sponsor(empty)
 SiteDetail(empty)
 County(empty)
- Loaded Helpers(array)
 0Html
 1Form
 2Session
 3Text
 4Number
 5SimpleGraph
 6Paginator
 7DebugTimer
 8Toolbar
 9HtmlToolbar
====

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

CakePHP Constants

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

PHP Environment

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

====

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
  6CORE/Controller/Component/PaginatorComponent.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
  7CORE/Utility/Sanitize.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Behavior(array)
  0APP/Model/Behavior/SoftDeleteBehavior.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/InvestigatorContact.php
  5APP/Model/Sponsor.php
  6APP/Model/SiteDetail.php
  7APP/Model/County.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
  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
====

Clinical Trial Applications: Filter, Search, and view applications {lang: 'en-GB'}

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 7 ms Total Queries: 9 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Clinical Trial Applications: Filter, Search, and view applications

Total Time: 7 ms
Total Queries: 9 queries