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 |
Parent topic: Data Mining Table Schema