sub-job

RIA · Score-Accounts

called by Load-Account-Data

sub-job RIA/Score-Accounts · db RIA_ProdMirror · updated 2025-12-19

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

Score-Accounts

42 tasks · RIA

sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc

AetnaAetna
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
Aetna Medicare ECFOI, MICTIC, RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
Aetna Medicare IMIBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-03-15incremental
Avmed MedicareBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-01-01incremental
BCBSBCBS
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-06-27incremental
BCBS Medicare ECFOIBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-06-27incremental
BCBS Medicare IMIBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
BCBS Medicare MICTICBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-01-01incremental
BCBS Medicare RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
Beech Street RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2006-11-01incremental
CarePlusCarePlus
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-01-01incremental
CarePlus RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-05-01incremental
CariskCarisk
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-05-01incremental
Cigna ECFOI, MICTIC, RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2020-01-01incremental
Cigna IMIBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-12-15incremental
CurativeCurative
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2025-09-14incremental
Devoted Health RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2022-12-01incremental
Employee Benefit Management Services RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2020-10-01incremental
Evolutions Healthcare Systems RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-10-16incremental
Florida HealthBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2020-01-01incremental
Florida Health MedicareBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2020-01-01incremental
Freedom Health MedicareBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-01-01incremental
Health First RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2018-08-01incremental
Hospice of Marion County RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2020-01-01incremental
HumanaHumana
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
Humana MedicareBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
MedicareMedicare
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-01-01incremental
MultiPlan RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2011-12-31incremental
Oscar RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2020-01-01incremental
Prime HealthBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
Prime Health Workers CompBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
Self PayBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
SimPlan RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2021-04-01incremental
Tricare RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2017-03-01incremental
Trustmark Health Benefits RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2020-11-01incremental
United HealthcareBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
United Healthcare Medicare IMI & ECFOIBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2023-01-01incremental
United Healthcare Medicare MICTICBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-01-01incremental
VA Community Care Network IMIBatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-01-01incremental
VA Community Care Network RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2021-08-01incremental
Volusia Health Network RAOC / RIABatchProcessAccounts
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2020-01-01incremental
WellCareWellCare
writes AccountEstimate · reads QuoteBatchVisitBatch
min service date=2024-01-01incremental