sub-job

OrthoAlliance · Flow-34792-Transform-LoadDimensionMembers

called by Flow-34792-Processing

sub-job OrthoAlliance/Flow-34792-Transform-LoadDimensionMembers · db OrthoAlliance_ProdMirror · updated 2026-06-01

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-34792-Transform-LoadDimensionMembers

3 tasks · OrthoAlliance

sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc

Load Time Dimensionssqlflow_34792_transform_loaddimensionmembers__load_time_dimensions.sql
✨ Builds and updates time-based dimension members for days, months, and years based on the range of scheduled appointment dates.
writes DimensionMember · reads TransformVisit
Load VisitStatus Dimensionsqlflow_34792_transform_loaddimensionmembers__load_visitstatus_dimension.sql
✨ Loads appointment status values into the visit status dimension to track patient encounter progress.
writes DimensionMember · reads TransformVisit
Load VisitType Dimensionssqlflow_34792_transform_loaddimensionmembers__load_visittype_dimensions.sql
✨ Builds and updates visit type dimension members using the most recent appointment data from HL7 visit messages.
writes DimensionMember · reads HL7Visit