# Plastic Surgery review brief — app condition

**To:** Theo Grant, product manager  
**Prepared by:** Samira Patel, fictional AI study persona  
**Status:** Draft; source/account validation pending

For HCPCS 19318 (breast reduction), average payment rises from **$190.79 to $194.74**, a **$3.95 / 2.1%** increase. Services rise from **1,727 to 1,798**, or **71 / 4.1%**. The supplied raw files independently reproduce the weighted payments and service counts using Plastic Surgery, HCPCS 19318, and at least 11 services per row. Changes use displayed cent-rounded payments and prior-year denominators.

The supplied sales report includes Plastic Surgery: **54 open deals / $4,649,500 assumed annual contract value**, representing **11.6%** of the **$40,178,200** all-specialty open total. At the invented **2026-08-31** scenario date, **all 54 deals** are overdue: **$4,649,500**, **45–311 days**. No selected open deal has a missing or invalid close date. Overdue deals remain in the open total.

**First question:** Which of those 54 opportunities remain active, and what account evidence is needed before connecting any confirmed customer problem to the payment pattern?

**Next reviewer and check:** Theo should ask the sales operations lead to reconcile the 54 stages and close dates against current account records, document confirmed corrections, and return the active exposure. Past-due dates alone do not close deals. The specialty analyst should explain source composition and service mix before Theo chooses further account-discovery questions.

All records are synthetic; 2022 is a generated comparison and 2023 a synthetic base, not a historical CMS trend. All 500 sales rows are included without period filtering; source capture time is unknown and stages are shown as supplied. Practice reimbursement and vendor software ACV are distinct. Unweighted ACV is neither recognized revenue nor a forecast. The unvalidated pressure score does not establish account need, product demand, purchase propensity, or outreach priority. No product/commercial recommendation or CRM update is made.

This completes the analyst fields from the untouched app export. Verification used the supplied local files; pinned links below identify provenance and were not fetched externally. Browser usability and human preparation time are not measured.

## Pinned sources

- [mart](https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/data/releases/databricks-527988765998273/mart.csv)
- [raw 2022](https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/data/sample_2022_puf_10k.csv)
- [raw 2023](https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/data/sample_2023_puf_10k.csv)
- [sales](https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/data/sample_sfdc_pipeline.csv)
- [metrics](https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/docs/METRIC_CERTIFICATION_LOG.md)