SQL — Transformations
SQL Files
| File | Description |
|---|---|
transformations/transformations.sql | Builds tmp_int_transformations; converts all non-dollar rate columns (pct-of-charges, per-diem, drug dosage, anesthesia) to dollar equivalents across 6 gross charge sources; applies MS-DRG and APR-DRG crosswalks |
Input Tables (params.py)
| Variable | Table |
|---|---|
REF_CMS_MSDRG_WEIGHTS | tq_production.reference_internal.ipps_msdrg |
APR_DRG_XWALK_TABLE | tq_production.reference_legacy.drg_crosswalk |
ASP_PRICING_TABLE | tq_production.reference_internal.asp_reference_pricing |
ANESTHESIA_BASE_UNITS | tq_intermediate.cld_utils.ref_anesthesia_base_units |