240 likes | 249 Views
Charting the Course of sftp and the Patient Data Backup. Sharon Smith. Key Objectives:. What is sftp sftp setup options Print scheduler setup for the Patient Data Backup Information included on the Patient Data Backup Report. Charting your course. FTP – File Transfer Protocol.
E N D
Charting the Course of sftp and the Patient Data Backup Sharon Smith
Key Objectives: • What is sftp • sftp setup options • Print scheduler setup for the Patient Data Backup • Information included on the Patient Data Backup Report
FTP – File Transfer Protocol • FTP = File Transfer Protocol • Popular method of transferring files between two remote systems • Should only be used in limited cases • Used with trusted networks
SFTP – SSH Secure File Transfer Protocol • SFTP = SSH File Transfer Protocol / Secure File Transfer Protocol • Secure File Transfer Protocol • Piggy-back on an SSH connection • Supports full security and authentication functionality of SSH • Replaced legacy FTP and replacing FTP/S • Provides all functionality offered by FTP and FTP/S • More secure and reliable • Easier configuration • Protects against password sniffing • Protects integrity of data, using encryption and cryptographic hash functions • Authenticates both the server and the user
Securely Copy Patient Data Backup Reports • Option 1: SCC creates SFTP account on AIX servers • Option 2: Client provides SFTP account credentials to connect to remote storage
Securely Copy PDB Reports – Option 1 • SCC creates SFTP account on AIX servers • Must be done on both MAINSYS and AUXSYS if 2-server configuration • Client establishes SFTP connection from “ftp hub” • Grabs file • Generates the key • Sends public key to SCC • SCC adds public key to the ~sftp/authorized_keys • SCC configures software to send PDB reports to SFTP home directory on AIX server • Client initiates copying files from AIX server to storage
Securely Copy PDB Reports – Option 2 • Client provides SFTP account credentials to connect to remote storage (authorized_keys) • SCC establishes SFTP connection from AIX server • SCC generates the key • Client adds the key to the proper location on their SFTP server • SCC configures software to send PDB reports using SFTP connection directly to remote storage
Why use the Patient Data Backup? • The patient data backup contains pertinent patient history • Used by end users when SoftBank is down
Patient Data Backup Default Settings • Patient’s Last Name • Patient’s First Name • Patient’s Middle Name • Medical Record Number • Date of Birth • ABO/Rh • Patient Messages w/Comments • Last Specimen Collected Date • Last Specimen Outdate • Last Transfusion – Cellular/Non-cellular • Transfusion Reactions • Antibodies
Possible Settings to be Added to Patient Data Backup in SoftBank 25.5.5.0 • Last Specimen Collected Date • Last Specimen Outdate Date • Last Specimen Outdate Time • Positive Patient Antibodies • Recent Antibody Screen Collected Date • Recent Antibody Screen Collected Time • Recent Antibody Screen Interpretation • Last Transfusion Type – Cellular/Non-cellular • Physician’s Impressions • Patient’s Full Name • Patient’s Last Name • Patient’s First Name • Patient’s Middle Name • Medical Record Number • Social Security Number • Auxiliary ID • MPI# • External ID • ABO/Rh • Patient special messages w/comments
Patient Data Backup Generated by SoftBank with Additional Settings
Patient Data Backup on Print Scheduler • Run the Patient Data Backup Report Automatically • Setup an additional run for scheduled down times
Patient Data Backup Setup in 4.0 • Utilities – Printer Scheduler • Locate BBPDBREP
Setup 4.0 continued • Determine days of week and times the report should run
Patient Data Backup Setup in 4.5 • Reports – Printer Scheduler • Locate BBPDBREP
Setup 4.5 continued • Determine days of week and times the report should run
Points of Interest • Parameters – Date Range; Special Message Comments • All patients are included. • Report can be set up to run from one site • File can be copied and moved to other sites specified location • Client controls who has access to view the information in the file
Please remember to take a few moments to fill out the session survey. You can find the QR code in your Conference Brochure as well as hyperlinks to the survey online at www.snuginconline.org with the SNUG 2019 handouts.