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-3
- Issued by
- Kentucky
About this file
This file is Attachment C detailing the data specifications for prescription claims between November 2023 and October 2024. The document outlines required data elements for 4,368,472 prescription claim records, including Dummy Member ID, National Drug Code, Drug Name, Pharmacy Identifiers (NCPDP or NPI), Quantity Dispensed, Days Supply, Mail/Retail Indicator, Formulary Status, Dispense as Written (DAW) codes, Service Dates (shifted 1-3 days), and Age Categories. The total quantity dispensed across all claims is 247,222,837.885 units.
The file provides technical specifications for data formatting, including formulary indicators (Y=Formulary, N=Not Formulary, U=Unknown) and age categories broken into four groups: 0-18, 19-39, 40-64, and 65+. The document appears to be a technical specification attachment that defines the structure and content requirements for prescription claims data reporting or analysis.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment F - Mandatory Requirements - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Attahment K - BAA.pdf | ||
| Attachment O - Census Data - KEHP Rx Plan Designs 2024.xlsx | XLSX spreadsheet | |
| Attachment N - Census Data - KEHP Network Disruption Final.xlsx | XLSX spreadsheet | |
| Attachment B - Cost Form - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Final_RFP_758_2500000221_1_SO_FORM.PDF | ||
| Attachment J -DEI Billing Procedure Document.pdf | ||
| Final_RFP_758_2500000221_3_SO_FORM.PDF | ||
| Attachment M - Census Data - KEHP Formulary Disruption Final.xlsx | XLSX spreadsheet | |
| Final_RFP_758_2500000221_2_SO_FORM.PDF | ||
| Attachment H - Technical Questionnaire - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Attachment L - KEHP Pharmacy Claims Invoicing Document - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Attachment I - KEHP Data Integration Chart - PBM RFP 2025.xlsx | XLSX spreadsheet | |
| Attachment P - Census Data - KEHP Rx Plan Designs 2025.xlsx | XLSX spreadsheet |
Show all 14
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 .