Changes between Version 2 and Version 3 of SOP Data Request

Timestamp:

08/22/17 16:35:03 (7 years ago)

Author:

dan.lawday

Comment:

--

SOP Data Request

@@ -37 +37 @@
 1. Where patient identifiable or sensitive data is extracted, the extracted data must be [[SOP Encryption|encrypted]].
 
+== When Florance (Stats team) Requests an update to the Genvasc Dataset for importing into SAS do this:
+1. connect useing SQL server to UHLSQLPRIME01\UHLBRICCSDB
+1. run in the i2b2_app03_genvasc_Data Database the PROC Refresh_ObservationsViewForFlo_B
+1. Export to CSV as follows Right click on Managament in the UHLSQLPRIME01\UHLBRICCSDB > Export Data > Next
+  1. Leave Data source and Server Name as is (SQL Server Native Client 10.0 and UHLSQLPRIME01\UHLBRICCSDB), Set Database to i2b2_app03_genvasc_Data.
+  1. Destination is FlatFile, Call the file GEN_ALL_C.CSV (I save to the Desktop (and delete when I'm all done, but you can save in other places providing it's secure)). Make sure you check the box Column names in the first data row
+  1. Select Copy Data > Next
+    1. Table is [dbo].[TBD_ObservationsViewForFlo_B]
+    1. Row del is {LF}
+    1. Column del is Vertical Bar {|}
+1. Copy to the Statshub folder as follows, Fire up Chrome browser and open https://myfiles.le.ac.uk/myfiles
+  1. browse to Departmental-X-Drive\Cardiovascular Sciences\LCBRU\Statshub
+  1. Select upload (top of the window next to the folders icon) and browse to where you saved the file then select upload in the uploading of multiple files window.
+  1. remember to delete the file from your desktop (or other locations).
+  1. Get your self a cuppa (takes about 20 mins).
+
+
+
 [[BackLinks]]