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

sub-job

Commonwealth · Load-ChargeType

Load the Charge Types from ChargeMaster + CPT Crosswalk

called by Daily-Accounts-Processing

sub-job Commonwealth/Load-ChargeType · db Commonwealth_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-ChargeType

6 tasks · Commonwealth
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-ImportChargeTypesqlload_chargetype__load_importchargetype.sql
    ✨ Loads formatted charge type definitions from the charge master to prepare display names and billing codes for the system.
    writes ImportChargeType · reads SourceChargeMaster
  2. Merge-ChargeTypesqlload_chargetype__merge_chargetype.sql
    ✨ Updates the final charge type table with claim-level and procedure-specific billing configurations for use across the application.
    writes ChargeType · reads ImportChargeType
    ↳ feeds from Load-ImportChargeType
  3. Update-ProcedureCode-DimensionMembersqlload_chargetype__update_procedurecode_dimensionmember.sql
    ✨ Updates the procedure code dimension with member IDs, descriptions, and category hierarchies to support clinical service reporting.
    writes DimensionMember · reads ChargeTypeProcedureCode
    ↳ feeds from Merge-ChargeType
  4. Update-ChargeType-DimensionMembersqlload_chargetype__update_chargetype_dimensionmember.sql
    ✨ Loads charge type identifiers and display names into the dimension table to categorize financial transactions.
    writes DimensionMember · reads ChargeType
    ↳ feeds from Merge-ChargeType
  5. Update ChargeMaster SchedulesUpdateFeePricing
    writes FeePricingRecord · reads SourceChargeMaster
    schedule insert type=Replaceschedule type=Chargessource table=SourceChargeMaster
  6. Load Charges SchedulesLoadFeeSchedules
    Generate time-based fee schedules from pricing records to establish effective date ranges for facility and insurance billing combinations.
    writes ScheduleScheduleMap · reads FeePricingRecord
    ↳ feeds from Update ChargeMaster Schedules