Oracle Argus Mart Additional Views

SM_PRODUCT table has a view that excludes records for concomitant drugs.

Table or View Name	Suspect?	Concomitant?
SM_PRODUCT table	Y	Y
SM_PRODUCT_S view	Y	-

SM_EVENT_PLUS_SMQ table views exclude or include different SMQs:

Table or View Name	PTs	Narrow SMQs?	Broad SMQs?	Alg. SMQs?
SM_EVENT_PLUS_SMQ table	Y	Y	Y	Y
SM_EVENT_PLUS_SMQ_NARROW view	Y	Y	-	-
SM_EVENT view	Y	-	-	-

Every table and view has a _SPONT view (for example, SM_CASE has SM_CASE_SPONT) which restricts the data to just the records in cases that qualify as spontaneous. The criteria for spontaneous cases is established when signal management is installed and the default is REPORT_TYPE_VE in ('SPONTANEOUS , 'LITERATURE').