High Utilizers Report

report columns column description member id cardholder id of the member last name patient last name first name patient first name dob patient date of birth lob line of business (egwp, mapd, dsnp) total rx cost total cost of pharmacy claims in the past 365 days total medical cost total cost of medical claims in the past 365 days total spend total spend of claims in the past 365 days chronic count count of icd 10 codes that identify presence of a chronic condition found in medical claims in entire patient history chronic conditions htn, dm, hyperlipidemia, ckd, asthma, copd, hiv behavioral counts count of icd 10 codes that identify presence of a behavioral health diagnosis found in medical claims in entire patient history distinct drugs count of distinct drugs filled in the past 365 days ccm code 1 member has a ccm (chronic care management) code ('99490', '99439') in the past 365 days on medical claims 0 no ccm code latest pcp name provider name of provider who has a taxonomy of primary care found in the latest office medical claim npi npi of the provider fax fax of the provider phone phone of the provider dx codes list list of unique icd 10 codes found in member's medical claims in the past 365 days