Summary: ESBD_521004_1780004177857_Exhibit A-7. Prescription Drug NDC 11.xlsx

This file is a prescription drug claim detail report for Aetna CVSH (Aetna CVS Health) covering claims submitted by Travis County Healthcare District Central during February 2025. The spreadsheet contains comprehensive claim-level data documenting prescription fills across multiple pharmacy locations, predominantly in Texas. The dataset encompasses over 1,100 individual prescription claims spanning fill dates from February 2 through February 7, 2025, with all claims processed under Aetna's formulary structure for group number 00181116.

The claims detail reflects a diverse medication portfolio including generic and brand-name drugs across therapeutic categories such as cardiovascular medications, diabetes treatments, psychiatric medications, antibiotics, pain management, and specialty pharmaceuticals. Notable drug utilization includes high-volume generic medications (metformin, sertraline, lisinopril, losartan) alongside specialty pharmaceuticals requiring specialized pharmacy handling (Mounjaro, Ozempic, Dupixent, SKYRIZI). Quantities dispensed vary significantly, from single-unit claims for vaccines and injectable medications to 360-unit claims for extended-supply generic tablets. Medications are distributed across retail pharmacy chains (HEB Pharmacy, CVS, Walgreens), mail-order services (Caremark Prescription Service), and specialty pharmacy providers. Formulary tier classifications range from Tier 1 generics to Tier 3 specialty medications, with most claims meeting formulary requirements. The data reflects actual adjudicated claims with no indication of pending approvals or special authorization requirements, representing standard claims processing for an integrated healthcare delivery system's covered population.