Shah Lab

User Tools

Site Tools

You are here: start » onboarding_affiliates
onboarding_affiliates

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Last revision Both sides next revision
onboarding_affiliates [2017/02/02 13:00]
acallaha 		onboarding_affiliates [2021/07/07 13:40]
acallaha
Line 1: Line 1:
 ====== Onboarding for affiliates ====== ====== Onboarding for affiliates ======
 ===== Onboarding steps ===== ===== Onboarding steps =====
 +
   - Get SUNET ID to access the Stanford network. External collaborators will require sponsorship from a Stanford staff.   - Get SUNET ID to access the Stanford network. External collaborators will require sponsorship from a Stanford staff.
-  - Get access to our [[int:lab_information#computing_resources |servers]] (shahlab-dev2, shahlab-db1). Contact Alex Skrenchuk. [[https://itservices.stanford.edu/service/vpn| VPN]] is needed for off-campus access and probably on-campus access as well. +  - Get access to our servers. Contact Jason Fries. [[https://itservices.stanford.edu/service/vpn|VPN]] is needed for off-campus access and probably on-campus access as well. 
-  - Identify the [[int:database | databases]] you need. Get authorization from database owner and work with your assigned mentor and Alex to arrange for access. Read and agree to DUA.+  - Identify the [[:int:database|databases]] you need. Get authorization from database owner and work with your assigned mentor and Jason Fries to arrange for access. Read and agree to [[https://shahlab.stanford.edu/_media/dua_for_collaborators_shah_lab.docx|DUA]].
   - Complete the necessary training   - Complete the necessary training
-      - IF you will access db1 AND dev1, you need to complete the following training: +      - IF you will access data containing PHI (e.g. clinical notes), you need to complete the following training: 
-          - Protecting Patient Privacy - contact Shauna Cruz (shaunalc@stanford.edu) to get signed up via LawRoom +        - Protecting Patient Privacy - sign up via [[https://axess.sahr.stanford.edu/group/guest/stars?psft_src=/EMPLOYEE/ELM/c/LM_SS_LEARNING.LM_BROWSE_LEARNER.GBL?type=COURSE&code=PRIV-2019|STARS]] 
-          - Protection of Human Subjects - GROUP 1: IRB REQUIRED FOR MEDICAL RESEARCH INVESTIGATORS AND STAFF - done via {{https://humansubjects.stanford.edu/new/resources/training/citi.html|CITI}} +        - Protection of Human Subjects - GROUP 7: IRB BioMed/GCP Research - done via [[https://researchcompliance.stanford.edu/hs/new/resources/training/citi.html|CITI]] 
-      - IF you will access ONLY db1, you need to complete the following training: +      - IF you will access ONLY de-identified patient data, you need to complete the following training: 
-          - HIPAA Certification for Workforce Members who Do Not Work with PHI - contact Shauna Cruz (shaunalc@stanford.edu) to get signed up via LawRoom +        - Protecting Patient Privacy - sign up via [[https://axess.sahr.stanford.edu/group/guest/stars?psft_src=/EMPLOYEE/ELM/c/LM_SS_LEARNING.LM_BROWSE_LEARNER.GBL?type=COURSE&code=PRIV-2018|STARS]] 
-      - Upload your certificates at: http://shahlab.stanford.edu/lab_members +      - Provide your certificates to Jason to get access 
-  - Understand our [[int:clinical_study|clinical study workflow]] and [[int:annotation| annotation workflow]] +  - Join the lab slack 
-  - You are encouraged to set up a wiki page to document your project. [[int:dou_jin| See example.]] +  - Find the person in the lab who can explain the data you will use - talk to them! 
-  - For details regarding specific steps, schedule a one-on-one session with the relevant person +  - Set up a wiki page to document your project. [[:int:callahan:medical_device_surveillance|See example.]] 
-    * Server access: Alex Skrenchuk +  - For details regarding specific resources, schedule a one-on-one session with the relevant person 
-    * Data use agreement: Nigam Shah +      * Server access: Jason Fries 
-    * Text processing: Juan Banda +      * Data use agreement: Nigam Shah 
-    * Cohort building: +      * Text processing: Jason Fries 
-      * [[int:clinical_study|Quick guide on querying EMR]] +      * Data/terminologies: Alison Callahan, Vladimir Polony 
-      * Patient matching +
-    * Data analysis:+
  
 ===== Data sharing and Use Agreement ===== ===== Data sharing and Use Agreement =====
Line 32: Line 32:
   * All __publications or presentations__ relating to the data will be cleared in advance through Shah lab.   * All __publications or presentations__ relating to the data will be cleared in advance through Shah lab.
  
-===== How to connect to Dev2 ======+===== How to connect to shahlab-compute (formerly dev2) ======
 If you are off-campus (or on the wireless network), you will need [[https://itservices.stanford.edu/service/vpn| VPN]].\\ If you are off-campus (or on the wireless network), you will need [[https://itservices.stanford.edu/service/vpn| VPN]].\\
-Not to be confused with DB1, this only needs a simple SSH command to connect (open a terminal):+SSH command to connect (open a terminal):
  
-<code>ssh <yourusername>@shahlab-dev2.stanford.edu </code>+<code>ssh <yourusername>@shahlab-compute.stanford.edu </code>
  
 The first time you do this it will ask you to store the RSA key, just type yes. After the first time, this should not appear anymore.  The first time you do this it will ask you to store the RSA key, just type yes. After the first time, this should not appear anymore. 
  
-===== How to connect to DB1 ======+===== How to connect to shahlab-database (formerly db1) ======
 There are multiple different ways of connecting to the database server. If you are off-campus, you will need [[https://itservices.stanford.edu/service/vpn| VPN]].\\ There are multiple different ways of connecting to the database server. If you are off-campus, you will need [[https://itservices.stanford.edu/service/vpn| VPN]].\\
  
-**NOTE: Your DB1 password is NOT the same as your dev2 password. It is found on the .my.cnf file file on your home/your_name directories.** +**NOTE: Your DB1 password is NOT the same as your shahlab-compute password. It is found on the .my.cnf file file on your home/your_name directories.** 
  
 1) (The easiest way) Set up a MySQL GUI:\\ 1) (The easiest way) Set up a MySQL GUI:\\
Line 60: Line 60:
 3) (hard and confusing) Create a tunnel from the database server to your computer: 3) (hard and confusing) Create a tunnel from the database server to your computer:
  
-- To connect to //shahlab-db1.stanford.edu//, a MySQL database (port 3306), tunnel via //shahlab-dev2.stanford.edu//. +- To connect to //shahlab-database.stanford.edu//, a MySQL database (port 3306), tunnel via //shahlab-dev2.stanford.edu//. 
-<code>ssh -L 3306:shahlab-db1.stanford.edu:3306 <yourusername>@shahlab-dev2.stanford.edu -Nf</code>+<code>ssh -L 3306:shahlab-database.stanford.edu:3306 <yourusername>@shahlab-compute.stanford.edu -Nf</code>
 - Use your local copy of MySQL (you need to instal the MySQL client on your computer) \\ - Use your local copy of MySQL (you need to instal the MySQL client on your computer) \\
 - Then connect to the database of interest - Then connect to the database of interest
 <code>mysql -h localhost -P 3306 -u<yourusername> -p<yourpassword> <databasename></code> <code>mysql -h localhost -P 3306 -u<yourusername> -p<yourpassword> <databasename></code>
onboarding_affiliates.txt · Last modified: 2021/11/23 17:25 by acallaha

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki