sub-job

SeaRad · Load-ALL-Medicaid-Schedules

called by Daily-Visit-Processing, Daily-Visit-Processing-HL7

sub-job SeaRad/Load-ALL-Medicaid-Schedules · 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

Load-ALL-Medicaid-Schedules

4 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

ContractMapsqlload_all_medicaid_schedules__contractmap.sqldisabled
✨ Updates contract mappings for Medicaid by associating facilities with standardized professional fee schedules and effective date ranges.
writes ContractMap · reads ContractMapFacility
Load All WA Medicaid Schedulessqlload_all_medicaid_schedules__load_all_wa_medicaid_schedules.sql
✨ Loads regional Medicaid fee schedules and schedule mappings into the system for non-hospital facilities and specific service types.
writes FeeScheduleRecordScheduleMap · reads CommonDataFeeScheduleRecordScheduleMap
↳ feeds from Copy Medicaid Schedules to All Insurances
LoadEntitiesFromQueryLoadEntitiesFromQuery
Load or update entity records from custom SQL query results into their corresponding system tables using intelligent merge logic.
writes Schedule · reads ScheduleMap
↳ feeds from Copy Medicaid Schedules to All Insurances, Load All WA Medicaid Schedules
entity type=Schedulecustom query
Copy Medicaid Schedules to All Insurancessqlload_all_medicaid_schedules__copy_medicaid_schedules_to_all_insurances.sql
✨ Propagates Medicaid fee schedule mappings to other insurance providers within the system to ensure consistent pricing across similar plans.
writes ScheduleMap · reads DimensionMemberScheduleMap
↳ feeds from Load All WA Medicaid Schedules