# DW_USER_ROLE_DATA_ASGNMNTS_D

This table contains the assignments of a user , role and data security context.

## Details

Module:

## Key Columns

USER_ROLE_DATA_ASSIGNMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
USER_ROLE_DATA_ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Record identifier for the user role data assignment. |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Source record identifier. |  |
USER_GUID | VARCHAR2 | 128 |  |  | Record identifier for the corresponding entry for the user in Oracle Identity Management. |  |
ROLE_NAME | VARCHAR2 | 512 |  |  | Role name that includes the grantee key as the recipient of the role grants. Role grant is the job role associated with the user. |  |
ORG_ID | NUMBER | 38 | 0 |  | Indicates the identifier of the business unit associated to the row. |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Record identifier for the ledger the user data role can access. |  |
BOOK_ID | NUMBER | 38 | 0 |  | Record identifier for the asset book the user data role can access. |  |
SET_ID | NUMBER | 38 | 0 |  | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. |  |
INV_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Record identifier for the inventory organization the user data role can access. |  |
CST_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Record identifier for the cost organization the user data role can access. |  |
ITM_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Record identifier for the item organization the user data role can access. |  |
ACCESS_SET_ID | NUMBER | 38 | 0 |  | Record identifier for the data access set the user data role can access. |  |
CONTROL_BUDGET_ID | NUMBER | 38 | 0 |  | Record identifier for the control budget the user data role can access. |  |
INTERCO_ORG_ID | NUMBER | 38 | 0 |  | Record identifier for the intercompany organization the user data role can access. |  |
PRJ_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Record identifier for the project organization the user data role can access. |  |
MFG_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Record identifier for the manufacturing organization the user data role can access. |  |
DATASEC_CONTEXT_TYPE_CODE | VARCHAR2 | 32 |  |  | Security context of the data access assignments, such as business unit or ledger. |  |
DATASEC_CONTEXT_VALUE1 | VARCHAR2 | 64 |  |  | Security context value of the data access assignments. |  |
DATASEC_CONTEXT_VALUE2 | VARCHAR2 | 64 |  |  | Security context value of the data access assignments. |  |
DATASEC_CONTEXT_VALUE3 | VARCHAR2 | 64 |  |  | Security context value of the data access assignments. |  |
DATASEC_CONTEXT_VALUE4 | VARCHAR2 | 64 |  |  | Security context value of the data access assignments. |  |
DATASEC_CONTEXT_VALUE5 | VARCHAR2 | 64 |  |  | Security context value of the data access assignments. |  |
START_DATE_ACTIVE | DATE |  |  |  | Date at the beginning of the date range within which the row is active. |  |
ACTIVE_FLAG | VARCHAR2 | 16 |  |  | Indicates the state of the data role assignment. Possible values are Y for active and N for not active. |  |
RECORD_TYPE_CODE | VARCHAR2 | 32 |  |  | Code to indicate whether the record is migrated, seeded or defined by the user. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who last updated the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
LAST_UPDATE_LOGIN | VARCHAR2 | 64 |  |  | Who column: indicates the session login associated to the user who last updated the row. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.