sub-job

SeaRad · Load-Medicare-Drug-Schedules

called by Load-ALL-Medicare-Schedules

sub-job SeaRad/Load-Medicare-Drug-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-Drug-Schedules

3 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 All Medicare Drug Schedulessqlload_medicare_drug_schedules__load_all_medicare_drug_schedules.sql
✨ Loads Medicare drug fee schedules and facility mappings into the system based on current Medicare pricing 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-Drug Schedules to All Insurances
entity type=Schedulecustom query
Copy Medicare-Drug Schedules to All Insurancessqlload_medicare_drug_schedules__copy_medicare_drug_schedules_to_all_insurances.sql
✨ Copies Medicare drug pricing schedules to all other insurance providers within the schedule mapping configuration.
writes ScheduleMap · reads DimensionMemberScheduleMap