Publications Summary


Document Type
Working Papers
Publication Topic(s)
Child Health and Development, Gender, Nutrition
Country(s)
Kenya, Cambodia
Language
English
Recommended Citation
Ettyang, Grace A. K. and Caroline J. Sawe. 2016. Factors Associated with Stunting in Children under Age 2 in the Cambodia and Kenya 2014 Demographic and Health Surveys. DHS Working Papers No. 126. Rockville, Maryland, USA: ICF International.
Download Citation
RIS format / Text format / Endnote format
Publication Date
August 2016
Publication ID
WP126

Order a Hard Copy: Please use electronic copies of DHS publications whenever possible. Hardcopies of publications are intended primarily for those in developing countries where internet connections are limited or unavailable.

Abstract:

Background: This study examined the relationships between child, maternal, household, and gender inequality characteristics and child stunting in Kenya and Cambodia. Globally, an estimated 171 million children are stunted, including 167 million in low- and middle-income countries, with especially high prevalence levels in Africa and Asia. Child stunting reflects chronic undernutrition, which often begins before birth and is almost irreversible after the second year of life. Methods: The study analyzed data from the 2014 Demographic and Health Surveys (DHS surveys) in Kenya and Cambodia for children under age 2. Bivariate and logistic regression analyses were performed to find associations between the variables and child stunting. Results: The prevalence of stunting among children under age 2 in Kenya was 22%, and in Cambodia, 25%. Child’s age, perceived birth size, family wealth status, and region of residence were significantly associated with stunting. In both countries children from the richest households had 0.4 times lower odds of being stunted compared with those from the poorest households. In Kenya alone, female children had 0.6 times lower odds of being stunted compared with male children. In Cambodia alone, children from rural areas had 0.6 times lower odds of being stunted compared with those from urban areas, while children whose mothers were underweight had 1.7 times higher odds of being stunted than children whose mothers were not underweight. In both countries, there was general lack of a strong and significant relationship between gender inequality and child stunting. Conclusions: Children’s characteristics were more important in predicting stunting than factors related to mothers, households, or gender. More extensive analysis of the DHS data should be done to include other aspects of gender inequality, such as decisions on choice and preparation of food and purchase of household goods.

Browse

Browse for Publications by:

Browse for Journal Articles based on DHS data by:


Debugging Information
ColdFusion Server Standard 2018,0,19,330149
Template /publications/publication-wp126-working-papers.cfm
Time Stamp 13-Oct-24 03:23 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.0.2.225
Host Name 10.0.2.225


Execution Time

Total Time Avg Time Count Template
622 ms 622 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
622 ms 622 ms 1 C:/inetpub/wwwroot/dhs/publications/publication-wp126-working-papers.cfm
548 ms 20 ms 28 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
548 ms 20 ms 28 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
498 ms 498 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
344 ms 344 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
344 ms 344 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
344 ms 344 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
344 ms 344 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
281 ms 281 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
266 ms 24 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
234 ms 234 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c1378-l70-t51-dAny.read
219 ms 219 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
154 ms 154 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
63 ms 63 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
62 ms 62 ms 1 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/publication/pub_detail_display.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/dhs/publications/Application.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c1433-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c19153-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/set-style-vars.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/templates/googlescholar_citation.cfm
16 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(23649, 11243) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/publication/citation_ris.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/dhs/templates/facebook_meta.cfm
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c1432-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c19152-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c19154-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c19155-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c19177-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p23649-c50815-l70-t27356-dAny.read
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/browser-detect-methods.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-site.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/style/load-page-classes.cfm
0 ms 0 ms 9 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile-meat.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 13 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/item-visible.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-page-stub.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-stub.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/common/modules/getvariables.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/dhs/customcf/legacy/publication/pubs_functions.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/publications/new-publication-summary-template.cfm
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(11242) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(1652) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(23649) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | DBQueue_Count() ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(11242, 2, 1652, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(23649, 2, 11242, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 2, 23649, 11242, 0, 0, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 2, 23649, 11242, 0, 0, 90) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomAppPath(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomModulePath(post-page-render, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc | GetEntry(23649) ] from C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc | getRewriteSettings(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getLatest() ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getSecurityPageIDMap([complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(11242) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | LoadTemplateProperties(new-publication-summary-template.cfm, 11242, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc | executeFunction(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc | getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('site' Remote Requests processed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('user' Remote Requests processed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(CGI variable processing) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(New (global) session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request object updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request.Params initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(RequestTimeout check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Server-level remote requests checked) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Subsite context updated (ID=2)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(authoring suspended check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(check for server property changes) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core cleanup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core variables) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(custom-application.cfm) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(customerScope object initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(init-server-scope loaded) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(lock checks/updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site environment initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site session check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(subsite context refreshed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user object created) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Server_Scope (read)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Site1_Core (exclusive)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Cache) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Element) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(LiveBookmarks) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc | onPageVisit(23649, 2) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 23649) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(23649) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
669 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

pendingRequests (Datasource=commonspot-sites, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 03:23:26.026
				SELECT params,RequestSequenceID
				  FROM ServerRemoteRequests
				 WHERE DestServerID = ?
					AND RequestMode = 3
			 ORDER BY RequestSequenceID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-sites, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 03:23:26.026
			SELECT *
			  FROM ServerRemoteRequests
			 WHERE DestServerID = ? 
				AND RequestMode IN (0,2)
		
		 ORDER BY RequestSequenceID, SourceServerID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

get (Datasource=dhs_legacy_live, Time=15ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 03:23:26.026
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
pendingRequests (Datasource=commonspot-users, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 03:23:26.026
				SELECT params,RequestSequenceID
				  FROM UsersRemoteRequests
				 WHERE DestServerID = ?
					AND RequestMode = 3
			 ORDER BY RequestSequenceID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-users, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 03:23:26.026
			SELECT *
			  FROM UsersRemoteRequests
			 WHERE DestServerID = ? 
				AND RequestMode IN (0,2)
		
		 ORDER BY RequestSequenceID, SourceServerID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 03:23:26.026
				SELECT params,RequestSequenceID
				  FROM RemoteRequests
				 WHERE DestServerID = ?
					AND RequestMode = 3
			 ORDER BY RequestSequenceID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 03:23:26.026
			SELECT *
			  FROM RemoteRequests
			 WHERE DestServerID = ? 
				AND RequestMode IN (0,2)
		
		 ORDER BY RequestSequenceID, SourceServerID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

GetPageRec (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\verify-stub-data.cfm @ 03:23:26.026
		SELECT *
		  FROM SitePages
		 WHERE ID=?
			AND AudienceID=0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

GetPageRec (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\build-and-write-stub.cfm @ 03:23:26.026
	SELECT *
	  FROM SitePages
	 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

inheritedCacheSettings (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:23:26.026
		SELECT StaleCacheMaxKeepTime,DynamicContentCacheKeepTime
		  FROM SitePages
		 WHERE (ID IN (?,?,?,?)) 
	 ORDER BY ID
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 1652
Parameter #4(CF_SQL_INTEGER) = 11242

GetBaseTemplateSubSiteID (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:23:26.026
		SELECT DISTINCT SitePages.SubSiteID
		  FROM SitePages, Subsites
		 WHERE SitePages.SubSiteID = Subsites.ID
		
			AND Subsites.ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

qParentTemplateInfo (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:23:26.026
			SELECT PageType
			  FROM SitePages
			 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11242

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 03:23:26.026
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:26.026
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,3,11,14,15))
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

qryKeywords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\keywords-tags\keywords-tags-base.cfc @ 03:23:26.026
		SELECT OriginalString AS Word 
				, KeywordType As KeywordTypeID
				
		  FROM ObjectKeywords
		 WHERE ObjectID = ? 
			AND KeywordType = ? 
	 ORDER BY Position, OriginalString
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649
Parameter #2(CF_SQL_TINYINT) = 0

GetRenderOptions (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:23:26.026
			SELECT GeneralCategories.Category, RenderOptions.PageID
			  FROM RenderOptions, GeneralCategories
			 WHERE GeneralCategories.ID = RenderOptions.CategoryID
				AND GeneralCategories.CategoryTypeID = ?
				AND (RenderOptions.PageID IN (?,?,?,?,?)) 
		 ORDER BY RenderOptions.PageID Desc
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 12
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 23649
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 1652
Parameter #6(CF_SQL_INTEGER) = 11242

getPageInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 03:23:26.026
	SELECT PageType, SubSiteID, CategoryID, InheritedTemplateList, DocType, Uploaded
	  FROM SitePages
	 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

FormData (Datasource=commonspot-site-dhs, Time=31ms, Records=42) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 03:23:26.026
	SELECT Data_FieldValue.PageID, Data_FieldValue.FieldValue, FormInputControl.FieldName, FormInputControl.type, FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid, FormInputControl.params AS fieldParams
						  
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE (Data_FieldValue.PageID IN (?,?,?,?,?))  
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
	
		
		AND (
				
				(
					(FormControlMap.ClassConstant = 4)
				
					AND (FormControlMap.ClassID IN (?,?)) 
				)
				
				
					OR (
								 (FormControlMap.ClassConstant = 1)
							AND ( (FormControlMap.ClassID IN (?,?,?,?)) )
						)
				
				
					OR (
								 (FormControlMap.ClassConstant = 2)
							AND (FormControlMap.ClassID = ?)
						)
				
				

				
			 )
	
 ORDER BY PageID DESC, FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 23649
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1652
Parameter #5(CF_SQL_INTEGER) = 11242
Parameter #6(CF_SQL_INTEGER) = 1
Parameter #7(CF_SQL_INTEGER) = 2
Parameter #8(CF_SQL_INTEGER) = 1
Parameter #9(CF_SQL_INTEGER) = 2
Parameter #10(CF_SQL_INTEGER) = 1652
Parameter #11(CF_SQL_INTEGER) = 11242
Parameter #12(CF_SQL_INTEGER) = 7

NamedClasses (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\style\load-page-classes.cfm @ 03:23:26.026
	SELECT *
	  FROM Data_ClassNames
	 WHERE (PageID IN (?,?,?,?,?)) 
		AND VersionState = ?
		AND OutputTypeID = 0
 ORDER BY PageID DESC, ControlID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 23649
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1652
Parameter #5(CF_SQL_INTEGER) = 11242
Parameter #6(CF_SQL_INTEGER) = 2

StyleSheetGroups (Datasource=commonspot-site-dhs, Time=0ms, Records=2) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 03:23:26.026
		SELECT *
		  FROM Data_StyleSheetGroups
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos ASC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 23649
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1652
Parameter #5(CF_SQL_INTEGER) = 11242
Parameter #6(CF_SQL_INTEGER) = 2

PageStyleSheets (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 03:23:26.026
		SELECT *
		  FROM Data_StyleSheets
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND ControlID = ?
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 23649
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1652
Parameter #5(CF_SQL_INTEGER) = 11242
Parameter #6(CF_SQL_INTEGER) = 3474
Parameter #7(CF_SQL_INTEGER) = 2

CheckCustomRender (Datasource=commonspot-site-dhs, Time=0ms, Records=52) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:23:26.026
		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 23649
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1652
Parameter #5(CF_SQL_INTEGER) = 11242
Parameter #6(CF_SQL_INTEGER) = 2

SecurityRecords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:23:26.026
	SELECT DISTINCT ControlID
	  FROM ItemSecurity
	 WHERE PageID = ?
		AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

ParentTemplateInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\write-stub.cfm @ 03:23:26.026
		SELECT SubsiteID,Filename,PageType
		  FROM SitePages
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11242

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=31ms, Records=2058) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 03:23:27.027
		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 23649
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1652
Parameter #5(CF_SQL_INTEGER) = 11242
Parameter #6(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 03:23:27.027
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=23649 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		
qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 03:23:27.027
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 03:23:27.027
		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649
Parameter #2(CF_SQL_INTEGER) = 11

getpub (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\templates\googlescholar_citation.cfm @ 03:23:27.027
SELECT Pub_Catalog.Pub_ID, Pub_Catalog.Pub_Type_ID, Pub_Stts.Stts_Lbl,Pub_Catalog.Pub_Code, 
  Pub_Catalog.Pub_Code_Num, Pub_Catalog.Ctry_List, Pub_Catalog.Print_Date, Pub_Catalog.Lang_List, 
  Pub_Catalog.Title, Pub_Catalog.Out_of_Print, Pub_Catalog.Copies, Pub_Type.Pub_Type_Name, Survey.Survey_Yr_Display, 
  Pub_Catalog.abstract, Pub_Catalog.authors, Pub_Catalog.notes, Pub_Catalog.Addln_notes, Pub_Catalog.title_secondary, 
  Pub_Catalog.title_sentencecaps, pub_url, publisher, publisher_city, pub_type_cite, citation, abstract_updated, citation_checked,
  Author_Fname_1, Author_Fname_2, Author_Fname_3, Author_Fname_4, Author_Fname_5,
  Author_Lname_1, Author_Lname_2, Author_Lname_3, Author_Lname_4, Author_Lname_5,
  Author_Fname_6, Author_Fname_7, Author_Fname_8, Author_Fname_9, Author_Fname_10,
  Author_Lname_6, Author_Lname_7, Author_Lname_8, Author_Lname_9, Author_Lname_10,
  Author_Type_1, Author_Type_2, Author_Type_3, Author_Type_4, Author_Type_5,
  Author_Type_6, Author_Type_7, Author_Type_8, Author_Type_9, Author_Type_10, 
  (SELECT ctry_name FROM Ctry, survey WHERE ctry.ctry_id = survey.ctry_id and survey.survey_id=Pub_Catalog.survey_id ) AS ctry_name, 
  (SELECT Count(*) FROM Pub_PDF WHERE Pub_PDF.Pub_ID = Pub_Catalog.Pub_ID) AS NoPDF 
FROM Pub_Catalog 
  INNER JOIN Pub_Type 
    ON Pub_Type.Pub_Type_ID = Pub_Catalog.Pub_Type_ID
     INNER JOIN Pub_Stts
    ON Pub_Stts.Stts_ID = Pub_Catalog.Stts_ID
  LEFT OUTER JOIN Survey 
    ON Survey.Survey_ID = Pub_Catalog.Survey_ID 
WHERE Pub_Code = 'wp126'
getpub_fb (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\templates\facebook_meta.cfm @ 03:23:27.027
SELECT Ctry_Name, Survey_Type_Lbl, Pub_Catalog.Pub_ID, Pub_Catalog.Pub_Type_ID, Pub_Stts.Stts_Lbl,Pub_Catalog.Pub_Code, 
  Pub_Catalog.Pub_Code_Num, Pub_Catalog.Print_Date, Pub_Catalog.Title, Pub_Type.Pub_Type_Name, Pub_Catalog.Lang_List, 
  Survey.Survey_Yr_Display, Pub_Catalog.title_secondary, Pub_Catalog.title_sentencecaps, pub_url
FROM Pub_Catalog 
  INNER JOIN Pub_Type 
    ON Pub_Type.Pub_Type_ID = Pub_Catalog.Pub_Type_ID
  INNER JOIN Pub_Stts
    ON Pub_Stts.Stts_ID = Pub_Catalog.Stts_ID
  LEFT OUTER JOIN Survey 
    ON Survey.Survey_ID = Pub_Catalog.Survey_ID 
  LEFT OUTER JOIN Ctry
     ON Ctry.Ctry_ID = Survey.Ctry_ID
  LEFT OUTER JOIN Survey_SubType
     ON Survey_SubType.Survey_SubType_ID = Survey.Survey_Type_ID
  LEFT OUTER JOIN Survey_Type
     ON Survey_Type.Survey_Type_ID = Survey_SubType.Survey_Type_MainID	
WHERE Pub_Code = 'wp126'
ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=77) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 03:23:27.027
		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 23649
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1652
Parameter #5(CF_SQL_INTEGER) = 11242

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 03:23:27.027
		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 400
Parameter #2(CF_SQL_INTEGER) = 22
Parameter #3(CF_SQL_INTEGER) = 44
Parameter #4(CF_SQL_INTEGER) = 55
Parameter #5(CF_SQL_INTEGER) = 1
Parameter #6(CF_SQL_INTEGER) = 56
Parameter #7(CF_SQL_INTEGER) = 47
Parameter #8(CF_SQL_INTEGER) = 26
Parameter #9(CF_SQL_INTEGER) = 48
Parameter #10(CF_SQL_INTEGER) = 27
Parameter #11(CF_SQL_INTEGER) = 28
Parameter #12(CF_SQL_INTEGER) = 51
Parameter #13(CF_SQL_INTEGER) = 31
Parameter #14(CF_SQL_INTEGER) = 33
Parameter #15(CF_SQL_INTEGER) = 26
Parameter #16(CF_SQL_INTEGER) = 48
Parameter #17(CF_SQL_INTEGER) = 37
Parameter #18(CF_SQL_INTEGER) = 27
Parameter #19(CF_SQL_INTEGER) = 38
Parameter #20(CF_SQL_INTEGER) = 28
Parameter #21(cf_sql_integer) = 26

Request.customCFUpfront (Datasource=commonspot-site-dhs, Time=0ms, Records=2) in C:\inetpub\wwwroot\commonspot\controls\upfront-generic.cfm @ 03:23:27.027
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=23649 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 03:23:27.027
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11242

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1652

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

qGetCntyFromList (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
				SELECT Ctry_ID
				 FROM    Ctry
				 WHERE   Ctry_Name = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Kenya,Cambodia

qGetTopicList (Datasource=, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
		SELECT topic_id, pub_topic_name
		FROM qGetTopicList
		ORDER by pub_topic_name 
		
qGetTopPdf (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
		SELECT PDF_File_Name
		FROM qGetPubsDetails   
		
checkifparent (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
    SELECT pub_id from pub_catalog where parent_pub_id = 1664 
checkforlinks (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
    SELECT link_pub_ids 
	FROM pub_catalog 
	WHERE pub_id = 1664 
	  AND link_pub_ids is not NULL
    
getpub (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\citation_ris.cfm @ 03:23:27.027
SELECT Pub_Catalog.Pub_ID, Pub_Catalog.Pub_Type_ID, Pub_Stts.Stts_Lbl,Pub_Catalog.Pub_Code, 
  Pub_Catalog.Pub_Code_Num, Pub_Catalog.Ctry_List, Pub_Catalog.Print_Date, Pub_Catalog.Lang_List, 
  Pub_Catalog.Title, Pub_Catalog.Out_of_Print, Pub_Catalog.Copies, Pub_Type.Pub_Type_Name, Survey.Survey_Yr_Display, 
  Pub_Catalog.abstract as abstract_text, Pub_Catalog.authors, Pub_Catalog.notes, Pub_Catalog.Addln_notes, Pub_Catalog.title_secondary, 
  Pub_Catalog.title_sentencecaps, pub_url, publisher, publisher_city, pub_type_cite, citation, abstract_updated, citation_checked,
  Author_Fname_1, Author_Fname_2, Author_Fname_3, Author_Fname_4, Author_Fname_5,
  Author_Lname_1, Author_Lname_2, Author_Lname_3, Author_Lname_4, Author_Lname_5,
  Author_Fname_6, Author_Fname_7, Author_Fname_8, Author_Fname_9, Author_Fname_10,
  Author_Lname_6, Author_Lname_7, Author_Lname_8, Author_Lname_9, Author_Lname_10,
  Author_Type_1, Author_Type_2, Author_Type_3, Author_Type_4, Author_Type_5,
  Author_Type_6, Author_Type_7, Author_Type_8, Author_Type_9, Author_Type_10, 
  (SELECT ctry_name FROM Ctry, survey WHERE ctry.ctry_id = survey.ctry_id and survey.survey_id=Pub_Catalog.survey_id ) AS ctry_name, 
  (SELECT Count(*) FROM Pub_PDF WHERE Pub_PDF.Pub_ID = Pub_Catalog.Pub_ID) AS NoPDF 
FROM Pub_Catalog 
  INNER JOIN Pub_Type 
    ON Pub_Type.Pub_Type_ID = Pub_Catalog.Pub_Type_ID
     INNER JOIN Pub_Stts
    ON Pub_Stts.Stts_ID = Pub_Catalog.Stts_ID
  LEFT OUTER JOIN Survey 
    ON Survey.Survey_ID = Pub_Catalog.Survey_ID 
WHERE Pub_Code <> 'NA' 
  AND Pub_Catalog.Pub_ID = 1664
  AND Pub_Type.Pub_Type_ID IN (15,16,6,18,9,45,11,4,8,12,27,5,26,39,21,30,46)    
getCID (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
				    SELECT Ctry_ID FROM    Ctry WHERE   Ctry_Name = 'Kenya'
				 
getCID (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
				    SELECT Ctry_ID FROM    Ctry WHERE   Ctry_Name = 'Cambodia'
				 
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 03:23:27.027
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23649

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11242

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1652

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:23:27.027
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

CacheUpdate (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 03:23:27.027
					UPDATE ElementInstance
						SET CacheFormat=?,
							 CacheValidUntil=?,
							 ContentValidUntil=?,
							 DataPageID=?,
							 DependentObjectID=?,
							 DynamicStatus=?,
							 HasChildren=?,
							 HasData=?,
							 HasDynamicContent=?,
							 IndexStatus=?,
							 IsDeviceDependent=?,
							 ParamPageID=?,
							 PrintStatus=?,
							 ShareStatus=?,
							 ConflictList=?
					 WHERE ServerID=?
						AND SubsiteID=?
						AND PageID=?
						AND ControlID=?
						AND CacheLevel=?
						AND IsWIP=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_VARCHAR) = 2124-10-13 03:23:26
Parameter #3(CF_SQL_VARCHAR) = 2124-10-13 03:23:26
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 0
Parameter #6(CF_SQL_VARCHAR) =
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 1
Parameter #9(CF_SQL_INTEGER) = 2
Parameter #10(CF_SQL_INTEGER) = 0
Parameter #11(CF_SQL_INTEGER) = 0
Parameter #12(CF_SQL_INTEGER) = 0
Parameter #13(CF_SQL_INTEGER) = 0
Parameter #14(CF_SQL_INTEGER) = 0
Parameter #15(CF_SQL_VARCHAR) =
Parameter #16(CF_SQL_INTEGER) = 1
Parameter #17(CF_SQL_INTEGER) = 2
Parameter #18(CF_SQL_INTEGER) = 23649
Parameter #19(CF_SQL_INTEGER) = 0
Parameter #20(CF_SQL_INTEGER) = 2
Parameter #21(CF_SQL_INTEGER) = 0


Stored Procedures

sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\templates\facebook_meta.cfm @ 03:23:27.027

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1664    
    
resultsets
nameresultset
 qDetails  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1664    
    
resultsets
nameresultset
 qDetails  1
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1664    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList  2
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:23:27.027
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  0    
    
resultsets
nameresultset
 qDetails_parentpub  1


Scope Variables

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=0
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-10-13 19:08:16
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\publications\publication-wp126-working-papers.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/publications/publication-wp126-working-papers.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\publications\publication-wp126-working-papers.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.2.225
REMOTE_HOST=10.0.2.225
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/publications/publication-wp126-working-papers.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CSRFTOKEN=5DF9247FF12CC46926C7742C0806934651A98BAE
Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=26
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (123)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_request_start_memory=3051114768
cs_runningdashboardcmdcode=0
csrftoken=5DF9247FF12CC46926C7742C0806934651A98BAE
ctrl_data=Struct (76)
customcf_data=Struct (2)
customcfupfront=Query (2)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-10-13 03:23:26
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1728789806891
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (86)
master_cfm_used=1
maxperms=Complex type
metadata=Struct (8)
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (85)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
parentisbasetemplate=0
parenttemplate=Struct (3)
previewmode=0
readmodewhereclause=(VersionState = 2)
rebuilt_stubs=
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-10-13 03:23:26.875
req_sequenceid=8265
req_startticks=1728789806875
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_84EA26AAADB2B0DE646545F5C0CE0978.cfusion
sessionstring=1_84EA26AAADB2B0DE646545F5C0CE0978.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=2
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-10-13 03:23:26'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=C2d0WfyMqe4K39HASmncTw==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=5DF9247FF12CC46926C7742C0806934651A98BAE
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=23649
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1728789806891
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=84EA26AAADB2B0DE646545F5C0CE0978.cfusion
sessionstring=1_84EA26AAADB2B0DE646545F5C0CE0978.cfusion
urltoken=CFID=9631310&CFTOKEN=b032590ccfd50f96-2705F7C1-A543-DCFF-4459949549D10F52&jsessionid=84EA26AAADB2B0DE646545F5C0CE0978.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 16 ms