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

sub-job

NWDerm · FHIR-Transform

FHIR Transformation Layer

called by FHIR-Processing

sub-job NWDerm/FHIR-Transform · db NWDerm_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

FHIR-Transform

5 tasks · NWDerm
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. ImportTransformVisitsqlfhir_transform__importtransformvisit.sql
    ✨ Loads incremental appointment changes from FHIR sources into staging, including reason codes and updated service type definitions.
    writes ImportTransformVisit · reads FHIRIncomingSourceAppointmentFHIRProcessBatchVisitDelta
  2. MergeTransformVisitsqlfhir_transform__mergetransformvisit.sql
    ✨ Updates the visit transformation table by replacing existing records with the latest imported appointment, facility, and provider details.
    writes TransformVisit · reads ImportTransformVisit
    ↳ feeds from ImportTransformVisit
  3. ImportTransformVisitInsurancesqlfhir_transform__importtransformvisitinsurance.sql
    ✨ Loads primary, secondary, and tertiary insurance details into the staging table while mapping source payers to standardized insurance records.
    writes ImportTransformVisitInsurance · reads FHIRIncomingSourceAppointmentFHIRProcessBatchInsuranceMapVisitDelta
  4. MergeTransformVisitInsurancesqlfhir_transform__mergetransformvisitinsurance.sql
    ✨ Updates the main insurance transformation table by replacing existing records with newly imported and mapped insurance information.
    writes TransformVisitInsurance · reads ImportTransformVisitInsurance
    ↳ feeds from ImportTransformVisitInsurance
  5. AugmentTransformVisitsqlfhir_transform__augmenttransformvisit.sqldisabled
    ✨ Refines visit service types by mapping insurance-specific codes to standardized eligibility categories for more accurate coverage verification.
    writes TransformVisit · reads EligibilityMapping2024ImportTransformVisitTransformVisitInsurance