sub-job

SeaRad · Load-Medicare-RVU-Schedules

called by Load-ALL-Medicare-Schedules

sub-job SeaRad/Load-Medicare-RVU-Schedules · db SeaRad_ProdMirror · updated 2025-09-17

task tree

What the sub-job runs

Tasks in order, each with what it does — typed stepsfrom the MDClarity task docs (click to open the reference), sub-jobsyou can expand inline (▶) to reveal their own tasks, and SQL steps summarized by Gemini (✨). Every step shows the tables it writes/reads and which earlier step it feeds from(sqlglot lineage).

sub-job

Load-Medicare-RVU-Schedules

4 tasks · SeaRad

sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc

Load Medicare RVU Schedules Clinicsqlload_medicare_rvu_schedules__load_medicare_rvu_schedules_clinic.sql
✨ Calculates and loads Medicare clinic fee schedules based on Relative Value Units and regional conversion factors.
Load Medicare RVU Schedules Hospitalsqlload_medicare_rvu_schedules__load_medicare_rvu_schedules_hospital.sqldisabled
✨ Builds and updates Medicare RVU fee schedules and facility mappings for hospital-based services using regional zip code data.
LoadEntitiesFromQueryLoadEntitiesFromQuery
Load or update entity records from custom SQL query results into their corresponding system tables using intelligent merge logic.
writes Schedule · reads Schedulemapschedule
↳ feeds from Copy Medicare-RVU Schedules to All Insurances
entity type=Schedulecustom query
Copy Medicare-RVU Schedules to All Insurancessqlload_medicare_rvu_schedules__copy_medicare_rvu_schedules_to_all_insurances.sql
✨ Replicates Medicare RVU schedule mappings across all non-government insurance providers to standardize fee schedule assignments.
writes ScheduleMap · reads DimensionMemberScheduleMap