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.