3.2.1 fcc_ob_json_table_config

This table defines the structure of the input JSON, which needs to be persisted in the KYC tables.

To view the table values, run the following query:

select * from fcc_tpg_json_table_config where parent_mapping_id='parent_mapping_id value' order by order_used;

The following table describes the values as follows.

Table 3-4 fcc_ob_json_table_config Table

Value Name	Description
PARENT_MAPPING_ID	Parent mapping ID of the JSON. The parent_mapping_id value can be one of the following: SCORING_RESPONSE CS_WLS_RESPONSE INT_WLS_RESPONSE TRULIOO_ENTITY_RESPONSE TRULIOO_RESPONSE.
JSON_ELEMENT	This field captures the JSON ID value for each JSON element. This value should match the element names in the JSON.
PARENT_JSON_ELEMENT	This field captures the name of the parent JSON element. If there is no parent element, (null) is displayed by default.
DATA_TYPE	This field captures the logical data type of the JSON element. The default is STRING. Other Data types are String array, Array, or JSON.
ORDER_USED	This field provides the order of the JSON elements which need to be captured among the complete JSON structure. The order of the first element to be captured is 1. The order of each subsequent element increases by 1 whenever a particular JSON element is captured.