RoleAvailableAccess (ver7.1.1)
Canonical list of Boolean properties that may be granted to a role.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Code | 7.1.1 | Varchar2(100) | Internal code used to identify a RoleAvailableAccess record. Codes will be unique within a module. Required. |
Description | 7.1.1 | Varchar2(1024) | Read-only description of a RoleAvailableAccess record. |
ID | 7.1.1 | Number(19) | Unique sequential number generated by the application. Required. |
IsEditable | 7.1.1 | Number(1) | 1 indicates the user can edit this record. 0 indicates the user cannot edit this record. Defaults to 0. Required. Note: This flag works in conjunction with the IsLocked flag in the RoleDef table. If this flag is set to 0 and the IsLocked flag is set to 1, the user has read-only access. |
MatrixVisible | 7.1.1 | Number(1) | 1 indicates the property is displayed to the user in the role matrix. Defaults to 0. Required. |
Name | 7.1.1 | Varchar2(100) | Short name that appears in the role list matrix. Required. |
RoleAttributeGroupID | 7.6.0 | Number(19) | Currently not used. |
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 RoleAvailableAccess from lowest to highest. 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. |
WhoCreated | 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. |