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

sub-job

EyeSouth · Load-Dimension-Members-General

Loads Dimension Members and Dimension Relations and Entities

called by Daily-Processing

sub-job EyeSouth/Load-Dimension-Members-General · db EyeSouth_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-General

21 tasks · EyeSouth
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 ChargeType Dimensionsqlload_dimension_members_general__load_chargetype_dimension.sql
    ✨ Updates the charge type dimension members by mapping charge codes and display names for use in analytical reporting.
    writes DimensionMember · reads ChargeTypeTransformChargemaster
  2. Load ProcedureCode Dimensionsqlload_dimension_members_general__load_procedurecode_dimension.sql
    ✨ Loads procedure codes into the dimension table and assigns parent categories based on CPT code suffixes.
    writes DimensionMember · reads ChargeType
  3. Load ProcedureCategory Dimensionsqlload_dimension_members_general__load_procedurecategory_dimension.sql
    ✨ Builds the procedure category dimension by extracting unique parent groupings from the existing procedure code dimension members.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load All Diagnosis Dimensions, Load BillingProvider Dimension, Load ChargeType Dimension, Load DenialCategory, Load Facility, Load FacilityGroup, Load Modifier Dimension, Load PlaceOfService Dimension, Load ProcedureCode Dimension, Load Provider Dimension, Load ProviderType, Load State Dimension, Load YesNoBit, LoadDimensionMembers, LoadInsuranceDimensionMembers
  4. Load Insurance Dimensionsqlload_dimension_members_general__load_insurance_dimension.sqldisabled
    ✨ Loads non-scenario insurance entities into the dimension table to support standard insurance-related reporting and filtering.
    writes DimensionMember · reads Insurance
  5. Load QuoteInsurance Dimension?sqlload_dimension_members_general__load_quoteinsurance_dimension.sqldisabled
    ✨ Updates the insurance dimension with all available insurance keys to ensure comprehensive coverage for quote-related data analysis.
    writes DimensionMember · reads Insurance
  6. Load EligibilityInsurance Dimensionsqlload_dimension_members_general__load_eligibilityinsurance_dimension.sqldisabled
    ✨ Loads insurance providers with active benefits API references into a specialized eligibility insurance dimension for verification workflows.
    writes DimensionMember · reads Insurance
  7. Load Provider Dimensionsqlload_dimension_members_general__load_provider_dimension.sql
    ✨ Loads healthcare providers into the dimension table, mapping them to their specific provider types for organizational reporting.
    writes DimensionMember · reads ProviderProviderMap
  8. Load ProviderTypesqlload_dimension_members_general__load_providertype.sql
    ✨ Builds the provider type dimension by identifying and grouping unique provider categories from the existing provider dimension records.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load All Diagnosis Dimensions, Load BillingProvider Dimension, Load ChargeType Dimension, Load DenialCategory, Load Facility, Load FacilityGroup, Load Modifier Dimension, Load PlaceOfService Dimension, Load ProcedureCategory Dimension, Load ProcedureCode Dimension, Load Provider Dimension, Load State Dimension, Load YesNoBit, LoadDimensionMembers, LoadInsuranceDimensionMembers
  9. Load BillingProvider Dimensionsqlload_dimension_members_general__load_billingprovider_dimension.sql
    ✨ Loads billing provider information into the dimension table to facilitate financial reporting and revenue cycle tracking.
    writes DimensionMember · reads ProviderProviderMap
  10. Load Modifier Dimensionsqlload_dimension_members_general__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
  11. Load PlaceOfService Dimensionsqlload_dimension_members_general__load_placeofservice_dimension.sql
    ✨ Builds the Place of Service dimension by mapping codes from account data to standard descriptions.
    writes DimensionMember · reads POSCodesTransformAccount
  12. Load All Diagnosis Dimensionssqlload_dimension_members_general__load_all_diagnosis_dimensions.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 BillingProvider Dimension, Load ChargeType Dimension, Load DenialCategory, Load Facility, Load FacilityGroup, Load Modifier Dimension, Load PlaceOfService Dimension, Load ProcedureCategory Dimension, Load ProcedureCode Dimension, Load Provider Dimension, Load ProviderType, Load State Dimension, Load YesNoBit, LoadDimensionMembers, LoadInsuranceDimensionMembers
  13. Load AllowedStatus Dimensionsqlload_dimension_members_general__load_allowedstatus_dimension.sqldisabled
    ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
    writes DimensionMember
  14. Load YesNoBitsqlload_dimension_members_general__load_yesnobit.sql
    ✨ Loads a boolean dimension for Yes/No status flags using standard bit values and display names.
    writes DimensionMember
  15. Load EncounterStatussqlload_dimension_members_general__load_encounterstatus.sqldisabled
    ✨ Builds the Encounter Status dimension using unique status codes and descriptions from source encounter records.
    writes DimensionMember · reads SourceEncounter
  16. Load DenialCategorysqlload_dimension_members_general__load_denialcategory.sql
    ✨ Loads denial category dimensions from adjustment code rollup data to categorize claim denials.
    writes DimensionMember · reads AdjustmentCodeRollup
  17. Load Facilitysqlload_dimension_members_general__load_facility.sql
    ✨ Loads the Facility dimension, mapping facility keys to their respective names and parent groups.
    writes DimensionMember · reads Facility
  18. Load FacilityGroupsqlload_dimension_members_general__load_facilitygroup.sql
    ✨ Builds the Facility Group dimension by mapping facility group keys to practice names.
    writes DimensionMember · reads FacilityPracticeMap
  19. 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 insurance
  20. LoadDimensionMembersLoadDimensionMembers
    Synchronize facility, provider, and insurance metadata into the dimension member table to refresh dashboard filters and reporting categories.
    writes DimensionMember
    load bill type
  21. Load State Dimensionsqlload_dimension_members_general__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