Details Of The Batch Execution Activity

In Scope

Technical: BATCH_ACTIVITY | ID: OR-STO-BATCH_ACTIVITY-BATCH_ACTIVITY

Stores the details of the batch execution activity.

See how this object fits into Store Operations

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Sequencing
Stage 2
Typical Sources
ERPLegacy

Classification

Object Type
dictionary

Target Structure

Load Approach
Table
Target Objects
BATCH_ACTIVITY

Field Definitions(5)

Rules & Considerations(16)

constraint

validation

Sample Load Data(4)

Example values from field definitions

IDRPK
1
JOB_NAMER
SAMPLE
JOB_EXECUTION_IDR
1
REVIEWED
S
PARAMETER
SAMPLE
CREATE_USER
SAMPLE
UPDATE_DATE
2026-01-01
UPDATE_USER
SAMPLE
ERROR_MESSAGE
Sample text
JOB_INSTANCE_ID
1
ADDITIONAL_INFORMATION
SAMPLE
START_TIMENTIMESTAMP(6)116END_TIMENTIMESTAMP(6)117JOB_STATUS
SAMPLE

default

IDRPK
3
JOB_NAMER
Batch Activity Secondary
JOB_EXECUTION_IDR
1000000003
REVIEWED
N
PARAMETER
Batch Activity-002-ALT
CREATE_USER
Batch Activity-002-ALT
UPDATE_DATE
2026-01-03
UPDATE_USER
2026-01-02-ALT
ERROR_MESSAGE
Batch Activity-002-ALT
JOB_INSTANCE_ID
1000000003
ADDITIONAL_INFORMATION
Batch Activity-002-ALT
START_TIMENTIMESTAMP(6)116END_TIMENTIMESTAMP(6)117JOB_STATUS
PENDING-ALT

default

IDRPK
5
JOB_NAMER
Batch Activity Core
JOB_EXECUTION_IDR
1000000005
REVIEWED
N
PARAMETER
Batch Activity-003-EDGE
CREATE_USER
Batch Activity-003-EDGE
UPDATE_DATE
2026-01-05
UPDATE_USER
2026-01-03-EDGE
ERROR_MESSAGE
Batch Activity-003-EDGE
JOB_INSTANCE_ID
1000000005
ADDITIONAL_INFORMATION
Batch Activity-003-EDGE
START_TIMENTIMESTAMP(6)116END_TIMENTIMESTAMP(6)117JOB_STATUS
ACTIVE-EDGE

Rule Validation Summary

Source Rule Count
23
Governed Rule Count
16