sub-job

USDH · Load-Custom-Properties

called by Load-Account-Data

sub-job USDH/Load-Custom-Properties · db USDH_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-Custom-Properties

2 tasks · USDH

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

Staging of Division Custom Prop Valuessqlload_custom_properties__staging_of_division_custom_prop_values.sql
✨ Stages account-level division properties by identifying practice ID changes that need to be updated in the custom property mapping.
writes TempCustomProperty · reads TempCustomProperty
UpdateCustomPropertyFromQueryUpdateCustomPropertyFromQuery
· reads TempCustomProperty
↳ feeds from Staging of Division Custom Prop Values
entity=Accountcustom property key=Divisionauto querybatch mode