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

sub-job

SeaRad · Populate-Core-Tables

called by Daily-Visit-Processing

sub-job SeaRad/Populate-Core-Tables · db SeaRad_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

Populate-Core-Tables

6 tasks · SeaRad
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. Populate Patient - Oldsqlpopulate_core_tables__populate_patient_old.sqldisabled
    ✨ Builds the core patient registry by extracting the most recent demographic information from scheduled appointment records.
    · reads SourceAppointment
  2. Load PatientsLoadPatients
    Upsert patient records into the patient dimension.
    · reads PatientSourceAppointment
    custom patient query
  3. Populate ChargeTypesqlpopulate_core_tables__populate_chargetype.sql
    ✨ Builds and updates the ChargeType table by merging procedure codes and descriptions from the charge master and appointment records.
    writes ImportChargeType · reads ChargeTypeCommonDataSourceAppointmentSourceChargeMaster
  4. Insert Additional Charges from Appointmentssqlpopulate_core_tables__insert_additional_charges_from_appointments.sqldisabled
    ✨ Loads new procedure codes from appointment data into the ChargeType table when they are missing from the existing master list.
    writes ChargeType · reads ChargeTypeProcedureCodeSourceAppointment
  5. Load FacilityLoadEntities
    writes Facility · reads DimensionMember
    entity type=Facilitycustom query
  6. Load BillTypeLoadEntities
    writes BillType · reads DimensionMember
    entity type=BillTypecustom query