Table Description
Condition Set Link : A link between a condition and condition set.

Conditional logic can be used to filter data such that it does not appear to a user, for example, recommended activities displayed in an outcome plan can be filtered such that only particular recommendations are displayed if configured conditions are met. A condition can be based on gender, age, a rule set, a factor score or a factor classification. Conditions can be grouped together into sets, for example, a condition set can contain a condition for gender and for age. A condition set can also contain other condition sets. This entity stores conditions and condition sets which have been grouped together.

Example

An outcome plan is created for James Smith, Linda Smith and their child Robert to identify and address their issues. James Smith is classified as having a Need in Substance Abuse. Adolescent Substance Abuse Treatment and Adult Inpatient Substance Abuse Treatment has been configured as recommendations for clients classified as having a Need in Substance Abuse. A condition has been associated with Adolescent Substance Abuse Treatment such that it is only recommended if the client is between the ages of 16 and 18. A condition set has been associated with Adult Inpatient Substance Abuse Treatment such that it is only recommended to male clients over the age of 18. Based on this condition, Adult Inpatient Substance Abuse Treatment is recommended for James as he is over the age of 18 and is a male. This entity stores the gender condition and the age condition which forms the condition set.

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::Condition::Entity::ConditionSetLink
Controlling File: AssessmentPlanning\model\AssessmentPlanning.emx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
conditionSetLinkIDkeynoThe primary key for the link entity. The key is auto generated based on the CONDITBO key server configuration.INTERNAL_ID SVR_INT64
parentConditionSetIDdetailsnoThe identifier of the parent condition set record. A condition set can contain child condition sets, this identifier is the id of the parent condition set record. This attribute is a foreign key to the ConditionSet entity.INTERNAL_ID SVR_INT64
conditionDataIDdetailsyesThe identifier of the linked condition data record. This attribute will be null if the link record is linking two condition sets. This attribute is a foreign key to the ConditionData entity.INTERNAL_ID SVR_INT64
executionOrderdetailsnoThe order in which the conditions should be executed for the set.NUMBER_OF_ITEMS SVR_INT32
recordStatusdetailsnoThe record status for the link, used to logically delete condition set link records. RECORD_STATUS_CODERecordStatusSVR_STRING<10>
childConditionSetIDdetailsyesThe identifier of the child condition set record. A condition set can contain child condition sets, this identifier is the id of the child condition set record. This attribute is a foreign key to the ConditionSet entity.INTERNAL_ID SVR_INT64
Foreign Keys (3)
ChildParent
ConditionSetLink.conditionDataIDConditionData.conditionDataID
ConditionSetLink.childConditionSetIDConditionSet.conditionSetID
ConditionSetLink.parentConditionSetIDConditionSet.conditionSetID
Indices (3)
Index NameAttributes
IND_1792204650parentConditionSetID
IND_336932098conditionDataID
IND_1418354080childConditionSetID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: conditionSetLinkID
AUTO_ID_KEY: CONDITBO
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: no
Standard Operation 
readread Standard Operation 
searchByConditionSetAndStatusreadmultiORDER_BY: executionOrder
Searches for link records based on ConditionSetID and recordStatus. Used to list all the active conditions within a set. 
readByConditionSetConditionAndStatusnsread   
searchByConditionAndStatusreadmulti Searches for link records by conditionDataID and recordStatus. 
readByParentConditionSetChildConditionSetAndStatusnsread Reads a link record by parentConditionSetID, childConditionSetID and recordStatus. Used to check if a child condition set has already been linked to the parent condition set. 
searchByChildConditionSetAndStatusreadmulti   
Related Pages (17)