This table requires activation of Cash Management functional area. This table contains details of user roles.
Module: Cash Management
USER_ROLE_ID
| 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.