Survey Datasets Files

Nepal: SPA, 2015
This page shows a listing of all dataset files available for the selected survey.
If you are a registered user, please login here to gain access to these files.
If you are not a registered user, please go here to register.
SPA Datasets
File Name File Size File Format
Antenatal Care Recode
NPAN71DTSR.ZIP 352 KB Stata dataset (.dta)
NPAN71FLSR.ZIP 371 KB Flat ASCII data (.dat)
NPAN71SDSR.ZIP 384 KB SAS dataset (.sas7bdat)
NPAN71SVSR.ZIP 366 KB SPSS dataset (.sav)
Country Specific Recode
NPCS71DTSR.ZIP 571 KB Stata dataset (.dta)
NPCS71FLSR.ZIP 609 KB Flat ASCII data (.dat)
NPCS71SDSR.ZIP 591 KB SAS dataset (.sas7bdat)
NPCS71SVSR.ZIP 585 KB SPSS dataset (.sav)
Facility Recode
NPFC71DTSR.ZIP 751 KB Stata dataset (.dta)
NPFC71FLSR.ZIP 885 KB Flat ASCII data (.dat)
NPFC71SDSR.ZIP 892 KB SAS dataset (.sas7bdat)
NPFC71SVSR.ZIP 764 KB SPSS dataset (.sav)
Family Planning Recode
NPFP71DTSR.ZIP 316 KB Stata dataset (.dta)
NPFP71FLSR.ZIP 344 KB Flat ASCII data (.dat)
NPFP71SDSR.ZIP 333 KB SAS dataset (.sas7bdat)
NPFP71SVSR.ZIP 322 KB SPSS dataset (.sav)
Provider Recode
NPPV71DTSR.ZIP 433 KB Stata dataset (.dta)
NPPV71FLSR.ZIP 454 KB Flat ASCII data (.dat)
NPPV71SDSR.ZIP 507 KB SAS dataset (.sas7bdat)
NPPV71SVSR.ZIP 437 KB SPSS dataset (.sav)
Sick Child Recode
NPSC71DTSR.ZIP 388 KB Stata dataset (.dta)
NPSC71FLSR.ZIP 410 KB Flat ASCII data (.dat)
NPSC71SDSR.ZIP 443 KB SAS dataset (.sas7bdat)
NPSC71SVSR.ZIP 424 KB SPSS dataset (.sav)
Staff/Provider Listing Recode
NPSL71DTSR.ZIP 268 KB Stata dataset (.dta)
NPSL71FLSR.ZIP 269 KB Flat ASCII data (.dat)
NPSL71SDSR.ZIP 278 KB SAS dataset (.sas7bdat)
NPSL71SVSR.ZIP 276 KB SPSS dataset (.sav)
Antenatal Care Raw
NPAN71DTSP.ZIP 168 KB Stata dataset (.dta)
NPAN71FLSP.ZIP 191 KB Flat ASCII data (.dat)
NPAN71SDSP.ZIP 194 KB SAS dataset (.sas7bdat)
NPAN71SVSP.ZIP 216 KB SPSS dataset (.sav)
Country Specific Raw
NPCS71DTSP.ZIP 202 KB Stata dataset (.dta)
NPCS71FLSP.ZIP 231 KB Flat ASCII data (.dat)
NPCS71SDSP.ZIP 222 KB SAS dataset (.sas7bdat)
NPCS71SVSP.ZIP 221 KB SPSS dataset (.sav)
Facility Raw
NPFC71DTSP.ZIP 589 KB Stata dataset (.dta)
NPFC71FLSP.ZIP 666 KB Flat ASCII data (.dat)
NPFC71SDSP.ZIP 804 KB SAS dataset (.sas7bdat)
NPFC71SVSP.ZIP 606 KB SPSS dataset (.sav)
Family Planning Raw
NPFP71DTSP.ZIP 123 KB Stata dataset (.dta)
NPFP71FLSP.ZIP 153 KB Flat ASCII data (.dat)
NPFP71SDSP.ZIP 140 KB SAS dataset (.sas7bdat)
NPFP71SVSP.ZIP 156 KB SPSS dataset (.sav)
Provider Raw
NPPV71DTSP.ZIP 253 KB Stata dataset (.dta)
NPPV71FLSP.ZIP 265 KB Flat ASCII data (.dat)
NPPV71SDSP.ZIP 362 KB SAS dataset (.sas7bdat)
NPPV71SVSP.ZIP 304 KB SPSS dataset (.sav)
Sick Child Raw
NPSC71DTSP.ZIP 202 KB Stata dataset (.dta)
NPSC71FLSP.ZIP 236 KB Flat ASCII data (.dat)
NPSC71SDSP.ZIP 242 KB SAS dataset (.sas7bdat)
NPSC71SVSP.ZIP 278 KB SPSS dataset (.sav)
Staff/Provider Listing Raw
NPSL71DTSP.ZIP 173 KB Stata dataset (.dta)
NPSL71FLSP.ZIP 200 KB Flat ASCII data (.dat)
NPSL71SDSP.ZIP 204 KB SAS dataset (.sas7bdat)
NPSL71SVSP.ZIP 184 KB SPSS dataset (.sav)
Geographic Datasets
File Name File Size File Format
Geographic Data
NPGE71FLSR.ZIP 73.1 KB Shape file (.shp)


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /data/dataset/Nepal_SPA_2015.cfm
Time Stamp 22-Jul-24 08:50 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.2.138
Host Name 10.0.2.138


Execution Time

Total Time Avg Time Count Template
2141 ms 79 ms 27 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
2126 ms 79 ms 27 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
937 ms 937 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
937 ms 937 ms 1 C:/inetpub/wwwroot/dhs/data/dataset/Nepal_SPA_2015.cfm
844 ms 844 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
797 ms 797 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
797 ms 797 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
797 ms 797 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
797 ms 797 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
750 ms 75 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
750 ms 750 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
688 ms 688 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c1378-l70-t51-dAny.read
672 ms 672 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c8022-l70-t51-dAny.read
641 ms 641 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
594 ms 594 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
468 ms 468 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/data/dataset_detail_display.cfm
126 ms 63 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(24993, 8024) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
78 ms 78 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/dhs/data/dataset/Application.cfm
32 ms 32 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19155-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
16 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19153-l70-t51-dAny.read
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
15 ms 4 ms 4 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(24993) ] 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/34/p24993-c1432-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19152-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19154-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19177-l70-t51-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/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/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/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/upfront-ghost-queries.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 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 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/verify-stub-data.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/survey/countries_functions.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(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(2352) ] 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(24993) ] 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(8021) ] 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(1, 1, 0, 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(24993, 34, 8021, 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 | GetPageCacheStatus(8021, 34, 2352, 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], 34, 24993, 8021, 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(34) ] 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, 34) ] 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(24993) ] 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(34) ] 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 | LoadTemplateProperties(template-dataset-access.cfm, 8021, 34) ] 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(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=34)) ] 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/visitor-context-rule-actions.cfc | onPageVisit(24993, 34) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
984 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

get (Datasource=dhs_legacy_live, Time=16ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 08:50:06.006
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=63ms, Records=2663) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 08:50:06.006
		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) = 2
Parameter #3(CF_SQL_INTEGER) = 24993
Parameter #4(CF_SQL_INTEGER) = 2352
Parameter #5(CF_SQL_INTEGER) = 8021
Parameter #6(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 08:50:06.006
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=24993 OR (PageID IN (8021,2352,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 @ 08:50:06.006
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 24993

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

qry (Datasource=commonspot-site-dhs, Time=15ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 08:50:06.006
		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) = 24993
Parameter #2(CF_SQL_INTEGER) = 11

Request.GetGhost (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\upfront-ghost-queries.cfm @ 08:50:06.006
	SELECT *
	  FROM Data_Ghost_Common
	 WHERE (PageID=24993 OR (PageID IN (8021,2352,2,1) AND (VersionState = 2)))
	ORDER BY ControlID, PageID DESC
ControlInstanceData (Datasource=commonspot-site-dhs, Time=16ms, Records=79) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 08:50:06.006
		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) = 2
Parameter #3(CF_SQL_INTEGER) = 24993
Parameter #4(CF_SQL_INTEGER) = 2352
Parameter #5(CF_SQL_INTEGER) = 8021

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 08:50:06.006
		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 @ 08:50:06.006
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=24993 OR (PageID IN (8021,2352,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 @ 08:50:06.006
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 24993

qry (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 08:50:06.006
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 24993

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

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

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

qSPADatasets (Datasource=, Time=0ms, Records=120) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
select name, size, 1 as scode
from qSPADatasets
where name like '%SR.ZIP%'

UNION

select name, size, 2 as scode
from qSPADatasets
where name like '%SP.ZIP%'

order by scode, name
getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=32ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=31ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:06.006
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=47ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'PV'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:07.007
			  SELECT File_Data_Type_Name
			  FROM File_Data_Type
			  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GE

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:50:07.007
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

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

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:50:07.007
		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=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:50:07.007
		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_dataset_disp (Datasource=dhs_legacy_live, Time=15ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:50:06.006

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  400    
    
resultsets
nameresultset
 qMetadata  1
 qDatasets  2
 qGPSDatasets  3
 qHIVDatasets  4
 qSPADatasets  5


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-23 01:30: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\data\dataset\Nepal_SPA_2015.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=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/data/dataset/Nepal_SPA_2015.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\data\dataset\Nepal_SPA_2015.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.2.138
REMOTE_HOST=10.0.2.138
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/data/dataset/Nepal_SPA_2015.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=8B9606D0588B20837153A2A0EE18150DBCFEC2B6
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=24
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=2673962984
cs_runningdashboardcmdcode=0
csrftoken=8B9606D0588B20837153A2A0EE18150DBCFEC2B6
ctrl_data=Struct (79)
customcf_data=Struct (2)
customcfupfront=Query (2)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
data_ghost=Struct (0)
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-22 08:50:06
getghost=Query (0)
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1721638206524
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
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 (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
previewmode=0
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-22 08:50:06.508
req_sequenceid=276983
req_startticks=1721638206508
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_5511B2AC08BC10FB934868FC1D19C1D0.cfusion
sessionstring=1_5511B2AC08BC10FB934868FC1D19C1D0.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=34
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-07-22 08:50:06'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (31)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
SURVEYINFO_ACTIVE_DATE=2024-7-24
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=8B9606D0588B20837153A2A0EE18150DBCFEC2B6
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=24993
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1721638206524
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=5511B2AC08BC10FB934868FC1D19C1D0.cfusion
sessionstring=1_5511B2AC08BC10FB934868FC1D19C1D0.cfusion
urltoken=CFID=3369987&CFTOKEN=4bb7145e214f8e7d-80551574-E1EE-BE37-2523B154E95DD81D&jsessionid=5511B2AC08BC10FB934868FC1D19C1D0.cfusion
usagelist=
user=Struct (31)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 32 ms