# DW_USER_ROLES_H (Preview)

This table requires activation of Cash Management functional area. This table contains details of user roles.

## Details

Module: Cash Management

## Key Columns

USER_ROLE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
USER_ROLE_ID | NUMBER | 38 | 0 | True |  |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier. Values are derived from combination of statement header identifier and statement balance identifier. |  |
USER_ID | NUMBER | 38 | 0 |  | Foreign Key to PER_USERS table. |  |
ROLE_ID | NUMBER | 38 | 0 |  | Foreign Key to PER_ROLES_DN table. |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS. |  |
ROLE_GUID | VARCHAR2 | 64 |  |  | Denormalized Role Guid |  |
METHOD_CODE | VARCHAR2 | 32 |  |  | Automatic, Manually or Externally provisioned |  |
USER_ROLES_ACTIVE_FLAG | VARCHAR2 | 32 |  |  | Flag to mark when a user role is active. |  |
TERMINATED_FLAG | VARCHAR2 | 32 |  |  | Flag to identify that this role belongs to a user that has had their employment terminated (used if reverse termination process is initiated to re-provision roles) |  |
START_DATE | DATE |  |  |  | the date that the user role is active from |  |
END_DATE | DATE |  |  |  | The date that the user role will cease to be active from |  |
CREATED_BY | VARCHAR2 | 64 |  |  | Iindicates the user who created the row. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | Indicates the user who last updated the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 |  |  | Indicates the session login associated to the user who last updated the row. |  |
ABSTRACT_ROLE | VARCHAR2 | 32 |  |  | ?Flag to Indicate it is an Abstract Role |  |
ROLES_ACTIVE_FLAG | VARCHAR2 | 32 |  |  | ?Flag to Indicate it is an Active Role |  |
DATA_ROLE | VARCHAR2 | 32 |  |  | ?Flag to Indicate it is an Data Role |  |
DELEGATION_ALLOWED | VARCHAR2 | 32 |  |  | ?Flag to Indicate it is the Role can be delegated |  |
DUTY_ROLE | VARCHAR2 | 32 |  |  | DUTY_ROLE |  |
EXTERNAL_ID | VARCHAR2 | 64 |  |  | EXTERNAL_ID |  |
EXTERNAL_ROLE | VARCHAR2 | 32 |  |  | ?Flag to Indicate it is an External Role |  |
JOB_ROLE | VARCHAR2 | 32 |  |  | ?Flag to Indicate it is an Job Role |  |
MULTITENANCY_COMMON_NAME | VARCHAR2 | 999 |  |  | The Multitenancy Common Name Defined in LDAP |  |
ROLE_COMMON_NAME | VARCHAR2 | 999 |  |  | The Common Name (CN) defined within LDAP. |  |
ROLE_DISTINGUISHED_NAME | VARCHAR2 | 999 |  |  | The Distinguished Name (DN) defined within LDAP - Contains group information etc. to provide a unique name. |  |
USERNAME | VARCHAR2 | 128 |  |  | The latest principal username of the user |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.