Log storage

Logs are stored in the Log Main table.

Validation process logs are represented by:

  • EVENT_ID: 7017, Validate Start
  • EVENT_ID: 7018, Validate Stop

Publishing process logs are represented by:

  • EVENT_ID: 7019, Publish Start
  • EVENT_ID: 7020, Publish Stop

Calculation process logs are represented by:

  • EVENT_ID: 7021, Calculate Start
  • EVENT_ID: 7022, Calculate Stop

This table describes the columns in the Log Main table:

Column Description
ID Internal event ID.
ADDED_DATE When the event was created or occurred.
ADDED_DATE_IND When the event was created or occurred, rounded to minutes for indexing purposes.
EVENT_ID

Meta data validation from the integration table uses:

  • 7017 Validate Start
  • 7018 Validate Stop

Meta data publishing from the integration table uses:

  • 7019 Publish Start
  • 7020 Publish Stop

Meta data calculation uses:

  • 7021 Calculate Start
  • 7022 Calculate Stop
TRACE_ID Correlation ID for grouping log entries. Not used by Workforce Budgeting.
SPAN_ID Parent ID for activity hierarchy. Not used by Workforce Budgeting.
LEVEL Log level: information, error, warning, debug.
INSTANCE_ID ID of the service unit.
SESSION_ID Session ID under which event happened.
USER_ID The user who caused the event (actor).
APPLICATION_NAME Application unique name in which context the event happened.
OBJECT_NAME Object unique name on which the event happened.
RESULT Result of the event.
DURATION The duration of the event (milliseconds).
EVENT_DATA Event data details. Warnings/errors.