Database & Methods Cyberseminar Series
Database & Methods Cyberseminar SeriesMeet VIReC: The Researcher’s Guide to VA DataDecember 3, 2018Maria Souden, MSI, PhDActing Director, VA Information Resource Center
2Database & Methods Cyberseminar SeriesInformational seminars to help VA researchersaccess and use VA databases.Topics VA data sources & data access systems Application of VA data to research and qualityimprovement questions Limitations of secondary data use Resources to support VA data use12/2018
3FY19 Database & Methods ScheduleVisit HSR&D’sVIReC CyberseminarArchive to watch cyberseminars/catalogarchive-virec.cfmVisit our Education pageon the Internet to registerfor an upcoming session:First Monday of the month* 1:00pm-2:00pm ETDate10/1/2018Overview of VA Data & Research Useshttps://www.hsrd.research.va.gov/for researchers/cyber seminars/archives/video archive.cfm?SessionID 3531Requesting Access to VA Data11/5/2018https://www.hsrd.research.va.gov/for researchers/cyber seminars/archives/video archive.cfm?SessionID 354012/3/2018Meet VIReC1/7/2019VA Pharmacy Datawww.virec.research.va.govTo disseminate your workor share suggestions forfuture sessions, emailHira 06778090754Mortality Ascertainment & Cause of 0818125004410370VA Medicare Data 2611881469612799746Race & Ethnicity 758840001084674Additional topics TBA for May 2019 and beyond!*Schedule shifts by one week in event of VA holiday.12/2018
Database & Methods Cyberseminar SeriesSession 3 - Meet VIReC: The Researcher’sGuide to VA Data
5Provide an overview of VIReC, our products,our services, and our Web environments.Today’s objective12/2018
6By the session’s end, you should be able to 1. Describe VIReC activities and value to the research &quality improvement communities.2. Understand key VIReC product types and their use insupporting work with VA data.3. Navigate VIReC’s web environments and locateVIReC resources online.4. Know where to go for additional questions andcustomer service.12/2018
7Poll #1: Your role as a data user What is your role in research and/or quality improvement? Investigator, PI, Co-I Data manager, analyst, or programmer Project coordinator Other – please describe via the Q&A function12/2018
8Poll #2: Your experience with VA dataHow many years of experience do you have working withVA data? One year or less More than 1, less than 3 years At least 3, less than 7 years At least 7, less than 10 years 10 years or more12/2018
9Session roadmap for Meet VIReC Who are we & what do we do? Staff & mission Relationship to VINCI Areas of activity Improving the data environment Special projects Data knowledge & dissemination VIReC products & websites (tour) Where to go for more help12/201810/2018
10Who is VIReC?Core StaffNameKey AreasNameKey AreasChandrea Culbreath, MPH, BSNCustomer Svc LeadDissem, QUERI, ClinicalData, InformaticsLinda Kok, MAData Policy & AccessGoal 3 Lead, Real SSN,Data Systems & SharingKristin de Groot, MPHVA/CMS Technical DirData Services, DataTranslation, OMOPBonnie Paris, PhDVA REDCap LeadForums, Data Translation,PharmacyMargaret Gonsoulin, PhDAssociate DirectorGoal 1 Lead, Ops, CDW,Methods, QUERI, EHRMDharani Ramanathan, MPHAnalystData Translation, CDW,Data Services, AnalysisMeghan Grum, MSCoordinatorAdmin, VA/CMS Requests,TravelMaria Souden, PhDPI/Acting DirectorGoal 2 Lead, Ops, QUERI,VA/CMS, Forums PIDolores IppolitoCoordinatorVA/CMS Requests, RealSSN, Admin, IRBJenifer Stelmack, MSWDissemination LeadForums Lead, Web, Editing,CORLindsey Jones, MPHAnalystData Translation, CDWAmanda Taylor, PhDVA/CMS Project MgrVA/CMS Requests & Policy,ACE, Data TransMelissa Joyce, MPHAdministrative OfficerOps, Admin, QUERI,VA/CMS Policy, RecordsKatrine Weismantle, MSWCoordinatorVA/CMS RequestsDonghui Kan, MSAnalystVA/CMS Repository & DataServicesPuling Zhang, MAAnalystVA REDCap, DataTranslation, AdminHira Khan, MPHEducation LeadDissem, Forums, Web, InfoDesign, AdminQiuying (Lucy) Zhang, MSAnalystVA/CMS, ACE, DataServices, AnalysisIPAs & Scientific AdvisorsAkanksha AggarwalPeter Addy, PhDCathy Blake, PhDRamon Durazo-Arvizu, PhDForums, Usability,Analytics, Data ScienceVA REDCap, Primary DataCollectionInformatics, Data Sci, InfoRetrieval, ForumsStatistical Consulting &AnalysisCharlesnika Evans, PhD, MPHHealth Services Research,Microbiology Data, EpiJoo Ho LeeForums, Analytics, NLPDenise Hynes, PhD, MPH, RNCommunity Care, VA/CMSSethi, ShivankitForums, User ExperienceDesign, User Testing
11What do we do?MissionTo advance VA capacity to use data effectively for research and quality improvementand to foster communication between data users and the VA healthcare community.ActivitiesDEVELOPDISSEMINATEIMPROVEdata knowledge and methodsdata knowledgedata access and availabilityFactbooks and User GuidesIntranet websiteSummary informationVHA Data PortalTechnical documentationCyberseminars(hosted by CIDER)Advocate on nationalcommittees & workgroups(collaboration with NDS & VINCI)Real SSN request reviewsHelpDesk 1:1 consultationVA/CMS* Data for ResearchHSRData ListservVA REDCap***VA/CMS Veteran data from Centers for Medicare & Medicaid** VA REDCap VA Research Electronic Data CaptureFunded by VA Health Service Research & Development (HSR&D)12/2018
12VIReC Mission and Areas of ActivityMissionTo advance VA capacity to use data effectively for research and quality improvementand to foster communication between data users and the VA healthcare community.ActivitiesDEVELOPDISSEMINATEIMPROVEdata knowledge and methodsdata knowledgedata access and availabilityFactbooks and User GuidesIntranet websiteSummary informationVHA Data PortalTechnical documentationCyberseminars(hosted by CIDER)Advocate on nationalcommittees & workgroups(collaboration with NDS & VINCI)Real SSN request reviewsHelpDesk 1:1 consultationVA/CMS* Data for ResearchHSRData ListservVA REDCap***VA/CMS Veteran data from Centers for Medicare & Medicaid** VA REDCap VA Research Electronic Data CaptureFunded by VA Health Service Research & Development (HSR&D)12/2018
13What is the relationshipbetween VIReC and VINCI?12/2018
14VA Informatics and Computing Infrastructure Secure data environment High-speed processing platform Workspace with data management andanalytic tools Tool development – NLP, chart review,cohort, and PTR VINCI services – data provisioning,conciergeVINCI Central Websitehttp://vaww.vinci.med.va.gov/vincicentral/ (VA Intranet)12/2018
15VIReC & VINCI CommonalitiesSimilar Services Information about datacontents and availability Education and training onrespective topics Help with specific data useissues and problems Data advocacy andavailabilityCollaborative Projects Specific education and outreachinitiatives Data Access Request Trackerimprovements Data centralization National Committees, e.g.,EHRM Policies for data sharing and re-use (with ORD) VA/CMS – OMOP datatransforms12/2018
16Complementary roles supporting CDW data useBISLNDSVINCIVIReCBusinessIntelligenceService LineNational DataSystemsVA Informatics& ComputingInfrastructureVA Data Knowledge& EducationBuild the datawarehouse thatorganizes dataGrants access toCDW dataProvisioning &Working withDataHost derived datasets on CDWserversUpdate, maintainAppropriate useand oversightPolicy andpermissions focusCreates subsetsof CDW data forapproved projectsMaintainsworkspace & toolsfor using dataDocuments CDWdomainsCreatesmethodological &technical guidesHelpDesk &listserv12/2018
17Session roadmap for Meet VIReC Who are we & what do we do? Staff & mission Relationship to VINCI Areas of activity Improving the data environment Special projects Data knowledge & dissemination VIReC products & websites (tour) Where to go for more help12/201810/2018
18VIReC Mission and Areas of ActivityMissionTo advance VA capacity to use data effectively for research and quality improvementand to foster communication between data users and the VA healthcare community.ActivitiesDEVELOPDISSEMINATEIMPROVEdata knowledge and methodsdata knowledgedata access and availabilityFactbooks and User GuidesIntranet websiteSummary informationVHA Data PortalTechnical documentationCyberseminars(hosted by CIDER)Advocate on nationalcommittees & workgroups(collaboration with NDS & VINCI)Real SSN request reviewsHelpDesk 1:1 consultationVA/CMS* Data for ResearchHSRData ListservVA REDCap***VA/CMS Veteran data from Centers for Medicare & Medicaid** VA REDCap VA Research Electronic Data CaptureFunded by VA Health Service Research & Development (HSR&D)12/2018
III. Improve the data environmentWe collaborate withVA data stewards andprogram offices toenhance dataavailability and toaddress issuesaffecting research thatuses data andinformation systems. Increase availabledata Streamline dataaccess Improve time to “gotmy data” Support data re-use Educate on data policy12/2018
20Special projects to enhance data environment VA/CMS Data for Research- repository, provisioning,governance OMOP mapping of VA/CMS data Manage and support VA REDCap Review of research requests for data with Real SSNs forORD12/2018
21National committees & workgroups Electronic Health RecordModernization, aka Cernertransition(data availability, access) Data Access RequestTracker (DART) workgroup(data availability, access,timeliness) Capability management andgovernance boards (dataavailability) 1200.12 revisions with Officeof Research & Development(data governance, re-use) Research Data Repositories(data governance, re-use) Work with data stewards,program offices on behalf ofresearch and QI data users(data availability, access,timeliness, re-use)12/2018
22Goal III Exemplar: VIReC Participation inElectronic Health Record Modernization (EHRM)Maintaining our Mission in a Shifting Environment
Cerner’s Impact on Data Users Data availability & use: TBD which Cerner data will be sentback to VA and in what form National reports and datasets may be incomplete once the firstlocation goes to Cerner Cerner data will differ in content, organization andstructure, so data users will need: Documentation of the mapping of VA data to Cerner HealtheIntent Definitions of VA Cerner data domains, tables, columns etc. Information about Cerner’s EHR for chart review purposes End users will likely need new technical skills / computerskills, such as: R, Python & SQL (on HP Vertica Analytics Platform)23
2424VIReC EHRM ParticipationChief MedicalOffice (CMO)Side –FunctionalReq’tsTechnologyInnovationOffice (CIO)Side –TechnicalReq’ts Quality, Safety & Value Clinical Council Detail –Research Workgroup Reports, Registries, & Research DataCollaborative Regulatory Workgroup Data Migration & Management Group Detail Data Resources & Analytics CapabilitiesManagement Board, Data Subcommittee VA/DoE Enterprise Architecture Workgroup Research & Education CapabilitiesManagement Board
Planning for the FutureVIReC plans to transform this participation into: Advocacy for the needs of research and quality improvement datausers A strategic plan renewal that lines up with the first Cer
experts in the field to create a . knowledge base of factual and evaluative information . about VA data and information systems. Data content and structure Context of collection How it’s been transformed, organized
VHA QUERI Cyberseminar . THE FEAR. LESS . ORGANIZATION . CREATING PSYCHOLOGICAL SAFETY FOR LEARNING, INNOVATION & GROWTH . Amy C. Edmondson, PhD . Harvard Business School
SMB_Dual Port, SMB_Cable assembly, Waterproof Cap RF Connector 1.6/5.6 Series,1.0/2.3 Series, 7/16 Series SMA Series, SMB Series, SMC Series, BT43 Series FME Series, MCX Series, MMCX Series, N Series TNC Series, UHF Series, MINI UHF Series SSMB Series, F Series, SMP Series, Reverse Polarity
Database Applications and SQL 12 The DBMS 15 The Database 16 Personal Versus Enterprise-Class Database Systems 18 What Is Microsoft Access? 18 What Is an Enterprise-Class Database System? 19 Database Design 21 Database Design from Existing Data 21 Database Design for New Systems Development 23 Database Redesign 23
Getting Started with Database Classic Cloud Service. About Oracle Database Classic Cloud Service1-1. About Database Classic Cloud Service Database Deployments1-2. Oracle Database Software Release1-3. Oracle Database Software Edition1-3. Oracle Database Type1-4. Computing Power1-5. Database Storage1-5. Automatic Backup Configuration1-6
Creating a new database To create a new database, choose File New Database from the menu bar, or click the arrow next to the New icon on the Standard toolbar and select Database from the drop-down menu. Both methods open the Database Wizard. On the first page of the Database Wizard, select Create a new database and then click Next. The second page has two questions.
Clinical example of use of extracted PFT data . 3 07/2018 . Poll Question #1 . 4 07/2018 . I am interested in VA data primarily due to my role as: a. Principal investigator/CoPI- b. . Text Integration Utilities (TIU) free-text data used to create Structured Query Language (SQL)-based tool .
10 Deploying Oracle 12c RAC Database on Dell EMC XC Series All-Flash 3110-BP-SDS 2.1.2 Oracle RAC database configuration Oracle RAC allows running multiple database instances on multiple servers in the cluster against a single database. The database spans multiple servers but appears as a single unified database to end-user applications.
(OSH Act) standards because they were rarely exposed to construction jobsite hazards. However, with the increasing roles that designers are playing on worksites, such as being part of a design-build team, it is becoming increasingly important that they receive construction safety training, including information about federal and state construction safety standards. The Occupational Safety .
