RoleDef (ver7.1.1)
This table stores roles for a given RoleModule.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CanScheduleExports | 9.1.0 | Number(01) | 1 indicates users assigned to this role are allowed to set up and run system-level scheduled exports. 0 indicates users assigned to this role are not allowed to set up and run system-level scheduled exports. Valid values: 0, 1. Defaults to 0. |
Description | 7.1.1 | Varchar2(1024) | User configurable description. |
ID | 7.1.1 | Number(19) | Unique sequential number generated by the application. Required. |
IsEnabled | 7.1.1 | Number(1) | 1 indicates this role should continue to be usable in the application for new associations. Defaults to 1. Required. |
IsLocked | 7.1.1 | Number(1) | 1 indicates the user can delete this role. 0 indicates the user cannot delete this role. Defaults to 0. Required. Note: This flag works in conjunction with the IsEditable flag in the RoleAvailableAccess, RoleAvailableCapability, and RoleAvailableProperty tables, which indicates whether or not a role is editable. |
IsVisible | 7.1.1 | Number(1) | 1 indicates this role appears in the Role Administration page. Defaults to 1. Required. |
Name | 7.1.1 | Varchar2(100) | User configurable name uniquely identifying the role to the user within a RoleModule Required. |
RoleKey | 7.1.1 | Varchar2(500) | Internal code uniquely identifying a role within a RoleModule. Required. |
RoleModuleID | 7.1.1 | Number(19) | Internal number for the associated RoleModule record. Indexed. Required. |
SortOrder | 7.1.1 | Number(19) | Determines the order in which this item appears in the list of roles from lowest to highest number Defaults to 0. Required. |
WhenCreated | 7.1.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 7.1.1 | Timestamp(6) | The date and time the record was last modified. Defaults to system date. Required. |
WhocCeated | 7.1.1 | Varchar2(100) | The name of the person who created the record. Defaults to database user. Required. |
WhoModified | 7.1.1 | Varchar2(100) | The name of person who last modified the record. Defaults to database user. Required. |