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

sub-job

SeaRad · Load-ALL-Medicare-Schedules

called by Daily-Visit-Processing, Daily-Visit-Processing-HL7

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

9 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 ContractMapsqlload_all_medicare_schedules__load_contractmap.sqldisabled
    ✨ Builds Medicare contract mappings for all facilities to define professional billing logic and effective coverage periods.
    writes ContractMap · reads ContractMapFacility
  2. ▶Load-Medicare-DME-Schedulessub-job · 3↗
    1. Load All Medicare DME Schedulessqlload_medicare_dme_schedules__load_all_medicare_dme_schedules.sql
      ✨ Loads Medicare Durable Medical Equipment fee schedules and facility mappings for the specified state into the system.
    2. 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-DME Schedules to All Insurances
      entity type=Schedulecustom query
    3. Copy Medicare-DME Schedules to All Insurancessqlload_medicare_dme_schedules__copy_medicare_dme_schedules_to_all_insurances.sql
      ✨ Replicates Medicare Durable Medical Equipment schedules across all other insurance providers to ensure consistent pricing maps.
      writes ScheduleMap · reads DimensionMemberScheduleMap
  3. ▶Load-Medicare-Drug-Schedulessub-job · 3↗
    1. 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.
    2. 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
    3. 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
  4. ▶Load-Medicare-Lab-Schedulessub-job · 11↗Update this with dbo.GetMedicareLabAmount when completed
    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
  5. ▶Load-Medicare-RVU-Schedulessub-job · 4↗
    1. 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.
    2. 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.
    3. 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
    4. 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
  6. ▶Load-Endoscopy-Base-Schedulessub-job · 5↗Copy from SSR
    1. [DISABLED]Load Endoscopy-Base-2015LoadScheduledisabled
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataEndoscopyBase
      schedule=Endoscopy-Base-2015schedule type=Endoscopy-BaseDISABLED
    2. [DISABLED]Load Endoscopy-Base-2016LoadScheduledisabled
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataEndoscopyBase
      schedule=Endoscopy-Base-2016schedule type=Endoscopy-BaseDISABLED
    3. Load-From-Commondatasqlload_endoscopy_base_schedules__load_from_commondata.sql
      ✨ Loads Medicare endoscopy base schedules and facility mappings from common data for specific regional localities.
      writes ScheduleMapcodeschedulerecord · reads FacilitymedicareEndoscopyschedulemedicareEndoscopyscheduleMapschedulemap
      ↳ feeds from Copy Endoscopy-Base Schedules to All Insurances
    4. 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 Endoscopy-Base Schedules to All Insurances, Load-From-Commondata
      entity type=Schedulecustom query
    5. Copy Endoscopy-Base Schedules to All Insurancessqlload_endoscopy_base_schedules__copy_endoscopy_base_schedules_to_all_insurances.sql
      ✨ Copies Medicare endoscopy base schedules to all other insurance providers within the schedule mapping table.
      writes ScheduleMap · reads DimensionMemberScheduleMap
      ↳ feeds from Load-From-Commondata
  7. ▶Load-Multiple-Procedure-Schedulessub-job · 11↗Copy from SSR
    1. Load Multiple-Procedure-2014LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2014schedule type=Multiple-Procedure
    2. Load Multiple-Procedure-2015LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2015schedule type=Multiple-Procedure
    3. Load Multiple-Procedure-2016LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2016schedule type=Multiple-Procedure
    4. Load Multiple-Procedure-2017LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2017schedule type=Multiple-Procedure
    5. Load Multiple-Procedure-2018LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2018schedule type=Multiple-Procedure
    6. Load Multiple-Procedure-2019LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2019schedule type=Multiple-Procedure
    7. Load Multiple-Procedure-2020LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2020schedule type=Multiple-Procedure
    8. Load Multiple-Procedure-2021LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2021schedule type=Multiple-Procedure
    9. Load Multiple-Procedure-2022LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2021schedule type=Multiple-Procedure
    10. Load Multiple-Procedure-2023LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2023schedule type=Multiple-Procedure
    11. Load Multiple-Procedure-2024LoadSchedule
      writes CodeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsuranceMedicareScheduleDataMultipleProcedure
      schedule=Multiple-Procedure-2024schedule type=Multiple-Procedure
  8. ▶Load-MidLevelProvider-Schedulessub-job · 10↗Copy from SSR
    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
  9. Load Medicare Carveout Schedule 2019LoadSchedule
    writes FeeScheduleRecordScheduleMap · reads DimensionMemberFacilityImportMedicareCarveoutInsurance
    schedule=Medicare-Carveout-2019schedule type=Carve-Outs