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
RevFind-Process-Load-ChargeType
5 tasks · SGP
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 ChargeTypesql
revfind_process_load_chargetype__load_chargetype.sql✨ Builds the charge type table by categorizing procedure codes into professional or facility bill types based on encounter data.writesChargeType· readsProcedureCodeSourceChargeSourceEncounter - Load ChargeType Dimensionsql
revfind_process_load_chargetype__load_chargetype_dimension.sql✨ Loads charge type members into the dimension table to support hierarchical reporting and data categorization.writesDimensionMember· readsChargeType↳ feeds from Load ChargeType - Load ProcedureCode Dimensionsql
revfind_process_load_chargetype__load_procedurecode_dimension.sql✨ Loads procedure code dimension members by mapping charge types to their respective descriptions and CPT categories.writesDimensionMember· readsChargeTypeProcedureCode↳ feeds from Load ChargeType - Load ProcedureCategory Dimensionsql
revfind_process_load_chargetype__load_procedurecategory_dimension.sql✨ Builds the procedure category dimension by extracting parent categories from existing procedure code records.writesDimensionMember· readsDimensionMember↳ feeds from Load ChargeType Dimension, Load ProcedureCode Dimension - Load Modifiers Dimensionsql
revfind_process_load_chargetype__load_modifiers_dimension.sqldisabled✨ Loads unique billing modifiers from transformed charge records into the dimension member table.writesDimensionMember· readsTransformCharge