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

sub-job

OneGI · Flow-MM-Processing-CustomProperty

called by Flow-MM-Processing-LoadVisits, Flow-ECW-Processing-LoadVisits

sub-job OneGI/Flow-MM-Processing-CustomProperty · db OneGI_ProdMirror · updated 2026-01-16

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

Flow-MM-Processing-CustomProperty

4 tasks · OneGI
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 Primary Coverage StatusUpdateCustomPropertyFromQuery
    · reads TransformVisitInsuranceCoverageStatusVisitBatch
    entity=Visitcustom property key=PrimaryCoverageStatuscustom querybatch mode
  2. Load Secondary Coverage StatusUpdateCustomPropertyFromQuery
    · reads TransformVisitInsuranceCoverageStatusVisitBatch
    entity=Visitcustom property key=SecondaryCoverageStatuscustom querybatch mode
  3. Load Tertiary Coverage StatusUpdateCustomPropertyFromQuery
    · reads TransformVisitInsuranceCoverageStatusVisitBatch
    entity=Visitcustom property key=TertiaryCoverageStatuscustom querybatch mode
  4. Load Colonoscopy TypeUpdateCustomPropertyFromQuery
    · reads TransformVisitVisitBatch
    entity=Visitcustom property key=ColonoscopyTypecustom querybatch mode