Table Description
CreoleRuleSetLink : A link entity used for linking artifacts to CER rulesets.

The CreoleRuleSetLink entity is used for linking artifacts to CER rulesets. Estimated cost calculations may be too complex to calculate in generic OOTB code. With the help of this entity an administrator will be able to define a CER rule set that is used to calculate the estimated cost for a particular artifact. CreoleRuleSetLink is used to link the rule set and the artifact.

Example

The calculation of the estimated cost of the Child Care service is complex, and depends on certain client information. An administrator defines a CER rule set that is used to calculate the estimated cost for a given service, and associates it with the Child Care service offering.

Model Details
Location in Model: Logical View::MetaModel::Curam::CPM::Service Layer::CreoleRuleSet::Entity::CreoleRuleSetLink
Controlling File: CPM\model\Packages\Service Layer\CreoleRuleSet\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
creoleRuleSetLinkIDkeynoThe unique system generated identifier for the CreoleRuleSetLink record.CREOLE_RULE_SET_LINK_ID SVR_INT64
creoleRuleSetIDdetailsnoThe unique system generated identifier for the CreoleRuleSet of this CreoleRuleSetLink.CREOLELINK_RULE_SET_ID SVR_INT64
relatedIDdetailsnoThe unique system generated identifier for the related entity. For example serviceOfferingID.CREOLE_RULE_SET_RELATED_ID SVR_INT64
relatedTypedetailsnoRelated type for which rule set is associated. For example ServiceOffering.CREOLE_RULE_SET_RELATED_TYPERelatedTypeSVR_STRING<10>
typedetailsnoRule set type associated with related type. 'Estimated Cost Rule Set' for Service Offering.CREOLE_RULE_SET_TYPECreoleRuleSetTypeSVR_STRING<10>
ruleSetClassNamedetails Name of the rule set class.CREOLELINK_RULE_SET_NAME SVR_STRING<255>
startDatedetailsnoThe date from which the rule set is active.CURAM_DATE SVR_DATE
endDatedetails The date till rule set is active.CURAM_DATE SVR_DATE
commentsdetails Comments for rule set.COMMENTS SVR_STRING<300>
recordStatusdetailsnoStatus of the rule set.For example Active or cancelRECORD_STATUS_CODERecordStatusSVR_STRING<10>
creoleDataStoreNamedetails Name of the data store.CREOLE_DATA_STORE_NAME SVR_STRING<200>
Indices (2)
Index NameAttributes
CreoleRuleSetLinkRelatedIDIdxrelatedID
IND__1126357634creoleRuleSetID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: creoleRuleSetLinkID
AUTO_ID_KEY: SEROFF
Creates a new row on CreoleRuleSetLink table. 
readread Reads a row of data from CreoleRuleSetLink table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on CreoleRuleSetLink table. 
searchByreadmultiWHERE: relatedID=:relatedID AND relatedType=:relatedType AND type=:type AND startDate<=:startDate AND (endDate is NULL or endDate>=:endDate) AND recordStatus=:recordStatus
Searches based on related ID, related type, type, date range and record status. 
readDataStoreByRuleIDnsread Reads data store name using rule set ID. 
readByServiceOfferingAndRuleSetTypensread Reads the rule set configuration details based on service offering ID and rule set type. 
removeremove Removes an existing row from CreoleRuleSetLink table. 
insertCreoleRuleSetLinknsinsert Creates a new row on CreoleRuleSetLink table and it should be used only when the user is passing the primary id. 
Related Pages (30)
Delete Service (ProviderManagement_cancelServiceOfferingFrmList)
Delete Service (ProviderManagement_cancelServiceOfferingFrmServiceGroup)
Delete Service (ProviderManagement_cancelServiceOfferingFromSearch)
Delete Service (ProviderManagement_cancelTrainingServiceOffering)
New Approval Criteria (ProviderManagement_createApprovalCriterion)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Service (ProviderManagement_createServiceOffering)
New Approval Check (ProviderManagement_createServiceOfferingApprovalCheck)
New Training Service (ProviderManagement_createTrainingServiceOffering)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Approval Criteria (ProviderManagement_listApprovalCriterion)
Contract Text (ProviderManagement_listContractTextForServiceOffering)
Good Causes for Service:# END, CR00260713 (ProviderManagement_listGoodCauseForServiceOffering)
Expected Outcomes for Service:# END, CR00260713 (ProviderManagement_listOutcomesForServiceOffering)
Rates (ProviderManagement_listRatesForServiceOffering)
Payment Options (ProviderManagement_listServicePaymentOption)
Performance Measures (ProviderManagement_listSOPerformanceMeasure)
Training Requirements (ProviderManagement_listTrainingRequirementsForServiceOffering)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Delivery (ProviderManagement_viewServiceDeliveryConfiguration)
Service (ProviderManagement_viewServiceForResourceMgr)
Home (ProviderManagement_viewServiceOfferingFrmList)
Home (ProviderManagement_viewServiceOfferingFrmServiceGroup)
Home (ProviderManagement_viewServiceOfferingFromSearch)
ProviderManagement_viewServiceOfferingTabDetails
Home (ProviderManagement_viewTrainingServiceOfferingFrmList)