Table Description
Ad hoc Bonus Criteria: An unplanned or non-standard payment to a participant in receipt of a product.

The type, start and end dates and bonus amount can be defined.

Example

When the temperature drops below -5 degrees Celsius for 8 consecutive days, an ad hoc bonus of $50 is paid to each participant over 65 to assist with fuel costs.
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::Core::Reference Model::Products::Entity Objects::AdhocBonusCriteria::AdhocBonusCriteria
Controlling File: core\model\Packages\Products\AdhocBonusCriteria_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
adhocBonusCriteriaIDkeynoUnique identifier of the AdhocBonusCriteria record.ADHOC_BONUS_CRITERIA_ID SVR_INT64
productIDdetailsnoId of the product to which the bonus payment may apply.PRODUCT_ID SVR_INT64
bonusTypeCodedetails Code to distinguish what type of bonus is being paid.BONUS_TYPE_CODEBonusTypeCodeSVR_STRING<10>
fromDatedetails Date from which the bonus may be applied on a case.CURAM_DATE SVR_DATE
toDatedetails Date to which the bonus may be applied on a case.CURAM_DATE SVR_DATE
bonusAmountdetails Fixed bonus amount which will be used in cases where the bonus is fixed.CURAM_AMOUNT SVR_MONEY
statusCodedetails Records the current status of the ad hoc recordRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
AdhocBonusCriteria.productIDProduct.productID
Indices (1)
Index NameAttributes
AdhocProdIDStatusproductID, statusCode
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByProductIDnsreadmulti Operation to read the AdhocBonusCriteria entity by productID. 
searchByProductIDStatusnsreadmulti To retrieve all AdhocBonusCriteria records using ProductID and RecordStatus 
modifyStatusCodensmodifyOPTIMISTIC_LOCKING: yes
To update the StatusCode of an AdhocBonusCriteria record. 
searchForDuplicatesnsmulti To retrieve any duplicate ad hoc bonus criteria records that may exist.SQL
searchByProductIDKeyreadmulti Return&nbsp;a&nbsp;list&nbsp;of&nbsp;adhoc bonus criteria&nbsp;records&nbsp;by&nbsp;product ID. 
insertAdhocBonusCriteriainsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts adhoc bonus criteria record. This method expects the&nbsp;adhocBonusCriteriaID to be set. It is preferred to call insertAdhocBonusCriteria&nbsp;method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
Related Pages (6)