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 ObjectTypeNullablePrimaryDescriptionReference
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.

action_type

severity

enum

False

False

The action severity

severity

category

enum

False

False

The action category

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.

action.attrs

Sample Use Cases

N/A