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(5)
Rules & Considerations(14)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | USER_IDR | STORE_IDR | TRANSACTION_TYPER | UPDATE_DATE | TRANSACTION_ID |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | 2026-01-01 | 1 |
| default | 3 | 3 | 1000000003 | 1000000003 | 3 | 2026-01-03 | 1000000003 |
| default | 5 | 5 | 1000000005 | 1000000005 | 5 | 2026-01-05 | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- STATUSR
- 1
- USER_IDR
- 1
- STORE_IDR
- 1
- TRANSACTION_TYPER
- 1
- UPDATE_DATE
- 2026-01-01
- TRANSACTION_ID
- 1
default
- IDRPK
- 3
- STATUSR
- 3
- USER_IDR
- 1000000003
- STORE_IDR
- 1000000003
- TRANSACTION_TYPER
- 3
- UPDATE_DATE
- 2026-01-03
- TRANSACTION_ID
- 1000000003
default
- IDRPK
- 5
- STATUSR
- 5
- USER_IDR
- 1000000005
- STORE_IDR
- 1000000005
- TRANSACTION_TYPER
- 5
- UPDATE_DATE
- 2026-01-05
- TRANSACTION_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 14