Go to primary content

Oracle® Argus Insight CMN Profile Enterprise Table Guide Release 8.1 E68409-01 |
| Contents

Previous | Next |

# 2 SYSTEM Profile Enterprise Switches

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

For information about the profile enterprise switches you can use to change settings for the database, see Chapter 3, "DATABASE Profile Enterprise Switches".

## 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 REPORT_FOOTER_LOGO_PATH

Section | SYSTEM
Key | REPORT_FOOTER_LOGO_PATH
Company Defined | 0
Name | REPORT FOOTER LOGO PATH
Default Value | ––
Description | Defines the full URL path to the image file of the product logo that prints in the footer 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.47 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.48 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.49 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.50 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.51 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.52 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.