Facts Over Time
| dc.contributor.author | Wieand, Kaleigh |
| dc.contributor.author | Dickinson, Kimberley |
| dc.contributor.other | PEDSnet Data Coordinating Center |
| dc.date.accessioned | 2025-05-28T17:15:38Z |
| dc.date.created | 2024 |
| dc.description.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.<br> <br> Results of this check for the current data cycle can be explored on the <a href="https://pedsnet.org/metadata/entities/documentation/9a3dcf2c-b84e-4c9c-9e09-074804956d0f">PEDSnet Data Quality Dashboard</a>. Data quality results for previous data cycles have been archived in the <a href="https://pedsnet.org/metadata/collections/a107d27a-5fe8-468c-852b-87a5ddb808b7">Facts Over Time Network Results collection</a>. |
| dc.identifier.uri | https://hdl.handle.net/20.500.14642/1043 |
| dc.identifier.uri | https://doi.org/10.24373/pdsp-481 |
| dc.publisher | PEDSnet |
| dc.relation.uri | https://github.com/PEDSnet/ndq/blob/main/R/facts_over_time.R |
| dc.rights | a CC-BY Attribution 4.0 license. |
| dc.rights.uri | https://creativecommons.org/licenses/by/4.0/ |
| dc.title | Facts Over Time |
| dspace.entity.type | DQCheck |
| local.description.raw | This check produces a raw data output containing 11 columns of data: <br> |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| {.dqcheck-table} <br> |
| local.description.viz | **NOTE: The visualizations are NOT part of the packaged code. This description applies to the visualizations available on the <a href="https://pedsnet.org/metadata/entities/documentation/9a3dcf2c-b84e-4c9c-9e09-074804956d0f">PEDSnet Data Quality Dashboard</a>.** <br><br> 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. |
| local.dqcheck.category | Consistency |
| local.dqcheck.clinicalprobe | Clinical Consistency |
| local.dqcheck.clinicalprobe | Clinical Data Distributions |
| local.dqcheck.probe | Temporality Consistency Check |
| local.dqcheck.requirement | fot_tbl |
| local.dqcheck.requirement | omop_or_pcornet |
| local.dqcheck.requirement | check_string |
| local.dqcheck.requirement | compute_method |
| local.dqcheck.requirement | time_span |
| local.dqcheck.requirement | time_period |
| local.dqcheck.requirement | lookback_interval |
| local.dqcheck.requirement | visits_only |
| local.dqcheck.requirement | distinct_visits |
| local.dqcheck.viz | Line Graph |
| relation.isCodeOfDQCheck | 3518c7c7-0f20-491d-bd3d-a2841b66ca2f |
| relation.isCodeOfDQCheck | 929c8dfc-2c8b-4e62-8e1d-0fa06c542832 |
| relation.isCodeOfDQCheck.latestForDiscovery | 3518c7c7-0f20-491d-bd3d-a2841b66ca2f |
| relation.isDocumentationOfDQCheck | 9a3dcf2c-b84e-4c9c-9e09-074804956d0f |
| relation.isDocumentationOfDQCheck.latestForDiscovery | 9a3dcf2c-b84e-4c9c-9e09-074804956d0f |