Configure CMN_FIELDS Table

You can configure the advance condition extensibility columns for the new field ID in the database table CMN_FIELDS as given below:

Table 1-1 CMN _FIELDS Column Details

Column	Sample Value for Insight Mart	Sample Value for Argus Mart	Description
ENTERPRISE_ID	3	3	Defines the current Enterprise ID. This is a mandatory column.
FIELD_ID	30000000	30000000	Defines the Oracle Argus Insight new field ID that must be unique and must be in the following range: For customers: 30000000 - 39999999 For partners: 40000000 - 49999999 All other IDs are reserved for Oracle. This is a mandatory column.
FIELD_LABEL	Custom Product Country	Custom Product Country	Defined the field label having maximum length of 200 characters. This is a mandatory column.
TABLE_NAME	V_RPT_PRODUCT	CASE_PRODUCT	Defines the table name that contains the column for search criteria. The maximum length for the table name is 50 characters. This is a mandatory column.
COLUMN_NAME	COUNTRY_ID	COUNTRY_ID	Defines the column name for the search criteria. This column name must exist in table populated in TABLE_NAME. The maximum length of this column is 50 characters. This is a mandatory column.
JOIN_FIELD	COUNTRY_ID	COUNTRY_ID	Defines the column name if this field is of drop-down type on UI. This column contains the name of column that you want to use for join condition between the tables populated in TABLE_NAME and SELECT_TABLE. This is an optional column.
SELECT_TABLE	LM_COUNTRIES	LM_COUNTRIES	Defines the table name if this field is of drop-down type on UI. This column contains the name of table that you want to use to populate the drop-down values. This is an optional column.
SELECT_COLUMN	COUNTRY	COUNTRY	Defines the column name if this field is of drop-down type on UI. This column contains the name of column that you want to use to populate for the drop-down values. This is an optional column.
ADV_COND_FIELD	1	1	Contains the value for the new field ID as 1. This is a mandatory column.
TREE_VIEW	PRODUCTS:Product Information	PRODUCTS:Product Information	Defines the hierarchical structure of field in advance condition tree on Advance Condition Editor page. The first level and second level node of the tree must be separated by character ":". For example, First Level Tree Node: Second Level Tree Node This is a mandatory column.
SQL_SELECT	SELECT 1 ID, 'UNITED STATE' STATUS FROM DUAL UNION SELECT 2, 'UNITED KINGDOM' FROM DUAL UNION SELECT 3, 'INDIA' FROM DUAL	SELECT 1 ID, 'UNITED STATE' STATUS FROM DUAL UNION SELECT 2, 'UNITED KINGDOM' FROM DUAL UNION SELECT 3, 'INDIA' FROM DUAL	Defines the SQL query if this field is of drop-down type on UI. This column contains the selected query that you want to use to populate the drop-down values. This select query must contain the columns ID and STATUS. Note: If this column is configured then the values configured in columns SELECT_COLUMN, SELECT_TABLE and JOIN_FIELD will be ignored. This is an optional column.
HIDDEN	0	0	Contains the value for the new field ID as 0. This is a mandatory column.
CONTROL_TYPE_ID	2	2	Defines the ID of the control that you want to display on UI.Refer to the table CMN_CONTROL_TYPE for supported Control Type ID. 1 - Textbox 2 - Dropdown 3 - DatePicker 4 - DateTimePicker 5 - Numeric Control Type This is a mandatory column.
ADDITIONAL_TABLE_LIST	RPT_EVENT	CASE_EVENT	Defines the comma separated table list that is to be added in From clause of final SQL query except table name entered in the column Table_Name, and: V_RPT_CASE (in case of Insight Mart) CASE_MASTER (in case of Oracle Argus Mart) This field is required only if any additional join tables are required. This is an optional column.
ADDITIONAL_WHERE	V_RPT_PRODUCT.SEQ_NUM = RPT_EVENT.SEQ_NUM AND V_RPT_PRODUCT. COUNTRY_ID > 0	CASE_PRODUCT.SEQ_NUM = CASE_EVENT.SEQ_NUM AND CASE_PRODUCT. COUNTRY_ID > 0	Defines the additional Where clause that you want to add in the final SQL query of advance condition. This is an optional column.
DATA_SOURCE_ID	1	2	Defines the value of the target data source (Insight Mart/Oracle Argus Mart). This is a mandatory column.

To configure remaining columns of the database table CMN_FIELDS, refer to the Oracle Argus Insight Database Administrator's Guide.