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

sub-job

MiddletownMedical · RevFind-Transform-ChargeType

Loads the ChargeType Table, and the ChargeType, ProcedureCode, ProcedureCodeCategory dimensions

called by RevFind-Daily-Processing

sub-job MiddletownMedical/RevFind-Transform-ChargeType · db MiddletownMedical_ProdMirror · updated 2026-04-28

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-Transform-ChargeType

6 tasks · MiddletownMedical
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. Merge ChargeTypeMergeSql
    writes ChargeType · reads SourceECWChargeItemsSourceECWEdiInvCPT
    merge data source type=ThisDatabasetable name=ChargeTypemerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  2. Merge ProcedureCode DimensionMemberMergeSql
    writes DimensionMember · reads ChargeTypeProcedureCode
    ↳ feeds from Merge ChargeType
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  3. Merge ChargeType into DimensionMemberMergeSql
    writes DimensionMember · reads ChargeType
    ↳ feeds from Merge ChargeType
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  4. Update ChargeMaster SchedulesUpdateFeePricingdisabled
    writes FeePricingRecord · reads SourceChargeMaster
    schedule insert type=Replaceschedule type=Chargessource table=SourceChargeMasterDISABLED
  5. Load Charges SchedulesLoadFeeSchedulesdisabled
    Generate time-based fee schedules from pricing records to establish effective date ranges for facility and insurance billing combinations.
    writes ScheduleScheduleMap · reads FeePricingRecord
    DISABLED
  6. Merge ProcedureCategory DimensionMergeSql
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Merge ChargeType into DimensionMember, Merge ProcedureCode DimensionMember
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock