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

sub-job

SeaRad · Load-Endoscopy-Base-Schedules

Copy from SSR

called by Load-ALL-Medicare-Schedules

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

5 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. [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