# Texas directed-payment reconciliation calculations (TIPPS, DPP-BHS, RAPPS) by NPI, plan and state fiscal year: NOT payments

`medicare_semantic.vw_medicaid_tx_sdp_reconciliation_calculations_v1` · State programs · status partial · 42,503 rows

Texas HHSC's published reconciliation workbooks for three directed-payment programs: scorecard, recalculated, allocation and recoupment CALCULATIONS by NPI and plan. These are calculations, not payments: no paid amount, no hospital receipt, never comparable with payments or SDP ceilings.

**Grain.** One row per NPI x plan x program x period_key (source_sha256 + source_locator unique); 42,503 rows: TIPPS 2,260, DPP-BHS 35,229, RAPPS 5,014, SFY2022-2025.

| column | type | meaning |
|---|---|---|
| state | varchar(2) |  |
| program | string |  |
| period_key | string |  |
| program_year | string |  |
| medicaid_program | string |  |
| payment_kind | varchar(35) |  |
| amount_kind | string |  |
| basis | string |  |
| edition_role | string |  |
| edition_basis | string |  |
| hospital_receipt_attribution | string |  |
| mco | string |  |
| plan_code | string |  |
| plan_name | string |  |
| sda | string |  |
| rhc_class | string |  |
| risk_group | string |  |
| npi | string |  |
| provider_name | string |  |
| identity_provider_ccn | string |  |
| identity_match_method | string |  |
| identity_confidence | string |  |
| mco_allocation_calc_usd | decimal(38,2) |  |
| mco_allocation_calc_basis | string |  |
| scorecard_calc_usd | decimal(38,2) |  |
| scorecard_calc_basis | string |  |
| recalculated_calc_usd | decimal(38,2) |  |
| recalculated_calc_basis | string |  |
| recoupment_calc_usd | decimal(38,2) |  |
| recoupment_calc_basis | string |  |
| difference_calc_usd | decimal(38,2) |  |
| difference_calc_basis | string |  |
| source_id | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| source_locator | string |  |
| sheet | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_medicaid_tx_sdp_reconciliation_calculations_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_medicaid_tx_sdp_reconciliation_calculations_v1")` first.