Facts Over Time
Created
Last Modified
Files
Domain
Category
Parameters
Publisher
Abstract
A network data quality check which computes different clinical facts over a range of time, as defined by the user. The check can examine facts by month or by year, and row, patient, and visit counts are able to be computed.
Results of this check for the current data cycle can be explored on the PEDSnet Data Quality Dashboard. Data quality results for previous data cycles have been archived in the Facts Over Time Network Results collection.
Data Requirements
Probe
Clinical Assessment
Access Package
Visualization Output
NOTE: The visualizations are NOT part of the packaged code. This description applies to the visualizations available on the PEDSnet Data Quality Dashboard.
There are two different types of line plots included for this module. The first is a smoothed line graph with a Loess regression applied, displaying the rate of records per 10,000 visits across time. The second displays the raw row count (shown on the left Y axis) compared to a normalized row count (shown on the right Y axis). We applied normalization using the following heuristic: (current month)/((month-1).25+(month+1).25+(month-12)*.5). In plain words, it is the current month divided by the weighted average of the previous month, the next month, and the value from the current month in the previous year.
Raw Output
This check produces a raw data output containing 11 columns of data:
| Column | Data Type | Definition |
|---|---|---|
row_cts |
numeric | the number of rows for that year and domain |
row_visits |
numeric | the number of visits for that year and domain |
row_pts |
numeric | the number of patients for that year and domain |
site |
character | the name of the site being targeted |
database_version |
character | the database version from which the counts originated |
check_type |
character | a short string identifier for the module |
check_name |
character | a short string identifier for the check |
check_desc |
character | the fact type being evaluated |
domain |
character | the table from which the fact type originated |
time_end |
date | the end date of the time period being evaluated |
time_start |
date | the start date of the time period being evaluated |

