The Other > Role custom field is available for the Roles table.
Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
center_created_by | NUMBER | 39 | 0 | Center created by | |||
center_created_date | TIMESTAMP | Center created date | |||||
center_id | VARCHAR2 | 128 | Center ID | ||||
center_modified_by | NUMBER | 39 | 0 | Center modified by | |||
center_modified_date | TIMESTAMP | Center modified date | |||||
center_name | VARCHAR2 | 128 | Center name | ||||
class_restriction_type | VARCHAR2 | 16 | Class restriction type | ||||
custom_record_permission_name | VARCHAR2 | 4000 | Custom record permission name | ||||
date_last_modified | TIMESTAMP | Date last modified (GMT) | |||||
department_restriction_type | VARCHAR2 | 16 | Department restriction type | ||||
employee_restriction_type | VARCHAR2 | 16 | Employee restriction type | ||||
is_classallowviewing | VARCHAR2 | 3 | Whether class allows viewing | ||||
is_departmentallowviewing | VARCHAR2 | 3 | Whether department allows viewing | ||||
is_employeeallowviewing | VARCHAR2 | 3 | Whether employee allows viewing | ||||
is_inactive | VARCHAR2 | 3 | Role is inactive | ||||
is_itemclassrestricted | VARCHAR2 | 3 | Whether item class is restricted | ||||
is_itemdepartmentrestricted | VARCHAR2 | 3 | Whether item department is restricted | ||||
is_itemlocationtrestricted | VARCHAR2 | 3 | Whether item location is restricted | ||||
is_locationallowviewing | VARCHAR2 | 3 | Whether location allows viewing | ||||
is_subsidiaryallowviewing | VARCHAR2 | 3 | Whether subsidiary allows viewing | ||||
location_restriction_type | VARCHAR2 | 16 | Location restriction type | ||||
permission_id | VARCHAR2 | 30 | Permission ID | ||||
permission_level_id | NUMBER | 39 | 0 | Permission level ID | |||
permission_level_name | VARCHAR2 | 64 | Permission level name | ||||
permission_name | VARCHAR2 | 200 | Permission name | ||||
permsofroles_date_modified | TIMESTAMP | Permissions of roles date modified | |||||
permsofroles_modified_by | NUMBER | 39 | 0 | Permissions of roles modified by | |||
role_created_by | NUMBER | 39 | 0 | Role created by | |||
role_created_date | TIMESTAMP | Role created date | |||||
role_id | NUMBER | 39 | 0 | Role ID | |||
role_modified_by | NUMBER | 39 | 0 | Role modified by | |||
role_name | VARCHAR2 | 999 | Role name |