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 _DM, _DMV, and _DMD views (for example, SM_CASE has SM_CASE_DM, SM_CASE_DMV, and SM_CASE_DMD ), which restrict the data to just the records in cases that qualify as all cases for data mining, vaccine cases for data mining, or drug cases for data mining. The criteria for those cases are defined by Argus Mart’s INCLUDE_DM_YN and INCLUDE_DM_VACC_YN flags.
Parent topic: Oracle Argus Mart Data Tables and Views