Diversion_Review.csv
Every one of the 10,000 rows in the connected file was read into RedFlag successfully. Within those ingested records, the 199 fields each one can carry are only 84.0% filled in on average.
File typeCSV
File size20.1 MB
Total records10,000
Total fields199
Last modifiedOct 5, 2026
SourceManual Upload
| Controlled-Substance & DEA Data 8 fields Populated in 76.9% of cells across these 11 fields; sparsest is dea_schedule at 21.4%. | |
prescriber_npi |
99.5%
|
prescriber_dea |
99.5%
|
prescriber_dea_schedules |
99.5%
|
dea_schedule |
21.4%
|
substance_category |
56.5%
|
refills_authorized |
56.5%
|
refill_number |
56.5%
|
federal_refill_ceiling |
56.5%
|
| Medication Details 14 fields Populated in 56.5% of cells across these 14 fields; sparsest is medication_request_id at 56.5%. | |
medication_request_id |
56.5%
|
medication_status |
56.5%
|
medication_prescribed |
56.5%
|
medication_rxnorm_code |
56.5%
|
medication_ndc11 |
56.5%
|
medication_strength_mg |
56.5%
|
medication_daily_dose_mg |
56.5%
|
fda_max_labeled_daily_dose_mg |
56.5%
|
quantity_value |
56.5%
|
quantity_unit |
56.5%
|
days_supply |
56.5%
|
authored_on |
56.5%
|
substitution_allowed |
56.5%
|
prescription_origin |
56.5%
|
| Diagnosis / Condition Details 3 fields Populated in 80.8% of cells across these 11 fields; sparsest is overdose_history_icd10 at 1.1%. | |
secondary_diagnosis_icd10 |
78.3%
|
substance_use_disorder_icd10 |
9.9%
|
overdose_history_icd10 |
1.1%
|
| Screening & PDMP 13 fields Populated in 55.5% of cells across these 22 fields; sparsest is adhd_rating_scale_score at 4.6%. | |
phq9_score |
44.8%
|
phq9_loinc |
44.8%
|
gad7_score |
33.9%
|
gad7_loinc |
33.9%
|
adhd_rating_scale_score |
4.6%
|
adhd_rating_scale_code_system |
4.6%
|
adhd_rating_scale_code |
4.6%
|
audit_c_score |
30.1%
|
audit_c_loinc |
30.1%
|
dast10_score |
27.9%
|
dast10_loinc |
27.9%
|
pdmp_distinct_prescribers_12mo |
16.8%
|
pdmp_distinct_pharmacies_12mo |
16.8%
|
| Identity, Telehealth & Licensure Verification 7 fields Populated in 82.8% of cells across these 15 fields; sparsest is technology_assessment at 57.9%. | |
telehealth_modality |
64.0%
|
telehealth_id |
64.0%
|
hipaa_compliant_platform_name |
64.0%
|
identity_verification_method |
64.0%
|
originating_site_state |
64.0%
|
distant_site_state |
64.0%
|
technology_assessment |
57.9%
|
| Clinical Outcome Tracking 2 fields Populated in 93.5% of cells across these 18 fields; sparsest is override_reason at 1.4%. | |
medication_reconciliation_snomed |
81.2%
|
override_reason |
1.4%
|
| Practitioner & Supervision 1 field Populated in 95.1% of cells across these 14 fields; sparsest is supervising_physician_npi at 31.3%. | |
supervising_physician_npi |
31.3%
|
| Claims & Billing 8 fields Populated in 79.8% of cells across these 34 fields; sparsest is modifier_4 at 0.2%. | |
bill_type |
4.0%
|
revenue_code |
4.0%
|
modifier_1 |
69.6%
|
modifier_2 |
21.5%
|
modifier_3 |
3.6%
|
modifier_4 |
0.2%
|
rtm_data_days_in_30 |
8.5%
|
remark_code_rarc |
2.2%
|
Import Data
Excel or PDF Manual Upload
