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

sub-job

StrideCare · RevFind-Transform-ChargeType

Load the Charge Types from ChargeMaster + CPT Crosswalk

called by RevFind-Daily-Processing-Accounts-33143

sub-job StrideCare/RevFind-Transform-ChargeType · db StrideCare_ProdMirror · updated 2026-06-09

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

12 tasks · StrideCare
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 TransformChargeMasterMergeSqldisabled
    writes TransformChargeMaster · reads SourceFeeScheduleDepartmentsourcefeeschedulesourcefeescheduleprocedure
    merge data source type=ThisDatabasetable name=TransformChargeMastermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  2. Merge ChargeTypeMergeSql
    writes ChargeType · reads ChargeTypeSourceProcedureCode_33143
    merge data source type=ThisDatabasetable name=ChargeTypemerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  3. 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
  4. 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
  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
  7. Load ProcedureCategory into DimensionMembersqlrevfind_transform_chargetype__load_procedurecategory_into_dimensionmember.sql
    ✨ Builds procedure category dimension members by extracting parent groupings from existing procedure codes to support hierarchical reporting.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Merge ChargeType into DimensionMember, Merge ProcedureCode DimensionMember
  8. Load TempFeeScheduleMapsqlrevfind_transform_chargetype__load_tempfeeschedulemap.sql
    ✨ Builds a temporary mapping table that identifies and categorizes fee schedules as either self-pay or chargemaster for specific departments.
    writes TempFeeScheduleMap · reads SourceFeeSchedAllowableCategory_33143SourceFeeScheduleDepartment_33143SourceFeeSchedule_33143SourcePayer_33143
  9. Load Chargemaster into ScheduleMap/FeeScheduleRecordsqlrevfind_transform_chargetype__load_chargemaster_into_schedulemap_feeschedulerecord.sql
    ✨ Loads chargemaster rates and facility mappings into the system to define standard billing amounts for medical procedures.
    writes FeeScheduleRecordScheduleMap · reads SourceFeeScheduleProcedure_33143TempFeeScheduleMap
    ↳ feeds from Load TempFeeScheduleMap
  10. Load Self-Pay Fees into ScheduleMap/FeeScheduleRecordsqlrevfind_transform_chargetype__load_self_pay_fees_into_schedulemap_feeschedulerecord.sql
    ✨ Loads self-pay fee schedules and facility mappings to establish fixed pricing for patients without insurance coverage.
    writes FeeScheduleRecordScheduleMap · reads SourceFeeScheduleProcedure_33143TempFeeScheduleMap
    ↳ feeds from Load TempFeeScheduleMap
  11. LoadEntitiesFromQuery (Chargemaster schedules)LoadEntities
    writes Schedule · reads TempFeeScheduleMap
    ↳ feeds from Load TempFeeScheduleMap
    entity type=Scheduleauto querykey prefix=S
  12. LoadEntitiesFromQuery (Selfpay schedules)LoadEntities
    writes Schedule · reads TempFeeScheduleMap
    ↳ feeds from Load TempFeeScheduleMap
    entity type=Scheduleauto querykey prefix=S