SM_EVENT_PLUS_SMQ_NARROW View

The SM_EVENT_PLUS_SMQ_NARROW view on the SM_EVENT_PLUS_SMQ table is created using a SQL WHERE clause.

The SM_EVENT_PLUS_SMQ_NARROW view on the SM_EVENT_PLUS_SMQ table is created using the following SQL WHERE clause:

WHERE INCLUDE_YN = 'Y' AND (EVENT_TYPE = 'PT' OR (EVENT_TYPE = 'SMQ' AND IS_NARROW = 'Y')

As a result, the PT_plus_Narrow_SMQ variable offered by this view includes MedDRA preferred terms and narrow standardized MedDRA queries for data mining. Information about the Oracle Empirica Signal configuration variables from the SM_EVENT_ PLUS_SMQ_NARROW view follows.

Configuration Variable	Column	Description
(Event/Narrow SMQ) Case Number	CASE_NUM	Case number
(Event/Narrow SMQ) PT_plus_ Narrow_SMQ	EVENT_PT	PT or Narrow SMQ Name
(Event/Narrow SMQ) Term Type	EVENT_TYPE	Type of term: PT/SMQ
(Event/Narrow SMQ) ValidEnd	VALIDEND	Valid end date
(Event/Narrow SMQ) ValidStart	VALIDSTART	Valid start date