product_response
- Sylvain Paillard
Each Product Response represents ONE individual product-type element suggested by CPO engine in response to a received request.
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. |
product_order_num | INTEGER | REQUIRED | PK, defines order in which products are are listed in the chosen response variant |
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. |
groupby_field | STRING | REQUIRED | Indicates the type of product provided as ID in the GROUPBY_VALUE field |
groupby_value | STRING | REQUIRED |
|
KPI_list | RECORD | REPEATED | list of KPIs, each KPI is technically represented by a STRUCT of (kpi_name string,kpi_val_num numeric,kpi_val_text string) |
KPI_list. kpi_name | STRING | REQUIRED |
|
KPI_list. kpi_val_num | NUMERIC | NULLABLE |
|
KPI_list. kpi_val_text | STRING | NULLABLE |
|
creation_tm | DATETIME | REQUIRED | technical field |
client_id | INTEGER | REQUIRED | technical field |
src_sys_id | INTEGER | REQUIRED | technical field |