Appendix%207.17%20ASP%20Reconciliation%20Template.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
Third Party Administrator Services for the State's Public Sector Health Plans
Solicitation number
RFP 31786-00190
Issued by
Davidson County, Tennessee

About this file

This is an ASP (Average Selling Price) Reconciliation Template appendix document related to Third Party Administrator Services for Tennessee's Public Sector Health Plans. The template is designed to facilitate the reconciliation of pharmaceutical claims at the claim level detail, capturing comprehensive data across medical specialty pharmacy transactions. The template requires documentation of provider information, including provider type and tax identification numbers, along with claim adjudication details such as date of adjudication and HCPC codes with corresponding procedure descriptions.

The reconciliation template captures critical pricing and utilization data elements including NDC numbers, drug strength descriptions, NDC package sizes, allowed units, billed units, and updated units. It tracks allowed charges against ASP (Average Selling Price) on the date of adjudication and calculates total ASP-based charges based on date of service and updated units, with provisions for ASP plus a percentage markup calculation. This template serves as the operational mechanism for ensuring accurate pharmaceutical claim reconciliation and pricing verification within the state's health plan administration framework, with all pricing information subject to Cigna's confidentiality protections.

View the file

Other files

File Type Posted
Appendix%207.15%20Simplified%20Wellness%20Activity%20Layout.xlsx XLSX spreadsheet
Appendix%207.13%20Supplier%20Direct%20Deposit%20Authorization.pdf PDF
Appendix%207.3%20Provider%20Disruption%20Analysis%20Instructions%20and%20Template.xlsx XLSX spreadsheet
Appendix%207.9%20Benefits%20Administration%20834%20Guidance%20Manual_v6.pdf PDF
31786-00190%20Digital%20Submission%20Instructions.docx DOCX document
Appendix%207.18%20Written%20Questions%20%20Comments%20Template.xlsx XLSX spreadsheet
Appendix%207.11%20HIPAA%20Business%20Associate%20Assessment.xlsx XLSX spreadsheet
Appendix%207.10%20Decision%20Support%20System%20File%20Format.xlsx XLSX spreadsheet
Appendix%207.4%20Quest%20Analytics%20Sample%20Reports.pdf PDF
Appendix%207.2%20Network%20Access%20Analysis%20Instructions.docx DOCX document
31786-00190%20TPA%20RFP%20for%20posting.docx DOCX document
Appendix%207.7%20Enrollment%20by%20Plan.xlsx XLSX spreadsheet
TPA%20Cost%20Proposal%20for%20posting.xlsx XLSX spreadsheet
Appendix%207.12%20Bank%20Draft%20Report%20Template.xlsx XLSX spreadsheet
Appendix%207.1%20Discount%20Data%20Specifications.pdf PDF
Appendix%207.14%20Process%20for%20Subrogation%20and%20Other%20Recoveries.pdf PDF
Appendix%207.16%20Implementation%20and%20Account%20team%20Surveys.xlsx XLSX spreadsheet
Appendix%207.8%20Claims%20and%20Utilization%20History.xlsx XLSX spreadsheet
Appendix%207.5%202026%20TN%20Zip%20Code%20Enrollment%20Counts.xlsx XLSX spreadsheet
Appendix%207.6%20Enrollment%20by%20Plan%20Group.xlsx XLSX spreadsheet
Show all 20

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

Claim Level Detail Medical Specialty Pharmacy ASP Reconciliation

Provider Type Provider Provider Tax ID number Date of Adjudication HCPC Code Procedure description NDC Number Drug Strength Description NDC Package Size Allowed Units Bill Units Updated Units Allowed Charges ASP on the Date of Adjudication Total ASP Based on DOS and Updated Units ASP + x%

Appendix 7.23

&BCigna Confidential&B &D Page &P

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