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

sub-job

USHP · RevFind-Source-ProcessNextGenData-FL

called by RevFind-Daily-Processing-Accounts

sub-job USHP/RevFind-Source-ProcessNextGenData-FL · db USHP_ProdMirror · updated 2026-04-06

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-ProcessNextGenData-FL

19 tasks · USHP
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. Download FLDownload
    Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
    server=USHP_ProdMirror-mdcssh-sftpremote directory=/Stuart101124/local directory={SourceDataFolder}\Stuart101124remote archive directory=/Archive/
  2. Clean AppointmentFL ExtractExecuteProcess
    command=powershell.exe
  3. Clean PatientInsuranceFL ExtractExecuteProcess
    command=powershell.exe
  4. Clean ChargeMasterFL ExtractExecuteProcess
    command=powershell.exe
  5. Clean ExportAdjustment (FL-specific)ExecuteProcess
    command=powershell.exe
  6. Process ExportAdjustmentFLProcessFile
    writes ImportAdjustmentFLSourceAdjustmentFL
    archive directory={SourceDataArchive}\Stuart101124base table name=AdjustmentFLrow terminator=Linefeedcolumn separator=Pipe
  7. Load ExportAppointmentFLProcessFile
    writes ImportAppointmentFLSourceAppointmentFL
    archive directory={SourceDataArchive}\Stuart101124base table name=AppointmentFLrow terminator=Linefeedcolumn separator=Pipe
  8. Load ExportChargeFLProcessFile
    writes ImportChargeFLSourceChargeFL
    archive directory={SourceDataArchive}\Stuart101124base table name=ChargeFLrow terminator=Linefeedcolumn separator=Pipe
  9. Load ImportChargeMasterFLProcessFile
    writes ImportChargeMasterFLSourceChargeMasterFL
    archive directory={SourceDataArchive}\Stuart101124base table name=ChargeMasterFLrow terminator=Linefeedcolumn separator=Pipe
  10. Load ExportEncounterFLProcessFile
    writes ImportEncounterFLSourceEncounterFL
    archive directory={SourceDataArchive}\Stuart101124base table name=EncounterFLrow terminator=Linefeedcolumn separator=Pipe
  11. Load ImportEncounterInsuranceFL DataFileLoadFile
    writes ImportEncounterInsuranceFL
    data file spec=ImportEncounterInsuranceFLimport mode=Replacearchive file path={SourceDataArchive}\Stuart101124
  12. Load SourceEncounterInsuranceFLsqlrevfind_source_processnextgendata_fl__load_sourceencounterinsurancefl.sql
    ✨ Loads Florida encounter insurance data from import tables into the source staging area for further processing.
    writes sourceencounterinsuranceFL · reads ImportEncounterInsuranceFL
    ↳ feeds from Load ImportEncounterInsuranceFL DataFile
  13. Load ExportEventFLProcessFile
    writes ImportEventFLSourceEventFL
    archive directory={SourceDataArchive}\Stuart101124base table name=EventFLrow terminator=Linefeedcolumn separator=Pipe
  14. Load ExportLocationFLProcessFile
    writes ImportLocationFLSourceLocationFL
    archive directory={SourceDataArchive}\Stuart101124base table name=LocationFLrow terminator=Linefeedcolumn separator=Pipe
  15. Load ExportPatientFLProcessFile
    writes ImportPatientFLSourcePatientFL
    archive directory={SourceDataArchive}\Stuart101124base table name=PatientFLrow terminator=Linefeedcolumn separator=Pipe
  16. Load ExportPatientInsuranceFLProcessFile
    writes ImportPatientInsuranceFLSourcePatientInsuranceFL
    archive directory={SourceDataArchive}\Stuart101124base table name=PatientInsuranceFLrow terminator=Linefeedcolumn separator=Pipe
  17. Load ExportPayerFLProcessFile
    writes ImportPayerFLSourcePayerFL
    archive directory={SourceDataArchive}\Stuart101124base table name=PayerFLrow terminator=Linefeedcolumn separator=Pipe
  18. Load ExportProviderFLProcessFile
    writes ImportProviderFLSourceProviderFL
    archive directory={SourceDataArchive}\Stuart101124base table name=ProviderFLrow terminator=Linefeedcolumn separator=Pipe
  19. Process ExportTransactionDetailFL DataFileProcessFile
    writes ImportTransactionDetailFLSourceTransactionDetailFL
    archive directory={SourceDataArchive}\Stuart101124base table name=TransactionDetailFLrow terminator=Linefeedcolumn separator=Pipe