The Oracle Argus Analytics Presentation Catalog displays columns that you can use to create requests.
This appendix contains the following topics:
See Also:
Chapter 3, "Working with Reports"
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 |
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.