Data_Pkg_21_Key_for_Additional_Claims_Level_Data_(Aug_14 _2013).xlsx

19 KB Posted

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

About this file

From the source

Data Pkg 21 Key for Additional Claims Level Data (Aug 14 2013)

View the file

Other files

File Type Posted
M260_TFL__Pharmacy_Pilot_Override_Report.pdf PDF
EXHIBIT_L-4_DoD_Benefit_Design_(Dec_17 _2013).pdf PDF
Exhibit_A.pdf PDF
EXHIBIT_L-10_Historical_Data_and_Other_Info_Available_to_Offerors_(Jan_13 _2013).pdf PDF
DRAFT_Data_Pkg_23_Utilization_Data_for_Jan-Nov_2013.xlsx XLSX spreadsheet
Data_Pkg_18_Prescription_Transfers_from_Retail_to_Mail_Order_(Dec_9_2013).xls XLS spreadsheet
L-10.16_MCPF_Sample_-_MTF_Pt_2_of_3.zip ZIP file
L-10.15_MCPF_Sample_-_MTF_Pt_1_of_3.zip ZIP file
Data_Pkg_6_Pre-Deployment_Out-Processing_Centers_(Dec_18_2013).docx DOCX document
Data_Pkg_17_Historical_Theater_Medical_Data_Store_(TMDS)_Volume_(Dec_10 _2013).xlsx XLSX spreadsheet
Data_Pkg_13_IHS_ _VA_Historical_Claims_Volume_CY12 CY13_(Dec_11 _2013).xlsx XLSX spreadsheet
Data_Pkg_19_ART_Referral_Volume_FY13_(Dec_19_2013).xls XLS spreadsheet
L-10.17_MCPF_Sample_-_MTF_Pt_3_of_3.zip ZIP file
EXHIBIT__L-1_Table_L-1_TPharm4_-_Ammendment_5_(Sep_19 _2013).xls XLS spreadsheet
Q A_Clarification_to_Set__9_Answers.pdf PDF
Q A_Ninth_Set_Answers.pdf PDF
W010_MTF_Data_Integrity_Report_v2.pdf PDF
D030_AttachA_Contractor_Payment-Check_Issue_Data_-_Formats.xlsx XLSX spreadsheet
Q A_Eighth_Set_Answers.pdf PDF
EXHIBIT__L-14_DRAFT_TPharm4_ProDUR_Parameters_(Aug_30_2013).doc DOC document
D020_AttachA_RPC_Data_-_revised.xlsx XLSX spreadsheet
Amendment_0003.pdf PDF
M190_AttachA_Mail_Order_Report_Format_w_instructions.xlsx XLSX spreadsheet
EXHIBIT_L-13_Background_Information_for_Retail_Network_Reimbursement _Table_L-1_(Aug_13 _2013).pdf PDF
EXHIBIT_L-11_Ordering_Instructions_for_Confidential_and_Protected_Information_(Aug_14 _2013)_Amendment_3.pdf PDF
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
Q A_Sixth_Set_Answers.pdf PDF
Data_Pkg_19_ART_Referral_Volume_FY13_Q1 Q2_(Aug_7 _2013).xls XLS spreadsheet
EXHIBIT_L-7_Draft_High_Cost_Medicaitons_List_(Aug_08 _2013).pdf PDF
Data_Pkg_18_Prescription_Transfers_from_Retail_to_Mail_Order_(Aug_7 _2013).xls XLS spreadsheet
EXHIBIT_L-8_Draft_TFL_(Over_65)_Mandatory_Mail_Drug_List_(May_15 _2013).xlsx XLSX spreadsheet
Data_Pkg_20_Prescription_Restriction_Volume_(Aug_7 _2013).xls XLS spreadsheet
Data_Pkg_2_Utilization_Data_CY2012_(Aug_1 _2013).xlsx XLSX spreadsheet
Q A_Second_Set_Answers.pdf PDF
Exhibit_A_to_Section_B.zip ZIP file
Draft_Data_Pkg_3_Retail_Utilization_Detail_CY2011_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Data_Pkg_10_Historical_MTF_Call_Volume_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Data_Pkg_12_Dept._of_Veteran's_Affairs_(DVA)_Pharmacy_Listing_(March _2013).xlsx XLSX spreadsheet
Draft_MTF_to_TMOP_Implementation_Guide_(Feb _2013).pdf PDF
Draft_TFL_Mandatory_Mail_Drug_List_(May_15 _2013).pdf PDF
Draft_Managed_Care_Pricing_File_-_MTF_Sample_Part_1_of_3_(April_25 _2013).zip ZIP file
Draft_Data_Pkg_8_Unreplenished_Agents_for_OP1 _OP2 _and_OP3_(Oct _2012).xlsx XLSX spreadsheet
Draft_Data_Pkg_2_Utilization_Data_for_Jan_-_Dec_2012_(May_17 _2013).xlsx XLSX spreadsheet
Draft_DoD_Benefit_Design_(March_29 _2013).pdf PDF
Draft_Data_Pkg_16_Historical_Federal_Ceiling_Price_(FCP)_Dispute_Volume_(May_22 _2013).xlsx XLSX spreadsheet
Draft_Data_Pkg_9_Historical_MTF_Claim_Volume_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Data_Pkg_6_Pre-Deployment_Out-Processing_Centers_(May_15 _2013).pdf PDF
Draft_Data_Pkg_5_Utilization_of_Retail_Maintenance_Meds_by_Benes_Over_65_(May_15 _2013).xlsx XLSX spreadsheet
Draft_Managed_Care_Pricing_File_-_TMOP_Sample_(May_15 _2013).zip ZIP file
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Title Page

FOR OFFICIAL USE ONLY
TMA Pharmacy Operations Center
Title: TPHARM4 Solicitation Reference
Report population: Mail Order & Retail Network
Date Range: 10/01/2011 - 09/30/2012
Report ran on: 08/09/2013
Report Data elements
ObjectDefinitionExample of Field ValueFormat
Date DispensedDate prescription was filled or refilledMM/DD/YYYYDate
NDCThe National Drug Code is an eleven-digit number, comprised of three segments. Each segment provides information about the product:12345678910Numeric
Service Category (Claim)Service Category Based on PCN #Mail Order ; RetailAlpha
NPI #2The NPI is a unique 10-digit number for health care providers that can be used nationally which contains no "intelligence" about the provider and is issued for life.1234567890Numeric
DMRIndicatorPaper Claim IndicatorY = DMR, N = not DMRAlpha
Compound CodeIdentify the dispensing is a compound prescription. This code allows the claim to be priced as a compound and not as a normal dispensing of an NDC.Y = Yes ; N= NoAlpha
MetricdecimalquantityThis contains the submitted metric decimal quantity for the prescription.9.3Numeric
Days SupplyDays supply calculated by the site's system. Range is from 1 to 365.30Numeric
# RXA count of the Prescriptions5Numeric

Report Outline

Report NumberDate Range
110/1/11
10/2/11
10/3/11
210/4/11
10/5/11
10/6/11
310/7/11
10/8/11
10/9/11
410/10/11
10/11/11
10/12/11
510/13/11
10/14/11
10/15/11
610/16/11
10/17/11
10/18/11
710/19/11
10/20/11
10/21/11
810/22/11
10/23/11
10/24/11
910/25/11
10/26/11
10/27/11
1010/28/11
10/29/11
10/30/11
1110/31/11
11/1/11
11/2/11
1211/3/11
11/4/11
11/5/11
1311/6/11
11/7/11
11/8/11
1411/9/11
11/10/11
11/11/11
1511/12/11
11/13/11
11/14/11
1611/15/11
11/16/11
11/17/11
1711/18/11
11/19/11
11/20/11
1811/21/11
11/22/11
11/23/11
1911/24/11
11/25/11
11/26/11
2011/27/11
11/28/11
11/29/11
2111/30/11
12/1/11
12/2/11
2212/3/11
12/4/11
12/5/11
2312/6/11
12/7/11
12/8/11
2412/9/11
12/10/11
12/11/11
2512/12/11
12/13/11
12/14/11
2612/15/11
12/16/11
12/17/11
2712/18/11
12/19/11
12/20/11
2812/21/11
12/22/11
12/23/11
2912/24/11
12/25/11
12/26/11
3012/27/11
12/28/11
12/29/11
3112/30/11
12/31/11
1/1/12
321/2/12
1/3/12
1/4/12
331/5/12
1/6/12
1/7/12
341/8/12
1/9/12
1/10/12
351/11/12
1/12/12
1/13/12
361/14/12
1/15/12
1/16/12
371/17/12
1/18/12
1/19/12
381/20/12
1/21/12
1/22/12
391/23/12
1/24/12
1/25/12
401/26/12
1/27/12
1/28/12
411/29/12
1/30/12
1/31/12
422/1/12
2/2/12
2/3/12
432/4/12
2/5/12
2/6/12
442/7/12
2/8/12
2/9/12
452/10/12
2/11/12
2/12/12
462/13/12
2/14/12
2/15/12
472/16/12
2/17/12
2/18/12
482/19/12
2/20/12
2/21/12
492/22/12
2/23/12
2/24/12
502/25/12
2/26/12
2/27/12
512/28/12
2/29/12
3/1/12
523/2/12
3/3/12
3/4/12
533/5/12
3/6/12
3/7/12
543/8/12
3/9/12
3/10/12
553/11/12
3/12/12
3/13/12
563/14/12
3/15/12
3/16/12
573/17/12
3/18/12
3/19/12
583/20/12
3/21/12
3/22/12
593/23/12
3/24/12
3/25/12
603/26/12
3/27/12
3/28/12
613/29/12
3/30/12
3/31/12
624/1/12
4/2/12
4/3/12
634/4/12
4/5/12
4/6/12
644/7/12
4/8/12
4/9/12
654/10/12
4/11/12
4/12/12
664/13/12
4/14/12
4/15/12
674/16/12
4/17/12
4/18/12
684/19/12
4/20/12
4/21/12
694/22/12
4/23/12
4/24/12
704/25/12
4/26/12
4/27/12
714/28/12
4/29/12
4/30/12
725/1/12
5/2/12
5/3/12
735/4/12
5/5/12
5/6/12
745/7/12
5/8/12
5/9/12
755/10/12
5/11/12
5/12/12
765/13/12
5/14/12
5/15/12
775/16/12
5/17/12
5/18/12
785/19/12
5/20/12
5/21/12
795/22/12
5/23/12
5/24/12
805/25/12
5/26/12
5/27/12
815/28/12
5/29/12
5/30/12
825/31/12
6/1/12
6/2/12
836/3/12
6/4/12
6/5/12
846/6/12
6/7/12
6/8/12
856/9/12
6/10/12
6/11/12
866/12/12
6/13/12
6/14/12
876/15/12
6/16/12
6/17/12
886/18/12
6/19/12
6/20/12
896/21/12
6/22/12
6/23/12
906/24/12
6/25/12
6/26/12
916/27/12
6/28/12
6/29/12
926/30/12
7/1/12
7/2/12
937/3/12
7/4/12
7/5/12
947/6/12
7/7/12
7/8/12
957/9/12
7/10/12
7/11/12
967/12/12
7/13/12
7/14/12
977/15/12
7/16/12
7/17/12
987/18/12
7/19/12
7/20/12
997/21/12
7/22/12
7/23/12
1007/24/12
7/25/12
7/26/12
1017/27/12
7/28/12
7/29/12
1027/30/12
7/31/12
8/1/12
1038/2/12
8/3/12
8/4/12
1048/5/12
8/6/12
8/7/12
1058/8/12
8/9/12
8/10/12
1068/11/12
8/12/12
8/13/12
1078/14/12
8/15/12
8/16/12
1088/17/12
8/18/12
8/19/12
1098/20/12
8/21/12
8/22/12
1108/23/12
8/24/12
8/25/12
1118/26/12
8/27/12
8/28/12
1128/29/12
8/30/12
8/31/12
1139/1/12
9/2/12
9/3/12
1149/4/12
9/5/12
9/6/12
1159/7/12
9/8/12
9/9/12
1169/10/12
9/11/12
9/12/12
1179/13/12
9/14/12
9/15/12
1189/16/12
9/17/12
9/18/12
1199/19/12
9/20/12
9/21/12
1209/22/12
9/23/12
9/24/12
1219/25/12
9/26/12
9/27/12
1229/28/12
9/29/12
9/30/12

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