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:47 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
9250 ms 343 ms 27 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
9250 ms 343 ms 27 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
3844 ms 3844 ms 1 C:/inetpub/wwwroot/dhs/data/dataset/Nepal_SPA_2015.cfm
3828 ms 3828 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
3515 ms 3515 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
3500 ms 3500 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
3500 ms 3500 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
3500 ms 3500 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
3500 ms 3500 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
3391 ms 339 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
3391 ms 3391 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
2719 ms 2719 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c1378-l70-t51-dAny.read
2672 ms 2672 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c8022-l70-t51-dAny.read
2594 ms 2594 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
2484 ms 2484 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
2266 ms 2266 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/data/dataset_detail_display.cfm
203 ms 102 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(24993, 8024) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
172 ms 172 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
156 ms 156 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19152-l70-t51-dAny.read
141 ms 141 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
125 ms 125 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
109 ms 109 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19155-l70-t51-dAny.read
94 ms 94 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
93 ms 93 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19154-l70-t51-dAny.read
78 ms 78 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(24993) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
63 ms 63 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19153-l70-t51-dAny.read
32 ms 32 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19172-l70-t51-dAny.read
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/dhs/data/dataset/Application.cfm
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19177-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/upfront-ghost-queries.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p24993-c19169-l70-t51-dAny.read
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.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
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-c19174-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/non-dashboard-include.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/browser-detect-methods.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/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/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
0 ms 0 ms 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 4 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.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/update-page-cache-status.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 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
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(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 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(1) ] 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(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
109 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
3984 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:47:41.041
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=172ms, Records=2663) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 08:47:41.041
		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=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 08:47:41.041
			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=47ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 08:47:41.041
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 24993

testQuery (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:47:41.041
		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:47:41.041
		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=16ms, Records=0) in C:\inetpub\wwwroot\commonspot\upfront-ghost-queries.cfm @ 08:47:41.041
	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:47:41.041
		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:47:41.041
		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:47:41.041
	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=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:47:41.041
		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=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 08:47:41.041
		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:47:41.041
		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:47:41.041
		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:47:41.041
		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:47:41.041
		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:47:41.041
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=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			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:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=31ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

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

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			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:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

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

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			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:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			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:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

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

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			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:47:42.042
      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:47:42.042
			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:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			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:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SC'
			
getFileformat (Datasource=dhs_legacy_live, Time=78ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			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:47:42.042
      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:47:42.042
			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:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

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

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			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:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'SL'
			
getFileformat (Datasource=dhs_legacy_live, Time=47ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      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:47:42.042
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'AN'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:42.042
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

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

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

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

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

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

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'CS'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:43.043
      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:47:43.043
			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:47:43.043
      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:47:43.043
			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:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			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:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			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:47:43.043
      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:47:43.043
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FC'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:43.043
      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:47:43.043
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			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:47:43.043
      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:47:43.043
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:43.043
      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:47:43.043
			SELECT File_Data_Type_Name
			FROM File_Data_Type
			WHERE File_Data_Type_Code = 'FP'
			
getFileformat (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:43.043
      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:47:43.043
			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:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			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:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			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:47:43.043
      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:47:43.043
			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:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=47ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			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:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=31ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			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:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=110ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:43.043
			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:47:43.043
      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:47:43.043
			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:47:43.043
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=31ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:44.044
			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:47:44.044
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:44.044
			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:47:44.044
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:44.044
			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:47:44.044
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

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

getDataType (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:44.044
			  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=16ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 08:47:44.044
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

testQuery (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:47:44.044
		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=32ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 08:47:44.044
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 24993

testQuery (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:47:44.044
		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:47:44.044
		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=31ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:47:44.044
		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=31ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:47:44.044
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

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


Stored Procedures

sp_dataset_disp (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 08:47:41.041

    
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?flag=1
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=flag=1
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=C5E633DDF89620554045F4E86D3F9729AA576780
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=3399914744
cs_runningdashboardcmdcode=0
csrftoken=C5E633DDF89620554045F4E86D3F9729AA576780
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:47:41
getghost=Query (0)
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1721638061267
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 (5)
params_formfields=
params_urlfields=flag
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:47:41.267
req_sequenceid=276548
req_startticks=1721638061267
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_1EF17F42D364E1C3EF222B159AC29234.cfusion
sessionstring=1_1EF17F42D364E1C3EF222B159AC29234.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:47:41'}
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=C5E633DDF89620554045F4E86D3F9729AA576780
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=1721638061282
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=1EF17F42D364E1C3EF222B159AC29234.cfusion
sessionstring=1_1EF17F42D364E1C3EF222B159AC29234.cfusion
urltoken=CFID=3369167&CFTOKEN=a8e8a1dde52f8fc3-803EEB83-09A4-DA4E-E9A034BCF933E5B3&jsessionid=1EF17F42D364E1C3EF222B159AC29234.cfusion
usagelist=
user=Struct (31)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
flag=1
Debug Rendering Time: 31 ms