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

sub-job

SeaRad · Load-Medicare-Lab-Schedules

Update this with dbo.GetMedicareLabAmount when completed

called by Load-ALL-Medicare-Schedules

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

11 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 Medicare-Lab-2015LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads DimensionMemberFacilityMedicareScheduleDataLab
    schedule=Medicare-Lab-2015schedule type=Medicare-Lab
  2. Load Medicare-Lab-2016LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads DimensionMemberFacilityMedicareScheduleDataLab
    schedule=Medicare-Lab-2016schedule type=Medicare-Lab
  3. Load Medicare-Lab-2017LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads DimensionMemberFacilityMedicareScheduleDataLab
    schedule=Medicare-Lab-2017schedule type=Medicare-Lab
  4. Load Medicare-Lab-2018LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads CommonDataDimensionMemberFacilityFeeScheduleRecordScheduleMap
    ↳ feeds from Copy Medicare-Lab Schedules to All Insurances, Load Medicare-Lab-2015, Load Medicare-Lab-2016, Load Medicare-Lab-2017, Load Medicare-Lab-2019, Load Medicare-Lab-2020, Load Medicare-Lab-2021, Load Medicare-Lab-2022, Load Medicare-Lab-2023, Load Medicare-Lab-2024
    schedule=Medicare-Lab-2018schedule type=Medicare-Lab
  5. Load Medicare-Lab-2019LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads CommonDataDimensionMemberFacilityFeeScheduleRecordScheduleMap
    ↳ feeds from Copy Medicare-Lab Schedules to All Insurances, Load Medicare-Lab-2015, Load Medicare-Lab-2016, Load Medicare-Lab-2017, Load Medicare-Lab-2018, Load Medicare-Lab-2020, Load Medicare-Lab-2021, Load Medicare-Lab-2022, Load Medicare-Lab-2023, Load Medicare-Lab-2024
    schedule=Medicare-Lab-2019schedule type=Medicare-Lab
  6. Load Medicare-Lab-2020LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads CommonDataDimensionMemberFacilityFeeScheduleRecordScheduleMap
    ↳ feeds from Copy Medicare-Lab Schedules to All Insurances, Load Medicare-Lab-2015, Load Medicare-Lab-2016, Load Medicare-Lab-2017, Load Medicare-Lab-2018, Load Medicare-Lab-2019, Load Medicare-Lab-2021, Load Medicare-Lab-2022, Load Medicare-Lab-2023, Load Medicare-Lab-2024
    schedule=Medicare-Lab-2020schedule type=Medicare-Lab
  7. Load Medicare-Lab-2021LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads CommonDataDimensionMemberFacilityFeeScheduleRecordScheduleMap
    ↳ feeds from Copy Medicare-Lab Schedules to All Insurances, Load Medicare-Lab-2015, Load Medicare-Lab-2016, Load Medicare-Lab-2017, Load Medicare-Lab-2018, Load Medicare-Lab-2019, Load Medicare-Lab-2020, Load Medicare-Lab-2022, Load Medicare-Lab-2023, Load Medicare-Lab-2024
    schedule=Medicare-Lab-2021schedule type=Medicare-Lab
  8. Load Medicare-Lab-2022LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads CommonDataDimensionMemberFacilityFeeScheduleRecordScheduleMap
    ↳ feeds from Copy Medicare-Lab Schedules to All Insurances, Load Medicare-Lab-2015, Load Medicare-Lab-2016, Load Medicare-Lab-2017, Load Medicare-Lab-2018, Load Medicare-Lab-2019, Load Medicare-Lab-2020, Load Medicare-Lab-2021, Load Medicare-Lab-2023, Load Medicare-Lab-2024
    schedule=Medicare-Lab-2022schedule type=Medicare-Lab
  9. Load Medicare-Lab-2023LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads CommonDataDimensionMemberFacilityFeeScheduleRecordScheduleMap
    ↳ feeds from Copy Medicare-Lab Schedules to All Insurances, Load Medicare-Lab-2015, Load Medicare-Lab-2016, Load Medicare-Lab-2017, Load Medicare-Lab-2018, Load Medicare-Lab-2019, Load Medicare-Lab-2020, Load Medicare-Lab-2021, Load Medicare-Lab-2022, Load Medicare-Lab-2024
    schedule=Medicare-Lab-2023schedule type=Medicare-Lab
  10. Load Medicare-Lab-2024LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads CommonDataDimensionMemberFacilityFeeScheduleRecordScheduleMap
    ↳ feeds from Copy Medicare-Lab Schedules to All Insurances, Load Medicare-Lab-2015, Load Medicare-Lab-2016, Load Medicare-Lab-2017, Load Medicare-Lab-2018, Load Medicare-Lab-2019, Load Medicare-Lab-2020, Load Medicare-Lab-2021, Load Medicare-Lab-2022, Load Medicare-Lab-2023
    schedule=Medicare-Lab-2024schedule type=Medicare-Lab
  11. Copy Medicare-Lab Schedules to All Insurancessqlload_medicare_lab_schedules__copy_medicare_lab_schedules_to_all_insurances.sql
    ✨ Replicates Medicare laboratory fee schedules to all other insurance providers to maintain uniform pricing maps.
    writes ScheduleMap · reads DimensionMemberScheduleMap
    ↳ feeds from Load Medicare-Lab-2015, Load Medicare-Lab-2016, Load Medicare-Lab-2017, Load Medicare-Lab-2018, Load Medicare-Lab-2019, Load Medicare-Lab-2020, Load Medicare-Lab-2021, Load Medicare-Lab-2022, Load Medicare-Lab-2023, Load Medicare-Lab-2024