Sec User
In ScopeTechnical: SEC_USER | ID: OR-MFCS-SEC_USER
Stores the database user id and the application user id associated with a security user. It is to ensure that users that have access to multiple applications will have access…
See how this object fits into Foundation Data
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
- SEC_USER
Field Definitions(10)
Rules & Considerations(17)
Sample Load Data(4)
| _scenario | MANAGERPK | USER_SEQRPK | CREATE_IDR | RMS_USER_INDR | REIM_USER_INDR | RESA_USER_INDR | CREATE_DATETIMER | ALLOCATION_USER_INDR | DATABASE_USER_ID | APPLICATION_USER_ID |
|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1 | USERENV | Y | N | N | 2026-01-01 | N | STD-SEC_USER-001 | STD-SEC_USER-001 |
default
- MANAGERPK
- 1
- USER_SEQRPK
- 1
- CREATE_IDR
- USERENV
- RMS_USER_INDR
- Y
- REIM_USER_INDR
- N
- RESA_USER_INDR
- N
- CREATE_DATETIMER
- 2026-01-01
- ALLOCATION_USER_INDR
- N
- DATABASE_USER_ID
- STD-SEC_USER-001
- APPLICATION_USER_ID
- STD-SEC_USER-001