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

sub-job

MNEye · Load-Charge-Dimension

called by Daily-Processing-Source-Data

sub-job MNEye/Load-Charge-Dimension · db MNEye_ProdMirror · updated 2026-02-03

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-Charge-Dimension

14 tasks · MNEye
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. TransformChargemaster ExecuteMergeSqlMergeSql
    writes TransformChargemaster · reads SourceChargeMaster
    merge data source type=ThisDatabasetable name=TransformChargemastermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  2. Add Missing Codes to Chargemaster (for now hack)sqlload_charge_dimension__add_missing_codes_to_chargemaster_for_now_hack.sql
    ✨ Inserts manual charge code entries into the chargemaster to address missing data for specific practices.
    writes TransformChargemaster · reads TransformChargemaster
    ↳ feeds from TransformChargemaster ExecuteMergeSql
  3. End to end chargemaster updatesqlload_charge_dimension__end_to_end_chargemaster_update.sql
    ✨ Builds the end-to-end mapping between chargemaster schedules, facilities, and insurance records for fee calculation.
    writes FeeScheduleRecordScheduleMapTempChargeSchedules · reads FacilityTempChargeSchedulesTransformChargeMaster
    ↳ feeds from Add Missing Codes to Chargemaster (for now hack), TransformChargemaster ExecuteMergeSql
  4. Load TempChargeSchedulessqlload_charge_dimension__load_tempchargeschedules.sqldisabled
    ✨ Builds temporary charge schedules by determining the effective start and end dates for each practice's chargemaster.
    writes TempChargeSchedules
  5. Load FeeScheduleRecordsqlload_charge_dimension__load_feeschedulerecord.sqldisabled
    ✨ Loads fee schedule records with specific amounts and modifier filters based on practice-specific chargemaster data and schedules.
    writes FeeScheduleRecord · reads SourceChargeMasterTempChargeSchedules
  6. Load ScheduleMapsqlload_charge_dimension__load_schedulemap.sqldisabled
    ✨ Updates the schedule map to link professional and facility fee schedules with their respective facilities and insurance categories.
    writes ScheduleMap · reads FacilityTempChargeSchedules
  7. Load ContractMapsqlload_charge_dimension__load_contractmap.sqldisabled
    ✨ Builds the contract mapping table by defining charge logic and bill types for various service categories across all locations.
    writes ContractMap · reads Facility
  8. Load ScheduleLoadEntities
    writes Schedule · reads ScheduleMapTempChargeSchedules
    ↳ feeds from End to end chargemaster update
    entity type=Schedulecustom query
  9. Load SourceChargeMapsqlload_charge_dimension__load_sourcechargemap.sql
    ✨ Loads a unified charge map by consolidating service-specific charge codes from the source master file for designated practices.
    writes SourceChargeMap · reads SourceChargeMaster
  10. Load ChargeTypesqlload_charge_dimension__load_chargetype.sqldisabled
    ✨ Builds the charge type table by mapping charge codes to display names, bill types, and specific billing rules or modifiers.
    writes ChargeType · reads MedicareRVUScheduleMedicareRVUScheduleMapSourceChargeMap
  11. Merge ChargeTypeMergeSql
    writes ChargeType · reads ChargeTypeMedicareRVUScheduleMedicareRVUScheduleMapSourceChargeMap
    ↳ feeds from Load SourceChargeMap
    merge data source type=ThisDatabasetable name=ChargeTypemerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  12. Load ChargeType Dimensionsqlload_charge_dimension__load_chargetype_dimension.sql
    ✨ Updates the charge type dimension by populating unique charge codes and descriptions for multiple billing categories.
    writes DimensionMember · reads DimensionMemberSourceChargeMap
    ↳ feeds from Load ProcedureCategory and Subcategory DM, Load ProcedureCode Dimension, Load SourceChargeMap
  13. Load ProcedureCode Dimensionsqlload_charge_dimension__load_procedurecode_dimension.sql
    ✨ Loads the procedure code dimension by organizing unique codes and descriptions into a hierarchical structure for reporting and analysis.
    writes DimensionMember · reads SourceChargeMap
    ↳ feeds from Load SourceChargeMap
  14. Load ProcedureCategory and Subcategory DMsqlload_charge_dimension__load_procedurecategory_and_subcategory_dm.sql
    ✨ Builds hierarchical dimensions for procedure categories and subcategories to enable grouped analysis of medical services and billing codes.
    writes DimensionMember · reads SourceChargeMap
    ↳ feeds from Load SourceChargeMap