D020_AttachA_RPC_Data_-_revised.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
TRICARE Pharmacy Program, Fourth Generation (TPharm4)
Solicitation number
HT9402-13-R-0001
Issued by

About this file

Attachment A to CDRL D020

View the file

Other files

File Type Posted
EXHIBIT_L-8_Draft_TFL_(Over_65)_Mandatory_Mail_Drug_List_(Dec_18 _2013).pdf PDF
M270_TFL_Pharmacy_Pilot_Opt-Out_Report.pdf PDF
EXHIBIT_L-10_Historical_Data_and_Other_Info_Available_to_Offerors_(Jan_13 _2013).pdf PDF
Amendment_0006.pdf PDF
M250_TFL_Pharmacy_Pilot_Summary_and_Savings_Report.pdf PDF
DRAFT_Data_Pkg_24_Retail_Utilization_Detail_CY2013_(Dec_16 _2013).xlsx XLSX spreadsheet
Data_Pkg_5_Utilization_of_Retail_Maintenance_Meds_by_Benes_Over_65_CY11-CY13_(Dec_13 _2013).xlsx XLSX spreadsheet
Data_Pkg_14_TRICARE_Beneficiaries_by_Zip_Code_(Dec_10 _2013).xlsx XLSX spreadsheet
Data_Pkg_9_Historical_MTF_Claim_Volume_(Dec_10 _2013).xlsx XLSX spreadsheet
Data_Pkg_4_Retail_Utilization_Detail_CY2012_(Dec_16 _2013).xlsx XLSX spreadsheet
Data_Pkg_7_Historical_Deployed_Prescription_Volume_(Dec_6_2013).xlsx XLSX spreadsheet
Data_Pkg_10_Historical_MTF_Call_Volume_(Dec_13_2013).xlsx XLSX spreadsheet
EXHIBIT_L-13_Background_Information_for_Retail_Network_Reimbursement_Table_L-1_(Sep_17 _2013).pdf PDF
Amendment_0005.pdf PDF
Amendment_0004.pdf PDF
Data_Pkg_17_Historical_TMDS_Claims_Volume_(Aug_27 _2013).xlsx XLSX spreadsheet
D030_Contractor_Payment-Check_Issue_Data.pdf PDF
EXHIBIT_L-4_DoD_Benefit_Design_(Aug_29 _2013).doc DOC document
EXHIBIT_L-5_DoD_Formulary_Restrictions_and_Limitations_(Aug_29 _2013).xlsx XLSX spreadsheet
EXHIBIT__L-1_Table_L-1_TPharm4_-_Ammendment_3_(Aug_13 _2013).docx DOCX document
EXHIBIT_L-10_Historical_Data_and_Other_Info_Available_to_Offerors_Amendment_3_(Aug_13 _2013).pdf PDF
Q A_Seventh_Set_Answers.pdf PDF
EXHIBIT_L-12_Instructions_for_Completing_Retail_Network_Reimbursement _Table_L-1_(Aug_13 _2013).pdf PDF
EXHIBIT_L-10_Historical_Data_and_Other_Info_Available_to_Offerors_(Aug_06 _2013).pdf PDF
EXHIBIT_L-5_DoD_Formulary_Restrictions_and_Limitations_(April_4 _2013).xlsx XLSX spreadsheet
Q A_Fifth_Set_Answers.pdf PDF
Data_Pkg_9_Historical_MTF_Claim_Volume_(Aug_1 _2013).xlsx XLSX spreadsheet
Data_Pkg_1_Utilization_Data_for_CY2011_(Aug_1 _2013)_.xlsx XLSX spreadsheet
Q A_Fourth_Set_Answers.pdf PDF
Amendment_0001.pdf PDF
Q A_Third_Set_Answers.pdf PDF
Q A_First_Set_Answers.pdf PDF
Exhibit_L-10_Technical_ _Interface_Documents.zip ZIP file
Exhibit_L-10_Historical_Data_Files.zip ZIP file
Section_J_Attachments_1-3.zip ZIP file
HT9402-13-R-0001.pdf PDF
Draft_Data_Pkg_17_Historical_Theater_Medical_Data_Store_(TMDS)_Volume_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Data_Pkg_7_Historical_Deployed_Prescription_Volume_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Data_Pkg_4_Retail_Utilization_Detail_CY2012_(May_15 _2013).xlsx XLSX spreadsheet
Instructions_to_Order_-_Confidential_and_Protected_Information.pdf PDF
Summary_of_Pre-Solicitation_Data_Files.pdf PDF
Draft_Managed_Care_Pricing_File_Info_May_15 _2013).pdf PDF
Draft_Data_Pkg_1_Utilization_Data_for_Jan__-_Dec_2011_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Data_Pkg_15_Misc_Summary_Volumes_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Managed_Care_Pricing_File_-_TMOP_Sample_(May_15 _2013).zip ZIP file
Draft_Data_Pkg_11_Indian_Health_Service_(IHS)_Pharmacy_Listing_(March _2013).xlsx XLSX spreadsheet
Draft_Managed_Care_Pricing_File_-_MTF_Sample_Part_3_of_3_(April_25 _2013).zip ZIP file
Draft_Data_Pkg_13_IHS_ _VA_Historical_Claims_Volume_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Managed_Care_Pricing_File_-_MTF_Sample_Part_2_of_3_(April_25 _2013).zip ZIP file
Draft_DoD_Formulary_Restrictions_and_Limitations_(April_4 _2013).pdf PDF
Show 40 more

50 files listed here. See the rest on GovTribe.

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

RPC Data Elements

TRICARE Pharmacy Program, Fourth Generation (TPharm4)
Retail Pharmacy Claims (RPC) Data Requirements (updated 2013-06-30)
NOTE: These data requirements are in addition to those specified in TRICARE Systems Manual (TSM).
1.0 General Information
1.1 The TPharm contractor shall submit TED records (batch/voucher header, non-institutional, and provider) to TRICARE Management Activity (TMA) as per TRICARE Systems Manual (TSM). In addition, the contractor shall submit Retail Pharmacy Claims (RPC) data files to TMA as instructed below.
1.2 Retail Pharmacy Claims (RPC) data files are required for all claims processed by the TPharm contractor for drugs and supplies dispensed at or through non-DoD pharmacies. RPC data files are NOT required for claims for administrative services (such as Prior Authorization or Medical Necessity) or for items dispensed through TRICARE Pharmacy Home Delivery (also known as TRICARE Mail Order Pharmacy or TMOP).
1.3 TED records for claims processed by the TPharm contractor for drugs and supplies dispensed at or through non-DoD pharmacies are submitted with BATCH/VOUCHER CLIN/ASAP ACCOUNT NUMBER (on BATCH/VOUCHER HEADER records) starting with either "1889" or "18D9". Each time the contractor submits or resubmits such TED records, it shall also submit or resubmit "companion" RPC records.
2.0 RPC-Specific Data Communications Technical Requirements

2.1 Communication Protocol: Connect:Direct through MHS B2B Gateway or Connect:Direct using Internet and Secure+.

2.2 Timing and other requirements: First submission shall be submitted at the same time as the first TED submission. Subsequent submissions shall be submitted with subsequent TED submissions.
3.0 RPC-Specific Transmission Records

3.1 The requirement for all electronic transmissions will incorporate the Health Insurance Portability and Accountability Act of 1996 (HIPAA) mandated standards wherever feasible.

3.2 The first record in each transmission to TMA will be a transmission header, using the following format. Where value is specified under comments, the value must be reported exactly as shown.

TRANSMISSION HEADER RECORD FORMAT

Position(s)DescriptionContentComment
1-8AlphaData TypeMust be "RPC Data".
9-10**DelimiterMust be "**".
11-22AlphanumericFile Name"RPyyyymmddnnss", where yyyymmdd is the Transmission Date, nn is the TMA-assigned Contractor Number, and ss is the sequence number (01-99) of the file sent on a particular day.
23-24**DelimiterMust be "**".
25-29AlphaMust be "FSIZE".
30-VariableNumericFile SizeTotal number of VOUCHER records and CLAIM records.

Includes transmission header, excludes transmission trailer.

Variable
(2 positions)**DelimiterMust be "**".
Variable
(6 positions)AlphaRecord TypeMust be "RTYPEV".
Variable
(2 positions)**DelimiterMust be "**".
Variable
(7 positions)AlphaMust be "MAXRLEN".
Variable
(2 positions)**DelimiterMust be "**".
VariableNumericMaximum
Record Length1000.

(Length of the longest variable length record within the transmission.)

Variable
(2 positions)**DelimiterMust be "**".
Variable - 80BlankReservedMust be spaces.
3.3 Appended to the end of each transmission to TMA will be a transmission trailer record. The format for the transmission trailer record follows:

TRANSMISSION TRAILER RECORD FORMAT

Position(s)DescriptionContentComment
1AlphaRecord IDMust be "@" sign.
2-3AlphanumericContractor
NumberTMA-assigned Contractor Number.
4-10AlphanumericTransmission
DateEnter in YYYYDDD format.
11-14NumericVoucher CountNumber of VOUCHER records in the transmission.
15-20NumericRecord CountTotal number of VOUCHER records and CLAIM records.

Excludes transmission header and transmission trailer.

21 - 80 Blank Reserved Must be spaces.

4.0 RPC VOUCHER Data Element Layout
4.1 For every TED BATCH/VOUCHER HEADER record with BATCH/VOUCHER CLIN/ASAP ACCOUNT NUMBER starting with "1889" or "18D9", the contractor shall also submit a matching and identical RPC VOUCHER record.
NCPDPPOSITIONCorresponding TED Data Element
ELNELEMENT NAMEField #FORMATWidthFROMTHRUELNELEMENT NAME
0-001HEADER TYPE INDICATORn/aX1110-001HEADER TYPE INDICATOR
0-010CONTRACT NUMBERn/aX(13)132140-010CONTRACT NUMBER
0-015BATCH/VOUCHER IDENTIFIERn/aX115150-015BATCH/VOUCHER IDENTIFIER
0-025BATCH/VOUCHER CLIN/ASAP ACCOUNT NUMBERn/aX(8)816230-025BATCH/VOUCHER CLIN/ASAP ACCOUNT NUMBER
0-030BATCH/VOUCHER DATEn/aYYYYDDD724300-030BATCH/VOUCHER DATE
0-035BATCH/VOUCHER SEQUENCE NUMBERn/aX(2)231320-035BATCH/VOUCHER SEQUENCE NUMBER
0-040BATCH/VOUCHER RESUBMISSION NUMBERn/aX(2)233340-040BATCH/VOUCHER RESUBMISSION NUMBER
0-045TOTAL NUMBER OF RECORDSn/a9(7)735410-045TOTAL NUMBER OF RECORDS
0-050TOTAL AMOUNT PAIDn/aS9(10)V991242530-050TOTAL AMOUNT PAID
0-055INITIAL TRANSMISSION DATE (TMA DERIVED)n/aYYYYMMDD854610-055INITIAL TRANSMISSION DATE (TMA DERIVED)
0-060TMA BATCH/VOUCHER PROCESSING DATE (TMA DERIVED)n/aYYYYMMDD862690-060TMA BATCH/VOUCHER PROCESSING DATE (TMA DERIVED)
0-065FUND ACCOUNTINGn/aS9(8)V991070790-065FUND ACCOUNTING
5.0 RPC CLAIM Data Element Layout
5.1 For every TED NON-INSTITUTIONAL record submitted together with a TED BATCH/VOUCHER HEADER record with BATCH/VOUCHER CLIN/ASAP ACCOUNT NUMBER starting with "1889" or "18D9", the contractor shall also submit a companion RPC CLAIM record consisting of data elements listed below.
5.2 Relationship between RPC CLAIM data elements and TED NON-INSTITUTIONAL data elements:
- TED RECORD INDICATOR data: The first 7 data elements, in the first 33 positions, on the RPC CLAIM record shall be identical to the first 7 data elements, and the first 33 positions, on the companion TED NON-INSTITUTIONAL record, as per Chapter 2, Section 2.2 of TSM.
- Other TED data: The next 12 RPC CLAIM elements shall be identical to those on the companion TED NON-INSTITUTIONAL record, albeit in different positions.
- NCPDP data: The rest of the RPC CLAIM elements shall be populated with original claim data as per NCPDP Telecommunication Standard Version D.0 or later.
NCPDPPOSITIONCorresponding TED Data Element
ELNELEMENT NAMEField #FORMATWidthFROMTHRUELNELEMENT NAME
X-001RECORD TYPE INDICATORn/aX(1)1112-001RECORD TYPE INDICATOR
X-015FILING DATEn/aYYYYDDD7282-015FILING DATE
X-020FILING STATE/COUNTRY CODEn/aX(3)39112-020FILING STATE/COUNTRY CODE
X-025SEQUENCE NUMBERn/aX(7)712182-025SEQUENCE NUMBER
X-030TIME STAMPn/aX(6)619242-030TIME STAMP
X-035ADJUSTMENT KEYn/aX(1)125252-035ADJUSTMENT KEY
X-040DATE TED RECORDS PROCESSED TO COMPLETIONn/aYYYYMMDD826332-040DATE TED RECORDS PROCESSED TO COMPLETION
X-055SERVICE BRANCH CLASSIFICATION CODE (SPONSOR)n/aX(1)134342-055SERVICE BRANCH CLASSIFICATION CODE (SPONSOR)
X-100TYPE OF SUBMISSIONn/aX(1)135352-100TYPE OF SUBMISSION
X-105CLAIM FORM TYPE/EMC INDICATORn/aX(1)136362-105CLAIM FORM TYPE/EMC INDICATOR
X-155END DATE OF CAREn/aYYYYMMDD837442-155END DATE OF CARE
X-170NATIONAL DRUG CODEn/aX(11)1145552-170NATIONAL DRUG CODE
X-185AMOUNT ALLOWED BY PROCEDURE CODEn/aS9(7)V99956642-185AMOUNT ALLOWED
X-190AMOUNT PAID BY OTHER HEALTH INSURANCE (OHI)n/aS9(7)V99965732-190AMOUNT PAID BY OTHER HEALTH INSURANCE (OHI)
X-205AMOUNT PAID BY GOV’T CONTRACTOR BY PROCEDURE CODEn/aS9(7)V99974822-205AMOUNT PAID BY GOV’T CONTRACTOR BY PROCEDURE CODE
X-230PROVIDER ORGANIZATIONAL NPI NUMBERn/aX(15)1583972-230PROVIDER ORGANIZATIONAL NPI NUMBER
X-250PROVIDER ZIP CODEn/aX(9)9981062-250PROVIDER ZIP CODE
X-265PROVIDER NETWORK STATUS INDICATORn/aX(1)11071072-265PROVIDER NETWORK STATUS INDICATOR
X-305SPECIAL PROCESSING CODEn/aX(8)81081152-305SPECIAL PROCESSING CODE
X-601Transaction Response Status112-ANX(1)1116116<--- start of Status Segment fields
X-604Authorization Number5Ø3-F3X(20)20117136
X-607Service Provider ID Qualifier2Ø2-B2X(2)2137138<--- start of Header Segment fields
X-610Service Provider ID2Ø1-B1X(15)15139153
X-613Date of Service4Ø1-D1YYYYMMDD8154161
X-616Prescription/Service Reference Number Qualifier455-EMX(1)1162162<--- start of Claim Segment fields
X-619Prescription/Service Reference Number4Ø2-D29(12)12163174
X-622Product/Service ID Qualifier436-E1X(2)2175176
X-625Product/Service ID4Ø7-D7X(19)19177195
X-628Quantity Dispensed442-E79(7)V99910196205
X-631Fill Number4Ø3-D39(2)2206207
X-634Days Supply4Ø5-D59(3)3208210
X-637Compound Code4Ø6-D69(1)1211211
X-640Dispense As Written (DAW)/Product Selection Code4Ø8-D8X(1)1212212
X-643Date Prescription Written414-DEYYYYMMDD8213220
X-646Number of Refills Authorized415-DF9(2)2221222
X-649Prescription Origin Code419-DJ9(1)1223223
X-652Submission Clarification Code Count (max = 3)354-NX9(1)1224224
X-655Submission Clarification Code - 1st42Ø-DK9(2)2225226
X-658Submission Clarification Code - 2nd42Ø-DK9(2)2227228
X-661Submission Clarification Code - 3rd42Ø-DK9(2)2229230
X-664Other Coverage Code3Ø8-C89(2)2231232
X-667Unit of Measure6ØØ-28X(2)2233234
X-670Level of Service418-DI9(2)2235236
X-673Prior Authorization Type Code461-EU9(2)2237238
X-676Prior Auth Number Submitted462-EV9(11)11239249
X-679Route of Administration995-E2X(11)11250260
X-682Dispensing Status343-HDX(1)1261261
X-685Associated Prescription/Service Reference Number456-EN9(12)12262273
X-688Associated Prescription/Service Date457-EPYYYYMMDD8274281
X-691Quantity Prescribed46Ø-ET9(7)V99910282291
X-694Quantity Intended To Be Dispensed344-HF9(7)V99910292301
X-697Days Supply Intended To Be Dispensed345-HG9(3)3302304
X-700Prescriber ID Qualifier466-EZX(2)2305306<--- start of Prescriber Segment fields
X-703Prescriber ID411-DBX(15)15307321
X-706Ingredient Cost Submitted4Ø9-D9S9(6)V998322329<--- start of Pricing Segment fields
X-709Patient Assignment Indicator (DMR Indicator)391-MTX(1)1330330
X-712Pharmacy Service Type147-U79(2)2331332
X-715Dispensing Fee Submitted412-DCS9(6)V998333340
X-718Patient Paid Amount Submitted433-DXS9(6)V998341348
X-721Usual and Customary Charge426-DQS9(6)V998349356
X-724Gross Amount Due43Ø-DUS9(6)V998357364
X-727Basis of Cost Determination423-DNX(2)2365366
X-730Patient Pay Amount5Ø5-F5S9(6)V998367374
X-733Ingredient Cost Paid5Ø6-F6S9(6)V998375382
X-736Dispensing Fee Paid5Ø7-F7S9(6)V998383390
X-739Other Payer Amount Recognized566-J5S9(6)V998391398
X-742Total Amount Paid5Ø9-F9S9(6)V998399406
X-745Basis of Reimbursement Determination522-FM9(2)2407408
X-748Coordination of Benefits/Other Payments Count (max = 3)337-4C9(1)1409409<--- start of Coordination of Benefits/Other Payments Segment fields
X-751Other Payer Coverage Type 1st338-5CX(2)2410411
X-754Other Payer ID Qualifier 1st339-6CX(2)2412413
X-757Other Payer ID 1st34Ø-7CX(10)10414423
X-760Other Payer Date 1st443-E8YYYYMMDD8424431
X-763Other Payer Amount Paid Count 1st341-HB9(1)1432432
X-766[Sum of] Other Payer Amount Paid 1st431-DVS9(6)V998433440
X-769Other Payer Reject Count 1st (max = 5)471-5E9(2)2441442
X-772Other Payer Reject Code 1st-1472-6EX(3)3443445
X-775Other Payer Reject Code 1st-2472-6EX(3)3446448
X-778Other Payer Reject Code 1st-3472-6EX(3)3449451
X-781Other Payer Reject Code 1st-4472-6EX(3)3452454
X-784Other Payer Reject Code 1st-5472-6EX(3)3455457
X-787Other Payer Coverage Type 2nd338-5CX(2)2458459
X-790Other Payer ID Qualifier 2nd339-6CX(2)2460461
X-793Other Payer ID 2nd34Ø-7CX(10)10462471
X-796Other Payer Date 2nd443-E8YYYYMMDD8472479
X-799Other Payer Amount Paid Count 2nd (max = 5)341-HB9(1)1480480
X-802[Sum of] Other Payer Amount Paid 2nd431-DVS9(6)V998481488
X-805Other Payer Reject Count 2nd471-5E9(2)2489490
X-808Other Payer Reject Code 2nd-1472-6EX(3)3491493
X-811Other Payer Reject Code 2nd-2472-6EX(3)3494496
X-814Other Payer Reject Code 2nd-3472-6EX(3)3497499
X-817Other Payer Reject Code 2nd-4472-6EX(3)3500502
X-820Other Payer Reject Code 2nd-5472-6EX(3)3503505
X-823Other Payer Coverage Type 3rd338-5CX(2)2506507
X-826Other Payer ID Qualifier 3rd339-6CX(2)2508509
X-829Other Payer ID 3rd34Ø-7CX(10)10510519
X-832Other Payer Date 3rd443-E8YYYYMMDD8520527
X-835Other Payer Amount Paid Count 3rd341-HB9(1)1528528
X-838[Sum of] Other Payer Amount Paid 3rd431-DVS9(6)V998529536
X-841Other Payer Reject Count 3rd (max = 5)471-5E9(2)2537538
X-844Other Payer Reject Code 3rd-1472-6EX(3)3539541
X-847Other Payer Reject Code 3rd-2472-6EX(3)3542544
X-850Other Payer Reject Code 3rd-3472-6EX(3)3545547
X-853Other Payer Reject Code 3rd-4472-6EX(3)3548550
X-856Other Payer Reject Code 3rd-5472-6EX(3)3551553
X-859Compound Dosage Form Description Code45Ø-EFX(15)15554568<--- start of Compound Segment fields
X-862Compound Dispensing Unit Form Indicator451-EG9(1)1569569
X-865Compound Ingredient Component Count (max = 25)447-EC9(2)2570571
X-868Compound Product ID Qualifier - 1st488-REX(2)2572573
X-871Compound Product ID - 1st489-TEX(19)19574592
X-874Compound Ingredient Quantity - 1st448-ED9(7)V99910593602
X-877Compound Ingredient Drug Cost - 1st449-EES9(6)V998603610
X-880Compound Ingredient Basis of Cost Determination - 1st49Ø-UEX(2)2611612
X-883Compound Product ID Qualifier - 2nd488-REX(2)2613614
X-886Compound Product ID - 2nd489-TEX(19)19615633
X-889Compound Ingredient Quantity - 2nd448-ED9(7)V99910634643
X-892Compound Ingredient Drug Cost - 2nd449-EES9(6)V998644651
X-895Compound Ingredient Basis of Cost Determination - 2nd49Ø-UEX(2)2652653
X-898Compound Product ID Qualifier - 3rd488-REX(2)2654655
X-901Compound Product ID - 3rd489-TEX(19)19656674
X-904Compound Ingredient Quantity - 3rd448-ED9(7)V99910675684
X-907Compound Ingredient Drug Cost - 3rd449-EES9(6)V998685692
X-910Compound Ingredient Basis of Cost Determination - 3rd49Ø-UEX(2)2693694
fillerX(306)3066951000

&8&F

&8Page &P of &N

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