Roles1

The Other > Role custom field is available for the Roles table.

Columns

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 4000 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 4000 Role name