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

sub-job

SGP · RevFind-Source-Import-QuickSight

called by RevFind-Daily-Processing

sub-job SGP/RevFind-Source-Import-QuickSight · db SGP_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

RevFind-Source-Import-QuickSight

14 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. Download QuickSite FilesDownloaddisabled
    Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
    server=SGP_ProdMirror-mdcssh-sftpremote directory=/local directory={SourceDataFolder}DISABLED
  2. S3DownloadS3Download
    command=powershell.exe
  3. Patient Encounter Ins File CleanupExecuteProcess
    command=powershell.exe
  4. Encounter File CleanupExecuteProcess
    command=powershell.exe
  5. Load ChargeMasterProcessFile
    writes ImportChargemasterSourceChargemaster
    file path={SourceDataFolder}\chargemaster_data000archive directory={SourceDataArchive}base table name=Chargemasterrow terminator=Linefeedcolumn separator=Comma
  6. Load EncountersProcessFile
    writes ImportEncounterSourceEncounter
    file path={SourceDataFolder}\encounter_data000archive directory={SourceDataArchive}base table name=Encounterrow terminator=Newlinecolumn separator=Comma
  7. Load PatientEncounterInsuranceProcessFile
    writes ImportPatientEncounterInsuranceSourcePatientEncounterInsurance
    archive directory={SourceDataArchive}base table name=PatientEncounterInsurancerow terminator=Newlinecolumn separator=Comma
  8. Load PatientProcessFile
    writes ImportPatientSourcePatient
    file path={SourceDataFolder}\patient_data000archive directory={SourceDataArchive}base table name=Patientrow terminator=Linefeedcolumn separator=Comma
  9. Load ProviderProcessFile
    writes ImportProviderSourceProvider
    file path={SourceDataFolder}\provider_data000archive directory={SourceDataArchive}base table name=Providerrow terminator=Linefeedcolumn separator=Comma
  10. Load LocationProcessFile
    writes ImportLocationSourceLocation
    file path={SourceDataFolder}\location_data000archive directory={SourceDataArchive}base table name=Locationrow terminator=Linefeedcolumn separator=Comma
  11. Load ChargeProcessFile
    writes ImportChargeSourceCharge
    file path={SourceDataFolder}\charges000archive directory={SourceDataArchive}base table name=Chargerow terminator=Linefeedcolumn separator=Comma
  12. Load TransactionProcessFile
    writes ImportTransactionSourceTransaction
    file path={SourceDataFolder}\payments_adj000archive directory={SourceDataArchive}base table name=Transactionrow terminator=Linefeedcolumn separator=Comma
  13. Load InsuranceProcessFile
    writes ImportInsuranceSourceInsurance
    file path={SourceDataFolder}\insurance__data000archive directory={SourceDataArchive}base table name=Insurancerow terminator=Linefeedcolumn separator=Comma
  14. Load Patient Encounter Insurance ExceptionsProcessFiledisabled
    writes ImportPatientEncounterInsuranceExceptionsSourcePatientEncounterInsuranceExceptions
    archive directory={SourceDataArchive}base table name=PatientEncounterInsuranceExceptionsrow terminator=Newlinecolumn separator=CommaDISABLED