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

sub-job

SGP · RevFind-Source-LoadDataFile

called by RevFind-Daily-Processing

sub-job SGP/RevFind-Source-LoadDataFile · db SGP_ProdMirror · updated 2026-01-21

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

RevFind-Source-LoadDataFile

16 tasks · SGP
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. S3DownloadS3Download
    command=powershell.exe
  2. Patient Encounter Ins File CleanupExecuteProcess
    command=powershell.exe
  3. Encounter File CleanupExecuteProcess
    command=powershell.exe
  4. Patient File CleanupExecuteProcess
    command=powershell.exe
  5. LoadDataFile-ChargeMasterLoadDataFile-ChargeMaster
    writes ChargemasterFile
    data file spec=ChargemasterFilefile path={SourceDataFolder}\chargemaster_data000import mode=Refillarchive file path={SourceDataArchive}
  6. LoadDataFile-EncountersLoadDataFile-Encounters
    writes EncounterFile
    data file spec=EncounterFilefile path={SourceDataFolder}\encounter_data000import mode=Refillarchive file path={SourceDataArchive}
  7. LoadDataFile-PatientEncounterInsuranceLoadDataFile-PatientEncounterInsurancedisabled
    writes PatientEncounterInsuranceFile
    data file spec=PatientEncounterInsuranceFileimport mode=Refillarchive file path={SourceDataArchive}DISABLED
  8. Load PatientEncounterInsuranceProcessFile
    writes ImportPatientEncounterInsuranceSourcePatientEncounterInsurance
    archive directory={SourceDataArchive}base table name=PatientEncounterInsurancerow terminator=Newlinecolumn separator=Comma
  9. LoadDataFile-PatientLoadDataFile-Patient
    writes PatientFile
    data file spec=PatientFilefile path={SourceDataFolder}\patient_data000import mode=Refillarchive file path={SourceDataArchive}
  10. LoadDataFile-ProviderLoadDataFile-Provider
    writes ProviderFile
    data file spec=ProviderFilefile path={SourceDataFolder}\provider_data000import mode=Refillarchive file path={SourceDataArchive}
  11. LoadDataFile-LocationLoadDataFile-Location
    writes LocationFile
    data file spec=LocationFilefile path={SourceDataFolder}\location_data000import mode=Refillarchive file path={SourceDataArchive}
  12. LoadDataFile-ChargeLoadDataFile-Chargedisabled
    writes ChargeFile
    data file spec=ChargeFilefile path={SourceDataFolder}\charges000import mode=Refillarchive file path={SourceDataArchive}DISABLED
  13. Load ChargeProcessFile
    writes ImportChargeSourceCharge
    file path={SourceDataFolder}\charges000archive directory={SourceDataArchive}base table name=Chargerow terminator=Linefeedcolumn separator=Comma
  14. LoadDataFile-TransactionLoadDataFile-Transaction
    writes TransactionFile
    data file spec=TransactionFilefile path={SourceDataFolder}\payments_adj000import mode=Refillarchive file path={SourceDataArchive}
  15. LoadDataFile-InsuranceLoadDataFile-Insurance
    writes InsuranceFile
    data file spec=InsuranceFilefile path={SourceDataFolder}\insurance__data000import mode=Refillarchive file path={SourceDataArchive}
  16. LoadDataFile-InsuranceExceptionsLoadDataFile-InsuranceExceptionsdisabled
    writes PatientEncounterInsuranceExceptionsFile
    data file spec=PatientEncounterInsuranceExceptionsFileimport mode=Refillarchive file path={SourceDataArchive}DISABLED