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

sub-job

OrthoAlliance · RevFind-SBO-Transform-ChargeType

Load the Charge Types from ChargeMaster + CPT Crosswalk

called by RevFind-SBO-Daily-Processing-Accounts

sub-job OrthoAlliance/RevFind-SBO-Transform-ChargeType · db OrthoAlliance_ProdMirror · updated 2025-10-08

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

6 tasks · OrthoAlliance
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 ChargeTypeSourceProcedureCodeOrthosSourceTransactionOrthos
    merge data source type=ThisDatabasetable name=ChargeTypemerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  2. Load TransformAthenaFeeScheduleMapsqlrevfind_sbo_transform_chargetype__load_transformathenafeeschedulemap.sql
    ✨ Builds a mapping of fee schedules to departments, identifying self-pay and chargemaster designations from source payer and schedule data.
    writes TransformAthenaFeeScheduleMap · reads SourceFeeSchedAllowableCategorySourceFeeScheduleDepartmentSourceFeeScheduleOrthosSourcePayerOrthosTransformAthenaFeeScheduleMap
  3. Update-ProcedureCode-DimensionMembersqlrevfind_sbo_transform_chargetype__update_procedurecode_dimensionmember.sql
    ✨ Updates the procedure code dimension with member IDs, descriptions, and category hierarchies to support clinical service reporting.
    writes DimensionMember · reads ChargeTypeProcedureCode
    ↳ feeds from Merge ChargeType
  4. Update-ChargeType-DimensionMembersqlrevfind_sbo_transform_chargetype__update_chargetype_dimensionmember.sql
    ✨ Updates the charge type dimension with standardized codes and display names for consistent reporting across the pipeline.
    writes DimensionMember · reads ChargeType
    ↳ feeds from Merge ChargeType
  5. Update ChargeMaster SchedulesUpdateFeePricingdisabled
    writes FeePricingRecord · reads SourceChargeMasterOrthos
    schedule insert type=Replaceschedule type=Chargessource table=SourceChargeMasterOrthosDISABLED
  6. 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