/
Data Fetch

Data Fetch

Owned by Gurpreet Kaur Saimy
Last updated: Aug 30, 2024
1 min read

  • Currently, data is extracted from excel sheets stored in dummydata folder

  • Connection to oncore database is yet to be established

  • Following data is stored in excel sheets:

    • Department

    • Staff - Primary Investigator & Study Coordinator

    • Research Protocols (IRB Num)

    • Month wise actual accrual count grouped by IRB Num

    • Research Protocol & accrual details

  • Queries to fetch required data and invalid data can be found in sqlqueries folder

Data

Excel Sheet Name

Data

Excel Sheet Name

Department

dept_excel_filtered.xlsx

Staff (PI & SC)

staff_excel_filtered.xlsx

All research protocols

protocols_filtered.xlsx

Protocol Accrual Details

accrual_details.xlsx

Protocol Accrual Count Data

accrual_count.xlsx

 

Steps to fetch data -

 

  1. Queries can be found in sqlqueries folder

  2. Run the query in sql developer

  3. Once data is displayed in sql developer, right click to export data & select xlsx option & directory path to store the excel

  4. Use the excel names as mentioned in above table

  5. store the excel in dummy data folder

Related content