D030_AttachA_Contractor_Payment-Check_Issue_Data_-_Formats.xlsx

XLSX spreadsheet 12 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 D030

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
DRAFT_Data_Pkg_24_Retail_Utilization_Detail_CY2013_(Dec_16 _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_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
EXHIBIT_L-13_Background_Information_for_Retail_Network_Reimbursement_Table_L-1_(Sep_17 _2013).pdf PDF
Amendment_0005.pdf PDF
Q A_Ninth_Set_Answers.pdf PDF
W010_MTF_Data_Integrity_Report_v2.pdf PDF
Amendment_0004.pdf PDF
Data_Pkg_17_Historical_TMDS_Claims_Volume_(Aug_27 _2013).xlsx XLSX spreadsheet
Amendment_0003.pdf PDF
EXHIBIT__L-1_Table_L-1_TPharm4_-_Ammendment_3_(Aug_13 _2013).docx DOCX document
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
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_Second_Set_Answers.pdf PDF
Q A_First_Set_Answers.pdf PDF
Exhibit_A_to_Section_B.zip ZIP file
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_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_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
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

Data Submission Format

FORMAT FOR CONTRACTOR PAYMENT/CHECK ISSUE DATA

HEADER

Column NbrFieldData sizeTEDS ELN#
1Record type indicator (H = Header)1HIndicates the Header information
2Batch/Voucher ASAP Account Number80-025ASAP ID number assigned to contractor by TMA, CRM.
3TMA Authorization Number8e.g. 20130601 for first cycle in June
4Record Count6Number of Records on this submission
5Total Amount of Check Run11Total dollar amount of the listing
DETAIL RECORDS
CHECKS/EFT
Column NbrFieldData sizeTEDS ELN# Institutional/ Non-Institutional
1Record type indicator1DIndicates the individual records
2Batch/Voucher ASAP Account Number80-025Same as Header
3Bank Account Number10Actual Contractor Bank Account
4Check Number/EFT Trace Number11leave blank for any extra spaces
5Check Payment Date8YYYYMMDD
6Payee50leave blank for any extra spaces
7Payee Tax ID/Provider Number181-200/2-240leave blank for any extra spaces
8Interest Paid111-145/2-112Optional if interest is included in Government Paid Amount. See below.
9Government Paid Amount111-140/2-205If Interest is not listed separately, should be included in the Government Paid Amount Field

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