Table Description
nbsp;Advice Item Case Link
: nbsp;Entity linking the Advice Item and Case details.          
 nbsp;Creates a link between the the Advice Item and Case details.

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::AdviceItemCaseLink::AdviceItemCaseLink
Controlling File: Advisor\model\Packages\Entity\AdviceItemCaseLink\AdviceItemCaseLink.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
adviceItemCaseLinkIDkeyno INTERNAL_ID SVR_INT64
caseIDdetailsyes CASE_ID SVR_INT64
evidenceTypedetails  EVIDENCE_TYPE_CODEEvidenceTypeSVR_STRING<10>
relatedIDdetails  RELATED_ID SVR_INT64
adviceItemIDdetailsyes INTERNAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
AdviceItemCaseLink.adviceItemIDAdviceItem.adviceItemID
AdviceItemCaseLink.caseIDCaseHeader.caseID
Indices (4)
Index NameAttributes
CaseAdviceItemIDIdxadviceItemID
AdviceItemCaseIDIdxcaseID
AdviceItemEvidenceTypeIdxevidenceType
AdviceItemRelatedIDIdxrelatedID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: adviceItemCaseLinkID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
searchByCasereadmulti   
searchByCaseAndEvidenceTypereadmulti   
searchByCaseAndRelatedIDreadmulti   
readByAdviceItemnsread Searches the&nbsp;AdviceItemCaseLink&nbsp;records&nbsp;based&nbsp;on&nbsp;the&nbsp;Advice&nbsp;Item. 
searchByCaseAndAdviceCategorynsmulti  SQL
searchByCaseIDEvidenceTypeAdviceCategorynsmulti  SQL
searchByCaseIDRelatedIDAdviceCategorynsmulti  SQL
Related Pages (0)