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

sub-job

JewishBoard · RevFind-Source-Import

called by RevFind-Daily-Processing

sub-job JewishBoard/RevFind-Source-Import · db JewishBoard_ProdMirror · updated 2026-01-29

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-Import

22 tasks · JewishBoard
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. DownloadDownload
    Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
    server=JewishBoard_ProdMirror-mdcssh-sftpremote directory=/local directory={SourceDataFolder}
  2. Charge ProcessDataFileProcessFiledisabled
    writes ImportChargeDetailsSourceChargeDetails
    archive directory={SourceDataArchive}base table name=ChargeDetailsrow terminator=Newlinecolumn separator=TabDISABLED
  3. BillingTxHistory ProcessDataFileProcessFiledisabled
    writes ImportBillingTxHistorySourceBillingTxHistory
    archive directory={SourceDataArchive}base table name=BillingTxHistoryrow terminator=Newlinecolumn separator=TabDISABLED
  4. Encounter ProcessDataFileProcessFiledisabled
    writes ImportEncounterSourceEncounter
    archive directory={SourceDataArchive}base table name=Encounterrow terminator=Newlinecolumn separator=PipeDISABLED
  5. ChargeMaster ProcessDataFileProcessFiledisabled
    writes ImportChargeMasterSourceChargeMaster
    archive directory={SourceDataArchive}base table name=ChargeMasterrow terminator=Newlinecolumn separator=TabDISABLED
  6. Insurance ProcessDataFileProcessFiledisabled
    writes ImportInsuranceSourceInsurance
    archive directory={SourceDataArchive}base table name=Insurancerow terminator=Newlinecolumn separator=TabDISABLED
  7. Location ProcessDataFileProcessFiledisabled
    writes ImportLocationSourceLocation
    archive directory={SourceDataArchive}base table name=Locationrow terminator=Newlinecolumn separator=TabDISABLED
  8. Patient ProcessDataFileProcessFiledisabled
    writes ImportPatientSourcePatient
    archive directory={SourceDataArchive}base table name=Patientrow terminator=Newlinecolumn separator=TabDISABLED
  9. PatientEncounterInsurance ProcessDataFileProcessFiledisabled
    writes ImportPatientEncounterInsuranceSourcePatientEncounterInsurance
    archive directory={SourceDataArchive}base table name=PatientEncounterInsurancerow terminator=Newlinecolumn separator=TabDISABLED
  10. Provider ProcessDataFileProcessFiledisabled
    writes ImportProviderSourceProvider
    archive directory={SourceDataArchive}base table name=Providerrow terminator=Newlinecolumn separator=TabDISABLED
  11. TransactionAdj ProcessDataFileProcessFiledisabled
    writes ImportTransactionPayAdjHistorySourceTransactionPayAdjHistory
    archive directory={SourceDataArchive}base table name=TransactionPayAdjHistoryrow terminator=Newlinecolumn separator=TabDISABLED
  12. ▶RevFind-Source-ChargeProcessDataFilesub-job · 1↗
    1. Charge ProcessDataFileProcessFile
      writes ImportChargeDetailsSourceChargeDetails
      file path={FilePath}archive directory={SourceDataArchive}base table name=ChargeDetailsrow terminator=Newlinecolumn separator=Tab
  13. ▶RevFind-Source-BillingTxProcessDataFilesub-job · 1↗
    1. BillingTxHistory ProcessDataFileProcessFile
      writes ImportBillingTxHistorySourceBillingTxHistory
      file path={FilePath}archive directory={SourceDataArchive}base table name=BillingTxHistoryrow terminator=Newlinecolumn separator=Tab
  14. ▶RevFind-Source-EncounterProcessDataFilesub-job · 1↗
    1. Encounter ProcessDataFileProcessFiledisabled
      writes ImportEncounterSourceEncounter
      file path={FilePath}archive directory={SourceDataArchive}base table name=Encounterrow terminator=Newlinecolumn separator=Pipe
  15. ▶RevFind-Source-ChargeMasterProcessDataFilesub-job · 1↗
    1. ChargeMaster ProcessDataFileProcessFile
      writes ImportChargeMasterSourceChargeMaster
      file path={FilePath}archive directory={SourceDataArchive}base table name=ChargeMasterrow terminator=Newlinecolumn separator=Tab
  16. ▶RevFind-Source-InsuranceProcessDataFilesub-job · 1↗
    1. Insurance ProcessDataFileProcessFile
      writes ImportInsuranceSourceInsurance
      file path={FilePath}archive directory={SourceDataArchive}base table name=Insurancerow terminator=Newlinecolumn separator=Tab
  17. ▶RevFind-Source-LocationProcessDataFilesub-job · 1↗
    1. Location ProcessDataFileProcessFile
      writes ImportLocationSourceLocation
      file path={FilePath}archive directory={SourceDataArchive}base table name=Locationrow terminator=Newlinecolumn separator=Tab
  18. ▶RevFind-Source-PatientProcessDataFilesub-job · 1↗
    1. Patient ProcessDataFileProcessFile
      writes ImportPatientSourcePatient
      file path={FilePath}archive directory={SourceDataArchive}base table name=Patientrow terminator=Newlinecolumn separator=Tab
  19. ▶RevFind-Source-PatEncInsProcessDataFilesub-job · 1↗
    1. PatientEncounterInsurance ProcessDataFileProcessFile
      writes ImportPatientEncounterInsuranceSourcePatientEncounterInsurance
      file path={FilePath}archive directory={SourceDataArchive}base table name=PatientEncounterInsurancerow terminator=Newlinecolumn separator=Tab
  20. ▶RevFind-Source-ProviderProcessDataFilesub-job · 1↗
    1. Provider ProcessDataFileProcessFile
      writes ImportProviderSourceProvider
      file path={FilePath}archive directory={SourceDataArchive}base table name=Providerrow terminator=Newlinecolumn separator=Tab
  21. ▶RevFind-Source-TranPayAdjProcessDataFilesub-job · 2↗
    1. dedupe txnsExecuteProcess
      command=powershell.exe
    2. TransactionAdj ProcessDataFileProcessFile
      writes ImportTransactionPayAdjHistorySourceTransactionPayAdjHistory
      file path={FilePath}archive directory={SourceDataArchive}base table name=TransactionPayAdjHistoryrow terminator=Newlinecolumn separator=Tab
  22. One-time load of SourcePayAdj to deal w dupessqlrevfind_source_import__one_time_load_of_sourcepayadj_to_deal_w_dupes.sql
    ✨ Deduplicates and merges payment and adjustment history into the source transaction table to ensure data integrity.
    writes SourceTransactionPayAdjHistory · reads ImportTransactionPayAdjHistoryJewishBoard