Links between Activity Types and Roles.
|
Field |
Data Type |
Reference |
Remarks |
|---|---|---|---|
|
access_type |
INTEGER |
Access_Type_v2::id |
Foreign key to access type id in Access_Type_v2. |
|
id |
INTEGER |
|
Specifies the unique (to the table) numeric ID. |
|
is_default |
INTEGER |
|
Specifies if this is the default role for this access type. 1 = default |
|
role_obj |
INTEGER |
usp_role::id |
Foreign key to the role_id field of the usp_role table. |
A dependent_control object specifies the attribute name and locked or required value that activates dependent control.
|
Attribute |
DB Field |
Data Type |
SREL References |
Flags |
|---|---|---|---|---|
|
id |
id |
INTEGER |
|
UNIQUE REQUIRED KEY |
|
control |
control |
INTEGER REF |
usp_dependent_control |
|
|
attrname |
attrname |
STRING 64 |
|
Identifies attribute name. |
|
locked |
locked |
INTEGER |
|
Identifies locked attribute. |
|
required |
required |
INTEGER |
|
Identifies required attribute. |
|
last_mod_dt |
last_mod_dt |
LOCAL_TIME |
|
Indicates the timestamp of when this record was last modified. |
|
last_mod_by |
last_mod_by |
UUID REF |
ca_contact |
Specifies the UUID of the contact who last modified this record. |
|
del |
|
INTEGER |
nn |
Deleted flag 0—Active 1—Inactive/marked as deleted |
|
tenant |
|
UUID REF |
ca_tenant |
|
|
Copyright © 2013 CA.
All rights reserved.
|
|