3.2.2 fcc_ob_json_table_map

This table contains the mappings between the configured JSON elements and the corresponding table elements.

To view the table values, run the following query:

select * from fcc_tpg_json_table_map where parent_mapping_id='< parent_mapping_id value>' order by order_used;

The following table describes the values as follows.

Table 3-5 fcc_ob_json_table_map Table

Value Name	Description
MAPPING_ID	Child mapping ID of the parent mapping ID. For example, if the corresponding parent mapping ID is mapped to three different tables, then three unique mapping IDs will be used.
PARENT_MAPPING_ID	Mapping ID which groups all the configurations and the corresponding mappings for the JSON. This must be the same in both config and map tables. The parent_mapping_id value can be one of the following: SCORING_RESPONSE CS_WLS_RESPONSE INT_WLS_RESPONSE IDV_ENTITY_RESPONSE IDV_RESPONSE.
JSON_ELEMENT	The JSON elements configured in the config table. Only captures JSON elements of type String or String array. If a JSON element of type JSON or array is defined in the config table, then that JSON element must not be displayed in the map table.
TARGET_TABLE	The table into which data is persisted.
TARGET_COLUMN	The column into which data is persisted.
EXPRESSION	Values can be the service name, system date, or another query expression. If you do not know the actual expression value, provide the value NOTNULL.
ORDER_USED	The same order used for a particular JSON element in the config table. Only captures JSON elements of type string.