The system currently supports a number of request types:
- Summary Table Queries - menu-driven queries that execute against Sentinel Common Data Model Summary Table databases
- ESP Requests - menu-driven queries that execute against ESP: MDPHnet databases
- File Distribution Requests - used to exchange documents between the Portal and DataMarts
- Menu-Driven Queries (MDQs) - easy-to-use tool that executes against the PCORnet Common Data Model in all supported relational database management systems (RDBMS). Query returns patient counts based on the set of criteria selected.
- Modular Program Distribution Requests - used to distribute modular program packages and results between the Portal and DataMartsSQL Distribution Requests - used to distributed raw SQL between the Portal and DataMarts
- /wiki/spaces/DOC/pages/8880343 - menu-driven queries that execute against Data Checker tables, created from data quality review and characterization output
- /wiki/spaces/DOC/pages/8880341 - menu-driven queries that search information about Requests, Organizations, DataMarts, and Registries within a network.
- Queries composed from a number of external applications, such as i2b2, that use a native interface to compose a query and submit it to a PopMedNet network
- Custom request types: Custom request types contain the elements below. Only administrators at designated network operating centers have the ability to create request types.
- Workflow: The steps involved in the request
- Data Model: The network data model it supports
- Data Adapter Detail: The specific sub-model for a particular network data model. ( For Sentinel summary tables, data model = Sentinel Summary Table, data adapter detail = prevalence, etc)
- Interface: The interface used by the request; it could be the MDQ interface or standard file distribution.