Data Quality and Use

One of the primary goals of The DHS Program is to produce high-quality data and make it available for analysis in a coherent and consistent form. However, national surveys in developing countries are prone to incomplete or partial reporting of responses. Additionally, complex questionnaires inevitably allow scope for inconsistent responses to be recorded for different questions. For the analyst this results in a data file containing incomplete or inconsistent data, complicating the analysis considerably.

In order to avoid these problems, The DHS Program has adopted a policy of editing and imputation which results in a data file that accurately reflects the population studied and may be readily used for analysis. Primary data quality policies include:

On This Page

For additional information, see the documents Guide to DHS Statistics and DHS Editing and Imputation located in Data Tools and Manuals.

Missing Values and Other Exceptions

During processing of the survey data and in the survey final reports, there are specific rules on how to deal with missing values and other special circumstances. Knowing these rules helps data users and analysts make sense of the survey data.

A "missing value" is defined as a variable that should have a response, but does not have a response — either because the question 
was not asked (due to interviewer error) or the respondent did not want to answer. The general rule for the survey data processing is that under no circumstances should an answer be made up. Instead, a missing value is assigned in the data file. In the final report, the way the missing values are handled varies depending on whether the table shows 1) a percent distribution or 2) individual cell percentages of respondents that do not sum to 100 percent.  For tables presenting a percent distribution that sums to 100 percent, missing values are shown when they account for at least 1 percent of cases in any row.  When missing values account for less than 1 percent of the distribution in every row, it depends on the author whether they are shown or not. For tables showing individual cell percentages of respondents, rows of missing values are not shown.

Other special responses and codes are: “inconsistent,” “don’t know,” and “blank” (or "not applicable.") “Missing,” “inconsistent,” “don’t know,” and “blank” codes are excluded when calculating statistics such as means or medians; otherwise they are treated as real values.

Sampling Weights

In a survey, sampling weights are adjustment factors applied to each case in tabulations to adjust for differences in probability of selection and interview between cases in a sample, either due to design or happenstance.

In a nationally representative survey, many times the sample is selected with unequal probability to expand the number of cases available for certain areas or subgroups for which statistics are needed. In this case, weights need to be applied when tabulations are made to produce the proper representation.


Median Calculations

There are four different types of median calculations in the survey statistics, and results vary according to the type of variable being analyzed.

(1) Medians for completed time periods: These are medians for variables such as intervals between events or ages calculated at different events. For example, current age, age at first union, and age at sterilization in the DHS belong to this category. Medians for this type of variables take into consideration that ages are given in completed years. A respondent who is currently 20 years old could be somewhere between 20 years and 1 day old or 20 years and 364 days old.

(2) Medians for continuous variables: These are medians for variables such as children’s weight at birth or any other type of measurement in a continuous scale.

(3) Medians for discrete variables: These types of medians apply to variables where the only possible values are discrete values. Examples include: number of children or number of prenatal care visits by the woman. A respondent can only have one, two, or any integer number of children. It is not possible to have 2.3 children.

(4) Medians using the current status data: These types of medians are calculated for variables where 100 or close to 100 percent of the population have that characteristic at the beginning of an event and the percentages diminish as time passes by. For example, 100 percent of children do not know how to walk at birth. As time progresses, some children begin to walk, and there is an age (in months) where 50 percent or more of the children learn to walk.

Other Tools of Demography

Rates: The frequency of demographic events in a population in a specified time period. Rates tell how frequently an event is occurring – how common it is. Crude rates are rates computed for an entire population. Specific rates are rates computed for a specific subgroup, usually the population at risk of having the event occur (for example, General Fertility Rate: births per 1,000 women age 15-49 years). Thus, rates can be age-specific, race-specific, occupation-specific, and so on.

Ratio: The relation of one population subgroup to another subgroup in the same population; that is, one subgroup divided by another (for example, sex ratio: 102 males per 100 females).

Proportion: The relation of a population subgroup to the entire population; that is, a population subgroup divided by the entire population (for example, the proportion urban: 26.7 percent of the population).

All Women Factors (DHS and AIS Surveys Only)

All women factors are used in the DHS and AIS surveys to adjust ever-married women samples in order to estimate statistics based on all women.

These factors are as follows:

  • Coverage: All women factors are specific for individual years of age and specific for the particular subgroup to be estimated (e.g., there are two sets of factors by type of area: one for urban areas and one for rural areas).
  • Numerator: Number of all de facto women
  • Denominator: Number of de facto ever-married women.

Wealth Index (DHS and AIS Surveys Only)

The Wealth Index was introduced in the DHS and AIS surveys and is presented in the Final Reports as a background characteristic. Information on the wealth index is based on data collected in the Household Questionnaire on household assets. This questionnaire includes questions concerning the household's ownership of a number of consumer items such as a television and car; dwelling characteristics such as flooring material; type of drinking water source; toilet facilities; and other characteristics that are related to wealth status.

Each household asset for which information is collected is assigned a weight or factor score generated through principal components analysis. The resulting asset scores are standardized in relation to a standard normal distribution with a mean of zero and a standard deviation of one. These standardized scores are then used to create the break points that define wealth quintiles as: Lowest, Second, Middle, Fourth, and Highest.

Each household is assigned a standardized score for each asset, where the score differs depending on whether or not the household owned that asset (or, in the case of sleeping arrangements, the number of people per room). These scores are summed by household, and individuals are ranked according to the total score of the household in which they reside. The sample is then divided into population quintiles -- five groups with the same number of individuals in each.

A single asset index is developed on the basis of data from the entire country sample and used in all the tabulations presented. Separate asset indices are not prepared for rural and urban population groups on the basis of rural or urban data, respectively.

Wealth quintiles are expressed in terms of quintiles of individuals in the population, rather than quintiles of individuals at risk for any one health or population indicator. This approach to defining wealth quintiles has the advantage of producing information directly relevant to the principal question of interest, for example, the health status or access to services for the poor in the population as a whole. This choice also facilitates comparisons across indicators for the same quintile, since the quintile denominators remain unchanged across indicators. However, some types of analysis may require data for quintiles of individuals at risk.

All health, nutrition and population indicators are calculated after applying the sampling weights so that the resulting numbers are generalizable to the total population. For each indicator in these tables, the total or population average presented is the weighted sum of the quintile values for that indicator, where the weight assigned to each quintile value is the proportion of the total number of individuals at risk in that quintile. The total value for indicators produced by this weighting scheme are representative of the total population, as they take into account the fact that the numbers of individuals at risk may vary across wealth quintiles. Similarly, each quintile value itself can be reproduced as a weighted average of urban/rural rates (weighted by proportions urban/rural) or the male/female rates (weighted by the proportion male/female). As a result of this weighting scheme, the population average for a given indicator presented in the tables will usually differ from a simple mean of the population subgroups.

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/Data-Quality-and-Use.cfm
Time Stamp 17-Oct-21 11:57 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
1145 ms 26 ms 44 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
1111 ms 25 ms 44 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
828 ms 828 ms 1 C:/inetpub/wwwroot/dhs/data/Data-Quality-and-Use.cfm
827 ms 827 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
747 ms 747 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
607 ms 607 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
605 ms 605 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
604 ms 604 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
604 ms 604 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
579 ms 579 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
573 ms 52 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
295 ms 295 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c1378-l70-t51-dAny.read
136 ms 136 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
56 ms 56 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c1433-l70-t51-dAny.read
56 ms 56 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
55 ms 55 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
46 ms 46 ms 1 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
27 ms 27 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c19153-l70-t51-dAny.read
26 ms 26 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c19154-l70-t51-dAny.read
26 ms 26 ms 1 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
25 ms 25 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c19152-l70-t51-dAny.read
23 ms 23 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c19155-l70-t51-dAny.read
22 ms 22 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
22 ms 22 ms 1 C:/inetpub/wwwroot/dhs/data/Application.cfm
21 ms 21 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
20 ms 20 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c5191-l70-t51-dAny.read
19 ms 19 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c5373-l70-t51-dAny.read
18 ms 18 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c5193-l70-t51-dAny.read
18 ms 18 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c5195-l70-t51-dAny.read
17 ms 17 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c5370-l70-t51-dAny.read
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/p5367-c5184-l70-t51-dAny.read
13 ms 13 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c5188-l70-t51-dAny.read
10 ms 10 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
7 ms 7 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c19174-l70-t51-dAny.read
7 ms 7 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c49703-l70-t27356-dAny.read
7 ms 7 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c49731-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/p5367-c19169-l70-t51-dAny.read
6 ms 3 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(5367, 5, 2352, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
5 ms 5 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c1432-l70-t51-dAny.read
4 ms 4 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-c19172-l70-t51-dAny.read
4 ms 4 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/5/p5367-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/set-style-vars.cfm
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 5367) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(5367) ] 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/dhs/custom-application.cfm
2 ms 1 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile-meat.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 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/style/load-page-classes.cfm
1 ms 0 ms 17 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-page-stub.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/dhs/data/template-Data-Template.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 5, 5367, 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/item-security-cache.cfc | GetEntry(5367) ] from C:/inetpub/wwwroot/commonspot/components/cache/item-security-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(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.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/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-foot.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-global.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-site.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 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 10 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/item-visible.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
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, 5367, 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/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/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 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) ] 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(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(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 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(5367, 5) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
13 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
863 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:57:28.028
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
CacheInfo (Datasource=commonspot-site-dhs, Time=3ms, Records=51) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 11:57:28.028
			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) = 5367
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1

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

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

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

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

qryKeywords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\keywords-tags\keywords-tags-base.cfc @ 11:57:28.028
		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) = 5367
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:57:28.028
			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) = 5367
Parameter #5(CF_SQL_INTEGER) = 2352

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

FormData (Datasource=commonspot-site-dhs, Time=22ms, Records=15) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 11:57:28.028
	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) = 5367
Parameter #4(CF_SQL_INTEGER) = 2352
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:57:28.028
	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) = 5367
Parameter #4(CF_SQL_INTEGER) = 2352
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:57:28.028
		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) = 5367
Parameter #4(CF_SQL_INTEGER) = 2352
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:57:28.028
		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) = 5367
Parameter #4(CF_SQL_INTEGER) = 2352
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:57:28.028
		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) = 5367
Parameter #4(CF_SQL_INTEGER) = 2352
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:57:28.028
	SELECT DISTINCT ControlID
	  FROM ItemSecurity
	 WHERE PageID = ?
		AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5367

ParentTemplateInfo (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\write-stub.cfm @ 11:57:28.028
		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:57:28.028
			SELECT *
			  FROM ItemSecurity
			 WHERE PageID = ?
				AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5367

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=1ms, Records=22) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 11:57:28.028
		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) = 5367
Parameter #4(CF_SQL_INTEGER) = 2352
Parameter #5(CF_SQL_INTEGER) = 2

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

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

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

CacheUpdate (Datasource=commonspot-site-dhs, Time=2ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 11:57:29.029
					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:57:28
Parameter #3(CF_SQL_VARCHAR) = 2121-10-17 11:57:28
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) = 5367
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\Data-Quality-and-Use.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/Data-Quality-and-Use.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\Data-Quality-and-Use.cfm
QUERY_STRING=
REMOTE_ADDR=3.237.16.210
REMOTE_HOST=3.237.16.210
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/data/Data-Quality-and-Use.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=1568475
CFTOKEN=c571c86dcec190d7-8D2336B9-BE83-73D1-3B2BC600CD8DE237
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
customcfupfront=
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 (0)
elementsrun=0
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138
formattedtimestamp=2021-10-17 11:57:28
getghost=
hivbold=1,3,8,9
ignoreauthuser=0
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1634471848243
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (86)
master_cfm_used=1
maxperms=Complex type
metadata=Struct (1)
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:57:28.236
req_sequenceid=9580
req_startticks=1634471848236
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_A2C458A9EA9B86953A3D1A6B6F4B5ED9.cfusion
sessionstring=1_A2C458A9EA9B86953A3D1A6B6F4B5ED9.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:57:28'}
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=5367
debugmode=0
debugstate=Struct (1)
editmode=0
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1634471848249
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=A2C458A9EA9B86953A3D1A6B6F4B5ED9.cfusion
urltoken=CFID=1568475&CFTOKEN=c571c86dcec190d7-8D2336B9-BE83-73D1-3B2BC600CD8DE237&jsessionid=A2C458A9EA9B86953A3D1A6B6F4B5ED9.cfusion
usagelist=
user=Struct (27)
Debug Rendering Time: 22 ms