Previous Topic: usp_rest_access TableNext Topic: usp_role_go_form Table


usp_role Table

Contains the information on the Roles.

Column

Type

Remarks

id

INTEGER

 

admin

INTEGER

Admin Function Access

call_mgr

INTEGER

Requests Function Access

change_mgr

INTEGER

Change Orders Function Access

code

STRING 30

Code

data_partition

SREL dmn

 

default_flag

INTEGER

Default

description

STRING (1024)

Description

form_group

SREL fmgrp

 

grant_level

SREL acc_lvls

 

help_view

SREL help_set

 

initial_form

STRING (256)

Initial Form

interface_type

INTEGER

Interface Type

inventory

INTEGER

Inventory Function Access

issue_mgr

INTEGER

Issues Function Access

kcat

INTEGER

 

kd

INTEGER

 

kd_query_description

STRING (255)

 

kd_query_id

SREL crsq

 

kt_admin

INTEGER

Knowledge System Administrator

kt_analyst

INTEGER

Knowledge Analyst

kt_customer

INTEGER

Knowledge Customer

kt_engineer

INTEGER

Knowledge Engineer

kt_manager

INTEGER

Knowledge Manager

kt_type

INTEGER

kt type

name

STRING (80)

Role Name

notify

INTEGER

Notify Function Access

override_cnt_datapart

INTEGER

Override Contact Data Partition

pref_doc

INTEGER

Preferred Document

reference

INTEGER

Reference Function Access

sd_admin

INTEGER

CA SDM System Administrator

sd_analyst

INTEGER

CA SDM Analyst

sd_customer

INTEGER

CA SDM Customer

sd_employee

INTEGER

CA SDM Employee

security

INTEGER

Security Function Access

single_tenant

SREL tenant

 

tenant

SREL tenant

 

tenant_access

INTEGER

Tenant Access

tenant_group

SREL tenant_group

 

tn_admin

INTEGER

 

update_global

INTEGER

Update Global

view_internal

INTEGER

View Internal