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 | ||
| ATTM 022.pdf | ||
| ATTM 024(a).docx | DOCX document | |
| ATTM 014.pdf | ||
| ATTM 016.pdf | ||
| ATTM 005.docx | DOCX document | |
| ATTM 006.docx | DOCX document | |
| ATTM 008.xlsx | XLSX spreadsheet | |
| PL 001.docx | DOCX document | |
| PL 003.pdf | ||
| ATTM 010.docx | DOCX document | |
| ATTM 026.docx | DOCX document | |
| ATTM 020.pdf | ||
| ATTM 009.xlsx | XLSX spreadsheet | |
| ATTM 017.pdf | ||
| ATTM 024(b).xlsx | XLSX spreadsheet | |
| ATTM 018.pdf | ||
| PL 002.pdf | ||
| ATTM 003.docx | DOCX document | |
| ATTM 013.xlsx | XLSX spreadsheet | |
| ATTM 019.pdf | ||
| ATTM 011.pdf | ||
| ATTM 015.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 Name | Frequency | Report details |
| Executive Summary Report | Yearly | Identifies financial summary yearly |
| Adjustment Reports Summary | Quarterly | Identifies adjustments used to update the 64.9r quarterly |
| Cash Flow Report | Monthly | Identifies deposits received monthly |
| Cash Receipt Recap Support Summary | Quarterly | Identifies interest and invoice payments deposited quarterly |
| Family Planning Drugs Payment Received | Quarterly | Identifies rebate amont paid by NDC for family planning drugs quarterly |
| Invoice Totals | Quarterly | Identifies invoice totals by manufacturer quarterly |
| Balance Sheet | Monthly | Identifies system beginning and ending balances monthly |
| Quarterly Labeler Account Balance | Quarterly | Identifies total outstanding balance by manufacturer quarterly |
| CMS 64.9R | Quarterly | Identifies total drug rebates for FFS and MCOs quarterly |
| SC Performance Guarantees (PG) Detail | Monthly | Identifies performance guarantees monthly |
| SC Performance Guarantees (PG) Summary | Monthly | Identifies performance guarantees monthly |
| Extract Summary | Weekly | Identifies claim metrics weekly |
| Extract Summary Top 20 | Weekly | Identifies the top 20 most expensive medications categorized as "Other" weekly |
| SCM Claims Extract | Weekly | Identifies POS claim activities weekly |
| SCDHHS Performance Guarantees | Monthly/Quarterly | Identifies services provided monthly and quarterly |
| SCDHHS Call Center Activity Afterhours | Monthly/Quarterly | Identifies call center activities afterhours monthly and quarterly |
| SCDHHS Call Center Activity | Monthly/Quarterly | Identifies call center activities monthly and quarterly |
| SCDHHS Determination Turnaround Time | Monthly/Quarterly | Identifies determination turnaround times monthly and quarterly |
| SCDHHS Determinations | Monthly/Quarterly | Identifies summary of final determinations monthly and quarterly |
| SCM Supplemental Rebate Invoices | Quarterly | Identifies total expenditure and amounts rebated quarterly |
| SC Pharmacy Utilization and Expenditure | Monthly/Quarterly | Identifies pharmacy metrics monthly and quarterly |
File details come from the government source that posted it. Updated .