Publications Summary


Document Type
Methodological Reports
Publication Topic(s)
Fertility and Fertility Preferences, Youth
Language
English
Recommended Citation
Pullum, Thomas W., Trevor Croft, and Kerry L. D. MacQuarrie. 2018. Methods to Estimate Under-15 Fertility Using Demographic and Health Surveys Data. DHS Methodological Reports No. 23. Rockville, Maryland, USA: ICF.
Download Citation
RIS format / Text format / Endnote format
Publication Date
September 2018
Publication ID
MR23

Download

Download this publication

Small PDF IconMethods to Estimate Under-15 Fertility Using Demographic and Health Surveys Data (PDF, 989K)
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:

Early childbearing carries serious risks to the health of both the child and the mother. International guidelines classify births before age 18 as high-risk births, and births before age 15 are of even greater concern. Early marriage and pregnancy are also interpreted as negative indicators of child protection, and may severely limit an adolescent girl’s educational opportunities. DHS surveys are a major source of fertility estimates for age 15-49, the age range of eligibility for the women’s interview and the collection of birth histories. Until recently, DHS surveys were not used for the calculation of fertility rates below age 15. This methodological report provides technical details for calculating fertility rates for age 12-14 and age 10-14 during the 3 years before the survey, and age 10-14 during the 5 years before the survey, the standard time intervals for DHS age-specific fertility rates. The under-15 births, which go into the numerator of the fertility rates, are obtained from the birth histories of women age 15-19 at the time of the survey. The central question is how to deal with the left censoring of under-15 exposure, which goes into the denominator of fertility rates, but is truncated because girls under age 15 are not included in the surveys. To deal with censoring, rates for single years of age 10, 11, 12, 13, and 14 are constructed. DHS does not normally construct single-year rates, but they are of special interest below age 15 and convenient for calculating 3-year and 5-year rates. Single-year rates are only slightly affected by censoring. For example, the mean age observed for age 14 in the past 3 years is only about 12 days higher than 14.5. Pooled rates for age 12-14 or 10-14 are constructed as weighted averages of the single-year rates. Three alternative weighting methods are considered. The first uses information about girls age 10-14, who are included in the household survey but not in the women’s survey. The second uses weights derived from the geometry of a Lexis diagram. These estimates are easier to calculate and are the ones currently available on STATcompiler. The third method is simply the arithmetic average of the single-year rates. These estimates are the easiest to calculate but lack a demographic rationale. The second and third methods, when relevant, also assume that 60% of the total exposure to age 10-14 is to age 12-14. This report applies the alternative approaches to 67 DHS surveys conducted between 2001 and 2016. The three estimates are virtually indistinguishable in almost all surveys. When they differ, the main reasons appear to be that the assumption of 60% is not valid and/or there are irregularities in the reported age distribution that are probably traceable to digit preference or age displacement across the age 15 boundary or potential age displacement related to having an early birth. The first method, which makes the most use of the available data, is most sensitive to data quality. The third method, which makes the least use of available data, is least sensitive to data quality. The report describes simulations of the effect of reducing the minimum age for eligibility from 15 to 14, or to 13, in terms of the expected additional number of under-15 births and the expected improvement in the precision of the estimated rate. The gain from lowering the age range of eligibility below age 15 would be surprisingly small. Most under-15 fertility occurs at age 14, and the birth histories of women 15-19 provide nearly complete information on births at age 14.

Browse

Browse for Publications by:

Browse for Journal Articles based on DHS data by:


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /publications/publication-MR23-Methodological-Reports.cfm
Time Stamp 03-Jul-24 03:32 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.0.0.149
Host Name 10.0.0.149


Execution Time

Total Time Avg Time Count Template
875 ms 875 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
875 ms 875 ms 1 C:/inetpub/wwwroot/dhs/publications/publication-MR23-Methodological-Reports.cfm
844 ms 30 ms 28 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
828 ms 30 ms 28 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
734 ms 734 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
531 ms 531 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
531 ms 531 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
531 ms 531 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
531 ms 531 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
453 ms 41 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
453 ms 453 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
312 ms 312 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c1378-l70-t51-dAny.read
297 ms 297 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
203 ms 203 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
109 ms 109 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
93 ms 93 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
93 ms 93 ms 1 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
79 ms 79 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
63 ms 63 ms 1 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/publication/pub_detail_display.cfm
46 ms 46 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
32 ms 32 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c1433-l70-t51-dAny.read
32 ms 32 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.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/p28817-c19152-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c19154-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c19169-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c50815-l70-t27356-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/publication/citation_ris.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/publications/Application.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(28817, 11243) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c19153-l70-t51-dAny.read
15 ms 15 ms 1 C:/inetpub/wwwroot/dhs/templates/facebook_meta.cfm
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 28817) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(28817) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c1432-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c19155-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/2/p28817-c19177-l70-t51-dAny.read
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.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/dhtmlmenu/menu-output-display.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/handle-styles.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/build-request-params.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/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/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 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.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 1 C:/inetpub/wwwroot/commonspot/utilities/set-style-vars.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-application.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(28817) ] 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(28817, 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, 28817, 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, 28817, 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(28817) ] 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(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(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(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(28817, 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/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
906 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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

inheritedCacheSettings (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:32:20.020
		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:32:20.020
		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=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:32:20.020
			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:32:20.020
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 28817

testQuery (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:32:20.020
		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) = 28817

qryKeywords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\keywords-tags\keywords-tags-base.cfc @ 03:32:20.020
		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) = 28817
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:32:20.020
			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) = 28817
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:32:20.020
	SELECT PageType, SubSiteID, CategoryID, InheritedTemplateList, DocType, Uploaded
	  FROM SitePages
	 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 28817

FormData (Datasource=commonspot-site-dhs, Time=63ms, Records=42) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 03:32:20.020
	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) = 28817
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:32:20.020
	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) = 28817
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:32:20.020
		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) = 28817
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:32:20.020
		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) = 28817
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=15ms, Records=52) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 03:32:20.020
		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) = 28817
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:32:20.020
	SELECT DISTINCT ControlID
	  FROM ItemSecurity
	 WHERE PageID = ?
		AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 28817

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

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=32ms, Records=2058) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 03:32:20.020
		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) = 28817
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:32:20.020
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=28817 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:32:20.020
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 28817

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

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 03:32:20.020
		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) = 28817
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:32:20.020
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 = 'MR23'
getpub_fb (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\templates\facebook_meta.cfm @ 03:32:20.020
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 = 'MR23'
ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=73) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 03:32:20.020
		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) = 28817
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:32:20.020
		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:32:20.020
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=28817 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:32:20.020
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 28817

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:32:20.020
		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:32:20.020
		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:32:20.020
		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:32:20.020
		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

qGetTopicList (Datasource=, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:32:21.021
		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:32:21.021
		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:32:21.021
    SELECT pub_id from pub_catalog where parent_pub_id = 1908 
checkforlinks (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:32:21.021
    SELECT link_pub_ids 
	FROM pub_catalog 
	WHERE pub_id = 1908 
	  AND link_pub_ids is not NULL
    
getpub (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\citation_ris.cfm @ 03:32:21.021
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 = 1908
  AND Pub_Type.Pub_Type_ID IN (15,16,6,18,9,45,11,4,8,12,27,5,26,39,21,30,46)    
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:32:21.021
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 28817

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 03:32:21.021
		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:32:21.021
		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:32:21.021
		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:32:21.021
		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


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1908    
    
resultsets
nameresultset
 qDetails  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=16ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\publication\pub_detail_display.cfm @ 03:32:21.021
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1908    
    
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:32:21.021
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1908    
    
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:32:21.021
    
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=4
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-07-03 12:12:03
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-MR23-Methodological-Reports.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=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=JSESSIONID=EBAD88DD0CF4D5DFAE85EF0F29F92A33.cfusion; CSRFTOKEN=A08DE345133116577954F8AB22D98087CFB10995
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/publications/publication-MR23-Methodological-Reports.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\publications\publication-MR23-Methodological-Reports.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.0.149
REMOTE_HOST=10.0.0.149
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/publications/publication-MR23-Methodological-Reports.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=A08DE345133116577954F8AB22D98087CFB10995
JSESSIONID=EBAD88DD0CF4D5DFAE85EF0F29F92A33.cfusion
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=2517893104
cs_runningdashboardcmdcode=0
csrftoken=A08DE345133116577954F8AB22D98087CFB10995
ctrl_data=Struct (72)
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-07-03 03:32:20
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719977540728
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)
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-07-03 03:32:20.728
req_sequenceid=58738
req_startticks=1719977540728
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_EBAD88DD0CF4D5DFAE85EF0F29F92A33.cfusion
sessionstring=1_EBAD88DD0CF4D5DFAE85EF0F29F92A33.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-07-03 03:32:20'}
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=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=A08DE345133116577954F8AB22D98087CFB10995
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=28817
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719977528822
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=EBAD88DD0CF4D5DFAE85EF0F29F92A33.cfusion
sessionstring=1_EBAD88DD0CF4D5DFAE85EF0F29F92A33.cfusion
urltoken=CFID=2279553&CFTOKEN=1147f0df834bb19a-A280725C-9B59-185A-01AABE7640D8246F&jsessionid=EBAD88DD0CF4D5DFAE85EF0F29F92A33.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 31 ms