Attachment C - Prescriptions Filled from Nov 2023 through Oct 2024.pdf
PDF 105 KB Posted
- Attached to
- Pharmacy Benefits Manager (PBM)
- Solicitation number
- RFP-758-2500000221-4
- Issued by
- Elliott County, Kentucky
About this file
Attachment C is a data file detailing prescription claims information for a healthcare or pharmacy benefits management project covering the period from November 2023 through October 2024. The document provides a comprehensive overview of prescription data with 4,368,472 total rows and a total quantity dispensed of 247,222,837.885. The claims file includes key data items such as Dummy Member ID, National Drug Code, Drug Name, Pharmacy NCPDP Number or NPI, Quantity Dispensed, Prescription Days Supply, Mail/Retail Indicator, Formulary Indicator, Dispense as Written (DAW), Service Date, and Age Category.
The data is segmented across four age categories (0-18, 19-39, 40-64, and 65+) and includes formulary indicators (Y = Formulary, N = Not Formulary, U = Unknown). The service dates have been shifted by 1-3 days, likely for privacy or data anonymization purposes. Each row represents a prescription claim with details about the medication, pharmacy, quantity, and patient demographic information, suggesting this is part of a larger healthcare data analysis or claims processing system.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment M - Census Data - KEHP Formulary Disruption Final.xlsx | XLSX spreadsheet | |
| Attachment O - Census Data - KEHP Rx Plan Designs 2024.xlsx | XLSX spreadsheet | |
| Attachment N - Census Data - KEHP Network Disruption Final.xlsx | XLSX spreadsheet | |
| Attachment L - KEHP Pharmacy Claims Invoicing Document - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Final_RFP_758_2500000221_4_SO_FORM.PDF | ||
| Attachment I - KEHP Data Integration Chart - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Attahment K - BAA.pdf | ||
| Attachment H - Technical Questionnaire - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Final_RFP_758_2500000221_2_SO_FORM.PDF | ||
| Attachment P - Census Data - KEHP Rx Plan Designs 2025.xlsx | XLSX spreadsheet | |
| Final_RFP_758_2500000221_1_SO_FORM.PDF | ||
| Attachment B - Cost Form - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Attachment J -DEI Billing Procedure Document.pdf | ||
| Final_RFP_758_2500000221_3_SO_FORM.PDF | ||
| Attachment F - Mandatory Requirements - PBM RFP 2025.xlsx | XLSX spreadsheet |
Show all 15
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Attachment C
Prescriptions Filled from Nov 2023 through Oct 2024
Claims File Data Items
• Dummy Member ID
• National Drug Code
• Drug Name
• Pharmacy NCPDP Number (seven digits) or NPI (ten digits)
• Quantity Dispensed
• Prescription Days Supply
• Mail/Retail Indicator
• Formulary Indicator
• Dispense as Written (DAW)
• Service Date (Shifted by 1-3 days)
• Age Category
Total Row Count
4,368,472 rows
Total Quantity Dispensed
247,222,837.885
Formulary Indicators
Y = Formulary
N = Not Formulary
U = Unknown
Age Category
0-18
19-39
40-64
65+
File details come from the government source that posted it. Updated .