extrainfo_response

Each ExtraInfo Response represents ONE individual extraInfo-type element suggested by CPO engine in response to a received request

Field name

Type

Mode

Description

Field name

Type

Mode

Description

request_id

STRING

REQUIRED

PK, Is a concatenation of a BUNDLE_ID and REQUEST_ORDER_NUM (a generated sequential number), source does not deliver IDs for individual requests.

variant_id

STRING

REQUIRED

PK, variants represent different strategies available for handling the same request. They are available as ad hoc choices for client system.

request_ts

TIMESTAMP

REQUIRED

Is the timestamp of the original request bundle. It is repeated across tables to partition data by date for fast access.

parameter_list

RECORD

REPEATED

Is ARRAY of STRUCT that encapsulates key-value pairs as provided in the extraInfo element of a variant

parameter_list. key

STRING

REQUIRED

 

parameter_list. value

STRING

REQUIRED

 

creation_tm

DATETIME

REQUIRED

technical field

client_id

INTEGER

REQUIRED

technical field

src_sys_id

INTEGER

REQUIRED

technical field