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

Batch / file feed · RevFind pipeline

USDH · Daily-Processing

pipeline USDH/Daily-Processing · db USDH_ProdMirror · updated 2025-09-17
classification: revfind · loads 2 visit tables

Loads visit tables
Besides its back-office work, this RevFind pipeline also loads a visit dimension/fact table (Load VisitStatus Dimension, 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 03:30

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 - USDHdaily at 03:30prod-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)
835
→
Contract model
→
Payer rules
PAYR
→
Work queue & sync
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).

Good-faith estimateExpected reimbursementDenial / underpaymentCPT / procedure logic

Payers in SQLMedicaidMedicare

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

Daily-Processing

6 tasks · USDH
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. ▶Process-EDIsub-job · 3↗
    1. Download Files from SFTPDownload
      Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
      server=USDH_ProdMirror-mdcssh-sftpremote directory=/local directory={SourceDataFolder}
    2. ▶Load-Edi-Filessub-job · 1↗
      1. ▶Load-Edi-Filesub-job · 3↗
        1. Bulk Insert File Into Databasesqlload_edi_file__bulk_insert_file_into_database.sqldisabled
          ✨ Loads raw EDI files into staging and identifies transaction types and subtypes based on file naming conventions.
          writes EDIFileStaging · reads SINGLE_CLOB
        2. Upload File to EDIFileStaging tableExecuteProcess
          command=powershell.exe
        3. Archive FilesExecuteProcess
          command=cmd.exe
    3. ▶TransformAndParseEDIsub-job · 5↗
      1. EDITransformsqltransformandparseedi__editransform.sql
        ✨ Loads unique EDI messages from staging into the transformation table while preventing duplicate records.
        writes EDITransform · reads EDIFileStagingEDITransform
      2. EDIBatchsqltransformandparseedi__edibatch.sql
        ✨ Builds a batch of unprocessed EDI messages, excluding empty records, for subsequent parsing and transformation.
        writes EDIBatch
      3. Clean Messages in EDIBatchsqltransformandparseedi__clean_messages_in_edibatch.sql
        ✨ Updates EDI batch messages by replacing specific formatting characters to ensure compatibility with parsing logic after vendor formatting changes.
        · reads EDIBatch
        ↳ feeds from EDIBatch, EDIParser
      4. EDIParserEDIParser
        writes EDIBatch
        table name=EDIBatch
      5. ▶Load-EDI-Metadatasub-job · 3↗
        1. Load EDIFacilityMapsqlload_edi_metadata__load_edifacilitymap.sql
          ✨ Loads the facility map with unique billing and service facility details extracted from electronic claim transactions.
          writes EDIFacilityMap · reads EDIFacilityMapTxn837P
        2. Load EDIProviderMapsqlload_edi_metadata__load_ediprovidermap.sql
          ✨ Builds the provider map by combining rendering provider information from claim transactions with national provider registry data.
          writes EDIProviderMap · reads EDIProviderMapNPIDataTxn837P
        3. Load EDIPayerMapsqlload_edi_metadata__load_edipayermap.sql
          ✨ Builds a master payer mapping table by consolidating payer names and identifiers from remittance and claim transaction records.
          writes EDIPayerMap · reads TransformRemitTxn837P
  2. ▶Load-Entitiessub-job · 2↗Load Facility, Provider
    1. Load FacilityLoadEntities
      writes Facility · reads EDIFacilityMapFacility
      entity type=Facilitycustom querykey prefix=F
    2. Load Providersqlload_entities__load_provider.sql
      ✨ Updates the provider master table with names, NPIs, and taxonomy classifications derived from provider mapping and reference data.
      writes Provider · reads EDIProviderMapProviderTaxonomy
  3. ▶Load-Transform-RemitDatasub-job · 18↗
    1. Load TransformRemitsqlload_transform_remitdata__load_transformremit.sql
      ✨ Standardizes remittance claim data by mapping filing indicators and calculating sequence ordinals for payment tracking.
      writes TransformRemit · reads Txn835Txn835ClaimPaymentTxn835ClaimPaymentLineTxn835ClaimPaymentOtherClaimAmount
    2. Load TempRemitCOBsqlload_transform_remitdata__load_tempremitcob.sql
      ✨ Calculates and updates the coordination of benefits sequence and claim ranking for remittance records.
      writes TempRemitCOBTransformRemit · reads TempRemitCOB
    3. Load TransformRemitAdjustmentsqlload_transform_remitdata__load_transformremitadjustment.sql
      ✨ Loads claim and line-level adjustments by unpivoting reason codes and amounts from electronic remittance advice transactions.
      writes TransformRemitAdjustment · reads TransformRemitTxn835ClaimAdjustment
      ↳ feeds from Load TempRemitCOB, Load TransformRemit
    4. Load TransformRemitLinesqlload_transform_remitdata__load_transformremitline.sql
      ✨ Builds standardized remittance line items by processing service dates, procedure codes, and unique charge matching identifiers.
      writes TransformRemitLine · reads TransformRemitTxn835ClaimPaymentLine
      ↳ feeds from Load TempRemitCOB, Load TransformRemit
    5. Load TransformRemitAdjustmentAggregatesqlload_transform_remitdata__load_transformremitadjustmentaggregate.sql
      ✨ Aggregates claim adjustments to identify and categorize initial and current denials based on standardized reason code rollups.
      writes TransformRemitAdjustmentAggregate · reads AdjustmentCodeRollupTransformRemitTransformRemitAdjustmentTransformRemitLine
      ↳ feeds from Load TempRemitCOB, Load TransformRemit, Load TransformRemitAdjustment, Load TransformRemitLine
    6. Load TransformChargeTransactionMeasuresqlload_transform_remitdata__load_transformchargetransactionmeasure.sql
      ✨ Aggregates financial metrics and denial categories at the charge level to support transaction measurement and reporting.
      writes TransformChargeTransactionMeasure · reads TransformRemitTransformRemitAdjustmentAggregateTransformRemitLine
      ↳ feeds from Load TempRemitCOB, Load TransformRemit, Load TransformRemitAdjustmentAggregate, Load TransformRemitLine
    7. Load TransformTxn837sqlload_transform_remitdata__load_transformtxn837.sql
      ✨ Loads and transforms outbound claim header data, determining bill types and mapping patient, subscriber, and provider information.
      writes TransformTxn837 · reads Txn837PTxn837PServiceLine
    8. Load TransformTxn837Linesqlload_transform_remitdata__load_transformtxn837line.sql
      ✨ Loads transformed service line details for outbound claims, including procedure codes, modifiers, and rendering provider information.
      writes TransformTxn837Line · reads TransformTxn837Txn837PServiceLine
      ↳ feeds from Load TransformTxn837
    9. Load TransformAccountsqlload_transform_remitdata__load_transformaccount.sql
      ✨ Builds a unified account view by consolidating encounter, provider, and multi-payer insurance information from claim transactions.
      writes TransformAccount · reads EDIFacilityMapTransformTxn837
      ↳ feeds from Load TransformTxn837
    10. Load TransformChargesqlload_transform_remitdata__load_transformcharge.sql
      ✨ Loads detailed service line charges by mapping procedure codes, modifiers, and units while generating unique keys for charge matching.
      writes TransformCharge · reads TransformAccountTransformTxn837TransformTxn837Line
      ↳ feeds from Load TransformAccount, Load TransformTxn837, Load TransformTxn837Line
    11. Merge TransformPatientsqlload_transform_remitdata__merge_transformpatient.sql
      ✨ Updates or inserts patient demographic records using the most recent contact and identity information found in claim transaction data.
      writes TransformPatient · reads TransformTxn837
      ↳ feeds from Load TransformTxn837
    12. Load TempTransactions (for RevFind Recovery)sqlload_transform_remitdata__load_temptransactions_for_revfind_recovery.sql
      ✨ Builds a temporary table of payment and adjustment transactions by combining remittance line and adjustment data for recovery analysis.
      writes TempTransactions · reads TempTransactions
    13. Load TempTransactionsAgg (for RevFind Recovery)sqlload_transform_remitdata__load_temptransactionsagg_for_revfind_recovery.sql
      ✨ Aggregates transaction data into a temporary table, calculating sums for payments, contracts, patient responsibility, and denials at the claim level.
      writes TempTransactionsAgg
    14. Load TempTransactionsAggTotal (for RevFind Recovery)sqlload_transform_remitdata__load_temptransactionsaggtotal_for_revfind_recovery.sql
      ✨ Summarizes aggregated transaction data to provide total amounts and initial versus current denial categories for each claim and charge match.
      writes TempTransactionsAggTotal
    15. Load TempTransactionsAggTotalFinal (for RevFind Recovery)sqlload_transform_remitdata__load_temptransactionsaggtotalfinal_for_revfind_recovery.sqldisabled
      ✨ Produces the final consolidated summary of financial metrics, including total paid, denied, and adjusted amounts for each claim line.
      writes TempTransactionsAggTotalFinal
    16. Update TransformChargeTransactionMeasure (for RevFind Recovery)sqlload_transform_remitdata__update_transformchargetransactionmeasure_for_revfind_recovery.sqldisabled
      ✨ Updates the charge transaction measurement table with final calculated payment, patient responsibility, and contract adjustment totals for recovery tracking.
      · reads TempTransactionsAggTotalFinalTransformChargeTransactionMeasuret
    17. Append PatientID on TransformAccountsqlload_transform_remitdata__append_patientid_on_transformaccount.sql
      ✨ Updates account records with patient identifiers by matching claim transaction details against existing patient mapping data.
      · reads TransformAccountTransformPatientTransformTxn837ta
      ↳ feeds from Append TransformPatient, Second Append of PatientID to TransformAccount, Load TransformAccount, Load TransformTxn837, Merge TransformPatient
    18. Append TransformPatient, Second Append of PatientID to TransformAccountsqlload_transform_remitdata__append_transformpatient_second_append_of_patientid_to_transformaccount.sql
      ✨ Updates the patient master list and assigns patient identifiers to accounts using encounter and practice information.
      writes TempTransformPatientTransformPatient · reads TempTransformPatientTransformAccountta
      ↳ feeds from Load TransformAccount
  4. ▶Load-InsuranceMapsub-job · 1↗
    1. LoadEntitiesFromQueryLoadEntitiesFromQuery
      Load or update entity records from custom SQL query results into their corresponding system tables using intelligent merge logic.
      writes InsuranceMap · reads EDIPayerMapInsuranceMap
      entity type=InsuranceMapauto querykey prefix=IM
  5. ▶Load-Account-Datasub-job · 10↗Load Account-Level Tables
    1. ReprocessChangedConfigurationsReprocessChangedConfigurationsdisabled
      Identify and queue visits or accounts affected by configuration changes to ensure historical data reflects updated pricing or insurance rules.
      reprocess accountsDISABLED
    2. LoadPatientsLoadPatients
      Upsert patient records into the patient dimension.
      · reads PatientTransformPatient
      custom patient query
    3. Load ChargeMeasuressqlload_account_data__load_chargemeasures.sql
      ✨ Aggregates financial metrics including paid, adjusted, and denied amounts at the charge level to support recovery insights and reporting.
      writes ChargeMeasures · reads ChargeMeasuresTempTransactionsAggTotalTransformAccountTransformCharge
    4. LoadAccountDataLoadAccountData
      Imports historical billing data from external systems into core account tables while preserving manual user modifications and application fields.
      · reads AccountChargeAdjustmentCodeRollupChargeMeasuresChargeTypeInsuranceMapPatientProviderTempTransactions
      ↳ feeds from Load ChargeMeasures
      custom account charge querycustom account querycustom account remit querycustom account insurance query
    5. ▶Load-Dimension-Memberssub-job · 16↗
      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 Dimensionssqlload_dimension_members__load_time_dimensions.sql
        ✨ Populates the time dimension table with day, month, and year members to support temporal reporting and analysis.
        writes DimensionMember · reads TransformAccount
      3. Load VisitStatus Dimensionsqlload_dimension_members__load_visitstatus_dimension.sqldisabled
        ✨ Loads appointment status values into the visit status dimension to track patient encounter progress.
        writes DimensionMember · reads TransformVisit
      4. Load DenialCategory Dimensionsqlload_dimension_members__load_denialcategory_dimension.sql
        ✨ Loads denial category dimensions from adjustment code rollup data to categorize claim denials.
        writes DimensionMember · reads AdjustmentCodeRollup
      5. Load Provider + ProviderType Dimensionssqlload_dimension_members__load_provider_providertype_dimensions.sql
        ✨ Synchronizes provider and provider type dimensions by mapping individual providers to their respective specialty or classification categories.
        writes DimensionMember · reads DimensionMemberProvider
        ↳ feeds from Load AllowedStatus Dimension, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load Facility + FacilityGroup Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
      6. Load Facility + FacilityGroup Dimensionssqlload_dimension_members__load_facility_facilitygroup_dimensions.sql
        ✨ Updates facility and facility group dimensions to organize locations within their parent organizational structures for reporting.
        writes DimensionMember · reads DimensionMemberFacility
        ↳ feeds from Load AllowedStatus Dimension, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Provider + ProviderType Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
      7. Load FacilityType Dimensionssqlload_dimension_members__load_facilitytype_dimensions.sql
        ✨ Loads unique facility types into the dimension table to categorize locations by their specific service or operational model.
        writes DimensionMember · reads Facility
      8. Load Practice Dimensionssqlload_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
      9. Load PlaceOfService Dimensionssqlload_dimension_members__load_placeofservice_dimensions.sql
        ✨ Loads the place of service dimension by synchronizing standardized facility codes and names from common reference data.
        writes DimensionMember · reads POSCodes
      10. Load VisitType Dimensionssqlload_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
      11. Load AccountStatus Dimensionsqlload_dimension_members__load_accountstatus_dimension.sqldisabled
        ✨ Updates account status dimensions using encounter status information to track the lifecycle of patient accounts.
        writes DimensionMember · reads SourceEncounter
      12. Load AllowedStatus Dimensionsqlload_dimension_members__load_allowedstatus_dimension.sql
        ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
        writes DimensionMember
      13. Load DiagnosisCode Dimensionsqlload_dimension_members__load_diagnosiscode_dimension.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 AllowedStatus Dimension, Load DenialCategory Dimension, Load Facility + FacilityGroup Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Provider + ProviderType Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
      14. Load Modifier Dimensionsqlload_dimension_members__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
      15. Load-Source-Insurance-Dimensionsqlload_dimension_members__load_source_insurance_dimension.sql
        ✨ Updates the insurance dimension table with source insurance names and identifiers from EDI data for reporting.
        writes DimensionMember · reads AccountInsuranceInsuranceMap
      16. Load State Dimensionsqlload_dimension_members__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
    6. ▶Load-Custom-Propertiessub-job · 2↗
      1. Staging of Division Custom Prop Valuessqlload_custom_properties__staging_of_division_custom_prop_values.sql
        ✨ Stages account-level division properties by identifying practice ID changes that need to be updated in the custom property mapping.
        writes TempCustomProperty · reads TempCustomProperty
      2. UpdateCustomPropertyFromQueryUpdateCustomPropertyFromQuery
        · reads TempCustomProperty
        ↳ feeds from Staging of Division Custom Prop Values
        entity=Accountcustom property key=Divisionauto querybatch mode
    7. SyncBatchSyncBatch
      Synchronizes processed data from batch staging tables to production tables, updating visits, quotes, and custom property mappings.
      writes CustomPropertyMap · reads CustomPropertyMapBatch
      sync custom property map
    8. ▶Score-Accountssub-job · 17↗
      1. MedicareMedicare
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      2. RGAL - Capital BlueBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2024-01-01incrementalupdate dimensions
      3. RGAL - UHCBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      4. RGAL - CignaBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      5. RGAL - AetnaBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2024-01-01incrementalupdate dimensions
      6. RGAL - Highmark CommercialBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      7. RGAL - Independence CommercialBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      8. RGAL - Preferred Healthcare CommercialBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2024-10-01incrementalupdate dimensions
      9. DCDC - AetnaBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2024-01-01incrementalupdate dimensions
      10. DCDC - AmerihealthBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      11. DCDC - CignaBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      12. DCDC - DE First HealthBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      13. DCDC - HighmarkBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      14. DCDC - TricareBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      15. DCDC - UHCBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      16. DCDC - World Trade CenterBatchProcessAccounts
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2023-01-01incrementalupdate dimensions
      17. UPMCUPMC
        writes AccountEstimate · reads QuoteBatchVisitBatch
        min service date=2025-01-01incremental
    9. Load AccountDetailsqlload_account_data__load_accountdetail.sqldisabled
      ✨ Builds a comprehensive account summary table by combining patient, insurance, and financial data for detailed encounter reporting.
      writes AccountDetail · reads AccountAccountChargeAccountDeltaAccountEstimateDimensionMemberPatientSourceEncounterInsuranceSourcePayer
    10. Load AccountChargeDetailsqlload_account_data__load_accountchargedetail.sqldisabled
      ✨ Loads granular charge-level details including procedure codes, modifiers, and payment metrics for individual service line analysis.
      writes AccountChargeDetail · reads AccountAccountChargeAccountDeltaAccountEstimateCalculationAccountEstimateChargeDimensionMemberPatientSourceEncounterInsurance
  6. ▶Load-Dimension-Memberssub-job · 16↗
    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 Dimensionssqlload_dimension_members__load_time_dimensions.sql
      ✨ Populates the time dimension table with day, month, and year members to support temporal reporting and analysis.
      writes DimensionMember · reads TransformAccount
    3. Load VisitStatus Dimensionsqlload_dimension_members__load_visitstatus_dimension.sqldisabled
      ✨ Loads appointment status values into the visit status dimension to track patient encounter progress.
      writes DimensionMember · reads TransformVisit
    4. Load DenialCategory Dimensionsqlload_dimension_members__load_denialcategory_dimension.sql
      ✨ Loads denial category dimensions from adjustment code rollup data to categorize claim denials.
      writes DimensionMember · reads AdjustmentCodeRollup
    5. Load Provider + ProviderType Dimensionssqlload_dimension_members__load_provider_providertype_dimensions.sql
      ✨ Synchronizes provider and provider type dimensions by mapping individual providers to their respective specialty or classification categories.
      writes DimensionMember · reads DimensionMemberProvider
      ↳ feeds from Load AllowedStatus Dimension, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load Facility + FacilityGroup Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
    6. Load Facility + FacilityGroup Dimensionssqlload_dimension_members__load_facility_facilitygroup_dimensions.sql
      ✨ Updates facility and facility group dimensions to organize locations within their parent organizational structures for reporting.
      writes DimensionMember · reads DimensionMemberFacility
      ↳ feeds from Load AllowedStatus Dimension, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Provider + ProviderType Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
    7. Load FacilityType Dimensionssqlload_dimension_members__load_facilitytype_dimensions.sql
      ✨ Loads unique facility types into the dimension table to categorize locations by their specific service or operational model.
      writes DimensionMember · reads Facility
    8. Load Practice Dimensionssqlload_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
    9. Load PlaceOfService Dimensionssqlload_dimension_members__load_placeofservice_dimensions.sql
      ✨ Loads the place of service dimension by synchronizing standardized facility codes and names from common reference data.
      writes DimensionMember · reads POSCodes
    10. Load VisitType Dimensionssqlload_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
    11. Load AccountStatus Dimensionsqlload_dimension_members__load_accountstatus_dimension.sqldisabled
      ✨ Updates account status dimensions using encounter status information to track the lifecycle of patient accounts.
      writes DimensionMember · reads SourceEncounter
    12. Load AllowedStatus Dimensionsqlload_dimension_members__load_allowedstatus_dimension.sql
      ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
      writes DimensionMember
    13. Load DiagnosisCode Dimensionsqlload_dimension_members__load_diagnosiscode_dimension.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 AllowedStatus Dimension, Load DenialCategory Dimension, Load Facility + FacilityGroup Dimensions, Load FacilityType Dimensions, Load Modifier Dimension, Load PlaceOfService Dimensions, Load Provider + ProviderType Dimensions, Load State Dimension, Load Time Dimensions, Load-Source-Insurance-Dimension, LoadInsuranceDimensionMembers
    14. Load Modifier Dimensionsqlload_dimension_members__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
    15. Load-Source-Insurance-Dimensionsqlload_dimension_members__load_source_insurance_dimension.sql
      ✨ Updates the insurance dimension table with source insurance names and identifiers from EDI data for reporting.
      writes DimensionMember · reads AccountInsuranceInsuranceMap
    16. Load State Dimensionsqlload_dimension_members__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