ATTM 023.xlsx

XLSX spreadsheet 18 KB Posted

Attached to
Pharmacy Benefit Services (PBS)
Solicitation number
5400029905
Issued by
Richland County, South Carolina

About this file

This file is a reporting specification document for the South Carolina Department of Health and Human Services (SCDHHS) Pharmacy Benefit Services (PBS) contract, detailing the required reports and metrics for pharmacy benefit management oversight. The document outlines a comprehensive suite of reporting requirements organized by frequency—yearly, quarterly, monthly, and weekly—to monitor financial performance, drug rebates, claim activities, and service delivery metrics across the pharmacy benefit program. Key reports include Executive Summary Reports (yearly financial summaries), CMS 64.9R reports (quarterly drug rebate tracking), Cash Flow Reports (monthly deposit tracking), and SCM Claims Extracts (weekly claim activity monitoring). Additional reports track family planning drug rebates, invoice totals by manufacturer, balance sheet positions, performance guarantees, call center activities, determination turnaround times, and pharmacy utilization and expenditure metrics. These reports serve to ensure comprehensive visibility into both financial transactions and operational performance across the pharmacy benefit program.

The reporting structure demonstrates a multi-layered accountability framework requiring detailed tracking of rebates, claims processing, and service quality metrics. The reports encompass financial reconciliation through quarterly adjustment reports and monthly balance sheets, compliance monitoring through performance guarantee reports (both detailed and summary levels), and operational performance assessment through call center activity reports and determination turnaround time analysis. The inclusion of weekly extract summaries identifying the top 20 most expensive medications categorized as "Other" indicates focus on cost containment and utilization management. The diverse reporting requirements across multiple time intervals—from weekly claims data to yearly executive summaries—establish a robust monitoring system for the contractor to maintain financial accuracy, ensure regulatory compliance with CMS requirements, and demonstrate service delivery performance across pharmacy benefit services operations.

View the file

Other files

File Type Posted
ATTM 021.pdf PDF
ATTM 022.pdf PDF
ATTM 024(a).docx DOCX document
ATTM 014.pdf PDF
ATTM 016.pdf PDF
ATTM 005.docx DOCX document
ATTM 006.docx DOCX document
ATTM 008.xlsx XLSX spreadsheet
PL 001.docx DOCX document
PL 003.pdf PDF
ATTM 010.docx DOCX document
ATTM 026.docx DOCX document
ATTM 020.pdf PDF
ATTM 009.xlsx XLSX spreadsheet
ATTM 017.pdf PDF
ATTM 024(b).xlsx XLSX spreadsheet
ATTM 018.pdf PDF
PL 002.pdf PDF
ATTM 003.docx DOCX document
ATTM 013.xlsx XLSX spreadsheet
ATTM 019.pdf PDF
ATTM 011.pdf PDF
ATTM 015.pdf PDF
ATTM 007.docx DOCX document
Solicitation 5400029905.docx DOCX document
ATTM 025.docx DOCX document
ATTM 012.xlsx XLSX spreadsheet
ATTM 004.docx DOCX document
ATTM 001.docx DOCX document
ATTM 002.docx DOCX document
Show all 30

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

Sheet1

ATTM 023
Report NameFrequencyReport details
Executive Summary ReportYearlyIdentifies financial summary yearly
Adjustment Reports SummaryQuarterlyIdentifies adjustments used to update the 64.9r quarterly
Cash Flow ReportMonthlyIdentifies deposits received monthly
Cash Receipt Recap Support SummaryQuarterlyIdentifies interest and invoice payments deposited quarterly
Family Planning Drugs Payment ReceivedQuarterlyIdentifies rebate amont paid by NDC for family planning drugs quarterly
Invoice TotalsQuarterlyIdentifies invoice totals by manufacturer quarterly
Balance SheetMonthlyIdentifies system beginning and ending balances monthly
Quarterly Labeler Account BalanceQuarterlyIdentifies total outstanding balance by manufacturer quarterly
CMS 64.9RQuarterlyIdentifies total drug rebates for FFS and MCOs quarterly
SC Performance Guarantees (PG) DetailMonthlyIdentifies performance guarantees monthly
SC Performance Guarantees (PG) SummaryMonthlyIdentifies performance guarantees monthly
Extract SummaryWeeklyIdentifies claim metrics weekly
Extract Summary Top 20WeeklyIdentifies the top 20 most expensive medications categorized as "Other" weekly
SCM Claims ExtractWeeklyIdentifies POS claim activities weekly
SCDHHS Performance GuaranteesMonthly/QuarterlyIdentifies services provided monthly and quarterly
SCDHHS Call Center Activity AfterhoursMonthly/QuarterlyIdentifies call center activities afterhours monthly and quarterly
SCDHHS Call Center ActivityMonthly/QuarterlyIdentifies call center activities monthly and quarterly
SCDHHS Determination Turnaround TimeMonthly/QuarterlyIdentifies determination turnaround times monthly and quarterly
SCDHHS DeterminationsMonthly/QuarterlyIdentifies summary of final determinations monthly and quarterly
SCM Supplemental Rebate InvoicesQuarterlyIdentifies total expenditure and amounts rebated quarterly
SC Pharmacy Utilization and ExpenditureMonthly/QuarterlyIdentifies pharmacy metrics monthly and quarterly

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