SQL — Output

SQL Files

Sub-version merge (orchestrator)

File	Description
merge_combined_chunks.sql	Merges per-payer combined_main chunks into the sub-version combined table
union_combined_abridged.sql	Builds prod_combined_abridged by UNIONing sub-version outputs and selecting the abridged column set
union_combined_all.sql	Builds prod_combined_all with the full column set
merge_rate_object_space.sql	Merges ROS sub-version outputs
traceability_formulas.sql	Computes canonical_rate_source and canonical_rate_subversion traceability columns
traceability_to_raw_data.sql	Links canonical rates back to the originating raw source row

Views (rollups & segments)

File	Description
views/rollups/payer.sql	prod_rollup_payer — payer-level rate summary
views/rollups/network.sql	prod_rollup_network — network-level rate summary
views/rollups/provider.sql	prod_rollup_provider — provider-level rate summary
views/rollups/code.sql	prod_rollup_code — code-level rate summary
views/segments/medical.sql	prod_segment_medical — medical (non-drug) rate segment
views/segments/drugs.sql	prod_segment_drug — drug rate segment

Publish

File	Description
copy_table_to_production.sql	Copies prod_combined_abridged to tq_production.clear_rates_YYYY_MM.prod_combined_abridged