Breadcrumbs

Tables (Agents)

This page contains the details about the Agent Model Tables.

RunHistory

Table Name – RunHistory
Label – Run History

Fields

Field Name

Label

Data Type

runId

Run Id

TEXT

runAt

Run At

DATETIME

status

Status

TEXT

message

Message

TEXT

detectedCount

Detected Count

INTEGER

actionCount

Action Count

INTEGER

hasActionPlan

Has Action Plan

BOOLEAN

ActionPlans

Table Name – ActionPlans
Label – Action Plans

Fields

Field Name

Label

Data Type

runId

Run Id

TEXT

runAt

Run At

DATETIME

actionPlanId

Action Plan Id

NUMBER

actionPlanType

Action Plan Type

TEXT

Actions

Table Name – Actions
Label – Actions

Fields

Field Name

Label

Data Type

Dimension

runId

Run Id

TEXT

Yes

runAt

Run At

DATETIME

Yes

actionId

Action Id

NUMBER

No

assignTo

Assign To

TEXT

Yes

currency

Currency

TEXT

Yes

This table also includes additional dynamic fields for action impact values and detected items dimensions.

DetectedItems

Table Name – DetectedItems
Label – Detected Items

Base Fields

Field Name

Label

Data Type

Dimension

runId

Run Id

TEXT

Yes

runAt

Run At

DATETIME

Yes

currency

Currency

TEXT

Yes

This table has dynamic fields added based on the selected series dimensions, measures, and action impact values.

LatestDetectedItems

Table Name – LatestDetectedItems
Label – Detected Items (same as DetectedItems)

Fields

Uses the same field structure as DetectedItems table.

ActionImpactDefinitions

Table Name – ActionImpactDefinitions
Label – Action Impact Definitions

Fields

Field Name

Label

Data Type

measure

Measure

TEXT

measureAlias

Measure Alias

TEXT

measureExpression

Measure Expression

TEXT

impactType

Impact Type

TEXT

realizationRate

Realization Rate

NUMBER

order

Order

INTEGER

IgnoredActionsSummary

Table Name – IgnoredActionsSummary
Label – Ignored Actions Summary

Fields

Field Name

Label

Data Type

Dimension

runId

Run Id

TEXT

Yes

runAt

Run At

DATETIME

Yes

currency

Currency

TEXT

Yes

createdActionsCount

Actions Created

INTEGER

Yes

ignoredActionsCount

Not Created Actions

INTEGER

Yes

ignoredDetectedItemsCount

Not Created Detected Items

INTEGER

Yes

This table also includes dynamic fields for each impact type (e.g., Profit Impact, Revenue Impact).

Additional Information

  • Fields marked as dimension are used for grouping and filtering in the Analytics.

  • Several tables (Actions, DetectedItems, LatestDetectedItems, IgnoredActionsSummary) have dynamic fields added at runtime based on configuration.

  • The runId and runAt fields use the same timestamp value (run execution time in milliseconds).

  • Data types are from the FieldType enumeration (TEXT, DATETIME, INTEGER, NUMBER, BOOLEAN).