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.