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
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
PR Household Member 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
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(1 - 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(1 - 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 Standard 2018,0,07,316715
Template /data/File-Types-and-Names.cfm
Time Stamp 17-Oct-21 11:51 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 3.237.16.210
Host Name 3.237.16.210


Execution Time

Total Time Avg Time Count Template
1204 ms 27 ms 45 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
1171 ms 26 ms 45 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
762 ms 762 ms 1 C:/inetpub/wwwroot/dhs/data/File-Types-and-Names.cfm
756 ms 756 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
625 ms 625 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
611 ms 611 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
610 ms 610 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
609 ms 609 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
609 ms 609 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
583 ms 583 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
578 ms 53 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
298 ms 298 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c1378-l70-t51-dAny.read
80 ms 80 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10136-l70-t51-dAny.read
71 ms 71 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
69 ms 69 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
60 ms 60 ms 1 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
55 ms 55 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c1433-l70-t51-dAny.read
52 ms 52 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
52 ms 52 ms 1 C:/inetpub/wwwroot/dhs/data/Application.cfm
51 ms 51 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
46 ms 15 ms 3 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
36 ms 36 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
35 ms 35 ms 1 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10138-l70-t51-dAny.read
27 ms 27 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19154-l70-t51-dAny.read
26 ms 26 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19152-l70-t51-dAny.read
26 ms 26 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19153-l70-t51-dAny.read
23 ms 23 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19155-l70-t51-dAny.read
23 ms 23 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
17 ms 9 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:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
14 ms 14 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
13 ms 13 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10131-l70-t51-dAny.read
13 ms 13 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10141-l70-t51-dAny.read
13 ms 13 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10330-l70-t51-dAny.read
12 ms 12 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10334-l70-t51-dAny.read
12 ms 12 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c10335-l70-t51-dAny.read
9 ms 9 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
8 ms 8 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19174-l70-t51-dAny.read
8 ms 8 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c49731-l70-t27356-dAny.read
8 ms 8 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
7 ms 7 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c49703-l70-t27356-dAny.read
7 ms 7 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-stub.cfm
6 ms 6 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19169-l70-t51-dAny.read
6 ms 6 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
5 ms 5 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19172-l70-t51-dAny.read
5 ms 5 ms 1 C:/inetpub/wwwroot/commonspot/utilities/set-style-vars.cfm
5 ms 5 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
4 ms 4 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c1432-l70-t51-dAny.read
4 ms 4 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p9816-c19177-l70-t51-dAny.read
4 ms 4 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
4 ms 4 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
4 ms 4 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
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 9816) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(9816) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
3 ms 3 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
3 ms 3 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
3 ms 3 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
2 ms 1 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/style/load-page-classes.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile.cfm
2 ms 1 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/dhs/data/customcf/data_file_types.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile-meat.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
1 ms 1 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
1 ms 1 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
1 ms 1 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
1 ms 1 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
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(2352) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
1 ms 1 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
1 ms 1 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
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Element) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
1 ms 1 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 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.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/session-first-site.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/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 13 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/item-visible.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-page-stub.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/data/template-Data-Template.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(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 3 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 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 5, 9816, 2352, 0, 0, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus(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 | 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/subsite-cache-manager.cfc | getLatest() ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getSecurityPageIDMap([complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/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) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc | getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('site' Remote Requests processed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('user' Remote Requests processed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(CGI variable processing) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(New (global) session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request object updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request.Params initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(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(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(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(Keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(LiveBookmarks) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc | onPageVisit(9816, 5) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.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
12 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
826 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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

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

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

CacheInfo (Datasource=commonspot-site-dhs, Time=3ms, Records=52) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 11:51:06.006
			SELECT *
			  FROM ElementInstance
			 WHERE SubsiteID=?
				AND PageID=?
				AND IsWIP=? 
				AND ServerID=? 
		 ORDER BY ControlID DESC,CacheLevel
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5
Parameter #2(CF_SQL_INTEGER) = 9816
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1

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

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

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

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

qParentTemplateInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 11:51:07.007
			SELECT PageType
			  FROM SitePages
			 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2352

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 11:51:07.007
					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 @ 11:51:07.007
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,3,11,14,15))
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9816

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

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

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

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

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

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

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

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

CheckCustomRender (Datasource=commonspot-site-dhs, Time=0ms, Records=22) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 11:51:07.007
		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 9816
Parameter #5(CF_SQL_INTEGER) = 2

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

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

PagePermissions (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\cache\item-security-cache.cfc @ 11:51:07.007
			SELECT *
			  FROM ItemSecurity
			 WHERE PageID = ?
				AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9816

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=1ms, Records=22) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 11:51:07.007
		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=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 11:51:07.007
			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=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 11:51:07.007
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9816

testQuery (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 11:51:07.007
		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=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 11:51:07.007
		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=2ms, Records=119) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 11:51:07.007
		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 @ 11:51:07.007
		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=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\controls\upfront-generic.cfm @ 11:51:07.007
	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 @ 11:51:07.007
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9816

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 11:51:07.007
		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 @ 11:51:07.007
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2352

qtypes (Datasource=dhs_legacy_live, Time=1ms, Records=57) in C:\inetpub\wwwroot\dhs\data\customcf\data_file_types.cfm @ 11:51:07.007
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 @ 11:51:07.007
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9816

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 11:51:07.007
		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 @ 11:51:07.007
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2352

CacheUpdate (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 11:51:07.007
					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) = 2121-10-17 11:51:06
Parameter #3(CF_SQL_VARCHAR) = 2121-10-17 11:51:06
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) = 5
Parameter #18(CF_SQL_INTEGER) = 9816
Parameter #19(CF_SQL_INTEGER) = 0
Parameter #20(CF_SQL_INTEGER) = 2
Parameter #21(CF_SQL_INTEGER) = 0


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
adf=Struct (88)
adfscheduler=Struct (0)
applicationname=site1
blogcache=Struct (4)
cachedimages=Struct (20)
cacheinfocache=Struct (51)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=6
covid_newsarticlecount=24
covid_pressreleasecount=4
covid_pubcount=2
cs_element_cache=Struct (0)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerscope=Struct (18)
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 (3)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2021-10-17 17:16:40
search_orphan_next_clean=2021-10-17 17:16:41
serverstatus=Struct (1)
site=Struct (71)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
taxonomy=Struct (2)
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=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
CERT_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
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=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
HTTPS_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/data/File-Types-and-Names.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\data\File-Types-and-Names.cfm
QUERY_STRING=
REMOTE_ADDR=3.237.16.210
REMOTE_HOST=3.237.16.210
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/data/File-Types-and-Names.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=1568450
CFTOKEN=f21371ce606104e9-8CE906D1-E558-CB4B-AC46647F097B20D5
Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
autologinhandled=0
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=43
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (124)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_runningdashboardcmdcode=0
ctrl_data=Struct (107)
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 (41)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138
formattedtimestamp=2021-10-17 11:51:06
getghost=
hivbold=1,3,8,9
ignoreauthuser=0
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1634471466906
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (86)
master_cfm_used=1
maxperms=Complex type
metadata=Struct (2)
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (85)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
parentisbasetemplate=0
parenttemplate=Struct (3)
previewmode=0
readmodewhereclause=(VersionState = 2)
rebuilt_stubs=
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (72)
req_cam_callcount=1
req_inittimestamp=2021-10-17 11:51:06.892
req_sequenceid=9555
req_startticks=1634471466892
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_A241F0463456A78D6D0E0B43DE37608D.cfusion
sessionstring=1_A241F0463456A78D6D0E0B43DE37608D.cfusion
sicupfront=
sicupfrontparam=
site=Struct (71)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
subsiteid=5
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2021-10-17 11:51:06'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (27)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (40)
EMAILALERTKEY=Cz/qOdKOVEQwE3OVjxl3UA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=9816
debugmode=0
debugstate=Struct (1)
editmode=0
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1634471466920
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=A241F0463456A78D6D0E0B43DE37608D.cfusion
urltoken=CFID=1568450&CFTOKEN=f21371ce606104e9-8CE906D1-E558-CB4B-AC46647F097B20D5&jsessionid=A241F0463456A78D6D0E0B43DE37608D.cfusion
usagelist=
user=Struct (27)
Debug Rendering Time: 24 ms