Table Description
Product Time Constraint: Time constraints for a product.

Product time constraints are added to products to allow for time constraints by type and for a period of days. An example of a product time constraint is appeal time limit; there may be a different time limit for each stage of the appeal process.
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::Service Layer::ProductTimeConstraint::Entity::ProductTimeConstraint::ProductTimeConstraint
Controlling File: core\model\Packages\Reference Model\Service Layer\ProductTimeConstraint\ProductTimeConstraint_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productTimeConstraintIDkeynoUnique internal reference number of the product time constraint.PRODUCT_TIME_CONSTRAINT_ID SVR_INT64
productIDdetailsnoUnique ID of the associated product (mandatory).PRODUCT_ID SVR_INT64
numberOfDaysdetailsnoThe number of days before the constraint expires (mandatory).NUMBER_OF_DAYS SVR_INT32
constraintTypedetailsnoThe constraint type for the product (mandatory).CONSTRAINT_TYPE_CODEConstraintTypeSVR_STRING<10>
fromDatedetailsnoThe date from which the time constraint commences (mandatory).CURAM_DATE SVR_DATE
recordStatusdetailsnoThe product time constraint record status.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
ProductTimeConstraint.productIDProduct.productID
Indices (2)
Index NameAttributes
PTCIDTypeDateIdxproductID, constraintType, fromDate
PTCIdTypeIdxproductTimeConstraintID, constraintType
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: productTimeConstraintID
PRE_DATA_ACCESS: yes
Entity operation to insert a product time constraint for a product. 
readread Entity operation to read a product time constraint for a product. 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Entity operation to modify a product time constraint for a product. 
validate  Entity operation to validate product time constraint details, called from preInsert and preModify. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Entity operation to cancel a product time constraint for a product, sets the record status to canceled. 
searchByProductIDnsreadmulti Entity operation to read a list of product time constraints for a product. 
searchByProductIDDateStatusTypensreadmulti Entity operation to read a list of product time constraints for a product by date, status and type. 
searchByProductIDTypensreadmulti Entity operation to read a list of product time constraints for a product by type. 
validateCancel  Entity operation to validate cancel product time constraint details, checks if the record has already been canceled. 
readStatusnsread Entity operation to read a product time constraint record status. 
countOverlapsnsPRE_DATA_ACCESS: yes
 		Entity operation to check for overlapping product time constraints, searching by product id, constraint type, status and date.SQL
getOverlappingRecord  @superseded - replaced by countOverlaps 
searchByProductreadmulti Return&nbsp;a&nbsp;list&nbsp;of&nbsp;product time constraint&nbsp;records&nbsp;by&nbsp;product ID. 
searchByProductIDAndVersionNonsreadmulti Entity operation to read a list of product time constraints for a product. 
insertProductTimeConstraintinsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts product time constraint record. This method expects the productTimeConstraintID to be set. It is preferred to call <font color="#000000">insertProductTimeConstraint&nbsp;</font>method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
modifyProductTimeConstraintmodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
Related Pages (8)