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-ChargeMaster-RevFind
3 tasks · HeatonEye
sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc
- Analyzes a delimited file's structure to automatically infer column definitions and save a reusable specification for future imports.data file spec key=ImportChargemasterfile path={FilePath}table name=ImportChargeMasterrow terminator=Newlinecolumn separator=Pipe
- Load ImportChargeMasterLoadFilewrites
ImportChargemasterdata file spec=ImportChargemasterfile path={FilePath}import mode=Replacearchive file path={SourceDataArchiveRevFind} - Merge SourceChargeMastersql
load_chargemaster_revfind__merge_sourcechargemaster.sql✨ Updates the source chargemaster table with imported data, including pricing, descriptions, and coding details for active service items.writessourcechargemaster· readsimportchargemaster↳ feeds from Load ImportChargeMaster