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.