Standard Claims Extract Format Pharmacy
What is the Standard Claims Extract Format?
The Standard Claims Extract (SCE) Format is a nationallyadopted data specification that defines how pharmacy claim information is exchanged between health plans, pharmacies, clearinghouses, and government agencies. It provides a single, consistent layout for claimlevel data, eliminating the need for custom mappings and reducing processing errors.
Originally created by the Centers for Medicare & Medicaid Services (CMS) as part of the Medicare Part D reporting requirements, the format has been extended to commercial plans and other payerpharmacy networks. It is designed to be flexible enough to support a wide range of pharmacy services retail, specialty, longterm care, and mailorder while still delivering the granularity needed for analytics, compliance, and reimbursement.
File Structure and Delivery Mechanisms
Each SCE file is a plaintext, pipedelimited (|) file that contains a series of records. The first record is a header, followed by a variable number of claim detail records, and ends with a trailer record that summarizes the file. The main components are:
- Header (H) identifies the file type, creation date, sending organization, and version of the specification.
- Claim Detail (D) one line per pharmacy claim, containing information about the patient, drug, prescriber, pharmacy, and financials.
- Trailer (T) provides record counts and a checksum to verify file integrity.
Files are typically transferred via secure FTP (SFTP), AS2, or directly through API endpoints that support bulk uploads. Encryption (AES256) and hash verification (SHA256) are recommended to meet HIPAA security standards.
Key Fields in a Claim Detail Record
Although the full specification includes more than 150 fields, the most commonly used elements for routine reporting are summarized below.
| Field Name | Position (Example) | Description |
|---|---|---|
| Record Type | 1 | Always D for claim detail. |
| Claim Identifier | 221 | Unique identifier assigned by the payer. |
| Member ID | 2241 | Encrypted subscriber or patient identifier. |
| Service Date | 4249 | Date the medication was dispensed (YYYYMMDD). |
| National Drug Code (NDC) | 5064 | 11digit identifier for the drug product. |
| Quantity Dispensed | 6570 | Number of units (e.g., tablets, mL). |
| Days Supply | 7173 | Prescribed days of therapy. |
| Prescriber NPI | 7488 | National Provider Identifier of the prescriber. |
| Pharmacy NPI | 89103 | National Provider Identifier of the dispensing pharmacy. |
| Gross Amount | 104113 | Total charge before discounts (in cents). |
| Paid Amount | 114123 | Amount actually paid to the pharmacy (in cents). |
| CoPay Amount | 124133 | Members responsibility. |
| Benefit Type | 134136 | Indicates generic, brand, specialty, etc. |
| Claim Status | 137139 | Paid, Rejected, Pending, etc. |
All numeric values are rightjustified and padded with leading zeros. Text fields are leftjustified and padded with spaces. Empty fields must be represented by the appropriate number of delimiters.
Why Use the Standard Claims Extract Format?
Interoperability By adhering to a single, prescribed layout, pharmacies and payers can exchange data without custom transformations, which accelerates onboarding and reduces integration costs.
Regulatory Compliance Many state Medicaid programs, Medicare Part D, and large commercial carriers require SCE submissions for rebate reporting, utilization monitoring, and fraud detection.
Data Quality The format enforces strict field lengths, data types, and mandatory elements, which helps catch errors early in the transmission process.
Analytics & Business Intelligence Consistent claim-level data enable robust trend analysis, cost forecasting, and performance benchmarking across multiple plans and pharmacy networks.
Implementation Tips and Best Practices
1. Validation Before Transmission
- Run a schema validator against the latest CMS SCE specification.
- Check date fields for valid calendar dates and ensure that numeric fields contain only digits.
- Confirm that NDC numbers match the FDAs NDC directory.
2. Secure File Transfer
- Use SFTP with dedicated user accounts per trading partner.
- Implement GPG or PGP encryption for an additional layer of security.
- Maintain an audit log of uploads, downloads, and checksum results.
3. Error Handling & Reconciliation
- Process the trailer record to verify record counts and checksum.
- Create a rejection file that lists line numbers, field positions, and error codes for any invalid records.
- Schedule daily or weekly reconciliation reports that compare sent vs. received claim totals.
4. Version Management
The specification is periodically updated (e.g., 2022, 2023 versions). Include the version number in the header and maintain backwardcompatible parsers for partners that have not migrated.
5. Testing with Public Test Files
CMS publishes sample files for each version. Use these to verify that your parsing logic correctly handles edge cases such as:
- Multiple claim lines for a single prescription (e.g., split fills).
- Zerovalue paid amounts (e.g., 100% patient responsibility).
- Special characters in freetext fields (e.g., pharmacy name).
6. Documentation and Support
Maintain an internal datadictionary that maps each field to business rules and downstream system requirements. Establish a single point of contact for each trading partner to resolve format questions quickly.
