B Oracle Argus Analytics Presentation Catalog

The Oracle Argus Analytics Presentation Catalog displays columns that you can use to create requests.

This appendix contains the following topics:

Dimensions in Oracle Argus Analytics Presentation Catalog
Facts and Sources in Oracle Argus Analytics Presentation Catalog

Dimensions in Oracle Argus Analytics Presentation Catalog

Table B-1 describes the Dimensions displayed in the Oracle Argus Analytics Presentation Catalog. For each column, it shows the name of the Column, its description, and the Dimension containing the column. The table is sorted by Dimension, and by Column within Dimension. This corresponds to how the Dimension columns are organized in the Presentation Catalog.

Please note that some columns have been de-normalized, so that they appear in more than one Dimension. This de-normalization speeds query execution by eliminating the need for a join to that column in another Dimension. It also supports the ability to constrain columns in a Prompt, so that when you select a value in one column, the other columns are constrained to those related to your selection. When you select a de-normalized column from a Dimension, your results will be limited to the grain of the Dimension.

Table B-1 Presentation Catalog - Dimensions

Dimension	Column	Description
Case Processing Site	Case Processing Site	Case Processing Site that the user belongs to.
Enterprise	Enterprise ID	CRO Enterprise (Client) Short Name
Enterprise	Enterprise Name	Enterprise Name
Period	Year	Per_name_year From W_day_d Table
Period	Quarter	Per_name_qtr From W_day_d Table
Period	Month	Per_name_month From W_day_d Table
Period	Week	Per_name_week From W_day_d Table
Period	Day	Calendar_date From W_day_d Table
Product	Product Group	Therapeutic Alignment Of User Groups By Product Indication (For Example, Oncology Group, Gynecology Group Etc)
Product	Product Family	Product Family - It is used to group Like products that share Datasheets and Primary Ingredients.
Product	PSUR Group	PSUR Group Name
Product	Product Name	Product Name
Product	Product Formulation	Formulation of the Product
Product	Product Concentration	Concentration/Strength of the Product
Study	Study ID	Study ID
Study	Project ID	Project ID for Study
Product	Generic Name	Generic Name of the Product
License	Product Name	Product Name
License	Product Formulation	Formulation of the Product
License	Product Concentration	Concentration/Strength of the Product
License	License ID	Product License Number
License	License Type	Product License Type (like Marketed Drug, Investigational Vaccine etc.)
License	License Name	Concatenated value of license trade name, license authorization country and license number displayed as - trade name \|\| ' (' \|\| country\|\| ') ' \|\| license number
License	License MAH	Manufacturer of the licensed product
License	License Country	Country of license award
License	CTPR Group	CTPR Group Name
License	Trade Name	Trade Name
Report Destination	Report Destination Country	Country of destination to which the report is submitted
Report Destination	Report Destination	Destination to which the report is submitted

Facts and Sources in Oracle Argus Analytics Presentation Catalog

This section contains an embedded Excel sheet that lists the Facts and Sources displayed in the Oracle Argus Analytics Presentation Catalog.

For each Column, it shows the name of the Column, its description, and the Fact and Group within the Fact that contain the Column. The sheet is sorted by Group and Column, within Fact.

This corresponds to how the Fact columns are organized in the Presentation Catalog, within the Fact folder. The embedded Excel sheet also describes how Oracle Argus Analytics populates each column from an Oracle Argus Safety database.

To view the table in the embedded Excel sheet, double-click this paperclip icon. Alternately, you can also right-click the icon and click Open File.

To save the Excel sheet to your local machine, right-click the icon and click the Save Embedded File to Disk... option.