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

sub-job

TheOregonClinic · RevFind-EDI-Process-LoadDimensionMembers

called by RevFind-EDI-Daily-Processing

sub-job TheOregonClinic/RevFind-EDI-Process-LoadDimensionMembers · db TheOregonClinic_ProdMirror · updated 2026-06-15

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-EDI-Process-LoadDimensionMembers

20 tasks · TheOregonClinic
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. LoadInsuranceDimensionMembersLoadInsuranceDimensionMembersdisabled
    Synchronize insurance-specific dimension members from the insurance table to update contract and eligibility filtering options across the application.
    writes DimensionMember
    load insuranceload quote insuranceload eligibility insuranceDISABLED
  2. Load Time Dimensionssqlrevfind_edi_process_loaddimensionmembers__load_time_dimensions.sql
    ✨ Updates the time dimension table with day, month, and year members to support temporal reporting across the pipeline.
    writes DimensionMember · reads TransformAccount
  3. Load ChargeType Dimensionsqlrevfind_edi_process_loaddimensionmembers__load_chargetype_dimension.sqldisabled
    ✨ Loads appointment status values into the visit status dimension to track patient encounter progress.
    writes DimensionMember · reads TransformVisit
  4. Load DenialCategory Dimensionsqlrevfind_edi_process_loaddimensionmembers__load_denialcategory_dimension.sql
    ✨ Loads denial category dimensions from adjustment code rollup data to categorize claim denials.
    writes DimensionMember · reads AdjustmentCodeRollup
  5. Load Provider + ProviderType Dimensionssqlrevfind_edi_process_loaddimensionmembers__load_provider_providertype_dimensions.sql
    ✨ Synchronizes provider and provider type dimensions by mapping individual providers to their respective specialty or classification categories.
    writes DimensionMember · reads DimensionMemberProvider
    ↳ feeds from Load AllowedStatus Dimension, Load ChargeType Dim, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load Facility + FacilityGroup Dimensions, Load FacilityType Dimensions, Load PlaceOfService Dimensions, Load ProcedureCode Dim, Load ProcedureModifier Dim, Load RevenueCode Dim, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadDimensionMembers
  6. Load Facility + FacilityGroup Dimensionssqlrevfind_edi_process_loaddimensionmembers__load_facility_facilitygroup_dimensions.sql
    ✨ Updates facility and facility group dimensions to organize locations within their parent organizational structures for reporting.
    writes DimensionMember · reads DimensionMemberFacility
    ↳ feeds from Load AllowedStatus Dimension, Load ChargeType Dim, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load FacilityType Dimensions, Load PlaceOfService Dimensions, Load ProcedureCode Dim, Load ProcedureModifier Dim, Load Provider + ProviderType Dimensions, Load RevenueCode Dim, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadDimensionMembers
  7. Load FacilityType Dimensionssqlrevfind_edi_process_loaddimensionmembers__load_facilitytype_dimensions.sql
    ✨ Loads unique facility types into the dimension table to categorize locations by their specific service or operational model.
    writes DimensionMember · reads Facility
  8. Load Practice Dimensionssqlrevfind_edi_process_loaddimensionmembers__load_practice_dimensions.sqldisabled
    ✨ Loads practice dimension members from the practice map for entities that have associated encounter records.
    writes DimensionMember · reads PracticeMapsourceencounter
  9. Load PlaceOfService Dimensionssqlrevfind_edi_process_loaddimensionmembers__load_placeofservice_dimensions.sql
    ✨ Loads the place of service dimension by synchronizing standardized facility codes and names from common reference data.
    writes DimensionMember · reads POSCodes
  10. Load VisitType Dimensionssqlrevfind_edi_process_loaddimensionmembers__load_visittype_dimensions.sqldisabled
    ✨ Loads and synchronizes visit type dimensions from event mapping data while removing entries no longer present in the source.
    writes DimensionMember · reads SourceEventTransformEventMap
  11. Load AccountStatus Dimensionsqlrevfind_edi_process_loaddimensionmembers__load_accountstatus_dimension.sqldisabled
    ✨ Updates account status dimensions using encounter status information to track the lifecycle of patient accounts.
    writes DimensionMember · reads SourceEncounter
  12. Load AllowedStatus Dimensionsqlrevfind_edi_process_loaddimensionmembers__load_allowedstatus_dimension.sql
    ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
    writes DimensionMember
  13. Load DiagnosisCode Dimensionsqlrevfind_edi_process_loaddimensionmembers__load_diagnosiscode_dimension.sql
    ✨ Builds diagnosis code dimensions by extracting codes from account charges and mapping them to standardized medical categories.
    writes DimensionMember · reads AccountChargeDimensionMember
    ↳ feeds from Load AllowedStatus Dimension, Load ChargeType Dim, Load DenialCategory Dimension, Load Facility + FacilityGroup Dimensions, Load FacilityType Dimensions, Load PlaceOfService Dimensions, Load ProcedureCode Dim, Load ProcedureModifier Dim, Load Provider + ProviderType Dimensions, Load RevenueCode Dim, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadDimensionMembers
  14. Load-Source-Insurance-Dimensionsqlrevfind_edi_process_loaddimensionmembers__load_source_insurance_dimension.sql
    ✨ Updates the insurance dimension table with source insurance names and identifiers from EDI data for reporting.
    writes DimensionMember · reads AccountInsuranceInsuranceMap
  15. Load State Dimensionsqlrevfind_edi_process_loaddimensionmembers__load_state_dimension.sql
    ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
    writes DimensionMember · reads Facility
  16. LoadDimensionMembersLoadDimensionMembers
    Synchronize facility, provider, and insurance metadata into the dimension member table to refresh dashboard filters and reporting categories.
    writes DimensionMember
    load insuranceload quote insuranceload eligibility insuranceload facilityload provider
  17. Load ChargeType DimMergeSql
    writes DimensionMember · reads ChargeType
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  18. Load ProcedureCode DimMergeSql
    writes DimensionMember · reads ChargeType
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  19. Load ProcedureModifier DimMergeSql
    writes DimensionMember · reads AccountChargeProcedureModifier
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  20. Load RevenueCode DimMergeSql
    writes DimensionMember · reads TransformCharge
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock