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

sub-job

SGP · RevFind-Process-QuickSight-Accounts

called by RevFind-Daily-Processing

sub-job SGP/RevFind-Process-QuickSight-Accounts · db SGP_ProdMirror · updated 2026-04-03

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-QuickSight-Accounts

8 tasks · SGP
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. LoadPatientsLoadPatients
    Upsert patient records into the patient dimension.
    · reads PatientTransformPatient
    auto patient query
  2. ReprocessChangedConfigurationsReprocessChangedConfigurations
    Identify and queue visits or accounts affected by configuration changes to ensure historical data reflects updated pricing or insurance rules.
    reprocess accounts
  3. Augment AccountDeltasqlrevfind_process_quicksight_accounts__augment_accountdelta.sql
    ✨ Flags accounts requiring reprocessing by adding them to the change tracking table for downstream updates.
    writes AccountDelta · reads AccountDeltaAccountsToReprocessTransformAccount
  4. Load ChargeMeasuresqlrevfind_process_quicksight_accounts__load_chargemeasure.sql
    ✨ Builds and updates financial metrics for charges, including payments, adjustments, and denials, for accounts with recent activity.
    writes ChargeMeasures · reads AccountDeltaTransformChargeTransformChargeTransactionMeasure
    ↳ feeds from Augment AccountDelta
  5. LoadAccountDataLoadAccountData
    Imports historical billing data from external systems into core account tables while preserving manual user modifications and application fields.
    · reads AccountChargeAccountDeltaChargeMeasuresChargeTypeFacilityInsuranceMapPatientSourceBCBSPrefixMap
    ↳ feeds from Augment AccountDelta, Load ChargeMeasure
    custom account charge querycustom account querycustom account remit querycustom account insurance query
  6. ▶RevFind-Process-Load-Dimension-Memberssub-job · 17↗
    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_load_dimension_members__load_time_dimensions.sql
      ✨ Loads time-based dimensions including days, months, and years into the dimension member table using encounter service dates.
      writes DimensionMember · reads SourceEncounter
    3. Load DenialCategory Dimensionsqlrevfind_process_load_dimension_members__load_denialcategory_dimension.sql
      ✨ Loads denial category dimensions from adjustment code rollup data to categorize claim denials.
      writes DimensionMember · reads AdjustmentCodeRollup
    4. Load Provider Dimensionsqlrevfind_process_load_dimension_members__load_provider_dimension.sql
      ✨ Loads and updates provider dimension members using provider IDs, names, and types from the source provider table.
      writes DimensionMember · reads Provider
    5. Load ProviderType Dimensionsqlrevfind_process_load_dimension_members__load_providertype_dimension.sql
      ✨ Builds the provider type dimension by extracting unique parent categories from existing provider dimension records.
      writes DimensionMember · reads DimensionMember
      ↳ feeds from Load AllowedStatus Dimension, Load DenialCategory Dimension, Load Facility Dimensions, Load FacilityGroup Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Provider Dimension, Load Time Dimensions, LoadInsuranceDimensionMembers
    6. Load Facility Dimensionssqlrevfind_process_load_dimension_members__load_facility_dimensions.sql
      ✨ Updates the facility dimension with unique facility identifiers, state-level parent groupings, and descriptive names.
      writes DimensionMember · reads Facility
    7. Load FacilityGroup Dimensionssqlrevfind_process_load_dimension_members__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 Facility Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Provider Dimension, Load ProviderType Dimension, Load Time Dimensions, LoadInsuranceDimensionMembers
    8. Load FacilityType Dimensionssqlrevfind_process_load_dimension_members__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
    9. Load Practice Dimensionssqlrevfind_process_load_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
    10. Load PlaceOfService Dimensionssqlrevfind_process_load_dimension_members__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
    11. Load VisitType Dimensionssqlrevfind_process_load_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
    12. Load AccountStatus Dimensionsqlrevfind_process_load_dimension_members__load_accountstatus_dimension.sqldisabled
      ✨ Loads account status dimension members by mapping billing status values from patient visit records.
      writes DimensionMember · reads SourcePatientVisits
    13. Load AllowedStatus Dimensionsqlrevfind_process_load_dimension_members__load_allowedstatus_dimension.sql
      ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
      writes DimensionMember
    14. Load DiagnosisCode Dimensionsqlrevfind_process_load_dimension_members__load_diagnosiscode_dimension.sqldisabled
      ✨ Builds the diagnosis code dimension by mapping codes from visit charges to their respective clinical categories.
    15. Load Modifier Dimensionsqlrevfind_process_load_dimension_members__load_modifier_dimension.sql
      ✨ Builds the procedure modifier dimension by identifying unique modifiers used in charge records and applying descriptive labels.
      writes DimensionMember · reads ProcedureModifierTransformCharge
    16. Load Eligibility Service Type Dimensionsqlrevfind_process_load_dimension_members__load_eligibility_service_type_dimension.sqldisabled
      ✨ Loads insurance eligibility service types by mapping procedure codes from account charges to standardized service type descriptions.
      writes DimensionMember · reads AccountChargeCPTServiceTypeMap
    17. Load EligibilityServiceTypesqlrevfind_process_load_dimension_members__load_eligibilityservicetype.sqldisabled
      ✨ Updates eligibility service type dimensions by cross-referencing procedure codes with chargemaster data and standardized service mappings.
      writes DimensionMember · reads CPTServiceTypeMapProcedureCodeSourceChargeMasterSourceProceduresTransformCharge
  7. ▶RevFind-Process-Score-Accountssub-job · 2↗
    1. Delta-Based Account ScoringProcessAccountDataFromQuerydisabled
      · reads AccountDelta
      custom queryDISABLED
    2. Score all qualified accountsBatchProcessAccounts
      writes AccountEstimate · reads QuoteBatchVisitBatch
      min service date=2024-01-01incremental
  8. ▶RevFind-Process-Score-Accounts-Medicaresub-job · 2↗
    1. Delta-Based Account ScoringProcessAccountDataFromQuerydisabled
      · reads AccountDelta
      custom queryDISABLED
    2. Score all qualified accountsBatchProcessAccounts
      writes AccountEstimate · reads QuoteBatchVisitBatch
      min service date=2024-01-01scenario insurance=Medicareincremental