Security User History
In ScopeTechnical: SECURITY_USER_HISTORY | ID: OR-STO-SECURITY_USER_HISTORY-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- SECURITY_USER_HISTORY
Field Definitions(7)
Rules & Considerations(14)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | USER_IDR | STORE_IDR | UPDATE_DATER | TRANSACTION_IDR | TRANSACTION_TYPER |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 2026-01-01 | 1 | 1 |
Example values from field definitions
- IDRPK
- 1
- STATUSR
- 1
- USER_IDR
- 1
- STORE_IDR
- 1
- UPDATE_DATER
- 2026-01-01
- TRANSACTION_IDR
- 1
- TRANSACTION_TYPER
- 1
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 14