Tables
Tables in the BIP schema populate the case data:
- Global Temporary tables (GTT) temporarily store data for report output generation. These are the only tables used in the BIP data model.
- RM_ tables store persist data and are copies of the GTT tables. The system stores parameters in these tables based on the Persist data.
- Configuration tables handle parameters and transactions.
- SUPPORT tables store information such as parameters and their values, case series details, and BIP job details.
Table 4-1 provides the list of tables in the BIP Owner schema and their users.
Table 4-1 List of Tables in BIP Owner Schema
Table Name | Type | Purpose |
---|---|---|
RPT_AGG_PARAMS |
SUPPORT |
Stores the list of parameters that are passed down to run the report. |
RPT_AGG_CASE_SERIES |
SUPPORT |
Stores case series information. |
RPT_AGG_CS_CASES |
SUPPORT |
Stores all cases in the case series that are selected for BIP report generation. For example, Main case series, Cumulative case series, Section 6.2 case series, Ad hoc1 case series, and so on. |
RPT_AGG_BIP_JOB |
SUPPORT |
Stores BIP job information and other transactional data. This table data is retained without purging. |
GTT_RPT_AGG_CASE |
Global Temp |
Stores case information. |
GTT_RPT_AGG_DRUG |
Global Temp |
Stores drug related information. |
GTT_RPT_AGG_EVENT |
Global Temp |
Stores event related information. |
GTT_RPT_AGG_EV2DRUG |
Global Temp |
Stores event to drugs related assessment details. |
GTT_RPT_AGG_HEALTHAUTHID |
Global Temp |
Stores health authority details. |
GTT_RPT_AGG_UNIQ_CASES |
Global Temp |
Maintains a list of unique cases. |
GTT_RPT_AGG_DET_LIST |
Global Temp |
Temporary support table that fetches assessment data. |
GTT_RPT_AGG_DRUGNAMES |
Global Temp |
Stores the drug names for reporting. |
GTT_RPT_AGG_BIP_BLOB |
CONFIG |
Copies and holds the report output blob between the BIP Owner schema and the BIP Metadata repository database. |
RPT_AGG_JOB_EXEC_STS |
CONFIG |
Used to avoid multiple report jobs fetching the report output at the same time. |
RM_RPT_AGG_CASE |
PERSIST |
Persist table for GTT_RPT_AGG_CASE. |
RM_RPT_AGG_DET_LIST |
PERSIST |
Persist table for GTT_RPT_AGG_DET_LIST. |
RM_RPT_AGG_DRUG |
PERSIST |
Persist table for GTT_RPT_AGG_DRUG. |
RM_RPT_AGG_DRUGNAMES |
PERSIST |
Persist table for GTT_RPT_AGG_DRUGNAMES. |
RM_RPT_AGG_EV2DRUG |
PERSIST |
Persist table for GTT_RPT_AGG_EV2DRUG. |
RM_RPT_AGG_EVENT |
PERSIST |
Persist table for GTT_RPT_AGG_EVENT. |
RM_RPT_AGG_HEALTHAUTHID |
PERSIST |
Persist table for GTT_RPT_AGG_HEALTHAUTHID. |
RM_RPT_AGG_PARAMS |
PERSIST |
Persist table for RPT_AGG_PARAMS. |
RM_RPT_AGG_UNIQ_CASES |
PERSIST |
Persist table for GTT_RPT_AGG_UNIQ_CASES. |
RPT_AGG_PARAMS |
SUPPORT |
Stores the list of parameters that are passed down to run the report. |
RPT_AGG_CASE_SERIES |
SUPPORT |
Stores case series information. |
RPT_AGG_CS_CASES |
SUPPORT |
Stores all cases of the case series that are selected for BIP report generation. For example, Main case series, Cumulative case series, Section 6.2 case series, Ad hoc1 case series, and so on. |
RPT_AGG_BIP_JOB |
SUPPORT |
Stores BIP job information and other transactional data. Table data is retained without purging. |
GTT_RPT_AGG_CASE |
Global Temp |
Stores case information. |
GTT_RPT_AGG_DRUG |
Global Temp |
Stores drug related information. |
GTT_RPT_AGG_EVENT |
Global Temp |
Stores event related information. |
GTT_RPT_AGG_EV2DRUG |
Global Temp |
Stores event to drugs related assessment details. |
GTT_RPT_AGG_HEALTHAUTHID |
Global Temp |
Stores health authority details. |
GTT_RPT_AGG_UNIQ_CASES |
Global Temp |
Maintains a list of unique cases. |
GTT_RPT_AGG_DET_LIST |
Global Temp |
Temporary support table that fetches assessment data. |
GTT_RPT_AGG_DRUGNAMES |
Global Temp |
Stores drug names for reporting. |
GTT_RPT_AGG_BIP_BLOB |
CONFIG |
Copies and holds the report output blob between the BIP Owner schema and the BIP Metadata repository database. |
RPT_AGG_JOB_EXEC_STS |
CONFIG |
Used to avoid multiple report jobs fetching the report output at the same time. This table should not contain any row when the reports are not running. If it does, the completed reports will not be pushed back into Oracle Argus Safety database. |
RM_RPT_AGG_CASE |
PERSIST |
Persist table for GTT_RPT_AGG_CASE. |
RM_RPT_AGG_DET_LIST |
PERSIST |
Persist table for GTT_RPT_AGG_DET_LIST. |
RM_RPT_AGG_DRUG |
PERSIST |
Persist table for GTT_RPT_AGG_DRUG. |
RM_RPT_AGG_DRUGNAMES |
PERSIST |
Persist table for GTT_RPT_AGG_DRUGNAMES. |
RM_RPT_AGG_EV2DRUG |
PERSIST |
Persist table for GTT_RPT_AGG_EV2DRUG. |
RM_RPT_AGG_EVENT |
PERSIST |
Persist table for GTT_RPT_AGG_EVENT. |
RM_RPT_AGG_HEALTHAUTHID |
PERSIST |
Persist table for GTT_RPT_AGG_HEALTHAUTHID. |
RM_RPT_AGG_PARAMS |
PERSIST |
Persist table for RPT_AGG_PARAMS. |
RM_RPT_AGG_UNIQ_CASES |
PERSIST |
Persist table for GTT_RPT_AGG_UNIQ_CASES. |
For details about tables, columns, and column mappings with Oracle Argus Safety, refer to the Argus Flexible Reporting Data Model.xls.
Parent topic: Database Architecture