Table Description
Product Provision: An association between product and product provider.

This also links to another entity link, provision location, that establishes an association to provider location.
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::ProductProvision::ProductProvision
Controlling File: core\model\Packages\Products\ProductProvision_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
VALIDATION_EXIT_POINTyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productProvisionIDkeynoUnique ID to identify a product provision record.PRODUCT_PROVISION_ID SVR_INT64
startDatedetails Start date of the product offered by the product provider.CURAM_DATE SVR_DATE
endDatedetails End date of the product offered by the product provider.CURAM_DATE SVR_DATE
creationDatedetails The date when the product provider created or offered the product.CURAM_DATE SVR_DATE
commentsdetails Comments pertaining to this product provisionCOMMENTS SVR_STRING<300>
statusCodedetails The status of the product being offered by the product provider.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
estimatedCostdetails The estimated cost of the product offered by the product provider.CURAM_AMOUNT SVR_MONEY
productIDdetailsnoForeign product ID to a product record.PRODUCT_ID SVR_INT64
providerConcernRoleIDdetailsnoForeign concern role id to a product provider record.CONCERN_ROLE_ID SVR_INT64
nextPaymentDatedetails The next payment date for the Product ProvisionCURAM_DATE SVR_DATE
paymentFrequencydetails The payment frequency for the provisionFREQUENCY_PATTERN SVR_STRING<9>
methodOfPmtCodedetails The preferred method of payment for the ProvisionMETHOD_OF_DELIVERY_CODEMethodOfDeliverySVR_STRING<10>
currencyTypedetails The preferred currency for payment for the provisionCURRENCY_CODECurrencySVR_STRING<10>
Foreign Keys (3)
ChildParent
ProductProvision.productIDProduct.productID
ProductProvision.providerConcernRoleIDProductProvider.concernRoleID
ProvisionLocation.productProvisionIDProductProvision.productProvisionID
Indices (2)
Index NameAttributes
ProductIDCRIDIndexproductID, providerConcernRoleID, statusCode, startDate
ProviderCRIDIndexproviderConcernRoleID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
readread Standard Operation 
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremovePRE_DATA_ACCESS: yes
Standard Operation 
searchProvisionByProductIDnsmultiPRE_DATA_ACCESS: no
 		@deprecated by searchProvisionByProductID1. @deprecated-since V6.0. Reads a summary list of product providers for a product.SQL
readByProductIDAndProviderIDns Reads a Product Provider Link by Product ID and Product Provider ID.SQL
readProductProviderNamens Retrieves the name of product provider.SQL
searchByProductAndProvidernsmulti Returns a list of locations based on a Product and Product Provider combinationSQL
readOverlappingActiveProvisionns search for Active provisions with the same provider, the same product and overlapping periodSQL
readEstimatedCostByProductIDAndProviderIDns Retrieves the estimated cost for the product provisionSQL
getProductProviderName  @superseded - replaced by readProductProviderName 
searchForOverlappingActiveProvisions  @superseded - replaced by readOverlappingActiveProvision 
searchByProductIDreadmulti Return&nbsp;a&nbsp;list&nbsp;of&nbsp;product provision&nbsp;records&nbsp;by&nbsp;product ID. 
insertProductProvisioninsert <p class="MsoNormal"> <span style="COLOR: #002060">Inserts product provision record. This method expects the productProvisionID to be set. It is preferred to call insertProductProvision method only in scenarios where calling method wants to set the value of primary key by itself.</span> </p> 
searchProvisionByProductID1nsmultiPRE_DATA_ACCESS: no
 		Reads a summary list of product providers for a product.SQL
modifyProductProvisionmodifyOPTIMISTIC_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 (26)