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

sub-job

USDH · Load-Dimension-Members

called by Load-Account-Data, Daily-Processing

sub-job USDH/Load-Dimension-Members · db USDH_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-Dimension-Members

16 tasks · USDH
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. LoadInsuranceDimensionMembersLoadInsuranceDimensionMembers
    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 insurance
  2. Load Time Dimensionssqlload_dimension_members__load_time_dimensions.sql
    ✨ Populates the time dimension table with day, month, and year members to support temporal reporting and analysis.
    writes DimensionMember · reads TransformAccount
  3. Load VisitStatus Dimensionsqlload_dimension_members__load_visitstatus_dimension.sqldisabled
    ✨ Loads appointment status values into the visit status dimension to track patient encounter progress.
    writes DimensionMember · reads TransformVisit
  4. Load DenialCategory Dimensionsqlload_dimension_members__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 Dimensionssqlload_dimension_members__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 DenialCategory Dimension, Load DiagnosisCode Dimension, Load Facility + FacilityGroup Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
  6. Load Facility + FacilityGroup Dimensionssqlload_dimension_members__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 DenialCategory Dimension, Load DiagnosisCode Dimension, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Provider + ProviderType Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
  7. Load FacilityType Dimensionssqlload_dimension_members__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 Dimensionssqlload_dimension_members__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 Dimensionssqlload_dimension_members__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 Dimensionssqlload_dimension_members__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 Dimensionsqlload_dimension_members__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 Dimensionsqlload_dimension_members__load_allowedstatus_dimension.sql
    ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
    writes DimensionMember
  13. Load DiagnosisCode Dimensionsqlload_dimension_members__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 DenialCategory Dimension, Load Facility + FacilityGroup Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Provider + ProviderType Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
  14. Load Modifier Dimensionsqlload_dimension_members__load_modifier_dimension.sql
    ✨ Loads the procedure modifier dimension by extracting unique codes from account charges and mapping them to their descriptive labels.
    writes DimensionMember · reads AccountChargeProcedureModifier
  15. Load-Source-Insurance-Dimensionsqlload_dimension_members__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
  16. Load State Dimensionsqlload_dimension_members__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