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

sub-job

JewishBoard · Load-Dimension-Members-RevFind

called by RevFind-Daily-Processing

sub-job JewishBoard/Load-Dimension-Members-RevFind · db JewishBoard_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-RevFind

15 tasks · JewishBoard
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. 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
  2. Load Time Dimensionssqlload_dimension_members_revfind__load_time_dimensions.sql
    ✨ Builds and updates time-based dimension members for days, months, and years within the reporting period.
    writes DimensionMember · reads AccountKeyMap
  3. Load DenialCategory Dimensionsqlload_dimension_members_revfind__load_denialcategory_dimension.sql
    ✨ Loads denial category dimensions from adjustment code rollup data to categorize claim denials.
    writes DimensionMember · reads AdjustmentCodeRollup
  4. Load FacilityGroup Dimensionssqlload_dimension_members_revfind__load_facilitygroup_dimensions.sql
    ✨ Builds the facility group dimension by extracting unique parent identifiers from existing facility records.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load AllowedStatus Dimension, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Source Insurance Dimension, Load Time Dimensions, LoadDimensionMembers
  5. Load FacilityType Dimensionssqlload_dimension_members_revfind__load_facilitytype_dimensions.sql
    ✨ Loads facility type dimension members from facility records to enable standardized categorization across the revenue cycle pipeline.
    writes DimensionMember · reads Facility
  6. Load Practice Dimensionssqlload_dimension_members_revfind__load_practice_dimensions.sqldisabled
    ✨ Loads practice dimension members from the practice map for entities that have associated encounter records.
    writes DimensionMember · reads PracticeMapsourceencounter
  7. Load PlaceOfService Dimensionssqlload_dimension_members_revfind__load_placeofservice_dimensions.sql
    ✨ Builds and updates the place of service dimension by mapping charge data to standardized codes and descriptive names.
    writes DimensionMember · reads POSCodesTransformCharge
  8. Load VisitType Dimensionssqlload_dimension_members_revfind__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
  9. Load AccountStatus Dimensionsqlload_dimension_members_revfind__load_accountstatus_dimension.sqldisabled
    ✨ Builds the account status dimension by extracting unique encounter status values from the source encounter records.
    writes DimensionMember · reads SourceEncounter
  10. Load AllowedStatus Dimensionsqlload_dimension_members_revfind__load_allowedstatus_dimension.sql
    ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
    writes DimensionMember
  11. Load DiagnosisCode Dimensionsqlload_dimension_members_revfind__load_diagnosiscode_dimension.sql
    ✨ Loads diagnosis code dimensions from charge data and assigns them to categories using standardized reference data.
    writes DimensionMember · reads DimensionMemberTransformCharge
    ↳ feeds from Load AllowedStatus Dimension, Load DenialCategory Dimension, Load FacilityGroup Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Source Insurance Dimension, Load Time Dimensions, LoadDimensionMembers
  12. Load Modifier Dimensionsqlload_dimension_members_revfind__load_modifier_dimension.sql
    ✨ Loads and updates procedure modifier dimension members using charge data and standard modifier descriptions.
    writes DimensionMember · reads ProcedureModifierTransformCharge
  13. Load State Dimensionsqlload_dimension_members_revfind__load_state_dimension.sqldisabled
    ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
    writes DimensionMember · reads Facility
  14. Load Source Insurance Dimensionsqlload_dimension_members_revfind__load_source_insurance_dimension.sql
    ✨ Loads and updates source insurance dimension members by mapping insurance IDs and names from the insurance map table.
    writes DimensionMember · reads InsuranceMap
  15. Load ProcedureCode Dimensionsqlload_dimension_members_revfind__load_procedurecode_dimension.sql
    ✨ Builds procedure code dimension members by extracting codes from charge types and joining them with standard procedure descriptions.
    · reads ChargeTypeProcedureCode