Table Description
Advice Item User Role: Entity linking the Advice Item and Security Role entities. Creates a link between the the Advice Item and Security Role entities.

Example
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Advisor::Entity::AdviceItemUserRole::AdviceItemUserRole
Controlling File: Advisor\model\Packages\Entity\AdviceItemUserRole\AdviceItemUserRole.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
adviceItemUserRoleIDkeyno INTERNAL_ID SVR_INT64
adviceItemIDdetailsyes INTERNAL_ID SVR_INT64
userRoledetails  SEC_ROLE_NAME SVR_STRING<50>
Foreign Keys (2)
ChildParent
AdviceItemUserRole.userRoleSecurityRole.roleName
AdviceItemUserRole.adviceItemIDAdviceItem.adviceItemID
Indices (1)
Index NameAttributes
AdviceItemUserRoleItemIdxadviceItemID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
searchByAdviceItemreadmulti Searches for AdviceItemUseRole records based on the Advice Item. 
insertinsertAUTO_ID: adviceItemUserRoleID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
Related Pages (0)