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

sub-job

EyeSouth · Load-Charges

called by Daily-Processing

sub-job EyeSouth/Load-Charges · db EyeSouth_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-Charges

7 tasks · EyeSouth
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 ChargeTypeMap (PP)sqlload_charges__load_chargetypemap_pp.sql
    ✨ Updates the charge type mapping table by consolidating service, supply, and product identifiers from source practice management systems.
    writes ChargeTypeMap · reads SourceNextTechPPChargemasterSourceNextTechPPProductSourceNextTechPPSupply
  2. Load ChargeTypeMap (Select)sqlload_charges__load_chargetypemap_select.sql
    ✨ Updates charge type mappings for select practices by linking chargemaster codes with their respective database and practice identifiers.
    writes ChargeTypeMap · reads ImportNextTechSelectChargemasterImportNextTechSelectPractice
  3. Load TransformChargemastersqlload_charges__load_transformchargemaster.sql
    ✨ Builds a transformed chargemaster by combining services, supplies, and products with specific bill types and active pricing data.
    writes TransformChargeMaster · reads ChargeTypeMapImportNextTechSelectChargeImportNextTechSelectChargemasterSourceNextTechPPChargeSourceNextTechPPChargemasterSourceNextTechPPProductSourceNextTechPPSupplyTransformAccountCharge
    ↳ feeds from Load ChargeTypeMap (PP), Load ChargeTypeMap (Select)
  4. Load ChargeTypesqlload_charges__load_chargetype.sql
    ✨ Loads the charge type table with formatted display names and concatenated code strings for claim and service-level reporting.
    writes ChargeType · reads TransformChargemaster
    ↳ feeds from Load TransformChargemaster
  5. Load TransformChargeMaster (NG)sqlload_charges__load_transformchargemaster_ng.sqldisabled
    ✨ Rebuilds the transformed chargemaster table with effective dates and pricing tiers for specific practice charge codes.
    writes TransformChargeMaster
  6. Load ContractMapsqlload_charges__load_contractmap.sqldisabled
    ✨ Builds default contract mappings for all facility and bill type combinations to support charge-based fee logic.
    writes ContractMap · reads BillTypeFacility
  7. ▶Load-Mid-Level-Chargessub-job · 1↗loads the standard Medicare % adjustments into FeeScheduleRecord for charges when a mid-level provider is rendering
    1. Load Medicare Mid-Level-Charges ScheduleLoadSchedule
      writes FeeScheduleRecordScheduleMap · reads ChargeTypeFacilityInsurance
      schedule=Medicare-Mid-Level-Chargesschedule type=Mid-Level-Charges