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

sub-job

StrideCare · RevFind-Process-LoadDimensionMembers

called by RevFind-Process-LoadAccount

sub-job StrideCare/RevFind-Process-LoadDimensionMembers · db StrideCare_ProdMirror · updated 2026-04-21

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

13 tasks · StrideCare
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 Dimensionssqlrevfind_process_loaddimensionmembers__load_time_dimensions.sql
    ✨ Builds time dimension members for days, months, and years based on account service dates to enable temporal reporting.
    writes DimensionMember · reads TransformAccount
  3. Load Provider Dimensionsqlrevfind_process_loaddimensionmembers__load_provider_dimension.sql
    ✨ Builds and updates the Provider and ProviderType dimensions, managing hierarchical relationships and identifying archived records.
    writes DimensionMember · reads DimensionMemberProvider
    ↳ feeds from Load AllowedStatus Dimensions, Load BilledToInsurance Dimensions, Load DenialCategory Dimensions, Load DiagnosisCode Dimension, Load Facility Dimensions, Load FacilityGroup Dimension, Load FacilityType Dimension, Load PlaceOfService Dimension, Load State Dimensions, Load Time Dimensions, LoadInsuranceDimensionMembers
  4. Load Facility Dimensionssqlrevfind_process_loaddimensionmembers__load_facility_dimensions.sql
    ✨ Builds and updates the Facility dimension by mapping source departments to specific facility groups and parent entities.
    writes DimensionMember · reads FacilitySourceDepartment_33143
  5. Load FacilityGroup Dimensionsqlrevfind_process_loaddimensionmembers__load_facilitygroup_dimension.sql
    ✨ Builds the FacilityGroup dimension by extracting unique parent entities from the existing Facility dimension members.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load AllowedStatus Dimensions, Load BilledToInsurance Dimensions, Load DenialCategory Dimensions, Load DiagnosisCode Dimension, Load Facility Dimensions, Load FacilityType Dimension, Load PlaceOfService Dimension, Load Provider Dimension, Load State Dimensions, Load Time Dimensions, LoadInsuranceDimensionMembers
  6. Load FacilityType Dimensionsqlrevfind_process_loaddimensionmembers__load_facilitytype_dimension.sql
    ✨ Loads facility type dimension members from facility records to enable standardized categorization across the revenue cycle pipeline.
    writes DimensionMember · reads Facility
  7. Load SourceInsurance Dimensionssqlrevfind_process_loaddimensionmembers__load_sourceinsurance_dimensions.sql
    ✨ Builds and updates the SourceInsurance dimension using mapped insurance data for active accounts from the source system.
  8. Load PlaceOfService Dimensionsqlrevfind_process_loaddimensionmembers__load_placeofservice_dimension.sql
    ✨ Loads place of service dimension members from transformed charge data to categorize where healthcare services were provided.
    writes DimensionMember · reads TransformCharge
  9. Load DiagnosisCode Dimensionsqlrevfind_process_loaddimensionmembers__load_diagnosiscode_dimension.sql
    ✨ Loads unique diagnosis codes from charge records into the dimension member table to support standardized clinical reporting.
    writes DimensionMember · reads TransformCharge
  10. Load State Dimensionssqlrevfind_process_loaddimensionmembers__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
  11. Load BilledToInsurance Dimensionssqlrevfind_process_loaddimensionmembers__load_billedtoinsurance_dimensions.sql
    ✨ Builds and updates the BilledToInsurance dimension using unique insurance identifiers and names from the source insurance map.
    writes DimensionMember · reads SourceInsuranceMap
  12. Load DenialCategory Dimensionssqlrevfind_process_loaddimensionmembers__load_denialcategory_dimensions.sql
    ✨ Loads denial category dimensions from adjustment code rollup data to categorize claim denials.
    writes DimensionMember · reads AdjustmentCodeRollup
  13. Load AllowedStatus Dimensionssqlrevfind_process_loaddimensionmembers__load_allowedstatus_dimensions.sql
    ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
    writes DimensionMember