Summary Table Metadata Refresh Queries

This documentation references PopMedNet 2021.1 +

For version 5.0 documentation, please see PopMedNet User's Guide v5.0

PopMedNet User's Guide

Based on version 2021.1 +

Summary Table Metadata Refresh Queries

DataMart Administrators with Summary Tables may submit special Summary Table Metadata Refresh queries to their own DataMarts. These queries check the data availability of the Summary Table database. 

The queries should be run each time that your site updates its Summary Table database. Note that if your site has multiple DataMart Administrators, these queries only need to be run by one user.

Follow the steps below to submit a Summary Table Metadata Refresh Query.

  1. Log in to your network web portal / query tool.
  2. Click the New Request button in the Requests panel.
  3. Select a project in which to run the queries. If you are running these queries as part of the Sentinel Summary Table ETL process, select: Sentinel
  4. Select the Inci Metadata: Refresh Dates request type to open the request composer page.
  5. Ensure that your DataMart is selected in the routing panel and click Submit. No other metadata need to be entered.
  6. Respond to the query via your DataMart Client.
  7. Repeat steps 2-6 twice more, once for MFU Metadata: Refresh Dates and once for Prev Metadata: Refresh Dates.

Request Composer Page - Summary Table Metadata Refresh Query

Contact Us

PopMedNet Service Desk