Legacy Pipeline Atlas worker-1snapshot 2026-07-15

sub-job

SeaRad · Load-MidLevelProvider-Schedules

Copy from SSR

called by Load-ALL-Medicare-Schedules

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

10 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
  1. Load Mid-Level Provider ScheduleLoadSchedule
    writes CodeScheduleRecordScheduleMap · reads FacilityInsuranceProviderProviderTaxonomy
    schedule=Mid-Level-Providersschedule type=Mid-Level-Providers
  2. Load Medicare Mid-Level-Charges 2016 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2016schedule type=Mid-Level-Charges
  3. Load Medicare Mid-Level-Charges 2017 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2017schedule type=Mid-Level-Charges
  4. Load Medicare Mid-Level-Charges 2018 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2018schedule type=Mid-Level-Charges
  5. Load Medicare Mid-Level-Charges 2019 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2019schedule type=Mid-Level-Charges
  6. Load Medicare Mid-Level-Charges 2020 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2020schedule type=Mid-Level-Charges
  7. Load Medicare Mid-Level-Charges 2021 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2021schedule type=Mid-Level-Charges
  8. Load Medicare Mid-Level-Charges 2022 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2022schedule type=Mid-Level-Charges
  9. Load Medicare Mid-Level-Charges 2023 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2023schedule type=Mid-Level-Charges
  10. Load Medicare Mid-Level-Charges 2024 scheduleLoadSchedule
    writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataRVU
    schedule=Medicare-Mid-Level-Charges-2024schedule type=Mid-Level-Charges