Common Queries (lexicals) Used in Reports
The following queries are available in the package header
pkg_agg_rpt
.
Table 6-3 pkg_agg_rpt Queries
Value | Description |
---|---|
Q_MESSAGE |
Returns all WARNING type log messages that appear in the trailer section Warning Messages. |
Q_ERROR |
All ERROR type messages appear in trailer page under Error Messages section. |
Q_CASES |
Lists Cases of only Main Case series from the BIP tables RPT_AGG_CASE_SERIES and RPT_AGG_CS_CASES on the Cover page. |
Q_REPORTCASESUMMARY |
Returns Totals section on the Trailer page. The Total of valid and invalid case count appears (only cases from MAIN CASE SERIES are considered). |
Q_WMARK |
Populates water marks for the reports. For example, DRAFT, INTERNAL. |
Q_MODCS |
Case Series Modification history appears on the cover page for all BIP reports. |
Q_HEAD |
Fetches reg_report_id, report title, report hash, report footer, report from and to date, Previous date and DLP/Non-DLP values for printing on the Cover page as headers. |
Q_TITLE |
Defines titles for the DSUR Main line listing and Cumulative Summary tabulations based on the parameter Print Serious Adverse Events or Reactions. |
The following queries are used in QA sections of the reports.
Table 6-4 QA Section Queries
Element | Description |
---|---|
Q_QA1 |
Lists case numbers without any qualifying drugs. Considers all cases not available in the GTT_RPT_AGG_DRUG table but available in GTT_RPT_AGG_CASE. |
Q_QA2 |
Lists Case numbers without any qualifying events. Considers all cases not available in the GTT_RPT_AGG_EVENT table but available in GTT_RPT_AGG_CASE. |
Q_QA3 |
Lists Case numbers with undefined case level unlabeledness. Considers all cases with the column GTT_RPT_AGG_CASE.CASEUNLABELEDNESSCODEvalue set to NULL. |
Q_QA4 |
Lists Case numbers with undefined event level unlabeledness. Considers all cases with the column GTT_RPT_AGG_EVENT.EVENTUNLABELEDNESSCODE value set to NULL. |
Q_QA5 |
Lists Case numbers with undefined Case level seriousness. Considers cases with column GTT_RPT_AGG_CASE.CASESERIOUSFLAG value set to NULL. |
Q_QA6 |
Lists Case numbers with undefined Event level seriousness. Considers cases with column GTT_RPT_AGG_EVENT.EVENTSERIOUSFLAG value set to NULL. |
Q_QA7 |
Lists the Labels configured for drugs in the drug list. The query is different for PMAR, PBRER and DSUR and is available in the data models. |
Q_QA9 |
Lists Non-Clinical Case numbers (where the column GTT_RPT_AGG_CASE.CASETYPE !='C') |
Q_QA13 |
Summary of Unlocked Cases. |
Q_QA14 |
Cases with Missing Assessment. |
Parent topic: Case Series Tables