DHR25006-PBM-att29.xlsx

XLSX spreadsheet 116 KB Posted

Attached to
Pharmacy Benefit Management Services
Solicitation number
DHR25006-PBM
Issued by
Kent County, Delaware

About this file

This document is a Post Adjudication Standard Layout file prepared by CVS Caremark, based on the National Council for Prescription Drug Programs (NCPDP) standard, dated May 28, 2010, and revised on 09/12/17. The file contains a detailed technical specification for processing pharmaceutical claims, with comprehensive fields covering patient information, prescription details, pharmacy data, and financial transaction information. The layout includes header, detail, and trailer records with precise definitions for each data field, ranging from record types and version numbers to specific claim-related attributes like patient demographics, prescription characteristics, and payment details.

The file provides an exhaustive breakdown of claim processing parameters, including fields for tracking patient information, pharmacy identifiers, drug details, dosage forms, and financial transactions. It includes specific codes for various scenarios such as prescription origin, other coverage indicators, reject codes, and drug categorizations. The document also contains exhibits detailing reject codes and drug dosage form codes, which serve as reference materials for claims processing. The technical specification appears designed to standardize and streamline pharmaceutical claims processing across different healthcare systems and insurance providers, with a focus on detailed, structured data capture and transaction tracking.

View the file

Other files

File Type Posted
DHR25006-PBM-its.pdf PDF
DHR25006-PBM-att230.xlsx XLSX spreadsheet
DHR25006-PBM-rfp.pdf PDF
DHR25006-PBM-qa.pdf 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

Cover

D.0 Post Adjudication Standard Descriptions and Values for Mandatory and Caremark selected fields

PAL4KD0 4000 Bytes

Prepared by CVS Caremark - May 28, 2010

Revised 09/12/17

Preface

The fields selected in this layout are based upon the NCPDP Post Adjudicated Standard Layout. Should
you require a copy of the proprietary NCPDP inplementation guide please contact NCPDP at:
National Council for Prescription Drug Programs
9240 East Raintree Drive
Scottsdale, AZ 85260
(480) 477-1000 fax (480) 767-1024
www.ncpdp.org

Page &P http://www.ncpdp.org/ CMK PA History Header Record

Post Adjudication History Header Record
Field #Field NameFormatSizeStartEndDescription/Values
1Record TypeA/N212PA = PA History Header Record
2Version/Release NumberA/N23410 = Post Adjudication 3.0 version
3Sending Entity IdentifierA/N24528Caremark
4Batch NumberN72935Julian Date

Format CCYYDDD

5Creation DateN83643Format CCYYMMDD
6Creation TimeN44447Format HHMM

HH = Hour MM = Minute

7Receiver IDA/N244871CVS Caremark Client Name
8Reporting Period Start DateN87279The first day of the period being reported in the file.

Format: CCYYMMDD 9 Reporting Period End Date N 8 80 87 The last day of the period being reported in the file.

Format: CCYYMMDD 10 File Type A/N 1 88 88 Identifies that the data to be applied is a test or prodution file.

Values:

P = Production 11 Transmission Action A/N 1 89 89 O = Original Submission (New)

12 Submission Number A/N 2 90 91 Indicates the number of times a data set has been resent.

Values:

Blank = Not Specified 00 = Original Submission 13 Filler A/N 3909 92 4000 Spaces

Page &P

CMK PA History Detail Record

Post Adjudication History Detail Record
Field #Field NameFormatSizeStartEndDescription/ValuesOverpunch
1Record TypeA/N212DE = PA History Detail Record

2 Record Indicator A/N 1 3 3 Action to be taken on the record.

Values:

Blank = Not Specified 0 = New record

3FillerA/N346Space Filled
4Final Plan QualifierA/N10716Adjudicated plan qualifier code
5FillerA/N101726Space Filled
6FillerA/N152741Space Filled
7FillerA/N64247Space Filled
8FillerA/N204867Space Filled
9FillerA/N206887Space Filled
10FillerA/N20088287Space Filled
11Cardholder IDA/N20288307The member ID as provided by the client on the enrollment feed.
12Last NameA/N35308342The last name of the cardholder. The value as provided by the client on the enrollment feed.
13First NameA/N25343367The first name of the cardholder. The value as provided by the client on the enrollment feed.
14Middle InitialA/N1368368The middle initial of the cardholder. The value as provided by the client on the enrollment feed.
15FillerA/N10369378Space Filled
16FillerA/N55379433Space Filled
17FillerA/N55434488Space Filled
18FillerA/N30489518Space Filled
19FillerA/N2519520Space Filled
20FillerA/N15521535Space Filled
21Cardholder Date of BirthN8536543The date of birth of the cardholder. The value as provided by the client on the enrollment feed.

Format CCYYMMDD

22FillerN1544544Zero Filled
23FillerA/N1545545Space Filled
24FillerA/N1546546Space Filled
25FillerA/N2547548Space Filled
26FillerA/N20549568Space Filled
27Patient Last NameA/N35569603The last name of the patient associated to the claim. The value as provided by the client on the enrollment feed.
28Patient First NameA/N25604628The first name of the patient associated to the claim. The value as provided by the client on the enrollment feed.
29Patient Middle InitialA/N1629629The middle initial of the patient associated to the claim. The value as provided by the client on the enrollment feed.
30FillerA/N10630639Space Filled
31FillerA/N55640694Space Filled
32FillerA/N55695749Space Filled
33FillerA/N30750779Space Filled
34FillerA/N2780781Space Filled
35FillerA/N15782796Space Filled
36Patient Date of BirthN8797804The date of birth of the patient that the claim processed against. The value as provided by the client on the enrollment feed.

Format CCYYMMDD 37 Patient Gender Code N 1 805 805 The gender of the patient that the claim processed against. The value as provided by the client on the enrollment feed.

Values:

1 = Male 2 = Female 0 = Not Specified 38 Eligibility/Patient Relationship Code N 2 806 807 The relationship code of the patient that the claim processed against. Values:

00 = Non Applicable 01 = Spouse 18 = Self 19 = Child 23 = Sponsored Dependent

39Patient AgeN3808810Format = YYY
40FillerA/N3811813Space Filled
41FillerN1814814Zero Filled
42FillerA/N1815815Space Filled
43FillerA/N10816825Space Filled
44Group IDA/N15826840ID assigned to the cardholder group or employer group.
45Carrier NumberA/N9841849Populated with the carrier ID associated to the patient at the time the prescription was filled.
46FillerA/N15850864Space Filled
47FillerA/N8865872Space Filled
48FillerA/N1873873Space Filled
49FillerA/N1874874Space Filled
50FillerA/N1875875Space Filled
51FillerA/N1876876Space Filled
52FillerA/N1877877Space Filled
53FillerA/N10878887Space Filled
54FillerA/N1888888Space Filled
55FillerA/N10889898Space Filled
56Other Coverage CodeN2899900Values: 00 or 01 = Primary claim can be either COB segment or copay only 02 = Secondary claim - OPAP, Segment billing 03 = Reject in Primary - drug not covered 04 = Other coverage exists, payment not collected - deductible 05 = Reject in Primary - Managed Care plan denial 06 = Reject in Primary - Not a participating provider 07 = Reject in Primary - Other coverage exists - not in effect at time of service 08 = Secondary claim - OACS - copay only billing
57FillerA/N2901902Space Filled
58FillerA/N4903906Space Filled
59Service Provider ID QualifierA/N2907908Populated with the provider qualifier value associated to the pharmacy. Values: Blank = Not Specified

01 = National Provider Identifier (NPI) 02 = Blue Cross 03 = Blue Shield 04 = Medicare 05 = Medicaid

06 = UPIN

07 = NCPDP Provider ID 08 = State License 09 = Champus 10 = Health Industry Number (HIN) 11 = Federal Tax ID 12 = Drug Enforcement Agency (DEA) 13 = State Issued 14 = Plan Specific 99 = Other

60Service Provider IDA/N15909923Populated with the dispensing provider ID number.
61FillerA/N2924925Space Filled
62FillerA/N15926940Space Filled
63FillerN7941947Zero Filled
64Pharmacy NameA/N35948982The name of the dispensing provider.
65Pharmacy Address Line 1A/N559831037The address of the dispensing provider.
66Pharmacy Address Line 2A/N5510381092The address of the dispensing provider.
67CityA/N3010931122The city of the dispensing provider.
68StateA/N211231124The state of the dispensing provider.
69ZipA/N1511251139The zip of the dispensing provider.
70FillerA/N311401142Space Filled
71Pharmacy Telephone NumberN1011431152The telephone number of the dispensing pharmacy.
72Pharmacy Dispenser TypeA/N211531154RxClaim client Values (Type of pharmacy dispensing product is based on the RCPADP file):

1 = Retail 2 = Grocery Store 3 = Department Store 4 = Long Term Care 5 = Mail Order 6 = IV Infusion 7 = Dispensing Physician 8 = Indian Health Services 9 = VA Hospital 10 = State Hospital 11 = Institution 12 = HMO Pharmacy

13= DME

14 = Clinic Pharmacy 15 = Specialty 16 = Nuclear 17 = Military 18 = Compounding 0 = Other

73FillerA/N111551155Space Filled
74FillerA/N111561156Space Filled
75Network Reimbursement IDA/N1011571166Pharmacy network identifier.
76Prescriber ID QualifierA/N211671168Populated with the qualifier value associated to the prescriber. Values:

Blank = Not Specified 01= National Provider Identifier (NPI) 02 = Blue Cross 03 = Blue Shield 04 = Medicare 05 = Medicaid

06 = UPIN

07 = NCPDP Provider ID 08 = State License 09 = Champus 10 = Health Industry Number (HIN) 11 = Federal Tax ID 12 = Drug Enforcement Agency (DEA) 13 = State Issued 14 = Plan Specific 99 = Other

77Prescriber IDA/N1511691183Populated with the prescriber ID submitted on the claim transaction by the pharmacy.
78FillerA/N211841185Space Filled
79FillerA/N1511861200Space Filled
80FillerA/N312011203Space Filled
81FillerA/N1012041213Space Filled
82FillerA/N212141215Space Filled
83Prescriber Last NameA/N3512161250The prescriber's last name as submitted by the pharmacy.
84Prescriber First NameA/N2512511275The prescriber's first name as submitted by the pharmacy.
85FillerN1012761285Zero Filled
86FillerA/N212861287Space Filled
87FillerA/N1512881302Space Filled
88FillerA/N313031305Space Filled
89FillerA/N3513061340Space Filled
90FillerA/N2513411365Space Filled
91Record Status CodeA/N113661366Identifies the transaction status as assigned by the processor.

Values:

Blank = Not Specified 1 = Paid 2 = Rejected 3 = Reversed 4 = Adjusted 5 = Captured 6 = Reverse Captured 92 Claim Media Type A/N 1 1367 1367 Claim submission type code.

Values:

Blank = Not Specified 1 = POS Claim 2 = Batch Claim 3 = Pharmacy Submitted Paper Claim (UCF) 4 = Member Submitted Paper Claim (DMR) 5 = Other

93FillerA/N213681369Space Filled
94FillerA/N113701370Space Filled
95FillerN913711379Zero Filled
96Product/Service ID QualifierA/N213801381Populated with the product ID qualifier associated to the product dispensed.

Values:

Blank/00 = Not Specified 01 = Universal Product Code (UPC) 02 = Health Related Item (HRI) 03 = National Drug Code (NDC) 04 = Universal Product Number (UPN) 05 = Department of Defense (DOD) 06 = Drug Use Review/Professional Pharmacy Service (DUR/PPS) 07 = Common Procedure Terminology (CPT4) 08 = Common Procedure Terminology (CPT5) 09 = Health Care Financing Administration Common Procedural Coding System (HCPCS) 10 = Pharmacy Practice Activity Classification (PPAC) 11 = National Pharmaceutical Product Interface Code (NAPPI) 12 = International Article Numbering System (EAN) 13 = Drug Identification Number (DIN) 99 = Other 97 Product/Service ID A/N 19 1382 1400 Populated with the product ID for the product dispensed.

Format = MMMMMDDDDPP 98 Date of Service N 8 1401 1408 Identifies the date the prescription was filled or professional service rendered.

Format = CCYYMMDD 99 Adjudication Date N 8 1409 1416 Date the claim or adjustment is processed.

Format = CCYYMMDD

100FillerN614171422Zero Filled
101FillerN814231430Zero Filled
102FillerN514311435Zero Filled
103Cycle End DateN814361443Cycle End Date. Populated with the run through date of the file.

Format = CCYYMMDD

104FillerA/N214441445Space Filled
105FillerN214461447Zero Filled
106FillerN114481448Zero Filled
107FillerN814491456Zero Filled
108FillerN814571464Zero Filled
109D.0 RX NUMBERN1514651479HIPAA D.0 Reference Number assigned by the provider for the dispensed drug/product and/or service provided.
110RX NUMBER QUALIFIERA/N114801480Indicates the type of billing submitted.

Values:

1 = Rx Billing 2 = Service Billing

111FillerA/N114811481Space Filled
112FillerN814821489Zero Filled
113FillerA/N3014901519Space Filled
114FillerN915201528Zero Filled
115FillerN815291536Zero Filled
116Quantity DispensedN1015371546Quantity dispensed expressed in metric decimal units.
Format = 9999999.999Yes
117Fill NumberN215471548The code indicating whether the prescription is an original or a refill. Values:

0 = Original dispensing 1 to 99 = Refill number

118Days SupplyA/N315491551Estimated number of days the prescription will last.Yes
119Date Prescription WrittenA/N815521559Date the prescription was written.

Format = CCYYMMDD 120 Dispense as Written (DAW)/Product Selection Code A/N 1 1560 1560 Code indicating whether or not the prescriber's instructions regarding generic substitution were followed. Values:

0 = No Product Selection Indicated 1 = Substitution Not Allowed by Prescriber 2 = Substitution Allowed - Patient Requested Product Dispensed.

3= Substitution Allowed - Pharmacist Selected Product Dispensed.

4 = Substitution Allowed - Generic Drug Not in Stock 5 = Substitution Allowed - Brand Drug Dispensed as a Generic.

6 = Override 7 = Substitution Not Allowed - Brand Drug Mandated by Law 8 = Substitution Allowed - Generic Drug Not Available in Marketplace 9 = Other 121 Number of Refills Authorized N 2 1561 1562 The number of refills authorized. Values:

0 = Not specified 1 thru 99, with 99 being as needed, refills unlimited.

122FillerN115631563Zero Filled
123Unit of MeasureA/N215641565NCPDP Standard Product billing codes.

EA = Each GM = Grams ML = Milliliters

124FillerN215661567Zero Filled
125FillerA/N115681568Space Filled
126Original QuantityN1015691578The original input quantity. If any reductions or corrections to quantity take place, refer to field 116 Quantity Dispensed. This field remains fixed. Submitted on the claim by the pharmacy in metric units.Yes
127FillerN1015791588Zero Filled
128Original Day SupplyN315891591Pharmacy submitted days supply. If any reductions or corrections to day supply take place, refer to field 118 Day Supply. This field remains fixed.Yes
129FillerN215921593Zero Filled
130Compound CodeN115941594Code indicating whether or not the prescription is a compound. Values:

0 = Not Specified 1 = Not a Compound 2 = Compound

131FillerN215951596Zero Filled
132Diagnosis Code QualifierA/N215971598Code qualifying the submitted diagnosis code.

Blank or 00 = Not Specified

01 = ICD-9

02 = ICD-10

133Diagnosis CodeA/N1515991613Diagnosis code as submitted with the claim transaction. As it is not needed for adjudication, may frequently be blank.
134FillerA/N216141615Space Filled
135FillerA/N1516161630Space Filled
136FillerA/N216311632Space Filled
137FillerA/N1516331647Space Filled
138FillerA/N216481649Space Filled
139FillerA/N1516501664Space Filled
140FillerA/N216651666Space Filled
141FillerA/N1516671681Space Filled
142FillerA/N216821683Space Filled
143FillerA/N216841685Space Filled
144FillerA/N216861687Space Filled
145FillerN216881689Zero Filled
146FillerA/N216901691Space Filled
147FillerA/N216921693Space Filled
148FillerA/N216941695Space Filled
149FillerN216961697Zero Filled
150FillerA/N216981699Space Filled
151FillerA/N217001701Space Filled
152FillerA/N217021703Space Filled
153FillerN217041705Zero Filled
154FillerA/N217061707Space Filled
155FillerA/N217081709Space Filled
156FillerA/N217101711Space Filled
157FillerN217121713Zero Filled
158FillerA/N217141715Space Filled
159FillerA/N217161717Space Filled
160FillerA/N217181719Space Filled
161FillerN217201721Zero Filled
162FillerA/N217221723Space Filled
163FillerA/N217241725Space Filled
164FillerA/N217261727Space Filled
165FillerN217281729Zero Filled
166FillerA/N217301731Space Filled
167FillerA/N217321733Space Filled
168FillerA/N217341735Space Filled
169FillerN217361737Zero Filled
170FillerA/N217381739Space Filled
171FillerA/N217401741Space Filled
172FillerA/N217421743Space Filled
173FillerN217441745Zero Filled
174FillerA/N217461747Space Filled
175FillerA/N217481749Space Filled
176FillerA/N217501751Space Filled
177FillerN217521753Zero Filled
178FillerA/N217541755Space Filled
179FillerA/N1917561774Space Filled
180FillerA/N117751775Space Filled
181Reject Code 1A/N317761778The first reject code associated to the claim if it was rejected (denied). Only available when requested to be populated. See Exhibit A for denial codes.
182Reject Code 2A/N317791781The second reject code associated to the claim if it was rejected (denied).

Only available when requested to be populated. See Exhibit A for denial codes.

183 Reject Code 3 A/N 3 1782 1784 The third reject code associated to the claim if it was rejected (denied).

Only available when requested to be populated. See Exhibit A for denial codes.

184FillerA/N317851787Space Filled
185FillerA/N317881790Space Filled
186FillerA/N3017911820Space Filled
187FillerN818211828Zero Filled
188Database IndicatorA/N118291829Code to define the database used for identifying the product.

Values:

Blank = Not Specified 1 = First DataBank 2 = Medi-Span Product Line 3 = Micromedex/Medical Economics 4 = Processor Developed 5 = Other 6 = Redbook 7 = Multum

189Product/Service NameA/N3018301859Label or drug name associated to the product dispensed.
190Generic NameA/N3018601889The name associated to the GPI or Generic name.
191Product StrengthA/N1518901904The strength of the product identified in the product code.
192Dosage Form CodeA/N419051908Indicates the dosage form of the drug. See Exhibit B for dosage form codes.
193FillerA/N619091914Space Filled
194FillerA/N219151916Space Filled
195Drug TypeN119171917Code to indicate the type of drug dispensed. Values:

0 = Not Specified 1 = Single source brand 2 = Branded generic 3 = Generic 4 = O.T.C (over the counter) 5 = Multi-source Brand 196 Maintenance Drug Indicator A/N 1 1918 1918 Indicates if the drug is a maintenance drug under the client's benefit plan.

Values:

Blank = Not Applicable Y = Maintenance Drug N = Not Maintenance 197 Drug Category Code A/N 1 1919 1919 Obtained from CVS Caremark drug database.

Values:

Blank = Not Specified

1 = INSULIN

2 = ORAL CONTRACEPTIVES

3 = SURGICAL SUPPLY/MEDICAL DEVICE/OSTOMY

4 = BLOOD COMPONENT

5 = DIAGNOSTIC AGENT

6 = GENERAL ANESTHETIC

7 = FERTILITY DRUGS

8 = ANOREXIC, ANTI-OBESITY

9 = MULTIPLE VITAMIN

A = USED FOR HIV INFECTION

C = COSMETIC ALTERATION DRUGS

D = ANTIDEPRESSANTS

F = MULTIPLE VITAMIN WITH FLUORIDE

G = GROWTH HORMONES/BIOSYNTHETIC HORMONES

H = HYPNOTICS/SEDATIVES

I = MULTIPLE VITAMIN WITH IRON

M = IMMUNOSUPPRESSANTS

P = ANTIPSYCHOTICS

S = SMOKING DETERRENTS

T = ANTIANXIETY AGENTS

K = NON ORAL SYSTEMIC CONTRACEPTIVES

L = CONTRACEPTIVES OTHER

B = BULK CHEMICALS

V = IMPOTENCE AGENTS

198FillerA/N119201920Space Filled
199FillerA/N119211921Space Filled
200Denial Clarification CodeN219221923Code indicating that the pharmacist is clarifying the submission.

Values:

00 = Not Specified 01 = No Override 02 = Other Override 03 = Vacation Supply 04 = Lost Prescription 05 = Therapy Change 06 = Starter Dose 07 - Medically Necessary 08 = Process Compound For Approved Ingredients 09 = Encounters 99 = Other

201FillerN219241925Zero Filled
202FillerN219261927Zero Filled
203FillerA/N119281928Space Filled
204GCN NumberA/N619291934GCN number associated to the drug dispensed. GCNs populated are those that are in the system at the time the file is run; not based on when the claim adjudicated.
205FillerA/N619351940Space Filled
206Generic Product IdentifierA/N1419411954Identifies the generic and therapeutic class of the drug dispensed.
207Med B/ Med D IndicatorA/N119551955B = Med B drug

D = Med D drug Blank = neither

208FillerN319561958Zero Filled
209FillerN219591960Zero Filled
210FillerA/N319611963Space Filled
211FillerA/N219641965Space Filled
212Therapeutic Class Code - AHFSA/N619661971Identifies the pharmacological Therapeutic category of the product according to the American Hospital Formulary Service (AHFS) system.
213Formulary StatusA/N119721972Indicates the Formulary status of the Drug.

Values:

Blank = Not Specified P = Drug on Formulary Q = Drug not on Formulary

214FillerA/N119731973Space Filled
215FillerA/N819741981Space Filled
216FillerA/N1519821996Space Filled
217FillerA/N119971997Space Filled
218Ingredient Cost PaidN819982005The ingredient cost, based on quantity dispensed times unit cost.

Format = s$$$$$$cc

s9(6)v99Yes
219Dispensing Fee PaidN820062013Fee paid to the pharmacy for dispensing the drug. Format = s$$$$$$cc

s9(6)v99

Yes
220Total Amount Paid by all SourcesN820142021Total amount of the prescription regardless of party responsible for payment.

(This field contains the sum of Net Amount Due (258) + any of the fields included in Patient Pay Amount (222). This calculation is exclusive of payments from other payers.)

Format = s$$$$$$cc

s9(6)v99Yes
221Amount Attributed To Sales TaxN820222029Amount that is due to total sales tax paid.

Format = s$$$$$$cc

s9(6)v99Yes
222Patient Pay AmountN820302037Amount that is calculated by the processor and returned to the pharmacy is the TOTAL amount to be paid by the patient to the pharmacy; the patient's total cost share, including copayments, amounts applied to deductible, over maximum amounts, penalties, etc.

Format = s$$$$$$cc

s9(6)v99Yes
223Amount of CopayN820382045Amount to be collected from the patient that is included in 'Patient Pay Amount' that is due to a per prescription copay.

Format = s$$$$$$cc

s9(6)v99Yes
224Amount of CoinsuranceN820462053Amount to be collected from the patient that is included in 'Patient Pay Amount' that is due to a per prescription coinsurance. Format = s$$$$$$cc
s9(6)v99Yes
225Amount Attributed To Product SelectionN820542061Amount to be collected from the patient that is included in Patient Pay Amount that is due to the patient's selection of drug product.

Format = s$$$$$$cc

s9(6)v99Yes
226Amount Applied to Periodic DeductibleN820622069The amount to be collected from a patient that is applied to a periodic deductible.

Format = s$$$$$$cc s9(6)v99

Yes
227FillerN820702077Zero Filled
228MAC Reduced IndicatorA/N120782078Indicates if a claim payment was reduced due to a MAC program.

Values:

Blank = Not applicable Y = Reduced to MAC pricing N = Not MAC Reduced 229 Client Pricing Basis of Cost A/N 2 2079 2080 Code indicating the method by which ingredient cost submitted is calculated based on client pricing. Values:

Blank = Not Specified

01 = AWP

1P = Pre-settlement AWP

02 = ACQ

03 = Manufacturer Direct Pricing 04 = Federal upper limit 05 = Average Generic Pricing 06 = U&C 07 = Submitted Ingredient Cost 08 = State MAC 09 = Unit 10 = U&C or Copay 230 Generic Indicator A/N 1 2081 2081 Distinguishes if product priced as Generic or Branded product: As defined by processor.

RxClaim client values:

M = Multi source branded product O = Brand Original N = Single source branded product Y = Generic product Z = Override generic indicator, price as "N" X = Price as "N", report as "Y" 231 Out of Pocket Apply Amount N 8 2082 2089 Total Patient Pay Amount. Same as Field 222.

Format = s$$$$$$cc s9(6)v99

Yes
232FillerN920902098Zero Filled
233FillerN820992106Zero Filled
234AWP Type IndicatorA/N121072107A = AWP Pricing Used

P = PAWP Pricing Used 235 Average Wholesale Unit Price N 10 2108 2117 Populate the AWP or PAWP unit price of the medication based on how claim adjudicated. Refer to AWP Type Indicator.

Format = s$$$$$ccccc s9(5)v9(5)

Yes
236FillerN321182120Zero Filled
237Average Wholesale Unit Price (Full)N1721212137Populate the AWP unit price. Provide full 17-byte value. Pending 9/22 release.Yes
238FillerN521382142Zero Filled
239Ingredient Cost SubmittedN821432150The submitted ingredient cost based on quantity dispensed times unit cost.

Format = s$$$$$$cc s9(6)v99

Yes
240Usual & Customary ChargeN821512158Amount charged cash customers for the prescription exclusive of sales tax or other amounts claimed.

Format = s$$$$$$cc

s9(6)v99Yes
241Flat Sales Tax Amount PaidN821592166Amount to be collected from the patient that is included in Patient Pay Amount that is due to sales tax paid when a flat sales tax is used.

Format = s$$$$$$cc

s9(6)v99Yes
242Percentage Sales Tax Amount PaidN821672174Amount to be collected from the patient that is included in Patient Pay Amount that is due to sales tax paid when a percentage is used to calculate the sales tax.

Format = s$$$$$$cc

s9(6)v99Yes
243FillerN721752181Zero Filled
244FillerA/N221822183Space Filled
245FillerN821842191Zero Filled
246FillerN821922199Zero Filled
247FillerA/N222002201Space Filled
248FillerN822022209Zero FilledYes
249FillerA/N222102211Space Filled
250FillerN822122219Zero Filled
251FillerA/N222202221Space Filled
252FillerN822222229Zero Filled
253FillerN822302237Zero Filled
254FillerA/N122382238Space Filled
255FillerN1022392248Zero Filled
256FillerA/N122492249Space Filled
257FillerN1022502259Zero Filled
258Net Amount Due
(Total Amount Billed/Paid)N822602267Net amount paid to provider by the payer or net amount due from the client to the payer. This is the Total Amount Billed/Paid.

Format = s$$$$$$cc

s9(6)v99Yes
259Basis of Reimbursement DeterminationN222682269Code identifying how the reimbursement amount was calculated for 'ingredient cost paid' (506-F6).

Values:

00 = Not Specified 01 = Ingredient Cost Paid as Submitted 02 = Ingredient Cost Reduced to AWP Pricing 03 = Ingredient Cost Reduced to AWP Less X% Pricing 04 = U&C Paid as Submitted 05 = Paid Lower of Ingredient Cost Plus Fees versus U&C 06 = MAC Pricing Ingredient Cost Paid 07 = MAC Pricing Ingredient Cost Reduced to MAC 08 = Contract Pricing 09 = Acquisition Pricing 14 = OPPR Amount (Other Payer-Patient Responsibility) 20 = Nat Avg Drug Acq Cost

260Accumulated Deductible AmountN822702277Amount in dollars met by the patient/family in a deductible plan.
Format = s$$$$$$cc s9(6)v99Yes
261FillerN822782285Zero Filled
262FillerN822862293Zero Filled
263FillerN822942301Zero Filled
264FillerN823022309Zero Filled
265FillerN823102317Zero Filled
266FillerN823182325Zero Filled
267Amount Exceeding Periodic Benefit MaximumN823262333Amount to be collected from the patient that is included in patient pay amount (222) that is due to the patient exceeding a periodic benefit maximum.

Format = s$$$$$$cc

s9(6)v99Yes
268FillerA/N223342335Space Filled
269Basis of Calculation - CopayA/N223362337Code identifying how the reimbursement amount was calculated for 'copay'.

Values:

00 = Not Specified 01 = Ingredient Cost Paid as Submitted 02 = Ingredient Cost Reduced to AWP Pricing 03 = Ingredient Cost Reduced to AWP Less X% Pricing 04 = U&C Paid as Submitted 05 = Paid Lower of Ingredient Cost Plus Fees versus U&C 06 = MAC Pricing Ingredient Cost Paid 07 = MAC Pricing Ingredient Cost Reduced to MAC 08 = Contract Pricing 09 = Acquisition Pricing 14 = OPPR Amount (Other Payer-Patient Responsibility) 20 = Nat Avg Drug Acq Cost

270FillerA/N223382339Space Filled
271FillerA/N223402341Space Filled
272FillerA/N223422343Space Filled
273FillerA/N123442344Space Filled
274FillerN823452352Zero Filled
275FillerA/N123532353Space Filled
276FillerA/N123542354Space Filled
277FillerN823552362Zero Filled
278FillerN823632370Zero Filled
279FillerN823712378Zero Filled
280FillerA/N123792379Space Filled
281FillerN423802383Zero Filled
282FillerN1123842394Zero FilledYes
283FillerN223952396Zero Filled
284FillerN1123972407Zero Filled
285Adjustment Issue IDN1024082417Internal CVS|Caremark EAS Issue ID
286FillerN124182418Zero Filled
287Processor Defined Prior Authorization Certification CodeN224192420Code submitted by the pharmacy to indicate the prior authorization certification code.

Values:

00 = Not Specified 01 = Prior Authorization 02 = Medical Certification

03 = EPSDT

04 = Exemption from Copay 05 = Exemption from Rx 06 = Family Plan Indicator

07 = TANF

08 = Payer Defined Exemption

288 Adjustment Reason Code A/N 3 2421 2423 11 - Not Specified

70 - LICS ADJUSTMENT

71 - LTC PATIENT PAY ADJUSTMENT

72 - CLAIM PAYMENT ADJUSTMENT

73 - MED D CLAIM PAYMENT ADJUSTMENT

74 - INTEREST PAYMENT

75 - AUTO-TROOP TRANSFER

76 - MANUAL TROOP TRANSFR

77 - PLAN DESIGN ADJUSTMENT

78 - CLAIM ADJUSTMENT- COB

79 - PHARM AUDIT RECOVERY DAILY

80 - CLAIM PAYMENT ADJUSTMENT

81 - PHARMACY COMPLIANCE FEE

82 - SALES TAX ADJUSTMENT

83 - MISC FEE BILLING ADJUSTMENT

84 - PHARMACY REQUESTED ADJUSTMENT

85 - PHARMACY ACKNOWLEDGED ADJ

86 - PHARMACY REQUESTED ADJUSTMENT

87 - FINANCIAL ASSISTANCE

88 - FINANCIAL ASST - RECOVERY

89 - PROCESSOR ERROR

90 - WRONG COPAY

91 - DISPENSING LIMITS

92 - WRONG CARRIER/GROUP

93 - PATIENT PAYS DIFF

94 - PAY DIFF OF CLM & PD

95 - OTHER

99 - CLAIM PAYMENT ADJUSTMENT

289FillerA/N124242424Space Filled
290FillerA/N3024252454Space Filled
291FillerN824552462Zero Filled
292Eligibility COB IndicatorA/N124632463Coordination of Benefits code as provided on Client eligibility.

Values:

Blank = Not specified 1 = Payer is primary 2 = Payer is secondary 3 = Payer is tertiary

293FillerA/N124642464Space Filled
294FillerA/N1024652474Space Filled
295FillerN824752482Zero Filled
296COB Primary Payer Amount PaidN824832490Amount paid by primary payer for product or service. Format = s$$$$$$cc s9(6)v99Yes
297OPAR AmountN824912498Other Payer Amount Received Format = s$$$$$$cc s9(6)v99Yes
298FillerN824992506Zero Filled
299COB Primary Payer CopayN825072514Copay amount according to primary payer for product or service. Format = s$$$$$$cc s9(6)v99Yes
300FillerA/N1025152524Space Filled
301FillerN825252532Zero Filled
302FillerN825332540Zero Filled
303FillerN825412548Zero Filled
304FillerN825492556Zero Filled
305FillerN825572564Zero Filled
306Transaction IDA/N3025652594Unique Claim Identifier (i.e., Doc#, RxClaim/Sequence #, BRT-ID/BRI-NB/Void Indicator)

The RxClaim/Sequence Number is for RxClaim clients and is defined as:

A unique number assigned by RxClaim based upon the following format: yyddssssshheee yy = The year submitted ddd = the julian date sssss = the number of seconds into the day hh = hundredths of seconds eee = the engine on which the claim was processed

The Sequence number of 999 is created along with the RxClaim number. The sequence number continues to increment down by one for every new paid or rejected transaction. If a claim is reversed, the reversal transaction retains both the same RxClaim identification of a paid-reversal combination.

307FillerA/N2025952614Space Filled
308FillerA/N926152623Space Filled
309FillerA/N426242627Space Filled
310FillerA/N526282632Space Filled
311FillerA/N226332634Space Filled
312Account IDA/N1526352649Populated with the RxClaim account ID associated to the patient at the time the prescription was filled. The definition varies from client to client.

If not applicable the field will be space filled.

313 Care Facility A/N 10 2650 2659 Populated with the RxClaim care facility ID associated to the patient at the time the prescription was filled. The definition varies from client to client.

If not applicable the field will be space filled.

314Specialty RX ClaimA/N126602660Indicates if the claim is SpecialtyRx. 'N' = Claim was not invoiced as an SRx drug. 'Y' = Claim was invoiced as an SRx drug
315FillerA/N126612661Space Filled
316FillerA/N326622664Space Filled
317Alternate IDA/N2026652684Cardholder Alternate ID. Only populated when Alternate ID is being used by the client.
318FillerA/N126852685Space Filled
319FillerA/N126862686Space Filled
320FillerA/N126872687Space Filled
321FillerA/N126882688Space Filled
322FillerA/N126892689Space Filled
323FillerA/N826902697Space Filled
324FillerA/N2126982718Space Filled
325Vaccine Administration Fee PaidN827192726This field will be populated only for Vaccine + Administration fee claims or for Administration fee claims. Format = s$$$$$$cc S9(6)V99
Yes
326Drug Admin Fee Type CodeA/N127272727This field will be populated only for Vaccine processing claims.

V = Vaccine only claims A = Admin fee only claims C = Vaccine & Admin fee claims Blank=For non Vaccine claims

327 Maintenance Choice Indicator A/N 1 2728 2728 This field will be populated if the claim paid using Maintenance Choice.

M = Claim paid using Maintenance Choice Blank = Non-Maintenance Choice Claim or Maintenance Choice N/A

328Applied HRA AmountN1127292739HRA amount. Format = S9(9)V99
If not applicable the field will be zero filled.Yes
329CB5 Qualifier 1A/N227402741Texas Medicaid Only
330CB5 OTH Amount 1N927422750Texas Medicaid OnlyYes
331CB5 Qualifier 2A/N227512752Texas Medicaid Only
332CB5 OTH Amount 2N927532761Texas Medicaid OnlyYes
333CB5 Qualifier 3A/N227622763Texas Medicaid Only
334CB5 OTH Amount 3N927642772Texas Medicaid OnlyYes
335PD6 Client Total Other AmountN927732781Texas Medicaid Only
336PD6 Buy Total Other AmountN927822790Texas Medicaid OnlyYes
337FillerA/N121027914000Space Filled

CMK PA History Trailer Record

Post Adjudication History Trailer Record
Field #Field NameFormatSizeStartEndDescription/ValuesOverpunch
1Record TypeA/N212PT = PA History Trailer Record
2Total Record CountN10312The total number of records being submitted, including header and trailer in count.
3Total Net Amount DueN121324Summarization of Net Amount Due (258)

Format s$$$$$$$$$$cc

s9(10)v99Yes
4FillerA/N3976254000Spaces

Overpunch Characters

Overpunch Characters
Overpunch allows representation of positive and negatives in a numeric field without having to expand the size of the field for a plus or minus sign. The overpunch character replaces the right-most character in a numeric field. In a six-digit field, 99.95 would be represented as 00999E. In the same field, a negative 99.95 would be represented as 00999N. Lack of an overpunch character implies a positive amount - in other words, a positive 99.95 could be sent on the file as 009995.
NumberPositive OverpunchNegative Overpunch
0{}
1AJ
2BK
3CL
4DM
5EN
6FO
7GP
8HQ
9IR

Exhibit A

EXHIBIT A: Reject Codes, RxClaim Clients
NCPDP Reject Codes applicable to fields 181 - 183, RxClaim clients
CodeMessageCodeMessageCodeMessage
01M/I Bin50Non-Matched Pharmacy99Host Processing Error
02M/I Version Number51Non-Matched Group IDCAM/I Patient First Name
03M/I Transaction Code52Non-Matched Cardholder IDCBM/I Patient Last Name
04M/I Processor Control Number53Non-Matched Person CodeCCM/I Cardholder First Name
05M/I Pharmacy Number54Non-Matched NDC NumberCDM/I Cardholder Last Name
06M/I Group Number55Non-Matched NDC Pkg SizeCEHome Plan Indicator
07M/I Cardholder ID56Non-Matched Prescriber IDCFEmployer Name
08M/I Person Code57Non-Matched PA/MC NumberCGEmployer Address
09M/I Birthdate58Non-Matched Primary PrescriberCHEmployer City
10M/I Sex Code59Non-Matched Clinic IDCIEmployer State
11M/I Relationship Code60(none)CJEmployer Zip
12M/I Customer Location61(none)CKEmployer Phone
13M/I Other Coverage Cd62(none)CLEmployer Contact
14M/I Eligibility Override63(none)CMPatient Address
15M/I Date Filled64(none)CNPatient City
16M/I Rx Number65Patient not coveredCOPatient State
17M/I New-Refill Code66Patient age exceeds maximumCPPatient Zip
18M/I Metric Quantity67Filled before coverage effectiveCQPatient Phone number
19M/I Days Supply68Filled after coverage expiredCRCarrier ID
20M/I Compound Code69Filled after coverage terminatedCTPatient Social Security Number
21M/I NDC Number70NDC not coveredDCM/I Dispensing Fee
22M/I Dispense as Written Code71Prescriber not coveredDPM/I Drug type override
23M/I Ingredient Cost72Primary Prescriber not coveredDQM/I U&C
24M/I Sales Tax73Refills not coveredDRM/I Doctor last name
25M/I Prescriber ID74Patient pay exceeds payableDSM/I Postage amount
26(none)75Prior Auth requiredDTM/I Unit dose indicator
27(none)76Plan Limitations exceededDUM/I Gross Amount
28M/I Date Rx Written77Discontinued NDCDVM/I Other payor amount
29M/I # Refills Authed78Cost exceeds maximumDWM/I Basis of days supply
30M/I PA/MC Code & Nbr79Refill too soonDXM/I Patient paid amount
31(none)80Drug-diagnosis mismatchDYInjury date
32M/I Level of Service81Claim too oldDZClaim reference ID
33M/I Rx Origin Code82Claim is post-datedE1Alternate product type
34M/I Rx Denial Override83Duplicate paid/capture claimE2Alternate product code
35M/I Primary Prescriber84Claim has not been paid/capturedE3Incentive amount submitted
36M/I Clinic Identification85Claim not processedE4DUR conflict code
37(none)86Submit manual reversalE5DUR intervention code
38M/I Basis of Cost87Reversal not processedE6DUR Outcome code
39M/I Diagnosis code88DUR reject errorE7Metric decimal quantity
40Non network pharmacy89Rejected claim fees paidE8Other payor date
41Submit bill to other payor90Host hung upM1Patient not covered
42(none)91Host response errorM2Recipient locked in
43(none)92System/Host unavailableM3Host PA/MC error
44(none)93Planned unavailableM4Prescription nbr/time
45(none)94Invalid messageM5Requires manual claim
46(none)95(none)M6Host eligibility error
47(none)96(none)M7Host drug file error
48(none)97(none)M8Host provider file error
49(none)98(none)MZError overflow
818MA Not Covrd, Plan Exclsn
ADBilling Provider not eligible to bill
R6Prod/Service not appropriate for this location
7XDay Supply Exceeds Plan Limits
EZMissing/Invalid Prescriber ID Qualifier
REMissing/Invalid Compound Produc ID Qualifier

Exhibit B EXHIBIT B: Drug Dosage Form Codes and Descriptions

Refer to Dosage Form Code, Field 192 (bytes 1905 - 1908)

FormDescription
AEPBArsl Pwdr-Breath Activate
AEROAerosol
AERBAerosol, Breath Activated
AERPAerosol, powder
AERSAerosol, solution
BARBar
BEADBeads
CPEPCap Enteric Coated Part
CPDRCapsule Delayed Release
CPECCapsule Enteric Coated
CPSPCapsule Sprinkle
CP12Capsule SR 12 HR
CP24Capsule SR 24 HR
CPCRCapsule, controlled rlse
CAPSCapsule, conventional
CONCConcentrate
CREACream
CRYSCrystals
DEVIDevice (not specified)
TESTDiagnosis test(not spcfd)
DPRHDiaphragm
DISKDisk
DCHEDouche, not specified
DCHPDouche, powder
DCHSDouche, solution
ELIXElixir
EMULEmulsion
ENEMEnema
FILMFilm
FLAKFlakes
EXTRFluid extract
FOAMFoam
GASGas
GELGel (jelly)
SOLGGel Forming Solution
GRANGranules
GREFGranules Effervescent
GUMGum
IMPLImplant
INHAInhaler
INJInjection (not specd)
INSTInsert
IUDIntrauterine device
KITKit (multiple component)
LEAVLeaves
LIQDLiquid (Not spec'd)
LQCRLiquid, cntrlld release
LPOPLozenge on a Handle
LOTNLotion
LOZGLozenge
MISCMiscellaneous (Not specd)
NEBUNebulization solution
OCSYOcular System
OILOil
OINTOintment
PACKPack
PADSPad
PSTEPaste
PTCHPatch
PTTWPatch Twice Weekly
PTWKPatch Weekly
PT24Patch 24 HR
PT72Patch 72 HR
PLLTPellet
POWDPowder
PDEFPowder Effervescent
PUDGPudding
RINGRing
SHAMShampoo
SHEESheet
SOLNSolution
SOLRSolution, when reconst'd
SPRTSpirit
STCKStick
STRPStrip
SUPPSuppository
SUSPSuspension
SUSRSuspension, when reconst
SWABSwab
SYRPSyrup
TABSTablet
TBDRTablet Delayed Release
TBDPTablet Dispersible
TBSOTablet Soluble
TB12Tablet SR 12 HR
TB24Tablet SR 24 HR
CHEWTablet, chewable
TBCRTablet, cntld release
TBEFTablet, effervescent
TBECTablet, enteric coated
SUBLTablet, sublingual
TAMPTampon
TAPETape
TARTar
TINCTincture
TDSYTransdermal system
TROCTroche
WAFRWafer
WAXWax
WHIPWhip
CAPACap Abuse Deter
CPEACap ER Deter
C12ACap 12HR Deter
C24ACap 24HR Deter
TABATab Abuse Deter
TBEATab ER Deter
T12ATab 12HR Deter
T24ATab 24HR Deter
THPKTherapy Pack
CPPKCap Ther Pack
CDPKCPDR Ther Pack
CEPKCPER Ther Pack
C2PKCP12 Ther Pack
C4PKCP24 Ther Pack
TBPKTab Ther Pack
TDPKTBDR Ther Pack
TPPKTBDP Ther Pack
TEPKTBER Ther Pack
T2PKTB12 Ther Pack
T4PKTB24 Ther Pack
LQPKLiqd Ther Pack
SOPKSoln Ther Pack
SUPKSusp Ther Pack
PENPen-injector
SOPNSoln Pen-inj
SUPNSusp Pen-inj
AUIJAuto-injector
SOAJSoln Auto-inj
SUAJSusp Auto-inj
JTAJJet-injector
SOTJSoln Jet-inj
SUTJSusp Jet-inj
CARTCartridge
SOCTSoln Cartridge
SUCTSusp Cartridge
PRSYPrefilled Syr
SOSYSoln Pref Syr
SUSYSusp Pref Syr
CSERCap ER Sprinkle
CS12CP12 Sprinkle
CS24CP24 Sprinkle
PNKTPen-Injector Kit
AJKTAuto-Injector Kit
JTKTJet-Injector Kit
CTKTCartridge Kit
PSKTPrefilled Syringe Kit
SUERSuspension ER
SRERFor Susp ER
EXHAExhaler
EXHPExhaler Powder
EXHLExhaler Liquid
EXHSExhaler Solution
EXHUExhaler Suspension
TB3DTab Disint Sol
TB3ETab Dis Sol ER
CSDRCap DR Sprinkle
CHERTablet ER Chew
TBDDTab DR Disp
TBEDTab ER Disp

image1.jpeg

File details come from the government source that posted it. Updated .