pending_action Table
This table lists the latest actions that have been recommended by the market. The table repopulates at a configurable interval (not necessarily every 10-minute market cycle). When it repopulates, all actions are replaced with the latest action recommendations.
This table does not include actions that are in progress.
Data Object | Type | Nullable | Primary | Description | Reference |
---|---|---|---|---|---|
recommendation_time |
timestamp with time zone |
False |
False |
When analysis recommended this action. |
|
action_oid |
bigint |
False |
False |
The action ID. Use this to get more action details. |
|
type |
enum |
False |
False |
the action type. |
|
severity |
enum |
False |
False |
The action severity |
|
category |
enum |
False |
False |
The action category |
|
target_entity_id |
bigint |
False |
False |
The ID of the entity this action affects. |
|
involved_entities |
bigint[] |
True |
False |
An array of IDs for all the entities involved in the action. Includes the target entity. |
|
description |
text |
False |
False |
The text description of the action. |
|
savings |
double precision |
False |
False |
The cost savings this action results in. A negative savings indicates an investment. |
|
attrs |
jsonb |
True |
False |
Additional (often type-specific) info for the action. For example, in resizes this will contain the commodity type and from/to amounts. |
Sample Use Cases
N/A