Oracle® Argus Insight

CMN Profile Enterprise Table Guide

Release 8.1.1

E90558-01

September 2017

Oracle Argus Insight CMN Profile Enterprise Table Guide, Release 8.1.1

E90558-01

Copyright © 2010, 2017, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

- Where to Find More Information

- Documentation Accessibility

1 Introduction

- 1.1 Internal Use Rows

- 1.2 About the Columns in the CMN_PROFILE_ENTERPRISE Table

- 1.3 Examples of Modifying the CMN_PROFILE_ENTERPRISE Table

2 SYSTEM Profile Enterprise Switches

- 2.1 ACCEPTABLE_ROUTING_JUSTIFICATION_FIELD_ID

- 2.2 ACCEPTABLE_SUBMISSION_JUSTIFICATION_FIELD_ID

- 2.3 ARGUS_MART_DB_NAME

- 2.4 ARGUS_MART_USER_NAME

- 2.5 ARGUS_MART_USER_PASSWORD

- 2.6 ARGUS_SAFETY_URL

- 2.7 AUTOE_P_E_TERM_DIC

- 2.8 AUTOE_P_SUS_D_DIC

- 2.9 BI_ANSWERS_WEB_URL

- 2.10 BIP_WEB_URL

- 2.11 BO_WEB_URL

- 2.12 CASE_REFERENCE_TYPE_ID

- 2.13 CAUSALITY_ASSESSMENT_C

- 2.14 CAUSALITY_ASSESSMENT_R

- 2.15 CAUSALITY_ASSESSMENT_R_C

- 2.16 CAUSALITY_ASSESSMENT_UDFIELD

- 2.17 COGNOS_WEB_URL

- 2.18 CONFIDENTIALITY

- 2.19 CORE_SITE

- 2.20 CORPORATE_LOGO_PATH

- 2.21 CUSTOM_HELP_URL

- 2.22 DATASHEET_BPI

- 2.23 DATASHEET_EMEA

- 2.24 DATASHEET_IB

- 2.25 DATASHEET_PI

- 2.26 DATA_SOURCE

- 2.27 DISPLAY_ENTERPRISE_SHORT_NAME

- 2.28 DLL_SLL_REPORTS_TABLE_POPULATION

- 2.29 DMS_MEDDRA_USER

- 2.30 DMS_WHO_USER

- 2.31 ENABLE_COMPANY_HOLIDAY

- 2.32 ESM_TABLE_POPULATION

- 2.33 EVENT_CAUSALITY_FIELD

- 2.34 FAILED_RECIPIENTS_STATUS_EMAIL_ADDRESS

- 2.35 FOLLOWUP_ACTION_CODE

- 2.36 KEEP_REPORT_DATA

- 2.37 LAM_TABLE_POPULATION

- 2.38 LICENSE_PARTY_STARTING_CODE

- 2.39 LL_REPORTS_DATASHEET

- 2.40 LL_REPORTS_TABLE_POPULATION

- 2.41 LOCKED_DAYS

- 2.42 MEDDRA_POPULATION

- 2.43 POPULATE_NARRATIVE_LANGUAGES_TABLES

- 2.44 POPULATE_RPT_REG_REPORTS_COLUMNS

- 2.45 PRODUCT_LOGO_PATH

- 2.46 PROXY_AUTO_DETECT

- 2.47 PROXY_HOST

- 2.48 PROXY_PASSWORD

- 2.49 PROXY_PORT

- 2.50 PROXY_TYPE

- 2.51 PROXY_USER

- 2.52 RESET_PASSWORD

- 2.53 SSL_START_MODE

- 2.54 STUDY_RECONCILIATION_TABLE_POPULATION

- 2.55 SUPPLIER_FIELD_ID

- 2.56 UDN_COL_FOR_SUPPLIER_NAME

- 2.57 WHO_DRUG_BROWSER_FORMAT

- 2.58 WHO_DRUG_POPULATION

3 DATABASE Profile Enterprise Switches

- 3.1 CHANGE_CONFIG_RC_UD

- 3.2 CHANGE_CONFIG_WF

- 3.3 DATASHEET_FLAG

- 3.4 DELAY_IDENTIFIER

- 3.5 DMS_WHO_DRUG_QUERY

- 3.6 DMS_WHO_DRUG_QUERY_ING

- 3.7 EMAIL_SENDER_ADDRESS

Preface

The Oracle Argus Insight CMN Profile Enterprise Table Guide describes the profile switches that you can use to control the behavior of all enterprises in the Argus Insight application.

Where to Find More Information

Oracle Help Center

The latest user documentation for Oracle Health Sciences products is available at http://docs.oracle.com/en/industries/health-sciences/.

My Oracle Support

The latest release notes, patches and white papers are on My Oracle Support (MOS) at https://support.oracle.com. For help with using MOS, see https://docs.oracle.com/cd/E74665_01/MOSHP/toc.htm.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

1 Introduction

The CMN_PROFILE_ENTERPRISE table contains values that control the behavior of all enterprises in the Argus Insight application.

You can update many of these values by modifying the Profile Switches in the List Maintenance tab on the ADMINISTRATION TOOLS page in Argus Insight.

Other values you can access and update only through direct SQL statements.

In addition to the CMN_PROFILE_ENTERPRISE table, the CMN_PROFILE_GLOBAL table contains values that control the behavior of Argus Insight. For more information about the modifying the profile global switches, see the Oracle Argus Insight CMN Profile Global Table Guide.

1.1 Internal Use Rows

During the initial Factory Data load when the database is created, the system creates several Internal Use rows. As the name implies, these rows of values are for Argus Insight internal use only.

Do not modify any values in the internal use rows.

1.2 About the Columns in the CMN_PROFILE_ENTERPRISE Table

Each profile switch described in this guide includes the following information:

- Section—Lists the name of the section within the CMN_PROFILE_ENTERPRISE table that has the profile switch. The sections are as follows:

- SYSTEM

- DATABASE

- BOXI (for BusinessObjects XI)

- COGNOS8

- Key—Lists the unique name for the profile switch.

- Company Defined—Indicates the method you can use to modify the profile switch:

- 0 = Indicates you can modify this profile switch only by issuing direct SQL statements. You should modify these profile switches with assistance from Oracle Support.

- 1 = Indicates you can modify this profile switch either by using the options in the List Maintenance tab in the Argus Insight application or by issuing direct SQL statements.

- Name—Lists the name of the profile switch as displayed in the List Maintenance tab in the Argus Insight application.

- Default Value—Lists the default value, if defined.

- Description—Provides more information about the function of the profile switch.

1.3 Examples of Modifying the CMN_PROFILE_ENTERPRISE Table

This section provides sample SQL for how to update and insert values in the CMN_PROFILE_ENTERPRISE table in the database.

Note that values, as specified, are case sensitive.

Updating an Existing Value

To update an existing value in the CMN_PROFILE_ENTERPRISE table:

UPDATE CMN_PROFILE_ENTERPRISE set value = '10'
WHERE section = 'DATABASE' AND key = 'ABC' AND ENTERPRISE_ID = 2;
commit;

Inserting a New Row of Values

To insert a new row of values into the CMN_PROFILE_ENTERPRISE table:

INSERT into CMN_PROFILE_ENTERPRISE (section, key, company_defined, name, value, description, enterprise_id)
values ('DATABASE', 'ABC', '0', 'ABC', '10', 'ABC_DEF_XYZ', 2);
commit;

2 SYSTEM Profile Enterprise Switches

This chapter lists the SYSTEM profile enterprise switches for Argus Insight.

2.1 ACCEPTABLE_ROUTING_JUSTIFICATION_FIELD_ID

Section

SYSTEM

Key

ACCEPTABLE_ROUTING_JUSTIFICATION_FIELD_ID

Company Defined

0

Name

ROUTING JUSTIFICATION ID

Default Value

4050003

Description

Specifies the LM_JUSTIFICATIONS.FIELD_ID value. This numeric value is customer-specific data.
Argus Insight uses this value to retrieve the List Maintenance Values for Acceptable Routing Justification from the LM_JUSTIFICATIONS table.

Argus Insight uses these routing justifications in the Regulatory Submission and Distribution Compliance Report.

2.2 ACCEPTABLE_SUBMISSION_JUSTIFICATION_FIELD_ID

Section

SYSTEM

Key

ACCEPTABLE_SUBMISSION_JUSTIFICATION_FIELD_ID

Company Defined

0

Name

SUBMISSION JUSTIFICATION ID

Default Value

6150002

Description

Specifies the LM_JUSTIFICATIONS.FIELD_ID value. This numeric value is customer-specific data.
Argus Insight uses this value to retrieve the List Maintenance Values for Acceptable Submission Justification from the LM_JUSTIFICATIONS table.

Argus Insight uses these submission justifications in the Regulatory Submission and Distribution Compliance Report.

2.3 ARGUS_MART_DB_NAME

Section

SYSTEM

Key

ARGUS_MART_DB_NAME

Company Defined

1

Name

ARGUS MART DB NAME

Default Value

––

Description

Specifies the database instance name for the Argus Mart data mart. This information will be used to connect Argus Insight application with Argus Mart database.

2.4 ARGUS_MART_USER_NAME

Section

SYSTEM

Key

ARGUS_MART_USER_NAME

Company Defined

1

Name

ARGUS MART USER NAME

Default Value

––

Description

Specifies the schema <AM_APP_USER> that user has created for Argus Insight application in Argus Mart installation through Schema Creation Tool. This user will be used to perform all the background functions from Argus Insight application to Argus Mart database including querying and reporting.

2.5 ARGUS_MART_USER_PASSWORD

Section

SYSTEM

Key

ARGUS_MART_USER_PASSWORD

Company Defined

1

Name

ARGUS MART USER PASSWORD

Default Value

––

Description

Specifies the password of the schema that user has created for Argus Insight application in Argus Mart database. This should be the password of the user configured in ARGUS MART USER NAME profile switch.

2.6 ARGUS_SAFETY_URL

Section

SYSTEM

Key

ARGUS_SAFETY_URL

Company Defined

0

Name

ARGUS SAFETY URL

Default Value

––

Description

Specifies the URL for the Oracle Argus Safety application.

2.7 AUTOE_P_E_TERM_DIC

Section

SYSTEM

Key

AUTOE_P_E_TERM_DIC

Company Defined

0

Name

MEDDRA DICTIONARY ID

Default Value

––

Description

Specifies the ID of the current Medical Dictionary for Regulatory Activities (MedDRA dictionary). Argus Insight automatically sets this value during the Extract Transform and Load (ETL) process.

2.8 AUTOE_P_SUS_D_DIC

Section

SYSTEM

Key

AUTOE_P_SUS_D_DIC

Company Defined

0

Name

WHO DICTIONARY ID

Default Value

––

Description

Specifies the ID of the current World Health Organization (WHO) dictionary. Argus Insight automatically sets this value during the ETL process.

2.9 BI_ANSWERS_WEB_URL

Section

SYSTEM

Key

BI_ANSWERS_WEB_URL

Company Defined

1

Name

BI ANSWERS WEB URL

Default Value

––

Description

Specifies the complete BI Answers Web URL for opening up the BI Answers Home page. This URL can be for standalone BI Answers server, or Load Balancer URL configured for multiple BI Answers servers. If BI Answers is configured for SSL, you must use https with the URL.

2.10 BIP_WEB_URL

Section

SYSTEM

Key

BIP_WEB_URL

Company Defined

1

Name

BIP WEB URL

Default Value

––

Description

Specifies the complete BI Publisher Web URL for opening the BI Publisher Home page. This URL can be for standalone BI Publisher server, or Load Balancer URL configured for multiple BI Publisher servers. If BI Publisher is configured for SSL, you must use https with the URL.

2.11 BO_WEB_URL

Section

SYSTEM

Key

BO_WEB_URL

Company Defined

1

Name

BO WEB URL

Default Value

––

Description

Specifies the complete BusinessObjects Web URL for opening the BusinessObjects Home page. This URL can be for standalone BusinessObjects server, or Load Balancer URL configured for multiple BusinessObjects servers. If BusinessObjects is configured for SSL, you must use https with the URL.

2.12 CASE_REFERENCE_TYPE_ID

Section

SYSTEM

Key

CASE_REFERENCE_TYPE_ID

Company Defined

0

Name

CASE REFERENCE TYPE ID

Default Value

––

Description

During the ETL process, Argus Insight uses this value to populate the RPT_CASE.FIRST_REF_NO column.
The ETL process populates the RPT_CASE.FIRST_REF_NO column only if this profile switch is set. Otherwise, the column value is null.

The Local Reference Number in reports points to the RPT_CASE.FIRST_REF_NO column.

2.13 CAUSALITY_ASSESSMENT_C

Section

SYSTEM

Key

CAUSALITY_ASSESSMENT_C

Company Defined

0

Name

CAUSALITY ASSESSMENT. C

Default Value

––

Description

Argus Insight uses this value in standard reports for Company Defined Causality.

2.14 CAUSALITY_ASSESSMENT_R

Section

SYSTEM

Key

CAUSALITY_ASSESSMENT_R

Company Defined

0

Name

CAUSALITY ASSESSMENT. R

Default Value

––

Description

Argus Insight uses this value in standard reports for Reporter Defined Causality.

2.15 CAUSALITY_ASSESSMENT_R_C

Section

SYSTEM

Key

CAUSALITY_ASSESSMENT_R_C

Company Defined

0

Name

CAUSALITY ASSESSMENT. R+C

Default Value

––

Description

Argus Insight uses this value in standard reports for Reporter Defined Causality and Company Defined Causality.

2.16 CAUSALITY_ASSESSMENT_UDFIELD

Section

SYSTEM

Key

CAUSALITY_ASSESSMENT_UDFIELD

Company Defined

0

Name

CAUSALITY ASSESSMENT. UD FIELD

Default Value

––

Description

Argus Insight uses this value in standard reports for the user-defined (UD) field to determine causality.

2.17 COGNOS_WEB_URL

Section

SYSTEM

Key

COGNOS_WEB_URL

Company Defined

1

Name

COGNOS WEB URL

Default Value

---

Description

Specifies the complete Cognos Web URL for opening the Cognos home page. This URL can be the Cognos URL for standalone Cognos server, or the Load Balancer URL configured for multiple Cognos servers. If Cognos is configured for SSL, you must use https with the URL.
Example: http://<server name>/Cognos102

2.18 CONFIDENTIALITY

Section

SYSTEM

Key

CONFIDENTIALITY

Company Defined

0

Name

CONFIDENTIALITY TEXT

Default Value

Confidential

Description

Defines the confidential text that prints in the running footer on each page in the reports.

2.19 CORE_SITE

Section

SYSTEM

Key

CORE_SITE

Company Defined

0

Name

CORE SITE

Default Value

CORE

Description

Configures the abbreviation that indicates a site is a core site. All sites listed in the LM_SITES table that have the configured site abbreviation are considered to be core sites.
In addition, Argus Insight uses the CORE_SITE value to calculate the value for the Core Receipt Date field in standard reports.

2.20 CORPORATE_LOGO_PATH

Section

SYSTEM

Key

CORPORATE_LOGO_PATH

Company Defined

0

Name

COMPANY LOGO PATH

Default Value

C:\Logo\logo.bmp

Description

Defines the location of the company logo on the local server. This logo prints in the report header.
For Cognos — Enter the logo file name with the full URL path to the file on the local server. Cognos supports the following file types: JPG, GIF, and BMP.

For BusinessObjects — Enter the logo file name with the directory path to the image file on the BusinessObjects server. BusinessObjects supports the following file types: TIFF and BMP.

2.21 CUSTOM_HELP_URL

Section

SYSTEM

Key

CUSTOM_HELP_URL

Company Defined

1

Name

CUSTOM HELP URL

Default Value

––

Description

Defines the URL for your customized online help.
If the URL is not valid, users receive the following error message:

Error 404 - Page Not Found

2.22 DATASHEET_BPI

Section

SYSTEM

Key

DATASHEET_BPI

Company Defined

0

Name

DATASHEET BPI

Default Value

––

Description

Configures the user-defined fields for assessment of BPI Datasheet in the Product tab.
Argus Insight uses this value in the following General and Compliance reports:

- Audit Review Listing

- Detailed Line Listing by Case Number

- Global Audit Listing

- MSE Review List for Non Serious SR

- MSE Review List for Unrelated CT

2.23 DATASHEET_EMEA

Section

SYSTEM

Key

DATASHEET_EMEA

Company Defined

0

Name

DATASHEET EMEA

Default Value

––

Description

Configures the user-defined fields for assessment of EMEA Datasheet in the Products tab.
Argus Insight uses this value in the following General and Compliance reports:

- Audit Review Listing

- Detailed Line Listing by Case Number

- Global Audit Listing

- MSE Review List for Non Serious SR

- MSE Review List for Unrelated CT

2.24 DATASHEET_IB

Section

SYSTEM

Key

DATASHEET_IB

Company Defined

0

Name

DATASHEET IB

Default Value

––

Description

Configures the user-defined fields for assessment of IB Datasheet in the Products tab.
Argus Insight uses this value in the following General and Compliance reports:

- Audit Review Listing

- Detailed Line Listing by Case Number

- Global Audit Listing

- MSE Review List for Non Serious SR

- MSE Review List for Unrelated CT

2.25 DATASHEET_PI

Section

SYSTEM

Key

DATASHEET_PI

Company Defined

0

Name

DATASHEET PI

Default Value

––

Description

Configures the user-defined fields for assessment of PI Datasheet in the Products tab.
Argus Insight uses this value in the following General and Compliance reports:

- Audit Review Listing

- Detailed Line Listing by Case Number

- Global Audit Listing

- MSE Review List for Non Serious SR

- MSE Review List for Unrelated CT

2.26 DATA_SOURCE

Section

SYSTEM

Key

DATA_SOURCE

Company Defined

1

Name

ARGUS INSIGHT APPLICATION DATA SOURCE

Default Value

1

Description

Configures the data source for Argus Insight application. You may run your queries against Argus Insight Mart or Argus Mart depending upon the value configured in this switch. The available values are:

- Argus Mart — Querying will be available only on Argus Mart data source

- Insight Mart — Querying will be available only on Argus Insight data source

- Both (Insight and Argus Mart) — You may choose between Insight Mart and Argus Mart data sources for creating and executing the queries. All the queries and case series created on these data sources can be identified in the application.

2.27 DISPLAY_ENTERPRISE_SHORT_NAME

Section

SYSTEM

Key

DISPLAY_ENTERPRISE_SHORT_NAME

Company Defined

0

Name

DISPLAY ENTERPRISE SHORT NAME

Default Value

0

Description

Defines whether to display the enterprise short name in the Argus Insight application.
0 = Do not display the enterprise short name.

1 = Display the enterprise short name.

2.28 DLL_SLL_REPORTS_TABLE_POPULATION

Section

SYSTEM

Key

DLL_SLL_REPORTS_TABLE_POPULATION

Company Defined

0

Name

POPULATE DLL SLL REPORTS TABLE DATA

Default Value

0

Description

Defines whether to populate the RPT_CASE_EVENT_PRODUCT table required for DLL and SLL.
0 = Do not populate the RPT_CASE_EVENT_PRODUCT table.

1 = Populate the RPT_CASE_EVENT_PRODUCT table.

2.29 DMS_MEDDRA_USER

Section

SYSTEM

Key

DMS_MEDDRA_USER

Company Defined

0

Name

DMS_MEDDRA_USER

Default Value

––

Description

Defines the name of the schema in the source system (Argus Safety) where the MEDDRA tables are populated.

2.30 DMS_WHO_USER

Section

SYSTEM

Key

DMS_WHO_USER

Company Defined

0

Name

DMS_WHO_USER

Default Value

––

Description

Defines the name of the schema in the source system (Argus Safety) where the WHO tables are populated.

2.31 ENABLE_COMPANY_HOLIDAY

Section

SYSTEM

Key

ENABLE_COMPANY_HOLIDAY

Company Defined

0

Name

ENABLE COMPANY HOLIDAY

Default Value

1

Description

Defines whether to include company holidays in the due date calculation for the Data Entry Performance Over Time Report.
0 = Do not include company holidays in the calculations.

1 = Include company holidays in the calculations.

2.32 ESM_TABLE_POPULATION

Section

SYSTEM

Key

ESM_TABLE_POPULATION

Company Defined

1

Name

POPULATE INTERCHANGE DATA

Default Value

0

Description

Defines whether to bring Interchange data into the data mart.
0 = Do not bring any Interchange data into the data mart.

1 = Bring all Interchange data into the data mart.

2 = Bring only the Interchange data from the following tables into the data mart:

- SAFETYREPORT

- MESSAGES

- EDI_INFO

2.33 EVENT_CAUSALITY_FIELD

Section

SYSTEM

Key

EVENT_CAUSALITY_FIELD

Company Defined

0

Name

EVENT CAUSALITY FIELD

Default Value

––

Description

Determines which user-defined fields in the Events tab will be displayed in reports.

2.34 FAILED_RECIPIENTS_STATUS_EMAIL_ADDRESS

Section

SYSTEM

Key

FAILED_RECIPIENTS_STATUS_EMAIL_ADDRESS

Company Defined

1

Name

FAILED RECIPIENTS STATUS EMAIL ADDRESS

Default Value

––

Description

Defines the email address of the user who will receive information regarding undeliverable email messages due to an invalid email ID or other error.

2.35 FOLLOWUP_ACTION_CODE

Section

SYSTEM

Key

FOLLOWUP_ACTION_CODE

Company Defined

0

Name

FOLLOW-UP ACTION CODE

Default Value

––

Description

Configures the code that indicates a follow-up action is required.
Argus Insight uses this code in the Follow-up Status Listing report.

2.36 KEEP_REPORT_DATA

Section

SYSTEM

Key

KEEP_REPORT_DATA

Company Defined

1

Name

KEEP REPORT DATA

Default Value

N

Description

A flag to determine if the report log tables need to be populated or not.
Y - Populate the report log tables

N - Do not populate the report log tables

Default Value - N

2.37 LAM_TABLE_POPULATION

Section

SYSTEM

Key

LAM_TABLE_POPULATION

Company Defined

1

Name

POPULATE AFFILIATE DATA

Default Value

0

Description

Defines whether to bring affiliate data from the Local Affiliate Module (LAM) into the data mart. The affiliate data comes from all tables with the LAM_ prefix.
0 = Do not bring any affiliate data into the data mart.

1 = Bring all affiliate data into the data mart.

2.38 LICENSE_PARTY_STARTING_CODE

Section

SYSTEM

Key

LICENSE_PARTY_STARTING_CODE

Company Defined

0

Name

LICENSE PARTY STARTING CODE

Default Value

LP

Description

Configures the starting code value for the licensing party. Argus Insight uses this value for the Process Performance Report - Notification report.

2.39 LL_REPORTS_DATASHEET

Section

SYSTEM

Key

LL_REPORTS_DATASHEET

Company Defined

0

Name

DATASHEET NAMES FOR LL REPORTS

Default Value

DATASHEET BPI, DATASHEET EMEA, DATASHEET IB, DATASHEET PI

Description

Specifies the names of the datasheets that Argus Insight must print on the line listing (LL) report. Argus Insight uses this value for the Detailed Line Listing by Case Number report.
Use a comma to separate each name in the value field.

2.40 LL_REPORTS_TABLE_POPULATION

Section

SYSTEM

Key

LL_REPORTS_TABLE_POPULATION

Company Defined

0

Name

POPULATE LL REPORTS TABLE DATA

Default Value

0

Description

Defines whether to populate the RPT_CASE_EVENT_PROD table and the RPT_CASE_EVENT_PRODUCT_ASSESS table required for the LL reports.
0 = Do not populate the RPT_CASE_EVENT_PROD and RPT_CASE_EVENT_PRODUCT_ASSESS tables.

1 = Populate the RPT_CASE_EVENT_PROD and RPT_CASE_EVENT_PRODUCT_ASSESS tables.

2.41 LOCKED_DAYS

Section

SYSTEM

Key

LOCKED_DAYS

Company Defined

0

Name

DAYS TO LOCK

Default Value

9

Description

Configures the number of days to lock for a case.

2.42 MEDDRA_POPULATION

Section

SYSTEM

Key

MEDDRA_POPULATION

Company Defined

0

Name

POPULATE MEDDRA DATA

Default Value

1

Description

Defines whether to populate the MedDRA tables.
0 = Do not populate the MedDRA tables.

1 = Populate the MedDRA tables.

2 = Populate the MedDRA and MedDRA/J (MedDRA Japanese Translation) tables.

To improve performance of Incremental ETL, Oracle recommends that you set this switch to 0 once you have completed the Initial ETL. Thereafter, whenever you update the MedDRA dictionary in Argus, set this switch to 1 before you run the Incremental ETL.

2.43 POPULATE_NARRATIVE_LANGUAGES_TABLES

Section

SYSTEM

Key

POPULATE_NARRATIVE_LANGUAGES_TABLES

Company Defined

0

Name

POPULATE NARRATIVE LANGUAGES TABLES

Default Value

0

Description

Defines whether to populate the RPT_CNL_MLINGUAL table and the RPT_CNL_ENGLISH table.
0 = Do not populate the RPT_CNL_MLINGUAL and RPT_CNL_ENGLISH tables.

1 = Populate the RPT_CNL_MLINGUAL and RPT_CNL_ENGLISH tables.

Argus Insight uses the information in these tables in the following reports:

- Case Narrative Listing - English

- Serious Adverse Events Report

2.44 POPULATE_RPT_REG_REPORTS_COLUMNS

Section

SYSTEM

Key

POPULATE_RPT_REG_REPORTS_COLUMNS

Company Defined

0

Name

POPULATE RPT_REG_REPORTS COLUMNS

Default Value

0

Description

Defines whether to populate the extra columns of the RPT_REG_REPORTS table.
0 = Do not populate the extra columns of RPT_REG_REPORTS table.

1 = Populate the extra columns of RPT_REG_REPORTS table.

2.45 PRODUCT_LOGO_PATH

Section

SYSTEM

Key

PRODUCT_LOGO_PATH

Company Defined

0

Name

PRODUCT LOGO PATH

Default Value

––

Description

Defines the full URL path to the image file of the product logo that prints in the header of the following reports:

- Adverse Events Line Listing

- Data Entry Performance Over Time Report

- DCA-TME Notification Report

- Manufacturing Monthly Report

- Process Performance Report - Notification

- Process Performance Report - Workflow

- Regulatory Submission and Distribution Compliance Report

- Serious Adverse Events Report

- Supplier Performance Report

2.46 PROXY_AUTO_DETECT

Section

SYSTEM

Key

PROXY_AUTO_DETECT

Company Defined

0

Name

PROXY_AUTO_DETECT

Default Value

0

Description

This property defines whether to detect proxy automatically.

2.47 PROXY_HOST

Section

SYSTEM

Key

PROXY_HOST

Company Defined

0

Name

PROXY_HOST

Default Value

NULL

Description

This property defines the name of the proxy server.

2.48 PROXY_PASSWORD

Section

SYSTEM

Key

PROXY_PASSWORD

Company Defined

0

Name

PROXY_PASSWORD

Default Value

NULL

Description

This property defines the password of the user which connects to proxy server.

2.49 PROXY_PORT

Section

SYSTEM

Key

PROXY_PORT

Company Defined

0

Name

PROXY_PORT

Default Value

NULL

Description

This property defines the proxy port.

2.50 PROXY_TYPE

Section

SYSTEM

Key

PROXY_TYPE

Company Defined

0

Name

PROXY_TYPE

Default Value

0

Description

This property defines the proxy type. Possible values:

- 0 = None

- 1 = Tunnel

- 2 = SOCKS4

- 3 = SOCKS5

2.51 PROXY_USER

Section

SYSTEM

Key

PROXY_USER

Company Defined

0

Name

PROXY_USER

Default Value

NULL

Description

This property defines the user name which connects to proxy server.

2.52 RESET_PASSWORD

Section

SYSTEM

Key

RESET_PASSWORD

Company Defined

0

Name

RESET PASSWORD

Default Value

BA520CFDD9CD7BF3C51AF9604B7EDFB071AE6E032EECEF18A7DA88D6A9E75853

Description

Defines the value to use when resetting a user's password.

2.53 SSL_START_MODE

Section

SYSTEM

Key

SSL_START_MODE

Company Defined

0

Name

SSL_START_MODE

Default Value

3

Description

This property defines the SSL start mode. Possible values:

- 0 = SSLAutomatic

- 1 = SSLImplicit

- 2 = SSLExplicit

- 3 = SSLNone

2.54 STUDY_RECONCILIATION_TABLE_POPULATION

Section

SYSTEM

Key

STUDY_RECONCILIATION_TABLE_POPULATION

Company Defined

0

Name

POPULATE STUDY RECONCILIATION REPORT TABLE DATA

Default Value

0

Description

Defines whether to populate the FACT_PROD_LICENSE table required for the Study Reconciliation Report.
0 = Do not populate the FACT_PROD_LICENSE table.

1 = Populate the FACT_PROD_LICENSE table.

2.55 SUPPLIER_FIELD_ID

Section

SYSTEM

Key

SUPPLIER_FIELD_ID

Company Defined

0

Name

SUPPLIER FIELD ID

Default Value

26050012

Description

Specifies the LM_JUSTIFICATIONS.FIELD_ID value. This numeric value is customer-specific data.
Argus Insight uses this value to retrieve the List Maintenance Values for Measurable Suppliers configuration from the LM_JUSTIFICATIONS table.

Argus Insight uses the configured suppliers in the Supplier Performance Report.

2.56 UDN_COL_FOR_SUPPLIER_NAME

Section

SYSTEM

Key

UDN_COL_FOR_SUPPLIER_NAME

Company Defined

0

Name

UDN COLUMN FOR SUPPLIER NAME

Default Value

––

Description

Defines the user-defined name (UDN) of the column in the Argus Safety CASE_MASTER table that contains the SUPPLIER NAME value.

2.57 WHO_DRUG_BROWSER_FORMAT

Section

SYSTEM

Key

WHO_DRUG_BROWSER_FORMAT

Company Defined

0

Name

WHO DRUG BROWSER FORMAT

Default Value

––

Description

Defines the WHO Drug Browser format populated by the ETL.
B = All the WHO Drug Browsers in the Argus Insight application will display the B format.

C = All the WHO Drug Browsers in the Argus Insight application will display the C format.

2.58 WHO_DRUG_POPULATION

Section

SYSTEM

Key

WHO_DRUG_POPULATION

Company Defined

0

Name

POPULATE WHO DRUG DATA

Default Value

1

Description

Defines whether to populate the WHO tables.
0 = Do not populate the WHO tables.

1 = Populate the WHO tables.

3 DATABASE Profile Enterprise Switches

This chapter lists the DATABASE profile enterprise switches for Argus Insight.

3.1 CHANGE_CONFIG_RC_UD

Section

DATABASE

Key

CHANGE_CONFIG_RC_UD

Company Defined

0

Name

CHANGE_CONFIG_RC_UD

Default Value

0

Description

Sets the RC_UD configuration flag (R = Reporter Defined Causality, C = Company Defined Causality, and UD = User-Defined Fields).
Argus Insight automatically sets this flag to 1 whenever the configuration of the following profile switches changes:

- CAUSALITY ASSESSMENT. R

- CAUSALITY ASSESSMENT. C

- CAUSALITY ASSESSMENT. R+C

- CAUSALITY ASSESSMENT. UD FIELD

If the value is 1, Argus Insight updates the RPT_EVENT.RCVALUE column for all cases.

3.2 CHANGE_CONFIG_WF

Section

DATABASE

Key

CHANGE_CONFIG_WF

Company Defined

0

Name

CHANGE_CONFIG_WF

Default Value

0

Description

Sets the workflow (WF) configuration flag.
Argus Insight automatically sets the value to 1 whenever the configuration of the following workflow attributes changes:

- Workflow Metrics - Archiving States

- Workflow Metrics - Data Entry Complete

- Workflow Metrics - Assessment Complete

- Workflow Metrics - Approval Complete

If the value is 1, Argus Insight updates the following columns in the RPT_FOLLOWUP table for all cases:

- DATA_ENTRY_COMPLETE_DATE

- ASSESSMENT_COMPLETE_DATE

- APPROVAL_COMPLETE_DATE

3.3 DATASHEET_FLAG

Section

DATABASE

Key

DATASHEET_FLAG

Company Defined

0

Name

DATASHEET FLAG

Default Value

0

Description

Sets the datasheet flag.
Argus Insight uses this flag during Incremental ETL to determine whether to populate the data in the four DATASHEET fields for all the cases or for only the modified cases.

0 = Populate the data for only the modified cases.

1 = Populate the data for all cases.

The four DATASHEET fields defined in the List Maintenance tab on the ADMINISTRATION TOOLS page in Argus Insight are as follows:

- DATASHEET BPI

- DATASHEET EMEA

- DATASHEET IB

- DATASHEET PI

3.4 DELAY_IDENTIFIER

Section

DATABASE

Key

DELAY_IDENTIFIER

Company Defined

0

Name

DELAY IDENTIFIER

Default Value

—

Description

Defines the delay text that ETL uses to populate the RPT_FOLLOWUP.CORE_DELAY_ROUTING_COMMENT field.
Argus Insight uses this field in the following reports:

- Supplier Performance Report

- Process Performance Report - Workflow

3.5 DMS_WHO_DRUG_QUERY

Section

DATABASE

Key

DMS_WHO_DRUG_QUERY

Company Defined

0

Name

DMS_WHO_DRUG_QUERY

Default Value

—

Description

DMS WHO Drug Query

3.6 DMS_WHO_DRUG_QUERY_ING

Section

DATABASE

Key

DMS_WHO_DRUG_QUERY_ING

Company Defined

0

Name

DMS_WHO_DRUG_QUERY_ING

Default Value

—

Description

DMS WHO Drug Query for Ingredient

3.7 EMAIL_SENDER_ADDRESS

Section

DATABASE

Key

EMAIL_SENDER_ADDRESS

Company Defined

1

Name

EMAIL SENDER ADDRESS

Default Value

––

Description

Defines the email address of the person on whose behalf Argus Insight sends all email messages. If you leave the value blank, then Argus Insight sends no email messages.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2017, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.