2024-10-10

• Curimeta access
  • No more table level permissions
  • Need to migrate to schema level permissions
  • 2 tables pending request
• Jenny Gurney crosswalk project
  • Pending info from Jenny
  • Snehil asked to be kept in the loop
• OMOP on postgres
  • Details: Chris L auto views
  • Maybe do a one time ingest to postgres for demo
  • Linying is approved to view all OMOP
• OMOP on Databricks
  • Send links to Snehil

2024-09-12

• ArcGIS data into synthetic data?
  • first 3 of zip is considered identifiable
  • census blocks may be considered identifiable
  • how do users get access for research
    • need to request actual data, not MDClone data
    • IRB required for geocoded data
    • what should we expose?
      • Just ADI should be fine
      • geocoded data should NOT be included
• During audit, who approves clarity finance data?
  • needs to be approved through governance group
  • if internally then Snehil and Bri can approve
  • we only have wash u financials, if they need BJC they need to ask EPIC1
  • trigger extra approval to governance team
• Regulatory Review
  • Can we ingest IRB data to use in auditing and intake review
  • Users can send screenshots of IRB if needed
• TriNetx
  • no approval needed
    • must be wash email
    • active employees
  • wustlkey may be possible?
  • mostly for getting counts
  • if they want cohort data, then they will need intake/review
  • cost to use?
    • no cost
    • exporting ids is a paid activity
    • exporting data requires IRB approval
    • needs to come through intake for review
• EnAct
  • DW originally managed i2db shrine, but was never used
  • DW did ETL work and infrastructure
  • Who at WU is assigned to what roles?
  • Helpdesk support
    • Documentation provided that we can send to users
    • Need information of what data is in there etc on the service page
      • No data before 2010
      • GCP cohort
      • at least 1 encounter since 2010, and other business rules
      • how are encounters defined
      • FAQs section
        • numbers etc.
      • MU date shifts data on their end, may account for discrepancies
    • Request access
    • Add an intake form
    • Funding ICTS?
      • do we need an act project in TT?
• MDClone ETL Migration