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

sub-job

USHP · RevFind-Transform-ChargeDimensions-MultiSource

called by RevFind-Daily-Processing-Accounts

sub-job USHP/RevFind-Transform-ChargeDimensions-MultiSource · db USHP_ProdMirror · updated 2026-03-27

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-ChargeDimensions-MultiSource

9 tasks · USHP
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 TempChargeSchedulessqlrevfind_transform_chargedimensions_multisource__load_tempchargeschedules.sql
    ✨ Builds a temporary table of charge schedules by identifying distinct start and end dates from multiple source chargemasters.
    writes TempChargeSchedules
  2. Load FeeScheduleRecordsqlrevfind_transform_chargedimensions_multisource__load_feeschedulerecord.sql
    ✨ Loads fee schedule records with pricing, modifiers, and priority levels mapped from various source chargemasters and temporary schedules.
    writes FeeScheduleRecord · reads SourceChargeMasterSourceChargeMasterDESourceChargeMasterFLTempChargeSchedules
    ↳ feeds from Load TempChargeSchedules
  3. Load ScheduleMapsqlrevfind_transform_chargedimensions_multisource__load_schedulemap.sql
    ✨ Maps charge schedules to specific facilities and insurance categories to define active pricing periods for professional and facility fees.
    writes ScheduleMap · reads FacilityTempChargeSchedules
    ↳ feeds from Load TempChargeSchedules
  4. Load ContractMapsqlrevfind_transform_chargedimensions_multisource__load_contractmap.sqldisabled
    ✨ Updates the contract map to define fee logic and billing types for facilities and professional services.
    writes ContractMap · reads Facility
  5. Load ScheduleLoadEntities
    writes Schedule · reads TempChargeSchedules
    ↳ feeds from Load TempChargeSchedules
    entity type=Schedulecustom query
  6. Merge ChargeTypeMergeSql
    writes ChargeType · reads SourceChargeMasterSourceChargeMasterDESourceChargeMasterFL
    merge data source type=ThisDatabasetable name=ChargeTypemerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  7. Load ChargeType Dimensionsqlrevfind_transform_chargedimensions_multisource__load_chargetype_dimension.sql
    ✨ Loads charge type members into the dimension table to support hierarchical reporting and data categorization.
    writes DimensionMember · reads ChargeType
    ↳ feeds from Merge ChargeType
  8. Load ProcedureCode Dimensionsqlrevfind_transform_chargedimensions_multisource__load_procedurecode_dimension.sql
    ✨ Builds the procedure code dimension by extracting codes from charge types and mapping them to standard descriptions and categories.
    writes DimensionMember · reads ChargeTypeDimensionMemberProcedureCode
    ↳ feeds from Load ChargeType Dimension, Load ProcedureCategory and Subcategory DM, Merge ChargeType
  9. Load ProcedureCategory and Subcategory DMsqlrevfind_transform_chargedimensions_multisource__load_procedurecategory_and_subcategory_dm.sql
    ✨ Builds the procedure category dimension by extracting unique parent groupings from existing procedure code members.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load ChargeType Dimension, Load ProcedureCode Dimension