Skip to main content

SOMC Pricing Results

Customer Details​

FieldValue
Customer Namesomc
Org ID730
Charge Multiplier0.50

Pre-Processing Test Results​

Test 1: Error in Notes Field​

StatusCountNotes
FAILED338Found 338 records containing errors in notes field

Resolution:

  • Reviewed error messages in notes field. These are due to an EAPG schedule issue due to Medicaid.
  • Confirmed with @Evelyn Ting we are good to move forward.

Test 2: Hospital Rates Plans Missing​

StatusCountNotes
FAILED2Found 2 payer/plan builds missing from line_item_price

Resolution:

  • Reviewed the two builds (below). These are both Medicaid plans. Flagged to @Gillian Halpin and @Megan Leak in #proj-pet-2_0.
MOLINA HEALTHCAREMEDICAID
UHCCPMEDICAID

Test 3: CSLI Subpackage Line Items Not Priced​

StatusCountNotes
PASSED0All subpackage line items were successfully priced

Resolution:

  • No action needed

Test 4: CSLI Subpackages Not Priced​

StatusCountNotes
PASSED0All subpackages were successfully priced

Resolution:

  • No action needed

Test 5: Duplicate Active Contracts​

StatusCountNotes
FAILED1Found 1 payer/plan/provider combo with multiple active contracts

Resolution:

  • Reviewed the duplicates (below). @Megan Leak confirmed this is expected for SOMC.
2484CignaCommercial2374
2484CignaCommercial532

Test 6: No Match in Hospital Rates​

StatusCountNotes
FAILED1606Found 1606 line items with no match in hospital_rates

Test 7: Multiple Matches in Hospital Rates​

StatusCountNotes
FAILED4767Found 4767 line items with multiple matches in hospital_rates

Resolution:

  • Reviewed and saw 96% of total have duplicates. Flag to @Evelyn Ting.

Test 11: Pricing Flags​

Flag TypeCountNotes
ZERO_PRICE4230All flagged items are $0 pricing
UNDER_5_PCT0
UNDER_10_PCT0
OVER_200_PCT0

Resolution:

  • May be related to Test 1 errors or Test 6/7 hospital_rates matching issues. Flag to @Evelyn Ting.

Post-Processing Test Results​

Will fill in after above are completed.

Test 8: Zero Prices in Final Table​

StatusCountNotes

Resolution:

  • [ ]

Test 9: Benchmark vs Production SSPs​

StatusCountMax VarianceNotes
SSPs with >25% variance
SSP IDSSP NameOutput AvgProd AvgVariance %

Resolution:

  • [ ]

Test 10: Benchmark vs Cash Prices​

StatusCountMax VarianceNotes
SSPs with >25% variance
SSP IDSSP NameOutput AvgProd AvgVariance %

Resolution:

  • [ ]
On this page: