Table Description
Advice Item: Top level of advice containing the advice text. An Advice Item stores advice based on a database write, which can be read for display.When the showAdvice attribute is false, it means that the record will not appear in the user interface.

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::AdviceItem::AdviceItem
Controlling File: Advisor\model\Packages\Entity\AdviceItem\AdviceItem_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
textResourceIDdetailsnoThe advice text.RESOURCE_KEY SVR_STRING<100>
adviceItemIDkeynoThe unique identifier for AdviceItem.INTERNAL_ID SVR_INT64
categoryTypedetails  CATEGORY_TYPEAdviceCategorySVR_STRING<10>
priorityTypedetails  PRIORITY_TYPEAdvicePrioritySVR_STRING<10>
showAdvicedetails  CURAM_INDICATOR SVR_BOOLEAN
statusTypedetails  STATUS_TYPEAdviceStatusSVR_STRING<10>
timeStampdetails  INTERNAL_ID SVR_INT64
expiryDateTimedetailsyesThe advice item expiry date time.CURAM_DATETIME SVR_DATETIME
sourceRuleSetdetails  CREOLE_RULE_SET_NAME SVR_STRING<100>
securityIdentifierdetails  SEC_SID_NAME SVR_STRING<100>
Foreign Keys (6)
ChildParent
AdviceContextItem.adviceItemIDAdviceItem.adviceItemID
AdviceItemCaseLink.adviceItemIDAdviceItem.adviceItemID
AdviceItemImage.adviceItemIDAdviceItem.adviceItemID
AdviceItemLink.adviceItemIDAdviceItem.adviceItemID
AdviceItemParameter.adviceItemIDAdviceItem.adviceItemID
AdviceItemUserRole.adviceItemIDAdviceItem.adviceItemID
Indices (1)
Index NameAttributes
AdviceCategoryIdxcategoryType
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: adviceItemID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
Related Pages (0)