REDFLAG

Diversion_Review.csv

An overview of the uploaded file and its field-level completeness.

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%