Data_Pkg_17_Historical_TMDS_Claims_Volume_(Aug_27 _2013).xlsx

XLSX spreadsheet 25 KB Posted Aug 30, 2013

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

About this file

From the source

Data Pkg 17_Historical TMDS Claims Volume (Aug 27 2013)

View the file

Other files

File	Type	Posted
M270_TFL_Pharmacy_Pilot_Opt-Out_Report.pdf	PDF	Feb 14, 2014
EXHIBIT_L-10_Historical_Data_and_Other_Info_Available_to_Offerors_(Jan_13 _2013).pdf	PDF	Feb 14, 2014
M260_TFL__Pharmacy_Pilot_Override_Report.pdf	PDF	Feb 14, 2014
EXHIBIT_L-4_DoD_Benefit_Design_(Dec_17 _2013).pdf	PDF	Feb 14, 2014
Amendment_0006.pdf	PDF	Feb 14, 2014
M250_TFL_Pharmacy_Pilot_Summary_and_Savings_Report.pdf	PDF	Feb 14, 2014
Exhibit_A.pdf	PDF	Feb 14, 2014
EXHIBIT_L-8_Draft_TFL_(Over_65)_Mandatory_Mail_Drug_List_(Dec_18 _2013).pdf	PDF	Feb 14, 2014
DRAFT_Data_Pkg_23_Utilization_Data_for_Jan-Nov_2013.xlsx	XLSX spreadsheet	Jan 23, 2014
DRAFT_Data_Pkg_24_Retail_Utilization_Detail_CY2013_(Dec_16 _2013).xlsx	XLSX spreadsheet	Jan 23, 2014
Data_Pkg_6_Pre-Deployment_Out-Processing_Centers_(Dec_18_2013).docx	DOCX document	Jan 13, 2014
Data_Pkg_18_Prescription_Transfers_from_Retail_to_Mail_Order_(Dec_9_2013).xls	XLS spreadsheet	Jan 13, 2014
L-10.16_MCPF_Sample_-_MTF_Pt_2_of_3.zip	ZIP file	Jan 13, 2014
L-10.15_MCPF_Sample_-_MTF_Pt_1_of_3.zip	ZIP file	Jan 13, 2014
Data_Pkg_17_Historical_Theater_Medical_Data_Store_(TMDS)_Volume_(Dec_10 _2013).xlsx	XLSX spreadsheet	Jan 13, 2014
Data_Pkg_13_IHS_ _VA_Historical_Claims_Volume_CY12 CY13_(Dec_11 _2013).xlsx	XLSX spreadsheet	Jan 13, 2014
Data_Pkg_7_Historical_Deployed_Prescription_Volume_(Dec_6_2013).xlsx	XLSX spreadsheet	Jan 13, 2014
Data_Pkg_19_ART_Referral_Volume_FY13_(Dec_19_2013).xls	XLS spreadsheet	Jan 13, 2014
L-10.17_MCPF_Sample_-_MTF_Pt_3_of_3.zip	ZIP file	Jan 13, 2014
Data_Pkg_10_Historical_MTF_Call_Volume_(Dec_13_2013).xlsx	XLSX spreadsheet	Jan 13, 2014
Data_Pkg_4_Retail_Utilization_Detail_CY2012_(Dec_16 _2013).xlsx	XLSX spreadsheet	Jan 13, 2014
Data_Pkg_9_Historical_MTF_Claim_Volume_(Dec_10 _2013).xlsx	XLSX spreadsheet	Jan 13, 2014
Data_Pkg_5_Utilization_of_Retail_Maintenance_Meds_by_Benes_Over_65_CY11-CY13_(Dec_13 _2013).xlsx	XLSX spreadsheet	Jan 13, 2014
Data_Pkg_14_TRICARE_Beneficiaries_by_Zip_Code_(Dec_10 _2013).xlsx	XLSX spreadsheet	Jan 13, 2014
EXHIBIT_L-12_Instructions_for_Completing_Retail_Network_Reimbursement _Table_L-1_(Sep_19 _2013).pdf	PDF	Sep 19, 2013
EXHIBIT__L-1_Table_L-1_TPharm4_-_Ammendment_5_(Sep_19 _2013).xls	XLS spreadsheet	Sep 19, 2013
Q A_Clarification_to_Set__9_Answers.pdf	PDF	Sep 19, 2013
Amendment_0005.pdf	PDF	Sep 19, 2013
EXHIBIT_L-13_Background_Information_for_Retail_Network_Reimbursement_Table_L-1_(Sep_17 _2013).pdf	PDF	Sep 19, 2013
Q A_Ninth_Set_Answers.pdf	PDF	Sep 10, 2013
M240_TMDS_Claims_Volume.pdf	PDF	Aug 30, 2013
EXHIBIT_L-5_DoD_Formulary_Restrictions_and_Limitations_(Aug_29 _2013).xlsx	XLSX spreadsheet	Aug 30, 2013
EXHIBIT__L-14_DRAFT_TPharm4_ProDUR_Parameters_(Aug_30_2013).doc	DOC document	Aug 30, 2013
Q A_Eighth_Set_Answers.pdf	PDF	Aug 30, 2013
D020_AttachA_RPC_Data_-_revised.xlsx	XLSX spreadsheet	Aug 30, 2013
W010_MTF_Data_Integrity_Report_v2.pdf	PDF	Aug 30, 2013
D030_Contractor_Payment-Check_Issue_Data.pdf	PDF	Aug 30, 2013
EXHIBIT_L-4_DoD_Benefit_Design_(Aug_29 _2013).doc	DOC document	Aug 30, 2013
D030_AttachA_Contractor_Payment-Check_Issue_Data_-_Formats.xlsx	XLSX spreadsheet	Aug 30, 2013
Amendment_0004.pdf	PDF	Aug 30, 2013
EXHIBIT_L-11_Ordering_Instructions_for_Confidential_and_Protected_Information_(Aug_14 _2013)_Amendment_3.pdf	PDF	Aug 15, 2013
Data_Pkg_21_Key_for_Additional_Claims_Level_Data_(Aug_14 _2013).xlsx	XLSX spreadsheet	Aug 15, 2013
M190_AttachA_Mail_Order_Report_Format_w_instructions.xlsx	XLSX spreadsheet	Aug 15, 2013
EXHIBIT_L-10_Historical_Data_and_Other_Info_Available_to_Offerors_Amendment_3_(Aug_13 _2013).pdf	PDF	Aug 15, 2013
Q A_Seventh_Set_Answers.pdf	PDF	Aug 15, 2013
Amendment_0003.pdf	PDF	Aug 15, 2013
EXHIBIT_L-12_Instructions_for_Completing_Retail_Network_Reimbursement _Table_L-1_(Aug_13 _2013).pdf	PDF	Aug 15, 2013
EXHIBIT_L-13_Background_Information_for_Retail_Network_Reimbursement _Table_L-1_(Aug_13 _2013).pdf	PDF	Aug 15, 2013
EXHIBIT__L-1_Table_L-1_TPharm4_-_Ammendment_3_(Aug_13 _2013).docx	DOCX document	Aug 15, 2013
Q A_Sixth_Set_Answers.pdf	PDF	Aug 8, 2013

Show 40 more

Latest 50 of 101 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.

Weekly TMDS File Stats

Theater Data Medical Store (TMDS) Claims Volumes

April 1, 2012 - April 21, 2013

Week Of	Total Number of Records Received from TMDS	AHLTA-T Records Adjudicated	TC2 Records Adjudicated	Total Records Adjudicated	Number of Aged Claims Dropped	Number of Duplicates Dropped	Number of Errors Dropped	Total Number Dropped	% Dropped
4/1/2012	26,484	19,711	3,225	22,936	3,063	338	147	3,548	13.4%
4/8/2012	23,001	15,324	2,674	17,998	1,022	3,729	252	5,003	21.8%
4/15/2012	21,192	12,069	2,777	14,846	979	5,208	159	6,346	29.9%
4/22/2012	23,138	11,083	3,487	14,570	1,461	6,894	213	8,568	37.0%
4/29/2012	16,331	6,020	2,683	8,703	777	6,724	127	7,628	46.7%
5/6/2012	19,637	5,627	2,896	8,523	947	9,967	200	11,114	56.6%
5/13/2012	23,302	9,688	2,772	12,460	2,991	7,658	193	10,842	46.5%
5/20/2012	20,493	8,834	2,936	11,770	1,115	7,420	188	8,723	42.6%
5/27/2012	18,174	7,219	2,766	9,985	752	7,221	216	8,189	45.1%
6/3/2012	24,325	8,179	3,700	11,879	1,073	11,199	174	12,446	51.2%
6/10/12	22,494	6,608	3,376	9,984	1,299	11,006	205	12,510	55.6%
6/17/12	19,495	5,549	3,250	8,799	745	9,779	172	10,696	54.9%
6/24/12	22,165	6,320	3,210	9,530	1,462	10,963	210	12,635	57.0%
7/1/12	20,028	6,577	2,705	9,282	1,007	9,540	199	10,746	53.7%
7/8/12	18,771	5,632	2,876	8,508	868	9,221	174	10,263	54.7%
7/15/12	20,538	5,314	3,469	8,783	1,562	9,999	194	11,755	57.2%
7/22/12	18,007	5,197	3,474	8,671	930	8,274	132	9,336	51.8%
7/29/12	18,408	5,459	2,926	8,385	1,157	8,716	150	10,023	54.4%
8/5/12	28,366	8,241	3,421	11,662	1,717	14,778	209	16,704	58.9%
8/12/12	17,332	4,644	2,615	7,259	745	9,154	174	10,073	58.1%
8/19/12	16,764	4,495	2,947	7,442	807	8,361	154	9,322	55.6%
8/26/12	20,759	5,925	2,881	8,806	1,101	10,667	185	11,953	57.6%
9/2/12	18,608	5,804	2,702	8,506	857	9,098	147	10,102	54.3%
9/9/12	18,797	5,559	3,002	8,561	1,174	8,932	130	10,236	54.5%
9/16/2012	21,974	6,611	3,003	9,614	1,468	10,744	148	12,360	56.2%
9/23/12	22,638	7,441	3,503	10,944	994	10,542	158	11,694	51.7%
9/30/12	24,779	8,919	3,107	12,026	1,310	13,712	154	15,176	61.2%
10/7/12	21,740	6,408	3,130	9,538	1,533	10,545	124	12,202	56.1%
10/14/12	22,356	7,407	2,894	10,301	808	11,112	135	12,055	53.9%
10/21/12	28,432	6,414	2,639	9,053	7,177	12,100	102	19,379	68.2%
10/28/12	19,310	2,578	6,264	8,842	641	9,716	111	10,468	54.2%
11/4/12	19,318	6,113	2,614	8,727	650	9,787	154	10,591	54.8%
11/11/12	20,625	6,488	2,593	9,081	726	10,686	132	11,544	56.0%
11/18/12	18,864	5,732	2,621	8,353	874	9,529	108	10,511	55.7%
11/25/12	17,297	4,987	2,372	7,359	1,067	8,777	94	9,938	57.5%
12/2/12	17,749	5,240	2,668	7,908	862	8,864	115	9,841	55.4%
12/9/12	23,248	6,621	2,588	9,209	2,362	11,499	178	14,039	60.4%
12/16/12	16,716	5,459	2,264	7,723	750	8,091	152	8,993	53.8%
12/17/2012*	288	99	22	121	9	158	0	167	58.0%
12/23/12	16,025	7,427	70	7,497	531	7,997	70	8,598	53.7%
12/30/12	14,929	4,865	1,933	6,798	670	7,427	34	8,131	54.5%
1/6/13	15,516	4,954	2,446	7,400	494	7,561	61	8,116	52.3%
1/13/13	15,176	5,016	2,116	7,132	602	7,336	106	8,044	53.0%
1/20/13	16,716	5,273	2,080	7,353	938	8,346	79	9,363	56.0%
1/27/13	15,372	4,821	1,925	6,746	706	7,848	72	8,626	56.1%
2/3/13	17,662	5,760	2,069	7,829	764	9,009	60	9,833	55.7%
2/10/2013	17,177	4,852	2,147	6,999	1,604	8,478	96	10,178	59.3%
2/17/2013	23,271	5,948	2,656	8,604	2,405	12,168	94	14,667	63.0%
2/24/13	34,513	3,044	3,900	6,944	3,025	24,412	132	27,569	79.9%
3/3/13	13,814	3,919	1,801	5,720	687	7,340	67	8,094	58.6%
3/10/2013	17,623	4,908	1,808	6,716	1,795	9,064	48	10,907	61.9%
3/17/13	14,657	3,439	1,741	5,180	591	8,804	82	9,477	64.7%
3/24/13	19,274	5,129	1,844	6,973	1,775	10,456	70	12,301	63.8%
3/31/2013	18,751	5,305	2,223	7,528	1,071	10,093	59	11,223	59.9%
4/7/2013	15,756	4,116	1,855	5,971	898	8,838	49	9,785	62.1%
4/14/2013	16,261	3,005	1,680	4,685	1,106	10,419	51	11,576	71.2%
4/21/2013	24,449	6,514	2,218	8,732	1,630	14,017	70	15,717	64.3%

* Due to techincal issues, a second weekly file was created this week.

&"-,Bold"&14Weekly TMDS File Statistics

Column Descriptions

Column Heading	Description of Contents
Week Of	Reflects Sunday calendar date for each week.
Total Number of Records Received from TMDS	Reflects total number of records received from TMDS before any processing is done by PDTS.
AHLTA-T Records Adjudicated	Reflects total number of AHLTA-T records remaining to be adjudicated on PDTS after initial processing.
TC2 Records Adjudicated	Reflects total number of TC2 records remaining to be adjudicated on PDTS after initial processing.
Total Records Adjudicated	Reflects total number of AHLTA-T and TC2 records adjudicated on PDTS.
Number of Aged Claims Dropped	Reflects total number of aged claims dropped.
Number of Duplicates Dropped	Reflects total number of duplicates dropped.
Number of Errors Dropped	Reflects total number of errors dropped.
Total Number Dropped	Reflects sum of aged claims, duplicates, and errors that were dropped.
% Dropped	Reflects percentage of total number of claims received from TMDS that were dropped prior to any claims being adjudicated on PDTS.

TMDS File Fields

Theater Medical Data Store File Fields
Field Number	XML Element Name	Java Data Type	Oracle Data Type
1	recordSequenceNumber	Integer	NUMBER

2 patientIdentifier String NUMBER

3	firstName	String	VARCHAR2 (80 Byte)
4	lastName	String	VARCHAR2 (80 Byte)

5 dob String DATE

6 gender String CHAR(1 Byte)

7 drugIdentifier String VARCHAR2 (80 Byte)

8 drugName String VARCHAR2(250)

9 patientDirections String VARCHAR2(120)

10 pharmacyNumber String VARCHAR2 (50 byte)

11 quantityDispensed String NUMBER

12	daysSupply	String	NUMBER
13	dateOfService	String	DATE

14	serviceLocation	String	VARCHAR2 (50 Byte)
15	prescriber	String	NUMBER

File details come from the government source that posted it. Updated Nov 14, 2017.