Include Page | ||||
---|---|---|---|---|
|
ESP Query Composer Projections and Adjustments
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Tip | ||
---|---|---|
| ||
The ESP Query Composer Projections and Adjustments functionality requires careful construction of the request and interpretation of the results.
|
Composing an ESP Query Composer Projections Request
The projections and adjustments functionality uses the same Query Composer request type to define a cohort of interest. See Query Composer Request v5.0 for more information on how to define a cohort, however note that in order to generate interpretable adjusted and projected patient counts, there are some restrictions on possible request parameters. These restrictions and instructions are detailed below.
Warning |
---|
If the restrictions and instructions detailed below are not followed, then you may not be able to view adjusted and project patients counts or the counts may not be easily interpreted. |
Terms
There are no restrictions on the terms that you may use in a criteria group.
Criteria Groups
There are no restrictions on the number of criteria groups that you may use to define your cohort. However, if your request does not define an observation period or defines an observation period that is larger than two years, then an additional criteria group must be added to ensure that the denominator for your observed patients matches the denominator of the observed population.
Warning |
---|
If this criteria group is not added, then there will be a mismatch between the denominators which will affect the interpretability of your results and could produce an outcome where the observed patient count is larger than the observed population count for a strata. See the diagram to to the right for a visual explanation of why this is necessary. |
Patient Counts | Description | Calculation |
---|---|---|
Observed Patients | Raw count of patients with selected outcomes in the source DataMarts | None |
Observed Population | Count of patients from the location(s) of interest with at least one visit of any kind in the two years prior to the end of the observation period of interest. If no observation period end date is defined, then this data set includes patients with at least one visit of any kind in the two years prior to the date that the request is executed by the data partner. | None |
Observed Population % | Percentage of the population from the source DataMarts in the strata | (Observed population strata / Σ(Observed population strata))*100 |
Census Population | Count of people from the specified location of interested from the 2010 census. | N/A |
Census Population % | Percentage of the census population in the strata | (Census population strata / Σ(Census population strata ))*100 |
Adjusted Patient Count | Adjusted count of patients with selected outcomes in the source DataMarts after taking into account differences in the age, sex, and/or race-ethnicity distribution in the DataMart population compared to the census population in the region of interest | Observed patient strata *(census population % strata / observed population % strata) |
Projected Patient Count | Projected number of patients with the outcome in the specified region of interest, after taking into account the census population demographics for the region of the interest | Observed patient strata * (census population strata / observed population strata) |
Additional Information
Anchor | ||||
---|---|---|---|---|
|
Race-Ethnicity Definitions
In order to produce data sets that could be compared to census data, the following mappings were created to map ESP Race and Hispanic values to ESP: MDPHnet Race-Ethnicity values. Additionally, when viewing projected results, ESP: MDPHnet Race-Ethnicity values are mapped to census values. These mappings are described below. The ESP: MDPHnet Race-Ethnicity mappings are displayed when viewing results.
ESP Race and Hispanic Mappings to ESP: MDPHnet Race-Ethnicity
ESP Race Values | ESP Hispanic Values | ESP: MDPHnet Race-Ethnicity |
---|---|---|
White | Yes | Hispanic |
White | No | White |
White | Missing / null | White |
White | Unknown | White |
Black or African American | Yes | Hispanic |
Black or African American | No | Black |
Black or African American | Missing / null | Black |
Black or African American | Unknown | Black |
Asian | Yes | Hispanic |
Asian | No | Asian |
Asian | Missing / null | Asian |
Asian | Unknown | Asian |
American Indian or Alaska Native | Yes | Hispanic |
American Indian or Alaska Native | No | American Indian or Alaska Native |
American Indian or Alaska Native | Missing / null | American Indian or Alaska Native |
American Indian or Alaska Native | Unknown | American Indian or Alaska Native |
Native Hawaiian or Other Pacific Islander | Yes | Hispanic |
Native Hawaiian or Other Pacific Islander | No | Asian |
Native Hawaiian or Other Pacific Islander | Missing / null | Asian |
Native Hawaiian or Other Pacific Islander | Unknown | Asian |
Unknown | Yes | Hispanic |
Unknown | No | Unknown |
Unknown | Missing / null | Unknown |
Unknown | Unknown | Unknown |
ESP: MDPHnet Mappings to Census Values
ESP: MDPHnet Race-Ethnicity | Census Values |
---|---|
White | NHW = White, non-Hispanic |
Black | NHB = Black, non-Hispanic |
Asian | NHAP = Asian Pacific Islander, non-Hispanic |
American Indian or Alaska Native | NHAI = American Indian, non-Hispanic |
Hispanic | HISP = Hispanic |
Unknown | No mapping available |
Include Page | ||||
---|---|---|---|---|
|