State programs

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·partial·semantic_view

Rows

42,503

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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

Grain

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

Columns (37)

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

describe_data_source(source_fqn="medicare_semantic.vw_medicaid_tx_sdp_reconciliation_calculations_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_medicaid_tx_sdp_reconciliation_calculations_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_sha256,source_locator`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_tx_sdp_reconciliation_calculations_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_tx_sdp_reconciliation_calculations_v1 (program = <one> AND period_key = <one>)
Note	Registered 2026-10-19 under register w8 (tx_medicaid_sdp_reconciliation_calculations) as the only read surface (registration branch codex/medicaid-fedreports). Door RAW, World W8, status partial, class unversioned. The base table medicare_silver.medicaid_tx_sdp_reconciliation_calculations_v1 is internal: no card, no World, refused NO_COVERAGE. Ships with the MCP lane's next main-based release.

This page as markdown: /docs-md/data/medicare_semantic_vw_medicaid_tx_sdp_reconciliation_calculations_v1.md · every page in one file: /llms-full.txt