Athens_Clarke_RFP___Record_Layout.pdf
PDF 110 KB Posted
- Attached to
- RFP 26030 - Pharmacy Benefit Administration
- Solicitation number
- PE-62960-NONST-2026-000000107
- Issued by
- Atkinson County, Georgia
About this file
This is a record layout document for a pharmacy claims data file submitted by the Unified Government of Athens-Clarke County in support of its RFP 26030 for Pharmacy Benefit Management services. The document specifies the structure and format of historical pharmacy claims data covering the period January 1, 2025 through December 31, 2025, containing 55,699 claim records. The file details 20 data fields including National Drug Code, pharmacy identifier, fill date, quantity dispensed, days supply, claim type, brand/generic indicator, member ID, formulary tier, specialty drug flag, and claim status. The data is provided in a delimited text format (Athens_Clarke_202602.txt) with defined field types and formats to enable bidders to analyze historical utilization patterns and develop proposals for pharmacy benefit administration services.
The claims data provided is confidential and proprietary, restricted for use solely in preparation of bid proposals under the nondisclosure agreement between Athens-Clarke County and bidders. The record layout indicates the dataset encompasses retail, mail, and paper claims with comprehensive information on drug selection, dispensing details, and payment status. This historical claims experience data serves as the foundation for vendors to assess the scope and complexity of the pharmacy benefit management services required and to structure competitive pricing and service proposals for the contract term beginning January 1, 2027.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Athens_Clarke_RFP___Rollup_Summary_and_Sample.pdf | ||
| ACCGov_Employee_Census___2026_02_10.xlsx | XLSX spreadsheet | |
| Athens_Clarke_202602 _ _ 26030.txt | TXT text file | |
| Boiler RFP _ 26030 Pharmacy Benefits Administ.pdf |
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
Athens Clarke
RFP RECORD LAYOUT
File Name: Athens_Clarke_202602.txt Dates of Service: 01/01/2025 - 12/31/2025 Field Name Definition Type Format Notes NDC National Drug Code (Product Service ID) Text 11-character NDC number DRUG_NAME Drug Name Associated with the Claim NDC Number Text PHMCY_NUMBER Pharmacy NABP/NCPDP/NPI Identifier (Service Provider ID) Text May be NCPDP 6, NCPDP 7 or NPI (10 digits) PHMCY_NAME Name of the Pharmacy Payee Text FILL_DATE Date of Fill (Date of Service) Number YYYYMMDD QUANTITY Quantity Dispensed (Metric Decimal Quantity) Decimal XXX.xxx DAYS_SUPPLY Days Supply Integer XXX CLAIM_TYPE Claim Type/Source Text R=Retail, M=Mail, P=Paper (Member-Submitted) BRND_GNC_IND Brand or Generic Indicator Text B=Brand, G=Generic DAW Dispense As Written Code (Product Selection Code) Text 0,1,2,3,4,5,6,7,8,9 MBR_ID De-Identified Member ID Number Text COMPOUND_IND Compound Indicator Text Y, N FRMLY_TIER Formulary Tier for the Claim Text 1, 2, 3, etc SRX Specialty Flag for the Claim Text Y, N CARRIER Carrier Code Text If/when applicable ACCOUNT Account Code Text If/when applicable GROUP Group Code Text If/when applicable CLAIM_STATUS Paid / Reversed Claim Indicator Text P = Paid, R = Reversal
Claim Records: 55,699
The information contained in Attachment A – Athens Clarke RFP Claims is confidential and proprietary. Disclosure of the information contained in Attachment A is subject to the Nondisclosure Agreement between Athens Clarke and bidder and may not be used for any other purpose than preparation of the bidder’s proposal.
Record Layout
File details come from the government source that posted it. Updated .