File Types and Names

Distribution Files

Survey datasets are distributed as compressed .ZIP files. A distribution .ZIP file contains multiple working files which generally include a data file, various data definition files, and other documentation. This page includes instructions on how to work with distribution .ZIP files. The video below provides a quick introduction to DHS datasets.

On this page
Distribution File Naming Convention
Country Codes
Data File Type Codes
Data Version Codes
File Format Codes
Data Structure Codes  

Working Files

The types of "working files" that are contained in each distributed .ZIP file include a data file, various data definitions, and other documentation. The exact type of files that are included will vary depending on the associated data type and file format.

Working files must be extracted from the distributed .ZIP file.  The files can be extracted using PKUNZIP, Winzip, or other data compression software. You can download the Winzip Evaluation Version for free.

Types of Working Files
Examples of Working File Types

Distribution File Naming Convention

An individual .ZIP file is distributed for each dataset type (e.g. household, women, men, children, couples, etc.) and file format (e.g. hierarchical, flat, SPSS, SAS, Stata.) Each .ZIP distribution file is uniquely named with a standard naming convention. The video below provides guidance to new users understanding the standard naming conventions used in our downloadable datasets. 

Dataset files are named according to the following convention: [CC][DD][VV][FF][DS].ZIP

Code Description:
[CC] Country Code
[DD] Dataset Type (e.g. HR-Household, PR-Household Member, IR-Women, MR-Men, BR-Births, KR-Children under 5, and CR-couples)
[VV] Dataset Version (First Character - DHS Phase) (Second Character - Release version)
[FF] File Format (eg. FL-Flat, SV-SPSS, DT-Stata, SD-SAS)
[DS] Data Structure for SPA (SR: SPA Recode | SP: SPA Raw)

Example:
To give an example of how distribution files for a survey are organized, the following table shows the available files, along with the names that they are given for the Kenya 2003 DHS survey.

Kenya 2003 DHS Survey
  ASCII File Types Software-Specific Data File Types
Unit of Analysis Hierarchical Flat SAS SPSS Stata
Households   KEHR42FL.ZIP KEHR42SD.ZIP KEHR42SV.ZIP KEHR42DT.ZIP
Household Members   KEPR42FL.ZIP KEPR42SD.ZIP KEPR42SV.ZIP KEPR42DT.ZIP
Women KEIR42.ZIP KEIR42FL.ZIP KEIR42SD.ZIP KEIR42SV.ZIP KEIR42DT.ZIP
Men KEMR42.ZIP KEMR42FL.ZIP KEMR42SD.ZIP KEMR42SV.ZIP KEMR42DT.ZIP
Births   KEBR42FL.ZIP KEBR42SD.ZIP KEBR42SV.ZIP KEBR42DT.ZIP
Children   KEKR42FL.ZIP KEKR42SD.ZIP KEKR42SV.ZIP KEKR42DT.ZIP
Couples   KECR42FL.ZIP KECR42SD.ZIP KECR42SV.ZIP KECR42DT.ZIP
HIV Test Results KEAR42.ZIP KEAR42FL.ZIP KEAR42SD.ZIP KEAR42SV.ZIP KEAR42DT.ZIP


The following reference tables contain the descriptions for the four different types of filename codes (country, data type, data version, and file format).
 

Country Codes (includes India State Codes) - [CC]DDVVFFDS.ZIP

CC: Country Code Description
 
Code Country Name Code Country Name
AF Afghanistan LB Liberia
AL Albania MD Madagascar
AO Angola MW Malawi
AM Armenia MV Maldives
AZ Azerbaijan ML Mali
BD Bangladesh MR Mauritania
BJ Benin MX Mexico
BO Bolivia MB Moldova
BT Botswana MA Morocco
BR Brazil MZ Mozambique
BF Burkina Faso MM Myanmar
BU Burundi NM Namibia
KH Cambodia NP Nepal
CM Cameroon NC Nicaragua
CV Cape Verde NI Niger
CF Central African Republic NG Nigeria
TD Chad OS Nigeria (Ondo State)
CO Colombia PK Pakistan
KM Comoros PY Paraguay
CG Congo PE Peru
CD Congo Democratic Republic PH Philippines
CI Cote d'Ivoire RW Rwanda
DR Dominican Republic WS Samoa
EC Ecuador ST Sao Tome and Principe
EG Egypt SN Senegal
ES El Salvador SL Sierra Leone
EK Equatorial Guinea ZA South Africa
ER Eritrea LK Sri Lanka
ET Ethiopia SD Sudan
GA Gabon SZ Swaziland
GM Gambia TJ Tajikistan
GH Ghana TZ Tanzania
GU Guatemala TH Thailand
GN Guinea TL Timor-Leste
GY Guyana TG Togo
HT Haiti TT Trinidad and Tobago
HN Honduras TN Tunisia
IA India TR Turkey
ID Indonesia TM Turkmenistan
JO Jordan UG Uganda
KK Kazakhstan UA Ukraine
KE Kenya UZ Uzbekistan
KY Kyrgyz Republic VN Vietnam
LA Lao People's Democratic Republic YE Yemen
LS Lesotho ZM Zambia
    ZW Zimbabwe
India States
 
Code State Name Code State Name
AP Andhra Pradesh AR Arunachal Pradesh
AS Assam BH Bihar
DL Delhi GJ Gujarat
GO Goa HP Himachal Pradesh
HR Haryana JM Jammu
KA Karnataka. KE Kerala
MG Meghalaya MH Maharastra
MN Manipur MP Madhya Pradesh
MZ Mizoram NA Nagaland
OR Orissa PJ Punjab
RJ Rajasthan TN Tamil Nadu
TR Tripura UP Uttar Pradesh
WB West Bengal SK Sikkim

Data File Types - CC[DD]VVFFDS.ZIP

DD: Data File Types
 
Data Type Description Category
BR Births Recode Household survey recode
CR Couples' Recode Household survey recode
GR Pregnancies Recode Household survey recode
HR Household Recode Household survey recode
IR Individual Recode Household survey recode
KR Children's Recode Household survey recode
MR Men's Recode Household survey recode
NR Pregnancy and Postnatal Care Recode Household survey recode
PR Household Member Recode Household survey recode
SR Siblings Recode Household survey recode
XR Child Under 5 Recode Household survey recode
AH Adult Health Household survey raw
BQ Births Raw Household survey raw
CH Children's Raw Household survey raw
CP Couples' Raw Household survey raw
EX Experimental Household survey raw
FW Fieldworker Questionnaire Household survey raw
HH Household Raw Household survey raw
HW Height and Weight Scores - WHO Child Growth Standards Household survey raw
ID In-depth Household survey raw
IH Individual/Household Raw Household survey raw
IQ Individual Raw Household survey raw
ML Men's Raw Household survey raw
OD Other Data Household survey raw
PQ Household Member Raw Household survey raw
SM Safe Motherhood Household survey raw
SQ Service Availability Raw Household survey raw
VA Verbal Autopsy Household survey raw
WI Wealth Index Household survey raw
WS Women's Status Household survey raw
XP Expenditure Household survey raw
AR HIV Test Results Recode HIV/Other biomarkers
HT HIV Test Results Raw HIV/Other biomarkers
OB Other Biomarkers HIV/Other biomarkers
GC Geospatial Covariates GIS
GE Geographic Data GIS
AN Antenatal Care Facility survey/SPA
AT ART Facility survey/SPA
CL Unit Check List Facility survey/SPA
CN Consultations Facility survey/SPA
CS Country Specific Facility survey/SPA
CT VCT Facility survey/SPA
FC Facility Facility survey/SPA
FP Family Planning Facility survey/SPA
IN Safe Injection Facility survey/SPA
IP Inpatient Unit Facility survey/SPA
LB Laboratory Facility survey/SPA
LD Labor Delivery Facility survey/SPA
MS Health Information System Facility survey/SPA
OI Outpatient/inpatient Facility survey/SPA
OP Outpatient Unit Facility survey/SPA
PH Pharmacy Facility survey/SPA
PI Personal Interview Facility survey/SPA
PM PMTCT Facility survey/SPA
PV Provider Facility survey/SPA
SC Sick Child Facility survey/SPA
SI Sexually Transmitted Infections Facility survey/SPA
SL Staff/Provider Listing Facility survey/SPA
TB TB data Facility survey/SPA
CO Community Community survey
VR Village Recode Community survey

Data Versions - CCDD[VV]FFDS.ZIP

VV: Version Number
 
Version No. Description
Phase 1
0(0 - 9) First survey conducted under DHS-I

00 - Release version 0
01 - Release version 1
02 - Release version 2
03 - Release version 3
[...]
Phase 2
2(0- 9) First survey conducted under DHS-II

20 - Release version 0
21 - Release version 1
22 - Release version 2
23 - Release version 3
[...]
Phase 3
3(0 - 9) First survey conducted under DHS-III

30 - Release Version 0
31 - Release version 1
32 - Release version 2
33 - Release version 3
[...]
3(A - H) Second survey conducted under DHS-III

3H - Release Version 0
3A - Release version 1
3B - Release version 2
3C - Release version 3
[...]
3(I - Q) Third survey conducted under DHS-III

3Q - Release Version 0
3I - Release version 1
3J - Release version 2
3K - Release version 3
[...]
Phase 4
4(0 - 9) First survey conducted under DHS-IV

40 - Release Version 0
41 - Release version 1
42 - Release version 2
43 - Release version 3
[...]
4(A - H) Second survey conducted under DHS-IV

4H - Release Version 0
4A - Release version 1
4B - Release version 2
4C - Release version 3
[...]
4(I - Q) Third survey conducted under DHS-IV

4Q - Release Version 0
4I - Release version 1
4J - Release version 2
4K - Release version 3
[...]
Phase 5
5(0 - 9) First survey conducted under DHS-V

50 - Release Version 0
51 - Release version 1
52 - Release version 2
53 - Release version 3
[...]
5(A - H) Second survey conducted under DHS-V

5H - Release Version 0
5A - Release version 1
5B - Release version 2
5C - Release version 3
[...]
5(I - Q) Third survey conducted under DHS-V

5Q - Release Version 0
5I - Release version 1
5J - Release version 2
5K - Release version 3
[...]
5(R - Z) Fourth survey conducted under DHS-V

5Z - Release version 0
5R - Release version 1
5S - Release version 2
5T - Release version 3
[...]
Phase 6
6(0 - 9) First survey conducted under DHS-VI

60 - Release Version 0
61 - Release version 1
62 - Release version 2
63 - Release version 3
[...]
6(A - H) Second survey conducted under DHS-VI

6H - Release Version 0
6A - Release version 1
6B - Release version 2
6C - Release version 3
[...]
6(I - Q) Third survey conducted under DHS-VI

6Q - Release Version 0
6I - Release version 1
6J - Release version 2
6K - Release version 3
[...]
6(R - Z) Fourth survey conducted under DHS-VI

6Z - Release version 0
6R - Release version 1
6S - Release version 2
6T - Release version 3
[...]
Phase 7
7(0 - 9) First survey conducted under DHS-VII

70 - Release Version 0
71 - Release version 1
72 - Release version 2
73 - Release version 3
[...]
7(A - H) Second survey conducted under DHS-VII

7H - Release Version 0
7A - Release version 1
7B - Release version 2
7C - Release version 3
[...]
7(I - Q) Third survey conducted under DHS-VII

7Q - Release Version 0
7I - Release version 1
7J - Release version 2
7K - Release version 3
[...]
7(R - Z) Fourth survey conducted under DHS-VII

7Z - Release version 0
7R - Release version 1
7S - Release version 2
7T - Release version 3
[...]
Phase 8
8(0 - 9) First survey conducted under DHS-VIII

80 - Release Version 0
81 - Release version 1
82 - Release version 2
83 - Release version 3
[...]
8(A - H) Second survey conducted under DHS-VIII

8H - Release Version 0
8A - Release version 1
8B - Release version 2
8C - Release version 3
[...]
8(I - Q) Third survey conducted under DHS-VIII

8Q - Release Version 0
8I - Release version 1
8J - Release version 2
8K - Release version 3
[...]
8(R - Z) Fourth survey conducted under DHS-VIII

8Z - Release version 0
8R - Release version 1
8S - Release version 2
8T - Release version 3
[...]

File Formats - CCDDVV[FF]DS.ZIP

FF: Format of the Data

Format Code
Description
__ Hierarchical (no format indicator)
FL Flat Data File
SV SPSS Data File
DT Stata Data File
SD SAS Data File

Data Structures - CCDDVVFF[DS].ZIP

DS: Data Structure for SPA Surveys 

Structure Code
Description
SP SPA Raw Data
SR SPA Recode Data


Types of Working Files

The following reference table lists the types of working files that are included in a distributed dataset .ZIP file, depending of the data format.

XXX: File Extension

File Extension Description Flat ASCII File Hierarchical File SPSS Data File SAS Data File Stata Data File Notes
.DAT ASCII data file YES YES



.DCF Dictionary file for use with CSPro YES YES


not in all files
.DCT Stata dictionary file (syntax) YES




.DO Stata syntax file YES




.DOC Microsoft word document with country information YES YES YES YES YES
.DTA STATA system file



YES
.FRQ Unweighted frequency distribution (open with a text editor) YES YES YES YES YES
.FRW Weighted frequency distribution (open with a text editor) YES YES YES YES YES
.MAP File layout or codebook (open with a text editor) YES YES YES YES YES
.SAS SAS data description file (syntax) YES




.SAV SPSS system file

YES


.SAS7BDAT    SAS system file


YES

.SPS SPSS data description file (syntax) YES




Please note that the .DOC file is only present in the Individual Recode(IR) and Men's Recode(MR) files.

Examples of Working File Types

Using the Kenya 2003 MEASURE DHS+ as an example, the following table shows the Individual Recode files distributed for each file format.

Kenya 2003 MEASURE DHS+
Hierarchical Data (KEIR41) Flat ASCII Data (KEIR41FL) SPSS Data File (KEIR41SV) SAS Data File (KEIR41SD) Stata Data File (KEIR41DT)
n/a n/a SPSS data file (.SAV) SAS data file (.SAS7BDAT) Stata data file (.DTA)
ASCII data file (.DAT) ASCII data file (.DAT) n/a n/a n/a
Dictionary file for use with CSPro (.DCF) Dictionary file for use with CSPro (.DCF) n/a n/a n/a
n/a Stata dictionary file (.DCT) n/a n/a n/a
n/a Stata syntax file (.DO) n/a n/a n/a
n/a SAS data description file (syntax) (.SAS) n/a n/a n/a
n/a SPSS data description file (syntax) (.SPS) n/a n/a n/a
File layout or codebook (.MAP)*
Unweighted frequency distribution (.FRQ)*
Weighted frequency distribution (.FRW)*
Microsoft word document with country information (.DOC)

* .MAP, .FRQ and .FRW files may be opened using an ASCII text editor, such as Notepad.

Download Datasets

The DHS Program is authorized to distribute, at no cost, unrestricted survey data files for legitimate academic research. Registration is required for access to data.

Guide to Using Datasets


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /data/File-Types-and-Names.cfm
Time Stamp 03-Jul-24 01:16 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.129
Host Name 10.0.2.129


Execution Time

Total Time Avg Time Count Template
765 ms 17 ms 45 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
765 ms 17 ms 45 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
516 ms 516 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
516 ms 516 ms 1 C:/inetpub/wwwroot/dhs/data/File-Types-and-Names.cfm
454 ms 454 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
438 ms 438 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
438 ms 438 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
438 ms 438 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
438 ms 438 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
390 ms 35 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
390 ms 390 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
171 ms 171 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c1378-l70-t51-dAny.read
78 ms 78 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10136-l70-t51-dAny.read
63 ms 63 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c1433-l70-t51-dAny.read
63 ms 63 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
63 ms 63 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
62 ms 62 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
32 ms 32 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19154-l70-t51-dAny.read
31 ms 16 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(9816, 27193) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19174-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19152-l70-t51-dAny.read
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19155-l70-t51-dAny.read
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/dhs/data/Application.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/5/p9816-c10131-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10138-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10141-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10330-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10334-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10335-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c1432-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19153-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19177-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c49703-l70-t27356-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c49731-l70-t27356-dAny.read
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/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/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/startup/site-application-meat.cfm
0 ms 0 ms 17 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 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.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-application.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/data/customcf/data_file_types.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(9816) ] 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 5 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(2352, 5, 2, 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(9816, 5, 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], 5, 9816, 2352, 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(5) ] 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, 5) ] 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(9816) ] 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(5) ] 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 3 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(2352) ] 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-Data-Template.cfm, 2352, 5) ] 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=5)) ] 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(9816, 5) ] 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/public_api/livebookmarks.cfc | getTags(9816) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
547 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

get (Datasource=dhs_legacy_live, Time=0ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 01:16:53.053
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=47ms, Records=3803) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 01:16:53.053
		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) = 2352
Parameter #4(CF_SQL_INTEGER) = 9816
Parameter #5(CF_SQL_INTEGER) = 2

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

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

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

ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=116) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 01:16:53.053
		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) = 2352
Parameter #4(CF_SQL_INTEGER) = 9816

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 01:16:53.053
		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=1) in C:\inetpub\wwwroot\commonspot\controls\upfront-generic.cfm @ 01:16:53.053
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=9816 OR (PageID IN (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 @ 01:16:53.053
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9816

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

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

qtypes (Datasource=dhs_legacy_live, Time=0ms, Records=61) in C:\inetpub\wwwroot\dhs\data\customcf\data_file_types.cfm @ 01:16:53.053
SELECT File_Data_Type_ID,File_Data_Type_Code,File_Data_Type_Name,File_data_flag,File_Data_Type_Cat
FROM File_Data_Type
WHERE File_Data_Type_Cat IS NOT NULL
ORDER BY File_Data_Type_Cat desc, File_Data_Type_Code  
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:16:53.053
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9816

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

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


Scope Variables

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\data\File-Types-and-Names.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/File-Types-and-Names.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\File-Types-and-Names.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.2.129
REMOTE_HOST=10.0.2.129
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/data/File-Types-and-Names.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=00F6033F0C009512C10D9F5507629A49C1D8EF35
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=43
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=3174221312
cs_runningdashboardcmdcode=0
csrftoken=00F6033F0C009512C10D9F5507629A49C1D8EF35
ctrl_data=Struct (104)
customcf_data=Struct (2)
customcfupfront=Query (1)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-07-03 01:16:53
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719969413480
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-03 01:16:53.465
req_sequenceid=55717
req_startticks=1719969413465
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_9AF5FA4FA145382FE7AB695ABBEDDF7A.cfusion
sessionstring=1_9AF5FA4FA145382FE7AB695ABBEDDF7A.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=5
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-07-03 01:16:53'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=00F6033F0C009512C10D9F5507629A49C1D8EF35
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=9816
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719969413480
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=9AF5FA4FA145382FE7AB695ABBEDDF7A.cfusion
sessionstring=1_9AF5FA4FA145382FE7AB695ABBEDDF7A.cfusion
urltoken=CFID=2270567&CFTOKEN=7072b4023a975281-9DA85390-0A49-AE49-FA4D0ED1263FD615&jsessionid=9AF5FA4FA145382FE7AB695ABBEDDF7A.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 31 ms