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

sub-job

OneGI · RevFind-Process-DimensionMembers

Loads all dimensions used for filtering and reporting

called by RevFind-Daily-Processing-ModMed, RevFind-Process-Accounts, RevFind-Daily-Processing

sub-job OneGI/RevFind-Process-DimensionMembers · db OneGI_ProdMirror · updated 2026-02-12

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-DimensionMembers

10 tasks · OneGI
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 Dimension MembersLoadDimensionMembers
    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 providerload bill type
  2. Merge DenialCategory DimensionMergeSql
    writes DimensionMember · reads AdjustmentCodeRollup
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  3. Merge Place Of Service DimensionMergeSql
    writes DimensionMember · reads SourceECWEdiInvoiceSourceECWFacilities
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  4. Merge Allowed Status DimensionMergeSql
    writes DimensionMember
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  5. Merge Diagnosis Code DimensionMergeSql
    writes DimensionMember · reads DimensionMemberSourceECWEdiInvDiagnosis
    ↳ feeds from Load Dimension Members, Merge Allowed Status Dimension, Merge DenialCategory Dimension, Merge Facility Dimension, Merge Facility Group Dimension, Merge Facility Type Dimension, Merge Modifier Dimension, Merge Place Of Service Dimension, Merge ProviderType Dimension
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  6. Merge Modifier DimensionMergeSql
    writes DimensionMember · reads ProcedureModifierTransformCharge
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  7. Merge Facility Group DimensionMergeSql
    writes DimensionMember · reads FacilitySourceFacilityGroupToTIN
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  8. Merge Facility DimensionMergeSql
    writes DimensionMember · reads Facility
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  9. Merge Facility Type DimensionMergeSql
    writes DimensionMember · reads Facility
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  10. Merge ProviderType DimensionMergeSql
    writes DimensionMember · reads Provider
    merge data source type=ThisDatabasetable name=DimensionMembermerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock