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

sub-job

RIA · Load-Dimension-Members

called by Load-Account-Data

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

15 tasks · RIA
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 Insurance Dimensionsqlload_dimension_members__load_insurance_dimension.sqldisabled
    ✨ Populates the insurance dimension with unique carrier keys to enable filtering and analysis by payer.
    writes DimensionMember · reads Insurance
  2. Load EligibilityInsurance Dimensionsqlload_dimension_members__load_eligibilityinsurance_dimension.sqldisabled
    ✨ Loads insurance members that support electronic eligibility and benefits verification via API integration.
    writes DimensionMember · reads DimensionMemberInsurance
  3. Load QuoteInsurance Dimensionsqlload_dimension_members__load_quoteinsurance_dimension.sqldisabled
    ✨ Builds a dimension of insurance providers associated with active contracts to facilitate accurate patient cost estimates.
    writes DimensionMember · reads ContractMapInsurance
  4. 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
  5. Load Time Dimensionssqlload_dimension_members__load_time_dimensions.sql
    ✨ Loads and updates time-based dimension members for days, months, and years into the dimension member table.
    writes DimensionMember · reads TransformVisit
  6. Load VisitStatus Dimensionsqlload_dimension_members__load_visitstatus_dimension.sql
    ✨ Builds the visit status dimension by extracting unique appointment statuses from transformed visit data.
    writes DimensionMember · reads TransformVisit
  7. Load Provider Dimensionsqlload_dimension_members__load_provider_dimension.sql
    ✨ Synchronizes provider details into the dimension member table to enable provider-based filtering and grouping in reports.
    writes DimensionMember · reads Provider
  8. Load Facility Dimensionssqlload_dimension_members__load_facility_dimensions.sql
    ✨ Loads facility and facility group hierarchies into the dimension table to organize location-based data for analysis.
    writes DimensionMember · reads DimensionMemberFacility
    ↳ feeds from Load Diagnosis Code Dimension, Load Modifier Dimension, Load Place of Service Dimension, Load Provider Dimension, Load RadioIsotopes Code Dimension, Load SourceInsurance Dimension, Load State Dimensions, Load Time Dimensions, Load VisitStatus Dimension, Load VisitType Dimensions, LoadInsuranceDimensionMembers
  9. Load VisitType Dimensionssqlload_dimension_members__load_visittype_dimensions.sql
    ✨ Populates the visit type dimension by mapping service IDs and CPT codes from order and crosswalk data.
    writes DimensionMember · reads HL7OrderRIACPTCrosswalk
  10. Load Diagnosis Code Dimensionsqlload_dimension_members__load_diagnosis_code_dimension.sql
    ✨ Loads and updates the DiagnosisCode dimension by extracting unique primary, secondary, and tertiary diagnosis codes from charge data.
    writes DimensionMember · reads TransformCharge
  11. Load RadioIsotopes Code Dimensionsqlload_dimension_members__load_radioisotopes_code_dimension.sql
    ✨ Flags and updates the RadioIsotopes dimension to indicate the presence of radioisotope codes within the source risk data.
    writes DimensionMember · reads SourceCareRiskRadioIsotopeCodes
  12. Load Modifier Dimensionsqlload_dimension_members__load_modifier_dimension.sql
    ✨ Loads and updates the Modifier dimension by collecting unique modifier codes from multiple charge record fields.
    writes DimensionMember · reads TransformCharge
  13. Load Place of Service Dimensionsqlload_dimension_members__load_place_of_service_dimension.sql
    ✨ Builds and updates the PlaceOfService dimension using unique location codes extracted from charge transaction records.
    writes DimensionMember · reads TransformCharge
  14. Load SourceInsurance Dimensionsqlload_dimension_members__load_sourceinsurance_dimension.sql
    ✨ Loads and updates the SourceInsurance dimension with mapped insurance provider details for specific data sources and active accounts.
    writes DimensionMember · reads AccountInsuranceInsuranceMap
  15. Load State Dimensionssqlload_dimension_members__load_state_dimensions.sql
    ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
    writes DimensionMember · reads Facility