Table Description
DAICD Code: ICD (International Classification of Diseases) Codes are classifications for health conditions (diseases, disorders, injuries etc.) established by the WHO (World Health Organization).

ICD (International Classification of Diseases) Codes is a classification for health conditions (diseases, disorders, injuries etc.) established by the WHO (World Health Organization).
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::ICDCodes::Entity::ICDCode
Controlling File: DecisionAssist\model\Packages\Service Layer\ICDCodes\Entity\ICDCode_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
ICDCodeIDkeynoSystem generated unique identifier for an ICD Code.DA_ICD_CODE_ID SVR_INT64
ICDCodeVersionIDdetailsnoSystem generated unique identifier for an ICD Code version.DA_ICD_CODE_VERSION_ID SVR_INT64
ICDCodedetails Alphanumeric code given to a disease by the World Health Organization.DA_ICD_CODE SVR_STRING<10>
ICDTextdetails Text description of the ICD Code.DA_ICD_TEXT SVR_STRING<300>
startDatedetails Start date of the period during which the ICD Code can be used.CURAM_DATE SVR_DATE
endDatedetails End date of the period during which the ICD Code can be used.CURAM_DATE SVR_DATE
dateCreateddetails The date that the ICD Code was created.CURAM_DATETIME SVR_DATETIME
createdBydetails Name of the user who created the ICD Code.DA_CREATED_BY_USER SVR_STRING<64>
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
ICDCode.ICDCodeVersionIDICDCodeVersion.ICDCodeVersionID
ICDCodeConditionLink.iCDCodeIDICDCode.ICDCodeID
Indices (1)
Index NameAttributes
IND__680569340ICDCodeVersionID
Operations (17)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
uploadICDCodesbatchinsert   
countByUniqueICDCodens  SQL
searchICDCodensmulti  SQL
modifyForReleaseICDCode    
modifyForRemoveICDCodensmodify   
removeICDCodeForInEditVersionnsremove   
removeICDCodeForReleasedVersion    
readStartDateByICDCodeVersionns  SQL
insertICDCodeinsert Standard Operation 
modifyForReleaseICDCodensmodifyOPTIMISTIC_LOCKING: no
Modifies ICD code details on releasing ICD code version. 
modifyICDCodeForReleasedVersionnsmodifyOPTIMISTIC_LOCKING: no
Modifies ICD code end date on releasing ICD code version.  
searchByICDCodeVersionnsreadmulti Searches ICD code by ICD code versions. 
searchByICDCodeVersionAndEndDatensreadmultiWHERE: ICDCodeVersionID = :ICDCodeVersionID AND ( endDate IS NULL OR endDate > :endDate )
Searches ICD code by ICD code version and end date. 
Related Pages (17)