List of Summary Statistics Included in executeDbProfile
The executeDbProfile function will execute and/or export the
following aggregate summary statistics and DQD checks:
Statistics
- Number of persons
- Number of persons by gender
- Number of persons by year of birth
- Number of persons by race
- Number of persons by ethnicity
- Number of persons with at least one day of observation in each
month
- Number of persons by observation period start month
- Number of persons by number of observation periods
- Number of persons by length of observation period, in 30d
increments
- Number of persons with at least one visit occurrence, by
visit_concept_id
- Number of distinct patients that overlap between specific domains -
including death
- Number of persons with at least one concept_id, by
measurement_concept_id
- Number of measurement occurrence records, by
measurement_concept_id
- Number of measurement occurrence records, by
measurement_source_concept_id
- Number of measurement records with no value (numeric, string, or
concept)
- Number of measurement records, by measurement_concept_id and
value_as_concept_id
- Number of persons with at least one concept_id, by
condition_concept_id
- Number of condition occurrence records, by condition_concept_id
- Number of condition occurrence records, by
condition_source_concept_id
- Number of persons with at least one concept_id, by
procedure_concept_id
- Number of procedure occurrence records, by procedure_concept_id
- Number of procedure occurrence records, by
procedure_source_concept_id
- Number of persons with at least one concept_id, by
drug_concept_id
- Number of drug exposure records, by drug_concept_id
- Number of drug exposure records, by drug_source_concept_id
- Number of persons with at least one drug era, by
drug_concept_id
- Number of drug era records, by drug_concept_id
- Number of persons with at least one concept_id, by
observation_concept_id
- Number of observation occurrence records, by
observation_concept_id
- Number of observation occurrence records, by
observation_source_concept_id
- Number of observation records, by observation_concept_id and
value_as_concept_id
- Number of persons with at least one concept_id, by
device_concept_id
- Number of device exposure records, by device_concept_id
- Number of device exposure records, by device_source_concept_id
- Distribution of numeric values, by measurement_concept_id and
unit_concept_id
Later inclusions - condition_status? - type concepts