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

Batch / file feed · RevFind pipeline

SGP · RevFind-Daily-Processing

Daily RevFind Processing main job. Added 'RevFind-Process-Load-ChargeType' as step 4 as this previously wasn't being run at all - CW [date] Moved 'Revfind-Source-LoadDataFile' to 'Cutover-Revfind-Source-LoadDataFile'. the old job is disabled above it - SF [date]

pipeline SGP/RevFind-Daily-Processing · db SGP_ProdMirror · updated 2026-06-16
classification: revfind · loads 1 visit table

Loads visit tables
Besides its back-office work, this RevFind pipeline also loads a visit dimension/fact table (Load VisitType Dimensions) — the shared rows Flow builds on. It runs no front-of-house work (no eligibility, estimate, or letters), so it stays RevFind.

trigger

How it's scheduled

Daily batch — once at 01:00

The Batch / file feed arrives as a scheduled drop, so one overnight pass is enough: it ingests the day's file and works the whole batch to process the visits. A tighter loop would just re-scan the same file.

Scheduled taskCadenceServerStateCoordination
\MDC\Daily - Processing - SGPdaily at 01:00prod-db-1enabledstandalone

shape

The RevFind back-office spine

RevFind pipelines share a back-office shape: ingest → load accounts → reconcile remits → model contracts → surface underpayments. Lit stages are the ones this pipeline runs.

Ingest
Batch / file feed
→
Accounts / AR
ACCT
→
Remit (835)
→
Contract model
CTR
→
Payer rules
→
Work queue & sync

computed concepts · from the SQL

What it computes

Business concepts mined from this pipeline's SQL text — the meaning behind the typed steps. Each links to the concept lens (who else computes it).

BundlesExpected reimbursementDenial / underpaymentCPT / procedure logic

Payers in SQLMedicare

task tree

What the pipeline 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).

revfind

RevFind-Daily-Processing

10 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. ▶RevFind-Source-Import-QuickSightsub-job · 14↗
    1. Download QuickSite FilesDownloaddisabled
      Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
      server=SGP_ProdMirror-mdcssh-sftpremote directory=/local directory={SourceDataFolder}DISABLED
    2. S3DownloadS3Download
      command=powershell.exe
    3. Patient Encounter Ins File CleanupExecuteProcess
      command=powershell.exe
    4. Encounter File CleanupExecuteProcess
      command=powershell.exe
    5. Load ChargeMasterProcessFile
      writes ImportChargemasterSourceChargemaster
      file path={SourceDataFolder}\chargemaster_data000archive directory={SourceDataArchive}base table name=Chargemasterrow terminator=Linefeedcolumn separator=Comma
    6. Load EncountersProcessFile
      writes ImportEncounterSourceEncounter
      file path={SourceDataFolder}\encounter_data000archive directory={SourceDataArchive}base table name=Encounterrow terminator=Newlinecolumn separator=Comma
    7. Load PatientEncounterInsuranceProcessFile
      writes ImportPatientEncounterInsuranceSourcePatientEncounterInsurance
      archive directory={SourceDataArchive}base table name=PatientEncounterInsurancerow terminator=Newlinecolumn separator=Comma
    8. Load PatientProcessFile
      writes ImportPatientSourcePatient
      file path={SourceDataFolder}\patient_data000archive directory={SourceDataArchive}base table name=Patientrow terminator=Linefeedcolumn separator=Comma
    9. Load ProviderProcessFile
      writes ImportProviderSourceProvider
      file path={SourceDataFolder}\provider_data000archive directory={SourceDataArchive}base table name=Providerrow terminator=Linefeedcolumn separator=Comma
    10. Load LocationProcessFile
      writes ImportLocationSourceLocation
      file path={SourceDataFolder}\location_data000archive directory={SourceDataArchive}base table name=Locationrow terminator=Linefeedcolumn separator=Comma
    11. Load ChargeProcessFile
      writes ImportChargeSourceCharge
      file path={SourceDataFolder}\charges000archive directory={SourceDataArchive}base table name=Chargerow terminator=Linefeedcolumn separator=Comma
    12. Load TransactionProcessFile
      writes ImportTransactionSourceTransaction
      file path={SourceDataFolder}\payments_adj000archive directory={SourceDataArchive}base table name=Transactionrow terminator=Linefeedcolumn separator=Comma
    13. Load InsuranceProcessFile
      writes ImportInsuranceSourceInsurance
      file path={SourceDataFolder}\insurance__data000archive directory={SourceDataArchive}base table name=Insurancerow terminator=Linefeedcolumn separator=Comma
    14. Load Patient Encounter Insurance ExceptionsProcessFiledisabled
      writes ImportPatientEncounterInsuranceExceptionsSourcePatientEncounterInsuranceExceptions
      archive directory={SourceDataArchive}base table name=PatientEncounterInsuranceExceptionsrow terminator=Newlinecolumn separator=CommaDISABLED
  2. ▶RevFind-Source-LoadDataFilesub-job · 16↗
    1. S3DownloadS3Download
      command=powershell.exe
    2. Patient Encounter Ins File CleanupExecuteProcess
      command=powershell.exe
    3. Encounter File CleanupExecuteProcess
      command=powershell.exe
    4. Patient File CleanupExecuteProcess
      command=powershell.exe
    5. LoadDataFile-ChargeMasterLoadDataFile-ChargeMaster
      writes ChargemasterFile
      data file spec=ChargemasterFilefile path={SourceDataFolder}\chargemaster_data000import mode=Refillarchive file path={SourceDataArchive}
    6. LoadDataFile-EncountersLoadDataFile-Encounters
      writes EncounterFile
      data file spec=EncounterFilefile path={SourceDataFolder}\encounter_data000import mode=Refillarchive file path={SourceDataArchive}
    7. LoadDataFile-PatientEncounterInsuranceLoadDataFile-PatientEncounterInsurancedisabled
      writes PatientEncounterInsuranceFile
      data file spec=PatientEncounterInsuranceFileimport mode=Refillarchive file path={SourceDataArchive}DISABLED
    8. Load PatientEncounterInsuranceProcessFile
      writes ImportPatientEncounterInsuranceSourcePatientEncounterInsurance
      archive directory={SourceDataArchive}base table name=PatientEncounterInsurancerow terminator=Newlinecolumn separator=Comma
    9. LoadDataFile-PatientLoadDataFile-Patient
      writes PatientFile
      data file spec=PatientFilefile path={SourceDataFolder}\patient_data000import mode=Refillarchive file path={SourceDataArchive}
    10. LoadDataFile-ProviderLoadDataFile-Provider
      writes ProviderFile
      data file spec=ProviderFilefile path={SourceDataFolder}\provider_data000import mode=Refillarchive file path={SourceDataArchive}
    11. LoadDataFile-LocationLoadDataFile-Location
      writes LocationFile
      data file spec=LocationFilefile path={SourceDataFolder}\location_data000import mode=Refillarchive file path={SourceDataArchive}
    12. LoadDataFile-ChargeLoadDataFile-Chargedisabled
      writes ChargeFile
      data file spec=ChargeFilefile path={SourceDataFolder}\charges000import mode=Refillarchive file path={SourceDataArchive}DISABLED
    13. Load ChargeProcessFile
      writes ImportChargeSourceCharge
      file path={SourceDataFolder}\charges000archive directory={SourceDataArchive}base table name=Chargerow terminator=Linefeedcolumn separator=Comma
    14. LoadDataFile-TransactionLoadDataFile-Transaction
      writes TransactionFile
      data file spec=TransactionFilefile path={SourceDataFolder}\payments_adj000import mode=Refillarchive file path={SourceDataArchive}
    15. LoadDataFile-InsuranceLoadDataFile-Insurance
      writes InsuranceFile
      data file spec=InsuranceFilefile path={SourceDataFolder}\insurance__data000import mode=Refillarchive file path={SourceDataArchive}
    16. LoadDataFile-InsuranceExceptionsLoadDataFile-InsuranceExceptionsdisabled
      writes PatientEncounterInsuranceExceptionsFile
      data file spec=PatientEncounterInsuranceExceptionsFileimport mode=Refillarchive file path={SourceDataArchive}DISABLED
  3. Cutover-Revfind-Source-LoadDataFilesub-job
  4. ▶RevFind-Source-MergeImportToSourcesub-job · 12↗
    1. Merge ChargeMasterMergeSql
      writes SourceChargemaster · reads ImportChargemaster
      merge data source type=ThisDatabasetable name=SourceChargemastermerge mode=InsertUpdateSoftDeletebulk copy timeout seconds=300bulk copy use table lock
    2. TEMPORARY Fix for Dupe Encounterssqlrevfind_source_mergeimporttosource__temporary_fix_for_dupe_encounters.sql
      ✨ Removes duplicate encounter records from the import table to ensure data integrity before merging into source tables.
      writes cte · reads ImportEncounter
    3. Merge EncountersMergeSql
      writes SourceEncounter · reads ImportEncounter
      merge data source type=ThisDatabasetable name=SourceEncountermerge mode=InsertUpdateSoftDeletebulk copy timeout seconds=300bulk copy use table lock
    4. Merge PatientEncounterInsuranceMergeSqldisabled
      writes SourcePatientEncounterInsurance · reads ImportPatientEncounterInsurance
      merge data source type=ThisDatabasetable name=SourcePatientEncounterInsurancemerge mode=InsertUpdateHardDeletebulk copy timeout seconds=300bulk copy use table lock
    5. Merge PatientMergeSql
      writes SourcePatient · reads ImportPatient
      merge data source type=ThisDatabasetable name=SourcePatientmerge mode=InsertUpdateSoftDeletebulk copy timeout seconds=300bulk copy use table lock
    6. Merge ProviderMergeSql
      writes SourceProvider · reads ImportProvider
      merge data source type=ThisDatabasetable name=SourceProvidermerge mode=InsertUpdateSoftDeletebulk copy timeout seconds=300bulk copy use table lock
    7. Merge LocationMergeSql
      writes SourceLocation · reads ImportLocation
      merge data source type=ThisDatabasetable name=SourceLocationmerge mode=InsertUpdateSoftDeletebulk copy timeout seconds=300bulk copy use table lock
    8. Merge ChargeMergeSql
      writes SourceCharge · reads ImportCharge
      merge data source type=ThisDatabasetable name=SourceChargemerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
    9. TEMPORARY Fix for dupe Txnssqlrevfind_source_mergeimporttosource__temporary_fix_for_dupe_txns.sql
      ✨ Removes duplicate transaction records from the import table based on matching IDs, amounts, and dates.
      writes CTE · reads ImportTransaction
    10. Merge TransactionMergeSql
      writes SourceTransaction · reads ImportTransaction
      merge data source type=ThisDatabasetable name=SourceTransactionmerge mode=InsertUpdateSoftDeletebulk copy timeout seconds=300bulk copy use table lock
    11. Merge InsuranceMergeSql
      writes SourceInsurance · reads ImportInsurance
      merge data source type=ThisDatabasetable name=SourceInsurancemerge mode=InsertUpdateSoftDeletebulk copy timeout seconds=300bulk copy use table lock
    12. Check Deleted Flag on Transactionssqlrevfind_source_mergeimporttosource__check_deleted_flag_on_transactions.sql
      ✨ Resets the deletion flag for transactions that have been updated or re-imported after being previously marked as deleted.
      · reads SourceTransaction
      ↳ feeds from Merge Transaction
  5. ▶RevFind-Process-Load-ChargeTypesub-job · 5↗
    1. Load ChargeTypesqlrevfind_process_load_chargetype__load_chargetype.sql
      ✨ Builds the charge type table by categorizing procedure codes into professional or facility bill types based on encounter data.
      writes ChargeType · reads ProcedureCodeSourceChargeSourceEncounter
    2. Load ChargeType Dimensionsqlrevfind_process_load_chargetype__load_chargetype_dimension.sql
      ✨ Loads charge type members into the dimension table to support hierarchical reporting and data categorization.
      writes DimensionMember · reads ChargeType
      ↳ feeds from Load ChargeType
    3. Load ProcedureCode Dimensionsqlrevfind_process_load_chargetype__load_procedurecode_dimension.sql
      ✨ Loads procedure code dimension members by mapping charge types to their respective descriptions and CPT categories.
      writes DimensionMember · reads ChargeTypeProcedureCode
      ↳ feeds from Load ChargeType
    4. Load ProcedureCategory Dimensionsqlrevfind_process_load_chargetype__load_procedurecategory_dimension.sql
      ✨ Builds the procedure category dimension by extracting parent categories from existing procedure code records.
      writes DimensionMember · reads DimensionMember
      ↳ feeds from Load ChargeType Dimension, Load ProcedureCode Dimension
    5. Load Modifiers Dimensionsqlrevfind_process_load_chargetype__load_modifiers_dimension.sqldisabled
      ✨ Loads unique billing modifiers from transformed charge records into the dimension member table.
      writes DimensionMember · reads TransformCharge
  6. ▶RevFind-Transform-QuickSight-Account-Transformsub-job · 14↗
    1. Create AccountKeyMapsqlrevfind_transform_quicksight_account_transform__create_accountkeymap.sql
      ✨ Builds a mapping table to link source account identifiers with internal unique keys for consistent cross-system tracking.
      writes AccountKeyMap · reads AccountKeyMapSourceEncounter
    2. Create AccountDeltasqlrevfind_transform_quicksight_account_transform__create_accountdelta.sql
      ✨ Identifies and loads account IDs that have changed or been deleted since the last pipeline execution into a delta table.
      writes AccountDelta · reads AccountKeyMapProcessLogSourceChargeSourceEncounterSourceTransaction
      ↳ feeds from Create AccountKeyMap
    3. Load AccountDeltaLogsqlrevfind_transform_quicksight_account_transform__load_accountdeltalog.sql
      ✨ Records the total number of changed accounts processed in the current batch for auditing and monitoring purposes.
      writes AccountDeltaLog · reads AccountDelta
      ↳ feeds from Create AccountDelta
    4. Load TransformPatientsqlrevfind_transform_quicksight_account_transform__load_transformpatient.sql
      ✨ Builds and updates the patient transformation table by merging demographic data and generating unique identifiers from source systems.
      writes TransformPatient · reads SourcePatient
    5. Load TransformLocationsqlrevfind_transform_quicksight_account_transform__load_transformlocation.sql
      ✨ Builds and updates the location transformation table by mapping facility addresses and zip codes to standardized state codes.
      writes TransformLocation · reads CMSZipMapSourceLocation
    6. Load TransformProvidersqlrevfind_transform_quicksight_account_transform__load_transformprovider.sql
      ✨ Builds and updates the provider transformation table by parsing names and mapping National Provider Identifiers from source systems.
      writes TransformProvider · reads SourceProvider
    7. Load TransformPayersqlrevfind_transform_quicksight_account_transform__load_transformpayer.sql
      ✨ Builds and updates the payer transformation table by consolidating insurance carrier names and generating unique payer identifiers.
      writes TransformPayer · reads SourceInsurance
    8. Load TransformChargesqlrevfind_transform_quicksight_account_transform__load_transformcharge.sql
      ✨ Loads charge-level details into the transformation table, calculating service units, amounts, and bill types for updated accounts.
      writes TransformCharge · reads AccountDeltaAccountKeyMapSourceChargeSourceEncounterSourceLocation
      ↳ feeds from Create AccountDelta, Create AccountKeyMap
    9. Load TransformAccountInsurancesqlrevfind_transform_quicksight_account_transform__load_transformaccountinsurance.sql
      ✨ Updates account insurance records by determining the coordination of benefits order and mapping member policy information for active coverage.
      writes TransformAccountInsurance · reads AccountDeltaAccountKeyMapSourceEncounterSourcePatientEncounterInsuranceSourcePatientEncounterInsuranceExceptions
      ↳ feeds from Create AccountDelta, Create AccountKeyMap
    10. Load TransformTransactionsqlrevfind_transform_quicksight_account_transform__load_transformtransaction.sql
      ✨ Loads and categorizes financial transactions into payments, adjustments, or denials based on source codes and coordination of benefits.
      writes TransformTransaction · reads AccountDeltaAccountKeyMapAdjustmentCodeRollupSourceEncounterSourceTransactionTransformAccountInsurance
      ↳ feeds from Create AccountDelta, Create AccountKeyMap, Load TransformAccountInsurance
    11. Load TransformAccountsqlrevfind_transform_quicksight_account_transform__load_transformaccount.sql
      ✨ Builds the account transformation table by aggregating charge balances and linking encounters to providers, facilities, and primary insurance.
      writes TransformAccount · reads AccountDeltaAccountKeyMapSourceEncounterSourceLocationTransformCharge
      ↳ feeds from Create AccountDelta, Create AccountKeyMap, Load TransformCharge
    12. Merge TransformTransactionMergeSqldisabled
      writes TransformTransaction · reads AdjustmentCodeRollupImportTransactionSourceEncounterTransformAccountInsurance
      merge data source type=ThisDatabasetable name=TransformTransactionmerge mode=InsertUpdateHardDeletebulk copy timeout seconds=300bulk copy use table lock
    13. Update Deltasqlrevfind_transform_quicksight_account_transform__update_delta.sqldisabled
      ✨ Identifies and records account IDs with recent transaction updates to track incremental changes for downstream processing.
      writes AccountDelta · reads AccountDeltaProcessLogTransformTransaction
    14. Load TransformChargeTransactionMeasuresqlrevfind_transform_quicksight_account_transform__load_transformchargetransactionmeasure.sql
      ✨ Calculates and updates aggregated financial metrics, including payments, adjustments, and denials, for accounts identified in the delta tracking table.
      writes TransformChargeTransactionMeasure · reads AccountDeltaAccountKeyMapAdjustmentCodeRollupSourceChargeTransformChargeTransformTransaction
      ↳ feeds from Create AccountDelta, Create AccountKeyMap, Load TransformCharge, Load TransformTransaction
  7. ▶RevFind-Transform-Load-Entitiessub-job · 3↗
    1. Load Providersqlrevfind_transform_load_entities__load_provider.sql
      ✨ Updates and inserts provider records by merging source data with national provider identifiers and taxonomy classifications.
      writes Provider · reads NPIDataProviderTaxonomySourceProviderTransformCharge
    2. Load FacilityLoadEntities
      writes Facility · reads FacilitySourceLocationTransformLocation
      entity type=Facilitycustom querykey prefix=F
    3. Load InsuranceMapLoadEntities
      writes InsuranceMap · reads InsuranceMapSourceInsurance
      entity type=InsuranceMapcustom querykey prefix=IM
  8. ▶RevFind-Process-QuickSight-Accountssub-job · 8↗
    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
  9. Load recovery reportsqlrevfind_daily_processing__load_recovery_report.sql
    ✨ Builds a temporary report summarizing recovered amounts, appeal statuses, and payment details for patient accounts and charges.
    writes TempChargeRecoveryReport · reads AccountAccountAppealStatusAccountAppealSummaryAccountChargeAccountEstimateChargeChargeTypeFacilityPatient
  10. ProcessScenarioModelProcessScenarioModel
    Calculates account estimates for queued scenario models to perform what-if analysis for contract modeling and pricing.