Security User History
In ScopeTechnical: SECURITY_USER_HISTORY | ID: OR-SIOCS-SECURITY_USER_HISTORY
Provides historical Security User History records used for Oracle Retail reporting, reconciliation, and downstream processing in SECURITY_USER_HISTORY.
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
Target Structure
- Load Approach
- Table
- Target Objects
- SECURITY_USER_HISTORY
Field Definitions(7)
Rules & Considerations(25)
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | USER_IDR | STORE_IDR | UPDATE_DATER | TRANSACTION_IDR | TRANSACTION_TYPER |
|---|---|---|---|---|---|---|---|
| default | 1 | 0001 | 1000000001 | 1000000001 | 2026-01-01 | 1000000001 | 0001 |
default
- IDRPK
- 1
- STATUSR
- 0001
- USER_IDR
- 1000000001
- STORE_IDR
- 1000000001
- UPDATE_DATER
- 2026-01-01
- TRANSACTION_IDR
- 1000000001
- TRANSACTION_TYPER
- 0001