Table Description
DAICDCodeConditionLink: The ICD code condition link entity holds details of the relationship between ICDCodes and Conditions.

The ICD Code Condition link entity holds details of the relationship between ICD Codes and Conditions.
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::Decision Assist::Service Layer::Condition::entity::ICDCodeConditionLink
Controlling File: DecisionAssist\model\Packages\Service Layer\Condition\entity\condition_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
iCDCodeConditionLinkIDkeynoSystem generated unique identifier for an ICD Code Condition link.DA_ICDCODE_CONDITION_LINK_ID SVR_INT64
conditionIDdetailsnoSystem generated unique identifier for the related condition.DA_CONDITION_ID SVR_INT64
iCDCodeIDdetailsyesSystem generated unique identifier for the related ICD code.DA_ICD_CODE_ID SVR_INT64
startDatedetails The Start Date of the association between the Condition and ICD Code.CURAM_DATE SVR_DATE
endDatedetails The End Date of the association between the Condition and ICD Code.CURAM_DATE SVR_DATE
removeFlagdetails This flag is used to denote whether the ICD Code association has been removed.BOOLEAN_TYPE SVR_BOOLEAN
Foreign Keys (2)
ChildParent
ICDCodeConditionLink.conditionIDCondition.conditionID
ICDCodeConditionLink.iCDCodeIDICDCode.ICDCodeID
Indices (2)
Index NameAttributes
IND_853248565conditionID
IND__12881551iCDCodeID
Operations (20)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: iCDCodeConditionLinkID
AUTO_ID_KEY: ICDCOCNLNK
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchICDCodesByConditionnsmulti  SQL
countICDCodeConditionLinkByICDCodens  SQL
countICDCodeConditionLinkByICDCodeVersionns  SQL
modifyEndDateForICDCodeConditionLinknsmodifyOPTIMISTIC_LOCKING: yes
  
modifyICDCodeConditionLinkDatesnsmodifyOPTIMISTIC_LOCKING: yes
  
searchCurrentICDCodesByConditionnsmulti  SQL
validateInsert    
searchActiveLinkDatesByConditionICDCodensmulti  SQL
countActiveICDCodesForConditionns  SQL
searchAllICDCodesForConditionnsmulti  SQL
searchCurrentICDCodesForConditionnsmulti  SQL
searchConditionsForICDCodensmulti  SQL
readConditionNamens  SQL
countConditionsByICDCodens  SQL
searchByConditionKeyreadmulti Lists all records for a condition id. 
insertICDCodeConditionLinkinsert Inserts record to ICD code condition link entity. This method expects ICD code condition link ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (ICD code condition link ID). It's preferred to call this method only in scenario's where caller wants to set the value of primary key (ICD code condition link ID) by itself. 
Related Pages (14)